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'}
139 rows where offence = "Stop a vehicle within pelican pedestrian crossing limits" and reporter_transport_mode = "Pedal Bike" 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 24
month 12
disposal 5
- Education 58
- Fixed Penalty 49
- NFA 22
- Warning Letter 8
- Court 2
council_area 5
- Coventry 85
- Birmingham 46
- Sandwell 4
- Sutton Coldfield 2
- Wolverhampton 2
reporter_transport_mode 1
- Pedal Bike · 139 ✖
offence 1
- Stop a vehicle within pelican pedestrian crossing limits · 139 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7578 | op-snap---monthly-publication-february-2026.pdf | 325 | 2026-02 | Pedal Bike | Nissan | Note | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 | ||
| 7654 | op-snap---monthly-publication-february-2026.pdf | 401 | 2026-02 | Pedal Bike | Peugeot | 308 S | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 7655 | op-snap---monthly-publication-february-2026.pdf | 402 | 2026-02 | Pedal Bike | Vauxhall | Astra | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 7950 | op-snap---monthly-publication-february-2026.pdf | 697 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Education | N/A | 52.436035 | -1.891685 | ||
| 8147 | op-snap---monthly-publication-february-2026.pdf | 894 | 2026-02 | Pedal Bike | Ford | Fiesta | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 8148 | op-snap---monthly-publication-february-2026.pdf | 895 | 2026-02 | Pedal Bike | Peugeot | 207 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 8728 | op-snap---monthly-publication-february-2026.pdf | 1475 | 2026-02 | Pedal Bike | Mercedes-Benz | spinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8890 | op-snap---monthly-publication-february-2026.pdf | 1637 | 2026-02 | Pedal Bike | Jaguar | xj | Black | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4221152 | -1.4959475 | ||
| 8891 | op-snap---monthly-publication-february-2026.pdf | 1638 | 2026-02 | Pedal Bike | Peugeot | 107 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 10544 | op-snap---monthly-publication-january-2026.pdf | 5 | 2026-01 | Pedal Bike | Toyota | Aygo | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 10914 | op-snap---monthly-publication-january-2026.pdf | 375 | 2026-01 | Pedal Bike | Audi | A7 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon St Cov | Earlsdon Street Cov | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 10916 | op-snap---monthly-publication-january-2026.pdf | 377 | 2026-01 | Pedal Bike | Hyundai | Kona | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 11136 | op-snap---monthly-publication-january-2026.pdf | 597 | 2026-01 | Pedal Bike | BMW | 335D | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 11309 | op-snap---monthly-publication-january-2026.pdf | 770 | 2026-01 | Pedal Bike | Mercedes-Benz | 180 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Gooch Street | Gooch Street | Birmingham | Birmingham | Education | N/A | 52.4686609 | -1.8945007 | ||
| 11472 | op-snap---monthly-publication-january-2026.pdf | 933 | 2026-01 | Pedal Bike | Ford | Fiesta | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | 52.3988977 | -1.5323674 | ||
| 11511 | op-snap---monthly-publication-january-2026.pdf | 972 | 2026-01 | Pedal Bike | Citroen | C3.. | Silver | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Earlsdon Avenue South | Earlsdon Avenue South | Coventry | Coventry | Education | N/A | 52.3960991 | -1.5255671 | ||
| 11570 | op-snap---monthly-publication-january-2026.pdf | 1031 | 2026-01 | Pedal Bike | Mercedes-Benz | C220 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Daventry Road | Daventry Road | Coventry | Coventry | Education | N/A | 52.3930931 | -1.4976428 | ||
| 11571 | op-snap---monthly-publication-january-2026.pdf | 1032 | 2026-01 | Pedal Bike | Mini | Cooper | Orange | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 11640 | op-snap---monthly-publication-january-2026.pdf | 1101 | 2026-01 | Pedal Bike | Ford | Transit | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 5146 | op-snap---monthly-publication-december-2025.pdf | 1274 | 2025-12 | Pedal Bike | Vauxhall | Vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 5147 | op-snap---monthly-publication-december-2025.pdf | 1275 | 2025-12 | Pedal Bike | Vauxhall | Mokka | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 20471 | op-snap---monthly-publication-november-2025.pdf | 13 | 2025-11 | Pedal Bike | Seat | Leon | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4071231 | -1.4985178 | ||
| 21038 | op-snap---monthly-publication-november-2025.pdf | 580 | 2025-11 | Pedal Bike | Nissan | Juke | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5959906 | -1.8345802 | ||
| 2609 | op-snap---monthly-publication-august-2025.pdf | 584 | 2025-08 | Pedal Bike | Volkswagen | Arteon | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 2612 | op-snap---monthly-publication-august-2025.pdf | 587 | 2025-08 | Pedal Bike | Vauxhall | Zafira | White | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 3146 | op-snap---monthly-publication-august-2025.pdf | 1121 | 2025-08 | Pedal Bike | Mercedes-Benz | AMG GT | White | Stop a vehicle within pelican pedestrian crossing limits | None | Gooch Street | Gooch Street | Birmingham | Birmingham | Education | N/A | 52.4686609 | -1.8945007 | ||
| 13153 | op-snap---monthly-publication-july-2025.pdf | 1205 | 2025-07 | Pedal Bike | Volkswagen | Golf S | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Edward Road , Balsall Heath | Edward Road , Balsall Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4593504 | -1.9013281 | ||
| 13169 | op-snap---monthly-publication-july-2025.pdf | 1221 | 2025-07 | Pedal Bike | Volkswagen | Golf | White | Stop a vehicle within pelican pedestrian crossing limits | None | De Montford Way | De Montford Way | Coventry | Coventry | Education | N/A | ||||
| 14606 | op-snap---monthly-publication-june-2025.pdf | 535 | 2025-06 | Pedal Bike | Toyota | Prius | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 15335 | op-snap---monthly-publication-june-2025.pdf | 1264 | 2025-06 | Pedal Bike | Mercedes-Benz | sprinter | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 15336 | op-snap---monthly-publication-june-2025.pdf | 1265 | 2025-06 | Pedal Bike | Renault | clio | White | Stop a vehicle within pelican pedestrian crossing limits | None | Rough Road | Rough Road | Birmingham | Birmingham | Education | N/A | 52.5539433 | -1.8804348 | ||
| 15392 | op-snap---monthly-publication-june-2025.pdf | 1321 | 2025-06 | Pedal Bike | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Harding Street | Harding Street | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 15786 | op-snap---monthly-publication-june-2025.pdf | 1715 | 2025-06 | Pedal Bike | Volkswagen | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | |||
| 15787 | op-snap---monthly-publication-june-2025.pdf | 1716 | 2025-06 | Pedal Bike | Hyundai | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | |||
| 15788 | op-snap---monthly-publication-june-2025.pdf | 1717 | 2025-06 | Pedal Bike | Peugeot | White | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | |||
| 15789 | op-snap---monthly-publication-june-2025.pdf | 1718 | 2025-06 | Pedal Bike | Vauxhall | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No VRM | 52.4308271 | -1.920078 | |||
| 15790 | op-snap---monthly-publication-june-2025.pdf | 1719 | 2025-06 | Pedal Bike | Mercedes-Benz | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No VRM | 52.4308271 | -1.920078 | |||
| 15977 | op-snap---monthly-publication-june-2025.pdf | 1906 | 2025-06 | Pedal Bike | Peugeot | Yaris | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Education | N/A | 52.5398019 | -1.8455792 | ||
| 18801 | op-snap---monthly-publication-may-2025.pdf | 163 | 2025-05 | Pedal Bike | Audi | A5 | Beige | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 18815 | op-snap---monthly-publication-may-2025.pdf | 177 | 2025-05 | Pedal Bike | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon St | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 18873 | op-snap---monthly-publication-may-2025.pdf | 235 | 2025-05 | Pedal Bike | Ford | fiesta | white | Stop a vehicle within pelican pedestrian crossing limits | none | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 18874 | op-snap---monthly-publication-may-2025.pdf | 236 | 2025-05 | Pedal Bike | BMW | x5 | black | Stop a vehicle within pelican pedestrian crossing limits | none | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 18894 | op-snap---monthly-publication-may-2025.pdf | 256 | 2025-05 | Pedal Bike | BMW | 320 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | High Street | High Street | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.5635963 | -2.0827567 | ||
| 18982 | op-snap---monthly-publication-may-2025.pdf | 344 | 2025-05 | Pedal Bike | Hyundai | Santa Fe | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 19022 | op-snap---monthly-publication-may-2025.pdf | 384 | 2025-05 | Pedal Bike | Mercedes-Benz | B180 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 19023 | op-snap---monthly-publication-may-2025.pdf | 385 | 2025-05 | Pedal Bike | BMW | x5 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 19060 | op-snap---monthly-publication-may-2025.pdf | 422 | 2025-05 | Pedal Bike | Mercedes-Benz | CLA 220 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 19072 | op-snap---monthly-publication-may-2025.pdf | 434 | 2025-05 | Pedal Bike | Fiat | Taxi | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 19075 | op-snap---monthly-publication-may-2025.pdf | 437 | 2025-05 | Pedal Bike | Audi | Q5 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 19076 | op-snap---monthly-publication-may-2025.pdf | 438 | 2025-05 | Pedal Bike | Nissan | Micra | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Court | N/A | 52.4274335 | -1.5002381 | ||
| 19153 | op-snap---monthly-publication-may-2025.pdf | 515 | 2025-05 | Pedal Bike | Toyota | Prius | White | Stop a vehicle within pelican pedestrian crossing limits | None | Trinity Street | Trinity Street | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4086572 | -1.5097176 | ||
| 19254 | op-snap---monthly-publication-may-2025.pdf | 616 | 2025-05 | Pedal Bike | Peugeot | 3008 | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 19449 | op-snap---monthly-publication-may-2025.pdf | 811 | 2025-05 | Pedal Bike | Ford | Puma | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Gooch St | Gooch Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4686609 | -1.8945007 | ||
| 19864 | op-snap---monthly-publication-may-2025.pdf | 1226 | 2025-05 | Pedal Bike | Volkswagen | Polo | Black | Stop a vehicle within pelican pedestrian crossing limits | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 19865 | op-snap---monthly-publication-may-2025.pdf | 1227 | 2025-05 | Pedal Bike | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 19963 | op-snap---monthly-publication-may-2025.pdf | 1325 | 2025-05 | Pedal Bike | Peugeot | Boxer | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney STanton Road , Coventry | Stoney STanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | ||
| 73 | op-snap---monthly-publication-april-2025.pdf | 72 | 2025-04 | Pedal Bike | Skoda | Octavia | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 75 | op-snap---monthly-publication-april-2025.pdf | 74 | 2025-04 | Pedal Bike | Ford | FIESTA | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | STONEY STANTON ROAD | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 81 | op-snap---monthly-publication-april-2025.pdf | 80 | 2025-04 | Pedal Bike | Peugeot | EXPERT | Black | Stop a vehicle within pelican pedestrian crossing limits | None | STONEY STANTON ROAD | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 242 | op-snap---monthly-publication-april-2025.pdf | 241 | 2025-04 | Pedal Bike | Nissan | JUKE | Red | Stop a vehicle within pelican pedestrian crossing limits | None | OLD WALSALL ROAD | Old Walsall Road | Birmingham | Birmingham | Education | N/A | 52.5294399 | -1.9282714 | ||
| 296 | op-snap---monthly-publication-april-2025.pdf | 295 | 2025-04 | Pedal Bike | Kia | Sportage | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5489715 | -1.9927402 | ||
| 297 | op-snap---monthly-publication-april-2025.pdf | 296 | 2025-04 | Pedal Bike | Citroen | C4 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5489715 | -1.9927402 | ||
| 441 | op-snap---monthly-publication-april-2025.pdf | 440 | 2025-04 | Pedal Bike | Nissan | NOTE | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | FAR GOSFORD STREET | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4071231 | -1.4985178 | ||
| 458 | op-snap---monthly-publication-april-2025.pdf | 457 | 2025-04 | Pedal Bike | Ford | Fiesta | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Springfield Road Birmingham | Springfield Road Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4496153 | -1.8646204 | ||
| 556 | op-snap---monthly-publication-april-2025.pdf | 555 | 2025-04 | Pedal Bike | Mercedes-Benz | A180 | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Delves Road | Delves Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 572 | op-snap---monthly-publication-april-2025.pdf | 571 | 2025-04 | Pedal Bike | BMW | 320D | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 836 | op-snap---monthly-publication-april-2025.pdf | 835 | 2025-04 | Pedal Bike | Fiat | 500 | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road , Coventry | Stoney Stanton Road , Coventry | Coventry | Coventry | Education | N/A | 52.4295082 | -1.4871963 | ||
| 1289 | op-snap---monthly-publication-april-2025.pdf | 1288 | 2025-04 | Pedal Bike | Toyota | PRIUS | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4071231 | -1.4985178 | ||
| 1482 | op-snap---monthly-publication-april-2025.pdf | 1481 | 2025-04 | Pedal Bike | Skoda | Octavia | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Fulford Road , Birmingham | Fulford Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1485 | op-snap---monthly-publication-april-2025.pdf | 1484 | 2025-04 | Pedal Bike | Vauxhall | Corsa | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Fulford Hall Road | Fulford Hall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1516 | op-snap---monthly-publication-april-2025.pdf | 1515 | 2025-04 | Pedal Bike | BMW | 2 Series | White | Stop a vehicle within pelican pedestrian crossing limits | None | Alcester Road , Birmingham | Alcester Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.452635 | -1.8874738 | ||
| 1517 | op-snap---monthly-publication-april-2025.pdf | 1516 | 2025-04 | Pedal Bike | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | St Marys Row , Birmingham | Street Marys Row , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 1518 | op-snap---monthly-publication-april-2025.pdf | 1517 | 2025-04 | Pedal Bike | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Gooch Street , Birmingham | Gooch Street , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4671612 | -1.8933216 | ||
| 1527 | op-snap---monthly-publication-april-2025.pdf | 1526 | 2025-04 | Pedal Bike | Ford | Focus | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Crankhall Lane , Wednesbury | Crankhall Lane , Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5562019 | -2.0028056 | ||
| 1697 | op-snap---monthly-publication-april-2025.pdf | 1696 | 2025-04 | Pedal Bike | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Alcester Road , Birmingham | Alcester Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.452635 | -1.8874738 | ||
| 1699 | op-snap---monthly-publication-april-2025.pdf | 1698 | 2025-04 | Pedal Bike | Volvo | Truck | White | Stop a vehicle within pelican pedestrian crossing limits | None | Alcester Road , Moseley | Alcester Road , Moseley | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4510452 | -1.8886129 | ||
| 1850 | op-snap---monthly-publication-april-2025.pdf | 1849 | 2025-04 | Pedal Bike | Toyota | NP | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road , Coventry | Stoney Stanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | ||
| 1860 | op-snap---monthly-publication-april-2025.pdf | 1859 | 2025-04 | Pedal Bike | Mercedes-Benz | Vito | White | Stop a vehicle within pelican pedestrian crossing limits | None | High Street , Sutton | High Street , Sutton | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.5669628 | -1.8233167 | ||
| 2022 | op-snap---monthly-publication-april-2025.pdf | 2021 | 2025-04 | Pedal Bike | Mercedes-Benz | NP | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Soney Stanton Road , Coventry | Soney Stanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 16339 | op-snap---monthly-publication-march-2025.pdf | 96 | 2025-03 | Pedal Bike | Mercedes-Benz | BENZ A CLASS | Black | Stop a vehicle within pelican pedestrian crossing limits | None | LADYPOOL ROAD | Ladypool Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4520441 | -1.8787544 | |
| 16542 | op-snap---monthly-publication-march-2025.pdf | 299 | 2025-03 | Pedal Bike | Citroen | C3 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Prior Deram Walk | Prior Deram Walk | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3953705 | -1.5551746 | |
| 16599 | op-snap---monthly-publication-march-2025.pdf | 356 | 2025-03 | Pedal Bike | Vauxhall | Astra | Black | Stop a vehicle within pelican pedestrian crossing limits | Use vehicle on a road without valid test certificate | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17257 | op-snap---monthly-publication-march-2025.pdf | 1014 | 2025-03 | Pedal Bike | Volkswagen | T-Cross | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4308271 | -1.920078 | |
| 17314 | op-snap---monthly-publication-march-2025.pdf | 1071 | 2025-03 | Pedal Bike | Citroen | Picasso | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 17315 | op-snap---monthly-publication-march-2025.pdf | 1072 | 2025-03 | Pedal Bike | Nissan | Note | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 17317 | op-snap---monthly-publication-march-2025.pdf | 1074 | 2025-03 | Pedal Bike | Volkswagen | Touareg | Black | Stop a vehicle within pelican pedestrian crossing limits | None | DAVENTRY ROAD | Daventry Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3930931 | -1.4976428 | |
| 17354 | op-snap---monthly-publication-march-2025.pdf | 1111 | 2025-03 | Pedal Bike | Toyota | Prius | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Rd | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17416 | op-snap---monthly-publication-march-2025.pdf | 1173 | 2025-03 | Pedal Bike | Nissan | Juke | Yellow | Stop a vehicle within pelican pedestrian crossing limits | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 17538 | op-snap---monthly-publication-march-2025.pdf | 1295 | 2025-03 | Pedal Bike | Peugeot | Partner | White | Stop a vehicle within pelican pedestrian crossing limits | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Fixed Penalty | N/A | Yes - Via Email | 52.5489715 | -1.9927402 | |
| 17601 | op-snap---monthly-publication-march-2025.pdf | 1358 | 2025-03 | Pedal Bike | Toyota | Estima | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 17617 | op-snap---monthly-publication-march-2025.pdf | 1374 | 2025-03 | Pedal Bike | Seat | Leon | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17819 | op-snap---monthly-publication-march-2025.pdf | 1576 | 2025-03 | Pedal Bike | Jaguar | XF | White | Stop a vehicle within pelican pedestrian crossing limits | None | Prior Deram Walk | Prior Deram Walk | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3953705 | -1.5551746 | |
| 17877 | op-snap---monthly-publication-march-2025.pdf | 1634 | 2025-03 | Pedal Bike | Mercedes-Benz | C220 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road at Cambridge Street | Stoney Stanton Road at Cambridge Street | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4295082 | -1.4871963 | |
| 17921 | op-snap---monthly-publication-march-2025.pdf | 1678 | 2025-03 | Pedal Bike | Volvo | V60 | Black | Stop a vehicle within pelican pedestrian crossing limits | No vehicle excise licence | STONEY STANTON ROAD | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17924 | op-snap---monthly-publication-march-2025.pdf | 1681 | 2025-03 | Pedal Bike | Toyota | Corolla | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17925 | op-snap---monthly-publication-march-2025.pdf | 1682 | 2025-03 | Pedal Bike | Toyota | Prius | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 18196 | op-snap---monthly-publication-march-2025.pdf | 1953 | 2025-03 | Pedal Bike | Volkswagen | T-Roc | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 18197 | op-snap---monthly-publication-march-2025.pdf | 1954 | 2025-03 | Pedal Bike | Toyota | Prius | White | Stop a vehicle within pelican pedestrian crossing limits | None | Blackberry Lane | Blackberry Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4254016 | -1.4665041 | |
| 18395 | op-snap---monthly-publication-march-2025.pdf | 2152 | 2025-03 | Pedal Bike | Ford | B-Max | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Prior Deram Walk | Prior Deram Walk | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3953705 | -1.5551746 | |
| 18431 | op-snap---monthly-publication-march-2025.pdf | 2188 | 2025-03 | Pedal Bike | Mg | EXCITE | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | KINGSTANDING ROAD | Kingstanding Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5521118 | -1.8845138 |
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);