names

117 rows where place_id = 669776

✎ 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
3600239 1867722 1867722 defendant Clavell William baker 669776 669776 Clavell, William, of Langeport Estover, baker 0
3603542 1868777 1868777 defendant Archer John dyer 669776 669776 Archer, John, of Langeport Estover, dyer 0
3944535 2005189 2005189 defendant Blakehall William merchant 669776 669776 Blakehall, William, of Langeport, yeoman, or of Exeter, merchant 0
3976760 2016439 2016439 defendant Wyllyams alias Fyllypps Thomas butcher 669776 669776 Wyllyams alias Fyllypps, Thomas, of Langeport Estover, butcher 0
3994398 2022749 2022749 defendant Rede Thomas yeoman 669776 669776 Rede, Thomas, of Langeport, yeoman 1
4399613 2164458 2164458 defendant Salmon John yeoman 669776 669776 Salmon, John, of Langeport, yeoman 1
4399615 2164458 2164458 defendant Hancocke Samuel innholder 669776 669776 Hancocke, Samuel, of Langeport, innholder 3
4416759 2170109 2170109 defendant Claydone John chaplain 669776 669776 Claydone, John, of Langeport, chaplain 0
4425315 2172744 2172744 defendant Faxton Peter de   669776 669776 Faxton, Peter de, of Langeport 0
4426465 2173090 2173090 defendant Claydon John de chaplain 669776 669776 Claydon, John de, of Langeport, chaplain 0
4444035 2183104 2183104 plaintiff Chipstaple Richard   669776 669776 Chipstaple, Richard, of Langeport 0
4444037 2183104 2183104 defendant Deyghere John   669776 669776 Deyghere, John, of Langeport 1
4464342 2189515 2189515 plaintiff Warde Simon   669776 669776 Warde, Simon, of Langeport, on his own account 0
4504738 2202023 2202023 plaintiff Saweyer John   669776 669776 Saweyer, John, of Langeport 0
4504741 2202023 2202023 defendant Smyth Thomas   669776 669776 (Smyth, Thomas, of Langeport 2
4532405 2210402 2210402 defendant Bakere John, sen   669776 669776 Bakere, John, sen, of Langeport 0
4537088 2211870 2211870 defendant Harpetre Richard   669776 669776 Harpetre, Richard, of Langeport 0
4543666 2213914 2213914 defendant Croft Thomas   669776 669776 Croft, Thomas, of Langeport 3
4551123 2216294 2216294 defendant Greyve William   669776 669776 Greyve, William, of Langeport 0
4554408 2217309 2217309 plaintiff Grey William   669776 669776 Grey, William, of Langeport 0
4559904 2219052 2219052 defendant Baker Robert   669776 669776 Baker, Robert, of Langeport 0
4559906 2219052 2219052 defendant Brugge John   669776 669776 Brugge, John, of Langeport 2
4560091 2219098 2219098 plaintiff Mosse William   669776 669776 Mosse, William, of Langeport, parson 0
4567529 2221403 2221403 defendant Goldsmyth Edward (legal representative) 669776 669776 Goldsmyth, Edward, of Langeport, administrator of 1
4590733 2228455 2228455 defendant Ande John   669776 669776 Ande, John, of Langeport 1
4622630 2238056 2238056 defendant Taillour Richard   669776 669776 Taillour, Richard, of Langeport 0
4623423 2238299 2238299 defendant Cooke Thomas   669776 669776 Cooke, Thomas, of Langeport 0
4629178 2240058 2240058 defendant Sawyer Isabel   669776 669776 Sawyer, Isabel, of Langeport 1
4654778 2247374 2247374 plaintiff Boucher Thomas (legal representative) 669776 669776 Boucher, Thomas, of Langeport, executors of 0
4656243 2247845 2247845 defendant Goldsmyth John goldsmith 669776 669776 Goldsmyth, John, of Langeport, goldsmith 0
4672771 2257125 2257125 plaintiff Come John   669776 669776 Come, John, of Langeport 0
4674052 2257495 2257495 defendant Elys John butcher 669776 669776 Elys, John, of Langeport, butcher 2
4674053 2257495 2257495 defendant Glover Richard glover 669776 669776 Glover, Richard, of Langeport, glover 3
4674510 2257640 2257640 defendant Smyth John chapman 669776 669776 Smyth, John, of Langeport Estover, chapman 1
4676829 2258371 2258371 defendant Lyston John husbandman 669776 669776 Lyston, John, of Langeport, husbandman 0
4676831 2258372 2258372 defendant Bolley John husbandman 669776 669776 Bolley, John, of Langeport, husbandman 0
4676832 2258372 2258372 defendant Lyffet John husbandman 669776 669776 Lyffet, John, of Langeport, husbandman 1
4681754 2259904 2259904 plaintiff Heylys John   669776 669776 Heylys, John, of Langeport 1
4682667 2260194 2260194 defendant Becfeld John yeoman 669776 669776 Becfeld, John, of Langeport, yeoman 2
4686633 2261430 2261430 defendant Holton Richard dyer 669776 669776 Holton, Richard, of Langeport, dyer 0
4686639 2261432 2261432 defendant Halberton Matilda widow & formerly wife of Philip Halberton 669776 669776 Halberton, Matilda, of Langeport, widow & formerly wife of Philip Halberton 1
4688304 2261910 2261910 defendant Spark William tanner 669776 669776 Spark, William, of Langeport, tanner 0
4691609 2262904 2262904 defendant Goldsmyth John (legal representative) 669776 669776 Goldsmyth, John, of Langeport, executrix of 0
4692950 2263305 2263305 defendant Gryme John husbandman 669776 669776 Gryme, John, of Langeport, husbandman 0
4705587 2267116 2267116 defendant Brydeport Thomas husbandman 669776 669776 Brydeport, Thomas, of Langeport, husbandman 3
4711180 2268848 2268848 defendant Deyghe John butcher 669776 669776 Deyghe, John, of Langeport, butcher 2
4725594 2273291 2273291 defendant Plommer Richard dyer 669776 669776 Plommer, Richard, of Langeport, dyer 2
4732739 2275418 2275418 defendant Wilkyns John   669776 669776 Wilkyns, John, of Langeport, franklin 1
4745919 2279311 2279311 defendant Plomer Richard dyer 669776 669776 Plomer, Richard, of Langeport, dyer 0
4780177 2289799 2289799 defendant Pydell Thomas husbandman 669776 669776 Pydell, Thomas, of Langeport Estover, husbandman 0
4780178 2289799 2289799 defendant White Robert husbandman 669776 669776 White, Robert, of Langeport Estover, husbandman 1
4785871 2291613 2291613 defendant Plomer Richard dyer 669776 669776 Plomer, Richard, of Langeport, dyer 1
4789153 2292660 2292660 defendant Pydell Thomas husbandman 669776 669776 Pydell, Thomas, of Langeport Estover, husbandman 0
4812457 2300007 2300007 defendant Love Richard husbandman 669776 669776 Love, Richard, of Langeport, husbandman 0
4812458 2300007 2300007 defendant Aude John, junior   669776 669776 Aude, John, junior, of Langeport, axe burner or ash burner 1
4815831 2301054 2301054 defendant Baker John dyer 669776 669776 Baker, John, of Langeport, Westover, dyer 0
4820436 2302464 2302464 defendant Toth Edward husbandman 669776 669776 with Toth, Edward, of Langeport, husbandman 2
4824075 2303604 2303604 defendant Smyth Robert smith 669776 669776 Smyth, Robert, of Langeport Westover, smith 0
4855557 2313101 2313101 defendant Holton John stainer 669776 669776 Holton, John, of Langeport, stainer 1
4859060 2314214 2314214 defendant Wascombe Richard husbandman 669776 669776 together with Wascombe, Richard, of Langeport Estover, husbandman 2
4859061 2314214 2314214 defendant Wascombe John ostler 669776 669776 Wascombe, John, of Langeport Estover, ostler 3
4859062 2314214 2314214 defendant Attekyns John shoemaker 669776 669776 Attekyns, John, of Langeport Estover, shoemaker 4
4859066 2314215 2314215 defendant Wascombe John ostler 669776 669776 Wascombe, John, of Langeport Estover, ostler 0
4859067 2314215 2314215 defendant Attekyns John shoemaker 669776 669776 Attekyns, John, of Langeport Estover, shoemaker 1
4859070 2314216 2314216 defendant Wascombe Richard husbandman 669776 669776 Wascombe, Richard, of Langeport Estover, husbandman 0
4859072 2314216 2314216 defendant Baker John husbandman 669776 669776 Baker, John, of Langeport Estover, husbandman 2
4860076 2314521 2314521 defendant Baker John dyer 669776 669776 Baker, John, of Langeport, dyer 3
4870373 2317711 2317711 defendant Kay Roger husbandman 669776 669776 Kay, Roger, of Langeport, husbandman 0
4870374 2317711 2317711 defendant Carter John, senior husbandman 669776 669776 Carter, John, senior, of Langeport, husbandman 1
4870375 2317711 2317711 defendant Barry John husbandman 669776 669776 Barry, John, of Langeport, husbandman 2
4870376 2317711 2317711 defendant Lilly Richard husbandman 669776 669776 Lilly, Richard, of Langeport, husbandman 3
4870667 2317804 2317804 defendant Person Roger tanner 669776 669776 Person, Roger, of Langeport, tanner 1
4873222 2318576 2318576 defendant Westmore John mercer 669776 669776 Westmore, John, of Langeport, mercer 2
4882482 2321430 2321430 defendant Westemour John mercer 669776 669776 Westemour, John, of Langeport, mercer 1
4884856 2322161 2322161 defendant Peret John fisher 669776 669776 Peret, John, of Langeport, fisher 12
4908017 2329066 2329066 defendant Loo Ricihard husbandman 669776 669776 Loo, Ricihard, of Langeport, Estover, husbandman 1
4918199 2332212 2332212 defendant Westemour John mercer 669776 669776 Westemour, John, of langeport Estover, mercer 2
4918200 2332212 2332212 defendant Grey Henry butcher 669776 669776 Grey, Henry, of Langeport Estover, butcher 3
4925295 2334343 2334343 defendant Tournour Richard mercer 669776 669776 Tournour, Richard, of Langeport Estover, mercer 1
4934323 2337123 2337123 defendant Porter John butcher 669776 669776 Porter, John, of Langeport Estover, butcher 0
4949512 2341843 2341843 defendant Baker John dyer 669776 669776 Baker, John, of Langeport Estover, dyer 0
4949516 2341844 2341844 defendant Sampford John merchant 669776 669776 Sampford, John, of Langeport Estover, merchant 2
4952302 2342654 2342654 defendant Baker John dyer 669776 669776 Baker, John, of Langeport Estover, dyer 3
4953522 2343024 2343024 defendant Potter John butcher 669776 669776 Potter, John, of Langeport Estover, butcher 0
4960569 2345129 2345129 defendant Spryngod John tailor 669776 669776 Spryngod, John, of Langeport Estover, tailor 2
4962290 2345623 2345623 defendant Sloo John   669776 669776 Sloo, John, of Langeport Estover 0
4969529 2347834 2347834 plaintiff Grey Thomas   669776 669776 Grey, Thomas, of Langeport 0
4995715 2355558 2355558 defendant Taillour Nicholas   669776 669776 together with Taillour, Nicholas, of Langeport Estover 5
5017509 2362006 2362006 defendant Leve Richard husbandman 669776 669776 Leve, Richard, of Langeport Estover, husbandman 1
5021786 2363266 2363266 defendant Westmore John mercer 669776 669776 Westmore, John, of Langeport Estover, mercer 0
5032233 2366307 2366307 defendant Sampford John merchant 669776 669776 Sampford, John, of Langeport Estover, merchant 0
5032239 2366308 2366308 defendant San- John merchant 669776 669776 San-, John, of Langeport Estover, merchant 0
5051992 2372209 2372209 defendant Smyth Walter (legal representative) 669776 669776 Smyth, Walter, of Langeport Estover, smith, executors of 0
5139299 2397984 2397984 defendant Carter William weaver 669776 669776 Carter, William, of Langeport Estover, weaver 1
5152584 2401895 2401895 plaintiff Heyron John dyer 669776 669776 Heyron, John, of Langeport, dyer 0
5152586 2401896 2401896 plaintiff Heyron John dyer 669776 669776 Heyron, John, of Langeport, dyer 0
5170291 2407042 2407042 plaintiff Heyron John dyer 669776 669776 Heyron, John, of Langeport, dyer 0
5257533 2432476 2432476 defendant Rye Simon merchant 669776 669776 Rye, Simon, of Langeport Estover, merchant 1
5277566 2438515 2438515 defendant Traynsham Thomas dyer 669776 669776 Traynsham, Thomas, of Langeport Estover, dyer 0
5277568 2438515 2438515 defendant Sparke John tanner 669776 669776 Sparke, John, of Langeport Estover, tanner 2

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