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'}
160 rows where disposal = "Education", month = "2025-07" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 26
council_area 11
- Birmingham 83
- Sandwell 15
- Coventry 14
- Solihull 14
- Dudley 10
- Walsall 9
- Wolverhampton 7
- Sutton Coldfield 5
- Basirtmingham 1
- Borirt Mrionagdham 1
- Cst Arnadwell 1
offence 9
- Contravening a Red Traffic Light 75
- Driving without Due Care and Attention 64
- Driving without Reasonable Consideration 9
- Drive a vehicle other than on the carriageway of a motorway 4
- Contravene Lane Closure Red X 3
- 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
- Vehicle overtake within crossing limits 1
reporter_transport_mode 1
- Car · 160 ✖
month 1
- 2025-07 · 160 ✖
disposal 1
- Education · 160 ✖
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 12424 | op-snap---monthly-publication-july-2025.pdf | 476 | 2025-07 | Car | Audi | SQ5 | Black | Driving without Due Care and Attention | None | Vicarage Road | Vicarage Road | Sandwell | Sandwell | Education | N/A | 52.5573855 | -2.0133095 | ||
| 12425 | op-snap---monthly-publication-july-2025.pdf | 477 | 2025-07 | Car | Nissan | Qashqai | Black | Vehicle overtake within crossing limits | None | Heath Street | Heath Street | Birmingham | Birmingham | Education | N/A | 52.4869563 | -1.9351596 | ||
| 12430 | op-snap---monthly-publication-july-2025.pdf | 482 | 2025-07 | Car | Toyota | Auris | Red | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Birmingham | Birmingham | Education | N/A | 52.4669004 | -1.9011385 | ||
| 12436 | op-snap---monthly-publication-july-2025.pdf | 488 | 2025-07 | Car | Kia | EV 6.. | Grey | Driving without Due Care and Attention | None | Stourbridge Road (Halesowen) | Stourbridge Road (Halesowen) | Dudley | Dudley | Education | N/A | 52.4514773 | -2.0541796 | ||
| 12438 | op-snap---monthly-publication-july-2025.pdf | 490 | 2025-07 | Car | Mercedes-Benz | GLA 200 | Grey | Contravening a Red Traffic Light | None | Riland Road | Riland Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5634102 | -1.8161524 | ||
| 12439 | op-snap---monthly-publication-july-2025.pdf | 491 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A454 Wolverhampton | Wolverhampton | Wolverhampton | Wolverhampton | Education | N/A | 52.5879884 | -2.120242 | ||
| 12443 | op-snap---monthly-publication-july-2025.pdf | 495 | 2025-07 | Car | Fiat | 500 L | Black | Driving without Due Care and Attention | None | Garratts Lane | Garratts Lane | Sandwell | Sandwell | Education | N/A | 52.4783554 | -2.0611589 | ||
| 12446 | op-snap---monthly-publication-july-2025.pdf | 498 | 2025-07 | Car | Saab | Silver | Contravening a Red Traffic Light | None | Church Road | Church Road | Birmingham | Birmingham | Education | N/A | 52.4624743 | -1.7763934 | |||
| 12447 | op-snap---monthly-publication-july-2025.pdf | 499 | 2025-07 | Car | Audi | S3 | Black | Contravening a Red Traffic Light | None | Hayes Lane | Hayes Lane | Dudley | Dudley | Education | N/A | 52.4599414 | -2.1028651 | ||
| 12453 | op-snap---monthly-publication-july-2025.pdf | 505 | 2025-07 | Car | Ford | Fiesta | Orange | Contravening a Red Traffic Light | None | A4041 Queslett Road | Queslett Road | Birmingham | Birmingham | Education | N/A | 52.5458699 | -1.9304484 | ||
| 12455 | op-snap---monthly-publication-july-2025.pdf | 507 | 2025-07 | Car | BMW | White | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Education | N/A | 52.5194011 | -1.8008643 | |||
| 12464 | op-snap---monthly-publication-july-2025.pdf | 516 | 2025-07 | Car | Volkswagen | Caddy | Silver | Contravene Lane Closure Red X | None | A38M | A38M | Birmingham | Birmingham | Education | N/A | ||||
| 12475 | op-snap---monthly-publication-july-2025.pdf | 527 | 2025-07 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | A45 Dunchurch Highway | Dunchurch Highway | Coventry | Coventry | Education | N/A | 52.4131902 | -1.5650136 | ||
| 12479 | op-snap---monthly-publication-july-2025.pdf | 531 | 2025-07 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Education | N/A | 52.503036 | -1.8289972 | ||
| 12490 | op-snap---monthly-publication-july-2025.pdf | 542 | 2025-07 | Car | BMW | 118 | White | Contravening a Red Traffic Light | None | Sutton Road | Sutton Road | Walsall | Walsall | Education | N/A | 52.5612988 | -2.0522715 | ||
| 12503 | op-snap---monthly-publication-july-2025.pdf | 555 | 2025-07 | Car | Audi | Q5 | Grey | Driving without Due Care and Attention | None | M6 Motorway, Southbound, nr Jn4A | M6 Motorway, Southbound, nr Jn4A | Birmingham | Birmingham | Education | N/A | ||||
| 12515 | op-snap---monthly-publication-july-2025.pdf | 567 | 2025-07 | Car | Mercedes-Benz | C180 | Silver | Contravening a Red Traffic Light | None | Rosemary Hill Road | Rosemary Hill Road | Birmingham | Birmingham | Education | N/A | 52.5918569 | -1.8630817 | ||
| 12520 | op-snap---monthly-publication-july-2025.pdf | 572 | 2025-07 | Car | Vauxhall | White | Driving without Due Care and Attention | None | Newbury Lane | Newbury Lane | Sandwell | Sandwell | Education | N/A | 52.4994655 | -2.0285102 | |||
| 12527 | op-snap---monthly-publication-july-2025.pdf | 579 | 2025-07 | Car | BMW | M3 | Blue | Driving without Due Care and Attention | None | St Bernards | Street Bernards | Solihull | Solihull | Education | N/A | ||||
| 12534 | op-snap---monthly-publication-july-2025.pdf | 586 | 2025-07 | Car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | Sneyd Lane | Sneyd Lane | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 12545 | op-snap---monthly-publication-july-2025.pdf | 597 | 2025-07 | Car | Citroen | relay | White | Driving without Reasonable Consideration | None | Stonehouse Lane | Stonehouse Lane | Birmingham | Birmingham | Education | N/A | 52.4440435 | -1.9818872 | ||
| 12549 | op-snap---monthly-publication-july-2025.pdf | 601 | 2025-07 | Car | Mercedes-Benz | C220 | Grey | Contravening a Red Traffic Light | None | Norton Road | Norton Road | Walsall | Walsall | Education | N/A | 52.6260635 | -1.9672945 | ||
| 12550 | op-snap---monthly-publication-july-2025.pdf | 602 | 2025-07 | Car | Mercedes-Benz | 180 | Blue | Contravening a Red Traffic Light | None | Norton Road | Norton Road | Walsall | Walsall | Education | N/A | 52.6260635 | -1.9672945 | ||
| 12555 | op-snap---monthly-publication-july-2025.pdf | 607 | 2025-07 | Car | Peugeot | Grey | Driving without Due Care and Attention | None | Churchbridge | Churchbridge | Sandwell | Sandwell | Education | N/A | 52.4938109 | -2.0217545 | |||
| 12564 | op-snap---monthly-publication-july-2025.pdf | 616 | 2025-07 | Car | BMW | 1 series | White | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 12570 | op-snap---monthly-publication-july-2025.pdf | 622 | 2025-07 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Rabone Lane | Rabone Lane | Sandwell | Sandwell | Education | N/A | 52.496577 | -1.9614637 |
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);