names

10 rows where case_id = 2492192

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5457661 2492192 2492192 plaintiff Dotton John, sen     Dotton, John, sen 0
5457662 2492192 2492192 defendant Cory Walter husbandman 603080 603080 Cory, Walter, of Bradworthy, husbandman 0
5457663 2492192 2492192 defendant Holygrave William husbandman 603080 603080 Holygrave, William, of Bradworthy, husbandman 1
5457664 2492192 2492192 defendant Fotys Thomas husbandman 603080 603080 Fotys, Thomas, of Bradworthy, husbandman 2
5457665 2492192 2492192 defendant Gene Robert, sen   603080 603080 Gene, Robert, sen, of Bradworthy, groom 3
5457666 2492192 2492192 defendant Gene Robert   603080 603080 Gene, Robert, of Bradworthy, groom 4
5457667 2492192 2492192 defendant Burteys Thomas   614246 614246 Burteys, Thomas, of Sutcombe, groom 5
5457668 2492192 2492192 defendant Beauford John   603080 603080 Beauford, John, of Bradworthy 6
5457669 2492192 2492192 defendant Trenman William husbandman 603080 603080 Trenman, William, of Bradworthy, husbandman 7
5457670 2492192 2492192 defendant Holygrave John husbandman 603080 603080 Holygrave, John, of Bradworthy, husbandman 8

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