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'}
117 rows where offence = "Stop a vehicle on pedestrian crossing" and reporter_transport_mode = "Pedestrian" 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 28
month 12
council_area 10
- Birmingham 78
- Coventry 12
- Sandwell 6
- Wolverhampton 6
- Solihull 5
- Sutton Coldfield 3
- Walsall 3
- Askoelsihpuellare Drive 1
- Dudley 1
- Out of Force Area 1
disposal 4
- Fixed Penalty 41
- Education 32
- NFA 29
- Warning Letter 15
reporter_transport_mode 1
- Pedestrian · 117 ✖
offence 1
- Stop a vehicle on pedestrian crossing · 117 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7300 | op-snap---monthly-publication-february-2026.pdf | 47 | 2026-02 | Pedestrian | Citroen | Berlingo | Black | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5206297 | -1.9208426 | ||
| 7303 | op-snap---monthly-publication-february-2026.pdf | 50 | 2026-02 | Pedestrian | Mercedes-Benz | C220 | Silver | Stop a vehicle on pedestrian crossing | None | Inverclyde Road | Inverclyde Road | Birmingham | Birmingham | Education | N/A | 52.5218439 | -1.9215045 | ||
| 7406 | op-snap---monthly-publication-february-2026.pdf | 153 | 2026-02 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 7447 | op-snap---monthly-publication-february-2026.pdf | 194 | 2026-02 | Pedestrian | BMW | 218I | White | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7448 | op-snap---monthly-publication-february-2026.pdf | 195 | 2026-02 | Pedestrian | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7512 | op-snap---monthly-publication-february-2026.pdf | 259 | 2026-02 | Pedestrian | Kia | Niro | White | Stop a vehicle on pedestrian crossing | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4111289 | -1.5094345 | ||
| 7837 | op-snap---monthly-publication-february-2026.pdf | 584 | 2026-02 | Pedestrian | Cupra | Formentor | White | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7838 | op-snap---monthly-publication-february-2026.pdf | 585 | 2026-02 | Pedestrian | Volkswagen | Golf | Black | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7865 | op-snap---monthly-publication-february-2026.pdf | 612 | 2026-02 | Pedestrian | Ford | S-max | Brown | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 8126 | op-snap---monthly-publication-february-2026.pdf | 873 | 2026-02 | Pedestrian | Hyundai | Tucson | Grey | Stop a vehicle on pedestrian crossing | None | Booths Farm Road | Booths Farm Road | Birmingham | Birmingham | Education | N/A | 52.541377 | -1.9175615 | ||
| 8129 | op-snap---monthly-publication-february-2026.pdf | 876 | 2026-02 | Pedestrian | Mercedes-Benz | C220 | Silver | Stop a vehicle on pedestrian crossing | None | Booths Farm Road | Booths Farm Road | Birmingham | Birmingham | Education | N/A | 52.541377 | -1.9175615 | ||
| 8130 | op-snap---monthly-publication-february-2026.pdf | 877 | 2026-02 | Pedestrian | Toyota | Estima | Black | Stop a vehicle on pedestrian crossing | None | Booths Farm Road | Booths Farm Road | Birmingham | Birmingham | Education | N/A | 52.541377 | -1.9175615 | ||
| 10716 | op-snap---monthly-publication-january-2026.pdf | 177 | 2026-01 | Pedestrian | Toyota | Prius | Silver | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 10717 | op-snap---monthly-publication-january-2026.pdf | 178 | 2026-01 | Pedestrian | Audi | A1.. | Grey | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 10932 | op-snap---monthly-publication-january-2026.pdf | 393 | 2026-01 | Pedestrian | Nissan | Qashhqai | Red | Stop a vehicle on pedestrian crossing | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11297 | op-snap---monthly-publication-january-2026.pdf | 758 | 2026-01 | Pedestrian | Audi | A5 | Black | Stop a vehicle on pedestrian crossing | None | Oxford Street | Oxford Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4769326 | -1.8875782 | ||
| 11424 | op-snap---monthly-publication-january-2026.pdf | 885 | 2026-01 | Pedestrian | Mercedes-Benz | A200 | White | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 11458 | op-snap---monthly-publication-january-2026.pdf | 919 | 2026-01 | Pedestrian | Vauxhall | Mokka | Red | Stop a vehicle on pedestrian crossing | None | Bourneville Lane | Bourneville Lane | Birmingham | Birmingham | Education | N/A | ||||
| 11503 | op-snap---monthly-publication-january-2026.pdf | 964 | 2026-01 | Pedestrian | Hyundai | I30 | Grey | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 11522 | op-snap---monthly-publication-january-2026.pdf | 983 | 2026-01 | Pedestrian | Nissan | Qashqai | Red | Stop a vehicle on pedestrian crossing | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Education | N/A | 52.436035 | -1.891685 | ||
| 11751 | op-snap---monthly-publication-january-2026.pdf | 1212 | 2026-01 | Pedestrian | Audi | A4 | Red | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 5111 | op-snap---monthly-publication-december-2025.pdf | 1239 | 2025-12 | Pedestrian | Vauxhall | Astra | Black | Stop a vehicle on pedestrian crossing | None | Timberley Lane | Timberley Lane | Birmingham | Birmingham | Education | N/A | 52.4982049 | -1.7736502 | ||
| 21168 | op-snap---monthly-publication-november-2025.pdf | 710 | 2025-11 | Pedestrian | Peugeot | 2008 | Brown | Stop a vehicle on pedestrian crossing | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 21172 | op-snap---monthly-publication-november-2025.pdf | 714 | 2025-11 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle on pedestrian crossing | None | Radford Road | Radford Road | Coventry | Coventry | Warning Letter | N/A | 52.4235908 | -1.5226276 | ||
| 21173 | op-snap---monthly-publication-november-2025.pdf | 715 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21174 | op-snap---monthly-publication-november-2025.pdf | 716 | 2025-11 | Pedestrian | Seat | Leon | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21175 | op-snap---monthly-publication-november-2025.pdf | 717 | 2025-11 | Pedestrian | Honda | Civic | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 23136 | op-snap---monthly-publication-october-2025.pdf | 1086 | 2025-10 | Pedestrian | BMW | 530D | Black | Stop a vehicle on pedestrian crossing | None | Highbury Road | Highbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4326994 | -1.8979459 | ||
| 23273 | op-snap---monthly-publication-october-2025.pdf | 1223 | 2025-10 | Pedestrian | BMW | 420d | Silver | Stop a vehicle on pedestrian crossing | None | avenue road | Avenue Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4941712 | -1.8795158 | ||
| 23274 | op-snap---monthly-publication-october-2025.pdf | 1224 | 2025-10 | Pedestrian | BMW | 218i | White | Stop a vehicle on pedestrian crossing | None | high street, tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 23275 | op-snap---monthly-publication-october-2025.pdf | 1225 | 2025-10 | Pedestrian | Iveco | daily | White | Stop a vehicle on pedestrian crossing | None | high street, tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 23276 | op-snap---monthly-publication-october-2025.pdf | 1226 | 2025-10 | Pedestrian | Toyota | corolla | Black | Stop a vehicle on pedestrian crossing | None | high street, tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 23329 | op-snap---monthly-publication-october-2025.pdf | 1279 | 2025-10 | Pedestrian | Ford | Ranger | Silver | Stop a vehicle on pedestrian crossing | None | Tetennhall High Street | Tetennhall High Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 23375 | op-snap---monthly-publication-october-2025.pdf | 1325 | 2025-10 | Pedestrian | Vauxhall | Corsa | Red | Stop a vehicle on pedestrian crossing | None | Green Lane | Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4618966 | -1.9955421 | ||
| 25213 | op-snap---monthly-publication-september-2025.pdf | 1432 | 2025-09 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Tettenhall High Street | Tettenhall High Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.598292 | -2.1677123 | ||
| 14085 | op-snap---monthly-publication-june-2025.pdf | 14 | 2025-06 | Pedestrian | BMW | 520d | Black | Stop a vehicle on pedestrian crossing | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Education | N/A | 52.4353506 | -1.8927483 | ||
| 14995 | op-snap---monthly-publication-june-2025.pdf | 924 | 2025-06 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle on pedestrian crossing | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4437078 | -1.8783408 | ||
| 15319 | op-snap---monthly-publication-june-2025.pdf | 1248 | 2025-06 | Pedestrian | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Roses Lane | Roses Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 15927 | op-snap---monthly-publication-june-2025.pdf | 1856 | 2025-06 | Pedestrian | Toyota | Prius | White | Stop a vehicle on pedestrian crossing | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Education | N/A | 52.4865107 | -1.9386263 | ||
| 15966 | op-snap---monthly-publication-june-2025.pdf | 1895 | 2025-06 | Pedestrian | Nissan | Qashqai | Red | Stop a vehicle on pedestrian crossing | None | Albany Road | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4006218 | -1.5284125 | ||
| 15974 | op-snap---monthly-publication-june-2025.pdf | 1903 | 2025-06 | Pedestrian | Tesla | Model 3 | White | Stop a vehicle on pedestrian crossing | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Education | N/A | 52.4221526 | -1.8425617 | ||
| 16011 | op-snap---monthly-publication-june-2025.pdf | 1940 | 2025-06 | Pedestrian | BMW | 320D | Blue | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 16042 | op-snap---monthly-publication-june-2025.pdf | 1971 | 2025-06 | Pedestrian | BMW | X1 | Grey | Stop a vehicle on pedestrian crossing | None | Green Lane | Green Lane | Solihull | Solihull | NFA | No Independent Evidence Available | 52.5069826 | -1.7643766 | ||
| 19134 | op-snap---monthly-publication-may-2025.pdf | 496 | 2025-05 | Pedestrian | Audi | A3 | Grey | Stop a vehicle on pedestrian crossing | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 19136 | op-snap---monthly-publication-may-2025.pdf | 498 | 2025-05 | Pedestrian | Audi | A4 | White | Stop a vehicle on pedestrian crossing | No vehicle excise lice | nOceLTON BOULEVARD | n Oce LTON BOULEVARD | Birmingham | Birmingham | Education | N/A | ||||
| 19137 | op-snap---monthly-publication-may-2025.pdf | 499 | 2025-05 | Pedestrian | Toyota | COROLLA | Black | Stop a vehicle on pedestrian crossing | none | SHAFTMOOR LANE | Shaftmoor Lane | Birmingham | Birmingham | Education | N/A | 52.4418944 | -1.8407335 | ||
| 19138 | op-snap---monthly-publication-may-2025.pdf | 500 | 2025-05 | Pedestrian | Volkswagen | TOURAN | White | Stop a vehicle on pedestrian crossing | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Education | N/A | 52.443439 | -1.8180486 | ||
| 19217 | op-snap---monthly-publication-may-2025.pdf | 579 | 2025-05 | Pedestrian | Toyota | Corolla | White | Stop a vehicle on pedestrian crossing | None | Bordsley Green | Bordsley Green | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19824 | op-snap---monthly-publication-may-2025.pdf | 1186 | 2025-05 | Pedestrian | Volkswagen | Transporter | Blue | Stop a vehicle on pedestrian crossing | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 19838 | op-snap---monthly-publication-may-2025.pdf | 1200 | 2025-05 | Pedestrian | Citroen | Berlingo | White | Stop a vehicle on pedestrian crossing | None | Avenue Road | Avenue Road | Birmingham | Birmingham | Education | N/A | 52.4941712 | -1.8795158 | ||
| 19908 | op-snap---monthly-publication-may-2025.pdf | 1270 | 2025-05 | Pedestrian | Jaguar | NP | Black | Stop a vehicle on pedestrian crossing | None | Crossing Barrington road | Crossing Barrington road | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 19939 | op-snap---monthly-publication-may-2025.pdf | 1301 | 2025-05 | Pedestrian | Seat | Ateca | White | Stop a vehicle on pedestrian crossing | None | Corner of Falstaff road, at JCT of Sh | Corner of Falstaff road, at JCT of Sh | aSkoelsihpuellare drive | Askoelsihpuellare Drive | NFA | Outside of 14 Days NIP | ||||
| 19952 | op-snap---monthly-publication-may-2025.pdf | 1314 | 2025-05 | Pedestrian | Volkswagen | GOLF | Silver | Stop a vehicle on pedestrian crossing | None | A435 King heath high street | King heath high street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.435978 | -1.8925342 | ||
| 19987 | op-snap---monthly-publication-may-2025.pdf | 1349 | 2025-05 | Pedestrian | BMW | NP | Grey | Stop a vehicle on pedestrian crossing | None | Aston street | Aston street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860595 | -1.8878051 | ||
| 20025 | op-snap---monthly-publication-may-2025.pdf | 1387 | 2025-05 | Pedestrian | BMW | NP | Silver | Stop a vehicle on pedestrian crossing | None | Wattville road | Wattville road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5063926 | -1.9548648 | ||
| 20103 | op-snap---monthly-publication-may-2025.pdf | 1465 | 2025-05 | Pedestrian | Volkswagen | np | Grey | Stop a vehicle on pedestrian crossing | None | Allens croft road | Allens croft road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4242527 | -1.910803 | ||
| 484 | op-snap---monthly-publication-april-2025.pdf | 483 | 2025-04 | Pedestrian | BMW | X7 | Black | Stop a vehicle on pedestrian crossing | None | Alum Rock Rd | Alum Rock Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4883936 | -1.8310056 | ||
| 591 | op-snap---monthly-publication-april-2025.pdf | 590 | 2025-04 | Pedestrian | BMW | 316d | White | Stop a vehicle on pedestrian crossing | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4456462 | -1.827993 | ||
| 658 | op-snap---monthly-publication-april-2025.pdf | 657 | 2025-04 | Pedestrian | Ford | Focus | Grey | Stop a vehicle on pedestrian crossing | None | Green Lane | Green Lane | Solihull | Solihull | Education | N/A | 52.5069826 | -1.7643766 | ||
| 659 | op-snap---monthly-publication-april-2025.pdf | 658 | 2025-04 | Pedestrian | Mitsubishi | Colt | Red | Stop a vehicle on pedestrian crossing | None | Green Lane | Green Lane | Solihull | Solihull | Education | N/A | 52.5069826 | -1.7643766 | ||
| 695 | op-snap---monthly-publication-april-2025.pdf | 694 | 2025-04 | Pedestrian | Volkswagen | Pssat | Blue | Stop a vehicle on pedestrian crossing | None | Parkgate Rd | Parkgate Road | Coventry | Coventry | Fixed Penalty | N/A | 52.445796 | -1.5148141 | ||
| 732 | op-snap---monthly-publication-april-2025.pdf | 731 | 2025-04 | Pedestrian | Toyota | Aygo | Black | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 735 | op-snap---monthly-publication-april-2025.pdf | 734 | 2025-04 | Pedestrian | Audi | Q5 | White | Stop a vehicle on pedestrian crossing | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 1420 | op-snap---monthly-publication-april-2025.pdf | 1419 | 2025-04 | Pedestrian | Seat | Leon | Black | Stop a vehicle on pedestrian crossing | None | stratford road | Stratford Road | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4191184 | -1.8326637 | ||
| 1435 | op-snap---monthly-publication-april-2025.pdf | 1434 | 2025-04 | Pedestrian | BMW | NP | White | Stop a vehicle on pedestrian crossing | None | Hazelville Road | Hazelville Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4254442 | -1.8341081 | ||
| 1590 | op-snap---monthly-publication-april-2025.pdf | 1589 | 2025-04 | Pedestrian | NP | White | Stop a vehicle on pedestrian crossing | None | Bertam road | Bertam road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 1628 | op-snap---monthly-publication-april-2025.pdf | 1627 | 2025-04 | Pedestrian | Honda | np | Black | Stop a vehicle on pedestrian crossing | None | n/a (junction road, near corner of Clarence news store) | n/a (junction road, near corner of Clarence news store) | NFA | Outside of 14 Days NIP | ||||||
| 1657 | op-snap---monthly-publication-april-2025.pdf | 1656 | 2025-04 | Pedestrian | Volkswagen | NP | Black | Stop a vehicle on pedestrian crossing | None | Moseley road. Balsall heath | Moseley road. Balsall heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4426959 | -1.8847675 | ||
| 1919 | op-snap---monthly-publication-april-2025.pdf | 1918 | 2025-04 | Pedestrian | Honda | np | Blue | Stop a vehicle on pedestrian crossing | None | dudley road | Dudley Road | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4881161 | -2.1199108 | ||
| 1920 | op-snap---monthly-publication-april-2025.pdf | 1919 | 2025-04 | Pedestrian | Mini | Cooper | Black | Stop a vehicle on pedestrian crossing | None | Dudley road | Dudley road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4865107 | -1.9386263 | ||
| 1928 | op-snap---monthly-publication-april-2025.pdf | 1927 | 2025-04 | Pedestrian | Vauxhall | Van | White | Stop a vehicle on pedestrian crossing | None | Kingstanding road B4138 | Kingstanding road B4138 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5551037 | -1.8834687 | ||
| 1929 | op-snap---monthly-publication-april-2025.pdf | 1928 | 2025-04 | Pedestrian | Honda | Civic | Blue | Stop a vehicle on pedestrian crossing | None | Kingstanding road B4138 | Kingstanding road B4138 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5551037 | -1.8834687 | ||
| 1931 | op-snap---monthly-publication-april-2025.pdf | 1930 | 2025-04 | Pedestrian | Toyota | Verso | Silver | Stop a vehicle on pedestrian crossing | None | Kingstanding road B4138 | Kingstanding road B4138 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5551037 | -1.8834687 | ||
| 1939 | op-snap---monthly-publication-april-2025.pdf | 1938 | 2025-04 | Pedestrian | Skoda | NP | White | Stop a vehicle on pedestrian crossing | None | Chester Road north | Chester Road north | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.548449 | -1.8594603 | ||
| 16356 | op-snap---monthly-publication-march-2025.pdf | 113 | 2025-03 | Pedestrian | Honda | Civic | Blue | Stop a vehicle on pedestrian crossing | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4221526 | -1.8425617 | |
| 16413 | op-snap---monthly-publication-march-2025.pdf | 170 | 2025-03 | Pedestrian | Porsche | Cayenne | Black | Stop a vehicle on pedestrian crossing | None | Albany Road | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4006218 | -1.5284125 | |
| 16461 | op-snap---monthly-publication-march-2025.pdf | 218 | 2025-03 | Pedestrian | Peugeot | 2008 | Blue | Stop a vehicle on pedestrian crossing | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4308271 | -1.920078 | |
| 16696 | op-snap---monthly-publication-march-2025.pdf | 453 | 2025-03 | Pedestrian | Fiat | 500 | White | Stop a vehicle on pedestrian crossing | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16697 | op-snap---monthly-publication-march-2025.pdf | 454 | 2025-03 | Pedestrian | Volkswagen | Sharan | Silver | Stop a vehicle on pedestrian crossing | None | Dudley Rd | Dudley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 16926 | op-snap---monthly-publication-march-2025.pdf | 683 | 2025-03 | Pedestrian | Ford | Kuga | Silver | Stop a vehicle on pedestrian crossing | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5521118 | -1.8845138 | |
| 17013 | op-snap---monthly-publication-march-2025.pdf | 770 | 2025-03 | Pedestrian | Chevrolet | Cruze | Black | Stop a vehicle on pedestrian crossing | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | |||
| 17022 | op-snap---monthly-publication-march-2025.pdf | 779 | 2025-03 | Pedestrian | Mercedes-Benz | A180 | Grey | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Wolverhampton | Wolverhampton | Education | N/A | Yes - Via Email | 52.5635963 | -2.0827567 | |
| 17244 | op-snap---monthly-publication-march-2025.pdf | 1001 | 2025-03 | Pedestrian | Audi | A6 | Blue | Stop a vehicle on pedestrian crossing | No vehicle excise licence | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4520441 | -1.8787544 | |
| 17458 | op-snap---monthly-publication-march-2025.pdf | 1215 | 2025-03 | Pedestrian | Peugeot | 308 SPORT | Red | Stop a vehicle on pedestrian crossing | None | Chapelhouse Road | Chapelhouse Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 17605 | op-snap---monthly-publication-march-2025.pdf | 1362 | 2025-03 | Pedestrian | Toyota | Avensis | Blue | Stop a vehicle on pedestrian crossing | None | Garrets Green Lane | Garrets Green Lane | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4657981 | -1.7964101 | |
| 18380 | op-snap---monthly-publication-march-2025.pdf | 2137 | 2025-03 | Pedestrian | Tesla | Model Y | White | Stop a vehicle on pedestrian crossing | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | Yes - Via Email | 52.5959906 | -1.8345802 | |
| 18444 | op-snap---monthly-publication-march-2025.pdf | 2201 | 2025-03 | Pedestrian | Fiat | 500 | Black | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 18609 | op-snap---monthly-publication-march-2025.pdf | 2366 | 2025-03 | Pedestrian | Nissan | Qashqai | Black | Stop a vehicle on pedestrian crossing | None | Dudley Road, Cape Hill | Dudley Road, Cape Hill | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 5336 | op-snap---monthly-publication-february-2025.pdf | 153 | 2025-02 | Pedestrian | Vauxhall | Corsa | Black | Stop a vehicle on pedestrian crossing | None | Poplar Rd Kings Heath | Poplar Road Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.436035 | -1.891685 | |
| 6255 | op-snap---monthly-publication-february-2025.pdf | 1072 | 2025-02 | Pedestrian | Volkswagen | T Roc | Black | Stop a vehicle on pedestrian crossing | None | Dudley Road Birmingham A457 | Dudley Road Birmingham A457 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4864458 | -1.9414973 | |
| 6257 | op-snap---monthly-publication-february-2025.pdf | 1074 | 2025-02 | Pedestrian | Toyota | Corolla | White | Stop a vehicle on pedestrian crossing | None | Dudley Road Birmingham A457 | Dudley Road Birmingham A457 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4864458 | -1.9414973 | |
| 6258 | op-snap---monthly-publication-february-2025.pdf | 1075 | 2025-02 | Pedestrian | Nissan | Ariya | Green | Stop a vehicle on pedestrian crossing | None | Dudley Road Birmingham A457 | Dudley Road Birmingham A457 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4864458 | -1.9414973 | |
| 6259 | op-snap---monthly-publication-february-2025.pdf | 1076 | 2025-02 | Pedestrian | Lexus | GS 300 | Blue | Stop a vehicle on pedestrian crossing | No Insurance | Dudley Road Birmingham A457 | Dudley Road Birmingham A457 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4864458 | -1.9414973 | |
| 6670 | op-snap---monthly-publication-february-2025.pdf | 1487 | 2025-02 | Pedestrian | Mazda | 3 | Silver | Stop a vehicle on pedestrian crossing | None | Jockey Road | Jockey Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5512291 | -1.8357776 | |
| 6984 | op-snap---monthly-publication-february-2025.pdf | 1801 | 2025-02 | Pedestrian | Ford | Focus | Black | Stop a vehicle on pedestrian crossing | None | Daylesford Road | Daylesford Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 7041 | op-snap---monthly-publication-february-2025.pdf | 1858 | 2025-02 | Pedestrian | Ford | Fiesta | Red | Stop a vehicle on pedestrian crossing | None | Crankhall Lane | Crankhall Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 7044 | op-snap---monthly-publication-february-2025.pdf | 1861 | 2025-02 | Pedestrian | Citroen | Dispatch | Red | Stop a vehicle on pedestrian crossing | None | Crankhall Lane | Crankhall Lane | Walsall | Walsall | Fixed Penalty | N/A | Yes - Via Email | |||
| 8970 | op-snap---monthly-publication-january-2025.pdf | 78 | 2025-01 | Pedestrian | BMW | 320D | Grey | Stop a vehicle on pedestrian crossing | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 8972 | op-snap---monthly-publication-january-2025.pdf | 80 | 2025-01 | Pedestrian | Mercedes-Benz | CLA180 | Grey | Stop a vehicle on pedestrian crossing | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 9006 | op-snap---monthly-publication-january-2025.pdf | 114 | 2025-01 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4103191 | -1.8670224 |
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);