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'}
210 rows where council_area = "Coventry", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 30
- Ford 29
- Mercedes-Benz 26
- Toyota 17
- BMW 14
- Volkswagen 14
- Audi 12
- Peugeot 12
- Vauxhall 12
- Seat 8
- Kia 7
- Citroen 6
- Nissan 6
- Renault 6
- Daf 5
- Mazda 5
- Hyundai 3
- Skoda 3
- Byd 2
- Land Rover 2
- London Taxi 2
- Mini 2
- Mitsubishi 2
- Suzuki 2
- Alfa Romeo 1
- Cupra 1
- Honda 1
- Jaguar 1
- Jeep 1
- Mg 1
- Scania 1
month 14
disposal 5
- Education 95
- Warning Letter 46
- NFA 45
- Court 13
- Fixed Penalty 11
reporter_transport_mode 1
- Pedal Bike · 210 ✖
offence 1
- Driving without Due Care and Attention · 210 ✖
council_area 1
- Coventry · 210 ✖
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 11834 | op-snap---monthly-publication-january-2026.pdf | 1295 | 2026-01 | Pedal Bike | Suzuki | Swift | Blue | Driving without Due Care and Attention | None | White Street | White Street | Coventry | Coventry | Court | N/A | 52.4122951 | -1.5045181 | ||
| 4017 | op-snap---monthly-publication-december-2025.pdf | 145 | 2025-12 | Pedal Bike | Ford | Transit | Grey | Driving without Due Care and Attention | None | Westward Way | Westward Way | Coventry | Coventry | Education | N/A | ||||
| 4086 | op-snap---monthly-publication-december-2025.pdf | 214 | 2025-12 | Pedal Bike | Volkswagen | UP | Red | Driving without Due Care and Attention | None | Swanswwell St | Swanswwell Street | Coventry | Coventry | Education | N/A | ||||
| 4378 | op-snap---monthly-publication-december-2025.pdf | 506 | 2025-12 | Pedal Bike | U/K | White | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4141017 | -1.4571973 | |||
| 4426 | op-snap---monthly-publication-december-2025.pdf | 554 | 2025-12 | Pedal Bike | Peugeot | 3008.. | Blue | Driving without Due Care and Attention | None | Gosford Street | Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4068712 | -1.4994695 | ||
| 4477 | op-snap---monthly-publication-december-2025.pdf | 605 | 2025-12 | Pedal Bike | Mercedes-Benz | Camper | White | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 4585 | op-snap---monthly-publication-december-2025.pdf | 713 | 2025-12 | Pedal Bike | Audi | A3 | Black | Driving without Due Care and Attention | None | Broad Lane, Coventry | Broad Lane, Coventry | Coventry | Coventry | Education | N/A | 52.4144409 | -1.5990259 | ||
| 4586 | op-snap---monthly-publication-december-2025.pdf | 714 | 2025-12 | Pedal Bike | Ford | Focus | Blue | Driving without Due Care and Attention | None | Waste Lane, Balsall Common | Waste Lane, Balsall Common | Coventry | Coventry | NFA | No Offence | ||||
| 4620 | op-snap---monthly-publication-december-2025.pdf | 748 | 2025-12 | Pedal Bike | Skoda | Fabia | grey | Driving without Due Care and Attention | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | 52.4071231 | -1.4985178 | ||
| 4716 | op-snap---monthly-publication-december-2025.pdf | 844 | 2025-12 | Pedal Bike | Jeep | Renegade | Black | Driving without Due Care and Attention | None | Broad Lane, Tile Hill, Coventry | Broad Lane, Tile Hill, Coventry | Coventry | Coventry | Education | N/A | 52.4112706 | -1.5792697 | ||
| 4725 | op-snap---monthly-publication-december-2025.pdf | 853 | 2025-12 | Pedal Bike | Mazda | CX3 | Silver | Driving without Due Care and Attention | None | Tile Hill Lane, Tile Hill, Coventry | Tile Hill Lane, Tile Hill, Coventry | Coventry | Coventry | Education | N/A | 52.4019676 | -1.5834005 | ||
| 4727 | op-snap---monthly-publication-december-2025.pdf | 855 | 2025-12 | Pedal Bike | Mazda | CX3 | Silver | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 4728 | op-snap---monthly-publication-december-2025.pdf | 856 | 2025-12 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 4803 | op-snap---monthly-publication-december-2025.pdf | 931 | 2025-12 | Pedal Bike | Mercedes-Benz | S350 | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 5086 | op-snap---monthly-publication-december-2025.pdf | 1214 | 2025-12 | Pedal Bike | Vauxhall | Corsa | Green | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Court | N/A | 52.4221152 | -1.4959475 | ||
| 20488 | op-snap---monthly-publication-november-2025.pdf | 30 | 2025-11 | Pedal Bike | London Taxi | taxi | Black | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 20492 | op-snap---monthly-publication-november-2025.pdf | 34 | 2025-11 | Pedal Bike | Byd | Bus | Grey | Driving without Due Care and Attention | None | Hale Street | Hale Street | Coventry | Coventry | NFA | No Offence | ||||
| 20517 | op-snap---monthly-publication-november-2025.pdf | 59 | 2025-11 | Pedal Bike | Kia | Ceed | Brown | Driving without Due Care and Attention | None | A444 Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Education | N/A | 52.4214017 | -1.4870278 | ||
| 20614 | op-snap---monthly-publication-november-2025.pdf | 156 | 2025-11 | Pedal Bike | Ford | Focus | White | Driving without Due Care and Attention | None | Counden Wedge Drive | Counden Wedge Drive | Coventry | Coventry | Education | N/A | ||||
| 20703 | op-snap---monthly-publication-november-2025.pdf | 245 | 2025-11 | Pedal Bike | BMW | 330E | Black | Driving without Due Care and Attention | Drive otherwise than in accordance with a licence | Foleshill Road | Foleshill Road | Coventry | Coventry | Court | N/A | 52.4274335 | -1.5002381 | ||
| 21298 | op-snap---monthly-publication-november-2025.pdf | 840 | 2025-11 | Pedal Bike | Peugeot | 2008 | Grey | Driving without Due Care and Attention | None | Rochester Road | Rochester Road | Coventry | Coventry | NFA | No Offence | 52.3974085 | -1.5422796 | ||
| 21388 | op-snap---monthly-publication-november-2025.pdf | 930 | 2025-11 | Pedal Bike | Byd | Temsa Coach | White | Driving without Due Care and Attention | None | Lawrence Sanders Road | Lawrence Sanders Road | Coventry | Coventry | NFA | No Offence | ||||
| 21471 | op-snap---monthly-publication-november-2025.pdf | 1013 | 2025-11 | Pedal Bike | Ford | Focus | Silver | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 21494 | op-snap---monthly-publication-november-2025.pdf | 1036 | 2025-11 | Pedal Bike | Peugeot | Expert | White | Driving without Due Care and Attention | None | Albany Road | Albany Road | Coventry | Coventry | Court | N/A | 52.4006218 | -1.5284125 | ||
| 21551 | op-snap---monthly-publication-november-2025.pdf | 1093 | 2025-11 | Pedal Bike | London Taxi | Taxi | Black | Driving without Due Care and Attention | None | Croft Road | Croft Road | Coventry | Coventry | Education | N/A | 52.4064698 | -1.5167474 | ||
| 21575 | op-snap---monthly-publication-november-2025.pdf | 1117 | 2025-11 | Pedal Bike | Volkswagen | Grey | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4103629 | -1.5441218 | |||
| 21967 | op-snap---monthly-publication-november-2025.pdf | 1509 | 2025-11 | Pedal Bike | Levc | White | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | No Offence | 52.4103629 | -1.5441218 | |||
| 21968 | op-snap---monthly-publication-november-2025.pdf | 1510 | 2025-11 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Swanawell Street | Swanawell Street | Coventry | Coventry | Warning Letter | N/A | ||||
| 21982 | op-snap---monthly-publication-november-2025.pdf | 1524 | 2025-11 | Pedal Bike | Volkswagen | Caddy | Red | Driving without Due Care and Attention | None | Bridle Brook Lane | Bridle Brook Lane | Coventry | Coventry | Education | N/A | 52.4475078 | -1.5736787 | ||
| 22044 | op-snap---monthly-publication-november-2025.pdf | 1586 | 2025-11 | Pedal Bike | Peugeot | 308 | Grey | Driving without Due Care and Attention | None | Dutton Road | Dutton Road | Coventry | Coventry | Court | N/A | 52.4447067 | -1.458495 | ||
| 22102 | op-snap---monthly-publication-october-2025.pdf | 52 | 2025-10 | Pedal Bike | BMW | 435.. | Black | Driving without Due Care and Attention | None | Allesley Road | Allesley Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.412663 | -1.5443742 | ||
| 22110 | op-snap---monthly-publication-october-2025.pdf | 60 | 2025-10 | Pedal Bike | Volkswagen | Transporter | Grey | Driving without Due Care and Attention | None | Earlsdon Av | Earlsdon Avenue | Coventry | Coventry | Education | N/A | 52.4047134 | -1.5351834 | ||
| 22122 | op-snap---monthly-publication-october-2025.pdf | 72 | 2025-10 | Pedal Bike | Skoda | Octavia | Silver | Driving without Due Care and Attention | None | Hurst Road | Hurst Road | Coventry | Coventry | NFA | No Offence | 52.4496884 | -1.4816181 | ||
| 22271 | op-snap---monthly-publication-october-2025.pdf | 221 | 2025-10 | Pedal Bike | Daf | Lorry | white | Driving without Due Care and Attention | None | Broad Lane, Coventry | Broad Lane, Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4144409 | -1.5990259 | ||
| 22311 | op-snap---monthly-publication-october-2025.pdf | 261 | 2025-10 | Pedal Bike | Toyota | Aygo | Red | Driving without Due Care and Attention | None | Corporation Road | Corporation Road | Coventry | Coventry | Education | N/A | ||||
| 22357 | op-snap---monthly-publication-october-2025.pdf | 307 | 2025-10 | Pedal Bike | Kia | Niro | White | Driving without Due Care and Attention | None | Hales Street | Hales Street | Coventry | Coventry | Fixed Penalty | N/A | 52.4110271 | -1.5074539 | ||
| 22447 | op-snap---monthly-publication-october-2025.pdf | 397 | 2025-10 | Pedal Bike | Volkswagen | Polo | Orange | Driving without Due Care and Attention | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Education | N/A | 52.417344 | -1.5264979 | ||
| 22448 | op-snap---monthly-publication-october-2025.pdf | 398 | 2025-10 | Pedal Bike | Mini | Mini | Black | Driving without Due Care and Attention | None | Four Pounds Avenue | Four Pounds Avenue | Coventry | Coventry | Warning Letter | N/A | 52.413228 | -1.5323652 | ||
| 22449 | op-snap---monthly-publication-october-2025.pdf | 399 | 2025-10 | Pedal Bike | Renault | Clio | White | Driving without Due Care and Attention | None | Earlsdon Avenue | Earlsdon Avenue | Coventry | Coventry | NFA | No Offence | 52.4047134 | -1.5351834 | ||
| 22546 | op-snap---monthly-publication-october-2025.pdf | 496 | 2025-10 | Pedal Bike | Mercedes-Benz | C220 | Grey | Driving without Due Care and Attention | None | Hales Street / White Street | Hales Street / White Street | Coventry | Coventry | NFA | No Offence | 52.4107158 | -1.5078486 | ||
| 22621 | op-snap---monthly-publication-october-2025.pdf | 571 | 2025-10 | Pedal Bike | Mercedes-Benz | A35 | Black | Driving without Due Care and Attention | None | Shorncliffe Road | Shorncliffe Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4243896 | -1.5433694 | ||
| 22622 | op-snap---monthly-publication-october-2025.pdf | 572 | 2025-10 | Pedal Bike | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Shorncliffe Road | Shorncliffe Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4243896 | -1.5433694 | ||
| 22623 | op-snap---monthly-publication-october-2025.pdf | 573 | 2025-10 | Pedal Bike | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | West Hill Road | West Hill Road | Coventry | Coventry | Education | N/A | 52.3994858 | -1.4923603 | ||
| 22637 | op-snap---monthly-publication-october-2025.pdf | 587 | 2025-10 | Pedal Bike | Toyota | Auris | Black | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | 52.4070602 | -1.4732469 | ||
| 22690 | op-snap---monthly-publication-october-2025.pdf | 640 | 2025-10 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 22699 | op-snap---monthly-publication-october-2025.pdf | 649 | 2025-10 | Pedal Bike | Mazda | 3 | Silver | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Warning Letter | N/A | 52.4103629 | -1.5441218 | ||
| 22713 | op-snap---monthly-publication-october-2025.pdf | 663 | 2025-10 | Pedal Bike | Volkswagen | T-Roc | Black | Driving without Due Care and Attention | None | Gosford Street | Gosford Street | Coventry | Coventry | Education | N/A | 52.4068712 | -1.4994695 | ||
| 22718 | op-snap---monthly-publication-october-2025.pdf | 668 | 2025-10 | Pedal Bike | Ford | B-Max | White | Driving without Due Care and Attention | None | Leamington Road | Leamington Road | Coventry | Coventry | Education | N/A | 52.3921304 | -1.5156601 | ||
| 22830 | op-snap---monthly-publication-october-2025.pdf | 780 | 2025-10 | Pedal Bike | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 22847 | op-snap---monthly-publication-october-2025.pdf | 797 | 2025-10 | Pedal Bike | Audi | Silver | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | |||
| 22939 | op-snap---monthly-publication-october-2025.pdf | 889 | 2025-10 | Pedal Bike | BMW | X2` | Blue | Driving without Due Care and Attention | None | St Nicholas St | Street Nicholas Street | Coventry | Coventry | Education | N/A | 52.4133001 | -1.5126792 | ||
| 23005 | op-snap---monthly-publication-october-2025.pdf | 955 | 2025-10 | Pedal Bike | Mercedes-Benz | E200 | Black | Driving without Due Care and Attention | None | Butts Road near Albany Road | Butts Road near Albany Road | Coventry | Coventry | Education | N/A | 52.4078926 | -1.5256816 | ||
| 23024 | op-snap---monthly-publication-october-2025.pdf | 974 | 2025-10 | Pedal Bike | Honda | Civic | Red | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | 52.4221152 | -1.4959475 | ||
| 23048 | op-snap---monthly-publication-october-2025.pdf | 998 | 2025-10 | Pedal Bike | Seat | Arona | Blue | Driving without Due Care and Attention | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Education | N/A | 52.4103629 | -1.5441218 | ||
| 23881 | op-snap---monthly-publication-september-2025.pdf | 100 | 2025-09 | Pedal Bike | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Corporation Street | Corporation Street | Coventry | Coventry | Warning Letter | N/A | 52.4086244 | -1.515132 | ||
| 24107 | op-snap---monthly-publication-september-2025.pdf | 326 | 2025-09 | Pedal Bike | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | B4101 TILE HILL LANE | B4101 Tile Hill Lane | Coventry | Coventry | Fixed Penalty | N/A |
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);