names

22 rows where case_id = 1871408

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611982 1871408 1871408 plaintiff Vernon Richard     Vernon, Richard 0
3611983 1871408 1871408 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3611984 1871408 1871408 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3611985 1871408 1871408 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3611986 1871408 1871408 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3611987 1871408 1871408 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3611988 1871408 1871408 defendant Slake Oliver laborer 591227 591227 Slake, Oliver, of Hope, laborer 5
3611989 1871408 1871408 defendant Slake John husbandman 591227 591227 Slake, John, of Hope, husbandman 6
3611990 1871408 1871408 defendant Eyre William husbandman 591227 591227 Eyre, William, of Hope, husbandman 7
3611991 1871408 1871408 defendant Treket John husbandman 591227 591227 Treket, John, of Hope, husbandman 8
3611992 1871408 1871408 defendant Slake Thomas husbandman 593479 593479 Slake, Thomas, of Castelton, husbandman 9
3611993 1871408 1871408 defendant Marshall Roger husbandman 593479 593479 Marshall, Roger, of Castelton, husbandman 10
3611994 1871408 1871408 defendant Bokkyng William husbandman 591227 591227 Bokkyng, William, of Hope, husbandman 11
3611995 1871408 1871408 defendant Bokkyng Denis laborer 591227 591227 Bokkyng, Denis, of Hope, laborer 12
3611996 1871408 1871408 defendant Marchall Humphrey husbandman 593479 593479 Marchall, Humphrey, of Castelton, husbandman 13
3611997 1871408 1871408 defendant Slake Ralph husbandman 591227 591227 Slake, Ralph, of Hope, husbandman 14
3611998 1871408 1871408 defendant Bokkyng John laborer 591227 591227 Bokkyng, John, of Hope, laborer 15
3611999 1871408 1871408 defendant Treket Thomas husbandman 591227 591227 Treket, Thomas, of Hope, husbandman 16
3612000 1871408 1871408 defendant Marchall Roger husbandman 591227 591227 Marchall, Roger, of Hope, husbandman 17
3612001 1871408 1871408 defendant Hethcote Thomas husbandman 591227 591227 Hethcote, Thomas, of Hope, husbandman 18
3612002 1871408 1871408 defendant Bore Henry husbandman 591227 591227 Bore, Henry, of Hope, husbandman 19
3612003 1871408 1871408 defendant Slykes John laborer 593479 593479 Slykes, John, of Castelton, laborer 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);