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'}
399 rows where council_area = "Sandwell" and disposal = "Warning Letter" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale, witness_contacted
vehicle_make >30
offence 25
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 150
- Driving without Due Care and Attention 80
- Cause vehicle to be left in a dangerous position 57
- Contravening a Red Traffic Light 27
- Cause unnecessary obstruction by motor vehicle 16
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 16
- Driving without Reasonable Consideration 10
- Misc - Non Traffic Offences 7
- Using a Mobile Phone Whilst Driving 6
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
- VRM fails to conform to Regulations 4
- Dangerous Driving 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Driving a vehicle wholly or partly on a footpath 2
- Prohibited vehicle in offside lane of motorway 2
- DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
- Drive on hard shoulder 1
- Driver not in position to have Proper Control 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- No Insurance 1
- Stop a vehicle on pedestrian crossing 1
- Use a vehicle / cycle on a road and contravene a l 1
month 14
reporter_transport_mode 6
- Pedestrian 209
- Car 169
- Pedal Bike 17
- Lorry 2
- Motorbike 1
- Other 1
disposal 1
- Warning Letter · 399 ✖
council_area 1
- Sandwell · 399 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7271 | op-snap---monthly-publication-february-2026.pdf | 18 | 2026-02 | Car | Mazda | 6.. | Red | Contravening a Red Traffic Light | None | Sedgley Road West | Sedgley Road West | Sandwell | Sandwell | Warning Letter | N/A | 52.5296941 | -2.0777252 | ||
| 7374 | op-snap---monthly-publication-february-2026.pdf | 121 | 2026-02 | Car | BMW | X5 | Black | Contravening a Red Traffic Light | None | M5 jct 1 slip | M5 jct 1 slip | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 7486 | op-snap---monthly-publication-february-2026.pdf | 233 | 2026-02 | Pedestrian | BMW | 318.. | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 7488 | op-snap---monthly-publication-february-2026.pdf | 235 | 2026-02 | Pedestrian | Peugeot | Bipper | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 7510 | op-snap---monthly-publication-february-2026.pdf | 257 | 2026-02 | Pedestrian | ssangyong | Blue | Driving a vehicle wholly or partly on a footpath | None | Causeway Green Road | Causeway Green Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4831146 | -2.0169818 | |||
| 7747 | op-snap---monthly-publication-february-2026.pdf | 494 | 2026-02 | Pedestrian | Volkswagen | Troc | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 7997 | op-snap---monthly-publication-february-2026.pdf | 744 | 2026-02 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Crocketts Lane | Crocketts Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.493515 | -1.966302 | ||
| 8088 | op-snap---monthly-publication-february-2026.pdf | 835 | 2026-02 | Car | Hyundai | Tucson | Blue | Driving without Due Care and Attention | None | M5 Jn2 to A4123 | M5 Jn2 to A4123 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8327 | op-snap---monthly-publication-february-2026.pdf | 1074 | 2026-02 | Car | Hyundai | Ioniq 5 | Grey | Driving without Due Care and Attention | None | M5 | M5 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 8633 | op-snap---monthly-publication-february-2026.pdf | 1380 | 2026-02 | Pedestrian | Volkswagen | golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | berwood road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8678 | op-snap---monthly-publication-february-2026.pdf | 1425 | 2026-02 | Car | Skoda | Kamiq | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Throne Road | Throne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4875572 | -2.0284052 | ||
| 8753 | op-snap---monthly-publication-february-2026.pdf | 1500 | 2026-02 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road Wednesbury | Hobbs Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8756 | op-snap---monthly-publication-february-2026.pdf | 1503 | 2026-02 | Pedestrian | Nissan | X-Trail | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hobbs Road Wednesbury | Hobbs Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8782 | op-snap---monthly-publication-february-2026.pdf | 1529 | 2026-02 | Pedestrian | BMW | 118.. | Blue | Driving without Due Care and Attention | None | Perry Street at Potters Lane Wednesbury | Perry Street at Potters Lane Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5004634 | -1.9710382 | ||
| 8791 | op-snap---monthly-publication-february-2026.pdf | 1538 | 2026-02 | Pedestrian | Volkswagen | tiguan | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | moat road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 8792 | op-snap---monthly-publication-february-2026.pdf | 1539 | 2026-02 | Pedestrian | Audi | a3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | moat road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 8839 | op-snap---monthly-publication-february-2026.pdf | 1586 | 2026-02 | Pedestrian | Mg | 3 | Silver | Cause vehicle to be left in a dangerous position | None | Berwood Road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8852 | op-snap---monthly-publication-february-2026.pdf | 1599 | 2026-02 | Car | Land Rover | defender | Black | Cause vehicle to be left in a dangerous position | none | high street, kingswinford | High Street, Kingswinford | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8854 | op-snap---monthly-publication-february-2026.pdf | 1601 | 2026-02 | Pedestrian | Hyundai | i10 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | grainger street | Grainger Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8855 | op-snap---monthly-publication-february-2026.pdf | 1602 | 2026-02 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | grainger street | Grainger Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 10716 | op-snap---monthly-publication-january-2026.pdf | 177 | 2026-01 | Pedestrian | Toyota | Prius | Silver | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | 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 | ||
| 10870 | op-snap---monthly-publication-january-2026.pdf | 331 | 2026-01 | Pedestrian | BMW | X5 | 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 | ||
| 10937 | op-snap---monthly-publication-january-2026.pdf | 398 | 2026-01 | Pedestrian | Peugeot | 3008 GT | 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 | ||
| 11094 | op-snap---monthly-publication-january-2026.pdf | 555 | 2026-01 | Car | Volkswagen | Polo | White | VRM fails to conform to Regulations | None | Birmingham New Road | Birmingham New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5151598 | -2.064717 | ||
| 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 | ||
| 11122 | op-snap---monthly-publication-january-2026.pdf | 583 | 2026-01 | Car | Fiat | Ducato | White | Driving without Due Care and Attention | None | M5 Jct 1 | M5 Junction 1 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 11129 | op-snap---monthly-publication-january-2026.pdf | 590 | 2026-01 | Pedestrian | Toyota | Auris | Red | 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 | ||
| 11143 | op-snap---monthly-publication-january-2026.pdf | 604 | 2026-01 | Pedestrian | Skoda | Octavia | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Victoria Rd Tipton | Victoria Road Tipton | Sandwell | Sandwell | Warning Letter | N/A | 52.5249615 | -2.0589075 | ||
| 11299 | op-snap---monthly-publication-january-2026.pdf | 760 | 2026-01 | Pedestrian | Toyota | Corolla | 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 | ||
| 11536 | op-snap---monthly-publication-january-2026.pdf | 997 | 2026-01 | Car | Chevrolet | Kalos | Blue | Driving without Due Care and Attention | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 11876 | op-snap---monthly-publication-january-2026.pdf | 1337 | 2026-01 | Car | Volvo | Lorry | White | Driving without Due Care and Attention | None | A4034 | A4034 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 11907 | op-snap---monthly-publication-january-2026.pdf | 1368 | 2026-01 | Pedestrian | BMW | X1 | White | Cause vehicle to be left in a dangerous position | None | tividale hall road | Tividale Hall Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5078829 | -2.058238 | ||
| 11926 | op-snap---monthly-publication-january-2026.pdf | 1387 | 2026-01 | Pedestrian | Kia | Silver | Cause vehicle to be left in a dangerous position | None | berwood road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | |||||
| 11927 | op-snap---monthly-publication-january-2026.pdf | 1388 | 2026-01 | Pedestrian | Nissan | juke | Red | Cause vehicle to be left in a dangerous position | None | berwood road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 11932 | op-snap---monthly-publication-january-2026.pdf | 1393 | 2026-01 | Car | Mg | HS | Blue | Cause vehicle to be left in a dangerous position | None | berwood road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 11940 | op-snap---monthly-publication-january-2026.pdf | 1401 | 2026-01 | Pedestrian | Ford | ecosport | White | Cause vehicle to be left in a dangerous position | None | berwood road | Berwood Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3878 | op-snap---monthly-publication-december-2025.pdf | 6 | 2025-12 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3897 | op-snap---monthly-publication-december-2025.pdf | 25 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Cause vehicle to be left in a dangerous position | None | West Bromwich High St | West Bromwich High Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5205106 | -1.9980473 | ||
| 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 | ||
| 3913 | op-snap---monthly-publication-december-2025.pdf | 41 | 2025-12 | Pedestrian | Ghibli | Yellow | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | |||
| 3917 | op-snap---monthly-publication-december-2025.pdf | 45 | 2025-12 | Pedestrian | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | ||
| 3918 | op-snap---monthly-publication-december-2025.pdf | 46 | 2025-12 | Pedestrian | Vauxhall | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | |||
| 3926 | op-snap---monthly-publication-december-2025.pdf | 54 | 2025-12 | Pedestrian | Nissan | Note | 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 | ||
| 3927 | op-snap---monthly-publication-december-2025.pdf | 55 | 2025-12 | Pedestrian | Peugeot | 108 | Red | Cause vehicle to be left in a dangerous position | 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 | ||
| 3929 | op-snap---monthly-publication-december-2025.pdf | 57 | 2025-12 | Pedestrian | Citroen | C1 | Blue | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3930 | op-snap---monthly-publication-december-2025.pdf | 58 | 2025-12 | Pedestrian | Volkswagen | 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 | |||
| 3931 | op-snap---monthly-publication-december-2025.pdf | 59 | 2025-12 | Pedestrian | Ford | Focus | 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 | ||
| 3938 | op-snap---monthly-publication-december-2025.pdf | 66 | 2025-12 | Pedestrian | Toyota | Auris | Grey | 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 | ||
| 3939 | op-snap---monthly-publication-december-2025.pdf | 67 | 2025-12 | Pedestrian | Kia | Niro | Grey | 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 | ||
| 3958 | op-snap---monthly-publication-december-2025.pdf | 86 | 2025-12 | Car | Nissan | Note | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5001925 | -1.9481997 | ||
| 4061 | op-snap---monthly-publication-december-2025.pdf | 189 | 2025-12 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | A41 Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 4123 | op-snap---monthly-publication-december-2025.pdf | 251 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Maple Tree Lane | Maple Tree Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4139 | op-snap---monthly-publication-december-2025.pdf | 267 | 2025-12 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4140 | op-snap---monthly-publication-december-2025.pdf | 268 | 2025-12 | Pedestrian | Mazda | CX-30 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4217 | op-snap---monthly-publication-december-2025.pdf | 345 | 2025-12 | Pedestrian | BMW | 3 Series | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4722765 | -1.9787531 | ||
| 4223 | op-snap---monthly-publication-december-2025.pdf | 351 | 2025-12 | Pedestrian | Mg | HS | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barncroft Road | Barncroft Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5061545 | -2.0570005 | ||
| 4275 | op-snap---monthly-publication-december-2025.pdf | 403 | 2025-12 | Pedestrian | Ford | fiesta | White | 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 | ||
| 4276 | op-snap---monthly-publication-december-2025.pdf | 404 | 2025-12 | Pedestrian | Vauxhall | zafiara | 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 | ||
| 4277 | op-snap---monthly-publication-december-2025.pdf | 405 | 2025-12 | Pedestrian | Peugeot | 5008 | 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 | ||
| 4502 | op-snap---monthly-publication-december-2025.pdf | 630 | 2025-12 | Car | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4503 | op-snap---monthly-publication-december-2025.pdf | 631 | 2025-12 | Car | Audi | A4 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4552 | op-snap---monthly-publication-december-2025.pdf | 680 | 2025-12 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Tollhouse Way | Tollhouse Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5003461 | -1.9782389 | ||
| 4582 | op-snap---monthly-publication-december-2025.pdf | 710 | 2025-12 | Car | Land Rover | Evoque | Black | Contravening a Red Traffic Light | None | West Bromwich Interchange | West Bromwich Interchange | Sandwell | Sandwell | Warning Letter | N/A | 52.5109262 | -1.9753718 | ||
| 4589 | op-snap---monthly-publication-december-2025.pdf | 717 | 2025-12 | Pedestrian | Renault | Clio | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq | Nuiopnmeent | Rosebery Road, Cape Hill | Rosebery Road, Cape Hill | Sandwell | Sandwell | Warning Letter | N/A | 52.4878382 | -1.9570553 | ||
| 4621 | op-snap---monthly-publication-december-2025.pdf | 749 | 2025-12 | Car | BMW | 840i | Black | Driving without Due Care and Attention | None | M5 NB J1 | M5 Northbound J1 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4630 | op-snap---monthly-publication-december-2025.pdf | 758 | 2025-12 | Car | Volkswagen | Scirocco | Black | Driving without Due Care and Attention | None | M6/M5 slip | M6/M5 slip | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 4754 | op-snap---monthly-publication-december-2025.pdf | 882 | 2025-12 | Car | Volkswagen | Passatt | Black | Contravening a Red Traffic Light | None | A41, Smethwick | A41, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.5098817 | -1.9621109 | ||
| 4793 | op-snap---monthly-publication-december-2025.pdf | 921 | 2025-12 | Pedestrian | Toyota | Yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4794 | op-snap---monthly-publication-december-2025.pdf | 922 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4795 | op-snap---monthly-publication-december-2025.pdf | 923 | 2025-12 | Car | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4796 | op-snap---monthly-publication-december-2025.pdf | 924 | 2025-12 | Car | Seat | Leon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4900 | op-snap---monthly-publication-december-2025.pdf | 1028 | 2025-12 | Car | Nissan | Micra | Blue | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 4946 | op-snap---monthly-publication-december-2025.pdf | 1074 | 2025-12 | Car | Peugeot | 3008 | Red | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4947 | op-snap---monthly-publication-december-2025.pdf | 1075 | 2025-12 | Car | Porsche | Cayenne | Silver | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 5135 | op-snap---monthly-publication-december-2025.pdf | 1263 | 2025-12 | Pedal Bike | Ford | Transit | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hadley Street | Hadley Street | Sandwell | Sandwell | Warning Letter | N/A | 52.4863612 | -2.0105376 | ||
| 20600 | op-snap---monthly-publication-november-2025.pdf | 142 | 2025-11 | Car | Vauxhall | Astra | Blue | Driving without Due Care and Attention | None | Sedgley Road | Sedgley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5219813 | -2.0581691 | ||
| 20741 | op-snap---monthly-publication-november-2025.pdf | 283 | 2025-11 | Car | Seat | Leon | Silver | Driving without Due Care and Attention | None | New Birmingham Road | New Birmingham Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5113475 | -2.0508304 | ||
| 20849 | op-snap---monthly-publication-november-2025.pdf | 391 | 2025-11 | Car | Audi | A4 | Grey | Contravening a Red Traffic Light | None | Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 20890 | op-snap---monthly-publication-november-2025.pdf | 432 | 2025-11 | Car | Nissan | Pulsar | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stanthorpe Road | Stanthorpe Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 20891 | op-snap---monthly-publication-november-2025.pdf | 433 | 2025-11 | Pedestrian | Volkswagen | Crafter | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stanthorpe Road | Stanthorpe Road | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 20893 | op-snap---monthly-publication-november-2025.pdf | 435 | 2025-11 | Pedestrian | Kia | Ceed | Blue | 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 | ||
| 20894 | op-snap---monthly-publication-november-2025.pdf | 436 | 2025-11 | Pedestrian | Peugeot | 2008 | Black | 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 | ||
| 20939 | op-snap---monthly-publication-november-2025.pdf | 481 | 2025-11 | Car | BMW | 420D | Grey | Driving without Due Care and Attention | None | Coopers Lane | Coopers Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4921093 | -1.9705849 | ||
| 20941 | op-snap---monthly-publication-november-2025.pdf | 483 | 2025-11 | Car | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4725977 | -1.9684448 | ||
| 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 | ||
| 21252 | op-snap---monthly-publication-november-2025.pdf | 794 | 2025-11 | Car | Hyundai | i10 | Blue | Contravening a Red Traffic Light | None | Nelson Street, West Bromwich | Nelson Street, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5264068 | -1.994278 | ||
| 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 | ||
| 21379 | op-snap---monthly-publication-november-2025.pdf | 921 | 2025-11 | Car | Volkswagen | polo | White | Cause vehicle to be left in a dangerous position | None | titford road | Titford Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4912913 | -2.0143264 | ||
| 21541 | op-snap---monthly-publication-november-2025.pdf | 1083 | 2025-11 | Pedestrian | Ford | focus | Grey | Cause vehicle to be left in a dangerous position | None | apsley road | Apsley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4651624 | -2.0105642 | ||
| 21902 | op-snap---monthly-publication-november-2025.pdf | 1444 | 2025-11 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 22024 | op-snap---monthly-publication-november-2025.pdf | 1566 | 2025-11 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 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 | ||
| 22305 | op-snap---monthly-publication-october-2025.pdf | 255 | 2025-10 | Pedestrian | BMW | M140.. | Yellow | Driving without Due Care and Attention | None | Upper High Street Wednesbury | Upper High Street Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5533962 | -2.0204699 | ||
| 22368 | op-snap---monthly-publication-october-2025.pdf | 318 | 2025-10 | Car | Vauxhall | Crossland | Blue | Drive a vehicle other than on the carriageway of a motorway | None | M6 SB J8 | M6 Southbound J8 | Sandwell | Sandwell | Warning Letter | N/A | 52.6760749 | -2.0862582 |
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);