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

215 rows where disposal = "Warning Letter", month = "2025-12" and offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, council_area_raw

vehicle_make 27

  • Toyota 25
  • Volkswagen 25
  • Ford 24
  • Mercedes-Benz 20
  • BMW 19
  • Vauxhall 18
  • Nissan 12
  • Audi 10
  • Kia 8
  • Peugeot 8
  • Hyundai 7
  • Citroen 5
  • Honda 5
  • Skoda 4
  • Land Rover 3
  • Mazda 3
  • Renault 3
  • Daf 2
  • Mg 2
  • Mitsubishi 2
  • Porsche 2
  • Seat 2
  • Volvo 2
  • Cupra 1
  • Fiat 1
  • Other 1
  • Tesla 1

council_area 10

  • Birmingham 159
  • Sandwell 18
  • Dudley 16
  • Wolverhampton 6
  • Coventry 5
  • Solihull 5
  • Sutton Coldfield 3
  • Bridrmingham 1
  • Nbs Irrmdingham 1
  • Walsall 1

reporter_transport_mode 3

  • Pedestrian 125
  • Car 81
  • Pedal Bike 9

offence 1

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 215 ✖

month 1

  • 2025-12 · 215 ✖

disposal 1

  • Warning Letter · 215 ✖
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
3880 op-snap---monthly-publication-december-2025.pdf   8 2025-12 Car BMW 1 Series Black 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
3881 op-snap---monthly-publication-december-2025.pdf   9 2025-12 Car Ford Fiesta Black 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
3883 op-snap---monthly-publication-december-2025.pdf   11 2025-12 Car Toyota   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
3888 op-snap---monthly-publication-december-2025.pdf   16 2025-12 Car Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barton Drive Barton Drive Solihull Solihull Warning Letter N/A   52.3770722 -1.7420909
3894 op-snap---monthly-publication-december-2025.pdf   22 2025-12 Car Hyundai Ioniq 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
3895 op-snap---monthly-publication-december-2025.pdf   23 2025-12 Car Vauxhall Corsa Black 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
3896 op-snap---monthly-publication-december-2025.pdf   24 2025-12 Car Vauxhall Mokka Black 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
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
3902 op-snap---monthly-publication-december-2025.pdf   30 2025-12 Pedestrian Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Maitland Road Maitland Road Birmingham Birmingham Warning Letter N/A   52.4868494 -1.8448776
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
3915 op-snap---monthly-publication-december-2025.pdf   43 2025-12 Car BMW X1 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
3916 op-snap---monthly-publication-december-2025.pdf   44 2025-12 Car Volkswagen Tiguan 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
3917 op-snap---monthly-publication-december-2025.pdf   45 2025-12 Pedestrian Volkswagen Golf Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shelsley Avenue Shelsley Avenue Sandwell Sandwell Warning Letter N/A   52.4906088 -2.0317097
3918 op-snap---monthly-publication-december-2025.pdf   46 2025-12 Pedestrian Vauxhall   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shelsley Avenue Shelsley Avenue Sandwell Sandwell Warning Letter N/A   52.4906088 -2.0317097
3924 op-snap---monthly-publication-december-2025.pdf   52 2025-12 Pedestrian BMW   Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None A435 A435 Birmingham Birmingham Warning Letter N/A      
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
3934 op-snap---monthly-publication-december-2025.pdf   62 2025-12 Car Ford Fiesta Black 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
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
3938 op-snap---monthly-publication-december-2025.pdf   66 2025-12 Pedestrian Toyota Auris Grey 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
3939 op-snap---monthly-publication-december-2025.pdf   67 2025-12 Pedestrian Kia Niro Grey 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
3943 op-snap---monthly-publication-december-2025.pdf   71 2025-12 Pedestrian Toyota Aygo Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wilden Lane Wilden Lane Birmingham Birmingham Warning Letter N/A      
3944 op-snap---monthly-publication-december-2025.pdf   72 2025-12 Pedestrian BMW X6 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Scafell Road Scafell Road Dudley Dudley Warning Letter N/A   52.4592579 -2.1385749
3945 op-snap---monthly-publication-december-2025.pdf   73 2025-12 Pedestrian Vauxhall Insignia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Scafell Road Scafell Road Dudley Dudley Warning Letter N/A   52.4592579 -2.1385749
3947 op-snap---monthly-publication-december-2025.pdf   75 2025-12 Pedestrian Audi Q7 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lyndon Road Lyndon Road Birmingham Birmingham Warning Letter N/A   52.5649901 -1.8274858
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
3949 op-snap---monthly-publication-december-2025.pdf   77 2025-12 Pedestrian Kia Venga Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braymoor Road Braymoor Road Birmingham Birmingham Warning Letter N/A   52.4756937 -1.762603
3951 op-snap---monthly-publication-december-2025.pdf   79 2025-12 Pedestrian Peugeot 2008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Withymoor Road Withymoor Road Dudley Dudley Warning Letter N/A   52.4871674 -2.0702998
3953 op-snap---monthly-publication-december-2025.pdf   81 2025-12 Pedestrian Kia Niro Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
3954 op-snap---monthly-publication-december-2025.pdf   82 2025-12 Pedestrian Ford Fiesta Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
3955 op-snap---monthly-publication-december-2025.pdf   83 2025-12 Pedestrian Toyota Avensis Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
3956 op-snap---monthly-publication-december-2025.pdf   84 2025-12 Car Toyota Estima Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Anne Road Anne Road Birmingham Birmingham Warning Letter N/A   52.5550797 -1.7950237
3957 op-snap---monthly-publication-december-2025.pdf   85 2025-12 Car Volkswagen Touran Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grove Lane Grove Lane Birmingham Birmingham Warning Letter N/A   52.5055208 -1.9328067
3958 op-snap---monthly-publication-december-2025.pdf   86 2025-12 Car Nissan Note Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Anne Road Anne Road Sandwell Sandwell Warning Letter N/A   52.5001925 -1.9481997
3959 op-snap---monthly-publication-december-2025.pdf   87 2025-12 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
3960 op-snap---monthly-publication-december-2025.pdf   88 2025-12 Pedestrian Toyota Yaris Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
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
3962 op-snap---monthly-publication-december-2025.pdf   90 2025-12 Pedestrian Renault Captur Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Huntingree road Huntingree road Dudley Dudley Warning Letter N/A      
3963 op-snap---monthly-publication-december-2025.pdf   91 2025-12 Pedestrian Volkswagen Tiguan Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Huntingree road Huntingree road Dudley Dudley Warning Letter N/A      
3964 op-snap---monthly-publication-december-2025.pdf   92 2025-12 Pedestrian Volkswagen s60 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None hill villiage road Hill Village Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5959906 -1.8345802
3972 op-snap---monthly-publication-december-2025.pdf   100 2025-12 Car Toyota prius 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
3978 op-snap---monthly-publication-december-2025.pdf   106 2025-12 Pedestrian Tesla modey y Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None sutton road Sutton Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5346721 -1.827743
4125 op-snap---monthly-publication-december-2025.pdf   253 2025-12 Pedestrian Toyota Prius   Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
4129 op-snap---monthly-publication-december-2025.pdf   257 2025-12 Pedestrian BMW 5 Series Silver 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      
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      
4132 op-snap---monthly-publication-december-2025.pdf   260 2025-12 Pedestrian Renault Captur Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Petersfield Road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
4139 op-snap---monthly-publication-december-2025.pdf   267 2025-12 Pedestrian Audi A3 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moat Road Moat Road Sandwell Sandwell Warning Letter N/A   52.4842946 -2.0027774
4140 op-snap---monthly-publication-december-2025.pdf   268 2025-12 Pedestrian Mazda CX-30 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moat Road Moat Road Sandwell Sandwell Warning Letter N/A   52.4842946 -2.0027774
4142 op-snap---monthly-publication-december-2025.pdf   270 2025-12 Car Ford Focus 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
4143 op-snap---monthly-publication-december-2025.pdf   271 2025-12 Car Toyota Priuis 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
4147 op-snap---monthly-publication-december-2025.pdf   275 2025-12 Car Toyota Prius Grey 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
4168 op-snap---monthly-publication-december-2025.pdf   296 2025-12 Pedestrian Volkswagen Sharan Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Popular Road Popular Road Birmingham Birmingham Warning Letter N/A   52.454374 -1.8774689
4169 op-snap---monthly-publication-december-2025.pdf   297 2025-12 Pedestrian Volkswagen Golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Popular Road Popular Road Birmingham Birmingham Warning Letter N/A   52.454374 -1.8774689
4172 op-snap---monthly-publication-december-2025.pdf   300 2025-12 Car Toyota Yaris Grey 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
4193 op-snap---monthly-publication-december-2025.pdf   321 2025-12 Pedestrian Vauxhall Meriva Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Marks Crescent Street Marks Crescent Birmingham Birmingham Warning Letter N/A      
4198 op-snap---monthly-publication-december-2025.pdf   326 2025-12 Pedestrian Mazda 3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Street Church Street Birmingham Birmingham Warning Letter N/A   52.5020781 -1.9122368
4201 op-snap---monthly-publication-december-2025.pdf   329 2025-12 Pedestrian Volkswagen Passat Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
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      
4207 op-snap---monthly-publication-december-2025.pdf   335 2025-12 Pedestrian Land Rover Range Rover Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grove Road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
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      
4209 op-snap---monthly-publication-december-2025.pdf   337 2025-12 Pedestrian Hyundai Tucson Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Reddings Lane Reddings Lane Birmingham Birmingham Warning Letter N/A   52.4506039 -1.8463952
4210 op-snap---monthly-publication-december-2025.pdf   338 2025-12 Pedestrian Hyundai Ioniq Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wills Street Wills Street Birmingham Birmingham Warning Letter N/A   52.500453 -1.9141126
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      
4219 op-snap---monthly-publication-december-2025.pdf   347 2025-12 Pedestrian Volkswagen Tiguan Black 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
4220 op-snap---monthly-publication-december-2025.pdf   348 2025-12 Pedestrian Land Rover Sport Grey 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
4221 op-snap---monthly-publication-december-2025.pdf   349 2025-12 Pedestrian Volkswagen Passat Silver 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
4223 op-snap---monthly-publication-december-2025.pdf   351 2025-12 Pedestrian Mg HS Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barncroft Road Barncroft Road Sandwell Sandwell Warning Letter N/A   52.5061545 -2.0570005
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
4226 op-snap---monthly-publication-december-2025.pdf   354 2025-12 Pedestrian Volkswagen Tiguan Grey 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
4227 op-snap---monthly-publication-december-2025.pdf   355 2025-12 Car Honda Civic Blue 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
4231 op-snap---monthly-publication-december-2025.pdf   359 2025-12 Pedestrian Land Rover Defender Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
4232 op-snap---monthly-publication-december-2025.pdf   360 2025-12 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hollybank Road Hollybank Road Birmingham Birmingham Warning Letter N/A   52.4236341 -1.8787502
4233 op-snap---monthly-publication-december-2025.pdf   361 2025-12 Pedestrian Skoda Kodiaq Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Retford Grove Retford Grove Birmingham Birmingham Warning Letter N/A   52.4591192 -1.8229566
4236 op-snap---monthly-publication-december-2025.pdf   364 2025-12 Pedestrian Vauxhall Insignia Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hall Green Road Hall Green Road Birmingham Birmingham Warning Letter N/A   52.473444 -1.8094123
4237 op-snap---monthly-publication-december-2025.pdf   365 2025-12 Car Kia Ceed 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
4238 op-snap---monthly-publication-december-2025.pdf   366 2025-12 Pedestrian Toyota Yaris Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None A5127 A5127 Birmingham Birmingham Warning Letter N/A      
4239 op-snap---monthly-publication-december-2025.pdf   367 2025-12 Pedestrian Nissan Qashqai Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grove Road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
4241 op-snap---monthly-publication-december-2025.pdf   369 2025-12 Pedestrian Ford Focus Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Apsley Road Apsley Road Birmingham Birmingham Warning Letter N/A   52.4633793 -1.9102892
4242 op-snap---monthly-publication-december-2025.pdf   370 2025-12 Car Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Warning Letter N/A   52.5517052 -1.7825505
4245 op-snap---monthly-publication-december-2025.pdf   373 2025-12 Car Volkswagen Polo Blue 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
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
4247 op-snap---monthly-publication-december-2025.pdf   375 2025-12 Car BMW 1 Series Grey 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
4250 op-snap---monthly-publication-december-2025.pdf   378 2025-12 Pedestrian Other moped Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None manilla road Manilla Road Birmingham Birmingham Warning Letter N/A   52.4376834 -1.9152398
4273 op-snap---monthly-publication-december-2025.pdf   401 2025-12 Pedestrian Citroen   Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None court oak road Court Oak Road Birmingham Birmingham Warning Letter N/A   52.4604383 -1.9760104
4275 op-snap---monthly-publication-december-2025.pdf   403 2025-12 Pedestrian Ford fiesta White 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
4276 op-snap---monthly-publication-december-2025.pdf   404 2025-12 Pedestrian Vauxhall zafiara 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
4277 op-snap---monthly-publication-december-2025.pdf   405 2025-12 Pedestrian Peugeot 5008 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
4297 op-snap---monthly-publication-december-2025.pdf   425 2025-12 Pedestrian Vauxhall grandland White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lime grove Lime Grove Birmingham Birmingham Warning Letter N/A   52.5042965 -1.9074069
4322 op-snap---monthly-publication-december-2025.pdf   450 2025-12 Pedestrian Toyota estima Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None anthony road Anthony Road Birmingham Birmingham Warning Letter N/A   52.4843724 -1.8470805
4323 op-snap---monthly-publication-december-2025.pdf   451 2025-12 Pedestrian Hyundai tucson Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None pineapple road Pineapple Road Birmingham Birmingham Warning Letter N/A   52.4303068 -1.9077938
4331 op-snap---monthly-publication-december-2025.pdf   459 2025-12 Pedal Bike Renault Master White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
4332 op-snap---monthly-publication-december-2025.pdf   460 2025-12 Pedestrian Toyota yaris Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ellesmered road Ellesmered Road Birmingham Birmingham Warning Letter N/A      
4333 op-snap---monthly-publication-december-2025.pdf   461 2025-12 Car Volkswagen golf Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None startfrod road Startfrod Road Birmingham Birmingham Warning Letter N/A      
4338 op-snap---monthly-publication-december-2025.pdf   466 2025-12 Pedestrian BMW 1 series Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None grove road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
4339 op-snap---monthly-publication-december-2025.pdf   467 2025-12 Car Kia sportag White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None haslucks green road Haslucks Green Road Birmingham Birmingham Warning Letter N/A      
4340 op-snap---monthly-publication-december-2025.pdf   468 2025-12 Pedal Bike Toyota Prius Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
4369 op-snap---monthly-publication-december-2025.pdf   497 2025-12 Car Vauxhall combo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
4370 op-snap---monthly-publication-december-2025.pdf   498 2025-12 Car BMW 1 series Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None sheldon heath road Sheldon Heath Road Birmingham Birmingham Warning Letter N/A   52.4744736 -1.7892633
4442 op-snap---monthly-publication-december-2025.pdf   570 2025-12 Pedestrian Honda civic Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None grove road Grove Road Birmingham Birmingham Warning Letter N/A   52.4453942 -1.8644982
4443 op-snap---monthly-publication-december-2025.pdf   571 2025-12 Car Audi q6 Black 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

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