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'}

14 rows where month = "2025-10" and vehicle_make = "Jaguar" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_model, vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 4

vehicle_make 1

  • Jaguar · 14 ✖

month 1

  • 2025-10 · 14 ✖
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
22412 op-snap---monthly-publication-october-2025.pdf   362 2025-10 Pedestrian Jaguar XJ50 Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22523 op-snap---monthly-publication-october-2025.pdf   473 2025-10 Car Jaguar   Red Driving without Due Care and Attention None A16 Holton Le Clay Holton Le Clay Out of Force Area Out of Force Area NFA Out of Force      
22640 op-snap---monthly-publication-october-2025.pdf   590 2025-10 Pedal Bike Jaguar F Pace Black Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22797 op-snap---monthly-publication-october-2025.pdf   747 2025-10 Car Jaguar F Pace Grey Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
22837 op-snap---monthly-publication-october-2025.pdf   787 2025-10 Car Jaguar XF Black Driving without Due Care and Attention None Bayton Road Bayton Road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
22937 op-snap---monthly-publication-october-2025.pdf   887 2025-10 Pedal Bike Jaguar F-Pace Red Contravening a Red Traffic Light None Catesby Road Catesby Road Coventry Coventry Education N/A   52.4346221 -1.5163727
23012 op-snap---monthly-publication-october-2025.pdf   962 2025-10 Other Jaguar XJ Black Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley NFA No Independent Evidence Available      
23041 op-snap---monthly-publication-october-2025.pdf   991 2025-10 Pedal Bike Jaguar XF Grey Driving without Due Care and Attention None Austin Way Austin Way Birmingham Birmingham Education N/A   52.3938378 -1.9883434
23144 op-snap---monthly-publication-october-2025.pdf   1094 2025-10 Pedestrian Jaguar IPACE Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street, Tettenhall High Street, Tettenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5980906 -2.168057
23285 op-snap---monthly-publication-october-2025.pdf   1235 2025-10 Car Jaguar F-Pace Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coldfield Rd Coldfield Road Birmingham Birmingham Warning Letter N/A   52.5425506 -1.7961226
23471 op-snap---monthly-publication-october-2025.pdf   1421 2025-10 Pedestrian Jaguar xe Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None wake green road Wake Green Road Birmingham Birmingham Warning Letter N/A   52.4437078 -1.8783408
23519 op-snap---monthly-publication-october-2025.pdf   1469 2025-10 Pedestrian Jaguar FPACE Green Cause vehicle to be left in a dangerous position No Insurance York road York road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
23574 op-snap---monthly-publication-october-2025.pdf   1524 2025-10 Pedestrian Jaguar XF Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
23591 op-snap---monthly-publication-october-2025.pdf   1541 2025-10 Car Jaguar   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High St High Street Wolverhampton Wolverhampton Warning Letter N/A   52.5635963 -2.0827567

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