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'}
5,123 rows where offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
- Volkswagen 594
- BMW 540
- Ford 499
- Audi 497
- Mercedes-Benz 455
- Vauxhall 303
- Toyota 289
- Seat 179
- Peugeot 149
- Nissan 140
- Hyundai 113
- Land Rover 113
- Skoda 113
- Honda 105
- Renault 104
- Volvo 81
- Citroen 79
- Kia 73
- Mini 49
- Fiat 47
- Suzuki 39
- Mazda 37
- Lexus 30
- Mg 30
- Porsche 30
- Tesla 27
- Yamaha 27
- Daf 24
- Jaguar 24
- Mitsubishi 19
- …
council_area >30
- Birmingham 2,348
- Out of Force Area 859
- Coventry 387
- Sandwell 331
- Dudley 262
- Solihull 260
- Wolverhampton 240
- Walsall 238
- Sutton Coldfield 113
- Halesowen 20
- Area 6
- Metropolitan Borough Of Dudley 4
- Out Of Force Area 4
- Metropolitan Borough 3
- Aorueta Of Force 2
- Soauntd Owf Eflolrce 2
- )Birmingham 1
- 4C4O4V)Entry 1
- Abyirmingham 1
- Ao)Ut Of Force Area 1
- Aofufts Opfo Floirccee) Area 1
- Aonudt B Olyf Tfhorce Area 1
- Bboiurmt Oinf Gthhea Mjunction 1
- Bdirmingham 1
- Borirt Mrionagdham 1
- Cst Arnadwell 1
- Do Ujnt 3Of Force Area 1
- Ds Bainrcdhwleeyll Island 1
- Ebtisrm Cinogrhnamer 1
- Eorucita Of Force Area 1
- …
month 14
disposal 8
- NFA 2,280
- Warning Letter 887
- Education 875
- Court 506
- Fixed Penalty 469
- RTC - Actioned 64
- Other Action Taken 40
- Duplicate Submission 2
reporter_transport_mode 1
- Car · 5,123 ✖
offence 1
- Driving without Due Care and Attention · 5,123 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7256 | op-snap---monthly-publication-february-2026.pdf | 3 | 2026-02 | Car | Audi | A5 | Black | Driving without Due Care and Attention | None | A38 | A38 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7257 | op-snap---monthly-publication-february-2026.pdf | 4 | 2026-02 | Car | Mazda | CX30 | Grey | Driving without Due Care and Attention | None | High Street, Quarry Bank | High Street, Quarry Bank | Dudley | Dudley | Education | N/A | 52.4576453 | -2.1150716 | ||
| 7259 | op-snap---monthly-publication-february-2026.pdf | 6 | 2026-02 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | A46 off force | A46 off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7266 | op-snap---monthly-publication-february-2026.pdf | 13 | 2026-02 | Car | Mercedes-Benz | CLA 250.. | White | Driving without Due Care and Attention | None | Solihull Bypass | Solihull Bypass | Solihull | Solihull | Fixed Penalty | N/A | 52.4207529 | -1.7757467 | ||
| 7270 | op-snap---monthly-publication-february-2026.pdf | 17 | 2026-02 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Hydes Road | Hydes Road | Sandwell | Sandwell | Court | N/A | 52.5538064 | -2.0139199 | ||
| 7272 | op-snap---monthly-publication-february-2026.pdf | 19 | 2026-02 | Car | Mg | HS | Black | Driving without Due Care and Attention | None | Russelsheim Way, Rugby | Russelsheim Way, Rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7273 | op-snap---monthly-publication-february-2026.pdf | 20 | 2026-02 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Footscray Road | Footscray Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7276 | op-snap---monthly-publication-february-2026.pdf | 23 | 2026-02 | Car | Suzuki | Jimny | Red | Driving without Due Care and Attention | None | Trumpet Terrace (Cumbria) | Trumpet Terrace (Cumbria) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7281 | op-snap---monthly-publication-february-2026.pdf | 28 | 2026-02 | Car | Mercedes-Benz | G63 | Black | Driving without Due Care and Attention | None | M6 Toll T8 | M6 Toll T8 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5804962 | -1.7833098 | ||
| 7282 | op-snap---monthly-publication-february-2026.pdf | 29 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Telford Trench | Telford Trench | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7291 | op-snap---monthly-publication-february-2026.pdf | 38 | 2026-02 | Car | Peugeot | 208 | Black | Driving without Due Care and Attention | None | St Peters Drive, Worcester | Street Peters Drive, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7311 | op-snap---monthly-publication-february-2026.pdf | 58 | 2026-02 | Car | Audi | A7 | Black | Driving without Due Care and Attention | None | Aldridge Road | Aldridge Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5668693 | -1.8879364 | ||
| 7319 | op-snap---monthly-publication-february-2026.pdf | 66 | 2026-02 | Car | Mercedes-Benz | 160 | White | Driving without Due Care and Attention | None | Ringway Queens | Ringway Queens | Coventry | Coventry | NFA | No Offence | 52.4039782 | -1.5161639 | ||
| 7322 | op-snap---monthly-publication-february-2026.pdf | 69 | 2026-02 | Car | Kia | Rio | White | Driving without Due Care and Attention | None | A16 Kirton | Kirton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7342 | op-snap---monthly-publication-february-2026.pdf | 89 | 2026-02 | Car | BMW | 116D | Red | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5170745 | -1.9012542 | ||
| 7344 | op-snap---monthly-publication-february-2026.pdf | 91 | 2026-02 | Car | Mini | Cooper | Black | Driving without Due Care and Attention | None | Telford Way | Telford Way | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5060705 | -1.9763452 | ||
| 7345 | op-snap---monthly-publication-february-2026.pdf | 92 | 2026-02 | Car | BMW | X4 | White | Driving without Due Care and Attention | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 7346 | op-snap---monthly-publication-february-2026.pdf | 93 | 2026-02 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | witton road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 7347 | op-snap---monthly-publication-february-2026.pdf | 94 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Streetly Road, Short Heath | Streetly Road, Short Heath | Birmingham | Birmingham | Education | N/A | 52.5316018 | -1.8581289 | ||
| 7356 | op-snap---monthly-publication-february-2026.pdf | 103 | 2026-02 | Car | BMW | M340i | Grey | Driving without Due Care and Attention | None | Great North Road, Retford | Great North Road, Retford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7365 | op-snap---monthly-publication-february-2026.pdf | 112 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Booth Street, Handsworth | Booth Street, Handsworth | Birmingham | Birmingham | Education | N/A | 52.5039035 | -1.9447084 | ||
| 7370 | op-snap---monthly-publication-february-2026.pdf | 117 | 2026-02 | Car | Honda | Jazz | Red | Driving without Due Care and Attention | None | Birchfield Island Olbury | Birchfield Island Olbury | Sandwell | Sandwell | Court | N/A | ||||
| 7372 | op-snap---monthly-publication-february-2026.pdf | 119 | 2026-02 | Car | Vauxhall | corsa | Red | Driving without Due Care and Attention | None | High Street | High Street | Dudley | Dudley | NFA | No Offence | 52.4779764 | -2.1598371 | ||
| 7390 | op-snap---monthly-publication-february-2026.pdf | 137 | 2026-02 | Car | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | Church Street | Church Street | Birmingham | Birmingham | Education | N/A | 52.5020781 | -1.9122368 | ||
| 7393 | op-snap---monthly-publication-february-2026.pdf | 140 | 2026-02 | Car | Toyota | Auris | Grey | Driving without Due Care and Attention | No Insurance | Crampers Field | Crampers Field | Coventry | Coventry | Court | N/A | 52.4176927 | -1.5257854 | ||
| 7403 | op-snap---monthly-publication-february-2026.pdf | 150 | 2026-02 | Car | Skoda | fabia | Blue | Driving without Due Care and Attention | None | A45, Kenilworth Road | A45, Kenilworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5124557 | -1.8917609 | ||
| 7404 | op-snap---monthly-publication-february-2026.pdf | 151 | 2026-02 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | A34 Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 7407 | op-snap---monthly-publication-february-2026.pdf | 154 | 2026-02 | Car | Skoda | Superb | Black | Driving without Due Care and Attention | None | Darmouth Middleway | Darmouth Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 7408 | op-snap---monthly-publication-february-2026.pdf | 155 | 2026-02 | Car | BMW | 118I | Grey | Driving without Due Care and Attention | None | Hall Green Road | Hall Green Road | Sandwell | Sandwell | Court | N/A | 52.5457385 | -1.9935809 | ||
| 7413 | op-snap---monthly-publication-february-2026.pdf | 160 | 2026-02 | Car | Ford | Kuga | Green | Driving without Due Care and Attention | None | Tipton Street | Tipton Street | Dudley | Dudley | RTC - Actioned | N/A | 52.5387558 | -2.1179869 | ||
| 7414 | op-snap---monthly-publication-february-2026.pdf | 161 | 2026-02 | Car | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No VRM | 52.6166864 | -1.9660822 | |||||
| 7418 | op-snap---monthly-publication-february-2026.pdf | 165 | 2026-02 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Venture Way | Venture Way | Dudley | Dudley | Warning Letter | N/A | 52.4836603 | -2.1189326 | ||
| 7422 | op-snap---monthly-publication-february-2026.pdf | 169 | 2026-02 | Car | Skoda | Fabia | Blue | Driving without Due Care and Attention | None | Vine Street (Cannock) | Vine Street (Cannock) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7450 | op-snap---monthly-publication-february-2026.pdf | 197 | 2026-02 | Car | Fiat | 500 | Blue | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Walsall | Walsall | NFA | 52.5867763 | -2.0104342 | |||
| 7475 | op-snap---monthly-publication-february-2026.pdf | 222 | 2026-02 | Car | Alfa Romeo | Spider | White | Driving without Due Care and Attention | None | B4455 | B4455 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3994858 | -1.4923603 | ||
| 7480 | op-snap---monthly-publication-february-2026.pdf | 227 | 2026-02 | Car | Toyota | C-HR | Blue | Driving without Due Care and Attention | None | Guarlford Road, Malvern | Guarlford Road, Malvern | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7484 | op-snap---monthly-publication-february-2026.pdf | 231 | 2026-02 | Car | Volkswagen | T-Cross | Grey | Driving without Due Care and Attention | None | A4040 Church Lane, Perry barr | Church Lane, Perry barr | Birmingham | Birmingham | Warning Letter | N/A | 52.5130255 | -1.9220091 | ||
| 7485 | op-snap---monthly-publication-february-2026.pdf | 232 | 2026-02 | Car | Peugeot | 2008.. | Blue | Driving without Due Care and Attention | None | Island Road | Island Road | Birmingham | Birmingham | NFA | No Offence | 52.5095686 | -1.9544485 | ||
| 7489 | op-snap---monthly-publication-february-2026.pdf | 236 | 2026-02 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 7496 | op-snap---monthly-publication-february-2026.pdf | 243 | 2026-02 | Car | Hyundai | I10 | Silver | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | Education | N/A | 52.4622646 | -1.8599985 | ||
| 7497 | op-snap---monthly-publication-february-2026.pdf | 244 | 2026-02 | Car | BMW | X1 | Blue | Driving without Due Care and Attention | None | Torcross Avenue | Torcross Avenue | Coventry | Coventry | Education | N/A | 52.4218194 | -1.46546 | ||
| 7503 | op-snap---monthly-publication-february-2026.pdf | 250 | 2026-02 | Car | Fiat | 500 | White | Driving without Due Care and Attention | None | M54 Motorway, jn4 | M54 Motorway, jn4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7505 | op-snap---monthly-publication-february-2026.pdf | 252 | 2026-02 | Car | Seat | Cupra | Grey | Driving without Due Care and Attention | None | Sand Pits | Sand Pits | Birmingham | Birmingham | Education | N/A | ||||
| 7509 | op-snap---monthly-publication-february-2026.pdf | 256 | 2026-02 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Education | N/A | 52.50787 | -1.8195713 | ||
| 7513 | op-snap---monthly-publication-february-2026.pdf | 260 | 2026-02 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 7532 | op-snap---monthly-publication-february-2026.pdf | 279 | 2026-02 | Car | Lexus | CT200 | White | Driving without Due Care and Attention | None | Cross Street South | Cross Street South | Wolverhampton | Wolverhampton | Education | N/A | 52.570955 | -2.130838 | ||
| 7534 | op-snap---monthly-publication-february-2026.pdf | 281 | 2026-02 | Car | Mercedes-Benz | SLK200 | Silver | Driving without Due Care and Attention | None | A51 Birmingham Road | Birmingham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7535 | op-snap---monthly-publication-february-2026.pdf | 282 | 2026-02 | Car | Peugeot | 206 | Silver | Driving without Due Care and Attention | None | Winding House Lane | Winding House Lane | Coventry | Coventry | Education | N/A | 52.4490457 | -1.5001195 | ||
| 7537 | op-snap---monthly-publication-february-2026.pdf | 284 | 2026-02 | Car | Renault | Megane | Silver | Driving without Due Care and Attention | None | Bradley Lane | Bradley Lane | Birmingham | Birmingham | NFA | No VRM | ||||
| 7546 | op-snap---monthly-publication-february-2026.pdf | 293 | 2026-02 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Diss Aldi Carpark (Norfolk) | Diss Aldi Carpark (Norfolk) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7567 | op-snap---monthly-publication-february-2026.pdf | 314 | 2026-02 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Friary Road | Friary Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5162814 | -1.9395798 | ||
| 7573 | op-snap---monthly-publication-february-2026.pdf | 320 | 2026-02 | Car | Peugeot | 2008GT | Grey | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 7579 | op-snap---monthly-publication-february-2026.pdf | 326 | 2026-02 | Car | Kia | Xceed | Grey | Driving without Due Care and Attention | None | Birmingham New Road | Birmingham New Road | Dudley | Dudley | Education | N/A | 52.5478387 | -2.0943116 | ||
| 7590 | op-snap---monthly-publication-february-2026.pdf | 337 | 2026-02 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | Court | N/A | 52.4349375 | -1.8510007 | ||
| 7593 | op-snap---monthly-publication-february-2026.pdf | 340 | 2026-02 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Walford Road | Walford Road | Birmingham | Birmingham | Court | N/A | 52.4594072 | -1.8658859 | ||
| 7596 | op-snap---monthly-publication-february-2026.pdf | 343 | 2026-02 | Car | Citroen | C3.. | White | Driving without Due Care and Attention | None | New John Street West | New John Street West | Birmingham | Birmingham | Education | N/A | 52.4944784 | -1.9122329 | ||
| 7597 | op-snap---monthly-publication-february-2026.pdf | 344 | 2026-02 | Car | Citroen | C3 | Silver | Driving without Due Care and Attention | None | Barnes Hill | Barnes Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4401325 | -1.9785938 | ||
| 7600 | op-snap---monthly-publication-february-2026.pdf | 347 | 2026-02 | Car | Peugeot | 208 | Silver | Driving without Due Care and Attention | None | KENT | Kent | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4719651 | -1.8980931 | ||
| 7603 | op-snap---monthly-publication-february-2026.pdf | 350 | 2026-02 | Car | Hyundai | 130 | Blue | Driving without Due Care and Attention | None | A46 Coventry | Coventry | Coventry | Coventry | Education | N/A | 52.400739 | -1.5135474 | ||
| 7604 | op-snap---monthly-publication-february-2026.pdf | 351 | 2026-02 | Car | BMW | X5 | Grey | Driving without Due Care and Attention | None | M6 Junction 15 | M6 Junction 15 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 7612 | op-snap---monthly-publication-february-2026.pdf | 359 | 2026-02 | Car | Skoda | Fabia | Black | Driving without Due Care and Attention | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | NFA | No Offence | 52.4468464 | -1.9454816 | ||
| 7614 | op-snap---monthly-publication-february-2026.pdf | 361 | 2026-02 | Car | Mg | HS | Red | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Dudley | Dudley | Warning Letter | N/A | 52.4881161 | -2.1199108 | ||
| 7617 | op-snap---monthly-publication-february-2026.pdf | 364 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | The Embankment | The Embankment | Dudley | Dudley | NFA | No Offence | 52.4826167 | -2.1144546 | ||
| 7618 | op-snap---monthly-publication-february-2026.pdf | 365 | 2026-02 | Car | Man | TGE | White | Driving without Due Care and Attention | None | The Embankment | The Embankment | Dudley | Dudley | NFA | No Offence | 52.4826167 | -2.1144546 | ||
| 7619 | op-snap---monthly-publication-february-2026.pdf | 366 | 2026-02 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 7622 | op-snap---monthly-publication-february-2026.pdf | 369 | 2026-02 | Car | Kia | Sportage | Brown | Driving without Due Care and Attention | None | M42 Jct 11 Roundabout | M42 Junction 11 Roundabout | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7625 | op-snap---monthly-publication-february-2026.pdf | 372 | 2026-02 | Car | Mercedes-Benz | CLA 220 | Red | Driving without Due Care and Attention | None | Coventry A45 W | Coventry A45 W | Coventry | Coventry | Education | N/A | 52.4314215 | -1.5948907 | ||
| 7633 | op-snap---monthly-publication-february-2026.pdf | 380 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Leicester Road Rugby (Warcs) | Leicester Road Rugby (Warcs) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7640 | op-snap---monthly-publication-february-2026.pdf | 387 | 2026-02 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Cheltenham Road, Bishop's Cleve | Cheltenham Road, Bishop's Cleve | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7641 | op-snap---monthly-publication-february-2026.pdf | 388 | 2026-02 | Car | Peugeot | 408 | Silver | Driving without Due Care and Attention | None | Monmouth Drive | Monmouth Drive | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5575249 | -1.8640053 | ||
| 7642 | op-snap---monthly-publication-february-2026.pdf | 389 | 2026-02 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | A38M | A38M | Birmingham | Birmingham | NFA | No Offence | ||||
| 7644 | op-snap---monthly-publication-february-2026.pdf | 391 | 2026-02 | Car | Ford | Transit Connect | Black | Driving without Due Care and Attention | None | Ambergate Road / Highfield Rd, Bilston | Ambergate Road / Highfield Road, Bilston | Wolverhampton | Wolverhampton | Education | N/A | 52.5597351 | -2.081298 | ||
| 7647 | op-snap---monthly-publication-february-2026.pdf | 394 | 2026-02 | Car | Dennis Bus | Red | Driving without Due Care and Attention | None | Sallbrook Queensway | Sallbrook Queensway | Birmingham | Birmingham | NFA | Not in Public Interest | |||||
| 7650 | op-snap---monthly-publication-february-2026.pdf | 397 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 7658 | op-snap---monthly-publication-february-2026.pdf | 405 | 2026-02 | Car | Audi | A4 | Red | Driving without Due Care and Attention | None | Hustcroft Road | Hustcroft Road | Birmingham | Birmingham | Education | N/A | ||||
| 7664 | op-snap---monthly-publication-february-2026.pdf | 411 | 2026-02 | Car | Peugeot | 5008 | Black | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 7665 | op-snap---monthly-publication-february-2026.pdf | 412 | 2026-02 | Car | Volkswagen | Taigo | White | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 7675 | op-snap---monthly-publication-february-2026.pdf | 422 | 2026-02 | Car | Volkswagen | Transporter | Grey | Driving without Due Care and Attention | None | A34 Walsall Road | Walsall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5919543 | -1.8517118 | ||
| 7681 | op-snap---monthly-publication-february-2026.pdf | 428 | 2026-02 | Car | Hyundai | Ionic | Silver | Driving without Due Care and Attention | None | A316 Sunbury Cross | Sunbury Cross | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7685 | op-snap---monthly-publication-february-2026.pdf | 432 | 2026-02 | Car | Audi | Q2 | Blue | Driving without Due Care and Attention | None | Leamore Lane | Leamore Lane | Walsall | Walsall | Education | N/A | 52.6056653 | -2.0050776 | ||
| 7688 | op-snap---monthly-publication-february-2026.pdf | 435 | 2026-02 | Car | Citroen | Berlingo | Silver | Driving without Due Care and Attention | None | Wallows Lane | Wallows Lane | Walsall | Walsall | NFA | No Offence | 52.5699435 | -2.0008354 | ||
| 7690 | op-snap---monthly-publication-february-2026.pdf | 437 | 2026-02 | Car | Ford | KA | Silver | Driving without Due Care and Attention | None | Huffley Lane | Huffley Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7692 | op-snap---monthly-publication-february-2026.pdf | 439 | 2026-02 | Car | Volkswagen | Tiguan | White | Driving without Due Care and Attention | None | JCT 11 M6 | Jct 11 M6 | Walsall | Walsall | NFA | No Offence | ||||
| 7693 | op-snap---monthly-publication-february-2026.pdf | 440 | 2026-02 | Car | BMW | X Drive | Black | Driving without Due Care and Attention | None | M5 Southbound | M5 Southbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7695 | op-snap---monthly-publication-february-2026.pdf | 442 | 2026-02 | Car | Land Rover | Evoque | Black | Driving without Due Care and Attention | None | M6 SB J19 | M6 Southbound J19 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7710 | op-snap---monthly-publication-february-2026.pdf | 457 | 2026-02 | Car | BMW | X3 M | Grey | Driving without Due Care and Attention | None | Heath Way | Heath Way | Birmingham | Birmingham | Education | N/A | 52.4963549 | -1.7806171 | ||
| 7717 | op-snap---monthly-publication-february-2026.pdf | 464 | 2026-02 | Car | Citroen | C4 | Blue | Driving without Due Care and Attention | None | Oakham Road | Oakham Road | Dudley | Dudley | NFA | No Offence | 52.5030757 | -2.0663819 | ||
| 7718 | op-snap---monthly-publication-february-2026.pdf | 465 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Education | N/A | 52.471632 | -1.9456776 | ||
| 7723 | op-snap---monthly-publication-february-2026.pdf | 470 | 2026-02 | Car | Kia | EV3 | Green | Driving without Due Care and Attention | None | Tanworth Lane | Tanworth Lane | Solihull | Solihull | Education | N/A | 52.4014694 | -1.8220541 | ||
| 7730 | op-snap---monthly-publication-february-2026.pdf | 477 | 2026-02 | Car | Audi | S3 | Blue | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 7732 | op-snap---monthly-publication-february-2026.pdf | 479 | 2026-02 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | No Insurance | Stourbridge Ring Road | Stourbridge Ring Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4590366 | -2.1465735 | ||
| 7738 | op-snap---monthly-publication-february-2026.pdf | 485 | 2026-02 | Car | Volkswagen | Polo | Purple | Driving without Due Care and Attention | No Insurance | Meadway Road | Meadway Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4758428 | -1.7931767 | ||
| 7742 | op-snap---monthly-publication-february-2026.pdf | 489 | 2026-02 | Car | Vauxhall | Corsa | Orange | Driving without Due Care and Attention | None | High Street, Stourbridge | High Street, Stourbridge | Dudley | Dudley | Warning Letter | N/A | 52.4570763 | -2.1136199 | ||
| 7752 | op-snap---monthly-publication-february-2026.pdf | 499 | 2026-02 | Car | Volkswagen | V40.. | Blue | Driving without Due Care and Attention | None | Chadd Road Coseley | Chadd Road Coseley | Dudley | Dudley | Other Action Taken | N/A | ||||
| 7753 | op-snap---monthly-publication-february-2026.pdf | 500 | 2026-02 | Car | Honda | CRV | Black | Driving without Due Care and Attention | None | Northampton Road, Rugby | Northampton Road, Rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7754 | op-snap---monthly-publication-february-2026.pdf | 501 | 2026-02 | Car | Citroen | Berlingo | Silver | Driving without Due Care and Attention | None | Fletchamstead Highway | Fletchamstead Highway | Coventry | Coventry | Warning Letter | N/A | 52.396476 | -1.5561348 | ||
| 7756 | op-snap---monthly-publication-february-2026.pdf | 503 | 2026-02 | Car | Toyota | Prius | Silver | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 7769 | op-snap---monthly-publication-february-2026.pdf | 516 | 2026-02 | Car | Mercedes-Benz | GLA | black | Driving without Due Care and Attention | None | Kenilworth Road, A452, nr Balsall Common | Kenilworth Road, A452, nr Balsall Common | Solihull | Solihull | Warning Letter | N/A | ||||
| 7775 | op-snap---monthly-publication-february-2026.pdf | 522 | 2026-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Watling Street | Watling Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562907 | -1.9111505 | ||
| 7779 | op-snap---monthly-publication-february-2026.pdf | 526 | 2026-02 | Car | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Curzon Circle | Curzon Circle | Birmingham | Birmingham | Warning Letter | N/A | 52.4834655 | -1.8801763 |
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);