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'}
99 rows where disposal = "Warning Letter", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedestrian" 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
month 12
council_area 8
- Birmingham 66
- Dudley 16
- Wolverhampton 5
- Sandwell 3
- Sutton Coldfield 3
- Coventry 2
- Solihull 2
- Walsall 2
reporter_transport_mode 1
- Pedestrian · 99 ✖
offence 1
- Driving without Due Care and Attention · 99 ✖
disposal 1
- Warning Letter · 99 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8749 | op-snap---monthly-publication-february-2026.pdf | 1496 | 2026-02 | Pedestrian | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5458699 | -1.9304484 | ||
| 8782 | op-snap---monthly-publication-february-2026.pdf | 1529 | 2026-02 | Pedestrian | BMW | 118.. | Blue | Driving without Due Care and Attention | None | Perry Street at Potters Lane Wednesbury | Perry Street at Potters Lane Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5004634 | -1.9710382 | ||
| 10587 | op-snap---monthly-publication-january-2026.pdf | 48 | 2026-01 | Pedestrian | Yamaha | gpd125 | Grey | Driving without Due Care and Attention | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 11664 | op-snap---monthly-publication-january-2026.pdf | 1125 | 2026-01 | Pedestrian | Toyota | Aygo | Red | Driving without Due Care and Attention | None | Maypole Lane | Maypole Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4046925 | -1.8764112 | ||
| 4592 | op-snap---monthly-publication-december-2025.pdf | 720 | 2025-12 | Pedestrian | Audi | s3 | Blue | Driving without Due Care and Attention | None | south parade | South Parade | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5618877 | -1.8226794 | ||
| 20885 | op-snap---monthly-publication-november-2025.pdf | 427 | 2025-11 | Pedestrian | Rolls-Royce | Cullinan | Black | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 20902 | op-snap---monthly-publication-november-2025.pdf | 444 | 2025-11 | Pedestrian | Ford | Kuga | White | Driving without Due Care and Attention | None | Wootton Road | Wootton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3905192 | -1.968829 | ||
| 20903 | op-snap---monthly-publication-november-2025.pdf | 445 | 2025-11 | Pedestrian | Vauxhall | Zafira | Black | Driving without Due Care and Attention | None | Wootton Road | Wootton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3905192 | -1.968829 | ||
| 20904 | op-snap---monthly-publication-november-2025.pdf | 446 | 2025-11 | Pedestrian | Honda | FRV | Grey | Driving without Due Care and Attention | None | Wootton Road | Wootton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3905192 | -1.968829 | ||
| 21021 | op-snap---monthly-publication-november-2025.pdf | 563 | 2025-11 | Pedestrian | Mercedes-Benz | E300 | Black | Driving without Due Care and Attention | None | Ivanhoe Street | Ivanhoe Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 22305 | op-snap---monthly-publication-october-2025.pdf | 255 | 2025-10 | Pedestrian | BMW | M140.. | Yellow | Driving without Due Care and Attention | None | Upper High Street Wednesbury | Upper High Street Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5533962 | -2.0204699 | ||
| 22316 | op-snap---monthly-publication-october-2025.pdf | 266 | 2025-10 | Pedestrian | Mercedes-Benz | GLC | Blue | Driving without Due Care and Attention | None | Holly Bush Lane | Holly Bush Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 23184 | op-snap---monthly-publication-october-2025.pdf | 1134 | 2025-10 | Pedestrian | Audi | A3 | Silver | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.463146 | -1.9844677 | ||
| 23303 | op-snap---monthly-publication-october-2025.pdf | 1253 | 2025-10 | Pedestrian | Suzuki | UZ 125 | Red | Driving without Due Care and Attention | None | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 23576 | op-snap---monthly-publication-october-2025.pdf | 1526 | 2025-10 | Pedestrian | Mercedes-Benz | C200 | White | Driving without Due Care and Attention | None | Walford Road | Walford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4594072 | -1.8658859 | ||
| 23734 | op-snap---monthly-publication-october-2025.pdf | 1684 | 2025-10 | Pedestrian | Volkswagen | Tiguan | White | Driving without Due Care and Attention | None | Newton Shipping Centre | Newton Shipping Centre | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23738 | op-snap---monthly-publication-october-2025.pdf | 1688 | 2025-10 | Pedestrian | BMW | 520D | White | Driving without Due Care and Attention | None | Oxford Road | Oxford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4456323 | -1.8858352 | ||
| 23810 | op-snap---monthly-publication-september-2025.pdf | 29 | 2025-09 | Pedestrian | Kia | Rio | Red | Driving without Due Care and Attention | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 24181 | op-snap---monthly-publication-september-2025.pdf | 400 | 2025-09 | Pedestrian | Volvo | V50 | Blue | Driving without Due Care and Attention | None | Farrington Road | Farrington Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5550312 | -2.1191799 | ||
| 24660 | op-snap---monthly-publication-september-2025.pdf | 879 | 2025-09 | Pedestrian | Mercedes-Benz | A-class | Silver | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 24964 | op-snap---monthly-publication-september-2025.pdf | 1183 | 2025-09 | Pedestrian | Volvo | Tipper | White | Driving without Due Care and Attention | None | Honiley ROad | Honiley ROad | Birmingham | Birmingham | Warning Letter | N/A | 52.4789688 | -1.7931848 | ||
| 25009 | op-snap---monthly-publication-september-2025.pdf | 1228 | 2025-09 | Pedestrian | BMW | 1 Series | White | Driving without Due Care and Attention | None | M6 southbound | M6 southbound | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 25177 | op-snap---monthly-publication-september-2025.pdf | 1396 | 2025-09 | Pedestrian | Renault | Trafic | Grey | Driving without Due Care and Attention | None | CLay Lane | CLay Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4509038 | -1.8083784 | ||
| 25245 | op-snap---monthly-publication-september-2025.pdf | 1464 | 2025-09 | Pedestrian | Honda | CBF | Red | Driving without Due Care and Attention | None | Wood Common Grange | Wood Common Grange | Walsall | Walsall | Warning Letter | N/A | 52.6319931 | -1.9785842 | ||
| 25364 | op-snap---monthly-publication-september-2025.pdf | 1583 | 2025-09 | Pedestrian | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | none | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4762784 | -1.9678366 | ||
| 25417 | op-snap---monthly-publication-september-2025.pdf | 1636 | 2025-09 | Pedestrian | Peugeot | Partner | White | Driving without Due Care and Attention | None | Mossfield Rd | Mossfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4305104 | -1.8890824 | ||
| 25588 | op-snap---monthly-publication-september-2025.pdf | 1807 | 2025-09 | Pedestrian | Peugeot | Expert | White | Driving without Due Care and Attention | None | Yardley Road | Yardley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613544 | -1.8160137 | ||
| 2370 | op-snap---monthly-publication-august-2025.pdf | 345 | 2025-08 | Pedestrian | Mazda | CX-30 | Red | Driving without Due Care and Attention | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 3000 | op-snap---monthly-publication-august-2025.pdf | 975 | 2025-08 | Pedestrian | Mercedes-Benz | E200 | White | Driving without Due Care and Attention | None | M5 North | M5 North | Sandwell | Sandwell | Warning Letter | N/A | 52.5274455 | -2.0298903 | ||
| 3023 | op-snap---monthly-publication-august-2025.pdf | 998 | 2025-08 | Pedestrian | BMW | X3 | White | Driving without Due Care and Attention | None | Clapgate Lane | Clapgate Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4417035 | -1.9902817 | ||
| 3087 | op-snap---monthly-publication-august-2025.pdf | 1062 | 2025-08 | Pedestrian | Audi | E-tron | Silver | Driving without Due Care and Attention | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6043868 | -2.1046385 | ||
| 3162 | op-snap---monthly-publication-august-2025.pdf | 1137 | 2025-08 | Pedestrian | Hyundai | I10 | Blue | Driving without Due Care and Attention | None | Chapel Lane | Chapel Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4409424 | -1.9387702 | ||
| 3288 | op-snap---monthly-publication-august-2025.pdf | 1263 | 2025-08 | Pedestrian | Audi | A6 | Black | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | ||
| 3289 | op-snap---monthly-publication-august-2025.pdf | 1264 | 2025-08 | Pedestrian | Porsche | Macan | Grey | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | ||
| 3290 | op-snap---monthly-publication-august-2025.pdf | 1265 | 2025-08 | Pedestrian | Maserati | Grey | Driving without Due Care and Attention | None | Regent Parade | Regent Parade | Birmingham | Birmingham | Warning Letter | N/A | 52.4863585 | -1.9094435 | |||
| 3330 | op-snap---monthly-publication-august-2025.pdf | 1305 | 2025-08 | Pedestrian | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 3331 | op-snap---monthly-publication-august-2025.pdf | 1306 | 2025-08 | Pedestrian | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 3461 | op-snap---monthly-publication-august-2025.pdf | 1436 | 2025-08 | Pedestrian | Skoda | Citigo | Black | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 3594 | op-snap---monthly-publication-august-2025.pdf | 1569 | 2025-08 | Pedestrian | BMW | X5 | Blue | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 3636 | op-snap---monthly-publication-august-2025.pdf | 1611 | 2025-08 | Pedestrian | Ford | Transit | Silver | Driving without Due Care and Attention | None | Cooksey Lane | Cooksey Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5590658 | -1.8882294 | ||
| 3806 | op-snap---monthly-publication-august-2025.pdf | 1781 | 2025-08 | Pedestrian | Volkswagen | Jetta | Black | Driving without Due Care and Attention | None | A34 Birmingham | Birmingham | Birmingham | Birmingham | Warning Letter | N/A | 52.4796992 | -1.9026911 | ||
| 3829 | op-snap---monthly-publication-august-2025.pdf | 1804 | 2025-08 | Pedestrian | Honda | Accord | Black | Driving without Due Care and Attention | None | Vicerage Road | Vicerage Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3835 | op-snap---monthly-publication-august-2025.pdf | 1810 | 2025-08 | Pedestrian | Honda | CRV | Blue | Driving without Due Care and Attention | None | Clarence Road | Clarence Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5940902 | -1.843503 | ||
| 3836 | op-snap---monthly-publication-august-2025.pdf | 1811 | 2025-08 | Pedestrian | Kia | Sportage | White | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3837 | op-snap---monthly-publication-august-2025.pdf | 1812 | 2025-08 | Pedestrian | Jaguar | I pace | White | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3838 | op-snap---monthly-publication-august-2025.pdf | 1813 | 2025-08 | Pedestrian | Nissan | Qashqai | Silver | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3839 | op-snap---monthly-publication-august-2025.pdf | 1814 | 2025-08 | Pedestrian | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3840 | op-snap---monthly-publication-august-2025.pdf | 1815 | 2025-08 | Pedestrian | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436035 | -1.891685 | ||
| 3870 | op-snap---monthly-publication-august-2025.pdf | 1845 | 2025-08 | Pedestrian | Mercedes-Benz | A180 | Black | Driving without Due Care and Attention | None | Vicerage Road | Vicerage Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 12178 | op-snap---monthly-publication-july-2025.pdf | 230 | 2025-07 | Pedestrian | Vauxhall | Zafira | Beige | Driving without Due Care and Attention | None | Outside Coventry Market | Outside Coventry Market | Coventry | Coventry | Warning Letter | N/A | ||||
| 13310 | op-snap---monthly-publication-july-2025.pdf | 1362 | 2025-07 | Pedestrian | Ford | Focus | Silver | Driving without Due Care and Attention | None | Waterfront Way, Dudley | Waterfront Way, Dudley | Dudley | Dudley | Warning Letter | N/A | 52.4880905 | -2.1164794 | ||
| 13470 | op-snap---monthly-publication-july-2025.pdf | 1522 | 2025-07 | Pedestrian | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 13536 | op-snap---monthly-publication-july-2025.pdf | 1588 | 2025-07 | Pedestrian | Ford | focus | Silver | Driving without Due Care and Attention | None | Falstaff road | Falstaff road | Solihull | Solihull | Warning Letter | N/A | 52.4042425 | -1.8243195 | ||
| 13662 | op-snap---monthly-publication-july-2025.pdf | 1714 | 2025-07 | Pedestrian | Ford | Focus | Blue | Driving without Due Care and Attention | none | Tower Street | Tower Street | Dudley | Dudley | Warning Letter | N/A | 52.5112053 | -2.0833165 | ||
| 13663 | op-snap---monthly-publication-july-2025.pdf | 1715 | 2025-07 | Pedestrian | Chysler | Grand yVoyager | Silver | Driving without Due Care and Attention | None | School Road | School Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4161736 | -1.8619692 | ||
| 13681 | op-snap---monthly-publication-july-2025.pdf | 1733 | 2025-07 | Pedestrian | Hyundai | Kona | Grey | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Warning Letter | N/A | 52.4831397 | -2.1309273 | ||
| 13897 | op-snap---monthly-publication-july-2025.pdf | 1949 | 2025-07 | Pedestrian | Audi | RS3 | Blue | Driving without Due Care and Attention | None | Longbridge Lane, Scotland Lane | Longbridge Lane, Scotland Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13931 | op-snap---monthly-publication-july-2025.pdf | 1983 | 2025-07 | Pedestrian | Nissan | Navara | Black | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13932 | op-snap---monthly-publication-july-2025.pdf | 1984 | 2025-07 | Pedestrian | Mini | Roadster | Red | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13934 | op-snap---monthly-publication-july-2025.pdf | 1986 | 2025-07 | Pedestrian | Mercedes-Benz | E220 | Blue | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13935 | op-snap---monthly-publication-july-2025.pdf | 1987 | 2025-07 | Pedestrian | Volkswagen | Polo | Silver | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13936 | op-snap---monthly-publication-july-2025.pdf | 1988 | 2025-07 | Pedestrian | Audi | TT | Black | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13937 | op-snap---monthly-publication-july-2025.pdf | 1989 | 2025-07 | Pedestrian | Mercedes-Benz | EQA | Black | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13938 | op-snap---monthly-publication-july-2025.pdf | 1990 | 2025-07 | Pedestrian | Mercedes-Benz | A170 | Silver | Driving without Due Care and Attention | None | Victoria Street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 13978 | op-snap---monthly-publication-july-2025.pdf | 2030 | 2025-07 | Pedestrian | BMW | M3 | Green | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | 52.4874281 | -2.1117204 | ||
| 14024 | op-snap---monthly-publication-july-2025.pdf | 2076 | 2025-07 | Pedestrian | Ford | Focus | Blue | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 14072 | op-snap---monthly-publication-june-2025.pdf | 1 | 2025-06 | Pedestrian | Seat | Leon | Grey | Driving without Due Care and Attention | None | Cotterills Road | Cotterills Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14171 | op-snap---monthly-publication-june-2025.pdf | 100 | 2025-06 | Pedestrian | Toyota | Aygo | White | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 14173 | op-snap---monthly-publication-june-2025.pdf | 102 | 2025-06 | Pedestrian | Kia | Picanto | Red | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 16089 | op-snap---monthly-publication-june-2025.pdf | 2018 | 2025-06 | Pedestrian | Iveco | Daily | White | Driving without Due Care and Attention | None | Steelpark Way | Steelpark Way | Walsall | Walsall | Warning Letter | N/A | ||||
| 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 | ||
| 19250 | op-snap---monthly-publication-may-2025.pdf | 612 | 2025-05 | Pedestrian | Ford | Transit | White | Driving without Due Care and Attention | None | Old Walsall Road/ Spouthouse Lane | Old Walsall Road/ Spouthouse Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5294399 | -1.9282714 | ||
| 20126 | op-snap---monthly-publication-may-2025.pdf | 1488 | 2025-05 | Pedestrian | Mercedes-Benz | E350 | White | Driving without Due Care and Attention | None | Greswolde Road | Greswolde Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4455718 | -1.861478 | ||
| 20127 | op-snap---monthly-publication-may-2025.pdf | 1489 | 2025-05 | Pedestrian | Honda | Jazz | Black | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20128 | op-snap---monthly-publication-may-2025.pdf | 1490 | 2025-05 | Pedestrian | Renault | scenic | Blue | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20131 | op-snap---monthly-publication-may-2025.pdf | 1493 | 2025-05 | Pedestrian | Tesla | Blue | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | |||
| 20133 | op-snap---monthly-publication-may-2025.pdf | 1495 | 2025-05 | Pedestrian | BMW | 3 Series | Grey | Driving without Due Care and Attention | None | Waterfront main car park | Waterfront main car park | Dudley | Dudley | Warning Letter | N/A | ||||
| 20190 | op-snap---monthly-publication-may-2025.pdf | 1552 | 2025-05 | Pedestrian | Tesla | Model Y | Grey | Driving without Due Care and Attention | none | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 20191 | op-snap---monthly-publication-may-2025.pdf | 1553 | 2025-05 | Pedestrian | BMW | IX3 | Grey | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 20236 | op-snap---monthly-publication-may-2025.pdf | 1598 | 2025-05 | Pedestrian | Audi | A3 | Grey | Driving without Due Care and Attention | None | Waterfront Way | Waterfront Way | Dudley | Dudley | Warning Letter | N/A | 52.4879006 | -2.1188734 | ||
| 20295 | op-snap---monthly-publication-may-2025.pdf | 1657 | 2025-05 | Pedestrian | Volkswagen | crafter | White | Driving without Due Care and Attention | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 20325 | op-snap---monthly-publication-may-2025.pdf | 1687 | 2025-05 | Pedestrian | BMW | 1 series | White | Driving without Due Care and Attention | None | Lower Queen street | Lower Queen street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20328 | op-snap---monthly-publication-may-2025.pdf | 1690 | 2025-05 | Pedestrian | Mercedes-Benz | c220 | Black | Driving without Due Care and Attention | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20332 | op-snap---monthly-publication-may-2025.pdf | 1694 | 2025-05 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Lower Queen street | Lower Queen street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 20352 | op-snap---monthly-publication-may-2025.pdf | 1714 | 2025-05 | Pedestrian | BMW | 330E | Grey | Driving without Due Care and Attention | none | Granton Road | Granton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4224968 | -1.9004066 | ||
| 20403 | op-snap---monthly-publication-may-2025.pdf | 1765 | 2025-05 | Pedestrian | Citroen | Picasso | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | Warning Letter | N/A | 52.4831397 | -2.1309273 | |||
| 16393 | op-snap---monthly-publication-march-2025.pdf | 150 | 2025-03 | Pedestrian | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Collingwood Avenue | Collingwood Avenue | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | |||
| 16463 | op-snap---monthly-publication-march-2025.pdf | 220 | 2025-03 | Pedestrian | Ford | Focus | Silver | Driving without Due Care and Attention | None | School Road, Kings Heath | School Road, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4384417 | -1.8875299 | |
| 16741 | op-snap---monthly-publication-march-2025.pdf | 498 | 2025-03 | Pedestrian | Honda | Civic | Yellow | Driving without Due Care and Attention | None | Amesbury Road | Amesbury Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4465507 | -1.8957752 | |
| 17746 | op-snap---monthly-publication-march-2025.pdf | 1503 | 2025-03 | Pedestrian | Kia | Picanto | Red | Driving without Due Care and Attention | None | Leicester Row | Leicester Row | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.414317 | -1.5104573 | |
| 18194 | op-snap---monthly-publication-march-2025.pdf | 1951 | 2025-03 | Pedestrian | Seat | Ateca | White | Driving without Due Care and Attention | None | Brandwood Road | Brandwood Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4139427 | -1.9037653 | |
| 18228 | op-snap---monthly-publication-march-2025.pdf | 1985 | 2025-03 | Pedestrian | Mercedes-Benz | Black | Driving without Due Care and Attention | No vehicle excise licence | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.471632 | -1.9456776 | ||
| 18567 | op-snap---monthly-publication-march-2025.pdf | 2324 | 2025-03 | Pedestrian | BMW | 120I | Blue | Driving without Due Care and Attention | None | Tilehouse Green Lane | Tilehouse Green Lane | Solihull | Solihull | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.3893231 | -1.7526648 | |
| 8977 | op-snap---monthly-publication-january-2025.pdf | 85 | 2025-01 | Pedestrian | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9250 | op-snap---monthly-publication-january-2025.pdf | 358 | 2025-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9251 | op-snap---monthly-publication-january-2025.pdf | 359 | 2025-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9252 | op-snap---monthly-publication-january-2025.pdf | 360 | 2025-01 | Pedestrian | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9253 | op-snap---monthly-publication-january-2025.pdf | 361 | 2025-01 | Pedestrian | BMW | 118 | Red | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 9254 | op-snap---monthly-publication-january-2025.pdf | 362 | 2025-01 | Pedestrian | Skoda | Citigo | Black | Driving without Due Care and Attention | None | Waterfront Car Park | Waterfront Car Park | Dudley | Dudley | Warning Letter | 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);