Sustainability And Transformation Partnerships (April 2021) EN BUC (V2)

Office for National Statistics

@ukgov.sustainability_and_transformation_partnerships_april_2_d0a93a98

Table List

1 table(12.56 KB)

Table 1

@ukgov.sustainability_and_transformation_partnerships_april_2_d0a93a98.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	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E54000007	Greater Manchester Health and Social Care Partnership	383161	401102	-2.25535	53.50635	f9283d67-9980-4480-b818-983bf88f4133	1401511558.72661	215637.871716204
2	E54000008	Cheshire and Merseyside	374405	380936	-2.38572	53.32473	815800cd-0dce-4080-a1ca-808003e351b1	2989759522.26178	426681.572590088
3	E54000009	South Yorkshire and Bassetlaw	447764	393041	-1.28256	53.43201	638f1109-e33f-4819-af07-1a013d1fd7b2	2189847398.5845	278206.161859417
4	E54000010	Staffordshire and Stoke on Trent	398243	334651	-2.02756	52.9093	51925b31-8c2c-43b6-91b9-1044dda126f2	2724139258.91841	349804.537358452
5	E54000011	Shropshire and Telford and Wrekin	350226	302960	-2.73668	52.62212	fab3f0c7-e06c-4b5e-9822-ee8a9f51d2e1	3483524784.5071	404498.203031894
6	E54000012	Joined Up Care Derbyshire	426752	353558	-1.6021	53.0786	e3240aea-b5bf-4709-8c6e-fc0cd74b437a	2497617402.39053	317081.460659007
7	E54000013	Lincolnshire	517984	358538	-0.23884	53.11101	27283049-6f1f-4287-a48e-3cbfcc0dde9c	5950075929.81551	485760.091192876
8	E54000014	Nottingham and Nottinghamshire Health and Care	466571	348422	-1.00883	53.02897	bb6053a9-30ed-4532-b4f0-760e8334bb17	1521635838.68509	202553.213149871
9	E54000015	Leicester, Leicestershire and Rutland	466552	310188	-1.0169	52.68532	ad81dc11-f81c-4178-acff-165ea5b797e0	2556246875.40918	276383.17646365
10	E54000016	The Black Country and West Birmingham	397824	291641	-2.03349	52.52265	45871b5c-9e6d-45a3-8780-ad3ab09a66ad	387510822.519432	110039.489133244


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