names

8 rows where case_id = 2516398

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5538071 2516398 2516398 plaintiff Deynman Thomas doctor of medicine, master of St Mary of Bethlehem, Bisshopsgate, London   Deynman, Thomas, doctor of medicine, master of St Mary of Bethlehem, Bisshopsgate, London, executors of 0
5538072 2516398 2516398 plaintiff Pye William     (Pye, William 1
5538073 2516398 2516398 plaintiff Darley Brian     Darley, Brian 2
5538074 2516398 2516398 defendant Curwen John clerk 586067 586067 Curwen, John, of York, clerk 0
5538075 2516398 2516398 defendant Trodys William chaplain 585869 585869 Trodys, William, of London, chaplain 1
5538076 2516398 2516398 defendant Warde John poulter 585869 585869 Warde, John, of London, poulter 2
5538077 2516398 2516398 defendant Duston Ralph pardoner 897689 897689 Duston, Ralph, of St John, West Smythfeld, Middx, pardoner 3
5538078 2516398 2516398 defendant Milles John tailor 616613 616613 Milles, John, of Hawsted, Essex, tailor 4

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