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'}
216 rows where disposal = "Education" and month = "2025-07" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 29
council_area 11
- Birmingham 100
- Coventry 27
- Sandwell 23
- Solihull 22
- Dudley 13
- Walsall 12
- Wolverhampton 9
- Sutton Coldfield 7
- Basirtmingham 1
- Borirt Mrionagdham 1
- Cst Arnadwell 1
offence 10
- Driving without Due Care and Attention 100
- Contravening a Red Traffic Light 88
- Driving without Reasonable Consideration 14
- Contravene Lane Closure Red X 4
- Drive a vehicle other than on the carriageway of a motorway 4
- Drive on hard shoulder 2
- Cause vehicle to be left in a dangerous position 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Vehicle overtake within crossing limits 1
reporter_transport_mode 7
- Car 160
- Pedal Bike 37
- Pedestrian 11
- Other 4
- Motorbike 2
- Bus 1
- car 1
month 1
- 2025-07 · 216 ✖
disposal 1
- Education · 216 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11949 | op-snap---monthly-publication-july-2025.pdf | 1 | 2025-07 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Airport WAY | Airport WAY | Birmingham | Birmingham | Education | N/A | ||||
| 11955 | op-snap---monthly-publication-july-2025.pdf | 7 | 2025-07 | Car | Seat | Ateca | Grey | Contravening a Red Traffic Light | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Education | N/A | 52.4220705 | -1.8372335 | ||
| 11956 | op-snap---monthly-publication-july-2025.pdf | 8 | 2025-07 | Car | Ford | Transit | White | Drive on hard shoulder | None | M42 J6 | M42 J6 | Solihull | Solihull | Education | N/A | ||||
| 11957 | op-snap---monthly-publication-july-2025.pdf | 9 | 2025-07 | Car | Volkswagen | Passat | Grey | Contravene Lane Closure Red X | None | Robin Hood Islland | Robin Hood Islland | Birmingham | Birmingham | Education | N/A | ||||
| 11970 | op-snap---monthly-publication-july-2025.pdf | 22 | 2025-07 | Car | Seat | Leon | Silver | Contravening a Red Traffic Light | None | Amesbury Road | Amesbury Road | Birmingham | Birmingham | Education | N/A | 52.4465507 | -1.8957752 | ||
| 11975 | op-snap---monthly-publication-july-2025.pdf | 27 | 2025-07 | Motorbike | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Tamworth Road | Tamworth Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5750404 | -1.8129485 | ||
| 11981 | op-snap---monthly-publication-july-2025.pdf | 33 | 2025-07 | Car | Audi | A3 | White | Contravening a Red Traffic Light | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 11982 | op-snap---monthly-publication-july-2025.pdf | 34 | 2025-07 | Pedal Bike | Scania | White | Driving without Due Care and Attention | None | Cornets End Lane | Cornets End Lane | Coventry | Coventry | Education | N/A | |||||
| 11983 | op-snap---monthly-publication-july-2025.pdf | 35 | 2025-07 | Pedal Bike | Peugeot | 208 | Black | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | ||
| 11991 | op-snap---monthly-publication-july-2025.pdf | 43 | 2025-07 | Pedal Bike | Audi | A3 | Silver | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5968709 | -2.0954054 | ||
| 12004 | op-snap---monthly-publication-july-2025.pdf | 56 | 2025-07 | Pedal Bike | Kia | Sportage | Grey | Driving without Reasonable Consideration | None | Ridgacre Road | Ridgacre Road | Birmingham | Birmingham | Education | N/A | 52.4593367 | -2.0000298 | ||
| 12008 | op-snap---monthly-publication-july-2025.pdf | 60 | 2025-07 | Car | Nissan | Qashqai | Blue | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 12009 | op-snap---monthly-publication-july-2025.pdf | 61 | 2025-07 | Car | Volkswagen | Passatt | Grey | Driving without Due Care and Attention | None | Richmond Road | Richmond Road | Solihull | Solihull | Education | N/A | 52.4430188 | -1.8022218 | ||
| 12010 | op-snap---monthly-publication-july-2025.pdf | 62 | 2025-07 | Pedal Bike | Volvo | V40 | Blue | Driving without Due Care and Attention | None | Meer End Road | Meer End Road | Solihull | Solihull | Education | N/A | 52.373396 | -1.6335409 | ||
| 12028 | op-snap---monthly-publication-july-2025.pdf | 80 | 2025-07 | Car | Audi | Q5 | Grey | Contravening a Red Traffic Light | None | Bills Lane, Shirley | Bills Lane, Shirley | Solihull | Solihull | Education | N/A | 52.4054849 | -1.8281697 | ||
| 12030 | op-snap---monthly-publication-july-2025.pdf | 82 | 2025-07 | Car | Mercedes-Benz | no trace | Silver | Contravening a Red Traffic Light | None | Bills Lane, Shirley | Bills Lane, Shirley | Solihull | Solihull | Education | N/A | 52.4054849 | -1.8281697 | ||
| 12031 | op-snap---monthly-publication-july-2025.pdf | 83 | 2025-07 | Pedestrian | Audi | A3.. | Grey | Contravening a Red Traffic Light | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 12084 | op-snap---monthly-publication-july-2025.pdf | 136 | 2025-07 | Car | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | High Street | High Street | Sandwell | Sandwell | Education | N/A | 52.5128738 | -1.9842054 | ||
| 12087 | op-snap---monthly-publication-july-2025.pdf | 139 | 2025-07 | Pedal Bike | BMW | 116.. | White | Driving without Due Care and Attention | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Education | N/A | 52.4725977 | -1.9684448 | ||
| 12095 | op-snap---monthly-publication-july-2025.pdf | 147 | 2025-07 | Car | BMW | x6 | White | Contravening a Red Traffic Light | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Education | N/A | 52.4709298 | -1.8722585 | ||
| 12098 | op-snap---monthly-publication-july-2025.pdf | 150 | 2025-07 | Car | Land Rover | Sport | Black | Driving without Due Care and Attention | None | Manor Lane | Manor Lane | Dudley | Dudley | Education | N/A | 52.4500678 | -2.0276115 | ||
| 12102 | op-snap---monthly-publication-july-2025.pdf | 154 | 2025-07 | Car | BMW | 330 | Grey | Drive a vehicle other than on the carriageway of a motorway | None | M42 Motorway SB | M42 Motorway Southbound | Solihull | Solihull | Education | N/A | ||||
| 12104 | op-snap---monthly-publication-july-2025.pdf | 156 | 2025-07 | Car | Land Rover | Sport | Blue | Drive a vehicle other than on the carriageway of a motorway | None | M6 SB J6 | M6 Southbound J6 | Birmingham | Birmingham | Education | N/A | 52.676119 | -2.0858425 | ||
| 12105 | op-snap---monthly-publication-july-2025.pdf | 157 | 2025-07 | Car | Daf | Lorry | White | Contravening a Red Traffic Light | None | A38 Minworth | Minworth | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5301514 | -1.7586638 | ||
| 12106 | op-snap---monthly-publication-july-2025.pdf | 158 | 2025-07 | Car | Mazda | CX 5 | Blue | Contravening a Red Traffic Light | None | Dingle Lane | Dingle Lane | Solihull | Solihull | Education | N/A | 52.4044204 | -1.7965379 | ||
| 12115 | op-snap---monthly-publication-july-2025.pdf | 167 | 2025-07 | Car | Mercedes-Benz | C220 | Red | Driving without Due Care and Attention | None | Wood End Road | Wood End Road | Wolverhampton | Wolverhampton | Education | N/A | 52.605993 | -2.0805938 | ||
| 12136 | op-snap---monthly-publication-july-2025.pdf | 188 | 2025-07 | Car | Hyundai | Kona | Black | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Education | N/A | ||||
| 12151 | op-snap---monthly-publication-july-2025.pdf | 203 | 2025-07 | Car | Toyota | Aygo | Grey | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12158 | op-snap---monthly-publication-july-2025.pdf | 210 | 2025-07 | Car | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Education | N/A | 52.5899123 | -1.8057069 | ||
| 12166 | op-snap---monthly-publication-july-2025.pdf | 218 | 2025-07 | Car | Land Rover | Discovery | Black | Contravening a Red Traffic Light | None | Solihull Road | Solihull Road | Solihull | Solihull | Education | N/A | 52.4114159 | -1.8197732 | ||
| 12168 | op-snap---monthly-publication-july-2025.pdf | 220 | 2025-07 | Pedal Bike | Tesla | Model 3 | White | Driving without Reasonable Consideration | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | ||
| 12170 | op-snap---monthly-publication-july-2025.pdf | 222 | 2025-07 | Car | Audi | A8 | Black | Driving without Due Care and Attention | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Education | N/A | 52.4762784 | -1.9678366 | ||
| 12172 | op-snap---monthly-publication-july-2025.pdf | 224 | 2025-07 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Fordge Lane Cradley Heath | Fordge Lane Cradley Heath | Sandwell | Sandwell | Education | N/A | ||||
| 12174 | op-snap---monthly-publication-july-2025.pdf | 226 | 2025-07 | Pedal Bike | Ford | B-Max | Blue | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Education | N/A | 52.4223176 | -1.8253145 | ||
| 12175 | op-snap---monthly-publication-july-2025.pdf | 227 | 2025-07 | Pedal Bike | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Haslucks Green Road | Haslucks Green Road | Solihull | Solihull | Education | N/A | 52.4145149 | -1.8301272 | ||
| 12176 | op-snap---monthly-publication-july-2025.pdf | 228 | 2025-07 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Widdrington Road | Widdrington Road | Coventry | Coventry | Education | N/A | 52.4191764 | -1.5105738 | ||
| 12179 | op-snap---monthly-publication-july-2025.pdf | 231 | 2025-07 | Pedal Bike | Honda | Jazz | Blue | Driving without Due Care and Attention | None | Ampton Road | Ampton Road | Birmingham | Birmingham | Education | N/A | 52.4632489 | -1.917458 | ||
| 12180 | op-snap---monthly-publication-july-2025.pdf | 232 | 2025-07 | Car | BMW | 320d | Blue | Driving without Due Care and Attention | None | Slaters Lane | Slaters Lane | Walsall | Walsall | Education | N/A | 52.5719978 | -2.0041926 | ||
| 12187 | op-snap---monthly-publication-july-2025.pdf | 239 | 2025-07 | Car | BMW | M 440.. | Blue | Contravening a Red Traffic Light | None | Mile Lane | Mile Lane | Coventry | Coventry | Education | N/A | 52.3992732 | -1.5044832 | ||
| 12188 | op-snap---monthly-publication-july-2025.pdf | 240 | 2025-07 | Car | Toyota | Estima | White | Contravening a Red Traffic Light | None | Morris Road | Morris Road | Birmingham | Birmingham | Education | N/A | 52.4953902 | -1.8236361 | ||
| 12189 | op-snap---monthly-publication-july-2025.pdf | 241 | 2025-07 | Car | Honda | CRV | White | Contravening a Red Traffic Light | None | Bromford lane | Bromford lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 12197 | op-snap---monthly-publication-july-2025.pdf | 249 | 2025-07 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Wharf Road | Wharf Road | Birmingham | Birmingham | Education | N/A | 52.4075531 | -1.927329 | ||
| 12200 | op-snap---monthly-publication-july-2025.pdf | 252 | 2025-07 | Car | Jaguar | XF | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12203 | op-snap---monthly-publication-july-2025.pdf | 255 | 2025-07 | Car | BMW | X Drive | Blue | Driving without Due Care and Attention | None | Brassington Avenue | Brassington Avenue | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5637812 | -1.823481 | ||
| 12206 | op-snap---monthly-publication-july-2025.pdf | 258 | 2025-07 | Car | Audi | A6... | Blue | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12208 | op-snap---monthly-publication-july-2025.pdf | 260 | 2025-07 | Car | Mitsubishi | Outlander | White | Contravening a Red Traffic Light | None | Isloington Row | Isloington Row | Birmingham | Birmingham | Education | N/A | ||||
| 12211 | op-snap---monthly-publication-july-2025.pdf | 263 | 2025-07 | Car | Volvo | Lorry | Red | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 | ||
| 12212 | op-snap---monthly-publication-july-2025.pdf | 264 | 2025-07 | Other | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 12215 | op-snap---monthly-publication-july-2025.pdf | 267 | 2025-07 | Car | Yamaha | MT-07 | Silver | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 12216 | op-snap---monthly-publication-july-2025.pdf | 268 | 2025-07 | Car | Yamaha | Kawasaki ZR750 | Blue | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 12217 | op-snap---monthly-publication-july-2025.pdf | 269 | 2025-07 | Car | BMW | 320 | Black | Contravening a Red Traffic Light | None | Stechford Lane | Stechford Lane | Birmingham | Birmingham | Education | N/A | 52.4930549 | -1.8179571 | ||
| 12218 | op-snap---monthly-publication-july-2025.pdf | 270 | 2025-07 | Pedal Bike | Jaguar | XE | Black | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5872149 | -1.8300386 | ||
| 12220 | op-snap---monthly-publication-july-2025.pdf | 272 | 2025-07 | Car | Toyota | Camry | Grey | Contravening a Red Traffic Light | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Education | N/A | 52.4679402 | -1.881408 | ||
| 12224 | op-snap---monthly-publication-july-2025.pdf | 276 | 2025-07 | Pedal Bike | Seat | Ibiza | Black | Driving without Due Care and Attention | None | Dads Lane | Dads Lane | Birmingham | Birmingham | Education | N/A | 52.4375913 | -1.9068522 | ||
| 12227 | op-snap---monthly-publication-july-2025.pdf | 279 | 2025-07 | Pedal Bike | Chevrolet | Chrysler | Black | Driving without Due Care and Attention | None | Danford Lane | Danford Lane | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 12232 | op-snap---monthly-publication-july-2025.pdf | 284 | 2025-07 | Car | Suzuki | Swace | White | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Education | N/A | 52.5867763 | -2.0104342 | ||
| 12234 | op-snap---monthly-publication-july-2025.pdf | 286 | 2025-07 | Car | BMW | X4 | Grey | Driving without Reasonable Consideration | None | Little Bromwich Road | Little Bromwich Road | Birmingham | Birmingham | Education | N/A | 52.4777017 | -1.8246255 | ||
| 12258 | op-snap---monthly-publication-july-2025.pdf | 310 | 2025-07 | Car | Vauxhall | Combo | Grey | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | ||
| 12261 | op-snap---monthly-publication-july-2025.pdf | 313 | 2025-07 | Car | Volkswagen | Transporter | Blue | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Education | N/A | 52.471632 | -1.9456776 | ||
| 12279 | op-snap---monthly-publication-july-2025.pdf | 331 | 2025-07 | Car | Peugeot | 2008.... | Red | Driving without Due Care and Attention | None | M6 South Jct 7 | M6 South Junction 7 | Sandwell | Sandwell | Education | N/A | ||||
| 12289 | op-snap---monthly-publication-july-2025.pdf | 341 | 2025-07 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Pershore Street | Pershore Street | Birmingham | Birmingham | Education | N/A | 52.4727929 | -1.8934901 | ||
| 12295 | op-snap---monthly-publication-july-2025.pdf | 347 | 2025-07 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Dudley Street | Dudley Street | Dudley | Dudley | Education | N/A | 52.540391 | -2.1211076 | ||
| 12296 | op-snap---monthly-publication-july-2025.pdf | 348 | 2025-07 | Car | Kia | Sportage | Red | Drive a vehicle other than on the carriageway of a motorway | None | M6 South Jct 6 Slip | M6 South Junction 6 Slip | Birmingham | Birmingham | Education | N/A | ||||
| 12305 | op-snap---monthly-publication-july-2025.pdf | 357 | 2025-07 | Car | Toyota | Rav 4. | Blue | Contravening a Red Traffic Light | None | Dudley Road Rowley Regis | Dudley Road Rowley Regis | Sandwell | Sandwell | Education | N/A | 52.4952912 | -2.0641749 | ||
| 12306 | op-snap---monthly-publication-july-2025.pdf | 358 | 2025-07 | Car | Toyota | Pro Ace | White | Contravening a Red Traffic Light | None | Hall Street | Hall Street | Dudley | Dudley | Education | N/A | 52.5409774 | -2.1235921 | ||
| 12312 | op-snap---monthly-publication-july-2025.pdf | 364 | 2025-07 | Car | BMW | X1.. | White | Driving without Due Care and Attention | None | M5 Junction 1 Island | M5 Junction 1 Island | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12316 | op-snap---monthly-publication-july-2025.pdf | 368 | 2025-07 | Car | Honda | Jazz | Black | Driving without Due Care and Attention | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Education | N/A | 52.4103191 | -1.8670224 | ||
| 12322 | op-snap---monthly-publication-july-2025.pdf | 374 | 2025-07 | Car | BMW | 220.. | Black | Driving without Due Care and Attention | None | Stubbers Green Road | Stubbers Green Road | Walsall | Walsall | Education | N/A | 52.6118163 | -1.9350405 | ||
| 12325 | op-snap---monthly-publication-july-2025.pdf | 377 | 2025-07 | Car | Peugeot | 107.. | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 12326 | op-snap---monthly-publication-july-2025.pdf | 378 | 2025-07 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 12330 | op-snap---monthly-publication-july-2025.pdf | 382 | 2025-07 | Car | Nissan | Primastar | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 12335 | op-snap---monthly-publication-july-2025.pdf | 387 | 2025-07 | Car | Mercedes-Benz | A180 | Black | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | Education | N/A | 52.5867763 | -2.0104342 | ||
| 12337 | op-snap---monthly-publication-july-2025.pdf | 389 | 2025-07 | Car | Skoda | Red | Drive on hard shoulder | None | M5 Motorway | M5 Motorway | Birmingham | Birmingham | Education | N/A | 52.4462651 | -2.015038 | |||
| 12338 | op-snap---monthly-publication-july-2025.pdf | 390 | 2025-07 | Car | Toyota | yaris | White | Drive a vehicle other than on the carriageway of a motorway | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | Education | N/A | 52.5327447 | -1.899844 | ||
| 12340 | op-snap---monthly-publication-july-2025.pdf | 392 | 2025-07 | Pedestrian | Mercedes-Benz | SLK 200 | Black | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 12341 | op-snap---monthly-publication-july-2025.pdf | 393 | 2025-07 | Car | Seat | Altea | Black | Driving without Due Care and Attention | None | M6 South J8 | M6 South J8 | Birmingham | Birmingham | Education | N/A | ||||
| 12343 | op-snap---monthly-publication-july-2025.pdf | 395 | 2025-07 | Car | Audi | A4 | Black | Contravening a Red Traffic Light | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Education | N/A | 52.4591339 | -1.9601054 | ||
| 12344 | op-snap---monthly-publication-july-2025.pdf | 396 | 2025-07 | Car | Citroen | C1 | Red | Contravening a Red Traffic Light | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Education | N/A | 52.4178465 | -1.968864 | ||
| 12345 | op-snap---monthly-publication-july-2025.pdf | 397 | 2025-07 | Car | Ford | Puma | Black | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 12346 | op-snap---monthly-publication-july-2025.pdf | 398 | 2025-07 | Car | Audi | A3 | Grey | Contravening a Red Traffic Light | None | Frankley Beeches Road | Frankley Beeches Road | Birmingham | Birmingham | Education | N/A | 52.4094108 | -1.9930633 | ||
| 12355 | op-snap---monthly-publication-july-2025.pdf | 407 | 2025-07 | Car | Dennis (Bus) | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Education | N/A | 52.4428606 | -1.812114 | |||
| 12357 | op-snap---monthly-publication-july-2025.pdf | 409 | 2025-07 | Bus | Mercedes-Benz | C220.. | Silver | Driving without Due Care and Attention | None | Newton Road | Newton Road | Sandwell | Sandwell | Education | N/A | 52.5428224 | -1.9569444 | ||
| 12358 | op-snap---monthly-publication-july-2025.pdf | 410 | 2025-07 | Car | Peugeot | 3008 | Black | Contravening a Red Traffic Light | None | Wolverhampton Road, Oldbury | Wolverhampton Road, Oldbury | Sandwell | Sandwell | Education | N/A | 52.5028787 | -2.0328384 | ||
| 12360 | op-snap---monthly-publication-july-2025.pdf | 412 | 2025-07 | Pedestrian | Volkswagen | Polo | Grey | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12361 | op-snap---monthly-publication-july-2025.pdf | 413 | 2025-07 | Car | Toyota | yaris | Silver | Contravening a Red Traffic Light | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Education | N/A | 52.4751651 | -1.8559775 | ||
| 12362 | op-snap---monthly-publication-july-2025.pdf | 414 | 2025-07 | Pedestrian | Volvo | Lorry | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12364 | op-snap---monthly-publication-july-2025.pdf | 416 | 2025-07 | Pedestrian | Honda | Civic | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 12370 | op-snap---monthly-publication-july-2025.pdf | 422 | 2025-07 | Pedal Bike | Ford | Fiesta | Blue | Driving without Reasonable Consideration | None | Friday Lane | Friday Lane | Solihull | Solihull | Education | N/A | 52.4142542 | -1.7217662 | ||
| 12372 | op-snap---monthly-publication-july-2025.pdf | 424 | 2025-07 | Car | Volvo | V40 | Blue | Contravening a Red Traffic Light | None | High Street | High Street | Dudley | Dudley | Education | N/A | 52.4779764 | -2.1598371 | ||
| 12380 | op-snap---monthly-publication-july-2025.pdf | 432 | 2025-07 | Pedal Bike | Audi | A3 | Black | Driving without Due Care and Attention | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | Education | N/A | 52.4374665 | -1.9119895 | ||
| 12382 | op-snap---monthly-publication-july-2025.pdf | 434 | 2025-07 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 12385 | op-snap---monthly-publication-july-2025.pdf | 437 | 2025-07 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 12391 | op-snap---monthly-publication-july-2025.pdf | 443 | 2025-07 | Pedal Bike | Peugeot | 2008 | Grey | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Coventry | Coventry | Education | N/A | 52.4111289 | -1.5094345 | ||
| 12395 | op-snap---monthly-publication-july-2025.pdf | 447 | 2025-07 | Car | Seat | Arona | Blue | Driving without Reasonable Consideration | None | M5 Junction 1 | M5 Junction 1 | Sandwell | Sandwell | Education | N/A | ||||
| 12398 | op-snap---monthly-publication-july-2025.pdf | 450 | 2025-07 | Car | Volkswagen | Transporter | Blue | Driving without Due Care and Attention | None | Tyburn Roundabout | Tyburn Roundabout | Birmingham | Birmingham | Education | N/A | ||||
| 12400 | op-snap---monthly-publication-july-2025.pdf | 452 | 2025-07 | Pedal Bike | Toyota | Auris | Black | Driving without Due Care and Attention | None | May Lane | May Lane | Birmingham | Birmingham | Education | N/A | 52.4197342 | -1.8839613 | ||
| 12410 | op-snap---monthly-publication-july-2025.pdf | 462 | 2025-07 | Pedestrian | BMW | 318.. | Grey | Contravening a Red Traffic Light | None | Ringway St Nicholas | Ringway Street Nicholas | Coventry | Coventry | Education | N/A | ||||
| 12412 | op-snap---monthly-publication-july-2025.pdf | 464 | 2025-07 | Car | Volkswagen | Up | Gold | Driving without Due Care and Attention | None | Sir William Lyons Road | Sir William Lyons Road | Coventry | Coventry | Education | N/A | 52.3877545 | -1.5585877 | ||
| 12415 | op-snap---monthly-publication-july-2025.pdf | 467 | 2025-07 | Car | Nissan | Qashqai | Silver | Contravening a Red Traffic Light | None | Four Pounds Avenue | Four Pounds Avenue | Coventry | Coventry | Education | N/A | 52.413228 | -1.5323652 | ||
| 12421 | op-snap---monthly-publication-july-2025.pdf | 473 | 2025-07 | Car | Audi | RS3 | Black | Contravening a Red Traffic Light | None | Catherine de Barnes Lane | Catherine de Barnes Lane | Solihull | Solihull | Education | N/A | 52.4391457 | -1.7277084 |
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);