names

16 rows where case_id = 2440331

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5283929 2440331 2440331 plaintiff FitzWilliam Richard sheriff of Lincs   FitzWilliam, Richard, sheriff of Lincs 0
5283930 2440331 2440331 defendant Petyte Thomas yeoman 589517 589517 Petyte, Thomas, of Wyntryngham, yeoman 0
5283931 2440331 2440331 defendant Spenythorn John yeoman 589517 589517 Spenythorn, John, of Wyntryngham, yeoman 1
5283932 2440331 2440331 defendant Cartwrite John yeoman 589517 589517 Cartwrite, John, of Wyntryngham, yeoman 2
5283933 2440331 2440331 defendant Pyburn Thomas yeoman 589517 589517 Pyburn, Thomas, of Wyntryngham, yeoman 3
5283934 2440331 2440331 defendant Trougton William yeoman 589517 589517 Trougton, William, of Wyntryngham, yeoman 4
5283935 2440331 2440331 defendant Bermyngham Richard yeoman 599508 599508 Bermyngham, Richard, of Repynghale, yeoman 5
5283936 2440331 2440331 defendant Whasshe John husbandman 868513 868513 Whasshe, John, of Spitell on le Strete, husbandman 6
5283937 2440331 2440331 defendant Whyte John yeoman 868514 868514 Whyte, John, of Welby juxa Ancastre, yeoman 7
5283938 2440331 2440331 defendant Watson Richard husbandman 634596 634596 Watson, Richard, of Welby, husbandman 8
5283939 2440331 2440331 defendant Skelton William husbandman 588269 588269 Skelton, William, of Burnby, husbandman 9
5283940 2440331 2440331 defendant Tebbe Richard husbandman 765096 765096 Tebbe, Richard, of Crosseby, husbandman 10
5283941 2440331 2440331 defendant Tayllour Robert husbandman 624750 624750 Tayllour, Robert, of Bysshop Norton, husbandman 11
5283942 2440331 2440331 defendant Tayllour John yeoman 590197 590197 Tayllour, John, of Cokeryngton, yeoman 12
5283943 2440331 2440331 defendant Tompson Robert husbandman 774981 774981 Tompson, Robert, of Dodythorp, husbandman 13
5283944 2440331 2440331 defendant Bethome Robert yeoman 868515 868515 Bethome, Robert, of Lessyngton, yeoman 14

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