names

14 rows where case_id = 2225670

✎ 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
4581495 2225670 2225670 plaintiff (not given)   bishop of Durham   Durham, bishop of 0
4581496 2225670 2225670 defendant Sergeant John   632496 632496 Sergeant, John, of Wresyll 0
4581497 2225670 2225670 defendant Walker Thomas   632496 632496 Walker, Thomas, of Wresyll 1
4581498 2225670 2225670 defendant Houton Thomas   632496 632496 Houton, Thomas, of Wresyll 2
4581499 2225670 2225670 defendant Baker John   632496 632496 Baker, John, of Wresyll 3
4581500 2225670 2225670 defendant Freman John   632496 632496 Freman, John, of Wresyll 4
4581501 2225670 2225670 defendant Gilbeson Robert     Gilbeson, Robert 5
4581502 2225670 2225670 defendant Fyssher Robert   632496 632496 Fyssher, Robert, of Wresyll 6
4581503 2225670 2225670 defendant Ward Richard   632496 632496 Ward, Richard, of Wresyll 7
4581504 2225670 2225670 defendant Milner William   632496 632496 Milner, William, of Wresyll 8
4581505 2225670 2225670 defendant Barde John   632496 632496 Barde, John, of Wresyll 9
4581506 2225670 2225670 defendant Boythorp William   632496 632496 Boythorp, William, of Wresyll 10
4581507 2225670 2225670 defendant Marynell William   632496 632496 Marynell, William, of Wresyll 11
4581508 2225670 2225670 defendant Rayner Richard   632496 632496 Rayner, Richard, of Wresyll 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);