names

10 rows where case_id = 2337351

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4934995 2337351 2337351 plaintiff Barton William (legal representative) 586067 586067 Barton, William, of York, skinner, executors of 0
4934996 2337351 2337351 plaintiff Barton Thomas his son   (Barton, Thomas, his son 1
4934997 2337351 2337351 plaintiff Beleby Thomas chaplain, parson in choir, church of York   Beleby, Thomas, chaplain, parson in choir, church of York 2
4934998 2337351 2337351 plaintiff Bolron John chaplain   Bolron, John, chaplain 3
4934999 2337351 2337351 plaintiff Lemyng William   586067 586067 Lemyng, William, of York 4
4935000 2337351 2337351 defendant Huddersfeld John prior of Nostell Priory   Huddersfeld, John, prior of Nostell Priory 0
4935001 2337351 2337351 defendant Astirby John gent 808871 808871 Astirby, John, of Thetilthorp, Lincs, gent 1
4935002 2337351 2337351 defendant Gardevyle John cutler 586067 586067 Gardevyle, John, of York, cutler 2
4935003 2337351 2337351 defendant Grenewode John gent 632408 632408 Grenewode, John, of Threske, gent 3
4935004 2337351 2337351 defendant Crathorn John esq 816491 816491 Crathorn, John, of Crathorn in Cleveland, esq 4

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