names

76 rows where place_id = 601068

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643734 1908466 1908466 defendant Chircheman John laborer 601068 601068 Chircheman, John, of Iklyngham, laborer 7
3649318 1910178 1910178 defendant Brett Thomas husbandman 601068 601068 Brett, Thomas, of Iklyngham, husbandman 0
3649319 1910178 1910178 defendant Warde William husbandman 601068 601068 Warde, William, of Iklyngham, husbandman 1
3649320 1910178 1910178 defendant Chercheman William husbandman 601068 601068 Chercheman, William, of Iklyngham, husbandman 2
3657612 1912643 1912643 defendant Dyper Robert smith 601068 601068 Dyper, Robert, of Iklyngham, smith 4
3657621 1912644 1912644 defendant Dyper Robert smith 601068 601068 Dyper, Robert, of Iklyngham, smith 4
3657622 1912644 1912644 defendant Warde John fuller 601068 601068 Warde, John, of Iklyngham, fuller 5
3670010 1916566 1916566 defendant Walby William yeoman 601068 601068 Walby, William, of Iklyngham, yeoman 0
3671577 1917094 1917094 defendant Walby William husbandman 601068 601068 Walby, William, of Iklyngham, husbandman 0
3671578 1917094 1917094 defendant Page John weaver 601068 601068 Page, John, of Iklyngham, weaver 1
3671579 1917094 1917094 defendant Dyper William smith 601068 601068 Dyper, William, of Iklyngham, smith 2
3771536 1948792 1948792 defendant Tymmer William husbandman 601068 601068 Tymmer, William, of Iklyngham, husbandman 0
3851863 1974175 1974175 plaintiff Poley William gent 601068 601068 Poley, William, of Iklyngham, gent 0
3851865 1974176 1974176 plaintiff Poley William gent 601068 601068 Poley, William, of Iklyngham, gent 0
3866360 1978983 1978983 plaintiff Poley William gent 601068 601068 Poley, William, of Iklyngham, gent 0
4691923 2263010 2263010 defendant Tyd Henry   601068 601068 Tyd, Henry, of Iklyngham, mill wright 0
4790786 2293205 2293205 defendant Holand William husbandman 601068 601068 Holand, William, of Iklyngham, husbandman 0
4828151 2304846 2304846 defendant London Margaret widow 601068 601068 London, Margaret, of Iklyngham, widow 3
4890424 2323772 2323772 defendant Gardener John mercer 601068 601068 Gardener, John, of Iklyngham, mercer 0
4943136 2339826 2339826 defendant Bakhoot Nicholas clerk 601068 601068 Bakhoot, Nicholas, of Iklyngham, clerk 0
4955072 2343469 2343469 defendant Walkard John baker 601068 601068 Walkard, John, of Iklyngham, baker 0
4955073 2343469 2343469 defendant Fullere John husbandman 601068 601068 Fullere, John, of Iklyngham, husbandman 1
5031997 2366231 2366231 defendant Parmenter Peter fuller 601068 601068 Parmenter, Peter, of Iklyngham, fuller 0
5084547 2381891 2381891 defendant Scarlet William gent 601068 601068 Scarlet, William,of Iklyngham, gent 0
5088025 2382872 2382872 defendant Pedder John husbandman 601068 601068 Pedder, John, of Iklyngham, husbandman 0
5111173 2389656 2389656 defendant Gardener John mercer or woolman 601068 601068 Gardener, John, of Iklyngham, mercer or woolman 0
5124213 2393539 2393539 defendant Bagot Robert smith 601068 601068 Bagot, Robert, of Iklyngham, smith 0
5124214 2393539 2393539 defendant Lose or Lofe John laborer 601068 601068 Lose or Lofe, John, of Iklyngham, laborer 1
5124215 2393539 2393539 defendant Bagot John laborer 601068 601068 Bagot, John, of Iklyngham, laborer 2
5125978 2394084 2394084 defendant Donewyche Thomas   601068 601068 Donewyche, Thomas, of Iklyngham 0
5139195 2397954 2397954 plaintiff Seynour Richard (legal representative) 601068 601068 Seynour, Richard, of Iklyngham, rector, executors of 0
5139196 2397954 2397954 plaintiff Shercroft Thomas   601068 601068 (Shercroft, Thomas, of Iklyngham, parson of All Saints church 1
5144579 2399575 2399575 defendant Donewyche Thomas husbandman 601068 601068 Donewyche, Thomas, of Iklyngham, husbandman 0
5160066 2404043 2404043 plaintiff Shercroft Thomas   601068 601068 (Shercroft, Thomas, of Iklyngham, parson of All Saints church 1
5237611 2426581 2426581 defendant Osbarn Adam husbandman 601068 601068 Osbarn, Adam, of Iklyngham, husbandman 0
5237612 2426581 2426581 defendant Heyward John tailor 601068 601068 Heyward, John, of Iklyngham, tailor 1
5247664 2429474 2429474 defendant Sokerman John butcher 601068 601068 Sokerman, John, of Iklyngham, butcher 8
5247674 2429475 2429475 defendant Sokerman John butcher 601068 601068 Sokerman, John, of Iklyngham, butcher 8
5304514 2446343 2446343 defendant Spyllyng William   601068 601068 Spyllyng, William, of Iklyngham, shepherd 0
5304515 2446343 2446343 defendant Whytw_ Richard tailor 601068 601068 Whytw_, Richard, of Iklyngham, tailor 1
5387819 2471577 2471577 defendant Yngham Robert husbandman 601068 601068 Yngham, Robert, of Iklyngham, husbandman 2
5398292 2474579 2474579 defendant Geddyng William gent 601068 601068 Geddyng, William, of Iklyngham, gent 1
5398301 2474580 2474580 defendant Geddyng William gent 601068 601068 Geddyng, William, of Iklyngham, gent 1
5400350 2475173 2475173 defendant Yngham John husbandman 601068 601068 Yngham, John, of Iklyngham, husbandman 3
5402618 2475822 2475822 defendant Chircheman John   601068 601068 Chircheman, John, of Iklyngham, wool man 2
5409359 2477770 2477770 defendant Melton Thomas fuller 601068 601068 Melton, Thomas, of Iklyngham, fuller 4
5411440 2478378 2478378 defendant Geddyng William gent 601068 601068 Geddyng, William, of Iklyngham, gent 0
5413345 2478920 2478920 defendant Yngham Robert husbandman 601068 601068 Yngham, Robert, of Iklyngham, husbandman 1
5413346 2478920 2478920 defendant Yngham John husbandman 601068 601068 Yngham, John, of Iklyngham, husbandman 2
5415528 2479584 2479584 defendant Chircheman John woolman 601068 601068 Chircheman, John, of Iklyngham, woolman 2
5428549 2483462 2483462 defendant Ingham Robert husbandman 601068 601068 Ingham, Robert, of Iklyngham, husbandman 1
5428550 2483462 2483462 defendant Yngham John husbandman 601068 601068 Yngham, John, of Iklyngham, husbandman 2
5431875 2484500 2484500 defendant Chircheman John woolman 601068 601068 Chircheman, John, of Iklyngham, woolman 2
5442189 2487583 2487583 defendant Assheby John laborer 601068 601068 Assheby, John, of Iklyngham, laborer 0
5458807 2492526 2492526 defendant Buk William laborer 601068 601068 Buk, William, of Iklyngham, laborer 0
5458808 2492526 2492526 defendant Gardyner William woolman 601068 601068 Gardyner, William, of Iklyngham, woolman 1
5458810 2492526 2492526 defendant Colies Thomas husbandman 601068 601068 Colies, Thomas, of Iklyngham, husbandman 3
5458811 2492526 2492526 defendant Goslyng Robert fuller 601068 601068 Goslyng, Robert, of Iklyngham, fuller 4
5458812 2492526 2492526 defendant Harkworth Thomas laborer 601068 601068 Harkworth, Thomas, of Iklyngham, laborer 5
5514505 2509384 2509384 defendant Bryghtwold Andrew weaver 601068 601068 Bryghtwold, Andrew, of Iklyngham, weaver 1
5516880 2510102 2510102 defendant Nedham Richard husbandman 601068 601068 Nedham, Richard, of Iklyngham, husbandman 2
5520798 2511325 2511325 defendant Godard Thomas husbandman 601068 601068 Godard, Thomas, of Iklyngham, husbandman 3
5522251 2511777 2511777 defendant Nobyll Ralph laborer 601068 601068 Nobyll, Ralph, of Iklyngham, laborer 1
5526722 2512925 2512925 defendant Garrard Thomas yeoman 601068 601068 Garrard, Thomas, of Iklyngham, yeoman 1
5534181 2515223 2515223 defendant Copynger Thomas laborer 601068 601068 Copynger, Thomas, of Iklyngham, laborer 1
5534185 2515223 2515223 defendant Arowesmyth John tailor 601068 601068 Arowesmyth, John, of Iklyngham, tailor 5
5555152 2521513 2521513 defendant Gayford Lawrence carpenter 601068 601068 Gayford, Lawrence, of Iklyngham, carpenter 0
5556589 2521878 2521878 defendant Batell John husbandman 601068 601068 Batell, John, of Iklyngham, husbandman 1
5567767 2525149 2525149 defendant Dyxe John husbandman 601068 601068 Dyxe, John, of Iklyngham, husbandman 0
5573125 2526692 2526692 defendant Batell John fuller 601068 601068 Batell, John, of Iklyngham, fuller 1
5573914 2526937 2526937 plaintiff Purdy Richard (legal representative) 601068 601068 Purdy, Richard, of Iklyngham, clerk, executors of 0
5573915 2526937 2526937 plaintiff Supe or Sumpe William   601068 601068 (Supe or Sumpe, William, of Iklyngham 1
5573916 2526937 2526937 plaintiff Gardener William   601068 601068 Gardener, William, of Iklyngham 2
5573917 2526937 2526937 plaintiff Bury James   601068 601068 Bury, James, of Iklyngham 3
5589741 2531786 2531786 defendant Bryghtwell Thomas husbandman 601068 601068 Bryghtwell, Thomas, of Iklyngham, husbandman 5
5607463 2537229 2537229 defendant Bryghtwell Thomas yeoman 601068 601068 Bryghtwell, Thomas, of Iklyngham, yeoman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);