Combined Authorities (December 2021) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2021_boundaries_en_bgc

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2021_boundaries_en_bgc.table_1

8.58 KB
10 rows
10 columns

objectid OBJECTID	cauth21cd CAUTH21CD	cauth21nm CAUTH21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E47000001	Greater Manchester	377940	401102	-2.33407	53.50615	029ec499-26a2-4555-ad1e-3ea055fe89f0	1275915286.64671	242523.000857112
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	069e2944-9212-400a-ba14-0be275592aab	1551470274.47165	281530.822886876
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	148cca3c-a1c4-4bc2-af23-57621aed09b2	2029283766.86362	278457.524654844
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	c20c5f7b-1085-44bf-957e-1cf7d53e0bb3	731269064.774124	374183.590486601
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	b7f50c65-5f11-4260-b7cf-f7644f3755c8	795164320.665649	319504.693699205
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	8921a79b-b671-4ed6-8ab9-3a4c2c6a285a	901648135.389511	251141.971596295
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	9f570cf0-1fb8-4aae-9206-5794159003d7	3396122587.12255	522632.426043529
8	E47000009	West of England	366423	173496	-2.48467	51.45943	0b13314a-bea1-4cb6-9231-4fdbeadfa0a2	957859808.436832	254439.955933967
9	E47000010	North East	413490	537463	-1.79204	54.73197	39307b8c-9526-49d2-95d4-7b4df21dce99	2575654762.62698	368301.419950236
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	71835ad9-65f8-454b-8b6b-d7ada164d06d	5228090226.5695	595926.61025677


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cauth21cd" VARCHAR,
  "cauth21nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);