names

13 rows where case_id = 2042904

✎ 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
4051313 2042904 2042904 plaintiff Wighell John attorney of the bench   Wighell, John, attorney of the bench 0
4051314 2042904 2042904 defendant Hallywell Robert husbandman 682817 682817 Hallywell, Robert, of Casington, husbandman 0
4051315 2042904 2042904 defendant Landesse Roger yeoman 586070 586070 Landesse, Roger, of Beverley, yeoman 1
4051316 2042904 2042904 defendant Wright William yeoman 682818 682818 Wright, William, of Skefeling, yeoman 2
4051317 2042904 2042904 defendant Merye Thomas yeoman 682819 682819 Merye, Thomas, of Byrlington, yeoman 3
4051318 2042904 2042904 defendant Eglesfeld William yeoman 682820 682820 Eglesfeld, William, of Rawleston, yeoman 4
4051319 2042904 2042904 defendant Ranson or Rauson Ambrose yeoman 587004 587004 Ranson or Rauson, Ambrose, of Preston, yeoman 5
4051320 2042904 2042904 defendant Hearne John husbandman 665170 665170 Hearne, John, of Keingham, husbandman 6
4051321 2042904 2042904 defendant Metcalf Eleanor widow 595174 595174 Metcalf, Eleanor, of Caweton, widow 7
4051322 2042904 2042904 defendant Bylett Robert (legal representative)   Bylett, Robert, executors of 8
4051323 2042904 2042904 defendant Skearne Thomas gent 626507 626507 (Skearne, Thomas, of Wyncott, gent 9
4051324 2042904 2042904 defendant Applebye William (legal representative)   Applebye, William, executrix of 10
4051325 2042904 2042904 defendant Applebye Francis widow 663935 663935 Applebye, Francis, of Hacknes, widow 11

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