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'}
121 rows where council_area = "Coventry", disposal = "Fixed Penalty" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, witness_contacted
vehicle_make 26
month 14
offence 12
- Using a Mobile Phone Whilst Driving 33
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 21
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 16
- Stop a vehicle within pelican pedestrian crossing limits 16
- Cause vehicle to be left in a dangerous position 12
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 7
- Stop a vehicle on pedestrian crossing 6
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- Contravening a Red Traffic Light 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
reporter_transport_mode 1
- Pedestrian · 121 ✖
disposal 1
- Fixed Penalty · 121 ✖
council_area 1
- Coventry · 121 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7526 | op-snap---monthly-publication-february-2026.pdf | 273 | 2026-02 | Pedestrian | Mazda | 2 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Drapers Fields | Drapers Fields | Coventry | Coventry | Fixed Penalty | N/A | 52.4144091 | -1.5109203 | ||
| 7671 | op-snap---monthly-publication-february-2026.pdf | 418 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Drapers Fields | Drapers Fields | Coventry | Coventry | Fixed Penalty | N/A | 52.4144091 | -1.5109203 | ||
| 7672 | op-snap---monthly-publication-february-2026.pdf | 419 | 2026-02 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Drapers Fields | Drapers Fields | Coventry | Coventry | Fixed Penalty | N/A | 52.4144091 | -1.5109203 | ||
| 7708 | op-snap---monthly-publication-february-2026.pdf | 455 | 2026-02 | Pedestrian | Peugeot | 3008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Maidavale Crescent | Maidavale Crescent | Coventry | Coventry | Fixed Penalty | N/A | 52.3802609 | -1.5140687 | ||
| 7826 | op-snap---monthly-publication-february-2026.pdf | 573 | 2026-02 | Pedestrian | Nissan | Qashqai | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Halford Lane at Burnaby Road | Halford Lane at Burnaby Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4398231 | -1.526811 | ||
| 7853 | op-snap---monthly-publication-february-2026.pdf | 600 | 2026-02 | Pedestrian | Ford | focus | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Halford Lane | Halford Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4398231 | -1.526811 | ||
| 8145 | op-snap---monthly-publication-february-2026.pdf | 892 | 2026-02 | Pedestrian | Citroen | C4X | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Green Lane | Green Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.38188 | -1.5300381 | ||
| 8335 | op-snap---monthly-publication-february-2026.pdf | 1082 | 2026-02 | Pedestrian | BMW | 320d | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lentons Lane | Lentons Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4503238 | -1.4546397 | ||
| 8347 | op-snap---monthly-publication-february-2026.pdf | 1094 | 2026-02 | Pedestrian | Kia | Ceed 2 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Drapers Fields | Drapers Fields | Coventry | Coventry | Fixed Penalty | N/A | 52.4144091 | -1.5109203 | ||
| 10826 | op-snap---monthly-publication-january-2026.pdf | 287 | 2026-01 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coombe Park Road | Coombe Park Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4065551 | -1.4426433 | ||
| 10878 | op-snap---monthly-publication-january-2026.pdf | 339 | 2026-01 | Pedestrian | Ford | Focus | Grey | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 10956 | op-snap---monthly-publication-january-2026.pdf | 417 | 2026-01 | Pedestrian | Ford | Transit | white | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lentons Lane | Lentons Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4503238 | -1.4546397 | ||
| 10996 | op-snap---monthly-publication-january-2026.pdf | 457 | 2026-01 | Pedestrian | Ford | Kuga | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Valley Road | Valley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4232784 | -1.4819114 | ||
| 11126 | op-snap---monthly-publication-january-2026.pdf | 587 | 2026-01 | Pedestrian | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Halford Lane | Halford Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4398231 | -1.526811 | ||
| 4114 | op-snap---monthly-publication-december-2025.pdf | 242 | 2025-12 | Pedestrian | Audi | Q3 | Black | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Langbank Avenue | Langbank Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3903106 | -1.4556064 | ||
| 20683 | op-snap---monthly-publication-november-2025.pdf | 225 | 2025-11 | Pedestrian | Nissan | Note | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21566 | op-snap---monthly-publication-november-2025.pdf | 1108 | 2025-11 | Pedestrian | Kia | Sportage | Blue | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4096725 | -1.487901 | ||
| 22273 | op-snap---monthly-publication-october-2025.pdf | 223 | 2025-10 | Pedestrian | BMW | 320.. | Beige | Using a Mobile Phone Whilst Driving | None | Bishop Street | Bishop Street | Coventry | Coventry | Fixed Penalty | N/A | 52.411051 | -1.5111644 | ||
| 24073 | op-snap---monthly-publication-september-2025.pdf | 292 | 2025-09 | Pedestrian | Fiat | Doblo | White | Using a Mobile Phone Whilst Driving | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4103629 | -1.5441218 | ||
| 24801 | op-snap---monthly-publication-september-2025.pdf | 1020 | 2025-09 | Pedestrian | Audi | Q5 | White | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4070602 | -1.4732469 | ||
| 2122 | op-snap---monthly-publication-august-2025.pdf | 97 | 2025-08 | Pedestrian | Renault | Scenic | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gulson Road | Gulson Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4076795 | -1.4911676 | ||
| 2481 | op-snap---monthly-publication-august-2025.pdf | 456 | 2025-08 | Pedestrian | Renault | Traffic | White | Using a Mobile Phone Whilst Driving | None | Radford Road | Radford Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4235908 | -1.5226276 | ||
| 12058 | op-snap---monthly-publication-july-2025.pdf | 110 | 2025-07 | Pedestrian | Seat | Leon | White | Using a Mobile Phone Whilst Driving | None | A46 | A46 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 14569 | op-snap---monthly-publication-june-2025.pdf | 498 | 2025-06 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14570 | op-snap---monthly-publication-june-2025.pdf | 499 | 2025-06 | Pedestrian | Land Rover | Defednder | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14625 | op-snap---monthly-publication-june-2025.pdf | 554 | 2025-06 | Pedestrian | Land Rover | Range Rover | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 15966 | op-snap---monthly-publication-june-2025.pdf | 1895 | 2025-06 | Pedestrian | Nissan | Qashqai | Red | Stop a vehicle on pedestrian crossing | None | Albany Road | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4006218 | -1.5284125 | ||
| 18802 | op-snap---monthly-publication-may-2025.pdf | 164 | 2025-05 | Pedestrian | Lexus | 300 H | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 19320 | op-snap---monthly-publication-may-2025.pdf | 682 | 2025-05 | Pedestrian | Audi | A6 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Bigginhall Crescent | Bigginhall Crescent | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 331 | op-snap---monthly-publication-april-2025.pdf | 330 | 2025-04 | Pedestrian | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 612 | op-snap---monthly-publication-april-2025.pdf | 611 | 2025-04 | Pedestrian | Ford | Focus | White | Cause vehicle to be left in a dangerous position | None | Ulverscroft Road | Ulverscroft Road | Coventry | Coventry | Fixed Penalty | N/A | 52.3913543 | -1.508629 | ||
| 695 | op-snap---monthly-publication-april-2025.pdf | 694 | 2025-04 | Pedestrian | Volkswagen | Pssat | Blue | Stop a vehicle on pedestrian crossing | None | Parkgate Rd | Parkgate Road | Coventry | Coventry | Fixed Penalty | N/A | 52.445796 | -1.5148141 | ||
| 696 | op-snap---monthly-publication-april-2025.pdf | 695 | 2025-04 | Pedestrian | Volkswagen | ID3 | Blue | Using a Mobile Phone Whilst Driving | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Fixed Penalty | N/A | 52.396476 | -1.5561348 | ||
| 769 | op-snap---monthly-publication-april-2025.pdf | 768 | 2025-04 | Pedestrian | Tivoli | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | |||
| 832 | op-snap---monthly-publication-april-2025.pdf | 831 | 2025-04 | Pedestrian | Mercedes-Benz | C300 | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 1069 | op-snap---monthly-publication-april-2025.pdf | 1068 | 2025-04 | Pedestrian | Volkswagen | Black | Using a Mobile Phone Whilst Driving | None | Woodway Lane , Coventry | Woodway Lane , Coventry | Coventry | Coventry | Fixed Penalty | N/A | 52.4292329 | -1.447102 | |||
| 16337 | op-snap---monthly-publication-march-2025.pdf | 94 | 2025-03 | Pedestrian | Ford | transoit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grayswood Avenue | Grayswood Avenue | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4174998 | -1.5458389 | |
| 16413 | op-snap---monthly-publication-march-2025.pdf | 170 | 2025-03 | Pedestrian | Porsche | Cayenne | Black | Stop a vehicle on pedestrian crossing | None | Albany Road | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4006218 | -1.5284125 | |
| 16435 | op-snap---monthly-publication-march-2025.pdf | 192 | 2025-03 | Pedestrian | Vauxhall | Astra | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Middlemarch Road | Middlemarch Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4316434 | -1.5142862 | |
| 16436 | op-snap---monthly-publication-march-2025.pdf | 193 | 2025-03 | Pedestrian | BMW | 1series | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Middlemarch Road | Middlemarch Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4316434 | -1.5142862 | |
| 16437 | op-snap---monthly-publication-march-2025.pdf | 194 | 2025-03 | Pedestrian | Volkswagen | Tiguan | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Middlemarch Road | Middlemarch Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4316434 | -1.5142862 | |
| 16442 | op-snap---monthly-publication-march-2025.pdf | 199 | 2025-03 | Pedestrian | Honda | Civic | Black | Cause vehicle to be left in a dangerous position | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 16443 | op-snap---monthly-publication-march-2025.pdf | 200 | 2025-03 | Pedestrian | BMW | 520 | Silver | Cause vehicle to be left in a dangerous position | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 16450 | op-snap---monthly-publication-march-2025.pdf | 207 | 2025-03 | Pedestrian | Citroen | DS5 | White | Cause vehicle to be left in a dangerous position | None | Ulverscroft Road | Ulverscroft Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3913543 | -1.508629 | |
| 16522 | op-snap---monthly-publication-march-2025.pdf | 279 | 2025-03 | Pedestrian | Peugeot | 208 | White | Contravening a Red Traffic Light | None | A46 Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3793117 | -1.4625379 | |
| 16733 | op-snap---monthly-publication-march-2025.pdf | 490 | 2025-03 | Pedestrian | Nissan | Qashqai | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street Coventry | Earlsdon Street Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 16766 | op-snap---monthly-publication-march-2025.pdf | 523 | 2025-03 | Pedestrian | BMW | 520d | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 17017 | op-snap---monthly-publication-march-2025.pdf | 774 | 2025-03 | Pedestrian | Peugeot | 2008 | Black | Cause vehicle to be left in a dangerous position | None | Parkgate Road | Parkgate Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.445796 | -1.5148141 | |
| 17131 | op-snap---monthly-publication-march-2025.pdf | 888 | 2025-03 | Pedestrian | Ford | S Max | Grey | Cause vehicle to be left in a dangerous position | None | Brookside Avenue | Brookside Avenue | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.411064 | -1.5578725 | |
| 17198 | op-snap---monthly-publication-march-2025.pdf | 955 | 2025-03 | Pedestrian | Mercedes-Benz | A180 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Rd | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17201 | op-snap---monthly-publication-march-2025.pdf | 958 | 2025-03 | Pedestrian | Toyota | Purple | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Rd | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | ||
| 17205 | op-snap---monthly-publication-march-2025.pdf | 962 | 2025-03 | Pedestrian | Volkswagen | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | foleshill Rd | foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | ||
| 17455 | op-snap---monthly-publication-march-2025.pdf | 1212 | 2025-03 | Pedestrian | Ford | Fiesta | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Albany Road | Albany Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4006218 | -1.5284125 | |
| 17545 | op-snap---monthly-publication-march-2025.pdf | 1302 | 2025-03 | Pedestrian | Hyundai | I10 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 17792 | op-snap---monthly-publication-march-2025.pdf | 1549 | 2025-03 | Pedestrian | Audi | Q5 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Foleshill Road/ Arbury Avenue | Foleshill Road/ Arbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4253508 | -1.5018457 | |
| 17824 | op-snap---monthly-publication-march-2025.pdf | 1581 | 2025-03 | Pedestrian | Ford | Transit | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17826 | op-snap---monthly-publication-march-2025.pdf | 1583 | 2025-03 | Pedestrian | Peugeot | 5008 | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17827 | op-snap---monthly-publication-march-2025.pdf | 1584 | 2025-03 | Pedestrian | Volkswagen | Caddy | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17829 | op-snap---monthly-publication-march-2025.pdf | 1586 | 2025-03 | Pedestrian | Seat | Arona | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17831 | op-snap---monthly-publication-march-2025.pdf | 1588 | 2025-03 | Pedestrian | Seat | Leon | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17833 | op-snap---monthly-publication-march-2025.pdf | 1590 | 2025-03 | Pedestrian | Toyota | Avensis | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17834 | op-snap---monthly-publication-march-2025.pdf | 1591 | 2025-03 | Pedestrian | BMW | 1 series | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17836 | op-snap---monthly-publication-march-2025.pdf | 1593 | 2025-03 | Pedestrian | Toyota | Prius | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17837 | op-snap---monthly-publication-march-2025.pdf | 1594 | 2025-03 | Pedestrian | Honda | S2000 | 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 | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17838 | op-snap---monthly-publication-march-2025.pdf | 1595 | 2025-03 | Pedestrian | Vauxhall | Insignia | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 17840 | op-snap---monthly-publication-march-2025.pdf | 1597 | 2025-03 | Pedestrian | Dacia | Sandera | White | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4096725 | -1.487901 | |
| 17861 | op-snap---monthly-publication-march-2025.pdf | 1618 | 2025-03 | Pedestrian | Kia | Picanto | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 17896 | op-snap---monthly-publication-march-2025.pdf | 1653 | 2025-03 | Pedestrian | Dacia | Jogger | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 17897 | op-snap---monthly-publication-march-2025.pdf | 1654 | 2025-03 | Pedestrian | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 17898 | op-snap---monthly-publication-march-2025.pdf | 1655 | 2025-03 | Pedestrian | Volvo | S80 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 17899 | op-snap---monthly-publication-march-2025.pdf | 1656 | 2025-03 | Pedestrian | Mercedes-Benz | CLA 200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Foster Road | Foster Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.42785 | -1.5190909 | |
| 18008 | op-snap---monthly-publication-march-2025.pdf | 1765 | 2025-03 | Pedestrian | Toyota | RAV4 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 18010 | op-snap---monthly-publication-march-2025.pdf | 1767 | 2025-03 | Pedestrian | Peugeot | 208 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 18158 | op-snap---monthly-publication-march-2025.pdf | 1915 | 2025-03 | Pedestrian | Porsche | Macan | Brown | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 18162 | op-snap---monthly-publication-march-2025.pdf | 1919 | 2025-03 | Pedestrian | Skoda | Fabia | Blue | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 18268 | op-snap---monthly-publication-march-2025.pdf | 2025 | 2025-03 | Pedestrian | Citroen | C1 | Grey | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 18271 | op-snap---monthly-publication-march-2025.pdf | 2028 | 2025-03 | Pedestrian | Audi | A3 | Black | Using a Mobile Phone Whilst Driving | None | Woodway Lane | Woodway Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4275505 | -1.4448681 | |
| 18364 | op-snap---monthly-publication-march-2025.pdf | 2121 | 2025-03 | Pedestrian | Mitsubishi | ASX | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coundon Drive | Coundon Drive | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4211945 | -1.5552333 | |
| 18426 | op-snap---monthly-publication-march-2025.pdf | 2183 | 2025-03 | Pedestrian | Jaguar | XF... | Green | Using a Mobile Phone Whilst Driving | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 5183 | op-snap---monthly-publication-february-2025.pdf | 0 | 2025-02 | Pedestrian | Volkswagen | AMAROK | Grey | Cause vehicle to be left in a dangerous position | None | WASTE LANE | Waste Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.437361 | -1.5371291 | |
| 5273 | op-snap---monthly-publication-february-2025.pdf | 90 | 2025-02 | Pedestrian | Honda | Civic | Blue | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 5488 | op-snap---monthly-publication-february-2025.pdf | 305 | 2025-02 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 5775 | op-snap---monthly-publication-february-2025.pdf | 592 | 2025-02 | Pedestrian | Suzuki | SX4 | Silver | Cause vehicle to be left in a dangerous position | None | Coat of Arms Bridge Road Cov | Coat of Arms Bridge Road Cov | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3881147 | -1.5283476 | |
| 5777 | op-snap---monthly-publication-february-2025.pdf | 594 | 2025-02 | Pedestrian | Volkswagen | Golf | Silver | Cause vehicle to be left in a dangerous position | None | Dewsbury Avenue Coventry | Dewsbury Avenue Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5836 | op-snap---monthly-publication-february-2025.pdf | 653 | 2025-02 | Pedestrian | BMW | X6 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Avenue, Coventry | Earlsdon Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.398248 | -1.528263 | |
| 5837 | op-snap---monthly-publication-february-2025.pdf | 654 | 2025-02 | Pedestrian | Peugeot | 206 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Avenue, Coventry | Earlsdon Avenue, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.398248 | -1.528263 | |
| 5843 | op-snap---monthly-publication-february-2025.pdf | 660 | 2025-02 | Pedestrian | Van | White | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | ||
| 5855 | op-snap---monthly-publication-february-2025.pdf | 672 | 2025-02 | Pedestrian | BMW | X1 | Grey | Cause vehicle to be left in a dangerous position | None | Coat of Arms Bridge Road | Coat of Arms Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3887077 | -1.5308677 | |
| 6006 | op-snap---monthly-publication-february-2025.pdf | 823 | 2025-02 | Pedestrian | Volkswagen | XC90 | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road Coventry | Bell Green Road Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4361538 | -1.4756447 | |
| 6008 | op-snap---monthly-publication-february-2025.pdf | 825 | 2025-02 | Pedestrian | Seat | Arona | White | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 6011 | op-snap---monthly-publication-february-2025.pdf | 828 | 2025-02 | Pedestrian | Ford | Transit | Silver | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4324855 | -1.4815548 | |
| 6048 | op-snap---monthly-publication-february-2025.pdf | 865 | 2025-02 | Pedestrian | Peugeot | 2008 | Grey | Using a Mobile Phone Whilst Driving | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4103629 | -1.5441218 | |
| 6073 | op-snap---monthly-publication-february-2025.pdf | 890 | 2025-02 | Pedestrian | Nissan | Qashqai | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Catesby Road | Catesby Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4346221 | -1.5163727 | |
| 6075 | op-snap---monthly-publication-february-2025.pdf | 892 | 2025-02 | Pedestrian | Mercedes-Benz | C300 | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Catesby Road | Catesby Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4346221 | -1.5163727 | |
| 6147 | op-snap---monthly-publication-february-2025.pdf | 964 | 2025-02 | Pedestrian | Jaguar | F PACE | Black | Stop a vehicle within pelican pedestrian crossing limits | None | EARLSDON STREET | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 6149 | op-snap---monthly-publication-february-2025.pdf | 966 | 2025-02 | Pedestrian | Nissan | QASHQUI | Black | Stop a vehicle within pelican pedestrian crossing limits | None | EARLSDON STREET | Earlsdon Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 6236 | op-snap---monthly-publication-february-2025.pdf | 1053 | 2025-02 | Pedestrian | Mercedes-Benz | 250 AMG | Black | Using a Mobile Phone Whilst Driving | None | Allesley Road | Allesley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.412663 | -1.5443742 | |
| 6365 | op-snap---monthly-publication-february-2025.pdf | 1182 | 2025-02 | Pedestrian | Ford | Fiesta | Silver | Using a Mobile Phone Whilst Driving | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 6541 | op-snap---monthly-publication-february-2025.pdf | 1358 | 2025-02 | Pedestrian | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Hinckley Road | Hinckley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.435502 | -1.4327166 | |
| 6728 | op-snap---monthly-publication-february-2025.pdf | 1545 | 2025-02 | Pedestrian | Volkswagen | T-ROC | Black | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 |
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);