UK BID Crime Map: methodology and data dictionary

Dan Sandford, Member Business · dataset v52 · updated 28 October 2026

Purpose and scope

The UK BID Crime Map compares recorded shoplifting inside each Business Improvement District (BID) with the area around it, over the same two years. It asks one question: did shoplifting in the BID change faster or slower than in its surroundings?

It does not measure whether a BID caused any change. A BID area that did better than its surroundings may have done so because of the BID, a new store, a closed store, a police operation, or a change in how a force records crime. The map shows where the numbers diverge; local knowledge explains why.

Coverage:

Out of scope:

The primary measure is shoplifting. All crime and anti-social behaviour (ASB) are reported as context, not verdicts.

Data sources

Every crime figure in the zone results comes from open police.uk data. Nothing is estimated or modelled.

SourceWhat it providesNotes
police.uk street-level crime filesEach recorded crime: month, type, approximate location (a map "snap point"), area codeSeptember 2023 to August 2026, 36 months per force
police.uk outcomes filesThe latest outcome for each crimeUsed for charge and no-suspect rates; Northern Ireland publishes none
police.uk stop-and-search filesSearches with location and outcomeContext only; coverage varies by force
ONS Police Force Area data tablesOfficial police recorded crime by force and local authorityUsed to check police.uk completeness (see below)
GLA London BID boundary fileOfficial boundaries for London BIDsGrade A
Council and BID business plans, ballot papers, mapsStreet lists, maps, term dates, servicesGrade B where an official street list exists
British BIDs index and BID Data registerWhich BIDs exist and their typeBritish BIDs used as the reference

Police.uk locations are deliberately approximate. Each crime is moved to the nearest of a fixed set of snap points (a street, a car park, a supermarket, a shopping area) to protect victims. The analysis works with those points, not exact addresses.

The comparison

Each zone gets a gap: its percentage change in shoplifting minus its comparator's percentage change.

Gap = (Y3zone ÷ Y1zone − 1) × 100 − (Y3comparator ÷ Y1comparator − 1) × 100

Window adjustments where a force's data has a break:

ForceMonths used
Devon and CornwallDecember to August (Sep–Nov 2023 under-recorded)
HampshireSeptember to June
NorthumbriaJanuary–February excluded
GloucestershireSeptember to January (data ends January 2026)
Dyfed-PowysJanuary–April excluded (shoplifting missing Jan–Apr 2024)

The same months are used in both years, so the comparison stays like for like.

Boundaries and grades

Every zone carries a boundary grade.

GradeMeaningTypical source
AOfficial GIS boundaryGLA London file; council GIS layers
BOfficial street list or official mapBID business plan appendix, ballot proposal, current BID map
CTraced or own definitionMap traced by hand, core shopping streets chosen by the analyst, or a street list from an unverified source

How a zone is built from a street list: crimes on listed streets are matched to their snap points; a convex hull is drawn around those points and extended by 40 metres. Where named points are too sparse for a hull, a radius around the town centre is used instead, and the row says so.

Core-cluster extension (grade C only): where a hull missed a town's main shopping point, a 150 m circle around the densest town-centre shoplifting cluster is added. That cluster is located using the middle year (September 2024 to August 2025), which favours neither side of the comparison. See the corrections log.

Grade C results are provisional. The open call to councils and BIDs (last section) is designed to move them to A or B.

Robustness tests

A verdict is marked robust only if it survives every test below. If any test changes the verdict, it is marked not robust. The rule is deliberately conservative: 107 of 240 directional BID verdicts are robust (62 fell, 45 rose).

TestWhat it doesWhy
Without supermarketsRecomputes the gap with all supermarket snap points removed, in zone and comparatorOne store opening, closing or changing its reporting can swing a whole zone
Without the top locationRemoves the single snap point with the largest changeCatches results resting on one spot
Boundary variantsRecomputes with a strict hull (no buffer) and with street-name matchingShows whether the verdict depends on where the line is drawn
Re-pinning checkFinds a point that drops sharply while a point within 400 m on the other side of the boundary rises by a similar amount in the same months; merges the pair both wayspolice.uk sometimes moves crimes from one snap point to another
Comparator distortionFlags comparators dominated by out-of-centre retail or a force-wide surgeApplied to Cleveland and noted for Ipswich

Small numbers: zones with fewer than 100 shoplifting offences in Y1 are flagged small_numbers = Yes and marked with an asterisk on the dashboard. Their gaps can be very large on a handful of offences, so read them as indicative only.

Check against official statistics

Police.uk is a public extract of the same police records that feed the official statistics. To test whether the extract is complete, police.uk shoplifting counts were compared with the ONS Police Force Area data tables (Home Office police recorded crime, year ending June 2026 edition) for July 2024 to June 2025 and July 2025 to June 2026, for 41 forces, the City of London and 292 local authority or community safety partnership areas.

A second check compared the year ending September 2024 (close to our first year) with the year ending June 2026 (close to our third). It confirmed the same pattern and picked up the known Dyfed-Powys gap in early 2024. Thirty areas diverged by more than 5 points in the same direction in both checks, after removing the explained gaps.

Every zone is compared with the rest of its own local authority from the same source, so a shortfall spread evenly across an area cancels out of the gap; one concentrated in town centres would not. Annual totals cannot show which, so the 45 zones whose comparator lies in a flagged area carry a caution in their caveat rather than a correction. The full check is published as a CSV. It will be rerun on the year ending September 2026 edition (due 28 January 2027).

Known data problems by police force

Seventeen forces have a recording break, a data gap or a publishing problem. Each is handled as shown.

ForceProblemHandling
Devon and CornwallSep–Nov 2023 under-recorded; ASB break from Dec 2025Dec–Aug window; ASB not reported
West MidlandsASB records roughly halve from Sep 2025ASB not reported for any West Midlands zone
HampshireJuly–August data unreliableSep–Jun window
NorthumbriaJan–Feb 2026 shortJan–Feb excluded
GloucestershireData ends January 2026Sep–Jan window
Dyfed-PowysShoplifting missing Jan–Apr 2024Jan–Apr excluded
ClevelandForce-wide shoplifting surge; comparators dominated by out-of-centre retailTeesside zones marked not robust
HumbersideForce-wide shoplifting jump from Mar 2026Absorbed by comparator; noted
LancashireASB halves from Jan 2026ASB treated with caution
West MerciaASB break Apr–May 2026ASB treated with caution
Northern Ireland (PSNI)No outcomes data; no area codesCharge rates blank; distance-based comparator
Bedfordshire, Norfolk, Nottinghamshire, South Yorkshire, GwentStop-and-search incomplete or missingStop-and-search not used for these forces
Greater ManchesterNot published on police.ukOut of scope

Corrections log

Every change that moved a published or circulated figure is logged here, newest first.

DateVersionChangeEffect
28 Oct 2026v52Internal shorthand removed from 25 caveatsWording only; no figures changed
25 Oct 2026v51Check against ONS official statisticsCaution added to 45 zones whose comparator area diverged from the official count; no verdicts changed
25 Oct 2026v50Core-cluster extension re-located on middle-year data. Previously the densest cluster was found using Y1 data, which biases results towards falls (regression to the mean).49 zones redrawn; average gap moved about +7 points towards rises; Melton fell → rose, Okehampton in line → rose; Newcastle-under-Lyme −78 → −38
25 Oct 2026v49Cross-check against the British BIDs indexBuxton, Morley, Trowbridge, Wednesbury reclassified as controls (BID still developing); Torquay, Paignton as former-BID controls; Bracknell as a control (its BID covers a business park); nine missing BIDs added
24 Oct 2026v30Re-pinning check run on all zonesSix London verdicts changed; West Fitzrovia and New West End Company lost robust status; Bedminster control changed fell → in line
24 Oct 2026v21–v29Comparator and boundary corrections during the national build (e.g. Woking found to have no BID and moved to controls; Worcester boundary widened)Logged in each row's caveat

How to read a result

  1. Verdict and gap. "Fell against trend, −31" means shoplifting in the zone changed 31 points less than in the comparator. It may still have risen in absolute terms.
  2. Robust. If not robust, the caveat names the test it failed, usually one supermarket or one location. Treat the verdict as unproven.
  3. Grade. A grade C boundary may not match the BID's real area. The result can change once an official boundary arrives.
  4. Caveat and small numbers. A zone with 20 offences in Y1 can show a gap of hundreds of points from a few incidents.

What the national picture shows: of 281 BID zones, 126 fell against trend, 114 rose and 41 were in line. Of the 107 robust results, 62 fell and 45 rose. Controls (town centres with no BID) show a similar mix.

What not to conclude:

Data dictionary

The dataset has one row per zone and 33 columns. Percentages are whole numbers; counts are offences.

ColumnMeaning
idZone name, unique
regionLondon, Outside London or Northern Ireland
areaTown or city
zoneWhat the zone covers
roleBID, new BID (with start date), industrial BID, or control type (no BID, pre-BID, former BID, developing)
forcePolice force supplying the data
comparatorThe surrounding area the zone is compared with
windowMonths compared
all_A, all_BAll recorded crime in the zone, Y1 and Y3
all_pct, comp_all_pct% change in all crime, zone and comparator
shop_A, shop_BShoplifting offences in the zone, Y1 and Y3
shop_pct, comp_shop_pct% change in shoplifting, zone and comparator
shop_gap_ptsshop_pct minus comp_shop_pct
shop_verdictFell against trend (≤ −10), In line, Rose against trend (≥ +10), Not assessed
robustYes / No / blank (in line, or not assessed)
verdict_ex_supermarketVerdict recomputed without supermarket points
small_numbersYes if fewer than 100 shoplifting offences in Y1
asb_pct, comp_asb_pct% change in ASB, zone and comparator; blank where the force has an ASB break
shop_charge_rate_centreShare of zone shoplifting charged v comparator
nosuspShare of zone shoplifting closed with no suspect v comparator
boundaryGrade (A/B/C) and how the zone was drawn
operating_modelBID term, ballot and services, from published sources
caveatRobustness results and anything that limits the verdict
waveLondon, Pilot or National build
crime_techCrime-reporting systems named in BID documents (e.g. DISC, radio)
staffing_modelPatrol or street staff named in BID documents
police_fundingBID-funded police time, where documented
british_bids_statusResult of the cross-check against the British BIDs index

Blank operating model, staffing or crime-tech cells mean not yet documented, not absent.

Corrections, contributions and next steps

This is a first pass, published so that BIDs, councils and others can correct it. Every correction with a source will be applied and logged.

  1. Write to councils. Councils bill the BID levy, so they hold each BID's property list and boundary. We are writing to the councils for every grade C BID, starting with those with the most recorded shoplifting.
  2. Open call to BIDs. Any BID can send its boundary map or street list, current term dates and services (patrols, rangers, reporting systems, funded police time). Grade C zones will be redrawn on what they send.
  3. Second pass, BID by BID. Close out data gaps, confirm term status for BIDs not in the British BIDs index, and add ballot results.
  4. Independent re-derivation. A reviewer who has not seen the analysis will recompute a random sample of zones from the raw police.uk files.
  5. Quarterly refresh as police.uk publishes new months.

How to send a correction: name the zone, say what is wrong, and attach or link the source (business plan, map, ballot notice, council record), to dan@oxcam.online.