names

10 rows where case_id = 2226824

✎ 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
4585287 2226824 2226824 plaintiff Hakeluyt Leonard knight   Hakeluyt, Leonard, knight 0
4585288 2226824 2226824 defendant More William   586422 586422 More, William, of Lynton 0
4585289 2226824 2226824 defendant Smyth John   607706 607706 Smyth, John, of Upton Bishop 1
4585290 2226824 2226824 defendant Gartson Roger     Gartson, Roger 2
4585291 2226824 2226824 defendant Smyth John   607706 607706 Smyth, John, of Upton Bishop, son of Henry 3
4585292 2226824 2226824 defendant Hulle William   772093 772093 Hulle, William, of Kempeley 4
4585293 2226824 2226824 defendant More John   772094 772094 More, John, of Kemepeley 5
4585294 2226824 2226824 defendant Cole William     Cole, William 6
4585295 2226824 2226824 defendant Cley Richard carpenter 596734 596734 Cley, Richard, of Dymmok, carpenter 7
4585296 2226824 2226824 defendant Tethegy Thomas     Tethegy, Thomas 8

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