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'}
51 rows where council_area = "Coventry", disposal = "Warning Letter" and vehicle_make = "Mercedes-Benz" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
month 14
offence 10
- Driving without Due Care and Attention 24
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 9
- Cause vehicle to be left in a dangerous position 5
- Driving without Reasonable Consideration 3
- Cause unnecessary obstruction by motor vehicle 2
- Contravening a Red Traffic Light 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Stop a vehicle within pelican pedestrian crossing limits 2
- Prohibited vehicle in offside lane of motorway 1
- VRM fails to conform to Regulations 1
reporter_transport_mode 3
- Car 22
- Pedal Bike 17
- Pedestrian 12
vehicle_make 1
- Mercedes-Benz · 51 ✖
disposal 1
- Warning Letter · 51 ✖
council_area 1
- Coventry · 51 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7594 | op-snap---monthly-publication-february-2026.pdf | 341 | 2026-02 | Pedestrian | Mercedes-Benz | E220.. | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Burnaby Road | Burnaby Road | Coventry | Coventry | Warning Letter | N/A | 52.4352 | -1.5194238 | ||
| 7621 | op-snap---monthly-publication-february-2026.pdf | 368 | 2026-02 | Pedestrian | Mercedes-Benz | GLA | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Drapers Field | Drapers Field | Coventry | Coventry | Warning Letter | N/A | 52.414436 | -1.5112122 | ||
| 7696 | op-snap---monthly-publication-february-2026.pdf | 443 | 2026-02 | Pedal Bike | Mercedes-Benz | A Class | Silver | Driving without Due Care and Attention | None | Tile Hill Lane | Tile Hill Lane | Coventry | Coventry | Warning Letter | N/A | 52.4041117 | -1.5595662 | ||
| 8543 | op-snap---monthly-publication-february-2026.pdf | 1290 | 2026-02 | Pedal Bike | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Westwood Way | Westwood Way | Coventry | Coventry | Warning Letter | N/A | 52.3880214 | -1.5797132 | ||
| 8668 | op-snap---monthly-publication-february-2026.pdf | 1415 | 2026-02 | Car | Mercedes-Benz | Vito | White | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 8728 | op-snap---monthly-publication-february-2026.pdf | 1475 | 2026-02 | Pedal Bike | Mercedes-Benz | spinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 10801 | op-snap---monthly-publication-january-2026.pdf | 262 | 2026-01 | Car | Mercedes-Benz | White | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Warning Letter | N/A | 52.3916468 | -1.4925995 | |||
| 4710 | op-snap---monthly-publication-december-2025.pdf | 838 | 2025-12 | Car | Mercedes-Benz | GLA | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Minster Road | Minster Road | Coventry | Coventry | Warning Letter | N/A | 52.4100542 | -1.5227279 | ||
| 20496 | op-snap---monthly-publication-november-2025.pdf | 38 | 2025-11 | Car | Mercedes-Benz | C220.. | Black | Contravening a Red Traffic Light | None | Tollbar End Cov | Tollbar End Cov | Coventry | Coventry | Warning Letter | N/A | 52.377406 | -1.4651313 | ||
| 20544 | op-snap---monthly-publication-november-2025.pdf | 86 | 2025-11 | Car | Mercedes-Benz | GLC | Blue | Driving without Due Care and Attention | None | Wigston Road, Hinkley Road Roundabout | Wigston Road, Hinkley Road Roundabout | Coventry | Coventry | Warning Letter | N/A | ||||
| 20574 | op-snap---monthly-publication-november-2025.pdf | 116 | 2025-11 | Car | Mercedes-Benz | CLA 200 | Silver | Driving without Due Care and Attention | None | Jimmy HIll Way | Jimmy HIll Way | Coventry | Coventry | Warning Letter | N/A | 52.4214017 | -1.4870278 | ||
| 20848 | op-snap---monthly-publication-november-2025.pdf | 390 | 2025-11 | Car | Mercedes-Benz | A 200 | Black | Driving without Due Care and Attention | None | Central Boulevard | Central Boulevard | Coventry | Coventry | Warning Letter | N/A | 52.4543969 | -1.5168781 | ||
| 21116 | op-snap---monthly-publication-november-2025.pdf | 658 | 2025-11 | Pedal Bike | Mercedes-Benz | A35 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 21461 | op-snap---monthly-publication-november-2025.pdf | 1003 | 2025-11 | Pedal Bike | Mercedes-Benz | c250 | White | Cause vehicle to be left in a dangerous position | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 22772 | op-snap---monthly-publication-october-2025.pdf | 722 | 2025-10 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 23218 | op-snap---monthly-publication-october-2025.pdf | 1168 | 2025-10 | Pedestrian | Mercedes-Benz | C220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bridge Rd | Bridge Road | Coventry | Coventry | Warning Letter | N/A | 52.4211632 | -1.4473468 | ||
| 23709 | op-snap---monthly-publication-october-2025.pdf | 1659 | 2025-10 | Pedestrian | Mercedes-Benz | spinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dallington road | Dallington Road | Coventry | Coventry | Warning Letter | N/A | 52.4220671 | -1.5422836 | ||
| 24281 | op-snap---monthly-publication-september-2025.pdf | 500 | 2025-09 | Car | Mercedes-Benz | Sprinter | Yellow | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Ringway, Swanswell | Ringway, Swanswell | Coventry | Coventry | Warning Letter | N/A | ||||
| 24938 | op-snap---monthly-publication-september-2025.pdf | 1157 | 2025-09 | Car | Mercedes-Benz | van | white | Driving without Due Care and Attention | None | A42 Coventry | Coventry | Coventry | Coventry | Warning Letter | N/A | 52.400739 | -1.5135474 | ||
| 25074 | op-snap---monthly-publication-september-2025.pdf | 1293 | 2025-09 | Pedal Bike | Mercedes-Benz | sprinter | White | Cause vehicle to be left in a dangerous position | None | NArbeth Way | NArbeth Way | Coventry | Coventry | Warning Letter | N/A | ||||
| 25327 | op-snap---monthly-publication-september-2025.pdf | 1546 | 2025-09 | Pedestrian | Mercedes-Benz | C350 | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | charter avenue | Charter Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3928409 | -1.5888076 | ||
| 25374 | op-snap---monthly-publication-september-2025.pdf | 1593 | 2025-09 | Pedestrian | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Durhman Rd | Durhman Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 25623 | op-snap---monthly-publication-september-2025.pdf | 1842 | 2025-09 | Car | Mercedes-Benz | Benz | Black | VRM fails to conform to Regulations | None | Coventry Road | Coventry Road | Coventry | Coventry | Warning Letter | N/A | 52.4111289 | -1.5094345 | ||
| 3431 | op-snap---monthly-publication-august-2025.pdf | 1406 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Prohibited vehicle in offside lane of motorway | None | M6 southbound towards coventry | M6 southbound towards coventry | Coventry | Coventry | Warning Letter | N/A | ||||
| 13085 | op-snap---monthly-publication-july-2025.pdf | 1137 | 2025-07 | Car | Mercedes-Benz | Silver | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | Warning Letter | N/A | 52.4235908 | -1.5226276 | |||
| 13319 | op-snap---monthly-publication-july-2025.pdf | 1371 | 2025-07 | Pedal Bike | Mercedes-Benz | GLE | Green | Driving without Due Care and Attention | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 13325 | op-snap---monthly-publication-july-2025.pdf | 1377 | 2025-07 | Pedal Bike | Mercedes-Benz | Coach | White | Driving without Due Care and Attention | None | Stoney Stanton Lane | Stoney Stanton Lane | Coventry | Coventry | Warning Letter | N/A | 52.4211068 | -1.4966527 | ||
| 13435 | op-snap---monthly-publication-july-2025.pdf | 1487 | 2025-07 | Pedal Bike | Mercedes-Benz | A180 | Grey | Cause vehicle to be left in a dangerous position | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 13635 | op-snap---monthly-publication-july-2025.pdf | 1687 | 2025-07 | Pedestrian | Mercedes-Benz | e220 | White | Cause vehicle to be left in a dangerous position | None | Chace Avenue | Chace Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3865575 | -1.4715848 | ||
| 13947 | op-snap---monthly-publication-july-2025.pdf | 1999 | 2025-07 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Earlsdon Avenue | Earlsdon Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4047134 | -1.5351834 | ||
| 13961 | op-snap---monthly-publication-july-2025.pdf | 2013 | 2025-07 | Car | Mercedes-Benz | c220 | Black | Driving without Due Care and Attention | None | A444 | A444 | Coventry | Coventry | Warning Letter | N/A | ||||
| 15429 | op-snap---monthly-publication-june-2025.pdf | 1358 | 2025-06 | Pedal Bike | Mercedes-Benz | A45 | Black | Driving without Due Care and Attention | None | A429 Kenilworth Road | Kenilworth Road | Coventry | Coventry | Warning Letter | N/A | 52.3833298 | -1.5379214 | ||
| 18917 | op-snap---monthly-publication-may-2025.pdf | 279 | 2025-05 | Car | Mercedes-Benz | Van | White | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | Warning Letter | N/A | 52.4085943 | -1.4943275 | ||
| 19283 | op-snap---monthly-publication-may-2025.pdf | 645 | 2025-05 | Car | Mercedes-Benz | CLS350 | Black | Driving without Due Care and Attention | None | Gibbett Hill Road | Gibbett Hill Road | Coventry | Coventry | Warning Letter | N/A | 52.3744413 | -1.553746 | ||
| 19682 | op-snap---monthly-publication-may-2025.pdf | 1044 | 2025-05 | Pedal Bike | Mercedes-Benz | GLB | Silver | Driving without Due Care and Attention | None | Broad lane | Broad lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 19714 | op-snap---monthly-publication-may-2025.pdf | 1076 | 2025-05 | Pedal Bike | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Binley Road | Binley Road | Coventry | Coventry | Warning Letter | N/A | 52.4070602 | -1.4732469 | ||
| 20183 | op-snap---monthly-publication-may-2025.pdf | 1545 | 2025-05 | Pedal Bike | Mercedes-Benz | A class | Black | Driving without Due Care and Attention | none | Ansty Road | Ansty Road | Coventry | Coventry | Warning Letter | N/A | 52.4205675 | -1.4520187 | ||
| 20273 | op-snap---monthly-publication-may-2025.pdf | 1635 | 2025-05 | Pedal Bike | Mercedes-Benz | A 180 | Silver | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | 52.4074716 | -1.5620671 | ||
| 20297 | op-snap---monthly-publication-may-2025.pdf | 1659 | 2025-05 | Pedestrian | Mercedes-Benz | c220 | Silver | Cause vehicle to be left in a dangerous position | None | Parkgate Road | Parkgate Road | Coventry | Coventry | Warning Letter | N/A | 52.445796 | -1.5148141 | ||
| 20437 | op-snap---monthly-publication-may-2025.pdf | 1799 | 2025-05 | Car | Mercedes-Benz | A200 | White | Driving without Due Care and Attention | None | Moseley Avenue, Coventry | Moseley Avenue, Coventry | Coventry | Coventry | Warning Letter | N/A | 52.4141818 | -1.5315277 | ||
| 475 | op-snap---monthly-publication-april-2025.pdf | 474 | 2025-04 | Car | Mercedes-Benz | E-class | Black | Driving without Reasonable Consideration | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Warning Letter | N/A | 52.4274335 | -1.5002381 | ||
| 17230 | op-snap---monthly-publication-march-2025.pdf | 987 | 2025-03 | Car | Mercedes-Benz | A200 | White | Contravening a Red Traffic Light | None | Broad Lane | Broad Lane | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4074716 | -1.5620671 | |
| 17652 | op-snap---monthly-publication-march-2025.pdf | 1409 | 2025-03 | Car | Mercedes-Benz | cla200 | Black | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4235908 | -1.5226276 | |
| 5538 | op-snap---monthly-publication-february-2025.pdf | 355 | 2025-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Rowleys Green Roundabout | Rowleys Green Roundabout | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4486967 | -1.4991069 | |
| 5809 | op-snap---monthly-publication-february-2025.pdf | 626 | 2025-02 | Pedestrian | Mercedes-Benz | EQC | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5810 | op-snap---monthly-publication-february-2025.pdf | 627 | 2025-02 | Pedestrian | Mercedes-Benz | E220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.3848122 | -1.5204351 | |
| 5917 | op-snap---monthly-publication-february-2025.pdf | 734 | 2025-02 | Pedestrian | Mercedes-Benz | Vito | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gateside Road Coventry | Gateside Road Coventry | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4400759 | -1.4966907 | |
| 6643 | op-snap---monthly-publication-february-2025.pdf | 1460 | 2025-02 | Car | Mercedes-Benz | A200 | Grey | Driving without Reasonable Consideration | None | M6 Junction 2 (Southbound) | M6 Junction 2 (Southbound) | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.676119 | -2.0858425 | |
| 7028 | op-snap---monthly-publication-february-2025.pdf | 1845 | 2025-02 | Pedestrian | Mercedes-Benz | C class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Crescent | Heath Crescent | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4209589 | -1.4822638 | |
| 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 | |
| 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 |
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);