names

19 rows where case_id = 2475078

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5399956 2475078 2475078 plaintiff Ferrers Martin     Ferrers, Martin 0
5399957 2475078 2475078 defendant Shelley John     Shelley, John 0
5399958 2475078 2475078 defendant Plowfeld William stationer   Plowfeld, William, stationer 1
5399959 2475078 2475078 defendant Middelton Nicholas     Middelton, Nicholas 2
5399960 2475078 2475078 defendant Gernes John     Gernes, John 3
5399961 2475078 2475078 defendant Manfeld Robert     Manfeld, Robert 4
5399962 2475078 2475078 defendant Paston Edmund     Paston, Edmund 5
5399963 2475078 2475078 defendant Lynsted William     Lynsted, William 6
5399964 2475078 2475078 defendant Dyn William     Dyn, William 7
5399965 2475078 2475078 defendant Forde Lawrence     Forde, Lawrence 8
5399966 2475078 2475078 defendant Fetiplace Anthony     Fetiplace, Anthony 9
5399967 2475078 2475078 defendant Gage Roger     Gage, Roger 10
5399968 2475078 2475078 defendant Mikefeld Robert     Mikefeld, Robert 11
5399969 2475078 2475078 defendant Brigham William     Brigham, William 12
5399970 2475078 2475078 defendant Dagges John     Dagges, John 13
5399971 2475078 2475078 defendant each a gent of London unless otherwise stated   each a gent, of London, unless otherwise stated 14
5399972 2475078 2475078 defendant Barton William gent 623313 623313 Barton, William, of Wynchester, Hants, gent 15
5399973 2475078 2475078 defendant Darby John   604018 604018 Darby, John, of Colchester, Essex 16
5399974 2475078 2475078 defendant Lathom John gent 883327 883327 Lathom, John, of Souothampton, Hants, gent 17

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