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'}
230 rows where month = "2025-03", 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 27
council_area 10
- Birmingham 159
- Sandwell 25
- Sutton Coldfield 16
- Coventry 10
- Wolverhampton 8
- Solihull 6
- Dudley 2
- Halesowen 2
- Metropolitan Borough Of Dudley 1
- Out of Force Area 1
disposal 5
- Fixed Penalty 121
- Warning Letter 89
- NFA 17
- Other Action Taken 2
- Education 1
reporter_transport_mode 1
- Pedestrian · 230 ✖
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 230 ✖
month 1
- 2025-03 · 230 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16247 | op-snap---monthly-publication-march-2025.pdf | 4 | 2025-03 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bordesley Green East | Bordesley Green East | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4802441 | -1.8327073 | |
| 16255 | op-snap---monthly-publication-march-2025.pdf | 12 | 2025-03 | Pedestrian | Skoda | Fabia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16256 | op-snap---monthly-publication-march-2025.pdf | 13 | 2025-03 | Pedestrian | Mg | 3 | white | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16257 | op-snap---monthly-publication-march-2025.pdf | 14 | 2025-03 | Pedestrian | Mercedes-Benz | A-class | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16258 | op-snap---monthly-publication-march-2025.pdf | 15 | 2025-03 | Pedestrian | Ford | Ranger | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 16259 | op-snap---monthly-publication-march-2025.pdf | 16 | 2025-03 | Pedestrian | BMW | 1 series | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4198291 | -1.9241732 | |
| 16260 | op-snap---monthly-publication-march-2025.pdf | 17 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Balaclava Road | Balaclava Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4337176 | -1.896658 | |
| 16291 | op-snap---monthly-publication-march-2025.pdf | 48 | 2025-03 | Pedestrian | Audi | A4 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monica Rd | Monica Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4714936 | -1.8386654 | |
| 16300 | op-snap---monthly-publication-march-2025.pdf | 57 | 2025-03 | Pedestrian | Volkswagen | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Belchers Lane | Belchers Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4800061 | -1.833007 | ||
| 16302 | op-snap---monthly-publication-march-2025.pdf | 59 | 2025-03 | Pedestrian | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hillfields Smethwick | Hillfields Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | |||
| 16311 | op-snap---monthly-publication-march-2025.pdf | 68 | 2025-03 | Pedestrian | Mercedes-Benz | HGV | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4437078 | -1.8783408 | |
| 16313 | op-snap---monthly-publication-march-2025.pdf | 70 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whittingham Road | Whittingham Road | Halesowen | Halesowen | Fixed Penalty | N/A | Yes - Via Email | 52.4565123 | -2.0552093 | |
| 16337 | op-snap---monthly-publication-march-2025.pdf | 94 | 2025-03 | Pedestrian | Ford | transoit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grayswood Avenue | Grayswood Avenue | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4174998 | -1.5458389 | |
| 16345 | op-snap---monthly-publication-march-2025.pdf | 102 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friary Gardens | Friary Gardens | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5156395 | -1.9424976 | |
| 16346 | op-snap---monthly-publication-march-2025.pdf | 103 | 2025-03 | Pedestrian | Audi | A6 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Larch Avenue | Larch Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5153484 | -1.9438891 | |
| 16347 | op-snap---monthly-publication-march-2025.pdf | 104 | 2025-03 | Pedestrian | Peugeot | 208 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | 52.4191184 | -1.8326637 | |
| 16348 | op-snap---monthly-publication-march-2025.pdf | 105 | 2025-03 | Pedestrian | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Larch Avenue | Larch Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5153484 | -1.9438891 | |
| 16349 | op-snap---monthly-publication-march-2025.pdf | 106 | 2025-03 | Pedestrian | Mini | Cooper | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Larch Avenue | Larch Avenue | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5153484 | -1.9438891 | |
| 16351 | op-snap---monthly-publication-march-2025.pdf | 108 | 2025-03 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Larch Avenue | Larch Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5153484 | -1.9438891 | |
| 16358 | op-snap---monthly-publication-march-2025.pdf | 115 | 2025-03 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lonsdale Road | Lonsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4598834 | -1.9579382 | |
| 16359 | op-snap---monthly-publication-march-2025.pdf | 116 | 2025-03 | Pedestrian | BMW | 320D | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lonsdale Road | Lonsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4598834 | -1.9579382 | |
| 16360 | op-snap---monthly-publication-march-2025.pdf | 117 | 2025-03 | Pedestrian | Volkswagen | Golf | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lonsdale Road | Lonsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4598834 | -1.9579382 | |
| 16361 | op-snap---monthly-publication-march-2025.pdf | 118 | 2025-03 | Pedestrian | Fiat | 500X | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lonsdale Road | Lonsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4598834 | -1.9579382 | |
| 16362 | op-snap---monthly-publication-march-2025.pdf | 119 | 2025-03 | Pedestrian | Volvo | XC60 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lonsdale Road | Lonsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4598834 | -1.9579382 | |
| 16388 | op-snap---monthly-publication-march-2025.pdf | 145 | 2025-03 | Pedestrian | Hyundai | I10 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Showell Green Lane | Showell Green Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4474637 | -1.8691688 | |
| 16398 | op-snap---monthly-publication-march-2025.pdf | 155 | 2025-03 | Pedestrian | Audi | A4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 16417 | op-snap---monthly-publication-march-2025.pdf | 174 | 2025-03 | Pedestrian | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mount Street | Mount Street | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | |||
| 16425 | op-snap---monthly-publication-march-2025.pdf | 182 | 2025-03 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addenbrooke Road, Smethwick | Addenbrooke Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4841474 | -1.976878 | |
| 16426 | op-snap---monthly-publication-march-2025.pdf | 183 | 2025-03 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addenbrooke Road, Smethwick | Addenbrooke Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4841474 | -1.976878 | |
| 16431 | op-snap---monthly-publication-march-2025.pdf | 188 | 2025-03 | Pedestrian | Mercedes-Benz | Sprinter | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Honeyborne Road | Honeyborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.573704 | -1.8085174 | |
| 16480 | op-snap---monthly-publication-march-2025.pdf | 237 | 2025-03 | Pedestrian | Mazda | 2 SE-L | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road, Boldmere (Sutton Coldfield) | Chester Road, Boldmere (Sutton Coldfield) | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 16487 | op-snap---monthly-publication-march-2025.pdf | 244 | 2025-03 | Pedestrian | Volkswagen | Transporter | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyde Green | Lyde Green | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | |||
| 16506 | op-snap---monthly-publication-march-2025.pdf | 263 | 2025-03 | Pedestrian | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alderton Close | Alderton Close | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | 52.4019526 | -1.7842218 | |
| 16507 | op-snap---monthly-publication-march-2025.pdf | 264 | 2025-03 | Pedestrian | Peugeot | 3008 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Asheville Ave | Asheville Ave | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 16530 | op-snap---monthly-publication-march-2025.pdf | 287 | 2025-03 | Pedestrian | Mercedes-Benz | A180 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cape Street towards West Heath Road | Cape Street towards West Heath Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 16538 | op-snap---monthly-publication-march-2025.pdf | 295 | 2025-03 | Pedestrian | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wavers Marston | Wavers Marston | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 16553 | op-snap---monthly-publication-march-2025.pdf | 310 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Park Hill | Park Hill | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4521968 | -1.8944051 | |
| 16557 | op-snap---monthly-publication-march-2025.pdf | 314 | 2025-03 | Pedestrian | Volkswagen | ID3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Parkfield | Parkfield | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4427968 | -2.015773 | |
| 16596 | op-snap---monthly-publication-march-2025.pdf | 353 | 2025-03 | Pedestrian | Volvo | V40 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mary Vale Road | Mary Vale Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.425105 | -1.9312861 | |
| 16598 | op-snap---monthly-publication-march-2025.pdf | 355 | 2025-03 | Pedestrian | Vauxhall | Astra | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mary Vale Road | Mary Vale Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.425105 | -1.9312861 | |
| 16626 | op-snap---monthly-publication-march-2025.pdf | 383 | 2025-03 | Pedestrian | Seat | Leon | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4578511 | -1.9734988 | |
| 16627 | op-snap---monthly-publication-march-2025.pdf | 384 | 2025-03 | Pedestrian | Audi | A6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oak Tree Lane | Oak Tree Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.431258 | -1.9394381 | |
| 16629 | op-snap---monthly-publication-march-2025.pdf | 386 | 2025-03 | Pedestrian | Renault | Traffic | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4578511 | -1.9734988 | |
| 16630 | op-snap---monthly-publication-march-2025.pdf | 387 | 2025-03 | Pedestrian | Mercedes-Benz | C250 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Villiers Street | Upper Villiers Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5707602 | -2.1325856 | |
| 16645 | op-snap---monthly-publication-march-2025.pdf | 402 | 2025-03 | Pedestrian | Honda | ENY1 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Carlton Road | Carlton Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.475243 | -1.8549354 | |
| 16666 | op-snap---monthly-publication-march-2025.pdf | 423 | 2025-03 | Pedestrian | Nissan | Qashqai | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 16699 | op-snap---monthly-publication-march-2025.pdf | 456 | 2025-03 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16705 | op-snap---monthly-publication-march-2025.pdf | 462 | 2025-03 | Pedestrian | Audi | A4 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kenelm Road | Kenelm Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4710451 | -1.8504087 | |
| 16706 | op-snap---monthly-publication-march-2025.pdf | 463 | 2025-03 | Pedestrian | Seat | Ibiza | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kenelm Road | Kenelm Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4710451 | -1.8504087 | |
| 16707 | op-snap---monthly-publication-march-2025.pdf | 464 | 2025-03 | Pedestrian | Seat | Ibiza | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kenelm Road | Kenelm Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4710451 | -1.8504087 | |
| 16720 | op-snap---monthly-publication-march-2025.pdf | 477 | 2025-03 | Pedestrian | Ford | Ranger | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Station Road Marston Green | Station Road Marston Green | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 16724 | op-snap---monthly-publication-march-2025.pdf | 481 | 2025-03 | Pedestrian | Mercedes-Benz | B160 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hilton Road | Hilton Road | Sandwell | Sandwell | NFA | No Offence | Yes - Via Email | 52.5049194 | -2.0394583 | |
| 16726 | op-snap---monthly-publication-march-2025.pdf | 483 | 2025-03 | Pedestrian | Toyota | Auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hilton Road | Hilton Road | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.5049194 | -2.0394583 | |
| 16739 | op-snap---monthly-publication-march-2025.pdf | 496 | 2025-03 | Pedestrian | Nissan | Juke | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wootoon Road | Wootoon Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 16743 | op-snap---monthly-publication-march-2025.pdf | 500 | 2025-03 | Pedestrian | Audi | A6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oak Tree Lane | Oak Tree Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.431258 | -1.9394381 | |
| 16754 | op-snap---monthly-publication-march-2025.pdf | 511 | 2025-03 | Pedestrian | Mercedes-Benz | e220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Rd | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 16762 | op-snap---monthly-publication-march-2025.pdf | 519 | 2025-03 | Pedestrian | Mg | MG3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4381959 | -1.8907391 | |
| 16782 | op-snap---monthly-publication-march-2025.pdf | 539 | 2025-03 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tenbury Road | Tenbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4264041 | -1.8966768 | |
| 16828 | op-snap---monthly-publication-march-2025.pdf | 585 | 2025-03 | Pedestrian | Toyota | Auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hilton Road Wolverhampton | Hilton Road Wolverhampton | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5609419 | -2.1099418 | |
| 16833 | op-snap---monthly-publication-march-2025.pdf | 590 | 2025-03 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4878246 | -1.9421047 | |
| 16836 | op-snap---monthly-publication-march-2025.pdf | 593 | 2025-03 | Pedestrian | Honda | Jazz | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4878246 | -1.9421047 | |
| 16841 | op-snap---monthly-publication-march-2025.pdf | 598 | 2025-03 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Park Hill Road, Smethwick | Park Hill Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4752879 | -1.983422 | |
| 16842 | op-snap---monthly-publication-march-2025.pdf | 599 | 2025-03 | Pedestrian | Volkswagen | Golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hales Road, Wednesbury | Hales Road, Wednesbury | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | |||
| 16843 | op-snap---monthly-publication-march-2025.pdf | 600 | 2025-03 | Pedestrian | Hyundai | i40 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Parkes Street, Smethwick | Parkes Street, Smethwick | Sandwell | Sandwell | NFA | No VRM | Yes - Via Email | 52.4892987 | -1.97475 | |
| 16844 | op-snap---monthly-publication-march-2025.pdf | 601 | 2025-03 | Pedestrian | Seat | Ibiza | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Green Street, Smethwick | Green Street, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.5078981 | -1.9846469 | |
| 16846 | op-snap---monthly-publication-march-2025.pdf | 603 | 2025-03 | Pedestrian | Peugeot | 3008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cemetery Road, Smethwick | Cemetery Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4884734 | -1.9734958 | |
| 16847 | op-snap---monthly-publication-march-2025.pdf | 604 | 2025-03 | Pedestrian | Vauxhall | Corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cemetery Road, Smethwick | Cemetery Road, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.4884734 | -1.9734958 | |
| 16848 | op-snap---monthly-publication-march-2025.pdf | 605 | 2025-03 | Pedestrian | BMW | 1 series | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cemetery Road, Smethwick | Cemetery Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4884734 | -1.9734958 | |
| 16849 | op-snap---monthly-publication-march-2025.pdf | 606 | 2025-03 | Pedestrian | Vauxhall | Corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Thompson Road, Smethwick | Thompson Road, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.485863 | -1.9753873 | |
| 16850 | op-snap---monthly-publication-march-2025.pdf | 607 | 2025-03 | Pedestrian | Seat | Cupra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Thompson Road, Smethwick | Thompson Road, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.485863 | -1.9753873 | |
| 16854 | op-snap---monthly-publication-march-2025.pdf | 611 | 2025-03 | Pedestrian | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4725977 | -1.9684448 | |
| 16874 | op-snap---monthly-publication-march-2025.pdf | 631 | 2025-03 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road / Grange Road junction | York Road / Grange Road junction | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5231321 | -1.8415573 | |
| 16928 | op-snap---monthly-publication-march-2025.pdf | 685 | 2025-03 | Pedestrian | Toyota | Yaris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wood Green Road | Wood Green Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4885732 | -1.9428314 | |
| 16929 | op-snap---monthly-publication-march-2025.pdf | 686 | 2025-03 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wood Green Road | Wood Green Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4885732 | -1.9428314 | |
| 16932 | op-snap---monthly-publication-march-2025.pdf | 689 | 2025-03 | Pedestrian | Fiat | 500 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Charles Road | Charles Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5094492 | -1.9113648 | |
| 16945 | op-snap---monthly-publication-march-2025.pdf | 702 | 2025-03 | Pedestrian | Skoda | Octavia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Albert Road | Albert Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4854338 | -1.8140135 | |
| 16971 | op-snap---monthly-publication-march-2025.pdf | 728 | 2025-03 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4236341 | -1.8787502 | |
| 16973 | op-snap---monthly-publication-march-2025.pdf | 730 | 2025-03 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4306504 | -1.878052 | |
| 16987 | op-snap---monthly-publication-march-2025.pdf | 744 | 2025-03 | Pedestrian | N/P | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holland Street | Holland Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.5594346 | -1.8239493 | |||
| 16995 | op-snap---monthly-publication-march-2025.pdf | 752 | 2025-03 | Pedestrian | BMW | 320i | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mayswood Road | Mayswood Road | Solihull | Solihull | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4415095 | -1.7763187 | |
| 16996 | op-snap---monthly-publication-march-2025.pdf | 753 | 2025-03 | Pedestrian | Citroen | C1 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Melbourne Road | Melbourne Road | Halesowen | Halesowen | Warning Letter | N/A | Yes - Via Email | 52.4969107 | -1.7598346 | |
| 17011 | op-snap---monthly-publication-march-2025.pdf | 768 | 2025-03 | Pedestrian | Honda | Jazz | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hilton Road | Hilton Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5609419 | -2.1099418 | |
| 17027 | op-snap---monthly-publication-march-2025.pdf | 784 | 2025-03 | Pedestrian | Nissan | Qashqai | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Old Church road | Old Church road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4529004 | -1.9554069 | |
| 17038 | op-snap---monthly-publication-march-2025.pdf | 795 | 2025-03 | Pedestrian | Volvo | XC60 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hamstead Hall Road | Hamstead Hall Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5218145 | -1.93423 | |
| 17040 | op-snap---monthly-publication-march-2025.pdf | 797 | 2025-03 | Pedestrian | Toyota | Prius | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hamstead Hall Road | Hamstead Hall Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5218145 | -1.93423 | |
| 17041 | op-snap---monthly-publication-march-2025.pdf | 798 | 2025-03 | Pedestrian | BMW | 218 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hamstead Hall Road | Hamstead Hall Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5218145 | -1.93423 | |
| 17042 | op-snap---monthly-publication-march-2025.pdf | 799 | 2025-03 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addison Road Kings Heath | Addison Road Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4313296 | -1.8882575 | |
| 17084 | op-snap---monthly-publication-march-2025.pdf | 841 | 2025-03 | Pedestrian | Audi | A4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Maitland Road | Maitland Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4868494 | -1.8448776 | |
| 17114 | op-snap---monthly-publication-march-2025.pdf | 871 | 2025-03 | Pedestrian | Dacia | Duster | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Love Lane | Love Lane | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | Yes - Via Email | 52.4891878 | -1.8872036 | |
| 17140 | op-snap---monthly-publication-march-2025.pdf | 897 | 2025-03 | Pedestrian | Toyota | Auris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Peters Road | Street Peters Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17141 | op-snap---monthly-publication-march-2025.pdf | 898 | 2025-03 | Pedestrian | Honda | Jazz | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennyson Rd | Tennyson Road | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | |||
| 17142 | op-snap---monthly-publication-march-2025.pdf | 899 | 2025-03 | Pedestrian | BMW | X1 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wavers Marston | Wavers Marston | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17153 | op-snap---monthly-publication-march-2025.pdf | 910 | 2025-03 | Pedestrian | Nissan | Micra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road West | Castle Road West | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4358056 | -1.9593904 | |
| 17173 | op-snap---monthly-publication-march-2025.pdf | 930 | 2025-03 | Pedestrian | Audi | Q5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.4687472 | -1.9893922 | |
| 17175 | op-snap---monthly-publication-march-2025.pdf | 932 | 2025-03 | Pedestrian | BMW | 318I | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Allens Croft Road | Allens Croft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4242527 | -1.910803 | ||
| 17176 | op-snap---monthly-publication-march-2025.pdf | 933 | 2025-03 | Pedestrian | Skoda | Octavia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wellfield Road | Wellfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4244197 | -1.8309669 | |
| 17187 | op-snap---monthly-publication-march-2025.pdf | 944 | 2025-03 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Orphanage Road, Birmingham | Orphanage Road, Birmingham | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.5269356 | -1.8337856 | ||||
| 17188 | op-snap---monthly-publication-march-2025.pdf | 945 | 2025-03 | Pedestrian | Toyota | Prius | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17189 | op-snap---monthly-publication-march-2025.pdf | 946 | 2025-03 | Pedestrian | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5690681 | -1.8271174 | |
| 17236 | op-snap---monthly-publication-march-2025.pdf | 993 | 2025-03 | Pedestrian | BMW | 530D | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | College Road | College Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5151832 | -1.9361664 |
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);