names

15 rows where case_id = 2202492

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4506368 2202492 2202492 plaintiff Thame John knight   Thame, John, knight 0
4506369 2202492 2202492 plaintiff Kynnesman Stephen     Kynnesman, Stephen, on their own account 1
4506370 2202492 2202492 defendant Trussell John knight   Trussell, John, knight 0
4506371 2202492 2202492 defendant (not given) John his son   John, his son 1
4506372 2202492 2202492 defendant Cristman William     Cristman, William 2
4506373 2202492 2202492 defendant Warker John   606860 606860 Warker, John, of Flore 3
4506374 2202492 2202492 defendant Warner Thomas   606860 606860 Warner, Thomas, of Flore 4
4506375 2202492 2202492 defendant Peverey Thomas Lyne, Robert   Peverey, Thomas, Lyne, Robert 5
4506376 2202492 2202492 defendant Smyth Nicholas   606860 606860 Smyth, Nicholas, of Flore 6
4506377 2202492 2202492 defendant Carter Thomas   606860 606860 Carter, Thomas, of Flore 7
4506378 2202492 2202492 defendant Cooke John   764473 764473 Cooke, John, of Flore, Taillour, ---, of Flore 8
4506379 2202492 2202492 defendant Boteler John   606860 606860 Boteler, John, of Flore 9
4506380 2202492 2202492 defendant Lay William     Lay, William 10
4506381 2202492 2202492 defendant Munk John   606860 606860 Munk, John, of Flore 11
4506382 2202492 2202492 defendant Stowe John   606860 606860 Stowe, John, of Flore 12

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