Counties (December 2023) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2023_boundaries_en_bgc

Table List

1 table(9.55 KB)

Table 1

@ukgov.counties_december_2023_boundaries_en_bgc.table_1

9.55 KB
21 rows
10 columns

fid FID	cty23cd CTY23CD	cty23nm CTY23NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E10000003	Cambridgeshire	520313	273863	-0.23504	52.34965	3052692364.36432	501802.505862412	73c50404-1316-47a2-bc15-d5a13f65d2b1
2	E10000007	Derbyshire	426751	353559	-1.60212	53.07861	2550855701.63541	455362.714699443	431b556b-4d27-4869-b4de-e1f61554a09f
3	E10000008	Devon	283143	93085	-3.65698	50.72558	6566708399.96059	1032003.68110504	e551c490-5699-470a-9a43-0a9c49f672af
4	E10000011	East Sussex	564122	117996	0.334545	50.93805	1712885170.71385	340283.337930174	ce41360a-010c-4a5a-9b40-13f9afccddf8
5	E10000012	Essex	575269	215409	0.541047	51.80984	3464874825.61353	1538716.17460117	cb8a6c5c-59fd-4711-9ab8-38ed16669f1e
6	E10000013	Gloucestershire	389595	213466	-2.15235	51.81972	2652504429.74343	520615.298501807	9b64e638-75a6-440c-a1fb-d9d660964b83
7	E10000014	Hampshire	452857	127536	-1.24737	51.04474	3678222366.41877	722593.576546118	aeadd991-cdc7-4b02-8337-976a05dd38ab
8	E10000015	Hertfordshire	518880	213639	-0.27703	51.80876	1643003549.81266	298579.833329507	1f01d823-bccb-4246-8346-2c7548850bc6
9	E10000016	Kent	590249	147268	0.72137	51.19295	3545271908.3791	723848.136186199	be33262b-513d-440e-92fe-d64fefdfc97f
10	E10000017	Lancashire	369784	440758	-2.46091	53.86216	2894497215.0536	945364.535408913	0e0ea36d-d22b-4661-8141-67ef647e3da0


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cty23cd" VARCHAR,
  "cty23nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);