Community Safety Partnerships (Dec 2019) EW BUC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2019_ew_buc

Table List

1 table(41.04 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2019_ew_buc.table_1

41.04 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	348611816.21056	107062.696328706	5289df69-f6e9-4eeb-aa70-e65f17c76176
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	110320041.55611	58260.2369001144	bb204d00-0639-4cb4-b633-aba416a05e4a
3	E22000003	North Somerset	347613	166719	-2.75439	51.39707	374705235.582317	113129.327916102	6355daff-88de-46f4-9910-909987c154f1
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	499853753.458225	113237.408942735	883f1ab4-b27d-4f94-bb3e-d73dcc893b19
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	475803430.167877	115931.402375604	bc9f3474-4113-47dc-a865-63474675950c
6	E22000010	Luton	508606	222559	-0.42319	51.89102	44068117.7992706	30772.5559397546	31109fab-1cae-465e-b7a9-61f552c374be
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40207020.3266754	30618.5641218865	dc0121f8-7b00-4fd6-83ef-78d2faa7fe9a
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	657791099.504105	166511.834410467	183b52c1-daf4-4d3a-8347-6b9250e01510
9	E22000015	Fenland	536361	294959	0.009016	52.53544	548030831.674225	136162.468747786	a5bae59a-ef49-4736-b687-1a72406cfedd
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	911554648.786415	193610.927760647	c7cf513a-d97a-4b0d-a370-2162bf764d20


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