names

62 rows where place_id = 586791

✎ 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
3589634 1864401 1864401 defendant Pollard Lewis clerk 586791 586791 (Pollard, Lewis, of Bydeford, clerk 1
3631272 1904595 1904595 defendant Burgh John husbandman 586791 586791 Burgh, John, of Bydeford, husbandman 0
3632267 1904911 1904911 defendant Davy William husbandman 586791 586791 Davy, William, of Bydeford, husbandman 0
3640916 1907602 1907602 defendant Turner William mercer 586791 586791 Turner, William, of Bydeford, mercer 2
3714489 1930828 1930828 defendant Bere Joan widow 586791 586791 Bere, Joan, of Bydeford, widow 1
4362746 2151735 2151735 defendant Pope Mathew mariner 586791 586791 Pope, Mathew, of Bydeford, mariner 2
4538669 2212372 2212372 defendant Goldeson Nicholas (legal representative) 586791 586791 Goldeson, Nicholas, of Bydeford, executrix of 0
4577576 2224494 2224494 defendant Denyok John   586791 586791 Denyok, John, of Bydeford 0
4580726 2225451 2225451 defendant Wyche Roger merchant 586791 586791 Wyche, Roger, of Bydeford, merchant 0
4580730 2225452 2225452 defendant Wychevile Roger merchant 586791 586791 Wychevile, Roger, of Bydeford, merchant 0
4610542 2234365 2234365 defendant Denyok John   586791 586791 Denyok, John, of Bydeford 0
4635078 2241819 2241819 defendant Walsh William   586791 586791 Walsh, William, of Bydeford 0
4652036 2246571 2246571 defendant Walsshe William husbandman 586791 586791 Walsshe, William, of Bydeford, husbandman 0
4691406 2262837 2262837 defendant Walsche William tailor 586791 586791 Walsche, William, of Bydeford, tailor 0
4702378 2266154 2266154 defendant Wakewell John husbandman 586791 586791 Wakewell, John, of Bydeford, husbandman 1
4726963 2273700 2273700 defendant Stawe John esq 586791 586791 Stawe, John, of Bydeford, esq 1
4739980 2277584 2277584 plaintiff Arundell John esq 586791 586791 Arundell, John, of Bydeford, esq, on his own account 0
4766351 2285467 2285467 defendant Cywele Thomas mariner 586791 586791 Cywele, Thomas, of Bydeford, mariner 3
4775792 2288425 2288425 defendant Hadcote John mariner 586791 586791 Hadcote, John, of Bydeford, mariner 11
4776950 2288778 2288778 plaintiff Arundell John (legal representative) 586791 586791 Arundell, John, of Bydeford, esq, executors of 0
4788279 2292405 2292405 defendant Stowe John gent 586791 586791 Stowe, John, of Bydeford, gent 0
4804279 2297525 2297525 defendant Souder or Sonder William merchant 586791 586791 Souder or Sonder, William, of Bydeford, merchant 0
4832931 2306318 2306318 plaintiff Veysy Richard   586791 586791 Veysy, Richard, of Bydeford, parson 4
4850887 2311724 2311724 defendant Breyte Walter husbandman 586791 586791 Breyte, Walter, of Bydeford, husbandman 0
4910158 2329700 2329700 defendant Lake William husbandman 586791 586791 Lake, William, of Bydeford, husbandman 1
4934734 2337259 2337259 defendant Magge Oliver scrivener 586791 586791 Magge, Oliver, of Bydeford, scrivener 0
4955503 2343607 2343607 defendant Smyth John merchant 586791 586791 Smyth, John, of Bydeford, merchant 0
4961209 2345319 2345319 defendant Dollyng John husbandman 586791 586791 Dollyng, John, of Bydeford, husbandman 0
4961210 2345319 2345319 defendant Potell Radulpha widow 586791 586791 Potell, Radulpha, of Bydeford, widow 1
4985696 2352637 2352637 defendant Cresseman John baker 586791 586791 Cresseman, John, of Bydeford, baker 2
5029054 2365369 2365369 defendant Fauconer John falconer 586791 586791 Fauconer, John, of Bydeford, falconer 1
5036101 2367410 2367410 plaintiff Smyth John   586791 586791 Smyth, John, of Bydeford 3
5044243 2369907 2369907 defendant Adam John smith 586791 586791 Adam, John, of Bydeford, smith 2
5072448 2378247 2378247 defendant Wydeslade Robert merchant 586791 586791 Wydeslade, Robert, of Bydeford, merchant 0
5072517 2378266 2378266 defendant Wodewill Richard husbandman 586791 586791 Wodewill, Richard, of Bydeford, husbandman 0
5107689 2388682 2388682 defendant Geryng Geoffrey butcher 586791 586791 Geryng, Geoffrey, of Bydeford, butcher 0
5107691 2388682 2388682 defendant Stete Edward mariner 586791 586791 Stete, Edward, of Bydeford, mariner 2
5216579 2420579 2420579 defendant Aps John esq 586791 586791 Aps, John, of Bydeford, esq 1
5254460 2431518 2431518 defendant Collys Thomas chaplain 586791 586791 Collys, Thomas, of Bydeford, chaplain 0
5254461 2431518 2431518 defendant Collys Arnold shoemaker 586791 586791 Collys, Arnold, of Bydeford, shoemaker 1
5254462 2431518 2431518 defendant Collys Henry shoemaker 586791 586791 Collys, Henry, of Bydeford, shoemaker 2
5254463 2431518 2431518 defendant Collys William tucker 586791 586791 Collys, William, of Bydeford, tucker 3
5282560 2439961 2439961 defendant Holle Baldwin husbandman 586791 586791 Holle, Baldwin, of Bydeford, husbandman 0
5296105 2443851 2443851 defendant Yeo John gent 586791 586791 Yeo, John, of Bydeford, gent 0
5302970 2445877 2445877 defendant Cook John merchant 586791 586791 Cook, John, of Bydeford, merchant 0
5323387 2452071 2452071 plaintiff Orchard William (legal representative) 586791 586791 Orchard, William, of Bydeford, executors of 0
5323391 2452071 2452071 defendant Smyth Agnes widow 586791 586791 Smyth, Agnes, of Bydeford, widow 1
5350336 2460227 2460227 defendant Payne William husbandman 586791 586791 Payne, William, of Bydeford, husbandman 2
5392893 2473039 2473039 defendant Pollard Lewis clerk 586791 586791 Pollard, Lewis, of Bydeford, clerk 1
5392894 2473039 2473039 defendant Yeo John gent 586791 586791 Yeo, John, of Bydeford, gent 2
5392895 2473039 2473039 defendant Donet Richard shoemaker 586791 586791 Donet, Richard, of Bydeford, shoemaker 3
5406013 2476792 2476792 defendant Yeo John gent 586791 586791 Yeo, John, of Bydeford, gent 1
5406014 2476792 2476792 defendant Pollard Lewis clerk 586791 586791 Pollard, Lewis, of Bydeford, clerk 2
5406015 2476792 2476792 defendant Donet Richard   586791 586791 Donet, Richard, of Bydeford, shoe maker 3
5419041 2480622 2480622 defendant Donet Richard shoemaker 586791 586791 Donet, Richard, of Bydeford, shoemaker 0
5438004 2486303 2486303 defendant Walshe John husbandman 586791 586791 Walshe, John, of Bydeford, husbandman 0
5462083 2493551 2493551 plaintiff Pollard Lewis   586791 586791 (Pollard, Lewis, of Bydeford, rector 1
5473031 2496889 2496889 defendant Lethe John   586791 586791 Lethe, John, of Bydeford 0
5473032 2496889 2496889 defendant Pole Henry fuller 586791 586791 Pole, Henry, of Bydeford, fuller 1
5488357 2501411 2501411 defendant Forlonge William smith 586791 586791 Forlonge, William, of Bydeford, smith 0
5593347 2532898 2532898 defendant Martyn Walter husbandman 586791 586791 Martyn, Walter, of Bydeford, husbandman 0
5599594 2534763 2534763 defendant Turner William mercer 586791 586791 Turner, William, of Bydeford, mercer 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);