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'}
91 rows where disposal = "Fixed Penalty", month = "2025-11" and offence = "Using a Mobile Phone Whilst Driving" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw
vehicle_make 24
- BMW 11
- Mercedes-Benz 9
- Nissan 8
- Volkswagen 8
- Toyota 6
- Audi 5
- Ford 5
- Fiat 4
- Land Rover 4
- Peugeot 4
- Citroen 3
- Renault 3
- Tesla 3
- Vauxhall 3
- Kia 2
- Porsche 2
- Suzuki 2
- Dacia 1
- Hyundai 1
- Jaguar 1
- Lexus 1
- Mitsubishi 1
- Rolls-Royce 1
- Seat 1
reporter_transport_mode 5
- Pedal Bike 69
- Pedestrian 10
- Car 9
- Other 2
- Motorbike 1
offence 1
- Using a Mobile Phone Whilst Driving · 91 ✖
month 1
- 2025-11 · 91 ✖
disposal 1
- Fixed Penalty · 91 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20470 | op-snap---monthly-publication-november-2025.pdf | 12 | 2025-11 | Pedal Bike | Taxi | Black | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | |||
| 20528 | op-snap---monthly-publication-november-2025.pdf | 70 | 2025-11 | Pedal Bike | BMW | 320d | White | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20529 | op-snap---monthly-publication-november-2025.pdf | 71 | 2025-11 | Pedal Bike | Peugeot | 3008 | Blue | Using a Mobile Phone Whilst Driving | none | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20530 | op-snap---monthly-publication-november-2025.pdf | 72 | 2025-11 | Pedal Bike | Land Rover | Discovery | Black | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 20546 | op-snap---monthly-publication-november-2025.pdf | 88 | 2025-11 | Pedal Bike | Volkswagen | Tiguan | Grey | Using a Mobile Phone Whilst Driving | None | Salisbury Road, Moseley | Salisbury Road, Moseley | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4490203 | -1.8955977 | ||
| 20547 | op-snap---monthly-publication-november-2025.pdf | 89 | 2025-11 | Pedal Bike | Volkswagen | Tiguan | White | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 20587 | op-snap---monthly-publication-november-2025.pdf | 129 | 2025-11 | Pedal Bike | Nissan | Micra | Blue | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | ||
| 20590 | op-snap---monthly-publication-november-2025.pdf | 132 | 2025-11 | Other | Mercedes-Benz | A180.. | Silver | Using a Mobile Phone Whilst Driving | No Insurance | Newton Road | Newton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4541102 | -1.8710993 | ||
| 20605 | op-snap---monthly-publication-november-2025.pdf | 147 | 2025-11 | Pedal Bike | Seat | Terraco | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20606 | op-snap---monthly-publication-november-2025.pdf | 148 | 2025-11 | Pedal Bike | BMW | X1 | White | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 20618 | op-snap---monthly-publication-november-2025.pdf | 160 | 2025-11 | Pedestrian | Renault | Megane | Grey | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 20642 | op-snap---monthly-publication-november-2025.pdf | 184 | 2025-11 | Pedal Bike | Dacia | DUSTER | Blue | Using a Mobile Phone Whilst Driving | None | Far Gosfrod St | Far Gosfrod Street | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 20654 | op-snap---monthly-publication-november-2025.pdf | 196 | 2025-11 | Car | Dennis Bin lorry | White | Using a Mobile Phone Whilst Driving | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4308271 | -1.920078 | |||
| 20680 | op-snap---monthly-publication-november-2025.pdf | 222 | 2025-11 | Pedal Bike | Vauxhall | Vivaro | White | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 20682 | op-snap---monthly-publication-november-2025.pdf | 224 | 2025-11 | Motorbike | Fiat | 500l | White | Using a Mobile Phone Whilst Driving | None | Mount Pleasant | Mount Pleasant | Dudley | Dudley | Fixed Penalty | N/A | 52.4734063 | -2.1135639 | ||
| 20683 | op-snap---monthly-publication-november-2025.pdf | 225 | 2025-11 | Pedestrian | Nissan | Note | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 20685 | op-snap---monthly-publication-november-2025.pdf | 227 | 2025-11 | Pedal Bike | Renault | Clio | Red | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20686 | op-snap---monthly-publication-november-2025.pdf | 228 | 2025-11 | Pedal Bike | Vauxhall | Astra | Blue | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20687 | op-snap---monthly-publication-november-2025.pdf | 229 | 2025-11 | Pedal Bike | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | A45 | A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 20688 | op-snap---monthly-publication-november-2025.pdf | 230 | 2025-11 | Pedal Bike | Kia | Sportage | White | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 20704 | op-snap---monthly-publication-november-2025.pdf | 246 | 2025-11 | Pedal Bike | Mercedes-Benz | E250 | Silver | Using a Mobile Phone Whilst Driving | None | Far Gosford St | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4071231 | -1.4985178 | ||
| 20726 | op-snap---monthly-publication-november-2025.pdf | 268 | 2025-11 | Pedal Bike | Volkswagen | Transporter | Silver | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 20728 | op-snap---monthly-publication-november-2025.pdf | 270 | 2025-11 | Pedal Bike | BMW | X3 | Blue | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 20730 | op-snap---monthly-publication-november-2025.pdf | 272 | 2025-11 | Pedal Bike | Toyota | Prius | Silver | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 20757 | op-snap---monthly-publication-november-2025.pdf | 299 | 2025-11 | Pedal Bike | BMW | X1 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20758 | op-snap---monthly-publication-november-2025.pdf | 300 | 2025-11 | Pedal Bike | Audi | Q3 | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20766 | op-snap---monthly-publication-november-2025.pdf | 308 | 2025-11 | Pedal Bike | Nissan | X-Trail | Black | Using a Mobile Phone Whilst Driving | None | Longmore Street | Longmore Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.464484 | -1.8923374 | ||
| 20767 | op-snap---monthly-publication-november-2025.pdf | 309 | 2025-11 | Pedal Bike | Suzuki | Swift | Grey | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 20773 | op-snap---monthly-publication-november-2025.pdf | 315 | 2025-11 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | No vehicle excise licence | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20779 | op-snap---monthly-publication-november-2025.pdf | 321 | 2025-11 | Car | Hyundai | I10 | White | Using a Mobile Phone Whilst Driving | None | Brass House Lane | Brass House Lane | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 20785 | op-snap---monthly-publication-november-2025.pdf | 327 | 2025-11 | Pedal Bike | Land Rover | Freelander | Silver | Using a Mobile Phone Whilst Driving | None | Black Haynes Road | Black Haynes Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4260755 | -1.9679443 | ||
| 20818 | op-snap---monthly-publication-november-2025.pdf | 360 | 2025-11 | Pedal Bike | Fiat | Punto | Blue | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20819 | op-snap---monthly-publication-november-2025.pdf | 361 | 2025-11 | Pedal Bike | Tesla | Model Y | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 20821 | op-snap---monthly-publication-november-2025.pdf | 363 | 2025-11 | Pedal Bike | Citroen | C3 | Black | Using a Mobile Phone Whilst Driving | None | Bristol Street | Bristol Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4691145 | -1.9003257 | ||
| 20823 | op-snap---monthly-publication-november-2025.pdf | 365 | 2025-11 | Pedal Bike | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 20982 | op-snap---monthly-publication-november-2025.pdf | 524 | 2025-11 | Pedestrian | Suzuki | Celerio | White | Using a Mobile Phone Whilst Driving | None | Hill Street | Hill Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4777765 | -1.901321 | ||
| 20983 | op-snap---monthly-publication-november-2025.pdf | 525 | 2025-11 | Pedal Bike | Ford | Focus | Grey | Using a Mobile Phone Whilst Driving | None | Church Lane | Church Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4202618 | -1.6010473 | ||
| 20986 | op-snap---monthly-publication-november-2025.pdf | 528 | 2025-11 | Pedal Bike | BMW | 320.. | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21004 | op-snap---monthly-publication-november-2025.pdf | 546 | 2025-11 | Pedal Bike | Fiat | 500 Abarth | Yellow | Using a Mobile Phone Whilst Driving | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4943878 | -1.8504211 | ||
| 21057 | op-snap---monthly-publication-november-2025.pdf | 599 | 2025-11 | Pedal Bike | Tesla | Model Y | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 21080 | op-snap---monthly-publication-november-2025.pdf | 622 | 2025-11 | Car | Toyota | Aygo | White | Using a Mobile Phone Whilst Driving | None | Birmingham Road Dudley | Birmingham Road Dudley | Dudley | Dudley | Fixed Penalty | N/A | 52.5130612 | -2.0648903 | ||
| 21083 | op-snap---monthly-publication-november-2025.pdf | 625 | 2025-11 | Pedal Bike | Audi | Q5 | Silver | Using a Mobile Phone Whilst Driving | No Seat Belt | Boleyn Road, Rubery | Boleyn Road, Rubery | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 21109 | op-snap---monthly-publication-november-2025.pdf | 651 | 2025-11 | Pedal Bike | Peugeot | 308.. | Blue | Using a Mobile Phone Whilst Driving | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4041117 | -1.5595662 | ||
| 21110 | op-snap---monthly-publication-november-2025.pdf | 652 | 2025-11 | Pedal Bike | Mercedes-Benz | C220.. | White | Using a Mobile Phone Whilst Driving | None | A45 at Sir Henry Parkes Drive | A45 at Sir Henry Parkes Drive | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 21111 | op-snap---monthly-publication-november-2025.pdf | 653 | 2025-11 | Pedal Bike | Fiat | Ducato | Black | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 21112 | op-snap---monthly-publication-november-2025.pdf | 654 | 2025-11 | Pedal Bike | BMW | 520D | Black | Using a Mobile Phone Whilst Driving | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4381959 | -1.8907391 | ||
| 21269 | op-snap---monthly-publication-november-2025.pdf | 811 | 2025-11 | Car | Peugeot | Bipper | White | Using a Mobile Phone Whilst Driving | None | Cinder Road | Cinder Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5128626 | -2.1348738 | ||
| 21369 | op-snap---monthly-publication-november-2025.pdf | 911 | 2025-11 | Pedal Bike | Nissan | Qashqai | Silver | Using a Mobile Phone Whilst Driving | None | Hinckley Road | Hinckley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.435502 | -1.4327166 | ||
| 21382 | op-snap---monthly-publication-november-2025.pdf | 924 | 2025-11 | Pedal Bike | Volkswagen | ID4 | Red | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4134557 | -1.4442138 | ||
| 21384 | op-snap---monthly-publication-november-2025.pdf | 926 | 2025-11 | Pedal Bike | Renault | Megane | Black | Using a Mobile Phone Whilst Driving | None | Hinckley Road | Hinckley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.435502 | -1.4327166 | ||
| 21385 | op-snap---monthly-publication-november-2025.pdf | 927 | 2025-11 | Pedal Bike | BMW | 218D | Grey | Using a Mobile Phone Whilst Driving | None | Moseley Av Cov | Moseley Avenue Cov | Coventry | Coventry | Fixed Penalty | N/A | 52.417344 | -1.5264979 | ||
| 21468 | op-snap---monthly-publication-november-2025.pdf | 1010 | 2025-11 | Pedal Bike | Ford | Ranger | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 21469 | op-snap---monthly-publication-november-2025.pdf | 1011 | 2025-11 | Other | Volkswagen | Polo | Silver | Using a Mobile Phone Whilst Driving | None | Dawlish Road | Dawlish Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4438979 | -1.9316285 | ||
| 21505 | op-snap---monthly-publication-november-2025.pdf | 1047 | 2025-11 | Pedal Bike | Mercedes-Benz | E220 | White | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 21506 | op-snap---monthly-publication-november-2025.pdf | 1048 | 2025-11 | Pedal Bike | Citroen | Relay | White | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 21510 | op-snap---monthly-publication-november-2025.pdf | 1052 | 2025-11 | Pedal Bike | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | Earlsdon Avenue North | Earlsdon Avenue North | Coventry | Coventry | Fixed Penalty | N/A | 52.4025196 | -1.5327802 | ||
| 21515 | op-snap---monthly-publication-november-2025.pdf | 1057 | 2025-11 | Pedal Bike | Audi | Q5 | Black | Using a Mobile Phone Whilst Driving | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 21524 | op-snap---monthly-publication-november-2025.pdf | 1066 | 2025-11 | Car | Mercedes-Benz | B Class | Black | Using a Mobile Phone Whilst Driving | None | Holliday Street | Holliday Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4780205 | -1.9047506 | ||
| 21547 | op-snap---monthly-publication-november-2025.pdf | 1089 | 2025-11 | Car | Toyota | Yaris | Silver | Using a Mobile Phone Whilst Driving | None | Broadway | Broadway | Walsall | Walsall | Fixed Penalty | N/A | 52.5719937 | -1.9639882 | ||
| 21552 | op-snap---monthly-publication-november-2025.pdf | 1094 | 2025-11 | Pedestrian | Toyota | Aygo | White | Using a Mobile Phone Whilst Driving | None | Hagley Road, Birmingham | Hagley Road, Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4720702 | -1.9367526 | ||
| 21565 | op-snap---monthly-publication-november-2025.pdf | 1107 | 2025-11 | Pedestrian | Audi | A1 | Black | Using a Mobile Phone Whilst Driving | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4720132 | -1.9142946 | ||
| 21566 | op-snap---monthly-publication-november-2025.pdf | 1108 | 2025-11 | Pedestrian | Kia | Sportage | Blue | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 21579 | op-snap---monthly-publication-november-2025.pdf | 1121 | 2025-11 | Pedestrian | Volkswagen | ID4 | Grey | Using a Mobile Phone Whilst Driving | None | Heaton Road, Solihull | Heaton Road, Solihull | Solihull | Solihull | Fixed Penalty | N/A | 52.4284827 | -1.7951002 | ||
| 21586 | op-snap---monthly-publication-november-2025.pdf | 1128 | 2025-11 | Pedestrian | Nissan | Micra | Silver | Using a Mobile Phone Whilst Driving | None | Cartland Road | Cartland Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4298554 | -1.9086629 | ||
| 21641 | op-snap---monthly-publication-november-2025.pdf | 1183 | 2025-11 | Pedal Bike | Nissan | Qashqai | Blue | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 21659 | op-snap---monthly-publication-november-2025.pdf | 1201 | 2025-11 | Pedal Bike | Volkswagen | Sharan | Silver | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4070602 | -1.4732469 | ||
| 21661 | op-snap---monthly-publication-november-2025.pdf | 1203 | 2025-11 | Pedal Bike | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 21662 | op-snap---monthly-publication-november-2025.pdf | 1204 | 2025-11 | Pedal Bike | Toyota | Yaris | Red | Using a Mobile Phone Whilst Driving | None | Humber Road | Humber Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4050667 | -1.4866877 | ||
| 21663 | op-snap---monthly-publication-november-2025.pdf | 1205 | 2025-11 | Pedal Bike | Citroen | C3 | White | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 21664 | op-snap---monthly-publication-november-2025.pdf | 1206 | 2025-11 | Pedal Bike | Audi | Q3 | Grey | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4070602 | -1.4732469 | ||
| 21700 | op-snap---monthly-publication-november-2025.pdf | 1242 | 2025-11 | Pedal Bike | BMW | 120d | Blue | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21703 | op-snap---monthly-publication-november-2025.pdf | 1245 | 2025-11 | Pedal Bike | Mercedes-Benz | C250 | Silver | Using a Mobile Phone Whilst Driving | None | Bell Green Lane | Bell Green Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.3995055 | -1.5349094 | ||
| 21705 | op-snap---monthly-publication-november-2025.pdf | 1247 | 2025-11 | Pedal Bike | Mitsubishi | Outlander | Silver | Using a Mobile Phone Whilst Driving | None | Proffitt Av | Proffitt Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.4330807 | -1.4816593 | ||
| 21706 | op-snap---monthly-publication-november-2025.pdf | 1248 | 2025-11 | Pedal Bike | Vauxhall | Mokka | Orange | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21709 | op-snap---monthly-publication-november-2025.pdf | 1251 | 2025-11 | Pedal Bike | Jaguar | XE.. | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21711 | op-snap---monthly-publication-november-2025.pdf | 1253 | 2025-11 | Car | Volkswagen | Tiguan | White | Using a Mobile Phone Whilst Driving | None | Bromford Road | Bromford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.503036 | -1.8289972 | ||
| 21859 | op-snap---monthly-publication-november-2025.pdf | 1401 | 2025-11 | Pedal Bike | Porsche | Macan | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 21860 | op-snap---monthly-publication-november-2025.pdf | 1402 | 2025-11 | Pedal Bike | Mercedes-Benz | GLA180 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 21861 | op-snap---monthly-publication-november-2025.pdf | 1403 | 2025-11 | Pedal Bike | BMW | IX3 | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 21862 | op-snap---monthly-publication-november-2025.pdf | 1404 | 2025-11 | Pedal Bike | Nissan | Micra | Grey | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 21863 | op-snap---monthly-publication-november-2025.pdf | 1405 | 2025-11 | Pedal Bike | Porsche | Macan | Black | Using a Mobile Phone Whilst Driving | None | High Street, Harborne | High Street, Harborne | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612733 | -1.9430543 | ||
| 21864 | op-snap---monthly-publication-november-2025.pdf | 1406 | 2025-11 | Pedal Bike | Land Rover | Discovery | Black | Using a Mobile Phone Whilst Driving | None | High Street, Harborne | High Street, Harborne | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612733 | -1.9430543 | ||
| 21923 | op-snap---monthly-publication-november-2025.pdf | 1465 | 2025-11 | Pedal Bike | Rolls-Royce | Ghost | Orange | Using a Mobile Phone Whilst Driving | None | Navigation Street | Navigation Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4781877 | -1.9011642 | ||
| 21924 | op-snap---monthly-publication-november-2025.pdf | 1466 | 2025-11 | Pedal Bike | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4071231 | -1.4985178 | ||
| 21954 | op-snap---monthly-publication-november-2025.pdf | 1496 | 2025-11 | Pedal Bike | BMW | X5 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 21955 | op-snap---monthly-publication-november-2025.pdf | 1497 | 2025-11 | Pedal Bike | Mercedes-Benz | C220 | Black | Using a Mobile Phone Whilst Driving | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 21957 | op-snap---monthly-publication-november-2025.pdf | 1499 | 2025-11 | Car | Land Rover | Discovery | Silver | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 21973 | op-snap---monthly-publication-november-2025.pdf | 1515 | 2025-11 | Car | Peugeot | RCZ | White | Using a Mobile Phone Whilst Driving | None | M42 | M42 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 22011 | op-snap---monthly-publication-november-2025.pdf | 1553 | 2025-11 | Pedestrian | Tesla | Model 3 | Grey | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 22012 | op-snap---monthly-publication-november-2025.pdf | 1554 | 2025-11 | Pedestrian | Lexus | NH | Black | Using a Mobile Phone Whilst Driving | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543565 | -1.9114004 | ||
| 22027 | op-snap---monthly-publication-november-2025.pdf | 1569 | 2025-11 | Pedal Bike | BMW | 3 series | Black | Using a Mobile Phone Whilst Driving | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4353506 | -1.8927483 |
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);