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'}
205 rows where offence = "Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD" and reporter_transport_mode = "Car" 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 27
month 14
council_area 13
disposal 4
- Warning Letter 90
- Fixed Penalty 75
- NFA 39
- Education 1
reporter_transport_mode 1
- Car · 205 ✖
offence 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD · 205 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7331 | op-snap---monthly-publication-february-2026.pdf | 78 | 2026-02 | Car | Land Rover | Discovery | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Burnaby Road | Burnaby Road | Coventry | Coventry | Warning Letter | N/A | 52.4352 | -1.5194238 | ||
| 7392 | op-snap---monthly-publication-february-2026.pdf | 139 | 2026-02 | Car | Land Rover | Range Rover | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 7394 | op-snap---monthly-publication-february-2026.pdf | 141 | 2026-02 | Car | Renault | Clio | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 7395 | op-snap---monthly-publication-february-2026.pdf | 142 | 2026-02 | Car | Toyota | Yaris | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 7464 | op-snap---monthly-publication-february-2026.pdf | 211 | 2026-02 | Car | Vauxhall | Zafira | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Feldon Lane | Feldon Lane | Halesowen | Halesowen | Warning Letter | N/A | 52.466978 | -2.0272755 | ||
| 7591 | op-snap---monthly-publication-february-2026.pdf | 338 | 2026-02 | Car | Vauxhall | Zafira | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Great Charles Street Queensway | Great Charles Street Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4821283 | -1.9037074 | ||
| 7722 | op-snap---monthly-publication-february-2026.pdf | 469 | 2026-02 | Car | Vauxhall | Corsa | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 7744 | op-snap---monthly-publication-february-2026.pdf | 491 | 2026-02 | Car | Toyota | Yaris | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7745 | op-snap---monthly-publication-february-2026.pdf | 492 | 2026-02 | Car | Audi | Q3 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 7910 | op-snap---monthly-publication-february-2026.pdf | 657 | 2026-02 | Car | Nissan | Leaf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 7993 | op-snap---monthly-publication-february-2026.pdf | 740 | 2026-02 | Car | Mercedes-Benz | GLC | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 8016 | op-snap---monthly-publication-february-2026.pdf | 763 | 2026-02 | Car | Toyota | Yaris | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4606652 | -1.8791145 | ||
| 8021 | op-snap---monthly-publication-february-2026.pdf | 768 | 2026-02 | Car | Audi | Q3 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Highgate Road | Highgate Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4606652 | -1.8791145 | ||
| 8028 | op-snap---monthly-publication-february-2026.pdf | 775 | 2026-02 | Car | Skoda | Karoq | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 8102 | op-snap---monthly-publication-february-2026.pdf | 849 | 2026-02 | Car | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Landor Street | Landor Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4822898 | -1.8707686 | ||
| 8114 | op-snap---monthly-publication-february-2026.pdf | 861 | 2026-02 | Car | Mercedes-Benz | C43 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A34 Walsall Road | Walsall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5919543 | -1.8517118 | ||
| 8146 | op-snap---monthly-publication-february-2026.pdf | 893 | 2026-02 | Car | Land Rover | range Rover | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830179 | -1.783876 | ||
| 8150 | op-snap---monthly-publication-february-2026.pdf | 897 | 2026-02 | Car | Ford | Focus | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830179 | -1.783876 | ||
| 8152 | op-snap---monthly-publication-february-2026.pdf | 899 | 2026-02 | Car | Mercedes-Benz | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830179 | -1.783876 | |||
| 8162 | op-snap---monthly-publication-february-2026.pdf | 909 | 2026-02 | Car | Nissan | Juke | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Wheelwright Road | Wheelwright Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5096312 | -1.8353508 | ||
| 8323 | op-snap---monthly-publication-february-2026.pdf | 1070 | 2026-02 | Car | Peugeot | 3008 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tixall Road | Tixall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4193312 | -1.8517995 | ||
| 8359 | op-snap---monthly-publication-february-2026.pdf | 1106 | 2026-02 | Car | Mercedes-Benz | CLA | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Spon Lane, West Bromwich | Spon Lane, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5151568 | -1.9909305 | ||
| 8553 | op-snap---monthly-publication-february-2026.pdf | 1300 | 2026-02 | Car | Volkswagen | Tiguan | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Longmore Street / Belgrave Middleway | Longmore Street / Belgrave Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.463427 | -1.893104 | ||
| 8597 | op-snap---monthly-publication-february-2026.pdf | 1344 | 2026-02 | Car | Toyota | Prius | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen St | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 8678 | op-snap---monthly-publication-february-2026.pdf | 1425 | 2026-02 | Car | Skoda | Kamiq | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Throne Road | Throne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4875572 | -2.0284052 | ||
| 8681 | op-snap---monthly-publication-february-2026.pdf | 1428 | 2026-02 | Car | BMW | 118 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 10596 | op-snap---monthly-publication-january-2026.pdf | 57 | 2026-01 | Car | Audi | s3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | warwick road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 10814 | op-snap---monthly-publication-january-2026.pdf | 275 | 2026-01 | Car | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 10816 | op-snap---monthly-publication-january-2026.pdf | 277 | 2026-01 | Car | Volkswagen | Polo | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 11633 | op-snap---monthly-publication-january-2026.pdf | 1094 | 2026-01 | Car | Skoda | Kodiaq | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Leamington | Leamington | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4562055 | -1.8762502 | ||
| 11781 | op-snap---monthly-publication-january-2026.pdf | 1242 | 2026-01 | Car | BMW | 320.. | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Springfield Road | Springfield Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4865171 | -1.9991074 | ||
| 11856 | op-snap---monthly-publication-january-2026.pdf | 1317 | 2026-01 | Car | Audi | Q3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | NFA | No Offence | 52.4634433 | -1.9965278 | ||
| 4077 | op-snap---monthly-publication-december-2025.pdf | 205 | 2025-12 | Car | Mercedes-Benz | C180 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4181 | op-snap---monthly-publication-december-2025.pdf | 309 | 2025-12 | Car | Ford | Transit | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A46 Warwick Road | Warwick Road | Coventry | Coventry | NFA | No VRM | 52.401916 | -1.5154953 | ||
| 4496 | op-snap---monthly-publication-december-2025.pdf | 624 | 2025-12 | Car | Nissan | Qashqai | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 4497 | op-snap---monthly-publication-december-2025.pdf | 625 | 2025-12 | Car | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4967329 | -1.8097462 | ||
| 4502 | op-snap---monthly-publication-december-2025.pdf | 630 | 2025-12 | Car | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4503 | op-snap---monthly-publication-december-2025.pdf | 631 | 2025-12 | Car | Audi | A4 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4696 | op-snap---monthly-publication-december-2025.pdf | 824 | 2025-12 | Car | Vauxhall | astra | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4699 | op-snap---monthly-publication-december-2025.pdf | 827 | 2025-12 | Car | Citroen | c1 | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4710 | op-snap---monthly-publication-december-2025.pdf | 838 | 2025-12 | Car | Mercedes-Benz | GLA | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Minster Road | Minster Road | Coventry | Coventry | Warning Letter | N/A | 52.4100542 | -1.5227279 | ||
| 4776 | op-snap---monthly-publication-december-2025.pdf | 904 | 2025-12 | Car | Hyundai | IX35 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4777 | op-snap---monthly-publication-december-2025.pdf | 905 | 2025-12 | Car | Toyota | Yaris | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4779 | op-snap---monthly-publication-december-2025.pdf | 907 | 2025-12 | Car | Toyota | Yaris | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4846 | op-snap---monthly-publication-december-2025.pdf | 974 | 2025-12 | Car | Toyota | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | NFA | No Offence | 52.5095686 | -1.9544485 | |||
| 21197 | op-snap---monthly-publication-november-2025.pdf | 739 | 2025-11 | Car | Ford | Galaxy | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 21702 | op-snap---monthly-publication-november-2025.pdf | 1244 | 2025-11 | Car | BMW | 3 Series | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 22505 | op-snap---monthly-publication-october-2025.pdf | 455 | 2025-10 | Car | Mercedes-Benz | E220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 22516 | op-snap---monthly-publication-october-2025.pdf | 466 | 2025-10 | Car | Toyota | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4071231 | -1.4985178 | |||
| 22852 | op-snap---monthly-publication-october-2025.pdf | 802 | 2025-10 | Car | Toyota | Corolla | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Warning Letter | N/A | 52.4709298 | -1.8722585 | ||
| 23623 | op-snap---monthly-publication-october-2025.pdf | 1573 | 2025-10 | Car | Mercedes-Benz | A Class | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A38 | A38 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23680 | op-snap---monthly-publication-october-2025.pdf | 1630 | 2025-10 | Car | Toyota | Prius | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Church Street | Church Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 | ||
| 25225 | op-snap---monthly-publication-september-2025.pdf | 1444 | 2025-09 | Car | Alfa Romeo | Mito | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Penn Road | Penn Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5599616 | -2.1556338 | |||
| 25284 | op-snap---monthly-publication-september-2025.pdf | 1503 | 2025-09 | Car | Toyota | Prius | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | |||
| 2047 | op-snap---monthly-publication-august-2025.pdf | 22 | 2025-08 | Car | Ferrari | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham | Birmingham | Warning Letter | N/A | |||||||
| 2754 | op-snap---monthly-publication-august-2025.pdf | 729 | 2025-08 | Car | Skoda | Octivia | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5505398 | -1.8252993 | ||
| 2759 | op-snap---monthly-publication-august-2025.pdf | 734 | 2025-08 | Car | Toyota | Prius | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5505398 | -1.8252993 | ||
| 3309 | op-snap---monthly-publication-august-2025.pdf | 1284 | 2025-08 | Car | Toyota | MPV | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | out of force | Out Of Force | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3466 | op-snap---monthly-publication-august-2025.pdf | 1441 | 2025-08 | Car | Ford | transit | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | walmley ash road | Walmley Ash Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5376726 | -1.7973346 | ||
| 3494 | op-snap---monthly-publication-august-2025.pdf | 1469 | 2025-08 | Car | Volkswagen | caddy | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent place | Regent place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 3583 | op-snap---monthly-publication-august-2025.pdf | 1558 | 2025-08 | Car | Vauxhall | combi | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Horsley field | Horsley field | Dudley | Dudley | Warning Letter | N/A | ||||
| 3591 | op-snap---monthly-publication-august-2025.pdf | 1566 | 2025-08 | Car | Seat | leon | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4745488 | -1.8065911 | ||
| 3674 | op-snap---monthly-publication-august-2025.pdf | 1649 | 2025-08 | Car | Mercedes-Benz | CLA | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regenct PLace | Regenct PLace | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12068 | op-snap---monthly-publication-july-2025.pdf | 120 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Edward Road | Edward Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4580901 | -1.894458 | ||
| 13463 | op-snap---monthly-publication-july-2025.pdf | 1515 | 2025-07 | Car | Honda | CRV | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 13482 | op-snap---monthly-publication-july-2025.pdf | 1534 | 2025-07 | Car | Vauxhall | Vivaro | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5361464 | -1.8270283 | ||
| 13496 | op-snap---monthly-publication-july-2025.pdf | 1548 | 2025-07 | Car | Audi | A3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Holy Head road | Holy Head road | Coventry | Coventry | Warning Letter | N/A | ||||
| 13539 | op-snap---monthly-publication-july-2025.pdf | 1591 | 2025-07 | Car | Mercedes-Benz | c220 | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | New Town Road | New Town Road | Birmingham | Birmingham | Warning Letter | N/A | 52.517641 | -2.029198 | ||
| 13694 | op-snap---monthly-publication-july-2025.pdf | 1746 | 2025-07 | Car | Toyota | Avensis | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stechford | Stechford | Birmingham | Birmingham | Warning Letter | N/A | 52.4851563 | -1.8110345 | ||
| 13768 | op-snap---monthly-publication-july-2025.pdf | 1820 | 2025-07 | Car | Audi | A4 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | All Saints Way | All Saints Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5344405 | -1.985568 | ||
| 13854 | op-snap---monthly-publication-july-2025.pdf | 1906 | 2025-07 | Car | BMW | 330D | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Mosely Road | Mosely Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13855 | op-snap---monthly-publication-july-2025.pdf | 1907 | 2025-07 | Car | Nissan | Qasqai | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 13904 | op-snap---monthly-publication-july-2025.pdf | 1956 | 2025-07 | Car | Toyota | estima | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Merry Hill | Merry Hill | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4817646 | -2.1113435 | ||
| 13996 | op-snap---monthly-publication-july-2025.pdf | 2048 | 2025-07 | Car | Toyota | Auris | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Jewellery Quater | Jewellery Quater | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14096 | op-snap---monthly-publication-june-2025.pdf | 25 | 2025-06 | Car | Renault | CLIO | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ALBANY ROAD | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4006218 | -1.5284125 | ||
| 14520 | op-snap---monthly-publication-june-2025.pdf | 449 | 2025-06 | Car | Toyota | CHR | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 14676 | op-snap---monthly-publication-june-2025.pdf | 605 | 2025-06 | Car | BMW | X1 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Dudley St | Dudley Street | Dudley | Dudley | Fixed Penalty | N/A | 52.540391 | -2.1211076 | ||
| 14966 | op-snap---monthly-publication-june-2025.pdf | 895 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Thynne Street | Thynne Street | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5145422 | -1.9842613 | ||
| 14967 | op-snap---monthly-publication-june-2025.pdf | 896 | 2025-06 | Car | Volkswagen | Golf | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Farren Road | Farren Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4032097 | -1.9872219 | ||
| 14999 | op-snap---monthly-publication-june-2025.pdf | 928 | 2025-06 | Car | Peugeot | 2008... | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Metropolitan Borough | Metropolitan Borough | Fixed Penalty | N/A | 52.4719358 | -1.9341335 | ||
| 15001 | op-snap---monthly-publication-june-2025.pdf | 930 | 2025-06 | Car | Yamaha | MT09 | Purple | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4053419 | -1.8944602 | ||
| 15024 | op-snap---monthly-publication-june-2025.pdf | 953 | 2025-06 | Car | Ford | Transit | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 15119 | op-snap---monthly-publication-june-2025.pdf | 1048 | 2025-06 | Car | Seat | Ibiza | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4726661 | -1.8769032 | ||
| 15129 | op-snap---monthly-publication-june-2025.pdf | 1058 | 2025-06 | Car | Vauxhall | Astra | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 15141 | op-snap---monthly-publication-june-2025.pdf | 1070 | 2025-06 | Car | Toyota | Rav 4 | black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Showell Green Lane | Showell Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4474637 | -1.8691688 | ||
| 15165 | op-snap---monthly-publication-june-2025.pdf | 1094 | 2025-06 | Car | Wright Bus | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | |||
| 15184 | op-snap---monthly-publication-june-2025.pdf | 1113 | 2025-06 | Car | Vauxhall | Corsa | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Birmingham | Birmingham | Warning Letter | N/A | ||||||
| 15399 | op-snap---monthly-publication-june-2025.pdf | 1328 | 2025-06 | Car | Volvo | Polestar | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsgrove Road | Walsgrove Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 15462 | op-snap---monthly-publication-june-2025.pdf | 1391 | 2025-06 | Car | Audi | Q5 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | a452 | A452 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15709 | op-snap---monthly-publication-june-2025.pdf | 1638 | 2025-06 | Car | Seat | Leon | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5919543 | -1.8517118 | ||
| 15967 | op-snap---monthly-publication-june-2025.pdf | 1896 | 2025-06 | Car | Vauxhall | Mokka | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Norwood Road | Norwood Road | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4831397 | -2.1309273 | ||
| 16157 | op-snap---monthly-publication-june-2025.pdf | 2086 | 2025-06 | Car | Skoda | Octavia | Beige | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 16163 | op-snap---monthly-publication-june-2025.pdf | 2092 | 2025-06 | Car | Toyota | Corolla | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 18731 | op-snap---monthly-publication-may-2025.pdf | 93 | 2025-05 | Car | Toyota | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Cheapside | Cheapside | Birmingham | Birmingham | Warning Letter | N/A | 52.4724785 | -1.8864752 | |||
| 18748 | op-snap---monthly-publication-may-2025.pdf | 110 | 2025-05 | Car | Iveco | TRUCK | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 18753 | op-snap---monthly-publication-may-2025.pdf | 115 | 2025-05 | Car | Seat | Leon | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.473883 | -1.9198244 | ||
| 18836 | op-snap---monthly-publication-may-2025.pdf | 198 | 2025-05 | Car | Mercedes-Benz | A CLASS | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4863384 | -1.9123011 | ||
| 18854 | op-snap---monthly-publication-may-2025.pdf | 216 | 2025-05 | Car | Porsche | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | |||
| 18918 | op-snap---monthly-publication-may-2025.pdf | 280 | 2025-05 | Car | Volvo | S60 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 18931 | op-snap---monthly-publication-may-2025.pdf | 293 | 2025-05 | Car | Volkswagen | GOLF | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | CHURCH STREET | Church Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 |
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);