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'}
626 rows where council_area = "Coventry" and offence = "Driving without Due Care and Attention" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
month 14
reporter_transport_mode 7
- Car 387
- Pedal Bike 210
- Pedestrian 12
- Other 8
- Motorbike 4
- car 3
- Lorry 2
disposal 7
- NFA 186
- Education 180
- Warning Letter 129
- Court 62
- Fixed Penalty 56
- RTC - Actioned 8
- Other Action Taken 5
offence 1
- Driving without Due Care and Attention · 626 ✖
council_area 1
- Coventry · 626 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7312 | op-snap---monthly-publication-february-2026.pdf | 59 | 2026-02 | Pedal Bike | BMW | 218i | Blue | Driving without Due Care and Attention | None | Bird Street at White Street | Bird Street at White Street | Coventry | Coventry | Education | N/A | 52.4124171 | -1.5065021 | ||
| 7319 | op-snap---monthly-publication-february-2026.pdf | 66 | 2026-02 | Car | Mercedes-Benz | 160 | White | Driving without Due Care and Attention | None | Ringway Queens | Ringway Queens | Coventry | Coventry | NFA | No Offence | 52.4039782 | -1.5161639 | ||
| 7359 | op-snap---monthly-publication-february-2026.pdf | 106 | 2026-02 | Pedal Bike | Ford | Focus | Silver | Driving without Due Care and Attention | None | Greens Road | Greens Road | Coventry | Coventry | Education | N/A | 52.4381927 | -1.5291209 | ||
| 7393 | op-snap---monthly-publication-february-2026.pdf | 140 | 2026-02 | Car | Toyota | Auris | Grey | Driving without Due Care and Attention | No Insurance | Crampers Field | Crampers Field | Coventry | Coventry | Court | N/A | 52.4176927 | -1.5257854 | ||
| 7470 | op-snap---monthly-publication-february-2026.pdf | 217 | 2026-02 | Pedal Bike | Kia | Rio | Blue | Driving without Due Care and Attention | None | Ansty Road | Ansty Road | Coventry | Coventry | Education | N/A | 52.4205675 | -1.4520187 | ||
| 7497 | op-snap---monthly-publication-february-2026.pdf | 244 | 2026-02 | Car | BMW | X1 | Blue | Driving without Due Care and Attention | None | Torcross Avenue | Torcross Avenue | Coventry | Coventry | Education | N/A | 52.4218194 | -1.46546 | ||
| 7498 | op-snap---monthly-publication-february-2026.pdf | 245 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Westwood WAY | Westwood WAY | Coventry | Coventry | Education | N/A | 52.3880214 | -1.5797132 | ||
| 7535 | op-snap---monthly-publication-february-2026.pdf | 282 | 2026-02 | Car | Peugeot | 206 | Silver | Driving without Due Care and Attention | None | Winding House Lane | Winding House Lane | Coventry | Coventry | Education | N/A | 52.4490457 | -1.5001195 | ||
| 7538 | op-snap---monthly-publication-february-2026.pdf | 285 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Education | N/A | 52.418488 | -1.5472387 | ||
| 7603 | op-snap---monthly-publication-february-2026.pdf | 350 | 2026-02 | Car | Hyundai | 130 | Blue | Driving without Due Care and Attention | None | A46 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 7625 | op-snap---monthly-publication-february-2026.pdf | 372 | 2026-02 | Car | Mercedes-Benz | CLA 220 | Red | Driving without Due Care and Attention | None | Coventry A45 W | Coventry A45 W | Coventry | Coventry | Education | N/A | 52.4314215 | -1.5948907 | ||
| 7632 | op-snap---monthly-publication-february-2026.pdf | 379 | 2026-02 | Pedal Bike | Seat | Leon | Silver | Driving without Due Care and Attention | None | Woodstock Road | Woodstock Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3919059 | -1.5026146 | ||
| 7696 | op-snap---monthly-publication-february-2026.pdf | 443 | 2026-02 | Pedal Bike | Mercedes-Benz | A Class | Silver | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Warning Letter | N/A | 52.4041117 | -1.5595662 | ||
| 7697 | op-snap---monthly-publication-february-2026.pdf | 444 | 2026-02 | Pedal Bike | Kia | Sportage | Silver | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Warning Letter | N/A | 52.4041117 | -1.5595662 | ||
| 7699 | op-snap---monthly-publication-february-2026.pdf | 446 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | white | Driving without Due Care and Attention | None | Broad Lane, Tile Hill | Broad Lane, Tile Hill | Coventry | Coventry | Education | N/A | 52.4112706 | -1.5792697 | ||
| 7700 | op-snap---monthly-publication-february-2026.pdf | 447 | 2026-02 | Pedal Bike | Kia | Niro | White | Driving without Due Care and Attention | None | Bloomfield Road, Earlsdon | Bloomfield Road, Earlsdon | Coventry | Coventry | Education | N/A | ||||
| 7754 | op-snap---monthly-publication-february-2026.pdf | 501 | 2026-02 | Car | Citroen | Berlingo | Silver | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 7756 | op-snap---monthly-publication-february-2026.pdf | 503 | 2026-02 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 7831 | op-snap---monthly-publication-february-2026.pdf | 578 | 2026-02 | Pedal Bike | Daf | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | No Offence | 52.4103629 | -1.5441218 | |||
| 7833 | op-snap---monthly-publication-february-2026.pdf | 580 | 2026-02 | Pedal Bike | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | ||
| 7835 | op-snap---monthly-publication-february-2026.pdf | 582 | 2026-02 | Car | Mercedes-Benz | EQB | Black | Driving without Due Care and Attention | None | Sewall Highway | Sewall Highway | Coventry | Coventry | Education | N/A | 52.4318623 | -1.4804069 | ||
| 7856 | op-snap---monthly-publication-february-2026.pdf | 603 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 7857 | op-snap---monthly-publication-february-2026.pdf | 604 | 2026-02 | Pedal Bike | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Warning Letter | N/A | 52.4103629 | -1.5441218 | ||
| 7874 | op-snap---monthly-publication-february-2026.pdf | 621 | 2026-02 | Car | Ford | KA | Red | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 7882 | op-snap---monthly-publication-february-2026.pdf | 629 | 2026-02 | Car | BMW | 318D | Black | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Education | N/A | 52.3916468 | -1.4925995 | ||
| 7934 | op-snap---monthly-publication-february-2026.pdf | 681 | 2026-02 | Pedal Bike | BMW | Orange | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | |||
| 7938 | op-snap---monthly-publication-february-2026.pdf | 685 | 2026-02 | Pedal Bike | BMW | Grey | Driving without Due Care and Attention | None | Back Lane Coventry | Back Lane Coventry | Coventry | Coventry | Education | N/A | 52.3796433 | -1.5600371 | |||
| 8017 | op-snap---monthly-publication-february-2026.pdf | 764 | 2026-02 | Pedal Bike | Mercedes-Benz | CLA220 | Red | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | ||
| 8027 | op-snap---monthly-publication-february-2026.pdf | 774 | 2026-02 | Pedal Bike | Nissan | Qashqai | Beige | Driving without Due Care and Attention | None | Hearsall Common | Hearsall Common | Coventry | Coventry | Education | N/A | 52.402753 | -1.5385829 | ||
| 8049 | op-snap---monthly-publication-february-2026.pdf | 796 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Broad Lane nr The Glade junction | Broad Lane nr The Glade junction | Coventry | Coventry | Education | N/A | ||||
| 8050 | op-snap---monthly-publication-february-2026.pdf | 797 | 2026-02 | Pedal Bike | Hyundai | i30 | Grey | Driving without Due Care and Attention | None | Broad Lane near Coral Close | Broad Lane near Coral Close | Coventry | Coventry | Education | N/A | 52.4144409 | -1.5990259 | ||
| 8056 | op-snap---monthly-publication-february-2026.pdf | 803 | 2026-02 | Pedal Bike | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | Brinklow Road | Brinklow Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4028059 | -1.4461048 | ||
| 8058 | op-snap---monthly-publication-february-2026.pdf | 805 | 2026-02 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | No Offence | ||||
| 8083 | op-snap---monthly-publication-february-2026.pdf | 830 | 2026-02 | Car | Ford | Focus | Red | Driving without Due Care and Attention | None | Lamb Street | Lamb Street | Coventry | Coventry | Education | N/A | 52.4110367 | -1.5143617 | ||
| 8103 | op-snap---monthly-publication-february-2026.pdf | 850 | 2026-02 | Pedal Bike | Audi | Q3 | White | Driving without Due Care and Attention | None | Hearsall Lane | Hearsall Lane | Coventry | Coventry | Education | N/A | 52.4064125 | -1.5320113 | ||
| 8167 | op-snap---monthly-publication-february-2026.pdf | 914 | 2026-02 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | Toll Bar End | Toll Bar End | Coventry | Coventry | Other Action Taken | N/A | 52.377406 | -1.4651313 | ||
| 8245 | op-snap---monthly-publication-february-2026.pdf | 992 | 2026-02 | Car | BMW | 5 Series | Blue | Driving without Due Care and Attention | None | Coventry Ring Road | Coventry Ring Road | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 8294 | op-snap---monthly-publication-february-2026.pdf | 1041 | 2026-02 | Car | Audi | A5 | Black | Driving without Due Care and Attention | No Insurance | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Court | N/A | 52.3793117 | -1.4625379 | ||
| 8321 | op-snap---monthly-publication-february-2026.pdf | 1068 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | Education | N/A | 52.4073149 | -1.5250454 | ||
| 8339 | op-snap---monthly-publication-february-2026.pdf | 1086 | 2026-02 | Car | Seat | Leon | Blue | Driving without Due Care and Attention | None | Broad lane | Broad lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | ||
| 8354 | op-snap---monthly-publication-february-2026.pdf | 1101 | 2026-02 | Pedal Bike | Citroen | C4.. | White | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Education | N/A | 52.4041117 | -1.5595662 | ||
| 8410 | op-snap---monthly-publication-february-2026.pdf | 1157 | 2026-02 | Car | Seat | Leon | White | Driving without Due Care and Attention | None | Rowleys Green Roundabout at Jummy Hill Way | Rowleys Green Roundabout at Jummy Hill Way | Coventry | Coventry | RTC - Actioned | N/A | 52.4486967 | -1.4991069 | ||
| 8514 | op-snap---monthly-publication-february-2026.pdf | 1261 | 2026-02 | Pedal Bike | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | White Street | White Street | Coventry | Coventry | Education | N/A | 52.4122951 | -1.5045181 | ||
| 8515 | op-snap---monthly-publication-february-2026.pdf | 1262 | 2026-02 | Pedal Bike | Peugeot | Expert | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 8532 | op-snap---monthly-publication-february-2026.pdf | 1279 | 2026-02 | Car | Polestar | Black | Driving without Due Care and Attention | None | London toward Twds Coventry at Whitley Interchange | London toward Twds Coventry at Whitley Interchange | Coventry | Coventry | Fixed Penalty | N/A | |||||
| 8540 | op-snap---monthly-publication-february-2026.pdf | 1287 | 2026-02 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Longfellow Road | Longfellow Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4102345 | -1.4609881 | ||
| 8541 | op-snap---monthly-publication-february-2026.pdf | 1288 | 2026-02 | Car | Nissan | Micra | Grey | Driving without Due Care and Attention | None | Sewall Highway | Sewall Highway | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4318623 | -1.4804069 | ||
| 8542 | op-snap---monthly-publication-february-2026.pdf | 1289 | 2026-02 | Pedal Bike | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Broad Lane Coventry | Broad Lane Coventry | Coventry | Coventry | Education | N/A | 52.4144409 | -1.5990259 | ||
| 8543 | op-snap---monthly-publication-february-2026.pdf | 1290 | 2026-02 | Pedal Bike | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Westwood Way | Westwood Way | Coventry | Coventry | Warning Letter | N/A | 52.3880214 | -1.5797132 | ||
| 8546 | op-snap---monthly-publication-february-2026.pdf | 1293 | 2026-02 | Pedal Bike | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Education | N/A | 52.4086244 | -1.515132 | ||
| 8550 | op-snap---monthly-publication-february-2026.pdf | 1297 | 2026-02 | Car | Toyota | Yaris | Red | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 8552 | op-snap---monthly-publication-february-2026.pdf | 1299 | 2026-02 | Car | Vauxhall | Vivaro | Grey | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | NFA | No Offence | 52.4073149 | -1.5250454 | ||
| 8554 | op-snap---monthly-publication-february-2026.pdf | 1301 | 2026-02 | Car | Mercedes-Benz | E220 | Silver | Driving without Due Care and Attention | None | London Road to A444 Whitley Interchange | London Road to A444 Whitley Interchange | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 8594 | op-snap---monthly-publication-february-2026.pdf | 1341 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Ludgate Road | Ludgate Road | Coventry | Coventry | Education | N/A | ||||
| 8613 | op-snap---monthly-publication-february-2026.pdf | 1360 | 2026-02 | Car | Mercedes-Benz | CLA | Black | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 8668 | op-snap---monthly-publication-february-2026.pdf | 1415 | 2026-02 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 8739 | op-snap---monthly-publication-february-2026.pdf | 1486 | 2026-02 | Car | Seat | Ateca | Silver | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Court | N/A | ||||
| 8760 | op-snap---monthly-publication-february-2026.pdf | 1507 | 2026-02 | Pedal Bike | Ford | Puma | Red | Driving without Due Care and Attention | None | Wall Hill Road | Wall Hill Road | Coventry | Coventry | Education | N/A | 52.4459445 | -1.5552508 | ||
| 8766 | op-snap---monthly-publication-february-2026.pdf | 1513 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Spon End | Spon End | Coventry | Coventry | Education | N/A | 52.4069072 | -1.5247498 | ||
| 8808 | op-snap---monthly-publication-february-2026.pdf | 1555 | 2026-02 | Car | Jeep | Avenger | Beige | Driving without Due Care and Attention | None | Tollbar End Roundabout | Tollbar End Roundabout | Coventry | Coventry | Court | N/A | ||||
| 8814 | op-snap---monthly-publication-february-2026.pdf | 1561 | 2026-02 | Pedal Bike | Seat | Leon | Grey | Driving without Due Care and Attention | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 10551 | op-snap---monthly-publication-january-2026.pdf | 12 | 2026-01 | Car | Lexus | IS 250 | Grey | Driving without Due Care and Attention | None | Coventry Ring Road | Coventry Ring Road | Coventry | Coventry | Education | N/A | ||||
| 10553 | op-snap---monthly-publication-january-2026.pdf | 14 | 2026-01 | Car | Toyota | Avensis | Silver | Driving without Due Care and Attention | None | M6 NB J3 | M6 Northbound J3 | Coventry | Coventry | NFA | No Independent Evidence Available | 52.6760749 | -2.0862582 | ||
| 10570 | op-snap---monthly-publication-january-2026.pdf | 31 | 2026-01 | Car | Mazda | 6 SE-L | Grey | Driving without Due Care and Attention | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4274335 | -1.5002381 | ||
| 10582 | op-snap---monthly-publication-january-2026.pdf | 43 | 2026-01 | Car | Polestar | White | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Warning Letter | N/A | |||||
| 10791 | op-snap---monthly-publication-january-2026.pdf | 252 | 2026-01 | Car | Mercedes-Benz | C350 | Black | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 10801 | op-snap---monthly-publication-january-2026.pdf | 262 | 2026-01 | Car | Mercedes-Benz | White | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Warning Letter | N/A | 52.3916468 | -1.4925995 | |||
| 10802 | op-snap---monthly-publication-january-2026.pdf | 263 | 2026-01 | Car | Daf | Orange | Driving without Due Care and Attention | None | Beake Avenue/ Rupert Road | Beake Avenue/ Rupert Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4242259 | -1.5233419 | |||
| 10803 | op-snap---monthly-publication-january-2026.pdf | 264 | 2026-01 | Car | Mercedes-Benz | E250 | Grey | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | NFA | No Offence | 52.3916468 | -1.4925995 | ||
| 10853 | op-snap---monthly-publication-january-2026.pdf | 314 | 2026-01 | Car | BMW | 439I | White | Driving without Due Care and Attention | None | Gosford Street | Gosford Street | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4068712 | -1.4994695 | ||
| 10884 | op-snap---monthly-publication-january-2026.pdf | 345 | 2026-01 | Pedal Bike | Volkswagen | Crafter | White | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | 52.4070602 | -1.4732469 | ||
| 10910 | op-snap---monthly-publication-january-2026.pdf | 371 | 2026-01 | Car | Volvo | C30 | Silver | Driving without Due Care and Attention | None | Barkers Butt Lane | Barkers Butt Lane | Coventry | Coventry | Warning Letter | N/A | ||||
| 10985 | op-snap---monthly-publication-january-2026.pdf | 446 | 2026-01 | Car | Hyundai | i40 | Silver | Driving without Due Care and Attention | None | Links Road | Links Road | Coventry | Coventry | Warning Letter | N/A | 52.4310925 | -1.5197728 | ||
| 11098 | op-snap---monthly-publication-january-2026.pdf | 559 | 2026-01 | Pedal Bike | Toyota | Avensis | Silver | Driving without Due Care and Attention | None | Butts Road | Butts Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4073149 | -1.5250454 | ||
| 11120 | op-snap---monthly-publication-january-2026.pdf | 581 | 2026-01 | Pedal Bike | Ford | Transit | Blue | Driving without Due Care and Attention | None | Burnaby Road at Beake Avenue | Burnaby Road at Beake Avenue | Coventry | Coventry | Education | N/A | 52.4352 | -1.5194238 | ||
| 11210 | op-snap---monthly-publication-january-2026.pdf | 671 | 2026-01 | Pedal Bike | BMW | 320D | Black | Driving without Due Care and Attention | None | Much Park Street | Much Park Street | Coventry | Coventry | Warning Letter | N/A | 52.4061531 | -1.505845 | ||
| 11211 | op-snap---monthly-publication-january-2026.pdf | 672 | 2026-01 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | 52.4070602 | -1.4732469 | ||
| 11273 | op-snap---monthly-publication-january-2026.pdf | 734 | 2026-01 | Pedal Bike | Audi | A3 | Black | Driving without Due Care and Attention | None | Hearsall Common | Hearsall Common | Coventry | Coventry | Warning Letter | N/A | 52.402753 | -1.5385829 | ||
| 11279 | op-snap---monthly-publication-january-2026.pdf | 740 | 2026-01 | Pedal Bike | Mitsubishi | Outlander | Silver | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | ||
| 11328 | op-snap---monthly-publication-january-2026.pdf | 789 | 2026-01 | Car | Seat | Leon | Blue | Driving without Due Care and Attention | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | 52.4134557 | -1.4442138 | ||
| 11351 | op-snap---monthly-publication-january-2026.pdf | 812 | 2026-01 | Pedal Bike | Citroen | C3 | Black | Driving without Due Care and Attention | None | Hollyfast Lane | Hollyfast Lane | Coventry | Coventry | Warning Letter | N/A | 52.4517652 | -1.5578662 | ||
| 11427 | op-snap---monthly-publication-january-2026.pdf | 888 | 2026-01 | Pedal Bike | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Earlsdon Avenue | Earlsdon Avenue | Coventry | Coventry | Education | N/A | 52.4047134 | -1.5351834 | ||
| 11451 | op-snap---monthly-publication-january-2026.pdf | 912 | 2026-01 | Pedal Bike | Audi | A3 | Grey | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Education | N/A | 52.4074716 | -1.5620671 | ||
| 11495 | op-snap---monthly-publication-january-2026.pdf | 956 | 2026-01 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Daventry Road | Daventry Road | Coventry | Coventry | NFA | Not in Public Interest | 52.3930931 | -1.4976428 | ||
| 11501 | op-snap---monthly-publication-january-2026.pdf | 962 | 2026-01 | Car | Honda | CRV | Grey | Driving without Due Care and Attention | None | Bonley Rd, Jimmy Hill Way Roundabout | Bonley Road, Jimmy Hill Way Roundabout | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 11517 | op-snap---monthly-publication-january-2026.pdf | 978 | 2026-01 | Car | Vauxhall | Insignia | White | Driving without Due Care and Attention | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Education | N/A | 52.417344 | -1.5264979 | ||
| 11528 | op-snap---monthly-publication-january-2026.pdf | 989 | 2026-01 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Leamington Road | Leamington Road | Coventry | Coventry | Warning Letter | N/A | 52.3921304 | -1.5156601 | ||
| 11530 | op-snap---monthly-publication-january-2026.pdf | 991 | 2026-01 | Car | Hyundai | I30.. | Grey | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 11533 | op-snap---monthly-publication-january-2026.pdf | 994 | 2026-01 | Car | Iveco | Daily luton van | White | Driving without Due Care and Attention | None | A4053 Ringway Queens | Ringway Queens | Coventry | Coventry | Fixed Penalty | N/A | 52.4039782 | -1.5161639 | ||
| 11539 | op-snap---monthly-publication-january-2026.pdf | 1000 | 2026-01 | Car | Kia | Ceed | Red | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Education | N/A | 52.396476 | -1.5561348 | ||
| 11553 | op-snap---monthly-publication-january-2026.pdf | 1014 | 2026-01 | Pedal Bike | Jaguar | F Pace | Black | Driving without Due Care and Attention | No Insurance | Stoney Stanton road | Stoney Stanton road | Coventry | Coventry | Court | N/A | 52.4221152 | -1.4959475 | ||
| 11557 | op-snap---monthly-publication-january-2026.pdf | 1018 | 2026-01 | Car | Unknown | Green | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Coventry | Coventry | NFA | No Offence | 52.423427 | -1.5471096 | |||
| 11585 | op-snap---monthly-publication-january-2026.pdf | 1046 | 2026-01 | Car | Seat | Altea | Silver | Driving without Due Care and Attention | None | Wainbody Avenue | Wainbody Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3849692 | -1.5311416 | ||
| 11588 | op-snap---monthly-publication-january-2026.pdf | 1049 | 2026-01 | Car | Land Rover | Defender | Black | Driving without Due Care and Attention | None | Stivichall Highway | Stivichall Highway | Coventry | Coventry | Education | N/A | 52.3774003 | -1.493293 | ||
| 11597 | op-snap---monthly-publication-january-2026.pdf | 1058 | 2026-01 | Car | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | Morrisons Car park exit to Holyhead Road | Morrisons Car park exit to Holyhead Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 11607 | op-snap---monthly-publication-january-2026.pdf | 1068 | 2026-01 | Car | Nissan | X-Trail | White | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.418488 | -1.5472387 | ||
| 11647 | op-snap---monthly-publication-january-2026.pdf | 1108 | 2026-01 | Car | BMW | 430.. | Black | Driving without Due Care and Attention | None | Gulson Road | Gulson Road | Coventry | Coventry | Court | N/A | 52.4076795 | -1.4911676 | ||
| 11680 | op-snap---monthly-publication-january-2026.pdf | 1141 | 2026-01 | Car | BMW | M135i | Black | Driving without Due Care and Attention | No Insurance | Cox Street | Cox Street | Coventry | Coventry | Court | N/A | 52.4092228 | -1.5034119 | ||
| 11690 | op-snap---monthly-publication-january-2026.pdf | 1151 | 2026-01 | Pedal Bike | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 11696 | op-snap---monthly-publication-january-2026.pdf | 1157 | 2026-01 | Pedal Bike | Hyundai | i10 | Blue | Driving without Due Care and Attention | None | Albany Road | Albany Road | Coventry | Coventry | Education | N/A | 52.4006218 | -1.5284125 |
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);