names

210 rows where place_id = 587061

✎ 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
3590355 1864624 1864624 defendant Payn Thomas husbandman 587061 587061 Payn, Thomas, of Combes, husbandman 0
3702660 1927101 1927101 defendant Thurmode Thomas husbandman 587061 587061 Thurmode, Thomas, of Combes, husbandman 1
3764675 1946614 1946614 defendant Mastlyn Henry butcher 587061 587061 Mastlyn, Henry, of Combes, butcher 0
3777524 1950722 1950722 defendant Thurmode Thomas husbandman 587061 587061 Thurmode, Thomas, of Combes, husbandman 1
3854492 1975045 1975045 plaintiff Thorpe William dyer and clothmaker 587061 587061 Thorpe, William, of Combes, dyer and clothmaker 0
3886395 1985703 1985703 defendant Bull Robert singleman 587061 587061 Bull, Robert, of Combes, singleman 0
3900157 1990277 1990277 defendant Poley Anthony yeoman 587061 587061 Poley, Anthony, of Combes, yeoman 2
3917811 1996318 1996318 defendant Turmode Thomas husbandman 587061 587061 Turmode, Thomas, of Combes, husbandman 0
3953654 2008353 2008353 defendant Welham Richard husbandman 587061 587061 Welham, Richard, of Combes, husbandman 0
3994494 2022780 2022780 defendant Deane Gregory husbandman 587061 587061 Deane, Gregory, of Combes, husbandman 0
3994495 2022780 2022780 defendant Deane Thomas husbandman 587061 587061 Deane, Thomas, of Combes, husbandman 1
4047872 2041684 2041684 defendant Coby Richard (legal representative) 587061 587061 Coby, Richard, of Combes, yeoman, executors of 0
4137985 2073946 2073946 defendant Payne Margaret widow 587061 587061 Payne, Margaret, of Combes, widow 0
4137987 2073947 2073947 defendant Payne Margaret widow 587061 587061 Payne, Margaret, of Combes, widow 0
4149453 2077934 2077934 defendant Payne Margaret widow 587061 587061 Payne, Margaret, of Combes, widow 3
4153358 2079272 2079272 defendant Deane Gregory husbandman 587061 587061 Deane, Gregory, of Combes, husbandman 1
4185956 2090577 2090577 defendant Payne Margaret widow 587061 587061 Payne, Margaret, of Combes, widow 0
4209763 2098971 2098971 defendant Payne Margaret widow 587061 587061 Payne, Margaret, of Combes, widow 0
4233569 2107260 2107260 defendant Deane Gregory husbandman 587061 587061 Deane, Gregory, of Combes, husbandman 1
4240355 2109750 2109750 defendant Bull alias Adger Robert glover 587061 587061 Bull alias Adger, Robert, of Combes, glover 2
4245795 2111573 2111573 defendant Humfrey Henry yeoman 587061 587061 Humfrey, Henry, of Combes, yeoman 0
4301328 2130584 2130584 defendant Neave Edmund husbandman 587061 587061 Neave, Edmund, of Combes, husbandman 0
4302781 2131092 2131092 defendant Gibbons Humphrey   587061 587061 Gibbons, Humphrey, of Combes, yeoman, or of Fynborough Magna, physician 0
4304184 2131595 2131595 defendant Ellys Richard husbandman 587061 587061 Ellys, Richard, of Combes, husbandman 1
4305069 2131914 2131914 defendant Humfrey William, senior yeoman 587061 587061 Humfrey, William, senior, of Combes, yeoman 0
4305260 2131978 2131978 defendant Humfrey Henry yeoman 587061 587061 Humfrey, Henry, of Combes, yeoman 0
4333825 2141595 2141595 defendant Dennys Edmund yeoman 587061 587061 Dennys, Edmund, of Combes, yeoman 0
4353990 2148622 2148622 defendant Balles Edmund yeoman 587061 587061 Balles, Edmund, of Combes, yeoman 0
4397842 2163856 2163856 defendant Gibbons Humphrey practitioner in physic 587061 587061 Gibbons, Humphrey, of Combes, medicus, practitioner in physic 0
4437748 2181128 2181128 defendant Gerry Richard   587061 587061 Gerry, Richard, of Combes 1
4438513 2181333 2181333 defendant W--e Robert   587061 587061 W--e, Robert, of Combes 0
4440787 2182035 2182035 defendant Dalkes Robert   587061 587061 Dalkes, Robert, of Combes 0
4440788 2182035 2182035 defendant Gery Ralph   587061 587061 Gery, Ralph, of Combes 1
4446600 2183851 2183851 defendant Gery Ralph   587061 587061 Gery, Ralph, of Combes 0
4461156 2188568 2188568 plaintiff Spragey Michael   587061 587061 Spragey, Michael, of Combes 0
4473330 2192319 2192319 defendant de Wode Thomas   587061 587061 de Wode, Thomas, of Combes 0
4478570 2193963 2193963 defendant Tournour Thomas   587061 587061 Tournour, Thomas, of Combes 4
4498395 2200154 2200154 defendant Cros Thomas   587061 587061 Cros, Thomas, of Combes 3
4498489 2200174 2200174 plaintiff Frend Richard   587061 587061 Frend, Richard, of Combes, on his own account 0
4502336 2201318 2201318 defendant Gardener John   587061 587061 Gardener, John, of Combes 0
4502339 2201318 2201318 defendant Man Simon   587061 587061 Man, Simon, of Combes 3
4508552 2203152 2203152 defendant Cokerel Robert   587061 587061 Cokerel, Robert, of Combes 0
4513006 2204502 2204502 defendant Cokerell Robert   587061 587061 Cokerell, Robert, of Combes 0
4513008 2204503 2204503 defendant Cokerell Robert   587061 587061 Cokerell, Robert, of Combes 0
4520877 2206872 2206872 defendant Boole John   587061 587061 Boole, John, of Combes 5
4522283 2207314 2207314 defendant Gery Ralph   587061 587061 Gery, Ralph, of Combes 1
4528796 2209291 2209291 plaintiff Mellere John   587061 587061 Mellere, John, of Combes 0
4535200 2211279 2211279 defendant Bailly John   587061 587061 Bailly, John, of Combes 25
4535221 2211280 2211280 defendant Bailly John   587061 587061 Bailly, John, of Combes 19
4549885 2215897 2215897 defendant Gery Ralph   587061 587061 Gery, Ralph, of Combes 1
4556072 2217841 2217841 plaintiff Hook Geoffrey   587061 587061 Hook, Geoffrey, of Combes 0
4557050 2218133 2218133 plaintiff Kent Nicholas   587061 587061 Kent, Nicholas, of Combes 0
4557053 2218133 2218133 defendant Creppyng John butcher 587061 587061 Creppyng, John, of Combes, butcher 2
4557055 2218134 2218134 plaintiff Kent Nicholas   587061 587061 Kent, Nicholas, of Combes 0
4557058 2218134 2218134 defendant Creppyng John butcher 587061 587061 Creppyng, John, of Combes, butcher 2
4564483 2220457 2220457 defendant Oldhygne Benedict cutler 587061 587061 Oldhygne, Benedict, of Combes, cutler 0
4585277 2226819 2226819 defendant Gosselyn William tanner 587061 587061 Gosselyn, William, of Combes, tanner 0
4588142 2227688 2227688 defendant Holgate John   587061 587061 Holgate, John, of Combes 4
4610060 2234231 2234231 defendant Hasard Alan   587061 587061 Hasard, Alan, of Combes 0
4610507 2234358 2234358 defendant Cobbe John   587061 587061 Cobbe, John, of Combes 1
4619892 2237200 2237200 defendant Deye John   587061 587061 Deye, John, of Combes 0
4627597 2239564 2239564 defendant Kent Nicholas   587061 587061 Kent, Nicholas, of Combes 0
4660782 2249196 2249196 defendant Edward John   587061 587061 Edward, John, of Combes, wright 2
4663633 2250105 2250105 plaintiff Gosselyn William   587061 587061 Gosselyn, William, of Combes 0
4676083 2258132 2258132 plaintiff Gardener John   587061 587061 Gardener, John, of Combes 0
4676821 2258368 2258368 plaintiff Grene Robert   587061 587061 Grene, Robert, of Combes 0
4678383 2258846 2258846 defendant Scalpy John husbandman 587061 587061 with Scalpy, John, of Combes,husbandman 2
4678384 2258847 2258847 plaintiff Holgate John   587061 587061 Holgate, John, of Combes 0
4678387 2258847 2258847 defendant Creppynge John butcher 587061 587061 Creppynge, John, of Combes, butcher 2
4691696 2262936 2262936 plaintiff Adgor Richard   587061 587061 Adgor, Richard, of Combes 0
4691697 2262936 2262936 defendant Eldyne or Gleyne Benedict   587061 587061 Eldyne or Gleyne, Benedict, of Combes 0
4697189 2264602 2264602 plaintiff Clerk Richard (legal representative) 587061 587061 Clerk, Richard, of Combes, executors of 0
4697192 2264602 2264602 defendant Lakford Thomas husbandman 587061 587061 Lakford, Thomas, of Combes, husbandman 0
4703857 2266586 2266586 plaintiff Holgate John   587061 587061 Holgate, John, of Combes 0
4820678 2302542 2302542 defendant Fravyll John yeoman 587061 587061 Fravyll, John, of Combes, yeoman 0
4820680 2302543 2302543 defendant Fravyll John yeoman 587061 587061 Fravyll, John, of Combes, yeoman 0
4846986 2310564 2310564 defendant Treker William yeoman 587061 587061 Treker, William, of Combes, yeoman 0
4846987 2310564 2310564 defendant Bastard Thomas baker 587061 587061 Bastard, Thomas, of Combes, baker 1
4859666 2314396 2314396 defendant Basse George   587061 587061 Basse, George, of Combes, wright 0
4874669 2319021 2319021 defendant Treker William yeoman 587061 587061 Treker, William, of Combes, yeoman 0
4874670 2319021 2319021 defendant Tascard Thomas yeoman 587061 587061 Tascard, Thomas, of Combes, yeoman 1
4886692 2322700 2322700 defendant Sperlyng Thomas laborer 587061 587061 Sperlyng, Thomas, of Combes, laborer 0
4919712 2332670 2332670 defendant Draper John weaver 587061 587061 Draper, John, of Combes, weaver 4
4924220 2334020 2334020 defendant Adgore Richard yeoman 587061 587061 Adgore, Richard, of Combes,yeoman 0
4926731 2334782 2334782 defendant Hebbes Gilbert husbandman 587061 587061 Hebbes, Gilbert, of Combes, husbandman 1
4926734 2334782 2334782 defendant Baldewyn Thomas laborer 587061 587061 Baldewyn, Thomas, of Combes, laborer 4
4926736 2334782 2334782 defendant Draper John weaver 587061 587061 Draper, John, of Combes, weaver 6
4954480 2343307 2343307 defendant Hebbys Gilbert husbandman 587061 587061 Hebbys, Gilbert, of Combes, husbandman 0
4961367 2345367 2345367 defendant Boole John   587061 587061 Boole, John, of Combes, wright 0
4963028 2345851 2345851 defendant Dewerys Robert husbandman 587061 587061 Dewerys, Robert, of Combes, husbandman 2
4970225 2348046 2348046 plaintiff Hasard John weaver 587061 587061 Hasard, John, of Combes, weaver 0
4970226 2348046 2348046 plaintiff Adgor Richard   587061 587061 Adgor, Richard, of Combes 1
4980821 2351194 2351194 defendant Hebbys Gilbert husbandman 587061 587061 Hebbys, Gilbert, of Combes, husbandman 0
4987825 2353323 2353323 defendant Bole John   587061 587061 Bole, John, of Combes, wright 0
4993412 2354897 2354897 defendant Russhebrook John gent 587061 587061 Russhebrook, John, of Combes, gent 1
4995626 2355530 2355530 defendant Chrche_ Thomas husbandman 587061 587061 Chrche_, Thomas, of Combes, husbandman 1
4995627 2355530 2355530 defendant Staverton John husbandman 587061 587061 Staverton, John, of Combes, husbandman 2
5005102 2358392 2358392 defendant Edwyn Margery   587061 587061 Edwyn, Margery, of Combes, servant 1
5005114 2358393 2358393 defendant Barkere Thomas   587061 587061 Barkere, Thomas, of Combes, cook 10
5018052 2362163 2362163 defendant Hony Richard husbandman 587061 587061 Hony, Richard, of Combes, husbandman 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);