cp40x: names: 11 rows where place

11 rows where place_id = 607309

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment
3668640	1916137 1916137	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668646	1916138 1916138	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668652	1916139 1916139	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668658	1916140 1916140	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668664	1916141 1916141	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668670	1916142 1916142	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668676	1916143 1916143	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668682	1916144 1916144	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668688	1916145 1916145	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668694	1916146 1916146	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, executors of
3668700	1916147 1916147	plaintiff	Babyngton	Thomas	(legal representative)	607309 607309	Babyngton, Thomas, of Dethykke, 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);