Police Force Areas (Dec 2021) EW BUC

Office for National Statistics

@ukgov.police_force_areas_dec_2021_ew_buc

Table List

1 table(11.95 KB)

Table 1

@ukgov.police_force_areas_dec_2021_ew_buc.table_1

11.95 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	502da4de-ad1f-4671-9856-447010f424dc	1581447581.32798	278133.581834794
2	E23000002	Cumbria	341868	527180	-2.90213	54.63638	f70a6bbc-e1da-469a-abeb-d83245150b85	6832513380.97198	542080.495822445
3	E23000003	Lancashire	363725	441045	-2.55307	53.86435	13b6f7b7-b01d-4b93-9cb9-7a2cb05155e1	3083028216.64262	393111.188909906
4	E23000004	Merseyside	344342	390164	-2.83866	53.40536	26f83d37-67b7-428f-8f76-3c84875686d4	641123765.133186	219690.405892465
5	E23000005	Greater Manchester	377940	401102	-2.33407	53.50615	d6543dd2-829f-428d-a1fe-469083fc0077	1273598337.12234	206057.361351532
6	E23000006	Cheshire	368759	368676	-2.46927	53.21423	a6edc031-cdbd-4c78-81c8-5c01d06841f6	2347262002.54929	306353.714499473
7	E23000007	Northumbria	398895	602529	-2.01896	55.31683	c009f093-4c9b-4265-b926-47b54da4be95	5570201112.40924	475506.051113428
8	E23000008	Durham	410381	532242	-1.8405	54.68513	6edae50d-38be-4894-901e-9ac0b49a81c0	2430801418.61249	286613.390575348
9	E23000009	North Yorkshire	429509	466515	-1.55032	54.09371	3de3fbea-2821-483f-a23c-d11534956cd2	8329486991.05682	608231.107215439
10	E23000010	West Yorkshire	418686	427238	-1.71817	53.7412	68f12f86-b238-4fc6-a886-3378e55e0916	2029163330.00949	240199.032694552


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