Combined Authorities (December 2023) Boundaries EN BSC

Office for National Statistics

@ukgov.combined_authorities_december_2023_boundaries_en_bsc

Table List

1 table(8.54 KB)

Table 1

@ukgov.combined_authorities_december_2023_boundaries_en_bsc.table_1

8.54 KB
10 rows
10 columns

fid FID	cauth23cd CAUTH23CD	cauth23nm CAUTH23NM	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	1275591498.32161	218919.526988813	a240217b-34a3-46e0-ac08-f283ec2a2f81
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1552214811.43106	228532.324709467	6149d534-4d3a-410f-a779-5e0f5d1c61ce
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2030973211.91727	259913.208594125	d9cc33c8-8284-448b-bc10-45bbef327227
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	726276937.295952	269952.902253165	9b011808-6cb0-4756-a1c5-e31b87e9ca61
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795645493.225143	259877.085352866	5a40ef9c-4b99-4681-bcfd-40ab5826668e
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	900290475.372238	225954.408489701	516bdf29-bc55-4db4-9088-2a58a6a50860
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3399895216.82044	393322.67385341	47f6eb2e-e86f-4afd-a6d6-40d28c536d02
8	E47000009	West of England	366422	173495	-2.48469	51.45942	958181046.284584	206522.59603288	bfb08bbd-800f-4062-9eb5-16c5fe1132c5
9	E47000010	North East	413490	537463	-1.79204	54.73197	2577364000.38315	296447.623036613	124a3ca1-3121-4474-80fc-359133e540a4
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5223673274.79216	489388.959587299	972b3679-5af3-4780-840a-f438cdda95af


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