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'}
179 rows where month = "2025-12", offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" 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 26
council_area 10
- Birmingham 114
- Dudley 27
- Sandwell 20
- Out of Force Area 4
- Solihull 4
- Sutton Coldfield 4
- Wolverhampton 3
- Bridrmingham 1
- Coventry 1
- Nbs Irrmdingham 1
disposal 4
- Warning Letter 125
- NFA 48
- Fixed Penalty 5
- Other Action Taken 1
reporter_transport_mode 1
- Pedestrian · 179 ✖
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 179 ✖
month 1
- 2025-12 · 179 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 3903 | op-snap---monthly-publication-december-2025.pdf | 31 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3917 | op-snap---monthly-publication-december-2025.pdf | 45 | 2025-12 | Pedestrian | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | ||
| 3918 | op-snap---monthly-publication-december-2025.pdf | 46 | 2025-12 | Pedestrian | Vauxhall | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | |||
| 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 | ||
| 3938 | op-snap---monthly-publication-december-2025.pdf | 66 | 2025-12 | Pedestrian | Toyota | Auris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 3939 | op-snap---monthly-publication-december-2025.pdf | 67 | 2025-12 | Pedestrian | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 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 | ||||
| 3944 | op-snap---monthly-publication-december-2025.pdf | 72 | 2025-12 | Pedestrian | BMW | X6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scafell Road | Scafell Road | Dudley | Dudley | Warning Letter | N/A | 52.4592579 | -2.1385749 | ||
| 3945 | op-snap---monthly-publication-december-2025.pdf | 73 | 2025-12 | Pedestrian | Vauxhall | Insignia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scafell Road | Scafell Road | Dudley | Dudley | Warning Letter | N/A | 52.4592579 | -2.1385749 | ||
| 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 | ||
| 3948 | op-snap---monthly-publication-december-2025.pdf | 76 | 2025-12 | Pedestrian | Mercedes-Benz | E220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Catholic Lane | Catholic Lane | Dudley | Dudley | Warning Letter | N/A | 52.5360259 | -2.125828 | ||
| 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 | ||
| 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 | ||
| 3951 | op-snap---monthly-publication-december-2025.pdf | 79 | 2025-12 | Pedestrian | Peugeot | 2008 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Withymoor Road | Withymoor Road | Dudley | Dudley | Warning Letter | N/A | 52.4871674 | -2.0702998 | ||
| 3953 | op-snap---monthly-publication-december-2025.pdf | 81 | 2025-12 | Pedestrian | Kia | Niro | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3954 | op-snap---monthly-publication-december-2025.pdf | 82 | 2025-12 | Pedestrian | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3955 | op-snap---monthly-publication-december-2025.pdf | 83 | 2025-12 | Pedestrian | Toyota | Avensis | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 3961 | op-snap---monthly-publication-december-2025.pdf | 89 | 2025-12 | Pedestrian | Mercedes-Benz | C220 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingtree road | Huntingtree road | Dudley | Dudley | Warning Letter | N/A | 52.4484682 | -2.0689885 | ||
| 3962 | op-snap---monthly-publication-december-2025.pdf | 90 | 2025-12 | Pedestrian | Renault | Captur | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingree road | Huntingree road | Dudley | Dudley | Warning Letter | N/A | ||||
| 3963 | op-snap---monthly-publication-december-2025.pdf | 91 | 2025-12 | Pedestrian | Volkswagen | Tiguan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingree road | Huntingree road | Dudley | Dudley | Warning Letter | N/A | ||||
| 3964 | op-snap---monthly-publication-december-2025.pdf | 92 | 2025-12 | Pedestrian | Volkswagen | s60 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | hill villiage road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5959906 | -1.8345802 | ||
| 3978 | op-snap---monthly-publication-december-2025.pdf | 106 | 2025-12 | Pedestrian | Tesla | modey y | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | sutton road | Sutton Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5346721 | -1.827743 | ||
| 4125 | op-snap---monthly-publication-december-2025.pdf | 253 | 2025-12 | Pedestrian | Toyota | Prius | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | |||
| 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 | ||
| 4139 | op-snap---monthly-publication-december-2025.pdf | 267 | 2025-12 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4140 | op-snap---monthly-publication-december-2025.pdf | 268 | 2025-12 | Pedestrian | Mazda | CX-30 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 4223 | op-snap---monthly-publication-december-2025.pdf | 351 | 2025-12 | Pedestrian | Mg | HS | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barncroft Road | Barncroft Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5061545 | -2.0570005 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 4231 | op-snap---monthly-publication-december-2025.pdf | 359 | 2025-12 | Pedestrian | Land Rover | Defender | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 4275 | op-snap---monthly-publication-december-2025.pdf | 403 | 2025-12 | Pedestrian | Ford | fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4276 | op-snap---monthly-publication-december-2025.pdf | 404 | 2025-12 | Pedestrian | Vauxhall | zafiara | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4277 | op-snap---monthly-publication-december-2025.pdf | 405 | 2025-12 | Pedestrian | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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);