names

10 rows where case_id = 2193696

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4477710 2193696 2193696 plaintiff Hakome Thomas   586067 586067 Hakome, Thomas, of York 0
4477711 2193696 2193696 defendant del Asshe Richard     del Asshe, Richard 0
4477712 2193696 2193696 defendant Appelby Robert     Appelby, Robert 1
4477713 2193696 2193696 defendant Carpenter Bernard   758933 758933 Carpenter, Bernard, of Brymeston 2
4477714 2193696 2193696 defendant Laxe Richard     Laxe, Richard 3
4477715 2193696 2193696 defendant Balle John   758298 758298 Balle, John, of Derbyshire 4
4477716 2193696 2193696 defendant Broune Richard   760690 760690 Broune, Richard, of Balderby 5
4477717 2193696 2193696 defendant Tanfeld John   761289 761289 Tanfeld, John, of Difford 6
4477718 2193696 2193696 defendant Mercer William   761290 761290 Mercer, William, of Midelha 7
4477719 2193696 2193696 defendant Marchall William   761291 761291 Marchall, William, of Effyngwald 8

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