names

7 rows where case_id = 2374145

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5058637 2374145 2374145 plaintiff de la Pole Alice Duchess of Suffolk, widow of de la Pole, William   de la Pole, Alice, Duchess of Suffolk, widow of de la Pole, William 0
5058638 2374145 2374145 defendant Hoke Richard fisher 586207 586207 Hoke, Richard, of Basyngstoke, fisher 0
5058639 2374145 2374145 defendant Dyker John yeoman 841403 841403 Dyker, John, of North Ocley, yeoman 1
5058640 2374145 2374145 defendant Fox William barber 586207 586207 Fox, William, of Basyngstoke, barber 2
5058641 2374145 2374145 defendant Cowfold William gent 832514 832514 Cowfold, William, of Cowyche, gent 3
5058642 2374145 2374145 defendant Waterende John gent 586207 586207 Waterende, John, of Basyngstoke, gent 4
5058643 2374145 2374145 defendant Grygge John gent 839023 839023 Grygge, John, of Upnatele, 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);