names

13 rows where case_id = 2343048

✎ 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
4953601 2343048 2343048 plaintiff Skulle Walter esq   Skulle, Walter, esq 0
4953602 2343048 2343048 defendant Longeford Philip yeoman 818453 818453 Longeford, Philip, of Topesley, yeoman 0
4953603 2343048 2343048 defendant Gerald David tailor 586208 586208 Gerald, David, of Hereford, tailor 1
4953604 2343048 2343048 defendant ap Hoel Rees husbandman 796113 796113 ap Hoel, Rees, of Frome Priors, husbandman 2
4953605 2343048 2343048 defendant Pelpottes Mathew husbandman 823456 823456 Pelpottes, Mathew, of Luyde, husbandman 3
4953606 2343048 2343048 defendant ap Thomas John husbandman 826786 826786 ap Thomas, John, of Kings Peon, husbandman 4
4953607 2343048 2343048 defendant Tyler Hugh husbandman 826786 826786 Tyler, Hugh, of Kings Peon, husbandman 5
4953608 2343048 2343048 defendant Wotton Alexander husbandman 826786 826786 Wotton, Alexander, of Kings Peon, husbandman 6
4953609 2343048 2343048 defendant Whitter William husbandman 826786 826786 Whitter, William, of Kings Peon, husbandman 7
4953610 2343048 2343048 defendant Wynston John gent 592031 592031 Wynston, John, of Madley, gent 8
4953611 2343048 2343048 defendant de la Feld Alice widow 592031 592031 de la Feld, Alice, of Madley, widow 9
4953612 2343048 2343048 defendant Gough John (legal representative)   Gough, John, administratrix of 10
4953613 2343048 2343048 defendant Gough Alice widow 599414 599414 Gough, Alice, of Lemster, widow 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);