names

16 rows where case_id = 2229193

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4593277 2229193 2229193 plaintiff Par John esq   Par, John, esq 0
4593278 2229193 2229193 defendant Cook John   585999 585999 Cook, John, of Kyrkeby 0
4593279 2229193 2229193 defendant Lete Richard   585999 585999 Lete, Richard, of Kyrkeby 1
4593280 2229193 2229193 defendant Hoggeson Thomas   585999 585999 Hoggeson, Thomas, of Kyrkeby 2
4593281 2229193 2229193 defendant Wyse John   585999 585999 Wyse, John, of Kyrkeby 3
4593282 2229193 2229193 defendant Hethelym William   621392 621392 Hethelym, William, of Desford 4
4593283 2229193 2229193 defendant Webster John   621392 621392 Webster, John, of Desford 5
4593284 2229193 2229193 defendant Rerebache William   621392 621392 Rerebache, William, of Desford 6
4593285 2229193 2229193 defendant Percevale Thomas   621392 621392 Percevale, Thomas, of Desford 7
4593286 2229193 2229193 defendant Goderiche Robert   621392 621392 Goderiche, Robert, of Desford 8
4593287 2229193 2229193 defendant Odam Thomas   621392 621392 Odam, Thomas, of Desford 9
4593288 2229193 2229193 defendant Smyth William   621392 621392 Smyth, William, of Desford 10
4593289 2229193 2229193 defendant Goterde Hugh   621392 621392 Goterde, Hugh, of Desford 11
4593290 2229193 2229193 defendant Hewet John   621392 621392 Hewet, John, of Desford 12
4593291 2229193 2229193 defendant Bret William   621392 621392 Bret, William, of Desford 13
4593292 2229193 2229193 defendant Porter Robert   621392 621392 Porter, Robert, of Desford 14

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