Index Of Place Names (July 2016) In GB
Office for National Statistics
@ukgov.index_of_place_names_july_2016_in_gb
Office for National Statistics
@ukgov.index_of_place_names_july_2016_in_gb
CREATE TABLE table_1 (
"objectid_1" BIGINT,
"objectid" BIGINT,
"placeid" BIGINT,
"place15cd" VARCHAR,
"placesort" VARCHAR,
"place15nm" VARCHAR,
"splitind" BIGINT,
"popcnt" VARCHAR,
"descnm" VARCHAR,
"ctyhistnm" VARCHAR,
"ctyltnm" VARCHAR,
"ctry15nm" VARCHAR,
"cty15cd" VARCHAR,
"cty15nm" VARCHAR,
"lad15cd" VARCHAR,
"lad15nm" VARCHAR,
"laddescnm" VARCHAR,
"wd15cd" VARCHAR,
"par15cd" VARCHAR,
"hlth12cd" VARCHAR,
"hlth12nm" VARCHAR,
"regd15cd" VARCHAR,
"regd15nm" VARCHAR,
"rgn15cd" VARCHAR,
"rgn15nm" VARCHAR,
"npark15cd" VARCHAR,
"npark15nm" VARCHAR,
"bua11cd" VARCHAR,
"pcon15cd" VARCHAR,
"pcon15nm" VARCHAR,
"eer15cd" VARCHAR,
"eer15nm" VARCHAR,
"pfa15cd" VARCHAR,
"pfa15nm" VARCHAR,
"gridgb1m" VARCHAR,
"gridgb1e" BIGINT,
"gridgb1n" BIGINT,
"grid1km" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"globalid" VARCHAR,
"x" BIGINT,
"y" BIGINT
);
Anyone who has the link will be able to view this.