Combined Authorities (December 2023) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2023_boundaries_en_bgc

Table List

1 table(8.54 KB)

Table 1

@ukgov.combined_authorities_december_2023_boundaries_en_bgc.table_1

8.54 KB
10 rows
10 columns

fid FID	cauth23cd CAUTH23CD	cauth23nm CAUTH23NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E47000001	Greater Manchester	377929	401095	-2.33423	53.50609	1275935270.13094	243234.154857328	32de3397-7228-4ac3-baa0-78805b178521
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551454099.80356	281657.009797073	0d049104-758b-4b1f-a5c4-f5fe3a0403c0
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2029230442.56143	278597.195034994	821a3216-4883-46f1-b653-3433d431cd95
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	731277160.278793	374239.268816708	6fd99f00-d8a3-48fe-b3bf-44287f685fcd
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795212503.746521	319488.488596224	2486d4e8-fe2d-41e7-bb82-0bbc57af8ce6
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	901676979.154747	251090.675892609	607c0ff9-1e28-4a55-bb3a-48e4d11af56f
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3396146424.86093	522926.119844617	52ae1d15-99a0-4331-8e35-9635d130bd94
8	E47000009	West of England	366422	173495	-2.48469	51.45942	957902871.846661	259792.058912019	d5ee4dbc-f507-470b-b9d3-0a66259bf8a5
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575591144.10088	368404.625759119	7b5fca53-8ebe-4314-8ec2-50338875103e
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228123992.27582	596097.249697397	f3715f6a-4e3d-4b1d-b5e5-e449d383d2ba


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