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'}
278 rows where month = "2025-08", offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
council_area 8
- Birmingham 233
- Coventry 12
- Sandwell 10
- Wolverhampton 9
- Dudley 5
- Sutton Coldfield 4
- Out of Force Area 3
- Solihull 2
disposal 3
- Warning Letter 233
- NFA 44
- Other Action Taken 1
reporter_transport_mode 1
- Pedestrian · 278 ✖
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 278 ✖
month 1
- 2025-08 · 278 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 2653 | op-snap---monthly-publication-august-2025.pdf | 628 | 2025-08 | Pedestrian | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | Not in Public Interest | 52.3778812 | -1.7427424 | ||
| 2654 | op-snap---monthly-publication-august-2025.pdf | 629 | 2025-08 | Pedestrian | Peugeot | Expert | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | Not in Public Interest | 52.3778812 | -1.7427424 | ||
| 3014 | op-snap---monthly-publication-august-2025.pdf | 989 | 2025-08 | Pedestrian | Volkswagen | Transporter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Dudley | Dudley | NFA | Outside of 14 DAYS Late Submission | 52.546276 | -2.0795953 | ||
| 3218 | op-snap---monthly-publication-august-2025.pdf | 1193 | 2025-08 | Pedestrian | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whitmore Road | Whitmore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.469595 | -1.8626844 | ||
| 3222 | op-snap---monthly-publication-august-2025.pdf | 1197 | 2025-08 | Pedestrian | Renault | NP | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Farm Road | Manor Farm Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4539235 | -1.8493825 | ||
| 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 | ||
| 3225 | op-snap---monthly-publication-august-2025.pdf | 1200 | 2025-08 | Pedestrian | Volkswagen | NP | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 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 | ||
| 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 | ||||
| 3280 | op-snap---monthly-publication-august-2025.pdf | 1255 | 2025-08 | Pedestrian | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4743497 | -1.965737 | ||
| 3281 | op-snap---monthly-publication-august-2025.pdf | 1256 | 2025-08 | Pedestrian | Vauxhall | antara | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley road | Barnsley road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4743497 | -1.965737 | ||
| 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 | ||
| 3283 | op-snap---monthly-publication-august-2025.pdf | 1258 | 2025-08 | Pedestrian | Mercedes-Benz | na | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barnsley road | Barnsley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4743497 | -1.965737 | ||
| 3284 | op-snap---monthly-publication-august-2025.pdf | 1259 | 2025-08 | Pedestrian | Renault | megane | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pelham road | Pelham road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.487616 | -1.8277815 | ||
| 3285 | op-snap---monthly-publication-august-2025.pdf | 1260 | 2025-08 | Pedestrian | Ford | silver | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Out of force | Out of force | Out of Force Are | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 3363 | op-snap---monthly-publication-august-2025.pdf | 1338 | 2025-08 | Pedestrian | Land Rover | vogue | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stapenhall Road | Stapenhall Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 3366 | op-snap---monthly-publication-august-2025.pdf | 1341 | 2025-08 | Pedestrian | Audi | E tron | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4470686 | -1.8880749 | ||
| 3367 | op-snap---monthly-publication-august-2025.pdf | 1342 | 2025-08 | Pedestrian | Suzuki | celerio | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4470686 | -1.8880749 | ||
| 3368 | op-snap---monthly-publication-august-2025.pdf | 1343 | 2025-08 | Pedestrian | Ford | Kuga | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4470686 | -1.8880749 | ||
| 3369 | op-snap---monthly-publication-august-2025.pdf | 1344 | 2025-08 | Pedestrian | Hyundai | Ionic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Caroline Street | Caroline Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4868654 | -1.9087043 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 3432 | op-snap---monthly-publication-august-2025.pdf | 1407 | 2025-08 | Pedestrian | BMW | M3 | White | 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 | ||
| 3435 | op-snap---monthly-publication-august-2025.pdf | 1410 | 2025-08 | Pedestrian | Nissan | Leaf | Blue | 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 | ||
| 3436 | op-snap---monthly-publication-august-2025.pdf | 1411 | 2025-08 | Pedestrian | Mercedes-Benz | A180 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tettenhall High Street | Tettenhall High Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.598292 | -2.1677123 | ||
| 3438 | op-snap---monthly-publication-august-2025.pdf | 1413 | 2025-08 | Pedestrian | Seat | Ibiza | 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 | ||
| 3439 | op-snap---monthly-publication-august-2025.pdf | 1414 | 2025-08 | Pedestrian | Mercedes-Benz | A180 | Grey | 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 | ||
| 3440 | op-snap---monthly-publication-august-2025.pdf | 1415 | 2025-08 | Pedestrian | Seat | Ibiza | Blue | 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 | ||
| 3441 | op-snap---monthly-publication-august-2025.pdf | 1416 | 2025-08 | Pedestrian | Volvo | XC90 | Blue | 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 | ||
| 3445 | op-snap---monthly-publication-august-2025.pdf | 1420 | 2025-08 | Pedestrian | Ford | Fiesta | Grey | 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 | ||
| 3446 | op-snap---monthly-publication-august-2025.pdf | 1421 | 2025-08 | Pedestrian | Vauxhall | Grandland | Black | 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 | ||
| 3447 | op-snap---monthly-publication-august-2025.pdf | 1422 | 2025-08 | Pedestrian | Porsche | Macan | Black | 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 | ||
| 3448 | op-snap---monthly-publication-august-2025.pdf | 1423 | 2025-08 | Pedestrian | Audi | A3 | Grey | 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 | ||
| 3449 | op-snap---monthly-publication-august-2025.pdf | 1424 | 2025-08 | Pedestrian | Mercedes-Benz | c220 | Silver | 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 | ||
| 3450 | op-snap---monthly-publication-august-2025.pdf | 1425 | 2025-08 | Pedestrian | BMW | X7 | Grey | 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 | ||
| 3451 | op-snap---monthly-publication-august-2025.pdf | 1426 | 2025-08 | Pedestrian | Vauxhall | Mokka | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill | Cannon Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4516065 | -1.9026461 | ||
| 3453 | op-snap---monthly-publication-august-2025.pdf | 1428 | 2025-08 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ocker Hill Road | Ocker Hill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 3458 | op-snap---monthly-publication-august-2025.pdf | 1433 | 2025-08 | Pedestrian | Porsche | Macan | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tettenhall High Street | Tettenhall High Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.598292 | -2.1677123 | ||
| 3460 | op-snap---monthly-publication-august-2025.pdf | 1435 | 2025-08 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Beechmount Drive | Beechmount Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5318064 | -1.8324021 | ||
| 3469 | op-snap---monthly-publication-august-2025.pdf | 1444 | 2025-08 | Pedestrian | Ford | fiesta | Red | 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 | ||
| 3471 | op-snap---monthly-publication-august-2025.pdf | 1446 | 2025-08 | Pedestrian | Ford | focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kinstanding road | Kinstanding road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3473 | op-snap---monthly-publication-august-2025.pdf | 1448 | 2025-08 | Pedestrian | BMW | x3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | oak tree lane | Oak Tree Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.431258 | -1.9394381 | ||
| 3475 | op-snap---monthly-publication-august-2025.pdf | 1450 | 2025-08 | Pedestrian | Honda | civic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St oswald road | Street oswald road | Coventry | Coventry | Warning Letter | N/A | ||||
| 3476 | op-snap---monthly-publication-august-2025.pdf | 1451 | 2025-08 | Pedestrian | Mercedes-Benz | spinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 3477 | op-snap---monthly-publication-august-2025.pdf | 1452 | 2025-08 | Pedestrian | Hyundai | sata fe | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shutlock Lane | Shutlock Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4381927 | -1.9042054 | ||
| 3478 | op-snap---monthly-publication-august-2025.pdf | 1453 | 2025-08 | Pedestrian | Vauxhall | zafira | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Portway Hill | Portway Hill | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 3479 | op-snap---monthly-publication-august-2025.pdf | 1454 | 2025-08 | Pedestrian | Vauxhall | astra | Black | 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 | ||
| 3482 | op-snap---monthly-publication-august-2025.pdf | 1457 | 2025-08 | Pedestrian | Mitsubishi | Outlander | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cheveral Avenue | Cheveral Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4257402 | -1.5185037 | ||
| 3483 | op-snap---monthly-publication-august-2025.pdf | 1458 | 2025-08 | Pedestrian | BMW | 1 Series | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Rd | Cannon Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4569873 | -1.8971744 |
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);