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'}
616 rows where council_area = "Coventry" and disposal = "NFA" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence >30
- Driving without Due Care and Attention 186
- Contravening a Red Traffic Light 97
- Driving without Reasonable Consideration 85
- Misc - Non Traffic Offences 72
- Using a Mobile Phone Whilst Driving 43
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 33
- Cause vehicle to be left in a dangerous position 22
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 16
- Stop a vehicle within pelican pedestrian crossing limits 13
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 11
- Stop a vehicle on pedestrian crossing 9
- Driving a vehicle wholly or partly on a footpath 3
- Fail to Conform to Cycle Lane 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Contravene Lane Closure Red X 2
- Dangerous Driving 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Cause unnecessary obstruction by motor vehicle 1
- Drive / Ride / Lead an animal on a footpath 1
- Driver not in position to have Proper Control 1
- Motor vehicle fail to accord precedence at a pelic 1
- Motor vehicle fail to comply with a non endorsab 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- No Insurance 1
- No Seat Belt 1
- No vehicle excise licence 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use a vehicle / cycle on a road and contravene a l 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- …
month 14
reporter_transport_mode 10
- Car 318
- Pedal Bike 179
- Pedestrian 95
- Other 17
- car 2
- Horse Rider 1
- Lorry 1
- Motorbike 1
- Pedal Cycle 1
- Pedal cycle 1
disposal 1
- NFA · 616 ✖
council_area 1
- Coventry · 616 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7267 | op-snap---monthly-publication-february-2026.pdf | 14 | 2026-02 | Pedestrian | Toyota | Elgrand | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Philip Stowell Road | Philip Stowell Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4499866 | -1.5418947 | ||
| 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 | ||
| 7512 | op-snap---monthly-publication-february-2026.pdf | 259 | 2026-02 | Pedestrian | Kia | Niro | White | Stop a vehicle on pedestrian crossing | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4111289 | -1.5094345 | ||
| 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 | ||
| 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 | |||
| 7968 | op-snap---monthly-publication-february-2026.pdf | 715 | 2026-02 | Pedestrian | DS3 | Black | Drive / Ride / Lead an animal on a footpath | None | Long Bank Avenue | Long Bank Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | |||||
| 7995 | op-snap---monthly-publication-february-2026.pdf | 742 | 2026-02 | Car | Dacia | Sandero | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hawthorne Lane | Hawthorne Lane | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 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 | ||||
| 8087 | op-snap---monthly-publication-february-2026.pdf | 834 | 2026-02 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | 52.4070602 | -1.4732469 | |||
| 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 | ||||
| 8249 | op-snap---monthly-publication-february-2026.pdf | 996 | 2026-02 | Car | BMW | 120 Sport | White | Using a Mobile Phone Whilst Driving | None | Scimitar Way | Scimitar Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3836203 | -1.4862458 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 8890 | op-snap---monthly-publication-february-2026.pdf | 1637 | 2026-02 | Pedal Bike | Jaguar | xj | Black | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4221152 | -1.4959475 | ||
| 10548 | op-snap---monthly-publication-january-2026.pdf | 9 | 2026-01 | Car | Mercedes-Benz | A200 | Black | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4070602 | -1.4732469 | ||
| 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 | ||
| 10565 | op-snap---monthly-publication-january-2026.pdf | 26 | 2026-01 | Pedal Bike | BMW | M3 | Grey | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 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 | ||
| 10633 | op-snap---monthly-publication-january-2026.pdf | 94 | 2026-01 | Car | Audi | Q2 | Grey | Contravening a Red Traffic Light | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4085943 | -1.4943275 | ||
| 10638 | op-snap---monthly-publication-january-2026.pdf | 99 | 2026-01 | Car | Peugeot | 3008 | Red | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 10757 | op-snap---monthly-publication-january-2026.pdf | 218 | 2026-01 | Pedestrian | Ford | Fiesta | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4331816 | -1.5630141 | ||
| 10764 | op-snap---monthly-publication-january-2026.pdf | 225 | 2026-01 | Pedestrian | Citroen | Picasso | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fenton Rd | Fenton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4331816 | -1.5630141 | ||
| 10765 | op-snap---monthly-publication-january-2026.pdf | 226 | 2026-01 | Pedestrian | Citroen | Picasso | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fenton Rd | Fenton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4331816 | -1.5630141 | ||
| 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 | ||
| 10976 | op-snap---monthly-publication-january-2026.pdf | 437 | 2026-01 | Car | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 11036 | op-snap---monthly-publication-january-2026.pdf | 497 | 2026-01 | Car | Mitsubishi | Black | Misc - Non Traffic Offences | None | Coventry | Coventry | Coventry | Coventry | NFA | Misc Inc Crimes | 52.400739 | -1.5135474 | |||
| 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 | ||
| 11119 | op-snap---monthly-publication-january-2026.pdf | 580 | 2026-01 | Pedal Bike | Honda | Civic | Blue | Contravening a Red Traffic Light | None | Burnaby Road at Beake Avenue | Burnaby Road at Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4352 | -1.5194238 | ||
| 11254 | op-snap---monthly-publication-january-2026.pdf | 715 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 11298 | op-snap---monthly-publication-january-2026.pdf | 759 | 2026-01 | Pedestrian | Renault | Megane | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 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 | ||
| 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 | |||
| 11558 | op-snap---monthly-publication-january-2026.pdf | 1019 | 2026-01 | Pedal Bike | Vauxhall | Corsa | White | Using a Mobile Phone Whilst Driving | None | A45, Coventry | A45, Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3791309 | -1.4740067 | ||
| 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 | ||
| 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 | ||
| 11632 | op-snap---monthly-publication-january-2026.pdf | 1093 | 2026-01 | Pedestrian | Seat | Arona | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3848122 | -1.5204351 | ||
| 11797 | op-snap---monthly-publication-january-2026.pdf | 1258 | 2026-01 | Car | Toyota | Dyna van | White | Driving without Due Care and Attention | None | Roundabout Middlemarch Business Park | Roundabout Middlemarch Business Park | Coventry | Coventry | NFA | No Offence | ||||
| 3879 | op-snap---monthly-publication-december-2025.pdf | 7 | 2025-12 | Car | Renault | Lorry | White | Driving without Due Care and Attention | None | M6 | M6 | Coventry | Coventry | NFA | No Offence | ||||
| 3905 | op-snap---monthly-publication-december-2025.pdf | 33 | 2025-12 | Pedestrian | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3906 | op-snap---monthly-publication-december-2025.pdf | 34 | 2025-12 | Pedestrian | Ford | Fiesta | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3907 | op-snap---monthly-publication-december-2025.pdf | 35 | 2025-12 | Pedestrian | Mercedes-Benz | Grey | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | |||
| 3966 | op-snap---monthly-publication-december-2025.pdf | 94 | 2025-12 | Pedestrian | BMW | 118D | Blue | Cause vehicle to be left in a dangerous position | None | charter avenue | Charter Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3928409 | -1.5888076 | ||
| 3967 | op-snap---monthly-publication-december-2025.pdf | 95 | 2025-12 | Pedestrian | Peugeot | 308 | Silver | Cause vehicle to be left in a dangerous position | None | charter avenue | Charter Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3928409 | -1.5888076 | ||
| 4043 | op-snap---monthly-publication-december-2025.pdf | 171 | 2025-12 | Car | Ford | White | Using a Mobile Phone Whilst Driving | None | Leamington Road | Leamington Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3921304 | -1.5156601 | |||
| 4058 | op-snap---monthly-publication-december-2025.pdf | 186 | 2025-12 | Car | Toyota | Yaris | White | Contravening a Red Traffic Light | None | Beake Avenue | Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4388246 | -1.5229308 | ||
| 4181 | op-snap---monthly-publication-december-2025.pdf | 309 | 2025-12 | Car | Ford | Transit | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A46 Warwick Road | Warwick Road | Coventry | Coventry | NFA | No VRM | 52.401916 | -1.5154953 | ||
| 4377 | op-snap---monthly-publication-december-2025.pdf | 505 | 2025-12 | Pedal Bike | NP | Misc - Non Traffic Offences | None | Mellowdew Road | Mellowdew Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4128327 | -1.4672401 | ||||
| 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 | |||
| 4465 | op-snap---monthly-publication-december-2025.pdf | 593 | 2025-12 | Car | Quad | Black | Driving without Due Care and Attention | None | UK | Uk | Coventry | Coventry | NFA | No VRM | 52.3994858 | -1.4923603 | |||
| 4479 | op-snap---monthly-publication-december-2025.pdf | 607 | 2025-12 | Pedal Bike | Mazda | RX 8 | Silver | Contravening a Red Traffic Light | None | Bell Green Road | Bell Green Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4324855 | -1.4815548 | ||
| 4572 | op-snap---monthly-publication-december-2025.pdf | 700 | 2025-12 | Car | Audi | Q3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Binley Rd | Binley Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4070602 | -1.4732469 | ||
| 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 | ||||
| 4595 | op-snap---monthly-publication-december-2025.pdf | 723 | 2025-12 | Pedestrian | Citroen | c4 | Black | Cause vehicle to be left in a dangerous position | None | halford lane | Halford Lane | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4398231 | -1.526811 | ||
| 4623 | op-snap---monthly-publication-december-2025.pdf | 751 | 2025-12 | Car | Mercedes-Benz | GLE 400 | Blue | Driving without Due Care and Attention | None | A46 | A46 | Coventry | Coventry | NFA | No Offence | ||||
| 4638 | op-snap---monthly-publication-december-2025.pdf | 766 | 2025-12 | Car | BMW | Black | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | No VRM | 52.4085943 | -1.4943275 | |||
| 4651 | op-snap---monthly-publication-december-2025.pdf | 779 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 4737 | op-snap---monthly-publication-december-2025.pdf | 865 | 2025-12 | Car | Peugeot | Allure | Black | Misc - Non Traffic Offences | None | Leicester Row | Leicester Row | Coventry | Coventry | NFA | No Independent Evidence Available | 52.414317 | -1.5104573 | ||
| 4757 | op-snap---monthly-publication-december-2025.pdf | 885 | 2025-12 | Car | Audi | TT | Black | Using a Mobile Phone Whilst Driving | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4459998 | -1.6949291 | ||
| 4807 | op-snap---monthly-publication-december-2025.pdf | 935 | 2025-12 | Car | Ford | Cmax | Blue | Driving without Due Care and Attention | None | Oakmoor Road | Oakmoor Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4485736 | -1.4819358 | ||
| 4815 | op-snap---monthly-publication-december-2025.pdf | 943 | 2025-12 | Other | Audi | SQ7 | Grey | Driving without Due Care and Attention | None | Greens End Road | Greens End Road | Coventry | Coventry | NFA | Out of Force | ||||
| 4819 | op-snap---monthly-publication-december-2025.pdf | 947 | 2025-12 | Other | Volkswagen | Caddy | Black | Misc - Non Traffic Offences | None | Greens End Road | Greens End Road | Coventry | Coventry | NFA | Out of Force | ||||
| 4895 | op-snap---monthly-publication-december-2025.pdf | 1023 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | No VRM | 52.4235908 | -1.5226276 | ||
| 4896 | op-snap---monthly-publication-december-2025.pdf | 1024 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4899 | op-snap---monthly-publication-december-2025.pdf | 1027 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4902 | op-snap---monthly-publication-december-2025.pdf | 1030 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4904 | op-snap---monthly-publication-december-2025.pdf | 1032 | 2025-12 | Car | Kia | Sportage | White | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No VRM | 52.4214017 | -1.4870278 | ||
| 4948 | op-snap---monthly-publication-december-2025.pdf | 1076 | 2025-12 | Car | Hyundai | I10 | White | Driving without Due Care and Attention | None | Croft Road Ringway | Croft Road Ringway | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | ||||
| 5005 | op-snap---monthly-publication-december-2025.pdf | 1133 | 2025-12 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | Charter Avenue | Charter Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3928409 | -1.5888076 | ||
| 5051 | op-snap---monthly-publication-december-2025.pdf | 1179 | 2025-12 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | A444 Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4214017 | -1.4870278 | ||
| 5081 | op-snap---monthly-publication-december-2025.pdf | 1209 | 2025-12 | Car | Peugeot | 3008.. | Black | Driving without Due Care and Attention | None | Stivichall Interchange | Stivichall, Coventry | Coventry | Coventry | NFA | No Offence | 52.3834202 | -1.5132278 | ||
| 5137 | op-snap---monthly-publication-december-2025.pdf | 1265 | 2025-12 | Car | Kia | Nero | Black | Driving without Due Care and Attention | None | A444 | A444 | Coventry | Coventry | NFA | Not in Public Interest | ||||
| 5182 | op-snap---monthly-publication-december-2025.pdf | 1310 | 2025-12 | Pedestrian | Ford | focus | Blue | Misc - Non Traffic Offences | None | thistley field | Thistley Field | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4271223 | -1.5298007 | ||
| 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 | ||||
| 20493 | op-snap---monthly-publication-november-2025.pdf | 35 | 2025-11 | Pedal Bike | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Bell Green Lane | Bell Green Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3995055 | -1.5349094 | ||
| 20525 | op-snap---monthly-publication-november-2025.pdf | 67 | 2025-11 | Car | BMW | X2 | Blue | Contravening a Red Traffic Light | None | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3793117 | -1.4625379 | ||
| 20581 | op-snap---monthly-publication-november-2025.pdf | 123 | 2025-11 | Other | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Gooch Street | Gooch Street | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 20653 | op-snap---monthly-publication-november-2025.pdf | 195 | 2025-11 | Car | Mercedes-Benz | cla | White | Misc - Non Traffic Offences | None | London Road | London Road | Coventry | Coventry | NFA | No Offence | 52.3916468 | -1.4925995 | ||
| 20659 | op-snap---monthly-publication-november-2025.pdf | 201 | 2025-11 | Car | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | None | Bell Green Road | Bell Green Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4324855 | -1.4815548 | ||
| 20699 | op-snap---monthly-publication-november-2025.pdf | 241 | 2025-11 | Pedestrian | London Taxi | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cheveral Avenue | Cheveral Avenue | Coventry | Coventry | NFA | Not in Public Interest | 52.4257402 | -1.5185037 | |||
| 20711 | op-snap---monthly-publication-november-2025.pdf | 253 | 2025-11 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No Offence | 52.396476 | -1.5561348 | ||
| 20721 | op-snap---monthly-publication-november-2025.pdf | 263 | 2025-11 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | No Insurance | Foleshll Island | Foleshll Island | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 21039 | op-snap---monthly-publication-november-2025.pdf | 581 | 2025-11 | Pedal Bike | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | none | binley road | Binley Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4070602 | -1.4732469 | ||
| 21090 | op-snap---monthly-publication-november-2025.pdf | 632 | 2025-11 | Pedestrian | Vauxhall | Zafira | Silver | Misc - Non Traffic Offences | None | St Elizabeth Rd | Street Elizabeth Road | Coventry | Coventry | NFA | No Offence | ||||
| 21124 | op-snap---monthly-publication-november-2025.pdf | 666 | 2025-11 | Pedal Bike | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | NFA | No VRM | 52.3988977 | -1.5323674 | |||||
| 21164 | op-snap---monthly-publication-november-2025.pdf | 706 | 2025-11 | Pedal Bike | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | Not in Public Interest | 52.4221152 | -1.4959475 | ||
| 21166 | op-snap---monthly-publication-november-2025.pdf | 708 | 2025-11 | Pedestrian | Renault | Megane | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21167 | op-snap---monthly-publication-november-2025.pdf | 709 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21169 | op-snap---monthly-publication-november-2025.pdf | 711 | 2025-11 | Pedestrian | Citroen | DS3 | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21170 | op-snap---monthly-publication-november-2025.pdf | 712 | 2025-11 | Pedestrian | Volkswagen | Passat | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21173 | op-snap---monthly-publication-november-2025.pdf | 715 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21174 | op-snap---monthly-publication-november-2025.pdf | 716 | 2025-11 | Pedestrian | Seat | Leon | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21175 | op-snap---monthly-publication-november-2025.pdf | 717 | 2025-11 | Pedestrian | Honda | Civic | Blue | Stop a vehicle on pedestrian crossing | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21176 | op-snap---monthly-publication-november-2025.pdf | 718 | 2025-11 | Pedestrian | Hyundai | Ionic | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21188 | op-snap---monthly-publication-november-2025.pdf | 730 | 2025-11 | Pedestrian | Ford | Ecosport | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mercia Gardens | Mercia Gardens | Coventry | Coventry | NFA | Not in Public Interest | 52.4284147 | -1.5049016 | ||
| 21189 | op-snap---monthly-publication-november-2025.pdf | 731 | 2025-11 | Pedestrian | BMW | 520d | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mercia Gardens | Mercia Gardens | Coventry | Coventry | NFA | Not in Public Interest | 52.4284147 | -1.5049016 | ||
| 21203 | op-snap---monthly-publication-november-2025.pdf | 745 | 2025-11 | Pedestrian | Mercedes-Benz | C220 | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21205 | op-snap---monthly-publication-november-2025.pdf | 747 | 2025-11 | Pedestrian | Honda | Jazz | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 |
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);