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'}
146 rows where council_area = "Coventry", disposal = "NFA" and month = "2025-04" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 24
offence 16
- Driving without Reasonable Consideration 65
- Contravening a Red Traffic Light 18
- Driving without Due Care and Attention 16
- Cause vehicle to be left in a dangerous position 13
- Stop a vehicle within pelican pedestrian crossing limits 9
- Using a Mobile Phone Whilst Driving 7
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 5
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
- Fail to Conform to Cycle Lane 2
- Misc - Non Traffic Offences 2
- Contravene Lane Closure Red X 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- No Insurance 1
- No vehicle excise licence 1
- Stop a vehicle on pedestrian crossing 1
reporter_transport_mode 7
- Pedal Bike 73
- Car 59
- Pedestrian 6
- Other 5
- Lorry 1
- Pedal Cycle 1
- Pedal cycle 1
month 1
- 2025-04 · 146 ✖
disposal 1
- NFA · 146 ✖
council_area 1
- Coventry · 146 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | op-snap---monthly-publication-april-2025.pdf | 8 | 2025-04 | Pedal Bike | Hyundai | I10 | Red | Driving without Reasonable Consideration | None | Evenlode Crescent | Evenlode Crescent | Coventry | Coventry | NFA | No Offence | 52.4190874 | -1.5373196 | ||
| 40 | op-snap---monthly-publication-april-2025.pdf | 39 | 2025-04 | Other | Mercedes-Benz | Sprinter | White | No Insurance | None | Sylvia Bird Close | Sylvia Bird Close | Coventry | Coventry | NFA | No Offence | 52.4021686 | -1.4662171 | ||
| 145 | op-snap---monthly-publication-april-2025.pdf | 144 | 2025-04 | Car | Vauxhall | Zafira | Silver | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4111289 | -1.5094345 | ||
| 150 | op-snap---monthly-publication-april-2025.pdf | 149 | 2025-04 | Pedal Bike | BMW | 318I | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Peel Street | Peel Street | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4220254 | -1.4950687 | ||
| 182 | op-snap---monthly-publication-april-2025.pdf | 181 | 2025-04 | Car | Hyundai | IX35 | White | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3833298 | -1.5379214 | ||
| 265 | op-snap---monthly-publication-april-2025.pdf | 264 | 2025-04 | Pedal Bike | Iveco | Daily | White | Driving without Reasonable Consideration | None | Torrington Avenue | Torrington Avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3987354 | -1.567693 | ||
| 290 | op-snap---monthly-publication-april-2025.pdf | 289 | 2025-04 | Car | Nissan | Qashqai | White | Driving without Due Care and Attention | None | Wyken Way Coventry | Wyken Way Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4209015 | -1.4789918 | ||
| 306 | op-snap---monthly-publication-april-2025.pdf | 305 | 2025-04 | Pedal Bike | Toyota | C - HR | Grey | Driving without Reasonable Consideration | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4214017 | -1.4870278 | ||
| 320 | op-snap---monthly-publication-april-2025.pdf | 319 | 2025-04 | Pedal Bike | Peugeot | 407.. | Black | Driving without Reasonable Consideration | None | Four Pounds Avenue | Four Pounds Avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.413228 | -1.5323652 | ||
| 322 | op-snap---monthly-publication-april-2025.pdf | 321 | 2025-04 | Pedal Bike | Nissan | Micra | Grey | Driving without Reasonable Consideration | None | Beechwood Avenue | Beechwood Avenue | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3960292 | -1.5340332 | ||
| 370 | op-snap---monthly-publication-april-2025.pdf | 369 | 2025-04 | Pedal Bike | Land Rover | Evogue | Black | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4275505 | -1.4448681 | ||
| 373 | op-snap---monthly-publication-april-2025.pdf | 372 | 2025-04 | Car | Ford | Ranger | Red | Driving without Due Care and Attention | None | M6/M42 | M6/M42 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4555561 | -1.4776118 | ||
| 394 | op-snap---monthly-publication-april-2025.pdf | 393 | 2025-04 | Pedal Bike | Mercedes-Benz | Vito | Red | Driving without Reasonable Consideration | None | Brandon Road | Brandon Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.399222 | -1.4414386 | ||
| 399 | op-snap---monthly-publication-april-2025.pdf | 398 | 2025-04 | Other | Mini | Cooper | Red | Driving without Due Care and Attention | None | Ashorne Close | Ashorne Close | Coventry | Coventry | NFA | No VRM | 52.4414338 | -1.465535 | ||
| 416 | op-snap---monthly-publication-april-2025.pdf | 415 | 2025-04 | Car | Volvo | V70 | Grey | Cause vehicle to be left in a dangerous position | None | Meriden Road | Meriden Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4233575 | -1.4380372 | ||
| 449 | op-snap---monthly-publication-april-2025.pdf | 448 | 2025-04 | Pedal Bike | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | none | Barras Lane | Barras Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4109877 | -1.5203488 | ||
| 450 | op-snap---monthly-publication-april-2025.pdf | 449 | 2025-04 | Pedal Bike | Mitsubishi | Colt | Blue | Fail to Conform to Cycle Lane | none | West Hill Road | West Hill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3994858 | -1.4923603 | ||
| 452 | op-snap---monthly-publication-april-2025.pdf | 451 | 2025-04 | Pedal Bike | Mini | Cooper | Blue | Driving without Reasonable Consideration | None | Stoneluiegh Rd | Stoneluiegh Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 453 | op-snap---monthly-publication-april-2025.pdf | 452 | 2025-04 | Pedal Bike | Land Rover | Discovery | Grey | Driving without Reasonable Consideration | None | Gibbet Hill Road | Gibbet Hill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3749141 | -1.5564977 | ||
| 455 | op-snap---monthly-publication-april-2025.pdf | 454 | 2025-04 | Pedal Bike | Volkswagen | Arteon | Red | Driving without Reasonable Consideration | None | Westwwod WAY | Westwwod WAY | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 489 | op-snap---monthly-publication-april-2025.pdf | 488 | 2025-04 | Pedal Bike | Peugeot | Partner | White | Driving without Reasonable Consideration | None | White Street | White Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4122951 | -1.5045181 | ||
| 514 | op-snap---monthly-publication-april-2025.pdf | 513 | 2025-04 | Pedal Bike | Volkswagen | Polo | Silver | Contravening a Red Traffic Light | None | Coundon Road | Coundon Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4125737 | -1.5215178 | ||
| 570 | op-snap---monthly-publication-april-2025.pdf | 569 | 2025-04 | Pedal Bike | Nissan | Note | Silver | Driving without Reasonable Consideration | None | Burnaby Road | Burnaby Road | Coventry | Coventry | NFA | No Offence | 52.4352 | -1.5194238 | ||
| 614 | op-snap---monthly-publication-april-2025.pdf | 613 | 2025-04 | Car | BMW | 116i | White | Cause vehicle to be left in a dangerous position | None | Heath Crst | Heath Crst | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 616 | op-snap---monthly-publication-april-2025.pdf | 615 | 2025-04 | Lorry | Scania | White | Driving without Due Care and Attention | None | New Union Street | New Union Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4048717 | -1.5098536 | |||
| 618 | op-snap---monthly-publication-april-2025.pdf | 617 | 2025-04 | Pedal Bike | Peugeot | 3008 | Red | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4134557 | -1.4442138 | ||
| 640 | op-snap---monthly-publication-april-2025.pdf | 639 | 2025-04 | Pedal Bike | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4221152 | -1.4959475 | ||
| 641 | op-snap---monthly-publication-april-2025.pdf | 640 | 2025-04 | Pedal Bike | Toyota | Corolla | Red | Driving without Reasonable Consideration | None | Church Lane | Church Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4202618 | -1.6010473 | ||
| 651 | op-snap---monthly-publication-april-2025.pdf | 650 | 2025-04 | Pedal Bike | BMW | 320d | Black | Driving without Reasonable Consideration | None | Church Lane | Church Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4202618 | -1.6010473 | ||
| 739 | op-snap---monthly-publication-april-2025.pdf | 738 | 2025-04 | Pedal Bike | Ford | Fiesta | Blue | Misc - Non Traffic Offences | None | Keris Way | Keris Way | Coventry | Coventry | NFA | Not in Public Interest | ||||
| 775 | op-snap---monthly-publication-april-2025.pdf | 774 | 2025-04 | Car | Toyota | Aygo | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4274335 | -1.5002381 | ||
| 787 | op-snap---monthly-publication-april-2025.pdf | 786 | 2025-04 | Pedal Bike | BMW | X1 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Barras Road | Barras Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4150239 | -1.4843313 | ||
| 788 | op-snap---monthly-publication-april-2025.pdf | 787 | 2025-04 | Pedal Bike | Mini | Cooper | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Barras Road | Barras Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4150239 | -1.4843313 | ||
| 790 | op-snap---monthly-publication-april-2025.pdf | 789 | 2025-04 | Pedal Bike | Ford | Transit | White | Contravening a Red Traffic Light | None | Kenilworth Road | Kenilworth Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3833298 | -1.5379214 | ||
| 791 | op-snap---monthly-publication-april-2025.pdf | 790 | 2025-04 | Pedal Bike | Volkswagen | Touran | Blue | Driving without Reasonable Consideration | None | Burnaby Road | Burnaby Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4352 | -1.5194238 | ||
| 793 | op-snap---monthly-publication-april-2025.pdf | 792 | 2025-04 | Pedal Bike | Renault | Captur | Grey | Misc - Non Traffic Offences | None | Scots Lane | Scots Lane | Coventry | Coventry | NFA | No Offence | 52.4234754 | -1.5328595 | ||
| 794 | op-snap---monthly-publication-april-2025.pdf | 793 | 2025-04 | Pedal Bike | Mg | HS | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tile House Lane | Tile House Lane | Coventry | Coventry | NFA | No Offence | ||||
| 824 | op-snap---monthly-publication-april-2025.pdf | 823 | 2025-04 | Car | Volkswagen | Passat | Silver | Driving without Reasonable Consideration | none | Stoney Stanton Road , Coventry | Stoney Stanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | ||
| 825 | op-snap---monthly-publication-april-2025.pdf | 824 | 2025-04 | Pedal Bike | Mercedes-Benz | Benz | Silver | Driving without Reasonable Consideration | none | Britton Road , Coventry | Britton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 827 | op-snap---monthly-publication-april-2025.pdf | 826 | 2025-04 | Pedal Bike | Volkswagen | White | Driving without Reasonable Consideration | none | Woodway Lane , Coventry | Woodway Lane , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4292329 | -1.447102 | |||
| 829 | op-snap---monthly-publication-april-2025.pdf | 828 | 2025-04 | Pedal Bike | Vauxhall | Black | Driving without Due Care and Attention | None | Stoney Stanton Junction , Coventry | Stoney Stanton Junction , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | |||||
| 837 | op-snap---monthly-publication-april-2025.pdf | 836 | 2025-04 | Car | Mercedes-Benz | Benz | White | Contravening a Red Traffic Light | None | Thorns Road , Dudley | Thorns Road , Dudley | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 855 | op-snap---monthly-publication-april-2025.pdf | 854 | 2025-04 | Car | Toyota | Auris | Grey | Driving without Reasonable Consideration | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4111289 | -1.5094345 | ||
| 871 | op-snap---monthly-publication-april-2025.pdf | 870 | 2025-04 | Pedal Bike | Ford | White | Driving without Reasonable Consideration | None | Kingfield Road , Coventry | Kingfield Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.42556 | -1.508101 | |||
| 887 | op-snap---monthly-publication-april-2025.pdf | 886 | 2025-04 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Bagington Road , Coventry | Bagington Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 896 | op-snap---monthly-publication-april-2025.pdf | 895 | 2025-04 | Car | Mercedes-Benz | White | Driving without Reasonable Consideration | None | Gosford Street , Coventry | Gosford Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4068712 | -1.4994695 | |||
| 903 | op-snap---monthly-publication-april-2025.pdf | 902 | 2025-04 | Pedal Bike | Ford | Van | White | Driving without Reasonable Consideration | None | Wilenhall Lane , Coventry | Wilenhall Lane , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 905 | op-snap---monthly-publication-april-2025.pdf | 904 | 2025-04 | Pedal Bike | Kia | Black | Driving without Reasonable Consideration | None | Willenhall Lane , Coventry | Willenhall Lane , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3983962 | -1.4423958 | |||
| 908 | op-snap---monthly-publication-april-2025.pdf | 907 | 2025-04 | Pedal cycle | Land Rover | Black | Driving without Reasonable Consideration | None | Ansty Road , Coventry | Ansty Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4151549 | -1.4663195 | |||
| 911 | op-snap---monthly-publication-april-2025.pdf | 910 | 2025-04 | Pedal Cycle | Audi | White | Using a Mobile Phone Whilst Driving | None | Walsgrave Road , Coventry | Walsgrave Road , Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | 52.410402 | -1.4847441 | |||
| 912 | op-snap---monthly-publication-april-2025.pdf | 911 | 2025-04 | Car | Peugeot | Beige | Driving without Reasonable Consideration | None | A4053 , Coventry | A4053 , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4031346 | -1.5096565 | |||
| 946 | op-snap---monthly-publication-april-2025.pdf | 945 | 2025-04 | Car | Toyota | Yaris | Blue | Driving without Reasonable Consideration | None | Earlsdon Avenue , Coventry | Earlsdon Avenue , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.398248 | -1.528263 | ||
| 949 | op-snap---monthly-publication-april-2025.pdf | 948 | 2025-04 | Pedal Bike | Toyota | Silver | Driving without Reasonable Consideration | None | Sherbourne Street , Coventry | Sherbourne Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4080688 | -1.5236936 | |||
| 963 | op-snap---monthly-publication-april-2025.pdf | 962 | 2025-04 | Car | Ford | Black | Contravening a Red Traffic Light | None | A45 , Coventry | A45 , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3772596 | -1.4884352 | |||
| 981 | op-snap---monthly-publication-april-2025.pdf | 980 | 2025-04 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Reasonable Consideration | None | Gibbet Hill Road , Kennilworth | Gibbet Hill Road , Kennilworth | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 983 | op-snap---monthly-publication-april-2025.pdf | 982 | 2025-04 | Car | Volkswagen | Touran | Black | Contravening a Red Traffic Light | None | Slade Road , Birmingham | Slade Road , Birmingham | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 989 | op-snap---monthly-publication-april-2025.pdf | 988 | 2025-04 | Car | Seat | Grey | Cause vehicle to be left in a dangerous position | None | Halford Lane , Coventry | Halford Lane , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4398231 | -1.526811 | |||
| 1016 | op-snap---monthly-publication-april-2025.pdf | 1015 | 2025-04 | Pedal Bike | Ford | Silver | Driving without Reasonable Consideration | None | Bell Green Road , Coventry | Bell Green Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4324855 | -1.4815548 | |||
| 1019 | op-snap---monthly-publication-april-2025.pdf | 1018 | 2025-04 | Pedal Bike | Audi | A6 | Silver | Cause vehicle to be left in a dangerous position | None | Stoney STanton Road , Coventry | Stoney STanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | ||
| 1021 | op-snap---monthly-publication-april-2025.pdf | 1020 | 2025-04 | Pedal Bike | Volkswagen | Golf | Grey | Cause vehicle to be left in a dangerous position | None | Stoney STanton Road , Coventry | Stoney STanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | ||
| 1022 | op-snap---monthly-publication-april-2025.pdf | 1021 | 2025-04 | Pedal Bike | Suzuki | Hatch | White | Cause vehicle to be left in a dangerous position | None | Briton Road , Coventry | Briton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.412783 | -1.480642 | ||
| 1023 | op-snap---monthly-publication-april-2025.pdf | 1022 | 2025-04 | Pedal Bike | Audi | Hatch | Blue | Driving without Reasonable Consideration | None | Farren Road , Coventry | Farren Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4198079 | -1.4513872 | ||
| 1026 | op-snap---monthly-publication-april-2025.pdf | 1025 | 2025-04 | Car | Ford | Blue | Driving without Reasonable Consideration | None | White Street , Coventry | White Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4122951 | -1.5045181 | |||
| 1029 | op-snap---monthly-publication-april-2025.pdf | 1028 | 2025-04 | Car | Citroen | C3 | Blue | Contravening a Red Traffic Light | None | Blue Ribbon Roundabout , Coventry | Blue Ribbon Roundabout , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 1035 | op-snap---monthly-publication-april-2025.pdf | 1034 | 2025-04 | Pedestrian | Volkswagen | Golf | white | Driving without Reasonable Consideration | none | Sherbourne Street , Coventry | Sherbourne Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4080688 | -1.5236936 | ||
| 1038 | op-snap---monthly-publication-april-2025.pdf | 1037 | 2025-04 | Car | Volkswagen | Grey or | Silver | Driving without Reasonable Consideration | None | B4113 | B4113 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4514773 | -1.4856758 | ||
| 1048 | op-snap---monthly-publication-april-2025.pdf | 1047 | 2025-04 | Car | Unknown | Silver | Cause vehicle to be left in a dangerous position | None | Stoney stanton Road , Coventry | Stoney stanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | |||
| 1062 | op-snap---monthly-publication-april-2025.pdf | 1061 | 2025-04 | Pedal Bike | Mercedes-Benz | White | Driving without Reasonable Consideration | None | Four Pounds Avenue , Coventry | Four Pounds Avenue , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4098559 | -1.5354583 | |||
| 1076 | op-snap---monthly-publication-april-2025.pdf | 1075 | 2025-04 | Car | Mercedes-Benz | Turbo | Black | Driving without Reasonable Consideration | None | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||||
| 1118 | op-snap---monthly-publication-april-2025.pdf | 1117 | 2025-04 | Pedestrian | Volkswagen | Black | Driving without Reasonable Consideration | None | Stoney STanton Road , Coventry | Stoney STanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | |||
| 1119 | op-snap---monthly-publication-april-2025.pdf | 1118 | 2025-04 | Pedestrian | Tesla | White | Cause vehicle to be left in a dangerous position | None | Grange Road , Dorridge | Grange Road , Dorridge | Coventry | Coventry | NFA | No Independent Evidence Available | |||||
| 1154 | op-snap---monthly-publication-april-2025.pdf | 1153 | 2025-04 | Car | Volvo | Blue | Driving without Reasonable Consideration | None | Duggins Lane , |Coventry | Duggins Lane , |Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3964189 | -1.5989088 | |||
| 1156 | op-snap---monthly-publication-april-2025.pdf | 1155 | 2025-04 | Car | Ford | Fiesta | White | Driving without Reasonable Consideration | None | Wolfe Road , Coventry | Wolfe Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.395482 | -1.575749 | ||
| 1157 | op-snap---monthly-publication-april-2025.pdf | 1156 | 2025-04 | Pedestrian | Mercedes-Benz | Silver | Cause vehicle to be left in a dangerous position | None | Coventry | Coventry | NFA | Outside of 14 Days NIP | |||||||
| 1175 | op-snap---monthly-publication-april-2025.pdf | 1174 | 2025-04 | Other | LDV | White | Driving without Reasonable Consideration | None | Cherry Tree Drive , Coventry | Cherry Tree Drive , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3966872 | -1.5595887 | |||
| 1181 | op-snap---monthly-publication-april-2025.pdf | 1180 | 2025-04 | Car | Mini | Black | Driving without Reasonable Consideration | None | Wolfe Road . Coventry | Wolfe Road . Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.395482 | -1.575749 | |||
| 1182 | op-snap---monthly-publication-april-2025.pdf | 1181 | 2025-04 | Car | Daf | Van | White | Driving without Reasonable Consideration | None | Styvechalke Roundabout , Coventry | Styvechalke Roundabout , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 1197 | op-snap---monthly-publication-april-2025.pdf | 1196 | 2025-04 | Car | Seat | Leon | White | Driving without Reasonable Consideration | None | Belgrave Road , Coventry | Belgrave Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4141017 | -1.4571973 | ||
| 1210 | op-snap---monthly-publication-april-2025.pdf | 1209 | 2025-04 | Car | Audi | A6 | Black | Driving without Reasonable Consideration | None | A45 towards Coventry | A45 towards Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 1213 | op-snap---monthly-publication-april-2025.pdf | 1212 | 2025-04 | Pedal Bike | Audi | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road , Coventry | Bell Green Road , Coventry | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4324855 | -1.4815548 | |||
| 1215 | op-snap---monthly-publication-april-2025.pdf | 1214 | 2025-04 | Pedal Bike | Volkswagen | Hatch | Black | Driving without Reasonable Consideration | None | Henley Road , Coventry | Henley Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4307281 | -1.462755 | ||
| 1216 | op-snap---monthly-publication-april-2025.pdf | 1215 | 2025-04 | Pedal Bike | Mercedes-Benz | Blue | Driving without Reasonable Consideration | None | Henley Road , Coventry | Henley Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4307281 | -1.462755 | |||
| 1225 | op-snap---monthly-publication-april-2025.pdf | 1224 | 2025-04 | Pedal Bike | Mercedes-Benz | GLC | Black | Driving without Reasonable Consideration | None | Lockhurst Lane , Coventry | Lockhurst Lane , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4279593 | -1.5028098 | ||
| 1235 | op-snap---monthly-publication-april-2025.pdf | 1234 | 2025-04 | Pedal Bike | Seat | Black | Driving without Reasonable Consideration | None | Allesley Old Road , Coventry | Allesley Old Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4132318 | -1.5494767 | |||
| 1280 | op-snap---monthly-publication-april-2025.pdf | 1279 | 2025-04 | Car | Vauxhall | Black | Driving without Due Care and Attention | None | Brade Drive | Brade Drive | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4299822 | -1.4378089 | |||
| 1284 | op-snap---monthly-publication-april-2025.pdf | 1283 | 2025-04 | Pedal Bike | Land Rover | Land rover | Silver | Contravening a Red Traffic Light | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4071231 | -1.4985178 | ||
| 1285 | op-snap---monthly-publication-april-2025.pdf | 1284 | 2025-04 | Pedal Bike | Ford | FIESTA | Black | Contravening a Red Traffic Light | None | Bell green road | Bell green road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4324855 | -1.4815548 | ||
| 1287 | op-snap---monthly-publication-april-2025.pdf | 1286 | 2025-04 | Pedal Bike | Suzuki | NP | GREY | Contravening a Red Traffic Light | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4274335 | -1.5002381 | ||
| 1292 | op-snap---monthly-publication-april-2025.pdf | 1291 | 2025-04 | Pedestrian | Renault | NP | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Earlsdon avenue south | Earlsdon avenue south | Coventry | Coventry | NFA | Not in Public Interest | 52.3960991 | -1.5255671 | ||
| 1293 | op-snap---monthly-publication-april-2025.pdf | 1292 | 2025-04 | Pedal Bike | BMW | NP | Black | Contravening a Red Traffic Light | None | Bell green road | Bell green road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4324855 | -1.4815548 | ||
| 1302 | op-snap---monthly-publication-april-2025.pdf | 1301 | 2025-04 | Car | Renault | CLIO | Black | Contravening a Red Traffic Light | None | Moseley Avenue road | Moseley Avenue road | Coventry | Coventry | NFA | No Offence | 52.4144961 | -1.5337013 | ||
| 1303 | op-snap---monthly-publication-april-2025.pdf | 1302 | 2025-04 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Moseley Avenue Road | Moseley Avenue Road | Coventry | Coventry | NFA | No Offence | 52.4144961 | -1.5337013 | ||
| 1304 | op-snap---monthly-publication-april-2025.pdf | 1303 | 2025-04 | Car | Ford | Fiesta | Silver | Contravene Lane Closure Red X | None | Moseley Avenue road | Moseley Avenue road | Coventry | Coventry | NFA | No Offence | 52.4144961 | -1.5337013 | ||
| 1306 | op-snap---monthly-publication-april-2025.pdf | 1305 | 2025-04 | Car | Toyota | YARIS | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | Coventry well street | Coventry well street | Coventry | Coventry | NFA | Not in Public Interest | 52.4109668 | -1.5140051 | ||
| 1330 | op-snap---monthly-publication-april-2025.pdf | 1329 | 2025-04 | Car | NP | Red | Driving without Due Care and Attention | None | Hipswell Highway | Hipswell Highway | Coventry | Coventry | NFA | outside of 14 Days NIP | 52.4119456 | -1.4589896 | |||
| 1343 | op-snap---monthly-publication-april-2025.pdf | 1342 | 2025-04 | Pedal Bike | Peugeot | Silver | Driving without Reasonable Consideration | None | Stoney Stanton Road , Coventry | Stoney Stanton Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4295082 | -1.4871963 | |||
| 1370 | op-snap---monthly-publication-april-2025.pdf | 1369 | 2025-04 | Pedal Bike | Ford | Transit | Green | Using a Mobile Phone Whilst Driving | None | bell green toad, A444 roundabout | bell green toad, A444 roundabout | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 1371 | op-snap---monthly-publication-april-2025.pdf | 1370 | 2025-04 | Pedal Bike | Mercedes-Benz | NP | Black | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4221152 | -1.4959475 | ||
| 1393 | op-snap---monthly-publication-april-2025.pdf | 1392 | 2025-04 | Pedal Bike | Peugeot | Partner | Black | Driving without Due Care and Attention | None | White street at the junction with Bird street | White street at the junction with Bird street | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4122951 | -1.5045181 | ||
| 1394 | op-snap---monthly-publication-april-2025.pdf | 1393 | 2025-04 | Pedal Bike | BMW | X6 | Black | Driving without Due Care and Attention | None | Vecqueray street , coventry | Vecqueray street , coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4066697 | -1.4969077 |
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);