names

6 rows where case_id = 2548587

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5615323 2548587 2548587 plaintiff Getehill John de     Getehill, John de 0
5615324 2548587 2548587 defendant Leghton John de   906110 906110 Leghton, John de, of Dunewy-- 0
5615325 2548587 2548587 defendant Hykdon Thomas   700355 700355 Hykdon, Thomas, of Ughill 1
5615326 2548587 2548587 defendant Elot William   906111 906111 Elot, William, of Moskerboth 2
5615327 2548587 2548587 defendant Kelleslay Thomas de   700355 700355 Kelleslay, Thomas de, of Ughill 3
5615328 2548587 2548587 defendant Nautehird Thomas   662814 662814 Nautehird, Thomas, of Wollay 4

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