names

12 rows where case_id = 1907405

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640314 1907405 1907405 defendant Audeley John   600252 600252 Audeley, John, of Wade, Hants, knight 0
3640315 1907405 1907405 defendant Wallop Robert esq 597916 597916 Wallop, Robert, of Farley, Hants, esq 1
3640316 1907405 1907405 defendant Dabriggecourt Barnard esq 600253 600253 Dabriggecourt, Barnard, of Stratfeld Saye, Hants, esq 2
3640317 1907405 1907405 defendant Pech John   600254 600254 Pech, John, of Lullyngton, Kent, knight 3
3640318 1907405 1907405 defendant Culpeper Alexander   600255 600255 Culpeper, Alexander, of Begeverey, Kent, knight 4
3640319 1907405 1907405 defendant Both Philip   600256 600256 Both, Philip, of Barham, Suff, knight 5
3640320 1907405 1907405 defendant Catesby John esq 600257 600257 Catesby, John, of Oldethorp, Nhants, esq 6
3640321 1907405 1907405 defendant Lytton William gent 600207 600207 Lytton, William, of Knebworth, Herts, gent 7
3640322 1907405 1907405 defendant Wyndesore Andrew   585869 585869 Wyndesore, Andrew, of London, knight 8
3640323 1907405 1907405 defendant Leventhorp Thomas   585869 585869 Leventhorp, Thomas, of London, gent, son of Leventhorp, John 9
3640324 1907405 1907405 defendant (not given)   prior of Wallyngford Priory, Berks   Wallyngford Priory, Berks, prior of 10
3640325 1907405 1907405 defendant (not given)   abbot of Croyland Abbey   Croyland Abbey, abbot of 11

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