Police Force Areas (Dec 2021) EW BFE

Office for National Statistics

@ukgov.police_force_areas_dec_2021_ew_bfe

Table List

1 table(11.97 KB)

Table 1

@ukgov.police_force_areas_dec_2021_ew_bfe.table_1

11.97 KB
43 rows
10 columns

objectid OBJECTID	pfa21cd PFA21CD	pfa21nm PFA21NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E23000001	Metropolitan Police	517515	178392	-0.30866	51.49227	07c82189-4314-4965-928b-6803eedcbc7a	1591550118.94907	265991.957590933
2	E23000002	Cumbria	341868	527180	-2.90213	54.63638	10092918-f01f-4c11-85ae-d8c81ca3c123	7183708511.20192	578174.454694289
3	E23000003	Lancashire	363725	441045	-2.55307	53.86435	0cf3bd7f-23f8-4309-ad45-bb36cd748d2b	3261595893.10746	407149.624377167
4	E23000004	Merseyside	344342	390164	-2.83866	53.40536	081ad867-052b-4bde-8e52-c01c0601afe5	812298673.728943	254199.302964953
5	E23000005	Greater Manchester	377940	401102	-2.33407	53.50615	bdc5c169-d797-4252-83e6-7f0c82823146	1275981137.97517	248705.59357712
6	E23000006	Cheshire	368759	368676	-2.46927	53.21423	698b28cb-8bd6-4cdc-af6f-667a28cb72b6	2380269815.74028	348166.614647162
7	E23000007	Northumbria	398895	602529	-2.01896	55.31683	7dcb70cf-ea7d-4bfa-b349-a23223fc6d67	5629009491.23349	619496.037885604
8	E23000008	Durham	410381	532242	-1.8405	54.68513	57ca456d-cc46-4db9-96a5-30b310f31890	2430086904.99597	333997.992208103
9	E23000009	North Yorkshire	429509	466515	-1.55032	54.09371	ba87512e-65bb-4cdd-af7e-7f98c9a2f876	8324207399.77066	745710.579609714
10	E23000010	West Yorkshire	418686	427238	-1.71817	53.7412	71346f7a-e4f3-4969-9ec4-ba00c5a8c7a2	2029258668.6001	282889.642770856


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "pfa21cd" VARCHAR,
  "pfa21nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);