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'}
162 rows where disposal = "Warning Letter" and reporter_transport_mode = "Other" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 28
offence 16
- Driving without Due Care and Attention 71
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 28
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 18
- Cause vehicle to be left in a dangerous position 8
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 8
- Driving a vehicle wholly or partly on a footpath 5
- Using a Mobile Phone Whilst Driving 5
- Driving without Reasonable Consideration 4
- Misc - Non Traffic Offences 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Drive / Ride / Lead an animal on a footpath 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 2
- Cause unnecessary obstruction by motor vehicle 1
- Duplicate Submission 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
month 14
council_area 11
- Dudley 68
- Birmingham 57
- Sutton Coldfield 9
- Coventry 8
- Metropolitan Borough Of Dudley 7
- Solihull 4
- Metropolitan Borough 3
- Wolverhampton 3
- Halesowen 1
- Sandwell 1
- Walsall 1
reporter_transport_mode 1
- Other · 162 ✖
disposal 1
- Warning Letter · 162 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7255 | op-snap---monthly-publication-february-2026.pdf | 2 | 2026-02 | Other | Fiat | 500 | White | Cause vehicle to be left in a dangerous position | None | Institute Road | Institute Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4334781 | -1.8892337 | ||
| 7274 | op-snap---monthly-publication-february-2026.pdf | 21 | 2026-02 | Other | Mg | ZS | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cambridge Street | Cambridge Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4802932 | -1.9079609 | ||
| 7659 | op-snap---monthly-publication-february-2026.pdf | 406 | 2026-02 | Other | Nissan | Qashqai | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 7666 | op-snap---monthly-publication-february-2026.pdf | 413 | 2026-02 | Other | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 7667 | op-snap---monthly-publication-february-2026.pdf | 414 | 2026-02 | Other | Vauxhall | Zafira | Blue | Drive / Ride / Lead an animal on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 7668 | op-snap---monthly-publication-february-2026.pdf | 415 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 7720 | op-snap---monthly-publication-february-2026.pdf | 467 | 2026-02 | Other | Ford | Kuga | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7936 | op-snap---monthly-publication-february-2026.pdf | 683 | 2026-02 | Other | Volkswagen | Golf | Blue | Duplicate Submission | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 7978 | op-snap---monthly-publication-february-2026.pdf | 725 | 2026-02 | Other | Nissan | Juke | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 7983 | op-snap---monthly-publication-february-2026.pdf | 730 | 2026-02 | Other | Mercedes-Benz | Splinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 8346 | op-snap---monthly-publication-february-2026.pdf | 1093 | 2026-02 | Other | Vauxhall | astra | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | churchill road | Churchill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5529597 | -1.8615015 | ||
| 8352 | op-snap---monthly-publication-february-2026.pdf | 1099 | 2026-02 | Other | Fiat | 500 | White | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8390 | op-snap---monthly-publication-february-2026.pdf | 1137 | 2026-02 | Other | Audi | A3 | Silver | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8446 | op-snap---monthly-publication-february-2026.pdf | 1193 | 2026-02 | Other | Yamaha | FZS 600 | Blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8483 | op-snap---monthly-publication-february-2026.pdf | 1230 | 2026-02 | Other | Volkswagen | Lupo | Green | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8484 | op-snap---monthly-publication-february-2026.pdf | 1231 | 2026-02 | Other | Seat | Ibiza | White | Driving without Due Care and Attention | None | Waterfront Main Car Park | Waterfront Main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 8735 | op-snap---monthly-publication-february-2026.pdf | 1482 | 2026-02 | Other | Hyundai | i10 | Black | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | Warning Letter | N/A | 52.5054363 | -1.8556273 | ||
| 8736 | op-snap---monthly-publication-february-2026.pdf | 1483 | 2026-02 | Other | Proton | Blue | Driving without Due Care and Attention | None | Gervase Drive | Gervase Drive | Dudley | Dudley | Warning Letter | N/A | 52.5169749 | -2.0827363 | |||
| 8737 | op-snap---monthly-publication-february-2026.pdf | 1484 | 2026-02 | Other | Volkswagen | Taigo | Black | Driving without Due Care and Attention | None | Gervase Drive | Gervase Drive | Dudley | Dudley | Warning Letter | N/A | 52.5169749 | -2.0827363 | ||
| 10552 | op-snap---monthly-publication-january-2026.pdf | 13 | 2026-01 | Other | Audi | A5 | Grey | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10569 | op-snap---monthly-publication-january-2026.pdf | 30 | 2026-01 | Other | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10597 | op-snap---monthly-publication-january-2026.pdf | 58 | 2026-01 | Other | Land Rover | 414.. | Red | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10604 | op-snap---monthly-publication-january-2026.pdf | 65 | 2026-01 | Other | Audi | Q7 | Blue | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 10652 | op-snap---monthly-publication-january-2026.pdf | 113 | 2026-01 | Other | Audi | A3.. | Grey | Driving without Due Care and Attention | None | Star City Car Park | Star City Car Park | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 10692 | op-snap---monthly-publication-january-2026.pdf | 153 | 2026-01 | Other | BMW | X3.. | White | Misc - Non Traffic Offences | None | Canal Court | Canal Court | Birmingham | Birmingham | Warning Letter | N/A | 52.4486586 | -1.8085554 | ||
| 11002 | op-snap---monthly-publication-january-2026.pdf | 463 | 2026-01 | Other | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cambridge Crescent | Cambridge Crescent | Birmingham | Birmingham | Warning Letter | N/A | 52.4652475 | -1.9056734 | ||
| 11023 | op-snap---monthly-publication-january-2026.pdf | 484 | 2026-01 | Other | Audi | S3 | Black | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11024 | op-snap---monthly-publication-january-2026.pdf | 485 | 2026-01 | Other | Land Rover | Range Rover | Green | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11025 | op-snap---monthly-publication-january-2026.pdf | 486 | 2026-01 | Other | Land Rover | Defender | Red | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11026 | op-snap---monthly-publication-january-2026.pdf | 487 | 2026-01 | Other | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11028 | op-snap---monthly-publication-january-2026.pdf | 489 | 2026-01 | Other | Suzuki | Vitara | Blue | Driving without Due Care and Attention | None | Castlegate Way | Castlegate Way | Dudley | Dudley | Warning Letter | N/A | 52.5143403 | -2.0723636 | ||
| 11088 | op-snap---monthly-publication-january-2026.pdf | 549 | 2026-01 | Other | Peugeot | Expert | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11089 | op-snap---monthly-publication-january-2026.pdf | 550 | 2026-01 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11219 | op-snap---monthly-publication-january-2026.pdf | 680 | 2026-01 | Other | Volkswagen | Crafter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lentons Lane | Lentons Lane | Coventry | Coventry | Warning Letter | N/A | 52.4503238 | -1.4546397 | ||
| 11236 | op-snap---monthly-publication-january-2026.pdf | 697 | 2026-01 | Other | BMW | 520D | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 11241 | op-snap---monthly-publication-january-2026.pdf | 702 | 2026-01 | Other | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11265 | op-snap---monthly-publication-january-2026.pdf | 726 | 2026-01 | Other | BMW | 318d | Grey | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11266 | op-snap---monthly-publication-january-2026.pdf | 727 | 2026-01 | Other | BMW | 323i | White | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 11337 | op-snap---monthly-publication-january-2026.pdf | 798 | 2026-01 | Other | Kia | Sportage | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 11438 | op-snap---monthly-publication-january-2026.pdf | 899 | 2026-01 | Other | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Waterfront Carpark 7 | Waterfront Carpark 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 11440 | op-snap---monthly-publication-january-2026.pdf | 901 | 2026-01 | Other | Renault | Clio | Blue | Driving without Due Care and Attention | None | Waterfront Carpark 7 | Waterfront Carpark 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 11621 | op-snap---monthly-publication-january-2026.pdf | 1082 | 2026-01 | Other | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Main car park dudley | Main car park dudley | Dudley | Dudley | Warning Letter | N/A | 52.4799731 | -2.0985927 | ||
| 11808 | op-snap---monthly-publication-january-2026.pdf | 1269 | 2026-01 | Other | Kia | Ceed | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 11911 | op-snap---monthly-publication-january-2026.pdf | 1372 | 2026-01 | Other | Volkswagen | passatt | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | edmund road | Edmund Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4876113 | -1.8542201 | ||
| 3968 | op-snap---monthly-publication-december-2025.pdf | 96 | 2025-12 | Other | Ford | puma | Silver | Cause vehicle to be left in a dangerous position | None | glenville drive | Glenville Drive | Coventry | Coventry | Warning Letter | N/A | ||||
| 4274 | op-snap---monthly-publication-december-2025.pdf | 402 | 2025-12 | Other | Audi | a4 | Blue | Misc - Non Traffic Offences | None | a45 small heath highway | A45 Small Heath Highway | Birmingham | Birmingham | Warning Letter | N/A | 52.4601838 | -1.8488291 | ||
| 4588 | op-snap---monthly-publication-december-2025.pdf | 716 | 2025-12 | Other | Nissan | Qashqai | Grey | Using a Mobile Phone Whilst Driving | No Seat Belt | Birmingham | Birmingham | Birmingham | Birmingham | Warning Letter | N/A | 52.4796992 | -1.9026911 | ||
| 4912 | op-snap---monthly-publication-december-2025.pdf | 1040 | 2025-12 | Other | Mercedes-Benz | C-class | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 4958 | op-snap---monthly-publication-december-2025.pdf | 1086 | 2025-12 | Other | Ford | focus | Black | Cause vehicle to be left in a dangerous position | None | alderbrook road | Alderbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4122406 | -1.7994225 | ||
| 20681 | op-snap---monthly-publication-november-2025.pdf | 223 | 2025-11 | Other | Ford | Fiesta | Silver | Driving a vehicle wholly or partly on a footpath | None | West Morland Road | West Morland Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 20712 | op-snap---monthly-publication-november-2025.pdf | 254 | 2025-11 | Other | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 21299 | op-snap---monthly-publication-november-2025.pdf | 841 | 2025-11 | Other | Toyota | Aygo | blue | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 21439 | op-snap---monthly-publication-november-2025.pdf | 981 | 2025-11 | Other | Saab | 09-Mar | Black | Driving without Due Care and Attention | None | Market Street, Stourbridge | Market Street, Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4569084 | -2.147453 | ||
| 22093 | op-snap---monthly-publication-october-2025.pdf | 43 | 2025-10 | Other | Mercedes-Benz | E220 | Grey | Driving without Due Care and Attention | None | Waterfront main Car Park | Waterfront main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 22669 | op-snap---monthly-publication-october-2025.pdf | 619 | 2025-10 | Other | Toyota | Auris | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Whittington Oval, Stechford | Whittington Oval, Stechford | Birmingham | Birmingham | Warning Letter | N/A | 52.4800782 | -1.7942034 | ||
| 23711 | op-snap---monthly-publication-october-2025.pdf | 1661 | 2025-10 | Other | Toyota | Prius | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | durham road | Durham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4535652 | -1.8699279 | ||
| 23781 | op-snap---monthly-publication-september-2025.pdf | 0 | 2025-09 | Other | Skoda | Fabia | White | Driving without Due Care and Attention | None | Waterfron main car park | Waterfron main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 23941 | op-snap---monthly-publication-september-2025.pdf | 160 | 2025-09 | Other | Fiat | 500 | Green | No Seat Belt | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4700545 | -1.834436 | ||
| 23999 | op-snap---monthly-publication-september-2025.pdf | 218 | 2025-09 | Other | Toyota | Auris | Blue | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Chadworth Avenue | Chadworth Avenue | Solihull | Solihull | Warning Letter | N/A | 52.377039 | -1.7639157 | ||
| 24032 | op-snap---monthly-publication-september-2025.pdf | 251 | 2025-09 | Other | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Dean Road | Dean Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5932146 | -2.102601 | ||
| 24325 | op-snap---monthly-publication-september-2025.pdf | 544 | 2025-09 | Other | Scania | White | Using a Mobile Phone Whilst Driving | None | Brettell Lane | Brettell Lane | Dudley | Dudley | Warning Letter | N/A | 52.4706676 | -2.1545486 | |||
| 24369 | op-snap---monthly-publication-september-2025.pdf | 588 | 2025-09 | Other | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Compton Close | Compton Close | Solihull | Solihull | Warning Letter | N/A | 52.4167285 | -1.811636 | ||
| 24584 | op-snap---monthly-publication-september-2025.pdf | 803 | 2025-09 | Other | Audi | A1 | Black | Driving without Due Care and Attention | None | Waterfront car park 7 | Waterfront car park 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 24586 | op-snap---monthly-publication-september-2025.pdf | 805 | 2025-09 | Other | Audi | A4 | Grey | Driving without Due Care and Attention | None | Waterfron car park 7 | Waterfron car park 7 | Dudley | Dudley | Warning Letter | N/A | ||||
| 24771 | op-snap---monthly-publication-september-2025.pdf | 990 | 2025-09 | Other | Volkswagen | EOS | Black | Driving without Due Care and Attention | None | Merry Hill Main Car Park | Merry Hill Main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 24789 | op-snap---monthly-publication-september-2025.pdf | 1008 | 2025-09 | Other | Seat | MII | Red | Driving without Due Care and Attention | None | St Margarets Avenue | Street Margarets Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24823 | op-snap---monthly-publication-september-2025.pdf | 1042 | 2025-09 | Other | Nissan | Note | Red | Driving a vehicle wholly or partly on a footpath | None | Empire Road, Tile Hill | Empire Road, Tile Hill | Coventry | Coventry | Warning Letter | N/A | 52.4073518 | -1.5831621 | ||
| 24838 | op-snap---monthly-publication-september-2025.pdf | 1057 | 2025-09 | Other | Seat | Leon | White | Driving without Due Care and Attention | None | Waterfront Main Car Park | Waterfront Main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 24839 | op-snap---monthly-publication-september-2025.pdf | 1058 | 2025-09 | Other | Yamaha | Aprilia 125 | Black | Driving without Due Care and Attention | None | Waterfront Main Car Park | Waterfront Main Car Park | Dudley | Dudley | Warning Letter | N/A | ||||
| 24875 | op-snap---monthly-publication-september-2025.pdf | 1094 | 2025-09 | Other | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 24876 | op-snap---monthly-publication-september-2025.pdf | 1095 | 2025-09 | Other | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 24883 | op-snap---monthly-publication-september-2025.pdf | 1102 | 2025-09 | Other | Seat | Leon | Red | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | Warning Letter | N/A | 52.5054363 | -1.8556273 | ||
| 25125 | op-snap---monthly-publication-september-2025.pdf | 1344 | 2025-09 | Other | Toyota | MPV | White | Cause vehicle to be left in a dangerous position | None | Paradise Street | Paradise Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4790667 | -1.9039768 | ||
| 2139 | op-snap---monthly-publication-august-2025.pdf | 114 | 2025-08 | Other | Hyundai | I20 | White | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2191 | op-snap---monthly-publication-august-2025.pdf | 166 | 2025-08 | Other | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2193 | op-snap---monthly-publication-august-2025.pdf | 168 | 2025-08 | Other | Mercedes-Benz | A180 | Black | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2194 | op-snap---monthly-publication-august-2025.pdf | 169 | 2025-08 | Other | Volkswagen | Corsa | Black | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2583 | op-snap---monthly-publication-august-2025.pdf | 558 | 2025-08 | Other | Audi | A1 | Black | Driving without Reasonable Consideration | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 2584 | op-snap---monthly-publication-august-2025.pdf | 559 | 2025-08 | Other | Volkswagen | Polo | Black | Driving without Reasonable Consideration | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 2585 | op-snap---monthly-publication-august-2025.pdf | 560 | 2025-08 | Other | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | Waterfront car park | Waterfront car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 2591 | op-snap---monthly-publication-august-2025.pdf | 566 | 2025-08 | Other | Nissan | Juke | Black | Driving without Due Care and Attention | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6043868 | -2.1046385 | ||
| 2593 | op-snap---monthly-publication-august-2025.pdf | 568 | 2025-08 | Other | Scania | lorry | Yellow | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 2637 | op-snap---monthly-publication-august-2025.pdf | 612 | 2025-08 | Other | Mini | Cooper | White | Driving without Due Care and Attention | None | Waterfront carpark | Waterfront carpark | Dudley | Dudley | Warning Letter | N/A | ||||
| 2705 | op-snap---monthly-publication-august-2025.pdf | 680 | 2025-08 | Other | Mini | cooper | White | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2706 | op-snap---monthly-publication-august-2025.pdf | 681 | 2025-08 | Other | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 2819 | op-snap---monthly-publication-august-2025.pdf | 794 | 2025-08 | Other | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Water front Merry Hill | Water front Merry Hill | Dudley | Dudley | Warning Letter | N/A | ||||
| 2852 | op-snap---monthly-publication-august-2025.pdf | 827 | 2025-08 | Other | Audi | A1 | Black | Driving without Due Care and Attention | None | Waterfront Merry Hill | Waterfront Merry Hill | Dudley | Dudley | Warning Letter | N/A | 52.4874176 | -2.1129449 | ||
| 3179 | op-snap---monthly-publication-august-2025.pdf | 1154 | 2025-08 | Other | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | 52.5112053 | -2.0833165 | ||
| 3857 | op-snap---monthly-publication-august-2025.pdf | 1832 | 2025-08 | Other | Mini | cooper | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | spring lane | Spring Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5182019 | -1.8336169 | ||
| 12159 | op-snap---monthly-publication-july-2025.pdf | 211 | 2025-07 | Other | Daf | Dennis | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4353506 | -1.8927483 | ||
| 12219 | op-snap---monthly-publication-july-2025.pdf | 271 | 2025-07 | Other | BMW | 330.. | White | Driving without Due Care and Attention | None | Waterfrnt Car Park | Waterfrnt Car Park | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | ||||
| 12392 | op-snap---monthly-publication-july-2025.pdf | 444 | 2025-07 | Other | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Arden Road | Arden Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4515759 | -1.8296192 | ||
| 12396 | op-snap---monthly-publication-july-2025.pdf | 448 | 2025-07 | Other | Seat | Leon | Black | Driving without Due Care and Attention | None | Waterfront carpark 7 | Waterfront carpark 7 | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | ||||
| 12487 | op-snap---monthly-publication-july-2025.pdf | 539 | 2025-07 | Other | Honda | C90MG | Red | Driving without Due Care and Attention | None | Bullring Sedgley | Bullring Sedgley | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.5411442 | -2.1221913 | ||
| 12729 | op-snap---monthly-publication-july-2025.pdf | 781 | 2025-07 | Other | Kawasaki | Blue | Misc - Non Traffic Offences | None | Moathouse Park (Cov) | Moathouse Park (Cov) | Coventry | Coventry | Warning Letter | N/A | 52.4352858 | -1.4634999 | |||
| 12791 | op-snap---monthly-publication-july-2025.pdf | 843 | 2025-07 | Other | BMW | 135.. | Blue | Driving without Due Care and Attention | None | Beacon Park Farm | Beacon Park Farm | Walsall | Walsall | Warning Letter | N/A | ||||
| 12806 | op-snap---monthly-publication-july-2025.pdf | 858 | 2025-07 | Other | BMW | 116.. | Black | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.5846796 | -1.9935385 | ||
| 13053 | op-snap---monthly-publication-july-2025.pdf | 1105 | 2025-07 | Other | Ford | Focus | Blue | Driving without Due Care and Attention | None | Waterfront Way Car park 7 | Waterfront Way Car park 7 | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | ||||
| 13377 | op-snap---monthly-publication-july-2025.pdf | 1429 | 2025-07 | Other | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13378 | op-snap---monthly-publication-july-2025.pdf | 1430 | 2025-07 | Other | Volkswagen | Tiguan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 |
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);