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'}
49 rows where disposal = "Court" and reporter_transport_mode = "Other" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, offence_location_raw, offence_location, council_area_raw, latitude, longitude
vehicle_make 20
month 12
offence 6
- Driving without Due Care and Attention 36
- Cause vehicle to be left in a dangerous position 3
- Dangerous Driving 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- No Insurance 1
council_area 5
- Dudley 35
- Birmingham 9
- Coventry 3
- Sandwell 1
- Walsall 1
reporter_transport_mode 1
- Other · 49 ✖
disposal 1
- Court · 49 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 8580 | op-snap---monthly-publication-february-2026.pdf | 1327 | 2026-02 | Other | Ford | Transit tipper | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Spring Vale Street, Willenhall | Spring Vale Street, Willenhall | Walsall | Walsall | Court | N/A | ||||
| 11295 | op-snap---monthly-publication-january-2026.pdf | 756 | 2026-01 | Other | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | George Street | George Street | Birmingham | Birmingham | Court | N/A | 52.5048075 | -1.9545728 | ||
| 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 | ||||
| 3969 | op-snap---monthly-publication-december-2025.pdf | 97 | 2025-12 | Other | Toyota | urban | Black | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | glenville drive | Glenville Drive | Coventry | Coventry | Court | N/A | ||||
| 4062 | op-snap---monthly-publication-december-2025.pdf | 190 | 2025-12 | Other | Audi | A5 | Black | Driving without Due Care and Attention | None | Gopsal Street | Gopsal Street | Birmingham | Birmingham | Court | N/A | 52.4837913 | -1.8822888 | ||
| 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 | ||
| 20598 | op-snap---monthly-publication-november-2025.pdf | 140 | 2025-11 | Other | Ford | Transit | Black | Driving without Due Care and Attention | None | The Deers Leap | The Deers Leap | Birmingham | Birmingham | Court | N/A | 52.5601871 | -1.8928907 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 12007 | op-snap---monthly-publication-july-2025.pdf | 59 | 2025-07 | Other | Audi | TT | Black | Driving without Due Care and Attention | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Court | N/A | 52.436155 | -1.5064002 | ||
| 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 | ||
| 12498 | op-snap---monthly-publication-july-2025.pdf | 550 | 2025-07 | Other | Hyundai | i20 | Grey | Driving without Due Care and Attention | No Insurance | Main Car Park, Waterfront | Main Car Park, Waterfront | Sandwell | Sandwell | Court | N/A | ||||
| 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 | ||
| 12877 | op-snap---monthly-publication-july-2025.pdf | 929 | 2025-07 | Other | Volkswagen | Taigo | Black | Driving without Due Care and Attention | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Court | N/A | 52.436155 | -1.5064002 | ||
| 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 | ||
| 14204 | op-snap---monthly-publication-june-2025.pdf | 133 | 2025-06 | Other | BMW | 116.. | Black | Driving without Due Care and Attention | No Insurance | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Court | N/A | 52.5390972 | -1.9319478 | ||
| 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 | ||||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |
| 5885 | op-snap---monthly-publication-february-2025.pdf | 702 | 2025-02 | Other | Toyota | Pruis | White | Cause vehicle to be left in a dangerous position | No Insurance | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 6116 | op-snap---monthly-publication-february-2025.pdf | 933 | 2025-02 | Other | Nissan | Qashqai | White | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 6176 | op-snap---monthly-publication-february-2025.pdf | 993 | 2025-02 | Other | Ford | Focus | White | Cause vehicle to be left in a dangerous position | No Insurance | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 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 | |
| 7246 | op-snap---monthly-publication-february-2025.pdf | 2063 | 2025-02 | Other | Audi | A4 | Black | No Insurance | Use vehicle on a road without valid test certificate | Heather Road | Heather Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4699812 | -1.841443 | |
| 9156 | op-snap---monthly-publication-january-2025.pdf | 264 | 2025-01 | Other | Land Rover | Sport | Black | Driving without Due Care and Attention | None | Glenville Street | Glenville Street | Birmingham | Birmingham | Court | 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);