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'}
77 rows where council_area = "Dudley" and month = "2025-01" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 25
offence 15
- Driving without Due Care and Attention 27
- Driving without Reasonable Consideration 13
- Cause vehicle to be left in a dangerous position 10
- Contravening a Red Traffic Light 10
- Dangerous Driving 5
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Using a Mobile Phone Whilst Driving 2
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 1
- Drive motor vehicle on a footpath/ Unnecessary Obstruction 1
- Driver not in position to have Proper Control 1
- Misc - Non Traffic Offences 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
- Use vehicle on a road without valid test certificate 1
- fail to comply with a non endorsable traffic sign 1
disposal 6
- Fixed Penalty 23
- Court 17
- Warning Letter 16
- Education 13
- NFA 7
- RTC - Actioned 1
reporter_transport_mode 5
- Car 36
- Pedestrian 26
- Pedal Bike 10
- Other 4
- Lorry 1
month 1
- 2025-01 · 77 ✖
council_area 1
- Dudley · 77 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8901 | op-snap---monthly-publication-january-2025.pdf | 9 | 2025-01 | Pedestrian | BMW | M3 | Black | Driving without Due Care and Attention | None | WATERFRONT CAR PARK | Waterfront Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 8910 | op-snap---monthly-publication-january-2025.pdf | 18 | 2025-01 | Pedal Bike | Volkswagen | POLO | Black | Driving without Due Care and Attention | None | HEATH LANE | Heath Lane | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.4495524 | -2.1459067 | |
| 8911 | op-snap---monthly-publication-january-2025.pdf | 19 | 2025-01 | Pedal Bike | Mazda | CX5 | Black | Driving without Reasonable Consideration | None | BROADWAY | Broadway | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.5147445 | -2.0836401 | |
| 8918 | op-snap---monthly-publication-january-2025.pdf | 26 | 2025-01 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | No Insurance | Pedmore Road | Pedmore Road | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4897451 | -2.1069141 | |
| 8947 | op-snap---monthly-publication-january-2025.pdf | 55 | 2025-01 | Pedestrian | Ford | Mustang | Blue | Driving without Due Care and Attention | None | Grey 7 Car park, Waterfront Merry Hill | Grey 7 Car park, Waterfront Merry Hill | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 8977 | op-snap---monthly-publication-january-2025.pdf | 85 | 2025-01 | Pedestrian | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 8985 | op-snap---monthly-publication-january-2025.pdf | 93 | 2025-01 | Car | BMW | 320D SPORT | Silver | Dangerous Driving | No Insurance | A461 DUDLEY PORT | A461 Dudley Port | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5137817 | -2.0633457 | |
| 8996 | op-snap---monthly-publication-january-2025.pdf | 104 | 2025-01 | Pedestrian | BMW | COMPETITION | Blue | Driving without Due Care and Attention | None | MERRYHILL CENTRE CAR PARK 7 | Merryhill Centre Car Park 7 | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9000 | op-snap---monthly-publication-january-2025.pdf | 108 | 2025-01 | Pedestrian | BMW | COMPETITION | Blue | Driving without Due Care and Attention | VRM fails to conform to Regulations | MERRYHILL CENTRE CAR PARK 7 | Merryhill Centre Car Park 7 | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 9027 | op-snap---monthly-publication-january-2025.pdf | 135 | 2025-01 | Pedal Bike | BMW | 11D | White | Driving without Reasonable Consideration | None | The Broadway | The Broadway | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.515445 | -2.0885791 | |
| 9103 | op-snap---monthly-publication-january-2025.pdf | 211 | 2025-01 | Pedestrian | Mercedes-Benz | Dropside lorry | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cot Lane, Kingswinford | Cot Lane, Kingswinford | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4939289 | -2.1730601 | |
| 9128 | op-snap---monthly-publication-january-2025.pdf | 236 | 2025-01 | Car | Citroen | Space Tourer | Orange | Driving without Due Care and Attention | None | Highpark Avenue, Stourbridge | Highpark Avenue, Stourbridge | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4536084 | -2.1694631 | |
| 9154 | op-snap---monthly-publication-january-2025.pdf | 262 | 2025-01 | Car | Mercedes-Benz | A180 | White | Driving without Reasonable Consideration | None | Victoria Road R/A at Park lane East | Victoria Road R/A at Park lane East | Dudley | Dudley | Education | N/A | Yes - Via Email | |||
| 9158 | op-snap---monthly-publication-january-2025.pdf | 266 | 2025-01 | Pedal Bike | BMW | ? | White | Driving without Due Care and Attention | None | Birmingham Street, Stourbridge | Birmingham Street, Stourbridge | Dudley | Dudley | NFA | No VRM | Yes - Via Email | 52.4571139 | -2.1359828 | |
| 9174 | op-snap---monthly-publication-january-2025.pdf | 282 | 2025-01 | Other | BMW | 318D | Silver | Driving without Due Care and Attention | None | Grey 7 Car Park, Waterfront Way, Merry Hill | Grey 7 Car Park, Waterfront Way, Merry Hill | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 9233 | op-snap---monthly-publication-january-2025.pdf | 341 | 2025-01 | Car | Peugeot | Allure | Red | Driving without Due Care and Attention | None | Worcester Street roundabout | Worcester Street roundabout | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9250 | op-snap---monthly-publication-january-2025.pdf | 358 | 2025-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9251 | op-snap---monthly-publication-january-2025.pdf | 359 | 2025-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9252 | op-snap---monthly-publication-january-2025.pdf | 360 | 2025-01 | Pedestrian | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9253 | op-snap---monthly-publication-january-2025.pdf | 361 | 2025-01 | Pedestrian | BMW | 118 | Red | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9254 | op-snap---monthly-publication-january-2025.pdf | 362 | 2025-01 | Pedestrian | Skoda | Citigo | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9269 | op-snap---monthly-publication-january-2025.pdf | 377 | 2025-01 | Car | Vauxhall | Vivaro | Red | Drive motor vehicle on a footpath/ Unnecessary Obstruction | None | Firs Road | Firs Road | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4950857 | -2.159268 | |
| 9270 | op-snap---monthly-publication-january-2025.pdf | 378 | 2025-01 | Pedestrian | BMW | 1 SERIES | Grey | Dangerous Driving | None | WATERFRONT MAIN CAR PARK | Waterfront Main Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9307 | op-snap---monthly-publication-january-2025.pdf | 415 | 2025-01 | Car | N/K | Dangerous Driving | None | COPPICE LANE | Coppice Lane | Dudley | Dudley | RTC - Actioned | N/A | Yes - Via Email | 52.4781025 | -2.098027 | |||
| 9324 | op-snap---monthly-publication-january-2025.pdf | 432 | 2025-01 | Car | BMW | 116 D | White | Driving without Reasonable Consideration | None | High Street A491 | High Street A491 | Dudley | Dudley | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4790749 | -2.1233254 | |
| 9328 | op-snap---monthly-publication-january-2025.pdf | 436 | 2025-01 | Other | BMW | 320d | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Prospect Street, Tipton | Prospect Street, Tipton | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 9338 | op-snap---monthly-publication-january-2025.pdf | 446 | 2025-01 | Other | Vauxhall | Vivaro | Red | Use vehicle on a road without valid test certificate | None | Firs Road, Kingswinford | Firs Road, Kingswinford | Dudley | Dudley | NFA | No Offence | Yes - Via Email | 52.4950857 | -2.159268 | |
| 9350 | op-snap---monthly-publication-january-2025.pdf | 458 | 2025-01 | Car | Audi | E-Tron | White | Driving without Due Care and Attention | None | Kidderminster Road | Kidderminster Road | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.5000055 | -2.1844503 | |
| 9384 | op-snap---monthly-publication-january-2025.pdf | 492 | 2025-01 | Pedestrian | Ford | Fiesta | Black | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 9396 | op-snap---monthly-publication-january-2025.pdf | 504 | 2025-01 | Car | Volkswagen | PASSAT | Black | Driving without Due Care and Attention | None | Park Road | Park Road | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4566333 | -2.1646355 | |
| 9401 | op-snap---monthly-publication-january-2025.pdf | 509 | 2025-01 | Car | Nissan | QASHQUI | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | DUDDLEY ROAD | Duddley Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | |||
| 9408 | op-snap---monthly-publication-january-2025.pdf | 516 | 2025-01 | Car | Yamaha | YS 125 | Red | Driving without Due Care and Attention | None | High Street, Kingswinford | High Street, Kingswinford | Dudley | Dudley | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4975687 | -2.1672039 | |
| 9422 | op-snap---monthly-publication-january-2025.pdf | 530 | 2025-01 | Pedal Bike | Vauxhall | MOVANO | White | Driving without Reasonable Consideration | None | HAGLEY ROAD, STOURBRIDGE | Hagley Road, Stourbridge | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.4357078 | -2.1323185 | |
| 9425 | op-snap---monthly-publication-january-2025.pdf | 533 | 2025-01 | Car | Skoda | RAPID | Silver | Using a Mobile Phone Whilst Driving | NONE | DUDLEY PORT | Dudley Port | Dudley | Dudley | NFA | No Offence | Yes - Via Email | 52.524461 | -2.0492538 | |
| 9542 | op-snap---monthly-publication-january-2025.pdf | 650 | 2025-01 | Car | Land Rover | Evoque | Black | Contravening a Red Traffic Light | Driving without Due Care and Attention | Cradley Road, Netherton | Cradley Road, Netherton | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4877241 | -2.0818998 | |
| 9557 | op-snap---monthly-publication-january-2025.pdf | 665 | 2025-01 | Car | Volkswagen | Golf | Grey | Dangerous Driving | No Insurance | Cole Street, Netherton | Cole Street, Netherton | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9575 | op-snap---monthly-publication-january-2025.pdf | 683 | 2025-01 | Pedestrian | Volkswagen | Golf | Black | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 9581 | op-snap---monthly-publication-january-2025.pdf | 689 | 2025-01 | Pedestrian | Mercedes-Benz | A200 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 9582 | op-snap---monthly-publication-january-2025.pdf | 690 | 2025-01 | Pedestrian | Mercedes-Benz | A200 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 9585 | op-snap---monthly-publication-january-2025.pdf | 693 | 2025-01 | Pedestrian | Fiat | 500 | Grey | fail to comply with a non endorsable traffic sign | None | Turners Lane | Turners Lane | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4721372 | -2.1243522 | |
| 9586 | op-snap---monthly-publication-january-2025.pdf | 694 | 2025-01 | Car | Seat | Leon | Black | Driving without Reasonable Consideration | No Insurance | Lower City Rd, Tividale | Lower City Road, Tividale | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9591 | op-snap---monthly-publication-january-2025.pdf | 699 | 2025-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Shaw Road | Shaw Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5480002 | -2.0943429 | |
| 9651 | op-snap---monthly-publication-january-2025.pdf | 759 | 2025-01 | Pedal Bike | Volkswagen | Transporter | Grey | Driving without Reasonable Consideration | None | Camp Hill | Camp Hill | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.475022 | -2.1566273 | |
| 9652 | op-snap---monthly-publication-january-2025.pdf | 760 | 2025-01 | Pedal Bike | Volvo | S80 | Silver | Driving without Reasonable Consideration | None | Swindon Road | Swindon Road | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.5003933 | -2.1846445 | |
| 9668 | op-snap---monthly-publication-january-2025.pdf | 776 | 2025-01 | Car | BMW | 430i | White | Contravening a Red Traffic Light | VRM fails to conform to Regulations | High Street, Quarry Bank | High Street, Quarry Bank | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4576453 | -2.1150716 | |
| 9773 | op-snap---monthly-publication-january-2025.pdf | 881 | 2025-01 | Car | Toyota | MPV | White | Driving without Reasonable Consideration | None | Bell Street, Stourbridge | Bell Street, Stourbridge | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.4564393 | -2.1490694 | |
| 9836 | op-snap---monthly-publication-january-2025.pdf | 944 | 2025-01 | Car | Renault | Clio | Black | Contravening a Red Traffic Light | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5478387 | -2.0943116 | |
| 9837 | op-snap---monthly-publication-january-2025.pdf | 945 | 2025-01 | Car | Daf | truck | Black | Contravening a Red Traffic Light | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | NFA | No Offence | Yes - Via Email | 52.5478387 | -2.0943116 | |
| 9871 | op-snap---monthly-publication-january-2025.pdf | 979 | 2025-01 | Car | BMW | 520d | White | Driving without Reasonable Consideration | None | Dudley Port | Dudley Port | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.524461 | -2.0492538 | |
| 9872 | op-snap---monthly-publication-january-2025.pdf | 980 | 2025-01 | Pedestrian | Peugeot | 208 | Blue | Driving without Due Care and Attention | None | Waterfront, Merry Hill | Waterfront, Merry Hill | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9893 | op-snap---monthly-publication-january-2025.pdf | 1001 | 2025-01 | Car | Kia | Niro | Blue | Contravening a Red Traffic Light | None | Skidmore Road | Skidmore Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5501779 | -2.0773101 | |
| 9895 | op-snap---monthly-publication-january-2025.pdf | 1003 | 2025-01 | Car | Mini | Cooper | Silver | Contravening a Red Traffic Light | None | Skidmore Road | Skidmore Road | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5501779 | -2.0773101 | |
| 9898 | op-snap---monthly-publication-january-2025.pdf | 1006 | 2025-01 | Car | BMW | 325 | Black | Driving without Due Care and Attention | None | Waterfront Carpark | Waterfront Carpark | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 9942 | op-snap---monthly-publication-january-2025.pdf | 1050 | 2025-01 | Pedestrian | Honda | Civic | Blue | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 9943 | op-snap---monthly-publication-january-2025.pdf | 1051 | 2025-01 | Lorry | Audi | A5 | White | Driving without Due Care and Attention | No vehicle excise licence | WOOD GREEN ROAD | Wood Green Road | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5206779 | -2.1327904 | |
| 9946 | op-snap---monthly-publication-january-2025.pdf | 1054 | 2025-01 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Grange Lane | Grange Lane | Dudley | Dudley | NFA | No VRM | Yes - Via Email | 52.4505457 | -2.1266938 | |
| 9968 | op-snap---monthly-publication-january-2025.pdf | 1076 | 2025-01 | Pedestrian | Fiat | 500 | White | Contravening a Red Traffic Light | None | A4101 DUDLEY | A4101 Dudley | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5026248 | -2.1092753 | |
| 9976 | op-snap---monthly-publication-january-2025.pdf | 1084 | 2025-01 | Pedal Bike | Vauxhall | Insignia | Red | Driving without Reasonable Consideration | None | Heath Lane | Heath Lane | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4495524 | -2.1459067 | |
| 9987 | op-snap---monthly-publication-january-2025.pdf | 1095 | 2025-01 | Pedestrian | Porsche | Boxter | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Turners Lane | Turners Lane | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4721372 | -2.1243522 | |
| 9997 | op-snap---monthly-publication-january-2025.pdf | 1105 | 2025-01 | Car | Citroen | C1 | Blue | Using a Mobile Phone Whilst Driving | None | Stream Road | Stream Road | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4871725 | -2.1623764 | |
| 9998 | op-snap---monthly-publication-january-2025.pdf | 1106 | 2025-01 | Car | Mg | 3 | White | Driving without Due Care and Attention | None | Camp Hill | Camp Hill | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.475022 | -2.1566273 | |
| 10145 | op-snap---monthly-publication-january-2025.pdf | 1253 | 2025-01 | Pedal Bike | Toyota | Prius | Silver | Driving without Reasonable Consideration | None | Hagley Road, Stourbridge | Hagley Road, Stourbridge | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.4357078 | -2.1323185 | |
| 10156 | op-snap---monthly-publication-january-2025.pdf | 1264 | 2025-01 | Car | Volkswagen | Polo | Black | Driving without Reasonable Consideration | None | Stream Road | Stream Road | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4871725 | -2.1623764 | |
| 10157 | op-snap---monthly-publication-january-2025.pdf | 1265 | 2025-01 | Car | Audi | Q5 | Blue | Misc - Non Traffic Offences | None | Brettell Lane | Brettell Lane | Dudley | Dudley | NFA | No Offence | Yes - Via Email | 52.4706676 | -2.1545486 | |
| 10162 | op-snap---monthly-publication-january-2025.pdf | 1270 | 2025-01 | Pedal Bike | Audi | A5 | Grey | Driving without Due Care and Attention | None | Norton Road, Stourbridge | Norton Road, Stourbridge | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4388442 | -2.1645703 | |
| 10165 | op-snap---monthly-publication-january-2025.pdf | 1273 | 2025-01 | Car | Nissan | JUKE | Yellow | Dangerous Driving | None | BRETTLE LANE | Brettle Lane | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 10204 | op-snap---monthly-publication-january-2025.pdf | 1312 | 2025-01 | Car | Ford | Transit | Black | Stop a vehicle within pelican pedestrian crossing limits | Use vehicle on a road without valid test c | eBrrtiiefircleayte Lane | e Brrtiiefircleayte Lane | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 10209 | op-snap---monthly-publication-january-2025.pdf | 1317 | 2025-01 | Car | BMW | x5 | Black | Driving without Due Care and Attention | None | m5 north Jct 2-3 | m5 north Junction 2-3 | Dudley | Dudley | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 10282 | op-snap---monthly-publication-january-2025.pdf | 1390 | 2025-01 | Pedestrian | BMW | X5 | Black | Cause vehicle to be left in a dangerous position | VRM fails to conform to Regulations | CASTLE ROAD EAST | Castle Road East | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 10317 | op-snap---monthly-publication-january-2025.pdf | 1425 | 2025-01 | Car | Seat | LEON | Silver | Contravening a Red Traffic Light | None | KING STREET | King Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.5095654 | -2.0806912 | |
| 10326 | op-snap---monthly-publication-january-2025.pdf | 1434 | 2025-01 | Pedestrian | Volvo | XC60 | Red | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 10329 | op-snap---monthly-publication-january-2025.pdf | 1437 | 2025-01 | Pedestrian | Mercedes-Benz | A180 | Black | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 10419 | op-snap---monthly-publication-january-2025.pdf | 1527 | 2025-01 | Car | Perodua Myvi | Blue | Driver not in position to have Proper Control | None | Dudley Port | Dudley Port | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.524461 | -2.0492538 | ||
| 10424 | op-snap---monthly-publication-january-2025.pdf | 1532 | 2025-01 | Pedestrian | BMW | X3 | Grey | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 10425 | op-snap---monthly-publication-january-2025.pdf | 1533 | 2025-01 | Pedestrian | Renault | Trafic | White | Cause vehicle to be left in a dangerous position | None | Prospect Street | Prospect Street | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email | 52.4924338 | -2.112525 | |
| 10484 | op-snap---monthly-publication-january-2025.pdf | 1592 | 2025-01 | Car | Dacia | Jogger | White | Contravening a Red Traffic Light | None | Dudley Port | Dudley Port | Dudley | Dudley | Education | N/A | Yes - Via Email | 52.524461 | -2.0492538 | |
| 10510 | op-snap---monthly-publication-january-2025.pdf | 1618 | 2025-01 | Other | BMW | 318D | Blue | Driving without Due Care and Attention | None | The Waterfront Car Park | The Waterfront Car Park | Dudley | Dudley | Fixed Penalty | N/A | Yes - Via Email |
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);