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'}
216 rows where council_area = "Birmingham", 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, nfa_rationale
vehicle_make 28
offence 17
- Driving without Due Care and Attention 89
- Using a Mobile Phone Whilst Driving 57
- Driving without Reasonable Consideration 15
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 9
- Stop a vehicle within pelican pedestrian crossing limits 8
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 8
- Cause vehicle to be left in a dangerous position 7
- Contravening a Red Traffic Light 6
- Misc - Non Traffic Offences 5
- 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 2
- Stop a vehicle on pedestrian crossing 2
- Contravene Lane Closure Red X 1
- Fail to Conform to Cycle Lane 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
- Vehicle overtake within crossing limits 1
disposal 5
- NFA 78
- Education 56
- Fixed Penalty 48
- Warning Letter 31
- Court 3
reporter_transport_mode 1
- Pedal Bike · 216 ✖
month 1
- 2025-06 · 216 ✖
council_area 1
- Birmingham · 216 ✖
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 14700 | op-snap---monthly-publication-june-2025.pdf | 629 | 2025-06 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5359496 | -1.8324115 | ||
| 14719 | op-snap---monthly-publication-june-2025.pdf | 648 | 2025-06 | Pedal Bike | BMW | 420d | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broad Street | Broad Street | Birmingham | Birmingham | NFA | No Offence | 52.4749212 | -1.9147497 | ||
| 14730 | op-snap---monthly-publication-june-2025.pdf | 659 | 2025-06 | Pedal Bike | Ford | Fiesta | Blue | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 14731 | op-snap---monthly-publication-june-2025.pdf | 660 | 2025-06 | Pedal Bike | Skoda | KAROQ | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 14733 | op-snap---monthly-publication-june-2025.pdf | 662 | 2025-06 | Pedal Bike | Tesla | Model 3 | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14740 | op-snap---monthly-publication-june-2025.pdf | 669 | 2025-06 | Pedal Bike | Mercedes-Benz | S 350 | Black | Driving without Due Care and Attention | None | A38 Kingsbuy Road | Kingsbuy Road | Birmingham | Birmingham | Education | N/A | ||||
| 14748 | op-snap---monthly-publication-june-2025.pdf | 677 | 2025-06 | Pedal Bike | BMW | M235I | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 14760 | op-snap---monthly-publication-june-2025.pdf | 689 | 2025-06 | Pedal Bike | Ford | Fiesta | Green | Driving without Due Care and Attention | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Offence | 52.4543565 | -1.9114004 | ||
| 14762 | op-snap---monthly-publication-june-2025.pdf | 691 | 2025-06 | Pedal Bike | Audi | Q5 | Black | Driving without Due Care and Attention | None | Bunbury Road | Bunbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4142089 | -1.9587147 | ||
| 14764 | op-snap---monthly-publication-june-2025.pdf | 693 | 2025-06 | Pedal Bike | Mercedes-Benz | E220 | Black | Driving without Due Care and Attention | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Offence | 52.4943878 | -1.8504211 | ||
| 14766 | op-snap---monthly-publication-june-2025.pdf | 695 | 2025-06 | Pedal Bike | Fiat | Ducato | White | Driving without Due Care and Attention | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Offence | 52.4943878 | -1.8504211 | ||
| 14776 | op-snap---monthly-publication-june-2025.pdf | 705 | 2025-06 | Pedal Bike | BMW | 420 | Black | Using a Mobile Phone Whilst Driving | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4749336 | -1.9003475 | ||
| 14778 | op-snap---monthly-publication-june-2025.pdf | 707 | 2025-06 | Pedal Bike | Peugeot | 2008.. | Orange | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 14780 | op-snap---monthly-publication-june-2025.pdf | 709 | 2025-06 | Pedal Bike | Land Rover | Range Rover | Black | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 14787 | op-snap---monthly-publication-june-2025.pdf | 716 | 2025-06 | Pedal Bike | Ford | Transit | Grey | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 | ||
| 14789 | op-snap---monthly-publication-june-2025.pdf | 718 | 2025-06 | Pedal Bike | Peugeot | Bipper | White | Driving without Reasonable Consideration | None | A38 Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5292752 | -1.7618805 | ||
| 14801 | op-snap---monthly-publication-june-2025.pdf | 730 | 2025-06 | Pedal Bike | Skoda | Karoq | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Leaford Road | Leaford Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14806 | op-snap---monthly-publication-june-2025.pdf | 735 | 2025-06 | Pedal Bike | Mercedes-Benz | E220 | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4718503 | -1.9195423 | ||
| 14889 | op-snap---monthly-publication-june-2025.pdf | 818 | 2025-06 | Pedal Bike | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Doe Bank Lane | Doe Bank Lane | Birmingham | Birmingham | Education | N/A | ||||
| 14902 | op-snap---monthly-publication-june-2025.pdf | 831 | 2025-06 | Pedal Bike | Mercedes-Benz | GLC | Silver | Contravening a Red Traffic Light | None | Gooch St | Gooch Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4686609 | -1.8945007 | ||
| 14918 | op-snap---monthly-publication-june-2025.pdf | 847 | 2025-06 | Pedal Bike | Skoda | Zodiaq | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scotland Lane | Scotland Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4277732 | -2.0022005 | ||
| 14919 | op-snap---monthly-publication-june-2025.pdf | 848 | 2025-06 | Pedal Bike | Renault | Traffic | White | Using a Mobile Phone Whilst Driving | None | Shenley Hill | Shenley Hill | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4267534 | -1.9790765 | ||
| 14921 | op-snap---monthly-publication-june-2025.pdf | 850 | 2025-06 | Pedal Bike | Cupra | Grey | Using a Mobile Phone Whilst Driving | None | Shenley Hill | Shenley Hill | Birmingham | Birmingham | NFA | No Offence | 52.4267534 | -1.9790765 | |||
| 14922 | op-snap---monthly-publication-june-2025.pdf | 851 | 2025-06 | Pedal Bike | Vauxhall | Zafira | Black | Using a Mobile Phone Whilst Driving | None | Shenley Hill | Shenley Hill | Birmingham | Birmingham | NFA | No Offence | 52.4267534 | -1.9790765 | ||
| 14923 | op-snap---monthly-publication-june-2025.pdf | 852 | 2025-06 | Pedal Bike | Audi | A3 | Grey | Using a Mobile Phone Whilst Driving | None | Vincent Drive | Vincent Drive | Birmingham | Birmingham | NFA | No Offence | 52.4528789 | -1.9354459 | ||
| 14924 | op-snap---monthly-publication-june-2025.pdf | 853 | 2025-06 | Pedal Bike | Seat | Ibiza | Blue | Driving without Due Care and Attention | none | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4943878 | -1.8504211 | ||
| 14925 | op-snap---monthly-publication-june-2025.pdf | 854 | 2025-06 | Pedal Bike | Citroen | Picasso | Blue | Driving without Due Care and Attention | None | Merritts Hill | Merritts Hill | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.424853 | -1.9814275 | ||
| 14926 | op-snap---monthly-publication-june-2025.pdf | 855 | 2025-06 | Pedal Bike | Land Rover | Discovery | White | Driving without Due Care and Attention | None | Scotland Lane | Scotland Lane | Birmingham | Birmingham | NFA | No Offence | 52.4277732 | -2.0022005 | ||
| 14927 | op-snap---monthly-publication-june-2025.pdf | 856 | 2025-06 | Pedal Bike | Peugeot | 207.. | Grey | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 14928 | op-snap---monthly-publication-june-2025.pdf | 857 | 2025-06 | Pedal Bike | BMW | 220.. | Orange | Driving without Due Care and Attention | None | Merritts Hill | Merritts Hill | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.424853 | -1.9814275 | ||
| 14929 | op-snap---monthly-publication-june-2025.pdf | 858 | 2025-06 | Pedal Bike | Fiat | Panda | Grey | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 14931 | op-snap---monthly-publication-june-2025.pdf | 860 | 2025-06 | Pedal Bike | Seat | Leon | Black | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4282602 | -1.9861769 | ||
| 14932 | op-snap---monthly-publication-june-2025.pdf | 861 | 2025-06 | Pedal Bike | BMW | 320d | Black | Using a Mobile Phone Whilst Driving | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.430111 | -1.9753703 | ||
| 14933 | op-snap---monthly-publication-june-2025.pdf | 862 | 2025-06 | Pedal Bike | Jaguar | XE | Black | Driving without Due Care and Attention | None | Shenley Lane | Shenley Lane | Birmingham | Birmingham | Education | N/A | 52.430111 | -1.9753703 |
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);