Community Safety Partnerships (Dec 2019) EW BFC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2019_ew_bfc

Table List

1 table(41.08 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2019_ew_bfc.table_1

41.08 KB
314 rows
10 columns

objectid OBJECTID	csp19cd CSP19CD	csp19nm CSP19NM	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	bf47b201-ea18-4c60-b590-ce76d3807e18
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109700128.6964	109722.849282357	3e645952-084e-44be-8be1-21e47c2a0591
3	E22000003	North Somerset	347613	166719	-2.75439	51.39707	374605310.994339	154190.82747873	563c6559-cd44-4a45-aca9-481d48a9a539
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	497035793.746422	141498.594060104	1c05af60-e9d1-465e-853b-9e05dbc97400
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476408299.162025	131721.268581354	c0349bb8-dae1-4a87-9995-f65931df4685
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43352491.6456223	34569.6531192547	af40e52b-be0d-4dd6-bb2e-17188021bb8b
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40698794.9341431	37170.4431684184	f653a421-4481-4230-bc47-198d89c47965
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651286023.596298	234187.982641903	c7d6918c-ef2e-443c-87d7-3aa030b2911b
9	E22000015	Fenland	536361	294959	0.009016	52.53544	546450057.397247	187882.168085419	73e62f62-5ab3-4607-8ca0-ef3c208835a8
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912455239.159904	223338.133370288	f9569895-0fcd-48cf-b138-1606165cef80


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