names

8 rows where case_id = 2467309

✎ 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
5373498 2467309 2467309 plaintiff Meger John     Meger, John 0
5373499 2467309 2467309 defendant Hyket John clerk 626421 626421 Hyket, John, of Pylton, Devon, clerk 0
5373500 2467309 2467309 defendant Auger John yeoman 782613 782613 Auger, John, of Poundestoke, Cornw, yeoman 1
5373501 2467309 2467309 defendant Payn William husbandman 657256 657256 Payn, William, of Wyke St mary, Cornw, husbandman 2
5373502 2467309 2467309 defendant Orchard William husbandman 879456 879456 Orchard, William, of Wyke, St Mary, husbandman 3
5373503 2467309 2467309 defendant Bonefaunt William husbandman 642211 642211 Bonefaunt, William, of Wyke St Mary, husbandman 4
5373504 2467309 2467309 defendant Dawe Thomas laborer 829668 829668 Dawe, Thomas, of Poundestoke, laborer 5
5373505 2467309 2467309 defendant Hyket Robert smith 879457 879457 Hyket, Robert, of Stratton Cornw, smith 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);