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'}
340 rows where council_area = "Birmingham", 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, nfa_rationale
vehicle_make >30
reporter_transport_mode 4
- Pedestrian 233
- Car 97
- Pedal Bike 8
- Other 2
disposal 3
- Warning Letter 298
- NFA 39
- Other Action Taken 3
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 340 ✖
month 1
- 2025-08 · 340 ✖
council_area 1
- Birmingham · 340 ✖
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 3300 | op-snap---monthly-publication-august-2025.pdf | 1275 | 2025-08 | Car | Audi | a4 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 3301 | op-snap---monthly-publication-august-2025.pdf | 1276 | 2025-08 | Car | Mercedes-Benz | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4929304 | -1.8229092 | |||
| 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 | ||||
| 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 | ||
| 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 | ||
| 3411 | op-snap---monthly-publication-august-2025.pdf | 1386 | 2025-08 | Car | Mercedes-Benz | Vito | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 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 |
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);