Combined Authorities (December 2020) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2020_boundaries_en_bfc

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2020_boundaries_en_bfc.table_1

8.58 KB
10 rows
10 columns

objectid OBJECTID	cauth20cd CAUTH20CD	cauth20nm CAUTH20NM	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	1275981137.66568	248706.074862127	0c8d00c9-f6da-4315-854e-645700d57b22
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.48311	1551564234.03366	287863.05555383	a136c518-fc63-4094-9fae-6c007fc5ad8d
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029258666.12598	282889.993305645	ad048380-4bc3-49e5-924d-83d6c475a9df
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	731278719.484932	389170.150984424	4bbfc938-a039-4764-b985-24a8800df171
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795072344.810562	329109.328978566	7acf9eda-5273-400b-b0bf-9f98ab4b45ae
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901639656.93718	256430.292771641	0f3ed1dc-45ad-4ee4-945b-a572c86a1e22
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3395893076.72215	529551.240172696	4b1f250d-552f-4d5a-8108-f15ef0c14c11
8	E47000009	West of England	366423	173496	-2.48467	51.45943	957840939.21233	264918.664457334	d0bb6588-c0de-4e23-854b-b2345f9ccedf
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575675701.54138	378122.187228529	68360229-ddb7-435f-b579-db1d148860f7
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	5228011420.37901	617675.862103425	298c1e4b-3be6-49db-98a6-e0f6ff19b8f2


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