names

6 rows where case_id = 2211734

✎ 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
4536622 2211734 2211734 plaintiff Stayndrop Thomas (legal representative) 770581 770581 Stayndrop, Thomas, of Exeter, canon, executors of 0
4536623 2211734 2211734 plaintiff Lugans John master & canon of the cathedral church 586036 586036 (Lugans, John, of Exeter, master & canon of the cathedral church 1
4536624 2211734 2211734 plaintiff Menel Robert shield bearer   Menel, Robert, shield bearer 2
4536625 2211734 2211734 plaintiff Aller John   767196 767196 Aller, John, of Clist St George, parson 3
4536626 2211734 2211734 plaintiff Crosse Henry clerk   Crosse, Henry, clerk 4
4536627 2211734 2211734 defendant Thorn John son & heir of Henry   Thorn, John, son & heir of Henry 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);