NHSPD Online Latest Centroids
Office for National Statistics
@ukgov.nhspd_online_latest_centroids4
Office for National Statistics
@ukgov.nhspd_online_latest_centroids4
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"pcd2" VARCHAR,
"pcds" VARCHAR,
"dointr" DOUBLE,
"doterm" DOUBLE,
"oseast100m" DOUBLE,
"osnrth100m" DOUBLE,
"oscty" VARCHAR,
"odslaua" VARCHAR,
"oslaua" VARCHAR,
"osward" VARCHAR,
"usertype" DOUBLE,
"osgrdind" DOUBLE,
"ctry" VARCHAR,
"oshlthau" VARCHAR,
"rgn" VARCHAR,
"oldha" VARCHAR,
"nhser" VARCHAR,
"sicbl" VARCHAR,
"psed" VARCHAR,
"cened" VARCHAR,
"edind" VARCHAR,
"ward98" VARCHAR,
"oa01" VARCHAR,
"nhsrlo" VARCHAR,
"hro" VARCHAR,
"lsoa01" VARCHAR,
"ur01ind" VARCHAR,
"msoa01" VARCHAR,
"cannet" VARCHAR,
"scn" VARCHAR,
"oshaprev" VARCHAR,
"oldpct" VARCHAR,
"oldhro" VARCHAR,
"pcon" VARCHAR,
"canreg" VARCHAR,
"pct" VARCHAR,
"oseast1m" DOUBLE,
"osnrth1m" DOUBLE,
"oa11" VARCHAR,
"lsoa11" VARCHAR,
"msoa11" VARCHAR,
"calncv" VARCHAR,
"icb" VARCHAR,
"oa21" VARCHAR,
"lsoa21" VARCHAR,
"msoa21" VARCHAR,
"globalid" VARCHAR
);
Anyone who has the link will be able to view this.