names

22 rows where case_id = 1871409

✎ 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
3612004 1871409 1871409 plaintiff Vernon Richard     Vernon, Richard 0
3612005 1871409 1871409 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3612006 1871409 1871409 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3612007 1871409 1871409 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3612008 1871409 1871409 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3612009 1871409 1871409 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3612010 1871409 1871409 defendant Slake Oliver     Slake, Oliver 5
3612011 1871409 1871409 defendant Slake John     Slake, John 6
3612012 1871409 1871409 defendant Eyre William     Eyre, William 7
3612013 1871409 1871409 defendant Treket John     Treket, John 8
3612014 1871409 1871409 defendant Slake Thomas     Slake, Thomas 9
3612015 1871409 1871409 defendant Marshall Roger     Marshall, Roger 10
3612016 1871409 1871409 defendant Bokkyng William     Bokkyng, William 11
3612017 1871409 1871409 defendant Bokkyng Denis     Bokkyng, Denis 12
3612018 1871409 1871409 defendant Marchall Humphrey     Marchall, Humphrey 13
3612019 1871409 1871409 defendant Slake Ralph     Slake, Ralph 14
3612020 1871409 1871409 defendant Bokkyng John     Bokkyng, John 15
3612021 1871409 1871409 defendant Treket Thomas     Treket, Thomas 16
3612022 1871409 1871409 defendant Marchall Roger     Marchall, Roger 17
3612023 1871409 1871409 defendant Hethecote Thomas     Hethecote, Thomas 18
3612024 1871409 1871409 defendant Bore Henry     Bore, Henry 19
3612025 1871409 1871409 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);