cp40x: names: 20 rows where place

20 rows where place_id = 669279

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment
3992493	2022076 2022076	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992497	2022077 2022077	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992501	2022078 2022078	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992505	2022079 2022079	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992509	2022080 2022080	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992513	2022081 2022081	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992517	2022082 2022082	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992521	2022083 2022083	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992525	2022084 2022084	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992529	2022085 2022085	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992534	2022086 2022086	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992538	2022087 2022087	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992542	2022088 2022088	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992546	2022089 2022089	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992550	2022090 2022090	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992554	2022091 2022091	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992558	2022092 2022092	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992563	2022093 2022093	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992567	2022094 2022094	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, executors of
3992571	2022095 2022095	plaintiff	Butler	Anthony	(legal representative)	669279 669279	Butler, Anthony, of Cotes juxta Stowe, esq, 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);