names

89 rows where place_id = 586945

✎ 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
3590049 1864527 1864527 defendant Forth John innholder 586945 586945 Forth, John, of Hoddesdon, Herts, innholder 1
3590051 1864528 1864528 defendant Forthe John innholder 586945 586945 Forthe, John, of Hoddesdon, Herts, innholder 0
3598972 1867308 1867308 defendant Palwell John yeoman 586945 586945 Palwell, John, of Hoddesdon, Herts, yeoman 0
3607465 1869994 1869994 defendant Borell Robert husbandman 586945 586945 Borell, Robert, of Hoddesdon, Herts, husbandman 0
3617245 1873017 1873017 defendant Wulmer John innholder 586945 586945 Wulmer, John, of Hoddesdon, Herts, innholder 1
3630115 1904267 1904267 defendant Hynde John dyer 586945 586945 Hynde, John, of Hoddesdon, Herts, dyer 1
3656400 1912247 1912247 defendant Abbot William   586945 586945 Abbot, William, of Hoddesdon, Herts, inn holdler 1
3659797 1913317 1913317 defendant Smyth William   586945 586945 Smyth, William, of Hoddesdon, Herts, inn holder 0
3660850 1913661 1913661 defendant Smyth William   586945 586945 Smyth, William, of Hoddesdon, Herts, inn holder 1
3662680 1914246 1914246 defendant Haver Robert botcher 586945 586945 Haver, Robert, of Hoddesdon, Herts, botcher 3
3665061 1915020 1915020 defendant Abbot Thomas   586945 586945 Abbot, Thomas, of Hoddesdon, Herts, shoe maker 0
3670501 1916736 1916736 defendant Hegger Thomas innholder 586945 586945 Hegger, Thomas, of Hoddesdon, Herts, innholder 0
3675625 1918412 1918412 defendant Bocher alias Abbot Thomas husbandman 586945 586945 Bocher alias Abbot, Thomas, of Hoddesdon, Herts, husbandman 1
3694119 1924365 1924365 defendant Hill Richard yeoman 586945 586945 Hill, Richard, of Hoddesdon, Herts, yeoman 1
3694123 1924366 1924366 defendant Hyll Richard yeoman 586945 586945 Hyll, Richard, of Hoddesdon, Herts, yeoman 1
3696913 1925255 1925255 defendant Slyte Richard chapman 586945 586945 Slyte, Richard, of Hoddesdon, Herts, chapman 0
3696917 1925256 1925256 defendant Slyte Richard chapman 586945 586945 Slyte, Richard, of Hoddesdon, Herts, chapman 0
3701389 1926681 1926681 defendant Rombold Robert yeoman 586945 586945 Rombold, Robert, of Hoddesdon, Herts, yeoman 0
3708110 1928834 1928834 defendant Hyll Richard yeoman 586945 586945 Hyll, Richard, of Hoddesdon, Herts, yeoman 3
3710859 1929715 1929715 defendant Robson George yeoman 586945 586945 Robson, George, of Hoddesdon, Herts, yeoman 0
3798131 1957311 1957311 defendant Cock John husbandman 586945 586945 Cock, John, of Hoddesdon, Herts, husbandman 0
3798253 1957350 1957350 defendant Asplond Richard   586945 586945 Asplond, Richard, of Hoddesdon, Herts, horse courser 2
3944629 2005219 2005219 defendant Borram William weaver 586945 586945 Borram, William, of Hoddesdon, Herts, weaver 0
3949397 2006860 2006860 defendant Fuller Thomas yeoman 586945 586945 Fuller, Thomas, of Hoddesdon, Herts, yeoman 0
3969756 2014029 2014029 defendant Fuller Thomas yeoman 586945 586945 Fuller, Thomas, of Hoddesdon, Herts, yeoman 0
3972077 2014793 2014793 defendant Tyover John innholder 586945 586945 Tyover, John, of Hoddesdon, Herts, innholder 0
3983395 2018836 2018836 defendant Fuller Thomas yeoman 586945 586945 Fuller, Thomas, of Hoddesdon, Herts, yeoman 0
4015611 2030281 2030281 plaintiff Smytheman Alexander (legal representative) 586945 586945 Smytheman, Alexander, of Hoddesdon, Herts, maltman, executor of 0
4028711 2034919 2034919 defendant Bennett Thomas draper 586945 586945 Bennett, Thomas, of Hoddesdon, Herts, draper 0
4040002 2038928 2038928 defendant Fuller Thomas yeoman 586945 586945 Fuller, Thomas, of Hoddesdon, Herts, yeoman 0
4078844 2052731 2052731 defendant Bennett Thomas draper 586945 586945 Bennett, Thomas, of Hoddesdon, Herts, draper 1
4079593 2053000 2053000 defendant Butler Thomas maltman 586945 586945 Butler, Thomas, of Hoddesdon, Herts, maltman 0
4086820 2055578 2055578 defendant Wyttam Richard yeoman 586945 586945 Wyttam, Richard, of Hoddesdon, Herts, yeoman 0
4161386 2082062 2082062 defendant Fuller John gent 586945 586945 Fuller, John, of Hoddesdon, Herts, gent 0
4197769 2094774 2094774 defendant Warde George yeoman 586945 586945 Warde, George, of Hoddesdon, Herts, yeoman 0
4200131 2095599 2095599 defendant Whittam Richard (legal representative) 586945 586945 Whittam, Richard, of Hoddesdon, Herts, innholder, administratrix of 0
4204142 2097002 2097002 defendant Bennett Thomas chapman 586945 586945 Bennett, Thomas, of Hoddesdon, Herts, chapman 0
4250773 2113236 2113236 defendant Southwell Robert victualer 586945 586945 Southwell, Robert, of Hoddesdon, Herts, victualer 0
4692442 2263154 2263154 defendant Dalton Richard yeoman 586945 586945 Dalton, Richard, of Hoddesdon, Herts, yeoman 2
4700069 2265444 2265444 defendant Deer William maltman 586945 586945 Deer, William, of Hoddesdon, Herts, maltman 0
4762974 2284403 2284403 defendant Skynner John husbandman & farmer of the manor 586945 586945 Skynner, John, of Hoddesdon, Herts, husbandman & farmer of the manor 0
4762979 2284405 2284405 defendant Skynner John farmer & husbandman 586945 586945 Skynner, John, of Hoddesdon, Herts, farmer & husbandman 0
4866666 2316535 2316535 defendant Stonesdale Thomas barber 586945 586945 Stonesdale, Thomas, of Hoddesdon, Herts, barber 0
4979490 2350822 2350822 defendant Percy John husbandman 586945 586945 Percy, John, of Hoddesdon, Herts, husbandman 3
4982825 2351777 2351777 defendant Latther John pulter 586945 586945 Latther, John, of Hoddesdon, Herts, pulter 1
4982831 2351778 2351778 defendant Latther John pulter 586945 586945 Latther, John, of Hoddesdon, Herts, pulter 1
5005892 2358625 2358625 defendant Skelton John   586945 586945 Skelton, John, of Hoddesdon, Herts, arrow maker 1
5014201 2361003 2361003 defendant Welyfedde Robert husbandman 586945 586945 Welyfedde, Robert, of Hoddesdon, Herts, husbandman 1
5032341 2366338 2366338 defendant Skelton John fletcher 586945 586945 Skelton, John, of Hoddesdon, Herts, fletcher 1
5032345 2366339 2366339 defendant Skelton John fletcher 586945 586945 Skelton, John, of Hoddesdon, Herts, fletcher 1
5084690 2381935 2381935 defendant Hyntwode John husbandman 586945 586945 Hyntwode, John, of Hoddesdon, Herts, husbandman 0
5084692 2381936 2381936 defendant Hyntwode John husbandman 586945 586945 Hyntwode, John, of Hoddesdon, Herts, husbandman 0
5096589 2385436 2385436 defendant Welefed Robert husbandman 586945 586945 Welefed, Robert, of Hoddesdon, Herts, husbandman 0
5099120 2386169 2386169 defendant Welyfed Robert husbandman 586945 586945 Welyfed, Robert, of Hoddesdon, Herts, husbandman 5
5164226 2405274 2405274 defendant Welyfed Robert hosteler 586945 586945 Welyfed, Robert, of Hoddesdon, Herts, hosteler 1
5200702 2415960 2415960 defendant Welyfed Robert hosteller 586945 586945 Welyfed, Robert, of Hoddesdon, Herts, hosteller 1
5212704 2419465 2419465 defendant Sturdy John maltman 586945 586945 Sturdy, John, of Hoddesdon, Herts, maltman 1
5245560 2428860 2428860 defendant Huet Thomas laborer 586945 586945 Huet, Thomas, of Hoddesdon, Herts, laborer 4
5245569 2428861 2428861 defendant Huet Thomas laborer 586945 586945 Huet, Thomas, of Hoddesdon, Herts, laborer 4
5259607 2433123 2433123 defendant Baker Lawrence chapman 586945 586945 Baker, Lawrence, of Hoddesdon, Herts, chapman 1
5261132 2433593 2433593 defendant Bekke Thomas maltman 586945 586945 Bekke, Thomas, of Hoddesdon, Herts, maltman 2
5267405 2435570 2435570 defendant Baker Richard cooper 586945 586945 Baker, Richard, of Hoddesdon, Herts, cooper 0
5300680 2445168 2445168 defendant Frank John tanner 586945 586945 Frank, John, of Hoddesdon, Herts, tanner 0
5300685 2445169 2445169 defendant Frank John tanner 586945 586945 Frank, John, of Hoddesdon, Herts, tanner 0
5301783 2445489 2445489 defendant Frank John tanner 586945 586945 Frank, John, of Hoddesdon, Herts, tanner 3
5306448 2446917 2446917 defendant Herde Nicholas husbandman 586945 586945 Herde, Nicholas, of Hoddesdon, Herts, husbandman 0
5334139 2455275 2455275 defendant Hynde George yeoman 586945 586945 Hynde, George, of Hoddesdon, Herts, yeoman 0
5339532 2456935 2456935 defendant Long Richard husbandman 586945 586945 Long, Richard, of Hoddesdon, Herts, husbandman 2
5350696 2460328 2460328 defendant Thomson John yeoman 586945 586945 Thomson, John, of Hoddesdon, Herts, yeoman 2
5356673 2462157 2462157 defendant Godfrey Henry smith 586945 586945 Godfrey, Henry, of Hoddesdon, Herts, smith 3
5358999 2462863 2462863 defendant Parker Richard tanner 586945 586945 Parker, Richard, of Hoddesdon, Herts, tanner 1
5392286 2472883 2472883 defendant Burgh Richard   586945 586945 Burgh, Richard, of Hoddesdon, Herts 2
5397277 2474305 2474305 defendant Parker Richard tanner 586945 586945 Parker, Richard, of Hoddesdon, Herts, tanner 2
5405537 2476661 2476661 defendant Sutton William mercer 586945 586945 Sutton, William, of Hoddesdon, Herts, mercer 2
5410511 2478088 2478088 defendant Parker Richard tanner 586945 586945 Parker, Richard, of Hoddesdon, Herts, tanner 2
5418409 2480434 2480434 defendant Burgh Richard clerk 586945 586945 Burgh, Richard, of Hoddesdon, Herts, clerk 1
5418602 2480488 2480488 defendant Sutton William husbandman 586945 586945 Sutton, William, of Hoddesdon, Herts, husbandman 2
5420906 2481181 2481181 defendant Tomson John yeoman 586945 586945 Tomson, John, of Hoddesdon, Herts, yeoman 2
5424399 2482262 2482262 defendant Parker Richard tanner 586945 586945 Parker, Richard, of Hoddesdon, Herts, tanner 1
5440041 2486922 2486922 defendant Thomson John yeoman 586945 586945 Thomson, John, of Hoddesdon, Herts, yeoman 2
5456356 2491821 2491821 defendant Kyrkeby Robert yeoman 586945 586945 Kyrkeby, Robert, of Hoddesdon, Herts, yeoman 0
5468189 2495429 2495429 defendant Kyrkeby Robert yeoman 586945 586945 Kyrkeby, Robert, of Hoddesdon, Herts, yeoman 0
5468206 2495431 2495431 defendant Kyrkeby Robert yeoman 586945 586945 Kyrkeby, Robert, of Hoddesdon, Herts, yeoman 0
5476735 2498042 2498042 defendant Abbot John innholder 586945 586945 Abbot, John, of Hoddesdon, Herts, innholder 0
5479376 2498849 2498849 defendant Kyrkeby Robert yeoman 586945 586945 Kyrkeby, Robert, of Hoddesdon, Herts, yeoman 0
5493551 2502984 2502984 defendant Werall William yeoman 586945 586945 Werall, William, of Hoddesdon, Herts, yeoman 3
5525269 2512495 2512495 defendant Wete Robert husbandman 586945 586945 Wete, Robert, of Hoddesdon, Herts, husbandman 0
5528408 2513421 2513421 defendant Skarlet John gent 586945 586945 Skarlet, John, of Hoddesdon, Herts, gent 7
5550775 2520257 2520257 defendant Johnson Hugh husbandman 586945 586945 Johnson, Hugh, of Hoddesdon, Herts, husbandman 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);