Counties (December 2024) Boundaries EN BSC

Office for National Statistics

@ukgov.counties_december_2024_boundaries_en_bsc

Table List

1 table(9.54 KB)

Table 1

@ukgov.counties_december_2024_boundaries_en_bsc.table_1

9.54 KB
21 rows
10 columns

fid FID	cty24cd CTY24CD	cty24nm CTY24NM	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.23505	52.34966	3055706744.70654	390013.874580145	aa3e0653-38fc-4010-a958-d91bdd91313e
2	E10000007	Derbyshire	426751	353559	-1.60212	53.07861	2549754475.87484	405786.592797629	b03f1b27-7ca0-4bf6-825e-4571886e9861
3	E10000008	Devon	283144	93087	-3.65697	50.72561	6568379526.57364	768201.137609553	8b4a5705-e6fe-4223-a8c3-3e96102d3ec5
4	E10000011	East Sussex	564122	117996	0.334545	50.93805	1716047083.13582	232647.184191397	63d7d8e1-1896-4c32-8c85-0905b0b08cd8
5	E10000012	Essex	575269	215409	0.541047	51.80985	3471011375.16956	733336.578479146	a2fb5d05-8a1a-4c4d-8303-cccaa6e2c428
6	E10000013	Gloucestershire	389595	213466	-2.15235	51.81973	2655023089.2953	442358.251446741	afa405b3-cd45-4bc0-b356-4ec746c70bb2
7	E10000014	Hampshire	452857	127536	-1.24738	51.04475	3679218300.66402	545172.778406498	497f3bbe-d498-45bc-857e-7cf71829718b
8	E10000015	Hertfordshire	518880	213639	-0.27704	51.80876	1641183347.57044	278924.608191088	4a1f5672-8502-4045-a67e-0ddce63ffeb5
9	E10000016	Kent	590249	147268	0.72137	51.19296	3547626621.18093	463607.96925534	1f2ef0a2-a14f-4889-95b3-3def19f60e00
10	E10000017	Lancashire	369784	440758	-2.46092	53.86217	2894758548.70752	528334.70350405	ee9258ec-ae16-482a-ad5d-7a4f1b3bc5d5


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