Community Safety Partnerships (Dec 2021) EW BUC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2021_ew_buc

Table List

1 table(41.99 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2021_ew_buc.table_1

41.99 KB
314 rows
11 columns

objectid OBJECTID	csp21cd CSP21CD	csp21nm CSP21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E22000001	Bath and North East Somerset	366217	161999	-2.48654	51.35604	c94e45cd-df22-4b70-8348-533d16aea00f	348611816.21056	107062.696328706
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	986c97dd-4d15-43d6-be80-21245e83529a	109333416.952518	64136.325025473
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	89f7d12f-0559-4825-a01b-f29ca00d9864	372142015.710533	109517.757193833
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	628d510a-3f3e-4889-bc36-35283321a935	522989103.414581	116032.414115091
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	eb914e01-f000-46f8-89db-e8c8f464e052	475803430.167877	115931.402375604
6	E22000010	Luton	508606	222559	-0.42319	51.89102	ec19f8b4-1cf9-458e-80b9-c616612a0536	44068117.7992706	30772.5559397546
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	e0b498a4-2690-4763-a279-a280be57ea7d	40207020.3266754	30618.5641218865
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	6be74b40-b679-42de-9047-7e64ea36c76e	657742533.360123	166638.442876232
9	E22000015	Fenland	536361	294959	0.009016	52.53544	04a4b8c5-2325-48eb-ba37-068dad231b14	548320875.846436	136403.379974394
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	bd3831d9-7a24-4b27-b5a4-9fc7ab3f4def	911218575.238808	193568.986000984


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "csp21cd" VARCHAR,
  "csp21nm" VARCHAR,
  "csp21nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);