Community Safety Partnerships (Dec 2021) EW BFE

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2021_ew_bfe

Table List

1 table(41.91 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2021_ew_bfe.table_1

41.91 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	f4e9a55d-df43-4dd0-a8ca-f48fc7aa7349	351123212.497639	141684.569708064
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	6aae8ed9-0e15-4f4b-be30-980e527bd10d	235441874.046032	145510.066245692
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	3950166d-73b9-4d12-bbaa-096f4cdc7793	390467134.391697	140559.058594278
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	68f8e0df-066c-4ecb-9b5a-fa4a73542192	536758434.528671	159839.66611388
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	0ab56b2c-ad25-4a94-b5dc-bf145a1e776c	476408301.260986	131721.083517931
6	E22000010	Luton	508606	222559	-0.42319	51.89102	d2f42143-0692-4ffb-887e-6f3de1ba3634	43352491.4350586	34569.6026266023
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	a6752d52-e28e-4097-9375-3674f625aa7a	40698797.9441071	37170.3582136235
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	b37aca24-1c38-4c60-a985-bfed35e0f355	651720403.688766	192582.753569455
9	E22000015	Fenland	536361	294959	0.009016	52.53544	75bf071f-c623-4cc0-8fe3-5210b8b84e6e	547355397.170364	153633.167713497
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	7ff6c248-4020-4412-b92f-f4882447cc8d	912545826.526749	222221.183274939


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
);