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 council_area = "Coventry" and month = "2025-02" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 28
offence 18
- Using a Mobile Phone Whilst Driving 41
- Driving without Due Care and Attention 36
- Driving without Reasonable Consideration 36
- Stop a vehicle within pelican pedestrian crossing limits 27
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 16
- Contravening a Red Traffic Light 14
- Cause vehicle to be left in a dangerous position 8
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Stop a vehicle on pedestrian crossing 3
- Misc - Non Traffic Offences 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Driver not in position to have Proper Control 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Seat Belt 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- VRM fails to conform to Regulations 1
reporter_transport_mode 7
- Pedal Bike 92
- Pedestrian 51
- Car 48
- Bus 2
- CAR 1
- Lorry 1
- car 1
disposal 5
- Fixed Penalty 92
- Education 55
- Warning Letter 24
- Court 15
- NFA 10
month 1
- 2025-02 · 196 ✖
council_area 1
- Coventry · 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5183 | op-snap---monthly-publication-february-2025.pdf | 0 | 2025-02 | Pedestrian | Volkswagen | AMAROK | Grey | Cause vehicle to be left in a dangerous position | None | WASTE LANE | Waste Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.437361 | -1.5371291 | |
| 5214 | op-snap---monthly-publication-february-2025.pdf | 31 | 2025-02 | Pedal Bike | BMW | 320D | Silver | Driving without Reasonable Consideration | None | Wall Hill Road | Wall Hill Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4459445 | -1.5552508 | |
| 5218 | op-snap---monthly-publication-february-2025.pdf | 35 | 2025-02 | Car | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 5219 | op-snap---monthly-publication-february-2025.pdf | 36 | 2025-02 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | Sewall Highway | Sewall Highway | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4318623 | -1.4804069 | |
| 5223 | op-snap---monthly-publication-february-2025.pdf | 40 | 2025-02 | Car | Honda | SH 125 AD-K | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 5228 | op-snap---monthly-publication-february-2025.pdf | 45 | 2025-02 | Car | Nissan | QASHQUI | Black | Contravening a Red Traffic Light | None | QUINTON ROAD | Quinton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4028847 | -1.5082329 | |
| 5272 | op-snap---monthly-publication-february-2025.pdf | 89 | 2025-02 | Pedal Bike | Volkswagen | Taigo | White | Driving without Reasonable Consideration | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 5273 | op-snap---monthly-publication-february-2025.pdf | 90 | 2025-02 | Pedestrian | Honda | Civic | Blue | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 5281 | op-snap---monthly-publication-february-2025.pdf | 98 | 2025-02 | Pedal Bike | Kia | Picanto | Yellow | Driving without Due Care and Attention | None | Allard Way | Allard Way | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3955174 | -1.4685442 | |
| 5286 | op-snap---monthly-publication-february-2025.pdf | 103 | 2025-02 | Car | Toyota | Prius | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Narberth Way | Narberth Way | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4306797 | -1.4440324 | |
| 5339 | op-snap---monthly-publication-february-2025.pdf | 156 | 2025-02 | Pedal Bike | Toyota | Estima | Grey | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5342 | op-snap---monthly-publication-february-2025.pdf | 159 | 2025-02 | Pedal Bike | Volkswagen | Passat | Silver | Driving without Reasonable Consideration | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5344 | op-snap---monthly-publication-february-2025.pdf | 161 | 2025-02 | Pedal Bike | Nissan | Red | Driving without Reasonable Consideration | None | Deedmore Road | Deedmore Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4373935 | -1.4615405 | ||
| 5345 | op-snap---monthly-publication-february-2025.pdf | 162 | 2025-02 | Pedal Bike | Audi | S3 | Black | Driving without Reasonable Consideration | None | Deedmore Road | Deedmore Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4373935 | -1.4615405 | |
| 5346 | op-snap---monthly-publication-february-2025.pdf | 163 | 2025-02 | Pedal Bike | Scania | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | ||
| 5348 | op-snap---monthly-publication-february-2025.pdf | 165 | 2025-02 | Pedal Bike | Ford | Mondeo | Red | Driving without Reasonable Consideration | None | Deedmore Road | Deedmore Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4373935 | -1.4615405 | |
| 5362 | op-snap---monthly-publication-february-2025.pdf | 179 | 2025-02 | Pedal Bike | Renault | Captur | Grey | Driving without Reasonable Consideration | None | Waste Lane | Waste Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.437361 | -1.5371291 | |
| 5415 | op-snap---monthly-publication-february-2025.pdf | 232 | 2025-02 | Car | Daf | Orange | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4073149 | -1.5250454 | ||
| 5416 | op-snap---monthly-publication-february-2025.pdf | 233 | 2025-02 | Car | Volkswagen | GOLF | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | LEICESTER ROW | Leicester Row | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.414317 | -1.5104573 | |
| 5419 | op-snap---monthly-publication-february-2025.pdf | 236 | 2025-02 | Pedal Bike | Audi | A4 | Black | Driving without Due Care and Attention | None | Gulson Road | Gulson Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4076795 | -1.4911676 | |
| 5428 | op-snap---monthly-publication-february-2025.pdf | 245 | 2025-02 | Car | Citroen | DS3 | Purple | Contravening a Red Traffic Light | None | MOSELEY AVENUE | Moseley Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | 52.417344 | -1.5264979 | |
| 5451 | op-snap---monthly-publication-february-2025.pdf | 268 | 2025-02 | Pedal Bike | Land Rover | Range Rover | Black | Driving without Reasonable Consideration | None | Charter Avenue | Charter Avenue | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3928409 | -1.5888076 | |
| 5488 | op-snap---monthly-publication-february-2025.pdf | 305 | 2025-02 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 5491 | op-snap---monthly-publication-february-2025.pdf | 308 | 2025-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Gibbet Hill Road | Gibbet Hill Road | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.3749141 | -1.5564977 | |
| 5509 | op-snap---monthly-publication-february-2025.pdf | 326 | 2025-02 | Pedal Bike | Nissan | Qashqai | Blue | Driving without Due Care and Attention | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 5510 | op-snap---monthly-publication-february-2025.pdf | 327 | 2025-02 | Pedal Bike | Ford | Fiesta | Blue | Driving without Reasonable Consideration | None | Willenhall Lane | Willenhall Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3983962 | -1.4423958 | |
| 5512 | op-snap---monthly-publication-february-2025.pdf | 329 | 2025-02 | Pedal Bike | Volkswagen | T-Cross | Blue | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5513 | op-snap---monthly-publication-february-2025.pdf | 330 | 2025-02 | Pedal Bike | Mini | Cooper | Blue | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5528 | op-snap---monthly-publication-february-2025.pdf | 345 | 2025-02 | Bus | Ford | Kuga | Green | VRM fails to conform to Regulations | None | Kenilworth Road, Coventry | Kenilworth Road, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3833298 | -1.5379214 | |
| 5538 | op-snap---monthly-publication-february-2025.pdf | 355 | 2025-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Rowleys Green Roundabout | Rowleys Green Roundabout | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4486967 | -1.4991069 | |
| 5540 | op-snap---monthly-publication-february-2025.pdf | 357 | 2025-02 | Car | Vauxhall | Corsa | Silver | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4380313 | -1.5339558 | |
| 5554 | op-snap---monthly-publication-february-2025.pdf | 371 | 2025-02 | Pedestrian | Volkswagen | Golf | White | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.3916468 | -1.4925995 | |
| 5572 | op-snap---monthly-publication-february-2025.pdf | 389 | 2025-02 | Car | Mg | HS | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4041117 | -1.5595662 | |
| 5576 | op-snap---monthly-publication-february-2025.pdf | 393 | 2025-02 | Car | Toyota | Verso | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 5586 | op-snap---monthly-publication-february-2025.pdf | 403 | 2025-02 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | No Insurance | Halford Lane, Coventry | Halford Lane, Coventry | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.4398231 | -1.526811 | |
| 5587 | op-snap---monthly-publication-february-2025.pdf | 404 | 2025-02 | Pedestrian | Mg | HS Trophy | White | Driving without Due Care and Attention | None | Shetland Close | Shetland Close | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4156476 | -1.5736772 | |
| 5697 | op-snap---monthly-publication-february-2025.pdf | 514 | 2025-02 | Pedal Bike | Mercedes-Benz | A180 | White | Driving without Reasonable Consideration | None | Allesley OId Road | Allesley OId Road | Coventry | Coventry | Education | N/A | Yes - Via Email | |||
| 5733 | op-snap---monthly-publication-february-2025.pdf | 550 | 2025-02 | Pedal Bike | Vauxhall | INSIGNIA | White | Stop a vehicle within pelican pedestrian crossing limits | None | FOLESHILL ROAD | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 5734 | op-snap---monthly-publication-february-2025.pdf | 551 | 2025-02 | Pedal Bike | Tesla | Y | Black | Using a Mobile Phone Whilst Driving | No Insurance | FAR GODFORD ROAD | Far Godford Road | Coventry | Coventry | Court | N/A | Yes - Via Email | |||
| 5742 | op-snap---monthly-publication-february-2025.pdf | 559 | 2025-02 | Pedal Bike | Volkswagen | Taigo | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4324855 | -1.4815548 | |
| 5757 | op-snap---monthly-publication-february-2025.pdf | 574 | 2025-02 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | A444 Coventry | Coventry | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.400739 | -1.5135474 | |
| 5775 | op-snap---monthly-publication-february-2025.pdf | 592 | 2025-02 | Pedestrian | Suzuki | SX4 | Silver | Cause vehicle to be left in a dangerous position | None | Coat of Arms Bridge Road Cov | Coat of Arms Bridge Road Cov | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3881147 | -1.5283476 | |
| 5777 | op-snap---monthly-publication-february-2025.pdf | 594 | 2025-02 | Pedestrian | Volkswagen | Golf | Silver | Cause vehicle to be left in a dangerous position | None | Dewsbury Avenue Coventry | Dewsbury Avenue Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5779 | op-snap---monthly-publication-february-2025.pdf | 596 | 2025-02 | Pedestrian | Hyundai | Tucson | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | none | Dewsbury Avenue Coventry | Dewsbury Avenue Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5787 | op-snap---monthly-publication-february-2025.pdf | 604 | 2025-02 | Car | BMW | 3series | Grey | Driving without Reasonable Consideration | None | Walsgrove Road, Coventry | Walsgrove Road, Coventry | Coventry | Coventry | NFA | No VRM | Yes - Via Email | |||
| 5809 | op-snap---monthly-publication-february-2025.pdf | 626 | 2025-02 | Pedestrian | Mercedes-Benz | EQC | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5810 | op-snap---monthly-publication-february-2025.pdf | 627 | 2025-02 | Pedestrian | Mercedes-Benz | E220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5811 | op-snap---monthly-publication-february-2025.pdf | 628 | 2025-02 | Car | Peugeot | BOXER | White | Driving without Due Care and Attention | None | M6 JCT 2 | M6 Jct 2 | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.676119 | -2.0858425 | |
| 5813 | op-snap---monthly-publication-february-2025.pdf | 630 | 2025-02 | Pedestrian | BMW | X6 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5820 | op-snap---monthly-publication-february-2025.pdf | 637 | 2025-02 | Pedestrian | Peugeot | 508 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moo Street, Coventry | Moo Street, Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 5836 | op-snap---monthly-publication-february-2025.pdf | 653 | 2025-02 | Pedestrian | BMW | X6 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Avenue, Coventry | Earlsdon Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.398248 | -1.528263 | |
| 5837 | op-snap---monthly-publication-february-2025.pdf | 654 | 2025-02 | Pedestrian | Peugeot | 206 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Avenue, Coventry | Earlsdon Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.398248 | -1.528263 | |
| 5843 | op-snap---monthly-publication-february-2025.pdf | 660 | 2025-02 | Pedestrian | Van | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | ||
| 5855 | op-snap---monthly-publication-february-2025.pdf | 672 | 2025-02 | Pedestrian | BMW | X1 | Grey | Cause vehicle to be left in a dangerous position | None | Coat of Arms Bridge Road | Coat of Arms Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3887077 | -1.5308677 | |
| 5862 | op-snap---monthly-publication-february-2025.pdf | 679 | 2025-02 | Pedal Bike | Mercedes-Benz | Van | White | Driving without Due Care and Attention | None | Charter Avenue, Coventry | Charter Avenue, Coventry | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.3931842 | -1.578222 | |
| 5881 | op-snap---monthly-publication-february-2025.pdf | 698 | 2025-02 | Pedal Bike | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Binley Road, Coventry | Binley Road, Coventry | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.4047676 | -1.4613118 | |
| 5883 | op-snap---monthly-publication-february-2025.pdf | 700 | 2025-02 | Pedal Bike | Ford | Focus | White | Driving without Due Care and Attention | None | Proffitt Avenue, Coventry | Proffitt Avenue, Coventry | Coventry | Coventry | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4330807 | -1.4816593 | |
| 5887 | op-snap---monthly-publication-february-2025.pdf | 704 | 2025-02 | Pedal Bike | Toyota | Corolla | Silver | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5888 | op-snap---monthly-publication-february-2025.pdf | 705 | 2025-02 | Pedal Bike | Vauxhall | Vivaro | Grey | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5890 | op-snap---monthly-publication-february-2025.pdf | 707 | 2025-02 | Pedal Bike | Mg | HS | Grey | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5891 | op-snap---monthly-publication-february-2025.pdf | 708 | 2025-02 | Pedal Bike | Peugeot | 3008 | Gold | No Seat Belt | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5893 | op-snap---monthly-publication-february-2025.pdf | 710 | 2025-02 | Pedal Bike | Nissan | Note | Grey | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5894 | op-snap---monthly-publication-february-2025.pdf | 711 | 2025-02 | Pedal Bike | Honda | Jazz | Silver | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5897 | op-snap---monthly-publication-february-2025.pdf | 714 | 2025-02 | Pedal Bike | Toyota | YARIS | Silver | Using a Mobile Phone Whilst Driving | None | WOODWAY LANE | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5900 | op-snap---monthly-publication-february-2025.pdf | 717 | 2025-02 | Pedal Bike | Kia | PICANTO | Red | Using a Mobile Phone Whilst Driving | None | WOODWAY LANE | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 5901 | op-snap---monthly-publication-february-2025.pdf | 718 | 2025-02 | Pedal Bike | Kia | NIRO | Red | Using a Mobile Phone Whilst Driving | None | CLIFFORD BRIDGE ROAD | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 5917 | op-snap---monthly-publication-february-2025.pdf | 734 | 2025-02 | Pedestrian | Mercedes-Benz | Vito | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gateside Road Coventry | Gateside Road Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4400759 | -1.4966907 | |
| 5918 | op-snap---monthly-publication-february-2025.pdf | 735 | 2025-02 | Pedestrian | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gateside Road Coventry | Gateside Road Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4400759 | -1.4966907 | |
| 5919 | op-snap---monthly-publication-february-2025.pdf | 736 | 2025-02 | Pedestrian | Peugeot | 308 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gateside Road Coventry | Gateside Road Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4400759 | -1.4966907 | |
| 5920 | op-snap---monthly-publication-february-2025.pdf | 737 | 2025-02 | Pedestrian | BMW | X1 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gateside Road Coventry | Gateside Road Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4400759 | -1.4966907 | |
| 5944 | op-snap---monthly-publication-february-2025.pdf | 761 | 2025-02 | Car | Toyota | Corolla | Blue | Motor vehicle fail to comply with solid white line road markings | None | A45 exit slip (Jct 6 M42 Island) | A45 exit slip (Junction 6 M42 Island) | Coventry | Coventry | Education | N/A | Yes - Via Email | |||
| 5954 | op-snap---monthly-publication-february-2025.pdf | 771 | 2025-02 | Pedal Bike | Mercedes-Benz | Van | White | Contravening a Red Traffic Light | None | Ansty Road, Coventry | Ansty Road, Coventry | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4205675 | -1.4520187 | |
| 5956 | op-snap---monthly-publication-february-2025.pdf | 773 | 2025-02 | Pedal Bike | Nissan | Micra | White | Using a Mobile Phone Whilst Driving | None | Woodway Lane, Coventry | Woodway Lane, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.425388 | -1.4441933 | |
| 5964 | op-snap---monthly-publication-february-2025.pdf | 781 | 2025-02 | Pedal Bike | Land Rover | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge, Coventry | Clifford Bridge, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | ||
| 5982 | op-snap---monthly-publication-february-2025.pdf | 799 | 2025-02 | Pedal Bike | BMW | I4 | Grey | Driving without Reasonable Consideration | None | Foleshill Rd | Foleshill Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 6006 | op-snap---monthly-publication-february-2025.pdf | 823 | 2025-02 | Pedestrian | Volkswagen | XC90 | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road Coventry | Bell Green Road Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4361538 | -1.4756447 | |
| 6008 | op-snap---monthly-publication-february-2025.pdf | 825 | 2025-02 | Pedestrian | Seat | Arona | White | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 6011 | op-snap---monthly-publication-february-2025.pdf | 828 | 2025-02 | Pedestrian | Ford | Transit | Silver | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4324855 | -1.4815548 | |
| 6012 | op-snap---monthly-publication-february-2025.pdf | 829 | 2025-02 | Pedal Bike | Mercedes-Benz | E220 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road, Coventry | Stoney Stanton Road, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 6019 | op-snap---monthly-publication-february-2025.pdf | 836 | 2025-02 | Pedal Bike | BMW | I5 E Drive | Blue | Using a Mobile Phone Whilst Driving | None | Blackberry Lane Coventry | Blackberry Lane Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4254016 | -1.4665041 | |
| 6022 | op-snap---monthly-publication-february-2025.pdf | 839 | 2025-02 | Pedal Bike | Toyota | Prius | Silver | Using a Mobile Phone Whilst Driving | None | Far Gosford Street, | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 6027 | op-snap---monthly-publication-february-2025.pdf | 844 | 2025-02 | Car | White | Stop a vehicle within pelican pedestrian crossing limits | None | EARLSDON STREET | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |||
| 6031 | op-snap---monthly-publication-february-2025.pdf | 848 | 2025-02 | Pedal Bike | Citroen | Berlingo | Black | Stop a vehicle within pelican pedestrian crossing limits | Use vehicle on a road without valid test certificate | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 6048 | op-snap---monthly-publication-february-2025.pdf | 865 | 2025-02 | Pedestrian | Peugeot | 2008 | Grey | Using a Mobile Phone Whilst Driving | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4103629 | -1.5441218 | |
| 6059 | op-snap---monthly-publication-february-2025.pdf | 876 | 2025-02 | Pedal Bike | Land Rover | Discovery 4 | White | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Coventry | Clifford Bridge Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6062 | op-snap---monthly-publication-february-2025.pdf | 879 | 2025-02 | Pedal Bike | Volkswagen | Caddy | White | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Coventry | Clifford Bridge Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6065 | op-snap---monthly-publication-february-2025.pdf | 882 | 2025-02 | Pedal Bike | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6066 | op-snap---monthly-publication-february-2025.pdf | 883 | 2025-02 | Pedal Bike | Seat | Cupra | Grey | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6067 | op-snap---monthly-publication-february-2025.pdf | 884 | 2025-02 | Pedal Bike | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6068 | op-snap---monthly-publication-february-2025.pdf | 885 | 2025-02 | Pedal Bike | Toyota | Prius | Silver | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6070 | op-snap---monthly-publication-february-2025.pdf | 887 | 2025-02 | Pedal Bike | BMW | M5 | Blue | Using a Mobile Phone Whilst Driving | Use vehicle on a road without valid test certificate | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6073 | op-snap---monthly-publication-february-2025.pdf | 890 | 2025-02 | Pedestrian | Nissan | Qashqai | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Catesby Road | Catesby Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4346221 | -1.5163727 | |
| 6075 | op-snap---monthly-publication-february-2025.pdf | 892 | 2025-02 | Pedestrian | Mercedes-Benz | C300 | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Catesby Road | Catesby Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4346221 | -1.5163727 | |
| 6085 | op-snap---monthly-publication-february-2025.pdf | 902 | 2025-02 | Car | Skoda | Octavia | Black | Driving without Due Care and Attention | None | Lythalls Lane | Lythalls Lane | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.4414384 | -1.4964531 | |
| 6104 | op-snap---monthly-publication-february-2025.pdf | 921 | 2025-02 | Car | Iveco Eurocargo | Red | Driving without Due Care and Attention | None | Cromwell Lane | Cromwell Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3961178 | -1.5956542 | ||
| 6109 | op-snap---monthly-publication-february-2025.pdf | 926 | 2025-02 | Pedal Bike | Peugeot | Partner | White | Driver not in position to have Proper Control | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 6114 | op-snap---monthly-publication-february-2025.pdf | 931 | 2025-02 | Pedal Bike | Ford | Transit | Silver | Driving without Due Care and Attention | None | Raglan Street | Raglan Street | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.4102012 | -1.5006637 | |
| 6118 | op-snap---monthly-publication-february-2025.pdf | 935 | 2025-02 | Pedal Bike | BMW | X1 | White | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 6120 | op-snap---monthly-publication-february-2025.pdf | 937 | 2025-02 | Pedal Bike | Volvo | Car Transporter | Orange | Driving without Reasonable Consideration | None | Ansty Road | Ansty Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4205675 | -1.4520187 | |
| 6124 | op-snap---monthly-publication-february-2025.pdf | 941 | 2025-02 | Pedal Bike | Nissan | Qashqai | Grey | Driving without Reasonable Consideration | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4096725 | -1.487901 |
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);