names

91 rows where place_id = 587323

✎ 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
3591071 1864837 1864837 defendant Sygar Thomas clerk 587323 587323 Sygar, Thomas, of Glemesford, clerk 1
3593384 1865563 1865563 defendant Robert John, senior weaver 587323 587323 Robert, John, senior, of Glemesford, weaver 0
3593386 1865563 1865563 defendant Moryell Walter miller 587323 587323 Moryell, Walter, of Glemesford, miller 2
3832052 1967924 1967924 defendant Raynold Robert clothmaker 587323 587323 Raynold, Robert, of Glemesford, clothmaker 0
4110720 2064093 2064093 defendant Cooke William Suff, clothier 587323 587323 Cooke William, of Glemesford, Suff, clothier 0
4141145 2075063 2075063 defendant Higham George husbandman 587323 587323 Higham, George, of Glemesford, husbandman 0
4168164 2084351 2084351 defendant Hayward John yeoman 587323 587323 Hayward, John, of Glemesford, yeoman 0
4192155 2092820 2092820 defendant Browne Robert yeoman 587323 587323 Browne, Robert, of Glemesford, yeoman 0
4332500 2141158 2141158 defendant Barker Richard clothier 587323 587323 Barker, Richard, of Glemesford, clothier 0
4353484 2148443 2148443 defendant Hayward John yeoman 587323 587323 Hayward, John, of Glemesford, yeoman 0
4524228 2207913 2207913 plaintiff Hikkesson John fuller 587323 587323 Hikkesson, John, of Glemesford, fuller 0
4556669 2218018 2218018 defendant Slaghtere John   587323 587323 Slaghtere, John, of Glemesford 0
4587741 2227574 2227574 plaintiff Jakes Richard   587323 587323 Jakes, Richard, of Glemesford 0
4587799 2227588 2227588 plaintiff Janne John (legal representative) 587323 587323 Janne, John, of Glemesford, formerly parson, executors of 0
4587803 2227588 2227588 defendant Cobbe John, sen   587323 587323 Cobbe, John, sen, of Glemesford 0
4587804 2227589 2227589 plaintiff Janne John (legal representative) 587323 587323 Janne, John, of Glemesford, parson, executors of 0
4587808 2227589 2227589 defendant Cobbe John   587323 587323 Cobbe, John, of Glemesford 0
4593484 2229249 2229249 defendant Cobbe John   587323 587323 Cobbe, John, of Glemesford 0
4593485 2229249 2229249 defendant atte Medwe John   587323 587323 atte Medwe, John, of Glemesford 1
4593674 2229295 2229295 defendant Canston Robert   587323 587323 Canston, Robert, of Glemesford 0
4593679 2229296 2229296 defendant Wolleman Robert   587323 587323 Wolleman, Robert, of Glemesford 0
4593681 2229296 2229296 defendant Bryce William   587323 587323 Bryce, William, of Glemesford 2
4593684 2229296 2229296 defendant Cobbe John   587323 587323 Cobbe, John, of Glemesford 5
4601518 2231699 2231699 plaintiff Sywardeby John   587323 587323 Sywardeby, John, of Glemesford, parson 1
4601520 2231699 2231699 defendant Wolleman Robert   587323 587323 Wolleman, Robert, of Glemesford 1
4613905 2235363 2235363 defendant Slaghtere John   587323 587323 Slaghtere, John, of Glemesford 1
4661727 2249509 2249509 defendant atte Melle Stephen husbandman 587323 587323 atte Melle, Stephen, of Glemesford, husbandman 2
4667968 2255687 2255687 defendant Sewale Thomas parker 587323 587323 Sewale, Thomas, of Glemesford, parker 0
4667969 2255687 2255687 defendant Slaughtere John husbandman 587323 587323 Slaughtere, John, of Glemesford, husbandman 1
4681067 2259705 2259705 defendant atte Fen William   587323 587323 (atte Fen, William, of Glemesford 1
4681734 2259899 2259899 defendant Sewale Thomas yeoman 587323 587323 Sewale, Thomas, of Glemesford, yeoman 3
4738216 2277048 2277048 defendant Contell Geoffrey fuller 587323 587323 Contell, Geoffrey, of Glemesford, fuller 0
4738217 2277048 2277048 defendant Fen William fuller 587323 587323 Fen, William, of Glemesford, fuller 1
4741925 2278132 2278132 defendant Heche John yeoman 587323 587323 Heche, John, of Glemesford, yeoman 2
4763009 2284416 2284416 defendant atte Melle Stephen husbandman 587323 587323 atte Melle, Stephen, of Glemesford, husbandman 0
4899502 2326483 2326483 defendant Golle Richard clerk 587323 587323 Golle, Richard, of Glemesford, clerk 2
4937037 2337960 2337960 defendant Parker Robert mercer 587323 587323 Parker, Robert, of Glemesford, mercer 0
4937395 2338065 2338065 defendant Bolnyngton or Bolvyngton William dyer 587323 587323 Bolnyngton or Bolvyngton, William, of Glemesford, dyer 2
4952470 2342696 2342696 plaintiff Rote John   587323 587323 Rote, John, of Glemesford 0
4952471 2342696 2342696 defendant Croos John, junior   587323 587323 Croos, John, junior, of Glemesford husbandman 0
4955051 2343462 2343462 defendant Parker Robert mercer 587323 587323 Parker, Robert, of Glemesford, mercer 0
4955054 2343463 2343463 defendant Parker Robert mercer 587323 587323 Parker, Robert, of Glemesford, mercer 0
4957599 2344246 2344246 defendant Barker Thomas carpenter 587323 587323 Barker, Thomas, of Glemesford, carpenter 3
4997038 2355967 2355967 defendant Rote Robert weaver 587323 587323 Rote, Robert, of Glemesford, weaver 1
4997509 2356106 2356106 defendant Gardener John shoemaker 587323 587323 Gardener, John, of Glemesford, shoemaker 2
5067766 2376860 2376860 plaintiff Panell or Pauell William yeoman 587323 587323 Panell or Pauell, William, of Glemesford, yeoman 0
5087545 2382737 2382737 defendant Wode Richard yeoman 587323 587323 Wode, Richard, of Glemesford, yeoman 0
5101481 2386844 2386844 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, millwright 0
5101482 2386844 2386844 defendant Bumpsted John fuller 587323 587323 Bumpsted, John, of Glemesford, fuller 1
5104175 2387647 2387647 defendant Strutte Thomas smith 587323 587323 Strutte, Thomas, of Glemesford, smith 0
5110414 2389448 2389448 defendant Halle Robert butcher 587323 587323 Halle, Robert, of Glemesford, butcher 0
5119877 2392248 2392248 defendant Sturt Thomas smith 587323 587323 Sturt, Thomas, of Glemesford, smith 0
5122829 2393108 2393108 defendant Strut Thomas smith 587323 587323 Strut, Thomas, of Glemesford, smith 3
5126091 2394113 2394113 defendant Halle Robert butcher 587323 587323 Halle, Robert, of Glemesford, butcher 1
5127980 2394660 2394660 defendant Lane John brewer 587323 587323 Lane, John, of Glemesford, brewer 3
5127986 2394661 2394661 defendant Lane John brewer 587323 587323 Lane, John, of Glemesford, brewer 3
5137425 2397460 2397460 defendant Gims Thomas yeoman 587323 587323 Gims, Thomas, of Glemesford, yeoman 1
5138573 2397779 2397779 defendant Hall Robert butcher 587323 587323 Hall, Robert, of Glemesford, butcher 1
5138577 2397780 2397780 defendant Halle Robert   587323 587323 Halle, Robert, of Glemesford 1
5140305 2398268 2398268 defendant Crosse John, junior husbandman 587323 587323 Crosse, John, junior, of Glemesford, husbandman 0
5142588 2398961 2398961 plaintiff Wryghte Richard (legal representative) 587323 587323 Wryghte, Richard, of Glemesford, executors of 0
5142589 2398961 2398961 plaintiff Welyngham John   587323 587323 (Welyngham, John, of Glemesford 1
5144604 2399580 2399580 defendant Gwuse Thomas gent 587323 587323 Gwuse, Thomas, of Glemesford, gent 0
5144707 2399608 2399608 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, mill wright 2
5158078 2403485 2403485 defendant Guns Thomas yeoman 587323 587323 Guns, Thomas, of Glemesford, yeoman 1
5159326 2403843 2403843 defendant Halle Robert butcher 587323 587323 Halle, Robert, of Glemesford, butcher 1
5161413 2404436 2404436 defendant Crosse John husbandman 587323 587323 Crosse, John, of Glemesford, husbandman 0
5163938 2405191 2405191 plaintiff Welyngham John   587323 587323 (Welyngham, John, of Glemesford 1
5173786 2408029 2408029 defendant Guns Thomas yeoman 587323 587323 Guns, Thomas, of Glemesford, yeoman 0
5174509 2408245 2408245 defendant Halle Robert butcher 587323 587323 Halle, Robert, of Glemesford, butcher 1
5175804 2408607 2408607 defendant Crosse John husbandman 587323 587323 Crosse, John, of Glemesford, husbandman 0
5179517 2409743 2409743 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, mill wright 1
5182618 2410672 2410672 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, mill wright 3
5201928 2416330 2416330 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, mill wright 1
5203502 2416777 2416777 defendant Rokell John   587323 587323 Rokell, John, of Glemesford, mill wright 3
5227404 2423643 2423643 defendant Hall Robert butcher 587323 587323 Hall, Robert, of Glemesford, butcher 0
5231245 2424737 2424737 defendant Hall Robert butcher 587323 587323 Hall, Robert, of Glemesford, butcher 0
5243407 2428266 2428266 defendant Letton Ralph yeoman 587323 587323 Letton, Ralph, of Glemesford, yeoman 0
5259484 2433087 2433087 defendant Strutte Thomas smith 587323 587323 Strutte, Thomas, of Glemesford, smith 1
5315191 2449598 2449598 defendant Crosse William husbandman 587323 587323 Crosse, William, of Glemesford, husbandman 0
5318064 2450490 2450490 defendant Holden John (legal representative) 587323 587323 Holden, John, of Glemesford, millwright, executor of 0
5318065 2450490 2450490 defendant Rogull William clothmaker 587323 587323 Rogull, William, of Glemesford, clothmaker 1
5318067 2450490 2450490 defendant Merk John tailor 587323 587323 Merk, John, of Glemesford, tailor 3
5350678 2460324 2460324 defendant Crosse John, junior butcher 587323 587323 Crosse, John, junior, of Glemesford, butcher 0
5518557 2510635 2510635 defendant Hore Alexander chaplain 587323 587323 Hore, Alexander, of Glemesford, chaplain 0
5536924 2516037 2516037 defendant Hyllys William yeoman 587323 587323 Hyllys, William, of Glemesford, yeoman 1
5542070 2517650 2517650 defendant Sethyng Thomas chaplain 587323 587323 Sethyng, Thomas, of Glemesford, chaplain 0
5544870 2518502 2518502 plaintiff Sethyng Thomas clerk 587323 587323 Sethyng, Thomas, of Glemesford, clerk 0
5544871 2518502 2518502 defendant Lynsey William clerk 587323 587323 Lynsey, William, of Glemesford, clerk 0
5569099 2525514 2525514 plaintiff Goldynge John clothmaker 587323 587323 Goldynge, John, of Glemesford, clothmaker 0
5607896 2537374 2537374 defendant Marchall Nicholas clothmaker 587323 587323 Marchall, Nicholas, of Glemesford, clothmaker 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);