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'}
155 rows where disposal = "NFA", month = "2025-11" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 29
offence 12
- Misc - Non Traffic Offences 65
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 50
- Cause vehicle to be left in a dangerous position 15
- Driving without Due Care and Attention 9
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 7
- Stop a vehicle on pedestrian crossing 3
- Contravening a Red Traffic Light 1
- Fail to display front VRM plate 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Using a Mobile Phone Whilst Driving 1
council_area 8
- Birmingham 56
- Coventry 40
- Dudley 30
- Out of Force Area 15
- Sutton Coldfield 6
- Sandwell 4
- Wolverhampton 3
- Solihull 1
reporter_transport_mode 1
- Pedestrian · 155 ✖
month 1
- 2025-11 · 155 ✖
disposal 1
- NFA · 155 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20459 | op-snap---monthly-publication-november-2025.pdf | 1 | 2025-11 | Pedestrian | Vauxhall | insignia | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20460 | op-snap---monthly-publication-november-2025.pdf | 2 | 2025-11 | Pedestrian | Mercedes-Benz | b200 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20461 | op-snap---monthly-publication-november-2025.pdf | 3 | 2025-11 | Pedestrian | Peugeot | 107 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 20536 | op-snap---monthly-publication-november-2025.pdf | 78 | 2025-11 | Pedestrian | Scooter | Black | Driving without Due Care and Attention | None | Sedgley Road West | Sedgley Road West | Dudley | Dudley | NFA | No VRM | 52.5301627 | -2.0799509 | |||
| 20566 | op-snap---monthly-publication-november-2025.pdf | 108 | 2025-11 | Pedestrian | Dacia | sandro | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.430111 | -1.9753703 | ||
| 20699 | op-snap---monthly-publication-november-2025.pdf | 241 | 2025-11 | Pedestrian | London Taxi | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cheveral Avenue | Cheveral Avenue | Coventry | Coventry | NFA | Not in Public Interest | 52.4257402 | -1.5185037 | |||
| 20788 | op-snap---monthly-publication-november-2025.pdf | 330 | 2025-11 | Pedestrian | Ford | Transit | White | Driving without Due Care and Attention | None | School Bank | School Bank | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5149378 | -2.1130096 | ||
| 20805 | op-snap---monthly-publication-november-2025.pdf | 347 | 2025-11 | Pedestrian | Volkswagen | Crafter | Grey | Driving without Due Care and Attention | None | Market Place | Market Place | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5303627 | -2.0353018 | ||
| 20829 | op-snap---monthly-publication-november-2025.pdf | 371 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | Leicester | Leicester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4145125 | -1.5097639 | |||||
| 20889 | op-snap---monthly-publication-november-2025.pdf | 431 | 2025-11 | Pedestrian | Tesla | Model Y | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High street, Tettenhall | High street, Tettenhall | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.5980906 | -2.168057 | ||
| 20908 | op-snap---monthly-publication-november-2025.pdf | 450 | 2025-11 | Pedestrian | Ford | Fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane | Holly Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5236889 | -1.8253311 | ||
| 20911 | op-snap---monthly-publication-november-2025.pdf | 453 | 2025-11 | Pedestrian | Volvo | XC60 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Lane | Grange Lane | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4505457 | -2.1266938 | ||
| 20942 | op-snap---monthly-publication-november-2025.pdf | 484 | 2025-11 | Pedestrian | Kia | Stonic | Red | No Seat Belt | None | Martineau Drive | Martineau Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4621711 | -1.9776235 | ||
| 20943 | op-snap---monthly-publication-november-2025.pdf | 485 | 2025-11 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Malvern | Malvern | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4093693 | -1.7713445 | ||
| 20962 | op-snap---monthly-publication-november-2025.pdf | 504 | 2025-11 | Pedestrian | Citroen | berlingo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | woodland road | Woodland Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4108681 | -1.9611917 | ||
| 20987 | op-snap---monthly-publication-november-2025.pdf | 529 | 2025-11 | Pedestrian | Honda | frv | Grey | Misc - Non Traffic Offences | None | Longbridge | Longbridge | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3940521 | -1.9807506 | ||
| 20989 | op-snap---monthly-publication-november-2025.pdf | 531 | 2025-11 | Pedestrian | Volkswagen | golf | Black | Misc - Non Traffic Offences | None | alderbrook road | Alderbrook Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 20992 | op-snap---monthly-publication-november-2025.pdf | 534 | 2025-11 | Pedestrian | Seat | Ateca | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | pershore road | Pershore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4308271 | -1.920078 | ||
| 20993 | op-snap---monthly-publication-november-2025.pdf | 535 | 2025-11 | Pedestrian | Ford | fiesta | Blue | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20998 | op-snap---monthly-publication-november-2025.pdf | 540 | 2025-11 | Pedestrian | Volkswagen | touran | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307 | -1.8494663 | ||
| 21047 | op-snap---monthly-publication-november-2025.pdf | 589 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | goodyear road | Goodyear Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||||
| 21070 | op-snap---monthly-publication-november-2025.pdf | 612 | 2025-11 | Pedestrian | Skoda | Silver | Misc - Non Traffic Offences | None | lichfield road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | NFA | Misc Inc Crimes | 52.5872149 | -1.8300386 | |||
| 21090 | op-snap---monthly-publication-november-2025.pdf | 632 | 2025-11 | Pedestrian | Vauxhall | Zafira | Silver | Misc - Non Traffic Offences | None | St Elizabeth Rd | Street Elizabeth Road | Coventry | Coventry | NFA | No Offence | ||||
| 21106 | op-snap---monthly-publication-november-2025.pdf | 648 | 2025-11 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Alderbrooke Road | Alderbrooke Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21135 | op-snap---monthly-publication-november-2025.pdf | 677 | 2025-11 | Pedestrian | Audi | RSQ8 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4456462 | -1.827993 | ||
| 21136 | op-snap---monthly-publication-november-2025.pdf | 678 | 2025-11 | Pedestrian | Renault | Clio | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 21137 | op-snap---monthly-publication-november-2025.pdf | 679 | 2025-11 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 21138 | op-snap---monthly-publication-november-2025.pdf | 680 | 2025-11 | Pedestrian | Vauxhall | Astra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4374665 | -1.9119895 | ||
| 21166 | op-snap---monthly-publication-november-2025.pdf | 708 | 2025-11 | Pedestrian | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21167 | op-snap---monthly-publication-november-2025.pdf | 709 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21169 | op-snap---monthly-publication-november-2025.pdf | 711 | 2025-11 | Pedestrian | Citroen | DS3 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21170 | op-snap---monthly-publication-november-2025.pdf | 712 | 2025-11 | Pedestrian | Volkswagen | Passat | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21171 | op-snap---monthly-publication-november-2025.pdf | 713 | 2025-11 | Pedestrian | Mazda | CX5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Balaclava Road | Balaclava Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4337176 | -1.896658 | ||
| 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 | ||
| 21176 | op-snap---monthly-publication-november-2025.pdf | 718 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21178 | op-snap---monthly-publication-november-2025.pdf | 720 | 2025-11 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4708802 | -1.8792135 | |||||
| 21182 | op-snap---monthly-publication-november-2025.pdf | 724 | 2025-11 | Pedestrian | Nissan | Navara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | No location given | No location given | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 21183 | op-snap---monthly-publication-november-2025.pdf | 725 | 2025-11 | Pedestrian | Volkswagen | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | No location given | No location given | Dudley | Dudley | NFA | No Independent Evidence Available | |||||
| 21188 | op-snap---monthly-publication-november-2025.pdf | 730 | 2025-11 | Pedestrian | Ford | Ecosport | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mercia Gardens | Mercia Gardens | Coventry | Coventry | NFA | Not in Public Interest | 52.4284147 | -1.5049016 | ||
| 21189 | op-snap---monthly-publication-november-2025.pdf | 731 | 2025-11 | Pedestrian | BMW | 520d | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mercia Gardens | Mercia Gardens | Coventry | Coventry | NFA | Not in Public Interest | 52.4284147 | -1.5049016 | ||
| 21202 | op-snap---monthly-publication-november-2025.pdf | 744 | 2025-11 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Worcester Close | Worcester Close | Sutton Coldfield | Sutton Coldfield | NFA | Not in Public Interest | 52.5921575 | -1.8139344 | ||
| 21203 | op-snap---monthly-publication-november-2025.pdf | 745 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21204 | op-snap---monthly-publication-november-2025.pdf | 746 | 2025-11 | Pedestrian | Mercedes-Benz | C180 | Black | Fail to display front VRM plate | None | Greswold Road | Greswold Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4232089 | -1.7804289 | ||
| 21205 | op-snap---monthly-publication-november-2025.pdf | 747 | 2025-11 | Pedestrian | Honda | Jazz | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21208 | op-snap---monthly-publication-november-2025.pdf | 750 | 2025-11 | Pedestrian | BMW | 1 Series | Grey | Misc - Non Traffic Offences | None | Ramsden Avenue | Ramsden Avenue | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21210 | op-snap---monthly-publication-november-2025.pdf | 752 | 2025-11 | Pedestrian | Kia | Stonic | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stourport Road | Stourport Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21229 | op-snap---monthly-publication-november-2025.pdf | 771 | 2025-11 | Pedestrian | Ford | Mondeo | White | Misc - Non Traffic Offences | Offence to be added | Gayfield Av | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 21231 | op-snap---monthly-publication-november-2025.pdf | 773 | 2025-11 | Pedestrian | Ford | Kuga | Grey | Misc - Non Traffic Offences | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 21232 | op-snap---monthly-publication-november-2025.pdf | 774 | 2025-11 | Pedestrian | Vauxhall | Agila | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21233 | op-snap---monthly-publication-november-2025.pdf | 775 | 2025-11 | Pedestrian | Volkswagen | CC | Grey | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21234 | op-snap---monthly-publication-november-2025.pdf | 776 | 2025-11 | Pedestrian | Honda | Civic | Black | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21244 | op-snap---monthly-publication-november-2025.pdf | 786 | 2025-11 | Pedestrian | Mercedes-Benz | a200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21245 | op-snap---monthly-publication-november-2025.pdf | 787 | 2025-11 | Pedestrian | Mercedes-Benz | glc 300 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Dudley | Dudley | NFA | No Offence | 52.4530622 | -2.0800139 | ||
| 21246 | op-snap---monthly-publication-november-2025.pdf | 788 | 2025-11 | Pedestrian | Peugeot | partner | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey road | Abbey road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21278 | op-snap---monthly-publication-november-2025.pdf | 820 | 2025-11 | Pedestrian | Honda | civic | Blue | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21279 | op-snap---monthly-publication-november-2025.pdf | 821 | 2025-11 | Pedestrian | Renault | clio | Red | Misc - Non Traffic Offences | None | fenton raod | Fenton Raod | Coventry | Coventry | NFA | Misc Inc Crimes | ||||
| 21280 | op-snap---monthly-publication-november-2025.pdf | 822 | 2025-11 | Pedestrian | Skoda | fabia | Silver | Misc - Non Traffic Offences | None | fenton raod | Fenton Raod | Coventry | Coventry | NFA | Misc Inc Crimes | ||||
| 21281 | op-snap---monthly-publication-november-2025.pdf | 823 | 2025-11 | Pedestrian | Honda | jazz | White | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21282 | op-snap---monthly-publication-november-2025.pdf | 824 | 2025-11 | Pedestrian | Nissan | note | Silver | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21283 | op-snap---monthly-publication-november-2025.pdf | 825 | 2025-11 | Pedestrian | BMW | 320d | Grey | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21287 | op-snap---monthly-publication-november-2025.pdf | 829 | 2025-11 | Pedestrian | Ford | fiesta | Silver | Misc - Non Traffic Offences | None | sir hiltons road | Sir Hiltons Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3932637 | -1.9575554 | ||
| 21289 | op-snap---monthly-publication-november-2025.pdf | 831 | 2025-11 | Pedestrian | Skoda | kodiaq | Silver | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21291 | op-snap---monthly-publication-november-2025.pdf | 833 | 2025-11 | Pedestrian | Volkswagen | golf | Grey | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21292 | op-snap---monthly-publication-november-2025.pdf | 834 | 2025-11 | Pedestrian | BMW | 320D | Grey | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21293 | op-snap---monthly-publication-november-2025.pdf | 835 | 2025-11 | Pedestrian | Skoda | Kodiaq | Gold | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21308 | op-snap---monthly-publication-november-2025.pdf | 850 | 2025-11 | Pedestrian | Seat | Ateca | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21320 | op-snap---monthly-publication-november-2025.pdf | 862 | 2025-11 | Pedestrian | Toyota | Avensis | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | kings heath highstreet | Kings Heath Highstreet | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21322 | op-snap---monthly-publication-november-2025.pdf | 864 | 2025-11 | Pedestrian | Ford | transit | Black | Cause vehicle to be left in a dangerous position | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | NFA | Misc Inc Crimes | 52.3988977 | -1.5323674 | ||
| 21323 | op-snap---monthly-publication-november-2025.pdf | 865 | 2025-11 | Pedestrian | Hyundai | ioniq | Grey | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21324 | op-snap---monthly-publication-november-2025.pdf | 866 | 2025-11 | Pedestrian | Ford | mondeo | Black | Cause vehicle to be left in a dangerous position | None | silverthorne lane | Silverthorne Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 21328 | op-snap---monthly-publication-november-2025.pdf | 870 | 2025-11 | Pedestrian | Ford | fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | silverthorne lane | Silverthorne Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 21329 | op-snap---monthly-publication-november-2025.pdf | 871 | 2025-11 | Pedestrian | Misc - Non Traffic Offences | None | shirley road | Shirley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4198291 | -1.9241732 | |||||
| 21337 | op-snap---monthly-publication-november-2025.pdf | 879 | 2025-11 | Pedestrian | Mercedes-Benz | glb200 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad lane | Broad Lane | Dudley | Dudley | NFA | Misc Inc Crimes | 52.6232232 | -2.0137162 | ||
| 21338 | op-snap---monthly-publication-november-2025.pdf | 880 | 2025-11 | Pedestrian | Cupra | formentor | Black | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21339 | op-snap---monthly-publication-november-2025.pdf | 881 | 2025-11 | Pedestrian | Vauxhall | astra | Black | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21340 | op-snap---monthly-publication-november-2025.pdf | 882 | 2025-11 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | handsworth road | Handsworth Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5137414 | -1.9222827 | ||
| 21352 | op-snap---monthly-publication-november-2025.pdf | 894 | 2025-11 | Pedestrian | Skoda | Octavia | Red | Misc - Non Traffic Offences | None | Bidford On Avon | Bidford On Avon | Out of Force Area | Out of Force Area | NFA | No Offence | ||||
| 21357 | op-snap---monthly-publication-november-2025.pdf | 899 | 2025-11 | Pedestrian | Audi | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | |||
| 21360 | op-snap---monthly-publication-november-2025.pdf | 902 | 2025-11 | Pedestrian | Ford | kuga | Black | Misc - Non Traffic Offences | None | stafford road | Stafford Road | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.6291998 | -2.126312 | ||
| 21361 | op-snap---monthly-publication-november-2025.pdf | 903 | 2025-11 | Pedestrian | Seat | cupra | Blue | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 21362 | op-snap---monthly-publication-november-2025.pdf | 904 | 2025-11 | Pedestrian | Vauxhall | Grey | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | |||
| 21370 | op-snap---monthly-publication-november-2025.pdf | 912 | 2025-11 | Pedestrian | Audi | Silver | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | |||
| 21372 | op-snap---monthly-publication-november-2025.pdf | 914 | 2025-11 | Pedestrian | Volkswagen | golf | Black | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21374 | op-snap---monthly-publication-november-2025.pdf | 916 | 2025-11 | Pedestrian | Skoda | kodiaq | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21378 | op-snap---monthly-publication-november-2025.pdf | 920 | 2025-11 | Pedestrian | Mercedes-Benz | Cause vehicle to be left in a dangerous position | None | wooten road | Wooten Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||||
| 21397 | op-snap---monthly-publication-november-2025.pdf | 939 | 2025-11 | Pedestrian | Honda | accord | Silver | Misc - Non Traffic Offences | No Insurance | Parkdale Close | Parkdale Close | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 21407 | op-snap---monthly-publication-november-2025.pdf | 949 | 2025-11 | Pedestrian | Vauxhall | Grandland | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4721372 | -2.1243522 | ||
| 21408 | op-snap---monthly-publication-november-2025.pdf | 950 | 2025-11 | Pedestrian | Unknown | Red | Driving without Due Care and Attention | None | Sir Henry Parkes Road | Sir Henry Parkes Road | Coventry | Coventry | NFA | No Offence | 52.3900568 | -1.5550766 | |||
| 21424 | op-snap---monthly-publication-november-2025.pdf | 966 | 2025-11 | Pedestrian | Mercedes-Benz | GLB200 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad lane | Broad Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4135483 | -1.9035033 | ||
| 21426 | op-snap---monthly-publication-november-2025.pdf | 968 | 2025-11 | Pedestrian | Scania | truck | Red | Misc - Non Traffic Offences | None | thackhall street | Thackhall Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21427 | op-snap---monthly-publication-november-2025.pdf | 969 | 2025-11 | Pedestrian | Porsche | Macan | Blue | Cause vehicle to be left in a dangerous position | None | barclary road | Barclay Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21440 | op-snap---monthly-publication-november-2025.pdf | 982 | 2025-11 | Pedestrian | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21448 | op-snap---monthly-publication-november-2025.pdf | 990 | 2025-11 | Pedestrian | Kia | ceed | Grey | Cause vehicle to be left in a dangerous position | None | somer park avenue | Somer Park Avenue | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 21465 | op-snap---monthly-publication-november-2025.pdf | 1007 | 2025-11 | Pedestrian | Daf | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | |||||
| 21478 | op-snap---monthly-publication-november-2025.pdf | 1020 | 2025-11 | Pedestrian | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells | Lozells | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5026318 | -1.9095912 | ||
| 21498 | op-snap---monthly-publication-november-2025.pdf | 1040 | 2025-11 | Pedestrian | Citroen | benga | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | braymoor road | Braymoor Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4756937 | -1.762603 | ||
| 21530 | op-snap---monthly-publication-november-2025.pdf | 1072 | 2025-11 | Pedestrian | BMW | 520D | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | clarence road | Clarence Road | Sutton Coldfield | Sutton Coldfield | NFA | Misc Inc Crimes | 52.5940902 | -1.843503 | ||
| 21535 | op-snap---monthly-publication-november-2025.pdf | 1077 | 2025-11 | Pedestrian | Peugeot | partner | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | morland place | Morland Place | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4032699 | -1.9761539 |
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);