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'}
41 rows where council_area = "Sandwell", disposal = "Warning Letter" and vehicle_make = "Mercedes-Benz" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, offence_location, nfa_rationale, latitude, longitude
month 13
offence 11
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 20
- Driving without Due Care and Attention 7
- Cause vehicle to be left in a dangerous position 5
- Cause unnecessary obstruction by motor vehicle 2
- Contravening a Red Traffic Light 1
- DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
- Drive on hard shoulder 1
- Driving without Reasonable Consideration 1
- Misc - Non Traffic Offences 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
reporter_transport_mode 3
- Pedestrian 29
- Car 11
- Lorry 1
vehicle_make 1
- Mercedes-Benz · 41 ✖
disposal 1
- Warning Letter · 41 ✖
council_area 1
- Sandwell · 41 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8359 | op-snap---monthly-publication-february-2026.pdf | 1106 | 2026-02 | Car | Mercedes-Benz | CLA | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Spon Lane, West Bromwich | Spon Lane, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5151568 | -1.9909305 | ||
| 10694 | op-snap---monthly-publication-january-2026.pdf | 155 | 2026-01 | Pedestrian | Mercedes-Benz | E220 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Road Tividale | Regent Road Tividale | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 10867 | op-snap---monthly-publication-january-2026.pdf | 328 | 2026-01 | Pedestrian | Mercedes-Benz | 330 | White | Misc - Non Traffic Offences | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4722765 | -1.9787531 | ||
| 11117 | op-snap---monthly-publication-january-2026.pdf | 578 | 2026-01 | Car | Mercedes-Benz | GLC 220 | Grey | Driving without Due Care and Attention | None | Birchley Island | Birchley Island | Sandwell | Sandwell | Warning Letter | N/A | 52.4926604 | -2.0216743 | ||
| 3903 | op-snap---monthly-publication-december-2025.pdf | 31 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3928 | op-snap---monthly-publication-december-2025.pdf | 56 | 2025-12 | Pedestrian | Mercedes-Benz | A Class | White | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4680 | op-snap---monthly-publication-december-2025.pdf | 808 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 20892 | op-snap---monthly-publication-november-2025.pdf | 434 | 2025-11 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stanhope Road | Stanhope Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4817557 | -1.9769853 | ||
| 21018 | op-snap---monthly-publication-november-2025.pdf | 560 | 2025-11 | Pedestrian | Mercedes-Benz | C300 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4722765 | -1.9787531 | ||
| 21275 | op-snap---monthly-publication-november-2025.pdf | 817 | 2025-11 | Car | Mercedes-Benz | A CLASS | Grey | Driving without Due Care and Attention | None | Birmingham Road Oldbury | Birmingham Road Oldbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5025832 | -2.0105737 | ||
| 22245 | op-snap---monthly-publication-october-2025.pdf | 195 | 2025-10 | Car | Mercedes-Benz | GLE | Black | Contravening a Red Traffic Light | None | Birchley Island Oldbury | Birchley Island Oldbury | Sandwell | Sandwell | Warning Letter | N/A | 52.4926604 | -2.0216743 | ||
| 23097 | op-snap---monthly-publication-october-2025.pdf | 1047 | 2025-10 | Pedestrian | Mercedes-Benz | AMG GLE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey road | Abbey road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 23098 | op-snap---monthly-publication-october-2025.pdf | 1048 | 2025-10 | Pedestrian | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 23124 | op-snap---monthly-publication-october-2025.pdf | 1074 | 2025-10 | Pedestrian | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 23325 | op-snap---monthly-publication-october-2025.pdf | 1275 | 2025-10 | Car | Mercedes-Benz | G Waggon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bancroft Road | Bancroft Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 23395 | op-snap---monthly-publication-october-2025.pdf | 1345 | 2025-10 | Pedestrian | Mercedes-Benz | A200 | Black | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 23423 | op-snap---monthly-publication-october-2025.pdf | 1373 | 2025-10 | Pedestrian | Mercedes-Benz | E220D | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tiverton Road | Tiverton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4920476 | -1.9612509 | ||
| 23562 | op-snap---monthly-publication-october-2025.pdf | 1512 | 2025-10 | Pedestrian | Mercedes-Benz | GLC | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bromford Lane | Bromford Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.5141069 | -2.003425 | ||
| 23654 | op-snap---monthly-publication-october-2025.pdf | 1604 | 2025-10 | Pedestrian | Mercedes-Benz | A200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | |||
| 24064 | op-snap---monthly-publication-september-2025.pdf | 283 | 2025-09 | Lorry | Mercedes-Benz | A250 | Black | DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable | None | M6 J8 SB | M6 J8 Southbound | Sandwell | Sandwell | Warning Letter | N/A | 52.6760749 | -2.0862582 | ||
| 25365 | op-snap---monthly-publication-september-2025.pdf | 1584 | 2025-09 | Pedestrian | Mercedes-Benz | Viano | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Castle Road East | Castle Road East | Sandwell | Sandwell | Warning Letter | N/A | 52.4687472 | -1.9893922 | ||
| 25616 | op-snap---monthly-publication-september-2025.pdf | 1835 | 2025-09 | Pedestrian | Mercedes-Benz | amg | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 2216 | op-snap---monthly-publication-august-2025.pdf | 191 | 2025-08 | Car | Mercedes-Benz | B Class | Blue | Driving without Due Care and Attention | None | Grove Lane | Grove Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4882564 | -1.949089 | ||
| 3000 | op-snap---monthly-publication-august-2025.pdf | 975 | 2025-08 | Pedestrian | Mercedes-Benz | E200 | White | Driving without Due Care and Attention | None | M5 North | M5 North | Sandwell | Sandwell | Warning Letter | N/A | 52.5274455 | -2.0298903 | ||
| 3439 | op-snap---monthly-publication-august-2025.pdf | 1414 | 2025-08 | Pedestrian | Mercedes-Benz | A180 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 3671 | op-snap---monthly-publication-august-2025.pdf | 1646 | 2025-08 | Car | Mercedes-Benz | CLA45 | Red | Drive on hard shoulder | None | m5 | M5 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3672 | op-snap---monthly-publication-august-2025.pdf | 1647 | 2025-08 | Car | Mercedes-Benz | A180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | mill lane | Mill Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4902082 | -2.0089952 | ||
| 13306 | op-snap---monthly-publication-july-2025.pdf | 1358 | 2025-07 | Pedestrian | Mercedes-Benz | B170 | Black | Cause vehicle to be left in a dangerous position | None | Dog Kennel Lane | Dog Kennel Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4901007 | -1.9986317 | ||
| 15122 | op-snap---monthly-publication-june-2025.pdf | 1051 | 2025-06 | Car | Mercedes-Benz | CLA | Black | Driving without Due Care and Attention | None | M5 J2 | M5 J2 | Sandwell | Sandwell | Warning Letter | N/A | 52.4945433 | -2.0190848 | ||
| 15367 | op-snap---monthly-publication-june-2025.pdf | 1296 | 2025-06 | Pedestrian | Mercedes-Benz | C class | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | Warning Letter | N/A | 52.4687472 | -1.9893922 | ||
| 16092 | op-snap---monthly-publication-june-2025.pdf | 2021 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.5489715 | -1.9927402 | ||
| 16108 | op-snap---monthly-publication-june-2025.pdf | 2037 | 2025-06 | Pedestrian | Mercedes-Benz | Vito | Black | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | Warning Letter | N/A | 52.4687472 | -1.9893922 | ||
| 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 | ||
| 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 | ||
| 16910 | op-snap---monthly-publication-march-2025.pdf | 667 | 2025-03 | Pedestrian | Mercedes-Benz | Black | Driving without Reasonable Consideration | No Insurance | Thimble Mill Lane | Thimble Mill Lane | Sandwell | Sandwell | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | ||||
| 5645 | op-snap---monthly-publication-february-2025.pdf | 462 | 2025-02 | Car | Mercedes-Benz | Benz | Black | Driving without Due Care and Attention | None | Yew Tree Walsall | Yew Tree Walsall | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.559139 | -1.9601491 | |
| 6477 | op-snap---monthly-publication-february-2025.pdf | 1294 | 2025-02 | Pedestrian | Mercedes-Benz | Benz Van | 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 | Yes - Via Email | 52.4955266 | -1.9697742 | |
| 6536 | op-snap---monthly-publication-february-2025.pdf | 1353 | 2025-02 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cranford Street Smethwick | Cranford Street Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.4936011 | -1.9513262 | |
| 6584 | op-snap---monthly-publication-february-2025.pdf | 1401 | 2025-02 | Pedestrian | Mercedes-Benz | C class | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cranford Street, Smethwick | Cranford Street, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.4945899 | -1.9534417 | |
| 6587 | op-snap---monthly-publication-february-2025.pdf | 1404 | 2025-02 | Pedestrian | Mercedes-Benz | A class | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cranford Street, Smethwick | Cranford Street, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.4945899 | -1.9534417 | |
| 10454 | op-snap---monthly-publication-january-2025.pdf | 1562 | 2025-01 | Pedestrian | Mercedes-Benz | GLC 220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clent Road | Clent Road | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.4725947 | -1.9952306 |
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);