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'}
45 rows where disposal = "Warning Letter", month = "2025-05" and vehicle_make = "Mercedes-Benz" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 8
- Driving without Due Care and Attention 16
- Cause vehicle to be left in a dangerous position 9
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 7
- Contravening a Red Traffic Light 6
- Driving without Reasonable Consideration 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Using a Mobile Phone Whilst Driving 2
- Stop a vehicle within pelican pedestrian crossing limits 1
council_area 8
- Birmingham 27
- Coventry 8
- Dudley 3
- Sandwell 2
- Solihull 2
- Out of Force Area 1
- Sutton Coldfield 1
- Wolverhampton 1
reporter_transport_mode 3
- Car 21
- Pedestrian 15
- Pedal Bike 9
vehicle_make 1
- Mercedes-Benz · 45 ✖
month 1
- 2025-05 · 45 ✖
disposal 1
- Warning Letter · 45 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18792 | op-snap---monthly-publication-may-2025.pdf | 154 | 2025-05 | Pedal Bike | Mercedes-Benz | G63.. | Black | Using a Mobile Phone Whilst Driving | None | Masshouse Lane | Masshouse Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4072996 | -1.9273914 | ||
| 18833 | op-snap---monthly-publication-may-2025.pdf | 195 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 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 | ||
| 18937 | op-snap---monthly-publication-may-2025.pdf | 299 | 2025-05 | Pedal Bike | Mercedes-Benz | C220 | White | Driving without Reasonable Consideration | None | Waterfall Lane | Waterfall Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 18996 | op-snap---monthly-publication-may-2025.pdf | 358 | 2025-05 | Pedestrian | Mercedes-Benz | CLA 180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4578511 | -1.9734988 | ||
| 19118 | op-snap---monthly-publication-may-2025.pdf | 480 | 2025-05 | Car | Mercedes-Benz | Sprinter | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 19145 | op-snap---monthly-publication-may-2025.pdf | 507 | 2025-05 | Pedestrian | Mercedes-Benz | Vito | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4616763 | -1.9653016 | ||
| 19221 | op-snap---monthly-publication-may-2025.pdf | 583 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wyatt Road | Wyatt Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5664484 | -1.7828946 | ||
| 19224 | op-snap---monthly-publication-may-2025.pdf | 586 | 2025-05 | Car | Mercedes-Benz | 310 | Blue | Driving without Due Care and Attention | None | Heath Street | Heath Street | Sandwell | Sandwell | Warning Letter | n/a | 52.4919542 | -1.9467735 | ||
| 19242 | op-snap---monthly-publication-may-2025.pdf | 604 | 2025-05 | Car | Mercedes-Benz | C200.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 19416 | op-snap---monthly-publication-may-2025.pdf | 778 | 2025-05 | Car | Mercedes-Benz | E220. | Black | Driving without Due Care and Attention | None | M42 | M42 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19491 | op-snap---monthly-publication-may-2025.pdf | 853 | 2025-05 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Drews Lane | Drews Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5005017 | -1.8353248 | |||
| 19584 | op-snap---monthly-publication-may-2025.pdf | 946 | 2025-05 | Car | Mercedes-Benz | A Class | Black | Driving without Due Care and Attention | None | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | Warning Letter | N/A | 52.4167172 | -1.7990388 | ||
| 19646 | op-snap---monthly-publication-may-2025.pdf | 1008 | 2025-05 | Car | Mercedes-Benz | C class | White | Driving without Reasonable Consideration | None | Little Merry Hill | Little Merry Hill | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 19653 | op-snap---monthly-publication-may-2025.pdf | 1015 | 2025-05 | Car | Mercedes-Benz | SLC 200 | Black | Contravening a Red Traffic Light | None | Hampton Lane | Hampton Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4381761 | -1.6508099 | ||
| 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 | ||
| 19743 | op-snap---monthly-publication-may-2025.pdf | 1105 | 2025-05 | Pedestrian | Mercedes-Benz | C class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Agnes Road | Street Agnes Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19749 | op-snap---monthly-publication-may-2025.pdf | 1111 | 2025-05 | Pedestrian | Mercedes-Benz | Van | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barn lane | Barn lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4307492 | -1.8828708 | ||
| 19867 | op-snap---monthly-publication-may-2025.pdf | 1229 | 2025-05 | Pedestrian | Mercedes-Benz | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street Smethwick | High Street Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.4955266 | -1.9697742 | ||
| 20126 | op-snap---monthly-publication-may-2025.pdf | 1488 | 2025-05 | Pedestrian | Mercedes-Benz | E350 | White | Driving without Due Care and Attention | None | Greswolde Road | Greswolde Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4455718 | -1.861478 | ||
| 20150 | op-snap---monthly-publication-may-2025.pdf | 1512 | 2025-05 | Car | Mercedes-Benz | GLC | White | Driving without Due Care and Attention | None | A34 Perry Barr | Perry Barr | Birmingham | Birmingham | Warning Letter | N/A | 52.516903 | -1.9012399 | ||
| 20158 | op-snap---monthly-publication-may-2025.pdf | 1520 | 2025-05 | Pedestrian | Mercedes-Benz | sprinter | White | Cause vehicle to be left in a dangerous position | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4506039 | -1.8463952 | ||
| 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 | ||
| 20198 | op-snap---monthly-publication-may-2025.pdf | 1560 | 2025-05 | Car | Mercedes-Benz | A Class | Blue | Driving without Due Care and Attention | none | M6 Motorway, Northbound | M6 Motorway, Northbound | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 20208 | op-snap---monthly-publication-may-2025.pdf | 1570 | 2025-05 | Car | Mercedes-Benz | GLB200 | White | Cause vehicle to be left in a dangerous position | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 20213 | op-snap---monthly-publication-may-2025.pdf | 1575 | 2025-05 | Car | Mercedes-Benz | C250.. | Blue | Cause vehicle to be left in a dangerous position | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4967329 | -1.8097462 | ||
| 20237 | op-snap---monthly-publication-may-2025.pdf | 1599 | 2025-05 | Pedal Bike | Mercedes-Benz | c200 | Silver | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 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 | ||
| 20279 | op-snap---monthly-publication-may-2025.pdf | 1641 | 2025-05 | Pedestrian | Mercedes-Benz | CLA | Black | Cause vehicle to be left in a dangerous position | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 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 | ||
| 20306 | op-snap---monthly-publication-may-2025.pdf | 1668 | 2025-05 | Car | Mercedes-Benz | c220 | Black | Driving without Due Care and Attention | None | LadyPool Road | Lady Pool Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 20314 | op-snap---monthly-publication-may-2025.pdf | 1676 | 2025-05 | Pedestrian | Mercedes-Benz | White | Contravening a Red Traffic Light | None | St Bernard Road | Street Bernard Road | Solihull | Solihull | Warning Letter | N/A | |||||
| 20323 | op-snap---monthly-publication-may-2025.pdf | 1685 | 2025-05 | Pedal Bike | Mercedes-Benz | A160 | Red | Cause vehicle to be left in a dangerous position | None | Sycamore Road | Sycamore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5398019 | -1.8455792 | ||
| 20327 | op-snap---monthly-publication-may-2025.pdf | 1689 | 2025-05 | Car | Mercedes-Benz | E250 | Black | Driving without Due Care and Attention | None | Holt Fleet | Holt Fleet | Out of Force Area | Out of Force Area | Warning Letter | N/A | ||||
| 20328 | op-snap---monthly-publication-may-2025.pdf | 1690 | 2025-05 | Pedestrian | Mercedes-Benz | c220 | Black | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20335 | op-snap---monthly-publication-may-2025.pdf | 1697 | 2025-05 | Pedal Bike | Mercedes-Benz | C200 | Grey | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Warning Letter | N/A | 52.459563 | -1.946922 | ||
| 20345 | op-snap---monthly-publication-may-2025.pdf | 1707 | 2025-05 | Pedestrian | Mercedes-Benz | GLA 220 | Grey | Cause vehicle to be left in a dangerous position | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 20349 | op-snap---monthly-publication-may-2025.pdf | 1711 | 2025-05 | Car | Mercedes-Benz | GLC | Black | Cause vehicle to be left in a dangerous position | None | North Road | North Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4461384 | -1.9346351 | ||
| 20363 | op-snap---monthly-publication-may-2025.pdf | 1725 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause vehicle to be left in a dangerous position | None | Ramsay Road | Ramsay Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5172724 | -1.8763076 | ||
| 20378 | op-snap---monthly-publication-may-2025.pdf | 1740 | 2025-05 | Car | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 20428 | op-snap---monthly-publication-may-2025.pdf | 1790 | 2025-05 | Car | Mercedes-Benz | A180 | Black | Contravening a Red Traffic Light | None | Watery Lane | Watery Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4767102 | -1.8756358 | ||
| 20430 | op-snap---monthly-publication-may-2025.pdf | 1792 | 2025-05 | Car | Mercedes-Benz | e200 | Grey | Contravening a Red Traffic Light | None | Walsall Road, Perry Barr | Walsall Road, Perry Barr | Birmingham | Birmingham | Warning Letter | N/A | 52.5290137 | -1.9098939 | ||
| 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 |
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);