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'}
229 rows where disposal = "Education" and month = "2025-10" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 30
offence 12
- Driving without Due Care and Attention 128
- Contravening a Red Traffic Light 82
- Drive a vehicle other than on the carriageway of a motorway 5
- Driving without Reasonable Consideration 4
- Cause vehicle to be left in a dangerous position 3
- Contravene Lane Closure Red X 1
- Drive on hard shoulder 1
- Driver not in position to have Proper Control 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Prohibited vehicle in offside lane of motorway 1
- Stop a vehicle within pelican pedestrian crossing limits 1
council_area 8
- Birmingham 129
- Coventry 27
- Wolverhampton 16
- Walsall 14
- Solihull 13
- Sandwell 12
- Dudley 10
- Sutton Coldfield 8
reporter_transport_mode 5
- Car 154
- Pedal Bike 64
- Pedestrian 6
- Lorry 4
- Van 1
month 1
- 2025-10 · 229 ✖
disposal 1
- Education · 229 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22051 | op-snap---monthly-publication-october-2025.pdf | 1 | 2025-10 | Car | Audi | Q7 | Black | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Education | N/A | 52.5531351 | -1.8852761 | ||
| 22052 | op-snap---monthly-publication-october-2025.pdf | 2 | 2025-10 | Car | Citroen | DS3 | Black | Contravening a Red Traffic Light | Driving without Due Care and Attention | Dudley Port | Dudley Port | Sandwell | Sandwell | Education | N/A | 52.524461 | -2.0492538 | ||
| 22057 | op-snap---monthly-publication-october-2025.pdf | 7 | 2025-10 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bilston Street Island | Bilston Street Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5834806 | -2.1204011 | ||
| 22079 | op-snap---monthly-publication-october-2025.pdf | 29 | 2025-10 | Pedal Bike | Mercedes-Benz | E320 | Silver | Driving without Due Care and Attention | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Education | N/A | 52.4381959 | -1.8907391 | ||
| 22080 | op-snap---monthly-publication-october-2025.pdf | 30 | 2025-10 | Car | Toyota | Aygo | White | Driving without Due Care and Attention | None | Haden Circus | Haden Circus | Birmingham | Birmingham | Education | N/A | 52.46284 | -1.8867453 | ||
| 22082 | op-snap---monthly-publication-october-2025.pdf | 32 | 2025-10 | Car | Hyundai | I10 | Red | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 22083 | op-snap---monthly-publication-october-2025.pdf | 33 | 2025-10 | Pedal Bike | Nissan | Note | Blue | Driving without Due Care and Attention | None | Inchlaggan Road | Inchlaggan Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6049304 | -2.10742 | ||
| 22087 | op-snap---monthly-publication-october-2025.pdf | 37 | 2025-10 | Pedal Bike | Nissan | X-Trail | Black | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 22096 | op-snap---monthly-publication-october-2025.pdf | 46 | 2025-10 | Pedal Bike | Mercedes-Benz | CLA 250 | Grey | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 22098 | op-snap---monthly-publication-october-2025.pdf | 48 | 2025-10 | Car | Volkswagen | Caddy | White | Contravening a Red Traffic Light | None | A5127 Sutton ring road | Sutton ring road | Sutton Coldfield | Sutton Coldfield | Education | N/A | ||||
| 22099 | op-snap---monthly-publication-october-2025.pdf | 49 | 2025-10 | Pedal Bike | Ford | B Max | Black | Driving without Due Care and Attention | None | Umberslade Road | Umberslade Road | Birmingham | Birmingham | Education | N/A | 52.4304526 | -1.9216716 | ||
| 22101 | op-snap---monthly-publication-october-2025.pdf | 51 | 2025-10 | Car | Seat | Arona | Silver | Contravening a Red Traffic Light | None | Cole Hill Lane | Cole Hill Lane | Birmingham | Birmingham | Education | N/A | 52.4951084 | -1.7913851 | ||
| 22108 | op-snap---monthly-publication-october-2025.pdf | 58 | 2025-10 | Pedal Bike | Yamaha | R6 | Blue | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 22110 | op-snap---monthly-publication-october-2025.pdf | 60 | 2025-10 | Pedal Bike | Volkswagen | Transporter | Grey | Driving without Due Care and Attention | None | Earlsdon Av | Earlsdon Avenue | Coventry | Coventry | Education | N/A | 52.4047134 | -1.5351834 | ||
| 22112 | op-snap---monthly-publication-october-2025.pdf | 62 | 2025-10 | Pedal Bike | Audi | Q2 | Grey | Driving without Due Care and Attention | None | Five Ways Roundabout | Five Ways Roundabout | Birmingham | Birmingham | Education | N/A | ||||
| 22119 | op-snap---monthly-publication-october-2025.pdf | 69 | 2025-10 | Car | Fiat | Panda | White | Driving without Due Care and Attention | None | Knighton Road | Knighton Road | Birmingham | Birmingham | Education | N/A | 52.5982705 | -1.8541228 | ||
| 22120 | op-snap---monthly-publication-october-2025.pdf | 70 | 2025-10 | Car | Mercedes-Benz | AMG | Black | Drive a vehicle other than on the carriageway of a motorway | None | A38M | A38M | Birmingham | Birmingham | Education | n/a | ||||
| 22126 | op-snap---monthly-publication-october-2025.pdf | 76 | 2025-10 | Car | BMW | 320 | White | Contravening a Red Traffic Light | None | Calthorpe Road | Calthorpe Road | Birmingham | Birmingham | Education | N/A | 52.5142235 | -1.9073557 | ||
| 22133 | op-snap---monthly-publication-october-2025.pdf | 83 | 2025-10 | Car | Suzuki | Celerio | Red | Contravening a Red Traffic Light | None | Aldersley Road | Aldersley Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6058472 | -2.1521123 | ||
| 22141 | op-snap---monthly-publication-october-2025.pdf | 91 | 2025-10 | Car | Toyota | Yaris | Silver | Contravening a Red Traffic Light | None | Water Orton Road | Water Orton Road | Birmingham | Birmingham | Education | N/A | 52.5153394 | -1.7573409 | ||
| 22144 | op-snap---monthly-publication-october-2025.pdf | 94 | 2025-10 | Car | Vauxhall | Mokka | Red | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 22155 | op-snap---monthly-publication-october-2025.pdf | 105 | 2025-10 | Car | Fiat | 500l | Red | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 22158 | op-snap---monthly-publication-october-2025.pdf | 108 | 2025-10 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Connaught Road | Connaught Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5876226 | -2.1426533 | ||
| 22165 | op-snap---monthly-publication-october-2025.pdf | 115 | 2025-10 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | City Road | City Road | Birmingham | Birmingham | Education | N/A | 52.4763176 | -1.9584897 | ||
| 22166 | op-snap---monthly-publication-october-2025.pdf | 116 | 2025-10 | Car | Mercedes-Benz | GLB 200 | Grey | Contravening a Red Traffic Light | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Education | N/A | 52.4520441 | -1.8787544 | ||
| 22167 | op-snap---monthly-publication-october-2025.pdf | 117 | 2025-10 | Car | Peugeot | boxer | White | Drive on hard shoulder | None | Salford Circus | Salford Circus | Birmingham | Birmingham | Education | N/A | 52.5095071 | -1.8593732 | ||
| 22169 | op-snap---monthly-publication-october-2025.pdf | 119 | 2025-10 | Car | Vauxhall | Grandland | Black | Contravening a Red Traffic Light | None | Trindle Road | Trindle Road | Dudley | Dudley | Education | N/A | 52.5126263 | -2.0755358 | ||
| 22171 | op-snap---monthly-publication-october-2025.pdf | 121 | 2025-10 | Pedestrian | Yamaha | GPD 125 | White | Driving without Due Care and Attention | None | Lyon Queensway | Lyon Queensway | Birmingham | Birmingham | Education | N/A | 52.4785129 | -1.9047486 | ||
| 22180 | op-snap---monthly-publication-october-2025.pdf | 130 | 2025-10 | Pedestrian | Volkswagen | Passat | Grey | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22183 | op-snap---monthly-publication-october-2025.pdf | 133 | 2025-10 | Car | Land Rover | Range Over | Black | Contravening a Red Traffic Light | None | A452 Collector Road | Collector Road | Birmingham | Birmingham | Education | N/A | 52.5139393 | -1.7600186 | ||
| 22198 | op-snap---monthly-publication-october-2025.pdf | 148 | 2025-10 | Car | Ford | Fiesta | Red | Driving without Reasonable Consideration | None | A4053 RIng Road | A4053 RIng Road | Coventry | Coventry | Education | N/A | ||||
| 22208 | op-snap---monthly-publication-october-2025.pdf | 158 | 2025-10 | Car | Ford | Mustang | Grey | Contravening a Red Traffic Light | None | A41 Soho Hill | Soho Hill | Birmingham | Birmingham | Education | N/A | 52.4983151 | -1.9186252 | ||
| 22216 | op-snap---monthly-publication-october-2025.pdf | 166 | 2025-10 | Car | Vauxhall | Zafira | Black | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 22225 | op-snap---monthly-publication-october-2025.pdf | 175 | 2025-10 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 22233 | op-snap---monthly-publication-october-2025.pdf | 183 | 2025-10 | Car | Toyota | Black | Driving without Due Care and Attention | None | Broadway West | Broadway West | Walsall | Walsall | Education | N/A | 52.5698309 | -1.9942176 | |||
| 22237 | op-snap---monthly-publication-october-2025.pdf | 187 | 2025-10 | Pedal Bike | BMW | 320.. | Black | Driving without Due Care and Attention | None | Longford Road | Longford Road | Birmingham | Birmingham | Education | N/A | 52.5524121 | -1.8764968 | ||
| 22242 | op-snap---monthly-publication-october-2025.pdf | 192 | 2025-10 | Car | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Wheelwright Road | Wheelwright Road | Birmingham | Birmingham | Education | N/A | 52.5094106 | -1.8373043 | ||
| 22248 | op-snap---monthly-publication-october-2025.pdf | 198 | 2025-10 | Car | Audi | Q4 | Blue | Driving without Due Care and Attention | None | Meadway | Meadway | Birmingham | Birmingham | Education | N/A | 52.4783348 | -1.8007708 | ||
| 22251 | op-snap---monthly-publication-october-2025.pdf | 201 | 2025-10 | Car | Tesla | Model Y | White | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 22264 | op-snap---monthly-publication-october-2025.pdf | 214 | 2025-10 | Pedestrian | Mercedes-Benz | vito | White | Stop a vehicle within pelican pedestrian crossing limits | None | Allens Croft | Allens Croft | Birmingham | Birmingham | Education | N/A | 52.421113 | -1.9142342 | ||
| 22265 | op-snap---monthly-publication-october-2025.pdf | 215 | 2025-10 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Garratts Green Lane | Garratts Green Lane | Birmingham | Birmingham | Education | N/A | ||||
| 22266 | op-snap---monthly-publication-october-2025.pdf | 216 | 2025-10 | Car | Porsche | Panamera | White | Driving without Due Care and Attention | None | A452 Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 22269 | op-snap---monthly-publication-october-2025.pdf | 219 | 2025-10 | Car | Yamaha | 125 | Grey | Driving without Due Care and Attention | None | Dudley Street | Dudley Street | Birmingham | Birmingham | Education | N/A | 52.4765075 | -1.897018 | ||
| 22277 | op-snap---monthly-publication-october-2025.pdf | 227 | 2025-10 | Car | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | Education | N/A | 52.5461417 | -1.9334193 | ||
| 22280 | op-snap---monthly-publication-october-2025.pdf | 230 | 2025-10 | Car | Hyundai | I30 | Blue | Driving without Due Care and Attention | None | Russell Road | Russell Road | Birmingham | Birmingham | Education | N/A | 52.4398245 | -1.8469786 | ||
| 22286 | op-snap---monthly-publication-october-2025.pdf | 236 | 2025-10 | Pedal Bike | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Friday Lane | Friday Lane | Solihull | Solihull | Education | N/A | 52.4142542 | -1.7217662 | ||
| 22290 | op-snap---monthly-publication-october-2025.pdf | 240 | 2025-10 | Car | Volkswagen | Crafter | White | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Hobs Moat Road | Hobs Moat Road | Solihull | Solihull | Education | N/A | 52.4497735 | -1.7831925 | ||
| 22294 | op-snap---monthly-publication-october-2025.pdf | 244 | 2025-10 | Car | Toyota | Yaris | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | ||
| 22304 | op-snap---monthly-publication-october-2025.pdf | 254 | 2025-10 | Car | Volkswagen | Transporter | Grey | Driving without Due Care and Attention | None | Warstones Road / Coalway Road, Penn | Warstones Road / Coalway Road, Penn | Wolverhampton | Wolverhampton | Education | N/A | 52.5687693 | -2.1613924 | ||
| 22308 | op-snap---monthly-publication-october-2025.pdf | 258 | 2025-10 | Car | Nissan | Juke | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 22311 | op-snap---monthly-publication-october-2025.pdf | 261 | 2025-10 | Pedal Bike | Toyota | Aygo | Red | Driving without Due Care and Attention | None | Corporation Road | Corporation Road | Coventry | Coventry | Education | N/A | ||||
| 22317 | op-snap---monthly-publication-october-2025.pdf | 267 | 2025-10 | Car | Mercedes-Benz | A Class | Black | Driving without Due Care and Attention | None | Camp Hill Island | Camp Hill Island | Birmingham | Birmingham | Education | N/A | ||||
| 22319 | op-snap---monthly-publication-october-2025.pdf | 269 | 2025-10 | Car | Nissan | Xtrail | Blue | Driving without Due Care and Attention | None | Nursery Road | Nursery Road | Birmingham | Birmingham | Education | N/A | 52.4979836 | -1.9118163 | ||
| 22324 | op-snap---monthly-publication-october-2025.pdf | 274 | 2025-10 | Pedal Bike | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Edgbaston Park Road | Edgbaston Park Road | Birmingham | Birmingham | Education | N/A | 52.4580375 | -1.9261777 | ||
| 22332 | op-snap---monthly-publication-october-2025.pdf | 282 | 2025-10 | Car | Volkswagen | Passat | White | Driving without Due Care and Attention | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Education | N/A | 52.4745488 | -1.8065911 | ||
| 22350 | op-snap---monthly-publication-october-2025.pdf | 300 | 2025-10 | Pedestrian | Land Rover | Velar | Silver | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22367 | op-snap---monthly-publication-october-2025.pdf | 317 | 2025-10 | Car | Ford | Blue | Drive a vehicle other than on the carriageway of a motorway | None | M6 Motorway J10 | M6 Motorway J10 | Walsall | Walsall | Education | N/A | |||||
| 22369 | op-snap---monthly-publication-october-2025.pdf | 319 | 2025-10 | Car | Ford | Fusion | Blue | Driving without Due Care and Attention | None | A435 Hollywood Bypass | Hollywood Bypass | Birmingham | Birmingham | Education | N/A | ||||
| 22377 | op-snap---monthly-publication-october-2025.pdf | 327 | 2025-10 | Pedal Bike | Mercedes-Benz | GLB | Black | Driving without Due Care and Attention | None | Constance Road, Edgbaston | Constance Road, Edgbaston | Birmingham | Birmingham | Education | N/A | 52.45815 | -1.9008028 | ||
| 22378 | op-snap---monthly-publication-october-2025.pdf | 328 | 2025-10 | Car | Mercedes-Benz | van | White | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Education | N/A | 52.4668753 | -1.8996143 | ||
| 22381 | op-snap---monthly-publication-october-2025.pdf | 331 | 2025-10 | Car | Peugeot | Partner | White | Contravening a Red Traffic Light | No vehicle excise licence | High Street Cape Hill | High Street Cape Hill | Sandwell | Sandwell | Education | N/A | 52.4903229 | -1.9673591 | ||
| 22383 | op-snap---monthly-publication-october-2025.pdf | 333 | 2025-10 | Pedestrian | Fiat | Scudo | Silver | Cause vehicle to be left in a dangerous position | None | Hobbs Road | Hobbs Road | Walsall | Walsall | Education | N/A | ||||
| 22392 | op-snap---monthly-publication-october-2025.pdf | 342 | 2025-10 | Car | Ford | KA | Silver | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Birmingham | Birmingham | Education | N/A | 52.505233 | -1.9446276 | ||
| 22395 | op-snap---monthly-publication-october-2025.pdf | 345 | 2025-10 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Education | N/A | 52.5194011 | -1.8008643 | ||
| 22405 | op-snap---monthly-publication-october-2025.pdf | 355 | 2025-10 | Pedal Bike | Ford | Transit | white | Driving without Due Care and Attention | None | Clevedon Road | Clevedon Road | Birmingham | Birmingham | Education | N/A | 52.4618531 | -1.894645 | ||
| 22408 | op-snap---monthly-publication-october-2025.pdf | 358 | 2025-10 | Pedal Bike | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Cartland Road | Cartland Road | Birmingham | Birmingham | Education | N/A | 52.4298554 | -1.9086629 | ||
| 22413 | op-snap---monthly-publication-october-2025.pdf | 363 | 2025-10 | Car | BMW | 330.. | Blue | Driving without Due Care and Attention | None | Birches Barn Road | Birches Barn Road | Wolverhampton | Wolverhampton | Education | N/A | 52.5716962 | -2.1462935 | ||
| 22415 | op-snap---monthly-publication-october-2025.pdf | 365 | 2025-10 | Pedal Bike | Vauxhall | Grandland | White | Driving without Due Care and Attention | None | A452 Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 22423 | op-snap---monthly-publication-october-2025.pdf | 373 | 2025-10 | Car | Peugeot | 207XR | Silver | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 22425 | op-snap---monthly-publication-october-2025.pdf | 375 | 2025-10 | Car | Volvo | VC90 | Grey | Driving without Due Care and Attention | None | A45 Birmingham Road | Birmingham Road | Coventry | Coventry | Education | N/A | 52.4272882 | -1.5753221 | ||
| 22431 | op-snap---monthly-publication-october-2025.pdf | 381 | 2025-10 | Pedal Bike | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Balsall Street | Balsall Street | Solihull | Solihull | Education | N/A | 52.3826029 | -1.6998649 | ||
| 22438 | op-snap---monthly-publication-october-2025.pdf | 388 | 2025-10 | Car | Audi | A5 | Grey | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 22439 | op-snap---monthly-publication-october-2025.pdf | 389 | 2025-10 | Car | Mercedes-Benz | GLC 300 | Black | Driving without Due Care and Attention | None | Hainge Road | Hainge Road | Sandwell | Sandwell | Education | N/A | 52.511993 | -2.0394885 | ||
| 22447 | op-snap---monthly-publication-october-2025.pdf | 397 | 2025-10 | Pedal Bike | Volkswagen | Polo | Orange | Driving without Due Care and Attention | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Education | N/A | 52.417344 | -1.5264979 | ||
| 22453 | op-snap---monthly-publication-october-2025.pdf | 403 | 2025-10 | Pedal Bike | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Streetsbrook Road | Streetsbrook Road | Birmingham | Birmingham | Education | N/A | 52.4223176 | -1.8253145 | ||
| 22466 | op-snap---monthly-publication-october-2025.pdf | 416 | 2025-10 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Wood Green Road | Wood Green Road | Walsall | Walsall | Education | N/A | 52.6248989 | -1.9343969 | ||
| 22467 | op-snap---monthly-publication-october-2025.pdf | 417 | 2025-10 | Car | Mercedes-Benz | A200 | Red | Driving without Due Care and Attention | None | Barnsley Road | Barnsley Road | Sandwell | Sandwell | Education | N/A | 52.4743497 | -1.965737 | ||
| 22468 | op-snap---monthly-publication-october-2025.pdf | 418 | 2025-10 | Car | Skoda | Octavia | Black | Contravening a Red Traffic Light | None | Allard Way | Allard Way | Coventry | Coventry | Education | N/A | 52.3955174 | -1.4685442 | ||
| 22470 | op-snap---monthly-publication-october-2025.pdf | 420 | 2025-10 | Lorry | BMW | 320i | Black | Contravening a Red Traffic Light | None | Summer Lane | Summer Lane | Birmingham | Birmingham | Education | N/A | 52.4948034 | -1.8983555 | ||
| 22482 | op-snap---monthly-publication-october-2025.pdf | 432 | 2025-10 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Walstead Road | Walstead Road | Walsall | Walsall | Education | N/A | 52.5648629 | -1.9517624 | ||
| 22489 | op-snap---monthly-publication-october-2025.pdf | 439 | 2025-10 | Car | Volvo | lorry | White | Prohibited vehicle in offside lane of motorway | None | M5 Motorway (southbound) | M5 Motorway (southbound) | Sandwell | Sandwell | Education | N/A | ||||
| 22490 | op-snap---monthly-publication-october-2025.pdf | 440 | 2025-10 | Pedal Bike | Toyota | Yaris | White | Driver not in position to have Proper Control | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Education | N/A | 52.4381959 | -1.8907391 | ||
| 22495 | op-snap---monthly-publication-october-2025.pdf | 445 | 2025-10 | Car | Hyundai | I10 | Grey | Driving without Due Care and Attention | None | Stonebridge Island | Stonebridge Island | Solihull | Solihull | Education | N/A | 52.445911 | -1.68657 | ||
| 22498 | op-snap---monthly-publication-october-2025.pdf | 448 | 2025-10 | Car | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Broadway | Broadway | Walsall | Walsall | Education | N/A | 52.5719937 | -1.9639882 | ||
| 22504 | op-snap---monthly-publication-october-2025.pdf | 454 | 2025-10 | Car | Audi | A4 | Black | Driving without Due Care and Attention | None | Fern Road, Erdington | Fern Road, Erdington | Birmingham | Birmingham | Education | N/A | 52.5215217 | -1.8359393 | ||
| 22508 | op-snap---monthly-publication-october-2025.pdf | 458 | 2025-10 | Car | Mini | Countryman | white | Driving without Due Care and Attention | None | Enville Road / High Street, Wall Heath | Enville Road / High Street, Wall Heath | Dudley | Dudley | Education | N/A | 52.5239908 | -2.1262445 | ||
| 22509 | op-snap---monthly-publication-october-2025.pdf | 459 | 2025-10 | Pedal Bike | Subaru | Blue | Driving without Due Care and Attention | None | Holders Lane | Holders Lane | Birmingham | Birmingham | Education | N/A | 52.4446701 | -1.9056872 | |||
| 22511 | op-snap---monthly-publication-october-2025.pdf | 461 | 2025-10 | Pedal Bike | Vauxhall | Insignia | Silver | Driving without Due Care and Attention | None | Redhill Road | Redhill Road | Birmingham | Birmingham | Education | N/A | 52.4618364 | -1.8328803 | ||
| 22517 | op-snap---monthly-publication-october-2025.pdf | 467 | 2025-10 | Car | Cupra | Formentor | Grey | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 22520 | op-snap---monthly-publication-october-2025.pdf | 470 | 2025-10 | Car | Mercedes-Benz | A Class | Grey | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 22525 | op-snap---monthly-publication-october-2025.pdf | 475 | 2025-10 | Car | Honda | Jazz | White | Contravening a Red Traffic Light | None | A452 | A452 | Birmingham | Birmingham | Education | N/A | ||||
| 22545 | op-snap---monthly-publication-october-2025.pdf | 495 | 2025-10 | Car | Vauxhall | Corsa | Grey | Contravene Lane Closure Red X | None | A38 | A38 | Birmingham | Birmingham | Education | N/A | ||||
| 22549 | op-snap---monthly-publication-october-2025.pdf | 499 | 2025-10 | Car | Peugeot | 208 | grey | Contravening a Red Traffic Light | None | Lode Lane | Lode Lane | Solihull | Solihull | Education | N/A | 52.4149064 | -1.7832364 | ||
| 22550 | op-snap---monthly-publication-october-2025.pdf | 500 | 2025-10 | Car | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | Stoneleigh Road | Stoneleigh Road | Coventry | Coventry | Education | N/A | 52.3698519 | -1.5482742 | ||
| 22552 | op-snap---monthly-publication-october-2025.pdf | 502 | 2025-10 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Sandy Lane | Sandy Lane | Coventry | Coventry | Education | N/A | 52.4172858 | -1.5134012 | ||
| 22563 | op-snap---monthly-publication-october-2025.pdf | 513 | 2025-10 | Car | Hyundai | I20 | Red | Contravening a Red Traffic Light | None | A452 | A452 | Birmingham | Birmingham | Education | N/A | ||||
| 22564 | op-snap---monthly-publication-october-2025.pdf | 514 | 2025-10 | Car | Audi | Q2 | Black | Driving without Due Care and Attention | None | Tyburn Island | Tyburn Island | Birmingham | Birmingham | Education | N/A | 52.5193542 | -1.800381 | ||
| 22570 | op-snap---monthly-publication-october-2025.pdf | 520 | 2025-10 | Car | Peugeot | Horizon | Grey | Contravening a Red Traffic Light | None | A4150N / Bilston Island | A4150N / Bilston Island | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 22572 | op-snap---monthly-publication-october-2025.pdf | 522 | 2025-10 | Car | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Oxford Street Island | Oxford Street Island | Wolverhampton | Wolverhampton | Education | N/A | 52.5649947 | -2.07061 | ||
| 22575 | op-snap---monthly-publication-october-2025.pdf | 525 | 2025-10 | Pedal Bike | Vauxhall | Vivaro | Blue | Driving without Due Care and Attention | None | Wagon Lane | Wagon Lane | Birmingham | Birmingham | Education | N/A | 52.4546868 | -1.793848 |
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);