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'}
210 rows where disposal = "Warning Letter" and offence = "Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD" 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 14
council_area 10
- Birmingham 136
- Sutton Coldfield 20
- Coventry 17
- Sandwell 16
- Dudley 8
- Wolverhampton 5
- Solihull 3
- Metropolitan Borough Of Dudley 2
- Walsall 2
- Halesowen 1
reporter_transport_mode 6
- Car 90
- Pedestrian 84
- Other 18
- Pedal Bike 16
- Lorry 1
- Motorbike 1
offence 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD · 210 ✖
disposal 1
- Warning Letter · 210 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7327 | op-snap---monthly-publication-february-2026.pdf | 74 | 2026-02 | Pedestrian | Citroen | DS3 | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Halford Lane | Halford Lane | Coventry | Coventry | Warning Letter | N/A | 52.4398231 | -1.526811 | ||
| 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 | ||
| 7333 | op-snap---monthly-publication-february-2026.pdf | 80 | 2026-02 | Pedestrian | Citroen | Cactus | Red | 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 | ||
| 7357 | op-snap---monthly-publication-february-2026.pdf | 104 | 2026-02 | Pedestrian | BMW | 128Ti | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No vehicle excise licence | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 7363 | op-snap---monthly-publication-february-2026.pdf | 110 | 2026-02 | Pedestrian | Ford | Focus | 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 | ||
| 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 | ||
| 7432 | op-snap---monthly-publication-february-2026.pdf | 179 | 2026-02 | Pedestrian | Audi | A5 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gayfield Av | Gayfield Avenue | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 7433 | op-snap---monthly-publication-february-2026.pdf | 180 | 2026-02 | Pedestrian | BMW | 320D | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gayfield Av | Gayfield Avenue | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 7483 | op-snap---monthly-publication-february-2026.pdf | 230 | 2026-02 | Pedestrian | Ford | Ecosport | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tividale Hall Road | Tividale Hall Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7486 | op-snap---monthly-publication-february-2026.pdf | 233 | 2026-02 | Pedestrian | BMW | 318.. | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 7488 | op-snap---monthly-publication-february-2026.pdf | 235 | 2026-02 | Pedestrian | Peugeot | Bipper | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 7491 | op-snap---monthly-publication-february-2026.pdf | 238 | 2026-02 | Pedestrian | Isuzu | Yukon | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4321165 | -1.8902667 | ||
| 7594 | op-snap---monthly-publication-february-2026.pdf | 341 | 2026-02 | Pedestrian | Mercedes-Benz | E220.. | Silver | 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 | ||
| 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 | ||
| 7747 | op-snap---monthly-publication-february-2026.pdf | 494 | 2026-02 | Pedestrian | Volkswagen | Troc | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 7770 | op-snap---monthly-publication-february-2026.pdf | 517 | 2026-02 | Pedestrian | Toyota | Aygo | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue | Woodfield Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5668728 | -2.1489012 | ||
| 7772 | op-snap---monthly-publication-february-2026.pdf | 519 | 2026-02 | Pedal Bike | Volkswagen | Transporter | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue | Woodfield Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5668728 | -2.1489012 | ||
| 7825 | op-snap---monthly-publication-february-2026.pdf | 572 | 2026-02 | Pedestrian | Mercedes-Benz | GLA | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue | Woodfield Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5668728 | -2.1489012 | ||
| 7832 | op-snap---monthly-publication-february-2026.pdf | 579 | 2026-02 | Pedestrian | Nissan | Qashqai | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Woodfield Avenue | Woodfield Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5668728 | -2.1489012 | ||
| 7883 | op-snap---monthly-publication-february-2026.pdf | 630 | 2026-02 | Pedestrian | Ford | Transit | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tiverton Road | Tiverton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4400034 | -1.9295885 | ||
| 7952 | op-snap---monthly-publication-february-2026.pdf | 699 | 2026-02 | Pedestrian | BMW | X2.. | 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 | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 7962 | op-snap---monthly-publication-february-2026.pdf | 709 | 2026-02 | Pedestrian | Ford | Fiesta | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coppice Road | Coppice Road | Solihull | Solihull | Warning Letter | N/A | 52.428932 | -1.7624515 | ||
| 7978 | op-snap---monthly-publication-february-2026.pdf | 725 | 2026-02 | Other | Nissan | Juke | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 8002 | op-snap---monthly-publication-february-2026.pdf | 749 | 2026-02 | Pedestrian | Nissan | Qashqai | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turnberry Road | Turnberry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5423917 | -1.9170598 | ||
| 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 | ||
| 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 | ||
| 8635 | op-snap---monthly-publication-february-2026.pdf | 1382 | 2026-02 | Pedestrian | Tesla | model 3 | Grey | 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 | ||
| 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 | ||
| 8711 | op-snap---monthly-publication-february-2026.pdf | 1458 | 2026-02 | Pedestrian | Honda | NSC | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | bishops gate street | Bishops Gate Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8712 | op-snap---monthly-publication-february-2026.pdf | 1459 | 2026-02 | Pedestrian | Honda | ww | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 8753 | op-snap---monthly-publication-february-2026.pdf | 1500 | 2026-02 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road Wednesbury | Hobbs Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8756 | op-snap---monthly-publication-february-2026.pdf | 1503 | 2026-02 | Pedestrian | Nissan | X-Trail | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road Wednesbury | Hobbs Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 11049 | op-snap---monthly-publication-january-2026.pdf | 510 | 2026-01 | Pedestrian | Vauxhall | Astra | Red | 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 | ||
| 11643 | op-snap---monthly-publication-january-2026.pdf | 1104 | 2026-01 | Pedestrian | Hyundai | Tucson | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Charter Academy | Charter Academy | Coventry | Coventry | Warning Letter | N/A | 52.3950371 | -1.5683301 | ||
| 11848 | op-snap---monthly-publication-january-2026.pdf | 1309 | 2026-01 | Pedestrian | Peugeot | Expert | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 3932 | op-snap---monthly-publication-december-2025.pdf | 60 | 2025-12 | Pedal Bike | Ford | Red | 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 | |||
| 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 | ||
| 4195 | op-snap---monthly-publication-december-2025.pdf | 323 | 2025-12 | Pedal Bike | Tesla | Model Y | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4234 | op-snap---monthly-publication-december-2025.pdf | 362 | 2025-12 | Pedestrian | Cupra | Ateca | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 4235 | op-snap---monthly-publication-december-2025.pdf | 363 | 2025-12 | Pedestrian | Mini | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | |||
| 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 | ||
| 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 | ||
| 4706 | op-snap---monthly-publication-december-2025.pdf | 834 | 2025-12 | Pedestrian | Honda | CR-V | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | The Oval | The Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4577754 | -1.8692099 | ||
| 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 | ||
| 4758 | op-snap---monthly-publication-december-2025.pdf | 886 | 2025-12 | Pedestrian | Honda | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Corporation Street | Corporation Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4895456 | -1.8900666 | |||
| 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 | ||
| 5094 | op-snap---monthly-publication-december-2025.pdf | 1222 | 2025-12 | Pedestrian | Jaguar | XE | Grey | 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 | No Independent Evidence Available | 52.471632 | -1.9456776 | ||
| 5153 | op-snap---monthly-publication-december-2025.pdf | 1281 | 2025-12 | Pedestrian | Toyota | Corolla | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 5155 | op-snap---monthly-publication-december-2025.pdf | 1283 | 2025-12 | Pedestrian | Volkswagen | Caddy | Green | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Withymoor Road | Withymoor Road | Dudley | Dudley | Warning Letter | N/A | 52.4871674 | -2.0702998 | ||
| 21107 | op-snap---monthly-publication-november-2025.pdf | 649 | 2025-11 | Pedestrian | Volkswagen | High UP | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4552055 | -1.9461279 | ||
| 21108 | op-snap---monthly-publication-november-2025.pdf | 650 | 2025-11 | Pedestrian | Suzuki | Ignis | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4552055 | -1.9461279 | ||
| 21196 | op-snap---monthly-publication-november-2025.pdf | 738 | 2025-11 | Pedestrian | Ford | Fiesta | White | 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 | ||
| 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 | ||
| 21823 | op-snap---monthly-publication-november-2025.pdf | 1365 | 2025-11 | Pedestrian | Jaguar | xf | 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 | ||
| 21824 | op-snap---monthly-publication-november-2025.pdf | 1366 | 2025-11 | Pedestrian | Lexus | ux250 | Black | 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 | ||
| 21825 | op-snap---monthly-publication-november-2025.pdf | 1367 | 2025-11 | Pedestrian | Audi | a1 | White | 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 | ||
| 21872 | op-snap---monthly-publication-november-2025.pdf | 1414 | 2025-11 | Pedestrian | Toyota | prius | 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 | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 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 | ||
| 23549 | op-snap---monthly-publication-october-2025.pdf | 1499 | 2025-10 | Pedestrian | Land Rover | Freelander | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 23551 | op-snap---monthly-publication-october-2025.pdf | 1501 | 2025-10 | Pedestrian | Toyota | Prius | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 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 | ||||
| 23633 | op-snap---monthly-publication-october-2025.pdf | 1583 | 2025-10 | Pedestrian | Yamaha | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bishopsgate street | Bishopsgate street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | |||
| 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 | |||
| 25230 | op-snap---monthly-publication-september-2025.pdf | 1449 | 2025-09 | Pedal Bike | BMW | M4 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5505398 | -1.8252993 | |||
| 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 | |||
| 25307 | op-snap---monthly-publication-september-2025.pdf | 1526 | 2025-09 | Pedal Bike | Tesla | Model Y | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | |||
| 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 | |||||||
| 2165 | op-snap---monthly-publication-august-2025.pdf | 140 | 2025-08 | Pedal Bike | Volkswagen | crafter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Friar Park Park | Friar Park Park | Sandwell | Sandwell | Warning Letter | N/A | 52.5547941 | -1.9893349 | ||
| 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 | ||
| 3391 | op-snap---monthly-publication-august-2025.pdf | 1366 | 2025-08 | Pedestrian | Audi | SQ5 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Carver Street | Carver Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4857687 | -1.915613 | ||
| 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 | ||||
| 3699 | op-snap---monthly-publication-august-2025.pdf | 1674 | 2025-08 | Pedestrian | Suzuki | Swift | 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 | ||
| 3703 | op-snap---monthly-publication-august-2025.pdf | 1678 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | 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 | ||
| 3704 | op-snap---monthly-publication-august-2025.pdf | 1679 | 2025-08 | Pedestrian | Toyota | Aygo | White | 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 | ||
| 3726 | op-snap---monthly-publication-august-2025.pdf | 1701 | 2025-08 | Pedestrian | Skoda | Superb | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Poplar Road, Kings Heath | Poplar Road, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3766 | op-snap---monthly-publication-august-2025.pdf | 1741 | 2025-08 | Pedestrian | Citroen | DS3 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vicarage Road, Kings Heath | Vicarage Road, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4301512 | -1.8996659 | ||
| 3767 | op-snap---monthly-publication-august-2025.pdf | 1742 | 2025-08 | Pedestrian | Vauxhall | Corsa | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vicarage Road, Kings Heath | Vicarage Road, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4301512 | -1.8996659 | ||
| 12026 | op-snap---monthly-publication-july-2025.pdf | 78 | 2025-07 | Pedal Bike | Toyota | Prius | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 12428 | op-snap---monthly-publication-july-2025.pdf | 480 | 2025-07 | Pedestrian | BMW | 420D | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Windward Way | Windward Way | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12690 | op-snap---monthly-publication-july-2025.pdf | 742 | 2025-07 | Pedal Bike | Honda | Moped | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4668753 | -1.8996143 | ||
| 13365 | op-snap---monthly-publication-july-2025.pdf | 1417 | 2025-07 | Pedestrian | Ford | transit | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 13411 | op-snap---monthly-publication-july-2025.pdf | 1463 | 2025-07 | Pedestrian | Toyota | Corolla | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Corporation Street | Corporation Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4895456 | -1.8900666 |
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);