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'}
287 rows where disposal = "NFA", offence = "Misc - Non Traffic Offences" 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 >30
month 14
council_area 13
- Birmingham 143
- Out of Force Area 37
- Coventry 36
- Dudley 22
- Wolverhampton 11
- Sandwell 10
- Sutton Coldfield 9
- Walsall 8
- Solihull 7
- Halesowen 1
- Kbirmingham 1
- Osru Cttloons Ecoldfield 1
- Yw Soclhvoeorhl Awm`Tpotonn 1
reporter_transport_mode 1
- Pedestrian · 287 ✖
offence 1
- Misc - Non Traffic Offences · 287 ✖
disposal 1
- NFA · 287 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7324 | op-snap---monthly-publication-february-2026.pdf | 71 | 2026-02 | Pedestrian | Ford | Puma | Black | Misc - Non Traffic Offences | None | Halord Lane | Halord Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7516 | op-snap---monthly-publication-february-2026.pdf | 263 | 2026-02 | Pedestrian | Scania | Lorry | Yellow | Misc - Non Traffic Offences | None | Avenue Road | Avenue Road | Birmingham | Birmingham | NFA | No Offence | 52.4941712 | -1.8795158 | ||
| 7565 | op-snap---monthly-publication-february-2026.pdf | 312 | 2026-02 | Pedestrian | Volkswagen | Polo | Silver | Misc - Non Traffic Offences | None | Hamlet Road | Hamlet Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4315327 | -1.8421334 | ||
| 7686 | op-snap---monthly-publication-february-2026.pdf | 433 | 2026-02 | Pedestrian | Toyota | CHR | White | Misc - Non Traffic Offences | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | NFA | No Offence | 52.4221526 | -1.8425617 | ||
| 7999 | op-snap---monthly-publication-february-2026.pdf | 746 | 2026-02 | Pedestrian | Vauxhall | Mokka | Blue | Misc - Non Traffic Offences | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 8409 | op-snap---monthly-publication-february-2026.pdf | 1156 | 2026-02 | Pedestrian | Toyota | Rav 4 | Green | Misc - Non Traffic Offences | No Insurance | Woodstock Road | Woodstock Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4486205 | -1.8740822 | ||
| 8610 | op-snap---monthly-publication-february-2026.pdf | 1357 | 2026-02 | Pedestrian | Mg | hs | Black | Misc - Non Traffic Offences | None | wolverhampton | Wolverhampton | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5879884 | -2.120242 | ||
| 8710 | op-snap---monthly-publication-february-2026.pdf | 1457 | 2026-02 | Pedestrian | Land Rover | freelander | Silver | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8713 | op-snap---monthly-publication-february-2026.pdf | 1460 | 2026-02 | Pedestrian | BMW | 320d | White | Misc - Non Traffic Offences | None | homer street | Homer Street | Solihull | Solihull | NFA | Misc Inc Crimes | ||||
| 8715 | op-snap---monthly-publication-february-2026.pdf | 1462 | 2026-02 | Pedestrian | Lamborghini | urus | Black | Misc - Non Traffic Offences | None | rockingham gardens | Rockingham Gardens | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5690681 | -1.8271174 | ||
| 8851 | op-snap---monthly-publication-february-2026.pdf | 1598 | 2026-02 | Pedestrian | Vauxhall | corsa | Grey | Misc - Non Traffic Offences | None | birmingham road | Birmingham Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5505398 | -1.8252993 | ||
| 8862 | op-snap---monthly-publication-february-2026.pdf | 1609 | 2026-02 | Pedestrian | Volkswagen | passat | Silver | Misc - Non Traffic Offences | None | holly lane | Holly Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5236889 | -1.8253311 | ||
| 10586 | op-snap---monthly-publication-january-2026.pdf | 47 | 2026-01 | Pedestrian | Audi | r8 | Black | Misc - Non Traffic Offences | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.473986 | -1.9147087 | ||
| 10591 | op-snap---monthly-publication-january-2026.pdf | 52 | 2026-01 | Pedestrian | Misc - Non Traffic Offences | None | aldre drive | Aldre Drive | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 10592 | op-snap---monthly-publication-january-2026.pdf | 53 | 2026-01 | Pedestrian | Toyota | rav4 | Green | Misc - Non Traffic Offences | None | woodstock road | Woodstock Road | Birmingham | Birmingham | NFA | No Offence | 52.4486205 | -1.8740822 | ||
| 10616 | op-snap---monthly-publication-january-2026.pdf | 77 | 2026-01 | Pedestrian | Volkswagen | polo | Blue | Misc - Non Traffic Offences | None | homelea road | Homelea Road | Birmingham | Birmingham | NFA | No Offence | 52.4711252 | -1.8149195 | ||
| 10620 | op-snap---monthly-publication-january-2026.pdf | 81 | 2026-01 | Pedestrian | Other | smart car | Black | Misc - Non Traffic Offences | None | woodstock road | Woodstock Road | Birmingham | Birmingham | NFA | No Offence | 52.4486205 | -1.8740822 | ||
| 10622 | op-snap---monthly-publication-january-2026.pdf | 83 | 2026-01 | Pedestrian | Seat | leon | Grey | Misc - Non Traffic Offences | None | woodstock road | Woodstock Road | Birmingham | Birmingham | NFA | No Offence | 52.4486205 | -1.8740822 | ||
| 10769 | op-snap---monthly-publication-january-2026.pdf | 230 | 2026-01 | Pedestrian | Grey | Misc - Non Traffic Offences | None | Camp Lane, Worcester | Camp Lane, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 10981 | op-snap---monthly-publication-january-2026.pdf | 442 | 2026-01 | Pedestrian | Vauxhall | Viva | Red | Misc - Non Traffic Offences | None | Fontley Close | Fontley Close | Birmingham | Birmingham | NFA | No Offence | 52.4760797 | -1.7952034 | ||
| 11254 | op-snap---monthly-publication-january-2026.pdf | 715 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 11257 | op-snap---monthly-publication-january-2026.pdf | 718 | 2026-01 | Pedestrian | Ford | Focus | Blue | Misc - Non Traffic Offences | None | Freer Road | Freer Road | Birmingham | Birmingham | NFA | No Offence | 52.5074462 | -1.8979307 | ||
| 11263 | op-snap---monthly-publication-january-2026.pdf | 724 | 2026-01 | Pedestrian | BMW | 1 series | Black | Misc - Non Traffic Offences | None | Freer Road | Freer Road | Birmingham | Birmingham | NFA | No Offence | 52.5074462 | -1.8979307 | ||
| 11296 | op-snap---monthly-publication-january-2026.pdf | 757 | 2026-01 | Pedestrian | BMW | 116d | White | Misc - Non Traffic Offences | None | Maitland Road | Maitland Road | Birmingham | Birmingham | NFA | No Offence | 52.4868494 | -1.8448776 | ||
| 11298 | op-snap---monthly-publication-january-2026.pdf | 759 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 11449 | op-snap---monthly-publication-january-2026.pdf | 910 | 2026-01 | Pedestrian | Peugeot | 208 | Pink | Misc - Non Traffic Offences | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4053419 | -1.8944602 | ||
| 11930 | op-snap---monthly-publication-january-2026.pdf | 1391 | 2026-01 | Pedestrian | Misc - Non Traffic Offences | None | cambridge crescent | Cambridge Crescent | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4652475 | -1.9056734 | |||||
| 11947 | op-snap---monthly-publication-january-2026.pdf | 1408 | 2026-01 | Pedestrian | Misc - Non Traffic Offences | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | No VRM | 52.4860376 | -1.9095854 | |||||
| 3901 | op-snap---monthly-publication-december-2025.pdf | 29 | 2025-12 | Pedestrian | Renault | Scenic | Blue | Misc - Non Traffic Offences | None | Barton Drive | Barton Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 3946 | op-snap---monthly-publication-december-2025.pdf | 74 | 2025-12 | Pedestrian | Misc - Non Traffic Offences | None | Himley Road | Himley Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5130072 | -2.09584 | |||||
| 3970 | op-snap---monthly-publication-december-2025.pdf | 98 | 2025-12 | Pedestrian | Nissan | qashqai | White | Misc - Non Traffic Offences | None | chilcote close | Chilcote Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167178 | -1.8457291 | ||
| 3971 | op-snap---monthly-publication-december-2025.pdf | 99 | 2025-12 | Pedestrian | Land Rover | discovery | White | Misc - Non Traffic Offences | None | chilcote close | Chilcote Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167178 | -1.8457291 | ||
| 4256 | op-snap---monthly-publication-december-2025.pdf | 384 | 2025-12 | Pedestrian | Land Rover | discovery | White | Misc - Non Traffic Offences | None | crankhall lane | Crankhall Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 4257 | op-snap---monthly-publication-december-2025.pdf | 385 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Misc - Non Traffic Offences | None | fox hollies road | Fox Hollies Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5517052 | -1.7825505 | ||
| 4259 | op-snap---monthly-publication-december-2025.pdf | 387 | 2025-12 | Pedestrian | Skoda | octavia | Black | Misc - Non Traffic Offences | None | cardigan street | Cardigan Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4849063 | -1.8846609 | ||
| 4260 | op-snap---monthly-publication-december-2025.pdf | 388 | 2025-12 | Pedestrian | Honda | jazz | Silver | Misc - Non Traffic Offences | None | cardigan street | Cardigan Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4849063 | -1.8846609 | ||
| 4298 | op-snap---monthly-publication-december-2025.pdf | 426 | 2025-12 | Pedestrian | Other | HGV | White | Misc - Non Traffic Offences | None | northfield road | Northfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167654 | -1.9411244 | ||
| 4336 | op-snap---monthly-publication-december-2025.pdf | 464 | 2025-12 | Pedestrian | BMW | 3 series | White | Misc - Non Traffic Offences | None | regent road | Regent Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.5106406 | -2.0559963 | ||
| 4337 | op-snap---monthly-publication-december-2025.pdf | 465 | 2025-12 | Pedestrian | Audi | a4 | Black | Misc - Non Traffic Offences | None | regendt road | Regendt Road | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 4438 | op-snap---monthly-publication-december-2025.pdf | 566 | 2025-12 | Pedestrian | Mercedes-Benz | a200 | Black | Misc - Non Traffic Offences | None | hafley road | Hafley Road | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 4439 | op-snap---monthly-publication-december-2025.pdf | 567 | 2025-12 | Pedestrian | BMW | Red | Misc - Non Traffic Offences | None | cambridge road | Cambridge Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4368662 | -1.8846451 | |||
| 4440 | op-snap---monthly-publication-december-2025.pdf | 568 | 2025-12 | Pedestrian | Audi | a4 | White | Misc - Non Traffic Offences | None | chilcote close | Chilcote Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167178 | -1.8457291 | ||
| 4445 | op-snap---monthly-publication-december-2025.pdf | 573 | 2025-12 | Pedestrian | Citroen | ds3 | White | Misc - Non Traffic Offences | None | allens croft road | Allens Croft Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4242527 | -1.910803 | ||
| 4462 | op-snap---monthly-publication-december-2025.pdf | 590 | 2025-12 | Pedestrian | Mg | ZS | Blue | Misc - Non Traffic Offences | None | Teazel Avenue | Teazel Avenue | Birmingham | Birmingham | NFA | No Offence | 52.4247795 | -1.9433534 | ||
| 4491 | op-snap---monthly-publication-december-2025.pdf | 619 | 2025-12 | Pedestrian | Volkswagen | troc | White | Misc - Non Traffic Offences | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | ||
| 4510 | op-snap---monthly-publication-december-2025.pdf | 638 | 2025-12 | Pedestrian | Vauxhall | mokka | Gold | Misc - Non Traffic Offences | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | ||
| 4512 | op-snap---monthly-publication-december-2025.pdf | 640 | 2025-12 | Pedestrian | BMW | 3 series | Black | Misc - Non Traffic Offences | None | whittington oval | Whittington Oval | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4800782 | -1.7942034 | ||
| 4558 | op-snap---monthly-publication-december-2025.pdf | 686 | 2025-12 | Pedestrian | Misc - Non Traffic Offences | None | np | Np | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 4559 | op-snap---monthly-publication-december-2025.pdf | 687 | 2025-12 | Pedestrian | Misc - Non Traffic Offences | None | np | Np | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 4563 | op-snap---monthly-publication-december-2025.pdf | 691 | 2025-12 | Pedestrian | Volkswagen | van | Black | Misc - Non Traffic Offences | None | vicaridge road | Vicaridge Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4564 | op-snap---monthly-publication-december-2025.pdf | 692 | 2025-12 | Pedestrian | Misc - Non Traffic Offences | None | UK | Uk | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.45124 | -1.937937 | |||||
| 4593 | op-snap---monthly-publication-december-2025.pdf | 721 | 2025-12 | Pedestrian | Vauxhall | insignia | White | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 4612 | op-snap---monthly-publication-december-2025.pdf | 740 | 2025-12 | Pedestrian | Toyota | corolla | White | Misc - Non Traffic Offences | None | clarence road | Clarence Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5940902 | -1.843503 | ||
| 4651 | op-snap---monthly-publication-december-2025.pdf | 779 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 4652 | op-snap---monthly-publication-december-2025.pdf | 780 | 2025-12 | Pedestrian | Vauxhall | astra | Blue | Misc - Non Traffic Offences | None | richard atreet | Richard Atreet | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4669 | op-snap---monthly-publication-december-2025.pdf | 797 | 2025-12 | Pedestrian | BMW | 1 Series | Silver | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4670 | op-snap---monthly-publication-december-2025.pdf | 798 | 2025-12 | Pedestrian | BMW | 3 Series | Black | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4671 | op-snap---monthly-publication-december-2025.pdf | 799 | 2025-12 | Pedestrian | Audi | A4 | Grey | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4684 | op-snap---monthly-publication-december-2025.pdf | 812 | 2025-12 | Pedestrian | Mercedes-Benz | A Class | Grey | Misc - Non Traffic Offences | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 4685 | op-snap---monthly-publication-december-2025.pdf | 813 | 2025-12 | Pedestrian | Tesla | Model 3 | Black | Misc - Non Traffic Offences | None | Centurion Drive Worcester | Centurion Drive Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4732 | op-snap---monthly-publication-december-2025.pdf | 860 | 2025-12 | Pedestrian | Daimler | White | Misc - Non Traffic Offences | None | Elmdon Road | Elmdon Road | Birmingham | Birmingham | NFA | No Offence | 52.4418657 | -1.9240253 | |||
| 4733 | op-snap---monthly-publication-december-2025.pdf | 861 | 2025-12 | Pedestrian | Volkswagen | Black | Misc - Non Traffic Offences | None | Elmdon Road | Elmdon Road | Birmingham | Birmingham | NFA | No Offence | 52.4418657 | -1.9240253 | |||
| 4785 | op-snap---monthly-publication-december-2025.pdf | 913 | 2025-12 | Pedestrian | Toyota | Prius | White | Misc - Non Traffic Offences | None | St Mary's Row, Moseley | Street Mary's Row, Moseley | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4945 | op-snap---monthly-publication-december-2025.pdf | 1073 | 2025-12 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | outmore road | Outmore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4767211 | -1.7814678 | ||
| 4953 | op-snap---monthly-publication-december-2025.pdf | 1081 | 2025-12 | Pedestrian | Seat | Leon | Black | Misc - Non Traffic Offences | None | wyrley road | Wyrley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5172973 | -1.8785949 | ||
| 4955 | op-snap---monthly-publication-december-2025.pdf | 1083 | 2025-12 | Pedestrian | Renault | scenic | Grey | Misc - Non Traffic Offences | None | flavell avenue | Flavell Avenue | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 4971 | op-snap---monthly-publication-december-2025.pdf | 1099 | 2025-12 | Pedestrian | Renault | captur | Black | Misc - Non Traffic Offences | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4307 | -1.8494663 | ||
| 5012 | op-snap---monthly-publication-december-2025.pdf | 1140 | 2025-12 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | mace street | Mace Street | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 5021 | op-snap---monthly-publication-december-2025.pdf | 1149 | 2025-12 | Pedestrian | Honda | crv | Blue | Misc - Non Traffic Offences | None | rowood drive | Rowood Drive | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4285752 | -1.7757399 | ||
| 5022 | op-snap---monthly-publication-december-2025.pdf | 1150 | 2025-12 | Pedestrian | BMW | 520D | Black | Misc - Non Traffic Offences | None | robin hall lane | Robin Hall Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4227193 | -1.8439628 | ||
| 5023 | op-snap---monthly-publication-december-2025.pdf | 1151 | 2025-12 | Pedestrian | Vauxhall | grandland | White | Misc - Non Traffic Offences | None | robin hood lane | Robin Hood Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4221526 | -1.8425617 | ||
| 5024 | op-snap---monthly-publication-december-2025.pdf | 1152 | 2025-12 | Pedestrian | Mercedes-Benz | cls350 | White | Misc - Non Traffic Offences | None | sheldon | Sheldon | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4533229 | -1.778016 | ||
| 5026 | op-snap---monthly-publication-december-2025.pdf | 1154 | 2025-12 | Pedestrian | Volkswagen | Up | White | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 5105 | op-snap---monthly-publication-december-2025.pdf | 1233 | 2025-12 | Pedestrian | Fiat | 500 | White | Misc - Non Traffic Offences | None | Dallington Road | Dallington Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 5133 | op-snap---monthly-publication-december-2025.pdf | 1261 | 2025-12 | Pedestrian | BMW | 3 Series | Blue | Misc - Non Traffic Offences | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 5182 | op-snap---monthly-publication-december-2025.pdf | 1310 | 2025-12 | Pedestrian | Ford | focus | Blue | Misc - Non Traffic Offences | None | thistley field | Thistley Field | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4271223 | -1.5298007 | ||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | |||||
| 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 |
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);