names

133 rows where place_id = 587118

✎ 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
3590515 1864676 1864676 defendant Eryll of Gryll William baker 587118 587118 Eryll of Gryll, William, of Exilond, baker 5
3605105 1869262 1869262 defendant Dyer Thomas husbandman 587118 587118 Dyer, Thomas, of Exilond, husbandman 0
3605106 1869262 1869262 defendant Trebowe John dyer 587118 587118 Trebowe, John, of Exilond, dyer 1
3607299 1869943 1869943 defendant Roo William dyer 587118 587118 Roo, William, of Exilond, dyer 2
3609545 1870648 1870648 defendant Hamond William dyer 587118 587118 Hamond, William, of Exilond, dyer 0
3610068 1870816 1870816 defendant Mershe William weaver 587118 587118 Mershe, William, of Exilond, weaver 1
3822608 1964976 1964976 defendant Baylly Henry dyer 587118 587118 Baylly, Henry, of Exilond, dyer 3
3822609 1964976 1964976 defendant Valence John dyer 587118 587118 Valence, John, of Exilond, dyer 4
3824899 1965666 1965666 defendant Ulfloe William tanner 587118 587118 Ulfloe, William, of Exilond, tanner 13
3924350 1998453 1998453 defendant Preston Thomas husbandman 587118 587118 Preston, Thomas, of Exilond, husbandman 0
3995793 2023244 2023244 defendant Shere John miller 587118 587118 Shere, John, of Exilond, miller 0
4443272 2182856 2182856 plaintiff Carpenter Henry   587118 587118 Carpenter, Henry, of Exilond 0
4658264 2248465 2248465 defendant Watte Richard dyer 587118 587118 Watte, Richard, of Exilond, dyer 0
4675510 2257952 2257952 defendant Blondon Simon merchant 587118 587118 Blondon, Simon, of Exilond, merchant 0
4677115 2258460 2258460 plaintiff Hakeworthy Roger   587118 587118 Hakeworthy, Roger, of Exilond, on his own account 0
4677119 2258461 2258461 plaintiff Hakeworthy Roger   587118 587118 Hakeworthy, Roger, of Exilond, on his own account 0
4677869 2258693 2258693 defendant Jones-servant Rawelyn Thomas laborer 587118 587118 Jones-servant Rawelyn, Thomas, of Exilond, laborer 0
4677874 2258693 2258693 defendant Smyth Thomas tanner 587118 587118 with Smyth, Thomas, of Exilond, tanner 5
4679648 2259251 2259251 defendant Potter John dyer 587118 587118 Potter, John, of Exilond, dyer 2
4679649 2259251 2259251 defendant Kyngesford Thomas dyer 587118 587118 Kyngesford, Thomas, of Exilond, dyer 3
4679977 2259341 2259341 defendant Potter Richard dyer 587118 587118 Potter, Richard, of Exilond, dyer 0
4686598 2261419 2261419 plaintiff Smyth Thomas (legal representative) 587118 587118 Smyth, Thomas, of Exilond, executors of 0
4691858 2262988 2262988 defendant Covent Baldwin baker 587118 587118 Covent, Baldwin, of Exilond, baker 0
4705270 2267019 2267019 defendant Potter John dyer 587118 587118 Potter, John, of Exilond, dyer 0
4757081 2282584 2282584 defendant Lane John dyer 587118 587118 Lane, John, of Exilond, dyer 1
4764477 2284873 2284873 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond, dyer 0
4767820 2285909 2285909 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond, dyer 0
4768648 2286174 2286174 defendant Wonston Alfred forester 587118 587118 Wonston, Alfred, of Exilond, forester 0
4779026 2289417 2289417 defendant Lane John dyer 587118 587118 Lane, John, of Exilond, dyer 0
4779028 2289418 2289418 defendant Lane John dyer 587118 587118 Lane, John, of Exilond, dyer 0
4788343 2292424 2292424 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond, dyer 0
4792214 2293654 2293654 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond, dyer 0
4794644 2294465 2294465 defendant Braas John baker 587118 587118 Braas, John, of Exilond, baker 2
4796375 2295016 2295016 defendant Clere John dyer 587118 587118 Clere, John, of Exilond, dyer 0
4822521 2303117 2303117 defendant Pellowe John dyer 587118 587118 Pellowe, John, of Exilond, dyer 0
4827485 2304645 2304645 defendant Pellowe John dyer 587118 587118 Pellowe, John, of Exilond, dyer 1
4830675 2305618 2305618 defendant Clere John dyer 587118 587118 Clere, John, of Exilond, dyer 0
4836656 2307438 2307438 defendant Carpenter John tanner 587118 587118 Carpenter, John, of Exilond, tanner 1
4836657 2307438 2307438 defendant Boryngton Richard tanner 587118 587118 Boryngton, Richard, of Exilond, tanner 2
4836661 2307438 2307438 defendant Ellis servant of John Okenowe laborer 587118 587118 Ellis, servant of John Okenowe, of Exilond, laborer 6
4841732 2308952 2308952 defendant Pellow John dyer 587118 587118 Pellow, John, of Exilond, dyer 1
4848061 2310860 2310860 defendant Clere John dyer 587118 587118 Clere, John, of Exilond, dyer 0
4857297 2313671 2313671 defendant Stephyn alias Dyer John merchant 587118 587118 Stephyn alias Dyer, John, of Exilond juxta Exeter, merchant 0
4863371 2315512 2315512 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond juxta Exeter, dyer 0
4863374 2315513 2315513 defendant Dyer Reginald dyer 587118 587118 Dyer, Reginald, of Exilond juxta Exeter, dyer 0
4926607 2334740 2334740 defendant Pelle John dyer 587118 587118 Pelle, John, of Exilond, dyer 0
4926609 2334741 2334741 defendant Kekelton John dyer 587118 587118 Kekelton, John, of Exilond, dyer 0
4934005 2337015 2337015 defendant Bette John dyer 587118 587118 together with Bette, John, of Exilond, dyer 1
4934539 2337196 2337196 defendant Clere John dyer 587118 587118 Clere, John, of Exilond, dyer 4
4954700 2343360 2343360 defendant Mathu Hugh merchant 587118 587118 Mathu, Hugh, of Exilond, merchant 0
4959223 2344726 2344726 defendant Bette john dyer 587118 587118 together with Bette, john, of Exilond, dyer 1
4971014 2348271 2348271 defendant Lamsede John merchant 587118 587118 Lamsede, John, of Exilond, merchant 0
4982694 2351736 2351736 defendant Hore Robert dyer 587118 587118 (Hore, Robert, of Exilond, dyer 3
4984138 2352188 2352188 defendant Bette John dyer 587118 587118 Bette, John, of Exilond, dyer 0
5014434 2361086 2361086 defendant Lammeshede John tailor 587118 587118 Lammeshede, John, of Exilond, tailor 1
5031889 2366199 2366199 defendant Combe John tanner 587118 587118 Combe, John, of Exilond, tanner 1
5041730 2369128 2369128 defendant Wodewale Gregory dyer 587118 587118 Wodewale, Gregory, of Exilond, dyer 0
5042133 2369255 2369255 defendant Lammyshede John husbandman 587118 587118 Lammyshede, John, of Exilond, husbandman 0
5057454 2373797 2373797 defendant Hakeworthy John merchant 587118 587118 Hakeworthy, John, of Exilond, merchant 0
5065478 2376207 2376207 defendant Mathewe Hugh merchant 587118 587118 Mathewe, Hugh, of Exilond, merchant 2
5068882 2377191 2377191 defendant Botte William merchant 587118 587118 Botte, William, of Exilond juxta Exeter, merchant 0
5125001 2393788 2393788 defendant Hakeworthy John   587118 587118 Hakeworthy, John, of Exilond, franklin 0
5125002 2393788 2393788 defendant butte William merchant 587118 587118 butte, William, of Exilond, merchant 1
5126575 2394248 2394248 defendant atte Marsshe Alexander husbandman 587118 587118 atte Marsshe, Alexander, of Exilond, husbandman 0
5129349 2395072 2395072 defendant Butte (illegible) merchant 587118 587118 Butte, ---, of Exilond, merchant 0
5130104 2395292 2395292 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5134561 2396601 2396601 defendant Combe Richard dyer 587118 587118 Combe, Richard, of Exilond, dyer 1
5137938 2397607 2397607 defendant Berd John merchant 587118 587118 Berd, John, of Exilond, merchant 1
5143643 2399275 2399275 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5143646 2399276 2399276 defendant Hakeworthy John   587118 587118 Hakeworthy, John, of Exilond, franklin 0
5148610 2400719 2400719 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5149420 2400963 2400963 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5154450 2402455 2402455 defendant Combe Richard dyer 587118 587118 Combe, Richard, of Exilond, dyer 0
5164794 2405435 2405435 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5167855 2406311 2406311 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5171532 2407394 2407394 defendant Combe Richard dyer 587118 587118 Combe, Richard, of Exilond, dyer 0
5183485 2410907 2410907 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5184252 2411137 2411137 defendant Butte William merchant 587118 587118 Butte, William, of Exilond, merchant 0
5188077 2412225 2412225 defendant York Walter   587118 587118 together with York, Walter, of Exilond, brass worker 2
5200623 2415940 2415940 defendant atte Marsh Andrew butcher 587118 587118 atte Marsh, Andrew, of Exilond, butcher 0
5201046 2416062 2416062 defendant York Walter brasier 587118 587118 Walter York, of Exilond, brasier 1
5211548 2419115 2419115 defendant atte Mersshe Andrew butcher 587118 587118 atte Mersshe, Andrew, of Exilond, butcher 0
5212167 2419297 2419297 defendant Hille Thyomas yeoman 587118 587118 Hille, Thyomas, of Exilond, yeoman 1
5241954 2427844 2427844 defendant Mederes Richard dyer 587118 587118 Mederes, Richard, of Exilond, dyer 0
5252295 2430827 2430827 defendant atte Mersshe Andrew husbandman 587118 587118 atte Mersshe, Andrew, of Exilond, husbandman 4
5262864 2434126 2434126 defendant Jenyn John dyer P.S. 587118 587118 Jenyn, John, of Exilond , dyer P.S. 3
5289052 2441808 2441808 defendant William John dyer 587118 587118 William, John, of Exilond, dyer 2
5289053 2441808 2441808 defendant Bragge Stephen dyer 587118 587118 Bragge, Stephen, of Exilond, dyer 3
5303604 2446073 2446073 defendant Edward John dyer 587118 587118 Edward, John, of Exilond, dyer 0
5303606 2446074 2446074 defendant Edward John dyer 587118 587118 Edward, John, of Exilond, dyer 0
5305532 2446658 2446658 defendant atte Mersshe Andrew butcher 587118 587118 atte Mersshe, Andrew, of Exilond, butcher 3
5318937 2450757 2450757 plaintiff Hakeworthy John (legal representative) 587118 587118 Hakeworthy, John, of Exilond, merchant, executor of 0
5319777 2451007 2451007 defendant Honewell John tanner 587118 587118 Honewell, John, of Exilond, tanner 0
5355736 2461871 2461871 defendant Lucas alias Walsh John dyer 587118 587118 Lucas alias Walsh, John, of Exilond, dyer 0
5355738 2461872 2461872 defendant Toser John dyer 587118 587118 Toser, John, of Exilond, dyer 0
5387968 2471616 2471616 defendant Edward William dyer 587118 587118 Edward, William, of Exilond, dyer 0
5400634 2475242 2475242 defendant Edward William dyer 587118 587118 Edward, William, of Exilond, dyer 0
5429981 2483905 2483905 defendant Dunnslegh John dyer 587118 587118 Dunnslegh, John, of Exilond, dyer 0
5432642 2484731 2484731 defendant Est John dyer 587118 587118 Est, John, of Exilond, dyer 1
5435684 2485610 2485610 defendant Come Richard dyer 587118 587118 Come, Richard, of Exilond, dyer 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);