names

35 rows where place_id = 820455

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4909680 2329557 2329557 defendant Yeme Peter carpenter 820455 820455 Yeme, Peter, of Earls Plympton, carpenter 0
4911646 2330144 2330144 defendant Hogge Stephen husbandman 820455 820455 Hogge, Stephen, of Earls Plympton, husbandman 2
4911648 2330145 2330145 defendant Hogge Stephen husbandman 820455 820455 Hogge, Stephen, of Earls Plympton, husbandman 0
4917368 2331946 2331946 defendant Yeme Peter carpenter 820455 820455 Yeme, Peter, of Earls Plympton, carpenter 0
4917369 2331946 2331946 defendant Bokeler William husbandman 820455 820455 Bokeler, William, of Earls Plympton, husbandman 1
4917371 2331946 2331946 defendant Terys Peter skinner 820455 820455 Terys, Peter, of Earls Plympton, skinner 3
4927864 2335150 2335150 defendant Elyot John tailor 820455 820455 Elyot, John, of Earls Plympton, tailor 0
4927871 2335152 2335152 defendant Silverlok John yeoman 820455 820455 Silverlok, John, of Earls Plympton, yeoman 0
4927954 2335174 2335174 defendant Sperkwyk Richard husbandman 820455 820455 Sperkwyk, Richard, of Earls Plympton, husbandman 1
4932905 2336681 2336681 defendant Lucas John shoemaker 820455 820455 Lucas, John, of Earls Plympton, shoemaker 0
4933349 2336816 2336816 defendant Brokyng Richard smith 820455 820455 with Brokyng, Richard, of Earls Plympton, smith 1
4933350 2336816 2336816 defendant Lukys John shoemaker 820455 820455 Lukys, John, of Earls Plympton, shoemaker 2
4989739 2353847 2353847 defendant Wylyam Lawrence butcher 820455 820455 Wylyam, Lawrence, of Earls Plympton, butcher 0
5041059 2368952 2368952 defendant Peke William merchant 820455 820455 Peke, William, of Earls Plympton, merchant 0
5041060 2368952 2368952 defendant Dobyn of Dovyn John husvandman 820455 820455 Dobyn of Dovyn, John, of Earls Plympton, husvandman 1
5042480 2369356 2369356 defendant Serle John gent 820455 820455 with Serle, John, of Earls Plympton, gent 1
5043778 2369766 2369766 defendant Ayssheman Thomas merchant 820455 820455 Ayssheman, Thomas, of Earls Plympton, merchant 0
5045012 2370139 2370139 defendant Tabyn alias Dobyn John merchant 820455 820455 Tabyn alias Dobyn, John, of Earls Plympton, merchant 0
5048347 2371139 2371139 defendant Tabyn or Tavy John merchant 820455 820455 Tabyn or Tavy, John, of Earls Plympton, merchant 1
5048348 2371139 2371139 defendant Weyman William tanner 820455 820455 Weyman, William, of Earls Plympton, tanner 2
5048597 2371223 2371223 plaintiff Roos Peter (legal representative) 820455 820455 Roos, Peter, of Earls Plympton, executors of 0
5048926 2371312 2371312 defendant Wyot John chapman 820455 820455 Wyot, John, of Earls Plympton, chapman 0
5052003 2372212 2372212 defendant Heryng John gent 820455 820455 Heryng, John, of Earls Plympton, gent 0
5052052 2372225 2372225 defendant Apperorre John   820455 820455 Apperorre, John, of Earls Plympton, bailiff 0
5137480 2397473 2397473 defendant Dray John fuller 820455 820455 Dray, John, of Earls Plympton, fuller 0
5178424 2409398 2409398 defendant Quynterell Margery widow 820455 820455 Quynterell, Margery, of Earls Plympton, widow 0
5198849 2415415 2415415 defendant Serle John gent 820455 820455 Serle, John, of Earls Plympton, gent 0
5371706 2466738 2466738 defendant Pyke William yeoman 820455 820455 Pyke, William, of Earls Plympton, yeoman 0
5386370 2471169 2471169 defendant Parker John yeoman 820455 820455 Parker, John, of Earls Plympton, yeoman 0
5386371 2471169 2471169 defendant Selman William yeoman 820455 820455 Selman, William, of Earls Plympton, yeoman 1
5398616 2474666 2474666 defendant (illegible) John yeoman 820455 820455 ---, John, of Earls Plympton, yeoman 0
5398617 2474666 2474666 defendant Selman (illegible) yeoman 820455 820455 Selman, ----, of Earls Plympton, yeoman 1
5407817 2477314 2477314 defendant Bray John yeoman 820455 820455 Bray, John, of Earls Plympton, yeoman 0
5411742 2478464 2478464 defendant P_ John yeoman 820455 820455 P_, John, of Earls Plympton, yeoman 0
5421023 2481219 2481219 defendant Bray John yeoman 820455 820455 Bray, John, of Earls Plympton, yeoman 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);