cp40x: names: 29 rows where place

29 rows where place_id = 607296

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment
3668549	1916123 1916123	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668557	1916124 1916124	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668565	1916125 1916125	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668572	1916126 1916126	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668578	1916127 1916127	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668584	1916128 1916128	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668590	1916129 1916129	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668596	1916130 1916130	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668604	1916131 1916131	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668610	1916132 1916132	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668616	1916133 1916133	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668622	1916134 1916134	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3668628	1916135 1916135	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3685280	1921551 1921551	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3685286	1921552 1921552	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3685292	1921553 1921553	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3700320	1926341 1926341	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, esq, executors of
3700324	1926342 1926342	plaintiff	Babyngton	Thomas	esq.	607296 607296	Babyngton, Thomas, of Dethyk, esq. executors of
3700327	1926343 1926343	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3700331	1926344 1926344	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3700335	1926345 1926345	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3713947	1930660 1930660	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, esq, executors of
3756697	1944068 1944068	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executor of
3756700	1944069 1944069	plaintiff	Babyngton	Thomas	(legal representative)	607296 607296	Babyngton, Thomas, of Dethyk, executors of
3774562	1949770 1949770	plaintiff	Babyngton	Anthony	esq	607296 607296	Babyngton, Anthony, of Dethyk, esq
3774566	1949771 1949771	plaintiff	Babyngton	Anthony	esq	607296 607296	Babyngton, Anthony, of Dethyk, esq
3774570	1949772 1949772	plaintiff	Babyngton	Anthony	esq	607296 607296	Babyngton, Anthony, of Dethyk, esq
4045790	2040942 2040942	defendant	Babyngton	Henry	(legal representative)	607296 607296	Babyngton, Henry, of Dethyk, esq, executors of
5578644	2528388 2528388	plaintiff	Babyngton	Thomas	esq	607296 607296	Babyngton, Thomas, of Dethyk, esq

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