names

187 rows where place_id = 586424

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588689 1864106 1864106 defendant Sharnebroke Robert butcher 586424 586424 Sharnebroke, Robert, of Hoddesdon, butcher 1
3594928 1866041 1866041 defendant Couper William butcher 586424 586424 Couper, William, of Hoddesdon, butcher 0
3605561 1869406 1869406 defendant Peres Richard butcher 586424 586424 Peres, Richard, of Hoddesdon, butcher 2
3612459 1871528 1871528 defendant Laurence John yeoman 586424 586424 Laurence, John, of Hoddesdon, yeoman 0
3614726 1872254 1872254 defendant Bocher John butcher 586424 586424 Bocher, John, of Hoddesdon, butcher 0
3618919 1873526 1873526 defendant Volantyne John husbandman 586424 586424 Volantyne, John, of Hoddesdon, husbandman 3
3630117 1904267 1904267 defendant Manke or Mayke Thomas maltman 586424 586424 Manke or Mayke, Thomas, of Hoddesdon, maltman 3
3640357 1907414 1907414 defendant Sowet Thomas maltman 586424 586424 Sowet, Thomas, of Hoddesdon, maltman 0
3658004 1912756 1912756 defendant Abbot Thomas hakneyman 586424 586424 Abbot, Thomas, of Hoddesdon, hakneyman 0
3660896 1913675 1913675 defendant Lukley Richard husbandman 586424 586424 Lukley, Richard, of Hoddesdon, husbandman 0
3663320 1914451 1914451 defendant Gaveloke Thomas smith 586424 586424 Gaveloke, Thomas, of Hoddesdon, smith 2
3665059 1915019 1915019 defendant Abbot Thomas butcher 586424 586424 Abbot, Thomas, of Hoddesdon, butcher 0
3671360 1917018 1917018 defendant Abbot Thomas courser 586424 586424 Abbot, Thomas, of Hoddesdon, courser 3
3674590 1918104 1918104 defendant Lokley Richard husbandman 586424 586424 Lokley, Richard, of Hoddesdon, husbandman 0
3677036 1918857 1918857 defendant Smyth William innholder 586424 586424 Smyth, William, of Hoddesdon, innholder 0
3680177 1919872 1919872 defendant Lucas George innholder 586424 586424 Lucas, George, of Hoddesdon, innholder 0
3681573 1920326 1920326 defendant Slyght Richard yeoman 586424 586424 Slyght, Richard, of Hoddesdon, yeoman 0
3685864 1921738 1921738 defendant Habot alias Abbott Thomas yeoman 586424 586424 Habot alias Abbott, Thomas, of Hoddesdon, yeoman 0
3692071 1923690 1923690 defendant Hamer Robert butcher 586424 586424 Hamer, Robert, of Hoddesdon, butcher 0
3697101 1925312 1925312 defendant Abbott Thomas courser 586424 586424 Abbott, Thomas, of Hoddesdon, courser 0
3697665 1925493 1925493 defendant Haggard John yeoman 586424 586424 Haggard, John, of Hoddesdon, yeoman 2
3736210 1937568 1937568 defendant Barganer William carpenter 586424 586424 Barganer, William, of Hoddesdon, carpenter 2
3741253 1939122 1939122 defendant Wellys John tailor 586424 586424 Wellys, John, of Hoddesdon, tailor 1
3748955 1941605 1941605 defendant Slyght Richard fisher 586424 586424 Slyght, Richard, of Hoddesdon, fisher 0
3766657 1947232 1947232 defendant Stevenson Robert husbandman 586424 586424 Stevenson, Robert, of Hoddesdon, husbandman 4
3783311 1952531 1952531 defendant Cocke John husbandman 586424 586424 Cocke, John, of Hoddesdon, husbandman 0
3795276 1956390 1956390 defendant Cok John or Joan courser 586424 586424 Cok, John or Joan, of Hoddesdon, courser 0
3806419 1959918 1959918 defendant Abbott John yeoman 586424 586424 Abbott, John, of Hoddesdon, yeoman 2
3809969 1961004 1961004 defendant Rumbold Robert maltman 586424 586424 Rumbold, Robert, of Hoddesdon, maltman 0
3809970 1961004 1961004 defendant Hellam Henry husbandman 586424 586424 Hellam, Henry, of Hoddesdon, husbandman 1
3809971 1961004 1961004 defendant Thurgood Thomas husbandman 586424 586424 Thurgood, Thomas, of Hoddesdon, husbandman 2
3816900 1963191 1963191 defendant Colson Richard courser 586424 586424 Colson, Richard, of Hoddesdon, courser 0
3843893 1971629 1971629 defendant Holewey Andrew yeoman 586424 586424 Holewey, Andrew, of Hoddesdon, yeoman 2
3847885 1972915 1972915 defendant Reve Robert butcher 586424 586424 Reve, Robert, of Hoddesdon, butcher 2
3848447 1973093 1973093 defendant Cokley William woolman 586424 586424 Cokley, William, of Hoddesdon, woolman 0
3872286 1980954 1980954 plaintiff Bennett Thomas yeoman 586424 586424 Bennett, Thomas, of Hoddesdon, yeoman 0
3895049 1988553 1988553 defendant Hedger Thomas husbandman 586424 586424 Hedger, Thomas, of Hoddesdon, husbandman 0
3910344 1993778 1993778 defendant Jamys Richard pulter 586424 586424 Jamys, Richard, of Hoddesdon, pulter 0
3941893 2004300 2004300 defendant Pery John, junior maltman 586424 586424 Pery, John, junior, of Hoddesdon, maltman 1
3967910 2013404 2013404 defendant Cannon John yeoman 586424 586424 Cannon, John, of Hoddesdon, or of Bengham, Herts, yeoman 0
3968126 2013477 2013477 plaintiff Carver John maltman 586424 586424 Carver, John, of Hoddesdon, maltman 0
3972078 2014793 2014793 defendant Cooke Henry shoemaker 586424 586424 Cooke, Henry, of Hoddesdon, shoemaker 1
4007764 2027561 2027561 plaintiff Mathew George innholder 586424 586424 Mathew, George, of Hoddesdon, innholder 0
4007795 2027570 2027570 plaintiff Mathewe George innholder 586424 586424 Mathewe, George, of Hoddesdon, innholder 0
4015608 2030280 2030280 plaintiff Smytheman Alexander (legal representative) 586424 586424 Smytheman, Alexander, of Hoddesdon, "loder", maltman, executor of 0
4028712 2034919 2034919 defendant Westwood John yeoman 586424 586424 Westwood, John, of Hoddesdon, yeoman 1
4035625 2037416 2037416 plaintiff Hollowey John weaver 586424 586424 Hollowey, John, of Hoddesdon, weaver 0
4040001 2038928 2038928 plaintiff Mathewe George innholder 586424 586424 Mathewe, George, of Hoddesdon, innholder 0
4044841 2040605 2040605 defendant Wyttam Richard yeoman or innholder 586424 586424 Wyttam, Richard, of Hoddesdon, yeoman or innholder 1
4232540 2106884 2106884 defendant Parnell William yeoman 586424 586424 Parnell, William, of Hoddesdon, yeoman 1
4250769 2113234 2113234 defendant Wytham John Herts, victualer 586424 586424 Wytham John, of Hoddesdon, Herts, victualer 0
4547911 2215282 2215282 defendant Loryng John   586424 586424 Loryng, John, of Hoddesdon 1
4548156 2215361 2215361 defendant atte Hill William   586424 586424 atte Hill, William, of Hoddesdon 0
4564477 2220455 2220455 defendant Aleyn John   586424 586424 Aleyn, John, of Hoddesdon 0
4564479 2220455 2220455 defendant Hentewode Robert   586424 586424 Hentewode, Robert, of Hoddesdon 2
4575328 2223796 2223796 plaintiff Boseham John   586424 586424 Boseham, John, of Hoddesdon 0
4586426 2227168 2227168 defendant Hothe John   586424 586424 Hothe, John, of Hoddesdon 1
4618029 2236649 2236649 defendant atte Thorne Robert   586424 586424 atte Thorne, Robert, of Hoddesdon 0
4627307 2239485 2239485 defendant West William   586424 586424 West, William, of Hoddesdon 0
4632310 2240992 2240992 plaintiff Tylere Richard   586424 586424 Tylere, Richard, of Hoddesdon 0
4734193 2275875 2275875 defendant Thorne Robert husbandman 586424 586424 Thorne, Robert, of Hoddesdon, husbandman 2
4739130 2277329 2277329 defendant Ley John tanner 586424 586424 Ley, John, of Hoddesdon, tanner 0
4756728 2282468 2282468 defendant Harpour John   586424 586424 Harpour, John, of Hoddesdon, "harpour" or harp player 0
4796840 2295167 2295167 defendant Hothe John husbandman 586424 586424 Hothe, John, of Hoddesdon, husbandman 3
4837580 2307687 2307687 plaintiff Freek Thomas (legal representative) 586424 586424 Freek, Thomas, of Hoddesdon, executors of 0
4851370 2311874 2311874 defendant Latber John maltman 586424 586424 Latber, John, of Hoddesdon, maltman 1
4866667 2316535 2316535 defendant Wolfrey William laborer 586424 586424 Wolfrey, William, of Hoddesdon, laborer 1
4867509 2316807 2316807 defendant Sharnebrook Robert husbandman 586424 586424 Sharnebrook, Robert, of Hoddesdon, husbandman 0
4886787 2322722 2322722 defendant Dethsale Thomas butcher 586424 586424 Dethsale, Thomas, of Hoddesdon, butcher 1
4898420 2326160 2326160 defendant Dedsale Thomas husbandman 586424 586424 Dedsale, Thomas, of Hoddesdon, husbandman 1
4902170 2327290 2327290 defendant Lord John butcher 586424 586424 Lord, John, of Hoddesdon, butcher 0
4914114 2330926 2330926 defendant Wakerell Thomas maltman 586424 586424 Wakerell, Thomas, of Hoddesdon, maltman 1
4923572 2333806 2333806 defendant Wakerell Thomas husbandman 586424 586424 Wakerell, Thomas, of Hoddesdon, husbandman 1
4928229 2335256 2335256 defendant Rogger William fuller 586424 586424 Rogger, William, of Hoddesdon, fuller 4
4954192 2343227 2343227 defendant Baker Thomas husbandman 586424 586424 Baker, Thomas, of Hoddesdon, husbandman 0
4962256 2345614 2345614 defendant Baker Thomas husbandman 586424 586424 Baker, Thomas, of Hoddesdon, husbandman 0
4976946 2350059 2350059 defendant Newerk William carpenter 586424 586424 Newerk, William, of Hoddesdon, carpenter 0
4978494 2350515 2350515 defendant Wakeryll Thomas maltman 586424 586424 Wakeryll, Thomas, of Hoddesdon, maltman 3
4979880 2350937 2350937 defendant Welefed Robert husbandman 586424 586424 Welefed, Robert, of Hoddesdon, husbandman 0
4980261 2351040 2351040 defendant Goldwell John husbandman 586424 586424 Goldwell, John, of Hoddesdon, husbandman 3
4980704 2351166 2351166 defendant Dedishale Thomas butcher 586424 586424 Dedishale, Thomas, of Hoddesdon, butcher 0
4980705 2351166 2351166 defendant Godfrey Geoffrey husbandman 586424 586424 Godfrey, Geoffrey, of Hoddesdon, husbandman 1
4980707 2351167 2351167 defendant Dedishale Thomas butcher 586424 586424 Dedishale, Thomas, of Hoddesdon, butcher 0
4980708 2351167 2351167 defendant Godfrey Geoffrey husbandman 586424 586424 Godfrey, Geoffrey, of Hoddesdon, husbandman 1
4995705 2355557 2355557 defendant Redisdale William summoner 586424 586424 Redisdale, William, of Hoddesdon, summoner 0
4997511 2356107 2356107 defendant Love John husbandman 586424 586424 Love, John, of Hoddesdon, husbandman 0
4997783 2356192 2356192 defendant Fygge John laborer 586424 586424 Fygge, John, of Hoddesdon, laborer 0
4997785 2356193 2356193 defendant Fygge William laborer 586424 586424 Fygge, William, of Hoddesdon, laborer 0
5001382 2357289 2357289 defendant Stacy Walter laborer 586424 586424 Stacy, Walter, of Hoddesdon, laborer 1
5014202 2361003 2361003 defendant Sonwhete Thomas husbandman 586424 586424 Sonwhete, Thomas, of Hoddesdon, husbandman 2
5028581 2365236 2365236 defendant Parker John husbandman 586424 586424 Parker, John, of Hoddesdon, husbandman 0
5034828 2367041 2367041 defendant Welfed Robert husbandman 586424 586424 Welfed, Robert, of Hoddesdon, husbandman 1
5052840 2372438 2372438 defendant Wakerell Thomas loader 586424 586424 Wakerell, Thomas, of Hoddesdon, loader 1
5052841 2372438 2372438 defendant Cryps John cordwainer 586424 586424 Cryps, John, of Hoddesdon, cordwainer 2
5070701 2377733 2377733 defendant Welyfed Robert ostler 586424 586424 Welyfed, Robert, of Hoddesdon, ostler 0
5070710 2377734 2377734 defendant Welyfed Robert ostler 586424 586424 Welyfed, Robert, of Hoddesdon, ostler 3
5073670 2378609 2378609 defendant Gylmyn John yeoman 586424 586424 Gylmyn, John, of Hoddesdon, yeoman 0
5085481 2382144 2382144 defendant Stacy Walter laborer 586424 586424 Stacy, Walter, of Hoddesdon, laborer 3
5091411 2383876 2383876 defendant Garrard John shoemaker 586424 586424 Garrard, John, of Hoddesdon, shoemaker 1
5099345 2386237 2386237 defendant Sutton William butcher 586424 586424 Sutton, William, of Hoddesdon, butcher 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);