Regions (December 2021) EN BFE

Office for National Statistics

@ukgov.regions_december_2021_en_bfe

Table List

1 table(8.36 KB)

Table 1

@ukgov.regions_december_2021_en_bfe.table_1

8.36 KB
9 rows
10 columns

objectid OBJECTID	rgn21cd RGN21CD	rgn21nm RGN21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E12000001	North East	417314	600356	-1.72888	55.29701	697ed164-a247-4b27-aea0-3f4b4a2f6347	8675517224.52754	804893.926568233
2	E12000002	North West	350014	506279	-2.77239	54.44944	ae28169d-4bbf-4631-aa3d-a929fe9df36a	14913854031.7538	1066984.73046169
3	E12000003	Yorkshire and The Humber	446902	448736	-1.28714	53.93264	d45d822e-6c51-4f44-b90b-d716b131a8d4	15560353265.1432	982047.705103009
4	E12000004	East Midlands	477659	322635	-0.84969	52.79572	eb0afe17-2953-4f15-9673-fef057410453	15810723352.3732	1066495.44592951
5	E12000005	West Midlands	386294	295477	-2.20358	52.55697	9ea099e6-5806-4e98-90ec-2382ffcbac95	13003737567.1263	953773.391464697
6	E12000006	East of England	571078	263235	0.504207	52.24073	f4b72e63-e788-41f6-8cf7-77dd2a0d1ae4	19584692923.3288	1047595.80545311
7	E12000007	London	517515	178392	-0.30866	51.49227	777a3113-013a-4680-b06c-eda8104b016f	1594697003.16721	256347.90127523
8	E12000008	South East	470062	172924	-0.99311	51.45097	d74403ef-a161-4222-bec0-a2839c29acc9	19399927120.9067	1389475.40260051
9	E12000009	South West	285013	102567	-3.63346	50.81119	8b05345e-d5b5-4e9d-a732-ac049133ed80	24385283189.1768	2378388.67777273


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