names

14 rows where case_id = 2137027

✎ 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
4319772 2137027 2137027 plaintiff Rocliffe Robert (legal representative)   Rocliffe, Robert, executors of 0
4319773 2137027 2137027 plaintiff Browne William     (Browne, William 1
4319774 2137027 2137027 defendant Stephenson John (legal representative)   Stephenson, John, executor of 0
4319775 2137027 2137027 defendant Stephenson John husbandman 736454 736454 Stephenson, John, of Asenby, husbandman 1
4319776 2137027 2137027 defendant Kaye Henry (legal representative) 736454 736454 Kaye, Henry, of Asenby, yeoman, executors of 2
4319777 2137027 2137027 defendant Hastwayte Richard husbandman 736454 736454 (Hastwayte, Richard, of Asenby, husbandman 3
4319778 2137027 2137027 defendant Kaye William yeoman 736456 736456 Kaye, William, of Asenbye, yeoman 4
4319779 2137027 2137027 defendant Kay Ralph yeoman 736454 736454 Kay, Ralph, of Asenby, yeoman 5
4319780 2137027 2137027 defendant Kaye Jane spinster 736456 736456 Kaye, Jane, of Asenbye, spinster 6
4319781 2137027 2137027 defendant Kaye Elizabeth spinster 736456 736456 Kaye, Elizabeth, of Asenbye, spinster 7
4319782 2137027 2137027 defendant Sowerby Thomas (legal representative) 736458 736458 Sowerby, Thomas, of Dishforth, yeoman, executors of 8
4319783 2137027 2137027 defendant Sowerbye Thomas husbandman 736458 736458 (Sowerbye, Thomas, of Dishforth, husbandman 9
4319784 2137027 2137027 defendant Jackson William husbandman 735961 735961 Jackson, William, of Topliff, husbandman 10
4319785 2137027 2137027 defendant Forrest Thomas husbandman 586143 586143 Forrest, Thomas, of Norton, husbandman 11

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