Community Safety Partnerships (December 2022) EW BUC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2022_ew_buc

Table List

1 table(41.83 KB)

Table 1

@ukgov.community_safety_partnerships_december_2022_ew_buc.table_1

41.83 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	348611816.21056	107062.696328706	25bd28e7-c60d-4295-bce2-57da33dcb205
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.47115	111321249.288754	77597.7715711395	693616aa-da21-47e4-bc46-e28d00be5ae3
3	E22000003	North Somerset	347614	166718	-2.75438	51.39706	373571728.205936	114746.543242535	427af039-64cd-4ce2-899b-37bd78354777
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.54673	500483844.765163	114719.593974583	3554bc2b-4015-4cb3-9b2a-a7b8ac6f8171
5	E22000009	Bedford	505721	256463	-0.45463	52.19628	475803430.176064	115931.402375604	4ff1f4e7-f5e3-4c8a-9e0c-a10d5e667d5d
6	E22000010	Luton	508606	222559	-0.42319	51.89102	44068117.7992706	30772.5559397546	15255e98-d9cb-4d5e-ba32-ee061eccaaf5
7	E22000013	Cambridge	545420	257901	0.126436	52.20017	40206167.0286865	30617.9932498982	c830338a-b9f3-40ff-8837-9a89ec9ade95
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.35788	657743069.846176	166638.054583718	781d70aa-d795-48b5-972c-90b1b3d1c6e9
9	E22000015	Fenland	536361	294959	0.009016	52.53544	548320827.811447	136403.362605862	b380d74a-3f67-457d-b0eb-40034f123ccf
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.35315	911217830.577621	193568.099243412	1ac4b607-8b3b-40af-aa3b-398127349fb8


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