names

12 rows where case_id = 1960296

✎ 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
3807677 1960296 1960296 plaintiff Wyatt Henry knight, treasurer of the chamber   Wyatt, Henry, knight, treasurer of the chamber 0
3807678 1960296 1960296 plaintiff Englefild Thomas justice   Englefild, Thomas, justice 1
3807679 1960296 1960296 plaintiff Dauncy John knight   Dauncy, John, knight 2
3807680 1960296 1960296 plaintiff Lyster Richard chief baron of Exchequer   Lyster, Richard, chief baron of Exchequer 3
3807681 1960296 1960296 defendant Throkmarton George   597277 597277 Throkmarton, George, of Coughton, Warks, knight 0
3807682 1960296 1960296 defendant Mordaunt John   585869 585869 Mordaunt, John, of London, knight 1
3807683 1960296 1960296 defendant Knyghtley Richard esq 632634 632634 Knyghtley, Richard, of Falley, Nhants, esq 2
3807684 1960296 1960296 defendant Arden Thomas esq 600771 600771 Arden, Thomas, of Aston, Warks, esq 3
3807685 1960296 1960296 defendant Parrys Philip esq 632635 632635 Parrys, Philip, of Lytill Lytton, Cams, esq 4
3807686 1960296 1960296 defendant Hynde John gent 631596 631596 Hynde, John, of Maddyngley, Cams, gent 5
3807687 1960296 1960296 defendant Hutton Thomas esq 632636 632636 Hutton, Thomas, of Harreton, Cams, esq 6
3807688 1960296 1960296 defendant Higham Richard gent 602073 602073 Higham, Richard, of Roydon, Essex, gent 7

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