names

13 rows where case_id = 2418037

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5207858 2418037 2418037 plaintiff Notyngham William     Notyngham, William 0
5207859 2418037 2418037 defendant Foderby Thomas merchant 859464 859464 Foderby, Thomas, of St Salvatore, Lincs, merchant 0
5207860 2418037 2418037 defendant Mundson John merchant 857956 857956 Mundson, John, of Kelesey, Lincs, merchant 1
5207861 2418037 2418037 defendant Frere James merchant 600449 600449 Frere, James, of Boston, Lincs, merchant 2
5207862 2418037 2418037 defendant Ouresby John merchant 857957 857957 Ouresby, John, of Ouresby, Lincs, merchant 3
5207863 2418037 2418037 defendant Mundson Robert merchant 603528 603528 Mundson, Robert, of Kyngeston upon Hull, merchant 4
5207864 2418037 2418037 defendant Hanworth John merchant 660478 660478 Hanworth, John, of Gaynsburgh, Lincs, merchant 5
5207865 2418037 2418037 defendant Dalyson John merchant 859465 859465 Dalyson, John, of Scotour, Lincs, merchant 6
5207866 2418037 2418037 defendant Horne William merchant 603528 603528 Horne, William, of Kyngeston upon Hull, merchant 7
5207867 2418037 2418037 defendant Sybsey William merchant 586286 586286 Sybsey, William, of Boston, merchant 8
5207868 2418037 2418037 defendant Wygot Richard merchant 586286 586286 Wygot, Richard, of Boston, merchant 9
5207869 2418037 2418037 defendant Stephenson John merchant 682304 682304 Stephenson, John, of Wynthorp, Lincs, merchant 10
5207870 2418037 2418037 defendant Leche William merchant 586286 586286 Leche, William, of Boston, merchant 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);