names

17 rows where case_id = 2189479

✎ 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
4464212 2189479 2189479 plaintiff Waltham Thomas   656624 656624 Waltham, Thomas, of Kingston upon Hull 0
4464213 2189479 2189479 defendant Halle Simon de     Halle, Simon de 0
4464214 2189479 2189479 defendant York Robert de     York, Robert de 1
4464215 2189479 2189479 defendant Dale Thomas de     Dale, Thomas de 2
4464216 2189479 2189479 defendant Dale William de     Dale, William de 3
4464217 2189479 2189479 defendant Storrere Walter     Storrere, Walter 4
4464218 2189479 2189479 defendant Ferwell John     Ferwell, John 5
4464219 2189479 2189479 defendant Coward Adam     Coward, Adam 6
4464220 2189479 2189479 defendant Gybson Richard     Gybson, Richard 7
4464221 2189479 2189479 defendant Appilton William de     Appilton, William de 8
4464222 2189479 2189479 defendant Fraunceys William     Fraunceys, William 9
4464223 2189479 2189479 defendant Williamson John     Williamson, John 10
4464224 2189479 2189479 defendant Irenmanger John     Irenmanger, John 11
4464225 2189479 2189479 defendant Smyth Nicholas     Smyth, Nicholas 12
4464226 2189479 2189479 defendant Fissher John     Fissher, John 13
4464227 2189479 2189479 defendant Herryson William     Herryson, William 14
4464228 2189479 2189479 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);