names

79 rows where place_id = 591355

✎ 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
3604156 1868966 1868966 defendant Fuller William weaver 591355 591355 Fuller, William, of Halsted, Essex, weaver 0
3652552 1911131 1911131 defendant Wynlove Robert tailor 591355 591355 Wynlove, Robert, of Halsted, Essex, tailor 0
3675014 1918214 1918214 defendant Smyth Robert smith 591355 591355 Smyth, Robert, of Halsted, Essex, smith 2
3688827 1922664 1922664 defendant Balby Nicholas clothmaker 591355 591355 Balby, Nicholas, of Halsted, Essex, clothmaker 0
3688829 1922665 1922665 defendant Balby Nicholas clothmaker 591355 591355 Balby, Nicholas, of Halsted, Essex, clothmaker 0
3724075 1933816 1933816 defendant White John plumber 591355 591355 White, John, of Halsted, Essex, plumber 0
3752027 1942556 1942556 defendant Lynde John yeoman 591355 591355 Lynde, John, of Halsted, Essex, yeoman 1
3754098 1943228 1943228 defendant Carter John smith 591355 591355 Carter, John, of Halsted, Essex, smith 1
3885849 1985523 1985523 defendant Cutler alias Leasur John clothier 591355 591355 Cutler alias Leasur, John, of Halsted, Essex, clothier 0
3910181 1993718 1993718 defendant Lunt John clothier 591355 591355 Lunt, John, of Halsted, Essex, clothier 1
3927176 1999423 1999423 defendant Martyn William clothier 591355 591355 Martyn, William, of Halsted, Essex, clothier 0
3944239 2005091 2005091 defendant Hunwyk William gent 591355 591355 Hunwyk, William, of Halsted, Essex, gent 0
3952684 2008009 2008009 plaintiff Holmested John gent 591355 591355 Holmested, John, of Halsted, Essex, gent 0
3952686 2008010 2008010 plaintiff Holmested John gent 591355 591355 Holmested, John, of Halsted, Essex, gent 0
3985748 2019664 2019664 defendant Sadlington William haberdasher 591355 591355 Sadlington, William, of Halsted, Essex, haberdasher 1
4020013 2031888 2031888 defendant Hardynge Richard gent 591355 591355 Hardynge, Richard, of Halsted, Essex, gent 0
4020017 2031890 2031890 defendant Hardinge Richard gent 591355 591355 Hardinge, Richard, of Halsted, Essex, gent 0
4034322 2036945 2036945 defendant Graye Thomas chapman 591355 591355 Graye, Thomas, of Halsted, Essex, chapman 0
4069519 2049379 2049379 defendant Grey Thomas chapman 591355 591355 Grey, Thomas, of Halsted, Essex, chapman 0
4254264 2114427 2114427 defendant Bullock John beer brewer 591355 591355 Bullock, John, of Halsted, Essex, beer brewer 0
4254268 2114428 2114428 defendant Bullocke John beer brewer 591355 591355 Bullocke, John, of Halsted, Essex, beer brewer 0
4292375 2127338 2127338 defendant Hardinge Richard gent 591355 591355 Hardinge, Richard, of Halsted, Essex, gent 1
4313074 2134692 2134692 defendant Stockdale Agnes widow 591355 591355 Stockdale, Agnes, of Halsted, Essex, widow 1
4330358 2140456 2140456 defendant Crysmas John innkeeper 591355 591355 Crysmas, John, of Halsted, Essex, innkeeper 1
4339290 2143508 2143508 defendant Turnor Ralph yeoman 591355 591355 Turnor, Ralph, of Halsted, Essex, yeoman 0
4341678 2144369 2144369 defendant Marten Roger   591355 591355 Marten, Roger, of Halsted, Essex, "aquaviteman" 0
4346016 2145864 2145864 defendant Walker Andrew miller 591355 591355 Walker, Andrew, of Halsted, Essex, or of Ratclyff, Middx, miller 0
4355910 2149285 2149285 defendant Foster Thomas, senior fukker 591355 591355 Foster, Thomas, senior, of Halsted, Essex, fukker 3
4392294 2162048 2162048 defendant Marten Roger   591355 591355 Marten, Roger, of Halsted, Essex, aquavita man 0
4392296 2162048 2162048 defendant Foster Thomas chapman 591355 591355 Foster, Thomas, of Halsted, Essex, chapman 2
4407549 2167090 2167090 defendant Shorde Thomas weaver 591355 591355 Shorde, Thomas, of Halsted, Essex, or of Cavendishe, Suff, weaver 2
4410067 2167971 2167971 defendant Foster Thomas, senior fuller 591355 591355 Foster, Thomas, senior, of Halsted, Essex, fuller 3
4677774 2258667 2258667 defendant Store Adam gent 591355 591355 Store, Adam, of Halsted, Essex, gent 0
4678528 2258890 2258890 defendant Dyere John dyer 591355 591355 Dyere, John, of Halsted, Essex, dyer 2
4725694 2273324 2273324 defendant Stoure Adam gent 591355 591355 Stoure, Adam, of Halsted, Essex, gent 0
4749609 2280369 2280369 defendant Page John, junior husbandman 591355 591355 Page, John, junior, of Halsted, Essex, husbandman 2
4773557 2287700 2287700 defendant Fuller Thomas   591355 591355 Fuller, Thomas, of Halsted, Essex, spice maker 2
4794365 2294381 2294381 defendant Fuller Thomas chapman 591355 591355 Fuller, Thomas, of Halsted, Essex, chapman 0
4855749 2313174 2313174 defendant Page John yeoman 591355 591355 Page, John, of Halsted, Essex, yeoman 0
4868453 2317106 2317106 defendant Burton Walter   591355 591355 Burton, Walter, of Halsted, Essex, minstrel 0
4868457 2317107 2317107 defendant Burton Walter   591355 591355 Burton, Walter, of Halsted, Essex, minstrel 0
4869972 2317582 2317582 defendant Fuller alias Hoo Thomas husbandman 591355 591355 Fuller alias Hoo, Thomas, of Halsted, Essex, husbandman 2
4873046 2318526 2318526 defendant Page John yeoman 591355 591355 Page, John, of Halsted, Essex, yeoman 0
4911439 2330080 2330080 defendant Boteler alias Horkesley Thomas husbandman 591355 591355 Boteler alias Horkesley, Thomas, of Halsted, Essex, husbandman 0
4963717 2346059 2346059 defendant Grenefeld Thomas gent 591355 591355 Grenefeld, Thomas, of Halsted, Essex, gent 1
4963721 2346060 2346060 defendant Grenefeld Thomas gent 591355 591355 Grenefeld, Thomas, of Halsted, Essex, gent 1
5029516 2365502 2365502 defendant Fuller Thomas hosteler 591355 591355 Fuller, Thomas, of Halsted, Essex, hosteler 2
5029520 2365503 2365503 defendant Fuller Thomas ostler 591355 591355 Fuller, Thomas, of Halsted, Essex, ostler 2
5047213 2370786 2370786 defendant Fuller Thomas husbandman 591355 591355 Fuller, Thomas, of Halsted, Essex, husbandman 3
5066289 2376445 2376445 defendant Brereton John husbandman 591355 591355 Brereton, John, of Halsted, Essex, husbandman 0
5165000 2405502 2405502 defendant Worthy John   591355 591355 Worthy, John, of Halsted, Essex 0
5187849 2412162 2412162 defendant Wrothy John gent 591355 591355 Wrothy, John, of Halsted, Essex, gent 0
5193863 2413929 2413929 defendant Warner John gent 591355 591355 Warner, John, of Halsted, Essex, gent 0
5205755 2417424 2417424 defendant Wrothy John gent 591355 591355 Wrothy, John, of Halsted, Essex, gent 0
5218421 2421119 2421119 defendant Page John yeoman 591355 591355 Page, John, of Halsted, Essex, yeoman 0
5223156 2422482 2422482 defendant Thomson Ralph yeoman 591355 591355 Thomson, Ralph, of Halsted, Essex, yeoman 0
5230273 2424473 2424473 defendant Worthy John gent 591355 591355 Worthy, John, of Halsted, Essex, gent 0
5257662 2432518 2432518 plaintiff Fuller John yeoman 591355 591355 Fuller, John, of Halsted, Essex, yeoman 0
5266241 2435195 2435195 defendant Worthy Elizabeth widow 591355 591355 Worthy, Elizabeth, of Halsted, Essex, widow 3
5270567 2436487 2436487 defendant Warnere John esq 591355 591355 Warnere, John, of Halsted, Essex, esq 0
5274697 2437676 2437676 defendant Salkyn Robert yeoman 591355 591355 Salkyn, Robert, of Halsted, Essex, yeoman 4
5285071 2440661 2440661 defendant Worthy John (legal representative) 591355 591355 Worthy, John, of Halsted, Essex, gent, administratrix of 0
5373125 2467190 2467190 defendant Symys William husbandman 591355 591355 Symys, William, of Halsted, Essex, husbandman 3
5383959 2470498 2470498 defendant Basch John laborer 591355 591355 Basch, John, of Halsted, Essex, laborer 0
5409045 2477669 2477669 defendant Dasth John laborer 591355 591355 Dasth, John, of Halsted, Essex, laborer 0
5422528 2481683 2481683 defendant Wattok Thomas carpenter 591355 591355 Wattok, Thomas, of Halsted, Essex, carpenter 1
5442167 2487574 2487574 defendant Wattok Thomas carpenter 591355 591355 Wattok, Thomas, of Halsted, Essex, carpenter 1
5454908 2491385 2491385 defendant Wattok Thomas carpenter 591355 591355 Wattok, Thomas, of Halsted, Essex, carpenter 1
5500279 2505032 2505032 defendant Tyllyngham John husbandman 591355 591355 Tyllyngham, John, of Halsted, Essex, husbandman 0
5520438 2511213 2511213 defendant Alilley William chapman 591355 591355 Alilley, William, of Halsted, Essex, chapman 0
5522224 2511767 2511767 defendant Lydyate homas dyer 591355 591355 Lydyate, homas, of Halsted, Essex, dyer 0
5543301 2518022 2518022 defendant Lediett Thomas dyer 591355 591355 Lediett, Thomas, of Halsted, Essex, dyer 0
5543306 2518023 2518023 defendant Lydiett Thomas dyer 591355 591355 Lydiett, Thomas, of Halsted, Essex, dyer 0
5550408 2520139 2520139 defendant Joslyn Philip clerk 591355 591355 Joslyn, Philip, of Halsted, Essex, clerk 0
5557835 2522244 2522244 defendant Josselyn Philip master of Halsted College 591355 591355 Josselyn, Philip, of Halsted, Essex, clerk, master of Halsted College 0
5566088 2524680 2524680 defendant Josselyn Philip clerk 591355 591355 Josselyn, Philip, of Halsted, Essex, clerk 0
5570090 2525828 2525828 defendant Browne John husbandman 591355 591355 Browne, John, of Halsted, Essex, husbandman 0
5576142 2527601 2527601 defendant Josselyn Philip clerk 591355 591355 Josselyn, Philip, of Halsted, Essex, clerk 0
5591603 2532354 2532354 defendant Maren Robert tanner 591355 591355 Maren, Robert, of Halsted, Essex, tanner 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);