Local Enterprise Partnerships (December 2022) EN BGC V2

Office for National Statistics

@ukgov.local_enterprise_partnerships_december_2022_en_bgc_v2

Table List

1 table(11.62 KB)

Table 1

@ukgov.local_enterprise_partnerships_december_2022_en_bgc_v2.table_1

11.62 KB
38 rows
10 columns

fid FID	lep22cd LEP22CD	lep22nm LEP22NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E37000001	Black Country	397407	292505	-2.03964	52.53042	356957268.94751	127706.163290557	f990bc1c-0d42-4f45-bccd-d2d0585b9695
2	E37000003	Cheshire and Warrington	368759	368676	-2.46927	53.21423	2266937231.82121	458387.868333393	bbbe20b8-5d1c-4660-8b15-c7f86be0057e
3	E37000005	Cornwall and Isles of Scilly	212497	64493	-4.64254	50.45022	3565048464.6077	1220429.20956726	f0c3e87e-495b-4245-87d6-abef24c14e42
4	E37000006	Coventry and Warwickshire	429584	266723	-1.5676	52.29785	2076141971.47845	356723.731613168	b9a38d07-7497-4967-bfb4-24e2807c6426
5	E37000007	Cumbria	341868	527180	-2.90213	54.63638	6823152161.95808	977789.067671989	8c840da4-d625-4e79-9737-ff497d13cdb7
6	E37000009	Dorset	375742	99796	-2.34556	50.7972	2653067260.09401	641320.838506383	bce2271a-94ec-411e-a052-ea7019bed02c
7	E37000011	GFirst	389595	213465	-2.15235	51.81971	2652600497.63037	520180.475425215	27741b5e-f4ba-4177-90f2-c70c923ed9b8
8	E37000012	Greater Birmingham and Solihull	399202	274029	-2.01313	52.36432	1743773060.63436	507425.555843639	44dd7593-1cf3-4d8d-b1a9-4ec4794fc7d3
9	E37000015	Greater Manchester	377940	401102	-2.33407	53.50615	1275915286.64671	242523.000857112	3c713dae-7cf9-4737-9d14-4960cf1bdb0d
10	E37000016	Heart of the South West	282430	97158	-3.66838	50.76205	10161284880.4911	1338710.2532724	fff0313b-cd97-4d1f-8579-f558afded0e3


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