names

16 rows where case_id = 2219097

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4560075 2219097 2219097 plaintiff Mosse William clerk   Mosse, William, clerk 0
4560076 2219097 2219097 plaintiff Swan Walter clerk   Swan, Walter, clerk 1
4560077 2219097 2219097 plaintiff Say Robert clerk   Say, Robert, clerk 2
4560078 2219097 2219097 defendant Lathebery Alfred     Lathebery, Alfred 0
4560079 2219097 2219097 defendant (not given) John his son   John, his son 1
4560080 2219097 2219097 defendant Bradbourne Robert     Bradbourne, Robert 2
4560081 2219097 2219097 defendant Langham John     Langham, John 3
4560082 2219097 2219097 defendant Hunte William     Hunte, William 4
4560083 2219097 2219097 defendant Garlond John     Garlond, John 5
4560084 2219097 2219097 defendant Ruggeley Richard     Ruggeley, Richard 6
4560085 2219097 2219097 defendant Tichull Thomas     Tichull, Thomas 7
4560086 2219097 2219097 defendant Boturton William     Boturton, William 8
4560087 2219097 2219097 defendant Stury Henry     Stury, Henry 9
4560088 2219097 2219097 defendant Bailly Robert   769591 769591 Bailly, Robert, of Uttoxhather 10
4560089 2219097 2219097 defendant Duffeld William     Duffeld, William 11
4560090 2219097 2219097 defendant Waturhouse John     Waturhouse, John 12

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