names

9 rows where case_id = 2535600

✎ 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
5602256 2535600 2535600 plaintiff Marney Henry knight, chancellor, Duchy of Lancaster   Marney, Henry, knight, chancellor, Duchy of Lancaster 0
5602257 2535600 2535600 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 1
5602258 2535600 2535600 plaintiff Englefeld Thomas knight   Englefeld, Thomas, knight 2
5602259 2535600 2535600 defendant Parker Henry gent 904771 904771 Parker, Henry, of Cloughton, Yorks, gent 0
5602260 2535600 2535600 defendant Vaughan John Lloid esq 904772 904772 Vaughan, John Lloid, of Maynerbere, Penbroch, esq 1
5602261 2535600 2535600 defendant Harbarde John gent 904773 904773 Harbarde, John, of Laghame, Karnarven, gent 2
5602262 2535600 2535600 defendant Lloide Maurice esq 904774 904774 Lloide, Maurice, of Llanstephan, Karnarven, esq 3
5602263 2535600 2535600 defendant Rede Nicholas gent 904775 904775 Rede, Nicholas, of Maynorgayne, Karnarven, gent 4
5602264 2535600 2535600 defendant Baret William gent 904776 904776 Baret, William, of Pendene, Karnarven, gent 5

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