names

7 rows where case_id = 2436405

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5270264 2436405 2436405 plaintiff (not given) Richard prior of de Ledes 878643 878643 de Ledes, Richard, of Monk Bretton, prior of the Monastery, of BM Magdalene 0
5270265 2436405 2436405 defendant Boswell Thomas   866604 866604 Boswell, Thomas, of Ardesley by Derfeld, esq, son & heir of William Bosewell 0
5270266 2436405 2436405 defendant Parker William smith 637137 637137 Parker, William, of Pontefracte, smith 1
5270267 2436405 2436405 defendant Pachet Thomas husbandman 866605 866605 Pachet, Thomas, of Deryngton, by Wentbrigge, husbandman 2
5270268 2436405 2436405 defendant Herdegate Robert husbandman 845851 845851 Herdegate, Robert, of Hykylton, husbandman 3
5270269 2436405 2436405 defendant Middelton Robert chaplain   Middelton, Robert, chaplain, administrator of 4
5270270 2436405 2436405 defendant Hogekynson Thomas husbandman 757831 757831 Hogekynson, Thomas, of Kirk Smeton, husbandman 5

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