names

13 rows where case_id = 2548014

✎ 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
5613506 2548014 2548014 plaintiff Dabernon John (legal representative) 591392 591392 Dabernon, John, of Bradeford, executors of 0
5613507 2548014 2548014 plaintiff Vaggescombe Robert   614731 614731 (Vaggescombe, Robert, of Parkham, parson 1
5613508 2548014 2548014 plaintiff Uppecote John de     Uppecote, John de 2
5613509 2548014 2548014 plaintiff Irname John     Irname, John 3
5613510 2548014 2548014 plaintiff Cokyn Henry   905955 905955 Cokyn, Henry, of Lostewythiel 4
5613511 2548014 2548014 plaintiff Isak John     Isak, John 5
5613512 2548014 2548014 plaintiff Waleys John     Waleys, John 6
5613513 2548014 2548014 plaintiff Treludek William     Treludek, William 7
5613514 2548014 2548014 plaintiff atte fursen Thomas     atte fursen, Thomas 8
5613515 2548014 2548014 plaintiff Cabernon John son of Robert, senior   Cabernon, John, son of Robert, senior 9
5613516 2548014 2548014 plaintiff Hobyn John     Hobyn, John 10
5613517 2548014 2548014 plaintiff Gerveys James     Gerveys, James 11
5613518 2548014 2548014 defendant Parson Humprey   905956 905956 Parson, Humprey, of Plymouth` 0

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