names

4 rows where case_id = 2135721

✎ 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
4316033 2135721 2135721 plaintiff Hynton William, senior (legal representative)   Hynton, William, senior, administrator of 0
4316034 2135721 2135721 plaintiff Hynton Anthony esq, administrator during minority of William Hynton, junior, son and   Hynton, Anthony, esq, administrator during minority of William Hynton, junior, son and executor of William senior 1
4316035 2135721 2135721 defendant Deverell Henry yeoman 607277 607277 Deverell, Henry, of Marlebrough, or of Bunger , Melsham, yeoman 0
4316036 2135721 2135721 defendant Curtys John yeoman 607277 607277 Curtys, John, of Marlebrough, or of Bunger, Mylsham, yeoman 1

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