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'}
196 rows where month = "2025-09" and reporter_transport_mode = "Pedal Bike" 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 13
- Driving without Due Care and Attention 94
- Cause unnecessary obstruction by motor vehicle 30
- Using a Mobile Phone Whilst Driving 28
- Driving without Reasonable Consideration 19
- Misc - Non Traffic Offences 9
- Motor vehicle fail to comply with a non endorsab 5
- Contravening a Red Traffic Light 3
- Cause vehicle to be left in a dangerous position 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with endorsable sect 1
- Stop a vehicle within pelican pedestrian crossing l 1
- Use a vehicle / cycle on a road and contravene a l 1
council_area 9
- Birmingham 79
- Wolverhampton 36
- Coventry 33
- Out of Force Area 12
- Solihull 9
- Sandwell 8
- Dudley 7
- Sutton Coldfield 6
- Walsall 6
disposal 6
- Education 57
- NFA 47
- Warning Letter 43
- Fixed Penalty 28
- Other Action Taken 14
- Court 7
reporter_transport_mode 1
- Pedal Bike · 196 ✖
month 1
- 2025-09 · 196 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23788 | op-snap---monthly-publication-september-2025.pdf | 7 | 2025-09 | Pedal Bike | Mercedes-Benz | Sprinter | Silver | Driving without Due Care and Attention | None | Moor Green lane | Moor Green lane | Birmingham | Birmingham | Education | N/A | 52.4374665 | -1.9119895 | ||
| 23791 | op-snap---monthly-publication-september-2025.pdf | 10 | 2025-09 | Pedal Bike | Nissan | NV400 | White | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 23800 | op-snap---monthly-publication-september-2025.pdf | 19 | 2025-09 | Pedal Bike | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | West Heath Road | West Heath Road | Birmingham | Birmingham | Education | N/A | 52.402785 | -1.9620058 | ||
| 23801 | op-snap---monthly-publication-september-2025.pdf | 20 | 2025-09 | Pedal Bike | BMW | Blue | Driving without Reasonable Consideration | None | West Heath Road | West Heath Road | Birmingham | Birmingham | Education | N/A | 52.402785 | -1.9620058 | |||
| 23802 | op-snap---monthly-publication-september-2025.pdf | 21 | 2025-09 | Pedal Bike | Kia | Sportage | Green | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Birmingham | Birmingham | Education | N/A | 52.4669004 | -1.9011385 | ||
| 23814 | op-snap---monthly-publication-september-2025.pdf | 33 | 2025-09 | Pedal Bike | Ford | Fusion | silver | Using a Mobile Phone Whilst Driving | None | Barford Road to Coplow St | Barford Road to Coplow Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23820 | op-snap---monthly-publication-september-2025.pdf | 39 | 2025-09 | Pedal Bike | Skoda | SUV | Grey | Driving without Due Care and Attention | None | Weston Road Evesham | Weston Road Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23828 | op-snap---monthly-publication-september-2025.pdf | 47 | 2025-09 | Pedal Bike | BMW | X3.. | Grey | Using a Mobile Phone Whilst Driving | None | Burnaby Road | Burnaby Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4352 | -1.5194238 | ||
| 23830 | op-snap---monthly-publication-september-2025.pdf | 49 | 2025-09 | Pedal Bike | Audi | A1 | Grey | Driving without Reasonable Consideration | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 23832 | op-snap---monthly-publication-september-2025.pdf | 51 | 2025-09 | Pedal Bike | Chevrolet | Matiz | Orange | Driving without Reasonable Consideration | None | Cheveral Avenue | Cheveral Avenue | Coventry | Coventry | NFA | No Offence | 52.4257402 | -1.5185037 | ||
| 23835 | op-snap---monthly-publication-september-2025.pdf | 54 | 2025-09 | Pedal Bike | Audi | RS5 | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Court | N/A | 52.4221152 | -1.4959475 | ||
| 23855 | op-snap---monthly-publication-september-2025.pdf | 74 | 2025-09 | Pedal Bike | Peugeot | 107 | Silver | Driving without Due Care and Attention | None | Wolverhampton Rd , jn with Dimmock Street | Wolverhampton Road , jn with Dimmock Street | Wolverhampton | Wolverhampton | Education | N/A | ||||
| 23867 | op-snap---monthly-publication-september-2025.pdf | 86 | 2025-09 | Pedal Bike | Land Rover | Sport | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 23874 | op-snap---monthly-publication-september-2025.pdf | 93 | 2025-09 | Pedal Bike | Nissan | Ariya | Green | Misc - Non Traffic Offences | None | Aldersly Leisure Village | Aldersly Leisure Village | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 23881 | op-snap---monthly-publication-september-2025.pdf | 100 | 2025-09 | Pedal Bike | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 23904 | op-snap---monthly-publication-september-2025.pdf | 123 | 2025-09 | Pedal Bike | Porsche | Panamera | Black | Using a Mobile Phone Whilst Driving | None | Park Hill Road | Park Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612518 | -1.9515542 | ||
| 23906 | op-snap---monthly-publication-september-2025.pdf | 125 | 2025-09 | Pedal Bike | Renault | Kangoo | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 23909 | op-snap---monthly-publication-september-2025.pdf | 128 | 2025-09 | Pedal Bike | Skoda | Rapid | Grey | Driving without Reasonable Consideration | None | New Street | New Street | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4791344 | -1.8986915 | ||
| 23946 | op-snap---monthly-publication-september-2025.pdf | 165 | 2025-09 | Pedal Bike | Mitsubishi | L200 | Red | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 23951 | op-snap---monthly-publication-september-2025.pdf | 170 | 2025-09 | Pedal Bike | Ford | Kuga | Grey | Using a Mobile Phone Whilst Driving | None | Pershore at Cartland | Pershore at Cartland | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4244988 | -1.9217197 | ||
| 23961 | op-snap---monthly-publication-september-2025.pdf | 180 | 2025-09 | Pedal Bike | Peugeot | Partner | White | Driving without Reasonable Consideration | None | Merritts Hill | Merritts Hill | Birmingham | Birmingham | Education | N/A | 52.424853 | -1.9814275 | ||
| 23964 | op-snap---monthly-publication-september-2025.pdf | 183 | 2025-09 | Pedal Bike | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | None | Evesham | Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3837388 | -1.5529669 | ||
| 23965 | op-snap---monthly-publication-september-2025.pdf | 184 | 2025-09 | Pedal Bike | Vauxhall | Insignia | Silver | Driving without Reasonable Consideration | None | Station Road Marston Green | Station Road Marston Green | Solihull | Solihull | Warning Letter | N/A | 52.4667342 | -1.747421 | ||
| 23970 | op-snap---monthly-publication-september-2025.pdf | 189 | 2025-09 | Pedal Bike | Ford | Focus | Red | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 23974 | op-snap---monthly-publication-september-2025.pdf | 193 | 2025-09 | Pedal Bike | M/C | Black | Driving without Due Care and Attention | None | Lickey Road | Lickey Road | Birmingham | Birmingham | NFA | No VRM | 52.3868298 | -2.0003781 | |||
| 23982 | op-snap---monthly-publication-september-2025.pdf | 201 | 2025-09 | Pedal Bike | Ford | Focus | Black | Driving without Due Care and Attention | No vehicle excise licence | Holly Lane, Marston Green | Holly Lane, Marston Green | Birmingham | Birmingham | Education | N/A | ||||
| 23993 | op-snap---monthly-publication-september-2025.pdf | 212 | 2025-09 | Pedal Bike | Ford | Transit | Pink | Contravening a Red Traffic Light | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Education | N/A | 52.4324855 | -1.4815548 | ||
| 23998 | op-snap---monthly-publication-september-2025.pdf | 217 | 2025-09 | Pedal Bike | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Church Road Edgbaston | Church Road Edgbaston | Birmingham | Birmingham | Education | N/A | 52.46114 | -1.9180882 | ||
| 24010 | op-snap---monthly-publication-september-2025.pdf | 229 | 2025-09 | Pedal Bike | BMW | 118 | Black | Driving without Due Care and Attention | None | Wylde Green Road | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.546976 | -1.8098124 | ||
| 24013 | op-snap---monthly-publication-september-2025.pdf | 232 | 2025-09 | Pedal Bike | Peugeot | 207 | Black | Driving without Reasonable Consideration | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24015 | op-snap---monthly-publication-september-2025.pdf | 234 | 2025-09 | Pedal Bike | BMW | 120d | White | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Walsall | Walsall | Education | N/A | 52.6166864 | -1.9660822 | ||
| 24016 | op-snap---monthly-publication-september-2025.pdf | 235 | 2025-09 | Pedal Bike | Ford | Mustang E | Red | Using a Mobile Phone Whilst Driving | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 24020 | op-snap---monthly-publication-september-2025.pdf | 239 | 2025-09 | Pedal Bike | Honda | Civic | Black | Driving without Due Care and Attention | None | Sampson Road | Sampson Road | Solihull | Solihull | NFA | No Offence | ||||
| 24023 | op-snap---monthly-publication-september-2025.pdf | 242 | 2025-09 | Pedal Bike | Ford | Focus | Red | Driving without Due Care and Attention | None | Tixall Road Shirley | Tixall Road Shirley | Birmingham | Birmingham | Education | N/A | ||||
| 24037 | op-snap---monthly-publication-september-2025.pdf | 256 | 2025-09 | Pedal Bike | Hyundai | Tucson | Blue | Driving without Due Care and Attention | None | Chester Road North | Chester Road North | Birmingham | Birmingham | Education | N/A | 52.548449 | -1.8594603 | ||
| 24042 | op-snap---monthly-publication-september-2025.pdf | 261 | 2025-09 | Pedal Bike | Tesla | Black | Driving without Due Care and Attention | None | Wylde Green Road | Wylde Green Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.546976 | -1.8098124 | |||
| 24090 | op-snap---monthly-publication-september-2025.pdf | 309 | 2025-09 | Pedal Bike | Hyundai | I20 | Grey | Driving without Due Care and Attention | None | Turners Lane | Turners Lane | Dudley | Dudley | Education | N/A | 52.4721372 | -2.1243522 | ||
| 24093 | op-snap---monthly-publication-september-2025.pdf | 312 | 2025-09 | Pedal Bike | Volkswagen | XC60 | Black | Contravening a Red Traffic Light | None | Holly Lane | Holly Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5236889 | -1.8253311 | ||
| 24105 | op-snap---monthly-publication-september-2025.pdf | 324 | 2025-09 | Pedal Bike | Renault | Traffic | Black | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Solihull | Solihull | Education | N/A | 52.4322443 | -1.6746508 | ||
| 24106 | op-snap---monthly-publication-september-2025.pdf | 325 | 2025-09 | Pedal Bike | Volvo | XC40 | Black | Driving without Due Care and Attention | None | Gower Street | Gower Street | Walsall | Walsall | Education | N/A | 52.5737189 | -2.0065411 | ||
| 24107 | op-snap---monthly-publication-september-2025.pdf | 326 | 2025-09 | Pedal Bike | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | B4101 TILE HILL LANE | B4101 Tile Hill Lane | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 24108 | op-snap---monthly-publication-september-2025.pdf | 327 | 2025-09 | Pedal Bike | Land Rover | Range Rover | White | Driving without Due Care and Attention | None | Devon Road | Devon Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4674008 | -1.9805667 | ||
| 24114 | op-snap---monthly-publication-september-2025.pdf | 333 | 2025-09 | Pedal Bike | Peugeot | Partner | Grey | Driving without Due Care and Attention | None | Tipton Road | Tipton Road | Dudley | Dudley | Education | N/A | 52.5198386 | -2.0740876 | ||
| 24119 | op-snap---monthly-publication-september-2025.pdf | 338 | 2025-09 | Pedal Bike | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Tat Bank Road | Tat Bank Road | Sandwell | Sandwell | Education | N/A | 52.4979925 | -2.0082232 | ||
| 24120 | op-snap---monthly-publication-september-2025.pdf | 339 | 2025-09 | Pedal Bike | Ford | Transit | Blue | Using a Mobile Phone Whilst Driving | None | Coundon Wedge Drive | Coundon Wedge Drive | Coventry | Coventry | Fixed Penalty | N/A | 52.4385402 | -1.5483746 | ||
| 24121 | op-snap---monthly-publication-september-2025.pdf | 340 | 2025-09 | Pedal Bike | Seat | Leon | White | Driving without Due Care and Attention | None | Priory Road | Priory Road | Birmingham | Birmingham | Education | N/A | 52.4132696 | -1.8555008 | ||
| 24122 | op-snap---monthly-publication-september-2025.pdf | 341 | 2025-09 | Pedal Bike | Audi | A1 | Grey | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | No Offence | 52.4103629 | -1.5441218 | ||
| 24131 | op-snap---monthly-publication-september-2025.pdf | 350 | 2025-09 | Pedal Bike | Isuzu | truck | Red | Driving without Due Care and Attention | None | B4234 Bishopswood Village, Staffordshire | Bishopswood Village, Staffordshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24148 | op-snap---monthly-publication-september-2025.pdf | 367 | 2025-09 | Pedal Bike | BMW | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | |||
| 24158 | op-snap---monthly-publication-september-2025.pdf | 377 | 2025-09 | Pedal Bike | Alexander Dennis | Grey | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Court | N/A | 52.4167654 | -1.9411244 | |||
| 24174 | op-snap---monthly-publication-september-2025.pdf | 393 | 2025-09 | Pedal Bike | Audi | A5 | White | Driving without Due Care and Attention | None | Harbury Lane | Harbury Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24176 | op-snap---monthly-publication-september-2025.pdf | 395 | 2025-09 | Pedal Bike | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Stonnal Road Aldridge | Stonnal Road Aldridge | Walsall | Walsall | Warning Letter | N/A | ||||
| 24178 | op-snap---monthly-publication-september-2025.pdf | 397 | 2025-09 | Pedal Bike | Vauxhall | Vivaro | White | Using a Mobile Phone Whilst Driving | None | Chester Road, Stonnall | Chester Road, Stonnall | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | ||||
| 24183 | op-snap---monthly-publication-september-2025.pdf | 402 | 2025-09 | Pedal Bike | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 24185 | op-snap---monthly-publication-september-2025.pdf | 404 | 2025-09 | Pedal Bike | Mercedes-Benz | A-class | Grey | Driving without Due Care and Attention | None | Lichfield Road, Aston | Lichfield Road, Aston | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5084175 | -1.8613455 | ||
| 24186 | op-snap---monthly-publication-september-2025.pdf | 405 | 2025-09 | Pedal Bike | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Bibury Road Cheltenham | Bibury Road Cheltenham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24193 | op-snap---monthly-publication-september-2025.pdf | 412 | 2025-09 | Pedal Bike | Mg | 4.. | Grey | Driving without Due Care and Attention | None | Beake Avenue | Beake Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4388246 | -1.5229308 | ||
| 24198 | op-snap---monthly-publication-september-2025.pdf | 417 | 2025-09 | Pedal Bike | BMW | 2 series | Grey | Driving without Due Care and Attention | No vehicle excise licence | Clarence Road | Clarence Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5940902 | -1.843503 | ||
| 24218 | op-snap---monthly-publication-september-2025.pdf | 437 | 2025-09 | Pedal Bike | Peugeot | 208 | Black | Driving without Due Care and Attention | None | Inchlaggon Road | Inchlaggon Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 24228 | op-snap---monthly-publication-september-2025.pdf | 447 | 2025-09 | Pedal Bike | Toyota | Prius | White | Contravening a Red Traffic Light | None | Queen Victoria Road and Rover Road | Queen Victoria Road and Rover Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4070937 | -1.5157687 | ||
| 24240 | op-snap---monthly-publication-september-2025.pdf | 459 | 2025-09 | Pedal Bike | Toyota | Landcruiser | Silver | Driving without Due Care and Attention | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4591339 | -1.9601054 | ||
| 24268 | op-snap---monthly-publication-september-2025.pdf | 487 | 2025-09 | Pedal Bike | Vauxhall | Combo | Grey | Driving without Due Care and Attention | None | Thorns Road | Thorns Road | Dudley | Dudley | Education | N/A | 52.4628538 | -2.1160108 | ||
| 24289 | op-snap---monthly-publication-september-2025.pdf | 508 | 2025-09 | Pedal Bike | Volvo | V40 | Blue | Driving without Reasonable Consideration | None | Henwick Road | Henwick Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24305 | op-snap---monthly-publication-september-2025.pdf | 524 | 2025-09 | Pedal Bike | Volkswagen | Polo | Black | Driving without Reasonable Consideration | None | School Road | School Road | Solihull | Solihull | Education | N/A | 52.3517888 | -1.7783232 | ||
| 24312 | op-snap---monthly-publication-september-2025.pdf | 531 | 2025-09 | Pedal Bike | Toyota | yaris | Silver | Driving without Reasonable Consideration | None | Radford Road/Wallace Road | Radford Road/Wallace Road | Coventry | Coventry | Education | N/A | 52.4235908 | -1.5226276 | ||
| 24340 | op-snap---monthly-publication-september-2025.pdf | 559 | 2025-09 | Pedal Bike | Toyota | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | |||
| 24341 | op-snap---monthly-publication-september-2025.pdf | 560 | 2025-09 | Pedal Bike | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Breedon Road | Breedon Road | Birmingham | Birmingham | Education | N/A | 52.4191978 | -1.9251219 | ||
| 24349 | op-snap---monthly-publication-september-2025.pdf | 568 | 2025-09 | Pedal Bike | Nissan | Qashqai | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4324855 | -1.4815548 | ||
| 24357 | op-snap---monthly-publication-september-2025.pdf | 576 | 2025-09 | Pedal Bike | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Hob Lane | Hob Lane | Solihull | Solihull | Education | N/A | 52.377539 | -1.6201491 | ||
| 24374 | op-snap---monthly-publication-september-2025.pdf | 593 | 2025-09 | Pedal Bike | Nissan | Note | Blue | Driving without Due Care and Attention | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 | ||
| 24380 | op-snap---monthly-publication-september-2025.pdf | 599 | 2025-09 | Pedal Bike | Tesla | model 3 | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road, Edgbaston | Augustus Road, Edgbaston | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 24387 | op-snap---monthly-publication-september-2025.pdf | 606 | 2025-09 | Pedal Bike | Mercedes-Benz | EQA | Blue | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Education | N/A | 52.4718503 | -1.9195423 | ||
| 24392 | op-snap---monthly-publication-september-2025.pdf | 611 | 2025-09 | Pedal Bike | Vauxhall | Vivaro | Black | Driving without Due Care and Attention | None | Lichfield Road towards Dartmouth Circus | Lichfield Road towards Dartmouth Circus | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24426 | op-snap---monthly-publication-september-2025.pdf | 645 | 2025-09 | Pedal Bike | Mercedes-Benz | S350 | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road, Edgbaston | Harborne Road, Edgbaston | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 24443 | op-snap---monthly-publication-september-2025.pdf | 662 | 2025-09 | Pedal Bike | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | George Road | George Road | Birmingham | Birmingham | Education | N/A | 52.5155831 | -1.8598862 | ||
| 24447 | op-snap---monthly-publication-september-2025.pdf | 666 | 2025-09 | Pedal Bike | Volkswagen | Transporter | Black | Using a Mobile Phone Whilst Driving | None | Newhall Street | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 24448 | op-snap---monthly-publication-september-2025.pdf | 667 | 2025-09 | Pedal Bike | Isuzu | Grafter | White | Using a Mobile Phone Whilst Driving | None | Silhill Hall Road | Silhill Hall Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4201252 | -1.7916238 | ||
| 24457 | op-snap---monthly-publication-september-2025.pdf | 676 | 2025-09 | Pedal Bike | Vauxhall | Astra | Red | Driving without Due Care and Attention | None | Holly Lane, Marston Green | Holly Lane, Marston Green | Birmingham | Birmingham | Education | N/A | ||||
| 24472 | op-snap---monthly-publication-september-2025.pdf | 691 | 2025-09 | Pedal Bike | Skoda | Fabia | Silver | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 24473 | op-snap---monthly-publication-september-2025.pdf | 692 | 2025-09 | Pedal Bike | Skoda | Kamiq | Grey | Using a Mobile Phone Whilst Driving | None | High St | High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5254588 | -1.8373064 | ||
| 24475 | op-snap---monthly-publication-september-2025.pdf | 694 | 2025-09 | Pedal Bike | Mazda | 3 | Red | Driving without Due Care and Attention | None | The Firs | The Firs | Coventry | Coventry | Education | N/A | 52.3965706 | -1.523038 | ||
| 24487 | op-snap---monthly-publication-september-2025.pdf | 706 | 2025-09 | Pedal Bike | Mercedes-Benz | CLA220 | Silver | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 24491 | op-snap---monthly-publication-september-2025.pdf | 710 | 2025-09 | Pedal Bike | Chysler | 300C | Silver | Driving without Due Care and Attention | None | The Broadway | The Broadway | Dudley | Dudley | Education | N/A | 52.515445 | -2.0885791 | ||
| 24493 | op-snap---monthly-publication-september-2025.pdf | 712 | 2025-09 | Pedal Bike | Land Rover | Evoque | Black | Driving without Due Care and Attention | None | A491 Hagley Road | Hagley Road | Dudley | Dudley | Education | N/A | 52.4514139 | -2.1423625 | ||
| 24494 | op-snap---monthly-publication-september-2025.pdf | 713 | 2025-09 | Pedal Bike | Citroen | C4 Picasso | Red | Driving without Due Care and Attention | None | Potters Lane, Wednesbury | Potters Lane, Wednesbury | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 24495 | op-snap---monthly-publication-september-2025.pdf | 714 | 2025-09 | Pedal Bike | Chysler | Voyager | Silver | Driving without Due Care and Attention | No Insurance | Great Bridge Road, Bilston | Great Bridge Road, Bilston | Wolverhampton | Wolverhampton | Court | N/A | 52.5602666 | -2.0579414 | ||
| 24496 | op-snap---monthly-publication-september-2025.pdf | 715 | 2025-09 | Pedal Bike | Porsche | Cayman | White | Driving without Due Care and Attention | None | Great Bridge Road, Bilston | Great Bridge Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5602666 | -2.0579414 | ||
| 24498 | op-snap---monthly-publication-september-2025.pdf | 717 | 2025-09 | Pedal Bike | Ford | Mondeo | Silver | Driving without Due Care and Attention | None | Umberslade Road, Stirchley | Umberslade Road, Stirchley | Birmingham | Birmingham | Warning Letter | N/A | 52.4304526 | -1.9216716 | ||
| 24510 | op-snap---monthly-publication-september-2025.pdf | 729 | 2025-09 | Pedal Bike | Hyundai | I10 | Red | Using a Mobile Phone Whilst Driving | None | Lynchgate Road | Lynchgate Road | Coventry | Coventry | Fixed Penalty | N/A | 52.3894664 | -1.5558269 | ||
| 24511 | op-snap---monthly-publication-september-2025.pdf | 730 | 2025-09 | Pedal Bike | BMW | M135 | Grey | Driving without Due Care and Attention | None | Tanners Lane Coventry | Tanners Lane Coventry | Coventry | Coventry | Fixed Penalty | N/A | 52.4007746 | -1.5997847 | ||
| 24512 | op-snap---monthly-publication-september-2025.pdf | 731 | 2025-09 | Pedal Bike | Scania | Coach | Green | Driving without Due Care and Attention | None | Balsall Street East, Balsall Common | Balsall Street East, Balsall Common | Coventry | Coventry | Warning Letter | N/A | ||||
| 24513 | op-snap---monthly-publication-september-2025.pdf | 732 | 2025-09 | Pedal Bike | Seat | Leon | Grey | Driving without Due Care and Attention | None | Wall Hill Road | Wall Hill Road | Coventry | Coventry | Education | N/A | 52.4459445 | -1.5552508 | ||
| 24520 | op-snap---monthly-publication-september-2025.pdf | 739 | 2025-09 | Pedal Bike | Renault | Zoe | Blue | Driving without Due Care and Attention | None | Queen Victoria Road | Queen Victoria Road | Coventry | Coventry | Warning Letter | N/A | 52.4063195 | -1.5157306 | ||
| 24531 | op-snap---monthly-publication-september-2025.pdf | 750 | 2025-09 | Pedal Bike | Volkswagen | Black | Driving without Due Care and Attention | None | Warstock Lane | Warstock Lane | Birmingham | Birmingham | Education | N/A | 52.4175988 | -1.8774655 | |||
| 24554 | op-snap---monthly-publication-september-2025.pdf | 773 | 2025-09 | Pedal Bike | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | None | Linthouse Lane | Linthouse Lane | Wolverhampton | Wolverhampton | Court | N/A | 52.6118187 | -2.0810618 | ||
| 24567 | op-snap---monthly-publication-september-2025.pdf | 786 | 2025-09 | Pedal Bike | Land Rover | Range Rover | Grey | Using a Mobile Phone Whilst Driving | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 24578 | op-snap---monthly-publication-september-2025.pdf | 797 | 2025-09 | Pedal Bike | Peugeot | 308 | Silver | Driving without Reasonable Consideration | None | Marston Lane | Marston Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4670062 | -1.7548427 | ||
| 24581 | op-snap---monthly-publication-september-2025.pdf | 800 | 2025-09 | Pedal Bike | Ford | Transit | White | Driving without Reasonable Consideration | None | Wrentham Street | Wrentham Street | Birmingham | Birmingham | Education | N/A | 52.4708757 | -1.8966158 | ||
| 24596 | op-snap---monthly-publication-september-2025.pdf | 815 | 2025-09 | Pedal Bike | BMW | 3 Series | White | Driving without Due Care and Attention | None | Chester Road North | Chester Road North | Walsall | Walsall | Education | N/A | 52.654063 | -1.9460461 | ||
| 24608 | op-snap---monthly-publication-september-2025.pdf | 827 | 2025-09 | Pedal Bike | Audi | A5 | Red | Driving without Due Care and Attention | None | Newton Road | Newton Road | Sandwell | Sandwell | Education | N/A | 52.5428224 | -1.9569444 |
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);