Regions (December 2021) EN BGC

Office for National Statistics

@ukgov.regions_december_2021_en_bgc

Table List

1 table(8.36 KB)

Table 1

@ukgov.regions_december_2021_en_bgc.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	b059f821-7da6-437e-ae22-cc20a5bfe83d	8598909309.86214	1001080.35972184
2	E12000002	North West	350014	506279	-2.77239	54.44944	8dc0f385-c680-4f15-bdf5-7f32d393372b	14163659383.3756	2261590.59757452
3	E12000003	Yorkshire and The Humber	446902	448736	-1.28714	53.93264	15a69a39-59b4-4d7b-bfdd-b4902d4651b4	15408647982.2749	1364415.20389628
4	E12000004	East Midlands	477659	322635	-0.84969	52.79572	5d9ab5f2-11e4-498a-a784-339449038ee9	15642193886.1087	1811280.69027971
5	E12000005	West Midlands	386294	295477	-2.20358	52.55697	e91991d4-2f00-4e76-9dce-50a0d011e2e7	13003733865.8613	921249.745397975
6	E12000006	East of England	571078	263235	0.504207	52.24073	dc237f1c-31c0-4b47-a449-f0f4c2025674	19130029231.068	3566349.34079948
7	E12000007	London	517515	178392	-0.30866	51.49227	2e765c71-01f3-4d3f-a9ec-452129b211e7	1573359367.21928	418599.443401155
8	E12000008	South East	470062	172924	-0.99311	51.45097	cae19f31-8754-4848-816f-e37e977df039	19087185332.5717	2585170.20924097
9	E12000009	South West	285013	102567	-3.63346	50.81119	199131a2-730c-4277-8ba3-e871894b5a63	23849977055.026	3303092.79922547


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
);