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

63 rows where offence = "Driving without Reasonable Consideration", reporter_transport_mode = "Car" and vehicle_make = "Mercedes-Benz" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

month 10

  • 2025-04 23
  • 2025-03 9
  • 2025-02 8
  • 2025-01 5
  • 2025-06 4
  • 2025-07 4
  • 2025-09 4
  • 2025-05 3
  • 2026-02 2
  • 2025-08 1

council_area 10

  • Birmingham 29
  • Coventry 9
  • Sandwell 6
  • Wolverhampton 5
  • Dudley 4
  • Solihull 4
  • Out of Force Area 2
  • Walsall 2
  • Halesowen 1
  • Sutton Coldfield 1

disposal 5

  • NFA 33
  • Warning Letter 15
  • Education 11
  • Fixed Penalty 3
  • Court 1

vehicle_make 1

  • Mercedes-Benz · 63 ✖

reporter_transport_mode 1

  • Car · 63 ✖

offence 1

  • Driving without Reasonable Consideration · 63 ✖
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
7958 op-snap---monthly-publication-february-2026.pdf   705 2026-02 Car Mercedes-Benz EAQ 350 Grey Driving without Reasonable Consideration None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
8494 op-snap---monthly-publication-february-2026.pdf   1241 2026-02 Car Mercedes-Benz 400 AMG Black Driving without Reasonable Consideration None Hockley Lane Hockley Lane Coventry Coventry Education N/A   52.4165323 -1.6001601
24063 op-snap---monthly-publication-september-2025.pdf   282 2025-09 Car Mercedes-Benz B180 Blue Driving without Reasonable Consideration None A38 Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24324 op-snap---monthly-publication-september-2025.pdf   543 2025-09 Car Mercedes-Benz GLC 300 Black Driving without Reasonable Consideration No Insurance Solihull bypass Solihull bypass Solihull Solihull Court N/A   52.4207529 -1.7757467
24332 op-snap---monthly-publication-september-2025.pdf   551 2025-09 Car Mercedes-Benz Smart Car Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24629 op-snap---monthly-publication-september-2025.pdf   848 2025-09 Car Mercedes-Benz GLC220 White Driving without Reasonable Consideration None High Street High Street Sandwell Sandwell Education N/A   52.5128738 -1.9842054
2857 op-snap---monthly-publication-august-2025.pdf   832 2025-08 Car Mercedes-Benz A class Silver Driving without Reasonable Consideration None St Andrews Street, Netherton Street Andrews Street, Netherton Dudley Dudley Warning Letter N/A   52.4905847 -2.0868385
12162 op-snap---monthly-publication-july-2025.pdf   214 2025-07 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None M6 Southbound approaching Jn6 M6 Southbound approaching Jn6 Birmingham Birmingham Warning Letter N/A      
12898 op-snap---monthly-publication-july-2025.pdf   950 2025-07 Car Mercedes-Benz sprinter Orange Driving without Reasonable Consideration None Caynton Road Caynton Road Out of Force Area Out of Force Area NFA Out of Force      
13034 op-snap---monthly-publication-july-2025.pdf   1086 2025-07 Car Mercedes-Benz   White Driving without Reasonable Consideration None Sherbourne Street , Coventry Sherbourne Street , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4080688 -1.5236936
13060 op-snap---monthly-publication-july-2025.pdf   1112 2025-07 Car Mercedes-Benz   Black Driving without Reasonable Consideration None Bromford Lane , Stetchford Bromford Lane , Stetchford Birmingham Birmingham NFA Outside of 14 Days NIP      
14340 op-snap---monthly-publication-june-2025.pdf   269 2025-06 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
15334 op-snap---monthly-publication-june-2025.pdf   1263 2025-06 Car Mercedes-Benz GLC Black Driving without Reasonable Consideration None M6 M6 Walsall Walsall NFA Outside of 14 Days NIP      
15648 op-snap---monthly-publication-june-2025.pdf   1577 2025-06 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Bilston Road Bilston Road Wolverhampton Wolverhampton Education N/A   52.5801329 -2.1138283
15738 op-snap---monthly-publication-june-2025.pdf   1667 2025-06 Car Mercedes-Benz A class White Driving without Reasonable Consideration None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA Outside of 14 Days NIP   52.396476 -1.5561348
18818 op-snap---monthly-publication-may-2025.pdf   180 2025-05 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Alcester Road South Alcester Road South Birmingham Birmingham NFA Outside of 14 Days NIP   52.4170522 -1.8906187
19629 op-snap---monthly-publication-may-2025.pdf   991 2025-05 Car Mercedes-Benz BENZ Grey Driving without Reasonable Consideration None OLDBURY INTERCHANGE Oldbury Interchange Sandwell Sandwell Education N/A   52.5032925 -2.0167285
19646 op-snap---monthly-publication-may-2025.pdf   1008 2025-05 Car Mercedes-Benz C class White Driving without Reasonable Consideration None Little Merry Hill Little Merry Hill Wolverhampton Wolverhampton Warning Letter N/A      
278 op-snap---monthly-publication-april-2025.pdf   277 2025-04 Car Mercedes-Benz 300D Blue Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham NFA Outside of 14 Days NIP   52.4119174 -1.9735247
475 op-snap---monthly-publication-april-2025.pdf   474 2025-04 Car Mercedes-Benz E-class Black Driving without Reasonable Consideration None Foleshill Road Foleshill Road Coventry Coventry Warning Letter N/A   52.4274335 -1.5002381
562 op-snap---monthly-publication-april-2025.pdf   561 2025-04 Car Mercedes-Benz A Class Red Driving without Reasonable Consideration None M42 M42 Solihull Solihull NFA Outside of 14 Days NIP      
838 op-snap---monthly-publication-april-2025.pdf   837 2025-04 Car Mercedes-Benz Benz White Driving without Reasonable Consideration None A450 , Stourbridge A450 , Stourbridge Dudley Dudley NFA Outside of 14 Days NIP   52.4577615 -2.1474345
895 op-snap---monthly-publication-april-2025.pdf   894 2025-04 Car Mercedes-Benz Benz Black Driving without Reasonable Consideration None WIlenhall Road , Wolverhampton WIlenhall Road , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP      
896 op-snap---monthly-publication-april-2025.pdf   895 2025-04 Car Mercedes-Benz   White Driving without Reasonable Consideration None Gosford Street , Coventry Gosford Street , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4068712 -1.4994695
969 op-snap---monthly-publication-april-2025.pdf   968 2025-04 Car Mercedes-Benz   White Driving without Reasonable Consideration None A34 towards Walsall A34 towards Walsall Walsall Walsall NFA Outside of 14 Days NIP      
980 op-snap---monthly-publication-april-2025.pdf   979 2025-04 Car Mercedes-Benz Viano Grey Driving without Reasonable Consideration None A461 & A457 heading towards Dudley Port A461 & A457 heading towards Dudley Port Sandwell Sandwell NFA Outside of 14 Days NIP   52.5193521 -2.0559955
997 op-snap---monthly-publication-april-2025.pdf   996 2025-04 Car Mercedes-Benz A Class Silver Driving without Reasonable Consideration None Anderton Road , Sparkbrook Anderton Road , Sparkbrook Birmingham Birmingham NFA Outside of 14 Days NIP   52.4628285 -1.8645629
1044 op-snap---monthly-publication-april-2025.pdf   1043 2025-04 Car Mercedes-Benz Van Silver Driving without Reasonable Consideration None Wilding house labne , Birmingham Wilding house labne , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1076 op-snap---monthly-publication-april-2025.pdf   1075 2025-04 Car Mercedes-Benz Turbo Black Driving without Reasonable Consideration None     Coventry Coventry NFA Outside of 14 Days NIP      
1178 op-snap---monthly-publication-april-2025.pdf   1177 2025-04 Car Mercedes-Benz C Class Black Driving without Reasonable Consideration None Fredrick Street , Birmingham Fredrick Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
1186 op-snap---monthly-publication-april-2025.pdf   1185 2025-04 Car Mercedes-Benz   Black Driving without Reasonable Consideration None Lichfield Road , Sutton Lichfield Road , Sutton Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.571317 -1.8232701
1224 op-snap---monthly-publication-april-2025.pdf   1223 2025-04 Car Mercedes-Benz   White Driving without Reasonable Consideration None The common valley Road The common valley Road Birmingham Birmingham NFA Outside of 14 Days NIP      
1265 op-snap---monthly-publication-april-2025.pdf   1264 2025-04 Car Mercedes-Benz A Class White Driving without Reasonable Consideration None Perry Park Road , Rowley Regis Perry Park Road , Rowley Regis Sandwell Sandwell NFA Outside of 14 Days NIP   52.4717873 -2.0494663
1267 op-snap---monthly-publication-april-2025.pdf   1266 2025-04 Car Mercedes-Benz   Black Driving without Reasonable Consideration None M6 Southbound , Junction 10 M6 Southbound , Junction 10 Sandwell Sandwell NFA Outside of 14 Days NIP   52.676119 -2.0858425
1640 op-snap---monthly-publication-april-2025.pdf   1639 2025-04 Car Mercedes-Benz Citan White Driving without Reasonable Consideration None College Road , Birmingham College Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.54782 -1.8534716
1739 op-snap---monthly-publication-april-2025.pdf   1738 2025-04 Car Mercedes-Benz Vito Silver Driving without Reasonable Consideration None Clifford Bridge Road , Coventry Clifford Bridge Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4211632 -1.4473468
1765 op-snap---monthly-publication-april-2025.pdf   1764 2025-04 Car Mercedes-Benz Benz Black Driving without Reasonable Consideration None Stockwell Road , WOlverhampton Stockwell Road , WOlverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6030355 -2.1653543
1858 op-snap---monthly-publication-april-2025.pdf   1857 2025-04 Car Mercedes-Benz Benz White Driving without Reasonable Consideration None First Avenue , Pensnett trading estate First Avenue , Pensnett trading estate Dudley Dudley NFA Outside of 14 Days NIP   52.5069559 -2.1481938
1888 op-snap---monthly-publication-april-2025.pdf   1887 2025-04 Car Mercedes-Benz Benz White Driving without Reasonable Consideration None Wednesfield Way , Wolverhampton Wednesfield Way , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5951458 -2.0795721
1966 op-snap---monthly-publication-april-2025.pdf   1965 2025-04 Car Mercedes-Benz Benz CLA 200d Grey Driving without Reasonable Consideration None Bristol Road , Birmingham Bristol Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4471946 -1.927388
2002 op-snap---monthly-publication-april-2025.pdf   2001 2025-04 Car Mercedes-Benz NP Silver Driving without Reasonable Consideration None Brettell Lane , Amblecote Brettell Lane , Amblecote Halesowen Halesowen NFA Outside of 14 Days NIP   52.4706676 -2.1545486
16776 op-snap---monthly-publication-march-2025.pdf   533 2025-03 Car Mercedes-Benz E200 Grey Driving without Reasonable Consideration None Queslett Road Queslett Road Birmingham Birmingham Education N/A Yes - Via Email 52.5458699 -1.9304484
16804 op-snap---monthly-publication-march-2025.pdf   561 2025-03 Car Mercedes-Benz A CLASS Grey Driving without Reasonable Consideration None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.466118 -1.8982999
17672 op-snap---monthly-publication-march-2025.pdf   1429 2025-03 Car Mercedes-Benz GLB220 White Driving without Reasonable Consideration None Windward Way Windward Way Solihull Solihull NFA No Offence Yes - Via Email 52.5023715 -1.7555515
17929 op-snap---monthly-publication-march-2025.pdf   1686 2025-03 Car Mercedes-Benz GLA250 Black Driving without Reasonable Consideration None Lee Bank Middleway Lee Bank Middleway Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.4677721 -1.9037358
18028 op-snap---monthly-publication-march-2025.pdf   1785 2025-03 Car Mercedes-Benz A200 Black Driving without Reasonable Consideration None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18029 op-snap---monthly-publication-march-2025.pdf   1786 2025-03 Car Mercedes-Benz B180 Grey Driving without Reasonable Consideration None Coventry Road at Kings Road Coventry Road at Kings Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
18049 op-snap---monthly-publication-march-2025.pdf   1806 2025-03 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
18284 op-snap---monthly-publication-march-2025.pdf   2041 2025-03 Car Mercedes-Benz C250 Black Driving without Reasonable Consideration None Dog Kennel Lane Dog Kennel Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3916957 -1.8169275
18325 op-snap---monthly-publication-march-2025.pdf   2082 2025-03 Car Mercedes-Benz C class White Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
5689 op-snap---monthly-publication-february-2025.pdf   506 2025-02 Car Mercedes-Benz Vito White Driving without Reasonable Consideration None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
5852 op-snap---monthly-publication-february-2025.pdf   669 2025-02 Car Mercedes-Benz E220 Grey Driving without Reasonable Consideration None Island Road Birmingham Island Road Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.509612 -1.9513666
6343 op-snap---monthly-publication-february-2025.pdf   1160 2025-02 Car Mercedes-Benz C220 Silver Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
6525 op-snap---monthly-publication-february-2025.pdf   1342 2025-02 Car Mercedes-Benz A Class Silver Driving without Reasonable Consideration None Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5458699 -1.9304484
6643 op-snap---monthly-publication-february-2025.pdf   1460 2025-02 Car Mercedes-Benz A200 Grey Driving without Reasonable Consideration None M6 Junction 2 (Southbound) M6 Junction 2 (Southbound) Coventry Coventry Warning Letter N/A Yes - Via Email 52.676119 -2.0858425
6773 op-snap---monthly-publication-february-2025.pdf   1590 2025-02 Car Mercedes-Benz GL320 Black Driving without Reasonable Consideration None M6 Northbound Junction 10 M6 Northbound Junction 10 Sandwell Sandwell Education N/A Yes - Via Email 52.676119 -2.0858425
6787 op-snap---monthly-publication-february-2025.pdf   1604 2025-02 Car Mercedes-Benz E220 White Driving without Reasonable Consideration None Walsall Raod, Perry Barr Walsall Raod, Perry Barr Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
7185 op-snap---monthly-publication-february-2025.pdf   2002 2025-02 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Bromsgrove Road, Romsley Bromsgrove Road, Romsley Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9086 op-snap---monthly-publication-january-2025.pdf   194 2025-01 Car Mercedes-Benz A Class Grey Driving without Reasonable Consideration None M42 Warwickshire M42 Warwickshire Birmingham Birmingham NFA Out of Force Yes - Via Email    
9133 op-snap---monthly-publication-january-2025.pdf   241 2025-01 Car Mercedes-Benz E220 Blue Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
9154 op-snap---monthly-publication-january-2025.pdf   262 2025-01 Car Mercedes-Benz A180 White Driving without Reasonable Consideration None Victoria Road R/A at Park lane East Victoria Road R/A at Park lane East Dudley Dudley Education N/A Yes - Via Email    
9739 op-snap---monthly-publication-january-2025.pdf   847 2025-01 Car Mercedes-Benz CLA 250 Grey Driving without Reasonable Consideration None Sky blue way Sky blue way Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4085943 -1.4943275
10394 op-snap---monthly-publication-january-2025.pdf   1502 2025-01 Car Mercedes-Benz GLC 43 Black Driving without Reasonable Consideration No Insurance Hamstead Road Hamstead Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.505832 -1.92002

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