opsnap

Every Operation Snap submission to West Midlands Police, January 2025 — February 2026.

Data license: ODbL · Data source: West Midlands Police

Queries

🗺️ All offences on a map
🚶 Pavement parking hotspots
📍 Top reported locations
🚗 Which car makes offend most? (normalised)
🚗 Top vehicle makes (raw count)
📊 Monthly trends
⚠️ Offence types
🏛️ Council area comparison
👁️ What different road users report
❌ Why reports get rejected
📱 Mobile phone enforcement
⚠️ Dangerous driving outcomes

Tables

reports

id, source_file, source_page, source_row, month, reporter_transport_mode, vehicle_make, vehicle_model, vehicle_colour, offence, second_offence, offence_location_raw, offence_location, council_area_raw, council_area, disposal, nfa_rationale, witness_contacted, latitude, longitude

25,627 rows

sqlite_sequence

name, seq

1 row

vehicle_registrations

make, licensed_vehicles, data_period, source

25 rows

... and 1 hidden table