Community Safety Partnerships (Dec 2020) EW BFC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2020_ew_bfc

Table List

1 table(41.15 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2020_ew_bfc.table_1

41.15 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	351123213.756172	141684.814205707	42cfa22d-ec73-443e-b3b7-d4ad6b7792d8
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109666791.152557	108825.818390629	e9848ef9-0a04-444d-bae5-b68046022ef5
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	374637225.164967	154770.379664983	f89cc15d-c83f-4ee3-bcf6-5297ca296f44
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	497050934.303089	142552.758507811	8b0d4d4f-c355-4879-a0a2-dfe74555ae51
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476408299.162025	131721.268581354	7bac36c4-f032-4092-ac66-ec7a5bd6c528
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43352491.6456223	34569.6531192547	8d280f0a-105d-4799-8a19-27e40273b2a3
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40698794.9378357	37170.4431684224	2f349986-05ef-445e-910f-cf09f20518d2
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651286023.587433	234187.982764809	ae61cae4-3861-4847-ac8b-1c7ffd9774fe
9	E22000015	Fenland	536361	294959	0.009016	52.53544	546450057.413757	187882.168208324	e2744e32-2a3c-411b-a284-01c9b485bd4d
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912455239.158791	223338.133370288	e3523e8d-acf5-4912-885c-c1e0db0ff345


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