Combined Authorities (December 2022) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_december_2022_boundaries_en_bfe

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2022_boundaries_en_bfe.table_1

8.53 KB
10 rows
10 columns

fid FID	cauth22cd CAUTH22CD	cauth22nm CAUTH22NM	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	377940	401102	-2.33407	53.50615	1275981144.284	248689.705337219	c3061148-2411-48db-be07-9968ef7798a7
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1552077412.2113	251977.784429272	4b2f1911-8868-4042-821b-e99e10b56381
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029258521.09647	282884.856552968	501cc310-4781-4211-9d1f-6a534d7c4614
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	902620159.080994	273319.106957278	4476c03f-09d1-4b87-9f04-acceec95a505
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	813898560.188309	257007.174954657	c0a8f1ad-0e8a-471b-9f8f-754bdd30a1b1
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901639614.382088	256417.079090854	41302feb-ad93-40a9-8024-9eb8c781038c
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3397445431.85711	428245.072611872	32130945-37fc-48be-b014-cc0b4b3af2a7
8	E47000009	West of England	366423	173496	-2.48467	51.45943	1123323558.32329	311262.643758915	3fddcdbf-a0f0-43dc-891f-32e59f9bb282
9	E47000010	North East	413490	537463	-1.79204	54.73197	2583330522.60086	329380.900806101	ef38b20e-768e-48bb-a64a-8e607b73f66c
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5278277620.18954	566891.068163554	81302483-cf6d-4cad-8025-6143a3a5155c


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