Community Safety Partnerships (Dec 2019) EW BFE

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2019_ew_bfe

Table List

1 table(41.1 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2019_ew_bfe.table_1

41.1 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	cf3975ca-e06f-4875-b7e4-a51ef2531e54
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	235425227.005074	144906.000740432	c29ded2b-ed84-46ff-9f22-4767ca89053c
3	E22000003	North Somerset	347613	166719	-2.75439	51.39707	390703956.916718	140593.473484182	1924bb61-d70f-421f-ae7f-cbdce69d4485
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	536421923.792049	160083.21886569	e95e1a58-e936-4c67-bee3-72ad6e5a733e
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476408299.165596	131721.268581354	3b21b315-03eb-4bc8-a507-f8a889bafb3b
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43352491.6456223	34569.6531192547	cacde24c-586a-4880-a841-7c9d20bce769
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40698794.9341431	37170.4431684184	10b73096-ca88-46a3-99c3-346f60d58588
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651720399.886719	192583.138286311	73bdfb77-4d6c-4e2b-9f0b-3df97492eb7f
9	E22000015	Fenland	536361	294959	0.009016	52.53544	547355396.694702	153633.528197865	deb965d0-f88a-4a6b-821a-00c07ef0684c
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912545831.512291	222221.64338218	76ec9813-d454-453c-b63f-b6fa1c050777


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