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'}
87 rows where month = "2025-05" and offence = "Stop a vehicle on pedestrian crossing" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 24
council_area 8
disposal 5
- Education 46
- NFA 35
- Court 2
- Fixed Penalty 2
- Warning Letter 2
reporter_transport_mode 4
- Car 66
- Pedestrian 13
- Pedal Bike 7
- car 1
offence 1
- Stop a vehicle on pedestrian crossing · 87 ✖
month 1
- 2025-05 · 87 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18668 | op-snap---monthly-publication-may-2025.pdf | 30 | 2025-05 | Car | Isuzu | Truck | White | Stop a vehicle on pedestrian crossing | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5872149 | -1.8300386 | ||
| 18687 | op-snap---monthly-publication-may-2025.pdf | 49 | 2025-05 | Car | Volkswagen | Golf | Silver | Stop a vehicle on pedestrian crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | ||
| 18750 | op-snap---monthly-publication-may-2025.pdf | 112 | 2025-05 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Charford Road Bromsgrove | Charford Road Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18752 | op-snap---monthly-publication-may-2025.pdf | 114 | 2025-05 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18754 | op-snap---monthly-publication-may-2025.pdf | 116 | 2025-05 | Car | Mercedes-Benz | C220 | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18756 | op-snap---monthly-publication-may-2025.pdf | 118 | 2025-05 | Car | Kia | Picanto | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18758 | op-snap---monthly-publication-may-2025.pdf | 120 | 2025-05 | Car | BMW | 116D | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18838 | op-snap---monthly-publication-may-2025.pdf | 200 | 2025-05 | Car | Mercedes-Benz | C200 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18839 | op-snap---monthly-publication-may-2025.pdf | 201 | 2025-05 | Car | Mercedes-Benz | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | |||
| 18842 | op-snap---monthly-publication-may-2025.pdf | 204 | 2025-05 | Car | Audi | A4 | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18843 | op-snap---monthly-publication-may-2025.pdf | 205 | 2025-05 | Car | Mercedes-Benz | CLS220 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18845 | op-snap---monthly-publication-may-2025.pdf | 207 | 2025-05 | Car | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18846 | op-snap---monthly-publication-may-2025.pdf | 208 | 2025-05 | Car | Mercedes-Benz | GLC350 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18847 | op-snap---monthly-publication-may-2025.pdf | 209 | 2025-05 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 18969 | op-snap---monthly-publication-may-2025.pdf | 331 | 2025-05 | Car | Citroen | Berlingo | White | Stop a vehicle on pedestrian crossing | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 18980 | op-snap---monthly-publication-may-2025.pdf | 342 | 2025-05 | Pedal Bike | Toyota | Yaris | Blue | Stop a vehicle on pedestrian crossing | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Education | N/A | 52.5489715 | -1.9927402 | ||
| 19119 | op-snap---monthly-publication-may-2025.pdf | 481 | 2025-05 | Car | Volvo | XC40 | Grey | Stop a vehicle on pedestrian crossing | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | No Offence | 52.4506039 | -1.8463952 | ||
| 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 | ||||
| 19222 | op-snap---monthly-publication-may-2025.pdf | 584 | 2025-05 | Car | Suzuki | Alto | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19223 | op-snap---monthly-publication-may-2025.pdf | 585 | 2025-05 | Car | Fiat | Florino | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19264 | op-snap---monthly-publication-may-2025.pdf | 626 | 2025-05 | Pedal Bike | Vauxhall | cOMBO | White | Stop a vehicle on pedestrian crossing | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Education | N/A | 52.4397168 | -1.9260414 | ||
| 19303 | op-snap---monthly-publication-may-2025.pdf | 665 | 2025-05 | Car | Ford | Transit | Black | Stop a vehicle on pedestrian crossing | None | Quinton Park | Quinton Park | Coventry | Coventry | Education | N/A | 52.3906999 | -1.5036996 | ||
| 19721 | op-snap---monthly-publication-may-2025.pdf | 1083 | 2025-05 | Car | Nissan | Juke | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19722 | op-snap---monthly-publication-may-2025.pdf | 1084 | 2025-05 | Car | Volkswagen | Sharan | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19723 | op-snap---monthly-publication-may-2025.pdf | 1085 | 2025-05 | Car | BMW | 730d | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19724 | op-snap---monthly-publication-may-2025.pdf | 1086 | 2025-05 | Car | Mercedes-Benz | CLA 180 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19725 | op-snap---monthly-publication-may-2025.pdf | 1087 | 2025-05 | Car | Peugeot | 3008 | Red | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19726 | op-snap---monthly-publication-may-2025.pdf | 1088 | 2025-05 | Car | Audi | R8 | red | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19727 | op-snap---monthly-publication-may-2025.pdf | 1089 | 2025-05 | Car | Volkswagen | Polo | White | Stop a vehicle on pedestrian crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | ||
| 19728 | op-snap---monthly-publication-may-2025.pdf | 1090 | 2025-05 | Car | Renault | Megane | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19729 | op-snap---monthly-publication-may-2025.pdf | 1091 | 2025-05 | Car | BMW | 520d | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19730 | op-snap---monthly-publication-may-2025.pdf | 1092 | 2025-05 | Car | Skoda | RAPID | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19731 | op-snap---monthly-publication-may-2025.pdf | 1093 | 2025-05 | Car | Nissan | X-TRAIL | Silver | Stop a vehicle on pedestrian crossing | None | SUMMER ROAD | Summer Road | Birmingham | Birmingham | Education | N/A | 52.5221219 | -1.8440857 | ||
| 19732 | op-snap---monthly-publication-may-2025.pdf | 1094 | 2025-05 | Car | Honda | CIVIC | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19733 | op-snap---monthly-publication-may-2025.pdf | 1095 | 2025-05 | Car | Mercedes-Benz | 220 | Silver | Stop a vehicle on pedestrian crossing | No Insurance | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Court | N/A | 52.4929304 | -1.8229092 | ||
| 19734 | op-snap---monthly-publication-may-2025.pdf | 1096 | 2025-05 | Car | Nissan | MICRA | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19762 | op-snap---monthly-publication-may-2025.pdf | 1124 | 2025-05 | Car | Mercedes-Benz | C250 | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19763 | op-snap---monthly-publication-may-2025.pdf | 1125 | 2025-05 | Car | Volkswagen | Toureg | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 19764 | op-snap---monthly-publication-may-2025.pdf | 1126 | 2025-05 | Car | Land Rover | Discovery | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19765 | op-snap---monthly-publication-may-2025.pdf | 1127 | 2025-05 | Car | Volkswagen | Touran | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | ||
| 19766 | op-snap---monthly-publication-may-2025.pdf | 1128 | 2025-05 | Car | Vauxhall | Insignia | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19767 | op-snap---monthly-publication-may-2025.pdf | 1129 | 2025-05 | Car | Vauxhall | Vivaro | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19768 | op-snap---monthly-publication-may-2025.pdf | 1130 | 2025-05 | Car | Nissan | Qashqai | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19783 | op-snap---monthly-publication-may-2025.pdf | 1145 | 2025-05 | Car | Mercedes-Benz | BENZ | Silver | Stop a vehicle on pedestrian crossing | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 19788 | op-snap---monthly-publication-may-2025.pdf | 1150 | 2025-05 | Car | Hyundai | IONIQ | Blue | Stop a vehicle on pedestrian crossing | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 19794 | op-snap---monthly-publication-may-2025.pdf | 1156 | 2025-05 | Car | Audi | A3.. | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19795 | op-snap---monthly-publication-may-2025.pdf | 1157 | 2025-05 | Car | Volvo | XC40 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 19800 | op-snap---monthly-publication-may-2025.pdf | 1162 | 2025-05 | Car | BMW | X5 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Offence | 52.4929304 | -1.8229092 | ||
| 19817 | op-snap---monthly-publication-may-2025.pdf | 1179 | 2025-05 | Car | Audi | A3 | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 19834 | op-snap---monthly-publication-may-2025.pdf | 1196 | 2025-05 | Car | BYD | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No VRM | 52.4929304 | -1.8229092 | |||
| 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 | ||
| 19876 | op-snap---monthly-publication-may-2025.pdf | 1238 | 2025-05 | Car | Vauxhall | Insignia | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 19877 | op-snap---monthly-publication-may-2025.pdf | 1239 | 2025-05 | Car | Nissan | Juke | Grey | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 19879 | op-snap---monthly-publication-may-2025.pdf | 1241 | 2025-05 | Pedal Bike | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Hill Village Road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5959906 | -1.8345802 | ||
| 19881 | op-snap---monthly-publication-may-2025.pdf | 1243 | 2025-05 | Car | Honda | Jazz | Silver | Stop a vehicle on pedestrian crossing | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 19888 | op-snap---monthly-publication-may-2025.pdf | 1250 | 2025-05 | Car | Land Rover | DISCOVERY | White | Stop a vehicle on pedestrian crossing | No Insurance | ALCESTER ROAD | Alcester Road | Birmingham | Birmingham | Court | N/A | 52.4470686 | -1.8880749 | ||
| 19889 | op-snap---monthly-publication-may-2025.pdf | 1251 | 2025-05 | Car | Vauxhall | CORSA | Blue | Stop a vehicle on pedestrian crossing | None | WITTON ROAD | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 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 | ||||
| 19910 | op-snap---monthly-publication-may-2025.pdf | 1272 | 2025-05 | Car | Audi | NP | Blue | Stop a vehicle on pedestrian crossing | None | Washwood heath road | Washwood heath road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4929304 | -1.8229092 | ||
| 19912 | op-snap---monthly-publication-may-2025.pdf | 1274 | 2025-05 | Car | Ford | NP | Red | Stop a vehicle on pedestrian crossing | None | Washwood heath | Washwood heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 19913 | op-snap---monthly-publication-may-2025.pdf | 1275 | 2025-05 | Car | Lexus | NP | Silver | Stop a vehicle on pedestrian crossing | None | Washwood road | Washwood road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4914938 | -1.8574697 | ||
| 19920 | op-snap---monthly-publication-may-2025.pdf | 1282 | 2025-05 | Car | Mercedes-Benz | A class | Grey | Stop a vehicle on pedestrian crossing | None | Edward road, Balsall Heath | Edward road, Balsall Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4570389 | -1.8891657 | ||
| 19927 | op-snap---monthly-publication-may-2025.pdf | 1289 | 2025-05 | Car | Kia | NP | White | Stop a vehicle on pedestrian crossing | None | High street, tettenhall | High street, tettenhall | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5980906 | -2.168057 | ||
| 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 | ||||
| 19942 | op-snap---monthly-publication-may-2025.pdf | 1304 | 2025-05 | Car | Mercedes-Benz | np | Black | Stop a vehicle on pedestrian crossing | None | old walsall road | Old Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5294399 | -1.9282714 | ||
| 19943 | op-snap---monthly-publication-may-2025.pdf | 1305 | 2025-05 | Car | Toyota | NP | Brown | Stop a vehicle on pedestrian crossing | None | Old walsall road | Old walsall road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5294399 | -1.9282714 | ||
| 19948 | op-snap---monthly-publication-may-2025.pdf | 1310 | 2025-05 | Car | Tesla | NP | White | Stop a vehicle on pedestrian crossing | None | Tettenhall Road | Tettenhall Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.5883523 | -2.1466187 | ||
| 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 | ||
| 19991 | op-snap---monthly-publication-may-2025.pdf | 1353 | 2025-05 | Pedal Bike | BMW | 520D | Grey | Stop a vehicle on pedestrian crossing | None | Stoney stanton | Stoney stanton | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4196813 | -1.4978941 | ||
| 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 | ||
| 20051 | op-snap---monthly-publication-may-2025.pdf | 1413 | 2025-05 | Pedal Bike | Skoda | Skoda | Grey | Stop a vehicle on pedestrian crossing | None | smallbrook queensway | Smallbrook Queensway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4772584 | -1.8965734 | ||
| 20078 | op-snap---monthly-publication-may-2025.pdf | 1440 | 2025-05 | Car | Lexus | NP | White | Stop a vehicle on pedestrian crossing | None | fox hollies rd | Fox Hollies Rd | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4425992 | -1.8338234 | ||
| 20079 | op-snap---monthly-publication-may-2025.pdf | 1441 | 2025-05 | Car | Volkswagen | NP | Grey | Stop a vehicle on pedestrian crossing | None | Fox hollies road | Fox hollies road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5517052 | -1.7825505 | ||
| 20081 | op-snap---monthly-publication-may-2025.pdf | 1443 | 2025-05 | car | Volkswagen | NP | Grey | Stop a vehicle on pedestrian crossing | None | Garretts green lane birmingham | Garretts green lane birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4675802 | -1.7905748 | ||
| 20082 | op-snap---monthly-publication-may-2025.pdf | 1444 | 2025-05 | Car | Volkswagen | NP | White | Stop a vehicle on pedestrian crossing | None | Garretts green lane | Garretts green lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4675802 | -1.7905748 | ||
| 20093 | op-snap---monthly-publication-may-2025.pdf | 1455 | 2025-05 | Pedal Bike | London taxi TX4 | Black | Stop a vehicle on pedestrian crossing | None | Earlsdon avenue | Earlsdon avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4047134 | -1.5351834 | |||
| 20095 | op-snap---monthly-publication-may-2025.pdf | 1457 | 2025-05 | Pedal Bike | Toyota | Auris | White | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3988977 | -1.5323674 | ||
| 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 | ||
| 20120 | op-snap---monthly-publication-may-2025.pdf | 1482 | 2025-05 | Car | Toyota | NP | Beige | Stop a vehicle on pedestrian crossing | None | WASHWOOD HEATH RD | Washwood Heath Rd | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4949047 | -1.8544884 | ||
| 20122 | op-snap---monthly-publication-may-2025.pdf | 1484 | 2025-05 | Car | Ford | NP | Red | Stop a vehicle on pedestrian crossing | None | WASHWOOD HEATH | Washwood Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 | ||
| 20123 | op-snap---monthly-publication-may-2025.pdf | 1485 | 2025-05 | Car | Seat | NP | Black | Stop a vehicle on pedestrian crossing | None | Washwood heath | Washwood heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4957234 | -1.8538937 |
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);