reports
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
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, council_area_raw
vehicle_make 27
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);