names

8 rows where case_id = 2512672

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5525834 2512672 2512672 plaintiff Hert William, senior (legal representative) 595094 595094 Hert, William, senior, of Flete Strete, St Dunstan in the West, gent, master of tailors Guild, executor of 0
5525835 2512672 2512672 plaintiff Hert John, senior     Hert, John, senior 1
5525836 2512672 2512672 defendant Westell Humphrey pulter or brewer 586528 586528 Westell, Humphrey, of Ware, Herts, pulter or brewer 0
5525837 2512672 2512672 defendant Welby William gent 636644 636644 Welby, William, of Welby, Lincs, gent 1
5525838 2512672 2512672 defendant Darnold Richard gent 585869 585869 Darnold, Richard, of London, gent 2
5525839 2512672 2512672 defendant Darnold Joan widow of Haryson, Thomas, pewterer   Joan his wife, widow of Haryson, Thomas, pewterer 3
5525840 2512672 2512672 defendant Blount Edward esq 602564 602564 Blount, Edward, of Sedyngton, Worcs, esq 4
5525841 2512672 2512672 defendant Bawede John gent 591603 591603 Bawede, John, of Chesterford, Essex, gent 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);