cp40x: names: 30 rows where place

30 rows where place_id = 616585

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment	seq
3715157	1931035 1931035	defendant	Bulkyn	Richard	husbandman	616585 616585	Bulkyn, Richard, of Stretford, husbandman	1
3715164	1931037 1931037	defendant	Bulkyn	Richard	husbandman	616585 616585	Bulkyn, Richard, of Stretford, husbandman	1
3742776	1939597 1939597	defendant	Bulkyn	Richard	husbandman	616585 616585	Bulkyn, Richard, of Stretford, husbandman	1
3934966	2001997 2001997	defendant	Polle	Hugh	husbandman	616585 616585	Polle, Hugh, of Stretford, husbandman	0
3935684	2002244 2002244	defendant	Grey	John	smith	616585 616585	Grey, John, of Stretford, smith	1
4231774	2106609 2106609	defendant	Taylor alias ap Powell	John	tailor	616585 616585	Taylor alias ap Powell, John, of Stretford, tailor	0
4241274	2110065 2110065	defendant	Posterne	William		616585 616585	Posterne, William, of Stretford, Salop yeoman	1
4315383	2135490 2135490	defendant	Stone	Richard	husbandman	616585 616585	Stone, Richard, of Stretford, husbandman	1
4473902	2192492 2192492	plaintiff	Lenyot or Levyot	William		616585 616585	Lenyot or Levyot, William, of Stretford, parson	1
4487146	2196705 2196705	defendant	Watford	Stephen		616585 616585	Watford, Stephen, of Stretford	0
4501124	2200958 2200958	defendant	Shakelok	Thomas		616585 616585	Shakelok, Thomas, of Stretford	0
4533820	2210844 2210844	defendant	Carpenter	John		616585 616585	Carpenter, John, of Stretford	0
4540543	2212940 2212940	defendant	Beley	John		616585 616585	Beley, John, of Stretford	0
4541812	2213328 2213328	defendant	Mason	Thomas		616585 616585	Mason, Thomas, of Stretford	0
4548605	2215504 2215504	defendant	Iremonger	Thomas		616585 616585	Iremonger, Thomas, of Stretford	0
4548606	2215504 2215504	defendant	Fladbury	Joan		616585 616585	Fladbury, Joan, of Stretford	1
4548608	2215505 2215505	defendant	Iremonger	Thomas		616585 616585	Iremonger, Thomas, of Stretford	0
4548609	2215505 2215505	defendant	Fladbury	Joan		616585 616585	Fladbury, Joan, of Stretford	1
4563949	2220297 2220297	defendant	Jakes	Thomas		616585 616585	Jakes, Thomas, of Stretford	1
4590030	2228242 2228242	defendant	Halle	Bartholomew		616585 616585	Halle, Bartholomew, of Stretford, parson	0
4608866	2233874 2233874	defendant	Hosyer	John		616585 616585	Hosyer, John, of Stretford	3
4701511	2265868 2265868	defendant	Skelton	Robert de	husbandman	616585 616585	Skelton, Robert de, of Stretford, husbandman	6
4829167	2305163 2305163	defendant	Gronowe or Grovowe	John	husbandman	616585 616585	Gronowe or Grovowe, John, of Stretford, husbandman	0
4833343	2306438 2306438	defendant	Halle	Richard	gent	616585 616585	Halle, Richard, of Stretford, gent	0
4957367	2344167 2344167	plaintiff	Webbe	John		616585 616585	Webbe, John, of Stretford	0
5202722	2416561 2416561	plaintiff	Burbage	Richard	tanner	616585 616585	Burbage, Richard, of Stretford, formerly of Coventry, tanner	0
5219217	2421344 2421344	defendant	Powes	William	butcher	616585 616585	Powes, William, of Stretford, butcher	0
5219220	2421345 2421345	defendant	Powes	William	butcher	616585 616585	Powes, William, of Stretford, butcher	0
5283760	2440293 2440293	defendant	Lancastre	Thomas	yeoman	616585 616585	Lancastre, Thomas, of Stretford, yeoman	1
5391171	2472553 2472553	plaintiff	Paget	Roger	mercer	616585 616585	Paget, Roger, of Stretford, mercer	0

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