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

72 rows where month = "2025-07", offence = "Driving without Due Care and Attention" and vehicle_make = "Ford" 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

council_area 10

  • Birmingham 25
  • Out of Force Area 12
  • Dudley 9
  • Coventry 7
  • Solihull 6
  • Sandwell 5
  • Wolverhampton 5
  • Metropolitan Borough Of Dudley 1
  • Sutton Coldfield 1
  • Walsall 1

reporter_transport_mode 7

  • Car 45
  • Pedal Bike 13
  • Pedestrian 7
  • Motorbike 3
  • Other 2
  • Horse Rider 1
  • Lorry 1

disposal 5

  • NFA 36
  • Warning Letter 19
  • Education 11
  • Court 5
  • RTC - Actioned 1

vehicle_make 1

  • Ford · 72 ✖

offence 1

  • Driving without Due Care and Attention · 72 ✖

month 1

  • 2025-07 · 72 ✖
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
11948 op-snap---monthly-publication-july-2025.pdf   0 2025-07 Car Ford Focus Silver Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham NFA No Offence   52.4398245 -1.8469786
11949 op-snap---monthly-publication-july-2025.pdf   1 2025-07 Car Ford Fiesta White Driving without Due Care and Attention None Airport WAY Airport WAY Birmingham Birmingham Education N/A      
11987 op-snap---monthly-publication-july-2025.pdf   39 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.471632 -1.9456776
11990 op-snap---monthly-publication-july-2025.pdf   42 2025-07 Car Ford Mondeo Blue Driving without Due Care and Attention None A5189 Burton upon Trent Burton upon Trent Out of Force Area Out of Force Area NFA Out of Force      
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12047 op-snap---monthly-publication-july-2025.pdf   99 2025-07 Car Ford Minibus White Driving without Due Care and Attention None Thornhill Road, Thornhill Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5690586 -1.8794686
12070 op-snap---monthly-publication-july-2025.pdf   122 2025-07 Car Ford Transit White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12116 op-snap---monthly-publication-july-2025.pdf   168 2025-07 Car Ford Ranger White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
12174 op-snap---monthly-publication-july-2025.pdf   226 2025-07 Pedal Bike Ford B-Max Blue Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12176 op-snap---monthly-publication-july-2025.pdf   228 2025-07 Car Ford Transit White Driving without Due Care and Attention None Widdrington Road Widdrington Road Coventry Coventry Education N/A   52.4191764 -1.5105738
12212 op-snap---monthly-publication-july-2025.pdf   264 2025-07 Other Ford Fiesta Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
12273 op-snap---monthly-publication-july-2025.pdf   325 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Haxelhurst Road Haxelhurst Road Birmingham Birmingham NFA No Offence      
12295 op-snap---monthly-publication-july-2025.pdf   347 2025-07 Car Ford Fiesta White Driving without Due Care and Attention None Dudley Street Dudley Street Dudley Dudley Education N/A   52.540391 -2.1211076
12298 op-snap---monthly-publication-july-2025.pdf   350 2025-07 Car Ford Fiesta Black Driving without Due Care and Attention None Fleetwood FY7 7JL Fleetwood FY7 7JL Out of Force Area Out of Force Area NFA Out of Force   52.4743461 -1.7895289
12300 op-snap---monthly-publication-july-2025.pdf   352 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Shaftsmore Lane Shaftsmore Lane Birmingham Birmingham Court N/A      
12326 op-snap---monthly-publication-july-2025.pdf   378 2025-07 Car Ford Focus Silver Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
12327 op-snap---monthly-publication-july-2025.pdf   379 2025-07 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Hazelhurts Road Hazelhurts Road Birmingham Birmingham NFA Not in Public Interest      
12345 op-snap---monthly-publication-july-2025.pdf   397 2025-07 Car Ford Puma Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
12401 op-snap---monthly-publication-july-2025.pdf   453 2025-07 Car Ford Mondeo Blue Driving without Due Care and Attention None Saltwells Road Netherton Saltwells Road Netherton Dudley Dudley Court N/A   52.4809471 -2.0826089
12444 op-snap---monthly-publication-july-2025.pdf   496 2025-07 Pedestrian Ford Focus Orange Driving without Due Care and Attention None Off Force Off Force Out of Force Area Out of Force Area NFA Out of Force      
12471 op-snap---monthly-publication-july-2025.pdf   523 2025-07 Horse Rider Ford Fiesta White Driving without Due Care and Attention None Haselour Lane Haselour Lane Out of Force Area Out of Force Area NFA Out of Force      
12475 op-snap---monthly-publication-july-2025.pdf   527 2025-07 Car Ford Fiesta Blue Driving without Due Care and Attention None A45 Dunchurch Highway Dunchurch Highway Coventry Coventry Education N/A   52.4131902 -1.5650136
12477 op-snap---monthly-publication-july-2025.pdf   529 2025-07 Car Ford Kuga Silver Driving without Due Care and Attention None Oakenshaw Road Oakenshaw Road Solihull Solihull Warning Letter N/A   52.4017754 -1.8151522
12480 op-snap---monthly-publication-july-2025.pdf   532 2025-07 Car Ford Kuga White Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham Warning Letter N/A   52.4731312 -1.930947
12499 op-snap---monthly-publication-july-2025.pdf   551 2025-07 Car Ford Focus Blue Driving without Due Care and Attention None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
12529 op-snap---monthly-publication-july-2025.pdf   581 2025-07 Car Ford Transit White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
12537 op-snap---monthly-publication-july-2025.pdf   589 2025-07 Car Ford Transit Grey Driving without Due Care and Attention None Wellington Road Wellington Road Walsall Walsall Warning Letter N/A   52.5676426 -1.9505165
12539 op-snap---monthly-publication-july-2025.pdf   591 2025-07 Car Ford Transit Yellow Driving without Due Care and Attention None Waddensbrook Lane Waddensbrook Lane Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission      
12543 op-snap---monthly-publication-july-2025.pdf   595 2025-07 Car Ford Fiesta Black Driving without Due Care and Attention No Insurance Ringway Street Ringway Street Coventry Coventry Court N/A      
12604 op-snap---monthly-publication-july-2025.pdf   656 2025-07 Pedestrian Ford Fiesta Brown Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
12633 op-snap---monthly-publication-july-2025.pdf   685 2025-07 Car Ford Galaxy Black Driving without Due Care and Attention None A38 Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force      
12635 op-snap---monthly-publication-july-2025.pdf   687 2025-07 Car Ford Transit Grey Driving without Due Care and Attention None Wynall Lane South Wynall Lane South Dudley Dudley Education N/A   52.4461293 -2.0923323
12697 op-snap---monthly-publication-july-2025.pdf   749 2025-07 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Valley Road, Earlswood Valley Road, Earlswood Out of Force Area Out of Force Area NFA Out of Force      
12710 op-snap---monthly-publication-july-2025.pdf   762 2025-07 Pedal Bike Ford Transit Blue Driving without Due Care and Attention No Insurance Grange Road Grange Road Birmingham Birmingham Court N/A   52.5065077 -1.892207
12716 op-snap---monthly-publication-july-2025.pdf   768 2025-07 Car Ford Ranger Grey Driving without Due Care and Attention None M74 M74 Out of Force Area Out of Force Area NFA Out of Force      
12730 op-snap---monthly-publication-july-2025.pdf   782 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Close Pass Close Pass Dudley Dudley NFA Outside of 14 Days NIP      
12734 op-snap---monthly-publication-july-2025.pdf   786 2025-07 Motorbike Ford Transit Blue Driving without Due Care and Attention None M5 Northbound M5 Northbound Sandwell Sandwell NFA Outside of 14 Days NIP      
12739 op-snap---monthly-publication-july-2025.pdf   791 2025-07 Car Ford Fiesta Black Driving without Due Care and Attention None Oldbury Road Oldbury Road Sandwell Sandwell Court N/A   52.5018196 -1.9811249
12742 op-snap---monthly-publication-july-2025.pdf   794 2025-07 Car Ford Fiesta White Driving without Due Care and Attention None M42 Motorway M42 Motorway Solihull Solihull Education N/A      
12751 op-snap---monthly-publication-july-2025.pdf   803 2025-07 Lorry Ford Transit Black Driving without Due Care and Attention None M6 Jct 8 South M6 Junction 8 South Birmingham Birmingham NFA No Independent Evidence Available   52.6760749 -2.0862582
12777 op-snap---monthly-publication-july-2025.pdf   829 2025-07 Car Ford   Blue Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA No Independent Evidence Available   52.4877352 -1.9494469
12848 op-snap---monthly-publication-july-2025.pdf   900 2025-07 Car Ford Transit White Driving without Due Care and Attention None Stoney Lane Stoney Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4745488 -1.8065911
12852 op-snap---monthly-publication-july-2025.pdf   904 2025-07 Car Ford Transit White Driving without Due Care and Attention None Tysley Hill Rd Tysley Hill Road Birmingham Birmingham Warning Letter N/A      
12884 op-snap---monthly-publication-july-2025.pdf   936 2025-07 Car Ford focus Grey Driving without Due Care and Attention None A46 A46 Coventry Coventry NFA No Offence      
12914 op-snap---monthly-publication-july-2025.pdf   966 2025-07 Pedal Bike Ford Transit Silver Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5836778 -2.0894997
13030 op-snap---monthly-publication-july-2025.pdf   1082 2025-07 Car Ford   White Driving without Due Care and Attention None     Birmingham Birmingham RTC - Actioned N/A      
13053 op-snap---monthly-publication-july-2025.pdf   1105 2025-07 Other Ford Focus Blue Driving without Due Care and Attention None Waterfront Way Car park 7 Waterfront Way Car park 7 Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A      
13067 op-snap---monthly-publication-july-2025.pdf   1119 2025-07 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13074 op-snap---monthly-publication-july-2025.pdf   1126 2025-07 Pedal Bike Ford Fusion Black Driving without Due Care and Attention None Stonehouse Hill Stonehouse Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4448348 -1.9713792
13078 op-snap---monthly-publication-july-2025.pdf   1130 2025-07 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham NFA No Offence   52.4468506 -1.9395619
13088 op-snap---monthly-publication-july-2025.pdf   1140 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Toll End Road Tipton Toll End Road Tipton Sandwell Sandwell NFA No Offence   52.5404048 -2.0400078
13102 op-snap---monthly-publication-july-2025.pdf   1154 2025-07 Car Ford Transit white Driving without Due Care and Attention None M6 j 5 M6 j 5 Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.6760749 -2.0862582
13122 op-snap---monthly-publication-july-2025.pdf   1174 2025-07 Car Ford Mustang White Driving without Due Care and Attention None Birstol Road South Birstol Road South Birmingham Birmingham NFA Outside of 14 Days NIP      
13245 op-snap---monthly-publication-july-2025.pdf   1297 2025-07 Motorbike Ford Transit White Driving without Due Care and Attention None Finchfield Road Finchfield Road Wolverhampton Wolverhampton Education N/A   52.5805119 -2.1581621
13252 op-snap---monthly-publication-july-2025.pdf   1304 2025-07 Car Ford Focus Blue Driving without Due Care and Attention None M5 Jn4A to Jn3 M5 Jn4A to Jn3 Out of Force Area Out of Force Area NFA Out of Force      
13310 op-snap---monthly-publication-july-2025.pdf   1362 2025-07 Pedestrian Ford Focus Silver Driving without Due Care and Attention None Waterfront Way, Dudley Waterfront Way, Dudley Dudley Dudley Warning Letter N/A   52.4880905 -2.1164794
13383 op-snap---monthly-publication-july-2025.pdf   1435 2025-07 Car Ford focus Silver Driving without Due Care and Attention No Insurance Waterloo Road Waterloo Road Birmingham Birmingham NFA Misc Inc Crimes   52.4622159 -1.8253401
13470 op-snap---monthly-publication-july-2025.pdf   1522 2025-07 Pedestrian Ford Fiesta Black Driving without Due Care and Attention None Regent Place Regent Place Birmingham Birmingham Warning Letter N/A   52.4860376 -1.9095854
13492 op-snap---monthly-publication-july-2025.pdf   1544 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Shaftmore Lane Shaftmore Lane Birmingham Birmingham NFA Misc Inc Crimes      
13536 op-snap---monthly-publication-july-2025.pdf   1588 2025-07 Pedestrian Ford focus Silver Driving without Due Care and Attention None Falstaff road Falstaff road Solihull Solihull Warning Letter N/A   52.4042425 -1.8243195
13569 op-snap---monthly-publication-july-2025.pdf   1621 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Express Way, West Brom Express Way, West Brom Sandwell Sandwell Warning Letter N/A      
13662 op-snap---monthly-publication-july-2025.pdf   1714 2025-07 Pedestrian Ford Focus Blue Driving without Due Care and Attention none Tower Street Tower Street Dudley Dudley Warning Letter N/A   52.5112053 -2.0833165
13939 op-snap---monthly-publication-july-2025.pdf   1991 2025-07 Car Ford Ranger Green Driving without Due Care and Attention None Oxford Oxford Out of Force Area Out of Force Area NFA Out of Force      
13949 op-snap---monthly-publication-july-2025.pdf   2001 2025-07 Pedal Bike Ford Ranger Silver Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Warning Letter N/A   52.4047134 -1.5351834
13957 op-snap---monthly-publication-july-2025.pdf   2009 2025-07 Motorbike Ford Fiesta Red Driving without Due Care and Attention None A444 Gallagher shopping center Gallagher shopping center Coventry Coventry Warning Letter N/A      
14004 op-snap---monthly-publication-july-2025.pdf   2056 2025-07 Car Ford Transit White Driving without Due Care and Attention None Raynor Road Raynor Road Wolverhampton Wolverhampton Warning Letter N/A   52.6043868 -2.1046385
14005 op-snap---monthly-publication-july-2025.pdf   2057 2025-07 Car Ford Transit White Driving without Due Care and Attention None Birmingham Fort Parkway Birmingham Fort Parkway Birmingham Birmingham Warning Letter N/A   52.5084571 -1.8214016
14007 op-snap---monthly-publication-july-2025.pdf   2059 2025-07 Car Ford focus Red Driving without Due Care and Attention None Stafford Road Stafford Road Birmingham Birmingham Warning Letter N/A   52.5039962 -1.9310883
14008 op-snap---monthly-publication-july-2025.pdf   2060 2025-07 Car Ford Transit Blue Driving without Due Care and Attention None Bee Lane Bee Lane Wolverhampton Wolverhampton Warning Letter N/A   52.6250891 -2.1212912
14011 op-snap---monthly-publication-july-2025.pdf   2063 2025-07 Car Ford Mondeo Black Driving without Due Care and Attention None M6 junction2 M6 junction2 Out of Force Area Out of Force Area NFA No Offence   52.676119 -2.0858425
14013 op-snap---monthly-publication-july-2025.pdf   2065 2025-07 Car Ford Transit Green Driving without Due Care and Attention None M42 Junction 5 M42 Junction 5 Solihull Solihull Warning Letter N/A      
14024 op-snap---monthly-publication-july-2025.pdf   2076 2025-07 Pedestrian Ford Focus Blue Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Warning Letter N/A   52.4879006 -2.1188734

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