names

6 rows where case_id = 2331926

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4917316 2331926 2331926 plaintiff Fyshere John     Fyshere, John 0
4917317 2331926 2331926 defendant Horewyll William   821704 821704 Horewyll, William, of Pedewyll by Asshecote, corn hukker or corn dealer 0
4917318 2331926 2331926 defendant Knyght John butcher 590512 590512 Knyght, John, of Welyngton, butcher 1
4917319 2331926 2331926 defendant Kene Lawrence drover 596517 596517 Kene, Lawrence, of Cumere, drover 2
4917320 2331926 2331926 defendant Cammell William (legal representative) 585996 585996 Cammell, William, of Briggewater, butcher, executors of 3
4917321 2331926 2331926 defendant Willyam Thomas husbandman 804265 804265 Willyam, Thomas, of Chedesey, husbandman 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);