names

73 rows where place_id = 609366

✎ 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
3678113 1919205 1919205 defendant Thomas John husbandman 609366 609366 Thomas, John, of Thacham, husbandman 0
3778723 1951061 1951061 defendant Butler Giles yeoman 609366 609366 (Butler, Giles, of Thacham, yeoman 1
3778724 1951061 1951061 defendant Butler Joan widow 609366 609366 Butler, Joan, of Thacham, widow 2
3806222 1959865 1959865 defendant Ludlowe Richard turner 609366 609366 Ludlowe, Richard, of Thacham, turner 0
3816766 1963151 1963151 defendant Dawby William millman 609366 609366 Dawby, William, of Thacham, millman 0
3830574 1967440 1967440 defendant Bradley John butcher 609366 609366 Bradley, John, of Thacham, butcher 0
3831936 1967884 1967884 defendant Lewes Thomas butcher 609366 609366 Lewes, Thomas, of Thacham, butcher 0
3858841 1976445 1976445 defendant Bye Edward fuller 609366 609366 Bye, Edward, of Thacham, fuller 0
3878137 1982937 1982937 defendant Hatte Thomas husbandman 609366 609366 Hatte, Thomas, of Thacham, husbandman 1
3880677 1983803 1983803 defendant Lewes Thomas butcher 609366 609366 Lewes, Thomas, of Thacham, butcher 0
3880678 1983803 1983803 defendant Whyte Robert fuller 609366 609366 Whyte, Robert, of Thacham, fuller 1
3900437 1990377 1990377 defendant Bye Edmund fuller 609366 609366 Bye, Edmund, of Thacham, fuller 0
3900438 1990377 1990377 defendant Busshenell John laborer 609366 609366 Busshenell, John, of Thacham, laborer 1
3900439 1990377 1990377 defendant Saydleyr John laborer 609366 609366 Saydleyr, John, of Thacham, laborer 2
3900440 1990377 1990377 defendant Sadleyr Robert laborer 609366 609366 Sadleyr, Robert, of Thacham, laborer 3
3900444 1990378 1990378 defendant Monke Thomas husbandman 609366 609366 Monke, Thomas, of Thacham, husbandman 1
3903027 1991240 1991240 plaintiff Foster Giles esq 609366 609366 Foster, Giles, of Thacham, esq 0
3921031 1997383 1997383 defendant Pole Richard clerk 609366 609366 Pole, Richard, of Thacham, clerk 0
3992444 2022063 2022063 defendant Harberd Richard tailor 609366 609366 Harberd, Richard, of Thacham, tailor 0
4011914 2028989 2028989 plaintiff Powle Robert yeoman 609366 609366 Powle, Robert, of Thacham, yeoman 0
4203141 2096647 2096647 defendant Pydgeon John tanner 609366 609366 Pydgeon, John, of Thacham, tanner 1
4269334 2119334 2119334 defendant Alexander Paul gent 609366 609366 Alexander, Paul, of Thacham, gent 0
4431698 2174684 2174684 defendant Draper John le   609366 609366 Draper, John le, of Thacham 0
4435838 2175957 2175957 plaintiff Poyer Stephen   609366 609366 Poyer, Stephen, of Thacham 0
4495755 2199356 2199356 plaintiff Chapman Thomas   609366 609366 Chapman, Thomas, of Thacham, on his own account 0
4495756 2199356 2199356 defendant Strode Thomas   609366 609366 Strode, Thomas, of Thacham 0
4513606 2204681 2204681 plaintiff Brounsmyth William (legal representative) 609366 609366 Brounsmyth, William, of Thacham, executors of 0
4528920 2209324 2209324 defendant Thwyhey Richard   609366 609366 Thwyhey, Richard, of Thacham 3
4528928 2209326 2209326 defendant Thwykey Richard   609366 609366 Thwykey, Richard, of Thacham 3
4582174 2225863 2225863 defendant Kyppyng John   609366 609366 Kyppyng, John, of Thacham 0
4588507 2227774 2227774 defendant Sutton John chapman 609366 609366 Sutton, John, of Thacham, chapman 3
4609572 2234093 2234093 defendant Bowre John chapman 609366 609366 Bowre, John, of Thacham, chapman 0
4609573 2234093 2234093 defendant Brasier Thomas   609366 609366 Brasier, Thomas, of Thacham 1
4615047 2235719 2235719 defendant Croweland John   609366 609366 Croweland, John, of Thacham 0
4616122 2236049 2236049 defendant Croweland John chapman 609366 609366 Croweland, John, of Thacham, chapman 1
4616126 2236050 2236050 defendant Croweland John chapman 609366 609366 Croweland, John, of Thacham, chapman 1
4619327 2237038 2237038 defendant Hosyer Richard   609366 609366 Hosyer, Richard, of Thacham 0
4622991 2238168 2238168 defendant Boure John   609366 609366 Boure, John, of Thacham 0
4649236 2245827 2245827 defendant Adam John   609366 609366 Adam, John, of Thacham 0
4736085 2276426 2276426 plaintiff Sutton John   609366 609366 Sutton, John, of Thacham 0
4738914 2277262 2277262 defendant Snell John carpenter 609366 609366 Snell, John, of Thacham, carpenter 0
4794581 2294445 2294445 defendant Hille John chapman 609366 609366 Hille, John, of Thacham, chapman 0
4892373 2324352 2324352 defendant Bye John chapman 609366 609366 Bye, John, of Thacham, chapman 0
4892374 2324352 2324352 defendant Vicory John butcher 609366 609366 Vicory, John, of Thacham, butcher 1
4892672 2324438 2324438 defendant Vicary John husbandman 609366 609366 Vicary, John, of Thacham, husbandman 0
4898658 2326228 2326228 defendant Vycary John husbandman 609366 609366 Vycary, John, of Thacham, husbandman 0
4925111 2334285 2334285 defendant Plesy Robert husbandman 609366 609366 Plesy, Robert, of Thacham, husbandman 0
4960913 2345227 2345227 defendant Strode alias Roper John husbandman 609366 609366 Strode alias Roper, John, of Thacham, husbandman 3
5034308 2366894 2366894 defendant Grene Patrick clerk 609366 609366 Grene, Patrick, of Thacham, clerk 0
5040993 2368930 2368930 plaintiff Chapman Thomas (legal representative) 609366 609366 Chapman, Thomas, of Thacham, executor of 0
5050084 2371647 2371647 defendant Glover John glover 609366 609366 Glover, John, of Thacham, glover 1
5054863 2373021 2373021 defendant Baker Henry fisher 609366 609366 Baker, Henry, of Thacham, fisher 0
5093723 2384560 2384560 defendant Castell Thomas (legal representative) 609366 609366 Castell, Thomas, of Thacham, chapman, executors of 0
5097071 2385575 2385575 defendant Glover John husbandman 609366 609366 Glover, John, of Thacham, husbandman 3
5097459 2385688 2385688 defendant Baker Robert ostler 609366 609366 Baker, Robert, of Thacham, ostler 0
5103361 2387412 2387412 defendant Lavender Roger weaver 609366 609366 Lavender, Roger, of Thacham, weaver 0
5103362 2387412 2387412 defendant More John weaver 609366 609366 More, John, of Thacham, weaver 1
5124540 2393640 2393640 plaintiff --astell (illegible) kerseyman 609366 609366 --astell, ---, of Thacham, kerseyman 0
5158452 2403593 2403593 defendant Bakere Robert weaver 609366 609366 Bakere, Robert, of Thacham, weaver 1
5174007 2408097 2408097 defendant Bakere Robert weaver 609366 609366 Bakere, Robert, of Thacham, weaver 1
5178620 2409461 2409461 defendant Frewyn John husbandman 609366 609366 Frewyn, John, of Thacham, husbandman 0
5178621 2409461 2409461 defendant Walsshman John husbandman 609366 609366 Walsshman, John, of Thacham, husbandman 1
5178908 2409558 2409558 defendant Holwey John, sen sheerman 609366 609366 Holwey, John, sen, of Thacham, sheerman 0
5201662 2416253 2416253 defendant Holwey John, sen sheerman 609366 609366 Holwey, John, sen, of Thacham, sheerman 0
5212370 2419360 2419360 defendant Derby John husbandman 609366 609366 Derby, John, of Thacham, husbandman 0
5248976 2429824 2429824 defendant Pecok William husbandman 609366 609366 Pecok, William, of Thacham, husbandman 0
5248980 2429825 2429825 defendant Gele Richard husbandman 609366 609366 Gele, Richard, of Thacham, husbandman 1
5306782 2447023 2447023 defendant Braknale Robert sadler 609366 609366 Braknale, Robert, of Thacham, sadler 1
5515372 2509653 2509653 defendant Dyke Richard husbandman 609366 609366 Dyke, Richard, of Thacham, husbandman 2
5550682 2520226 2520226 defendant Bakehows Richard dyer 609366 609366 Bakehows, Richard, of Thacham, dyer 0
5559689 2522792 2522792 defendant Dybley Richards grasier 609366 609366 Dybley, Richards, of Thacham, grasier 0
5580590 2529009 2529009 defendant Everard Stephen innholder 609366 609366 Everard, Stephen, of Thacham, innholder 0
5598923 2534541 2534541 defendant Frogmore Nicholas, junior carpenter 609366 609366 Frogmore, Nicholas, junior, of Thacham, carpenter 0

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