Sustainability And Transformation Partnerships (April 2021) EN BFC

Office for National Statistics

@ukgov.sustainability_and_transformation_partnerships_april_2_bccfe430

Table List

1 table(12.56 KB)

Table 1

@ukgov.sustainability_and_transformation_partnerships_april_2_bccfe430.table_1

12.56 KB
42 rows
10 columns

objectid OBJECTID	stp21cd STP21CD	stp21nm STP21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E54000007	Greater Manchester Health and Social Care Partnership	383161	401102	-2.25535	53.50635	1402057510.69281	258431.704568869	a65cbaa6-fe94-4258-b462-f4dc2a0e28d3
2	E54000008	Cheshire and Merseyside	374405	380936	-2.38572	53.32473	3031700005.89432	772580.10396224	e472dcbc-a13e-42d7-9fcd-0ba5adcd14ff
3	E54000009	South Yorkshire and Bassetlaw	447764	393041	-1.28256	53.43201	2189401675.03773	361741.045830642	7079de88-e6d3-465f-8b55-2e8ebe711196
4	E54000010	Staffordshire and Stoke on Trent	398243	334651	-2.02756	52.9093	2716766581.59096	437360.146621383	f252f9c0-bc2d-43b6-8e39-651349c54442
5	E54000011	Shropshire and Telford and Wrekin	350226	302960	-2.73668	52.62212	3487616586.65537	497026.935577436	a464a2b1-c4e0-429d-819c-9d48bee2b185
6	E54000012	Joined Up Care Derbyshire	426752	353558	-1.6021	53.0786	2502707042.50641	398175.602142321	73c7cf76-be2c-4d8c-9288-6f576b1f4f2c
7	E54000013	Lincolnshire	517984	358538	-0.23884	53.11101	5937298572.65771	1306987.76542935	b8f7775e-3cdc-4891-bfa6-76881fb06723
8	E54000014	Nottingham and Nottinghamshire Health and Care	466571	348422	-1.00883	53.02897	1521517420.29848	249714.976998163	8588eedb-6521-45c1-9c91-01f8991d194d
9	E54000015	Leicester, Leicestershire and Rutland	466552	310188	-1.0169	52.68532	2550866048.00472	342565.518671311	b0d4f955-50d9-4785-94a0-dbe14a86bba5
10	E54000016	The Black Country and West Birmingham	397824	291641	-2.03349	52.52265	389855758.067337	139598.445712787	2736cd38-a3ef-40d6-8be8-9e212aa4f277


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "stp21cd" VARCHAR,
  "stp21nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);