names

12 rows where case_id = 2186186

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4453747 2186186 2186186 plaintiff (not given)   Abbot of Leyston   Leyston, Abbot of 0
4453748 2186186 2186186 defendant Bertelot Richard   754324 754324 Bertelot, Richard, of Snapes 0
4453749 2186186 2186186 defendant Poreman John tailor   Poreman, John, tailor 1
4453750 2186186 2186186 defendant Thacchere Randolf le   754324 754324 Thacchere, Randolf le, of Snapes 2
4453751 2186186 2186186 defendant Dondale Thomas     Dondale, Thomas 3
4453752 2186186 2186186 defendant Fraunceys John     Fraunceys, John 4
4453753 2186186 2186186 defendant Palmere William le     Palmere, William le 5
4453754 2186186 2186186 defendant Deye Henry le     Deye, Henry le 6
4453755 2186186 2186186 defendant Sprunt Alexander   646867 646867 Sprunt, Alexander, of Saxmundham 7
4453756 2186186 2186186 defendant Gosson John     Gosson, John 8
4453757 2186186 2186186 defendant Peroun John   646867 646867 Peroun John, of Saxmundham 9
4453758 2186186 2186186 defendant Chambyrleyn Robert   597185 597185 together with Chambyrleyn, Robert, of Freston 10

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