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'}
285 rows where offence = "Use a vehicle / cycle on a road and contravene a local traffic order other than parking" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
month 13
council_area 11
- Birmingham 165
- Coventry 42
- Sutton Coldfield 25
- Dudley 20
- Sandwell 12
- Out of Force Area 6
- Walsall 5
- Wolverhampton 4
- Ds Rutotoand Coldfield 2
- Metropolitan Borough 2
- Solihull 2
disposal 6
- Warning Letter 99
- NFA 92
- Fixed Penalty 90
- Education 2
- Court 1
- Duplicate Submission 1
reporter_transport_mode 5
- Car 137
- Pedestrian 93
- Pedal Bike 37
- Other 17
- car 1
offence 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking · 285 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7727 | op-snap---monthly-publication-february-2026.pdf | 474 | 2026-02 | Pedestrian | Ford | Transit | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10556 | op-snap---monthly-publication-january-2026.pdf | 17 | 2026-01 | car | Mercedes-Benz | GLE | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Newhall St | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 10634 | op-snap---monthly-publication-january-2026.pdf | 95 | 2026-01 | Pedestrian | Nissan | X Trail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 10647 | op-snap---monthly-publication-january-2026.pdf | 108 | 2026-01 | Pedal Bike | Mercedes-Benz | Vito | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | New Street | New Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4791344 | -1.8986915 | ||
| 10672 | op-snap---monthly-publication-january-2026.pdf | 133 | 2026-01 | Car | BMW | 320d | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High Street, Deritend | High Street, Deritend | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4746492 | -1.8839977 | ||
| 10691 | op-snap---monthly-publication-january-2026.pdf | 152 | 2026-01 | Car | Toyota | Auris | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Street Lozells | Church Street Lozells | Birmingham | Birmingham | Warning Letter | N/A | 52.4997378 | -1.9113714 | ||
| 10694 | op-snap---monthly-publication-january-2026.pdf | 155 | 2026-01 | Pedestrian | Mercedes-Benz | E220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Road Tividale | Regent Road Tividale | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 10702 | op-snap---monthly-publication-january-2026.pdf | 163 | 2026-01 | Pedestrian | Volkswagen | Touran | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | Warning Letter | N/A | 52.4721372 | -2.1243522 | ||
| 10733 | op-snap---monthly-publication-january-2026.pdf | 194 | 2026-01 | Car | Citroen | C4 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walmley Road | Walmley Road | Birmingham | Birmingham | NFA | No Offence | 52.5534398 | -1.7987049 | ||
| 10736 | op-snap---monthly-publication-january-2026.pdf | 197 | 2026-01 | Pedestrian | Nissan | Juke | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Road | Regent Road | Dudley | Dudley | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 10756 | op-snap---monthly-publication-january-2026.pdf | 217 | 2026-01 | Car | Vauxhall | Corsa | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 10841 | op-snap---monthly-publication-january-2026.pdf | 302 | 2026-01 | Pedestrian | Vauxhall | Insignia | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Belgrade Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4668753 | -1.8996143 | ||
| 10960 | op-snap---monthly-publication-january-2026.pdf | 421 | 2026-01 | Car | Toyota | Estima | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | McKean Road | Mc Kean Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5077405 | -2.0124813 | ||
| 10976 | op-snap---monthly-publication-january-2026.pdf | 437 | 2026-01 | Car | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 11127 | op-snap---monthly-publication-january-2026.pdf | 588 | 2026-01 | Car | Nissan | Note | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5095686 | -1.9544485 | ||
| 11446 | op-snap---monthly-publication-january-2026.pdf | 907 | 2026-01 | Pedestrian | Peugeot | 2008 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4053419 | -1.8944602 | ||
| 11644 | op-snap---monthly-publication-january-2026.pdf | 1105 | 2026-01 | Car | Citroen | C4.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road at Edwards Road. | Moseley Road at Edwards Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 11720 | op-snap---monthly-publication-january-2026.pdf | 1181 | 2026-01 | Car | Honda | Civic | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bordesley Green East | Bordesley Green East | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4802441 | -1.8327073 | ||
| 11736 | op-snap---monthly-publication-january-2026.pdf | 1197 | 2026-01 | Pedestrian | Volkswagen | Polo | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.4321165 | -1.8902667 | ||
| 4099 | op-snap---monthly-publication-december-2025.pdf | 227 | 2025-12 | Pedal Bike | BMW | 335.. | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4397168 | -1.9260414 | ||
| 4382 | op-snap---monthly-publication-december-2025.pdf | 510 | 2025-12 | Car | Toyota | Corolla | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4450 | op-snap---monthly-publication-december-2025.pdf | 578 | 2025-12 | Car | BMW | Mini | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Long Street, Atherstone | Long Street, Atherstone | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4574 | op-snap---monthly-publication-december-2025.pdf | 702 | 2025-12 | Car | Kia | Stinger | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High St, Aston | High Street, Aston | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4973154 | -1.8956143 | ||
| 4575 | op-snap---monthly-publication-december-2025.pdf | 703 | 2025-12 | Car | Toyota | Prius | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High St Aston | High Street Aston | Birmingham | Birmingham | Fixed Penalty | N/A | 52.500816 | -1.8965601 | ||
| 5006 | op-snap---monthly-publication-december-2025.pdf | 1134 | 2025-12 | Car | Hyundai | I10 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 5114 | op-snap---monthly-publication-december-2025.pdf | 1242 | 2025-12 | Pedal Bike | Volkswagen | Transporter | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 20465 | op-snap---monthly-publication-november-2025.pdf | 7 | 2025-11 | Car | Ferrari | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bath Row, Birmingham | Bath Row, Birmingham | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4729953 | -1.905901 | |||
| 20479 | op-snap---monthly-publication-november-2025.pdf | 21 | 2025-11 | Car | Audi | Q3. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Street at Edmund Street | Church Street at Edmund Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 | ||
| 20776 | op-snap---monthly-publication-november-2025.pdf | 318 | 2025-11 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 20834 | op-snap---monthly-publication-november-2025.pdf | 376 | 2025-11 | Car | Citroen | C3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Rd | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 20940 | op-snap---monthly-publication-november-2025.pdf | 482 | 2025-11 | Car | Nissan | Leaf | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Midlands Road | Midlands Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4525632 | -1.8279809 | ||
| 20971 | op-snap---monthly-publication-november-2025.pdf | 513 | 2025-11 | Car | Toyota | Prius | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 20972 | op-snap---monthly-publication-november-2025.pdf | 514 | 2025-11 | Pedestrian | Peugeot | 2008 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Street | Regent Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4291721 | -1.9250565 | ||
| 20973 | op-snap---monthly-publication-november-2025.pdf | 515 | 2025-11 | Pedal Bike | Mercedes-Benz | GLC | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fredrick Street | Fredrick Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21086 | op-snap---monthly-publication-november-2025.pdf | 628 | 2025-11 | Pedestrian | BMW | 520D | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walsall Rd | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 21153 | op-snap---monthly-publication-november-2025.pdf | 695 | 2025-11 | Car | Peugeot | 3008 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 21154 | op-snap---monthly-publication-november-2025.pdf | 696 | 2025-11 | Car | Suzuki | Swift | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 21158 | op-snap---monthly-publication-november-2025.pdf | 700 | 2025-11 | Car | Mercedes-Benz | Dropside | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Soho Road | Soho Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502568 | -1.9305447 | ||
| 21166 | op-snap---monthly-publication-november-2025.pdf | 708 | 2025-11 | Pedestrian | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21167 | op-snap---monthly-publication-november-2025.pdf | 709 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21169 | op-snap---monthly-publication-november-2025.pdf | 711 | 2025-11 | Pedestrian | Citroen | DS3 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21170 | op-snap---monthly-publication-november-2025.pdf | 712 | 2025-11 | Pedestrian | Volkswagen | Passat | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21176 | op-snap---monthly-publication-november-2025.pdf | 718 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21203 | op-snap---monthly-publication-november-2025.pdf | 745 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21205 | op-snap---monthly-publication-november-2025.pdf | 747 | 2025-11 | Pedestrian | Honda | Jazz | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21765 | op-snap---monthly-publication-november-2025.pdf | 1307 | 2025-11 | Car | Skoda | Kamiq | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A452 Collector Road | Collector Road | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 21775 | op-snap---monthly-publication-november-2025.pdf | 1317 | 2025-11 | Car | Seat | Ibiza | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Nechells Parkway | Nechells Parkway | Birmingham | Birmingham | Education | N/A | 52.4922722 | -1.8711754 | ||
| 21947 | op-snap---monthly-publication-november-2025.pdf | 1489 | 2025-11 | Car | Nissan | Qashqai | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | ||
| 22124 | op-snap---monthly-publication-october-2025.pdf | 74 | 2025-10 | Pedestrian | Volvo | V60 | Gold | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lye By Pass | Lye By Pass | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4589885 | -2.1160387 | ||
| 22173 | op-snap---monthly-publication-october-2025.pdf | 123 | 2025-10 | Car | Kia | Ce'ed | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 22220 | op-snap---monthly-publication-october-2025.pdf | 170 | 2025-10 | Pedestrian | BMW | 330e | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4762433 | -1.9176665 | ||
| 22279 | op-snap---monthly-publication-october-2025.pdf | 229 | 2025-10 | Car | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 22334 | op-snap---monthly-publication-october-2025.pdf | 284 | 2025-10 | Car | Kia | Sportage | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4745488 | -1.8065911 | ||
| 22391 | op-snap---monthly-publication-october-2025.pdf | 341 | 2025-10 | Car | Hyundai | I30 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Warren Farm Road | Warren Farm Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5424846 | -1.8794625 | ||
| 22422 | op-snap---monthly-publication-october-2025.pdf | 372 | 2025-10 | Car | Ford | C Max | Brown | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 22442 | op-snap---monthly-publication-october-2025.pdf | 392 | 2025-10 | Car | Audi | Q3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4606652 | -1.8791145 | ||
| 22494 | op-snap---monthly-publication-october-2025.pdf | 444 | 2025-10 | Pedestrian | Peugeot | 2008.. | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 22543 | op-snap---monthly-publication-october-2025.pdf | 493 | 2025-10 | Car | Volkswagen | Golf | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 22544 | op-snap---monthly-publication-october-2025.pdf | 494 | 2025-10 | Car | Mercedes-Benz | C220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 22625 | op-snap---monthly-publication-october-2025.pdf | 575 | 2025-10 | Car | Peugeot | Eurotaxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 22638 | op-snap---monthly-publication-october-2025.pdf | 588 | 2025-10 | Car | BMW | 116i | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 22724 | op-snap---monthly-publication-october-2025.pdf | 674 | 2025-10 | Car | Nissan | X-Trail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Gulson Road | Gulson Road | Coventry | Coventry | NFA | No VRM | 52.4076795 | -1.4911676 | ||
| 22843 | op-snap---monthly-publication-october-2025.pdf | 793 | 2025-10 | Car | BMW | 118.. | Orange | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 22873 | op-snap---monthly-publication-october-2025.pdf | 823 | 2025-10 | Car | Mini | Cooper | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Warning Letter | N/A | 52.470423 | -1.9304786 | ||
| 22916 | op-snap---monthly-publication-october-2025.pdf | 866 | 2025-10 | Car | Mercedes-Benz | Sprinter | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High Street, | High Street | Dudley | Dudley | Warning Letter | N/A | 52.4779764 | -2.1598371 | ||
| 23001 | op-snap---monthly-publication-october-2025.pdf | 951 | 2025-10 | Car | Peugeot | Partner | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Chester Road | Chester Road | Solihull | Solihull | Warning Letter | N/A | 52.5021946 | -1.7719526 | ||
| 23092 | op-snap---monthly-publication-october-2025.pdf | 1042 | 2025-10 | Car | Audi | A3 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | St Martins Road | Street Martins Road | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 23322 | op-snap---monthly-publication-october-2025.pdf | 1272 | 2025-10 | Car | Toyota | Pirus | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stontey Stanton | Stontey Stanton | Coventry | Coventry | Warning Letter | N/A | ||||
| 23725 | op-snap---monthly-publication-october-2025.pdf | 1675 | 2025-10 | Pedestrian | Volvo | C70 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 23731 | op-snap---monthly-publication-october-2025.pdf | 1681 | 2025-10 | Car | Cupra | Ateca | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 23732 | op-snap---monthly-publication-october-2025.pdf | 1682 | 2025-10 | Car | Mercedes-Benz | C220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 23776 | op-snap---monthly-publication-october-2025.pdf | 1726 | 2025-10 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walsall Rd | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 2137 | op-snap---monthly-publication-august-2025.pdf | 112 | 2025-08 | Car | Ford | Kuga | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lottie Road | Lottie Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4393277 | -1.9383576 | ||
| 2241 | op-snap---monthly-publication-august-2025.pdf | 216 | 2025-08 | Pedestrian | Audi | A5 | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | Warning Letter | N/A | 52.4721372 | -2.1243522 | ||
| 2322 | op-snap---monthly-publication-august-2025.pdf | 297 | 2025-08 | Pedal Bike | Land Rover | Evoque | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Friar Park Road | Friar Park Road | Walsall | Walsall | Warning Letter | N/A | 52.5505096 | -1.9798102 | ||
| 2457 | op-snap---monthly-publication-august-2025.pdf | 432 | 2025-08 | Car | Audi | Q3 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | New John Street West | New John Street West | Birmingham | Birmingham | Warning Letter | N/A | 52.4944784 | -1.9122329 | ||
| 2533 | op-snap---monthly-publication-august-2025.pdf | 508 | 2025-08 | Other | Daf | HGV | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lucknow Road | Lucknow Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 2538 | op-snap---monthly-publication-august-2025.pdf | 513 | 2025-08 | Pedal Bike | Mercedes-Benz | E220 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Corporation Street | Corporation Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4086244 | -1.515132 | ||
| 2539 | op-snap---monthly-publication-august-2025.pdf | 514 | 2025-08 | Pedal Bike | Toyota | Prius | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 2593 | op-snap---monthly-publication-august-2025.pdf | 568 | 2025-08 | Other | Scania | lorry | Yellow | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 2691 | op-snap---monthly-publication-august-2025.pdf | 666 | 2025-08 | Car | BMW | 520.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 2703 | op-snap---monthly-publication-august-2025.pdf | 678 | 2025-08 | Car | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bishops gate Street | Bishops gate Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2910 | op-snap---monthly-publication-august-2025.pdf | 885 | 2025-08 | Car | Volkswagen | Passat | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A41 Newport | Newport | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.5027779 | -1.7982159 | ||
| 3109 | op-snap---monthly-publication-august-2025.pdf | 1084 | 2025-08 | Pedal Bike | Toyota | Avensis | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road, Kings Heath | Poplar Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 3122 | op-snap---monthly-publication-august-2025.pdf | 1097 | 2025-08 | Pedal Bike | Skoda | Octavia | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3150 | op-snap---monthly-publication-august-2025.pdf | 1125 | 2025-08 | Car | Audi | A3 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.503036 | -1.8289972 | ||
| 3188 | op-snap---monthly-publication-august-2025.pdf | 1163 | 2025-08 | Pedestrian | Toyota | Aygo | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A302 (London) | A302 (London) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3189 | op-snap---monthly-publication-august-2025.pdf | 1164 | 2025-08 | Pedestrian | Toyota | Yaris | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A302 (London) | A302 (London) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3335 | op-snap---monthly-publication-august-2025.pdf | 1310 | 2025-08 | Car | Ford | Transit | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 12018 | op-snap---monthly-publication-july-2025.pdf | 70 | 2025-07 | Pedestrian | Volvo | XC40 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Dudley Town Centre | Dudley Town Centre | Dudley | Dudley | Fixed Penalty | N/A | 52.5136239 | -2.0721522 | ||
| 12059 | op-snap---monthly-publication-july-2025.pdf | 111 | 2025-07 | Pedal Bike | BMW | 4 series | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 12060 | op-snap---monthly-publication-july-2025.pdf | 112 | 2025-07 | Car | Mercedes-Benz | A 180.. | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4178465 | -1.968864 | ||
| 12128 | op-snap---monthly-publication-july-2025.pdf | 180 | 2025-07 | Car | Skoda | Elroq | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Church Road | Church Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4624743 | -1.7763934 | ||
| 12145 | op-snap---monthly-publication-july-2025.pdf | 197 | 2025-07 | Other | BMW | 5 series | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Middlemarch Road | Middlemarch Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4316434 | -1.5142862 | ||
| 12177 | op-snap---monthly-publication-july-2025.pdf | 229 | 2025-07 | Car | Ssangyong taxi | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stetchford Lesiure Centre | Stetchford Lesiure Centre | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 12181 | op-snap---monthly-publication-july-2025.pdf | 233 | 2025-07 | Car | Ford | Puma | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broadwell Road | Broadwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5043614 | -2.0104333 | ||
| 12182 | op-snap---monthly-publication-july-2025.pdf | 234 | 2025-07 | Car | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Braodwell Road | Braodwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 12315 | op-snap---monthly-publication-july-2025.pdf | 367 | 2025-07 | Pedestrian | Volkswagen | Golf | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4721372 | -2.1243522 | ||
| 12530 | op-snap---monthly-publication-july-2025.pdf | 582 | 2025-07 | Car | Audi | TT | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Eardley Road, Streatham | Eardley Road, Streatham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12540 | op-snap---monthly-publication-july-2025.pdf | 592 | 2025-07 | Car | Vauxhall | Astra | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Wednesfield Road | Wednesfield Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5885601 | -2.122003 |
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);