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'}
356 rows where council_area = "Dudley" and disposal = "Warning Letter" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 22
- Driving without Due Care and Attention 130
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 87
- Cause vehicle to be left in a dangerous position 56
- Driving without Reasonable Consideration 22
- Contravening a Red Traffic Light 12
- Cause unnecessary obstruction by motor vehicle 10
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 8
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 6
- Using a Mobile Phone Whilst Driving 5
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Driver not in position to have Proper Control 3
- Driving a vehicle wholly or partly on a footpath 2
- VRM fails to conform to Regulations 2
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
- Dangerous Driving 1
- Drive motor vehicle on a footpath/ Unnecessary Obstruction 1
- Duplicate Submission 1
- Keeping a vehicle with registration marks obscured 1
- Misc - Non Traffic Offences 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- Stop a vehicle on pedestrian crossing 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
month 14
reporter_transport_mode 5
- Pedestrian 137
- Car 133
- Other 68
- Pedal Bike 15
- Motorbike 3
disposal 1
- Warning Letter · 356 ✖
council_area 1
- Dudley · 356 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7418 | op-snap---monthly-publication-february-2026.pdf | 165 | 2026-02 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Venture Way | Venture Way | Dudley | Dudley | Warning Letter | N/A | 52.4836603 | -2.1189326 | ||
| 7614 | op-snap---monthly-publication-february-2026.pdf | 361 | 2026-02 | Car | Mg | HS | Red | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Dudley | Dudley | Warning Letter | N/A | 52.4881161 | -2.1199108 | ||
| 7615 | op-snap---monthly-publication-february-2026.pdf | 362 | 2026-02 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | A491 | A491 | Dudley | Dudley | Warning Letter | N/A | ||||
| 7630 | op-snap---monthly-publication-february-2026.pdf | 377 | 2026-02 | Car | Mitsubishi | Outlander | Black | Contravening a Red Traffic Light | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Warning Letter | N/A | 52.5002997 | -2.1081386 | ||
| 7666 | op-snap---monthly-publication-february-2026.pdf | 413 | 2026-02 | Other | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 7742 | op-snap---monthly-publication-february-2026.pdf | 489 | 2026-02 | Car | Vauxhall | Corsa | Orange | Driving without Due Care and Attention | None | High Street, Stourbridge | High Street, Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4570763 | -2.1136199 | ||
| 7802 | op-snap---monthly-publication-february-2026.pdf | 549 | 2026-02 | Pedestrian | Audi | A4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingswood Road | Kingswood Road | Dudley | Dudley | Warning Letter | N/A | 52.4876186 | -2.175395 | ||
| 7936 | op-snap---monthly-publication-february-2026.pdf | 683 | 2026-02 | Other | Volkswagen | Golf | Blue | Duplicate Submission | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8352 | op-snap---monthly-publication-february-2026.pdf | 1099 | 2026-02 | Other | Fiat | 500 | White | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8390 | op-snap---monthly-publication-february-2026.pdf | 1137 | 2026-02 | Other | Audi | A3 | Silver | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8446 | op-snap---monthly-publication-february-2026.pdf | 1193 | 2026-02 | Other | Yamaha | FZS 600 | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8483 | op-snap---monthly-publication-february-2026.pdf | 1230 | 2026-02 | Other | Volkswagen | Lupo | Green | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8484 | op-snap---monthly-publication-february-2026.pdf | 1231 | 2026-02 | Other | Seat | Ibiza | White | Driving without Due Care and Attention | None | Waterfront Main Car Park | Waterfront Main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8682 | op-snap---monthly-publication-february-2026.pdf | 1429 | 2026-02 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | The Broadway Stourbridge | The Broadway Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4411413 | -2.1695219 | ||
| 8736 | op-snap---monthly-publication-february-2026.pdf | 1483 | 2026-02 | Other | Proton | Blue | Driving without Due Care and Attention | None | Gervase Drive | Gervase Drive | Dudley | Dudley | Warning Letter | N/A | 52.5169749 | -2.0827363 | |||
| 8737 | op-snap---monthly-publication-february-2026.pdf | 1484 | 2026-02 | Other | Volkswagen | Taigo | Black | Driving without Due Care and Attention | None | Gervase Drive | Gervase Drive | Dudley | Dudley | Warning Letter | N/A | 52.5169749 | -2.0827363 | ||
| 10552 | op-snap---monthly-publication-january-2026.pdf | 13 | 2026-01 | Other | Audi | A5 | Grey | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10569 | op-snap---monthly-publication-january-2026.pdf | 30 | 2026-01 | Other | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10597 | op-snap---monthly-publication-january-2026.pdf | 58 | 2026-01 | Other | Land Rover | 414.. | Red | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10604 | op-snap---monthly-publication-january-2026.pdf | 65 | 2026-01 | Other | Audi | Q7 | Blue | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10702 | op-snap---monthly-publication-january-2026.pdf | 163 | 2026-01 | Pedestrian | Volkswagen | Touran | Blue | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | Warning Letter | N/A | 52.4721372 | -2.1243522 | ||
| 10736 | op-snap---monthly-publication-january-2026.pdf | 197 | 2026-01 | Pedestrian | Nissan | Juke | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Road | Regent Road | Dudley | Dudley | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 10958 | op-snap---monthly-publication-january-2026.pdf | 419 | 2026-01 | Car | Audi | A3 | grey | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Cinder Bank Island, Netherton | Cinder Bank Island, Netherton | Dudley | Dudley | Warning Letter | N/A | 52.5004694 | -2.0904035 | ||
| 10963 | op-snap---monthly-publication-january-2026.pdf | 424 | 2026-01 | Car | Scania | Tipper | Yellow | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5131355 | -2.0651615 | ||
| 11023 | op-snap---monthly-publication-january-2026.pdf | 484 | 2026-01 | Other | Audi | S3 | Black | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11024 | op-snap---monthly-publication-january-2026.pdf | 485 | 2026-01 | Other | Land Rover | Range Rover | Green | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11025 | op-snap---monthly-publication-january-2026.pdf | 486 | 2026-01 | Other | Land Rover | Defender | Red | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11026 | op-snap---monthly-publication-january-2026.pdf | 487 | 2026-01 | Other | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11028 | op-snap---monthly-publication-january-2026.pdf | 489 | 2026-01 | Other | Suzuki | Vitara | Blue | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11241 | op-snap---monthly-publication-january-2026.pdf | 702 | 2026-01 | Other | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11265 | op-snap---monthly-publication-january-2026.pdf | 726 | 2026-01 | Other | BMW | 318d | Grey | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11266 | op-snap---monthly-publication-january-2026.pdf | 727 | 2026-01 | Other | BMW | 323i | White | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11315 | op-snap---monthly-publication-january-2026.pdf | 776 | 2026-01 | Pedal Bike | Skoda | Fabia | Grey | Driving without Due Care and Attention | None | The Broadway | The Broadway | Dudley | Dudley | Warning Letter | N/A | 52.515445 | -2.0885791 | ||
| 11365 | op-snap---monthly-publication-january-2026.pdf | 826 | 2026-01 | Car | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moor Green Lane | Moor Green Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 11415 | op-snap---monthly-publication-january-2026.pdf | 876 | 2026-01 | Car | Audi | SQ5 | Blue | Driving without Due Care and Attention | None | The Broadwway | The Broadwway | Dudley | Dudley | Warning Letter | N/A | ||||
| 11438 | op-snap---monthly-publication-january-2026.pdf | 899 | 2026-01 | Other | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Waterfront Carpark 7 | Waterfront Carpark 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 11440 | op-snap---monthly-publication-january-2026.pdf | 901 | 2026-01 | Other | Renault | Clio | Blue | Driving without Due Care and Attention | None | Waterfront Carpark 7 | Waterfront Carpark 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 11442 | op-snap---monthly-publication-january-2026.pdf | 903 | 2026-01 | Car | BMW | 220i | Blue | Driving without Due Care and Attention | None | Greenfields | Greenfields | Dudley | Dudley | Warning Letter | N/A | 52.4938043 | -2.1639183 | ||
| 11443 | op-snap---monthly-publication-january-2026.pdf | 904 | 2026-01 | Car | Volkswagen | T Cross | White | Driving without Due Care and Attention | None | Stream Road | Stream Road | Dudley | Dudley | Warning Letter | N/A | 52.4871725 | -2.1623764 | ||
| 11621 | op-snap---monthly-publication-january-2026.pdf | 1082 | 2026-01 | Other | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Main car park dudley | Main car park dudley | Dudley | Dudley | Warning Letter | N/A | 52.4799731 | -2.0985927 | ||
| 3933 | op-snap---monthly-publication-december-2025.pdf | 61 | 2025-12 | Pedestrian | Land Rover | Blue | Cause vehicle to be left in a dangerous position | None | Withymoor Road | Withymoor Road | Dudley | Dudley | Warning Letter | N/A | 52.4871674 | -2.0702998 | |||
| 3944 | op-snap---monthly-publication-december-2025.pdf | 72 | 2025-12 | Pedestrian | BMW | X6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scafell Road | Scafell Road | Dudley | Dudley | Warning Letter | N/A | 52.4592579 | -2.1385749 | ||
| 3945 | op-snap---monthly-publication-december-2025.pdf | 73 | 2025-12 | Pedestrian | Vauxhall | Insignia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scafell Road | Scafell Road | Dudley | Dudley | Warning Letter | N/A | 52.4592579 | -2.1385749 | ||
| 3948 | op-snap---monthly-publication-december-2025.pdf | 76 | 2025-12 | Pedestrian | Mercedes-Benz | E220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Catholic Lane | Catholic Lane | Dudley | Dudley | Warning Letter | N/A | 52.5360259 | -2.125828 | ||
| 3951 | op-snap---monthly-publication-december-2025.pdf | 79 | 2025-12 | Pedestrian | Peugeot | 2008 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Withymoor Road | Withymoor Road | Dudley | Dudley | Warning Letter | N/A | 52.4871674 | -2.0702998 | ||
| 3952 | op-snap---monthly-publication-december-2025.pdf | 80 | 2025-12 | Pedestrian | Land Rover | Defender | Blue | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3953 | op-snap---monthly-publication-december-2025.pdf | 81 | 2025-12 | Pedestrian | Kia | Niro | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3954 | op-snap---monthly-publication-december-2025.pdf | 82 | 2025-12 | Pedestrian | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3955 | op-snap---monthly-publication-december-2025.pdf | 83 | 2025-12 | Pedestrian | Toyota | Avensis | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 3961 | op-snap---monthly-publication-december-2025.pdf | 89 | 2025-12 | Pedestrian | Mercedes-Benz | C220 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingtree road | Huntingtree road | Dudley | Dudley | Warning Letter | N/A | 52.4484682 | -2.0689885 | ||
| 3962 | op-snap---monthly-publication-december-2025.pdf | 90 | 2025-12 | Pedestrian | Renault | Captur | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingree road | Huntingree road | Dudley | Dudley | Warning Letter | N/A | ||||
| 3963 | op-snap---monthly-publication-december-2025.pdf | 91 | 2025-12 | Pedestrian | Volkswagen | Tiguan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Huntingree road | Huntingree road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4027 | op-snap---monthly-publication-december-2025.pdf | 155 | 2025-12 | Pedal Bike | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | A491 Hagley Road | Hagley Road | Dudley | Dudley | Warning Letter | N/A | 52.4514139 | -2.1423625 | ||
| 4069 | op-snap---monthly-publication-december-2025.pdf | 197 | 2025-12 | Car | Kia | Picanto | White | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 4125 | op-snap---monthly-publication-december-2025.pdf | 253 | 2025-12 | Pedestrian | Toyota | Prius | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | |||
| 4184 | op-snap---monthly-publication-december-2025.pdf | 312 | 2025-12 | Car | Lexus | RX | Black | Driving without Due Care and Attention | None | The Boulevard Brierley Hill | The Boulevard Brierley Hill | Dudley | Dudley | Warning Letter | N/A | 52.4788849 | -2.1125394 | ||
| 4231 | op-snap---monthly-publication-december-2025.pdf | 359 | 2025-12 | Pedestrian | Land Rover | Defender | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4255 | op-snap---monthly-publication-december-2025.pdf | 383 | 2025-12 | Pedestrian | Kia | niro | Red | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4300 | op-snap---monthly-publication-december-2025.pdf | 428 | 2025-12 | Pedestrian | Mercedes-Benz | a200 | Black | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4514 | op-snap---monthly-publication-december-2025.pdf | 642 | 2025-12 | Car | Kia | rio | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | silvertrees road | Silvertrees Road | Dudley | Dudley | Warning Letter | N/A | 52.5263871 | -2.0677928 | ||
| 4598 | op-snap---monthly-publication-december-2025.pdf | 726 | 2025-12 | Pedestrian | Peugeot | 308 | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4599 | op-snap---monthly-publication-december-2025.pdf | 727 | 2025-12 | Pedestrian | Volkswagen | touran | Black | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4864 | op-snap---monthly-publication-december-2025.pdf | 992 | 2025-12 | Pedal Bike | Vauxhall | Grandland | Brown | Driving without Due Care and Attention | None | Heath Street, Stourbridge | Heath Street, Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4528944 | -2.152138 | ||
| 4911 | op-snap---monthly-publication-december-2025.pdf | 1039 | 2025-12 | Car | Nissan | Micra | Silver | Contravening a Red Traffic Light | None | New Birmingham Road | New Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5123958 | -2.0585145 | ||
| 4912 | op-snap---monthly-publication-december-2025.pdf | 1040 | 2025-12 | Other | Mercedes-Benz | C-class | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 4939 | op-snap---monthly-publication-december-2025.pdf | 1067 | 2025-12 | Pedestrian | Vauxhall | astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4965 | op-snap---monthly-publication-december-2025.pdf | 1093 | 2025-12 | Car | Vauxhall | Mokka | Black | Contravening a Red Traffic Light | None | Stroubridge Road | Stroubridge Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4998 | op-snap---monthly-publication-december-2025.pdf | 1126 | 2025-12 | Car | Peugeot | 308cc | Red | Driving without Due Care and Attention | None | Pedmore Road | Pedmore Road | Dudley | Dudley | Warning Letter | N/A | 52.4897451 | -2.1069141 | ||
| 5010 | op-snap---monthly-publication-december-2025.pdf | 1138 | 2025-12 | Pedestrian | Hyundai | tucson | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | moat road | Moat Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 5011 | op-snap---monthly-publication-december-2025.pdf | 1139 | 2025-12 | Pedestrian | Audi | a4 | Grey | Cause vehicle to be left in a dangerous position | None | halesowne road | Halesowne Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 5013 | op-snap---monthly-publication-december-2025.pdf | 1141 | 2025-12 | Pedestrian | Vauxhall | astra | Red | Cause vehicle to be left in a dangerous position | None | halesowne road | Halesowne Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 5014 | op-snap---monthly-publication-december-2025.pdf | 1142 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ash street | Ash Street | Dudley | Dudley | Warning Letter | N/A | 52.6194553 | -1.9924281 | ||
| 5025 | op-snap---monthly-publication-december-2025.pdf | 1153 | 2025-12 | Pedestrian | BMW | 520d | Grey | Cause vehicle to be left in a dangerous position | None | regent road | Regent Road | Dudley | Dudley | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 5078 | op-snap---monthly-publication-december-2025.pdf | 1206 | 2025-12 | Car | Volvo | XC40 | Black | Driving without Due Care and Attention | None | Black Country New Road | Black Country New Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 5155 | op-snap---monthly-publication-december-2025.pdf | 1283 | 2025-12 | Pedestrian | Volkswagen | Caddy | Green | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Withymoor Road | Withymoor Road | Dudley | Dudley | Warning Letter | N/A | 52.4871674 | -2.0702998 | ||
| 20551 | op-snap---monthly-publication-november-2025.pdf | 93 | 2025-11 | Motorbike | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Pedmore Road | Pedmore Road | Dudley | Dudley | Warning Letter | N/A | 52.4897451 | -2.1069141 | ||
| 20712 | op-snap---monthly-publication-november-2025.pdf | 254 | 2025-11 | Other | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 20830 | op-snap---monthly-publication-november-2025.pdf | 372 | 2025-11 | Car | Audi | A7 | White | VRM fails to conform to Regulations | None | Sedgley Town Centre | Sedgley Town Centre | Dudley | Dudley | Warning Letter | N/A | ||||
| 20895 | op-snap---monthly-publication-november-2025.pdf | 437 | 2025-11 | Car | Volvo | XC60 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Lane | Grange Lane | Dudley | Dudley | Warning Letter | N/A | 52.4505457 | -2.1266938 | ||
| 20961 | op-snap---monthly-publication-november-2025.pdf | 503 | 2025-11 | Car | Honda | civic | Red | Cause vehicle to be left in a dangerous position | None | regend road | Regend Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 21036 | op-snap---monthly-publication-november-2025.pdf | 578 | 2025-11 | Car | Land Rover | Evoque | White | Stop a vehicle on pedestrian crossing | None | Lower Church Lane | Lower Church Lane | Dudley | Dudley | Warning Letter | N/A | 52.5264111 | -2.0472971 | ||
| 21045 | op-snap---monthly-publication-november-2025.pdf | 587 | 2025-11 | Car | Renault | clio | Orange | Cause vehicle to be left in a dangerous position | None | hobbs road | Hobbs Road | Dudley | Dudley | Warning Letter | N/A | 52.5225246 | -2.0764333 | ||
| 21067 | op-snap---monthly-publication-november-2025.pdf | 609 | 2025-11 | Car | Toyota | corolla | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | hobbs road | Hobbs Road | Dudley | Dudley | Warning Letter | N/A | 52.5225246 | -2.0764333 | ||
| 21082 | op-snap---monthly-publication-november-2025.pdf | 624 | 2025-11 | Car | Honda | Jazz | Blue | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5131355 | -2.0651615 | ||
| 21179 | op-snap---monthly-publication-november-2025.pdf | 721 | 2025-11 | Pedestrian | Toyota | Avenis | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 21180 | op-snap---monthly-publication-november-2025.pdf | 722 | 2025-11 | Pedestrian | Skoda | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | |||
| 21181 | op-snap---monthly-publication-november-2025.pdf | 723 | 2025-11 | Pedestrian | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 21220 | op-snap---monthly-publication-november-2025.pdf | 762 | 2025-11 | Pedestrian | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ash Street | Ash Street | Dudley | Dudley | Warning Letter | N/A | 52.6194553 | -1.9924281 | ||
| 21221 | op-snap---monthly-publication-november-2025.pdf | 763 | 2025-11 | Pedestrian | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ash Street | Ash Street | Dudley | Dudley | Warning Letter | N/A | 52.6194553 | -1.9924281 | ||
| 21230 | op-snap---monthly-publication-november-2025.pdf | 772 | 2025-11 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 21247 | op-snap---monthly-publication-november-2025.pdf | 789 | 2025-11 | Pedestrian | Mercedes-Benz | a180 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Dudley | Dudley | Warning Letter | N/A | 52.4530622 | -2.0800139 | ||
| 21290 | op-snap---monthly-publication-november-2025.pdf | 832 | 2025-11 | Pedestrian | Toyota | prius | Silver | Cause vehicle to be left in a dangerous position | None | tividale hall | Tividale Hall | Dudley | Dudley | Warning Letter | N/A | ||||
| 21299 | op-snap---monthly-publication-november-2025.pdf | 841 | 2025-11 | Other | Toyota | Aygo | blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 21331 | op-snap---monthly-publication-november-2025.pdf | 873 | 2025-11 | Pedestrian | Vauxhall | antara | Grey | Cause vehicle to be left in a dangerous position | None | high street quarry bank | High Street Quarry Bank | Dudley | Dudley | Warning Letter | N/A | 52.4583107 | -2.1169703 | ||
| 21332 | op-snap---monthly-publication-november-2025.pdf | 874 | 2025-11 | Pedestrian | Hyundai | i10 | Grey | Cause vehicle to be left in a dangerous position | None | high street quarry bank | High Street Quarry Bank | Dudley | Dudley | Warning Letter | N/A | 52.4583107 | -2.1169703 | ||
| 21333 | op-snap---monthly-publication-november-2025.pdf | 875 | 2025-11 | Pedestrian | BMW | 520d | Black | Cause vehicle to be left in a dangerous position | None | high street quarry bank | High Street Quarry Bank | Dudley | Dudley | Warning Letter | N/A | 52.4583107 | -2.1169703 | ||
| 21336 | op-snap---monthly-publication-november-2025.pdf | 878 | 2025-11 | Pedestrian | BMW | 320D | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad lane | Broad Lane | Dudley | Dudley | Warning Letter | N/A | 52.6232232 | -2.0137162 | ||
| 21344 | op-snap---monthly-publication-november-2025.pdf | 886 | 2025-11 | Pedestrian | Nissan | qashqai | Blue | Cause vehicle to be left in a dangerous position | None | regend road | Regend Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 21353 | op-snap---monthly-publication-november-2025.pdf | 895 | 2025-11 | Pedestrian | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Market Street | Market Street | Dudley | Dudley | Warning Letter | N/A | 52.4964695 | -2.1680501 | ||
| 21373 | op-snap---monthly-publication-november-2025.pdf | 915 | 2025-11 | Pedestrian | Nissan | xtrail | Grey | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Dudley | Dudley | Warning Letter | N/A |
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);