Police Force Areas (December 2023) EW BFE

Office for National Statistics

@ukgov.police_force_areas_december_2023_ew_bfe

Table List

1 table(11.93 KB)

Table 1

@ukgov.police_force_areas_december_2023_ew_bfe.table_1

11.93 KB
43 rows
10 columns

fid FID	pfa23cd PFA23CD	pfa23nm PFA23NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E23000001	Metropolitan Police	517517	178394	-0.30863	51.49228	1591478049.41156	266215.112305173	9061bbab-8fa6-4b33-9bd5-6697bec47d94
2	E23000002	Cumbria	341868	527180	-2.90213	54.63638	7184985215.65723	585520.050937391	5b1017c3-95bb-4872-8597-752cae7d7b2f
3	E23000003	Lancashire	363725	441045	-2.55307	53.86435	3261628864.45402	407898.291837629	ff255ee3-82f2-4f12-8bec-4d5675cbda34
4	E23000004	Merseyside	344345	390165	-2.83861	53.40536	812217587.668907	254332.282112262	3fe38c52-4c48-4da4-8e66-eea09a6ae547
5	E23000005	Greater Manchester	377929	401095	-2.33423	53.50609	1275966379.66261	250386.779256902	eaaf19a9-70de-4acb-8513-683cb344dbe4
6	E23000006	Cheshire	368761	368676	-2.46924	53.21423	2380200785.13551	349589.459401076	3b31ebf1-935b-4a8a-86cb-0229e8737e99
7	E23000007	Northumbria	398895	602527	-2.01896	55.31682	5629034214.68349	619858.274828165	a260ce51-b521-4546-a40f-8d92438e0d2d
8	E23000008	Durham	410383	532242	-1.84047	54.68513	2430068162.51381	334464.954176517	5e4c93ec-fa77-4e59-92a1-eca81903b4c6
9	E23000009	North Yorkshire	429508	466514	-1.55033	54.0937	8324333027.80168	746545.812916841	0b08af36-083b-453d-949b-a495fc4da54b
10	E23000010	West Yorkshire	418683	427238	-1.71822	53.7412	2029207949.36984	283437.438986907	d00fb092-09cf-4c1c-9a34-5ab2fd497455


CREATE TABLE table_1 (
  "fid" BIGINT,
  "pfa23cd" VARCHAR,
  "pfa23nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);