names

15 rows where case_id = 2225673

✎ 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
4581520 2225673 2225673 plaintiff (not given) Walter bishop of Durham   Durham, Walter, bishop of, executors of 0
4581521 2225673 2225673 plaintiff Weston Thomas de master & archdeacon 604337 604337 (Weston, Thomas de, of Durham, master & archdeacon 1
4581522 2225673 2225673 plaintiff Holme Richard de   771735 771735 Holme, Richard de, of Wermouth, Durham diocese, parson 2
4581523 2225673 2225673 plaintiff Wyclyf Robert   771736 771736 Wyclyf, Robert, of Rudby, Yorks, York diocese, parson 3
4581524 2225673 2225673 plaintiff Newerke Alan   771737 771737 Newerke, Alan, of Langchestre, Durham diocese, canon of the collegiate college 4
4581525 2225673 2225673 plaintiff del Hay Peter domicellus or squire   del Hay, Peter, domicellus or squire 5
4581526 2225673 2225673 plaintiff Hildyard John     Hildyard, John 6
4581527 2225673 2225673 defendant Coke Nicholas   589626 589626 Coke, Nicholas, of Walkyngton 0
4581528 2225673 2225673 defendant Boythorp Thomas   589626 589626 Boythorp, Thomas, of Walkyngton 1
4581529 2225673 2225673 defendant Proktour John   589626 589626 Proktour, John, of Walkyngton 2
4581530 2225673 2225673 defendant Abbot Robert     Abbot, Robert 3
4581531 2225673 2225673 defendant Santon John   591310 591310 Santon, John, of Houden 4
4581532 2225673 2225673 defendant Barkere John   591310 591310 Barkere, John, of Houden 5
4581533 2225673 2225673 defendant Tayllour Thomas   589626 589626 Tayllour, Thomas, of Walkyngton 6
4581534 2225673 2225673 defendant Baillyf Robert   771738 771738 Baillyf, Robert, of Sandeholme 7

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