Police Force Areas (Dec 2021) EW BFC

Office for National Statistics

@ukgov.police_force_areas_dec_2021_ew_bfc

Table List

1 table(11.96 KB)

Table 1

@ukgov.police_force_areas_dec_2021_ew_bfc.table_1

11.96 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	dea1d180-5a0e-4d80-afbc-2e089f00019b	1570510139.44302	436936.953745608
2	E23000002	Cumbria	341868	527180	-2.90213	54.63638	88139af1-e43b-4fe5-8cb5-78c6ee1d5e44	6823532586.99287	1026433.45956839
3	E23000003	Lancashire	363725	441045	-2.55307	53.86435	12c05e9e-18c4-4b5a-b8a9-1d4b273380b6	3067081094.00445	968255.28485323
4	E23000004	Merseyside	344342	390164	-2.83866	53.40536	cf24051e-5acf-4d31-9b84-c8526c74b972	652194684.51313	349686.439472223
5	E23000005	Greater Manchester	377940	401102	-2.33407	53.50615	ef5fe88c-19bd-41ad-9309-f2ad54e066fe	1275981137.97517	248705.59357712
6	E23000006	Cheshire	368759	368676	-2.46927	53.21423	508de435-43f1-4c75-8dee-323d256bf00b	2346087396.78014	489379.941691173
7	E23000007	Northumbria	398895	602529	-2.01896	55.31683	75cdbd3e-1435-4105-aedc-e45b8b54b9cc	5572238508.26054	772724.4406485
8	E23000008	Durham	410381	532242	-1.8405	54.68513	4011fc77-b252-40d1-86f4-4d143951850a	2428935014.7715	339015.052273987
9	E23000009	North Yorkshire	429509	466515	-1.55032	54.09371	6ae04324-5e3b-4ee5-a769-1a5929f06473	8311900556.37102	813758.499664398
10	E23000010	West Yorkshire	418686	427238	-1.71817	53.7412	fc84998b-9572-484a-b483-ddc2096e1d04	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
);