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'}
36 rows where council_area = "Dudley", month = "2025-06" and offence = "Driving without Due Care and Attention" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, offence_location_raw, offence_location, nfa_rationale, latitude, longitude
vehicle_make 15
- Audi 6
- Ford 6
- BMW 4
- Peugeot 4
- Volkswagen 4
- Mercedes-Benz 3
- Citroen 1
- Honda 1
- Land Rover 1
- Mazda 1
- Mini 1
- Renault 1
- Skoda 1
- Toyota 1
- Vauxhall 1
disposal 5
- NFA 15
- Education 13
- Warning Letter 4
- Court 3
- Fixed Penalty 1
reporter_transport_mode 4
- Car 20
- Other 9
- Pedal Bike 4
- Pedestrian 3
offence 1
- Driving without Due Care and Attention · 36 ✖
month 1
- 2025-06 · 36 ✖
council_area 1
- Dudley · 36 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14134 | op-snap---monthly-publication-june-2025.pdf | 63 | 2025-06 | Pedal Bike | Audi | A1 | White | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Education | N/A | 52.5131355 | -2.0651615 | ||
| 14152 | op-snap---monthly-publication-june-2025.pdf | 81 | 2025-06 | Car | Volkswagen | MOVE | Black | Driving without Due Care and Attention | None | DUDLEY STREET | Dudley Street | Dudley | Dudley | Education | N/A | 52.540391 | -2.1211076 | ||
| 14191 | op-snap---monthly-publication-june-2025.pdf | 120 | 2025-06 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | The Straits | The Straits | Dudley | Dudley | NFA | Misc Inc Crimes | 52.526275 | -2.1436065 | ||
| 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 | ||
| 14208 | op-snap---monthly-publication-june-2025.pdf | 137 | 2025-06 | Car | Ford | FIESTA | Silver | Driving without Due Care and Attention | None | NEW ROWLEY ROAD | New Rowley Road | Dudley | Dudley | NFA | No Offence | 52.4985531 | -2.0680023 | ||
| 14215 | op-snap---monthly-publication-june-2025.pdf | 144 | 2025-06 | Car | BMW | 125 D. | Grey | Driving without Due Care and Attention | None | Church Avenue Amblecotte | Church Avenue Amblecotte | Dudley | Dudley | Education | N/A | ||||
| 14328 | op-snap---monthly-publication-june-2025.pdf | 257 | 2025-06 | Car | Renault | Captur? | Orange | Driving without Due Care and Attention | None | Lutley Lane | Lutley Lane | Dudley | Dudley | NFA | No VRM | 52.4418328 | -2.0871638 | ||
| 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 | ||||
| 14361 | op-snap---monthly-publication-june-2025.pdf | 290 | 2025-06 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | Ring Road Stourbridge | Ring Road Stourbridge | Dudley | Dudley | Education | N/A | 52.455785 | -2.1435102 | ||
| 14367 | op-snap---monthly-publication-june-2025.pdf | 296 | 2025-06 | Car | Honda | CRV | Silver | Driving without Due Care and Attention | None | CASTLEFIELDS | Castlefields | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 14556 | op-snap---monthly-publication-june-2025.pdf | 485 | 2025-06 | Car | Mercedes-Benz | CLA | Grey | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Dudley | Dudley | NFA | No Offence | 52.4514139 | -2.1423625 | ||
| 14557 | op-snap---monthly-publication-june-2025.pdf | 486 | 2025-06 | Car | Peugeot | TEPEE | Black | Driving without Due Care and Attention | None | A4101 | A4101 | Dudley | Dudley | NFA | No Offence | ||||
| 14656 | op-snap---monthly-publication-june-2025.pdf | 585 | 2025-06 | Car | Peugeot | Partner | White | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Dudley | Dudley | NFA | No Offence | 52.4514139 | -2.1423625 | ||
| 14688 | op-snap---monthly-publication-june-2025.pdf | 617 | 2025-06 | Pedal Bike | Peugeot | 2008.. | White | Driving without Due Care and Attention | None | Broadway, Stourbridge | Broadway, Stourbridge | Dudley | Dudley | Education | N/A | 52.4411413 | -2.1695219 | ||
| 14725 | op-snap---monthly-publication-june-2025.pdf | 654 | 2025-06 | Car | Peugeot | 108 | White | Driving without Due Care and Attention | None | Pedmore Road | Pedmore Road | Dudley | Dudley | NFA | Not in Public Interest | 52.4897451 | -2.1069141 | ||
| 14777 | op-snap---monthly-publication-june-2025.pdf | 706 | 2025-06 | Car | BMW | 520D | Grey | Driving without Due Care and Attention | None | Delph Road | Delph Road | Dudley | Dudley | NFA | Outside of 14 DAYS Late Submission | 52.4754271 | -2.1310168 | ||
| 14893 | op-snap---monthly-publication-june-2025.pdf | 822 | 2025-06 | Car | Citroen | Blue | Driving without Due Care and Attention | None | Manor Way | Manor Way | Dudley | Dudley | NFA | No VRM | 52.4493861 | -2.0168307 | |||
| 15013 | op-snap---monthly-publication-june-2025.pdf | 942 | 2025-06 | Car | Audi | TT | Grey | Driving without Due Care and Attention | None | Waterfront Way, Merry Hill | Waterfront Way, Merry Hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | ||||
| 15058 | op-snap---monthly-publication-june-2025.pdf | 987 | 2025-06 | Pedal Bike | Mini | Countryman | Blue | Driving without Due Care and Attention | None | Worcester Street | Worcester Street | Dudley | Dudley | Education | N/A | 52.4507058 | -2.1503743 | ||
| 15180 | op-snap---monthly-publication-june-2025.pdf | 1109 | 2025-06 | Car | Audi | A1 | White | Driving without Due Care and Attention | None | LYE HIGH STREET | Lye High Street | Dudley | Dudley | Fixed Penalty | N/A | 52.4577221 | -2.1148055 | ||
| 15297 | op-snap---monthly-publication-june-2025.pdf | 1226 | 2025-06 | Car | Volkswagen | Crafter | White | Driving without Due Care and Attention | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Education | N/A | 52.5002997 | -2.1081386 | ||
| 15421 | op-snap---monthly-publication-june-2025.pdf | 1350 | 2025-06 | Pedestrian | Ford | Grey | Driving without Due Care and Attention | None | King Street | King Street | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.5095654 | -2.0806912 | |||
| 15542 | op-snap---monthly-publication-june-2025.pdf | 1471 | 2025-06 | Pedestrian | Ford | KA | Red | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 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 | ||
| 15604 | op-snap---monthly-publication-june-2025.pdf | 1533 | 2025-06 | Other | Mercedes-Benz | C220 | Silver | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 15635 | op-snap---monthly-publication-june-2025.pdf | 1564 | 2025-06 | Other | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 15693 | op-snap---monthly-publication-june-2025.pdf | 1622 | 2025-06 | Other | Mazda | 2 | Green | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Education | N/A | 52.4831397 | -2.1309273 | ||
| 15700 | op-snap---monthly-publication-june-2025.pdf | 1629 | 2025-06 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Bridgnorth Road | Bridgnorth Road | Dudley | Dudley | Education | N/A | 52.4603456 | -2.1716457 | ||
| 15727 | op-snap---monthly-publication-june-2025.pdf | 1656 | 2025-06 | Other | Ford | fiesta | Blue | Driving without Due Care and Attention | None | Car Park 7 Merry Hill | Car Park 7 Merry Hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | ||||
| 15746 | op-snap---monthly-publication-june-2025.pdf | 1675 | 2025-06 | Car | Audi | RS3 | Grey | Driving without Due Care and Attention | None | Cementery Lane | Cementery Lane | Dudley | Dudley | Education | N/A | ||||
| 16161 | op-snap---monthly-publication-june-2025.pdf | 2090 | 2025-06 | Other | Toyota | Avensis | Grey | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4831397 | -2.1309273 | ||
| 16177 | op-snap---monthly-publication-june-2025.pdf | 2106 | 2025-06 | Other | Vauxhall | astra | Silver | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4831397 | -2.1309273 | ||
| 16178 | op-snap---monthly-publication-june-2025.pdf | 2107 | 2025-06 | Other | BMW | 320 | White | Driving without Due Care and Attention | None | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | 52.5112053 | -2.0833165 | ||
| 16184 | op-snap---monthly-publication-june-2025.pdf | 2113 | 2025-06 | Pedestrian | Land Rover | Evoque | Grey | Driving without Due Care and Attention | None | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | 52.5112053 | -2.0833165 | ||
| 16186 | op-snap---monthly-publication-june-2025.pdf | 2115 | 2025-06 | Other | Ford | Ka | White | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Warning Letter | N/A | 52.4831397 | -2.1309273 | ||
| 16214 | op-snap---monthly-publication-june-2025.pdf | 2143 | 2025-06 | Other | Mercedes-Benz | a180 | White | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Warning Letter | N/A | 52.4831397 | -2.1309273 |
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);