names

11 rows where case_id = 2229262

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4593559 2229262 2229262 plaintiff Pays John (legal representative) 585869 585869 Pays, John, of London, draper, executors of 0
4593560 2229262 2229262 plaintiff Eyleston John     (Eyleston, John 1
4593561 2229262 2229262 plaintiff Eyleston Denisa     Denisa, his wife 2
4593562 2229262 2229262 defendant Cocowe John carpenter 772829 772829 Cocowe, John, of Catewade, carpenter 0
4593563 2229262 2229262 defendant Pays Richard   587249 587249 Pays, Richard, of Chelmesford 1
4593564 2229262 2229262 defendant Depedale John     Depedale, John 2
4593565 2229262 2229262 defendant Risacle Lawrence mason   Risacle, Lawrence, mason 3
4593566 2229262 2229262 defendant Bailly John     Bailly, John 4
4593567 2229262 2229262 defendant Bellowe John (legal representative) 601768 601768 Bellowe, John, of Harowe, executor of 5
4593568 2229262 2229262 defendant Bellowe John   601768 601768 Bellowe, John, of Harowe 6
4593569 2229262 2229262 defendant Neuman Thomas   654460 654460 Neuman, Thomas, of St John Street 7

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