names

16 rows where case_id = 1917559

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672969 1917559 1917559 plaintiff Dudley Richard clerk   Dudley, Richard, clerk 0
3672970 1917559 1917559 plaintiff Dudley George clerk   Dudley, George, clerk 1
3672971 1917559 1917559 plaintiff Long Henry knight   Long, Henry, knight 2
3672972 1917559 1917559 plaintiff Wrattersley Richard esq   Wrattersley, Richard, esq 3
3672973 1917559 1917559 plaintiff Wrattesley Walter gent   Wrattesley, Walter, gent 4
3672974 1917559 1917559 plaintiff Dudley John son of Dudley, Guy   Dudley, John, son of Dudley, Guy 5
3672975 1917559 1917559 plaintiff Didley John esq 587352 587352 Didley, John, of Aston, esq 6
3672976 1917559 1917559 plaintiff Sutton Robert esq   Sutton, Robert, esq 7
3672977 1917559 1917559 plaintiff Beamount James gent   Beamount, James, gent 8
3672978 1917559 1917559 plaintiff Hussey Giles     Hussey, Giles 9
3672979 1917559 1917559 plaintiff Denton Thomas     Denton, Thomas 10
3672980 1917559 1917559 plaintiff Sutton Henry     Sutton, Henry 11
3672981 1917559 1917559 plaintiff Bawde John     Bawde, John 12
3672982 1917559 1917559 plaintiff Gillam Thomas     Gillam, Thomas 13
3672983 1917559 1917559 plaintiff Harres John     Harres, John 14
3672984 1917559 1917559 defendant Hussey John   608272 608272 Hussey, John, of Slyfford, Lincs, knight 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);