names

17 rows where case_id = 2189480

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4464229 2189480 2189480 plaintiff Waltham Thomas   603528 603528 Waltham, Thomas, of Kyngeston upon Hull, on his own account 0
4464230 2189480 2189480 defendant Halle Simon de     Halle, Simon de 0
4464231 2189480 2189480 defendant York Robert de     York, Robert de 1
4464232 2189480 2189480 defendant Dale Thomas de     Dale, Thomas de 2
4464233 2189480 2189480 defendant Dale William     Dale, William 3
4464234 2189480 2189480 defendant Storrere Walter     Storrere, Walter 4
4464235 2189480 2189480 defendant Farwell John     Farwell, John 5
4464236 2189480 2189480 defendant Godard Adam     Godard, Adam 6
4464237 2189480 2189480 defendant Gibson Richard     Gibson, Richard 7
4464238 2189480 2189480 defendant Appilton William de     Appilton, William de 8
4464239 2189480 2189480 defendant Fraunceys William     Fraunceys, William 9
4464240 2189480 2189480 defendant Williamson John     Williamson, John 10
4464241 2189480 2189480 defendant Irenmonger John     Irenmonger, John 11
4464242 2189480 2189480 defendant Smyth Simon     Smyth, Simon 12
4464243 2189480 2189480 defendant Fissher John     Fissher, John 13
4464244 2189480 2189480 defendant Henryson William     Henryson, William 14
4464245 2189480 2189480 defendant Erby John de     Erby, John de 15

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