Regions (Dec 2020) EN BUC

Office for National Statistics

@ukgov.regions_dec_2020_en_buc

Table List

1 table(8.36 KB)

Table 1

@ukgov.regions_dec_2020_en_buc.table_1

8.36 KB
9 rows
10 columns

objectid OBJECTID	rgn20cd RGN20CD	rgn20nm RGN20NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E12000001	North East	417314	600356	-1.72888	55.29701	8605838482.06133	646532.079960146	a9a7f5ce-c85f-4fa2-8ea9-fc22d5ee4db5
2	E12000002	North West	350014	506279	-2.77239	54.44944	14177573672.423	1080404.61515613	3d56f576-e796-482e-b705-a0027eb0b4c4
3	E12000003	Yorkshire and The Humber	446902	448736	-1.28714	53.93264	15426739163.5468	874153.8329426	d61afce3-a645-495b-94a2-ac8848e95dcb
4	E12000004	East Midlands	477659	322635	-0.84969	52.79572	15658944810.3175	896271.54655634	b47b6c05-639c-4def-9e82-a93924360e21
5	E12000005	West Midlands	386294	295477	-2.20358	52.55697	13002151353.8657	774627.649694849	cf939565-315a-43e4-a87b-61d239850aee
6	E12000006	East of England	571078	263235	0.504207	52.24073	19151191341.4062	1081850.72273862	d98e954e-7b5f-423b-b59f-2a7ed9f4c35e
7	E12000007	London	517515	178392	-0.30866	51.49227	1584124665.03175	271231.442173954	8fb01971-e68d-4402-861b-3e4773a16d29
8	E12000008	South East	470062	172924	-0.99311	51.45097	19105631496.2037	1468849.12077244	733d32ba-8776-4306-a5b3-8b259f34e2a4
9	E12000009	South West	285013	102567	-3.63346	50.81119	23969358826.6181	1662106.02533701	120aab4b-449a-4108-b2f3-a20684e05bdd


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