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'}
146 rows where council_area = "Birmingham", offence = "Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 27
month 13
disposal 5
- Fixed Penalty 68
- Warning Letter 55
- NFA 21
- Court 1
- Education 1
reporter_transport_mode 1
- Pedestrian · 146 ✖
offence 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD · 146 ✖
council_area 1
- Birmingham · 146 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 7737 | op-snap---monthly-publication-february-2026.pdf | 484 | 2026-02 | Pedestrian | Ford | Transit | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 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 | ||
| 7790 | op-snap---monthly-publication-february-2026.pdf | 537 | 2026-02 | Pedestrian | Mg | HS | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5342947 | -1.8155375 | ||
| 7793 | op-snap---monthly-publication-february-2026.pdf | 540 | 2026-02 | Pedestrian | Volkswagen | Fox | Yellow | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5342947 | -1.8155375 | ||
| 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 | ||
| 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 | ||
| 8131 | op-snap---monthly-publication-february-2026.pdf | 878 | 2026-02 | Pedestrian | Jaguar | F Pace | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Emerson Road | Emerson Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4589005 | -1.9541717 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 10724 | op-snap---monthly-publication-january-2026.pdf | 185 | 2026-01 | Pedestrian | Land Rover | Discovery | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chilcote Close | Chilcote Close | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167178 | -1.8457291 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 4773 | op-snap---monthly-publication-december-2025.pdf | 901 | 2025-12 | Pedestrian | Vauxhall | Meriva | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne St | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 23413 | op-snap---monthly-publication-october-2025.pdf | 1363 | 2025-10 | Pedestrian | Cupra | Born | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ryland Street | Ryland Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4757111 | -1.9189009 | ||
| 23548 | op-snap---monthly-publication-october-2025.pdf | 1498 | 2025-10 | Pedestrian | 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 | NFA | Misc Inc Crimes | 52.4851181 | -1.9106263 | ||||
| 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 | ||
| 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 | |||
| 23635 | op-snap---monthly-publication-october-2025.pdf | 1585 | 2025-10 | Pedestrian | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | High St | High Street | Birmingham | Birmingham | NFA | No Offence | 52.5254588 | -1.8373064 | ||
| 2916 | op-snap---monthly-publication-august-2025.pdf | 891 | 2025-08 | Pedestrian | Audi | Q8 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Alcester Street | Alcester Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4696096 | -1.8871873 | ||
| 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 | ||
| 3697 | op-snap---monthly-publication-august-2025.pdf | 1672 | 2025-08 | Pedestrian | BMW | I4 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place, city centre | Regent Place, city centre | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 13540 | op-snap---monthly-publication-july-2025.pdf | 1592 | 2025-07 | Pedestrian | BMW | 120D | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 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 | ||
| 14331 | op-snap---monthly-publication-june-2025.pdf | 260 | 2025-06 | Pedestrian | Volkswagen | Golf | 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 | ||
| 15361 | op-snap---monthly-publication-june-2025.pdf | 1290 | 2025-06 | Pedestrian | Volkswagen | Passat | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | York Road | York Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5231321 | -1.8415573 | ||
| 15386 | op-snap---monthly-publication-june-2025.pdf | 1315 | 2025-06 | Pedestrian | Toyota | Auris | 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 | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 15762 | op-snap---monthly-publication-june-2025.pdf | 1691 | 2025-06 | Pedestrian | Kia | niro | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chapel house street | Chapel house street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.474429 | -1.8854816 | ||
| 15763 | op-snap---monthly-publication-june-2025.pdf | 1692 | 2025-06 | Pedestrian | Kia | Picanto | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Chapel house street | Chapel house street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.474429 | -1.8854816 | ||
| 16013 | op-snap---monthly-publication-june-2025.pdf | 1942 | 2025-06 | Pedestrian | Toyota | Verso | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4679402 | -1.881408 | ||
| 16219 | op-snap---monthly-publication-june-2025.pdf | 2148 | 2025-06 | Pedestrian | Toyota | corolla | 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 | ||
| 18645 | op-snap---monthly-publication-may-2025.pdf | 7 | 2025-05 | Pedestrian | Audi | A5.. | Silver | 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 | ||
| 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 | ||
| 18741 | op-snap---monthly-publication-may-2025.pdf | 103 | 2025-05 | Pedestrian | Mercedes-Benz | BENZ | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | NEWHALL HILL | Newhall Hill | Birmingham | Birmingham | Education | N/A | 52.4832761 | -1.9110049 | ||
| 18833 | op-snap---monthly-publication-may-2025.pdf | 195 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 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 | ||
| 19158 | op-snap---monthly-publication-may-2025.pdf | 520 | 2025-05 | Pedestrian | Ford | Fiesta | Red | 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 | ||
| 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 | ||
| 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 | ||
| 19652 | op-snap---monthly-publication-may-2025.pdf | 1014 | 2025-05 | Pedestrian | Audi | A4 | 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 | Warning Letter | N/A | 52.4520441 | -1.8787544 | ||
| 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 | ||
| 19850 | op-snap---monthly-publication-may-2025.pdf | 1212 | 2025-05 | Pedestrian | Kia | Ceed | 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 | NFA | No Offence | 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 | ||
| 20066 | op-snap---monthly-publication-may-2025.pdf | 1428 | 2025-05 | Pedestrian | Nissan | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | sherborne street | Sherborne Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4762433 | -1.9176665 | ||
| 20201 | op-snap---monthly-publication-may-2025.pdf | 1563 | 2025-05 | Pedestrian | Hyundai | I10 | 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 | ||
| 20202 | op-snap---monthly-publication-may-2025.pdf | 1564 | 2025-05 | Pedestrian | Seat | Ibiza | 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 | ||
| 20204 | op-snap---monthly-publication-may-2025.pdf | 1566 | 2025-05 | Pedestrian | Audi | Q8 | 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 | ||
| 20206 | op-snap---monthly-publication-may-2025.pdf | 1568 | 2025-05 | Pedestrian | Nissan | Qashqai | 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 | ||
| 20207 | op-snap---monthly-publication-may-2025.pdf | 1569 | 2025-05 | Pedestrian | Toyota | Prius | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 670 | op-snap---monthly-publication-april-2025.pdf | 669 | 2025-04 | Pedestrian | Citroen | Berlingo | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place at Victoria Street | Regent Place at Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 672 | op-snap---monthly-publication-april-2025.pdf | 671 | 2025-04 | Pedestrian | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place at Victoria Street | Regent Place at Victoria Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4860376 | -1.9095854 | ||
| 675 | op-snap---monthly-publication-april-2025.pdf | 674 | 2025-04 | Pedestrian | Mercedes-Benz | GLA 200 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place at Victoria Street | Regent Place at Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 678 | op-snap---monthly-publication-april-2025.pdf | 677 | 2025-04 | Pedestrian | Land Rover | Range Rover | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place at Victoria Street | Regent Place at Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 680 | op-snap---monthly-publication-april-2025.pdf | 679 | 2025-04 | Pedestrian | Mercedes-Benz | GLA 200 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Plave at Victoria Street | Regent Plave at Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 1594 | op-snap---monthly-publication-april-2025.pdf | 1593 | 2025-04 | Pedestrian | Toyota | NP | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bishopsgate street | Bishopsgate street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.473986 | -1.9147087 | ||
| 1772 | op-snap---monthly-publication-april-2025.pdf | 1771 | 2025-04 | Pedestrian | Tesla | NP | 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 | NFA | Outside of 14 Days NIP | 52.4470686 | -1.8880749 | ||
| 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 | |
| 16809 | op-snap---monthly-publication-march-2025.pdf | 566 | 2025-03 | Pedestrian | Toyota | PRIUS | Silver | 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 | |
| 16838 | op-snap---monthly-publication-march-2025.pdf | 595 | 2025-03 | Pedestrian | Vauxhall | Corsa | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5919543 | -1.8517118 | |
| 17169 | op-snap---monthly-publication-march-2025.pdf | 926 | 2025-03 | Pedestrian | Audi | Q8 | 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 | Warning Letter | N/A | Yes - Via Email | 52.471632 | -1.9456776 | |
| 17171 | op-snap---monthly-publication-march-2025.pdf | 928 | 2025-03 | Pedestrian | Porsche | Panamera | 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 | Yes - Via Email | 52.471632 | -1.9456776 | |
| 17630 | op-snap---monthly-publication-march-2025.pdf | 1387 | 2025-03 | Pedestrian | Audi | Q5 | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.471632 | -1.9456776 |
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);