names

144 rows where place_id = 605076

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3660300 1913482 1913482 defendant John alias Ley William yeoman 605076 605076 John alias Ley, William, of Bodmin, yeoman 0
3661457 1913854 1913854 defendant Calwodeley John scolmaster 605076 605076 Calwodeley, John, of Bodmin, scolmaster 2
3928622 1999911 1999911 defendant Vyvyan John gent 605076 605076 Vyvyan, John, of Bodmin, gent 2
4414251 2169366 2169366 plaintiff Farford John de merchant 605076 605076 Farford, John de, of Bodmin, merchant 1
4452393 2185743 2185743 plaintiff Juyl Richard   605076 605076 Juyl, Richard, of Bodmin 0
4463086 2189157 2189157 defendant Chubba Walter goldsmith 605076 605076 Chubba, Walter, of Bodmin, goldsmith 0
4475350 2192976 2192976 defendant Gyfford Henry   605076 605076 Gyfford, Henry, of Bodmin 0
4477922 2193763 2193763 defendant Richard Henry   605076 605076 Richard, Henry, of Bodmin 0
4493740 2198740 2198740 plaintiff Martyn Roger, senior   605076 605076 (Martyn, Roger, senior, of Bodmin 1
4498277 2200119 2200119 plaintiff Foll John (legal representative) 605076 605076 Foll, John, of Bodmin, executors of 0
4498282 2200119 2200119 defendant Sala Henry   605076 605076 Sala, Henry, of Bodmin 0
4502032 2201230 2201230 plaintiff Martyn Roger, senior   605076 605076 Martyn, Roger, senior, of Bodmin 0
4518879 2206270 2206270 defendant Hokkyn Richard   605076 605076 Hokkyn, Richard, of Bodmin 0
4520582 2206786 2206786 plaintiff Foll John (legal representative) 605076 605076 Foll, John, of Bodmin, executors of 0
4520586 2206786 2206786 defendant Sela Henry   605076 605076 Sela, Henry, of Bodmin 0
4522374 2207342 2207342 plaintiff Grendon John (legal representative) 605076 605076 Grendon, John, of Bodmin, executors of 0
4522375 2207342 2207342 plaintiff Langa John   605076 605076 (Langa, John, of Bodmin 1
4526015 2208435 2208435 defendant Monke John   605076 605076 Monke, John, of Bodmin 0
4528530 2209200 2209200 plaintiff Martyn Roger, sen   605076 605076 Martyn, Roger, sen, of Bodmin 0
4529061 2209360 2209360 defendant Cornou Roger   605076 605076 Cornou, Roger, of Bodmin 0
4538445 2212311 2212311 defendant Hopkyn Richard   605076 605076 Hopkyn, Richard, of Bodmin 0
4544602 2214226 2214226 defendant Crugkarowe Thomas clerk 605076 605076 Crugkarowe, Thomas, of Bodmin, clerk 0
4558141 2218486 2218486 defendant Glen Stephen (legal representative) 605076 605076 Glen, Stephen, of Bodmin, administrator of 0
4561104 2219428 2219428 defendant Glovere Ralph   605076 605076 Glovere, Ralph, of Bodmin 0
4565432 2220757 2220757 defendant Bereshull John   605076 605076 Bereshull, John, of Bodmin 1
4565433 2220757 2220757 defendant Trote Simon   605076 605076 Trote, Simon, of Bodmin 2
4576599 2224191 2224191 plaintiff Budde Richard   605076 605076 Budde, Richard, of Bodmin 0
4591501 2228698 2228698 defendant Mollyng Roger   605076 605076 Mollyng, Roger, of Bodmin 0
4592282 2228934 2228934 plaintiff Nicolle John   605076 605076 Nicolle, John, of Bodmin 0
4632117 2240925 2240925 defendant Hobbekyne Richard   605076 605076 Hobbekyne, Richard, of Bodmin 1
4634466 2241628 2241628 defendant Sporyer Reginald   605076 605076 Sporyer, Reginald, of Bodmin 0
4638118 2242685 2242685 defendant Trota Simon   605076 605076 Trota, Simon, of Bodmin 0
4644341 2244435 2244435 defendant Talik Robert   605076 605076 Talik, Robert, of Bodmin 2
4661786 2249528 2249528 defendant Gauden or Ganden Stephen cordwainer 605076 605076 Gauden or Ganden, Stephen, of Bodmin, cordwainer 0
4681665 2259875 2259875 defendant Whyler John ostler 605076 605076 Whyler, John, of Bodmin, ostler 0
4682471 2260142 2260142 plaintiff Nicoll John   605076 605076 Nicoll, John, of Bodmin 0
4696370 2264343 2264343 defendant Tyllyk Emma spinster 605076 605076 Tyllyk, Emma, of Bodmin, spinster 4
4700769 2265641 2265641 defendant Ryes John   605076 605076 Ryes, John, of Bodmin, husb 0
4701568 2265885 2265885 defendant Wilcok John   605076 605076 Wilcok, John, of Bodmin, glove maker 0
4701570 2265885 2265885 defendant Baker Richard baker 605076 605076 Baker, Richard, of Bodmin, baker 2
4702884 2266298 2266298 defendant Aunger Peter   605076 605076 Aunger, Peter, of Bodmin 2
4709741 2268405 2268405 defendant Goldsmyth William goldsmith 605076 605076 Goldsmyth, William, of Bodmin, goldsmith 4
4709743 2268406 2268406 defendant Goldsmyth William goldsmith 605076 605076 Goldsmyth, William, of Bodmin, goldsmith 0
4709750 2268407 2268407 defendant Goldsmyth William goldsmith 605076 605076 together with Goldsmyth, William, of Bodmin, goldsmith 1
4709751 2268407 2268407 defendant Helston William goldsmith 605076 605076 Helston, William, of Bodmin, goldsmith 2
4709758 2268408 2268408 defendant Goundry Richard yeoman 605076 605076 Goundry, Richard, of Bodmin, yeoman 2
4710737 2268712 2268712 defendant Goundrey John yeoman 605076 605076 Goundrey, John, of Bodmin, yeoman 0
4710752 2268716 2268716 defendant Goundrey John yeoman 605076 605076 Goundrey, John, of Bodmin, yeoman 0
4713803 2269644 2269644 plaintiff Syman John   605076 605076 Syman, John, of Bodmin 0
4714714 2269931 2269931 defendant Busshell William   605076 605076 Busshell, William, of Bodmin, shoe maker 0
4715850 2270271 2270271 defendant Kelly John butcher 605076 605076 Kelly, John, of Bodmin, butcher 1
4715851 2270271 2270271 defendant Davy John merchant 605076 605076 Davy, John, of Bodmin, merchant 2
4715854 2270272 2270272 defendant Kelly John butcher 605076 605076 Kelly, John, of Bodmin, butcher 1
4715855 2270272 2270272 defendant Davy John merchant 605076 605076 Davy, John, of Bodmin, merchant 2
4716075 2270335 2270335 defendant Symon John merchant 605076 605076 Symon, John, of Bodmin, merchant 0
4716076 2270335 2270335 defendant Hoig Benedict shoemaker 605076 605076 Hoig, Benedict, of Bodmin, shoemaker 1
4720435 2271728 2271728 plaintiff Broun Thomas   605076 605076 Broun, Thomas, of Bodmin 0
4731008 2274901 2274901 defendant Piers Walter carrier 605076 605076 Piers, Walter, of Bodmin, carrier 2
4731009 2274901 2274901 defendant Langston William baker 605076 605076 Langston, William, of Bodmin, baker 3
4731022 2274906 2274906 defendant Talbot John smith 605076 605076 Talbot, John, of Bodmin, smith 1
4736611 2276581 2276581 plaintiff Thomma John   605076 605076 Thomma, John, of Bodmin, brass worker 0
4737100 2276724 2276724 defendant Symon John mercer 605076 605076 Symon, John, of Bodmin, mercer 0
4737114 2276727 2276727 defendant Denyok Gregory yeoman 605076 605076 Denyok, Gregory, of Bodmin, yeoman 3
4739471 2277429 2277429 defendant Tremayn Richard gent 605076 605076 Tremayn, Richard, of Bodmin, gent 0
4747702 2279836 2279836 defendant Coly John   605076 605076 Coly, John, of Bodmin, esq, son & heir of Thomas Colyn of Hellond 0
4749983 2280469 2280469 defendant Whotsyn John husbandman 605076 605076 Whotsyn, John, of Bodmin, husbandman 4
4752870 2281294 2281294 defendant Cornowe Henry husbandman 605076 605076 Cornowe, Henry, of Bodmin, husbandman 1
4760428 2283613 2283613 defendant Tomma John   605076 605076 Tomma, John, of Bodmin, brass maker 1
4764479 2284874 2284874 defendant Nichol John Cornwall, merchant 605076 605076 Nichol John, of Bodmin, Cornwall, merchant 0
4766381 2285476 2285476 defendant Colyn John esq 605076 605076 Colyn, John, of Bodmin, gent, son & heir of Thomas Colyn, of Hellond, esq 0
4768600 2286160 2286160 plaintiff Nicoll John   605076 605076 Nicoll, John, of Bodmin 0
4768608 2286161 2286161 plaintiff Nicoll John   605076 605076 Nicoll, John, of Bodmin 0
4769839 2286543 2286543 defendant Tregenstek Henry smith 605076 605076 Tregenstek, Henry, of Bodmin, smith 0
4770616 2286791 2286791 defendant Pate John butcher 605076 605076 Pate, John, of Bodmin, butcher 0
4773381 2287650 2287650 defendant Senyon Richard husbandman 605076 605076 Senyon, Richard, of Bodmin, husbandman 0
4774049 2287868 2287868 defendant De_ Gregory yeoman 605076 605076 De_, Gregory, of Bodmin, yeoman 3
4774084 2287877 2287877 defendant (not given) John his son, gent 605076 605076 John, his son, of Bodmin, gent 7
4818202 2301769 2301769 plaintiff Nicoll John   605076 605076 Nicoll, John, of Bodmin 0
4818669 2301922 2301922 defendant Laurens John yeoman 605076 605076 Laurens, John, of Bodmin, yeoman 1
4836936 2307510 2307510 defendant Raulyn John merchant 605076 605076 Raulyn, John, of Bodmin, merchant 0
4838964 2308117 2308117 plaintiff Gurdyn John   605076 605076 Gurdyn, John, of Bodmin 0
4843419 2309457 2309457 defendant Nicoll John merchant 605076 605076 Nicoll, John, of Bodmin, merchant 0
4844097 2309665 2309665 defendant Skerell William yeoman 605076 605076 Skerell, William, of Bodmin, yeoman 0
4844379 2309754 2309754 defendant Skerell William yeoman 605076 605076 Skerell, William, of Bodmin, yeoman 0
4844383 2309755 2309755 defendant Wythiell John goldsmith 605076 605076 Wythiell, John, of Bodmin, goldsmith 0
4919864 2332722 2332722 defendant Wythyell John goldsmith 605076 605076 Wythyell, John, of Bodmin, goldsmith 0
4986062 2352753 2352753 defendant Robert Pastus glover 605076 605076 Robert, Pastus, of Bodmin, glover 1
4987473 2353210 2353210 plaintiff Bernard John   605076 605076 Bernard, John, of Bodmin 0
4988056 2353399 2353399 defendant Nycoll John gent 605076 605076 Nycoll, John, of Bodmin, gent 0
4989756 2353853 2353853 defendant Wythyell or Wychyell John goldsmith 605076 605076 Wythyell or Wychyell, John, of Bodmin, goldsmith 0
4991840 2354444 2354444 defendant Taillour Osbert tailor 605076 605076 Taillour, Osbert, of Bodmin, tailor 3
4999535 2356734 2356734 defendant Wythyell John goldsmith & gent 605076 605076 Wythyell, John, of Bodmin, goldsmith & gent 0
5002314 2357581 2357581 defendant Hoigge Benedict shoemaker 605076 605076 Hoigge, Benedict, of Bodmin, shoemaker 0
5126320 2394180 2394180 defendant Luky Michael goldsmith 605076 605076 Luky, Michael, of bodmin, goldsmith 1
5126324 2394180 2394180 defendant Malet John shoemaker 605076 605076 Malet, John, of Bodmin, shoemaker 5
5128980 2394961 2394961 plaintiff (not given) Thomas prior of Courteys 605076 605076 Courteys, Thomas, of Bodmin, prior of the House & Church of St Petroc 0
5128984 2394962 2394962 plaintiff (not given) Thomas prior of Courteys 605076 605076 Courteys, Thomas, of Bodmin, prior of the House & Church of St Petroc or Bodmyn, Thomas, prior of 0
5128985 2394962 2394962 defendant Watte John fuller 605076 605076 Watte, John, of Bodmin, fuller 0
5144863 2399648 2399648 defendant Luky Michael goldsmith 605076 605076 Luky, Michael, of Bodmin, goldsmith 1
5144867 2399648 2399648 defendant Malet John shoemaker 605076 605076 Malet, John, of Bodmin, shoemaker 5

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