Community Safety Partnerships (Dec 2020) EW BFE

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2020_ew_bfe

Table List

1 table(41.06 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2020_ew_bfe.table_1

41.06 KB
314 rows
10 columns

objectid OBJECTID	csp20cd CSP20CD	csp20nm CSP20NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E22000001	Bath and North East Somerset	366217	161999	-2.48654	51.35604	351123212.497639	141684.569708064	a84ecaa8-cdbe-4691-9806-eef1cdbbb64f
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	235441874.046032	145510.066245692	9df3a744-7937-477e-affe-507be7347c35
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	390467134.390469	140559.070612594	643635f6-2222-46f5-a116-2c8054c5dba4
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	536758393.395679	159839.662989842	817dc2b5-6b14-4867-bf3b-fd09c67328f3
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476408301.260986	131721.083517931	2ec32df0-f237-456b-878a-1a1edc095240
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43352491.4350586	34569.6026266023	bcb30e91-d4ed-43e6-9b7c-90cfcd299475
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40698797.9441071	37170.3582136235	72d8665a-4380-41d3-892f-12f0f8144d7b
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651720403.688766	192582.753569455	21d26736-54d9-4f35-b31c-25a0e71e0554
9	E22000015	Fenland	536361	294959	0.009016	52.53544	547355397.170364	153633.167713497	e74d811e-27bb-4b1a-900b-e89751a6ee2f
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912545826.526749	222221.183274939	b9bea442-9f24-4136-844c-94f247d4474a


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