Community Safety Partnerships (December 2022) EW BGC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2022_ew_bgc

Table List

1 table(41.84 KB)

Table 1

@ukgov.community_safety_partnerships_december_2022_ew_bgc.table_1

41.84 KB
314 rows
11 columns

fid FID	csp22cd CSP22CD	csp22nm CSP22NM	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	351162481.349098	137361.544956717	67b33387-1e37-4794-94fc-5e721f009b37
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109684373.822365	110438.130514569	13dc97a1-a0a2-40c5-a9f5-6072c0b404d9
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	374667062.372784	148593.787829197	a00d945d-4cdf-4f5c-b67e-43e9bee64769
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	497027510.024757	141237.939918453	38e17134-6bbc-4238-8b47-d044671f37b5
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476350301.321297	129909.591702924	83e51a37-ed83-4962-9411-ceca697b03f2
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43358521.6528168	34269.1108387269	d9853372-1726-4041-88b0-a3bdd3da7635
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40710543.5061035	36901.199995128	8a2af2f6-6fae-4b4f-bf66-73a9b974a905
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651262151.136108	231678.248276357	0ef80c1c-ad62-4536-927c-903b964c525e
9	E22000015	Fenland	536361	294959	0.009016	52.53544	546490910.672073	192506.026461437	51632ac6-9b9c-47d9-a51e-71f3bf1ae22f
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912560545.608215	220576.67794001	518726b5-7e6c-4448-a606-56453ed5707e


CREATE TABLE table_1 (
  "fid" BIGINT,
  "csp22cd" VARCHAR,
  "csp22nm" VARCHAR,
  "csp22nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);