names

16 rows where case_id = 2195808

✎ 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
4484344 2195808 2195808 plaintiff Percy Thomas knight   Percy, Thomas, knight, on his own account 0
4484345 2195808 2195808 defendant Grancourt John, junior     Grancourt, John, junior 0
4484346 2195808 2195808 defendant Paule John     Paule, John 1
4484347 2195808 2195808 defendant Cook William   593661 593661 Cook, William, of Aldermanston 2
4484348 2195808 2195808 defendant Smyth Thomas   709774 709774 Smyth, Thomas, of Baghurst 3
4484349 2195808 2195808 defendant Frythe John   762076 762076 Frythe, John, of Bagherst 4
4484350 2195808 2195808 defendant (illegible) John chaplain   ---, John, chaplain 5
4484351 2195808 2195808 defendant Dalton Henry     Dalton, Henry 6
4484352 2195808 2195808 defendant Bechefunte Nicholas   762077 762077 Bechefunte, Nicholas, of Tadelegh 7
4484353 2195808 2195808 defendant Stacy William     Stacy, William 8
4484354 2195808 2195808 defendant Northfeld John     Northfeld, John 9
4484355 2195808 2195808 defendant (not given)   prior of Tadelegh   Tadelegh, prior of 10
4484356 2195808 2195808 defendant Spencer William   762078 762078 Spencer, William, of Beghurst 11
4484357 2195808 2195808 defendant Hurt John     Hurt, John 12
4484358 2195808 2195808 defendant Andrewe Nicholas     Andrewe, Nicholas 13
4484359 2195808 2195808 defendant S--- William     S---, William 14

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