names

6 rows where place_id = 770853

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
4571983 2222807 2222807 defendant Menrell John   770853 770853 Menrell, John, of Calnore 19
4572073 2222827 2222827 defendant Menrell John   770853 770853 Menrell, John, of Calnore 13
4572074 2222827 2222827 defendant Ryley William de   770853 770853 Ryley, William de, of Calnore 14
4572075 2222827 2222827 defendant Wales John de   770853 770853 Wales, John de, of Calnore 15
4630045 2240313 2240313 defendant Burton John   770853 770853 Burton, John, of Calnore 9
4960023 2344963 2344963 defendant Staley William husbandman 770853 770853 Staley, William, of Calnore, husbandman 1

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