names

16 rows where case_id = 2208279

✎ 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
4525384 2208279 2208279 plaintiff Jaan Stephen     Jaan, Stephen 0
4525385 2208279 2208279 defendant Benalek Philip     Benalek, Philip 0
4525386 2208279 2208279 defendant Carthu John     Carthu, John 1
4525387 2208279 2208279 defendant Croke John     Croke, John 2
4525388 2208279 2208279 defendant Bogef Reginald     Bogef, Reginald 3
4525389 2208279 2208279 defendant Pye John     Pye, John 4
4525390 2208279 2208279 defendant Malkyn John     Malkyn, John 5
4525391 2208279 2208279 defendant Gardyner Nicholas     Gardyner, Nicholas 6
4525392 2208279 2208279 defendant Hykke John   766182 766182 Hykke, John, of Branel 7
4525393 2208279 2208279 defendant Fotour Nicholas     Fotour, Nicholas 8
4525394 2208279 2208279 defendant Jaky John     Jaky, John 9
4525395 2208279 2208279 defendant Beryn John     Beryn, John 10
4525396 2208279 2208279 defendant Trenevyan John     Trenevyan, John 11
4525397 2208279 2208279 defendant Nody Oliver     Nody, Oliver 12
4525398 2208279 2208279 defendant Smyth Philip   599163 599163 Smyth, Philip, of St Austell 13
4525399 2208279 2208279 defendant Seke Roger     Seke, Roger 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);