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'}
162 rows where month = "2025-05" 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, nfa_rationale
vehicle_make 27
council_area 9
- Birmingham 97
- Coventry 34
- Sandwell 10
- Solihull 7
- Sutton Coldfield 6
- Wolverhampton 3
- Walsall 2
- `Birmingham 2
- Dudley 1
reporter_transport_mode 6
- Pedestrian 68
- Pedal Bike 43
- Car 37
- Other 11
- car 2
- Van 1
disposal 6
- NFA 63
- Warning Letter 54
- Fixed Penalty 40
- Education 3
- Court 1
- Other Action Taken 1
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 162 ✖
month 1
- 2025-05 · 162 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18644 | op-snap---monthly-publication-may-2025.pdf | 6 | 2025-05 | Other | Volkswagen | Jetta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Haywards Close | Haywards Close | Birmingham | Birmingham | Fixed Penalty | N/A | 52.526412 | -1.8514249 | ||
| 18649 | op-snap---monthly-publication-may-2025.pdf | 11 | 2025-05 | Pedal Bike | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4569873 | -1.8971744 | ||
| 18650 | op-snap---monthly-publication-may-2025.pdf | 12 | 2025-05 | Other | Toyota | Prius | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5265939 | -1.8509884 | ||
| 18653 | op-snap---monthly-publication-may-2025.pdf | 15 | 2025-05 | Pedestrian | Volvo | XC60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clent Road | Clent Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4725947 | -1.9952306 | ||
| 18655 | op-snap---monthly-publication-may-2025.pdf | 17 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road | Castle Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5258312 | -2.0768625 | ||
| 18656 | op-snap---monthly-publication-may-2025.pdf | 18 | 2025-05 | Pedestrian | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheatley Road | Wheatley Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4705903 | -1.9933164 | ||
| 18664 | op-snap---monthly-publication-may-2025.pdf | 26 | 2025-05 | Other | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5265939 | -1.8509884 | ||
| 18666 | op-snap---monthly-publication-may-2025.pdf | 28 | 2025-05 | Other | Mercedes-Benz | A CLass | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5265939 | -1.8509884 | ||
| 18696 | op-snap---monthly-publication-may-2025.pdf | 58 | 2025-05 | Pedestrian | Audi | A6.. | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 18706 | op-snap---monthly-publication-may-2025.pdf | 68 | 2025-05 | Pedestrian | Nissan | Qashqai | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Field Lane | Field Lane | Dudley | Dudley | NFA | Not in Public Interest | 52.4469063 | -2.1430048 | ||
| 18726 | op-snap---monthly-publication-may-2025.pdf | 88 | 2025-05 | Pedal Bike | Mercedes-Benz | ML350 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westhill Road | Westhill Road | Coventry | Coventry | NFA | No Offence | 52.4225058 | -1.5356916 | ||
| 18733 | op-snap---monthly-publication-may-2025.pdf | 95 | 2025-05 | Pedestrian | Renault | CAPTUR | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | PETERSFIELD ROAD | Petersfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307 | -1.8494663 | ||
| 18737 | op-snap---monthly-publication-may-2025.pdf | 99 | 2025-05 | Pedestrian | Hyundai | Tucson | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Windsor Street South | Windsor Street South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4850068 | -1.8801252 | ||
| 18747 | op-snap---monthly-publication-may-2025.pdf | 109 | 2025-05 | Pedestrian | Volvo | S60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Trossachs Road | Trossachs Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.412542 | -1.5757615 | ||
| 18790 | op-snap---monthly-publication-may-2025.pdf | 152 | 2025-05 | Pedal Bike | Toyota | MPV | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Small Brook Queensway | Small Brook Queensway | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 18795 | op-snap---monthly-publication-may-2025.pdf | 157 | 2025-05 | Pedal Bike | Vauxhall | Insignia | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 18800 | op-snap---monthly-publication-may-2025.pdf | 162 | 2025-05 | Pedestrian | London Taxi | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Road | Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4220874 | -1.9409615 | |||
| 18809 | op-snap---monthly-publication-may-2025.pdf | 171 | 2025-05 | Car | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Soho Road | Soho Road | Birmingham | Birmingham | Education | N/A | 52.502568 | -1.9305447 | ||
| 18810 | op-snap---monthly-publication-may-2025.pdf | 172 | 2025-05 | Car | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Soho Road | Soho Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502568 | -1.9305447 | ||
| 18817 | op-snap---monthly-publication-may-2025.pdf | 179 | 2025-05 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hey Lane | Hey Lane | Solihull | Solihull | NFA | No VRM | ||||
| 18826 | op-snap---monthly-publication-may-2025.pdf | 188 | 2025-05 | Car | Honda | Civic | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4203897 | -1.8338574 | ||
| 18832 | op-snap---monthly-publication-may-2025.pdf | 194 | 2025-05 | Pedestrian | Peugeot | BVoxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broadway | Broadway | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3999339 | -1.5249817 | ||
| 18853 | op-snap---monthly-publication-may-2025.pdf | 215 | 2025-05 | Car | BMW | X3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 18866 | op-snap---monthly-publication-may-2025.pdf | 228 | 2025-05 | Pedestrian | Seat | Ibiza | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | NFA | No Offence | 52.4578511 | -1.9734988 | ||
| 18869 | op-snap---monthly-publication-may-2025.pdf | 231 | 2025-05 | Pedestrian | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lightswood Hill | Lightswood Hill | Birmingham | Birmingham | NFA | No Offence | ||||
| 18876 | op-snap---monthly-publication-may-2025.pdf | 238 | 2025-05 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4720132 | -1.9142946 | ||
| 18886 | op-snap---monthly-publication-may-2025.pdf | 248 | 2025-05 | Other | Seat | Leon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shutlock Lane | Shutlock Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4381927 | -1.9042054 | ||
| 18915 | op-snap---monthly-publication-may-2025.pdf | 277 | 2025-05 | Other | Volkswagen | Passat | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hayward Close | Hayward Close | Birmingham | Birmingham | NFA | No Offence | ||||
| 18940 | op-snap---monthly-publication-may-2025.pdf | 302 | 2025-05 | Pedestrian | Mercedes-Benz | E class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Halford Lane | Halford Lane | Coventry | Coventry | Education | N/A | 52.4398231 | -1.526811 | ||
| 18955 | op-snap---monthly-publication-may-2025.pdf | 317 | 2025-05 | Pedal Bike | Renault | Master | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford St | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 18962 | op-snap---monthly-publication-may-2025.pdf | 324 | 2025-05 | Pedestrian | BMW | X5 | 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 | 52.4470686 | -1.8880749 | ||
| 18970 | op-snap---monthly-publication-may-2025.pdf | 332 | 2025-05 | Pedestrian | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | City Road | City Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4763176 | -1.9584897 | ||
| 18973 | op-snap---monthly-publication-may-2025.pdf | 335 | 2025-05 | Pedal Bike | Volkswagen | Transporter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wolverhampton Road West Walsall | Wolverhampton Road West Walsall | Walsall | Walsall | Warning Letter | N/A | 52.586437 | -2.0276998 | ||
| 18996 | op-snap---monthly-publication-may-2025.pdf | 358 | 2025-05 | Pedestrian | Mercedes-Benz | CLA 180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4578511 | -1.9734988 | ||
| 19000 | op-snap---monthly-publication-may-2025.pdf | 362 | 2025-05 | Car | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WHITTINGTON OVAL | Whittington Oval | Birmingham | Birmingham | NFA | No VRM | 52.4800782 | -1.7942034 | ||
| 19001 | op-snap---monthly-publication-may-2025.pdf | 363 | 2025-05 | Car | Hyundai | I20 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WHITTINGTON OVAL | Whittington Oval | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4800782 | -1.7942034 | ||
| 19002 | op-snap---monthly-publication-may-2025.pdf | 364 | 2025-05 | Pedal Bike | Vauxhall | Zafira | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Canon Hill Road | Canon Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19019 | op-snap---monthly-publication-may-2025.pdf | 381 | 2025-05 | Van | Citroen | C4 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ELLESMERE ROAD | Ellesmere Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4881533 | -1.8553625 | ||
| 19041 | op-snap---monthly-publication-may-2025.pdf | 403 | 2025-05 | Pedestrian | Ford | various makes | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.5690681 | -1.8271174 | ||
| 19046 | op-snap---monthly-publication-may-2025.pdf | 408 | 2025-05 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Battery Way | Battery Way | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4493988 | -1.8476406 | ||
| 19066 | op-snap---monthly-publication-may-2025.pdf | 428 | 2025-05 | Pedal Bike | Jaguar | iPace | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Swarthmaore Road | Swarthmaore Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19090 | op-snap---monthly-publication-may-2025.pdf | 452 | 2025-05 | Car | Ford | S-Max | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No vehicle excise lice | nDcearwin Street | n Dcearwin Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19092 | op-snap---monthly-publication-may-2025.pdf | 454 | 2025-05 | Car | Nissan | Qashqai | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.468128 | -1.8848315 | ||
| 19110 | op-snap---monthly-publication-may-2025.pdf | 472 | 2025-05 | Other | Lexus | IS250 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Selly Park Road | Selly Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4390561 | -1.9209229 | ||
| 19115 | op-snap---monthly-publication-may-2025.pdf | 477 | 2025-05 | Pedal Bike | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4520441 | -1.8787544 | ||
| 19127 | op-snap---monthly-publication-may-2025.pdf | 489 | 2025-05 | Pedal Bike | Vauxhall | Astra | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 19139 | op-snap---monthly-publication-may-2025.pdf | 501 | 2025-05 | Pedestrian | Toyota | RAV 4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 19145 | op-snap---monthly-publication-may-2025.pdf | 507 | 2025-05 | Pedestrian | Mercedes-Benz | Vito | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4616763 | -1.9653016 | ||
| 19150 | op-snap---monthly-publication-may-2025.pdf | 512 | 2025-05 | Pedal Bike | Audi | A1 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gosford Street | Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4068712 | -1.4994695 | ||
| 19151 | op-snap---monthly-publication-may-2025.pdf | 513 | 2025-05 | Pedal Bike | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gosford Street | Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4068712 | -1.4994695 | ||
| 19152 | op-snap---monthly-publication-may-2025.pdf | 514 | 2025-05 | Pedal Bike | Volkswagen | Polo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gosford Street | Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4068712 | -1.4994695 | ||
| 19179 | op-snap---monthly-publication-may-2025.pdf | 541 | 2025-05 | Pedestrian | Vauxhall | Zafira | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodland Street | Woodland Street | Sandwell | Sandwell | Other Action Taken | nN/A | ||||
| 19187 | op-snap---monthly-publication-may-2025.pdf | 549 | 2025-05 | Pedal Bike | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 19191 | op-snap---monthly-publication-may-2025.pdf | 553 | 2025-05 | Pedestrian | Peugeot | Partner | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5664484 | -1.7828946 | ||
| 19192 | op-snap---monthly-publication-may-2025.pdf | 554 | 2025-05 | Pedestrian | Ford | Puma | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5664484 | -1.7828946 | ||
| 19219 | op-snap---monthly-publication-may-2025.pdf | 581 | 2025-05 | Car | Hyundai | I20.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bewdley Road | Bewdley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4330724 | -1.9181313 | ||
| 19220 | op-snap---monthly-publication-may-2025.pdf | 582 | 2025-05 | Pedestrian | Daf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5664484 | -1.7828946 | |||
| 19221 | op-snap---monthly-publication-may-2025.pdf | 583 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5664484 | -1.7828946 | ||
| 19255 | op-snap---monthly-publication-may-2025.pdf | 617 | 2025-05 | Pedal Bike | Hyundai | Tucson | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bulls Head Lane | Bulls Head Lane | Coventry | Coventry | NFA | No Offence | 52.4026553 | -1.4800859 | ||
| 19256 | op-snap---monthly-publication-may-2025.pdf | 618 | 2025-05 | Pedal Bike | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hill Street | Hill Street | Coventry | Coventry | Warning Letter | N/A | 52.4094312 | -1.51615 | ||
| 19257 | op-snap---monthly-publication-may-2025.pdf | 619 | 2025-05 | Pedal Bike | BMW | 118 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Norman Place Road | Norman Place Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4285935 | -1.5370895 | ||
| 19385 | op-snap---monthly-publication-may-2025.pdf | 747 | 2025-05 | Car | Toyota | Corolla | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5872149 | -1.8300386 | ||
| 19543 | op-snap---monthly-publication-may-2025.pdf | 905 | 2025-05 | Car | Volkswagen | Amarok | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | M6 junction 5 | M6 junction 5 | Birmingham | Birmingham | Education | N/A | 52.6760749 | -2.0862582 | ||
| 19550 | op-snap---monthly-publication-may-2025.pdf | 912 | 2025-05 | Car | Toyota | AURIS | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19551 | op-snap---monthly-publication-may-2025.pdf | 913 | 2025-05 | car | Seat | LEON | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19552 | op-snap---monthly-publication-may-2025.pdf | 914 | 2025-05 | car | Mercedes-Benz | SPRINTER | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19570 | op-snap---monthly-publication-may-2025.pdf | 932 | 2025-05 | Car | Audi | A5.. | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birchfield Lane | Birchfield Lane | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19691 | op-snap---monthly-publication-may-2025.pdf | 1053 | 2025-05 | Pedestrian | BMW | 3 Series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Salsbury Road | Salsbury Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19692 | op-snap---monthly-publication-may-2025.pdf | 1054 | 2025-05 | Pedal Bike | Toyota | Prius | 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 | ||
| 19693 | op-snap---monthly-publication-may-2025.pdf | 1055 | 2025-05 | Pedestrian | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4943878 | -1.8504211 | ||
| 19694 | op-snap---monthly-publication-may-2025.pdf | 1056 | 2025-05 | Pedestrian | Volkswagen | Troc | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4150779 | -1.930901 | ||
| 19697 | op-snap---monthly-publication-may-2025.pdf | 1059 | 2025-05 | Pedestrian | Volkswagen | Scirocco | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road Easat | Castle Road Easat | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 19698 | op-snap---monthly-publication-may-2025.pdf | 1060 | 2025-05 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Private Land | Private Land | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 19699 | op-snap---monthly-publication-may-2025.pdf | 1061 | 2025-05 | Car | Hyundai | Tuscon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Springfield Road | Springfield Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4327486 | -1.8844997 | ||
| 19702 | op-snap---monthly-publication-may-2025.pdf | 1064 | 2025-05 | Car | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Erithway Road | Erithway Road | Coventry | Coventry | Warning Letter | N/A | 52.379422 | -1.5198878 | ||
| 19706 | op-snap---monthly-publication-may-2025.pdf | 1068 | 2025-05 | Car | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anglesy Street | Anglesy Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19712 | op-snap---monthly-publication-may-2025.pdf | 1074 | 2025-05 | Pedestrian | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bagnall Road | Bagnall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4611092 | -1.8825745 | ||
| 19713 | op-snap---monthly-publication-may-2025.pdf | 1075 | 2025-05 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Road | Manor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5619179 | -1.8297455 | ||
| 19714 | op-snap---monthly-publication-may-2025.pdf | 1076 | 2025-05 | Pedal Bike | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Binley Road | Binley Road | Coventry | Coventry | Warning Letter | N/A | 52.4070602 | -1.4732469 | ||
| 19715 | op-snap---monthly-publication-may-2025.pdf | 1077 | 2025-05 | Pedal Bike | Mini | Cooper | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Binley Road | Binley Road | Coventry | Coventry | Warning Letter | N/A | 52.4070602 | -1.4732469 | ||
| 19720 | op-snap---monthly-publication-may-2025.pdf | 1082 | 2025-05 | Pedestrian | Peugeot | Expert | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Formans Road | Formans Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4482024 | -1.8507493 | ||
| 19735 | op-snap---monthly-publication-may-2025.pdf | 1097 | 2025-05 | Car | Seat | TOLEDO | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | WITTON ROAD | Witton Road | Birmingham | Birmingham | Court | N/A | 52.513336 | -1.8833226 | ||
| 19736 | op-snap---monthly-publication-may-2025.pdf | 1098 | 2025-05 | Car | Peugeot | 207 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19737 | op-snap---monthly-publication-may-2025.pdf | 1099 | 2025-05 | Car | Volkswagen | JETTA | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19738 | op-snap---monthly-publication-may-2025.pdf | 1100 | 2025-05 | Car | Mercedes-Benz | BENZ | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19739 | op-snap---monthly-publication-may-2025.pdf | 1101 | 2025-05 | Car | Ford | FOCUS | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19743 | op-snap---monthly-publication-may-2025.pdf | 1105 | 2025-05 | Pedestrian | Mercedes-Benz | C class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Agnes Road | Street Agnes Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19749 | op-snap---monthly-publication-may-2025.pdf | 1111 | 2025-05 | Pedestrian | Mercedes-Benz | Van | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barn lane | Barn lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4307492 | -1.8828708 | ||
| 19753 | op-snap---monthly-publication-may-2025.pdf | 1115 | 2025-05 | Pedestrian | BMW | 325i | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | South Road | South Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4972567 | -1.9214327 | ||
| 19769 | op-snap---monthly-publication-may-2025.pdf | 1131 | 2025-05 | Car | Volkswagen | Sharan | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oak Road | Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4623735 | -1.9822963 | ||
| 19774 | op-snap---monthly-publication-may-2025.pdf | 1136 | 2025-05 | Car | Audi | A1 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brighton Road | Brighton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543156 | -1.8840717 | ||
| 19775 | op-snap---monthly-publication-may-2025.pdf | 1137 | 2025-05 | Pedestrian | Vauxhall | Insignia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodgreen road | Woodgreen road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4637236 | -1.9981359 | ||
| 19776 | op-snap---monthly-publication-may-2025.pdf | 1138 | 2025-05 | Pedestrian | Peugeot | Boxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Crosswells Road | Crosswells Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19781 | op-snap---monthly-publication-may-2025.pdf | 1143 | 2025-05 | Car | Hyundai | GETZ | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WHITMORE ROAD | Whitmore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.469595 | -1.8626844 | ||
| 19784 | op-snap---monthly-publication-may-2025.pdf | 1146 | 2025-05 | Car | Toyota | ESTIMA | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 19785 | op-snap---monthly-publication-may-2025.pdf | 1147 | 2025-05 | Car | Audi | A4 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.513336 | -1.8833226 | ||
| 19787 | op-snap---monthly-publication-may-2025.pdf | 1149 | 2025-05 | Car | Ford | TRANSIT | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | CLARENCE ROAD | Clarence Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5940902 | -1.843503 | ||
| 19796 | op-snap---monthly-publication-may-2025.pdf | 1158 | 2025-05 | Pedestrian | Ford | ST | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4878246 | -1.9421047 | ||
| 19797 | op-snap---monthly-publication-may-2025.pdf | 1159 | 2025-05 | Pedestrian | BMW | 420.. | 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 | ||
| 19798 | op-snap---monthly-publication-may-2025.pdf | 1160 | 2025-05 | Pedestrian | Kia | Rio | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Winton Street | Winton Street | Birmingham | Birmingham | Warning Letter | N/A |
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);