names

16 rows where place_id = 793875

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4738054 2277003 2277003 defendant Butturworth Bernard gent 793875 793875 Butturworth, Bernard, of Holmefryth, gent 0
4848014 2310852 2310852 defendant Littlelwode James   793875 793875 Littlelwode, James, of Holmefryth 5
4848015 2310852 2310852 defendant Wodecok Thomas   793875 793875 Wodecok, Thomas, of Holmefryth 6
4848016 2310852 2310852 defendant Whitley Thurston   793875 793875 Whitley, Thurston, of Holmefryth 7
4848017 2310852 2310852 defendant Gaunt William   793875 793875 Gaunt, William, of Holmefryth 8
4848018 2310852 2310852 defendant Lynley Richard   793875 793875 Lynley, Richard, of Holmefryth 9
4848021 2310852 2310852 defendant Rodes John   793875 793875 Rodes, John, of Holmefryth 12
4848022 2310852 2310852 defendant Diconson Richard   793875 793875 Diconson, Richard, of Holmefryth 13
4848023 2310852 2310852 defendant Lynley John   793875 793875 Lynley, John, of Holmefryth 14
4848024 2310852 2310852 defendant Riche John   793875 793875 Riche, John, of Holmefryth 15
4848026 2310852 2310852 defendant Atkynson Thomas   793875 793875 Atkynson, Thomas, of Holmefryth 17
4848027 2310852 2310852 defendant Otes William   793875 793875 Otes, William, of Holmefryth 18
4848028 2310852 2310852 defendant Tynker Thomas   793875 793875 Tynker, Thomas, of Holmefryth 19
4848029 2310852 2310852 defendant Tynker William   793875 793875 Tynker, William, of Holmefryth 20
4848030 2310852 2310852 defendant Charleworth John   793875 793875 Charleworth, John, of Holmefryth 21
4848031 2310852 2310852 defendant Brodehed William   793875 793875 Brodehed, William, of Holmefryth 22

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