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'}
266 rows where disposal = "Fixed Penalty" 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
vehicle_make 29
month 12
council_area 12
- Birmingham 130
- Coventry 52
- Sutton Coldfield 46
- Dudley 14
- Sandwell 9
- Halesowen 5
- Wolverhampton 3
- Metropolitan Borough 2
- Solihull 2
- Boiurmt Oinf Gfhoarmce 1
- Metropolitan Borough Of Dudley 1
- Walsall 1
reporter_transport_mode 4
- Pedestrian 131
- Car 75
- Pedal Bike 45
- Other 15
offence 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD · 266 ✖
disposal 1
- Fixed Penalty · 266 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7354 | op-snap---monthly-publication-february-2026.pdf | 101 | 2026-02 | Pedestrian | Ford | Focus | Silver | 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 | ||
| 7465 | op-snap---monthly-publication-february-2026.pdf | 212 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4374665 | -1.9119895 | ||
| 7525 | op-snap---monthly-publication-february-2026.pdf | 272 | 2026-02 | Pedestrian | Audi | Spyder | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | ||
| 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 | ||
| 7749 | op-snap---monthly-publication-february-2026.pdf | 496 | 2026-02 | Pedestrian | Land Rover | Defender | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Clarence Road | Clarence Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5940902 | -1.843503 | ||
| 7771 | op-snap---monthly-publication-february-2026.pdf | 518 | 2026-02 | Pedestrian | Audi | Q5 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7826 | op-snap---monthly-publication-february-2026.pdf | 573 | 2026-02 | Pedestrian | Nissan | Qashqai | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Halford Lane at Burnaby Road | Halford Lane at Burnaby Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4398231 | -1.526811 | ||
| 7853 | op-snap---monthly-publication-february-2026.pdf | 600 | 2026-02 | Pedestrian | Ford | focus | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Halford Lane | Halford Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4398231 | -1.526811 | ||
| 7891 | op-snap---monthly-publication-february-2026.pdf | 638 | 2026-02 | Pedestrian | Audi | A6 | 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 | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7892 | op-snap---monthly-publication-february-2026.pdf | 639 | 2026-02 | Pedestrian | Tesla | model 3 | 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 | ||
| 7894 | op-snap---monthly-publication-february-2026.pdf | 641 | 2026-02 | Pedestrian | Nissan | Juke | Black | 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 | ||
| 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 | ||
| 7977 | op-snap---monthly-publication-february-2026.pdf | 724 | 2026-02 | Other | Vauxhall | Astra | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5265939 | -1.8509884 | ||
| 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 | ||
| 8145 | op-snap---monthly-publication-february-2026.pdf | 892 | 2026-02 | Pedestrian | Citroen | C4X | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Green Lane | Green Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.38188 | -1.5300381 | ||
| 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 | |||
| 8193 | op-snap---monthly-publication-february-2026.pdf | 940 | 2026-02 | Pedestrian | Seat | Ibiza | 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 | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 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 | ||
| 8506 | op-snap---monthly-publication-february-2026.pdf | 1253 | 2026-02 | Pedal Bike | Volkswagen | Polo | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | City Road Bearwood | City Road Bearwood | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4825977 | -1.9621948 | ||
| 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 | ||
| 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 | ||
| 8755 | op-snap---monthly-publication-february-2026.pdf | 1502 | 2026-02 | Other | Hyundai | I30 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Trinity Road South | Trinity Road South | Sandwell | Sandwell | Fixed Penalty | N/A | 52.510081 | -1.9892908 | ||
| 11671 | op-snap---monthly-publication-january-2026.pdf | 1132 | 2026-01 | Pedestrian | Volkswagen | Polo | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | ||
| 11676 | op-snap---monthly-publication-january-2026.pdf | 1137 | 2026-01 | Pedestrian | Volkswagen | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | |||
| 11677 | op-snap---monthly-publication-january-2026.pdf | 1138 | 2026-01 | Pedestrian | Vauxhall | Grandland X | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 11738 | op-snap---monthly-publication-january-2026.pdf | 1199 | 2026-01 | Pedestrian | Audi | A1 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | ||
| 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 | ||
| 11786 | op-snap---monthly-publication-january-2026.pdf | 1247 | 2026-01 | Pedestrian | BMW | 218 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11790 | op-snap---monthly-publication-january-2026.pdf | 1251 | 2026-01 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11799 | op-snap---monthly-publication-january-2026.pdf | 1260 | 2026-01 | Pedestrian | BMW | 320D | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No Insurance | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11801 | op-snap---monthly-publication-january-2026.pdf | 1262 | 2026-01 | Pedestrian | Audi | A5 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11803 | op-snap---monthly-publication-january-2026.pdf | 1264 | 2026-01 | Pedestrian | Nissan | Qashqai | Beige | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11832 | op-snap---monthly-publication-january-2026.pdf | 1293 | 2026-01 | Pedestrian | Vauxhall | Movano | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane, Brierley Hill | Turners Lane, Brierley Hill | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 4654 | op-snap---monthly-publication-december-2025.pdf | 782 | 2025-12 | Pedestrian | 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 | ||
| 4740 | op-snap---monthly-publication-december-2025.pdf | 868 | 2025-12 | Pedestrian | Ford | C-Max | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road | Hobbs Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 21268 | op-snap---monthly-publication-november-2025.pdf | 810 | 2025-11 | Pedal Bike | Ford | Kuga | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gibbins Road Selly Oak | Gibbins Road Selly Oak | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4390303 | -1.9512931 | ||
| 2122 | op-snap---monthly-publication-august-2025.pdf | 97 | 2025-08 | Pedestrian | Renault | Scenic | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gulson Road | Gulson Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4076795 | -1.4911676 | ||
| 12209 | op-snap---monthly-publication-july-2025.pdf | 261 | 2025-07 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Kirkstone Way | Kirkstone Way | Dudley | Dudley | Fixed Penalty | N/A | 52.4709992 | -2.1310412 | ||
| 12607 | op-snap---monthly-publication-july-2025.pdf | 659 | 2025-07 | Pedestrian | Nissan | Note | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane, Brierley Hill | Turners Lane, Brierley Hill | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 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 | ||
| 14273 | op-snap---monthly-publication-june-2025.pdf | 202 | 2025-06 | Pedestrian | Mercedes-Benz | A180. | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No Insurance | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 14310 | op-snap---monthly-publication-june-2025.pdf | 239 | 2025-06 | Pedestrian | Vauxhall | Mokka | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 15773 | op-snap---monthly-publication-june-2025.pdf | 1702 | 2025-06 | Pedestrian | Honda | Civic | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gayfield Avenue | Gayfield Avenue | Metropolitan Borough | Metropolitan Borough | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 18694 | op-snap---monthly-publication-may-2025.pdf | 56 | 2025-05 | Pedestrian | Hyundai | I30 | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 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 | ||
| 18784 | op-snap---monthly-publication-may-2025.pdf | 146 | 2025-05 | Pedal Bike | Mercedes-Benz | BENZ | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | KENT STREET | Kent Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4717099 | -1.897463 | ||
| 18910 | op-snap---monthly-publication-may-2025.pdf | 272 | 2025-05 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 19093 | op-snap---monthly-publication-may-2025.pdf | 455 | 2025-05 | Pedestrian | Skoda | Fabia | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 19095 | op-snap---monthly-publication-may-2025.pdf | 457 | 2025-05 | Pedestrian | Renault | Clio | 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 | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 19102 | op-snap---monthly-publication-may-2025.pdf | 464 | 2025-05 | Pedal Bike | Seat | Leon | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4520441 | -1.8787544 | ||
| 19161 | op-snap---monthly-publication-may-2025.pdf | 523 | 2025-05 | Pedestrian | Nissan | Qashqai | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19165 | op-snap---monthly-publication-may-2025.pdf | 527 | 2025-05 | Pedestrian | Peugeot | 108 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19190 | op-snap---monthly-publication-may-2025.pdf | 552 | 2025-05 | Pedestrian | Ford | Focus | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 19239 | op-snap---monthly-publication-may-2025.pdf | 601 | 2025-05 | Pedestrian | BMW | X3 | 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 | ||
| 19267 | op-snap---monthly-publication-may-2025.pdf | 629 | 2025-05 | Pedal Bike | Seat | Arona | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | The Burges | The Burges | Coventry | Coventry | Fixed Penalty | N/A | 52.410226 | -1.5111468 | ||
| 19268 | op-snap---monthly-publication-may-2025.pdf | 630 | 2025-05 | Pedal Bike | BMW | 330 | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | The Burges | The Burges | Coventry | Coventry | Fixed Penalty | N/A | 52.410226 | -1.5111468 | ||
| 19556 | op-snap---monthly-publication-may-2025.pdf | 918 | 2025-05 | Pedestrian | Land Rover | Velar | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19711 | op-snap---monthly-publication-may-2025.pdf | 1073 | 2025-05 | Car | Nissan | 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 | |||
| 19843 | op-snap---monthly-publication-may-2025.pdf | 1205 | 2025-05 | Pedestrian | Toyota | Yaris | Grey | 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 | ||
| 19845 | op-snap---monthly-publication-may-2025.pdf | 1207 | 2025-05 | Pedestrian | Hyundai | Santa Fe | 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 | ||
| 19848 | op-snap---monthly-publication-may-2025.pdf | 1210 | 2025-05 | Pedestrian | Land Rover | Velar | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19849 | op-snap---monthly-publication-may-2025.pdf | 1211 | 2025-05 | Pedestrian | BMW | 5 series | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19851 | op-snap---monthly-publication-may-2025.pdf | 1213 | 2025-05 | Pedestrian | Mercedes-Benz | E-class | 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 | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19852 | op-snap---monthly-publication-may-2025.pdf | 1214 | 2025-05 | Pedestrian | Audi | Q2 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19853 | op-snap---monthly-publication-may-2025.pdf | 1215 | 2025-05 | Pedestrian | Ford | Transit | 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 | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 22 | op-snap---monthly-publication-april-2025.pdf | 21 | 2025-04 | Pedestrian | Toyota | VERSO | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | HIGHFIELD ROAD | Highfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4216321 | -1.855984 | ||
| 79 | op-snap---monthly-publication-april-2025.pdf | 78 | 2025-04 | Pedestrian | Volkswagen | Golf | 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 | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 106 | op-snap---monthly-publication-april-2025.pdf | 105 | 2025-04 | Pedestrian | Land Rover | Range Rover | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762433 | -1.9176665 | ||
| 107 | op-snap---monthly-publication-april-2025.pdf | 106 | 2025-04 | Pedestrian | Nissan | Cupra | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762433 | -1.9176665 | ||
| 193 | op-snap---monthly-publication-april-2025.pdf | 192 | 2025-04 | Car | Seat | Leon | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Street | Upper Holland Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | ||||
| 199 | op-snap---monthly-publication-april-2025.pdf | 198 | 2025-04 | Pedestrian | Toyota | CHR | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street at Upper Holland Road | Lower Queen Street at Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 207 | op-snap---monthly-publication-april-2025.pdf | 206 | 2025-04 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moor Green Lane | Moor Green Lane | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | ||||
| 337 | op-snap---monthly-publication-april-2025.pdf | 336 | 2025-04 | Car | Peugeot | 108 | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | BRISTOL ROAD SOUTH | Bristol Road South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4119174 | -1.9735247 | ||
| 345 | op-snap---monthly-publication-april-2025.pdf | 344 | 2025-04 | Car | Citroen | DS4 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Use vehicle on a road without valid test certificate | TOWER STREET | Tower Street | Dudley | Dudley | Fixed Penalty | N/A | 52.5112053 | -2.0833165 | ||
| 361 | op-snap---monthly-publication-april-2025.pdf | 360 | 2025-04 | Car | Vauxhall | CORSA | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | TOWER STREET | Tower Street | Dudley | Dudley | Fixed Penalty | N/A | 52.5112053 | -2.0833165 | ||
| 469 | op-snap---monthly-publication-april-2025.pdf | 468 | 2025-04 | Car | Seat | Leon | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Small Heath Highway | Small Heath Highway | BOiurmt oinf gFhoarmce | Boiurmt Oinf Gfhoarmce | Fixed Penalty | N/A | 52.4709298 | -1.8722585 | ||
| 496 | op-snap---monthly-publication-april-2025.pdf | 495 | 2025-04 | Pedestrian | Volkswagen | Passat | 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 | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 500 | op-snap---monthly-publication-april-2025.pdf | 499 | 2025-04 | Pedestrian | Volkswagen | Transporter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 501 | op-snap---monthly-publication-april-2025.pdf | 500 | 2025-04 | Pedestrian | Porsche | Cayyenne | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 538 | op-snap---monthly-publication-april-2025.pdf | 537 | 2025-04 | Car | Mercedes-Benz | E CLASS | 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 | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 557 | op-snap---monthly-publication-april-2025.pdf | 556 | 2025-04 | Pedestrian | Ford | Transit | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane, Brierley Hill | Turners Lane, Brierley Hill | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 581 | op-snap---monthly-publication-april-2025.pdf | 580 | 2025-04 | Pedestrian | Seat | Leon | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 686 | op-snap---monthly-publication-april-2025.pdf | 685 | 2025-04 | Car | Citroen | Berlingo | 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 | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 16250 | op-snap---monthly-publication-march-2025.pdf | 7 | 2025-03 | Car | Kia | Ceed | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Robert Street from Jews Lane | Robert Street from Jews Lane | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 16253 | op-snap---monthly-publication-march-2025.pdf | 10 | 2025-03 | Pedestrian | Dacia | Sandero | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street, Sutton Coldfield | Lower Queen Street, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5596343 | -1.8225298 | |
| 16269 | op-snap---monthly-publication-march-2025.pdf | 26 | 2025-03 | Car | Yamaha | Lex moto | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 16275 | op-snap---monthly-publication-march-2025.pdf | 32 | 2025-03 | Car | Mercedes-Benz | X350 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 16328 | op-snap---monthly-publication-march-2025.pdf | 85 | 2025-03 | Pedestrian | BMW | iX | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | St Martin's Queensway | Street Martin's Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4786917 | -1.8917295 | |
| 16354 | op-snap---monthly-publication-march-2025.pdf | 111 | 2025-03 | Other | Nissan | Micra | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tower Street | Tower Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 16376 | op-snap---monthly-publication-march-2025.pdf | 133 | 2025-03 | Other | Volkswagen | T-Cross | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.5265939 | -1.8509884 |
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);