names

14 rows where case_id = 2225669

✎ 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
4581481 2225669 2225669 plaintiff (not given)   bishop of Durham   Durham, bishop of 0
4581482 2225669 2225669 defendant Sergeant John   609634 609634 Sergeant, John, of Wresill 0
4581483 2225669 2225669 defendant Walker Thomas   632496 632496 Walker, Thomas, of Wresyll 1
4581484 2225669 2225669 defendant Houton Thomas   632496 632496 Houton, Thomas, of Wresyll 2
4581485 2225669 2225669 defendant Barker John   632496 632496 Barker, John, of Wresyll 3
4581486 2225669 2225669 defendant Freman John   632496 632496 Freman, John, of Wresyll 4
4581487 2225669 2225669 defendant Gibbeson Robert   632496 632496 Gibbeson, Robert, of Wresyll 5
4581488 2225669 2225669 defendant Fyssher Robert   632496 632496 Fyssher, Robert, of Wresyll 6
4581489 2225669 2225669 defendant Ward Richard   632496 632496 Ward, Richard, of Wresyll 7
4581490 2225669 2225669 defendant Milner William   632496 632496 Milner, William, of Wresyll 8
4581491 2225669 2225669 defendant Warde John   632496 632496 Warde, John, of Wresyll 9
4581492 2225669 2225669 defendant Boythorp William   632496 632496 Boythorp, William, of Wresyll 10
4581493 2225669 2225669 defendant Marynell William   632496 632496 Marynell, William, of Wresyll 11
4581494 2225669 2225669 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);