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'}
205 rows where council_area = "Birmingham", month = "2025-12" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 11
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 114
- Misc - Non Traffic Offences 34
- Cause vehicle to be left in a dangerous position 15
- Stop a vehicle within pelican pedestrian crossing limits 14
- Driving without Due Care and Attention 9
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
- Using a Mobile Phone Whilst Driving 6
- Driving a vehicle wholly or partly on a footpath 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Stop a vehicle on pedestrian crossing 1
disposal 6
- Warning Letter 108
- NFA 71
- Fixed Penalty 12
- Education 10
- Other Action Taken 2
- RTC - Actioned 2
reporter_transport_mode 1
- Pedestrian · 205 ✖
month 1
- 2025-12 · 205 ✖
council_area 1
- Birmingham · 205 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3876 | op-snap---monthly-publication-december-2025.pdf | 4 | 2025-12 | Pedestrian | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | New John Street | New John Street | Birmingham | Birmingham | Other Action Taken | No Independent Evidence Available | 52.4920451 | -1.8920402 | ||
| 3890 | op-snap---monthly-publication-december-2025.pdf | 18 | 2025-12 | Pedestrian | Tesla | Model Y | White | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 3898 | op-snap---monthly-publication-december-2025.pdf | 26 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Trittiford Road | Trittiford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4248084 | -1.8660294 | ||
| 3899 | op-snap---monthly-publication-december-2025.pdf | 27 | 2025-12 | Pedestrian | Toyota | Yaris | Silver | Misc - Non Traffic Offences | None | Gibson Drive | Gibson Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.507404 | -1.9170214 | ||
| 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 | ||||
| 3902 | op-snap---monthly-publication-december-2025.pdf | 30 | 2025-12 | Pedestrian | Toyota | Yaris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maitland Road | Maitland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4868494 | -1.8448776 | ||
| 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 | ||
| 3924 | op-snap---monthly-publication-december-2025.pdf | 52 | 2025-12 | Pedestrian | BMW | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | A435 | A435 | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 3925 | op-snap---monthly-publication-december-2025.pdf | 53 | 2025-12 | Pedestrian | Mercedes-Benz | A Class | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shaftmoor Lane | Shaftmoor Lane | Birmingham | Birmingham | Warning Letter | N/A | 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 | ||
| 3943 | op-snap---monthly-publication-december-2025.pdf | 71 | 2025-12 | Pedestrian | Toyota | Aygo | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wilden Lane | Wilden Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3947 | op-snap---monthly-publication-december-2025.pdf | 75 | 2025-12 | Pedestrian | Audi | Q7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyndon Road | Lyndon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5649901 | -1.8274858 | ||
| 3949 | op-snap---monthly-publication-december-2025.pdf | 77 | 2025-12 | Pedestrian | Kia | Venga | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braymoor Road | Braymoor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4756937 | -1.762603 | ||
| 3960 | op-snap---monthly-publication-december-2025.pdf | 88 | 2025-12 | Pedestrian | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 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 | ||
| 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 | ||
| 4129 | op-snap---monthly-publication-december-2025.pdf | 257 | 2025-12 | Pedestrian | BMW | 5 Series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Park Close | High Park Close | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4130 | op-snap---monthly-publication-december-2025.pdf | 258 | 2025-12 | Pedestrian | Mercedes-Benz | C Class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Park Close | High Park Close | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4132 | op-snap---monthly-publication-december-2025.pdf | 260 | 2025-12 | Pedestrian | Renault | Captur | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4307 | -1.8494663 | ||
| 4168 | op-snap---monthly-publication-december-2025.pdf | 296 | 2025-12 | Pedestrian | Volkswagen | Sharan | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Popular Road | Popular Road | Birmingham | Birmingham | Warning Letter | N/A | 52.454374 | -1.8774689 | ||
| 4169 | op-snap---monthly-publication-december-2025.pdf | 297 | 2025-12 | Pedestrian | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Popular Road | Popular Road | Birmingham | Birmingham | Warning Letter | N/A | 52.454374 | -1.8774689 | ||
| 4175 | op-snap---monthly-publication-december-2025.pdf | 303 | 2025-12 | Pedestrian | Mazda | model 3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 4193 | op-snap---monthly-publication-december-2025.pdf | 321 | 2025-12 | Pedestrian | Vauxhall | Meriva | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marks Crescent | Street Marks Crescent | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4198 | op-snap---monthly-publication-december-2025.pdf | 326 | 2025-12 | Pedestrian | Mazda | 3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Street | Church Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5020781 | -1.9122368 | ||
| 4201 | op-snap---monthly-publication-december-2025.pdf | 329 | 2025-12 | Pedestrian | Volkswagen | Passat | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 4206 | op-snap---monthly-publication-december-2025.pdf | 334 | 2025-12 | Pedestrian | Mercedes-Benz | GLB | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Old Road | Moseley Old Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4207 | op-snap---monthly-publication-december-2025.pdf | 335 | 2025-12 | Pedestrian | Land Rover | Range Rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 4208 | op-snap---monthly-publication-december-2025.pdf | 336 | 2025-12 | Pedestrian | Mercedes-Benz | C250 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Middlewood Close | Middlewood Close | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4209 | op-snap---monthly-publication-december-2025.pdf | 337 | 2025-12 | Pedestrian | Hyundai | Tucson | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4506039 | -1.8463952 | ||
| 4210 | op-snap---monthly-publication-december-2025.pdf | 338 | 2025-12 | Pedestrian | Hyundai | Ioniq | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street | Wills Street | Birmingham | Birmingham | Warning Letter | N/A | 52.500453 | -1.9141126 | ||
| 4211 | op-snap---monthly-publication-december-2025.pdf | 339 | 2025-12 | Pedestrian | Mercedes-Benz | GLC | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Carpenters Road | Carpenters Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||||
| 4219 | op-snap---monthly-publication-december-2025.pdf | 347 | 2025-12 | Pedestrian | Volkswagen | Tiguan | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville drive | Glenville drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 4220 | op-snap---monthly-publication-december-2025.pdf | 348 | 2025-12 | Pedestrian | Land Rover | Sport | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville drive | Glenville drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 4221 | op-snap---monthly-publication-december-2025.pdf | 349 | 2025-12 | Pedestrian | Volkswagen | Passat | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 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 | ||
| 4225 | op-snap---monthly-publication-december-2025.pdf | 353 | 2025-12 | Pedestrian | Mercedes-Benz | GLC | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 4226 | op-snap---monthly-publication-december-2025.pdf | 354 | 2025-12 | Pedestrian | Volkswagen | Tiguan | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 4232 | op-snap---monthly-publication-december-2025.pdf | 360 | 2025-12 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 4233 | op-snap---monthly-publication-december-2025.pdf | 361 | 2025-12 | Pedestrian | Skoda | Kodiaq | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Retford Grove | Retford Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.4591192 | -1.8229566 | ||
| 4234 | op-snap---monthly-publication-december-2025.pdf | 362 | 2025-12 | Pedestrian | Cupra | Ateca | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | ||
| 4235 | op-snap---monthly-publication-december-2025.pdf | 363 | 2025-12 | Pedestrian | Mini | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4851181 | -1.9106263 | |||
| 4236 | op-snap---monthly-publication-december-2025.pdf | 364 | 2025-12 | Pedestrian | Vauxhall | Insignia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hall Green Road | Hall Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.473444 | -1.8094123 | ||
| 4238 | op-snap---monthly-publication-december-2025.pdf | 366 | 2025-12 | Pedestrian | Toyota | Yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | A5127 | A5127 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4239 | op-snap---monthly-publication-december-2025.pdf | 367 | 2025-12 | Pedestrian | Nissan | Qashqai | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 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 | ||
| 4241 | op-snap---monthly-publication-december-2025.pdf | 369 | 2025-12 | Pedestrian | Ford | Focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Apsley Road | Apsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4633793 | -1.9102892 | ||
| 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 | |||||
| 4250 | op-snap---monthly-publication-december-2025.pdf | 378 | 2025-12 | Pedestrian | Other | moped | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | manilla road | Manilla Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4376834 | -1.9152398 | ||
| 4254 | op-snap---monthly-publication-december-2025.pdf | 382 | 2025-12 | Pedestrian | Mg | hs | Blue | Misc - Non Traffic Offences | None | teazel avenue | Teazel Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4247795 | -1.9433534 | ||
| 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 | ||
| 4273 | op-snap---monthly-publication-december-2025.pdf | 401 | 2025-12 | Pedestrian | Citroen | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | court oak road | Court Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4604383 | -1.9760104 | |||
| 4297 | op-snap---monthly-publication-december-2025.pdf | 425 | 2025-12 | Pedestrian | Vauxhall | grandland | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lime grove | Lime Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.5042965 | -1.9074069 | ||
| 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 | ||||
| 4322 | op-snap---monthly-publication-december-2025.pdf | 450 | 2025-12 | Pedestrian | Toyota | estima | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | anthony road | Anthony Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4843724 | -1.8470805 | ||
| 4323 | op-snap---monthly-publication-december-2025.pdf | 451 | 2025-12 | Pedestrian | Hyundai | tucson | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | pineapple road | Pineapple Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4303068 | -1.9077938 | ||
| 4324 | op-snap---monthly-publication-december-2025.pdf | 452 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Stop a vehicle within pelican pedestrian crossing limits | None | bristol road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 4332 | op-snap---monthly-publication-december-2025.pdf | 460 | 2025-12 | Pedestrian | Toyota | yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ellesmered road | Ellesmered Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4338 | op-snap---monthly-publication-december-2025.pdf | 466 | 2025-12 | Pedestrian | BMW | 1 series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | grove road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 4344 | op-snap---monthly-publication-december-2025.pdf | 472 | 2025-12 | Pedestrian | Toyota | Prius | white | Using a Mobile Phone Whilst Driving | None | Green Lane, Small Heath | Green Lane, Small Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4733613 | -1.8591116 | ||
| 4346 | op-snap---monthly-publication-december-2025.pdf | 474 | 2025-12 | Pedestrian | Peugeot | 2008 | Black | Using a Mobile Phone Whilst Driving | None | Green Lane, Small Heath | Green Lane, Small Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4733613 | -1.8591116 | ||
| 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 | ||
| 4372 | op-snap---monthly-publication-december-2025.pdf | 500 | 2025-12 | Pedestrian | BMW | 330e | Blue | Cause vehicle to be left in a dangerous position | None | westley road | Westley Road | Birmingham | Birmingham | Education | N/A | 52.4456462 | -1.827993 | ||
| 4389 | op-snap---monthly-publication-december-2025.pdf | 517 | 2025-12 | Pedestrian | Mini | Cooper | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 4433 | op-snap---monthly-publication-december-2025.pdf | 561 | 2025-12 | Pedestrian | Lexus | CT | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 4441 | op-snap---monthly-publication-december-2025.pdf | 569 | 2025-12 | Pedestrian | Other | moped | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | manilla road | Manilla Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4376834 | -1.9152398 | ||
| 4442 | op-snap---monthly-publication-december-2025.pdf | 570 | 2025-12 | Pedestrian | Honda | civic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | grove road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 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 | ||
| 4456 | op-snap---monthly-publication-december-2025.pdf | 584 | 2025-12 | Pedestrian | Daf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | |||
| 4457 | op-snap---monthly-publication-december-2025.pdf | 585 | 2025-12 | Pedestrian | Citroen | Dispatch | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 4458 | op-snap---monthly-publication-december-2025.pdf | 586 | 2025-12 | Pedestrian | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Apsley Road | Apsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4633793 | -1.9102892 | ||
| 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 | ||
| 4492 | op-snap---monthly-publication-december-2025.pdf | 620 | 2025-12 | Pedestrian | Volkswagen | Polo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coles Lane | Coles Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5557121 | -1.8191693 | ||
| 4493 | op-snap---monthly-publication-december-2025.pdf | 621 | 2025-12 | Pedestrian | Ford | KA | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queens Street | Lower Queens Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4500 | op-snap---monthly-publication-december-2025.pdf | 628 | 2025-12 | Pedestrian | Nissan | Note | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood | Ladywood | Birmingham | Birmingham | Warning Letter | N/A | 52.4774932 | -1.9233654 | ||
| 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 | ||
| 4513 | op-snap---monthly-publication-december-2025.pdf | 641 | 2025-12 | Pedestrian | Yamaha | GPD125 | Blue | Driving without Due Care and Attention | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | Education | N/A | 52.473986 | -1.9147087 | ||
| 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 | |||||||
| 4517 | op-snap---monthly-publication-december-2025.pdf | 645 | 2025-12 | Pedestrian | Renault | traffic | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | regent road | Regent Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5077359 | -1.9452509 | ||
| 4522 | op-snap---monthly-publication-december-2025.pdf | 650 | 2025-12 | Pedestrian | BMW | m5 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | kings heath | Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4388601 | -1.8936667 |
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);