Combined Authorities (December 2023) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_december_2023_boundaries_en_buc

Table List

1 table(8.54 KB)

Table 1

@ukgov.combined_authorities_december_2023_boundaries_en_buc.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	1273633508.15593	206125.590904917	8f21142e-f6bd-4b7b-8232-765e41e9c21f
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1549413633.39879	213365.900834407	c5300ac5-c3cc-4a9a-9694-060335d33f0a
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2030451396.09381	240550.696410954	9d94260f-645e-408f-90ca-0bd049178d6c
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	725227567.637413	282941.984509219	0f26f812-361a-4e3e-867e-e38aac1ee767
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	803562296.165527	224838.105488725	28806559-9a9a-48cc-aef4-f24d8068a2c1
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	902418076.487282	206338.231657785	286b0b8c-94c4-4ab0-8d03-9de1a1857ecb
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3397865071.55595	369739.302161805	5724c3ee-780b-4ad7-ade4-920889d8a28b
8	E47000009	West of England	366422	173495	-2.48469	51.45942	960246845.165424	193606.578091496	90e0cd58-fce4-4f8c-a51c-92fa61a161d1
9	E47000010	North East	413490	537463	-1.79204	54.73197	2576859759.64096	278539.483859152	bd61b938-8c50-493d-961d-3c0b57ec5e5f
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228238983.52217	457635.071461295	604dc1b4-80ac-4059-bad9-a72656b978ed


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