names

17 rows where case_id = 2504495

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5498470 2504495 2504495 plaintiff Norton John knight   Norton, John, knight 0
5498471 2504495 2504495 defendant Daynell or Dayvell Thomas gent 589293 589293 Daynell or Dayvell, Thomas, of Bylton, gent 0
5498472 2504495 2504495 defendant Stokys Robert gent 793958 793958 Stokys, Robert, of Bekerton, gent 1
5498473 2504495 2504495 defendant Munkton William. Pf Bekerton yeoman   Munkton, William. Pf Bekerton, yeoman 2
5498474 2504495 2504495 defendant Hall John weaver 595707 595707 Hall, John, of Salley juxta Rypon, weaver 3
5498475 2504495 2504495 defendant Lemyng William barker 812153 812153 Lemyng, William, of Salley, barker 4
5498476 2504495 2504495 defendant Barhous William   812153 812153 Barhous, William, of Salley 5
5498477 2504495 2504495 defendant Skypton John tailor 812153 812153 Skypton, John, of Salley, tailor 6
5498478 2504495 2504495 defendant Abbot John weaver 812153 812153 Abbot, John, of Salley, weaver 7
5498479 2504495 2504495 defendant rasskell George husbandman 812153 812153 rasskell, George, of Salley, husbandman 8
5498480 2504495 2504495 defendant Kyng William laborer 812153 812153 Kyng, William, of Salley, laborer 9
5498481 2504495 2504495 defendant Wilkynson William yeoman 812153 812153 Wilkynson, William, of Salley, yeoman 10
5498482 2504495 2504495 defendant Lax John husbandman 812153 812153 Lax, John, of Salley, husbandman 11
5498483 2504495 2504495 defendant Askwyth William yeoman 812153 812153 Askwyth, William, of Salley, yeoman 12
5498484 2504495 2504495 defendant Horsman John husbandman 812153 812153 Horsman, John, of Salley, husbandman 13
5498485 2504495 2504495 defendant Wardrop Edmund laborer 812153 812153 Wardrop, Edmund, of Salley, laborer 14
5498486 2504495 2504495 defendant Walker William laborer 812153 812153 Walker, William, of Salley, laborer 15

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