names

11 rows where case_id = 2216178

✎ 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
4550760 2216178 2216178 plaintiff Dennyng John     Dennyng, John 0
4550761 2216178 2216178 defendant Keynes John   762302 762302 Keynes, John, of Wynkele 0
4550762 2216178 2216178 defendant (not given) John his son   John, his son 1
4550763 2216178 2216178 defendant Bukke Robert   603556 603556 Bukke, Robert, of Gydesham 2
4550764 2216178 2216178 defendant Gray John   586036 586036 Gray, John, of Exeter 3
4550765 2216178 2216178 defendant Wilford William   586036 586036 Wilford, William, of Exeter 4
4550766 2216178 2216178 defendant Shappelegh of Exeter     Shappelegh, of Exeter 5
4550767 2216178 2216178 defendant Oke William   586036 586036 Oke, William, of Exeter 6
4550768 2216178 2216178 defendant Talbot John   586036 586036 Talbot, John, of Exeter 7
4550769 2216178 2216178 defendant Skam John   586036 586036 Skam, John, of Exeter 8
4550770 2216178 2216178 defendant Tyrel Isabel formerly wife of Henry   Tyrel, Isabel, formerly wife of Henry 9

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