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

44 rows where month = "2025-09", offence = "Driving without Due Care and Attention" and vehicle_make = "Vauxhall" 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, latitude, longitude

council_area 9

  • Birmingham 21
  • Out of Force Area 7
  • Coventry 5
  • Dudley 3
  • Sandwell 2
  • Solihull 2
  • Sutton Coldfield 2
  • Walsall 1
  • Wolverhampton 1

reporter_transport_mode 5

  • Car 33
  • Pedal Bike 8
  • Lorry 1
  • Other 1
  • Pedestrian 1

disposal 5

  • NFA 16
  • Warning Letter 12
  • Education 8
  • Fixed Penalty 5
  • Court 3

vehicle_make 1

  • Vauxhall · 44 ✖

offence 1

  • Driving without Due Care and Attention · 44 ✖

month 1

  • 2025-09 · 44 ✖
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
23793 op-snap---monthly-publication-september-2025.pdf   12 2025-09 Other Vauxhall Grandland Red Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
23857 op-snap---monthly-publication-september-2025.pdf   76 2025-09 Car Vauxhall Zafira Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
23863 op-snap---monthly-publication-september-2025.pdf   82 2025-09 Car Vauxhall Corsa Black Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham Court N/A   52.505832 -1.92002
23872 op-snap---monthly-publication-september-2025.pdf   91 2025-09 Car Vauxhall Mokka White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
23885 op-snap---monthly-publication-september-2025.pdf   104 2025-09 Car Vauxhall Corsa White Driving without Due Care and Attention None A42 A42 Out of Force Area Out of Force Area NFA Out of Force      
23968 op-snap---monthly-publication-september-2025.pdf   187 2025-09 Car Vauxhall Zafira Blue Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Offence   52.4070602 -1.4732469
23973 op-snap---monthly-publication-september-2025.pdf   192 2025-09 Car Vauxhall Insignia Silver Driving without Due Care and Attention None M6 SB J7 M6 Southbound J7 Birmingham Birmingham NFA No Offence   52.676119 -2.0858425
23975 op-snap---monthly-publication-september-2025.pdf   194 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None George Street Ringway, Bedworth George Street Ringway, Bedworth Out of Force Area Out of Force Area NFA Out of Force      
23998 op-snap---monthly-publication-september-2025.pdf   217 2025-09 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Church Road Edgbaston Church Road Edgbaston Birmingham Birmingham Education N/A   52.46114 -1.9180882
24033 op-snap---monthly-publication-september-2025.pdf   252 2025-09 Car Vauxhall MOKKA Black Driving without Due Care and Attention None Wolverton Road Wolverton Road Birmingham Birmingham NFA Out of Force   52.3900767 -1.9976014
24079 op-snap---monthly-publication-september-2025.pdf   298 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None St Martins Road at Erithway Road Street Martins Road at Erithway Road Coventry Coventry Fixed Penalty N/A      
24107 op-snap---monthly-publication-september-2025.pdf   326 2025-09 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None B4101 TILE HILL LANE B4101 Tile Hill Lane Coventry Coventry Fixed Penalty N/A      
24118 op-snap---monthly-publication-september-2025.pdf   337 2025-09 Car Vauxhall Astra White Driving without Due Care and Attention None M6 Coventry M6 Coventry Coventry Coventry Warning Letter N/A   52.4457805 -1.454783
24155 op-snap---monthly-publication-september-2025.pdf   374 2025-09 Car Vauxhall Corsa White Driving without Due Care and Attention Contravening a Red Traffic Light Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4214017 -1.4870278
24182 op-snap---monthly-publication-september-2025.pdf   401 2025-09 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield Education N/A   52.5405351 -1.8002219
24184 op-snap---monthly-publication-september-2025.pdf   403 2025-09 Car Vauxhall mokka Blue Driving without Due Care and Attention None The Crescent The Crescent Birmingham Birmingham Warning Letter N/A   52.4568799 -1.8734416
24268 op-snap---monthly-publication-september-2025.pdf   487 2025-09 Pedal Bike Vauxhall Combo Grey Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Education N/A   52.4628538 -2.1160108
24272 op-snap---monthly-publication-september-2025.pdf   491 2025-09 Car Vauxhall Corsa Red Driving without Due Care and Attention None Reservoir Place Reservoir Place Walsall Walsall Warning Letter N/A   52.5770818 -2.0074916
24290 op-snap---monthly-publication-september-2025.pdf   509 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Education N/A   52.5344405 -1.985568
24299 op-snap---monthly-publication-september-2025.pdf   518 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Birmingham Birmingham NFA No Independent Evidence Available   52.4223176 -1.8253145
24392 op-snap---monthly-publication-september-2025.pdf   611 2025-09 Pedal Bike Vauxhall Vivaro Black Driving without Due Care and Attention None Lichfield Road towards Dartmouth Circus Lichfield Road towards Dartmouth Circus Birmingham Birmingham Warning Letter N/A      
24395 op-snap---monthly-publication-september-2025.pdf   614 2025-09 Car Vauxhall Zafira Grey Driving without Due Care and Attention None Mincing Lane, Oldbury Mincing Lane, Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.4818028 -2.0312761
24403 op-snap---monthly-publication-september-2025.pdf   622 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      
24406 op-snap---monthly-publication-september-2025.pdf   625 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24408 op-snap---monthly-publication-september-2025.pdf   627 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None Meadway Meadway Birmingham Birmingham Fixed Penalty N/A   52.4783348 -1.8007708
24428 op-snap---monthly-publication-september-2025.pdf   647 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield NFA No Offence   52.6043776 -1.8446597
24443 op-snap---monthly-publication-september-2025.pdf   662 2025-09 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None George Road George Road Birmingham Birmingham Education N/A   52.5155831 -1.8598862
24457 op-snap---monthly-publication-september-2025.pdf   676 2025-09 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
24485 op-snap---monthly-publication-september-2025.pdf   704 2025-09 Car Vauxhall Astra Grey Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Fixed Penalty N/A   52.4216321 -1.855984
24552 op-snap---monthly-publication-september-2025.pdf   771 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None Duck Lane, Codsall Duck Lane, Codsall Out of Force Area Out of Force Area NFA Out of Force      
24554 op-snap---monthly-publication-september-2025.pdf   773 2025-09 Pedal Bike Vauxhall Corsa Silver Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Court N/A   52.6118187 -2.0810618
24574 op-snap---monthly-publication-september-2025.pdf   793 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None Wheelers Lane Wheelers Lane Birmingham Birmingham NFA No Offence   52.4306504 -1.878052
24579 op-snap---monthly-publication-september-2025.pdf   798 2025-09 Car Vauxhall Corsa Silver Driving without Due Care and Attention None Northampton Road, Rugby Northampton Road, Rugby Out of Force Area Out of Force Area NFA Out of Force      
24597 op-snap---monthly-publication-september-2025.pdf   816 2025-09 Car Vauxhall Vectra Silver Driving without Due Care and Attention None A5 East near to Oswestry East near to Oswestry Out of Force Area Out of Force Area NFA Out of Force      
24658 op-snap---monthly-publication-september-2025.pdf   877 2025-09 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Newton Road Newton Road Birmingham Birmingham NFA No VRM   52.4541102 -1.8710993
24712 op-snap---monthly-publication-september-2025.pdf   931 2025-09 Pedestrian Vauxhall Caddy White Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
24722 op-snap---monthly-publication-september-2025.pdf   941 2025-09 Lorry Vauxhall Vivaro White Driving without Due Care and Attention None Shrewbury Emstrey Shrewbury Emstrey Out of Force Area Out of Force Area NFA Out of Force      
24730 op-snap---monthly-publication-september-2025.pdf   949 2025-09 Car Vauxhall Vivaro White Driving without Due Care and Attention None M6 Toll M6 Toll Out of Force Area Out of Force Area NFA Out of Force   52.5804962 -1.7833098
24809 op-snap---monthly-publication-september-2025.pdf   1028 2025-09 Pedal Bike Vauxhall Corsa Silver Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham Warning Letter N/A   52.4436471 -1.9604594
24916 op-snap---monthly-publication-september-2025.pdf   1135 2025-09 Car Vauxhall Corsa Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
25051 op-snap---monthly-publication-september-2025.pdf   1270 2025-09 Car Vauxhall Insignia Blue Driving without Due Care and Attention None Green lane Green lane Birmingham Birmingham Warning Letter N/A   52.4618966 -1.9955421
25198 op-snap---monthly-publication-september-2025.pdf   1417 2025-09 Car Vauxhall Mokka White Driving without Due Care and Attention None Poplar Road Poplar Road Birmingham Birmingham Warning Letter N/A   52.436035 -1.891685
25371 op-snap---monthly-publication-september-2025.pdf   1590 2025-09 Car Vauxhall Corsa Blue Driving without Due Care and Attention None m6 Southbound jct 7 to 6 m6 Southbound jct 7 to 6 Birmingham Birmingham Warning Letter N/A   52.676119 -2.0858425
25452 op-snap---monthly-publication-september-2025.pdf   1671 2025-09 Car Vauxhall astra Silver Driving without Due Care and Attention None M42 M42 Solihull Solihull Warning Letter N/A      

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