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'}
460 rows where disposal = "Education" and month = "2026-02" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make >30
offence 11
- Driving without Due Care and Attention 191
- Stop a vehicle within pelican pedestrian crossing limits 99
- Contravening a Red Traffic Light 88
- Cause vehicle to be left in a dangerous position 38
- Stop a vehicle on pedestrian crossing 28
- Drive on hard shoulder 6
- Drive a vehicle other than on the carriageway of a motorway 3
- Driving without Reasonable Consideration 3
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2
- Contravene Lane Closure Red X 1
- Vehicle overtake within crossing limits 1
council_area 9
- Birmingham 301
- Coventry 51
- Dudley 26
- Sandwell 19
- Wolverhampton 17
- Solihull 16
- Sutton Coldfield 15
- Walsall 14
- Halesowen 1
reporter_transport_mode 7
- Car 278
- Pedal Bike 98
- Pedestrian 64
- Other 15
- Lorry 3
- Horse Rider 1
- car 1
month 1
- 2026-02 · 460 ✖
disposal 1
- Education · 460 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7257 | op-snap---monthly-publication-february-2026.pdf | 4 | 2026-02 | Car | Mazda | CX30 | Grey | Driving without Due Care and Attention | None | High Street, Quarry Bank | High Street, Quarry Bank | Dudley | Dudley | Education | N/A | 52.4576453 | -2.1150716 | ||
| 7260 | op-snap---monthly-publication-february-2026.pdf | 7 | 2026-02 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7262 | op-snap---monthly-publication-february-2026.pdf | 9 | 2026-02 | Car | Fiat | 500.. | Grey | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7265 | op-snap---monthly-publication-february-2026.pdf | 12 | 2026-02 | Car | Mercedes-Benz | CLA 180 | Black | Contravening a Red Traffic Light | None | Oak Tree Lane | Oak Tree Lane | Birmingham | Birmingham | Education | N/A | 52.431258 | -1.9394381 | ||
| 7268 | op-snap---monthly-publication-february-2026.pdf | 15 | 2026-02 | Car | Rolls-Royce | Blue | Contravening a Red Traffic Light | None | M6 J9 | M6 J9 | Walsall | Walsall | Education | N/A | 52.676119 | -2.0858425 | |||
| 7283 | op-snap---monthly-publication-february-2026.pdf | 30 | 2026-02 | Car | Nissan | Qashqai | White | Cause vehicle to be left in a dangerous position | None | Chantry Road | Chantry Road | Birmingham | Birmingham | Education | N/A | 52.4496376 | -1.8915224 | ||
| 7286 | op-snap---monthly-publication-february-2026.pdf | 33 | 2026-02 | Pedestrian | Hyundai | Ioniq 5 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Education | N/A | 52.4271614 | -1.9302862 | ||
| 7289 | op-snap---monthly-publication-february-2026.pdf | 36 | 2026-02 | Car | Mg | 6 S GT | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7292 | op-snap---monthly-publication-february-2026.pdf | 39 | 2026-02 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Knowle High Street | Knowle High Street | Coventry | Coventry | Education | N/A | ||||
| 7294 | op-snap---monthly-publication-february-2026.pdf | 41 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Education | N/A | 52.4119174 | -1.9735247 | ||
| 7296 | op-snap---monthly-publication-february-2026.pdf | 43 | 2026-02 | Pedestrian | Audi | A3.. | Black | Cause vehicle to be left in a dangerous position | None | Ulverscroft Road | Ulverscroft Road | Coventry | Coventry | Education | N/A | 52.3913543 | -1.508629 | ||
| 7297 | op-snap---monthly-publication-february-2026.pdf | 44 | 2026-02 | Pedal Bike | Toyota | Prius | Red | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7298 | op-snap---monthly-publication-february-2026.pdf | 45 | 2026-02 | Pedal Bike | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7299 | op-snap---monthly-publication-february-2026.pdf | 46 | 2026-02 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Franklin Road | Franklin Road | Birmingham | Birmingham | Education | N/A | 52.4195456 | -1.9350703 | ||
| 7303 | op-snap---monthly-publication-february-2026.pdf | 50 | 2026-02 | Pedestrian | Mercedes-Benz | C220 | Silver | Stop a vehicle on pedestrian crossing | None | Inverclyde Road | Inverclyde Road | Birmingham | Birmingham | Education | N/A | 52.5218439 | -1.9215045 | ||
| 7305 | op-snap---monthly-publication-february-2026.pdf | 52 | 2026-02 | Pedal Bike | BMW | Black | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | |||
| 7312 | op-snap---monthly-publication-february-2026.pdf | 59 | 2026-02 | Pedal Bike | BMW | 218i | Blue | Driving without Due Care and Attention | None | Bird Street at White Street | Bird Street at White Street | Coventry | Coventry | Education | N/A | 52.4124171 | -1.5065021 | ||
| 7316 | op-snap---monthly-publication-february-2026.pdf | 63 | 2026-02 | Pedestrian | Vauxhall | Corsa | Silver | Cause vehicle to be left in a dangerous position | None | Heeley Road | Heeley Road | Birmingham | Birmingham | Education | N/A | 52.4401847 | -1.9331572 | ||
| 7330 | op-snap---monthly-publication-february-2026.pdf | 77 | 2026-02 | Pedal Bike | Ford | Focus | Grey | Driving without Due Care and Attention | None | Trittiford Road | Trittiford Road | Birmingham | Birmingham | Education | N/A | 52.4248084 | -1.8660294 | ||
| 7335 | op-snap---monthly-publication-february-2026.pdf | 82 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7336 | op-snap---monthly-publication-february-2026.pdf | 83 | 2026-02 | Car | Audi | A4 | red | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7337 | op-snap---monthly-publication-february-2026.pdf | 84 | 2026-02 | Car | Volkswagen | Touran | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7339 | op-snap---monthly-publication-february-2026.pdf | 86 | 2026-02 | Car | Vauxhall | Adam | Red | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7341 | op-snap---monthly-publication-february-2026.pdf | 88 | 2026-02 | Car | Toyota | Corolla | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7343 | op-snap---monthly-publication-february-2026.pdf | 90 | 2026-02 | Car | Audi | A3 | Silver | Contravening a Red Traffic Light | None | Station Road | Station Road | Sandwell | Sandwell | Education | N/A | 52.4774652 | -2.0337514 | ||
| 7347 | op-snap---monthly-publication-february-2026.pdf | 94 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Streetly Road, Short Heath | Streetly Road, Short Heath | Birmingham | Birmingham | Education | N/A | 52.5316018 | -1.8581289 | ||
| 7348 | op-snap---monthly-publication-february-2026.pdf | 95 | 2026-02 | Car | Citroen | DS3 | Purple | Contravening a Red Traffic Light | None | Sir Herbert Austin Way | Sir Herbert Austin Way | Birmingham | Birmingham | Education | N/A | 52.4132666 | -1.9735631 | ||
| 7353 | op-snap---monthly-publication-february-2026.pdf | 100 | 2026-02 | Pedal Bike | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 7359 | op-snap---monthly-publication-february-2026.pdf | 106 | 2026-02 | Pedal Bike | Ford | Focus | Silver | Driving without Due Care and Attention | None | Greens Road | Greens Road | Coventry | Coventry | Education | N/A | 52.4381927 | -1.5291209 | ||
| 7365 | op-snap---monthly-publication-february-2026.pdf | 112 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Booth Street, Handsworth | Booth Street, Handsworth | Birmingham | Birmingham | Education | N/A | 52.5039035 | -1.9447084 | ||
| 7371 | op-snap---monthly-publication-february-2026.pdf | 118 | 2026-02 | Car | Land Rover | Evoque | Beige | Contravening a Red Traffic Light | None | Venture Way | Venture Way | Dudley | Dudley | Education | N/A | 52.4836603 | -2.1189326 | ||
| 7373 | op-snap---monthly-publication-february-2026.pdf | 120 | 2026-02 | Pedestrian | BMW | 116d | White | Cause vehicle to be left in a dangerous position | None | Ellesmere Road | Ellesmere Road | Birmingham | Birmingham | Education | N/A | 52.4881533 | -1.8553625 | ||
| 7375 | op-snap---monthly-publication-february-2026.pdf | 122 | 2026-02 | Pedestrian | Land Rover | Evoque | Grey | Cause vehicle to be left in a dangerous position | None | Roebuck Lane | Roebuck Lane | Sandwell | Sandwell | Education | N/A | 52.5027291 | -1.9781818 | ||
| 7376 | op-snap---monthly-publication-february-2026.pdf | 123 | 2026-02 | Pedal Bike | Hyundai | Ioniq | Black | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 7377 | op-snap---monthly-publication-february-2026.pdf | 124 | 2026-02 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Walmley Road | Walmley Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5405351 | -1.8002219 | ||
| 7379 | op-snap---monthly-publication-february-2026.pdf | 126 | 2026-02 | Car | Ford | Ecosport | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Clarkes Lane, West Bromwich | Clarkes Lane, West Bromwich | Sandwell | Sandwell | Education | N/A | ||||
| 7380 | op-snap---monthly-publication-february-2026.pdf | 127 | 2026-02 | Pedal Bike | Honda | Civic | Grey | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7381 | op-snap---monthly-publication-february-2026.pdf | 128 | 2026-02 | Pedal Bike | Volvo | V60 | Black | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7383 | op-snap---monthly-publication-february-2026.pdf | 130 | 2026-02 | Pedal Bike | Mercedes-Benz | 180 | Grey | Driving without Due Care and Attention | None | Weoley Castle | Weoley Castle | Birmingham | Birmingham | Education | N/A | 52.4428373 | -1.9698276 | ||
| 7384 | op-snap---monthly-publication-february-2026.pdf | 131 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 7385 | op-snap---monthly-publication-february-2026.pdf | 132 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7386 | op-snap---monthly-publication-february-2026.pdf | 133 | 2026-02 | Car | Ford | KA | Black | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 7390 | op-snap---monthly-publication-february-2026.pdf | 137 | 2026-02 | Car | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Church Street | Church Street | Birmingham | Birmingham | Education | N/A | 52.5020781 | -1.9122368 | ||
| 7391 | op-snap---monthly-publication-february-2026.pdf | 138 | 2026-02 | Car | Ford | Fiesta | Silver | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7398 | op-snap---monthly-publication-february-2026.pdf | 145 | 2026-02 | Pedal Bike | Hyundai | I30.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row Moseley | Street Marys Row Moseley | Birmingham | Birmingham | Education | N/A | ||||
| 7415 | op-snap---monthly-publication-february-2026.pdf | 162 | 2026-02 | Pedestrian | Nissan | X Trail | White | Stop a vehicle within pelican pedestrian crossing limits | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 7419 | op-snap---monthly-publication-february-2026.pdf | 166 | 2026-02 | Pedal Bike | Volvo | XC60 | White | Driving without Due Care and Attention | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Education | N/A | 52.4271614 | -1.9302862 | ||
| 7424 | op-snap---monthly-publication-february-2026.pdf | 171 | 2026-02 | Pedestrian | Honda | Civic | Silver | Cause vehicle to be left in a dangerous position | No Insurance | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Education | N/A | 52.4700545 | -1.834436 | ||
| 7425 | op-snap---monthly-publication-february-2026.pdf | 172 | 2026-02 | Car | Ford | Fiesta | Grey | Contravening a Red Traffic Light | None | Gravelly Hill | Gravelly Hill | Birmingham | Birmingham | Education | N/A | 52.5153884 | -1.8527437 | ||
| 7431 | op-snap---monthly-publication-february-2026.pdf | 178 | 2026-02 | Pedestrian | Audi | A4 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 7437 | op-snap---monthly-publication-february-2026.pdf | 184 | 2026-02 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | Mill Street | Mill Street | Dudley | Dudley | Education | N/A | 52.4779239 | -2.1561956 | ||
| 7446 | op-snap---monthly-publication-february-2026.pdf | 193 | 2026-02 | Pedestrian | Vauxhall | Corsa | Red | Cause vehicle to be left in a dangerous position | None | Dowar Road / Irvine Road | Dowar Road / Irvine Road | Birmingham | Birmingham | Education | N/A | 52.3932301 | -1.9992819 | ||
| 7447 | op-snap---monthly-publication-february-2026.pdf | 194 | 2026-02 | Pedestrian | BMW | 218I | White | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7448 | op-snap---monthly-publication-february-2026.pdf | 195 | 2026-02 | Pedestrian | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7454 | op-snap---monthly-publication-february-2026.pdf | 201 | 2026-02 | Pedal Bike | Volkswagen | Tayron | Grey | Driving without Due Care and Attention | None | Hallam Street | Hallam Street | Birmingham | Birmingham | Education | N/A | 52.4563937 | -1.8933429 | ||
| 7470 | op-snap---monthly-publication-february-2026.pdf | 217 | 2026-02 | Pedal Bike | Kia | Rio | Blue | Driving without Due Care and Attention | None | Ansty Road | Ansty Road | Coventry | Coventry | Education | N/A | 52.4205675 | -1.4520187 | ||
| 7471 | op-snap---monthly-publication-february-2026.pdf | 218 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7473 | op-snap---monthly-publication-february-2026.pdf | 220 | 2026-02 | Car | Mercedes-Benz | 312.. | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7474 | op-snap---monthly-publication-february-2026.pdf | 221 | 2026-02 | Pedestrian | Nissan | Note | Blue | Cause vehicle to be left in a dangerous position | None | Wills Street | Wills Street | Birmingham | Birmingham | Education | N/A | 52.500453 | -1.9141126 | ||
| 7477 | op-snap---monthly-publication-february-2026.pdf | 224 | 2026-02 | Car | Volkswagen | Golf R | Silver | Contravening a Red Traffic Light | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 7478 | op-snap---monthly-publication-february-2026.pdf | 225 | 2026-02 | Car | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Education | N/A | 52.5531351 | -1.8852761 | ||
| 7487 | op-snap---monthly-publication-february-2026.pdf | 234 | 2026-02 | Car | Seat | mii | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Hollyfield Road | Hollyfield Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5620486 | -1.8030784 | ||
| 7489 | op-snap---monthly-publication-february-2026.pdf | 236 | 2026-02 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 7496 | op-snap---monthly-publication-february-2026.pdf | 243 | 2026-02 | Car | Hyundai | I10 | Silver | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | Education | N/A | 52.4622646 | -1.8599985 | ||
| 7497 | op-snap---monthly-publication-february-2026.pdf | 244 | 2026-02 | Car | BMW | X1 | Blue | Driving without Due Care and Attention | None | Torcross Avenue | Torcross Avenue | Coventry | Coventry | Education | N/A | 52.4218194 | -1.46546 | ||
| 7498 | op-snap---monthly-publication-february-2026.pdf | 245 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Westwood WAY | Westwood WAY | Coventry | Coventry | Education | N/A | 52.3880214 | -1.5797132 | ||
| 7505 | op-snap---monthly-publication-february-2026.pdf | 252 | 2026-02 | Car | Seat | Cupra | Grey | Driving without Due Care and Attention | None | Sand Pits | Sand Pits | Birmingham | Birmingham | Education | N/A | ||||
| 7509 | op-snap---monthly-publication-february-2026.pdf | 256 | 2026-02 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Education | N/A | 52.50787 | -1.8195713 | ||
| 7513 | op-snap---monthly-publication-february-2026.pdf | 260 | 2026-02 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 7514 | op-snap---monthly-publication-february-2026.pdf | 261 | 2026-02 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Ridgacre Road | Ridgacre Road | Birmingham | Birmingham | Education | N/A | 52.4593367 | -2.0000298 | ||
| 7517 | op-snap---monthly-publication-february-2026.pdf | 264 | 2026-02 | Pedal Bike | Jaguar | i-Pace | Black | Driving without Due Care and Attention | None | South Road, Stourbridge | South Road, Stourbridge | Dudley | Dudley | Education | N/A | 52.4530371 | -2.1660216 | ||
| 7528 | op-snap---monthly-publication-february-2026.pdf | 275 | 2026-02 | Pedal Bike | Audi | SQ5 | Blue | Contravening a Red Traffic Light | None | Longmore Street | Longmore Street | Birmingham | Birmingham | Education | N/A | 52.464484 | -1.8923374 | ||
| 7532 | op-snap---monthly-publication-february-2026.pdf | 279 | 2026-02 | Car | Lexus | CT200 | White | Driving without Due Care and Attention | None | Cross Street South | Cross Street South | Wolverhampton | Wolverhampton | Education | N/A | 52.570955 | -2.130838 | ||
| 7535 | op-snap---monthly-publication-february-2026.pdf | 282 | 2026-02 | Car | Peugeot | 206 | Silver | Driving without Due Care and Attention | None | Winding House Lane | Winding House Lane | Coventry | Coventry | Education | N/A | 52.4490457 | -1.5001195 | ||
| 7536 | op-snap---monthly-publication-february-2026.pdf | 283 | 2026-02 | Pedal Bike | Mercedes-Benz | ML320 | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 7538 | op-snap---monthly-publication-february-2026.pdf | 285 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Education | N/A | 52.418488 | -1.5472387 | ||
| 7569 | op-snap---monthly-publication-february-2026.pdf | 316 | 2026-02 | Pedestrian | Volkswagen | Sharan | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Popular Road | Popular Road | Birmingham | Birmingham | Education | N/A | 52.454374 | -1.8774689 | ||
| 7572 | op-snap---monthly-publication-february-2026.pdf | 319 | 2026-02 | Car | BMW | 325D | Black | Contravening a Red Traffic Light | None | Danford Lane at Blossomfield Road | Danford Lane at Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 7575 | op-snap---monthly-publication-february-2026.pdf | 322 | 2026-02 | Other | Seat | Alteca | Grey | Driving without Due Care and Attention | None | Orphange Road / Chester Road | Orphange Road / Chester Road | Birmingham | Birmingham | Education | N/A | ||||
| 7577 | op-snap---monthly-publication-february-2026.pdf | 324 | 2026-02 | Pedal Bike | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Bromyard Road | Bromyard Road | Birmingham | Birmingham | Education | N/A | 52.4457403 | -1.8536648 | ||
| 7578 | op-snap---monthly-publication-february-2026.pdf | 325 | 2026-02 | Pedal Bike | Nissan | Note | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 | ||
| 7579 | op-snap---monthly-publication-february-2026.pdf | 326 | 2026-02 | Car | Kia | Xceed | Grey | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Education | N/A | 52.5478387 | -2.0943116 | ||
| 7580 | op-snap---monthly-publication-february-2026.pdf | 327 | 2026-02 | Car | Honda | CR-V | Blue | Contravening a Red Traffic Light | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 7582 | op-snap---monthly-publication-february-2026.pdf | 329 | 2026-02 | Car | Dennis | Green | Cause vehicle to be left in a dangerous position | None | Tinkers Farm Road | Tinkers Farm Road | Birmingham | Birmingham | Education | N/A | 52.4124264 | -1.981477 | |||
| 7585 | op-snap---monthly-publication-february-2026.pdf | 332 | 2026-02 | Car | Land Rover | Land Rover | Blue | Contravening a Red Traffic Light | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 7596 | op-snap---monthly-publication-february-2026.pdf | 343 | 2026-02 | Car | Citroen | C3.. | White | Driving without Due Care and Attention | None | New John Street West | New John Street West | Birmingham | Birmingham | Education | N/A | 52.4944784 | -1.9122329 | ||
| 7598 | op-snap---monthly-publication-february-2026.pdf | 345 | 2026-02 | Pedestrian | Ford | Fiesta | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7599 | op-snap---monthly-publication-february-2026.pdf | 346 | 2026-02 | Pedestrian | BMW | X Drive | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7603 | op-snap---monthly-publication-february-2026.pdf | 350 | 2026-02 | Car | Hyundai | 130 | Blue | Driving without Due Care and Attention | None | A46 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 7606 | op-snap---monthly-publication-february-2026.pdf | 353 | 2026-02 | Pedestrian | Cupra | Formentor | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Poplar Road Kings Heath | Poplar Road Kings Heath | Birmingham | Birmingham | Education | N/A | 52.436035 | -1.891685 | ||
| 7619 | op-snap---monthly-publication-february-2026.pdf | 366 | 2026-02 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 7620 | op-snap---monthly-publication-february-2026.pdf | 367 | 2026-02 | Pedestrian | Nissan | Qashai | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Church Road | Church Road | Birmingham | Birmingham | Education | N/A | 52.4624743 | -1.7763934 | ||
| 7625 | op-snap---monthly-publication-february-2026.pdf | 372 | 2026-02 | Car | Mercedes-Benz | CLA 220 | Red | Driving without Due Care and Attention | None | Coventry A45 W | Coventry A45 W | Coventry | Coventry | Education | N/A | 52.4314215 | -1.5948907 | ||
| 7626 | op-snap---monthly-publication-february-2026.pdf | 373 | 2026-02 | Other | Alfa Romeo | Giulietta | Blue | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 7634 | op-snap---monthly-publication-february-2026.pdf | 381 | 2026-02 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Education | N/A | 52.4096725 | -1.487901 | ||
| 7635 | op-snap---monthly-publication-february-2026.pdf | 382 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Tettenhall | High Street Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 7641 | op-snap---monthly-publication-february-2026.pdf | 388 | 2026-02 | Car | Peugeot | 408 | Silver | Driving without Due Care and Attention | None | Monmouth Drive | Monmouth Drive | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5575249 | -1.8640053 | ||
| 7644 | op-snap---monthly-publication-february-2026.pdf | 391 | 2026-02 | Car | Ford | Transit Connect | Black | Driving without Due Care and Attention | None | Ambergate Road / Highfield Rd, Bilston | Ambergate Road / Highfield Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5597351 | -2.081298 | ||
| 7645 | op-snap---monthly-publication-february-2026.pdf | 392 | 2026-02 | Pedestrian | Audi | RSQ8 | Black | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7649 | op-snap---monthly-publication-february-2026.pdf | 396 | 2026-02 | Car | Volkswagen | Polo | Silver | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 |
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);