reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

Data license: ODbL · Data source: West Midlands Police

id
{'label': 'ID'}
source_file
{'label': 'Source PDF'}
source_page
{'label': 'Page'}
source_row
{'label': 'Row'}
month
{'label': 'Month'}
reporter_transport_mode
{'label': 'Reporter'}
vehicle_make
{'label': 'Make'}
vehicle_model
{'label': 'Model'}
vehicle_colour
{'label': 'Colour'}
offence
{'label': 'Offence'}
second_offence
{'label': 'Second offence'}
offence_location_raw
{'label': 'Location (raw)'}
offence_location
{'label': 'Location'}
council_area_raw
{'label': 'Council (raw)'}
council_area
{'label': 'Council area'}
disposal
{'label': 'Outcome'}
nfa_rationale
{'label': 'NFA reason'}
witness_contacted
{'label': 'Witness contacted'}
latitude
{'label': 'Lat'}
longitude
{'label': 'Lng'}

12 rows where council_area = "Out of Force Area", month = "2025-11" and vehicle_make = "Volkswagen" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_model, vehicle_colour

reporter_transport_mode 3

vehicle_make 1

  • Volkswagen · 12 ✖

month 1

  • 2025-11 · 12 ✖

disposal 1

council_area 1

  • Out of Force Area · 12 ✖
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
20509 op-snap---monthly-publication-november-2025.pdf   51 2025-11 Car Volkswagen Golf Black Driving without Due Care and Attention None Dinmore Hill Dinmore Hill Out of Force Area Out of Force Area NFA Out of Force      
20545 op-snap---monthly-publication-november-2025.pdf   87 2025-11 Car Volkswagen Golf White Driving without Due Care and Attention None Derby Road, Burton On Trent Derby Road, Burton On Trent Out of Force Area Out of Force Area NFA Out of Force      
20639 op-snap---monthly-publication-november-2025.pdf   181 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None Abbey Bridge Evesham Abbey Bridge Evesham Out of Force Area Out of Force Area NFA Out of Force      
20675 op-snap---monthly-publication-november-2025.pdf   217 2025-11 Car Volkswagen Golf Blue Driving without Due Care and Attention None Hanbury Hanbury Out of Force Area Out of Force Area NFA Out of Force   52.3760234 -1.7518131
20724 op-snap---monthly-publication-november-2025.pdf   266 2025-11 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Blackhalve Lane Blackhalve Lane Out of Force Area Out of Force Area NFA Out of Force   52.6139368 -2.0960778
20731 op-snap---monthly-publication-november-2025.pdf   273 2025-11 Car Volkswagen California Grey Driving without Due Care and Attention None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
20828 op-snap---monthly-publication-november-2025.pdf   370 2025-11 Car Volkswagen Polo Blue Driving without Due Care and Attention None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
20967 op-snap---monthly-publication-november-2025.pdf   509 2025-11 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Springfield Road, Worcester Springfield Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
21291 op-snap---monthly-publication-november-2025.pdf   833 2025-11 Pedestrian Volkswagen golf Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
21490 op-snap---monthly-publication-november-2025.pdf   1032 2025-11 Car Volkswagen Touran Blue Driving without Due Care and Attention None Manor Road Kenilworth Manor Road Kenilworth Out of Force Area Out of Force Area NFA Out of Force   52.386917 -1.7285648
21632 op-snap---monthly-publication-november-2025.pdf   1174 2025-11 Car Volkswagen T Roc Blue Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Out of Force Area Out of Force Area NFA Out of Force   52.4331313 -2.1702262
21667 op-snap---monthly-publication-november-2025.pdf   1209 2025-11 Car Volkswagen Passatt Silver Driving without Due Care and Attention None V6 Grafton Street V6 Grafton Street Out of Force Area Out of Force Area NFA Out of Force   52.4070357 -1.4938256

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE reports (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            source_file TEXT NOT NULL,
            source_page INTEGER,
            source_row INTEGER,
            month TEXT NOT NULL,
            reporter_transport_mode TEXT,
            vehicle_make TEXT,
            vehicle_model TEXT,
            vehicle_colour TEXT,
            offence TEXT,
            second_offence TEXT,
            offence_location_raw TEXT,
            offence_location TEXT,
            council_area_raw TEXT,
            council_area TEXT,
            disposal TEXT,
            nfa_rationale TEXT,
            witness_contacted TEXT
        , latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);