names

11 rows where place_id = 675502

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4018902 2031493 2031493 defendant Saltaker Edith widow 675502 675502 Edith his wife, alias Edith Robson, of Abington, widow 1
4170064 2085024 2085024 defendant Jennens William   675502 675502 Jennens, William, of Abington, yeoman, woolen draper 1
4208103 2098392 2098392 defendant Clenche Henry painter 675502 675502 Clenche, Henry, of Abington, painter 2
4268741 2119139 2119139 defendant Thornburgh Edward esq 675502 675502 Thornburgh, Edward, of Abington, esq 0
4268742 2119139 2119139 defendant Hinton Edward yeoman 675502 675502 Hinton, Edward, of Abington, yeoman 1
4270021 2119556 2119556 defendant Barnard Francis, junior gent 675502 675502 Barnard, Francis, junior, of Abington, gent 0
4304502 2131712 2131712 defendant Jeninges William yeoman 675502 675502 Jeninges, William, of Abington, yeoman 0
4304503 2131712 2131712 defendant Tirrett or Terrett or Tirwitt John yeoman 675502 675502 Tirrett or Terrett or Tirwitt, John, of Abington, yeoman 1
4322311 2137877 2137877 defendant Gray Richard tailor 675502 675502 Gray, Richard, of Abington, tailor 0
4398165 2163965 2163965 defendant Barton William saddler 675502 675502 Barton, William, of Abington, saddler 1
5180935 2410163 2410163 defendant Apperley John   675502 675502 Apperley, John, of Abington, kersey man 0

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