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'}
357 rows where disposal = "Warning Letter", month = "2025-08" 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, second_offence, council_area_raw
vehicle_make >30
council_area 8
- Birmingham 298
- Coventry 16
- Wolverhampton 15
- Sandwell 9
- Sutton Coldfield 7
- Dudley 4
- Solihull 4
- Walsall 4
reporter_transport_mode 4
- Pedestrian 233
- Car 111
- Pedal Bike 12
- Other 1
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 357 ✖
month 1
- 2025-08 · 357 ✖
disposal 1
- Warning Letter · 357 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2384 | op-snap---monthly-publication-august-2025.pdf | 359 | 2025-08 | Pedal Bike | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Corportaion Street | Corportaion Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 2507 | op-snap---monthly-publication-august-2025.pdf | 482 | 2025-08 | Pedestrian | Audi | A3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bank Street | Bank Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4359081 | -1.8936852 | ||
| 3215 | op-snap---monthly-publication-august-2025.pdf | 1190 | 2025-08 | Car | Nissan | juke | Orange | 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 | ||
| 3216 | op-snap---monthly-publication-august-2025.pdf | 1191 | 2025-08 | Car | Volkswagen | golf | Blue | 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 | ||
| 3219 | op-snap---monthly-publication-august-2025.pdf | 1194 | 2025-08 | Car | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Brownhills | High Street, Brownhills | Walsall | Walsall | Warning Letter | N/A | 52.6252131 | -1.9338823 | ||
| 3220 | op-snap---monthly-publication-august-2025.pdf | 1195 | 2025-08 | Car | Citroen | C4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 3223 | op-snap---monthly-publication-august-2025.pdf | 1198 | 2025-08 | Pedestrian | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3224 | op-snap---monthly-publication-august-2025.pdf | 1199 | 2025-08 | Pedestrian | Vauxhall | Corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3226 | op-snap---monthly-publication-august-2025.pdf | 1201 | 2025-08 | Pedestrian | Vauxhall | astra | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3227 | op-snap---monthly-publication-august-2025.pdf | 1202 | 2025-08 | Pedestrian | Ford | tourneo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Green | Heath Green | Birmingham | Birmingham | Warning Letter | N/A | 52.4873353 | -1.9407986 | ||
| 3228 | op-snap---monthly-publication-august-2025.pdf | 1203 | 2025-08 | Pedestrian | Ford | mondeo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Dudley | Dudley | Warning Letter | N/A | 52.4881161 | -2.1199108 | ||
| 3229 | op-snap---monthly-publication-august-2025.pdf | 1204 | 2025-08 | Pedestrian | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | earlsdon street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 3230 | op-snap---monthly-publication-august-2025.pdf | 1205 | 2025-08 | Pedestrian | Kia | picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley road | Dudley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3231 | op-snap---monthly-publication-august-2025.pdf | 1206 | 2025-08 | Pedestrian | Peugeot | Expert | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley road | Dudley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3232 | op-snap---monthly-publication-august-2025.pdf | 1207 | 2025-08 | Pedestrian | Ford | puma | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Well Street | Upper Well Street | Coventry | Coventry | Warning Letter | N/A | 52.4102625 | -1.5137293 | ||
| 3233 | op-snap---monthly-publication-august-2025.pdf | 1208 | 2025-08 | Pedestrian | Volkswagen | golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Telfer Road | Telfer Road | Coventry | Coventry | Warning Letter | N/A | 52.4311807 | -1.5191239 | ||
| 3246 | op-snap---monthly-publication-august-2025.pdf | 1221 | 2025-08 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avon Street | Avon Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4556565 | -1.8643304 | ||
| 3247 | op-snap---monthly-publication-august-2025.pdf | 1222 | 2025-08 | Pedestrian | Peugeot | 3008 | Blue | 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 | ||
| 3249 | op-snap---monthly-publication-august-2025.pdf | 1224 | 2025-08 | Pedestrian | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fairbourne Towerr | Fairbourne Towerr | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3250 | op-snap---monthly-publication-august-2025.pdf | 1225 | 2025-08 | Pedestrian | Mercedes-Benz | GLC200 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill road | Cannon Hill road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3251 | op-snap---monthly-publication-august-2025.pdf | 1226 | 2025-08 | Pedestrian | Hyundai | Santa FE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Canno Hill Road | Canno Hill Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3252 | op-snap---monthly-publication-august-2025.pdf | 1227 | 2025-08 | Pedestrian | Suzuki | swift | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3253 | op-snap---monthly-publication-august-2025.pdf | 1228 | 2025-08 | Pedestrian | Mg | 4 | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 | ||
| 3254 | op-snap---monthly-publication-august-2025.pdf | 1229 | 2025-08 | Pedestrian | Cupra | Formentor | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3265 | op-snap---monthly-publication-august-2025.pdf | 1240 | 2025-08 | Car | Vauxhall | movano | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Balsall Common | Balsall Common | Solihull | Solihull | Warning Letter | N/A | 52.3902971 | -1.648477 | ||
| 3266 | op-snap---monthly-publication-august-2025.pdf | 1241 | 2025-08 | Car | Mercedes-Benz | SLC250 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tetenhall Road | Tetenhall Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 3277 | op-snap---monthly-publication-august-2025.pdf | 1252 | 2025-08 | Car | Mazda | CX3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maney Corner | Maney Corner | Birmingham | Birmingham | Warning Letter | N/A | 52.5569597 | -1.8263727 | ||
| 3279 | op-snap---monthly-publication-august-2025.pdf | 1254 | 2025-08 | Pedestrian | Suzuki | vitara | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tetenhall road | Tetenhall road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3282 | op-snap---monthly-publication-august-2025.pdf | 1257 | 2025-08 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley road | Barnsley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 3286 | op-snap---monthly-publication-august-2025.pdf | 1261 | 2025-08 | Pedestrian | Iveco | Daily | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bonner Grove | Bonner Grove | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3299 | op-snap---monthly-publication-august-2025.pdf | 1274 | 2025-08 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ormes LAne | Ormes LAne | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5897993 | -2.1774009 | ||
| 3302 | op-snap---monthly-publication-august-2025.pdf | 1277 | 2025-08 | Car | Toyota | yaris | 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 | ||
| 3303 | op-snap---monthly-publication-august-2025.pdf | 1278 | 2025-08 | Car | Audi | a6 | 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 | ||
| 3304 | op-snap---monthly-publication-august-2025.pdf | 1279 | 2025-08 | Car | Nissan | micra | 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 | ||
| 3305 | op-snap---monthly-publication-august-2025.pdf | 1280 | 2025-08 | Car | Toyota | mpv | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | coleshill road | Coleshill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | ||
| 3306 | op-snap---monthly-publication-august-2025.pdf | 1281 | 2025-08 | Car | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | coleshill road | Coleshill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | ||
| 3307 | op-snap---monthly-publication-august-2025.pdf | 1282 | 2025-08 | Car | Toyota | auris | 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 | ||
| 3308 | op-snap---monthly-publication-august-2025.pdf | 1283 | 2025-08 | Car | Ford | tourneo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | audley road | Audley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4876917 | -1.7963729 | ||
| 3310 | op-snap---monthly-publication-august-2025.pdf | 1285 | 2025-08 | Pedestrian | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 3338 | op-snap---monthly-publication-august-2025.pdf | 1313 | 2025-08 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Craythorne Avenue | Craythorne Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.5264721 | -1.9412009 | ||
| 3339 | op-snap---monthly-publication-august-2025.pdf | 1314 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Craythorne Avenue | Craythorne Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.5264721 | -1.9412009 | ||
| 3341 | op-snap---monthly-publication-august-2025.pdf | 1316 | 2025-08 | Car | Vauxhall | Corsa | Silver | 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 | ||
| 3342 | op-snap---monthly-publication-august-2025.pdf | 1317 | 2025-08 | Pedestrian | Land Rover | Velar | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Overdale Road | Overdale Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4540128 | -1.9850912 | ||
| 3343 | op-snap---monthly-publication-august-2025.pdf | 1318 | 2025-08 | Car | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobmoor Road | Hobmoor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4709249 | -1.8295416 | ||
| 3344 | op-snap---monthly-publication-august-2025.pdf | 1319 | 2025-08 | Car | BMW | M340 | 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 | ||
| 3345 | op-snap---monthly-publication-august-2025.pdf | 1320 | 2025-08 | Pedestrian | Mazda | s TS | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | John Street | John Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5010537 | -1.9155739 | ||
| 3347 | op-snap---monthly-publication-august-2025.pdf | 1322 | 2025-08 | Pedestrian | Mg | ZS | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avenue Road | Avenue Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4941712 | -1.8795158 | ||
| 3351 | op-snap---monthly-publication-august-2025.pdf | 1326 | 2025-08 | Pedestrian | BMW | 320d | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5065077 | -1.892207 | ||
| 3352 | op-snap---monthly-publication-august-2025.pdf | 1327 | 2025-08 | Pedestrian | Toyota | Yaris | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Inverness Road | Inverness Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4129524 | -1.9785922 | ||
| 3353 | op-snap---monthly-publication-august-2025.pdf | 1328 | 2025-08 | Pedestrian | Volkswagen | Polo | Blue | 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 | ||
| 3354 | op-snap---monthly-publication-august-2025.pdf | 1329 | 2025-08 | Pedestrian | Ford | Kuga | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Rd | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3355 | op-snap---monthly-publication-august-2025.pdf | 1330 | 2025-08 | Pedestrian | Skoda | Enyaq | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kings Rd | Kings Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5531351 | -1.8852761 | ||
| 3356 | op-snap---monthly-publication-august-2025.pdf | 1331 | 2025-08 | Pedestrian | Toyota | Corolla | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5333535 | -1.9189815 | ||
| 3357 | op-snap---monthly-publication-august-2025.pdf | 1332 | 2025-08 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tower Hill | Tower Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.5335541 | -1.9186098 | ||
| 3358 | op-snap---monthly-publication-august-2025.pdf | 1333 | 2025-08 | Pedestrian | Land Rover | Sport SE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5333535 | -1.9189815 | ||
| 3361 | op-snap---monthly-publication-august-2025.pdf | 1336 | 2025-08 | Pedestrian | BMW | 335I | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley raod | Barnsley raod | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3362 | op-snap---monthly-publication-august-2025.pdf | 1337 | 2025-08 | Pedestrian | Isuzu | DMAZ | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 3364 | op-snap---monthly-publication-august-2025.pdf | 1339 | 2025-08 | Pedestrian | Tesla | model X | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stapenhall road | Stapenhall road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3365 | op-snap---monthly-publication-august-2025.pdf | 1340 | 2025-08 | Pedestrian | Citroen | relay | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Knightlow Road | Knightlow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4684561 | -1.9608907 | ||
| 3370 | op-snap---monthly-publication-august-2025.pdf | 1345 | 2025-08 | Car | Toyota | Auris | 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 | ||
| 3371 | op-snap---monthly-publication-august-2025.pdf | 1346 | 2025-08 | Car | Toyota | Avensis | 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 | ||
| 3372 | op-snap---monthly-publication-august-2025.pdf | 1347 | 2025-08 | Car | Honda | Civic | 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 | ||
| 3373 | op-snap---monthly-publication-august-2025.pdf | 1348 | 2025-08 | Car | Vauxhall | corsa | 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 | ||
| 3374 | op-snap---monthly-publication-august-2025.pdf | 1349 | 2025-08 | Car | Mercedes-Benz | e350 | 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 | ||
| 3375 | op-snap---monthly-publication-august-2025.pdf | 1350 | 2025-08 | Car | Seat | Alhambra | 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 | ||
| 3376 | op-snap---monthly-publication-august-2025.pdf | 1351 | 2025-08 | Pedestrian | Toyota | Aygo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Little Green Lane | Little Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4751722 | -1.860976 | ||
| 3379 | op-snap---monthly-publication-august-2025.pdf | 1354 | 2025-08 | Pedestrian | Audi | RS6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Port Hope ROad | Port Hope ROad | Birmingham | Birmingham | Warning Letter | N/A | 52.4661986 | -1.8764709 | ||
| 3380 | op-snap---monthly-publication-august-2025.pdf | 1355 | 2025-08 | Pedestrian | Kia | Stonic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Farm Road | Manor Farm Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4539235 | -1.8493825 | ||
| 3381 | op-snap---monthly-publication-august-2025.pdf | 1356 | 2025-08 | Car | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Rd | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3382 | op-snap---monthly-publication-august-2025.pdf | 1357 | 2025-08 | Car | Citroen | C3 | Black | 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 | ||
| 3383 | op-snap---monthly-publication-august-2025.pdf | 1358 | 2025-08 | Car | Ford | B-Max | 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 | ||
| 3384 | op-snap---monthly-publication-august-2025.pdf | 1359 | 2025-08 | Car | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Rd | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3385 | op-snap---monthly-publication-august-2025.pdf | 1360 | 2025-08 | Car | Toyota | Prius | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Rd | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3386 | op-snap---monthly-publication-august-2025.pdf | 1361 | 2025-08 | Car | Honda | Civic | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Rd | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3389 | op-snap---monthly-publication-august-2025.pdf | 1364 | 2025-08 | Pedestrian | Ford | S-Max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4700545 | -1.834436 | ||
| 3392 | op-snap---monthly-publication-august-2025.pdf | 1367 | 2025-08 | Pedestrian | Nissan | qashqai | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friary Road | Friary Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5162814 | -1.9395798 | ||
| 3393 | op-snap---monthly-publication-august-2025.pdf | 1368 | 2025-08 | Pedestrian | Ford | focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradshaw Road | Bradshaw Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3394 | op-snap---monthly-publication-august-2025.pdf | 1369 | 2025-08 | Pedestrian | Vauxhall | Combo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shutlock Street | Shutlock Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3395 | op-snap---monthly-publication-august-2025.pdf | 1370 | 2025-08 | Pedestrian | Toyota | auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Linden Road | Linden Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263156 | -1.9351622 | ||
| 3396 | op-snap---monthly-publication-august-2025.pdf | 1371 | 2025-08 | Pedestrian | Mg | HS | Silver | 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 | ||
| 3398 | op-snap---monthly-publication-august-2025.pdf | 1373 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dove House Lane | Dove House Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3399 | op-snap---monthly-publication-august-2025.pdf | 1374 | 2025-08 | Pedestrian | Kia | Picanto | Blue | 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 | ||
| 3400 | op-snap---monthly-publication-august-2025.pdf | 1375 | 2025-08 | Pedestrian | Audi | A7 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addison Road | Addison Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4313296 | -1.8882575 | ||
| 3402 | op-snap---monthly-publication-august-2025.pdf | 1377 | 2025-08 | Car | Toyota | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coleshill road | Coleshill road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | |||
| 3403 | op-snap---monthly-publication-august-2025.pdf | 1378 | 2025-08 | Car | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4624743 | -1.7763934 | ||
| 3406 | op-snap---monthly-publication-august-2025.pdf | 1381 | 2025-08 | Pedestrian | BMW | 320i | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stapenhall Road | Stapenhall Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3407 | op-snap---monthly-publication-august-2025.pdf | 1382 | 2025-08 | Car | Toyota | Auris | 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 | ||
| 3408 | op-snap---monthly-publication-august-2025.pdf | 1383 | 2025-08 | Car | Toyota | Auris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood Hetah road | washwood Hetah road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3409 | op-snap---monthly-publication-august-2025.pdf | 1384 | 2025-08 | Car | Citroen | C1 | Red | 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 | ||
| 3410 | op-snap---monthly-publication-august-2025.pdf | 1385 | 2025-08 | Car | Mazda | 3 Sport | 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 | ||
| 3414 | op-snap---monthly-publication-august-2025.pdf | 1389 | 2025-08 | Car | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Streetsbrooke Road | Streetsbrooke Road | Solihull | Solihull | Warning Letter | N/A | |||||
| 3415 | op-snap---monthly-publication-august-2025.pdf | 1390 | 2025-08 | Car | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addison Road | Addison Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4313296 | -1.8882575 | ||
| 3416 | op-snap---monthly-publication-august-2025.pdf | 1391 | 2025-08 | Car | Land Rover | Biography | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Portman Road | Portman Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4306424 | -1.8844833 | ||
| 3418 | op-snap---monthly-publication-august-2025.pdf | 1393 | 2025-08 | Car | Audi | A7 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cotterills Lane | Cotterills Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4884297 | -1.817811 | ||
| 3419 | op-snap---monthly-publication-august-2025.pdf | 1394 | 2025-08 | Pedestrian | Peugeot | 5008 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 3420 | op-snap---monthly-publication-august-2025.pdf | 1395 | 2025-08 | Pedestrian | Nissan | qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | The Droveway | The Droveway | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6213604 | -2.1617671 | ||
| 3422 | op-snap---monthly-publication-august-2025.pdf | 1397 | 2025-08 | Pedestrian | Citroen | relay | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.4471223 | -1.8664309 | ||
| 3423 | op-snap---monthly-publication-august-2025.pdf | 1398 | 2025-08 | Car | Peugeot | partner | 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 | ||
| 3424 | op-snap---monthly-publication-august-2025.pdf | 1399 | 2025-08 | Car | Volkswagen | passat | 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 | ||
| 3425 | op-snap---monthly-publication-august-2025.pdf | 1400 | 2025-08 | Car | Honda | Jazz | 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 |
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);