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'}
320 rows where month = "2025-06" 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 19
- Driving without Due Care and Attention 149
- Using a Mobile Phone Whilst Driving 63
- Driving without Reasonable Consideration 24
- Contravening a Red Traffic Light 14
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 13
- Cause vehicle to be left in a dangerous position 13
- Stop a vehicle within pelican pedestrian crossing limits 10
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 8
- Misc - Non Traffic Offences 6
- Stop a vehicle on pedestrian crossing 5
- Fail to Conform to Cycle Lane 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Contravene Lane Closure Red X 1
- Fail to display rear VRM plate 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use vehicle on a road without valid test certificate 1
- Vehicle overtake within crossing limits 1
council_area 11
- Birmingham 216
- Coventry 31
- Solihull 18
- Walsall 11
- Sandwell 10
- Sutton Coldfield 10
- Wolverhampton 8
- Dudley 7
- Out of Force Area 6
- Metropolitan Borough 2
- Halesowen 1
disposal 5
- NFA 117
- Education 90
- Fixed Penalty 55
- Warning Letter 48
- Court 10
reporter_transport_mode 1
- Pedal Bike · 320 ✖
month 1
- 2025-06 · 320 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14073 | op-snap---monthly-publication-june-2025.pdf | 2 | 2025-06 | Pedal Bike | Toyota | Corolla | Black | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 14084 | op-snap---monthly-publication-june-2025.pdf | 13 | 2025-06 | Pedal Bike | Audi | Q5 | Silver | Driving without Reasonable Consideration | None | GRANGE ROAD | Grange Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4285724 | -1.8019101 | ||
| 14086 | op-snap---monthly-publication-june-2025.pdf | 15 | 2025-06 | Pedal Bike | Toyota | Aygo | White | Contravening a Red Traffic Light | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 14087 | op-snap---monthly-publication-june-2025.pdf | 16 | 2025-06 | Pedal Bike | Mercedes-Benz | C180 | Blue | Contravening a Red Traffic Light | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 14095 | op-snap---monthly-publication-june-2025.pdf | 24 | 2025-06 | Pedal Bike | Mercedes-Benz | E300 | White | Driving without Due Care and Attention | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 14104 | op-snap---monthly-publication-june-2025.pdf | 33 | 2025-06 | Pedal Bike | Nissan | QASHQUI | Grey | Using a Mobile Phone Whilst Driving | None | ALCESTER ROAD | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14109 | op-snap---monthly-publication-june-2025.pdf | 38 | 2025-06 | Pedal Bike | Volvo | Red | Driving without Due Care and Attention | None | B4151 towards Walsall | B4151 towards Walsall | Walsall | Walsall | Education | N/A | |||||
| 14110 | op-snap---monthly-publication-june-2025.pdf | 39 | 2025-06 | Pedal Bike | Ford | Kuga | Silver | Using a Mobile Phone Whilst Driving | None | Oxford Road | Oxford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4456323 | -1.8858352 | ||
| 14116 | op-snap---monthly-publication-june-2025.pdf | 45 | 2025-06 | Pedal Bike | Ford | kUGA | Black | Using a Mobile Phone Whilst Driving | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.470423 | -1.9304786 | ||
| 14117 | op-snap---monthly-publication-june-2025.pdf | 46 | 2025-06 | Pedal Bike | Jaguar | XF | Red | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Education | N/A | 52.4718503 | -1.9195423 | ||
| 14118 | op-snap---monthly-publication-june-2025.pdf | 47 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14119 | op-snap---monthly-publication-june-2025.pdf | 48 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4718503 | -1.9195423 | ||
| 14120 | op-snap---monthly-publication-june-2025.pdf | 49 | 2025-06 | Pedal Bike | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | Education | N/A | 52.4282602 | -1.9861769 | ||
| 14121 | op-snap---monthly-publication-june-2025.pdf | 50 | 2025-06 | Pedal Bike | Kia | Sportage | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Road | Shenley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4373076 | -1.9543847 | ||
| 14122 | op-snap---monthly-publication-june-2025.pdf | 51 | 2025-06 | Pedal Bike | Hyundai | I10 | White | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4744337 | -1.9677475 | ||
| 14123 | op-snap---monthly-publication-june-2025.pdf | 52 | 2025-06 | Pedal Bike | Citroen | C3 | Grey | Using a Mobile Phone Whilst Driving | None | Popular Road | Popular Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.454374 | -1.8774689 | ||
| 14134 | op-snap---monthly-publication-june-2025.pdf | 63 | 2025-06 | Pedal Bike | Audi | A1 | White | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Education | N/A | 52.5131355 | -2.0651615 | ||
| 14139 | op-snap---monthly-publication-june-2025.pdf | 68 | 2025-06 | Pedal Bike | Peugeot | 2008 | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 14147 | op-snap---monthly-publication-june-2025.pdf | 76 | 2025-06 | Pedal Bike | BMW | IX8 | White | Driving without Due Care and Attention | None | Clarence Road | Clarence Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5940902 | -1.843503 | ||
| 14159 | op-snap---monthly-publication-june-2025.pdf | 88 | 2025-06 | Pedal Bike | Volkswagen | UP | Blue | Using a Mobile Phone Whilst Driving | None | HIGHFIELD ROAD | Highfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4216321 | -1.855984 | ||
| 14178 | op-snap---monthly-publication-june-2025.pdf | 107 | 2025-06 | Pedal Bike | Porsche | 911 | Blue | Driving without Reasonable Consideration | None | Highlands Road | Highlands Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 14179 | op-snap---monthly-publication-june-2025.pdf | 108 | 2025-06 | Pedal Bike | BMW | X5 | Silver | Driving without Due Care and Attention | None | Danford Lane | Danford Lane | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 14194 | op-snap---monthly-publication-june-2025.pdf | 123 | 2025-06 | Pedal Bike | BMW | 320d | White | Driving without Due Care and Attention | None | The Broadway | The Broadway | Dudley | Dudley | Court | N/A | 52.515445 | -2.0885791 | ||
| 14196 | op-snap---monthly-publication-june-2025.pdf | 125 | 2025-06 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Waste Lane | Waste Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.437361 | -1.5371291 | ||
| 14216 | op-snap---monthly-publication-june-2025.pdf | 145 | 2025-06 | Pedal Bike | Ford | fiesta | Black | Driving without Due Care and Attention | None | The Broadway | The Broadway | Metropolitan Borough | Metropolitan Borough | Warning Letter | N/A | 52.5108588 | -1.8919435 | ||
| 14218 | op-snap---monthly-publication-june-2025.pdf | 147 | 2025-06 | Pedal Bike | Renault | Trafic | White | Contravening a Red Traffic Light | None | Halesowen Road, Cradley Heath | Halesowen Road, Cradley Heath | Sandwell | Sandwell | Warning Letter | N/A | 52.4641171 | -2.0557973 | ||
| 14232 | op-snap---monthly-publication-june-2025.pdf | 161 | 2025-06 | Pedal Bike | Audi | A1 S LINE | White | Driving without Reasonable Consideration | None | STRATFORD ROAD | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 14238 | op-snap---monthly-publication-june-2025.pdf | 167 | 2025-06 | Pedal Bike | Audi | Q5 | Black | Driving without Due Care and Attention | None | Salibsury Road | Salibsury Road | Birmingham | Birmingham | Education | N/A | ||||
| 14239 | op-snap---monthly-publication-june-2025.pdf | 168 | 2025-06 | Pedal Bike | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Pebble Mill Road | Pebble Mill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4512925 | -1.9124618 | ||
| 14240 | op-snap---monthly-publication-june-2025.pdf | 169 | 2025-06 | Pedal Bike | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 14242 | op-snap---monthly-publication-june-2025.pdf | 171 | 2025-06 | Pedal Bike | Volkswagen | Tiguan | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Newhall Street | Newhall Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4830482 | -1.905069 | ||
| 14244 | op-snap---monthly-publication-june-2025.pdf | 173 | 2025-06 | Pedal Bike | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 14258 | op-snap---monthly-publication-june-2025.pdf | 187 | 2025-06 | Pedal Bike | Mercedes-Benz | nk | White | Misc - Non Traffic Offences | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 14261 | op-snap---monthly-publication-june-2025.pdf | 190 | 2025-06 | Pedal Bike | Honda | Civic | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 14262 | op-snap---monthly-publication-june-2025.pdf | 191 | 2025-06 | Pedal Bike | Mercedes-Benz | A180 | Grey | Misc - Non Traffic Offences | None | Startford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 14265 | op-snap---monthly-publication-june-2025.pdf | 194 | 2025-06 | Pedal Bike | Hyundai | I30.. | White | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 14266 | op-snap---monthly-publication-june-2025.pdf | 195 | 2025-06 | Pedal Bike | Volkswagen | Transporter | White | Driving without Reasonable Consideration | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 14277 | op-snap---monthly-publication-june-2025.pdf | 206 | 2025-06 | Pedal Bike | BMW | X3 | Blue | Driving without Due Care and Attention | No Insurance | Woden Road South | Woden Road South | Sandwell | Sandwell | Court | N/A | 52.546752 | -2.0155769 | ||
| 14281 | op-snap---monthly-publication-june-2025.pdf | 210 | 2025-06 | Pedal Bike | BMW | X1 | Grey | Driving without Due Care and Attention | No Insurance | Holders Lane | Holders Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4446701 | -1.9056872 | ||
| 14282 | op-snap---monthly-publication-june-2025.pdf | 211 | 2025-06 | Pedal Bike | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 14283 | op-snap---monthly-publication-june-2025.pdf | 212 | 2025-06 | Pedal Bike | Nissan | Note | Black | Using a Mobile Phone Whilst Driving | None | Cateswell Road | Cateswell Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4387009 | -1.8454267 | ||
| 14285 | op-snap---monthly-publication-june-2025.pdf | 214 | 2025-06 | Pedal Bike | Audi | A1 | Black | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 14286 | op-snap---monthly-publication-june-2025.pdf | 215 | 2025-06 | Pedal Bike | Volkswagen | Sharan | Silver | Driving without Due Care and Attention | None | Old Dickens Heath Road | Old Dickens Heath Road | Solihull | Solihull | Warning Letter | N/A | 52.3864791 | -1.8355922 | ||
| 14288 | op-snap---monthly-publication-june-2025.pdf | 217 | 2025-06 | Pedal Bike | Honda | E | Black | Driving without Due Care and Attention | None | Cliff Rock Road | Cliff Rock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3937169 | -2.0011078 | ||
| 14289 | op-snap---monthly-publication-june-2025.pdf | 218 | 2025-06 | Pedal Bike | Peugeot | 2008 | Red | Contravening a Red Traffic Light | None | Beake Avenue | Beake Avenue | Coventry | Coventry | NFA | No Offence | 52.4388246 | -1.5229308 | ||
| 14294 | op-snap---monthly-publication-june-2025.pdf | 223 | 2025-06 | Pedal Bike | Mazda | 3 | Silver | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard, Selly Oak | Aston Webb Boulevard, Selly Oak | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4443904 | -1.9419231 | ||
| 14295 | op-snap---monthly-publication-june-2025.pdf | 224 | 2025-06 | Pedal Bike | Mercedes-Benz | C220 | White | Using a Mobile Phone Whilst Driving | No Insurance | Aston Webb Boulevard, Selly Oak | Aston Webb Boulevard, Selly Oak | Birmingham | Birmingham | Court | N/A | 52.4443904 | -1.9419231 | ||
| 14301 | op-snap---monthly-publication-june-2025.pdf | 230 | 2025-06 | Pedal Bike | BMW | 420D | Black | Driving without Due Care and Attention | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | NFA | No Offence | 52.4397168 | -1.9260414 | ||
| 14305 | op-snap---monthly-publication-june-2025.pdf | 234 | 2025-06 | Pedal Bike | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | No Offence | 52.4520441 | -1.8787544 | ||
| 14307 | op-snap---monthly-publication-june-2025.pdf | 236 | 2025-06 | Pedal Bike | Toyota | Corolla | White | Driving without Due Care and Attention | None | Berkswell Road | Berkswell Road | Coventry | Coventry | Education | N/A | 52.4422534 | -1.4791016 | ||
| 14366 | op-snap---monthly-publication-june-2025.pdf | 295 | 2025-06 | Pedal Bike | Alfa Romeo | Giullietta | Red | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4074716 | -1.5620671 | ||
| 14369 | op-snap---monthly-publication-june-2025.pdf | 298 | 2025-06 | Pedal Bike | Mini | Cooper | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 14372 | op-snap---monthly-publication-june-2025.pdf | 301 | 2025-06 | Pedal Bike | Peugeot | 208 | Black | Misc - Non Traffic Offences | No Insurance | TAUNTON ROAD | Taunton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4531128 | -1.875763 | ||
| 14374 | op-snap---monthly-publication-june-2025.pdf | 303 | 2025-06 | Pedal Bike | Volkswagen | Caddy | Silver | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 14376 | op-snap---monthly-publication-june-2025.pdf | 305 | 2025-06 | Pedal Bike | Audi | A1 | White | Using a Mobile Phone Whilst Driving | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 14377 | op-snap---monthly-publication-june-2025.pdf | 306 | 2025-06 | Pedal Bike | Volvo | XC40 | Black | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4943878 | -1.8504211 | ||
| 14397 | op-snap---monthly-publication-june-2025.pdf | 326 | 2025-06 | Pedal Bike | Ford | Ecosport | Silver | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 14399 | op-snap---monthly-publication-june-2025.pdf | 328 | 2025-06 | Pedal Bike | Nissan | Juke | White | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | ||
| 14416 | op-snap---monthly-publication-june-2025.pdf | 345 | 2025-06 | Pedal Bike | Vauxhall | Corsa | White | Using a Mobile Phone Whilst Driving | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4760986 | -1.9018641 | ||
| 14426 | op-snap---monthly-publication-june-2025.pdf | 355 | 2025-06 | Pedal Bike | Hyundai | Ioniq | Silver | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 14430 | op-snap---monthly-publication-june-2025.pdf | 359 | 2025-06 | Pedal Bike | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | Education | N/A | 52.4851072 | -1.9468115 | ||
| 14434 | op-snap---monthly-publication-june-2025.pdf | 363 | 2025-06 | Pedal Bike | BMW | X1 | White | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | ||
| 14441 | op-snap---monthly-publication-june-2025.pdf | 370 | 2025-06 | Pedal Bike | BMW | 3 SERIES | Blue | Driving without Reasonable Consideration | None | LICHFIELD ROAD | Lichfield Road | Birmingham | Birmingham | Education | N/A | 52.5012458 | -1.8780942 | ||
| 14457 | op-snap---monthly-publication-june-2025.pdf | 386 | 2025-06 | Pedal Bike | Mercedes-Benz | C180 | Silver | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 14465 | op-snap---monthly-publication-june-2025.pdf | 394 | 2025-06 | Pedal Bike | BMW | 340I | Black | Driving without Due Care and Attention | None | Blossomfield Road | Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4144779 | -1.7848758 | ||
| 14480 | op-snap---monthly-publication-june-2025.pdf | 409 | 2025-06 | Pedal Bike | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | Alwod Road | Alwod Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14481 | op-snap---monthly-publication-june-2025.pdf | 410 | 2025-06 | Pedal Bike | Seat | Ibiza | Grey | Driving without Reasonable Consideration | None | Wrentham St | Wrentham Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708757 | -1.8966158 | ||
| 14482 | op-snap---monthly-publication-june-2025.pdf | 411 | 2025-06 | Pedal Bike | Toyota | Avensis | White | Using a Mobile Phone Whilst Driving | None | Smallbrooks Queensway | Smallbrooks Queensway | Birmingham | Birmingham | NFA | No Offence | ||||
| 14483 | op-snap---monthly-publication-june-2025.pdf | 412 | 2025-06 | Pedal Bike | Kia | Cee'd | Black | Driving without Due Care and Attention | None | Richmond Hill Road, Harborne | Richmond Hill Road, Harborne | Birmingham | Birmingham | Education | N/A | 52.4607238 | -1.935227 | ||
| 14485 | op-snap---monthly-publication-june-2025.pdf | 414 | 2025-06 | Pedal Bike | Toyota | Pruis | Red | Driving without Due Care and Attention | None | Qunton Road | Qunton Road | Birmingham | Birmingham | Education | N/A | ||||
| 14489 | op-snap---monthly-publication-june-2025.pdf | 418 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Burnaby Road | Burnaby Road | Coventry | Coventry | Education | N/A | 52.4352 | -1.5194238 | ||
| 14496 | op-snap---monthly-publication-june-2025.pdf | 425 | 2025-06 | Pedal Bike | Audi | A3 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 14507 | op-snap---monthly-publication-june-2025.pdf | 436 | 2025-06 | Pedal Bike | Toyota | Yaris | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 14517 | op-snap---monthly-publication-june-2025.pdf | 446 | 2025-06 | Pedal Bike | Toyota | Auris | Green | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | ||
| 14519 | op-snap---monthly-publication-june-2025.pdf | 448 | 2025-06 | Pedal Bike | Suzuki | GXSR | White | Driving without Due Care and Attention | None | Grange Hill, off Manor Way | Grange Hill, off Manor Way | Halesowen | Halesowen | Court | N/A | ||||
| 14527 | op-snap---monthly-publication-june-2025.pdf | 456 | 2025-06 | Pedal Bike | Audi | A6 | Black | Driving without Due Care and Attention | None | Gibbet Hill Road | Gibbet Hill Road | Coventry | Coventry | Warning Letter | N/A | 52.3749141 | -1.5564977 | ||
| 14530 | op-snap---monthly-publication-june-2025.pdf | 459 | 2025-06 | Pedal Bike | BMW | M235 | White | Driving without Due Care and Attention | None | Norton Lane | Norton Lane | Solihull | Solihull | Education | N/A | 52.3778771 | -1.8581547 | ||
| 14539 | op-snap---monthly-publication-june-2025.pdf | 468 | 2025-06 | Pedal Bike | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | None | Rowheath Road, Cotteridge | Rowheath Road, Cotteridge | Birmingham | Birmingham | Education | N/A | 52.4179718 | -1.9289891 | ||
| 14540 | op-snap---monthly-publication-june-2025.pdf | 469 | 2025-06 | Pedal Bike | Infiniti | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | |||
| 14544 | op-snap---monthly-publication-june-2025.pdf | 473 | 2025-06 | Pedal Bike | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14545 | op-snap---monthly-publication-june-2025.pdf | 474 | 2025-06 | Pedal Bike | BMW | 218i | Red | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14546 | op-snap---monthly-publication-june-2025.pdf | 475 | 2025-06 | Pedal Bike | Volkswagen | T-roc | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14555 | op-snap---monthly-publication-june-2025.pdf | 484 | 2025-06 | Pedal Bike | Vauxhall | Zafira | Black | Contravening a Red Traffic Light | None | Skidmore Rpad | Skidmore Rpad | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 14573 | op-snap---monthly-publication-june-2025.pdf | 502 | 2025-06 | Pedal Bike | MAN | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | |||
| 14574 | op-snap---monthly-publication-june-2025.pdf | 503 | 2025-06 | Pedal Bike | Audi | A4 | Black | Driving without Due Care and Attention | None | Windward Way | Windward Way | Solihull | Solihull | NFA | No Offence | 52.5023715 | -1.7555515 | ||
| 14577 | op-snap---monthly-publication-june-2025.pdf | 506 | 2025-06 | Pedal Bike | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Roses Lane | Roses Lane | Birmingham | Birmingham | Education | N/A | ||||
| 14587 | op-snap---monthly-publication-june-2025.pdf | 516 | 2025-06 | Pedal Bike | Skoda | fabia | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Gooch Street | Gooch Street | Birmingham | Birmingham | NFA | No Offence | 52.4686609 | -1.8945007 | ||
| 14606 | op-snap---monthly-publication-june-2025.pdf | 535 | 2025-06 | Pedal Bike | Toyota | Prius | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 14609 | op-snap---monthly-publication-june-2025.pdf | 538 | 2025-06 | Pedal Bike | BMW | 420i | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4071231 | -1.4985178 | ||
| 14634 | op-snap---monthly-publication-june-2025.pdf | 563 | 2025-06 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | New Street, Frankley | New Street, Frankley | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4041101 | -2.0086912 | ||
| 14652 | op-snap---monthly-publication-june-2025.pdf | 581 | 2025-06 | Pedal Bike | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | Hallen Drive | Hallen Drive | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 14658 | op-snap---monthly-publication-june-2025.pdf | 587 | 2025-06 | Pedal Bike | Toyota | Auris | White | Cause vehicle to be left in a dangerous position | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4520441 | -1.8787544 | ||
| 14670 | op-snap---monthly-publication-june-2025.pdf | 599 | 2025-06 | Pedal Bike | Mercedes-Benz | GLE 350 | Black | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 14671 | op-snap---monthly-publication-june-2025.pdf | 600 | 2025-06 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 14673 | op-snap---monthly-publication-june-2025.pdf | 602 | 2025-06 | Pedal Bike | Audi | Q4.. | Blue | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 14674 | op-snap---monthly-publication-june-2025.pdf | 603 | 2025-06 | Pedal Bike | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Tile Hill | Tile Hill | Coventry | Coventry | Education | N/A | 52.3951906 | -1.5972825 | ||
| 14675 | op-snap---monthly-publication-june-2025.pdf | 604 | 2025-06 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Westwood Way | Westwood Way | Coventry | Coventry | NFA | No Offence | 52.3880214 | -1.5797132 | ||
| 14683 | op-snap---monthly-publication-june-2025.pdf | 612 | 2025-06 | Pedal Bike | Fiat | Ducato | White | Driving without Due Care and Attention | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 14687 | op-snap---monthly-publication-june-2025.pdf | 616 | 2025-06 | Pedal Bike | BMW | x4 | White | Contravening a Red Traffic Light | None | Holloway Circus | Holloway Circus | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.474604 | -1.89977 | ||
| 14688 | op-snap---monthly-publication-june-2025.pdf | 617 | 2025-06 | Pedal Bike | Peugeot | 2008.. | White | Driving without Due Care and Attention | None | Broadway, Stourbridge | Broadway, Stourbridge | Dudley | Dudley | Education | N/A | 52.4411413 | -2.1695219 |
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);