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'}
325 rows where council_area = "Dudley" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make 28
offence 24
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 113
- Cause vehicle to be left in a dangerous position 86
- Driving without Due Care and Attention 48
- Misc - Non Traffic Offences 22
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 11
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 9
- Stop a vehicle within pelican pedestrian crossing limits 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 6
- Cause unnecessary obstruction by motor vehicle 3
- Contravening a Red Traffic Light 2
- Dangerous Driving 2
- Driving a vehicle wholly or partly on a footpath 2
- Driving without Reasonable Consideration 2
- Motor vehicle fail to comply with solid white line road markings 2
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
- Driver not in position to have Proper Control 1
- MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with a non endorsab 1
- No Insurance 1
- Stop a vehicle on pedestrian crossing 1
- Using a Mobile Phone Whilst Driving 1
- Waiting on a road in a prohibited area 1
- fail to comply with a non endorsable traffic sign 1
month 14
disposal 6
- Warning Letter 137
- NFA 108
- Fixed Penalty 44
- Education 23
- Court 11
- Other Action Taken 2
reporter_transport_mode 1
- Pedestrian · 325 ✖
council_area 1
- Dudley · 325 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7350 | op-snap---monthly-publication-february-2026.pdf | 97 | 2026-02 | Pedestrian | Mercedes-Benz | Sprinter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 7431 | op-snap---monthly-publication-february-2026.pdf | 178 | 2026-02 | Pedestrian | Audi | A4 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 7437 | op-snap---monthly-publication-february-2026.pdf | 184 | 2026-02 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | Mill Street | Mill Street | Dudley | Dudley | Education | N/A | 52.4779239 | -2.1561956 | ||
| 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 | ||
| 7806 | op-snap---monthly-publication-february-2026.pdf | 553 | 2026-02 | Pedestrian | Mercedes-Benz | CLA | White | Cause vehicle to be left in a dangerous position | None | Butchers Lane | Butchers Lane | Dudley | Dudley | Education | N/A | 52.4636446 | -2.0823797 | ||
| 10636 | op-snap---monthly-publication-january-2026.pdf | 97 | 2026-01 | Pedestrian | Porsche | Cayman | Blue | Using a Mobile Phone Whilst Driving | None | Merry Hill Car Park | Merry Hill Car Park | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 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 | ||
| 10742 | op-snap---monthly-publication-january-2026.pdf | 203 | 2026-01 | Pedestrian | Volkswagen | Sharan | Black | Cause vehicle to be left in a dangerous position | None | Gayfield Drive | Gayfield Drive | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 10744 | op-snap---monthly-publication-january-2026.pdf | 205 | 2026-01 | Pedestrian | Skoda | Octavia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Drive | Gayfield Drive | Dudley | Dudley | NFA | Not in Public Interest | ||||
| 10745 | op-snap---monthly-publication-january-2026.pdf | 206 | 2026-01 | Pedestrian | Ford | Smax | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Drive | Gayfield Drive | Dudley | Dudley | NFA | Not in Public Interest | ||||
| 10755 | op-snap---monthly-publication-january-2026.pdf | 216 | 2026-01 | Pedestrian | Peugeot | 3008 | Blue | Driving a vehicle wholly or partly on a footpath | None | Bromley Lane | Bromley Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4893583 | -2.1529025 | ||
| 11054 | op-snap---monthly-publication-january-2026.pdf | 515 | 2026-01 | Pedestrian | Ford | Ranger | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 11055 | op-snap---monthly-publication-january-2026.pdf | 516 | 2026-01 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 11056 | op-snap---monthly-publication-january-2026.pdf | 517 | 2026-01 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 11057 | op-snap---monthly-publication-january-2026.pdf | 518 | 2026-01 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 11059 | op-snap---monthly-publication-january-2026.pdf | 520 | 2026-01 | Pedestrian | Peugeot | 108 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 11060 | op-snap---monthly-publication-january-2026.pdf | 521 | 2026-01 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4693896 | -2.1251602 | ||
| 11220 | op-snap---monthly-publication-january-2026.pdf | 681 | 2026-01 | Pedestrian | Ford | Focus | Black | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11226 | op-snap---monthly-publication-january-2026.pdf | 687 | 2026-01 | Pedestrian | Vauxhall | Astra | Silver | Cause vehicle to be left in a dangerous position | None | Gayfield Ave | Gayfield Ave | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11360 | op-snap---monthly-publication-january-2026.pdf | 821 | 2026-01 | Pedestrian | Kia | Nero | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Regent Road Tividale | Regent Road Tividale | Dudley | Dudley | Education | N/A | 52.5106406 | -2.0559963 | ||
| 11430 | op-snap---monthly-publication-january-2026.pdf | 891 | 2026-01 | Pedestrian | Ford | TRANSIT | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11462 | op-snap---monthly-publication-january-2026.pdf | 923 | 2026-01 | Pedestrian | Ford | fiesta | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Zoar Street | Zoar Street | Dudley | Dudley | Education | N/A | 52.5178733 | -2.1280333 | ||
| 11463 | op-snap---monthly-publication-january-2026.pdf | 924 | 2026-01 | Pedestrian | Ford | C Max | White | Stop a vehicle within pelican pedestrian crossing limits | None | Zoar Street | Zoar Street | Dudley | Dudley | Education | N/A | 52.5178733 | -2.1280333 | ||
| 11465 | op-snap---monthly-publication-january-2026.pdf | 926 | 2026-01 | Pedestrian | Ford | transit | Yellow | Stop a vehicle within pelican pedestrian crossing limits | None | Zoar Street | Zoar Street | Dudley | Dudley | NFA | No Independent Evidence Available | 52.5178733 | -2.1280333 | ||
| 11466 | op-snap---monthly-publication-january-2026.pdf | 927 | 2026-01 | Pedestrian | Toyota | C-HR | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Zoar Street | Zoar Street | Dudley | Dudley | Education | N/A | 52.5178733 | -2.1280333 | ||
| 11677 | op-snap---monthly-publication-january-2026.pdf | 1138 | 2026-01 | Pedestrian | Vauxhall | Grandland X | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 11697 | op-snap---monthly-publication-january-2026.pdf | 1158 | 2026-01 | Pedestrian | Volkswagen | Golf | Silver | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11700 | op-snap---monthly-publication-january-2026.pdf | 1161 | 2026-01 | Pedestrian | Land Rover | Discovery | Black | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11832 | op-snap---monthly-publication-january-2026.pdf | 1293 | 2026-01 | Pedestrian | Vauxhall | Movano | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane, Brierley Hill | Turners Lane, Brierley Hill | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 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 | ||
| 3950 | op-snap---monthly-publication-december-2025.pdf | 78 | 2025-12 | Pedestrian | Renault | Master | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Withymoor Road | Withymoor Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4871674 | -2.0702998 | ||
| 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 | ||||
| 3979 | op-snap---monthly-publication-december-2025.pdf | 107 | 2025-12 | Pedestrian | Audi | q3 | Black | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 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 | |||
| 4199 | op-snap---monthly-publication-december-2025.pdf | 327 | 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 | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | ||
| 4200 | op-snap---monthly-publication-december-2025.pdf | 328 | 2025-12 | Pedestrian | Toyota | Prius | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 4228 | op-snap---monthly-publication-december-2025.pdf | 356 | 2025-12 | Pedestrian | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | |||
| 4229 | op-snap---monthly-publication-december-2025.pdf | 357 | 2025-12 | Pedestrian | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | |||
| 4230 | op-snap---monthly-publication-december-2025.pdf | 358 | 2025-12 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 4253 | op-snap---monthly-publication-december-2025.pdf | 381 | 2025-12 | Pedestrian | Volkswagen | golf | White | Cause vehicle to be left in a dangerous position | VRM fails to conform to Regu | glaatyiofinesld avenue | Glaatyiofinesld Avenue | Dudley | Dudley | Education | N/A | ||||
| 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 | ||
| 4256 | op-snap---monthly-publication-december-2025.pdf | 384 | 2025-12 | Pedestrian | Land Rover | discovery | White | Misc - Non Traffic Offences | None | crankhall lane | Crankhall Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 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 | ||||
| 4336 | op-snap---monthly-publication-december-2025.pdf | 464 | 2025-12 | Pedestrian | BMW | 3 series | White | Misc - Non Traffic Offences | None | regent road | Regent Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.5106406 | -2.0559963 | ||
| 4337 | op-snap---monthly-publication-december-2025.pdf | 465 | 2025-12 | Pedestrian | Audi | a4 | Black | Misc - Non Traffic Offences | None | regendt road | Regendt Road | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 4438 | op-snap---monthly-publication-december-2025.pdf | 566 | 2025-12 | Pedestrian | Mercedes-Benz | a200 | Black | Misc - Non Traffic Offences | None | hafley road | Hafley Road | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 4600 | op-snap---monthly-publication-december-2025.pdf | 728 | 2025-12 | Pedestrian | Volkswagen | tiguan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 4610 | op-snap---monthly-publication-december-2025.pdf | 738 | 2025-12 | Pedestrian | Audi | a3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 4937 | op-snap---monthly-publication-december-2025.pdf | 1065 | 2025-12 | Pedestrian | Skoda | kodiaq | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 4938 | op-snap---monthly-publication-december-2025.pdf | 1066 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 4940 | op-snap---monthly-publication-december-2025.pdf | 1068 | 2025-12 | Pedestrian | Skoda | kodiaq | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4693896 | -2.1251602 | ||
| 4941 | op-snap---monthly-publication-december-2025.pdf | 1069 | 2025-12 | Pedestrian | Ford | focus | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 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 | ||||
| 5012 | op-snap---monthly-publication-december-2025.pdf | 1140 | 2025-12 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | mace street | Mace Street | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 5017 | op-snap---monthly-publication-december-2025.pdf | 1145 | 2025-12 | Pedestrian | Vauxhall | astra | Brown | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | none | aintree way | Aintree Way | Dudley | Dudley | NFA | Misc Inc Crimes | 52.5154873 | -2.1115464 | ||
| 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 | ||
| 5148 | op-snap---monthly-publication-december-2025.pdf | 1276 | 2025-12 | Pedestrian | Mazda | 3 TS2 | Grey | No Insurance | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Fixed Penalty | N/A | 52.5002997 | -2.1081386 | ||
| 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 | ||
| 20536 | op-snap---monthly-publication-november-2025.pdf | 78 | 2025-11 | Pedestrian | Scooter | Black | Driving without Due Care and Attention | None | Sedgley Road West | Sedgley Road West | Dudley | Dudley | NFA | No VRM | 52.5301627 | -2.0799509 | |||
| 20911 | op-snap---monthly-publication-november-2025.pdf | 453 | 2025-11 | Pedestrian | Volvo | XC60 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Lane | Grange Lane | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4505457 | -2.1266938 | ||
| 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 | ||
| 21182 | op-snap---monthly-publication-november-2025.pdf | 724 | 2025-11 | Pedestrian | Nissan | Navara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | No location given | No location given | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 21183 | op-snap---monthly-publication-november-2025.pdf | 725 | 2025-11 | Pedestrian | Volkswagen | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | No location given | No location given | Dudley | Dudley | NFA | No Independent Evidence Available | |||||
| 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 | ||
| 21229 | op-snap---monthly-publication-november-2025.pdf | 771 | 2025-11 | Pedestrian | Ford | Mondeo | White | Misc - Non Traffic Offences | Offence to be added | Gayfield Av | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 21231 | op-snap---monthly-publication-november-2025.pdf | 773 | 2025-11 | Pedestrian | Ford | Kuga | Grey | Misc - Non Traffic Offences | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | NFA | No Offence | 52.4693896 | -2.1251602 | ||
| 21244 | op-snap---monthly-publication-november-2025.pdf | 786 | 2025-11 | Pedestrian | Mercedes-Benz | a200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21245 | op-snap---monthly-publication-november-2025.pdf | 787 | 2025-11 | Pedestrian | Mercedes-Benz | glc 300 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Dudley | Dudley | NFA | No Offence | 52.4530622 | -2.0800139 | ||
| 21246 | op-snap---monthly-publication-november-2025.pdf | 788 | 2025-11 | Pedestrian | Peugeot | partner | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey road | Abbey road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 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 | ||
| 21289 | op-snap---monthly-publication-november-2025.pdf | 831 | 2025-11 | Pedestrian | Skoda | kodiaq | Silver | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 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 | ||||
| 21293 | op-snap---monthly-publication-november-2025.pdf | 835 | 2025-11 | Pedestrian | Skoda | Kodiaq | Gold | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21308 | op-snap---monthly-publication-november-2025.pdf | 850 | 2025-11 | Pedestrian | Seat | Ateca | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21324 | op-snap---monthly-publication-november-2025.pdf | 866 | 2025-11 | Pedestrian | Ford | mondeo | Black | Cause vehicle to be left in a dangerous position | None | silverthorne lane | Silverthorne Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 21328 | op-snap---monthly-publication-november-2025.pdf | 870 | 2025-11 | Pedestrian | Ford | fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | silverthorne lane | Silverthorne Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 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 |
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);