names

5 rows where case_id = 2175348

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4433841 2175348 2175348 plaintiff Hastinges Humphrey de (legal representative) 587020 587020 Hastinges, Humphrey de, of Iseldon, prebendary of the prebend of Islington, in the church of St Paul's, London, executors of 0
4433842 2175348 2175348 plaintiff Stafford John de knight   (Stafford, John de, knight 1
4433843 2175348 2175348 plaintiff Pikstoke Thomas de clerk   Pikstoke, Thomas de, clerk 2
4433844 2175348 2175348 plaintiff White Hugh le     White, Hugh le 3
4433845 2175348 2175348 defendant Holewey Stephen   587020 587020 Holewey, Stephen, of Iseldon 0

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