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'}
148 rows where council_area = "Coventry", month = "2025-01" and reporter_transport_mode = "Pedal Bike" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 24
offence 13
- Using a Mobile Phone Whilst Driving 45
- Driving without Reasonable Consideration 44
- Stop a vehicle within pelican pedestrian crossing limits 21
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 7
- Contravening a Red Traffic Light 6
- Stop a vehicle on pedestrian crossing 6
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 6
- Driving without Due Care and Attention 5
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2
- Driver not in position to have Proper Control 2
- Fail to Conform to Cycle Lane 2
- Contravene local traffic order 1
- No Seat Belt 1
disposal 6
- Fixed Penalty 82
- Education 37
- Warning Letter 16
- NFA 7
- Court 5
- Other Action Taken 1
reporter_transport_mode 1
- Pedal Bike · 148 ✖
month 1
- 2025-01 · 148 ✖
council_area 1
- Coventry · 148 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8904 | op-snap---monthly-publication-january-2025.pdf | 12 | 2025-01 | Pedal Bike | Mercedes-Benz | E 220 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road, Coventry | Stoney Stanton Road, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 8905 | op-snap---monthly-publication-january-2025.pdf | 13 | 2025-01 | Pedal Bike | Toyota | Prius | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road, Coventry | Stoney Stanton Road, Coventry | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 8935 | op-snap---monthly-publication-january-2025.pdf | 43 | 2025-01 | Pedal Bike | Vauxhall | Astra | 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 | |
| 8936 | op-snap---monthly-publication-january-2025.pdf | 44 | 2025-01 | Pedal Bike | BMW | 320d | Grey | 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 | |
| 8937 | op-snap---monthly-publication-january-2025.pdf | 45 | 2025-01 | Pedal Bike | BMW | 318d | Black | 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 | |
| 8938 | op-snap---monthly-publication-january-2025.pdf | 46 | 2025-01 | Pedal Bike | Mercedes-Benz | Vito | 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 | |
| 8967 | op-snap---monthly-publication-january-2025.pdf | 75 | 2025-01 | Pedal Bike | Ford | Kuga | Black | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4096725 | -1.487901 | |
| 8968 | op-snap---monthly-publication-january-2025.pdf | 76 | 2025-01 | Pedal Bike | Toyota | Noah | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4096725 | -1.487901 | |
| 8969 | op-snap---monthly-publication-january-2025.pdf | 77 | 2025-01 | Pedal Bike | Ford | Kuga | Grey | Using a Mobile Phone Whilst Driving | None | Longford Road | Longford Road | Coventry | Coventry | Court | N/A | Yes - Via Email | 52.445164 | -1.4879298 | |
| 8971 | op-snap---monthly-publication-january-2025.pdf | 79 | 2025-01 | Pedal Bike | Vauxhall | Zaffira | Brown | Driving without Reasonable Consideration | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 8974 | op-snap---monthly-publication-january-2025.pdf | 82 | 2025-01 | Pedal Bike | BMW | 320D | Blue | Driving without Reasonable Consideration | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 8995 | op-snap---monthly-publication-january-2025.pdf | 103 | 2025-01 | Pedal Bike | Ford | FOCUS | Blue | Using a Mobile Phone Whilst Driving | None | WALSGRAVE ROAD | Walsgrave Road | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | 52.4096725 | -1.487901 | |
| 9088 | op-snap---monthly-publication-january-2025.pdf | 196 | 2025-01 | Pedal Bike | Peugeot | 208 | Black | Driving without Due Care and Attention | None | Binley Road | Binley Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9090 | op-snap---monthly-publication-january-2025.pdf | 198 | 2025-01 | Pedal Bike | Audi | Q3 | Grey | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9132 | op-snap---monthly-publication-january-2025.pdf | 240 | 2025-01 | Pedal Bike | Vauxhall | Astra | Silver | Using a Mobile Phone Whilst Driving | None | Far Gosford St | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 9145 | op-snap---monthly-publication-january-2025.pdf | 253 | 2025-01 | Pedal Bike | Land Rover | SPORT | White | Driving without Reasonable Consideration | None | MOSELEY AVENUE | Moseley Avenue | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.417344 | -1.5264979 | |
| 9146 | op-snap---monthly-publication-january-2025.pdf | 254 | 2025-01 | Pedal Bike | Nissan | QASHQUI | Silver | Driver not in position to have Proper Control | None | PARK ROAD | Park Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4023403 | -1.5101708 | |
| 9228 | op-snap---monthly-publication-january-2025.pdf | 336 | 2025-01 | Pedal Bike | Ford | Focus | Blue | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9229 | op-snap---monthly-publication-january-2025.pdf | 337 | 2025-01 | Pedal Bike | Fiat | 500X | Green | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9230 | op-snap---monthly-publication-january-2025.pdf | 338 | 2025-01 | Pedal Bike | Volkswagen | Jetta | Red | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9231 | op-snap---monthly-publication-january-2025.pdf | 339 | 2025-01 | Pedal Bike | Mercedes-Benz | Sprinter | White | Stop a vehicle on pedestrian crossing | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9232 | op-snap---monthly-publication-january-2025.pdf | 340 | 2025-01 | Pedal Bike | Audi | A3 | Black | 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 | |
| 9234 | op-snap---monthly-publication-january-2025.pdf | 342 | 2025-01 | Pedal Bike | Mercedes-Benz | C220 | Blue | Contravene local traffic order | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9236 | op-snap---monthly-publication-january-2025.pdf | 344 | 2025-01 | Pedal Bike | Lexus | CT200 | Red | Using a Mobile Phone Whilst Driving | None | Old Church Road | Old Church Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4387079 | -1.4803581 | |
| 9237 | op-snap---monthly-publication-january-2025.pdf | 345 | 2025-01 | Pedal Bike | Skoda | Karoq | Black | 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 | |
| 9240 | op-snap---monthly-publication-january-2025.pdf | 348 | 2025-01 | Pedal Bike | Toyota | Avenis | Red | 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 | |
| 9242 | op-snap---monthly-publication-january-2025.pdf | 350 | 2025-01 | Pedal Bike | Audi | A6 | Black | Using a Mobile Phone Whilst Driving | None | Foles Hill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 9244 | op-snap---monthly-publication-january-2025.pdf | 352 | 2025-01 | Pedal Bike | Mitsubishi | l200 | Red | 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 | |
| 9247 | op-snap---monthly-publication-january-2025.pdf | 355 | 2025-01 | Pedal Bike | BMW | X3 | Blue | 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 | |
| 9282 | op-snap---monthly-publication-january-2025.pdf | 390 | 2025-01 | Pedal Bike | Mercedes-Benz | C250 AMG | Grey | Driving without Reasonable Consideration | None | Much Park Street | Much Park Street | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4061531 | -1.505845 | |
| 9308 | op-snap---monthly-publication-january-2025.pdf | 416 | 2025-01 | Pedal Bike | Audi | A3 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | FAR GOSFORD STREET | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 9309 | op-snap---monthly-publication-january-2025.pdf | 417 | 2025-01 | Pedal Bike | Honda | civic | Red | Stop a vehicle within pelican pedestrian crossing limits | None | FAR GOSFORD STREET | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 9311 | op-snap---monthly-publication-january-2025.pdf | 419 | 2025-01 | Pedal Bike | Toyota | Prius | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 9387 | op-snap---monthly-publication-january-2025.pdf | 495 | 2025-01 | Pedal Bike | Land Rover | FREELANDER | Black | Driving without Reasonable Consideration | None | Middlemarch Road | Middlemarch Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4316434 | -1.5142862 | |
| 9389 | op-snap---monthly-publication-january-2025.pdf | 497 | 2025-01 | Pedal Bike | Ford | Fiesta | Grey | Driving without Reasonable Consideration | None | Spon End | Spon End | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4069072 | -1.5247498 | |
| 9392 | op-snap---monthly-publication-january-2025.pdf | 500 | 2025-01 | Pedal Bike | Hyundai | I10 | Blue | Driving without Reasonable Consideration | None | Browns Lane | Browns Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.435719 | -1.5617089 | |
| 9411 | op-snap---monthly-publication-january-2025.pdf | 519 | 2025-01 | Pedal Bike | Ford | Transit | Grey | 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 | |
| 9412 | op-snap---monthly-publication-january-2025.pdf | 520 | 2025-01 | Pedal Bike | Volkswagen | Polo | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Street | Earlsdon Street | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.3988977 | -1.5323674 | |
| 9464 | op-snap---monthly-publication-january-2025.pdf | 572 | 2025-01 | Pedal Bike | Ford | FIESTA | Grey | 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 | |
| 9466 | op-snap---monthly-publication-january-2025.pdf | 574 | 2025-01 | Pedal Bike | BMW | X3 | Blue | Using a Mobile Phone Whilst Driving | None | BINLEY ROAD | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9468 | op-snap---monthly-publication-january-2025.pdf | 576 | 2025-01 | Pedal Bike | CJEVROLET SPARK | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | STONEY STATON ROAD | Stoney Staton Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | ||||
| 9471 | op-snap---monthly-publication-january-2025.pdf | 579 | 2025-01 | Pedal Bike | DACIA DUSTER | White | Using a Mobile Phone Whilst Driving | None | RED LANE | Red Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4207563 | -1.4898515 | ||
| 9472 | op-snap---monthly-publication-january-2025.pdf | 580 | 2025-01 | Pedal Bike | Volkswagen | GOLF | 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 | |
| 9480 | op-snap---monthly-publication-january-2025.pdf | 588 | 2025-01 | Pedal Bike | Mercedes-Benz | GLA250 | Silver | Driving without Reasonable Consideration | None | Earlsdon Avenue North | Earlsdon Avenue North | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4025196 | -1.5327802 | |
| 9481 | op-snap---monthly-publication-january-2025.pdf | 589 | 2025-01 | Pedal Bike | Ford | Transit | Black | Driving without Reasonable Consideration | None | Earlsdon Avenue South | Earlsdon Avenue South | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3960991 | -1.5255671 | |
| 9483 | op-snap---monthly-publication-january-2025.pdf | 591 | 2025-01 | Pedal Bike | Mercedes-Benz | Sprinter | Green | Stop a vehicle within pelican pedestrian crossing limits | None | Charter Avenue | Charter Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3928409 | -1.5888076 | |
| 9489 | op-snap---monthly-publication-january-2025.pdf | 597 | 2025-01 | Pedal Bike | Citroen | C5 | Blue | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9491 | op-snap---monthly-publication-january-2025.pdf | 599 | 2025-01 | Pedal Bike | Jaguar | FP | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9493 | op-snap---monthly-publication-january-2025.pdf | 601 | 2025-01 | Pedal Bike | N/a | Black | Using a Mobile Phone Whilst Driving | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | NFA | No VRM | Yes - Via Email | 52.4134557 | -1.4442138 | ||
| 9494 | op-snap---monthly-publication-january-2025.pdf | 602 | 2025-01 | Pedal Bike | Citroen | Berlingo | Silver | Using a Mobile Phone Whilst Driving | None | Herald Way | Herald Way | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3949335 | -1.4405195 | |
| 9544 | op-snap---monthly-publication-january-2025.pdf | 652 | 2025-01 | Pedal Bike | Suzuki | SX4 | Blue | Driving without Reasonable Consideration | None | Mile Lane | Mile Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3992732 | -1.5044832 | |
| 9593 | op-snap---monthly-publication-january-2025.pdf | 701 | 2025-01 | Pedal Bike | Mercedes-Benz | C200 | Grey | Driving without Reasonable Consideration | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9594 | op-snap---monthly-publication-january-2025.pdf | 702 | 2025-01 | Pedal Bike | Ford | Focus | Silver | Driving without Reasonable Consideration | Use vehicle on a road without valid test c | eCrotixf iSctarteeet | e Crotixf i Sctarteeet | Coventry | Coventry | Court | N/A | Yes - Via Email | |||
| 9597 | op-snap---monthly-publication-january-2025.pdf | 705 | 2025-01 | Pedal Bike | Vauxhall | Astra | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9600 | op-snap---monthly-publication-january-2025.pdf | 708 | 2025-01 | Pedal Bike | Toyota | Corrolla | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4221152 | -1.4959475 | |
| 9605 | op-snap---monthly-publication-january-2025.pdf | 713 | 2025-01 | Pedal Bike | Peugeot | 3008 | Grey | Driving without Reasonable Consideration | None | Beechwood Avenue | Beechwood Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3960292 | -1.5340332 | |
| 9607 | op-snap---monthly-publication-january-2025.pdf | 715 | 2025-01 | Pedal Bike | Volkswagen | GOLF | 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 | |
| 9608 | op-snap---monthly-publication-january-2025.pdf | 716 | 2025-01 | Pedal Bike | BMW | 520I | 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 | |
| 9609 | op-snap---monthly-publication-january-2025.pdf | 717 | 2025-01 | Pedal Bike | Peugeot | 3008 | Black | No Seat Belt | Motor vehicle fail to comply with a non e | nFdOoLrEsSaHbIlLeL t RraOffAicD sign - detected by means other than ACD | n Fd Oo Lr Es Sa Hb Il Le L t Rra Off Aic D sign - detected by means other than ACD | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | |||
| 9610 | op-snap---monthly-publication-january-2025.pdf | 718 | 2025-01 | Pedal Bike | Vauxhall | MOKKA | White | 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 | |
| 9611 | op-snap---monthly-publication-january-2025.pdf | 719 | 2025-01 | Pedal Bike | Ford | FIESTA | 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 | |
| 9613 | op-snap---monthly-publication-january-2025.pdf | 721 | 2025-01 | Pedal Bike | Toyota | Yaris | White | 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 | |
| 9614 | op-snap---monthly-publication-january-2025.pdf | 722 | 2025-01 | Pedal Bike | Renault | Megane | 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 | |
| 9615 | op-snap---monthly-publication-january-2025.pdf | 723 | 2025-01 | Pedal Bike | Hyundai | Ioniq | White | Driving without Reasonable Consideration | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 9617 | op-snap---monthly-publication-january-2025.pdf | 725 | 2025-01 | Pedal Bike | Ford | Ranger | Black | Driving without Due Care and Attention | No vehicle excise licence | Church Lane | Church Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4202618 | -1.6010473 | |
| 9618 | op-snap---monthly-publication-january-2025.pdf | 726 | 2025-01 | Pedal Bike | Nissan | Micra | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Princethorpe Way | Princethorpe Way | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.3953553 | -1.4561037 | |
| 9619 | op-snap---monthly-publication-january-2025.pdf | 727 | 2025-01 | Pedal Bike | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Quorn Way | Quorn Way | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3934973 | -1.4536866 | |
| 9620 | op-snap---monthly-publication-january-2025.pdf | 728 | 2025-01 | Pedal Bike | Ford | Kuga | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4096725 | -1.487901 | |
| 9628 | op-snap---monthly-publication-january-2025.pdf | 736 | 2025-01 | Pedal Bike | Vauxhall | mokka | Blue | Stop a vehicle on pedestrian crossing | None | Earlsden Street | Earlsden Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | |||
| 9636 | op-snap---monthly-publication-january-2025.pdf | 744 | 2025-01 | Pedal Bike | Toyota | Corolla | White | 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 | |
| 9637 | op-snap---monthly-publication-january-2025.pdf | 745 | 2025-01 | Pedal Bike | Deliver 9 | White | 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 | ||
| 9638 | op-snap---monthly-publication-january-2025.pdf | 746 | 2025-01 | Pedal Bike | Ford | Mondeo | Red | 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 | |
| 9640 | op-snap---monthly-publication-january-2025.pdf | 748 | 2025-01 | Pedal Bike | Vauxhall | Zafira | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 9641 | op-snap---monthly-publication-january-2025.pdf | 749 | 2025-01 | Pedal Bike | Volkswagen | Golf | Silver | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4274335 | -1.5002381 | |
| 9642 | op-snap---monthly-publication-january-2025.pdf | 750 | 2025-01 | Pedal Bike | Volvo | V60 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Far Gosford Street | Far Gosford Street | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4071231 | -1.4985178 | |
| 9655 | op-snap---monthly-publication-january-2025.pdf | 763 | 2025-01 | Pedal Bike | Volkswagen | Golf | Black | Driving without Reasonable Consideration | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.396476 | -1.5561348 | |
| 9657 | op-snap---monthly-publication-january-2025.pdf | 765 | 2025-01 | Pedal Bike | Kia | Ceed | Brown | Contravening a Red Traffic Light | None | Beake Ave | Beake Ave | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | 52.4360855 | -1.5226352 | |
| 9660 | op-snap---monthly-publication-january-2025.pdf | 768 | 2025-01 | Pedal Bike | Mercedes-Benz | CLA180 | Black | Using a Mobile Phone Whilst Driving | None | Burnaby Road | Burnaby Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4352 | -1.5194238 | |
| 9691 | op-snap---monthly-publication-january-2025.pdf | 799 | 2025-01 | Pedal Bike | Hyundai | IX35 | Black | Stop a vehicle within pelican pedestrian crossing limits | No vehicle excise licence | Scots Lane | Scots Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4234754 | -1.5328595 | |
| 9752 | op-snap---monthly-publication-january-2025.pdf | 860 | 2025-01 | Pedal Bike | Peugeot | 3008 | White | Using a Mobile Phone Whilst Driving | None | Coventry Eastern By-Pass | Coventry Eastern By-Pass | Coventry | Coventry | NFA | Out of Force | Yes - Via Email | |||
| 9753 | op-snap---monthly-publication-january-2025.pdf | 861 | 2025-01 | Pedal Bike | Volkswagen | Transporter | Grey | Using a Mobile Phone Whilst Driving | None | Narberth Way | Narberth Way | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4306797 | -1.4440324 | |
| 9755 | op-snap---monthly-publication-january-2025.pdf | 863 | 2025-01 | Pedal Bike | BMW | 320 | white | Using a Mobile Phone Whilst Driving | None | Coventry Eastern By-Pass | Coventry Eastern By-Pass | Coventry | Coventry | NFA | Out of Force | Yes - Via Email | |||
| 9758 | op-snap---monthly-publication-january-2025.pdf | 866 | 2025-01 | Pedal Bike | Ford | Transit | White | 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 | |
| 9760 | op-snap---monthly-publication-january-2025.pdf | 868 | 2025-01 | Pedal Bike | Nissan | Note | Red | Fail to Conform to Cycle Lane | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9761 | op-snap---monthly-publication-january-2025.pdf | 869 | 2025-01 | Pedal Bike | Ford | Focus | White | Fail to Conform to Cycle Lane | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9762 | op-snap---monthly-publication-january-2025.pdf | 870 | 2025-01 | Pedal Bike | Citroen | Picasso | Silver | Using a Mobile Phone Whilst Driving | None | Binley Road | Binley Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4070602 | -1.4732469 | |
| 9774 | op-snap---monthly-publication-january-2025.pdf | 882 | 2025-01 | Pedal Bike | Mercedes-Benz | A250 | Silver | Using a Mobile Phone Whilst Driving | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4096725 | -1.487901 | |
| 9775 | op-snap---monthly-publication-january-2025.pdf | 883 | 2025-01 | Pedal Bike | Ford | Ranger | Grey | Driving without Reasonable Consideration | None | Brandon Road | Brandon Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.399222 | -1.4414386 | |
| 9777 | op-snap---monthly-publication-january-2025.pdf | 885 | 2025-01 | Pedal Bike | Vauxhall | Movano | Grey | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9778 | op-snap---monthly-publication-january-2025.pdf | 886 | 2025-01 | Pedal Bike | Ford | Focus | Grey | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9780 | op-snap---monthly-publication-january-2025.pdf | 888 | 2025-01 | Pedal Bike | Mercedes-Benz | C220 | Silver | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9781 | op-snap---monthly-publication-january-2025.pdf | 889 | 2025-01 | Pedal Bike | Citroen | C5 | Black | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9782 | op-snap---monthly-publication-january-2025.pdf | 890 | 2025-01 | Pedal Bike | Peugeot | Partner | White | Driving without Reasonable Consideration | None | Swancroft Road | Swancroft Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4201997 | -1.4875978 | |
| 9785 | op-snap---monthly-publication-january-2025.pdf | 893 | 2025-01 | Pedal Bike | Vauxhall | Astra | Red | Driving without Reasonable Consideration | None | Swancroft Road | Swancroft Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4201997 | -1.4875978 | |
| 9790 | op-snap---monthly-publication-january-2025.pdf | 898 | 2025-01 | Pedal Bike | Fiat | TRANSIT | Silver | Driving without Reasonable Consideration | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9913 | op-snap---monthly-publication-january-2025.pdf | 1021 | 2025-01 | Pedal Bike | Volkswagen | CADDY | White | Driving without Reasonable Consideration | None | CLIFFORD BRIDGE ROAD | Clifford Bridge Road | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.4134557 | -1.4442138 | |
| 9927 | op-snap---monthly-publication-january-2025.pdf | 1035 | 2025-01 | Pedal Bike | Ford | Kuga | Silver | Contravening a Red Traffic Light | None | Lockhurst Lane | Lockhurst Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4255689 | -1.5023841 | |
| 9930 | op-snap---monthly-publication-january-2025.pdf | 1038 | 2025-01 | Pedal Bike | Toyota | Prius | Blue | Contravening a Red Traffic Light | None | Lockhurst Lane | Lockhurst Lane | Coventry | Coventry | Fixed Penalty | N/A | Yes - Via Email | 52.4255689 | -1.5023841 | |
| 9937 | op-snap---monthly-publication-january-2025.pdf | 1045 | 2025-01 | Pedal Bike | Volkswagen | GOLF | White | Driving without Reasonable Consideration | None | DUGGINS LANE | Duggins Lane | Coventry | Coventry | Education | N/A | Yes - Via Email | 52.3964189 | -1.5989088 | |
| 9944 | op-snap---monthly-publication-january-2025.pdf | 1052 | 2025-01 | Pedal Bike | Jaguar | E-Pace | 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 |
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);