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'}
112 rows where disposal = "Warning Letter", month = "2025-03" and offence = "Driving without Due Care and Attention" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 22
council_area 10
- Birmingham 63
- Coventry 13
- Dudley 7
- Solihull 7
- Wolverhampton 7
- Walsall 6
- Sandwell 4
- Metropolitan Borough Of Dudley 3
- Out of Force Area 1
- Sutton Coldfield 1
reporter_transport_mode 7
- Car 88
- Pedal Bike 10
- Pedestrian 7
- Other 4
- Bus 1
- Lorry 1
- Motorbike 1
offence 1
- Driving without Due Care and Attention · 112 ✖
month 1
- 2025-03 · 112 ✖
disposal 1
- Warning Letter · 112 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16280 | op-snap---monthly-publication-march-2025.pdf | 37 | 2025-03 | Car | BMW | 125 | Black | Driving without Due Care and Attention | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4349375 | -1.8510007 | |
| 16372 | op-snap---monthly-publication-march-2025.pdf | 129 | 2025-03 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | M6 J7 | M6 J7 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.676119 | -2.0858425 | |
| 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 | |||
| 16403 | op-snap---monthly-publication-march-2025.pdf | 160 | 2025-03 | Car | Land Rover | Freedlander | Grey | Driving without Due Care and Attention | None | Moseley Road | Moseley Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5782924 | -2.0742911 | |
| 16415 | op-snap---monthly-publication-march-2025.pdf | 172 | 2025-03 | Car | Daf | BUS | White | Driving without Due Care and Attention | None | Ducan Edawards Way | Ducan Edawards Way | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 16423 | op-snap---monthly-publication-march-2025.pdf | 180 | 2025-03 | Car | BMW | 118 | Blue | Driving without Due Care and Attention | None | Moorend Avenue | Moorend Avenue | Birmingham | Birmingham | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | |||
| 16453 | op-snap---monthly-publication-march-2025.pdf | 210 | 2025-03 | Car | Vauxhall | Astra | Blue | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5194011 | -1.8008643 | |
| 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 | |
| 16574 | op-snap---monthly-publication-march-2025.pdf | 331 | 2025-03 | Car | Volkswagen | GOLF | White | Driving without Due Care and Attention | None | BUXTON ROAD | Buxton Road | Wolverhampton | Wolverhampton | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 16624 | op-snap---monthly-publication-march-2025.pdf | 381 | 2025-03 | Car | Yamaha | R6 | Blue | Driving without Due Care and Attention | None | High Street | High Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5254588 | -1.8373064 | |
| 16636 | op-snap---monthly-publication-march-2025.pdf | 393 | 2025-03 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4468506 | -1.9395619 | |
| 16688 | op-snap---monthly-publication-march-2025.pdf | 445 | 2025-03 | Car | Vauxhall | Astra | Blue | Driving without Due Care and Attention | None | A45 Poets Corner | Poets Corner | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4647091 | -1.8588833 | |
| 16729 | op-snap---monthly-publication-march-2025.pdf | 486 | 2025-03 | Car | Hyundai | I10. | White | Driving without Due Care and Attention | None | A47 Erdington (Near Fort Shopping Centre) | Erdington (Near Fort Shopping Centre) | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 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 | |
| 16764 | op-snap---monthly-publication-march-2025.pdf | 521 | 2025-03 | Car | Royal Alloy | Grey | Driving without Due Care and Attention | None | Pelsall Road, Brownhills | Pelsall Road, Brownhills | Walsall | Walsall | Warning Letter | N/A | Yes - Via Email | 52.6486073 | -1.9363667 | ||
| 16771 | op-snap---monthly-publication-march-2025.pdf | 528 | 2025-03 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 16775 | op-snap---monthly-publication-march-2025.pdf | 532 | 2025-03 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Church Lane | Church Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5030217 | -1.8764632 | |
| 16795 | op-snap---monthly-publication-march-2025.pdf | 552 | 2025-03 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Level Street, Brierley Hill | Level Street, Brierley Hill | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4850236 | -2.1088919 | |
| 16796 | op-snap---monthly-publication-march-2025.pdf | 553 | 2025-03 | Car | Audi | Q5 | Black | Driving without Due Care and Attention | None | Level Street, Brierley Hill | Level Street, Brierley Hill | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4850236 | -2.1088919 | |
| 16811 | op-snap---monthly-publication-march-2025.pdf | 568 | 2025-03 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 16880 | op-snap---monthly-publication-march-2025.pdf | 637 | 2025-03 | Car | Skoda | Kodiaq | Blue | Driving without Due Care and Attention | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.502683 | -1.9033516 | |
| 16896 | op-snap---monthly-publication-march-2025.pdf | 653 | 2025-03 | Car | Ford | Puma | Black | Driving without Due Care and Attention | None | Smallheath Highway | Smallheath Highway | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 16931 | op-snap---monthly-publication-march-2025.pdf | 688 | 2025-03 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4344402 | -1.8845368 | |
| 16952 | op-snap---monthly-publication-march-2025.pdf | 709 | 2025-03 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 16975 | op-snap---monthly-publication-march-2025.pdf | 732 | 2025-03 | Car | Toyota | MPV | Silver | Driving without Due Care and Attention | None | Hatherton Street | Hatherton Street | Walsall | Walsall | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5880551 | -1.9796606 | |
| 17111 | op-snap---monthly-publication-march-2025.pdf | 868 | 2025-03 | Car | Hyundai | IX40 | Red | Driving without Due Care and Attention | None | Newtown Middleway | Newtown Middleway | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4922617 | -1.8912734 | |
| 17127 | op-snap---monthly-publication-march-2025.pdf | 884 | 2025-03 | Car | Vauxhall | Vectra | Silver | Driving without Due Care and Attention | None | Clark Road Wolverhampton | Clark Road Wolverhampton | Wolverhampton | Wolverhampton | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.5879262 | -2.1518061 | |
| 17128 | op-snap---monthly-publication-march-2025.pdf | 885 | 2025-03 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | A452 Chester Re at Tyburn House | Chester Re at Tyburn House | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17166 | op-snap---monthly-publication-march-2025.pdf | 923 | 2025-03 | Lorry | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | M42 SB J4 | M42 Southbound J4 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17179 | op-snap---monthly-publication-march-2025.pdf | 936 | 2025-03 | Pedal Bike | Mercedes-Benz | X250 | Grey | Driving without Due Care and Attention | None | Quinton Road | Quinton Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.447826 | -1.9574468 | |
| 17225 | op-snap---monthly-publication-march-2025.pdf | 982 | 2025-03 | Car | Land Rover | Range Rover | Grey | Driving without Due Care and Attention | None | Rampart Way Telford | Rampart Way Telford | Out of Force Area | Out of Force Area | Warning Letter | N/A | Yes - Via Email | |||
| 17240 | op-snap---monthly-publication-march-2025.pdf | 997 | 2025-03 | Pedal Bike | Mitsubishi | L200 | Silver | Driving without Due Care and Attention | None | Wall Hill Road | Wall Hill Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4459445 | -1.5552508 | |
| 17373 | op-snap---monthly-publication-march-2025.pdf | 1130 | 2025-03 | Car | Audi | S7 | White | Driving without Due Care and Attention | None | Bescot Lane | Bescot Lane | Walsall | Walsall | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5704696 | -2.0017451 | |
| 17413 | op-snap---monthly-publication-march-2025.pdf | 1170 | 2025-03 | Car | Mercedes-Benz | VITO | White | Driving without Due Care and Attention | None | WINDWARD WAY | Windward Way | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17421 | op-snap---monthly-publication-march-2025.pdf | 1178 | 2025-03 | Car | Toyota | Corolla | Silver | Driving without Due Care and Attention | None | Five Ways Island | Five Ways Island | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17572 | op-snap---monthly-publication-march-2025.pdf | 1329 | 2025-03 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Wood Road | Wood Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | Yes - Via Email | 52.5925594 | -2.1745928 | |
| 17611 | op-snap---monthly-publication-march-2025.pdf | 1368 | 2025-03 | Car | Audi | A3 | Blue | Driving without Due Care and Attention | None | St Annes Road | Street Annes Road | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | |||
| 17650 | op-snap---monthly-publication-march-2025.pdf | 1407 | 2025-03 | Other | Vauxhall | Mokka | Grey | Driving without Due Care and Attention | None | Jubilee Close | Jubilee Close | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | |||
| 17652 | op-snap---monthly-publication-march-2025.pdf | 1409 | 2025-03 | Car | Mercedes-Benz | cla200 | Black | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4235908 | -1.5226276 | |
| 17679 | op-snap---monthly-publication-march-2025.pdf | 1436 | 2025-03 | Car | Audi | RS Q8 | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17681 | op-snap---monthly-publication-march-2025.pdf | 1438 | 2025-03 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17683 | op-snap---monthly-publication-march-2025.pdf | 1440 | 2025-03 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17685 | op-snap---monthly-publication-march-2025.pdf | 1442 | 2025-03 | Car | Mercedes-Benz | AMG C63 | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17688 | op-snap---monthly-publication-march-2025.pdf | 1445 | 2025-03 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17690 | op-snap---monthly-publication-march-2025.pdf | 1447 | 2025-03 | Car | Skoda | Octavia | Silver | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 17691 | op-snap---monthly-publication-march-2025.pdf | 1448 | 2025-03 | Car | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Bromsgrove Street | Bromsgrove Street | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4728322 | -1.897536 | |
| 17731 | op-snap---monthly-publication-march-2025.pdf | 1488 | 2025-03 | Car | BMW | 320i | Grey | Driving without Due Care and Attention | None | M42 towards M40 split J4 to 3a | M42 towards M40 split J4 to 3a | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 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 | |
| 17748 | op-snap---monthly-publication-march-2025.pdf | 1505 | 2025-03 | Car | Vauxhall | Insignia | Silver | Driving without Due Care and Attention | None | M5 SB J2 | M5 Southbound J2 | Sandwell | Sandwell | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4945433 | -2.0190848 | |
| 17759 | op-snap---monthly-publication-march-2025.pdf | 1516 | 2025-03 | Car | BMW | M4 | Grey | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5458699 | -1.9304484 | |
| 17761 | op-snap---monthly-publication-march-2025.pdf | 1518 | 2025-03 | Car | Mercedes-Benz | AMG E53 | Grey | Driving without Due Care and Attention | None | Russels Road | Russels Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17843 | op-snap---monthly-publication-march-2025.pdf | 1600 | 2025-03 | Car | TRACTOR | White | Driving without Due Care and Attention | None | HIGH BULLEN ROAD | High Bullen Road | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | ||||
| 17847 | op-snap---monthly-publication-march-2025.pdf | 1604 | 2025-03 | Car | Ford | Mondeo | Red | Driving without Due Care and Attention | None | Eachelhurst Road | Eachelhurst Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | Yes - Via Email | 52.5376965 | -1.80033 | |
| 17917 | op-snap---monthly-publication-march-2025.pdf | 1674 | 2025-03 | Car | Honda | ENY1 | Blue | Driving without Due Care and Attention | None | A4123 Tipton | Tipton | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.5290396 | -2.0693747 | |
| 17952 | op-snap---monthly-publication-march-2025.pdf | 1709 | 2025-03 | Pedal Bike | BMW | 118d | Silver | Driving without Due Care and Attention | None | Sandy Lane | Sandy Lane | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.4172858 | -1.5134012 | |
| 17970 | op-snap---monthly-publication-march-2025.pdf | 1727 | 2025-03 | Car | Nissan | Micra | Red | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | Yes - Via Email | 52.418488 | -1.5472387 | |
| 17983 | op-snap---monthly-publication-march-2025.pdf | 1740 | 2025-03 | Car | Volkswagen | Touran | Blue | Driving without Due Care and Attention | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4473373 | -1.9392405 | |
| 18055 | op-snap---monthly-publication-march-2025.pdf | 1812 | 2025-03 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | No Insurance | Birmingham Road | Birmingham Road | Walsall | Walsall | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5723244 | -1.9607214 | |
| 18066 | op-snap---monthly-publication-march-2025.pdf | 1823 | 2025-03 | Car | Skoda | Yeti | Silver | Driving without Due Care and Attention | None | East Meadway at Mackadown Lane | East Meadway at Mackadown Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4813031 | -1.7670825 | |
| 18090 | op-snap---monthly-publication-march-2025.pdf | 1847 | 2025-03 | Car | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4804926 | -1.8563658 | |
| 18092 | op-snap---monthly-publication-march-2025.pdf | 1849 | 2025-03 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4804926 | -1.8563658 | |
| 18120 | op-snap---monthly-publication-march-2025.pdf | 1877 | 2025-03 | Other | Seat | Leon | Black | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4874281 | -2.1117204 | |
| 18121 | op-snap---monthly-publication-march-2025.pdf | 1878 | 2025-03 | Other | BMW | M140i | Black | Driving without Due Care and Attention | None | Waterfront | Waterfront | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4874281 | -2.1117204 | |
| 18131 | op-snap---monthly-publication-march-2025.pdf | 1888 | 2025-03 | Car | BMW | X3 | White | Driving without Due Care and Attention | None | Birmingham Road at Rood End Road | Birmingham Road at Rood End Road | Sandwell | Sandwell | Warning Letter | N/A | Yes - Via Email | 52.5051109 | -1.9908209 | |
| 18148 | op-snap---monthly-publication-march-2025.pdf | 1905 | 2025-03 | Other | Toyota | Prius | Black | Driving without Due Care and Attention | None | Eddish Road | Eddish Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4833672 | -1.7871439 | |
| 18164 | op-snap---monthly-publication-march-2025.pdf | 1921 | 2025-03 | Car | Peugeot | 207 | Grey | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.3916468 | -1.4925995 | |
| 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 | ||
| 18254 | op-snap---monthly-publication-march-2025.pdf | 2011 | 2025-03 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5113867 | -1.8337258 | |
| 18295 | op-snap---monthly-publication-march-2025.pdf | 2052 | 2025-03 | Car | Mercedes-Benz | CLS | Blue | Driving without Due Care and Attention | None | Shakespeare Drive | Shakespeare Drive | Solihull | Solihull | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4021013 | -1.8317213 | |
| 18315 | op-snap---monthly-publication-march-2025.pdf | 2072 | 2025-03 | Pedal Bike | Scania | White | Driving without Due Care and Attention | None | Mitchell Avenue | Mitchell Avenue | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.3940834 | -1.5696642 | ||
| 18319 | op-snap---monthly-publication-march-2025.pdf | 2076 | 2025-03 | Car | Toyota | Auris | Black | Driving without Due Care and Attention | None | A441 Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4308271 | -1.920078 | |
| 18322 | op-snap---monthly-publication-march-2025.pdf | 2079 | 2025-03 | Car | Volkswagen | Passat | Red | Driving without Due Care and Attention | None | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4709298 | -1.8722585 | |
| 18324 | op-snap---monthly-publication-march-2025.pdf | 2081 | 2025-03 | Car | Jeep | Black | Driving without Due Care and Attention | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4119174 | -1.9735247 | ||
| 18336 | op-snap---monthly-publication-march-2025.pdf | 2093 | 2025-03 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18404 | op-snap---monthly-publication-march-2025.pdf | 2161 | 2025-03 | Bus | BMW | 3 | Blue | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4415108 | -1.8971434 | |
| 18409 | op-snap---monthly-publication-march-2025.pdf | 2166 | 2025-03 | Car | Land Rover | Freelander | Black | Driving without Due Care and Attention | None | Sutton Road | Sutton Road | Walsall | Walsall | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5612988 | -2.0522715 | |
| 18442 | op-snap---monthly-publication-march-2025.pdf | 2199 | 2025-03 | Car | MAN | White | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | ||||
| 18443 | op-snap---monthly-publication-march-2025.pdf | 2200 | 2025-03 | Pedal Bike | Hyundai | i40 | Black | Driving without Due Care and Attention | None | Vecqueray street at Far Gosford Street | Vecqueray street at Far Gosford Street | Coventry | Coventry | Warning Letter | Outside of 14 DAYS Late Submission | Yes - Via Email | 52.4066697 | -1.4969077 | |
| 18458 | op-snap---monthly-publication-march-2025.pdf | 2215 | 2025-03 | Car | Hyundai | Tucson | Grey | Driving without Due Care and Attention | None | WIDNEY ROAD | Widney Road | Solihull | Solihull | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.3795667 | -1.7478958 | |
| 18460 | op-snap---monthly-publication-march-2025.pdf | 2217 | 2025-03 | Car | Mercedes-Benz | GLC | Silver | Driving without Due Care and Attention | None | M6 Southbound nr Jn8 | M6 Southbound nr Jn8 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18462 | op-snap---monthly-publication-march-2025.pdf | 2219 | 2025-03 | Car | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | M6 J2 | M6 J2 | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.6760749 | -2.0862582 | |
| 18463 | op-snap---monthly-publication-march-2025.pdf | 2220 | 2025-03 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | M6 J2 | M6 J2 | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.6760749 | -2.0862582 | |
| 18464 | op-snap---monthly-publication-march-2025.pdf | 2221 | 2025-03 | Car | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | M6 J2 | M6 J2 | Coventry | Coventry | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.6760749 | -2.0862582 | |
| 18473 | op-snap---monthly-publication-march-2025.pdf | 2230 | 2025-03 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | M42 Motorway | M42 Motorway | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.490826 | -1.8882034 | |
| 18493 | op-snap---monthly-publication-march-2025.pdf | 2250 | 2025-03 | Pedal Bike | Ford | focus | Blue | Driving without Due Care and Attention | None | Dale Road | Dale Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4470038 | -1.9356202 | |
| 18495 | op-snap---monthly-publication-march-2025.pdf | 2252 | 2025-03 | Car | BMW | 325d | Black | Driving without Due Care and Attention | None | Peartree Lane | Peartree Lane | Dudley | Dudley | Warning Letter | N/A | Yes - Via Email | 52.4999595 | -2.0919022 | |
| 18532 | op-snap---monthly-publication-march-2025.pdf | 2289 | 2025-03 | Pedal Bike | Volvo | V40 | Grey | Driving without Due Care and Attention | None | Dog Pool Lane | Dog Pool Lane | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18533 | op-snap---monthly-publication-march-2025.pdf | 2290 | 2025-03 | Car | Ford | Ranger | Blue | Driving without Due Care and Attention | None | Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5642677 | -2.0755469 | |
| 18534 | op-snap---monthly-publication-march-2025.pdf | 2291 | 2025-03 | Car | Seat | Leon | White | Driving without Due Care and Attention | None | Kingswinford | Kingswinford | Dudley | Dudley | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4967692 | -2.1661721 | |
| 18535 | op-snap---monthly-publication-march-2025.pdf | 2292 | 2025-03 | Car | Nissan | X Trail | Red | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4014694 | -1.8220541 | |
| 18540 | op-snap---monthly-publication-march-2025.pdf | 2297 | 2025-03 | Car | Audi | A5 | Black | Driving without Due Care and Attention | None | M5 Junction 1 | M5 Junction 1 | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18545 | op-snap---monthly-publication-march-2025.pdf | 2302 | 2025-03 | Car | Vauxhall | Corsa | Red | Driving without Due Care and Attention | None | Henwood Road Wolverhampton | Henwood Road Wolverhampton | Wolverhampton | Wolverhampton | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5930037 | -2.1685306 | |
| 18551 | op-snap---monthly-publication-march-2025.pdf | 2308 | 2025-03 | Car | Renault | Clio | Grey | Driving without Due Care and Attention | None | Aston Church Road | Aston Church Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4998848 | -1.8630958 | |
| 18559 | op-snap---monthly-publication-march-2025.pdf | 2316 | 2025-03 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Boprdesely Green | Boprdesely Green | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 18561 | op-snap---monthly-publication-march-2025.pdf | 2318 | 2025-03 | Car | Porsche | Cayenne | Grey | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.4014694 | -1.8220541 | |
| 18565 | op-snap---monthly-publication-march-2025.pdf | 2322 | 2025-03 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | M42 | M42 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 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 | |
| 18570 | op-snap---monthly-publication-march-2025.pdf | 2327 | 2025-03 | Car | Renault | Capture | Silver | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 18577 | op-snap---monthly-publication-march-2025.pdf | 2334 | 2025-03 | Car | Ford | Puma | Black | Driving without Due Care and Attention | None | Boldmere Road | Boldmere Road | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | 52.548309 | -1.8411769 |
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);