Counties (May 2021) Boundaries EN BFC

Office for National Statistics

@ukgov.counties_may_2021_boundaries_en_bfc

Table List

1 table(8.21 KB)

Table 1

@ukgov.counties_may_2021_boundaries_en_bfc.table_1

8.21 KB
24 rows
9 columns

objectid OBJECTID	cty21cd CTY21CD	cty21nm CTY21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length
1	E10000003	Cambridgeshire	520312	273864	-0.23506	52.34966	3052514925.75574	507388.953431785
2	E10000006	Cumbria	341868	527180	-2.90213	54.63638	6823534649.83325	1026705.11709395
3	E10000007	Derbyshire	426752	353556	-1.6021	53.07858	2550760412.9399	469089.428127809
4	E10000008	Devon	283143	93085	-3.65698	50.72558	6566736281.25592	1115285.32642735
5	E10000011	East Sussex	564123	117996	0.334559	50.93805	1712766558.25084	353073.166368492
6	E10000012	Essex	575270	215407	0.54106	51.80982	3465997071.41582	1736668.27861225
7	E10000013	Gloucestershire	389595	213465	-2.15235	51.81971	2652532055.96023	535353.007418559
8	E10000014	Hampshire	452859	127536	-1.24735	51.04474	3678348783.41247	787493.635790894
9	E10000015	Hertfordshire	518883	213642	-0.27699	51.80879	1643064814.89599	302890.887989407
10	E10000016	Kent	590249	147268	0.72137	51.19295	3545511143.99335	781668.062502518


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cty21cd" VARCHAR,
  "cty21nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);