Community Safety Partnerships (Dec 2020) EW BGC

Office for National Statistics

@ukgov.community_safety_partnerships_dec_2020_ew_bgc

Table List

1 table(41.06 KB)

Table 1

@ukgov.community_safety_partnerships_dec_2020_ew_bgc.table_1

41.06 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	351158364.257771	137360.570458013	bcfc4ae2-11be-4c5c-84bc-99ee9e2ff99a
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109674473.802296	104654.689607863	356483af-e602-48c7-9a84-cb5cab5f1939
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	374666737.154278	148633.566861282	b2049cd8-2634-45b4-8b57-d4db4bab2707
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	497029582.921387	137985.98543062	e16412be-8298-4bb9-84c7-fe0923fb29e9
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476378677.238068	129908.872540076	21031e43-5a4f-4a1d-88f3-6b142c0bcf28
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43359040.1051331	34269.1249342676	b2b7b302-947a-4592-a030-874950f632cf
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40707275.2701416	36893.5946428477	b7b985cf-4d8e-4356-bac2-7364fc064f5d
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651264659.62056	231692.121494975	62dd4fb7-e728-496b-a1dc-2b23c94666ee
9	E22000015	Fenland	536361	294959	0.009016	52.53544	546475075.039474	186361.538074744	9f86b986-fd20-45df-bb24-331b23928459
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912555215.566505	220432.975387594	01f790d5-1950-484f-ad0b-40f48dea2287


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