Combined Authorities (December 2021) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_december_2021_boundaries_en_buc

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2021_boundaries_en_buc.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	05b8430a-fe49-4006-a3bb-4ce840fda67d	1273598337.12234	206057.361351532
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	d2f8412f-0287-40f6-9c29-76cbbd497f56	1550439660.66766	213333.854095139
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2f4adf32-2e60-45a8-a4b8-c316a1fff943	2029163330.00949	240199.032694552
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	2ded052c-d863-4916-852f-601657dc5784	724016287.4795	246634.702869028
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	9ad283a1-781d-4d36-a54f-ec6bfa348604	803648043.357056	220417.935549219
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	b2868b55-2064-4523-8bc1-84628306a247	902348993.609993	206334.877572412
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	19b12489-8d70-467d-8418-70546a82cdbb	3397579672.92561	369774.715386345
8	E47000009	West of England	366423	173496	-2.48467	51.45943	d80b24e0-ac81-41de-8f66-6f0bb0b3e880	980799631.755119	178123.536906629
9	E47000010	North East	413490	537463	-1.79204	54.73197	1cd81a4a-61d8-4a33-a189-867fafd317ec	2578071580.24741	273716.018016577
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	c3ce979f-5c5f-4751-81f4-8a6bb134a04d	5224118180.0076	426555.703540666


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