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'}
210 rows where disposal = "Warning Letter", month = "2025-12" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 28
council_area 12
- Birmingham 144
- Sandwell 18
- Wolverhampton 16
- Dudley 7
- Solihull 7
- Walsall 6
- Coventry 3
- Edldu Dalveey Brierley Hill 3
- Sutton Coldfield 2
- Ubdirymaridn Gghraomve 2
- Eb Ihrmilli)Ngham 1
- Rbdir Mingham 1
offence 9
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 81
- Driving without Due Care and Attention 43
- Cause vehicle to be left in a dangerous position 39
- Contravening a Red Traffic Light 19
- Misc - Non Traffic Offences 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 10
- Stop a vehicle within pelican pedestrian crossing limits 6
- Contravene Lane Closure Red X 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
reporter_transport_mode 1
- Car · 210 ✖
month 1
- 2025-12 · 210 ✖
disposal 1
- Warning Letter · 210 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3878 | op-snap---monthly-publication-december-2025.pdf | 6 | 2025-12 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3880 | op-snap---monthly-publication-december-2025.pdf | 8 | 2025-12 | Car | BMW | 1 Series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3881 | op-snap---monthly-publication-december-2025.pdf | 9 | 2025-12 | Car | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3883 | op-snap---monthly-publication-december-2025.pdf | 11 | 2025-12 | Car | Toyota | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | |||
| 3888 | op-snap---monthly-publication-december-2025.pdf | 16 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barton Drive | Barton Drive | Solihull | Solihull | Warning Letter | N/A | 52.3770722 | -1.7420909 | ||
| 3894 | op-snap---monthly-publication-december-2025.pdf | 22 | 2025-12 | Car | Hyundai | Ioniq | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3895 | op-snap---monthly-publication-december-2025.pdf | 23 | 2025-12 | Car | Vauxhall | Corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3896 | op-snap---monthly-publication-december-2025.pdf | 24 | 2025-12 | Car | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3897 | op-snap---monthly-publication-december-2025.pdf | 25 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Cause vehicle to be left in a dangerous position | None | West Bromwich High St | West Bromwich High Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5205106 | -1.9980473 | ||
| 3915 | op-snap---monthly-publication-december-2025.pdf | 43 | 2025-12 | Car | BMW | X1 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 3916 | op-snap---monthly-publication-december-2025.pdf | 44 | 2025-12 | Car | Volkswagen | Tiguan | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3934 | op-snap---monthly-publication-december-2025.pdf | 62 | 2025-12 | Car | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3935 | op-snap---monthly-publication-december-2025.pdf | 63 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3936 | op-snap---monthly-publication-december-2025.pdf | 64 | 2025-12 | Car | Mercedes-Benz | C220 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3940 | op-snap---monthly-publication-december-2025.pdf | 68 | 2025-12 | Car | Audi | RS6 | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 3956 | op-snap---monthly-publication-december-2025.pdf | 84 | 2025-12 | Car | Toyota | Estima | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5550797 | -1.7950237 | ||
| 3957 | op-snap---monthly-publication-december-2025.pdf | 85 | 2025-12 | Car | Volkswagen | Touran | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 3958 | op-snap---monthly-publication-december-2025.pdf | 86 | 2025-12 | Car | Nissan | Note | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5001925 | -1.9481997 | ||
| 3959 | op-snap---monthly-publication-december-2025.pdf | 87 | 2025-12 | Car | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 3972 | op-snap---monthly-publication-december-2025.pdf | 100 | 2025-12 | Car | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3973 | op-snap---monthly-publication-december-2025.pdf | 101 | 2025-12 | Car | Citroen | berlingo | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3975 | op-snap---monthly-publication-december-2025.pdf | 103 | 2025-12 | Car | Volkswagen | xc90 | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3977 | op-snap---monthly-publication-december-2025.pdf | 105 | 2025-12 | Car | Vauxhall | corsa | Red | Cause vehicle to be left in a dangerous position | None | washwood hath road | Washwood Hath Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3981 | op-snap---monthly-publication-december-2025.pdf | 109 | 2025-12 | Car | Toyota | AYGO | White | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 3990 | op-snap---monthly-publication-december-2025.pdf | 118 | 2025-12 | Car | Mercedes-Benz | CLA220 | White | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 4002 | op-snap---monthly-publication-december-2025.pdf | 130 | 2025-12 | Car | BMW | 3 Series | Grey | Driving without Due Care and Attention | None | Stafford St | Stafford Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5653849 | -2.0755665 | ||
| 4003 | op-snap---monthly-publication-december-2025.pdf | 131 | 2025-12 | Car | Jeep | Renegade | Black | Driving without Due Care and Attention | None | Grove Lane | Grove Lane | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5541631 | -1.7509992 | ||
| 4061 | op-snap---monthly-publication-december-2025.pdf | 189 | 2025-12 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | A41 Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 4065 | op-snap---monthly-publication-december-2025.pdf | 193 | 2025-12 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 4069 | op-snap---monthly-publication-december-2025.pdf | 197 | 2025-12 | Car | Kia | Picanto | White | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 4077 | op-snap---monthly-publication-december-2025.pdf | 205 | 2025-12 | Car | Mercedes-Benz | C180 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4101 | op-snap---monthly-publication-december-2025.pdf | 229 | 2025-12 | Car | BMW | X3.. | Grey | Contravening a Red Traffic Light | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4170522 | -1.8906187 | ||
| 4105 | op-snap---monthly-publication-december-2025.pdf | 233 | 2025-12 | Car | Kia | Niro.. | Black | Driving without Due Care and Attention | None | Hawthorn Road | Hawthorn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5436609 | -1.8214668 | ||
| 4106 | op-snap---monthly-publication-december-2025.pdf | 234 | 2025-12 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | M6 Motorway | M6 Motorway | Walsall | Walsall | Warning Letter | N/A | 52.6151447 | -2.0290522 | ||
| 4115 | op-snap---monthly-publication-december-2025.pdf | 243 | 2025-12 | Car | Kia | Sportage | Yellow | Driving without Due Care and Attention | None | New Cross Hospital | New Cross Hospital | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6000052 | -2.0954966 | ||
| 4118 | op-snap---monthly-publication-december-2025.pdf | 246 | 2025-12 | Car | Citroen | Berlingo | Black | Driving without Due Care and Attention | None | Ambergate Road Bilston | Ambergate Road Bilston | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5597351 | -2.081298 | ||
| 4123 | op-snap---monthly-publication-december-2025.pdf | 251 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Maple Tree Lane | Maple Tree Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4127 | op-snap---monthly-publication-december-2025.pdf | 255 | 2025-12 | Car | Volkswagen | Golf | Grey | Misc - Non Traffic Offences | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4134 | op-snap---monthly-publication-december-2025.pdf | 262 | 2025-12 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Nechells Lane | Nechells Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 4142 | op-snap---monthly-publication-december-2025.pdf | 270 | 2025-12 | Car | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4143 | op-snap---monthly-publication-december-2025.pdf | 271 | 2025-12 | Car | Toyota | Priuis | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4147 | op-snap---monthly-publication-december-2025.pdf | 275 | 2025-12 | Car | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4151 | op-snap---monthly-publication-december-2025.pdf | 279 | 2025-12 | Car | Lexus | Lexus | Silver | Driving without Due Care and Attention | None | Castle Vale | Castle Vale | Birmingham | Birmingham | Warning Letter | N/A | 52.5212593 | -1.7845494 | ||
| 4172 | op-snap---monthly-publication-december-2025.pdf | 300 | 2025-12 | Car | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 4184 | op-snap---monthly-publication-december-2025.pdf | 312 | 2025-12 | Car | Lexus | RX | Black | Driving without Due Care and Attention | None | The Boulevard Brierley Hill | The Boulevard Brierley Hill | Dudley | Dudley | Warning Letter | N/A | 52.4788849 | -2.1125394 | ||
| 4227 | op-snap---monthly-publication-december-2025.pdf | 355 | 2025-12 | Car | Honda | Civic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4237 | op-snap---monthly-publication-december-2025.pdf | 365 | 2025-12 | Car | Kia | Ceed | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 4242 | op-snap---monthly-publication-december-2025.pdf | 370 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5517052 | -1.7825505 | ||
| 4245 | op-snap---monthly-publication-december-2025.pdf | 373 | 2025-12 | Car | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4246 | op-snap---monthly-publication-december-2025.pdf | 374 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4247 | op-snap---monthly-publication-december-2025.pdf | 375 | 2025-12 | Car | BMW | 1 Series | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4251 | op-snap---monthly-publication-december-2025.pdf | 379 | 2025-12 | Car | Toyota | mpv | Black | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 4252 | op-snap---monthly-publication-december-2025.pdf | 380 | 2025-12 | Car | Mercedes-Benz | c250 | Silver | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 4258 | op-snap---monthly-publication-december-2025.pdf | 386 | 2025-12 | Car | Ford | fusion | Blue | Cause vehicle to be left in a dangerous position | None | vauxhall road | Vauxhall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4834623 | -1.8796522 | ||
| 4263 | op-snap---monthly-publication-december-2025.pdf | 391 | 2025-12 | Car | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4216321 | -1.855984 | ||
| 4264 | op-snap---monthly-publication-december-2025.pdf | 392 | 2025-12 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Arden Oak Road | Arden Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4533929 | -1.7703309 | ||
| 4266 | op-snap---monthly-publication-december-2025.pdf | 394 | 2025-12 | Car | Audi | A3.. | White | Contravening a Red Traffic Light | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4268 | op-snap---monthly-publication-december-2025.pdf | 396 | 2025-12 | Car | Scania | Lorry | White | Contravening a Red Traffic Light | None | Islington Road | Islington Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4272 | op-snap---monthly-publication-december-2025.pdf | 400 | 2025-12 | Car | Jaguar | E Pace | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4279 | op-snap---monthly-publication-december-2025.pdf | 407 | 2025-12 | Car | Nissan | qashqai | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4280 | op-snap---monthly-publication-december-2025.pdf | 408 | 2025-12 | Car | Toyota | corolla | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4293 | op-snap---monthly-publication-december-2025.pdf | 421 | 2025-12 | Car | Mercedes-Benz | e350 | Silver | Cause vehicle to be left in a dangerous position | None | waswood heath | Waswood Heath | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4294 | op-snap---monthly-publication-december-2025.pdf | 422 | 2025-12 | Car | Ford | transit | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath | Washwood Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4957234 | -1.8538937 | ||
| 4295 | op-snap---monthly-publication-december-2025.pdf | 423 | 2025-12 | Car | BMW | x3 | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4296 | op-snap---monthly-publication-december-2025.pdf | 424 | 2025-12 | Car | Honda | crv | Brown | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4305 | op-snap---monthly-publication-december-2025.pdf | 433 | 2025-12 | Car | Seat | Leon | Silver | Driving without Due Care and Attention | None | A452 | A452 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4306 | op-snap---monthly-publication-december-2025.pdf | 434 | 2025-12 | Car | Mini | Clubman | Grey | Contravening a Red Traffic Light | None | Chester Road North | Chester Road North | Birmingham | Birmingham | Warning Letter | N/A | 52.548449 | -1.8594603 | ||
| 4327 | op-snap---monthly-publication-december-2025.pdf | 455 | 2025-12 | Car | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Fletchemstead Highway A45 | Fletchemstead Highway A45 | Coventry | Coventry | Warning Letter | N/A | ||||
| 4333 | op-snap---monthly-publication-december-2025.pdf | 461 | 2025-12 | Car | Volkswagen | golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | startfrod road | Startfrod Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4339 | op-snap---monthly-publication-december-2025.pdf | 467 | 2025-12 | Car | Kia | sportag | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | haslucks green road | Haslucks Green Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4355 | op-snap---monthly-publication-december-2025.pdf | 483 | 2025-12 | Car | Seat | ibiza | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4361 | op-snap---monthly-publication-december-2025.pdf | 489 | 2025-12 | Car | Toyota | Aygo | Green | Cause vehicle to be left in a dangerous position | None | Coleshill Rd (heading toward Hodg | Coleshill Road (heading toward Hodg | eB iHrmilli)ngham | Eb Ihrmilli)Ngham | Warning Letter | N/A | ||||
| 4362 | op-snap---monthly-publication-december-2025.pdf | 490 | 2025-12 | Car | Volkswagen | Polo | Grey | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4363 | op-snap---monthly-publication-december-2025.pdf | 491 | 2025-12 | Car | Iveco | Daily | White | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4364 | op-snap---monthly-publication-december-2025.pdf | 492 | 2025-12 | Car | Volkswagen | Golf | Grey | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4365 | op-snap---monthly-publication-december-2025.pdf | 493 | 2025-12 | Car | Toyota | Auris | Silver | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4369 | op-snap---monthly-publication-december-2025.pdf | 497 | 2025-12 | Car | Vauxhall | combo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 4370 | op-snap---monthly-publication-december-2025.pdf | 498 | 2025-12 | Car | BMW | 1 series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | sheldon heath road | Sheldon Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4744736 | -1.7892633 | ||
| 4382 | op-snap---monthly-publication-december-2025.pdf | 510 | 2025-12 | Car | Toyota | Corolla | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4383 | op-snap---monthly-publication-december-2025.pdf | 511 | 2025-12 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 4385 | op-snap---monthly-publication-december-2025.pdf | 513 | 2025-12 | Car | Audi | Q3 | Silver | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Battery Way | Battery Way | Birmingham | Birmingham | Warning Letter | N/A | 52.4493988 | -1.8476406 | ||
| 4398 | op-snap---monthly-publication-december-2025.pdf | 526 | 2025-12 | Car | Audi | A4 | Silver | Driving without Due Care and Attention | None | Hunters Road | Hunters Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5011362 | -1.9175837 | ||
| 4419 | op-snap---monthly-publication-december-2025.pdf | 547 | 2025-12 | Car | Kia | Niro | Red | Cause vehicle to be left in a dangerous position | None | Opposite Withymoor School Gayfi | Opposite Withymoor School Gayfi | eDldu dAlveey Brierley Hill | Edldu Dalveey Brierley Hill | Warning Letter | N/A | ||||
| 4420 | op-snap---monthly-publication-december-2025.pdf | 548 | 2025-12 | Car | Skoda | Kodiaq | Gold | Cause vehicle to be left in a dangerous position | None | Opposite Withymoor School Gayfi | Opposite Withymoor School Gayfi | eDldu dAlveey Brierley Hill | Edldu Dalveey Brierley Hill | Warning Letter | N/A | ||||
| 4421 | op-snap---monthly-publication-december-2025.pdf | 549 | 2025-12 | Car | Land Rover | Evoque Dynamics | Black | Cause vehicle to be left in a dangerous position | None | Opposite Withymoor School Gayfi | Opposite Withymoor School Gayfi | eDldu dAlveey Brierley Hill | Edldu Dalveey Brierley Hill | Warning Letter | N/A | ||||
| 4443 | op-snap---monthly-publication-december-2025.pdf | 571 | 2025-12 | Car | Audi | q6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4444 | op-snap---monthly-publication-december-2025.pdf | 572 | 2025-12 | Car | BMW | 116d | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4453 | op-snap---monthly-publication-december-2025.pdf | 581 | 2025-12 | Car | BMW | 1 Series | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4454 | op-snap---monthly-publication-december-2025.pdf | 582 | 2025-12 | Car | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4455 | op-snap---monthly-publication-december-2025.pdf | 583 | 2025-12 | Car | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4467 | op-snap---monthly-publication-december-2025.pdf | 595 | 2025-12 | Car | Citroen | Berlingo | Green | Driving without Due Care and Attention | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.3962003 | -1.9821252 | ||
| 4470 | op-snap---monthly-publication-december-2025.pdf | 598 | 2025-12 | Car | Volkswagen | Golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kings Close | Kings Close | Birmingham | Birmingham | Warning Letter | N/A | 52.4082793 | -1.9251695 | ||
| 4496 | op-snap---monthly-publication-december-2025.pdf | 624 | 2025-12 | Car | Nissan | Qashqai | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 4499 | op-snap---monthly-publication-december-2025.pdf | 627 | 2025-12 | Car | BMW | X5 Sport | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | 132 Burnaby Rd | 132 Burnaby Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4501 | op-snap---monthly-publication-december-2025.pdf | 629 | 2025-12 | Car | Porsche | Turismo | Black | Cause vehicle to be left in a dangerous position | None | Colemore Rd | Colemore Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4502 | op-snap---monthly-publication-december-2025.pdf | 630 | 2025-12 | Car | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4503 | op-snap---monthly-publication-december-2025.pdf | 631 | 2025-12 | Car | Audi | A4 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4514 | op-snap---monthly-publication-december-2025.pdf | 642 | 2025-12 | Car | Kia | rio | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | silvertrees road | Silvertrees Road | Dudley | Dudley | Warning Letter | N/A | 52.5263871 | -2.0677928 | ||
| 4523 | op-snap---monthly-publication-december-2025.pdf | 651 | 2025-12 | Car | Audi | s3 | Black | Cause vehicle to be left in a dangerous position | None | coleshill road | Coleshill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | ||
| 4540 | op-snap---monthly-publication-december-2025.pdf | 668 | 2025-12 | Car | Nissan | Juke | Blue | Cause vehicle to be left in a dangerous position | None | Junction of Eddish Rd and Loeless | Junction of Eddish Road and Loeless | RBdir mingham | Rbdir Mingham | Warning Letter | N/A |
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);