names

3 rows where place_id = 776576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4635302 2241878 2241878 defendant Lambert Robert   776576 776576 Lambert, Robert, of Croseby 2
5158917 2403726 2403726 defendant Hope Richard yeoman 776576 776576 Hope, Richard, of Croseby, yeoman 28
5158918 2403726 2403726 defendant Levyngton William   776576 776576 Levyngton, William, of Croseby 29

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