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

672 rows where disposal = "Warning Letter" 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

offence >30

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 234
  • Driving without Due Care and Attention 142
  • Cause vehicle to be left in a dangerous position 100
  • Contravening a Red Traffic Light 42
  • Cause unnecessary obstruction by motor vehicle 34
  • Driving without Reasonable Consideration 26
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 20
  • Stop a vehicle within pelican pedestrian crossing limits 11
  • Using a Mobile Phone Whilst Driving 9
  • VRM fails to conform to Regulations 8
  • Contravene Lane Closure Red X 7
  • Misc - Non Traffic Offences 7
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 7
  • Drive on hard shoulder 3
  • Drive a vehicle on common land 2
  • Fail to display rear VRM plate 2
  • Motor vehicle fail to comply with endorsable sect 2
  • Stop a vehicle on pedestrian crossing 2
  • DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
  • Dangerous Driving 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Fail to Conform to Cycle Lane 1
  • Keeping a vehicle with registration marks obscured 1
  • Motor vehicle fail to accord precedence at a pelican crossing 1
  • Motor vehicle fail to comply with a non endorsab 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
  • No Seat Belt 1
  • Prohibited vehicle in offside lane of motorway 1
  • Stop a vehicle within pelican pedestrian crossing l 1
  • Use a vehicle / cycle on a road and contravene a l 1
  • …

month 14

  • 2025-10 90
  • 2025-07 87
  • 2025-08 68
  • 2025-09 61
  • 2025-11 58
  • 2025-03 51
  • 2025-06 47
  • 2025-05 45
  • 2025-02 42
  • 2026-02 35
  • 2025-12 34
  • 2025-01 21
  • 2026-01 19
  • 2025-04 14

council_area 12

  • Birmingham 453
  • Coventry 51
  • Sandwell 41
  • Solihull 29
  • Sutton Coldfield 27
  • Dudley 23
  • Wolverhampton 23
  • Walsall 17
  • Metropolitan Borough 3
  • Out of Force Area 3
  • Boiurmt Oinf Gfhoarmce 1
  • Metropolitan Borough Of Dudley 1

reporter_transport_mode 6

  • Car 313
  • Pedestrian 276
  • Pedal Bike 68
  • Other 8
  • Motorbike 4
  • Lorry 3

vehicle_make 1

  • Mercedes-Benz · 672 ✖

disposal 1

  • Warning Letter · 672 ✖
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
7293 op-snap---monthly-publication-february-2026.pdf   40 2026-02 Pedal Bike Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
7301 op-snap---monthly-publication-february-2026.pdf   48 2026-02 Pedal Bike Mercedes-Benz GL350 White Contravening a Red Traffic Light None Penn Road Penn Road Wolverhampton Wolverhampton Warning Letter N/A   52.5599616 -2.1556338
7551 op-snap---monthly-publication-february-2026.pdf   298 2026-02 Pedestrian Mercedes-Benz CLA 200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Walmley Close Walmley Close Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5398069 -1.8008939
7594 op-snap---monthly-publication-february-2026.pdf   341 2026-02 Pedestrian Mercedes-Benz E220.. Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Burnaby Road Burnaby Road Coventry Coventry Warning Letter N/A   52.4352 -1.5194238
7621 op-snap---monthly-publication-february-2026.pdf   368 2026-02 Pedestrian Mercedes-Benz GLA Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Drapers Field Drapers Field Coventry Coventry Warning Letter N/A   52.414436 -1.5112122
7631 op-snap---monthly-publication-february-2026.pdf   378 2026-02 Pedal Bike Mercedes-Benz GLA 200 Grey Contravening a Red Traffic Light None Mere Green Road Mere Green Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5874888 -1.8297106
7668 op-snap---monthly-publication-february-2026.pdf   415 2026-02 Other Mercedes-Benz E220 Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
7696 op-snap---monthly-publication-february-2026.pdf   443 2026-02 Pedal Bike Mercedes-Benz A Class Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7724 op-snap---monthly-publication-february-2026.pdf   471 2026-02 Pedestrian Mercedes-Benz CLA Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Warning Letter N/A   52.4877244 -1.787883
7769 op-snap---monthly-publication-february-2026.pdf   516 2026-02 Car Mercedes-Benz GLA black Driving without Due Care and Attention None Kenilworth Road, A452, nr Balsall Common Kenilworth Road, A452, nr Balsall Common Solihull Solihull Warning Letter N/A      
7825 op-snap---monthly-publication-february-2026.pdf   572 2026-02 Pedestrian Mercedes-Benz GLA Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Woodfield Avenue Woodfield Avenue Wolverhampton Wolverhampton Warning Letter N/A   52.5668728 -2.1489012
7886 op-snap---monthly-publication-february-2026.pdf   633 2026-02 Pedestrian Mercedes-Benz CLA 180 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Edward Street Edward Street Birmingham Birmingham Warning Letter N/A   52.4816233 -1.9124334
7913 op-snap---monthly-publication-february-2026.pdf   660 2026-02 Pedestrian Mercedes-Benz GLC Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Monkspath Hall Road / Whitefields Road Monkspath Hall Road / Whitefields Road Solihull Solihull Warning Letter N/A   52.3909753 -1.8020771
7955 op-snap---monthly-publication-february-2026.pdf   702 2026-02 Pedestrian Mercedes-Benz E300.. Blue Misc - Non Traffic Offences None Edward Street Edward Street Birmingham Birmingham Warning Letter N/A   52.4816233 -1.9124334
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
7983 op-snap---monthly-publication-february-2026.pdf   730 2026-02 Other Mercedes-Benz Splinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham Warning Letter N/A   52.5265939 -1.8509884
8001 op-snap---monthly-publication-february-2026.pdf   748 2026-02 Pedestrian Mercedes-Benz C250 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Booths Farm Rd Booths Farm Road Birmingham Birmingham Warning Letter N/A   52.541377 -1.9175615
8265 op-snap---monthly-publication-february-2026.pdf   1012 2026-02 Car Mercedes-Benz CLS 220 White Driving without Due Care and Attention None A34 A34 Birmingham Birmingham Warning Letter N/A      
8359 op-snap---monthly-publication-february-2026.pdf   1106 2026-02 Car Mercedes-Benz CLA White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Spon Lane, West Bromwich Spon Lane, West Bromwich Sandwell Sandwell Warning Letter N/A   52.5151568 -1.9909305
8422 op-snap---monthly-publication-february-2026.pdf   1169 2026-02 Car Mercedes-Benz E320 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hertford Way / Balkwill Cres Hertford Way / Balkwill Crescent Solihull Solihull Warning Letter N/A   52.3778812 -1.7427424
8534 op-snap---monthly-publication-february-2026.pdf   1281 2026-02 Car Mercedes-Benz E300 Black Driving without Due Care and Attention None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
8543 op-snap---monthly-publication-february-2026.pdf   1290 2026-02 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Westwood Way Westwood Way Coventry Coventry Warning Letter N/A   52.3880214 -1.5797132
8563 op-snap---monthly-publication-february-2026.pdf   1310 2026-02 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
8607 op-snap---monthly-publication-february-2026.pdf   1354 2026-02 Car Mercedes-Benz A180 Red Stop a vehicle on pedestrian crossing None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8608 op-snap---monthly-publication-february-2026.pdf   1355 2026-02 Pedestrian Mercedes-Benz A160 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None thornton road Thornton Road Birmingham Birmingham Warning Letter N/A   52.491445 -1.8277188
8622 op-snap---monthly-publication-february-2026.pdf   1369 2026-02 Pedestrian Mercedes-Benz c63 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None willis street Willis Street Birmingham Birmingham Warning Letter N/A      
8668 op-snap---monthly-publication-february-2026.pdf   1415 2026-02 Car Mercedes-Benz Vito White Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
8716 op-snap---monthly-publication-february-2026.pdf   1463 2026-02 Pedestrian Mercedes-Benz eqb Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None rockingham gardens Rockingham Gardens Birmingham Birmingham Warning Letter N/A   52.5690681 -1.8271174
8728 op-snap---monthly-publication-february-2026.pdf   1475 2026-02 Pedal Bike Mercedes-Benz spinter White Stop a vehicle within pelican pedestrian crossing limits None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
8731 op-snap---monthly-publication-february-2026.pdf   1478 2026-02 Pedestrian Mercedes-Benz a180 Black Stop a vehicle within pelican pedestrian crossing limits None bearwood road Bearwood Road Birmingham Birmingham Warning Letter Duplicate Submission   52.4762784 -1.9678366
8794 op-snap---monthly-publication-february-2026.pdf   1541 2026-02 Car Mercedes-Benz c220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None victoria street Victoria Street Birmingham Birmingham Warning Letter N/A   52.4751651 -1.8559775
8795 op-snap---monthly-publication-february-2026.pdf   1542 2026-02 Car Mercedes-Benz sprinter White Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8796 op-snap---monthly-publication-february-2026.pdf   1543 2026-02 Car Mercedes-Benz c220 Black Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8829 op-snap---monthly-publication-february-2026.pdf   1576 2026-02 Car Mercedes-Benz sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8887 op-snap---monthly-publication-february-2026.pdf   1634 2026-02 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Benton Road Benton Road Birmingham Birmingham Warning Letter N/A   52.4589836 -1.8637054
10588 op-snap---monthly-publication-january-2026.pdf   49 2026-01 Pedestrian Mercedes-Benz box van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None beech road Beech Road Birmingham Birmingham Warning Letter N/A   52.5393906 -1.8446767
10615 op-snap---monthly-publication-january-2026.pdf   76 2026-01 Pedestrian Mercedes-Benz sprinter White Cause vehicle to be left in a dangerous position None alcester road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
10625 op-snap---monthly-publication-january-2026.pdf   86 2026-01 Car Mercedes-Benz gl350 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None oxhill road Oxhill Road Birmingham Birmingham Warning Letter N/A   52.513857 -1.9367367
10659 op-snap---monthly-publication-january-2026.pdf   120 2026-01 Car Mercedes-Benz e220 Black Cause vehicle to be left in a dangerous position None robin hood lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
10694 op-snap---monthly-publication-january-2026.pdf   155 2026-01 Pedestrian Mercedes-Benz E220 Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Regent Road Tividale Regent Road Tividale Sandwell Sandwell Warning Letter N/A   52.5106406 -2.0559963
10746 op-snap---monthly-publication-january-2026.pdf   207 2026-01 Car Mercedes-Benz C300 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Churchill Road Churchill Road Birmingham Birmingham Warning Letter N/A   52.5529597 -1.8615015
10801 op-snap---monthly-publication-january-2026.pdf   262 2026-01 Car Mercedes-Benz   White Driving without Due Care and Attention None London Road London Road Coventry Coventry Warning Letter N/A   52.3916468 -1.4925995
10867 op-snap---monthly-publication-january-2026.pdf   328 2026-01 Pedestrian Mercedes-Benz 330 White Misc - Non Traffic Offences None Barclay Road Barclay Road Sandwell Sandwell Warning Letter N/A   52.4722765 -1.9787531
10909 op-snap---monthly-publication-january-2026.pdf   370 2026-01 Pedestrian Mercedes-Benz EQA Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham Warning Letter N/A      
10947 op-snap---monthly-publication-january-2026.pdf   408 2026-01 Car Mercedes-Benz G63 Black Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Warning Letter N/A   52.4622646 -1.8599985
11021 op-snap---monthly-publication-january-2026.pdf   482 2026-01 Pedestrian Mercedes-Benz Sprinter Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Balaclava Road Balaclava Road Birmingham Birmingham Warning Letter N/A   52.4337176 -1.896658
11117 op-snap---monthly-publication-january-2026.pdf   578 2026-01 Car Mercedes-Benz GLC 220 Grey Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell Warning Letter N/A   52.4926604 -2.0216743
11179 op-snap---monthly-publication-january-2026.pdf   640 2026-01 Pedestrian Mercedes-Benz GLA 200 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shirley Road at Breedon Road Shirley Road at Breedon Road Birmingham Birmingham Warning Letter N/A   52.445607 -1.8234364
11301 op-snap---monthly-publication-january-2026.pdf   762 2026-01 Pedestrian Mercedes-Benz A200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham Warning Letter N/A      
11405 op-snap---monthly-publication-january-2026.pdf   866 2026-01 Pedal Bike Mercedes-Benz Vito Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
11636 op-snap---monthly-publication-january-2026.pdf   1097 2026-01 Pedal Bike Mercedes-Benz Tourismo Blue Driving without Due Care and Attention None Warwick Road at Ashleigh Road Warwick Road at Ashleigh Road Solihull Solihull Warning Letter N/A   52.4385199 -1.8069384
11864 op-snap---monthly-publication-january-2026.pdf   1325 2026-01 Pedestrian Mercedes-Benz CLA 200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Legge Lane Legge Lane Birmingham Birmingham Warning Letter N/A   52.4843538 -1.9127963
11905 op-snap---monthly-publication-january-2026.pdf   1366 2026-01 Pedestrian Mercedes-Benz glc Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None warwick road Warwick Road Solihull Solihull Warning Letter N/A   52.4428606 -1.812114
11942 op-snap---monthly-publication-january-2026.pdf   1403 2026-01 Pedal Bike Mercedes-Benz c220 Black Cause vehicle to be left in a dangerous position None cannon hill road Cannon Hill Road Birmingham Birmingham Warning Letter N/A   52.4569873 -1.8971744
3898 op-snap---monthly-publication-december-2025.pdf   26 2025-12 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Trittiford Road Trittiford Road Birmingham Birmingham Warning Letter N/A   52.4248084 -1.8660294
3903 op-snap---monthly-publication-december-2025.pdf   31 2025-12 Pedestrian Mercedes-Benz Sprinter Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Abbey Road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
3925 op-snap---monthly-publication-december-2025.pdf   53 2025-12 Pedestrian Mercedes-Benz A Class White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Warning Letter N/A   52.4418944 -1.8407335
3928 op-snap---monthly-publication-december-2025.pdf   56 2025-12 Pedestrian Mercedes-Benz A Class White Cause vehicle to be left in a dangerous position None Abbey Road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
3935 op-snap---monthly-publication-december-2025.pdf   63 2025-12 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3936 op-snap---monthly-publication-december-2025.pdf   64 2025-12 Car Mercedes-Benz C220 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3948 op-snap---monthly-publication-december-2025.pdf   76 2025-12 Pedestrian Mercedes-Benz E220 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Catholic Lane Catholic Lane Dudley Dudley Warning Letter N/A   52.5360259 -2.125828
3961 op-snap---monthly-publication-december-2025.pdf   89 2025-12 Pedestrian Mercedes-Benz C220 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Huntingtree road Huntingtree road Dudley Dudley Warning Letter N/A   52.4484682 -2.0689885
3990 op-snap---monthly-publication-december-2025.pdf   118 2025-12 Car Mercedes-Benz CLA220 White Contravening a Red Traffic Light None Stafford Road Stafford Road Wolverhampton Wolverhampton Warning Letter N/A   52.6291998 -2.126312
4077 op-snap---monthly-publication-december-2025.pdf   205 2025-12 Car Mercedes-Benz C180 Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
4130 op-snap---monthly-publication-december-2025.pdf   258 2025-12 Pedestrian Mercedes-Benz C Class Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Park Close High Park Close Birmingham Birmingham Warning Letter N/A      
4206 op-snap---monthly-publication-december-2025.pdf   334 2025-12 Pedestrian Mercedes-Benz GLB Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moseley Old Road Moseley Old Road Birmingham Birmingham Warning Letter N/A      
4208 op-snap---monthly-publication-december-2025.pdf   336 2025-12 Pedestrian Mercedes-Benz C250 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Middlewood Close Middlewood Close Birmingham Birmingham Warning Letter N/A      
4211 op-snap---monthly-publication-december-2025.pdf   339 2025-12 Pedestrian Mercedes-Benz GLC Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Carpenters Road Carpenters Road Birmingham Birmingham Warning Letter N/A      
4225 op-snap---monthly-publication-december-2025.pdf   353 2025-12 Pedestrian Mercedes-Benz GLC Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
4246 op-snap---monthly-publication-december-2025.pdf   374 2025-12 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4252 op-snap---monthly-publication-december-2025.pdf   380 2025-12 Car Mercedes-Benz c250 Silver Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
4293 op-snap---monthly-publication-december-2025.pdf   421 2025-12 Car Mercedes-Benz e350 Silver Cause vehicle to be left in a dangerous position None waswood heath Waswood Heath Birmingham Birmingham Warning Letter N/A      
4300 op-snap---monthly-publication-december-2025.pdf   428 2025-12 Pedestrian Mercedes-Benz a200 Black Cause vehicle to be left in a dangerous position None barclay road Barclay Road Dudley Dudley Warning Letter N/A      
4611 op-snap---monthly-publication-december-2025.pdf   739 2025-12 Pedestrian Mercedes-Benz gle 250 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None clarence road Clarence Road Birmingham Birmingham Warning Letter N/A   52.5940902 -1.843503
4680 op-snap---monthly-publication-december-2025.pdf   808 2025-12 Pedestrian Mercedes-Benz Sprinter Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Regent Road Regent Road Sandwell Sandwell Warning Letter N/A   52.5106406 -2.0559963
4689 op-snap---monthly-publication-december-2025.pdf   817 2025-12 Car Mercedes-Benz CLA180 Silver Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
4710 op-snap---monthly-publication-december-2025.pdf   838 2025-12 Car Mercedes-Benz GLA White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Minster Road Minster Road Coventry Coventry Warning Letter N/A   52.4100542 -1.5227279
4735 op-snap---monthly-publication-december-2025.pdf   863 2025-12 Car Mercedes-Benz Vito Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
4747 op-snap---monthly-publication-december-2025.pdf   875 2025-12 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
4833 op-snap---monthly-publication-december-2025.pdf   961 2025-12 Car Mercedes-Benz Sprinter Blue Driving without Due Care and Attention None Park Lane, Wednesbury Park Lane, Wednesbury Walsall Walsall Warning Letter N/A   52.5687807 -2.0165653
4875 op-snap---monthly-publication-december-2025.pdf   1003 2025-12 Car Mercedes-Benz Sprinter White Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
4912 op-snap---monthly-publication-december-2025.pdf   1040 2025-12 Other Mercedes-Benz C-class Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
4916 op-snap---monthly-publication-december-2025.pdf   1044 2025-12 Pedal Bike Mercedes-Benz C350 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
4943 op-snap---monthly-publication-december-2025.pdf   1071 2025-12 Car Mercedes-Benz sprinter White Cause vehicle to be left in a dangerous position None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
5031 op-snap---monthly-publication-december-2025.pdf   1159 2025-12 Pedestrian Mercedes-Benz a180 Black Cause vehicle to be left in a dangerous position None barclay road Barclay Road Birmingham Birmingham Warning Letter N/A      
5087 op-snap---monthly-publication-december-2025.pdf   1215 2025-12 Car Mercedes-Benz C43 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stratford Road, Hall Green Stratford Road, Hall Green Birmingham Birmingham Warning Letter N/A   52.4197143 -1.8333031
5108 op-snap---monthly-publication-december-2025.pdf   1236 2025-12 Car Mercedes-Benz C43 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Warning Letter N/A   52.4221526 -1.8425617
5109 op-snap---monthly-publication-december-2025.pdf   1237 2025-12 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Station Road Station Road Birmingham Birmingham Warning Letter N/A   52.5054559 -1.9506109
20496 op-snap---monthly-publication-november-2025.pdf   38 2025-11 Car Mercedes-Benz C220.. Black Contravening a Red Traffic Light None Tollbar End Cov Tollbar End Cov Coventry Coventry Warning Letter N/A   52.377406 -1.4651313
20534 op-snap---monthly-publication-november-2025.pdf   76 2025-11 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Longdales Road Longdales Road Birmingham Birmingham Warning Letter N/A   52.3947881 -1.9285109
20543 op-snap---monthly-publication-november-2025.pdf   85 2025-11 Car Mercedes-Benz E200 Black Contravening a Red Traffic Light None Old Walsall Rd, Great Barr Old Walsall Road, Great Barr Walsall Walsall Warning Letter N/A   52.5523033 -1.9111356
20544 op-snap---monthly-publication-november-2025.pdf   86 2025-11 Car Mercedes-Benz GLC Blue Driving without Due Care and Attention None Wigston Road, Hinkley Road Roundabout Wigston Road, Hinkley Road Roundabout Coventry Coventry Warning Letter N/A      
20551 op-snap---monthly-publication-november-2025.pdf   93 2025-11 Motorbike Mercedes-Benz C220 Black Contravening a Red Traffic Light None Pedmore Road Pedmore Road Dudley Dudley Warning Letter N/A   52.4897451 -2.1069141
20574 op-snap---monthly-publication-november-2025.pdf   116 2025-11 Car Mercedes-Benz CLA 200 Silver Driving without Due Care and Attention None Jimmy HIll Way Jimmy HIll Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
20663 op-snap---monthly-publication-november-2025.pdf   205 2025-11 Pedal Bike Mercedes-Benz Tractor White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20748 op-snap---monthly-publication-november-2025.pdf   290 2025-11 Lorry Mercedes-Benz ML250 Silver Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A      
20831 op-snap---monthly-publication-november-2025.pdf   373 2025-11 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hampden Close Hampden Close Birmingham Birmingham Warning Letter N/A      
20836 op-snap---monthly-publication-november-2025.pdf   378 2025-11 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dovehouse Lane Dovehouse Lane Solihull Solihull Warning Letter N/A   52.4319915 -1.7915192
20848 op-snap---monthly-publication-november-2025.pdf   390 2025-11 Car Mercedes-Benz A 200 Black Driving without Due Care and Attention None Central Boulevard Central Boulevard Coventry Coventry Warning Letter N/A   52.4543969 -1.5168781
20854 op-snap---monthly-publication-november-2025.pdf   396 2025-11 Pedal Bike Mercedes-Benz A200 White Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135

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