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'}
141 rows where council_area = "Coventry" and month = "2025-06" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 26
offence 16
- Driving without Due Care and Attention 57
- Contravening a Red Traffic Light 27
- Using a Mobile Phone Whilst Driving 12
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 11
- Cause vehicle to be left in a dangerous position 6
- Misc - Non Traffic Offences 6
- Stop a vehicle within pelican pedestrian crossing limits 5
- Driving without Reasonable Consideration 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Stop a vehicle on pedestrian crossing 3
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Driving a vehicle wholly or partly on a footpath 1
- Fail to Conform to Cycle Lane 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
reporter_transport_mode 7
- Car 88
- Pedal Bike 31
- Pedestrian 15
- Other 4
- Horse Rider 1
- Van 1
- car 1
disposal 7
- NFA 60
- Education 31
- Warning Letter 24
- Fixed Penalty 12
- Court 9
- RTC - Actioned 3
- Other Action Taken 2
month 1
- 2025-06 · 141 ✖
council_area 1
- Coventry · 141 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14094 | op-snap---monthly-publication-june-2025.pdf | 23 | 2025-06 | Car | Seat | Altea | Silver | Driving without Due Care and Attention | None | Stonebridge Highway | Stonebridge Highway | Coventry | Coventry | Court | N/A | 52.3782187 | -1.478696 | ||
| 14096 | op-snap---monthly-publication-june-2025.pdf | 25 | 2025-06 | Car | Renault | CLIO | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ALBANY ROAD | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4006218 | -1.5284125 | ||
| 14100 | op-snap---monthly-publication-june-2025.pdf | 29 | 2025-06 | Car | BMW | X6 | White | Driving without Due Care and Attention | None | Rowleys Green Roundabout | Rowleys Green Roundabout | Coventry | Coventry | Warning Letter | N/A | 52.4486967 | -1.4991069 | ||
| 14125 | op-snap---monthly-publication-june-2025.pdf | 54 | 2025-06 | Car | BMW | 420d | Black | Driving without Due Care and Attention | None | Much Park Street | Much Park Street | Coventry | Coventry | Court | N/A | 52.4061531 | -1.505845 | ||
| 14133 | op-snap---monthly-publication-june-2025.pdf | 62 | 2025-06 | Car | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.418488 | -1.5472387 | ||
| 14146 | op-snap---monthly-publication-june-2025.pdf | 75 | 2025-06 | Car | Toyota | Aygo | Silver | Driving without Reasonable Consideration | None | Radford Road | Radford Road | Coventry | Coventry | Education | N/A | 52.4235908 | -1.5226276 | ||
| 14153 | op-snap---monthly-publication-june-2025.pdf | 82 | 2025-06 | car | Seat | Ibiza | White | Driving without Due Care and Attention | None | Coventry ring road | Coventry ring road | Coventry | Coventry | NFA | No Offence | ||||
| 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 | ||
| 14209 | op-snap---monthly-publication-june-2025.pdf | 138 | 2025-06 | Car | Dacia | Sandero | Orange | Driving without Due Care and Attention | None | A46 Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Education | N/A | 52.3793117 | -1.4625379 | ||
| 14217 | op-snap---monthly-publication-june-2025.pdf | 146 | 2025-06 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | Warning Letter | N/A | 52.4459998 | -1.6949291 | ||
| 14225 | op-snap---monthly-publication-june-2025.pdf | 154 | 2025-06 | Car | BMW | M440i | Black | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 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 | ||
| 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 | ||
| 14321 | op-snap---monthly-publication-june-2025.pdf | 250 | 2025-06 | Car | Fiat | Punto | Red | No Seat Belt | None | A45 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 14345 | op-snap---monthly-publication-june-2025.pdf | 274 | 2025-06 | Car | Fiat | Punto | Blue | Driving without Due Care and Attention | None | Prologis Park | Prologis Park | Coventry | Coventry | NFA | No Offence | 52.4552589 | -1.5260803 | ||
| 14363 | op-snap---monthly-publication-june-2025.pdf | 292 | 2025-06 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Brays Road | Brays Road | Coventry | Coventry | Education | N/A | 52.4576718 | -1.7968647 | ||
| 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 | ||
| 14371 | op-snap---monthly-publication-june-2025.pdf | 300 | 2025-06 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | Baginton | Baginton | Coventry | Coventry | NFA | Out of Force | 52.3800804 | -1.4748304 | |||
| 14383 | op-snap---monthly-publication-june-2025.pdf | 312 | 2025-06 | Car | Toyota | Aygo | Silver | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4373088 | -1.504993 | ||
| 14384 | op-snap---monthly-publication-june-2025.pdf | 313 | 2025-06 | Car | BMW | Black | Contravening a Red Traffic Light | None | Ash Green | Ash Green | Coventry | Coventry | NFA | No VRM | 52.4203416 | -1.5763062 | |||
| 14401 | op-snap---monthly-publication-june-2025.pdf | 330 | 2025-06 | Car | Skoda | Enyaq | Black | Driving without Due Care and Attention | None | A444 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 14406 | op-snap---monthly-publication-june-2025.pdf | 335 | 2025-06 | Car | BMW | 540i | Black | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | RTC - Actioned | N/A | 52.4214017 | -1.4870278 | ||
| 14420 | op-snap---monthly-publication-june-2025.pdf | 349 | 2025-06 | Car | Volkswagen | Sharan | Black | Using a Mobile Phone Whilst Driving | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4214017 | -1.4870278 | ||
| 14448 | op-snap---monthly-publication-june-2025.pdf | 377 | 2025-06 | Car | Volvo | C40 | Silver | Contravening a Red Traffic Light | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No Offence | 52.418488 | -1.5472387 | ||
| 14450 | op-snap---monthly-publication-june-2025.pdf | 379 | 2025-06 | Car | Toyota | PRIUS | Grey | Contravening a Red Traffic Light | None | Moseley Ave | Moseley Ave | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4141818 | -1.5315277 | ||
| 14456 | op-snap---monthly-publication-june-2025.pdf | 385 | 2025-06 | Car | Peugeot | 3008 | Grey | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4070602 | -1.4732469 | ||
| 14458 | op-snap---monthly-publication-june-2025.pdf | 387 | 2025-06 | Car | Lexus | RX450 | Black | Contravening a Red Traffic Light | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.436155 | -1.5064002 | ||
| 14476 | op-snap---monthly-publication-june-2025.pdf | 405 | 2025-06 | Car | Citroen | C3 | Black | Driving without Due Care and Attention | None | Henley Road | Henley Road | Coventry | Coventry | Education | N/A | 52.4307281 | -1.462755 | ||
| 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 | ||
| 14513 | op-snap---monthly-publication-june-2025.pdf | 442 | 2025-06 | Car | Smartcar | Black | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No VRM | 52.396476 | -1.5561348 | |||
| 14518 | op-snap---monthly-publication-june-2025.pdf | 447 | 2025-06 | Car | Toyota | Corolla | White | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 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 | ||
| 14533 | op-snap---monthly-publication-june-2025.pdf | 462 | 2025-06 | Car | Audi | Q7 | Black | Driving without Due Care and Attention | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Education | N/A | 52.4274335 | -1.5002381 | ||
| 14538 | op-snap---monthly-publication-june-2025.pdf | 467 | 2025-06 | Pedestrian | Ford | fiesta | Pink | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Mitchell Avenue | Mitchell Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3940834 | -1.5696642 | ||
| 14552 | op-snap---monthly-publication-june-2025.pdf | 481 | 2025-06 | Car | Audi | A3.... | Black | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4070602 | -1.4732469 | ||
| 14563 | op-snap---monthly-publication-june-2025.pdf | 492 | 2025-06 | Car | Audi | A4.. | Grey | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Churchill Avenue | Churchill Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4349565 | -1.4998638 | ||
| 14568 | op-snap---monthly-publication-june-2025.pdf | 497 | 2025-06 | Car | Peugeot | 3008.. | Black | Driving without Due Care and Attention | None | A45 Coventry | Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | 52.400739 | -1.5135474 | ||
| 14569 | op-snap---monthly-publication-june-2025.pdf | 498 | 2025-06 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14570 | op-snap---monthly-publication-june-2025.pdf | 499 | 2025-06 | Pedestrian | Land Rover | Defednder | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 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 | ||
| 14623 | op-snap---monthly-publication-june-2025.pdf | 552 | 2025-06 | Car | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Warning Letter | N/A | 52.417344 | -1.5264979 | ||
| 14624 | op-snap---monthly-publication-june-2025.pdf | 553 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.417344 | -1.5264979 | ||
| 14625 | op-snap---monthly-publication-june-2025.pdf | 554 | 2025-06 | Pedestrian | Land Rover | Range Rover | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 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 | ||
| 14686 | op-snap---monthly-publication-june-2025.pdf | 615 | 2025-06 | Car | Fiat | 500... | Red | Driving without Due Care and Attention | None | Earlsdon Avenue | Earlsdon Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4047134 | -1.5351834 | ||
| 14690 | op-snap---monthly-publication-june-2025.pdf | 619 | 2025-06 | Car | Fiat | Punto | White | Driving without Due Care and Attention | None | Scimitar Way | Scimitar Way | Coventry | Coventry | Court | N/A | 52.3836203 | -1.4862458 | ||
| 14691 | op-snap---monthly-publication-june-2025.pdf | 620 | 2025-06 | Car | Audi | RS3 | Black | Driving without Due Care and Attention | None | Coundon Wedge Drove | Coundon Wedge Drove | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 14692 | op-snap---monthly-publication-june-2025.pdf | 621 | 2025-06 | Car | London Taxi | Black | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4380313 | -1.5339558 | |||
| 14698 | op-snap---monthly-publication-june-2025.pdf | 627 | 2025-06 | Pedal Bike | Audi | A5 | Black | Driving without Due Care and Attention | None | Rochester Road | Rochester Road | Coventry | Coventry | Education | N/A | 52.3974085 | -1.5422796 | ||
| 14705 | op-snap---monthly-publication-june-2025.pdf | 634 | 2025-06 | Car | Volvo | Truck | Green | Contravening a Red Traffic Light | None | Coventry Bypass | Coventry Bypass | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3794055 | -1.4626632 | ||
| 14717 | op-snap---monthly-publication-june-2025.pdf | 646 | 2025-06 | Pedal Bike | Fiat | Punto | Blue | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Toad | Stoney Stanton Toad | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 14732 | op-snap---monthly-publication-june-2025.pdf | 661 | 2025-06 | Other | Misc - Non Traffic Offences | None | NP | Np | Coventry | Coventry | NFA | No Independent Evidence Available | |||||||
| 14737 | op-snap---monthly-publication-june-2025.pdf | 666 | 2025-06 | Car | Yamaha | XMX800 | Black | Driving without Due Care and Attention | None | Sandy Lane | Sandy Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4172858 | -1.5134012 | ||
| 14754 | op-snap---monthly-publication-june-2025.pdf | 683 | 2025-06 | Car | Nissan | Micra | Grey | Using a Mobile Phone Whilst Driving | None | Fletchhamstead Highway | Fletchhamstead Highway | Coventry | Coventry | Warning Letter | N/A | ||||
| 14761 | op-snap---monthly-publication-june-2025.pdf | 690 | 2025-06 | Car | Hyundai | Comfort | Red | Contravening a Red Traffic Light | None | Fletchmstead Highway | Fletchmstead Highway | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 14769 | op-snap---monthly-publication-june-2025.pdf | 698 | 2025-06 | Car | Toyota | Landcruiser | Silver | Using a Mobile Phone Whilst Driving | None | Blackberry Lane | Blackberry Lane | Coventry | Coventry | NFA | No Offence | 52.4254016 | -1.4665041 | ||
| 14771 | op-snap---monthly-publication-june-2025.pdf | 700 | 2025-06 | Pedal Bike | Vauxhall | Corsa | Silver | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 14775 | op-snap---monthly-publication-june-2025.pdf | 704 | 2025-06 | Car | Moped | Blue | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | No VRM | 52.4085943 | -1.4943275 | |||
| 14781 | op-snap---monthly-publication-june-2025.pdf | 710 | 2025-06 | Car | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | A45 | A45 | Coventry | Coventry | Warning Letter | N/A | ||||
| 14814 | op-snap---monthly-publication-june-2025.pdf | 743 | 2025-06 | Pedal Bike | Seat | Ibiza | Silver | Driving without Due Care and Attention | None | Beechwood Avenue | Beechwood Avenue | Coventry | Coventry | Education | N/A | 52.3960292 | -1.5340332 | ||
| 14838 | op-snap---monthly-publication-june-2025.pdf | 767 | 2025-06 | Car | Volkswagen | Golf | White | Contravening a Red Traffic Light | None | Allesley Road | Allesley Road | Coventry | Coventry | Education | N/A | 52.412663 | -1.5443742 | ||
| 14850 | op-snap---monthly-publication-june-2025.pdf | 779 | 2025-06 | Car | Seat | Ibiza | White | Driving without Due Care and Attention | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4205675 | -1.4520187 | ||
| 14878 | op-snap---monthly-publication-june-2025.pdf | 807 | 2025-06 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 14879 | op-snap---monthly-publication-june-2025.pdf | 808 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Sunbeam Way | Sunbeam Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.398205 | -1.4851165 | ||
| 14883 | op-snap---monthly-publication-june-2025.pdf | 812 | 2025-06 | Car | Nissan | Juke | Yellow | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | Other Action Taken | N/A | 52.4085943 | -1.4943275 | ||
| 14886 | op-snap---monthly-publication-june-2025.pdf | 815 | 2025-06 | Pedal Bike | BMW | 520d | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.418488 | -1.5472387 | ||
| 14908 | op-snap---monthly-publication-june-2025.pdf | 837 | 2025-06 | Car | Audi | A5 | Grey | Contravening a Red Traffic Light | None | Queensland Av | Queensland Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.406658 | -1.5363495 | ||
| 14913 | op-snap---monthly-publication-june-2025.pdf | 842 | 2025-06 | Car | Volkswagen | Golf | Blue | Using a Mobile Phone Whilst Driving | None | Randle Street | Randle Street | Coventry | Coventry | NFA | No Offence | 52.4179193 | -1.5227563 | ||
| 14914 | op-snap---monthly-publication-june-2025.pdf | 843 | 2025-06 | Car | BMW | M140i | Black | Driving without Due Care and Attention | None | Ring Road | Ring Road | Coventry | Coventry | Court | N/A | ||||
| 14915 | op-snap---monthly-publication-june-2025.pdf | 844 | 2025-06 | Car | Land Rover | Green | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | A452 | A452 | Coventry | Coventry | Warning Letter | N/A | |||||
| 14916 | op-snap---monthly-publication-june-2025.pdf | 845 | 2025-06 | Car | BMW | X6.. | Black | Driving without Due Care and Attention | No Insurance | A453 | A453 | Coventry | Coventry | Court | N/A | ||||
| 14936 | op-snap---monthly-publication-june-2025.pdf | 865 | 2025-06 | Pedal Bike | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4134557 | -1.4442138 | ||
| 14944 | op-snap---monthly-publication-june-2025.pdf | 873 | 2025-06 | Car | Iveco | White | Stop a vehicle within pelican pedestrian crossing limits | None | Whitacre Road | Whitacre Road | Coventry | Coventry | Education | N/A | |||||
| 14947 | op-snap---monthly-publication-june-2025.pdf | 876 | 2025-06 | Other | Misc - Non Traffic Offences | None | Coventry | Coventry | Coventry | Coventry | NFA | Misc Inc Crimes | 52.400739 | -1.5135474 | |||||
| 14960 | op-snap---monthly-publication-june-2025.pdf | 889 | 2025-06 | Car | Peugeot | 108... | Purple | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 14978 | op-snap---monthly-publication-june-2025.pdf | 907 | 2025-06 | Car | Volvo | Red | Driving without Due Care and Attention | None | Courtland Avenue | Courtland Avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.421244 | -1.5366787 | |||
| 14980 | op-snap---monthly-publication-june-2025.pdf | 909 | 2025-06 | Other | Toyota | Auris | Blue | Misc - Non Traffic Offences | None | M6 | M6 | Coventry | Coventry | NFA | No Offence | ||||
| 15041 | op-snap---monthly-publication-june-2025.pdf | 970 | 2025-06 | Car | Citroen | C4 | Blue | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Education | N/A | 52.4073149 | -1.5250454 | ||
| 15044 | op-snap---monthly-publication-june-2025.pdf | 973 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Wigston Road | Wigston Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4302822 | -1.4386034 | ||
| 15052 | op-snap---monthly-publication-june-2025.pdf | 981 | 2025-06 | Pedal Bike | Suzuki | Ignis | White | Driving without Due Care and Attention | None | Herald Avenue | Herald Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4029059 | -1.5541193 | ||
| 15056 | op-snap---monthly-publication-june-2025.pdf | 985 | 2025-06 | Car | Peugeot | Grey | Driving without Due Care and Attention | None | Swallow Road | Swallow Road | Coventry | Coventry | RTC - Actioned | N/A | 52.4369925 | -1.510331 | |||
| 15059 | op-snap---monthly-publication-june-2025.pdf | 988 | 2025-06 | Car | Tesla | Grey | Driving without Due Care and Attention | None | Quinton Road | Quinton Road | Coventry | Coventry | Education | N/A | 52.4028847 | -1.5082329 | |||
| 15062 | op-snap---monthly-publication-june-2025.pdf | 991 | 2025-06 | Car | Seat | Cupra | Grey | Driving without Due Care and Attention | None | Westwood Heat Road | Westwood Heat Road | Coventry | Coventry | Education | N/A | ||||
| 15070 | op-snap---monthly-publication-june-2025.pdf | 999 | 2025-06 | Car | Red | Using a Mobile Phone Whilst Driving | None | London Road | London Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3916468 | -1.4925995 | ||||
| 15100 | op-snap---monthly-publication-june-2025.pdf | 1029 | 2025-06 | Car | Tesla | Y Long | White | Contravening a Red Traffic Light | None | Waste Lane | Waste Lane | Coventry | Coventry | Court | N/A | 52.437361 | -1.5371291 | ||
| 15101 | op-snap---monthly-publication-june-2025.pdf | 1030 | 2025-06 | Van | BMW | 140i | blue | Driving without Reasonable Consideration | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Warning Letter | N/A | 52.436155 | -1.5064002 | ||
| 15124 | op-snap---monthly-publication-june-2025.pdf | 1053 | 2025-06 | Car | Volkswagen | Caddy | Blue | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4205675 | -1.4520187 | ||
| 15176 | op-snap---monthly-publication-june-2025.pdf | 1105 | 2025-06 | Pedestrian | Peugeot | Partner | White | Driving a vehicle wholly or partly on a footpath | None | Allesley Hall Drive | Allesley Hall Drive | Coventry | Coventry | Warning Letter | N/A | 52.4177276 | -1.5557037 | ||
| 15179 | op-snap---monthly-publication-june-2025.pdf | 1108 | 2025-06 | Car | BMW | 335d | Grey | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No Offence | 52.396476 | -1.5561348 | ||
| 15204 | op-snap---monthly-publication-june-2025.pdf | 1133 | 2025-06 | Car | Toyota | Aygo | Silver | Driving without Due Care and Attention | None | Lockhurst Lane | Lockhurst Lane | Coventry | Coventry | Court | N/A | 52.4255689 | -1.5023841 | ||
| 15211 | op-snap---monthly-publication-june-2025.pdf | 1140 | 2025-06 | Car | Volkswagen | Passat | Silver | Contravening a Red Traffic Light | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Warning Letter | N/A | 52.4071231 | -1.4985178 | ||
| 15214 | op-snap---monthly-publication-june-2025.pdf | 1143 | 2025-06 | Car | Audi | A5 | Red | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Coventry | Coventry | NFA | No Offence | 52.4111289 | -1.5094345 | ||
| 15235 | op-snap---monthly-publication-june-2025.pdf | 1164 | 2025-06 | Car | Toyota | Rav 4 | Black | Contravening a Red Traffic Light | None | Leamington Road | Leamington Road | Coventry | Coventry | Warning Letter | N/A | 52.3921304 | -1.5156601 | ||
| 15241 | op-snap---monthly-publication-june-2025.pdf | 1170 | 2025-06 | Car | Yamaha | Xmax | Red | Contravening a Red Traffic Light | None | Walsgrave ROad | Walsgrave ROad | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4096725 | -1.487901 | ||
| 15269 | op-snap---monthly-publication-june-2025.pdf | 1198 | 2025-06 | Car | TAXI | Black | Driving without Due Care and Attention | None | FAR GOSFORD ROAD | Far Gosford Road | Coventry | Coventry | Education | N/A | |||||
| 15282 | op-snap---monthly-publication-june-2025.pdf | 1211 | 2025-06 | Car | Vauxhall | corsa | White | Using a Mobile Phone Whilst Driving | None | Light Lane | Light Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4146866 | -1.5143578 | ||
| 15314 | op-snap---monthly-publication-june-2025.pdf | 1243 | 2025-06 | Pedal Bike | Audi | A5 | Grey | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 15315 | op-snap---monthly-publication-june-2025.pdf | 1244 | 2025-06 | Pedal Bike | Hyundai | Tucson | Blue | Stop a vehicle on pedestrian crossing | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 |
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);