names

4 rows where case_id = 1911927

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655334 1911927 1911927 plaintiff (not given) William prior of Bolton 585869 585869 Bolton, William, of London, prior of the priory and church of St Bartholomew, West Smithfeld, successor to William Eny 0
3655335 1911927 1911927 defendant Gayton Robert (legal representative) 585869 585869 Gayton, Robert, of London, gent, executors of 0
3655336 1911927 1911927 defendant Chamberleyn Edward gent 586594 586594 (Chamberleyn, Edward, of Stratford at Bowe, Middx, gent 1
3655337 1911927 1911927 defendant Chamberleyn Joan formerly wife of Robert   Joan, his wife, formerly wife of Robert 2

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