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'}
167 rows where disposal = "Fixed Penalty", month = "2025-03" and offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 27
council_area 9
- Birmingham 113
- Coventry 20
- Sandwell 11
- Sutton Coldfield 11
- Solihull 4
- Wolverhampton 4
- Walsall 2
- Dudley 1
- Halesowen 1
reporter_transport_mode 5
- Pedestrian 121
- Pedal Bike 27
- Car 15
- Other 3
- Bus 1
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 167 ✖
month 1
- 2025-03 · 167 ✖
disposal 1
- Fixed Penalty · 167 ✖
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 16535 | op-snap---monthly-publication-march-2025.pdf | 292 | 2025-03 | Pedal Bike | Vauxhall | Corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 16536 | op-snap---monthly-publication-march-2025.pdf | 293 | 2025-03 | Pedal Bike | Hyundai | I10 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 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 | |
| 16569 | op-snap---monthly-publication-march-2025.pdf | 326 | 2025-03 | Other | UK | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |||
| 16601 | op-snap---monthly-publication-march-2025.pdf | 358 | 2025-03 | Pedal Bike | BMW | 520 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 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 | |
| 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 | |
| 16676 | op-snap---monthly-publication-march-2025.pdf | 433 | 2025-03 | Other | Volkswagen | T-Cross | Black | 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 | |
| 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 | |
| 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 | |
| 16753 | op-snap---monthly-publication-march-2025.pdf | 510 | 2025-03 | Pedal Bike | Seat | Leon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Legge Lane | Legge Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4843538 | -1.9127963 | |
| 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 | |
| 16814 | op-snap---monthly-publication-march-2025.pdf | 571 | 2025-03 | Pedal Bike | Mercedes-Benz | Coach | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cherry Tree Avenue, Walsall | Cherry Tree Avenue, Walsall | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 16817 | op-snap---monthly-publication-march-2025.pdf | 574 | 2025-03 | Pedal Bike | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Primrose Hill | Primrose Hill | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.3998874 | -1.9258787 | |
| 16818 | op-snap---monthly-publication-march-2025.pdf | 575 | 2025-03 | Pedal Bike | Audi | A5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highgate Road | Highgate Road | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | 52.574104 | -1.9740515 | |
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 16988 | op-snap---monthly-publication-march-2025.pdf | 745 | 2025-03 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4141818 | -1.5315277 | |
| 16990 | op-snap---monthly-publication-march-2025.pdf | 747 | 2025-03 | Car | Toyota | N/P | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4141818 | -1.5315277 | |
| 16991 | op-snap---monthly-publication-march-2025.pdf | 748 | 2025-03 | Car | Volkswagen | Taigo | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4141818 | -1.5315277 | |
| 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 | |
| 17043 | op-snap---monthly-publication-march-2025.pdf | 800 | 2025-03 | Car | Peugeot | Expert | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | De Montfort Way | De Montfort Way | Birmingham | Birmingham | Fixed Penalty | 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 | |||
| 17144 | op-snap---monthly-publication-march-2025.pdf | 901 | 2025-03 | Pedal Bike | Mercedes-Benz | ML280 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 17146 | op-snap---monthly-publication-march-2025.pdf | 903 | 2025-03 | Pedal Bike | Seat | Ibiza | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 17147 | op-snap---monthly-publication-march-2025.pdf | 904 | 2025-03 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 17151 | op-snap---monthly-publication-march-2025.pdf | 908 | 2025-03 | Pedal Bike | Toyota | Auris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 17154 | op-snap---monthly-publication-march-2025.pdf | 911 | 2025-03 | Pedal Bike | Hyundai | I10 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 17155 | op-snap---monthly-publication-march-2025.pdf | 912 | 2025-03 | Pedal Bike | Vauxhall | Insignia | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 17156 | op-snap---monthly-publication-march-2025.pdf | 913 | 2025-03 | Pedal Bike | Toyota | aqua | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708802 | -1.8792135 | |
| 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 | |
| 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 | |
| 17241 | op-snap---monthly-publication-march-2025.pdf | 998 | 2025-03 | Pedestrian | Jaguar | iPACE | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lichfield Road Mere Green | Lichfield Road Mere Green | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5872149 | -1.8300386 | |
| 17249 | op-snap---monthly-publication-march-2025.pdf | 1006 | 2025-03 | Pedestrian | Peugeot | 208 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4878246 | -1.9421047 | |
| 17250 | op-snap---monthly-publication-march-2025.pdf | 1007 | 2025-03 | Pedestrian | Volkswagen | Jetta | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4878246 | -1.9421047 | |
| 17255 | op-snap---monthly-publication-march-2025.pdf | 1012 | 2025-03 | Pedestrian | Volkswagen | Golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 17263 | op-snap---monthly-publication-march-2025.pdf | 1020 | 2025-03 | Pedestrian | Vauxhall | Corsa | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maitland Road | Maitland Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4868494 | -1.8448776 | |
| 17285 | op-snap---monthly-publication-march-2025.pdf | 1042 | 2025-03 | Pedal Bike | Vauxhall | Zafira | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 17286 | op-snap---monthly-publication-march-2025.pdf | 1043 | 2025-03 | Pedestrian | Land Rover | Evoque | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Lake Av | Long Lake Avenue | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | Yes - Via Email | 52.5914157 | -2.1849138 | |
| 17349 | op-snap---monthly-publication-march-2025.pdf | 1106 | 2025-03 | Pedestrian | BMW | 320 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | College RD, Moseley | College RD, Moseley | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4295958 | -1.8874346 | |
| 17350 | op-snap---monthly-publication-march-2025.pdf | 1107 | 2025-03 | Pedestrian | Audi | A5 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | College Rd, Moseley | College Road, Moseley | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4295958 | -1.8874346 | |
| 17351 | op-snap---monthly-publication-march-2025.pdf | 1108 | 2025-03 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxford Rd, Moseley | Oxford Road, Moseley | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4449095 | -1.8855079 | |
| 17352 | op-snap---monthly-publication-march-2025.pdf | 1109 | 2025-03 | Pedestrian | Nissan | Micra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxford Rd, Moseley | Oxford Road, Moseley | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4449095 | -1.8855079 | |
| 17370 | op-snap---monthly-publication-march-2025.pdf | 1127 | 2025-03 | Car | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Boscombe Road | Boscombe Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4521018 | -1.8489379 | |
| 17390 | op-snap---monthly-publication-march-2025.pdf | 1147 | 2025-03 | Pedestrian | Seat | Ibiza | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Marsham Road | Marsham Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4117052 | -1.888565 | |
| 17412 | op-snap---monthly-publication-march-2025.pdf | 1169 | 2025-03 | Pedestrian | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Green Road | Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.436871 | -1.8592799 | |
| 17417 | op-snap---monthly-publication-march-2025.pdf | 1174 | 2025-03 | Car | Citroen | C3 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | AUDLEY ROAD | Audley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4876917 | -1.7963729 | |
| 17418 | op-snap---monthly-publication-march-2025.pdf | 1175 | 2025-03 | Car | Toyota | YARIS | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | AUDLEY ROAD | Audley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4876917 | -1.7963729 | |
| 17432 | op-snap---monthly-publication-march-2025.pdf | 1189 | 2025-03 | Car | Ford | C MAX | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5603978 | -1.8227403 | |
| 17438 | op-snap---monthly-publication-march-2025.pdf | 1195 | 2025-03 | Pedestrian | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wherretts Well Lane | Wherretts Well Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 17447 | op-snap---monthly-publication-march-2025.pdf | 1204 | 2025-03 | Car | Kia | PICANTO | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | GREENHILL ROAD | Greenhill Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5142714 | -1.9419168 | |
| 17499 | op-snap---monthly-publication-march-2025.pdf | 1256 | 2025-03 | Pedestrian | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maitland Road Alum Rock | Maitland Road Alum Rock | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4868494 | -1.8448776 | |
| 17502 | op-snap---monthly-publication-march-2025.pdf | 1259 | 2025-03 | Pedestrian | Honda | Jazz | Blue | 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 | |
| 17516 | op-snap---monthly-publication-march-2025.pdf | 1273 | 2025-03 | Pedestrian | Mercedes-Benz | CLA | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4679402 | -1.881408 | |
| 17522 | op-snap---monthly-publication-march-2025.pdf | 1279 | 2025-03 | Pedestrian | BMW | 420D | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | MOSELEY ROAD | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4679402 | -1.881408 | |
| 17567 | op-snap---monthly-publication-march-2025.pdf | 1324 | 2025-03 | Pedestrian | Renault | Captur | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whitehouse Common Road | Whitehouse Common Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.574907 | -1.8032902 | |
| 17592 | op-snap---monthly-publication-march-2025.pdf | 1349 | 2025-03 | Pedestrian | Ford | Fiesta | Blue | 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 | |
| 17612 | op-snap---monthly-publication-march-2025.pdf | 1369 | 2025-03 | Pedal Bike | Peugeot | 208 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | CLISSOLD ROAD | Clissold Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 17656 | op-snap---monthly-publication-march-2025.pdf | 1413 | 2025-03 | Pedestrian | Audi | TT | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gladys Road | Gladys Road | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.47917 | -1.9730045 | |
| 17658 | op-snap---monthly-publication-march-2025.pdf | 1415 | 2025-03 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4865107 | -1.9386263 |
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);