Combined Authorities (December 2019) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2019_boundaries_en_bfc1

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2019_boundaries_en_bfc1.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	1275981137.66568	248706.074862127	f5633213-f9c0-4a50-a095-644e7d76a29e
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.483109	1551564234.03366	287863.05555383	88c03123-d95d-4ec4-b278-d9c88e70787e
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.741199	2029258666.12323	282889.993363596	6a795aab-87ee-4f57-bb65-c2c7c29f3e8f
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.405361	731278719.48661	389170.150984436	ad419695-d8b5-4406-a978-7562972d0bd9
5	E47000006	Tees Valley	436953	521739	-1.42968	54.589512	795072335.780548	329113.819643083	6da15855-b7bf-48e6-9380-32799294e7c5
6	E47000007	West Midlands	402507	289715	-1.96448	52.505341	901639656.934853	256430.292771641	b386af38-df5c-44b6-8080-041004554db2
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.327549	3395893076.7163	529551.240172697	232d3cc5-e0ec-4bba-bdd8-70f262fc8ca9
8	E47000009	West of England	366423	173496	-2.48467	51.459431	957859136.199329	264761.530901356	9671fdf4-7c51-4514-a303-18c2cdd123cc
9	E47000010	North East	413490	537463	-1.79204	54.731972	2575698526.72215	378874.901902391	5d7d3c81-337d-46bc-bfff-e08bbc1bdbf7
10	E47000011	North of Tyne	397235	600993	-2.0451	55.303028	5226526905.77197	613525.179524207	80081f07-8687-4294-852e-155554af4f17


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