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'}
3,282 rows where council_area = "Birmingham" and offence = "Driving without Due Care and Attention" 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 >30
- Volkswagen 413
- Audi 331
- BMW 323
- Ford 311
- Mercedes-Benz 306
- Toyota 225
- Vauxhall 194
- Seat 125
- Nissan 90
- Peugeot 86
- Honda 80
- Hyundai 76
- Skoda 71
- Renault 61
- Land Rover 54
- Kia 47
- Volvo 47
- Citroen 46
- Fiat 32
- Mini 29
- Mg 21
- Suzuki 21
- Yamaha 20
- Jaguar 19
- Mazda 19
- Lexus 17
- Tesla 17
- Porsche 15
- Mitsubishi 13
- Daf 8
- …
month 14
reporter_transport_mode 11
- Car 2,348
- Pedal Bike 643
- Pedestrian 169
- Other 70
- Motorbike 19
- Lorry 14
- car 12
- Bus 2
- CAR 2
- Van 2
- Horse Rider 1
disposal 8
- NFA 1,052
- Education 817
- Warning Letter 696
- Court 332
- Fixed Penalty 304
- RTC - Actioned 49
- Other Action Taken 30
- Duplicate Submission 2
offence 1
- Driving without Due Care and Attention · 3,282 ✖
council_area 1
- Birmingham · 3,282 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7297 | op-snap---monthly-publication-february-2026.pdf | 44 | 2026-02 | Pedal Bike | Toyota | Prius | Red | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7298 | op-snap---monthly-publication-february-2026.pdf | 45 | 2026-02 | Pedal Bike | Peugeot | 3008 | Grey | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 7299 | op-snap---monthly-publication-february-2026.pdf | 46 | 2026-02 | Pedal Bike | Toyota | Auris | Brown | Driving without Due Care and Attention | None | Franklin Road | Franklin Road | Birmingham | Birmingham | Education | N/A | 52.4195456 | -1.9350703 | ||
| 7305 | op-snap---monthly-publication-february-2026.pdf | 52 | 2026-02 | Pedal Bike | BMW | Black | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | |||
| 7330 | op-snap---monthly-publication-february-2026.pdf | 77 | 2026-02 | Pedal Bike | Ford | Focus | Grey | Driving without Due Care and Attention | None | Trittiford Road | Trittiford Road | Birmingham | Birmingham | Education | N/A | 52.4248084 | -1.8660294 | ||
| 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 | ||
| 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 | ||
| 7353 | op-snap---monthly-publication-february-2026.pdf | 100 | 2026-02 | Pedal Bike | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 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 | ||
| 7380 | op-snap---monthly-publication-february-2026.pdf | 127 | 2026-02 | Pedal Bike | Honda | Civic | Grey | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7381 | op-snap---monthly-publication-february-2026.pdf | 128 | 2026-02 | Pedal Bike | Volvo | V60 | Black | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7383 | op-snap---monthly-publication-february-2026.pdf | 130 | 2026-02 | Pedal Bike | Mercedes-Benz | 180 | Grey | Driving without Due Care and Attention | None | Weoley Castle | Weoley Castle | Birmingham | Birmingham | Education | N/A | 52.4428373 | -1.9698276 | ||
| 7384 | op-snap---monthly-publication-february-2026.pdf | 131 | 2026-02 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 7387 | op-snap---monthly-publication-february-2026.pdf | 134 | 2026-02 | Other | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | Other Action Taken | N/A | 52.5054363 | -1.8556273 | ||
| 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 | ||
| 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 | ||||
| 7419 | op-snap---monthly-publication-february-2026.pdf | 166 | 2026-02 | Pedal Bike | Volvo | XC60 | White | Driving without Due Care and Attention | None | Bournville Lane | Bournville Lane | Birmingham | Birmingham | Education | N/A | 52.4271614 | -1.9302862 | ||
| 7426 | op-snap---monthly-publication-february-2026.pdf | 173 | 2026-02 | Pedal Bike | Toyota | Estima | Silver | Driving without Due Care and Attention | None | Weoley Park Road | Weoley Park Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4368136 | -1.9495478 | ||
| 7427 | op-snap---monthly-publication-february-2026.pdf | 174 | 2026-02 | Pedal Bike | Chysler | Grand Voyager | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 7430 | op-snap---monthly-publication-february-2026.pdf | 177 | 2026-02 | Pedal Bike | Mg | ZR | Black | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 7442 | op-snap---monthly-publication-february-2026.pdf | 189 | 2026-02 | Pedal Bike | Mercedes-Benz | E220 | Silver | Driving without Due Care and Attention | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Court | N/A | 52.4708802 | -1.8792135 | ||
| 7454 | op-snap---monthly-publication-february-2026.pdf | 201 | 2026-02 | Pedal Bike | Volkswagen | Tayron | Grey | Driving without Due Care and Attention | None | Hallam Street | Hallam Street | Birmingham | Birmingham | Education | N/A | 52.4563937 | -1.8933429 | ||
| 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 | ||
| 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 | ||
| 7514 | op-snap---monthly-publication-february-2026.pdf | 261 | 2026-02 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Ridgacre Road | Ridgacre Road | Birmingham | Birmingham | Education | N/A | 52.4593367 | -2.0000298 | ||
| 7536 | op-snap---monthly-publication-february-2026.pdf | 283 | 2026-02 | Pedal Bike | Mercedes-Benz | ML320 | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 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 | ||||
| 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 | ||
| 7575 | op-snap---monthly-publication-february-2026.pdf | 322 | 2026-02 | Other | Seat | Alteca | Grey | Driving without Due Care and Attention | None | Orphange Road / Chester Road | Orphange Road / Chester Road | Birmingham | Birmingham | Education | N/A | ||||
| 7577 | op-snap---monthly-publication-february-2026.pdf | 324 | 2026-02 | Pedal Bike | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Bromyard Road | Bromyard Road | Birmingham | Birmingham | Education | N/A | 52.4457403 | -1.8536648 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 7682 | op-snap---monthly-publication-february-2026.pdf | 429 | 2026-02 | Pedal Bike | Land Rover | Discovery | Brown | Driving without Due Care and Attention | None | Redhill Road | Redhill Road | Birmingham | Birmingham | Education | N/A | 52.4618364 | -1.8328803 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7794 | op-snap---monthly-publication-february-2026.pdf | 541 | 2026-02 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | M6 Junction 6 | M6 Junction 6 | Birmingham | Birmingham | Warning Letter | N/A | 52.676119 | -2.0858425 | ||
| 7797 | op-snap---monthly-publication-february-2026.pdf | 544 | 2026-02 | Car | Peugeot | White | Driving without Due Care and Attention | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4749336 | -1.9003475 | |||
| 7801 | op-snap---monthly-publication-february-2026.pdf | 548 | 2026-02 | Car | Byd | Bus | Grey | Driving without Due Care and Attention | None | Haden Way | Haden Way | Birmingham | Birmingham | Education | N/A | 52.4596018 | -1.8864623 | ||
| 7803 | op-snap---monthly-publication-february-2026.pdf | 550 | 2026-02 | Car | Toyota | Corolla | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7805 | op-snap---monthly-publication-february-2026.pdf | 552 | 2026-02 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Court | N/A | 52.4198291 | -1.9241732 | ||
| 7808 | op-snap---monthly-publication-february-2026.pdf | 555 | 2026-02 | Car | Toyota | Corolla | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5274116 | -1.9287273 | ||
| 7809 | op-snap---monthly-publication-february-2026.pdf | 556 | 2026-02 | Car | Mercedes-Benz | A180 | Red | Driving without Due Care and Attention | None | A38 | A38 | Birmingham | Birmingham | Education | N/A | ||||
| 7815 | op-snap---monthly-publication-february-2026.pdf | 562 | 2026-02 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Yardley Road | Yardley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613544 | -1.8160137 | ||
| 7819 | op-snap---monthly-publication-february-2026.pdf | 566 | 2026-02 | Car | Audi | A3 | Red | Driving without Due Care and Attention | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4397168 | -1.9260414 | ||
| 7820 | op-snap---monthly-publication-february-2026.pdf | 567 | 2026-02 | Car | Mazda | 6 | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 7839 | op-snap---monthly-publication-february-2026.pdf | 586 | 2026-02 | Pedal Bike | Skoda | Octavia | Blue | Driving without Due Care and Attention | No Insurance | Dads Lane | Dads Lane | Birmingham | Birmingham | Court | N/A | 52.4375913 | -1.9068522 | ||
| 7841 | op-snap---monthly-publication-february-2026.pdf | 588 | 2026-02 | Pedal Bike | Kia | Sport | White | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Education | N/A | 52.4656414 | -1.9852276 | ||
| 7843 | op-snap---monthly-publication-february-2026.pdf | 590 | 2026-02 | Pedal Bike | Toyota | Prius | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 7844 | op-snap---monthly-publication-february-2026.pdf | 591 | 2026-02 | Car | Mini | One | Black | Driving without Due Care and Attention | None | A456 J3 M5 | A456 J3 M5 | Birmingham | Birmingham | NFA | No Offence | ||||
| 7846 | op-snap---monthly-publication-february-2026.pdf | 593 | 2026-02 | Car | Audi | A1 | White | Driving without Due Care and Attention | None | Cole Valley Road | Cole Valley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4255079 | -1.8570247 | ||
| 7849 | op-snap---monthly-publication-february-2026.pdf | 596 | 2026-02 | Pedal Bike | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Gillhurst Road | Gillhurst Road | Birmingham | Birmingham | Court | N/A | 52.467676 | -1.9548345 | ||
| 7862 | op-snap---monthly-publication-february-2026.pdf | 609 | 2026-02 | Pedal Bike | Audi | TT | Blue | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Education | N/A | 52.4656414 | -1.9852276 | ||
| 7873 | op-snap---monthly-publication-february-2026.pdf | 620 | 2026-02 | Car | Yamaha | YZF125 | White | Driving without Due Care and Attention | None | Station Road, Stechford | Station Road, Stechford | Birmingham | Birmingham | Education | N/A | 52.480771 | -1.8086714 | ||
| 7876 | op-snap---monthly-publication-february-2026.pdf | 623 | 2026-02 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Anglesey Street, Lozells | Anglesey Street, Lozells | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 7878 | op-snap---monthly-publication-february-2026.pdf | 625 | 2026-02 | Car | Tesla | Model Y | White | Driving without Due Care and Attention | None | Anglesey Street | Anglesey Street | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 7885 | op-snap---monthly-publication-february-2026.pdf | 632 | 2026-02 | Car | Vauxhall | Corsa | Blue | Driving without Due Care and Attention | None | M6 after J4 | M6 after J4 | Birmingham | Birmingham | Education | N/A | ||||
| 7887 | op-snap---monthly-publication-february-2026.pdf | 634 | 2026-02 | Car | Audi | A4 | Black | Driving without Due Care and Attention | None | Burman Street | Burman Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 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 | ||
| 7921 | op-snap---monthly-publication-february-2026.pdf | 668 | 2026-02 | Car | Volkswagen | Caddy | White | Driving without Due Care and Attention | None | J10 slip M6 towards Bham | J10 slip M6 towards Bham | Birmingham | Birmingham | Education | N/A | ||||
| 7939 | op-snap---monthly-publication-february-2026.pdf | 686 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Monument Road | Monument Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4731312 | -1.930947 | ||
| 7943 | op-snap---monthly-publication-february-2026.pdf | 690 | 2026-02 | Car | Audi | Red | Driving without Due Care and Attention | None | West Boulevard | West Boulevard | Birmingham | Birmingham | Education | N/A | 52.4484674 | -1.9780395 | |||
| 7967 | op-snap---monthly-publication-february-2026.pdf | 714 | 2026-02 | Car | Volkswagen | White | Driving without Due Care and Attention | None | Woodland Road | Woodland Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4108681 | -1.9611917 | |||
| 7970 | op-snap---monthly-publication-february-2026.pdf | 717 | 2026-02 | Car | Audi | TT | White | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Other Action Taken | N/A | 52.4668753 | -1.8996143 | ||
| 7974 | op-snap---monthly-publication-february-2026.pdf | 721 | 2026-02 | Car | Suzuki | Alto | Silver | Driving without Due Care and Attention | None | Pages Lane | Pages Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.3954143 | -1.9791764 | ||
| 7998 | op-snap---monthly-publication-february-2026.pdf | 745 | 2026-02 | Car | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5170745 | -1.9012542 | ||
| 8014 | op-snap---monthly-publication-february-2026.pdf | 761 | 2026-02 | Car | Citroen | C3 | Black | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Education | N/A | 52.4198291 | -1.9241732 | ||
| 8015 | op-snap---monthly-publication-february-2026.pdf | 762 | 2026-02 | Pedal Bike | Audi | A3 | Green | Driving without Due Care and Attention | None | Pritchatts Road, Edgbaston | Pritchatts Road, Edgbaston | Birmingham | Birmingham | Court | N/A | 52.4563161 | -1.934895 | ||
| 8031 | op-snap---monthly-publication-february-2026.pdf | 778 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Tessall Lane | Tessall Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4045186 | -1.9891793 | ||
| 8037 | op-snap---monthly-publication-february-2026.pdf | 784 | 2026-02 | Car | BMW | 320i | Grey | Driving without Due Care and Attention | None | Holloway Circus Queensway | Holloway Circus Queensway | Birmingham | Birmingham | NFA | No Offence | 52.4751679 | -1.9006538 | ||
| 8039 | op-snap---monthly-publication-february-2026.pdf | 786 | 2026-02 | Car | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Russell Road | Russell Road | Birmingham | Birmingham | Education | N/A | 52.4398245 | -1.8469786 | ||
| 8040 | op-snap---monthly-publication-february-2026.pdf | 787 | 2026-02 | Pedal Bike | Peugeot | 5008 | Silver | Driving without Due Care and Attention | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 8041 | op-snap---monthly-publication-february-2026.pdf | 788 | 2026-02 | Car | Toyota | CHR | Grey | Driving without Due Care and Attention | None | St Chads Queensway | Street Chads Queensway | Birmingham | Birmingham | NFA | No Offence | ||||
| 8045 | op-snap---monthly-publication-february-2026.pdf | 792 | 2026-02 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Battery Way | Battery Way | Birmingham | Birmingham | Court | N/A | 52.4493988 | -1.8476406 | ||
| 8051 | op-snap---monthly-publication-february-2026.pdf | 798 | 2026-02 | Car | Volkswagen | Caddy | Blue | Driving without Due Care and Attention | None | Kings Road, Tyseley | Kings Road, Tyseley | Birmingham | Birmingham | Education | N/A | 52.4572996 | -1.8391692 | ||
| 8060 | op-snap---monthly-publication-february-2026.pdf | 807 | 2026-02 | Car | Nissan | Juke | Blue | Driving without Due Care and Attention | None | Victoria Road Perry Barr | Victoria Road Perry Barr | Birmingham | Birmingham | Education | N/A | 52.5024231 | -1.8980876 | ||
| 8065 | op-snap---monthly-publication-february-2026.pdf | 812 | 2026-02 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | No Insurance | A45 Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | Court | N/A | 52.4709298 | -1.8722585 | ||
| 8066 | op-snap---monthly-publication-february-2026.pdf | 813 | 2026-02 | Car | Suzuki | Alto | Grey | Driving without Due Care and Attention | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | Education | N/A | 52.4883936 | -1.8310056 |
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);