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'}
121 rows where council_area = "Coventry" and month = "2025-08" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 25
offence 16
- Driving without Due Care and Attention 52
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 17
- Contravening a Red Traffic Light 14
- Misc - Non Traffic Offences 9
- Using a Mobile Phone Whilst Driving 7
- Driving without Reasonable Consideration 5
- Cause vehicle to be left in a dangerous position 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Dangerous Driving 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Prohibited vehicle in offside lane of motorway 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
disposal 6
- Warning Letter 45
- NFA 37
- Education 23
- Fixed Penalty 7
- Court 6
- Other Action Taken 3
reporter_transport_mode 4
- Car 70
- Pedestrian 27
- Pedal Bike 23
- Other 1
month 1
- 2025-08 · 121 ✖
council_area 1
- Coventry · 121 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2044 | op-snap---monthly-publication-august-2025.pdf | 19 | 2025-08 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Court | N/A | 52.4274335 | -1.5002381 | ||
| 2052 | op-snap---monthly-publication-august-2025.pdf | 27 | 2025-08 | Car | Unknown | Blue | Misc - Non Traffic Offences | None | A444 | A444 | Coventry | Coventry | NFA | No Offence | |||||
| 2053 | op-snap---monthly-publication-august-2025.pdf | 28 | 2025-08 | Pedal Bike | Audi | S3 | Black | Using a Mobile Phone Whilst Driving | None | Swaswell St | Swaswell Street | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 2061 | op-snap---monthly-publication-august-2025.pdf | 36 | 2025-08 | Car | Subaru | Grey | Driving without Due Care and Attention | None | Meeting House Lane | Meeting House Lane | Coventry | Coventry | NFA | No Offence | |||||
| 2073 | op-snap---monthly-publication-august-2025.pdf | 48 | 2025-08 | Car | UK | Silver | Driving a vehicle wholly or partly on a footpath | None | Longford Road | Longford Road | Coventry | Coventry | NFA | Not in Public Interest | 52.445164 | -1.4879298 | |||
| 2078 | op-snap---monthly-publication-august-2025.pdf | 53 | 2025-08 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Offence | 52.4214017 | -1.4870278 | ||
| 2084 | op-snap---monthly-publication-august-2025.pdf | 59 | 2025-08 | Car | Fiat | 500 | Grey | Contravening a Red Traffic Light | None | Hall Green Road | Hall Green Road | Coventry | Coventry | Education | N/A | 52.4401926 | -1.475417 | ||
| 2086 | op-snap---monthly-publication-august-2025.pdf | 61 | 2025-08 | Car | Ford | Transit | Blue | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | 52.4070602 | -1.4732469 | ||
| 2088 | op-snap---monthly-publication-august-2025.pdf | 63 | 2025-08 | Car | Tesla | Model 3 | White | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Warning Letter | N/A | 52.4073149 | -1.5250454 | ||
| 2093 | op-snap---monthly-publication-august-2025.pdf | 68 | 2025-08 | Car | Volkswagen | Polo | Black | Contravening a Red Traffic Light | None | Ringway St Johns | Ringway Street Johns | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2097 | op-snap---monthly-publication-august-2025.pdf | 72 | 2025-08 | Car | Audi | Grey | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | Not in Public Interest | 52.4085943 | -1.4943275 | |||
| 2100 | op-snap---monthly-publication-august-2025.pdf | 75 | 2025-08 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Foleshill | Foleshill | Coventry | Coventry | NFA | Not in Public Interest | 52.4335692 | -1.4944742 | |||
| 2118 | op-snap---monthly-publication-august-2025.pdf | 93 | 2025-08 | Car | Lexus | CT | Black | Driving without Due Care and Attention | None | Coventry | Coventry | Education | N/A | ||||||
| 2122 | op-snap---monthly-publication-august-2025.pdf | 97 | 2025-08 | Pedestrian | Renault | Scenic | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gulson Road | Gulson Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4076795 | -1.4911676 | ||
| 2171 | op-snap---monthly-publication-august-2025.pdf | 146 | 2025-08 | Pedal Bike | Tesla | Red | Driving without Reasonable Consideration | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | |||
| 2179 | op-snap---monthly-publication-august-2025.pdf | 154 | 2025-08 | Car | Mercedes-Benz | A Class | White | Driving without Due Care and Attention | None | Ringway, Whitefriars | Ringway, Whitefriars | Coventry | Coventry | NFA | Not in Public Interest | ||||
| 2203 | op-snap---monthly-publication-august-2025.pdf | 178 | 2025-08 | Pedal Bike | Volkswagen | ID | Grey | Driving without Reasonable Consideration | None | St James Lane | Street James Lane | Coventry | Coventry | Education | N/A | ||||
| 2214 | op-snap---monthly-publication-august-2025.pdf | 189 | 2025-08 | Car | BMW | 118d | White | Driving without Due Care and Attention | None | M6 South | M6 South | Coventry | Coventry | Fixed Penalty | N/A | 52.4146643 | -1.5694761 | ||
| 2220 | op-snap---monthly-publication-august-2025.pdf | 195 | 2025-08 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Keresley Road | Keresley Road | Coventry | Coventry | Warning Letter | N/A | 52.4331176 | -1.5314475 | ||
| 2233 | op-snap---monthly-publication-august-2025.pdf | 208 | 2025-08 | Car | Vauxhall | Agila | Red | Driving without Due Care and Attention | None | Gosford Street | Gosford Street | Coventry | Coventry | Education | N/A | 52.4068712 | -1.4994695 | ||
| 2242 | op-snap---monthly-publication-august-2025.pdf | 217 | 2025-08 | Car | Volkswagen | Golf | Red | Driving without Due Care and Attention | None | Puma Way | Puma Way | Coventry | Coventry | Education | N/A | 52.401984 | -1.5046079 | ||
| 2255 | op-snap---monthly-publication-august-2025.pdf | 230 | 2025-08 | Car | Ford | Grey | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | Not in Public Interest | |||||
| 2290 | op-snap---monthly-publication-august-2025.pdf | 265 | 2025-08 | Car | BMW | 530D | Grey | Driving without Due Care and Attention | None | Widdrington Road | Widdrington Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4191764 | -1.5105738 | ||
| 2313 | op-snap---monthly-publication-august-2025.pdf | 288 | 2025-08 | Pedal Bike | Hyundai | I10 | Grey | Using a Mobile Phone Whilst Driving | None | Catesby Road | Catesby Road | Coventry | Coventry | NFA | No Offence | 52.4346221 | -1.5163727 | ||
| 2317 | op-snap---monthly-publication-august-2025.pdf | 292 | 2025-08 | Car | Hyundai | Red | Driving without Due Care and Attention | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4274335 | -1.5002381 | |||
| 2321 | op-snap---monthly-publication-august-2025.pdf | 296 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Longford Road | Longford Road | Coventry | Coventry | Education | N/A | 52.445164 | -1.4879298 | ||
| 2340 | op-snap---monthly-publication-august-2025.pdf | 315 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Longford | Longford | Coventry | Coventry | Education | N/A | 52.4516182 | -1.4885443 | ||
| 2341 | op-snap---monthly-publication-august-2025.pdf | 316 | 2025-08 | Car | Kia | Sportage | Silver | Contravening a Red Traffic Light | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 | ||
| 2342 | op-snap---monthly-publication-august-2025.pdf | 317 | 2025-08 | Pedestrian | Land Rover | Velar | Black | Driving without Due Care and Attention | None | Flethchamstead Road | Flethchamstead Road | Coventry | Coventry | Court | N/A | ||||
| 2371 | op-snap---monthly-publication-august-2025.pdf | 346 | 2025-08 | Pedal Bike | Toyota | Aygo | Silver | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 2406 | op-snap---monthly-publication-august-2025.pdf | 381 | 2025-08 | Car | Honda | M/C | Black | Contravening a Red Traffic Light | None | Ansty Interchange | Ansty Interchange | Coventry | Coventry | Other Action Taken | N/A | 52.4399359 | -1.4395909 | ||
| 2409 | op-snap---monthly-publication-august-2025.pdf | 384 | 2025-08 | Car | Seat | Ibiza | Red | Contravening a Red Traffic Light | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Warning Letter | N/A | 52.4096725 | -1.487901 | ||
| 2429 | op-snap---monthly-publication-august-2025.pdf | 404 | 2025-08 | Car | Ford | C-Max | Blue | Driving without Due Care and Attention | None | Windmill Hill | Windmill Hill | Coventry | Coventry | NFA | No VRM | 52.4290141 | -1.5708635 | ||
| 2435 | op-snap---monthly-publication-august-2025.pdf | 410 | 2025-08 | Car | Audi | SQ5 | White | Driving without Due Care and Attention | None | Daventry Road | Daventry Road | Coventry | Coventry | Education | N/A | 52.3930931 | -1.4976428 | ||
| 2444 | op-snap---monthly-publication-august-2025.pdf | 419 | 2025-08 | Car | Mercedes-Benz | A160 | Silver | Using a Mobile Phone Whilst Driving | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | No Offence | 52.4205675 | -1.4520187 | ||
| 2461 | op-snap---monthly-publication-august-2025.pdf | 436 | 2025-08 | Pedestrian | BMW | NK | Black | Misc - Non Traffic Offences | None | Binley (general area) nothing more specific provided. | Binley (general area) nothing more specific provided | Coventry | Coventry | Other Action Taken | N/A | ||||
| 2464 | op-snap---monthly-publication-august-2025.pdf | 439 | 2025-08 | Car | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4274335 | -1.5002381 | ||
| 2471 | op-snap---monthly-publication-august-2025.pdf | 446 | 2025-08 | Pedestrian | Toyota | Auris | Grey | Contravening a Red Traffic Light | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 2479 | op-snap---monthly-publication-august-2025.pdf | 454 | 2025-08 | Pedestrian | Ford | Focus | White | Misc - Non Traffic Offences | None | Binley | Binley | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4001634 | -1.4444074 | ||
| 2481 | op-snap---monthly-publication-august-2025.pdf | 456 | 2025-08 | Pedestrian | Renault | Traffic | White | Using a Mobile Phone Whilst Driving | None | Radford Road | Radford Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4235908 | -1.5226276 | ||
| 2484 | op-snap---monthly-publication-august-2025.pdf | 459 | 2025-08 | Car | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | No VRM | 52.4070602 | -1.4732469 | |||||
| 2520 | op-snap---monthly-publication-august-2025.pdf | 495 | 2025-08 | Car | Vauxhall | Combo | Silver | Contravening a Red Traffic Light | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 2538 | op-snap---monthly-publication-august-2025.pdf | 513 | 2025-08 | Pedal Bike | Mercedes-Benz | E220 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Corporation Street | Corporation Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4086244 | -1.515132 | ||
| 2539 | op-snap---monthly-publication-august-2025.pdf | 514 | 2025-08 | Pedal Bike | Toyota | Prius | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 2557 | op-snap---monthly-publication-august-2025.pdf | 532 | 2025-08 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Allesley old Road | Allesley old Road | Coventry | Coventry | NFA | No Offence | 52.4103629 | -1.5441218 | ||
| 2569 | op-snap---monthly-publication-august-2025.pdf | 544 | 2025-08 | Car | Volkswagen | Up | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | A45 Kenpas Highway | Kenpas Highway | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3833661 | -1.5265665 | ||
| 2594 | op-snap---monthly-publication-august-2025.pdf | 569 | 2025-08 | Pedal Bike | Renault | Clio | Blue | Driving without Due Care and Attention | None | Hearsall Common | Hearsall Common | Coventry | Coventry | Education | N/A | 52.402753 | -1.5385829 | ||
| 2595 | op-snap---monthly-publication-august-2025.pdf | 570 | 2025-08 | Pedal Bike | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Earlsdon Av | Earlsdon Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4047134 | -1.5351834 | ||
| 2614 | op-snap---monthly-publication-august-2025.pdf | 589 | 2025-08 | Car | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Ansty Island Coventry | Ansty Island Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2620 | op-snap---monthly-publication-august-2025.pdf | 595 | 2025-08 | Pedestrian | Yamaha | 125 | Blue | Misc - Non Traffic Offences | None | Skipworth Road | Skipworth Road | Coventry | Coventry | NFA | No Offence | 52.3980123 | -1.438048 | ||
| 2622 | op-snap---monthly-publication-august-2025.pdf | 597 | 2025-08 | Pedestrian | n/a | Misc - Non Traffic Offences | None | Skipworth Road | Skipworth Road | Coventry | Coventry | NFA | No Offence | 52.3980123 | -1.438048 | ||||
| 2655 | op-snap---monthly-publication-august-2025.pdf | 630 | 2025-08 | Car | Ford | Fiesta | Silver | Misc - Non Traffic Offences | None | A45 | A45 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2661 | op-snap---monthly-publication-august-2025.pdf | 636 | 2025-08 | Car | Vauxhall | Mokka | Blue | Driving without Due Care and Attention | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | Education | N/A | 52.4459998 | -1.6949291 | ||
| 2675 | op-snap---monthly-publication-august-2025.pdf | 650 | 2025-08 | Car | Subuara | Grey | Driving without Due Care and Attention | None | Torrington Avenue | Torrington Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3987354 | -1.567693 | |||
| 2691 | op-snap---monthly-publication-august-2025.pdf | 666 | 2025-08 | Car | BMW | 520.. | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 2695 | op-snap---monthly-publication-august-2025.pdf | 670 | 2025-08 | Car | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | A444 | A444 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2710 | op-snap---monthly-publication-august-2025.pdf | 685 | 2025-08 | Car | Volkswagen | Golf | Grey | Driving without Reasonable Consideration | None | Jimmy Hill WAY | Jimmy Hill WAY | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 2714 | op-snap---monthly-publication-august-2025.pdf | 689 | 2025-08 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Coundon Wedge Drive | Coundon Wedge Drive | Coventry | Coventry | Court | N/A | 52.4385402 | -1.5483746 | ||
| 2720 | op-snap---monthly-publication-august-2025.pdf | 695 | 2025-08 | Car | Peugeot | 1007SE | Black | Driving without Due Care and Attention | None | Holbrook WAY | Holbrook WAY | Coventry | Coventry | Warning Letter | N/A | 52.438551 | -1.502488 | ||
| 2722 | op-snap---monthly-publication-august-2025.pdf | 697 | 2025-08 | Pedal Bike | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4275505 | -1.4448681 | ||
| 2728 | op-snap---monthly-publication-august-2025.pdf | 703 | 2025-08 | Other | NP | Driving without Due Care and Attention | None | Squirrel Close | Squirrel Close | Coventry | Coventry | NFA | No VRM | 52.4384449 | -1.4683592 | ||||
| 2731 | op-snap---monthly-publication-august-2025.pdf | 706 | 2025-08 | Pedal Bike | Citroen | C4 | Grey | Driving without Due Care and Attention | None | Links Road | Links Road | Coventry | Coventry | NFA | No Offence | 52.4310925 | -1.5197728 | ||
| 2757 | op-snap---monthly-publication-august-2025.pdf | 732 | 2025-08 | Car | BMW | 320D | Blue | Driving without Due Care and Attention | None | Green Lane | Green Lane | Coventry | Coventry | Warning Letter | N/A | 52.38188 | -1.5300381 | ||
| 2790 | op-snap---monthly-publication-august-2025.pdf | 765 | 2025-08 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Court | N/A | 52.436155 | -1.5064002 | ||
| 2793 | op-snap---monthly-publication-august-2025.pdf | 768 | 2025-08 | Pedestrian | Volkswagen | Black | Using a Mobile Phone Whilst Driving | None | South Bank Road | South Bank Road | Coventry | Coventry | NFA | Misc Inc Crimes | |||||
| 2806 | op-snap---monthly-publication-august-2025.pdf | 781 | 2025-08 | Car | Hyundai | I10.. | Grey | Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver | None | Allard Way | Allard Way | Coventry | Coventry | Fixed Penalty | N/A | 52.3955174 | -1.4685442 | ||
| 2829 | op-snap---monthly-publication-august-2025.pdf | 804 | 2025-08 | Car | Porsche | Cayenne | Blue | Driving without Reasonable Consideration | None | Kirby Corner Island | Kirby Corner Island | Coventry | Coventry | Warning Letter | N/A | ||||
| 2871 | op-snap---monthly-publication-august-2025.pdf | 846 | 2025-08 | Pedestrian | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 2873 | op-snap---monthly-publication-august-2025.pdf | 848 | 2025-08 | Pedal Bike | Toyota | Aygo | Red | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 2881 | op-snap---monthly-publication-august-2025.pdf | 856 | 2025-08 | Pedestrian | Mercedes-Benz | GLA | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Thomas Lansdail St | Thomas Lansdail Street | Coventry | Coventry | Court | N/A | ||||
| 2897 | op-snap---monthly-publication-august-2025.pdf | 872 | 2025-08 | Car | Volkswagen | Polo | White | Using a Mobile Phone Whilst Driving | None | Jubilee Crescent | Jubilee Crescent | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4307567 | -1.5167147 | ||
| 2899 | op-snap---monthly-publication-august-2025.pdf | 874 | 2025-08 | Car | Land Rover | LO12HYA | White | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2909 | op-snap---monthly-publication-august-2025.pdf | 884 | 2025-08 | Car | Audi | Q5 | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 2956 | op-snap---monthly-publication-august-2025.pdf | 931 | 2025-08 | Car | Using a Mobile Phone Whilst Driving | None | Barker Butts Lane | Barker Butts Lane | Coventry | Coventry | NFA | No VRM | |||||||
| 2964 | op-snap---monthly-publication-august-2025.pdf | 939 | 2025-08 | Car | Audi | Electric | Grey | Driving without Due Care and Attention | None | Tamworth Road and Long Lane | Tamworth Road and Long Lane | Coventry | Coventry | Education | N/A | 52.4380313 | -1.5339558 | ||
| 2993 | op-snap---monthly-publication-august-2025.pdf | 968 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Anderton Road | Anderton Road | Coventry | Coventry | Warning Letter | N/A | 52.4519205 | -1.4736655 | ||
| 3009 | op-snap---monthly-publication-august-2025.pdf | 984 | 2025-08 | Pedestrian | Off road M/C | Orange | Misc - Non Traffic Offences | None | Wilson Lane | Wilson Lane | Coventry | Coventry | Other Action Taken | N/A | |||||
| 3048 | op-snap---monthly-publication-august-2025.pdf | 1023 | 2025-08 | Car | Seat | Leon | White | Driving without Due Care and Attention | None | A45 Coventry near Broad Lane Jct | Coventry near Broad Lane Junction | Coventry | Coventry | Fixed Penalty | N/A | 52.400739 | -1.5135474 | ||
| 3052 | op-snap---monthly-publication-august-2025.pdf | 1027 | 2025-08 | Pedal Bike | Ford | Puma | Grey | Driving without Due Care and Attention | None | Tile Hill Road | Tile Hill Road | Coventry | Coventry | Education | N/A | ||||
| 3055 | op-snap---monthly-publication-august-2025.pdf | 1030 | 2025-08 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 3069 | op-snap---monthly-publication-august-2025.pdf | 1044 | 2025-08 | Car | Volkswagen | Troc | Silver | Driving without Due Care and Attention | None | Holbrook WAY | Holbrook WAY | Coventry | Coventry | Education | N/A | 52.438551 | -1.502488 | ||
| 3086 | op-snap---monthly-publication-august-2025.pdf | 1061 | 2025-08 | Pedal Bike | Mercedes-Benz | GLS | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 3095 | op-snap---monthly-publication-august-2025.pdf | 1070 | 2025-08 | Car | UK | Dangerous Driving | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4459998 | -1.6949291 | ||||
| 3161 | op-snap---monthly-publication-august-2025.pdf | 1136 | 2025-08 | Car | Audi | Grey | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No VRM | 52.4214017 | -1.4870278 | |||
| 3166 | op-snap---monthly-publication-august-2025.pdf | 1141 | 2025-08 | Car | Audi | A1 | Grey | Driving without Due Care and Attention | None | Westwood Heath road | Westwood Heath road | Coventry | Coventry | Court | N/A | 52.3846451 | -1.5763626 | ||
| 3173 | op-snap---monthly-publication-august-2025.pdf | 1148 | 2025-08 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | Education | N/A | 52.4205675 | -1.4520187 | ||
| 3175 | op-snap---monthly-publication-august-2025.pdf | 1150 | 2025-08 | Car | BMW | 1 series | White | Driving without Due Care and Attention | None | Silver Eagle Way | Silver Eagle Way | Coventry | Coventry | Warning Letter | N/A | ||||
| 3182 | op-snap---monthly-publication-august-2025.pdf | 1157 | 2025-08 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | Silver Birch Avenue, Canley | Silver Birch Avenue, Canley | Coventry | Coventry | Warning Letter | N/A | 52.3954274 | -1.5568965 | ||
| 3186 | op-snap---monthly-publication-august-2025.pdf | 1161 | 2025-08 | Car | Renault | Kadjar | Black | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4111289 | -1.5094345 | ||
| 3220 | op-snap---monthly-publication-august-2025.pdf | 1195 | 2025-08 | Car | Citroen | C4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 3229 | op-snap---monthly-publication-august-2025.pdf | 1204 | 2025-08 | Pedestrian | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | earlsdon street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 3232 | op-snap---monthly-publication-august-2025.pdf | 1207 | 2025-08 | Pedestrian | Ford | puma | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Well Street | Upper Well Street | Coventry | Coventry | Warning Letter | N/A | 52.4102625 | -1.5137293 | ||
| 3233 | op-snap---monthly-publication-august-2025.pdf | 1208 | 2025-08 | Pedestrian | Volkswagen | golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Telfer Road | Telfer Road | Coventry | Coventry | Warning Letter | N/A | 52.4311807 | -1.5191239 | ||
| 3259 | op-snap---monthly-publication-august-2025.pdf | 1234 | 2025-08 | Pedal Bike | Vauxhall | Astra | Black | Cause vehicle to be left in a dangerous position | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 3260 | op-snap---monthly-publication-august-2025.pdf | 1235 | 2025-08 | Pedal Bike | Toyota | Yaris | Silver | Cause vehicle to be left in a dangerous position | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 3261 | op-snap---monthly-publication-august-2025.pdf | 1236 | 2025-08 | Pedal Bike | Audi | A6 | Red | Cause vehicle to be left in a dangerous position | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 3314 | op-snap---monthly-publication-august-2025.pdf | 1289 | 2025-08 | Car | Vauxhall | Movano | White | Driving without Due Care and Attention | None | Leamington Road | Leamington Road | Coventry | Coventry | Warning Letter | N/A | 52.3921304 | -1.5156601 | ||
| 3431 | op-snap---monthly-publication-august-2025.pdf | 1406 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Prohibited vehicle in offside lane of motorway | None | M6 southbound towards coventry | M6 southbound towards coventry | Coventry | Coventry | Warning Letter | N/A | ||||
| 3442 | op-snap---monthly-publication-august-2025.pdf | 1417 | 2025-08 | Pedal Bike | Cupra | Leon | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 3443 | op-snap---monthly-publication-august-2025.pdf | 1418 | 2025-08 | Pedal Bike | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 |
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);