cp40x: places: 238,900 rows

238,900 rows

descending

id ▼	place_name	place_norm	locality	county	flags
585863	Bedynden	bedynden	Bedynden
585864	Cranebroke	cranebroke	Cranebroke
585865	Kyngeston Bowecy	kyngeston bowecy	Kyngeston Bowecy
585866	Shermanbury	shermanbury	Shermanbury
585867	Maughfeld	maughfeld	Maughfeld
585868	Chepsted, Kent	chepsted\|kent	Chepsted	Kent	had_county
585869	London	london	London
585870	Brygewater, Soms	brygewater\|soms	Brygewater	Soms	had_county
585871	Taunton, Soms	taunton\|soms	Taunton	Soms	had_county
585872	Wy	wy	Wy
585873	High Crosse, Stondon	high crosse, stondon	High Crosse, Stondon
585874	Hatfeld Peverell, Essex	hatfeld peverell\|essex	Hatfeld Peverell	Essex	had_county
585876	Ottham	ottham	Ottham
585877	Chart	chart	Chart
585878	Basyngbourn, Cams	basyngbourn\|cams	Basyngbourn	Cams	had_county
585879	Nymet Episcopi	nymet episcopi	Nymet Episcopi
585881	Wokyngham, Berks	wokyngham\|berks	Wokyngham	Berks	had_county
585882	Wokyngham	wokyngham	Wokyngham
585884	Mullberton	mullberton	Mullberton
585885	Wikewode	wikewode	Wikewode
585886	Guldeford, Surrey	guldeford\|surrey	Guldeford	Surrey	had_county
585887	Guldeford	guldeford	Guldeford
585888	Maidstone, Kent	maidstone\|kent	Maidstone	Kent	had_county
585889	Some, Isle of Ely, Cams	some, isle of ely\|cams	Some, Isle of Ely	Cams	had_county
585890	Hampsted Marchall, Berks	hampsted marchall\|berks	Hampsted Marchall	Berks	had_county
585891	Hampsted Marchall	hampsted marchall	Hampsted Marchall
585892	Welwyn, Herts	welwyn\|herts	Welwyn	Herts	had_county
585893	Barnby on Donne	barnby on donne	Barnby on Donne
585894	Carcroft, Suston	carcroft, suston	Carcroft, Suston
585895	Mekesburgh	mekesburgh	Mekesburgh
585897	Parkeham, Devon	parkeham\|devon	Parkeham	Devon	had_county
585898	Shytlyngton	shytlyngton	Shytlyngton
585899	Shordyche	shordyche	Shordyche
585900	Saham Tony	saham tony	Saham Tony
585901	Burwell	burwell	Burwell
585902	Reynham	reynham	Reynham
585903	Shaldeford, Surrey	shaldeford\|surrey	Shaldeford	Surrey	had_county
585904	Berton Bendyche	berton bendyche	Berton Bendyche
585905	Lytelport, Isle of Ely, Cams	lytelport, isle of ely\|cams	Lytelport, Isle of Ely	Cams	had_county
585906	West Lynne	west lynne	West Lynne
585907	Bishops Lenn	bishops lenn	Bishops Lenn
585908	Hyllyngton	hyllyngton	Hyllyngton
585909	Boxworth, Cams	boxworth\|cams	Boxworth	Cams	had_county
585910	Fulburn, Cams	fulburn\|cams	Fulburn	Cams	had_county
585911	Mortlake, Middx	mortlake\|middx	Mortlake	Middx	had_county
585912	Highgate, Haryngay	highgate, haryngay	Highgate, Haryngay
585913	Sandferst	sandferst	Sandferst
585914	Nekton	nekton	Nekton
585915	Shypdam	shypdam	Shypdam
585917	Magna Badmanton, Glos, esq, kinsman, of Boteler, John, knight	magna badmanton\|glos	Magna Badmanton	Glos	stripped_leading_of,stripped_occupation,had_county
585920	Etyngton, Warks	etyngton\|warks	Etyngton	Warks	had_county
585921	Arrowe, Warks	arrowe\|warks	Arrowe	Warks	had_county
585922	Wodam Ferrys, Essex	wodam ferrys\|essex	Wodam Ferrys	Essex	had_county
585924	Thornbury, Glos	thornbury\|glos	Thornbury	Glos	had_county
585925	Bristol	bristol	Bristol
585926	Alysbery, Bucks	alysbery\|bucks	Alysbery	Bucks	had_county
585927	Bradford, Wilts	bradford\|wilts	Bradford	Wilts	had_county
585928	Magna Dodyngton, Nhants	magna dodyngton\|nhants	Magna Dodyngton	Nhants	had_county
585929	St Clement Danes	st clement danes	St Clement Danes
585930	Tadmerton, Oxon	tadmerton\|oxon	Tadmerton	Oxon	had_county
585931	Hadlo, Kent	hadlo\|kent	Hadlo	Kent	had_county
585932	Kingston on Hull	kingston on hull	Kingston on Hull
585933	Great Yarmouth	great yarmouth	Great Yarmouth
585934	Becclys	becclys	Becclys
585936	Norwich	norwich	Norwich
585937	Bylston	bylston	Bylston
585938	Langley, Norf	langley\|norf	Langley	Norf	had_county
585941	Brayles, Warks	brayles\|warks	Brayles	Warks	had_county
585942	Dorn, Worcs	dorn\|worcs	Dorn	Worcs	had_county
585944	Pershore, Worcs	pershore\|worcs	Pershore	Worcs	had_county
585945	Pershore	pershore	Pershore
585946	Lygh	lygh	Lygh
585947	Hadley	hadley	Hadley
585948	Retyngdon	retyngdon	Retyngdon
585949	Magna Wakeryng	magna wakeryng	Magna Wakeryng
585950	Rayley	rayley	Rayley
585951	Winchester	winchester	Winchester
585953	Eppyng Heth	eppyng heth	Eppyng Heth
585954	Pynche	pynche	Pynche
585955	Hayward	hayward	Hayward
585957	Neuton Busshell	neuton busshell	Neuton Busshell
585958	Bishops Hyll	bishops hyll	Bishops Hyll
585960	Burneham	burneham	Burneham
585961	Dowenend	dowenend	Dowenend
585962	Comewyche	comewyche	Comewyche
585963	Brygewater	brygewater	Brygewater
585964	Louthe, Lincs	louthe\|lincs	Louthe	Lincs	had_county
585965	Bylston, Suff	bylston\|suff	Bylston	Suff	had_county
585966	Bryggewater, Soms	bryggewater\|soms	Bryggewater	Soms	had_county
585967	Gelyngham, Norf	gelyngham\|norf	Gelyngham	Norf	had_county
585968	Beclys	beclys	Beclys
585969	Lewys, Sussex	lewys\|sussex	Lewys	Sussex	had_county
585970	Oxford	oxford	Oxford
585971	Ryngwode	ryngwode	Ryngwode
585972	Abyngdon, Berks	abyngdon\|berks	Abyngdon	Berks	had_county
585973	Yevyll, Soms	yevyll\|soms	Yevyll	Soms	had_county
585974	Shaftesbury, Dorset	shaftesbury\|dorset	Shaftesbury	Dorset	had_county
585975	Shaftesbury	shaftesbury	Shaftesbury
585976	Cirencester, Glos	cirencester\|glos	Cirencester	Glos	had_county
585977	Gildeford, Surrey	gildeford\|surrey	Gildeford	Surrey	had_county

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE places (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    place_name TEXT NOT NULL,
    place_norm TEXT NOT NULL UNIQUE
, locality TEXT, county TEXT, flags TEXT);
CREATE INDEX idx_places_norm ON places(place_norm);
CREATE INDEX idx_places_locality ON places(locality);
CREATE INDEX idx_places_county ON places(county);