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'}
124 rows where disposal = "NFA", month = "2025-12" 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 24
offence 10
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 48
- Misc - Non Traffic Offences 48
- Cause vehicle to be left in a dangerous position 13
- Driving without Due Care and Attention 6
- Contravening a Red Traffic Light 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Drive / Ride / Lead an animal on a footpath 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Using a Mobile Phone Whilst Driving 1
council_area 7
- Birmingham 71
- Dudley 16
- Sandwell 14
- Out of Force Area 13
- Coventry 8
- Solihull 1
- Wolverhampton 1
reporter_transport_mode 1
- Pedestrian · 124 ✖
month 1
- 2025-12 · 124 ✖
disposal 1
- NFA · 124 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 3905 | op-snap---monthly-publication-december-2025.pdf | 33 | 2025-12 | Pedestrian | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3906 | op-snap---monthly-publication-december-2025.pdf | 34 | 2025-12 | Pedestrian | Ford | Fiesta | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3907 | op-snap---monthly-publication-december-2025.pdf | 35 | 2025-12 | Pedestrian | Mercedes-Benz | Grey | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | |||
| 3914 | op-snap---monthly-publication-december-2025.pdf | 42 | 2025-12 | Pedestrian | Porsche | Cayenne | Black | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 3923 | op-snap---monthly-publication-december-2025.pdf | 51 | 2025-12 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shaftmoor Lane | Shaftmoor Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4418944 | -1.8407335 | ||
| 3937 | op-snap---monthly-publication-december-2025.pdf | 65 | 2025-12 | Pedestrian | Toyota | Aygo | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | B249RT | B249Rt | Birmingham | Birmingham | NFA | No Offence | 52.5124268 | -1.833263 | ||
| 3941 | op-snap---monthly-publication-december-2025.pdf | 69 | 2025-12 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birdwell Croft | Birdwell Croft | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.425424 | -1.8903528 | ||
| 3942 | op-snap---monthly-publication-december-2025.pdf | 70 | 2025-12 | Pedestrian | Nissan | Juke | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birdwell Croft | Birdwell Croft | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.425424 | -1.8903528 | ||
| 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 | |||||
| 3950 | op-snap---monthly-publication-december-2025.pdf | 78 | 2025-12 | Pedestrian | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Withymoor Road | Withymoor Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4871674 | -2.0702998 | ||
| 3966 | op-snap---monthly-publication-december-2025.pdf | 94 | 2025-12 | Pedestrian | BMW | 118D | Blue | Cause vehicle to be left in a dangerous position | None | charter avenue | Charter Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3928409 | -1.5888076 | ||
| 3967 | op-snap---monthly-publication-december-2025.pdf | 95 | 2025-12 | Pedestrian | Peugeot | 308 | Silver | Cause vehicle to be left in a dangerous position | None | charter avenue | Charter Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3928409 | -1.5888076 | ||
| 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 | ||
| 4055 | op-snap---monthly-publication-december-2025.pdf | 183 | 2025-12 | Pedestrian | Ford | Yellow | Using a Mobile Phone Whilst Driving | None | Mallards Close | Mallards Close | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4070 | op-snap---monthly-publication-december-2025.pdf | 198 | 2025-12 | Pedestrian | Volkswagen | Passatt | Blue | Driving without Due Care and Attention | None | Glenville Drivce | Glenville Drivce | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4126 | op-snap---monthly-publication-december-2025.pdf | 254 | 2025-12 | Pedestrian | Land Rover | Discovery | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chilcote Close | Chilcote Close | Birmingham | Birmingham | NFA | No Offence | 52.4167178 | -1.8457291 | ||
| 4128 | op-snap---monthly-publication-december-2025.pdf | 256 | 2025-12 | Pedestrian | Ford | S Max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | No Offence | 52.4700545 | -1.834436 | ||
| 4149 | op-snap---monthly-publication-december-2025.pdf | 277 | 2025-12 | Pedestrian | Honda | Motorbike NSS | Blue | Drive / Ride / Lead an animal on a footpath | None | Whitington | Whitington | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4199 | op-snap---monthly-publication-december-2025.pdf | 327 | 2025-12 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | ||
| 4200 | op-snap---monthly-publication-december-2025.pdf | 328 | 2025-12 | Pedestrian | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 4212 | op-snap---monthly-publication-december-2025.pdf | 340 | 2025-12 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Old ROad | Moseley Old ROad | Birmingham | Birmingham | NFA | Duplicate Submission | ||||
| 4213 | op-snap---monthly-publication-december-2025.pdf | 341 | 2025-12 | Pedestrian | Kia | Picanto | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cranford Street | Cranford Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4214 | op-snap---monthly-publication-december-2025.pdf | 342 | 2025-12 | Pedestrian | BMW | 3 Series | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Caroline Close | Caroline Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5172414 | -1.9775684 | ||
| 4215 | op-snap---monthly-publication-december-2025.pdf | 343 | 2025-12 | Pedestrian | Mitsubishi | Outlander | White | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | ||
| 4216 | op-snap---monthly-publication-december-2025.pdf | 344 | 2025-12 | Pedestrian | Ford | Focus | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | ||
| 4218 | op-snap---monthly-publication-december-2025.pdf | 346 | 2025-12 | Pedestrian | Nissan | Airya | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 4222 | op-snap---monthly-publication-december-2025.pdf | 350 | 2025-12 | Pedestrian | Volkswagen | Passat | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lydford Grove | Lydford Grove | Birmingham | Birmingham | NFA | No Offence | 52.5121491 | -1.8327774 | ||
| 4224 | op-snap---monthly-publication-december-2025.pdf | 352 | 2025-12 | Pedestrian | Toyota | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | |||
| 4228 | op-snap---monthly-publication-december-2025.pdf | 356 | 2025-12 | Pedestrian | Vauxhall | White | 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 | |||
| 4229 | op-snap---monthly-publication-december-2025.pdf | 357 | 2025-12 | Pedestrian | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | |||
| 4230 | op-snap---monthly-publication-december-2025.pdf | 358 | 2025-12 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 4240 | op-snap---monthly-publication-december-2025.pdf | 368 | 2025-12 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | NFA | No Offence | 52.4616763 | -1.9653016 | ||
| 4248 | op-snap---monthly-publication-december-2025.pdf | 376 | 2025-12 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alexandra Road | Alexandra Road | Birmingham | Birmingham | NFA | No VRM | 52.4626826 | -1.8955418 | |||||
| 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 | ||
| 4278 | op-snap---monthly-publication-december-2025.pdf | 406 | 2025-12 | Pedestrian | Land Rover | range rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 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 | ||
| 4299 | op-snap---monthly-publication-december-2025.pdf | 427 | 2025-12 | Pedestrian | Land Rover | range rover | Black | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4321 | op-snap---monthly-publication-december-2025.pdf | 449 | 2025-12 | Pedestrian | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 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 | ||||
| 4371 | op-snap---monthly-publication-december-2025.pdf | 499 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | hunters road | Hunters Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5011362 | -1.9175837 | ||
| 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 | ||
| 4484 | op-snap---monthly-publication-december-2025.pdf | 612 | 2025-12 | Pedestrian | Citroen | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | |||
| 4485 | op-snap---monthly-publication-december-2025.pdf | 613 | 2025-12 | Pedestrian | Citroen | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | |||
| 4486 | op-snap---monthly-publication-december-2025.pdf | 614 | 2025-12 | Pedestrian | Seat | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | |||
| 4487 | op-snap---monthly-publication-december-2025.pdf | 615 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 4488 | op-snap---monthly-publication-december-2025.pdf | 616 | 2025-12 | Pedestrian | Mercedes-Benz | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | |||
| 4489 | op-snap---monthly-publication-december-2025.pdf | 617 | 2025-12 | Pedestrian | Honda | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | |||
| 4490 | op-snap---monthly-publication-december-2025.pdf | 618 | 2025-12 | Pedestrian | Ford | transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 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 | ||
| 4516 | op-snap---monthly-publication-december-2025.pdf | 644 | 2025-12 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | wooten road | Wooten Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 4524 | op-snap---monthly-publication-december-2025.pdf | 652 | 2025-12 | Pedestrian | Nissan | note | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ladywood | Ladywood | Birmingham | Birmingham | NFA | No Offence | 52.4774932 | -1.9233654 | ||
| 4531 | op-snap---monthly-publication-december-2025.pdf | 659 | 2025-12 | Pedestrian | BMW | m5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | kings heath | Kings Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4388601 | -1.8936667 | ||
| 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 | |||||
| 4577 | op-snap---monthly-publication-december-2025.pdf | 705 | 2025-12 | Pedestrian | Audi | A6 | Grey | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4622646 | -1.8599985 | ||
| 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 | ||
| 4595 | op-snap---monthly-publication-december-2025.pdf | 723 | 2025-12 | Pedestrian | Citroen | c4 | Black | Cause vehicle to be left in a dangerous position | None | halford lane | Halford Lane | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4398231 | -1.526811 | ||
| 4602 | op-snap---monthly-publication-december-2025.pdf | 730 | 2025-12 | Pedestrian | Renault | Clio | Black | Driving without Due Care and Attention | None | Shrewsbury Road | Shrewsbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 4649 | op-snap---monthly-publication-december-2025.pdf | 777 | 2025-12 | Pedestrian | Audi | q2 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | shirley road | Shirley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4198291 | -1.9241732 | ||
| 4650 | op-snap---monthly-publication-december-2025.pdf | 778 | 2025-12 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | apsley road | Apsley Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4651624 | -2.0105642 | |||||
| 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 | ||||
| 4653 | op-snap---monthly-publication-december-2025.pdf | 781 | 2025-12 | Pedestrian | Toyota | yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ellesmer road | Ellesmer Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | ||||
| 4668 | op-snap---monthly-publication-december-2025.pdf | 796 | 2025-12 | Pedestrian | Mercedes-Benz | GLC 220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | NFA | Duplicate Submission | ||||
| 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 | ||||
| 4687 | op-snap---monthly-publication-december-2025.pdf | 815 | 2025-12 | Pedestrian | Driving without Due Care and Attention | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4760986 | -1.9018641 | |||||
| 4688 | op-snap---monthly-publication-december-2025.pdf | 816 | 2025-12 | Pedestrian | Driving without Due Care and Attention | None | Alston Street | Alston Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4772629 | -1.9267359 | |||||
| 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 | |||
| 4773 | op-snap---monthly-publication-december-2025.pdf | 901 | 2025-12 | Pedestrian | Vauxhall | Meriva | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne St | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 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 | ||||
| 4936 | op-snap---monthly-publication-december-2025.pdf | 1064 | 2025-12 | Pedestrian | BMW | 525d | White | Driving without Due Care and Attention | None | oval | Oval | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4577754 | -1.8692099 | ||
| 4937 | op-snap---monthly-publication-december-2025.pdf | 1065 | 2025-12 | 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 | ||
| 4938 | op-snap---monthly-publication-december-2025.pdf | 1066 | 2025-12 | Pedestrian | Ford | transit | White | 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 | ||
| 4940 | op-snap---monthly-publication-december-2025.pdf | 1068 | 2025-12 | 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 | Outside of 14 Days NIP | 52.4693896 | -2.1251602 | ||
| 4941 | op-snap---monthly-publication-december-2025.pdf | 1069 | 2025-12 | Pedestrian | Ford | focus | 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 | ||
| 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 | ||
| 4950 | op-snap---monthly-publication-december-2025.pdf | 1078 | 2025-12 | Pedestrian | Audi | a4 | Silver | Cause vehicle to be left in a dangerous position | None | poplar road | Poplar Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.436035 | -1.891685 | ||
| 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 | ||
| 4954 | op-snap---monthly-publication-december-2025.pdf | 1082 | 2025-12 | Pedestrian | Hyundai | tucson | Grey | Cause vehicle to be left in a dangerous position | None | tividale road | Tividale Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5144157 | -2.0586136 | ||
| 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 |
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);