Combined Authorities (May 2024) Boundaries EN BSC

Office for National Statistics

@ukgov.combined_authorities_may_2024_boundaries_en_bsc

Table List

1 table(8.66 KB)

Table 1

@ukgov.combined_authorities_may_2024_boundaries_en_bsc.table_1

8.66 KB
11 rows
10 columns

fid FID	cauth24cd CAUTH24CD	cauth24nm CAUTH24NM	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	377929	401095	-2.33423	53.50609	1275599081.31169	220341.825887705	477632af-d0eb-4605-a9e4-f6a593b66236
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1552501023.4711	228192.532495699	1056cdea-b32f-4012-a441-9f745804b56a
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2030457121.19038	259815.086847668	02d70e38-2a05-4281-9825-c839d4a8448d
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	726832533.986221	270433.662110696	4e0e962d-aeb0-4e99-aeab-e816e1051370
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795833628.001846	260313.259202284	31705e97-c7ac-485a-adee-934400b43206
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	899819395.937126	226441.302126299	cd96e390-e859-441f-ac0b-6d56248ae249
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3399035664.96375	393888.654629662	736dfafc-8d41-429e-8247-1f6bf9827920
8	E47000009	West of England	366422	173495	-2.48469	51.45942	958709118.491402	194948.640967571	0dbeb5eb-2947-47fc-9268-9e49eebf584f
9	E47000012	York and North Yorkshire	429508	466514	-1.55033	54.0937	8315711737.34366	651842.521026044	2f389b97-7fc7-431f-b9c8-3931a6a5ec41
10	E47000013	East Midlands	449616	357963	-1.26015	53.11656	4789154221.96925	495618.561545412	8cb47685-acc5-4fe2-97bf-e37ff2e4d4b1


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cauth24cd" VARCHAR,
  "cauth24nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);