names

11 rows where case_id = 2212439

✎ 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
4538898 2212439 2212439 plaintiff Typendenne Thomas     Typendenne, Thomas 0
4538899 2212439 2212439 defendant Wythrendenne Henry     Wythrendenne, Henry 0
4538900 2212439 2212439 defendant Snothe Edmund     Snothe, Edmund 1
4538901 2212439 2212439 defendant att Capell Richard     att Capell, Richard 2
4538902 2212439 2212439 defendant Carendale John     Carendale, John 3
4538903 2212439 2212439 defendant Smyth William   596022 596022 Smyth, William, of Halden 4
4538904 2212439 2212439 defendant Pyryman Richard     Pyryman, Richard 5
4538905 2212439 2212439 defendant Birchet Adam     Birchet, Adam 6
4538906 2212439 2212439 defendant Eslegh Henry jun   Eslegh, Henry, jun 7
4538907 2212439 2212439 defendant atte Capell Stephen jun   atte Capell, Stephen, jun 8
4538908 2212439 2212439 defendant Wythrenden William Snothe, Richard   Wythrenden, William, Snothe, Richard 9

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