names

13 rows where case_id = 2042905

✎ 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
4051326 2042905 2042905 plaintiff Wighell John attorney of the bench   Wighell, John, attorney of the bench 0
4051327 2042905 2042905 defendant Hallywell Robert husbandman 661969 661969 Hallywell, Robert, of Easington, husbandman 0
4051328 2042905 2042905 defendant Landesse Roger yeoman 586070 586070 Landesse, Roger, of Beverley, yeoman 1
4051329 2042905 2042905 defendant Wright William yeoman 682821 682821 Wright, William, of Skefelinge, yeoman 2
4051330 2042905 2042905 defendant Marye Thomas yeoman 682819 682819 Marye, Thomas, of Byrlington, yeoman 3
4051331 2042905 2042905 defendant Eglesfeld William yeoman 682820 682820 Eglesfeld, William, of Rawleston, yeoman 4
4051332 2042905 2042905 defendant Ranson or Rauson Ambrose yeoman 587004 587004 Ranson or Rauson, Ambrose, of Preston, yeoman 5
4051333 2042905 2042905 defendant Hearne John husbandman 665170 665170 Hearne, John, of Keingham, husbandman 6
4051334 2042905 2042905 defendant Metcalf Eleanor widow 595174 595174 Metcalf, Eleanor, of Caweton, widow 7
4051335 2042905 2042905 defendant Bylett Robert (legal representative)   Bylett, Robert, executors of 8
4051336 2042905 2042905 defendant Skearne Thomas gent 682822 682822 (Skearne, Thomas, of Wyncett, gent 9
4051337 2042905 2042905 defendant Applebye William (legal representative)   Applebye, William, executrix of 10
4051338 2042905 2042905 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);