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'}
77 rows where council_area = "Coventry", month = "2025-07" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 26
offence 14
- Driving without Due Care and Attention 31
- Contravening a Red Traffic Light 20
- Driving without Reasonable Consideration 8
- Using a Mobile Phone Whilst Driving 5
- Cause vehicle to be left in a dangerous position 4
- Contravene Lane Closure Red X 1
- Driver not in position to have Proper Control 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- No Insurance 1
- No Seat Belt 1
- Prohibited vehicle in offside lane of motorway 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
disposal 5
- NFA 32
- Warning Letter 23
- Education 14
- Court 4
- Fixed Penalty 4
reporter_transport_mode 1
- Car · 77 ✖
month 1
- 2025-07 · 77 ✖
council_area 1
- Coventry · 77 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11961 | op-snap---monthly-publication-july-2025.pdf | 13 | 2025-07 | Car | Ford | Transit | Silver | Using a Mobile Phone Whilst Driving | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.418488 | -1.5472387 | ||
| 11989 | op-snap---monthly-publication-july-2025.pdf | 41 | 2025-07 | Car | Volkswagen | Caddy | White | Driving without Reasonable Consideration | None | Grange Road, Coventry | Grange Road, Coventry | Coventry | Coventry | Warning Letter | N/A | 52.4521035 | -1.4777638 | ||
| 12002 | op-snap---monthly-publication-july-2025.pdf | 54 | 2025-07 | Car | Daf | Grey | Contravening a Red Traffic Light | none | Sir Henry Parkes Road | Sir Henry Parkes Road | Coventry | Coventry | Warning Letter | N/A | 52.3900568 | -1.5550766 | |||
| 12014 | op-snap---monthly-publication-july-2025.pdf | 66 | 2025-07 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4214017 | -1.4870278 | ||
| 12019 | op-snap---monthly-publication-july-2025.pdf | 71 | 2025-07 | Car | Mg | Trophy | Grey | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Coventry | Coventry | NFA | No Offence | 52.3833298 | -1.5379214 | ||
| 12042 | op-snap---monthly-publication-july-2025.pdf | 94 | 2025-07 | Car | Mercedes-Benz | GLE | Blue | Contravene Lane Closure Red X | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4103629 | -1.5441218 | ||
| 12064 | op-snap---monthly-publication-july-2025.pdf | 116 | 2025-07 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Daventry Road | Daventry Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3930931 | -1.4976428 | ||
| 12113 | op-snap---monthly-publication-july-2025.pdf | 165 | 2025-07 | Car | Kia | GT.. | Grey | Driving without Due Care and Attention | None | B4101 Coventry | Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.400739 | -1.5135474 | ||
| 12136 | op-snap---monthly-publication-july-2025.pdf | 188 | 2025-07 | Car | Hyundai | Kona | Black | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Education | N/A | ||||
| 12143 | op-snap---monthly-publication-july-2025.pdf | 195 | 2025-07 | Car | Skoda | Octavia | Black | Driving without Reasonable Consideration | None | A444 Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 12176 | op-snap---monthly-publication-july-2025.pdf | 228 | 2025-07 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Widdrington Road | Widdrington Road | Coventry | Coventry | Education | N/A | 52.4191764 | -1.5105738 | ||
| 12187 | op-snap---monthly-publication-july-2025.pdf | 239 | 2025-07 | Car | BMW | M 440.. | Blue | Contravening a Red Traffic Light | None | Mile Lane | Mile Lane | Coventry | Coventry | Education | N/A | 52.3992732 | -1.5044832 | ||
| 12235 | op-snap---monthly-publication-july-2025.pdf | 287 | 2025-07 | Car | Grey | Contravening a Red Traffic Light | None | Croft Road at Starley Road | Croft Road at Starley Road | Coventry | Coventry | NFA | No VRM | 52.4060808 | -1.5185521 | ||||
| 12236 | op-snap---monthly-publication-july-2025.pdf | 288 | 2025-07 | Car | Motorcycle | White | Driving without Due Care and Attention | None | Millenium Plaza | Millenium Plaza | Coventry | Coventry | NFA | No VRM | |||||
| 12246 | op-snap---monthly-publication-july-2025.pdf | 298 | 2025-07 | Car | Mini | Mini | Yellow | Driving without Due Care and Attention | None | Coventry | Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | 52.400739 | -1.5135474 | ||
| 12307 | op-snap---monthly-publication-july-2025.pdf | 359 | 2025-07 | Car | Jaguar | S Type | Green | Contravening a Red Traffic Light | None | Firefly Road | Firefly Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3786307 | -1.4839701 | ||
| 12308 | op-snap---monthly-publication-july-2025.pdf | 360 | 2025-07 | Car | Toyota | Prius | Red | Contravening a Red Traffic Light | No vehicle excise licence | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.396476 | -1.5561348 | ||
| 12317 | op-snap---monthly-publication-july-2025.pdf | 369 | 2025-07 | Car | Mercedes-Benz | White | Driving without Due Care and Attention | None | A444 Rowlwys Green Roundabout | Rowlwys Green Roundabout | Coventry | Coventry | Court | N/A | |||||
| 12318 | op-snap---monthly-publication-july-2025.pdf | 370 | 2025-07 | Car | Alfa Romeo | Giulietta | Red | Using a Mobile Phone Whilst Driving | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Fixed Penalty | N/A | 52.418488 | -1.5472387 | ||
| 12371 | op-snap---monthly-publication-july-2025.pdf | 423 | 2025-07 | Car | Toyota | Auris | White | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | 52.4134557 | -1.4442138 | ||
| 12412 | op-snap---monthly-publication-july-2025.pdf | 464 | 2025-07 | Car | Volkswagen | Up | Gold | Driving without Due Care and Attention | None | Sir William Lyons Road | Sir William Lyons Road | Coventry | Coventry | Education | N/A | 52.3877545 | -1.5585877 | ||
| 12415 | op-snap---monthly-publication-july-2025.pdf | 467 | 2025-07 | Car | Nissan | Qashqai | Silver | Contravening a Red Traffic Light | None | Four Pounds Avenue | Four Pounds Avenue | Coventry | Coventry | Education | N/A | 52.413228 | -1.5323652 | ||
| 12475 | op-snap---monthly-publication-july-2025.pdf | 527 | 2025-07 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | A45 Dunchurch Highway | Dunchurch Highway | Coventry | Coventry | Education | N/A | 52.4131902 | -1.5650136 | ||
| 12505 | op-snap---monthly-publication-july-2025.pdf | 557 | 2025-07 | Car | Skoda | Citigo | Red | Driving without Due Care and Attention | None | Stivichall Roundabout | Stivichall Roundabout | Coventry | Coventry | Warning Letter | N/A | 52.3776818 | -1.4982138 | ||
| 12519 | op-snap---monthly-publication-july-2025.pdf | 571 | 2025-07 | Car | Ford | Focus | Grey | Using a Mobile Phone Whilst Driving | None | Lockhurst Lane | Lockhurst Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4255689 | -1.5023841 | ||
| 12529 | op-snap---monthly-publication-july-2025.pdf | 581 | 2025-07 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4070602 | -1.4732469 | ||
| 12543 | op-snap---monthly-publication-july-2025.pdf | 595 | 2025-07 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | No Insurance | Ringway Street | Ringway Street | Coventry | Coventry | Court | N/A | ||||
| 12584 | op-snap---monthly-publication-july-2025.pdf | 636 | 2025-07 | Car | Vauxhall | Astra | Grey | Driving without Reasonable Consideration | None | Moseley Avenue | Moseley Avenue | Coventry | Coventry | Warning Letter | N/A | 52.417344 | -1.5264979 | ||
| 12614 | op-snap---monthly-publication-july-2025.pdf | 666 | 2025-07 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Hales Street | Hales Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4110271 | -1.5074539 | ||
| 12648 | op-snap---monthly-publication-july-2025.pdf | 700 | 2025-07 | Car | Peugeot | Partner | Grey | Contravening a Red Traffic Light | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4041117 | -1.5595662 | ||
| 12661 | op-snap---monthly-publication-july-2025.pdf | 713 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A45 Covntry | Covntry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 12662 | op-snap---monthly-publication-july-2025.pdf | 714 | 2025-07 | Car | Kia | Niro | Grey | Driving without Due Care and Attention | None | The Chesils | The Chesils | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3887111 | -1.5065639 | ||
| 12671 | op-snap---monthly-publication-july-2025.pdf | 723 | 2025-07 | Car | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Warning Letter | N/A | 52.436155 | -1.5064002 | ||
| 12725 | op-snap---monthly-publication-july-2025.pdf | 777 | 2025-07 | Car | Audi | A1 | Red | Driving without Due Care and Attention | None | Bulls Head Lane | Bulls Head Lane | Coventry | Coventry | Education | N/A | 52.4026553 | -1.4800859 | ||
| 12756 | op-snap---monthly-publication-july-2025.pdf | 808 | 2025-07 | Car | Citroen | Picasso | Beige | Driving without Due Care and Attention | None | Spon End | Spon End | Coventry | Coventry | NFA | Not in Public Interest | 52.4069072 | -1.5247498 | ||
| 12778 | op-snap---monthly-publication-july-2025.pdf | 830 | 2025-07 | Car | Renault | Grey | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Education | N/A | 52.418488 | -1.5472387 | |||
| 12781 | op-snap---monthly-publication-july-2025.pdf | 833 | 2025-07 | Car | Audi | Q3 | Grey | Contravening a Red Traffic Light | None | B4027 | B4027 | Coventry | Coventry | Education | N/A | 52.3994858 | -1.4923603 | ||
| 12782 | op-snap---monthly-publication-july-2025.pdf | 834 | 2025-07 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Gulson Road | Gulson Road | Coventry | Coventry | Warning Letter | N/A | 52.4076795 | -1.4911676 | ||
| 12855 | op-snap---monthly-publication-july-2025.pdf | 907 | 2025-07 | Car | Ford | Fiesat | Silver | Driving a vehicle wholly or partly on a footpath | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.436155 | -1.5064002 | ||
| 12856 | op-snap---monthly-publication-july-2025.pdf | 908 | 2025-07 | Car | Land Rover | Discovert | White | Driving without Due Care and Attention | None | Whitley Interchange | Whitley Interchange | Coventry | Coventry | Education | N/A | ||||
| 12872 | op-snap---monthly-publication-july-2025.pdf | 924 | 2025-07 | Car | Toyota | Prius | Gold | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4205675 | -1.4520187 | ||
| 12884 | op-snap---monthly-publication-july-2025.pdf | 936 | 2025-07 | Car | Ford | focus | Grey | Driving without Due Care and Attention | None | A46 | A46 | Coventry | Coventry | NFA | No Offence | ||||
| 12915 | op-snap---monthly-publication-july-2025.pdf | 967 | 2025-07 | Car | Volkswagen | T - Ron | Black | Contravening a Red Traffic Light | None | Broad Lane - A45 | Broad Lane - A45 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4054611 | -1.5491157 | ||
| 12919 | op-snap---monthly-publication-july-2025.pdf | 971 | 2025-07 | Car | Vauxhall | Insignia | Blue | Driving without Reasonable Consideration | None | Eastern Green Road , Coventry | Eastern Green Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4131188 | -1.5784769 | ||
| 12938 | op-snap---monthly-publication-july-2025.pdf | 990 | 2025-07 | Car | Volvo | Lorry | White | Driving without Reasonable Consideration | None | Cornetts End lane | Cornetts End lane | Coventry | Coventry | Court | N/A | ||||
| 12963 | op-snap---monthly-publication-july-2025.pdf | 1015 | 2025-07 | Car | Nissan | Qashqai | Red | Driving without Due Care and Attention | None | Ansty Interchange | Ansty Interchange | Coventry | Coventry | Education | N/A | 52.4399359 | -1.4395909 | ||
| 12970 | op-snap---monthly-publication-july-2025.pdf | 1022 | 2025-07 | Car | Seat | Ibiza | Silver | Using a Mobile Phone Whilst Driving | None | Southbound of M5 - Junction 5 | Southbound of M5 - Junction 5 | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 12987 | op-snap---monthly-publication-july-2025.pdf | 1039 | 2025-07 | Car | Audi | A3 | Grey | Contravening a Red Traffic Light | None | Coventry Road , A45 | Coventry Road , A45 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4516899 | -1.7753139 | ||
| 12992 | op-snap---monthly-publication-july-2025.pdf | 1044 | 2025-07 | Car | Audi | A3 Sport | Grey | Driving without Reasonable Consideration | No Insurance | Hockett Street , Coventry | Hockett Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3981697 | -1.5050109 | ||
| 13034 | op-snap---monthly-publication-july-2025.pdf | 1086 | 2025-07 | Car | Mercedes-Benz | White | Driving without Reasonable Consideration | None | Sherbourne Street , Coventry | Sherbourne Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4080688 | -1.5236936 | |||
| 13085 | op-snap---monthly-publication-july-2025.pdf | 1137 | 2025-07 | Car | Mercedes-Benz | Silver | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | Warning Letter | N/A | 52.4235908 | -1.5226276 | |||
| 13087 | op-snap---monthly-publication-july-2025.pdf | 1139 | 2025-07 | Car | BMW | 320i | Blue | No Insurance | Use vehicle on a road without | Kvainligds t eRsot acde,r tCifoicvaetentry | Kvainligds t e Rsot acde, r t Cifoicvaetentry | Coventry | Coventry | Court | N/A | ||||
| 13108 | op-snap---monthly-publication-july-2025.pdf | 1160 | 2025-07 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Banner Lane | Banner Lane | Coventry | Coventry | Education | N/A | 52.4010821 | -1.5953502 | ||
| 13111 | op-snap---monthly-publication-july-2025.pdf | 1163 | 2025-07 | Car | BMW | 218 | Blue | Driving without Due Care and Attention | None | Beake Avenue | Beake Avenue | Coventry | Coventry | Education | N/A | 52.4388246 | -1.5229308 | ||
| 13160 | op-snap---monthly-publication-july-2025.pdf | 1212 | 2025-07 | Car | Audi | A3.. | White | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4205675 | -1.4520187 | ||
| 13190 | op-snap---monthly-publication-july-2025.pdf | 1242 | 2025-07 | Car | Kia | Rio.. | Red | Contravening a Red Traffic Light | None | B4109 Aldermans Green Road | Aldermans Green Road | Coventry | Coventry | Education | N/A | 52.4520641 | -1.4663835 | ||
| 13196 | op-snap---monthly-publication-july-2025.pdf | 1248 | 2025-07 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4214017 | -1.4870278 | ||
| 13198 | op-snap---monthly-publication-july-2025.pdf | 1250 | 2025-07 | Car | Scania | Tractor | White | Driving without Due Care and Attention | None | Toll Bar End | Toll Bar End | Coventry | Coventry | Warning Letter | N/A | 52.377406 | -1.4651313 | ||
| 13199 | op-snap---monthly-publication-july-2025.pdf | 1251 | 2025-07 | Car | Peugeot | Boxer | White | Driving without Due Care and Attention | None | Torrington Avenue | Torrington Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3987354 | -1.567693 | ||
| 13212 | op-snap---monthly-publication-july-2025.pdf | 1264 | 2025-07 | Car | Hyundai | Blue | Contravening a Red Traffic Light | None | Broad Lane | Broad Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4074716 | -1.5620671 | |||
| 13224 | op-snap---monthly-publication-july-2025.pdf | 1276 | 2025-07 | Car | BMW | 218i | White | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Warning Letter | N/A | ||||
| 13225 | op-snap---monthly-publication-july-2025.pdf | 1277 | 2025-07 | Car | Hyundai | Silver | Motor vehicle fail to accord precedence at a pelican crossing | None | Jordan Well | Jordan Well | Coventry | Coventry | Fixed Penalty | N/A | 52.4068069 | -1.5051214 | |||
| 13243 | op-snap---monthly-publication-july-2025.pdf | 1295 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Contravening a Red Traffic Light | None | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3793117 | -1.4625379 | ||
| 13249 | op-snap---monthly-publication-july-2025.pdf | 1301 | 2025-07 | Car | Dacia | Sandero | White | Driving without Due Care and Attention | None | A45 Sir Henry Parkes Road | Sir Henry Parkes Road | Coventry | Coventry | Warning Letter | N/A | 52.3900568 | -1.5550766 | ||
| 13342 | op-snap---monthly-publication-july-2025.pdf | 1394 | 2025-07 | Car | Toyota | Prius | Silver | Cause vehicle to be left in a dangerous position | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Warning Letter | N/A | 52.3988977 | -1.5323674 | ||
| 13410 | op-snap---monthly-publication-july-2025.pdf | 1462 | 2025-07 | Car | Citroen | C4 | Blue | Driving without Due Care and Attention | None | Cheveral Avenue | Cheveral Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4257402 | -1.5185037 | ||
| 13496 | op-snap---monthly-publication-july-2025.pdf | 1548 | 2025-07 | Car | Audi | A3 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Holy Head road | Holy Head road | Coventry | Coventry | Warning Letter | N/A | ||||
| 13548 | op-snap---monthly-publication-july-2025.pdf | 1600 | 2025-07 | Car | BMW | X1 | White | No Seat Belt | None | Croft Road | Croft Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4064698 | -1.5167474 | ||
| 13606 | op-snap---monthly-publication-july-2025.pdf | 1658 | 2025-07 | Car | Vauxhall | Corsa | 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 | ||
| 13759 | op-snap---monthly-publication-july-2025.pdf | 1811 | 2025-07 | Car | Ford | BMAX | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Barras Lane | Barras Lane | Coventry | Coventry | Warning Letter | N/A | 52.4109877 | -1.5203488 | ||
| 13772 | op-snap---monthly-publication-july-2025.pdf | 1824 | 2025-07 | Car | Ford | Luton | White | Driver not in position to have Proper Control | None | London Road, Coventry | London Road, Coventry | Coventry | Coventry | NFA | Not in Public Interest | 52.3916468 | -1.4925995 | ||
| 13901 | op-snap---monthly-publication-july-2025.pdf | 1953 | 2025-07 | Car | Citroen | Berlingo | White | Using a Mobile Phone Whilst Driving | None | Unknon in Coventry | Unknon in Coventry | Coventry | Coventry | Warning Letter | N/A | ||||
| 13918 | op-snap---monthly-publication-july-2025.pdf | 1970 | 2025-07 | Car | Mazda | 3 Sport | Silver | Driving without Due Care and Attention | None | Holyhead road | Holyhead road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 13955 | op-snap---monthly-publication-july-2025.pdf | 2007 | 2025-07 | Car | Audi | Q3 | Black | Cause vehicle to be left in a dangerous position | None | Queen Victoria Road | Queen Victoria Road | Coventry | Coventry | Warning Letter | N/A | 52.4063195 | -1.5157306 | ||
| 13956 | op-snap---monthly-publication-july-2025.pdf | 2008 | 2025-07 | Car | Volkswagen | Polo | Blue | Cause vehicle to be left in a dangerous position | None | Queen Victoria Road | Queen Victoria Road | Coventry | Coventry | Warning Letter | N/A | 52.4063195 | -1.5157306 | ||
| 13961 | op-snap---monthly-publication-july-2025.pdf | 2013 | 2025-07 | Car | Mercedes-Benz | c220 | Black | Driving without Due Care and Attention | None | A444 | A444 | Coventry | Coventry | Warning Letter | N/A | ||||
| 14040 | op-snap---monthly-publication-july-2025.pdf | 2092 | 2025-07 | Car | Iveco | Daily | White | Prohibited vehicle in offside lane of motorway | None | M6 North junction3 | M6 North junction3 | Coventry | Coventry | Warning Letter | 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);