Counties (December 2020) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2020_boundaries_en_bgc

Table List

1 table(10.05 KB)

Table 1

@ukgov.counties_december_2020_boundaries_en_bgc.table_1

10.05 KB
25 rows
10 columns

objectid OBJECTID	cty20cd CTY20CD	cty20nm CTY20NM	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	520312	273864	-0.23506	52.34966	3052691659.38935	501103.129418918	3e39e429-3968-44ca-a4b9-c1ead635d7a5
2	E10000006	Cumbria	341868	527180	-2.90213	54.63638	6823158081.46582	979927.97496151	6494139d-1358-4e76-a77a-aae9dfe88abc
3	E10000007	Derbyshire	426752	353556	-1.6021	53.07858	2550829158.21843	454845.502234306	a4c62a24-a282-465b-8bee-017d2e206604
4	E10000008	Devon	283143	93085	-3.65698	50.72558	6566764722.875	1032183.86873369	d347d988-4325-4691-a7d2-6f5dbd3b8b30
5	E10000011	East Sussex	564123	117996	0.334559	50.93805	1712848887.82708	339829.617403081	e380ab2d-cb21-46cf-8d97-55a14f9677ae
6	E10000012	Essex	575270	215407	0.54106	51.80982	3464895109.61125	1542572.42371868	3fdfbf26-e9dd-4d91-b11f-30d92a8f073a
7	E10000013	Gloucestershire	389595	213465	-2.15235	51.81971	2652602297.37598	520161.742315986	816aa6d6-d3f0-469a-9df6-b894acef3aac
8	E10000014	Hampshire	452859	127536	-1.24735	51.04474	3678205318.3101	721854.300036126	63716ffb-a408-4245-b729-5f91a90e4a78
9	E10000015	Hertfordshire	518883	213642	-0.27699	51.80879	1643004848.94437	298584.060473229	a456f635-c3de-438c-93ab-bea98f60c087
10	E10000016	Kent	590249	147268	0.72137	51.19295	3545289833.21954	725818.453324374	7a922572-525b-4ffa-9d05-983b5e3bbd53


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cty20cd" VARCHAR,
  "cty20nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);