Combined Authorities (December 2020) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_december_2020_boundaries_en_bfe

Table List

1 table(8.59 KB)

Table 1

@ukgov.combined_authorities_december_2020_boundaries_en_bfe.table_1

8.59 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	6fe0fab2-473f-4ea9-b7e3-1d0dd944902a
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.48311	1552093262.20369	251952.619091691	bbbea56d-08c5-45af-b137-ac4b40f0af67
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029258666.12598	282889.993305645	d5391bed-b30e-4909-861d-dd1b5582a86d
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	902716001.733818	274039.016170256	952d2b24-008e-434b-aefc-4e4749fd7a06
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	813892118.080887	257028.500995919	e65f7b17-0a69-4021-9e14-89688372fb28
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901639656.935059	256430.292771641	6ba969b1-de88-4ba2-9a28-ff573232de40
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3397445441.42753	428253.171952837	03407401-09d3-4d9a-9ca1-5fb0499e1461
8	E47000009	West of England	366423	173496	-2.48467	51.45943	1123323329.17044	311301.002825243	779f1f75-981c-4748-9fec-238ece891da1
9	E47000010	North East	413490	537463	-1.79204	54.73197	2583383673.97722	328782.211358147	22047125-b2a4-4d60-8ba6-c8cac444548d
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	5278220455.73418	566544.188447725	9b36c3d9-e432-4047-ae98-2a8ac4865341


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