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

132 rows where offence = "Driving without Reasonable Consideration" 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 11

  • 2025-04 44
  • 2025-03 22
  • 2025-01 19
  • 2025-02 19
  • 2025-05 10
  • 2025-06 5
  • 2025-09 5
  • 2025-07 4
  • 2026-02 2
  • 2025-08 1
  • 2025-10 1

council_area 11

  • Birmingham 65
  • Coventry 24
  • Solihull 10
  • Sandwell 7
  • Out of Force Area 6
  • Wolverhampton 6
  • Dudley 5
  • Walsall 4
  • Sutton Coldfield 3
  • Ecnoventry 1
  • Halesowen 1

reporter_transport_mode 5

  • Car 63
  • Pedal Bike 62
  • Pedestrian 5
  • Horse Rider 1
  • Other 1

disposal 5

  • NFA 64
  • Education 30
  • Warning Letter 26
  • Fixed Penalty 9
  • Court 3

vehicle_make 1

  • Mercedes-Benz · 132 ✖

offence 1

  • Driving without Reasonable Consideration · 132 ✖
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
22190 op-snap---monthly-publication-october-2025.pdf   140 2025-10 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Cornets End Lane Cornets End Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4269547 -1.6668911
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
24641 op-snap---monthly-publication-september-2025.pdf   860 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration No Insurance Harborne Road Harborne Road Birmingham Birmingham Court N/A   52.4718503 -1.9195423
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      
15446 op-snap---monthly-publication-june-2025.pdf   1375 2025-06 Pedal Bike Mercedes-Benz A Class Silver Driving without Reasonable Consideration None Wednesfield Way Wednesfield Way Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.59548 -2.0896906
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
18757 op-snap---monthly-publication-may-2025.pdf   119 2025-05 Pedal Bike Mercedes-Benz E 220 Black Driving without Reasonable Consideration None Quinton Road West Quinton Road West Birmingham Birmingham Education N/A   52.457704 -2.0022002
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
18828 op-snap---monthly-publication-may-2025.pdf   190 2025-05 Pedal Bike Mercedes-Benz E400. White Driving without Reasonable Consideration None The Radleys The Radleys Birmingham Birmingham NFA Outside of 14 Days NIP   52.4698717 -1.7649619
18888 op-snap---monthly-publication-may-2025.pdf   250 2025-05 Pedal Bike Mercedes-Benz A class Black Driving without Reasonable Consideration None Cromer Road Cromer Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4549149 -1.8880392
18922 op-snap---monthly-publication-may-2025.pdf   284 2025-05 Pedal Bike Mercedes-Benz C220 Black Driving without Reasonable Consideration None Hampton Lane Hampton Lane Solihull Solihull Education N/A   52.4190728 -1.7449943
18937 op-snap---monthly-publication-may-2025.pdf   299 2025-05 Pedal Bike Mercedes-Benz C220 White Driving without Reasonable Consideration None Waterfall Lane Waterfall Lane Dudley Dudley Warning Letter N/A      
19326 op-snap---monthly-publication-may-2025.pdf   688 2025-05 Pedal Bike Mercedes-Benz GLE Grey Driving without Reasonable Consideration None Hampton Road Hampton Road Solihull Solihull Education N/A   52.3985342 -1.7240581
19524 op-snap---monthly-publication-may-2025.pdf   886 2025-05 Pedal Bike Mercedes-Benz CLA 220 Grey Driving without Reasonable Consideration None A458 Bridgnorth Bridgnorth Out of Force Area Out of Force Area NFA Out of Force      
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
338 op-snap---monthly-publication-april-2025.pdf   337 2025-04 Pedal Bike Mercedes-Benz C 300 Black Driving without Reasonable Consideration None Woodbridge Road Woodbridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4482076 -1.8864335
394 op-snap---monthly-publication-april-2025.pdf   393 2025-04 Pedal Bike Mercedes-Benz Vito Red Driving without Reasonable Consideration None Brandon Road Brandon Road Coventry Coventry NFA Outside of 14 Days NIP   52.399222 -1.4414386
410 op-snap---monthly-publication-april-2025.pdf   409 2025-04 Pedal Bike Mercedes-Benz HGV White Driving without Reasonable Consideration None Cleobury Rd Cleobury Road Solihull Solihull NFA Outside of 14 Days NIP      
454 op-snap---monthly-publication-april-2025.pdf   453 2025-04 Pedal Bike Mercedes-Benz GLC 300 Black Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
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
481 op-snap---monthly-publication-april-2025.pdf   480 2025-04 Pedal Bike Mercedes-Benz Sprinter Green Driving without Reasonable Consideration None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
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      
586 op-snap---monthly-publication-april-2025.pdf   585 2025-04 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
825 op-snap---monthly-publication-april-2025.pdf   824 2025-04 Pedal Bike Mercedes-Benz Benz Silver Driving without Reasonable Consideration none Britton Road , Coventry Britton Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP      
826 op-snap---monthly-publication-april-2025.pdf   825 2025-04 Pedal Bike Mercedes-Benz Benz White Driving without Reasonable Consideration none Baldwins Lane , Hall Green Baldwins Lane , Hall Green Birmingham Birmingham NFA Outside of 14 Days NIP   52.4199232 -1.8387943
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
921 op-snap---monthly-publication-april-2025.pdf   920 2025-04 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Gibbins Road , Selly Oak Gibbins Road , Selly Oak Birmingham Birmingham NFA Outside of 14 Days NIP   52.4429137 -1.9425028
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
988 op-snap---monthly-publication-april-2025.pdf   987 2025-04 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Merritts Hill , Bartley Green Merritts Hill , Bartley Green Birmingham Birmingham NFA Outside of 14 Days NIP   52.4232417 -1.9781787
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      
1062 op-snap---monthly-publication-april-2025.pdf   1061 2025-04 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Four Pounds Avenue , Coventry Four Pounds Avenue , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4098559 -1.5354583
1063 op-snap---monthly-publication-april-2025.pdf   1062 2025-04 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Vittoria Street , Birmingham Vittoria Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4865378 -1.9112801
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
1216 op-snap---monthly-publication-april-2025.pdf   1215 2025-04 Pedal Bike Mercedes-Benz   Blue Driving without Reasonable Consideration None Henley Road , Coventry Henley Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4307281 -1.462755
1219 op-snap---monthly-publication-april-2025.pdf   1218 2025-04 Pedal Bike Mercedes-Benz Benz White Driving without Reasonable Consideration None Edgbaston Park Road , Birmingham Edgbaston Park Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4580375 -1.9261777
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      
1225 op-snap---monthly-publication-april-2025.pdf   1224 2025-04 Pedal Bike Mercedes-Benz GLC Black Driving without Reasonable Consideration None Lockhurst Lane , Coventry Lockhurst Lane , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4279593 -1.5028098
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
1401 op-snap---monthly-publication-april-2025.pdf   1400 2025-04 Pedal Bike Mercedes-Benz GLA Blue Driving without Reasonable Consideration None Sandy Lane , Coventry Sandy Lane , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4172858 -1.5134012
1414 op-snap---monthly-publication-april-2025.pdf   1413 2025-04 Pedal Bike Mercedes-Benz CLA Black Driving without Reasonable Consideration None Beechwood Avenue , Coventry Beechwood Avenue , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.3960292 -1.5340332
1525 op-snap---monthly-publication-april-2025.pdf   1524 2025-04 Pedal Bike Mercedes-Benz NP Black Driving without Reasonable Consideration None Foleshill Road , Coventry Foleshill Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4363104 -1.4936555
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
1764 op-snap---monthly-publication-april-2025.pdf   1763 2025-04 Pedal Bike Mercedes-Benz Estate Silver Driving without Reasonable Consideration None Kelsey Lane , Solihull Kelsey Lane , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.3845059 -1.6371483
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
1771 op-snap---monthly-publication-april-2025.pdf   1770 2025-04 Pedal Bike Mercedes-Benz Benz C White Driving without Reasonable Consideration None Washwood Heath Road , Washwood Heath Washwood Heath Road , Washwood Heath Birmingham Birmingham NFA Outside of 14 Days NIP   52.4949047 -1.8544884
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
1975 op-snap---monthly-publication-april-2025.pdf   1974 2025-04 Pedal Bike Mercedes-Benz 200 Blue Driving without Reasonable Consideration None Newton Middleway , Birmingham Newton Middleway , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
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
16637 op-snap---monthly-publication-march-2025.pdf   394 2025-03 Pedal Bike Mercedes-Benz GLA 220 White Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3875525 -1.8339426
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
16799 op-snap---monthly-publication-march-2025.pdf   556 2025-03 Pedestrian Mercedes-Benz   White Driving without Reasonable Consideration None LICHFIELD ROAD Lichfield Road Metropolitan Borough of Walsall Walsall NFA No VRM Yes - Via Email 52.6095168 -2.0493009
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
16910 op-snap---monthly-publication-march-2025.pdf   667 2025-03 Pedestrian Mercedes-Benz   Black Driving without Reasonable Consideration No Insurance Thimble Mill Lane Thimble Mill Lane Sandwell Sandwell Warning Letter Outside of 14 Days NIP Yes - Via Email    
17014 op-snap---monthly-publication-march-2025.pdf   771 2025-03 Pedal Bike Mercedes-Benz Box van White Driving without Reasonable Consideration None Holiday Street Holiday Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4757071 -1.8988573
17028 op-snap---monthly-publication-march-2025.pdf   785 2025-03 Pedal Bike Mercedes-Benz E220... Black Driving without Reasonable Consideration None Hollie Lucas Road Hollie Lucas Road Birmingham Birmingham Education N/A Yes - Via Email 52.4263502 -1.8840926
17053 op-snap---monthly-publication-march-2025.pdf   810 2025-03 Pedal Bike Mercedes-Benz Box Van Brown Driving without Reasonable Consideration None Foles Hill Road Foleshill Road Coventry Coventry Education N/A Yes - Via Email 52.4274335 -1.5002381
17082 op-snap---monthly-publication-march-2025.pdf   839 2025-03 Pedal Bike Mercedes-Benz B Black Driving without Reasonable Consideration None Redditch Redditch Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4072158 -1.9277937
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
17851 op-snap---monthly-publication-march-2025.pdf   1608 2025-03 Pedal Bike Mercedes-Benz C200 Silver Driving without Reasonable Consideration None Stonnall Rd Stonnall Road Birmingham Birmingham Education N/A Yes - Via Email    
17852 op-snap---monthly-publication-march-2025.pdf   1609 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Chester Rd Chester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5359496 -1.8324115
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
17940 op-snap---monthly-publication-march-2025.pdf   1697 2025-03 Pedal Bike Mercedes-Benz C220 Black Driving without Reasonable Consideration None Stoney Stanton Road towards Courthouse Gre Stoney Stanton Road towards Courthouse Gre eCnoventry Ecnoventry Education N/A Yes - Via Email    
17977 op-snap---monthly-publication-march-2025.pdf   1734 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None Gillhurst Lane Gillhurst Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email    
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
18429 op-snap---monthly-publication-march-2025.pdf   2186 2025-03 Pedal Bike Mercedes-Benz Sprinter White Driving without Reasonable Consideration None CHESTER ROAD Chester Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5359496 -1.8324115
18445 op-snap---monthly-publication-march-2025.pdf   2202 2025-03 Horse Rider Mercedes-Benz EQE 500 Black Driving without Reasonable Consideration None Brockamin Lane Brockamin Lane Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
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
5697 op-snap---monthly-publication-february-2025.pdf   514 2025-02 Pedal Bike Mercedes-Benz A180 White Driving without Reasonable Consideration None Allesley OId Road Allesley OId Road Coventry Coventry Education N/A Yes - Via Email    
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
5914 op-snap---monthly-publication-february-2025.pdf   731 2025-02 Pedal Bike Mercedes-Benz E220 Grey Driving without Reasonable Consideration None Avenue Road, Kings Heath Avenue Road, Kings Heath Birmingham Birmingham Education N/A Yes - Via Email 52.4328354 -1.8999608
5986 op-snap---monthly-publication-february-2025.pdf   803 2025-02 Pedal Bike Mercedes-Benz C-class Silver Driving without Reasonable Consideration None Kidderminster Kidderminster Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4331313 -2.1702262
6058 op-snap---monthly-publication-february-2025.pdf   875 2025-02 Other Mercedes-Benz GLB 200 Blue Driving without Reasonable Consideration None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A Yes - Via Email 52.5265939 -1.8509884

Next page

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