cp40x: names: 7 rows where place

7 rows where place_id = 610726

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment
3684888	1921411 1921411	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, executors of
3684895	1921412 1921412	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, executors of
3684902	1921413 1921413	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, executors of
3684908	1921414 1921414	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, executors of
3700031	1926245 1926245	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, merchant, executors of
3700038	1926246 1926246	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, merchant, executors of
3713537	1930546 1930546	plaintiff	Andrewe	Thomas	(legal representative)	610726 610726	Andrewe, Thomas, of Exeter St Mary Arches, executors of

Advanced export

JSON shape: default, array, newline-delimited, object

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