names

7 rows where case_id = 2356673

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4999337 2356673 2356673 plaintiff Lasselles William archdeacon of Huntingdon, and residentary canon in the cathedral church of the BM, in Lincoln   Lasselles, William, archdeacon of Huntingdon, and residentary canon in the cathedral church of the BM, in Lincoln, executors of 0
4999338 2356673 2356673 plaintiff Stanley William     (Stanley, William 1
4999339 2356673 2356673 plaintiff Boston Robert   586846 586846 Boston, Robert, of Lincoln, vicar choral, in the cathedral church, of the BM 2
4999340 2356673 2356673 plaintiff Laceby John chaplain   Laceby, John, chaplain 3
4999341 2356673 2356673 defendant Botewryght John clerk 832966 832966 Botewryght, John, of Sqwaffham, Norf, clerk 0
4999342 2356673 2356673 defendant Elveden Robert husbandman 832967 832967 Elveden, Robert, of Schuldham, Norf, husbandman 1
4999343 2356673 2356673 defendant Elveden John   650511 650511 Elveden, John, of Hamerton, Hunts, notary 2

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