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'}
97 rows where council_area = "Coventry", disposal = "NFA" and offence = "Contravening a Red Traffic Light" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 22
month 14
reporter_transport_mode 5
- Car 71
- Pedal Bike 21
- Pedestrian 3
- Motorbike 1
- Other 1
offence 1
- Contravening a Red Traffic Light · 97 ✖
disposal 1
- NFA · 97 ✖
council_area 1
- Coventry · 97 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8087 | op-snap---monthly-publication-february-2026.pdf | 834 | 2026-02 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | 52.4070602 | -1.4732469 | |||
| 10633 | op-snap---monthly-publication-january-2026.pdf | 94 | 2026-01 | Car | Audi | Q2 | Grey | Contravening a Red Traffic Light | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4085943 | -1.4943275 | ||
| 10638 | op-snap---monthly-publication-january-2026.pdf | 99 | 2026-01 | Car | Peugeot | 3008 | Red | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4221152 | -1.4959475 | ||
| 11119 | op-snap---monthly-publication-january-2026.pdf | 580 | 2026-01 | Pedal Bike | Honda | Civic | Blue | Contravening a Red Traffic Light | None | Burnaby Road at Beake Avenue | Burnaby Road at Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4352 | -1.5194238 | ||
| 3905 | op-snap---monthly-publication-december-2025.pdf | 33 | 2025-12 | Pedestrian | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3906 | op-snap---monthly-publication-december-2025.pdf | 34 | 2025-12 | Pedestrian | Ford | Fiesta | White | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | ||
| 3907 | op-snap---monthly-publication-december-2025.pdf | 35 | 2025-12 | Pedestrian | Mercedes-Benz | Grey | Contravening a Red Traffic Light | None | Leaf Lane | Leaf Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3837942 | -1.4979145 | |||
| 4058 | op-snap---monthly-publication-december-2025.pdf | 186 | 2025-12 | Car | Toyota | Yaris | White | Contravening a Red Traffic Light | None | Beake Avenue | Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4388246 | -1.5229308 | ||
| 4479 | op-snap---monthly-publication-december-2025.pdf | 607 | 2025-12 | Pedal Bike | Mazda | RX 8 | Silver | Contravening a Red Traffic Light | None | Bell Green Road | Bell Green Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4324855 | -1.4815548 | ||
| 4904 | op-snap---monthly-publication-december-2025.pdf | 1032 | 2025-12 | Car | Kia | Sportage | White | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No VRM | 52.4214017 | -1.4870278 | ||
| 20493 | op-snap---monthly-publication-november-2025.pdf | 35 | 2025-11 | Pedal Bike | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Bell Green Lane | Bell Green Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3995055 | -1.5349094 | ||
| 20525 | op-snap---monthly-publication-november-2025.pdf | 67 | 2025-11 | Car | BMW | X2 | Blue | Contravening a Red Traffic Light | None | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3793117 | -1.4625379 | ||
| 20721 | op-snap---monthly-publication-november-2025.pdf | 263 | 2025-11 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | No Insurance | Foleshll Island | Foleshll Island | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 21302 | op-snap---monthly-publication-november-2025.pdf | 844 | 2025-11 | Car | Honda | crv | Grey | Contravening a Red Traffic Light | None | A45 | A45 | Coventry | Coventry | NFA | No VRM | ||||
| 21509 | op-snap---monthly-publication-november-2025.pdf | 1051 | 2025-11 | Car | Peugeot | 2008 | Grey | Contravening a Red Traffic Light | None | A444 Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4214017 | -1.4870278 | ||
| 21578 | op-snap---monthly-publication-november-2025.pdf | 1120 | 2025-11 | Car | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | Puma Way | Puma Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.401984 | -1.5046079 | ||
| 21609 | op-snap---monthly-publication-november-2025.pdf | 1151 | 2025-11 | Car | Ford | Explorer | Blue | Contravening a Red Traffic Light | None | Moseley Av | Moseley Avenue | Coventry | Coventry | NFA | No Offence | 52.417344 | -1.5264979 | ||
| 22054 | op-snap---monthly-publication-october-2025.pdf | 4 | 2025-10 | Other | Black | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.401916 | -1.5154953 | ||||
| 22424 | op-snap---monthly-publication-october-2025.pdf | 374 | 2025-10 | Car | Mercedes-Benz | EQA | Black | Contravening a Red Traffic Light | None | M6 Jn2 | M6 Jn2 | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 22578 | op-snap---monthly-publication-october-2025.pdf | 528 | 2025-10 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Firefly Road | Firefly Road | Coventry | Coventry | NFA | No Offence | 52.3786307 | -1.4839701 | ||
| 22647 | op-snap---monthly-publication-october-2025.pdf | 597 | 2025-10 | Pedal Bike | Toyota | Prius | Black | Contravening a Red Traffic Light | None | Primrose Hill Street | Primrose Hill Street | Coventry | Coventry | NFA | No VRM | 52.412862 | -1.5030563 | ||
| 22856 | op-snap---monthly-publication-october-2025.pdf | 806 | 2025-10 | Car | Vauxhall | Mokka | Red | Contravening a Red Traffic Light | None | Daventry Road | Daventry Road | Coventry | Coventry | NFA | No VRM | 52.3930931 | -1.4976428 | ||
| 23008 | op-snap---monthly-publication-october-2025.pdf | 958 | 2025-10 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | None | Kenilworth Road | Kenilworth Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3833298 | -1.5379214 | ||
| 23039 | op-snap---monthly-publication-october-2025.pdf | 989 | 2025-10 | Car | Nissan | Qashqai | White | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4205675 | -1.4520187 | ||
| 24446 | op-snap---monthly-publication-september-2025.pdf | 665 | 2025-09 | Car | Nissan | X-Trail | Silver | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No Independent Evidence Available | 52.396476 | -1.5561348 | ||
| 24603 | op-snap---monthly-publication-september-2025.pdf | 822 | 2025-09 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | Queenslands Avenue | Queenslands Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 24604 | op-snap---monthly-publication-september-2025.pdf | 823 | 2025-09 | Car | Nissan | Qashqai | Grey | Contravening a Red Traffic Light | None | Walkers Heath Lane | Walkers Heath Lane | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 24648 | op-snap---monthly-publication-september-2025.pdf | 867 | 2025-09 | Car | BMW | 5 series | Silver | Contravening a Red Traffic Light | None | Foleshill Road, | Foleshill Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4274335 | -1.5002381 | ||
| 24933 | op-snap---monthly-publication-september-2025.pdf | 1152 | 2025-09 | Car | Mercedes-Benz | A180.. | Grey | Contravening a Red Traffic Light | None | Queensland Avenue | Queensland Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.406658 | -1.5363495 | ||
| 24943 | op-snap---monthly-publication-september-2025.pdf | 1162 | 2025-09 | Motorbike | Citroen | DS3 | Red | Contravening a Red Traffic Light | None | Allard Way | Allard Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3955174 | -1.4685442 | ||
| 24953 | op-snap---monthly-publication-september-2025.pdf | 1172 | 2025-09 | Car | BMW | 330i | Black | Contravening a Red Traffic Light | None | Canley Road | Canley Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4006176 | -1.5454677 | ||
| 2093 | op-snap---monthly-publication-august-2025.pdf | 68 | 2025-08 | Car | Volkswagen | Polo | Black | Contravening a Red Traffic Light | None | Ringway St Johns | Ringway Street Johns | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2100 | op-snap---monthly-publication-august-2025.pdf | 75 | 2025-08 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Foleshill | Foleshill | Coventry | Coventry | NFA | Not in Public Interest | 52.4335692 | -1.4944742 | |||
| 2484 | op-snap---monthly-publication-august-2025.pdf | 459 | 2025-08 | Car | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | No VRM | 52.4070602 | -1.4732469 | |||||
| 11986 | op-snap---monthly-publication-july-2025.pdf | 38 | 2025-07 | Pedal Bike | Ford | Fiesta | Brown | Contravening a Red Traffic Light | None | Broomfield Road | Broomfield Road | Coventry | Coventry | NFA | No Offence | 52.4034143 | -1.5300449 | ||
| 12014 | op-snap---monthly-publication-july-2025.pdf | 66 | 2025-07 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4214017 | -1.4870278 | ||
| 12235 | op-snap---monthly-publication-july-2025.pdf | 287 | 2025-07 | Car | Grey | Contravening a Red Traffic Light | None | Croft Road at Starley Road | Croft Road at Starley Road | Coventry | Coventry | NFA | No VRM | 52.4060808 | -1.5185521 | ||||
| 12307 | op-snap---monthly-publication-july-2025.pdf | 359 | 2025-07 | Car | Jaguar | S Type | Green | Contravening a Red Traffic Light | None | Firefly Road | Firefly Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3786307 | -1.4839701 | ||
| 12308 | op-snap---monthly-publication-july-2025.pdf | 360 | 2025-07 | Car | Toyota | Prius | Red | Contravening a Red Traffic Light | No vehicle excise licence | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.396476 | -1.5561348 | ||
| 12648 | op-snap---monthly-publication-july-2025.pdf | 700 | 2025-07 | Car | Peugeot | Partner | Grey | Contravening a Red Traffic Light | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4041117 | -1.5595662 | ||
| 12661 | op-snap---monthly-publication-july-2025.pdf | 713 | 2025-07 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A45 Covntry | Covntry | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 12695 | op-snap---monthly-publication-july-2025.pdf | 747 | 2025-07 | Pedal Bike | Mazda | model 6 | White | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No Offence | 52.396476 | -1.5561348 | ||
| 12706 | op-snap---monthly-publication-july-2025.pdf | 758 | 2025-07 | Pedal Bike | Peugeot | 208 | White | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No Independent Evidence Available | 52.396476 | -1.5561348 | ||
| 12872 | op-snap---monthly-publication-july-2025.pdf | 924 | 2025-07 | Car | Toyota | Prius | Gold | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4205675 | -1.4520187 | ||
| 12915 | op-snap---monthly-publication-july-2025.pdf | 967 | 2025-07 | Car | Volkswagen | T - Ron | Black | Contravening a Red Traffic Light | None | Broad Lane - A45 | Broad Lane - A45 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4054611 | -1.5491157 | ||
| 12987 | op-snap---monthly-publication-july-2025.pdf | 1039 | 2025-07 | Car | Audi | A3 | Grey | Contravening a Red Traffic Light | None | Coventry Road , A45 | Coventry Road , A45 | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4516899 | -1.7753139 | ||
| 13160 | op-snap---monthly-publication-july-2025.pdf | 1212 | 2025-07 | Car | Audi | A3.. | White | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4205675 | -1.4520187 | ||
| 13196 | op-snap---monthly-publication-july-2025.pdf | 1248 | 2025-07 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4214017 | -1.4870278 | ||
| 13212 | op-snap---monthly-publication-july-2025.pdf | 1264 | 2025-07 | Car | Hyundai | Blue | Contravening a Red Traffic Light | None | Broad Lane | Broad Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4074716 | -1.5620671 | |||
| 13243 | op-snap---monthly-publication-july-2025.pdf | 1295 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Contravening a Red Traffic Light | None | Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3793117 | -1.4625379 | ||
| 14289 | op-snap---monthly-publication-june-2025.pdf | 218 | 2025-06 | Pedal Bike | Peugeot | 2008 | Red | Contravening a Red Traffic Light | None | Beake Avenue | Beake Avenue | Coventry | Coventry | NFA | No Offence | 52.4388246 | -1.5229308 | ||
| 14383 | op-snap---monthly-publication-june-2025.pdf | 312 | 2025-06 | Car | Toyota | Aygo | Silver | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4373088 | -1.504993 | ||
| 14384 | op-snap---monthly-publication-june-2025.pdf | 313 | 2025-06 | Car | BMW | Black | Contravening a Red Traffic Light | None | Ash Green | Ash Green | Coventry | Coventry | NFA | No VRM | 52.4203416 | -1.5763062 | |||
| 14448 | op-snap---monthly-publication-june-2025.pdf | 377 | 2025-06 | Car | Volvo | C40 | Silver | Contravening a Red Traffic Light | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | No Offence | 52.418488 | -1.5472387 | ||
| 14450 | op-snap---monthly-publication-june-2025.pdf | 379 | 2025-06 | Car | Toyota | PRIUS | Grey | Contravening a Red Traffic Light | None | Moseley Ave | Moseley Ave | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4141818 | -1.5315277 | ||
| 14456 | op-snap---monthly-publication-june-2025.pdf | 385 | 2025-06 | Car | Peugeot | 3008 | Grey | Contravening a Red Traffic Light | None | Binley Road | Binley Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4070602 | -1.4732469 | ||
| 14458 | op-snap---monthly-publication-june-2025.pdf | 387 | 2025-06 | Car | Lexus | RX450 | Black | Contravening a Red Traffic Light | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.436155 | -1.5064002 | ||
| 14513 | op-snap---monthly-publication-june-2025.pdf | 442 | 2025-06 | Car | Smartcar | Black | Contravening a Red Traffic Light | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | NFA | No VRM | 52.396476 | -1.5561348 | |||
| 14692 | op-snap---monthly-publication-june-2025.pdf | 621 | 2025-06 | Car | London Taxi | Black | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4380313 | -1.5339558 | |||
| 14705 | op-snap---monthly-publication-june-2025.pdf | 634 | 2025-06 | Car | Volvo | Truck | Green | Contravening a Red Traffic Light | None | Coventry Bypass | Coventry Bypass | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3794055 | -1.4626632 | ||
| 14761 | op-snap---monthly-publication-june-2025.pdf | 690 | 2025-06 | Car | Hyundai | Comfort | Red | Contravening a Red Traffic Light | None | Fletchmstead Highway | Fletchmstead Highway | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 14879 | op-snap---monthly-publication-june-2025.pdf | 808 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Sunbeam Way | Sunbeam Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.398205 | -1.4851165 | ||
| 14908 | op-snap---monthly-publication-june-2025.pdf | 837 | 2025-06 | Car | Audi | A5 | Grey | Contravening a Red Traffic Light | None | Queensland Av | Queensland Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.406658 | -1.5363495 | ||
| 15124 | op-snap---monthly-publication-june-2025.pdf | 1053 | 2025-06 | Car | Volkswagen | Caddy | Blue | Contravening a Red Traffic Light | None | Ansty Road | Ansty Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4205675 | -1.4520187 | ||
| 15241 | op-snap---monthly-publication-june-2025.pdf | 1170 | 2025-06 | Car | Yamaha | Xmax | Red | Contravening a Red Traffic Light | None | Walsgrave ROad | Walsgrave ROad | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4096725 | -1.487901 | ||
| 15441 | op-snap---monthly-publication-june-2025.pdf | 1370 | 2025-06 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Wheelwright Lane | Wheelwright Lane | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4484571 | -1.5109455 | |||
| 15454 | op-snap---monthly-publication-june-2025.pdf | 1383 | 2025-06 | Car | Volkswagen | White | Contravening a Red Traffic Light | None | Foleshill Road | Foleshill Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4274335 | -1.5002381 | |||
| 18867 | op-snap---monthly-publication-may-2025.pdf | 229 | 2025-05 | Car | Honda | Accord | Blue | Contravening a Red Traffic Light | None | Woodway Lane | Woodway Lane | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4275505 | -1.4448681 | ||
| 19073 | op-snap---monthly-publication-may-2025.pdf | 435 | 2025-05 | Car | Renault | Traffic | White | Contravening a Red Traffic Light | None | Stivichall Roundabout | Stivichall Roundabout | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3776818 | -1.4982138 | ||
| 19154 | op-snap---monthly-publication-may-2025.pdf | 516 | 2025-05 | Pedal Bike | BMW | X1 | Grey | Contravening a Red Traffic Light | None | Barker Butt Lane | Barker Butt Lane | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 19447 | op-snap---monthly-publication-may-2025.pdf | 809 | 2025-05 | Car | Bike | Contravening a Red Traffic Light | None | A444 Coventry | Coventry | Coventry | Coventry | NFA | No VRM | 52.400739 | -1.5135474 | ||||
| 19461 | op-snap---monthly-publication-may-2025.pdf | 823 | 2025-05 | Car | Peugeot | 208 | White | Contravening a Red Traffic Light | None | Baginton Road | Baginton Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3850475 | -1.5147678 | ||
| 19668 | op-snap---monthly-publication-may-2025.pdf | 1030 | 2025-05 | Car | Bentley | Black | Contravening a Red Traffic Light | None | Pickford Way | Pickford Way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4220824 | -1.5625669 | |||
| 19918 | op-snap---monthly-publication-may-2025.pdf | 1280 | 2025-05 | Pedal Bike | Citroen | C4 | Grey | Contravening a Red Traffic Light | None | Foleshill road, at A444 roundabout | Foleshill road, at A444 roundabout | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4363104 | -1.4936555 | ||
| 19958 | op-snap---monthly-publication-may-2025.pdf | 1320 | 2025-05 | Pedal Bike | Toyota | Prius | White | Contravening a Red Traffic Light | None | Gosford Street , Coventry | Gosford Street , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4068712 | -1.4994695 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 1395 | op-snap---monthly-publication-april-2025.pdf | 1394 | 2025-04 | Pedal Bike | Nissan | Micra | Black | Contravening a Red Traffic Light | None | Far gosford street at the junction with sky blue way | Far gosford street at the junction with sky blue way | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4071231 | -1.4985178 | ||
| 1722 | op-snap---monthly-publication-april-2025.pdf | 1721 | 2025-04 | Car | Ford | Focus | Silver | Contravening a Red Traffic Light | None | Sky blue way road | Sky blue way road | Coventry | Coventry | NFA | Outside of 14 Days NIP | ||||
| 1842 | op-snap---monthly-publication-april-2025.pdf | 1841 | 2025-04 | Car | Tesla | NP | White | Contravening a Red Traffic Light | None | Leamington Road , Coventry | Leamington Road , Coventry | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3834234 | -1.5160909 | ||
| 1951 | op-snap---monthly-publication-april-2025.pdf | 1950 | 2025-04 | Pedal Bike | Mercedes-Benz | 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 | ||
| 1969 | op-snap---monthly-publication-april-2025.pdf | 1968 | 2025-04 | Car | Volkswagen | Hatch | Black | Contravening a Red Traffic Light | None | Hipswell , Coventry | Hipswell , Coventry | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4050907 | -1.460151 | ||
| 17494 | op-snap---monthly-publication-march-2025.pdf | 1251 | 2025-03 | Car | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | Allesley Old Road | Allesley Old Road | Coventry | Coventry | NFA | No Offence | Yes - Via Email | 52.4103629 | -1.5441218 | |
| 17926 | op-snap---monthly-publication-march-2025.pdf | 1683 | 2025-03 | Car | BMW | M5 | Black | Contravening a Red Traffic Light | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | 52.4214017 | -1.4870278 | |
| 5428 | op-snap---monthly-publication-february-2025.pdf | 245 | 2025-02 | Car | Citroen | DS3 | Purple | Contravening a Red Traffic Light | None | MOSELEY AVENUE | Moseley Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | Yes - Via Email | 52.417344 | -1.5264979 | |
| 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 |
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);