Community Safety Partnerships (Dec 2020) EW BUC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2020_ew_buc

Table List

1 table(41.18 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2020_ew_buc.table_1

41.18 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	348611814.493904	107062.696416252	26390314-2dad-4c1d-857b-f75c667355b6
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109330796.983871	63557.8612004235	602e54e5-6531-43bb-a351-09a673c147b8
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	372311827.052864	109731.313864662	62f4cfd5-4d03-4c7c-8a19-2356175f8e6d
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	522992145.367832	116032.943494706	b3837f1b-2cab-487c-81df-a4dd207012b6
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	475803430.167877	115931.402375604	54eb25e2-cbaa-4df3-bda7-0ed5126361fc
6	E22000010	Luton	508606	222559	-0.42319	51.89102	44068117.7992706	30772.5559397546	1fb99bad-a6f7-485d-918f-23973d8a7671
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40207020.3266754	30618.5641218865	eb7b84e2-e991-4eb4-b65b-19eb020cd8de
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	657742533.763306	166638.442939476	1227aaa7-acd4-427d-a898-0a16b597f9f3
9	E22000015	Fenland	536361	294959	0.009016	52.53544	548320875.846436	136403.379974394	ad3528e3-1b83-461c-9d2c-a2f8d63d34eb
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	911218575.238808	193568.986000984	e0c8d6ae-d648-403a-b327-404c5ccb0d86


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