names

106 rows where place_id = 597563

✎ 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
3629030 1903956 1903956 defendant Bonor Thomas yeoman 597563 597563 Bonor, Thomas, of Manytre, Essex, yeoman 0
3651937 1910953 1910953 plaintiff Thwaytys Christopher (legal representative) 597563 597563 Thwaytys, Christopher, of Manytre, Essex, gent, executors of 0
3657881 1912713 1912713 defendant Bownowre Thomas mercer 597563 597563 Bownowre, Thomas, of Manytre, Essex, mercer 0
3659423 1913208 1913208 defendant Cradok John tailor 597563 597563 Cradok, John, of Manytre, Essex, tailor 1
3675583 1918400 1918400 defendant Kelyk William mercer 597563 597563 Kelyk, William, of Manytre, Essex, mercer 0
3684039 1921142 1921142 defendant Aleyn Robert sherman 597563 597563 Aleyn, Robert, of Manytre, Essex, sherman 0
3692988 1924008 1924008 defendant Aleyn Robert dyer 597563 597563 Aleyn, Robert, of Manytre, Essex, dyer 0
3693406 1924154 1924154 plaintiff Man John merchant 597563 597563 Man, John, of Manytre, Essex, merchant 0
3693409 1924155 1924155 plaintiff Man John merchant 597563 597563 Man, John, of Manytre, Essex, merchant 0
3703378 1927332 1927332 defendant Payne Simon carrier 597563 597563 Payne, Simon, of Manytre, Essex, carrier 1
3732030 1936251 1936251 defendant Pye Robert mercer 597563 597563 Pye, Robert, of Manytre, Essex, mercer 0
3732725 1936467 1936467 plaintiff Crystmas Thomas (legal representative) 597563 597563 Crystmas, Thomas, of Manytre, Essex, executor of 0
3736892 1937793 1937793 defendant Ellen alias Paylemaker William mariner 597563 597563 Ellen alias Paylemaker, William, of Manytre, Essex, mariner 0
3744456 1940168 1940168 defendant Bennor Thomas chapman 597563 597563 Bennor, Thomas, of Manytre, Essex, chapman 3
3752645 1942758 1942758 defendant Jobson John merchant 597563 597563 Jobson, John, of Manytre, Essex, merchant 1
3754103 1943229 1943229 defendant Hale Edward chapman 597563 597563 Hale, Edward, of Manytre, Essex, chapman 0
3769456 1948107 1948107 defendant Jobson John merchant 597563 597563 Jobson, John, of Manytre, Essex, merchant 1
3769900 1948241 1948241 defendant Darnell James merchant 597563 597563 Darnell, James, of Manytre, Essex, merchant 0
3771657 1948834 1948834 plaintiff Thawaytes William gent 597563 597563 Thawaytes, William, of Manytre, Essex, gent 0
3787877 1953998 1953998 defendant Darnell James merchant 597563 597563 Darnell, James, of Manytre, Essex, merchant 0
3793467 1955822 1955822 defendant Butteler John merchant 597563 597563 Butteler, John, of Manytre, Essex, merchant 0
3793778 1955918 1955918 defendant Byat Richard blacksmith 597563 597563 Byat, Richard, of Manytre, Essex, blacksmith 0
3795621 1956515 1956515 defendant Bretylbank Nicholas passenger 597563 597563 Bretylbank, Nicholas, of Manytre, Essex, passenger 1
3821998 1964770 1964770 defendant Cradok John tailor 597563 597563 Cradok, John, of Manytre, Essex, tailor 1
3822001 1964771 1964771 defendant Cradok John tailor 597563 597563 Cradok, John, of Manytre, Essex, tailor 1
3842509 1971189 1971189 defendant Hawle Edward clothman 597563 597563 Hawle, Edward, of Manytre, Essex, clothman 3
3844045 1971683 1971683 defendant Budde William clothier 597563 597563 Budde, William, of Manytre, Essex, clothier 0
3851403 1974038 1974038 defendant Darnell James clothmaker 597563 597563 Darnell, James, of Manytre, Essex, clothmaker 0
3862291 1977575 1977575 defendant Garrad William butcher 597563 597563 Garrad, William, of Manytre, Essex, butcher 3
3876341 1982332 1982332 defendant Boner Thomas merchant 597563 597563 Boner, Thomas, of Manytre, Essex, merchant 0
3887753 1986161 1986161 defendant Boner Thomas merchant 597563 597563 Boner, Thomas, of Manytre, Essex, merchant 0
3901856 1990844 1990844 defendant Symonde John husbandman 597563 597563 Symonde, John, of Manytre, Essex, husbandman 0
3904352 1991704 1991704 defendant Lock William clothman 597563 597563 Lock, William, of Manytre, Essex, clothman 1
3910175 1993717 1993717 defendant Lock William clothier 597563 597563 Lock, William, of Manytre, Essex, clothier 0
3910183 1993718 1993718 defendant Went Thomas clothier 597563 597563 Went, Thomas, of Manytre, Essex, clothier 3
3910377 1993790 1993790 defendant Lok William clothmaker 597563 597563 Lok, William, of Manytre, Essex, clothmaker 0
3932650 2001215 2001215 defendant Brokelbanke Nicholas   597563 597563 Brokelbanke, Nicholas, of Manytre, Essex 0
4030259 2035474 2035474 defendant Lyllye John husbandman 597563 597563 Lyllye, John, of Manytre, Essex, husbandman 0
4061649 2046563 2046563 defendant Gosse William husbandman 597563 597563 Gosse, William, of Manytre, Essex, husbandman 0
4180076 2088511 2088511 defendant Johnson Hercules beer brewer 597563 597563 Johnson, Hercules, of Manytre, Essex, beer brewer 0
4558447 2218589 2218589 defendant Hardyng William   597563 597563 Hardyng, William, of Manytre, Essex 0
4632336 2241001 2241001 defendant Haddenham William   597563 597563 Haddenham, William, of Manytre, Essex 0
4652310 2246675 2246675 defendant Munk John chapman 597563 597563 Munk, John, of Manytre, Essex, chapman 1
4652335 2246681 2246681 defendant Joye John mercer 597563 597563 Joye, John, of Manytre, Essex, mercer 0
4667530 2255564 2255564 defendant Joye John, senior yeoman 597563 597563 Joye, John, senior, of Manytre, Essex, yeoman 3
4670432 2256437 2256437 defendant atte Stone Thomas fuller 597563 597563 atte Stone, Thomas, of Manytre, Essex, fuller 3
4686522 2261391 2261391 defendant Joye John   597563 597563 Joye, John, of Manytre, Essex 0
4689271 2262206 2262206 defendant Bakere John tanner 597563 597563 Bakere, John, of Manytre, Essex, tanner 0
4734187 2275873 2275873 defendant Debenham John yeoman 597563 597563 Debenham, John, of Manytre, Essex, yeoman 0
4755736 2282177 2282177 defendant Ducheman Dedericus barber 597563 597563 Ducheman, Dedericus, of Manytre, Essex, barber 2
4777724 2289026 2289026 defendant Ducheman Dederic barber 597563 597563 Ducheman, Dederic, of Manytre, Essex, barber 0
4814682 2300706 2300706 defendant Mendham Richard yeoman 597563 597563 Mendham, Richard, of Manytre, Essex, yeoman 0
4870446 2317728 2317728 defendant Dyere Nicholas dyer 597563 597563 Dyere, Nicholas, of Manytre, Essex, dyer 2
4886402 2322607 2322607 defendant Stratton John chapman 597563 597563 Stratton, John, of Manytre, Essex, chapman 3
4889003 2323351 2323351 defendant Stratton John chapman 597563 597563 Stratton, John, of Manytre, Essex, chapman 3
4897183 2325773 2325773 defendant Herde John cordwainer 597563 597563 Herde, John, of Manytre, Essex, cordwainer 4
4920285 2332858 2332858 defendant Debenham John husbandman 597563 597563 Debenham, John, of Manytre, Essex, husbandman 1
4967591 2347248 2347248 defendant Hulwode John carpenter 597563 597563 Hulwode, John, of Manytre, Essex, carpenter 1
4976414 2349908 2349908 defendant Fletysmouth John merchant 597563 597563 Fletysmouth, John, of Manytre, Essex, merchant 2
4983557 2351999 2351999 defendant Fletysmouthe John yeoman 597563 597563 Fletysmouthe, John, of Manytre, Essex, yeoman 0
4988295 2353468 2353468 defendant Grantham William   597563 597563 Grantham, William, of Manytre, Essex, bakere 3
4997224 2356023 2356023 defendant Calwer William chapman 597563 597563 Calwer, William, of Manytre, Essex, chapman 0
5006079 2358666 2358666 defendant Hulwode John carpenter 597563 597563 Hulwode, John, of Manytre, Essex, carpenter 0
5019857 2362686 2362686 defendant Fletesmowth John yeoman 597563 597563 Fletesmowth, John, of Manytre, Essex, yeoman 0
5053239 2372571 2372571 defendant Bonde Adam smith 597563 597563 Bonde, Adam, of Manytre, Essex, smith 1
5154918 2402596 2402596 defendant Fletysmouth John yeoman 597563 597563 Fletysmouth, John, of Manytre, Essex, yeoman 4
5250807 2430361 2430361 defendant Pulter Thomas yeoman 597563 597563 Pulter, Thomas, of Manytre, Essex, yeoman 0
5251415 2430541 2430541 defendant Bodde William husbandman 597563 597563 Bodde, William, of Manytre, Essex, husbandman 1
5251601 2430604 2430604 defendant Hylp Robert yeoman 597563 597563 Hylp, Robert, of Manytre, Essex, yeoman 4
5293784 2443146 2443146 defendant Buxton John mercer 597563 597563 Buxton, John, of Manytre, Essex, mercer 1
5315712 2449763 2449763 defendant Broke Robert husbandman 597563 597563 Broke, Robert, of Manytre, Essex, husbandman 3
5331196 2454406 2454406 plaintiff Brook Robert   597563 597563 Brook, Robert, of Manytre, Essex 0
5349182 2459869 2459869 defendant Brook Robert merchant 597563 597563 Brook, Robert, of Manytre, Essex, merchant 3
5351470 2460558 2460558 defendant Edwarde John shipman 597563 597563 Edwarde, John, of Manytre, Essex, shipman 0
5356277 2462041 2462041 defendant Brooke William yeoman 597563 597563 Brooke, William, of Manytre, Essex, yeoman 0
5368713 2465806 2465806 defendant Broke Robert merchant 597563 597563 Broke, Robert, of Manytre, Essex, merchant 0
5368722 2465808 2465808 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 0
5370840 2466468 2466468 defendant Broke William yeoman 597563 597563 Broke, William, of Manytre, Essex, yeoman 3
5380033 2469342 2469342 defendant Broke Robert merchant 597563 597563 Broke, Robert, of Manytre, Essex, merchant 0
5380035 2469342 2469342 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 2
5380896 2469592 2469592 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 1
5386770 2471283 2471283 defendant Broke Robert, senior merchant 597563 597563 Broke, Robert, senior, of Manytre, Essex, merchant 0
5386783 2471286 2471286 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 0
5395661 2473842 2473842 defendant Broke Robert merchant 597563 597563 Broke, Robert, of Manytre, Essex, merchant 0
5397250 2474297 2474297 defendant Brook Robert, senior   597563 597563 Brook, Robert, senior, of Manytre, Essex, cloth man 0
5397443 2474355 2474355 defendant Brook Robert merchant 597563 597563 Brook, Robert, of manytre, Essex, merchant 3
5399165 2474832 2474832 defendant Broke Robert, senior merchant 597563 597563 Broke, Robert, senior, of Manytre, Essex, merchant 0
5399169 2474833 2474833 defendant Broke Robert, senior merchant 597563 597563 Broke, Robert, senior, of Manytre, Essex, merchant 0
5399181 2474836 2474836 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 0
5407968 2477358 2477358 defendant Brook Richard, senior   597563 597563 Brook, Richard, senior, of Manytre, Essex, cloth maker 1
5410467 2478076 2478076 defendant Brook Robert clothman 597563 597563 Brook, Robert, of Manytre, Essex, clothman 0
5412207 2478604 2478604 defendant Broke Robert, sen merchant 597563 597563 Broke, Robert, sen, of Manytre, Essex, merchant 0
5412211 2478605 2478605 defendant Broke William beer brewer 597563 597563 Broke, William, of Manytre, Essex, beer brewer 0
5412212 2478605 2478605 defendant Broke Robert   597563 597563 Broke, Robert, of Manytre, Essex 1
5421173 2481261 2481261 defendant Brook Robert, sen clothmaker 597563 597563 Brook, Robert, sen, of Manytre, Essex, clothmaker 1
5424353 2482248 2482248 defendant Brook Robert clothman 597563 597563 Brook, Robert, of Manytre, Essex, clothman 0
5424356 2482249 2482249 defendant Brook Robert clothman 597563 597563 Brook, Robert, of Manytre, Essex, clothman 0
5424359 2482250 2482250 defendant Brook Robert, sen clothman 597563 597563 Brook, Robert, sen, of Manytre, Essex, clothman 0
5424609 2482332 2482332 defendant Brook Robert merchant 597563 597563 Brook, Robert, of Manytre, Essex, merchant 2
5440373 2487016 2487016 defendant Brook Robert, sen clothmaker 597563 597563 Brook, Robert, sen, of Manytre, Essex, clothmaker 1

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