Combined Authorities (December 2020) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_december_2020_boundaries_en_buc

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2020_boundaries_en_buc.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	1273598337.7578	206057.361346331	2741fa23-c249-46dd-85ec-243eaa7ebe43
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.48311	1550439661.95709	213333.854596125	287f9112-a58d-4ef7-9b05-8051eeb1792d
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029163329.04822	240199.033100926	ea3b018c-646b-44da-993f-c32d402d53c0
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	724061449.240219	246602.851969865	fad6e6c4-c2bb-4629-b030-56b585dfcfd9
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	803648299.236298	220417.807850246	54be1a66-0ddc-48c1-bb53-c7a4f6e0337c
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	902348993.996651	206334.876999092	e49bb402-8f8a-44ad-b029-b63e0457a8e9
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3397579672.91154	369774.715909412	17dd1a2f-3a87-404a-b760-71998f436e1f
8	E47000009	West of England	366423	173496	-2.48467	51.45943	980934758.316257	183156.609129986	d72556ed-b265-43dc-95d4-c1019f69a090
9	E47000010	North East	413490	537463	-1.79204	54.73197	2578121442.16609	273669.655746941	5a2f5a8d-d083-4435-924f-949df58987a5
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	5224068740.65907	426505.65865066	61e7cfda-2c69-4a87-8dc5-7d554fa5a8e4


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