Regions (December 2023) Boundaries EN BSC

Office for National Statistics

@ukgov.regions_december_2023_boundaries_en_bsc

Table List

1 table(8.32 KB)

Table 1

@ukgov.regions_december_2023_boundaries_en_bsc.table_1

8.32 KB
9 rows
10 columns

fid FID	rgn23cd RGN23CD	rgn23nm RGN23NM	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	8596682768.40045	788027.597977175	fd7f665d-059c-400f-baa9-f40866a497a7
2	E12000002	North West	350014	506279	-2.77239	54.44944	14163170032.859	1411596.70884213	3725ef7b-8ad3-45eb-b466-fd5611e3ffa6
3	E12000003	Yorkshire and The Humber	446902	448736	-1.28714	53.93264	15426022154.1921	928879.90127012	3271e3b8-47f9-47be-a379-536b26e0485f
4	E12000004	East Midlands	477658	322635	-0.8497	52.79572	15648615721.1071	974362.740806437	babe8425-857e-44fa-a328-409ea3df4db1
5	E12000005	West Midlands	386293	295477	-2.2036	52.55697	13005160788.7505	833972.493041374	2a8eed9d-14ca-4475-8415-4e49fa6422bd
6	E12000006	East of England	571076	263235	0.504178	52.24073	19145019559.3575	1470204.64635094	9e648392-4236-4e7b-bb56-f04c42fd6546
7	E12000007	London	517517	178394	-0.30863	51.49228	1574289382.33127	350268.711449644	22f4ba5f-249b-441b-9baa-0370f2863c0e
8	E12000008	South East	470064	172925	-0.99308	51.45098	19098236081.4549	1696848.78854773	b3bfda25-b630-493c-9cfd-8d3b5b780f8f
9	E12000009	South West	285016	102566	-3.63342	50.81118	23861907201.6625	2298989.24103073	16f828cb-ebb9-4610-8891-e5dd1602b52b


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