names

269 rows where place_id = 592767

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608850 1870425 1870425 plaintiff Warberton Thomas   592767 592767 Warberton, Thomas, of Stoke Neylond 0
3612960 1871700 1871700 defendant Austyn Thomas clothmaker 592767 592767 Austyn, Thomas, of Stoke Neylond, clothmaker 1
3625084 1875380 1875380 defendant Craufyn or Cranfyn Joan widow 592767 592767 Craufyn or Cranfyn, Joan, of Stoke Neylond, widow 1
3625085 1875380 1875380 defendant Rote John, junior clothman 592767 592767 Rote, John, junior, of Stoke Neylond, clothman 2
3636841 1906316 1906316 defendant Hayton John carpenter 592767 592767 Hayton, John, of Stoke Neylond, carpenter 0
3647935 1909751 1909751 defendant Hache John (legal representative) 592767 592767 Hache, John, of Stoke Neylond, yeoman, executor of 4
3668965 1916225 1916225 defendant Taylor Robert butcher 592767 592767 Taylor, Robert, of Stoke Neylond, butcher 1
3678554 1919350 1919350 defendant Berton Thomas yeoman 592767 592767 Berton, Thomas, of Stoke Neylond, yeoman 3
3680587 1920009 1920009 defendant Love Thomas laborer 592767 592767 Love, Thomas, of Stoke Neylond, laborer 1
3688833 1922667 1922667 defendant Chevyngton Thomas tanner 592767 592767 Chevyngton, Thomas, of Stoke Neylond, tanner 0
3699833 1926173 1926173 plaintiff Abell John clothman 592767 592767 Abell, John, of Stoke Neylond, clothman 0
3699835 1926173 1926173 defendant Hall John clothmaker 592767 592767 Hall, John, of Stoke Neylond, clothmaker 1
3713317 1930477 1930477 defendant Abell Anne widow 592767 592767 Abell, Anne, of Stoke Neylond, widow 0
3803483 1958993 1958993 defendant Armond Edmund tailor 592767 592767 Armond, Edmund, of Stoke Neylond, tailor 1
3813186 1962034 1962034 defendant Clyfford John husbandman 592767 592767 Clyfford, John, of Stoke Neylond, husbandman 2
3829198 1967015 1967015 plaintiff Cowper Robert clothman 592767 592767 Cowper, Robert, of Stoke Neylond, clothman 0
3842049 1971067 1971067 defendant Houghton Thomas clothier 592767 592767 Houghton, Thomas, of Stoke Neylond, clothier 2
3845790 1972232 1972232 defendant Scranton Robert carpenter 592767 592767 Scranton, Robert, of Stoke Neylond, carpenter 1
3916487 1995892 1995892 defendant Leme William butcher 592767 592767 Leme, William, of Stoke Neylond, butcher 0
3918424 1996489 1996489 defendant Holton Thomas clothmaker 592767 592767 Holton, Thomas, of Stoke Neylond, clothmaker 0
3942968 2004654 2004654 defendant Smyth James clothier 592767 592767 Smyth, James, of Stoke Neylond, clothier 1
4423049 2172068 2172068 defendant Cokefeld John   592767 592767 Cokefeld, John, of Stoke Neylond 1
4463659 2189333 2189333 defendant Bernard John   592767 592767 Bernard, John, of Stoke Neylond 1
4463671 2189334 2189334 defendant Bernard John   592767 592767 Bernard, John, of Stoke Neylond 1
4463758 2189348 2189348 defendant Bernard John   592767 592767 Bernard, John, of Stoke Neylond 1
4469670 2191181 2191181 defendant Taillour Robert   592767 592767 Taillour, Robert, of Stoke Neylond 0
4475925 2193142 2193142 defendant Adam John   592767 592767 Adam, John, of Stoke Neylond 4
4488349 2197074 2197074 defendant Mors Thomas   592767 592767 Mors, Thomas, of Stoke Neylond 1
4509950 2203598 2203598 defendant Gru Stephen   592767 592767 Gru, Stephen, of Stoke Neylond 1
4509951 2203598 2203598 defendant Wyllys Mathew   592767 592767 Wyllys, Mathew, of Stoke Neylond 2
4509956 2203599 2203599 defendant Gru Stephen   592767 592767 Gru, Stephen, of Stoke Neylond 1
4509957 2203599 2203599 defendant Wyllys Mathew   592767 592767 Wyllys, Mathew, of Stoke Neylond 2
4521448 2207051 2207051 defendant Taillour William   592767 592767 Taillour, William, of Stoke Neylond 0
4522784 2207463 2207463 defendant Hacon John   592767 592767 Hacon, John, of Stoke Neylond 0
4533109 2210619 2210619 defendant Taillour William   592767 592767 Taillour, William, of Stoke Neylond 0
4541852 2213343 2213343 plaintiff Wymark Robert   592767 592767 Wymark, Robert, of Stoke Neylond 0
4553499 2217025 2217025 plaintiff George Nicholas   592767 592767 George, Nicholas, of Stoke Neylond 0
4554298 2217272 2217272 plaintiff Garton John   592767 592767 Garton, John, of Stoke Neylond 1
4555536 2217660 2217660 defendant Doudyng John   592767 592767 Doudyng, John, of Stoke Neylond 5
4555950 2217798 2217798 defendant Leche Lawrence   592767 592767 Leche, Lawrence, of Stoke Neylond 1
4574786 2223638 2223638 plaintiff Bisshop Roger   592767 592767 Bisshop, Roger, of Stoke Neylond 0
4578379 2224727 2224727 defendant Turnour Thomas   592767 592767 Turnour, Thomas, of Stoke Neylond 0
4578383 2224727 2224727 defendant Warner John   592767 592767 Warner, John, of Stoke Neylond 4
4605026 2232730 2232730 defendant Skynner Robert   592767 592767 Skynner, Robert, of Stoke Neylond 1
4616598 2236192 2236192 defendant Halk Robert   592767 592767 Halk, Robert, of Stoke Neylond 0
4620914 2237523 2237523 defendant Stedeman Thomas   592767 592767 Stedeman, Thomas, of Stoke Neylond 1
4621604 2237745 2237745 plaintiff Laryot John   592767 592767 Laryot, John, of Stoke Neylond 0
4622878 2238137 2238137 plaintiff Mannok Philip   592767 592767 Mannok, Philip, of Stoke Neylond 0
4624420 2238621 2238621 defendant Cokeman Alice   592767 592767 Cokeman, Alice, of Stoke Neylond 0
4627749 2239608 2239608 plaintiff Cole John   592767 592767 Cole, John, of Stoke Neylond 1
4627751 2239608 2239608 defendant Cole John   592767 592767 Cole, John, of Stoke Neylond 1
4629095 2240024 2240024 plaintiff Skynner Richard   592767 592767 Skynner, Richard, of Stoke Neylond 0
4630271 2240378 2240378 plaintiff Sterre John   592767 592767 Sterre, John, of Stoke Neylond 0
4630273 2240378 2240378 defendant Lelseye Thomas   592767 592767 Lelseye, Thomas, of Stoke Neylond 1
4632747 2241127 2241127 defendant Fynche John   592767 592767 Fynche, John, of Stoke Neylond 0
4647664 2245373 2245373 plaintiff Skynnere Richard   592767 592767 Skynnere, Richard, of Stoke Neylond 0
4657788 2248321 2248321 defendant Chaumberleyn Ralph gent 592767 592767 Chaumberleyn, Ralph, of Stoke Neylond, gent 0
4671070 2256618 2256618 defendant atte Mere Robert yeoman 592767 592767 atte Mere, Robert, of Stoke Neylond, yeoman 0
4674017 2257487 2257487 defendant Howe John husbandman 592767 592767 Howe, John, of Stoke Neylond, husbandman 3
4674018 2257487 2257487 defendant Bakere Thomas baker 592767 592767 Bakere, Thomas, of Stoke Neylond, baker 4
4674019 2257487 2257487 defendant Bakere John clerk 592767 592767 Bakere, John, of Stoke Neylond, clerk 5
4674020 2257487 2257487 defendant Hacche John laborer 592767 592767 Hacche, John, of Stoke Neylond, laborer 6
4674021 2257487 2257487 defendant Deye William laborer 592767 592767 Deye, William, of Stoke Neylond, laborer 7
4676256 2258186 2258186 plaintiff George Katherine   592767 592767 George, Katherine, of Stoke Neylond, formerly wife of Nicholas George 0
4676257 2258186 2258186 plaintiff George John   592767 592767 George, John, of Stoke Neylond 1
4676258 2258186 2258186 defendant Schort alias Langeley Lawrence husbandman 592767 592767 Schort alias Langeley, Lawrence, of Stoke Neylond, husbandman 0
4679987 2259344 2259344 plaintiff Laryoth John (legal representative) 592767 592767 Laryoth, John, of Stoke Neylond, executors of 0
4679988 2259344 2259344 plaintiff Cappe Thomas   592767 592767 (Cappe, Thomas, of Stoke Neylond 1
4680787 2259610 2259610 defendant Leyre John gent 592767 592767 Leyre, John, of Stoke Neylond, gent 1
4682402 2260115 2260115 defendant Paton Robert husbandman 592767 592767 Paton, Robert, of Stoke Neylond, husbandman 0
4682403 2260115 2260115 defendant atte Mere Robert husbandman 592767 592767 atte Mere, Robert, of Stoke Neylond, husbandman 1
4683194 2260359 2260359 defendant Garton John baker 592767 592767 Garton, John, of Stoke Neylond, baker 0
4686516 2261390 2261390 plaintiff Smyth John   592767 592767 Smyth, John, of Stoke Neylond 0
4686521 2261391 2261391 plaintiff Smyth John   592767 592767 Smyth, John, of Stoke Neylond 0
4688168 2261865 2261865 defendant Grove John, junior shoemaker 592767 592767 Grove, John, junior, of Stoke Neylond, shoemaker 0
4688169 2261865 2261865 defendant Deyes John butcher 592767 592767 Deyes, John, of Stoke Neylond, butcher 1
4688170 2261865 2261865 defendant Dryver Bartholomew butcher 592767 592767 Dryver, Bartholomew, of Stoke Neylond, butcher 2
4688171 2261865 2261865 defendant Damesele Thomas weaver 592767 592767 Damesele, Thomas, of Stoke Neylond, weaver 3
4705653 2267144 2267144 plaintiff Laryoth John (legal representative) 592767 592767 Laryoth, John, of Stoke Neylond, executors of 0
4705655 2267144 2267144 plaintiff Cappe Thomas   592767 592767 Cappe, Thomas, of Stoke Neylond 2
4705659 2267145 2267145 plaintiff Laryoth John, senior (legal representative) 592767 592767 Laryoth, John, senior, of Stoke Neylond, executors of 0
4711497 2268926 2268926 plaintiff Rysyng John   592767 592767 Rysyng, John, of Stoke Neylond 0
4717006 2270648 2270648 defendant Kersey Richard fuller 592767 592767 Kersey, Richard, of Stoke Neylond, fuller 3
4718393 2271092 2271092 defendant Proud Augustine butcher 592767 592767 Proud, Augustine, of Stoke Neylond, butcher 0
4718394 2271092 2271092 defendant Bette Thomas butcher 592767 592767 Bette, Thomas, of Stoke Neylond, butcher 1
4721081 2271929 2271929 defendant Skynner John yeoman 592767 592767 Skynner, John, of Stoke Neylond, yeoman 0
4722336 2272309 2272309 defendant Coupere John   592767 592767 Coupere, John, of Stoke Neylond, shoe maker 2
4723477 2272652 2272652 defendant Sterre John chapman 592767 592767 Sterre, John, of Stoke Neylond, chapman 2
4723587 2272682 2272682 defendant Mitton Nicholas dyer 592767 592767 Mitton, Nicholas, of Stoke Neylond, dyer 0
4724666 2273013 2273013 defendant Debenham William yeoman 592767 592767 Debenham, William, of Stoke Neylond, yeoman 0
4724667 2273013 2273013 defendant Blast John barber 592767 592767 Blast, John, of Stoke Neylond, barber 1
4725153 2273165 2273165 defendant Milner John husbandman 592767 592767 Milner, John, of Stoke Neylond, husbandman 0
4725154 2273165 2273165 defendant Barton John husbandman 592767 592767 Barton, John, of Stoke Neylond, husbandman 1
4725155 2273165 2273165 defendant Stedeman John husbandman 592767 592767 Stedeman, John, of Stoke Neylond, husbandman 2
4725156 2273165 2273165 defendant Debenham John husbandman 592767 592767 Debenham, John, of Stoke Neylond, husbandman 3
4725366 2273226 2273226 defendant Lungeley Lawrence husbandman 592767 592767 Lungeley, Lawrence, of Stoke Neylond, husbandman 0
4725367 2273226 2273226 defendant Mastly Robert fuller 592767 592767 Mastly, Robert, of Stoke Neylond, fuller 1
4728581 2274177 2274177 defendant Mud Richard yeoman 592767 592767 Mud, Richard, of Stoke Neylond, yeoman 0
4735277 2276180 2276180 defendant Haselbeche Thomas tanner 592767 592767 Haselbeche, Thomas, of Stoke Neylond, tanner 0
4736417 2276520 2276520 defendant Smyth Geoffrey smith 592767 592767 Smyth, Geoffrey, of Stoke Neylond, smith 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);