Combined Authorities (December 2023) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2023_boundaries_en_bfc

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2023_boundaries_en_bfc.table_1

8.53 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	1275966379.66261	250386.779256902	140509a9-be6c-4049-ac31-f9d901ec30f4
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551536335.45305	288021.617047673	fadeac26-8f2a-40fa-a885-647586277499
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2029207949.36984	283437.438986907	825c09ff-0ce8-4d7e-9f46-66618fbfb019
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	731295634.369537	389406.863405376	47067bc6-89bb-47e9-b3b5-33708a72ea3c
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795107166.874969	329341.350133222	e7607cc4-2917-4942-8718-1ff4a35cd339
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	901699100.399864	256682.626435654	d9cd6f1b-a221-439d-a490-a6c8201f6eb3
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3395872144.50101	530322.502731286	97da7397-ea63-48d8-92c2-d9e37bab80b9
8	E47000009	West of England	366422	173495	-2.48469	51.45942	957833908.220596	265881.914743858	da7eb66c-5bb6-4ee3-a5af-e5d07bad4bad
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575616138.84398	378913.053258708	ef8081a5-7776-411a-a63e-b3ba06ca135b
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228065052.21637	618363.391247631	273ae08a-b5b3-4a50-a69c-7feacdcb1d7d


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