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'}
56 rows where council_area = "Dudley", disposal = "Warning Letter" and offence = "Cause vehicle to be left in a dangerous position" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, latitude, longitude
vehicle_make 18
reporter_transport_mode 3
- Pedestrian 41
- Car 14
- Pedal Bike 1
offence 1
- Cause vehicle to be left in a dangerous position · 56 ✖
disposal 1
- Warning Letter · 56 ✖
council_area 1
- Dudley · 56 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 20961 | op-snap---monthly-publication-november-2025.pdf | 503 | 2025-11 | Car | Honda | civic | Red | Cause vehicle to be left in a dangerous position | None | regend road | Regend Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 21045 | op-snap---monthly-publication-november-2025.pdf | 587 | 2025-11 | Car | Renault | clio | Orange | Cause vehicle to be left in a dangerous position | None | hobbs road | Hobbs Road | Dudley | Dudley | Warning Letter | N/A | 52.5225246 | -2.0764333 | ||
| 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 | ||||
| 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 | ||
| 21333 | op-snap---monthly-publication-november-2025.pdf | 875 | 2025-11 | Pedestrian | BMW | 520d | Black | 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 | ||
| 21344 | op-snap---monthly-publication-november-2025.pdf | 886 | 2025-11 | Pedestrian | Nissan | qashqai | Blue | Cause vehicle to be left in a dangerous position | None | regend road | Regend Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 21373 | op-snap---monthly-publication-november-2025.pdf | 915 | 2025-11 | Pedestrian | Nissan | xtrail | Grey | Cause vehicle to be left in a dangerous position | None | barclay road | Barclay Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 21375 | op-snap---monthly-publication-november-2025.pdf | 917 | 2025-11 | Pedestrian | Vauxhall | corsa | 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 | ||
| 21429 | op-snap---monthly-publication-november-2025.pdf | 971 | 2025-11 | Pedestrian | Ford | Ecosport | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenuew | Gayfield Avenuew | Dudley | Dudley | Warning Letter | N/A | ||||
| 21464 | op-snap---monthly-publication-november-2025.pdf | 1006 | 2025-11 | Pedestrian | Vauxhall | vivaro | White | Cause vehicle to be left in a dangerous position | None | northway | Northway | Dudley | Dudley | Warning Letter | N/A | 52.548846 | -2.1297656 | ||
| 21748 | op-snap---monthly-publication-november-2025.pdf | 1290 | 2025-11 | Pedestrian | Nissan | note | Grey | Cause vehicle to be left in a dangerous position | None | halesowen road | Halesowen Road | Dudley | Dudley | Warning Letter | N/A | 52.4624413 | -2.0175178 | ||
| 21845 | op-snap---monthly-publication-november-2025.pdf | 1387 | 2025-11 | Pedestrian | Nissan | micra | Silver | Cause vehicle to be left in a dangerous position | None | regent road | Regent Road | Dudley | Dudley | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 22007 | op-snap---monthly-publication-november-2025.pdf | 1549 | 2025-11 | Pedestrian | Audi | A4 | Grey | Cause vehicle to be left in a dangerous position | None | Kingswood Road | Kingswood Road | Dudley | Dudley | Warning Letter | N/A | 52.4876186 | -2.175395 | ||
| 23277 | op-snap---monthly-publication-october-2025.pdf | 1227 | 2025-10 | Pedestrian | Seat | leon | Silver | Cause vehicle to be left in a dangerous position | None | gayfield avennue | Gayfield Avennue | Dudley | Dudley | Warning Letter | N/A | ||||
| 23362 | op-snap---monthly-publication-october-2025.pdf | 1312 | 2025-10 | Car | Hyundai | santa fe | Green | Cause vehicle to be left in a dangerous position | None | school furnace lane | School Furnace Lane | Dudley | Dudley | Warning Letter | N/A | 52.4536097 | -2.0510246 | ||
| 23387 | op-snap---monthly-publication-october-2025.pdf | 1337 | 2025-10 | Pedestrian | Vauxhall | Astra | 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 | ||
| 25381 | op-snap---monthly-publication-september-2025.pdf | 1600 | 2025-09 | Pedestrian | Vauxhall | corsa | Silver | Cause vehicle to be left in a dangerous position | None | castle road west | Castle Road West | Dudley | Dudley | Warning Letter | N/A | 52.5258312 | -2.0768625 | ||
| 25561 | op-snap---monthly-publication-september-2025.pdf | 1780 | 2025-09 | Car | Ford | Grey | Cause vehicle to be left in a dangerous position | None | roberts road | Roberts Road | Dudley | Dudley | Warning Letter | N/A | 52.5246963 | -2.1150892 | |||
| 13260 | op-snap---monthly-publication-july-2025.pdf | 1312 | 2025-07 | Car | Volvo | XC60 | Grey | Cause vehicle to be left in a dangerous position | None | Roberts St | Roberts Street | Dudley | Dudley | Warning Letter | N/A | 52.5213135 | -2.1197042 | ||
| 13261 | op-snap---monthly-publication-july-2025.pdf | 1313 | 2025-07 | Car | Volkswagen | T-Roc | Grey | Cause vehicle to be left in a dangerous position | None | Roberts St | Roberts Street | Dudley | Dudley | Warning Letter | N/A | 52.5213135 | -2.1197042 | ||
| 13278 | op-snap---monthly-publication-july-2025.pdf | 1330 | 2025-07 | Car | Ford | Fiesta | Blue | Cause vehicle to be left in a dangerous position | None | Sevendwellings View | Sevendwellings View | Dudley | Dudley | Warning Letter | N/A | 52.4740529 | -2.1270111 | ||
| 13619 | op-snap---monthly-publication-july-2025.pdf | 1671 | 2025-07 | Pedestrian | Nissan | Qashqai | Red | Cause vehicle to be left in a dangerous position | None | Gayfield Road | Gayfield Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 13620 | op-snap---monthly-publication-july-2025.pdf | 1672 | 2025-07 | Pedestrian | Vauxhall | Mokka | White | Cause vehicle to be left in a dangerous position | None | Gayfield Road | Gayfield Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 13621 | op-snap---monthly-publication-july-2025.pdf | 1673 | 2025-07 | Pedestrian | Citroen | DS3 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Road | Gayfield Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 13631 | op-snap---monthly-publication-july-2025.pdf | 1683 | 2025-07 | Pedal Bike | Hyundai | i20 | Red | Cause vehicle to be left in a dangerous position | None | Oak Road | Oak Road | Dudley | Dudley | Warning Letter | N/A | 52.5208353 | -2.0860104 | ||
| 13659 | op-snap---monthly-publication-july-2025.pdf | 1711 | 2025-07 | Car | Nissan | X-Trail | Black | Cause vehicle to be left in a dangerous position | None | strourbridge ring road | Strourbridge Ring Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 13660 | op-snap---monthly-publication-july-2025.pdf | 1712 | 2025-07 | Car | Ford | Focus | Black | Cause vehicle to be left in a dangerous position | None | Stourbridge Ring Road | Stourbridge Ring Road | Dudley | Dudley | Warning Letter | N/A | 52.4590366 | -2.1465735 | ||
| 13822 | op-snap---monthly-publication-july-2025.pdf | 1874 | 2025-07 | Pedestrian | Renault | Captur | Grey | Cause vehicle to be left in a dangerous position | None | Jews Lane | Jews Lane | Dudley | Dudley | Warning Letter | N/A | 52.5253568 | -2.1128168 | ||
| 13823 | op-snap---monthly-publication-july-2025.pdf | 1875 | 2025-07 | Pedestrian | Ford | S max | Grey | Cause vehicle to be left in a dangerous position | None | Jews Lane | Jews Lane | Dudley | Dudley | Warning Letter | N/A | 52.5253568 | -2.1128168 | ||
| 13870 | op-snap---monthly-publication-july-2025.pdf | 1922 | 2025-07 | Pedestrian | Vauxhall | zafira | Blue | Cause vehicle to be left in a dangerous position | No Insurance | Basons LAne | Basons LAne | Dudley | Dudley | Warning Letter | N/A | ||||
| 13871 | op-snap---monthly-publication-july-2025.pdf | 1923 | 2025-07 | Pedestrian | Mercedes-Benz | E320 | Blue | Cause vehicle to be left in a dangerous position | None | Dog Kennel Lane | Dog Kennel Lane | Dudley | Dudley | Warning Letter | N/A | 52.4453509 | -2.045968 | ||
| 13872 | op-snap---monthly-publication-july-2025.pdf | 1924 | 2025-07 | Pedestrian | Ford | transit | White | Cause vehicle to be left in a dangerous position | None | Dog Kennel Lane | Dog Kennel Lane | Dudley | Dudley | Warning Letter | N/A | 52.4453509 | -2.045968 | ||
| 16071 | op-snap---monthly-publication-june-2025.pdf | 2000 | 2025-06 | Pedestrian | Land Rover | Range Rover | White | Cause vehicle to be left in a dangerous position | None | Yew Tree Lane | Yew Tree Lane | Dudley | Dudley | Warning Letter | N/A | 52.5474844 | -2.0788584 | ||
| 16079 | op-snap---monthly-publication-june-2025.pdf | 2008 | 2025-06 | Car | Volvo | XC60 | White | Cause vehicle to be left in a dangerous position | None | Sweetpool Lane | Sweetpool Lane | Dudley | Dudley | Warning Letter | N/A | ||||
| 16118 | op-snap---monthly-publication-june-2025.pdf | 2047 | 2025-06 | Car | Fiat | punto | Grey | Cause vehicle to be left in a dangerous position | None | Roberts Street | Roberts Street | Dudley | Dudley | Warning Letter | N/A | 52.5213135 | -2.1197042 | ||
| 16120 | op-snap---monthly-publication-june-2025.pdf | 2049 | 2025-06 | Pedestrian | Ford | Focus | Black | Cause vehicle to be left in a dangerous position | None | Ham Lane | Ham Lane | Dudley | Dudley | Warning Letter | N/A | 52.5092904 | -2.1617173 | ||
| 16231 | op-snap---monthly-publication-june-2025.pdf | 2160 | 2025-06 | Pedestrian | Citroen | DS3 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 16233 | op-snap---monthly-publication-june-2025.pdf | 2162 | 2025-06 | Car | Fiat | Punto | 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 | ||
| 20279 | op-snap---monthly-publication-may-2025.pdf | 1641 | 2025-05 | Pedestrian | Mercedes-Benz | CLA | Black | Cause vehicle to be left in a dangerous position | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 20318 | op-snap---monthly-publication-may-2025.pdf | 1680 | 2025-05 | Car | Volkswagen | Sharan | Black | Cause vehicle to be left in a dangerous position | None | Church Street | Church Street | Dudley | Dudley | Warning Letter | N/A | 52.4737921 | -2.0330173 | ||
| 20366 | op-snap---monthly-publication-may-2025.pdf | 1728 | 2025-05 | Car | Nissan | Juke | Red | Cause vehicle to be left in a dangerous position | none | Clarence St | Clarence Street | Dudley | Dudley | Warning Letter | N/A | 52.5297896 | -2.1178425 | ||
| 5633 | op-snap---monthly-publication-february-2025.pdf | 450 | 2025-02 | Pedestrian | Citroen | DS | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 6040 | op-snap---monthly-publication-february-2025.pdf | 857 | 2025-02 | Pedestrian | Ford | Mondeo | Silver | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 6043 | op-snap---monthly-publication-february-2025.pdf | 860 | 2025-02 | Pedestrian | Audi | A3 | Grey | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 6044 | op-snap---monthly-publication-february-2025.pdf | 861 | 2025-02 | Pedestrian | Ford | Focus | Red | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4693896 | -2.1251602 | |
| 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 |
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);