names

9 rows where case_id = 1977174

✎ 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
3861031 1977174 1977174 plaintiff Elyot Gilbert     Elyot, Gilbert 0
3861032 1977174 1977174 defendant Braylyford Roger yeoman 625849 625849 Braylyford, Roger, of Tupton, yeoman 0
3861033 1977174 1977174 defendant Braylyford Thomas husbandman 625849 625849 Braylyford, Thomas, of Tupton, husbandman 1
3861034 1977174 1977174 defendant Reyley John husbandman 625849 625849 Reyley, John, of Tupton, husbandman 2
3861035 1977174 1977174 defendant Reyley Thomas husbandman 625849 625849 Reyley, Thomas, of Tupton, husbandman 3
3861036 1977174 1977174 defendant Cley John husbandman 641358 641358 Cley, John, of Hollyns, husbandman 4
3861037 1977174 1977174 defendant Cley Thomas laborer 641358 641358 Cley, Thomas, of Hollyns, laborer 5
3861038 1977174 1977174 defendant Cley Elizabeth spinster 641358 641358 Cley, Elizabeth, of Hollyns, spinster 6
3861039 1977174 1977174 defendant Clay Alice spinster 641358 641358 Clay, Alice, of Hollyns, spinster 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);