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'}
169 rows where council_area = "Birmingham", 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, nfa_rationale
vehicle_make 29
month 14
disposal 7
- Warning Letter 66
- NFA 48
- Education 23
- Fixed Penalty 17
- Court 8
- RTC - Actioned 4
- Other Action Taken 3
reporter_transport_mode 1
- Pedestrian · 169 ✖
offence 1
- Driving without Due Care and Attention · 169 ✖
council_area 1
- Birmingham · 169 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7912 | op-snap---monthly-publication-february-2026.pdf | 659 | 2026-02 | Pedestrian | Volkswagen | Polo | Green | Driving without Due Care and Attention | None | Wedgewood Road | Wedgewood Road | Birmingham | Birmingham | Court | N/A | 52.4560365 | -1.9936623 | ||
| 7914 | op-snap---monthly-publication-february-2026.pdf | 661 | 2026-02 | Pedestrian | Ford | Focus | Black | Driving without Due Care and Attention | None | Wedgewood Road | Wedgewood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4560365 | -1.9936623 | ||
| 8144 | op-snap---monthly-publication-february-2026.pdf | 891 | 2026-02 | Pedestrian | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | Education | N/A | 52.4883936 | -1.8310056 | ||
| 8307 | op-snap---monthly-publication-february-2026.pdf | 1054 | 2026-02 | Pedestrian | Mercedes-Benz | Black | Driving without Due Care and Attention | None | Highters Heath Lane | Highters Heath Lane | Birmingham | Birmingham | NFA | No VRM | 52.4100972 | -1.8742772 | |||
| 8334 | op-snap---monthly-publication-february-2026.pdf | 1081 | 2026-02 | Pedestrian | BMW | X4 | Black | Driving without Due Care and Attention | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Education | N/A | 52.4762433 | -1.9176665 | ||
| 8566 | op-snap---monthly-publication-february-2026.pdf | 1313 | 2026-02 | Pedestrian | Mercedes-Benz | A200 | Grey | Driving without Due Care and Attention | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | Education | N/A | 52.4702385 | -1.895011 | ||
| 8567 | op-snap---monthly-publication-february-2026.pdf | 1314 | 2026-02 | Pedestrian | Toyota | White | Driving without Due Care and Attention | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | Education | N/A | 52.4702385 | -1.895011 | |||
| 8568 | op-snap---monthly-publication-february-2026.pdf | 1315 | 2026-02 | Pedestrian | Toyota | Blue | Driving without Due Care and Attention | None | Sherlock Street | Sherlock Street | Birmingham | Birmingham | NFA | 52.4702385 | -1.895011 | ||||
| 8585 | op-snap---monthly-publication-february-2026.pdf | 1332 | 2026-02 | Pedestrian | Toyota | yaris | Grey | Driving without Due Care and Attention | None | Tenbury Road | Tenbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4264041 | -1.8966768 | ||
| 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 | ||
| 8758 | op-snap---monthly-publication-february-2026.pdf | 1505 | 2026-02 | Pedestrian | Multiple | Driving without Due Care and Attention | None | Metchley lane | Metchley lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4552055 | -1.9461279 | ||||
| 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 | ||
| 10653 | op-snap---monthly-publication-january-2026.pdf | 114 | 2026-01 | Pedestrian | Hyundai | I20 | Grey | Driving without Due Care and Attention | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 10988 | op-snap---monthly-publication-january-2026.pdf | 449 | 2026-01 | Pedestrian | Audi | A3 | Blue | Driving without Due Care and Attention | None | Boleyn Road | Boleyn Road | Birmingham | Birmingham | NFA | No Offence | 52.4030543 | -2.0296756 | ||
| 11132 | op-snap---monthly-publication-january-2026.pdf | 593 | 2026-01 | Pedestrian | Peugeot | 307.. | Silver | Driving without Due Care and Attention | No Insurance | Stonor Road | Stonor Road | Birmingham | Birmingham | Court | N/A | 52.4176973 | -1.8351247 | ||
| 11493 | op-snap---monthly-publication-january-2026.pdf | 954 | 2026-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | High Street | High Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5254588 | -1.8373064 | ||
| 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 | ||
| 11755 | op-snap---monthly-publication-january-2026.pdf | 1216 | 2026-01 | Pedestrian | Audi | Q2 | Grey | Driving without Due Care and Attention | None | Cotford Road | Cotford Road | Birmingham | Birmingham | Education | N/A | 52.4062317 | -1.8814294 | ||
| 11840 | op-snap---monthly-publication-january-2026.pdf | 1301 | 2026-01 | Pedestrian | Kia | Sportage | Black | Driving without Due Care and Attention | No Insurance | Floodgate Street | Floodgate Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4752856 | -1.8858047 | ||
| 3876 | op-snap---monthly-publication-december-2025.pdf | 4 | 2025-12 | Pedestrian | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | New John Street | New John Street | Birmingham | Birmingham | Other Action Taken | No Independent Evidence Available | 52.4920451 | -1.8920402 | ||
| 4070 | op-snap---monthly-publication-december-2025.pdf | 198 | 2025-12 | Pedestrian | Volkswagen | Passatt | Blue | Driving without Due Care and Attention | None | Glenville Drivce | Glenville Drivce | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4513 | op-snap---monthly-publication-december-2025.pdf | 641 | 2025-12 | Pedestrian | Yamaha | GPD125 | Blue | Driving without Due Care and Attention | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | Education | N/A | 52.473986 | -1.9147087 | ||
| 4577 | op-snap---monthly-publication-december-2025.pdf | 705 | 2025-12 | Pedestrian | Audi | A6 | Grey | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4622646 | -1.8599985 | ||
| 4625 | op-snap---monthly-publication-december-2025.pdf | 753 | 2025-12 | Pedestrian | Unknown | Red | Driving without Due Care and Attention | None | Mandelson Crescent | Mandelson Crescent | Birmingham | Birmingham | RTC - Actioned | N/A | |||||
| 4687 | op-snap---monthly-publication-december-2025.pdf | 815 | 2025-12 | Pedestrian | Driving without Due Care and Attention | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4760986 | -1.9018641 | |||||
| 4688 | op-snap---monthly-publication-december-2025.pdf | 816 | 2025-12 | Pedestrian | Driving without Due Care and Attention | None | Alston Street | Alston Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4772629 | -1.9267359 | |||||
| 4936 | op-snap---monthly-publication-december-2025.pdf | 1064 | 2025-12 | Pedestrian | BMW | 525d | White | Driving without Due Care and Attention | None | oval | Oval | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4577754 | -1.8692099 | ||
| 4961 | op-snap---monthly-publication-december-2025.pdf | 1089 | 2025-12 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Aston Church Road | Aston Church Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4998848 | -1.8630958 | ||
| 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 | ||||
| 21049 | op-snap---monthly-publication-november-2025.pdf | 591 | 2025-11 | Pedestrian | Yamaha | GPD125 | Red | Driving without Due Care and Attention | None | Newtown St | Newtown Street | Birmingham | Birmingham | Court | N/A | 52.4964717 | -1.8963477 | ||
| 21106 | op-snap---monthly-publication-november-2025.pdf | 648 | 2025-11 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Alderbrooke Road | Alderbrooke Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21851 | op-snap---monthly-publication-november-2025.pdf | 1393 | 2025-11 | Pedestrian | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | regent road | Regent Road | Birmingham | Birmingham | Education | N/A | 52.5077359 | -1.9452509 | ||
| 21852 | op-snap---monthly-publication-november-2025.pdf | 1394 | 2025-11 | Pedestrian | Hyundai | tucson | Red | Driving without Due Care and Attention | None | regent road | Regent Road | Birmingham | Birmingham | NFA | No VRM | 52.5077359 | -1.9452509 | ||
| 21868 | op-snap---monthly-publication-november-2025.pdf | 1410 | 2025-11 | Pedestrian | Land Rover | velar | Blue | Driving without Due Care and Attention | None | regent place | Regent Place | Birmingham | Birmingham | Education | N/A | 52.4860376 | -1.9095854 | ||
| 21870 | op-snap---monthly-publication-november-2025.pdf | 1412 | 2025-11 | Pedestrian | Ford | transit | Grey | Driving without Due Care and Attention | None | regent place | Regent Place | Birmingham | Birmingham | Education | N/A | 52.4860376 | -1.9095854 | ||
| 22171 | op-snap---monthly-publication-october-2025.pdf | 121 | 2025-10 | Pedestrian | Yamaha | GPD 125 | White | Driving without Due Care and Attention | None | Lyon Queensway | Lyon Queensway | Birmingham | Birmingham | Education | N/A | 52.4785129 | -1.9047486 | ||
| 22235 | op-snap---monthly-publication-october-2025.pdf | 185 | 2025-10 | Pedestrian | White | Driving without Due Care and Attention | None | Newtown | Newtown | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4978509 | -1.8963733 | ||||
| 22553 | op-snap---monthly-publication-october-2025.pdf | 503 | 2025-10 | Pedestrian | Mercedes-Benz | Silver | Driving without Due Care and Attention | None | Sarehole Road | Sarehole Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4422505 | -1.8539684 | |||
| 22660 | op-snap---monthly-publication-october-2025.pdf | 610 | 2025-10 | Pedestrian | Skoda | Kamiq | Grey | Driving without Due Care and Attention | None | Burtons Way | Burtons Way | Birmingham | Birmingham | Education | N/A | ||||
| 22928 | op-snap---monthly-publication-october-2025.pdf | 878 | 2025-10 | Pedestrian | Mercedes-Benz | A Class | White | Driving without Due Care and Attention | None | Priory Road | Priory Road | Birmingham | Birmingham | NFA | No Offence | 52.4132696 | -1.8555008 | ||
| 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 | ||
| 24233 | op-snap---monthly-publication-september-2025.pdf | 452 | 2025-09 | Pedestrian | Ford | S Max | Grey | Driving without Due Care and Attention | None | Aldi,Hall Green | Aldi, Hall Green | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4271029 | -1.8406313 | ||
| 24503 | op-snap---monthly-publication-september-2025.pdf | 722 | 2025-09 | Pedestrian | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Lionel Street | Lionel Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4821516 | -1.9058355 | ||
| 24545 | op-snap---monthly-publication-september-2025.pdf | 764 | 2025-09 | Pedestrian | Skoda | Grey | Driving without Due Care and Attention | None | Midland Road | Midland Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4190372 | -1.9294685 | |||
| 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 | ||
| 24949 | op-snap---monthly-publication-september-2025.pdf | 1168 | 2025-09 | Pedestrian | BMW | 335D | Silver | Driving without Due Care and Attention | No vehicle excise licence | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Court | N/A | 52.473986 | -1.9147087 | ||
| 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 | ||
| 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 | ||
| 2051 | op-snap---monthly-publication-august-2025.pdf | 26 | 2025-08 | Pedestrian | Ford | Fiesta | Yellow | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Education | N/A | ||||
| 2221 | op-snap---monthly-publication-august-2025.pdf | 196 | 2025-08 | Pedestrian | Audi | Q2.. | Black | Driving without Due Care and Attention | None | A38.. | A38 | Birmingham | Birmingham | NFA | No Offence | ||||
| 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 | ||
| 2588 | op-snap---monthly-publication-august-2025.pdf | 563 | 2025-08 | Pedestrian | Audi | A5 | Grey | Driving without Due Care and Attention | None | Lightwoods Hill | Lightwoods Hill | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2627 | op-snap---monthly-publication-august-2025.pdf | 602 | 2025-08 | Pedestrian | Peugeot | 208.. | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | ||
| 2807 | op-snap---monthly-publication-august-2025.pdf | 782 | 2025-08 | Pedestrian | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 2983 | op-snap---monthly-publication-august-2025.pdf | 958 | 2025-08 | Pedestrian | Volkswagen | Grey | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4543565 | -1.9114004 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||||
| 3834 | op-snap---monthly-publication-august-2025.pdf | 1809 | 2025-08 | Pedestrian | Driving without Due Care and Attention | None | Clarence Road | Clarence Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5940902 | -1.843503 | |||||
| 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 | ||||
| 11967 | op-snap---monthly-publication-july-2025.pdf | 19 | 2025-07 | Pedestrian | Seat | Leon | Blue | Driving without Due Care and Attention | None | Heath Road South | Heath Road South | Birmingham | Birmingham | NFA | No VRM | 52.415858 | -1.9632649 | ||
| 12099 | op-snap---monthly-publication-july-2025.pdf | 151 | 2025-07 | Pedestrian | Nissan | Juke | Red | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4622646 | -1.8599985 | ||
| 12340 | op-snap---monthly-publication-july-2025.pdf | 392 | 2025-07 | Pedestrian | Mercedes-Benz | SLK 200 | Black | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 12365 | op-snap---monthly-publication-july-2025.pdf | 417 | 2025-07 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | No Insurance | Bordsley Green | Bordsley Green | Birmingham | Birmingham | Court | N/A | ||||
| 12506 | op-snap---monthly-publication-july-2025.pdf | 558 | 2025-07 | Pedestrian | Peugeot | 207 | Silver | Driving without Due Care and Attention | None | Kenilworth Road | Kenilworth Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5124557 | -1.8917609 | ||
| 12636 | op-snap---monthly-publication-july-2025.pdf | 688 | 2025-07 | Pedestrian | Mg | 3... | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 13001 | op-snap---monthly-publication-july-2025.pdf | 1053 | 2025-07 | Pedestrian | Mercedes-Benz | White | Driving without Due Care and Attention | None | Russell Bank Road | Russell Bank Road | Birmingham | Birmingham | NFA | No VRM | 52.5941017 | -1.8521585 | |||
| 13362 | op-snap---monthly-publication-july-2025.pdf | 1414 | 2025-07 | Pedestrian | U/K | Driving without Due Care and Attention | No Insurance | Northfield | Northfield | Birmingham | Birmingham | NFA | No VRM | 52.4082951 | -1.9651246 | ||||
| 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 | ||
| 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 | ||
| 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 |
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);