Combined Authorities (December 2019) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2019_boundaries_en_bgc1

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2019_boundaries_en_bgc1.table_1

8.58 KB
10 rows
10 columns

objectid OBJECTID	cauth19cd Cauth19cd	cauth19nm Cauth19nm	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.506149	1275916522.5007	242513.081813091	9ce51d44-ff59-424c-9e0a-5616c98a5c02
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.483109	1551480878.80183	281514.381096324	b51d4d10-499a-4149-bb0a-90be8547ec11
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.741199	2029283766.81836	278457.52457224	41aa0ee9-6c41-4c62-9238-2febe0f4c63c
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.405361	731289375.723564	374237.20429583	6b20257c-a94a-4439-9a1e-e1d45d68c83f
5	E47000006	Tees Valley	436953	521739	-1.42968	54.589512	795158358.322601	319950.210024287	d6d2ff3e-bf02-4798-9590-429afab2254a
6	E47000007	West Midlands	402507	289715	-1.96448	52.505341	901648135.389511	251141.971596295	eeb76b7f-78f1-45b0-9cc2-e8c822563e5b
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.327549	3396115505.24882	522624.297288447	9314bfc4-4fd6-4b1e-89c9-8d8c86a10d34
8	E47000009	West of England	366423	173496	-2.48467	51.459431	957904380.810909	256001.50099249	201ed9ca-494f-4f52-bbd2-412ca92524fd
9	E47000010	North East	413490	537463	-1.79204	54.731972	2575668170.93054	368767.219314073	f770ec2c-c1b2-4151-aed4-0ba67a722717
10	E47000011	North of Tyne	397235	600993	-2.0451	55.303028	5226629200.17209	593079.667528044	2686a684-68f9-4c30-beb5-6b679f054268


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