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'}
169 rows where council_area = "Sandwell", disposal = "Warning Letter" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 30
offence 21
- Driving without Due Care and Attention 67
- Contravening a Red Traffic Light 26
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 14
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 9
- Cause vehicle to be left in a dangerous position 8
- Driving without Reasonable Consideration 8
- Misc - Non Traffic Offences 5
- Using a Mobile Phone Whilst Driving 5
- Cause unnecessary obstruction by motor vehicle 4
- 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
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Prohibited vehicle in offside lane of motorway 2
- 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 equipment 1
- No Insurance 1
- Use a vehicle / cycle on a road and contravene a l 1
month 14
reporter_transport_mode 1
- Car · 169 ✖
disposal 1
- Warning Letter · 169 ✖
council_area 1
- Sandwell · 169 ✖
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 22380 | op-snap---monthly-publication-october-2025.pdf | 330 | 2025-10 | Car | Land Rover | Range Rover | Grey | Contravening a Red Traffic Light | None | Holyhead Road Wednesbury | Holyhead Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5567885 | -2.035824 | ||
| 22394 | op-snap---monthly-publication-october-2025.pdf | 344 | 2025-10 | Car | Citroen | DS3.. | Black | Driving without Due Care and Attention | None | Station Road | Station Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4774652 | -2.0337514 | ||
| 22665 | op-snap---monthly-publication-october-2025.pdf | 615 | 2025-10 | Car | Citroen | C4 | Grey | Driving without Due Care and Attention | None | M5 SB J1 | M5 Southbound J1 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 22791 | op-snap---monthly-publication-october-2025.pdf | 741 | 2025-10 | Car | Ford | Kuga | Blue | Driving without Due Care and Attention | None | B4135 | B4135 | Sandwell | Sandwell | Warning Letter | N/A | 52.4904552 | -1.9428634 | ||
| 22834 | op-snap---monthly-publication-october-2025.pdf | 784 | 2025-10 | Car | Lexus | CT 200H | Grey | Driving without Due Care and Attention | None | Mucklow Hill | Mucklow Hill | Sandwell | Sandwell | Warning Letter | N/A | 52.4791745 | -2.0681676 | ||
| 22966 | op-snap---monthly-publication-october-2025.pdf | 916 | 2025-10 | Car | Nissan | Micra | White | Driving without Due Care and Attention | None | Tipton Road | Tipton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5157798 | -2.0437191 | ||
| 23220 | op-snap---monthly-publication-october-2025.pdf | 1170 | 2025-10 | Car | Toyota | Yaris | Red | 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 | ||
| 23312 | op-snap---monthly-publication-october-2025.pdf | 1262 | 2025-10 | Car | Volkswagen | Tiguan | Grey | 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 | ||
| 23313 | op-snap---monthly-publication-october-2025.pdf | 1263 | 2025-10 | Car | Volkswagen | polo | Black | 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 | ||
| 23314 | op-snap---monthly-publication-october-2025.pdf | 1264 | 2025-10 | Car | Porsche | macan | Blue | 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 | ||
| 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 | ||||
| 23673 | op-snap---monthly-publication-october-2025.pdf | 1623 | 2025-10 | Car | Renault | Megane | Black | No Insurance | None | Newton Road | Newton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5428224 | -1.9569444 | ||
| 23769 | op-snap---monthly-publication-october-2025.pdf | 1719 | 2025-10 | Car | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Ethel St | Ethel Street | Sandwell | Sandwell | Warning Letter | N/A | 52.4782487 | -1.9729502 | ||
| 23843 | op-snap---monthly-publication-september-2025.pdf | 62 | 2025-09 | Car | BMW | M3.. | White | Contravening a Red Traffic Light | None | Windmill Lane Smethwick | Windmill Lane Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.4877204 | -1.9592449 | ||
| 24086 | op-snap---monthly-publication-september-2025.pdf | 305 | 2025-09 | Car | BMW | 116 | Silver | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4702299 | -1.9948976 | ||
| 24235 | op-snap---monthly-publication-september-2025.pdf | 454 | 2025-09 | Car | Ford | Mondeo | Grey | Contravening a Red Traffic Light | No vehicle excise licence | New Road | New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5330407 | -2.0376222 | ||
| 24329 | op-snap---monthly-publication-september-2025.pdf | 548 | 2025-09 | Car | Ford | Fiesta van | White | Use a vehicle / cycle on a road and contravene a l | ocal traffic order other Nthoanne parking | Londonderry Lane, Smethwick | Londonderry Lane, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.4910374 | -1.9779539 | ||
| 24412 | op-snap---monthly-publication-september-2025.pdf | 631 | 2025-09 | Car | Citroen | Berlingo | White | Contravening a Red Traffic Light | None | Churchbridge, Oldbury | Churchbridge, Oldbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5013 | -2.018225 | ||
| 24419 | op-snap---monthly-publication-september-2025.pdf | 638 | 2025-09 | Car | Ford | Edge | Black | Contravening a Red Traffic Light | None | Oldbury / Birmingham Road | Oldbury / Birmingham Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5028033 | -2.0111743 | ||
| 24508 | op-snap---monthly-publication-september-2025.pdf | 727 | 2025-09 | Car | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Galton Bridge | Galton Bridge | Sandwell | Sandwell | Warning Letter | N/A | 52.5019236 | -1.9793875 | ||
| 24621 | op-snap---monthly-publication-september-2025.pdf | 840 | 2025-09 | Car | Mazda | 3.. | Silver | Misc - Non Traffic Offences | None | Newton Road | Newton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5428224 | -1.9569444 | ||
| 25005 | op-snap---monthly-publication-september-2025.pdf | 1224 | 2025-09 | Car | Ford | Ranger | Black | Prohibited vehicle in offside lane of motorway | None | M5 northbound junction 2 | M5 northbound junction 2 | Sandwell | Sandwell | Warning Letter | N/A | 52.4945433 | -2.0190848 | ||
| 25124 | op-snap---monthly-publication-september-2025.pdf | 1343 | 2025-09 | Car | Vauxhall | Astra | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Adams Street | Adams Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5206781 | -2.0082357 | ||
| 25401 | op-snap---monthly-publication-september-2025.pdf | 1620 | 2025-09 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 25501 | op-snap---monthly-publication-september-2025.pdf | 1720 | 2025-09 | Car | Volkswagen | Transporter | White | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.5489715 | -1.9927402 | ||
| 25620 | op-snap---monthly-publication-september-2025.pdf | 1839 | 2025-09 | Car | Audi | s4 | Grey | 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 | ||
| 2037 | op-snap---monthly-publication-august-2025.pdf | 12 | 2025-08 | Car | Cupra | Ateca | Grey | Driving without Due Care and Attention | None | Sedgley Road | Sedgley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5219813 | -2.0581691 | ||
| 2185 | op-snap---monthly-publication-august-2025.pdf | 160 | 2025-08 | Car | Ford | Puma | White | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 2195 | op-snap---monthly-publication-august-2025.pdf | 170 | 2025-08 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Churchbridge | Churchbridge | Sandwell | Sandwell | Warning Letter | N/A | 52.4938109 | -2.0217545 | ||
| 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 | ||
| 2408 | op-snap---monthly-publication-august-2025.pdf | 383 | 2025-08 | Car | Nissan | Juke | Silver | Driving without Reasonable Consideration | None | M5 Motorway SB | M5 Motorway Southbound | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 2448 | op-snap---monthly-publication-august-2025.pdf | 423 | 2025-08 | Car | Vauxhall | Astra | Red | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4702299 | -1.9948976 | ||
| 2850 | op-snap---monthly-publication-august-2025.pdf | 825 | 2025-08 | Car | Audi | A1 | Black | Misc - Non Traffic Offences | No vehicle excise licence | M5 | M5 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3016 | op-snap---monthly-publication-august-2025.pdf | 991 | 2025-08 | Car | Land Rover | Defender | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Telford Way | Telford Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5041001 | -1.9769903 | ||
| 3076 | op-snap---monthly-publication-august-2025.pdf | 1051 | 2025-08 | Car | Seat | Ibiza | Blue | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4702299 | -1.9948976 | ||
| 3211 | op-snap---monthly-publication-august-2025.pdf | 1186 | 2025-08 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | Gospel End Road | Gospel End Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5493259 | -2.0471207 | ||
| 3388 | op-snap---monthly-publication-august-2025.pdf | 1363 | 2025-08 | Car | Ford | Transit | Silver | Prohibited vehicle in offside lane of motorway | None | M5 Southbound Jct 1 to Jct 2 | M5 Southbound Junction 1 to Junction 2 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||
| 3745 | op-snap---monthly-publication-august-2025.pdf | 1720 | 2025-08 | Car | Toyota | CHR | Blue | Driving without Due Care and Attention | None | Sycamore Road | Sycamore Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5506385 | -2.0128406 | ||
| 3748 | op-snap---monthly-publication-august-2025.pdf | 1723 | 2025-08 | Car | Ford | Focus | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | M5 near junction 1 | M5 near junction 1 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3768 | op-snap---monthly-publication-august-2025.pdf | 1743 | 2025-08 | Car | Audi | A4 | Black | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Great Western Way | Great Western Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5312261 | -2.0341031 | ||
| 3787 | op-snap---monthly-publication-august-2025.pdf | 1762 | 2025-08 | Car | Audi | A5 | Black | VRM fails to conform to Regulations | None | Horseley Heath | Horseley Heath | Sandwell | Sandwell | Warning Letter | N/A | 52.5292478 | -2.0422614 | ||
| 12310 | op-snap---monthly-publication-july-2025.pdf | 362 | 2025-07 | Car | Toyota | Corolla | Blue | Driving without Due Care and Attention | None | M5 Junction 1 Island | M5 Junction 1 Island | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 12713 | op-snap---monthly-publication-july-2025.pdf | 765 | 2025-07 | Car | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | Driving without Due Care and | AWttoeondtisoentton | AWttoeondtisoentton | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 12745 | op-snap---monthly-publication-july-2025.pdf | 797 | 2025-07 | Car | Volkswagen | Golf GTI | Blue | Driving without Due Care and Attention | None | Kenrick Way | Kenrick Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5079468 | -1.9755194 | ||
| 12880 | op-snap---monthly-publication-july-2025.pdf | 932 | 2025-07 | Car | Volvo | Bus | Red | Driving without Due Care and Attention | None | Dudley Road, Tipton | Dudley Road, Tipton | Sandwell | Sandwell | Warning Letter | N/A | 52.5238596 | -2.0740455 | ||
| 12990 | op-snap---monthly-publication-july-2025.pdf | 1042 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | Warning Letter | N/A | |||||
| 13302 | op-snap---monthly-publication-july-2025.pdf | 1354 | 2025-07 | Car | Ford | Mondeo | Green | Cause vehicle to be left in a dangerous position | None | Castle Road West | Castle Road West | Sandwell | Sandwell | Warning Letter | N/A | 52.4686934 | -1.9974957 | ||
| 13315 | op-snap---monthly-publication-july-2025.pdf | 1367 | 2025-07 | Car | Toyota | Corolla | Grey | Cause vehicle to be left in a dangerous position | None | Roberts Street | Roberts Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13317 | op-snap---monthly-publication-july-2025.pdf | 1369 | 2025-07 | Car | Vauxhall | Mokka | Red | Cause vehicle to be left in a dangerous position | None | Roberts Street | Roberts Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13355 | op-snap---monthly-publication-july-2025.pdf | 1407 | 2025-07 | Car | Ford | Puma | Grey | 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 | ||
| 13569 | op-snap---monthly-publication-july-2025.pdf | 1621 | 2025-07 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | Express Way, West Brom | Express Way, West Brom | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13591 | op-snap---monthly-publication-july-2025.pdf | 1643 | 2025-07 | Car | Honda | CR-V | Grey | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Vicarage Road | Vicarage Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5573855 | -2.0133095 | ||
| 13768 | op-snap---monthly-publication-july-2025.pdf | 1820 | 2025-07 | Car | Audi | A4 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | All Saints Way | All Saints Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5344405 | -1.985568 |
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);