home / opsnap

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

29 rows where month = "2025-09", reporter_transport_mode = "Car" and vehicle_make = "Peugeot" 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

offence 8

  • Driving without Due Care and Attention 7
  • Cause unnecessary obstruction by motor vehicle 6
  • Contravening a Red Traffic Light 5
  • Using a Mobile Phone Whilst Driving 5
  • Driving without Reasonable Consideration 2
  • Misc - Non Traffic Offences 2
  • Cause vehicle to be left in a dangerous position 1
  • Contravene Lane Closure Red X 1

council_area 6

  • Birmingham 13
  • Out of Force Area 6
  • Coventry 4
  • Dudley 3
  • Wolverhampton 2
  • Sandwell 1

disposal 4

  • NFA 12
  • Warning Letter 10
  • Education 4
  • Fixed Penalty 3

vehicle_make 1

  • Peugeot · 29 ✖

reporter_transport_mode 1

  • Car · 29 ✖

month 1

  • 2025-09 · 29 ✖
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
23892 op-snap---monthly-publication-september-2025.pdf   111 2025-09 Car Peugeot 208.. Blue Using a Mobile Phone Whilst Driving None University Locks (Outside Co-Op) University Locks (Outside Co-Op) Birmingham Birmingham NFA No Independent Evidence Available      
23977 op-snap---monthly-publication-september-2025.pdf   196 2025-09 Car Peugeot Boxer White Driving without Due Care and Attention None Griff Roundabout, Nuneaton Griff Roundabout, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
24006 op-snap---monthly-publication-september-2025.pdf   225 2025-09 Car Peugeot 308 Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24052 op-snap---monthly-publication-september-2025.pdf   271 2025-09 Car Peugeot Traveller Black Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
24088 op-snap---monthly-publication-september-2025.pdf   307 2025-09 Car Peugeot 2008.. Grey Using a Mobile Phone Whilst Driving None Park Road at Parkes Hall Road Park Road at Parkes Hall Road Dudley Dudley Fixed Penalty N/A   52.4566333 -2.1646355
24157 op-snap---monthly-publication-september-2025.pdf   376 2025-09 Car Peugeot Expert White Driving without Due Care and Attention None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Warning Letter N/A   52.4760986 -1.9018641
24203 op-snap---monthly-publication-september-2025.pdf   422 2025-09 Car Peugeot 208 Grey Driving without Reasonable Consideration None M1 J21 - Leicester M1 J21 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
24221 op-snap---monthly-publication-september-2025.pdf   440 2025-09 Car Peugeot Bipper White Driving without Due Care and Attention No vehicle excise licence Greville Road, in Warwick Greville Road, in Warwick Out of Force Area Out of Force Area NFA Out of Force      
24229 op-snap---monthly-publication-september-2025.pdf   448 2025-09 Car Peugeot Partner White Contravening a Red Traffic Light None High Street / A491, Audnam, Stourbridge High Street / A491, Audnam, Stourbridge Dudley Dudley Education N/A   52.4722518 -2.1552954
24234 op-snap---monthly-publication-september-2025.pdf   453 2025-09 Car Peugeot 308 Black Driving without Due Care and Attention None A5 A5 Out of Force Area Out of Force Area NFA Out of Force      
24239 op-snap---monthly-publication-september-2025.pdf   458 2025-09 Car Peugeot Boxer White Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham Warning Letter N/A   52.4344402 -1.8845368
24316 op-snap---monthly-publication-september-2025.pdf   535 2025-09 Car Peugeot 208 White Using a Mobile Phone Whilst Driving None Birmingham new Road Birmingham new Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
24433 op-snap---monthly-publication-september-2025.pdf   652 2025-09 Car Peugeot Boxer Green Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
24439 op-snap---monthly-publication-september-2025.pdf   658 2025-09 Car Peugeot 107 Red Contravening a Red Traffic Light None Bristol Street Bristol Street Birmingham Birmingham Education N/A   52.4691145 -1.9003257
24461 op-snap---monthly-publication-september-2025.pdf   680 2025-09 Car Peugeot 3008 Black Using a Mobile Phone Whilst Driving None Black Lake Black Lake Sandwell Sandwell NFA No Offence   52.5341947 -2.0098521
24570 op-snap---monthly-publication-september-2025.pdf   789 2025-09 Car Peugeot 2008 Black Contravening a Red Traffic Light None Leafield Road Leafield Road Birmingham Birmingham Warning Letter N/A      
24819 op-snap---monthly-publication-september-2025.pdf   1038 2025-09 Car Peugeot 208 Blue Driving without Due Care and Attention None A51 Weston to Hixon, Staffs Weston to Hixon, Staffs Out of Force Area Out of Force Area NFA Out of Force      
24820 op-snap---monthly-publication-september-2025.pdf   1039 2025-09 Car Peugeot 2008 Black Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Chester Road / College Road Chester Road / College Road Birmingham Birmingham NFA No VRM   52.5460025 -1.8572602
24879 op-snap---monthly-publication-september-2025.pdf   1098 2025-09 Car Peugeot Expert White Driving without Reasonable Consideration None Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
24896 op-snap---monthly-publication-september-2025.pdf   1115 2025-09 Car Peugeot Expert Red Contravening a Red Traffic Light None Willenhall Road Willenhall Road Wolverhampton Wolverhampton Education N/A   52.5836778 -2.0894997
25023 op-snap---monthly-publication-september-2025.pdf   1242 2025-09 Car Peugeot 5008 Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
25091 op-snap---monthly-publication-september-2025.pdf   1310 2025-09 Car Peugeot 3008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25190 op-snap---monthly-publication-september-2025.pdf   1409 2025-09 Car Peugeot Horizon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Coventry Coventry Warning Letter N/A   52.4144961 -1.5337013
25255 op-snap---monthly-publication-september-2025.pdf   1474 2025-09 Car Peugeot 207 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Selly Oak Road Selly Oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
25291 op-snap---monthly-publication-september-2025.pdf   1510 2025-09 Car Peugeot 308 Grey Contravene Lane Closure Red X None M6 Southbound M6 Southbound Birmingham Birmingham Warning Letter N/A      
25308 op-snap---monthly-publication-september-2025.pdf   1527 2025-09 Car Peugeot 107 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Cannock Road Cannock Road Wolverhampton Wolverhampton NFA Misc Inc Crimes   52.6083917 -2.1033365
25391 op-snap---monthly-publication-september-2025.pdf   1610 2025-09 Car Peugeot 208 Pink Cause vehicle to be left in a dangerous position None queen mary road Queen Mary Road Coventry Coventry Warning Letter N/A   52.4318936 -1.4981794
25541 op-snap---monthly-publication-september-2025.pdf   1760 2025-09 Car Peugeot 208 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
25619 op-snap---monthly-publication-september-2025.pdf   1838 2025-09 Car Peugeot 3008 Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      

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