names

22 rows where case_id = 1871410

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612026 1871410 1871410 plaintiff Vernon Richard     Vernon, Richard 0
3612027 1871410 1871410 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3612028 1871410 1871410 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3612029 1871410 1871410 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3612030 1871410 1871410 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3612031 1871410 1871410 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3612032 1871410 1871410 defendant Slake Oliver     Slake, Oliver 5
3612033 1871410 1871410 defendant Slake John     Slake, John 6
3612034 1871410 1871410 defendant Eyre William     Eyre, William 7
3612035 1871410 1871410 defendant Treket John     Treket, John 8
3612036 1871410 1871410 defendant Slake Thomas     Slake, Thomas 9
3612037 1871410 1871410 defendant Marshall Roger     Marshall, Roger 10
3612038 1871410 1871410 defendant Bokkyng William     Bokkyng, William 11
3612039 1871410 1871410 defendant Bokkyng Denis     Bokkyng, Denis 12
3612040 1871410 1871410 defendant Marchall Humphrey     Marchall, Humphrey 13
3612041 1871410 1871410 defendant Slake Ralph     Slake, Ralph 14
3612042 1871410 1871410 defendant Bokkyng John     Bokkyng, John 15
3612043 1871410 1871410 defendant Treket Thomas     Treket, Thomas 16
3612044 1871410 1871410 defendant Marchall Roger     Marchall, Roger 17
3612045 1871410 1871410 defendant Hethecote Thomas     Hethecote, Thomas 18
3612046 1871410 1871410 defendant Bore Henry     Bore, Henry 19
3612047 1871410 1871410 defendant Slykes John     Slykes, John 20

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