cp40x: names: 29 rows where place

29 rows where place_id = 591580

descending

id ▼	case_id	role	surname	forename	occupation	place_id	raw_segment	seq
3604884	1869192 1869192	defendant	Parker	Richard	cordwainer	591580 591580	Parker, Richard, of Yoxall, cordwainer	2
3814002	1962285 1962285	defendant	Fletcher	Richard	yeoman	591580 591580	Fletcher, Richard, of Yoxall, yeoman	1
3814003	1962285 1962285	defendant	Sclatter	John	husbandman	591580 591580	Sclatter, John, of Yoxall, husbandman	2
3900828	1990507 1990507	defendant	Leyster	John	smith	591580 591580	Leyster, John, of Yoxall, smith	0
3907181	1992693 1992693	defendant	Warde	Stephen	gent	591580 591580	Warde, Stephen, of Yoxall, gent	0
3956684	2009404 2009404	defendant	Carlton or Cholton	Geoffrey	laborer	591580 591580	Carlton or Cholton, Geoffrey, of Yoxall, laborer	0
3956686	2009405 2009405	defendant	Harwell	Edward	husbandman	591580 591580	Harwell, Edward, of Yoxall, husbandman	0
3969975	2014096 2014096	defendant	Curson	John	gent	591580 591580	Curson, John, of Yoxall, gent	1
3969980	2014097 2014097	defendant	Curson	John	gent	591580 591580	Curson, John, of Yoxall, gent	2
3985754	2019666 2019666	defendant	Wryght	Robert	yeoman	591580 591580	Wryght, Robert, of Yoxall, yeoman	0
3994462	2022771 2022771	defendant	Salte	Anne	widow	591580 591580	Salte, Anne, of Yoxall, widow	2
4048310	2041839 2041839	defendant	Marlowe	Thomas	husbandman	591580 591580	Marlowe, Thomas, of Yoxall, husbandman	0
4075527	2051548 2051548	defendant	Burdett	Francis	gent	591580 591580	Burdett, Francis, of Yoxall, gent	1
4147575	2077294 2077294	defendant	Camden	William	gent	591580 591580	Camden, William, of Yoxall, gent	0
4147604	2077303 2077303	defendant	Shepton	Humphrey	yeoman	591580 591580	Shepton, Humphrey, of Yoxall, yeoman	1
4147711	2077343 2077343	defendant	Camden	William	gent	591580 591580	Camden, William, of Yoxall, gent	0
4181450	2088991 2088991	defendant	Tatte	Richard	laborer	591580 591580	Tatte, Richard, of Yoxall, laborer	0
4184464	2090074 2090074	defendant	Morres	Robert	chandler	591580 591580	Morres, Robert, of Yoxall, chandler	0
4218902	2102106 2102106	defendant	Hoode	Thomas	thatcher	591580 591580	Hoode, Thomas, of Yoxall, thatcher	2
4282905	2123920 2123920	defendant	Blakenhall or Blakenole	William	gent	591580 591580	Blakenhall or Blakenole, William, of Yoxall, or of Draiton Bassett, Staffs, gent	0
4300282	2130200 2130200	defendant	Blakenhall	William	gent	591580 591580	Blakenhall, William, of Yoxall, or of Draiton Bassett, Staffs, gent	0
4305481	2132054 2132054	defendant	Camden	William	gent	591580 591580	Camden, William, of Yoxall, gent	0
4319571	2136957 2136957	defendant	Bealyes	William	yeoman	591580 591580	Bealyes, William, of Yoxall, yeoman	0
4319574	2136957 2136957	defendant	Newton	Thomas	husbandman	591580 591580	Newton, Thomas, of Yoxall, husbandman	3
4334526	2141820 2141820	defendant	Cunwaye	George		591580 591580	Cunwaye, George, of Yoxall, cook	3
4347204	2146281 2146281	defendant	Cockson	Thomas	yeoman	591580 591580	Cockson, Thomas, of Yoxall, yeoman	0
4398945	2164230 2164230	defendant	Cockson	Thomas	yeoman	591580 591580	Cockson, Thomas, of Yoxall, yeoman	0
5344957	2458584 2458584	defendant	Rouce or Ronce	Robert	yeoman	591580 591580	Rouce or Ronce, Robert, of Yoxall, yeoman	0
5569999	2525803 2525803	defendant	Wodward	John	husbandman	591580 591580	Wodward, John, of Yoxall, husbandman	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);