Community Safety Partnerships (December 2022) EW BFC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2022_ew_bfc

Table List

1 table(42.01 KB)

Table 1

@ukgov.community_safety_partnerships_december_2022_ew_bfc.table_1

42.01 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	351122231.123779	141674.013988052	9555aadf-185f-45a3-bcf4-c9b3f7f10ce6
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	109666892.551918	109531.617064517	2e254b1f-83a0-4c04-b987-366a6e6a1172
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	374636531.10976	154748.182939052	93462e04-f84c-46a8-9c86-256d5d0a4232
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	497050998.431568	143098.847233425	1709b5dc-8e43-4f85-8065-583ee117f04f
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	476408392.68708	131719.283474792	c352a46d-3556-4f0f-81e9-c8afb8817c7a
6	E22000010	Luton	508606	222559	-0.42319	51.89102	43352485.6740799	34569.1847138739	5206fe32-059d-4034-bb79-d515144f9b7b
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40698821.5531006	37169.1755199722	1af5e8df-763c-4be2-b37f-dba3c8d5cce9
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	651285998.080215	234186.37804255	50ef2c84-4e06-4a9e-90b3-f1bdbcc44a37
9	E22000015	Fenland	536361	294959	0.009016	52.53544	546450116.18045	187880.713056672	7c5f7735-d6e1-4d3a-9302-e02bf30ec521
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	912455230.882179	223334.10582777	00920613-bf06-41a1-b036-607072338351


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