names

8 rows where case_id = 2354608

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4992380 2354608 2354608 plaintiff Dalamore Thomas     Dalamore, Thomas 0
4992381 2354608 2354608 defendant Atkynson Nicholas yeoman 600820 600820 Atkynson, Nicholas, of wigton, yeoman 0
4992382 2354608 2354608 defendant Calfherd John yeoman 758065 758065 Calfherd, John, of Laysyngby, yeoman 1
4992383 2354608 2354608 defendant Uslay Alan yeoman 654046 654046 Uslay, Alan, of Dalston, yeoman 2
4992384 2354608 2354608 defendant Grisedale John yeoman 654046 654046 Grisedale, John, of Dalston, yeoman 3
4992385 2354608 2354608 defendant Coldaleman Robert yeoman 831857 831857 Coldaleman, Robert, of Crosewath, yeoman 4
4992386 2354608 2354608 defendant Bakhous William husbandman 831858 831858 Bakhous, William, of Blenogowe, husbandman 5
4992387 2354608 2354608 defendant Whitehed John husbandman 597715 597715 Whitehed, John, of Wygton, husbandman 6

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