names

116 rows where place_id = 603370

✎ 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
3629138 1903985 1903985 defendant Tanne Thomas (legal representative) 603370 603370 Tanne, Thomas, of Lynne, merchant, executor of 0
3629142 1903986 1903986 defendant Tanne Thomas (legal representative) 603370 603370 Tanne, Thomas, of Lynne, merchant, executor of 0
3654321 1911611 1911611 defendant Whythe Thomas gent 603370 603370 Whythe, Thomas, of Lynne, gent 0
3663570 1914536 1914536 plaintiff Pepyr Richard merchant 603370 603370 Pepyr, Richard, of Lynne, merchant 0
3707992 1928794 1928794 plaintiff Miller Thomas merchant 603370 603370 Miller, Thomas, of Lynne, merchant 0
3707994 1928795 1928795 plaintiff Miller Thomas merchant 603370 603370 Miller, Thomas, of Lynne, merchant 0
3730510 1935777 1935777 plaintiff Branstell Christopher   603370 603370 Branstell, Christopher, of Lynne 0
3731124 1935960 1935960 defendant Bothom John husbandman 603370 603370 Bothom, John, of Lynne, husbandman 0
3735014 1937187 1937187 plaintiff Guybon Thomas esq 603370 603370 Guybon, Thomas, of Lynne, esq 0
3741140 1939091 1939091 defendant Mason Thomas (legal representative) 603370 603370 Mason, Thomas, of Lynne, merchant, executors of 0
3746694 1940878 1940878 defendant Palmer Thomas merchant 603370 603370 Palmer, Thomas, of Lynne, merchant 0
3794393 1956124 1956124 defendant Lucas Thomas (legal representative) 603370 603370 Lucas, Thomas, of Lynne, merchant, executor of 3
3817199 1963294 1963294 defendant Knyght William yeoman 603370 603370 Knyght, William, of Lynne, yeoman 1
3894619 1988407 1988407 defendant Danyell Humphrey husbandman 603370 603370 Danyell, Humphrey, of Lynne, husbandman 5
3895073 1988563 1988563 plaintiff Skalys John (legal representative) 603370 603370 Skalys, John, of Lynne, executrix of 0
3934002 2001671 2001671 defendant Warner Robert chapman 603370 603370 Warner, Robert, of Lynne, chapman 0
3973140 2015177 2015177 plaintiff Grave Thomas merchant 603370 603370 Grave, Thomas, of Lynne, merchant 0
4000410 2024915 2024915 plaintiff Wadson John   603370 603370 Wadson, John, of Lynne, corn merchant 1
4000413 2024916 2024916 plaintiff Wadson John   603370 603370 Wadson, John, of Lynne, corn merchant 1
4000415 2024917 2024917 plaintiff Grave Thomas merchant 603370 603370 Grave, Thomas, of Lynne, merchant 0
4015025 2030074 2030074 defendant Anderson William husbandman 603370 603370 Anderson, William, of Lynne, husbandman 1
4324158 2138483 2138483 defendant Hall John gent 603370 603370 Hall, John, of Lynne, gent 0
4419715 2171062 2171062 plaintiff Bernoye William   603370 603370 Bernoye, William, of Lynne 0
4439150 2181528 2181528 defendant Walton Richard sheerman 603370 603370 Walton, Richard, of Lynne, sheerman 1
4442466 2182589 2182589 defendant Sadeler John   603370 603370 Sadeler, John, of Lynne 0
4448563 2184477 2184477 defendant Madefeld William, junior   603370 603370 Madefeld, William, junior, of Lynne 5
4452586 2185812 2185812 defendant Dorset Thomas   603370 603370 Dorset, Thomas, of Lynne 0
4453417 2186074 2186074 defendant Sparham Thomas merchant 603370 603370 Sparham, Thomas, of Lynne, merchant 0
4454210 2186332 2186332 defendant Magges John   603370 603370 Magges, John, of Lynne 0
4462994 2189127 2189127 defendant Faukes Edmund   603370 603370 Faukes, Edmund, of lynne 0
4465643 2189929 2189929 plaintiff Wyght Philip   603370 603370 Wyght, Philip, of Lynne 0
4479327 2194183 2194183 plaintiff Waterden Robert   603370 603370 Waterden, Robert, of Lynne 1
4479328 2194183 2194183 defendant Lynschale William   603370 603370 Lynschale, William, of lynne 0
4479336 2194186 2194186 plaintiff Waterden Robert   603370 603370 Waterden, Robert, of Lynne 1
4479337 2194186 2194186 defendant Lansthale William   603370 603370 Lansthale, William, of Lynne 0
4492862 2198471 2198471 defendant Trunche John   603370 603370 Trunche, John, of Lynne 0
4497207 2199780 2199780 defendant Knorre John   603370 603370 Knorre, John, of Lynne 1
4497214 2199781 2199781 defendant Knorre (illegible)   603370 603370 Knorre, ----, of Lynne 2
4501917 2201200 2201200 defendant Alcok John   603370 603370 Alcok, John, of Lynne 0
4501922 2201201 2201201 defendant Alcok John   603370 603370 Alcok, John, of Lynne 0
4503525 2201676 2201676 defendant Wych John   603370 603370 Wych, John, of Lynne, vitriar or glass maker 0
4504243 2201880 2201880 defendant Gaylard William   603370 603370 Gaylard, William, of Lynne 0
4508348 2203098 2203098 defendant Taverner John   603370 603370 Taverner, John, of Lynne 0
4523659 2207727 2207727 defendant Wareyn Adam   603370 603370 Wareyn, Adam, of Lynne 1
4523902 2207807 2207807 defendant Taweton Thomas   603370 603370 Taweton, Thomas, of Lynne 3
4529168 2209401 2209401 defendant Stokke Robert   603370 603370 Stokke, Robert, of Lynne 0
4539662 2212665 2212665 defendant Eston Roger   603370 603370 Eston, Roger, of Lynne 0
4540959 2213079 2213079 defendant Foulere Thomas   603370 603370 Foulere, Thomas, of Lynne 0
4544332 2214138 2214138 defendant Wymundham Richard   603370 603370 Wymundham, Richard, of Lynne 1
4544377 2214149 2214149 defendant Wymundham Richard   603370 603370 Wymundham, Richard, of Lynne 2
4544982 2214352 2214352 defendant Hokeryng John   603370 603370 Hokeryng, John, of Lynne 1
4546450 2214822 2214822 defendant Rosse John   603370 603370 Rosse, John, of Lynne 2
4550820 2216193 2216193 defendant Goldyng Richard mariner 603370 603370 Goldyng, Richard, of Lynne, mariner 0
4550822 2216193 2216193 defendant Sparkes Thomas   603370 603370 Sparkes, Thomas, of Lynne 2
4551971 2216566 2216566 defendant Twayt Richard   603370 603370 Twayt, Richard, of Lynne 0
4554346 2217287 2217287 plaintiff Grene Thomas   603370 603370 Grene, Thomas, of Lynne, burgess 0
4556497 2217969 2217969 defendant Lynschalle William   603370 603370 Lynschalle, William, of Lynne 0
4561160 2219450 2219450 defendant Howelet Lawrence chapman 603370 603370 Howelet, Lawrence, of Lynne, chapman 0
4570635 2222391 2222391 defendant Baldeswell John   603370 603370 Baldeswell, John, of Lynne 0
4575390 2223817 2223817 plaintiff Botesham Robert   603370 603370 Botesham, Robert, of Lynne 0
4590719 2228451 2228451 defendant Gardyner William butcher 603370 603370 Gardyner, William, of Lynne, butcher 0
4590722 2228452 2228452 defendant Gardyner William butcher 603370 603370 Gardyner, William, of Lynne, butcher 0
4605862 2232946 2232946 defendant Wyth William   603370 603370 Wyth, William, of Lynne 4
4615458 2235842 2235842 defendant Systerne John   603370 603370 Systerne, John, of Lynne 4
4615465 2235843 2235843 defendant Systerne John   603370 603370 Systerne, John, of Lynne 3
4616885 2236284 2236284 defendant Borowe John   603370 603370 Borowe, John, of Lynne 1
4630687 2240500 2240500 defendant Creyk John   603370 603370 Creyk, John, of Lynne 9
4640428 2243312 2243312 defendant Patryk John   603370 603370 Patryk, John, of Lynne 2
4640999 2243462 2243462 defendant Trussebut Thomas   603370 603370 Trussebut, Thomas, of Lynne 3
4648366 2245571 2245571 defendant Brunham John   603370 603370 Brunham, John, of Lynne 5
4658046 2248393 2248393 plaintiff Cook Hugh draper 603370 603370 Cook, Hugh, of Lynne, draper 0
4732846 2275447 2275447 defendant Grove John ploughman 603370 603370 Grove, John, of Lynne, ploughman 0
4740085 2277616 2277616 defendant Burman John chapman 603370 603370 Burman, John, of Lynne, chapman 0
4758451 2283021 2283021 plaintiff Byrcham Stephen   603370 603370 Byrcham, Stephen, of Lynne 0
4780376 2289860 2289860 plaintiff Burcham Stephen   603370 603370 Burcham, Stephen, of Lynne 0
4812184 2299925 2299925 plaintiff Grene Thomas   603370 603370 Grene, Thomas, of Lynne, burgess 0
4814962 2300790 2300790 defendant Stacy William brewer 603370 603370 Stacy, William, of Lynne, brewer 0
4856333 2313355 2313355 plaintiff Barry Richard merchant 603370 603370 Barry, Richard, of Lynne, merchant 0
4888535 2323213 2323213 plaintiff Pygot John   603370 603370 Pygot, John, of Lynne 1
4905366 2328269 2328269 plaintiff Pygot John   603370 603370 Pygot, John, of Lynne 1
4905664 2328372 2328372 defendant Knyght John   603370 603370 Knyght, John, of Lynne, holy water clerk 0
4936714 2337865 2337865 plaintiff Brekerope John (legal representative) 603370 603370 Brekerope, John, of Lynne, executors of 0
4944020 2340098 2340098 plaintiff Gyggys Richard merchant 603370 603370 Gyggys, Richard, of Lynne, merchant 0
4944021 2340098 2340098 plaintiff Skynnere Hugh   603370 603370 Skynnere, Hugh, of Lynne 1
4953905 2343132 2343132 defendant Mullisworth William merchant 603370 603370 Mullisworth, William, of Lynne, merchant 0
4982331 2351632 2351632 plaintiff Tolyot or Tullyote Thomas mercer 603370 603370 Tolyot or Tullyote, Thomas, of Lynne, mercer 0
5017401 2361978 2361978 plaintiff Chawesex Thomas   603370 603370 Chawesex, Thomas, of Lynne 0
5071878 2378083 2378083 defendant Olyet Thomas   603370 603370 Olyet, Thomas, of Lynne, coverlet weaver 3
5075989 2379312 2379312 defendant Wythe John (legal representative) 603370 603370 Wythe, John, of Lynne, merchant, executors of 0
5093482 2384494 2384494 plaintiff Pye John   603370 603370 Pye, John, of Lynne 0
5214692 2420025 2420025 plaintiff Calbot Thomas merchant 603370 603370 Calbot, Thomas, of Lynne, merchant 0
5214694 2420026 2420026 plaintiff Calbot Thomas merchant 603370 603370 Calbot, Thomas, of Lynne, merchant 0
5243130 2428191 2428191 defendant Golsell Thomas esq 603370 603370 Golsell, Thomas, of Lynne, esq 0
5350228 2460193 2460193 defendant Carter Thomas yeoman 603370 603370 Carter, Thomas, of Lynne, yeoman 0
5391287 2472587 2472587 plaintiff Pateman Roger   603370 603370 Pateman, Roger, of Lynne 0
5404496 2476356 2476356 plaintiff Peteman Roger   603370 603370 Peteman, Roger, of Lynne 0
5404660 2476410 2476410 plaintiff Poteman Roger   603370 603370 Poteman, Roger, of Lynne 0
5417619 2480189 2480189 plaintiff Peteman Roger   603370 603370 Peteman, Roger, of Lynne 0
5502405 2505674 2505674 plaintiff Thursby Thomas merchant 603370 603370 Thursby, Thomas, of Lynne, merchant 0
5502410 2505675 2505675 plaintiff Thursby Thomas merchant 603370 603370 Thursby, Thomas, of Lynne, merchant 0

Next page

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);