names

168 rows where place_id = 587585

✎ 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
3591842 1865069 1865069 defendant Hardyng Richard husbandman 587585 587585 Hardyng, Richard, of Tenham, husbandman 0
3597861 1866951 1866951 defendant Norden William (legal representative) 587585 587585 Norden, William, of Tenham, executors of 0
3633659 1905337 1905337 defendant Kyrton John husbandman 587585 587585 Kyrton, John, of Tenham, husbandman 1
3636694 1906268 1906268 defendant Derton John yeoman 587585 587585 Derton, John, of Tenham, yeoman 0
3638872 1906980 1906980 defendant Roper Thomas husbandman 587585 587585 Roper, Thomas, of Tenham, husbandman 0
3638874 1906981 1906981 defendant Roper Thomas husbandman 587585 587585 Roper, Thomas, of Tenham, husbandman 0
3704413 1927677 1927677 defendant Roper Thomas husbandman 587585 587585 Roper, Thomas, of Tenham, husbandman 2
3725163 1934159 1934159 defendant Roper Thomas husbandman 587585 587585 Roper, Thomas, of Tenham, husbandman 0
3727347 1934827 1934827 defendant Meryall William carpenter 587585 587585 Meryall, William, of Tenham, carpenter 0
3741069 1939069 1939069 defendant Rooper Thomas husbandman 587585 587585 Rooper, Thomas, of Tenham, husbandman 0
3756492 1944004 1944004 defendant Goldsmyth William husbandman 587585 587585 Goldsmyth, William, of Tenham, husbandman 1
3776767 1950479 1950479 defendant Pye John (legal representative) 587585 587585 Pye, John, of Tenham, husbandman, executrix of 0
3776768 1950479 1950479 defendant Pye Ellen widow 587585 587585 Pye, Ellen, of Tenham, widow 1
3864878 1978454 1978454 defendant Goldsmyth William husbandman 587585 587585 Goldsmyth, William, of Tenham, husbandman 3
4125909 2069550 2069550 defendant Kenett Robert yeoman 587585 587585 Kenett, Robert, of Tenham, yeoman 1
4162049 2082284 2082284 defendant Harris William fruiterer 587585 587585 Harris, William, of Tenham, fruiterer 0
4165469 2083424 2083424 defendant Borne Henry husbandman 587585 587585 Borne, Henry, of Tenham, husbandman 3
4316764 2135980 2135980 defendant Harris William yeoman 587585 587585 Harris, William, of Tenham, yeoman 1
4321336 2137554 2137554 defendant Cooke William husbandman 587585 587585 Cooke, William, of Tenham, husbandman 0
4364593 2152394 2152394 defendant Bourne Stephen yeoman 587585 587585 Bourne, Stephen, of Tenham, yeoman 0
4371286 2154794 2154794 defendant Harris William yeoman 587585 587585 Harris, William, of Tenham, yeoman 0
4391457 2161760 2161760 defendant Bourne Stephen yeoman 587585 587585 Bourne, Stephen, of Tenham, yeoman 0
4486137 2196365 2196365 defendant Kno--- Michael   587585 587585 Kno---, Michael, of Tenham 0
4500426 2200752 2200752 defendant Seman Joan   587585 587585 Seman, Joan, of Tenham 1
4501277 2201004 2201004 defendant Amys John   587585 587585 Amys, John, of Tenham 0
4524726 2208073 2208073 plaintiff Houchoun John   587585 587585 Houchoun, John, of Tenham 0
4556252 2217896 2217896 plaintiff Houchon Henry   587585 587585 Houchon, Henry, of Tenham 0
4557243 2218199 2218199 plaintiff Knouth Michael   587585 587585 Knouth, Michael, of Tenham 0
4557246 2218199 2218199 defendant Herde John   587585 587585 Herde, John, of Tenham 2
4560555 2219240 2219240 defendant Clement John   587585 587585 Clement, John, of Tenham 0
4560558 2219241 2219241 plaintiff Noke Richard   587585 587585 Noke, Richard, of Tenham 0
4570369 2222307 2222307 defendant Seman John   587585 587585 Seman, John, of Tenham 0
4570370 2222307 2222307 defendant Forstall John   587585 587585 Forstall, John, of Tenham 1
4582325 2225914 2225914 defendant Herde John   587585 587585 Herde, John, of Tenham 0
4588526 2227781 2227781 plaintiff Knouth Michael   587585 587585 Knouth, Michael, of Tenham, administrators of 0
4595218 2229753 2229753 defendant Tomas John   587585 587585 Tomas, John, of Tenham 2
4597859 2230586 2230586 defendant Forstall John, sen   587585 587585 Forstall, John, sen, of Tenham 1
4610408 2234332 2234332 plaintiff Carpenter John   587585 587585 Carpenter, John, of Tenham 0
4616471 2236146 2236146 defendant Clopton John   587585 587585 Clopton, John, of Tenham 2
4651619 2246500 2246500 defendant Knouth Richard husbandman 587585 587585 Knouth, Richard, of Tenham, husbandman 1
4666198 2250900 2250900 defendant Bakere William husbandman 587585 587585 Bakere, William, of Tenham, husbandman 0
4671725 2256802 2256802 defendant Roper John husbandman 587585 587585 Roper, John, of Tenham, husbandman 1
4699723 2265356 2265356 defendant Seman William husbandman 587585 587585 Seman, William, of Tenham, husbandman 0
4699724 2265356 2265356 defendant Seman Richard   587585 587585 Seman, Richard, of Tenham 1
4702276 2266121 2266121 defendant Seman John laborer 587585 587585 Seman, John, of Tenham, laborer 0
4717400 2270781 2270781 defendant Roberd John laborer 587585 587585 Roberd, John, of Tenham, laborer 3
4717401 2270781 2270781 defendant Parker Simon laborer 587585 587585 Parker, Simon, of Tenham, laborer 4
4721123 2271941 2271941 defendant Gode John weaver 587585 587585 Gode, John, of Tenham, weaver 0
4727361 2273805 2273805 defendant Wodecok Michael shipman 587585 587585 Wodecok, Michael, of Tenham, shipman 0
4738130 2277026 2277026 defendant Robard John husbandman 587585 587585 Robard, John, of Tenham, husbandman 0
4738131 2277026 2277026 defendant Parker Simon husbandman 587585 587585 Parker, Simon, of Tenham, husbandman 1
4738133 2277026 2277026 defendant Bryan Robert husbandman 587585 587585 Bryan, Robert, of Tenham, husbandman 3
4745209 2279105 2279105 plaintiff Frogenhale John esq 587585 587585 Frogenhale, John, of Tenham, esq 0
4752521 2281195 2281195 defendant Seman John husbandman 587585 587585 Seman, John, of Tenham, husbandman 4
4758613 2283075 2283075 defendant Worston John gent 587585 587585 Worston, John, of Tenham, gent 0
4762660 2284302 2284302 defendant Fort Thomas laborer 587585 587585 Fort, Thomas, of Tenham, laborer 0
4791911 2293573 2293573 defendant Bryan Robert smith 587585 587585 Bryan, Robert, of Tenham, smith 0
4800004 2296184 2296184 defendant Seman William husbandman 587585 587585 Seman, William, of Tenham, husbandman 2
4840907 2308692 2308692 defendant Warde John laborer 587585 587585 Warde, John, of Tenham, laborer 0
4845931 2310234 2310234 defendant Doder Walter husbandman 587585 587585 Doder, Walter, of Tenham, husbandman 0
4857863 2313825 2313825 defendant Benette William butcher 587585 587585 Benette, William, of Tenham, butcher 0
4859953 2314480 2314480 defendant Dodyr Walter husbandman 587585 587585 Dodyr, Walter, of Tenham, husbandman 2
4908048 2329075 2329075 defendant Doder Walter husbandman 587585 587585 Doder, Walter, of Tenham, husbandman 0
4911140 2329997 2329997 defendant Knewethe Henry yeoman 587585 587585 Knewethe, Henry, of Tenham, yeoman 2
4911884 2330220 2330220 defendant Eytherst or Gytherst William husbandman 587585 587585 Eytherst or Gytherst, William, of Tenham, husbandman 0
4935476 2337492 2337492 defendant Doder Walter yeoman 587585 587585 Doder, Walter, of Tenham, yeoman 0
4936713 2337864 2337864 defendant Knouth Henry   587585 587585 Knouth, Henry, of Tenham 2
4937896 2338233 2338233 plaintiff Canon William   587585 587585 Canon, William, of Tenham 0
4939160 2338634 2338634 defendant Canon William shipman 587585 587585 Canon, William, of Tenham, shipman 1
4941335 2339316 2339316 defendant Colbroke William laborer 587585 587585 Colbroke, William, of Tenham, laborer 0
4949791 2341925 2341925 plaintiff Northwode John   587585 587585 Northwode, John, of Tenham 0
4956402 2343878 2343878 defendant Knowth Henry husbandman 587585 587585 Knowth, Henry, of Tenham, husbandman 0
4956403 2343878 2343878 defendant Doder Walter husbandman 587585 587585 Doder, Walter, of Tenham, husbandman 1
4960874 2345215 2345215 defendant Dodder Walter yeoman 587585 587585 Dodder, Walter, of Tenham, yeoman 1
4964589 2346315 2346315 defendant Benet William butcher 587585 587585 Benet, William, of Tenham, butcher 0
5000951 2357158 2357158 defendant Northwode John husbandman 587585 587585 Northwode, John, of Tenham, husbandman 0
5000952 2357158 2357158 defendant Northwode Michael husbandman 587585 587585 Northwode, Michael, of Tenham, husbandman 1
5027499 2364921 2364921 defendant Conon William shipman 587585 587585 Conon, William, of Tenham, shipman 0
5041132 2368967 2368967 defendant Nenclyf John yeoman 587585 587585 Nenclyf, John, of Tenham, yeoman 1
5041133 2368967 2368967 defendant atte Welle William yeoman 587585 587585 atte Welle, William, of Tenham, yeoman 2
5041134 2368967 2368967 defendant Northwode Michael yeoman 587585 587585 Northwode, Michael, of Tenham, yeoman 3
5046240 2370505 2370505 defendant Canon William shipman 587585 587585 Canon, William, of Tenham, shipman 1
5058153 2373999 2373999 defendant Nordon William husbandman 587585 587585 Nordon, William, of Tenham, husbandman 1
5058154 2373999 2373999 defendant Bocher John husbandman 587585 587585 Bocher, John, of Tenham, husbandman 2
5058155 2373999 2373999 defendant Met Henry husbandman 587585 587585 Met, Henry, of Tenham, husbandman 3
5058156 2373999 2373999 defendant Hardyng William laborer 587585 587585 Hardyng, William, of Tenham, laborer 4
5081423 2380948 2380948 defendant Kyng John husbandman 587585 587585 Kyng, John, of Tenham, husbandman 0
5083301 2381507 2381507 plaintiff Eytherst John   587585 587585 Eytherst, John, of Tenham 0
5084098 2381746 2381746 plaintiff Frend John   587585 587585 Frend, John, of Tenham 0
5109109 2389088 2389088 plaintiff Frend John   587585 587585 Frend, John, of Tenham 0
5109158 2389101 2389101 defendant Starlyng William husbandman 587585 587585 Starlyng, William, of Tenham, husbandman 0
5117044 2391410 2391410 defendant Sterlyng William husbandman 587585 587585 Sterlyng, William, of Tenham, husbandman 1
5127953 2394654 2394654 plaintiff Chapman (illegible)   587585 587585 Chapman, ---, of Tenham, vicar 0
5127955 2394654 2394654 defendant Mette Henry husbandman 587585 587585 Mette, Henry, of Tenham, husbandman 1
5127956 2394654 2394654 defendant Vynour Thomas husbandman 587585 587585 Vynour, Thomas, of Tenham, husbandman 2
5131061 2395571 2395571 plaintiff Frend John   587585 587585 Frend, John, of Tenham 0
5145715 2399889 2399889 defendant Venour Thomas husbandman 587585 587585 Venour, Thomas, of Tenham, husbandman 4
5147024 2400269 2400269 plaintiff Chapman John   587585 587585 Chapman, John, of Tenham, vicar 0
5147027 2400269 2400269 defendant Smythyet Thomas husbandman 587585 587585 Smythyet, Thomas, of Tenham, husbandman 2
5150568 2401308 2401308 plaintiff Frende John   587585 587585 Frende, John, of Tenham 0

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