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'}
103 rows where council_area = "Dudley" and disposal = "Court" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence
vehicle_make 25
month 14
offence 9
- Driving without Due Care and Attention 75
- Dangerous Driving 9
- Contravening a Red Traffic Light 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Cause vehicle to be left in a dangerous position 2
- Driving without Reasonable Consideration 2
- Using a Mobile Phone Whilst Driving 2
- Stop a vehicle within pelican pedestrian crossing limits 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
reporter_transport_mode 6
- Car 54
- Other 35
- Pedestrian 11
- Lorry 1
- Motorbike 1
- Pedal Bike 1
disposal 1
- Court · 103 ✖
council_area 1
- Dudley · 103 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7716 | op-snap---monthly-publication-february-2026.pdf | 463 | 2026-02 | Motorbike | Kia | Ceed | Red | Driving without Due Care and Attention | None | Quarry Bank HS | Quarry Bank HS | Dudley | Dudley | Court | N/A | 52.4733135 | -2.1014635 | ||
| 8269 | op-snap---monthly-publication-february-2026.pdf | 1016 | 2026-02 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | No Insurance | Halesowen Road Netherton | Halesowen Road Netherton | Dudley | Dudley | Court | N/A | 52.4904317 | -2.0833451 | ||
| 8503 | op-snap---monthly-publication-february-2026.pdf | 1250 | 2026-02 | Other | BMW | 335d | Black | Driving without Due Care and Attention | No Insurance | Showcase Cinema | Showcase Cinema | Dudley | Dudley | Court | N/A | 52.5169253 | -2.070981 | ||
| 8702 | op-snap---monthly-publication-february-2026.pdf | 1449 | 2026-02 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Highbridge Road | Highbridge Road | Dudley | Dudley | Court | N/A | 52.485907 | -2.0953009 | ||
| 11063 | op-snap---monthly-publication-january-2026.pdf | 524 | 2026-01 | Car | Peugeot | Boxvan | White | Driving without Due Care and Attention | None | New Road, Halesowen | New Road, Halesowen | Dudley | Dudley | Court | N/A | 52.4514694 | -2.0500697 | ||
| 11398 | op-snap---monthly-publication-january-2026.pdf | 859 | 2026-01 | Other | BMW | Z4 | Blue | Driving without Due Care and Attention | No Insurance | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 11504 | op-snap---monthly-publication-january-2026.pdf | 965 | 2026-01 | Car | Seat | leon | White | Driving without Reasonable Consideration | No Insurance | Wrens Nest Road | Wrens Nest Road | Dudley | Dudley | Court | N/A | 52.5253252 | -2.0995407 | ||
| 11688 | op-snap---monthly-publication-january-2026.pdf | 1149 | 2026-01 | Car | Vauxhall | MOKKA | Black | Driving without Due Care and Attention | None | Lodge Lane | Lodge Lane | Dudley | Dudley | Court | N/A | 52.4953929 | -2.1814598 | ||
| 4411 | op-snap---monthly-publication-december-2025.pdf | 539 | 2025-12 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | No Insurance | Sedgley Road | Sedgley Road | Dudley | Dudley | Court | N/A | 52.5329532 | -2.0933963 | ||
| 4982 | op-snap---monthly-publication-december-2025.pdf | 1110 | 2025-12 | Other | Audi | A3 | White | Driving without Due Care and Attention | No Insurance | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 20463 | op-snap---monthly-publication-november-2025.pdf | 5 | 2025-11 | Other | Audi | RS3 | Black | Driving without Due Care and Attention | No Insurance | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 20476 | op-snap---monthly-publication-november-2025.pdf | 18 | 2025-11 | Other | BMW | 225d | White | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Court | N/A | ||||
| 20505 | op-snap---monthly-publication-november-2025.pdf | 47 | 2025-11 | Other | Vauxhall | Corsa | Red | Driving without Due Care and Attention | None | Waterfront Main Car Park | Waterfront Main Car Park | Dudley | Dudley | Court | N/A | ||||
| 20595 | op-snap---monthly-publication-november-2025.pdf | 137 | 2025-11 | Other | Ford | Transit | White | Driving without Due Care and Attention | No vehicle excise licence | Norwood Road | Norwood Road | Dudley | Dudley | Court | N/A | 52.4831397 | -2.1309273 | ||
| 20674 | op-snap---monthly-publication-november-2025.pdf | 216 | 2025-11 | Car | Ford | Kuga | Black | Driving without Due Care and Attention | None | Tipton Road | Tipton Road | Dudley | Dudley | Court | N/A | 52.5198386 | -2.0740876 | ||
| 20714 | op-snap---monthly-publication-november-2025.pdf | 256 | 2025-11 | Other | Hyundai | I10 | Beige | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Court | N/A | ||||
| 20715 | op-snap---monthly-publication-november-2025.pdf | 257 | 2025-11 | Other | Jaguar | Blue | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Court | N/A | |||||
| 20717 | op-snap---monthly-publication-november-2025.pdf | 259 | 2025-11 | Other | Nissan | Micra | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 21093 | op-snap---monthly-publication-november-2025.pdf | 635 | 2025-11 | Car | Nissan | Navara | Silver | Driving without Due Care and Attention | No Insurance | Graingers Lane | Graingers Lane | Dudley | Dudley | Court | N/A | 52.4840702 | -2.0657046 | ||
| 21276 | op-snap---monthly-publication-november-2025.pdf | 818 | 2025-11 | Other | Vauxhall | Corsa | White | Driving without Due Care and Attention | No Insurance | Waterfront | Waterfront | Dudley | Dudley | Court | N/A | 52.4874281 | -2.1117204 | ||
| 21296 | op-snap---monthly-publication-november-2025.pdf | 838 | 2025-11 | Other | Vauxhall | Corsa | Yellow | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 21822 | op-snap---monthly-publication-november-2025.pdf | 1364 | 2025-11 | Pedestrian | Nissan | micra | Silver | Cause vehicle to be left in a dangerous position | None | hillcrest road | Hillcrest Road | Dudley | Dudley | Court | N/A | 52.512245 | -2.0722984 | ||
| 21935 | op-snap---monthly-publication-november-2025.pdf | 1477 | 2025-11 | Other | BMW | M135 | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 22201 | op-snap---monthly-publication-october-2025.pdf | 151 | 2025-10 | Pedestrian | Mazda | 2 | Black | Driving without Due Care and Attention | None | Lower High Street, Stourbridge | Lower High Street, Stourbridge | Dudley | Dudley | Court | N/A | 52.4586871 | -2.1483642 | ||
| 22202 | op-snap---monthly-publication-october-2025.pdf | 152 | 2025-10 | Other | Suzuki | Green | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | |||||
| 22205 | op-snap---monthly-publication-october-2025.pdf | 155 | 2025-10 | Other | SMC | White | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | |||||
| 22218 | op-snap---monthly-publication-october-2025.pdf | 168 | 2025-10 | Car | Ford | Black | Driving without Due Care and Attention | None | A491 High Street Stourbridge | High Street Stourbridge | Dudley | Dudley | Court | N/A | 52.4570763 | -2.1136199 | |||
| 22454 | op-snap---monthly-publication-october-2025.pdf | 404 | 2025-10 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | No Insurance | Vicar Street | Vicar Street | Dudley | Dudley | Court | N/A | 52.5401776 | -2.121708 | ||
| 22497 | op-snap---monthly-publication-october-2025.pdf | 447 | 2025-10 | Car | Ford | Transit | White | Contravening a Red Traffic Light | No Insurance | Moss Grove | Moss Grove | Dudley | Dudley | Court | N/A | 52.5025066 | -2.1702039 | ||
| 22988 | op-snap---monthly-publication-october-2025.pdf | 938 | 2025-10 | Car | Ford | Focus | White | Contravening a Red Traffic Light | No Insurance | Pedmore Road | Pedmore Road | Dudley | Dudley | Court | N/A | 52.4897451 | -2.1069141 | ||
| 23846 | op-snap---monthly-publication-september-2025.pdf | 65 | 2025-09 | Car | Mercedes-Benz | Smart ForTwo | Black | Driving without Due Care and Attention | No Insurance | Roberts Street | Roberts Street | Dudley | Dudley | Court | N/A | 52.5213135 | -2.1197042 | ||
| 23914 | op-snap---monthly-publication-september-2025.pdf | 133 | 2025-09 | Other | Kia | Picanto | Yellow | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 23918 | op-snap---monthly-publication-september-2025.pdf | 137 | 2025-09 | Other | Teyin | Black | Driving without Due Care and Attention | No Insurance | Waterfront Merry Hill | Waterfront Merry Hill | Dudley | Dudley | Court | N/A | 52.4874176 | -2.1129449 | |||
| 23919 | op-snap---monthly-publication-september-2025.pdf | 138 | 2025-09 | Car | Hyundai | Tuscon | Grey | Driving without Due Care and Attention | None | Bridgnorth Road | Bridgnorth Road | Dudley | Dudley | Court | N/A | 52.4603456 | -2.1716457 | ||
| 24314 | op-snap---monthly-publication-september-2025.pdf | 533 | 2025-09 | Other | Mini | One | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 24318 | op-snap---monthly-publication-september-2025.pdf | 537 | 2025-09 | Other | Audi | A1 | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 24546 | op-snap---monthly-publication-september-2025.pdf | 765 | 2025-09 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Bunns Lane | Bunns Lane | Dudley | Dudley | Court | N/A | 52.5111371 | -2.0643295 | ||
| 24843 | op-snap---monthly-publication-september-2025.pdf | 1062 | 2025-09 | Car | BMW | X1 | White | Driving without Due Care and Attention | None | Tame Road | Tame Road | Dudley | Dudley | Court | N/A | 52.4710313 | -2.0126866 | ||
| 24903 | op-snap---monthly-publication-september-2025.pdf | 1122 | 2025-09 | Car | Mercedes-Benz | C220 | White | Driving without Due Care and Attention | None | Cot Lane | Cot Lane | Dudley | Dudley | Court | N/A | 52.4939289 | -2.1730601 | ||
| 2173 | op-snap---monthly-publication-august-2025.pdf | 148 | 2025-08 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Himley Road | Himley Road | Dudley | Dudley | Court | N/A | 52.5142667 | -2.1304764 | ||
| 2238 | op-snap---monthly-publication-august-2025.pdf | 213 | 2025-08 | Other | Fiat | Punto | white | Dangerous Driving | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Court | N/A | ||||
| 2368 | op-snap---monthly-publication-august-2025.pdf | 343 | 2025-08 | Car | BMW | 335 | Black | Dangerous Driving | None | Stourbridge Ring Road | Stourbridge Ring Road | Dudley | Dudley | Court | N/A | 52.4590366 | -2.1465735 | ||
| 2469 | op-snap---monthly-publication-august-2025.pdf | 444 | 2025-08 | Other | Volkswagen | Golf | White | Driving without Due Care and Attention | No Insurance | Car park opposite Odeon Cinema | Car park opposite Odeon Cinema | Dudley | Dudley | Court | N/A | ||||
| 2581 | op-snap---monthly-publication-august-2025.pdf | 556 | 2025-08 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 2724 | op-snap---monthly-publication-august-2025.pdf | 699 | 2025-08 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Duncan Edwards Way | Duncan Edwards Way | Dudley | Dudley | Court | N/A | 52.5047428 | -2.0823754 | ||
| 2888 | op-snap---monthly-publication-august-2025.pdf | 863 | 2025-08 | Other | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 2893 | op-snap---monthly-publication-august-2025.pdf | 868 | 2025-08 | Other | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 3085 | op-snap---monthly-publication-august-2025.pdf | 1060 | 2025-08 | Car | Byd | Atto 3 | Blue | Driving without Due Care and Attention | None | A449 Kidderminster Road, Kingswinford | Kidderminster Road, Kingswinford | Dudley | Dudley | Court | N/A | ||||
| 3114 | op-snap---monthly-publication-august-2025.pdf | 1089 | 2025-08 | Other | Vauxhall | Corsa | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Waterfront Car Park Grey 7 | Waterfront Car Park Grey 7 | Dudley | Dudley | Court | N/A | ||||
| 12134 | op-snap---monthly-publication-july-2025.pdf | 186 | 2025-07 | Car | Toyota | Aygo | Silver | Driving without Due Care and Attention | None | Himley Road | Himley Road | Dudley | Dudley | Court | N/A | 52.5142667 | -2.1304764 | ||
| 12193 | op-snap---monthly-publication-july-2025.pdf | 245 | 2025-07 | Other | Mazda | MX5 | Green | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Court | N/A | 52.4874281 | -2.1117204 | ||
| 12230 | op-snap---monthly-publication-july-2025.pdf | 282 | 2025-07 | Car | Mg | Style | Grey | Driving without Due Care and Attention | None | Pedmore Road | Pedmore Road | Dudley | Dudley | Court | N/A | 52.4897451 | -2.1069141 | ||
| 12401 | op-snap---monthly-publication-july-2025.pdf | 453 | 2025-07 | Car | Ford | Mondeo | Blue | Driving without Due Care and Attention | None | Saltwells Road Netherton | Saltwells Road Netherton | Dudley | Dudley | Court | N/A | 52.4809471 | -2.0826089 | ||
| 12523 | op-snap---monthly-publication-july-2025.pdf | 575 | 2025-07 | Car | Skoda | Fabia | Green | Driving without Due Care and Attention | No Insurance | Tansey Green Road | Tansey Green Road | Dudley | Dudley | Court | N/A | 52.5078472 | -2.1423423 | ||
| 12580 | op-snap---monthly-publication-july-2025.pdf | 632 | 2025-07 | Car | Land Rover | Vogue | Black | Driving without Due Care and Attention | None | Himley Road | Himley Road | Dudley | Dudley | Court | N/A | 52.5142667 | -2.1304764 | ||
| 12589 | op-snap---monthly-publication-july-2025.pdf | 641 | 2025-07 | Other | Citroen | DS3 | White | Dangerous Driving | None | High Street, Stourbridge | High Street, Stourbridge | Dudley | Dudley | Court | N/A | 52.4570763 | -2.1136199 | ||
| 12985 | op-snap---monthly-publication-july-2025.pdf | 1037 | 2025-07 | Car | Mercedes-Benz | C 220. | White | Driving without Due Care and Attention | No Insurance | Commonside (Pensnett) | Commonside (Pensnett) | Dudley | Dudley | Court | N/A | 52.4996591 | -2.1336122 | ||
| 13207 | op-snap---monthly-publication-july-2025.pdf | 1259 | 2025-07 | Other | Honda | 125d | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | No Insurance | Tower Street | Tower Street | Dudley | Dudley | Court | N/A | 52.5112053 | -2.0833165 | ||
| 14194 | op-snap---monthly-publication-june-2025.pdf | 123 | 2025-06 | Pedal Bike | BMW | 320d | White | Driving without Due Care and Attention | None | The Broadway | The Broadway | Dudley | Dudley | Court | N/A | 52.515445 | -2.0885791 | ||
| 14207 | op-snap---monthly-publication-june-2025.pdf | 136 | 2025-06 | Car | Volkswagen | GOLF | Black | Contravening a Red Traffic Light | None | KING STREET | King Street | Dudley | Dudley | Court | N/A | 52.5095654 | -2.0806912 | ||
| 14241 | op-snap---monthly-publication-june-2025.pdf | 170 | 2025-06 | Other | Seat | ATECA | Black | Dangerous Driving | None | WATERFRONT CAR PARK | Waterfront Car Park | Dudley | Dudley | Court | N/A | ||||
| 14349 | op-snap---monthly-publication-june-2025.pdf | 278 | 2025-06 | Car | Volkswagen | Scirocco | White | Driving without Due Care and Attention | No Insurance | Burton Road, towards Sedgley | Burton Road, towards Sedgley | Dudley | Dudley | Court | N/A | ||||
| 15246 | op-snap---monthly-publication-june-2025.pdf | 1175 | 2025-06 | Car | BMW | M4 | White | Contravening a Red Traffic Light | None | NEW B-HAM ROAD | New B-Ham Road | Dudley | Dudley | Court | N/A | ||||
| 15586 | op-snap---monthly-publication-june-2025.pdf | 1515 | 2025-06 | Car | Audi | A5 | Black | Driving without Due Care and Attention | None | Cinder Bank | Cinder Bank | Dudley | Dudley | Court | N/A | 52.4951209 | -2.0924902 | ||
| 19208 | op-snap---monthly-publication-may-2025.pdf | 570 | 2025-05 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Granville Road | Granville Road | Dudley | Dudley | Court | N/A | ||||
| 19332 | op-snap---monthly-publication-may-2025.pdf | 694 | 2025-05 | Car | Mitsubishi | ASX | Red | Driving without Due Care and Attention | No vehicle excise lice | nBceirmingham New Road | n Bceirmingham New Road | Dudley | Dudley | Court | N/A | ||||
| 19455 | op-snap---monthly-publication-may-2025.pdf | 817 | 2025-05 | Car | Mitsubishi | Lancer | Silver | Driving without Due Care and Attention | None | Halesowen Road | Halesowen Road | Dudley | Dudley | Court | N/A | 52.4624413 | -2.0175178 | ||
| 19577 | op-snap---monthly-publication-may-2025.pdf | 939 | 2025-05 | Car | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | No Seat Belt | Narrowboat way | Narrowboat way | Dudley | Dudley | Court | N/A | 52.4914718 | -2.1011818 | ||
| 657 | op-snap---monthly-publication-april-2025.pdf | 656 | 2025-04 | Car | Peugeot | 2008.. | White | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Dudley | Dudley | Court | N/A | 52.4879172 | -2.07401 | ||
| 16352 | op-snap---monthly-publication-march-2025.pdf | 109 | 2025-03 | Other | Toyota | Corolla | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | Use vehicle on a road without valid test certificate | Tower Street | Tower Street | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 16527 | op-snap---monthly-publication-march-2025.pdf | 284 | 2025-03 | Car | Seat | Leon | White | Contravening a Red Traffic Light | No Insurance | Commonside | Commonside | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4931112 | -2.1326078 | |
| 16615 | op-snap---monthly-publication-march-2025.pdf | 372 | 2025-03 | Other | BMW | 118 | White | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 16616 | op-snap---monthly-publication-march-2025.pdf | 373 | 2025-03 | Other | Mercedes-Benz | 180 | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 16717 | op-snap---monthly-publication-march-2025.pdf | 474 | 2025-03 | Car | Ford | KA | Black | Using a Mobile Phone Whilst Driving | Driving without Due Care and Attention | Langley Road | Langley Road | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 16786 | op-snap---monthly-publication-march-2025.pdf | 543 | 2025-03 | Other | Volkswagen | Lupo | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 16791 | op-snap---monthly-publication-march-2025.pdf | 548 | 2025-03 | Other | Skoda | Octavia | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 16793 | op-snap---monthly-publication-march-2025.pdf | 550 | 2025-03 | Pedestrian | Volkswagen | Polo | Grey | Driving without Due Care and Attention | No Insurance | Waterfront Way, Merry Hill (Car Park 7) | Waterfront Way, Merry Hill (Car Park 7) | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 17246 | op-snap---monthly-publication-march-2025.pdf | 1003 | 2025-03 | Car | Volkswagen | Golf | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | No Insurance | High Street, Lye | High Street, Lye | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4568929 | -2.1129422 | |
| 17489 | op-snap---monthly-publication-march-2025.pdf | 1246 | 2025-03 | Pedestrian | Volkswagen | Polo | Silver | Dangerous Driving | None | Waterfront Way (Car Park 7), Brierley Hill | Waterfront Way (Car Park 7), Brierley Hill | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 17770 | op-snap---monthly-publication-march-2025.pdf | 1527 | 2025-03 | Other | BMW | M235i | Black | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4879006 | -2.1188734 | |
| 5724 | op-snap---monthly-publication-february-2025.pdf | 541 | 2025-02 | Car | BMW | X2 | White | Driving without Due Care and Attention | None | Himley Road, Dudley | Himley Road, Dudley | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5142667 | -2.1304764 | |
| 6183 | op-snap---monthly-publication-february-2025.pdf | 1000 | 2025-02 | Car | Renault | Berlingo | White | Driving without Due Care and Attention | None | Hagley Road (Foley Arms) | Hagley Road (Foley Arms) | Dudley | Dudley | Court | N/A | Yes - Via Email | |||
| 6581 | op-snap---monthly-publication-february-2025.pdf | 1398 | 2025-02 | Car | Skoda | Superb | Grey | Driving without Due Care and Attention | None | Coppice Lane Brierley Hill | Coppice Lane Brierley Hill | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4754915 | -2.1075217 | |
| 6704 | op-snap---monthly-publication-february-2025.pdf | 1521 | 2025-02 | Car | Mini | One | Blue | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Brierley Hill Road | Brierley Hill Road | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.4811151 | -2.1456435 | |
| 6778 | op-snap---monthly-publication-february-2025.pdf | 1595 | 2025-02 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Wellington Road | Wellington Road | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5072771 | -2.0954756 | |
| 7233 | op-snap---monthly-publication-february-2025.pdf | 2050 | 2025-02 | Other | Audi | A6 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | No Insurance | Tower Street | Tower Street | Dudley | Dudley | Court | N/A | Yes - Via Email | 52.5112053 | -2.0833165 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 |
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);