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'}
178 rows where council_area = "Birmingham", month = "2025-02" and offence = "Driving without Due Care and Attention" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 25
disposal 7
- Fixed Penalty 52
- Education 40
- Warning Letter 37
- Court 26
- NFA 19
- Other Action Taken 2
- RTC - Actioned 2
reporter_transport_mode 5
- Car 143
- Pedal Bike 26
- Pedestrian 7
- Motorbike 1
- Other 1
offence 1
- Driving without Due Care and Attention · 178 ✖
month 1
- 2025-02 · 178 ✖
council_area 1
- Birmingham · 178 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5197 | op-snap---monthly-publication-february-2025.pdf | 14 | 2025-02 | Car | Audi | QUATTRO | Black | Driving without Due Care and Attention | None | HOLDER ROAD | Holder Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4655509 | -1.8219 | |
| 5226 | op-snap---monthly-publication-february-2025.pdf | 43 | 2025-02 | Pedal Bike | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Forest Road, Moseley | Forest Road, Moseley | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4467275 | -1.8804014 | |
| 5227 | op-snap---monthly-publication-february-2025.pdf | 44 | 2025-02 | Car | Mercedes-Benz | SPRINTER | White | Driving without Due Care and Attention | None | BLACK COUNTRY ROUTE | Black Country Route | Birmingham | Birmingham | Warning Letter | Outside of 14 Days NIP | Yes - Via Email | |||
| 5229 | op-snap---monthly-publication-february-2025.pdf | 46 | 2025-02 | Car | Toyota | Aygo | Orange | Driving without Due Care and Attention | None | Great Hampton Street | Great Hampton Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4910446 | -1.9105163 | |
| 5256 | op-snap---monthly-publication-february-2025.pdf | 73 | 2025-02 | Car | Honda | CIVIC | BLACK | Driving without Due Care and Attention | No vehicle excise licence | BROMFORD LANE | Bromford Lane | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 5271 | op-snap---monthly-publication-february-2025.pdf | 88 | 2025-02 | Car | Fiat | 500 | Black | Driving without Due Care and Attention | None | Mackadown Lane | Mackadown Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4708415 | -1.7675939 | |
| 5278 | op-snap---monthly-publication-february-2025.pdf | 95 | 2025-02 | Car | Volkswagen | T-cross | Black | Driving without Due Care and Attention | None | Birchfield Lane | Birchfield Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 5297 | op-snap---monthly-publication-february-2025.pdf | 114 | 2025-02 | Car | Mercedes-Benz | E220 | Grey | Driving without Due Care and Attention | None | FRIARY ROAD | Friary Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5162814 | -1.9395798 | |
| 5298 | op-snap---monthly-publication-february-2025.pdf | 115 | 2025-02 | Car | Volkswagen | GOLF R | Black | Driving without Due Care and Attention | None | HIGH STREET, ASTON | High Street, Aston | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4973154 | -1.8956143 | |
| 5299 | op-snap---monthly-publication-february-2025.pdf | 116 | 2025-02 | Car | Toyota | COROLLA | Black | Driving without Due Care and Attention | None | VILLA STREET | Villa Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.500382 | -1.913307 | |
| 5304 | op-snap---monthly-publication-february-2025.pdf | 121 | 2025-02 | Car | Vauxhall | Vivaro | White | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 5323 | op-snap---monthly-publication-february-2025.pdf | 140 | 2025-02 | Car | Ford | Fiesat | Silver | Driving without Due Care and Attention | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4745488 | -1.8065911 | |
| 5324 | op-snap---monthly-publication-february-2025.pdf | 141 | 2025-02 | Car | Toyota | PRIUS | Silver | Driving without Due Care and Attention | None | PORTLAND ROAD | Portland Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4737014 | -1.9412436 | |
| 5331 | op-snap---monthly-publication-february-2025.pdf | 148 | 2025-02 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | No Insurance | Church Lane | Church Lane | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5030217 | -1.8764632 | |
| 5333 | op-snap---monthly-publication-february-2025.pdf | 150 | 2025-02 | Car | Mercedes-Benz | CLA220 | Black | Driving without Due Care and Attention | None | Hagley Rd, Edgbaston | Hagley Road, Edgbaston | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4719401 | -1.9323711 | |
| 5354 | op-snap---monthly-publication-february-2025.pdf | 171 | 2025-02 | Car | Peugeot | 2008 | White | Driving without Due Care and Attention | None | Alcester Road at Salisbury Road | Alcester Road at Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4467548 | -1.8880528 | |
| 5356 | op-snap---monthly-publication-february-2025.pdf | 173 | 2025-02 | Car | Vauxhall | CORSA | White | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5357 | op-snap---monthly-publication-february-2025.pdf | 174 | 2025-02 | Car | Mercedes-Benz | C CLASS | White | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5358 | op-snap---monthly-publication-february-2025.pdf | 175 | 2025-02 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5359 | op-snap---monthly-publication-february-2025.pdf | 176 | 2025-02 | Car | Seat | LEON | White | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5360 | op-snap---monthly-publication-february-2025.pdf | 177 | 2025-02 | Car | Volkswagen | TIGUAN | Blue | Driving without Due Care and Attention | No vehicle excise licence | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5361 | op-snap---monthly-publication-february-2025.pdf | 178 | 2025-02 | Car | Audi | A5 | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5363 | op-snap---monthly-publication-february-2025.pdf | 180 | 2025-02 | Car | Audi | RS3 | Silver | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5364 | op-snap---monthly-publication-february-2025.pdf | 181 | 2025-02 | Car | Hyundai | I40 | White | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5365 | op-snap---monthly-publication-february-2025.pdf | 182 | 2025-02 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | Montague Street | Montague Street | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 5368 | op-snap---monthly-publication-february-2025.pdf | 185 | 2025-02 | Car | Ford | TRANSIT | White | Driving without Due Care and Attention | None | MONICA ROAD | Monica Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4714936 | -1.8386654 | |
| 5369 | op-snap---monthly-publication-february-2025.pdf | 186 | 2025-02 | Car | Hyundai | Kona | Black | Driving without Due Care and Attention | None | College Road | College Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5151832 | -1.9361664 | |
| 5370 | op-snap---monthly-publication-february-2025.pdf | 187 | 2025-02 | Car | Lexus | CT | Red | Driving without Due Care and Attention | None | Park Road | Park Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5641687 | -1.8272087 | |
| 5378 | op-snap---monthly-publication-february-2025.pdf | 195 | 2025-02 | Car | Suzuki | GSF1250 | Black | Driving without Due Care and Attention | No Insurance | BRANDWOOD | Brandwood | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.4167623 | -1.8959344 | |
| 5413 | op-snap---monthly-publication-february-2025.pdf | 230 | 2025-02 | Pedal Bike | Mg | ZS | Silver | Driving without Due Care and Attention | None | GIBBINS ROAD | Gibbins Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4390303 | -1.9512931 | |
| 5438 | op-snap---monthly-publication-february-2025.pdf | 255 | 2025-02 | Pedal Bike | Suzuki | Alto | White | Driving without Due Care and Attention | None | Redhill Rd and A441 Kings Norton | Redhill Road and A441 Kings Norton | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.3942085 | -1.9534932 | |
| 5441 | op-snap---monthly-publication-february-2025.pdf | 258 | 2025-02 | Car | Vauxhall | Vivaro | Grey | Driving without Due Care and Attention | None | Rubery Lane | Rubery Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4007375 | -2.0158237 | |
| 5445 | op-snap---monthly-publication-february-2025.pdf | 262 | 2025-02 | Car | Honda | 125 | Blue | Driving without Due Care and Attention | None | Wellington Road | Wellington Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.5133725 | -1.9193405 | |
| 5447 | op-snap---monthly-publication-february-2025.pdf | 264 | 2025-02 | Car | MAN | Driving without Due Care and Attention | None | Alston Street | Alston Street | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4772629 | -1.9267359 | |||
| 5453 | op-snap---monthly-publication-february-2025.pdf | 270 | 2025-02 | Pedestrian | Daf | Truck | White | Driving without Due Care and Attention | None | Sheepcoat Street, City Centre | Sheepcoat Street, City Centre | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 5459 | op-snap---monthly-publication-february-2025.pdf | 276 | 2025-02 | Car | Ford | S-max | Black | Driving without Due Care and Attention | No Insurance | Vicarage Road | Vicarage Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.470423 | -1.9304786 | |
| 5470 | op-snap---monthly-publication-february-2025.pdf | 287 | 2025-02 | Pedal Bike | Mazda | CX5 | Grey | Driving without Due Care and Attention | None | Swarthmore Road | Swarthmore Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4299657 | -1.9599121 | |
| 5471 | op-snap---monthly-publication-february-2025.pdf | 288 | 2025-02 | Pedal Bike | Mercedes-Benz | GLC 220 | Black | Driving without Due Care and Attention | None | Churchyard Lane | Churchyard Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4089716 | -1.9295218 | |
| 5484 | op-snap---monthly-publication-february-2025.pdf | 301 | 2025-02 | Car | Renault | Clio | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5492 | op-snap---monthly-publication-february-2025.pdf | 309 | 2025-02 | Car | Kia | Picanto | Blue | Driving without Due Care and Attention | None | Old Horns Crescent, Birmingham | Old Horns Crescent, Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5506799 | -1.9100116 | |
| 5496 | op-snap---monthly-publication-february-2025.pdf | 313 | 2025-02 | Car | Volkswagen | Toureg | Black | Driving without Due Care and Attention | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 5497 | op-snap---monthly-publication-february-2025.pdf | 314 | 2025-02 | Car | Lexus | CT | White | Driving without Due Care and Attention | No Insurance | Warwick Road, Olton | Warwick Road, Olton | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 5498 | op-snap---monthly-publication-february-2025.pdf | 315 | 2025-02 | Car | Kia | EV9 | Black | Driving without Due Care and Attention | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 5504 | op-snap---monthly-publication-february-2025.pdf | 321 | 2025-02 | Pedestrian | Audi | S3 | Blue | Driving without Due Care and Attention | No Insurance | Cardigan Street | Cardigan Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4849063 | -1.8846609 | |
| 5505 | op-snap---monthly-publication-february-2025.pdf | 322 | 2025-02 | Car | Mercedes-Benz | GLB 200 AMG | White | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5274116 | -1.9287273 | |
| 5529 | op-snap---monthly-publication-february-2025.pdf | 346 | 2025-02 | Car | Kia | Rio | Black | Driving without Due Care and Attention | None | Scarsdale Road | Scarsdale Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.540994 | -1.9027862 | |
| 5545 | op-snap---monthly-publication-february-2025.pdf | 362 | 2025-02 | Car | Toyota | PRIUS | White | Driving without Due Care and Attention | None | ASTON EXPRESSWAY | Aston Expressway | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.493793 | -1.8881773 | |
| 5558 | op-snap---monthly-publication-february-2025.pdf | 375 | 2025-02 | Motorbike | Ford | focus | Silver | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.5292752 | -1.7618805 | |
| 5562 | op-snap---monthly-publication-february-2025.pdf | 379 | 2025-02 | Car | Vauxhall | ASTRA | Silver | Driving without Due Care and Attention | None | BELGRAVE INTERCHANGE | Belgrave Interchange | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.466118 | -1.8982999 | |
| 5564 | op-snap---monthly-publication-february-2025.pdf | 381 | 2025-02 | Pedestrian | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 5574 | op-snap---monthly-publication-february-2025.pdf | 391 | 2025-02 | Car | Volkswagen | Passat | Black | Driving without Due Care and Attention | None | Green Lane | Green Lane | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4618966 | -1.9955421 | |
| 5578 | op-snap---monthly-publication-february-2025.pdf | 395 | 2025-02 | Car | BMW | X5 | Black | Driving without Due Care and Attention | None | Cole Bank Road Birmingham | Cole Bank Road Birmingham | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4349375 | -1.8510007 | |
| 5579 | op-snap---monthly-publication-february-2025.pdf | 396 | 2025-02 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Cooks Lane Birmingham | Cooks Lane Birmingham | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.482758 | -1.7603097 | |
| 5583 | op-snap---monthly-publication-february-2025.pdf | 400 | 2025-02 | Car | BMW | 118D | Black | Driving without Due Care and Attention | None | M6, Junction 6 | M6, Junction 6 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.6760749 | -2.0862582 | |
| 5589 | op-snap---monthly-publication-february-2025.pdf | 406 | 2025-02 | Car | BMW | 5 Series | Black | Driving without Due Care and Attention | None | Chester Road at Kingsbury Road | Chester Road at Kingsbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5590 | op-snap---monthly-publication-february-2025.pdf | 407 | 2025-02 | Car | Lex Moto | Black | Driving without Due Care and Attention | None | Chester Road at Kingsbury Road | Chester Road at Kingsbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | ||
| 5591 | op-snap---monthly-publication-february-2025.pdf | 408 | 2025-02 | Car | Volkswagen | Golf R | White | Driving without Due Care and Attention | None | Chester Road at Kingsbury Road | Chester Road at Kingsbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5592 | op-snap---monthly-publication-february-2025.pdf | 409 | 2025-02 | Car | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Chester Road at Kingsbury Road | Chester Road at Kingsbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 5596 | op-snap---monthly-publication-february-2025.pdf | 413 | 2025-02 | Car | Renault | Trucks | White | Driving without Due Care and Attention | None | Junction 6 M6 Southbound | Junction 6 M6 Southbound | Birmingham | Birmingham | NFA | No offence | Yes - Via Email | |||
| 5598 | op-snap---monthly-publication-february-2025.pdf | 415 | 2025-02 | Pedestrian | N/P | White | Driving without Due Care and Attention | None | Brandwood Park Road | Brandwood Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4138206 | -1.9041686 | ||
| 5600 | op-snap---monthly-publication-february-2025.pdf | 417 | 2025-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Highters Heath Road | Highters Heath Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4120728 | -1.8622915 | |
| 5604 | op-snap---monthly-publication-february-2025.pdf | 421 | 2025-02 | Pedestrian | Toyota | Auris | Driving without Due Care and Attention | None | Court Oak Road | Court Oak Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4604383 | -1.9760104 | ||
| 5605 | op-snap---monthly-publication-february-2025.pdf | 422 | 2025-02 | Car | Mercedes-Benz | 400 AMG | Black | Driving without Due Care and Attention | None | Portway Road | Portway Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 5611 | op-snap---monthly-publication-february-2025.pdf | 428 | 2025-02 | Car | Toyota | Auris | White | Driving without Due Care and Attention | None | A38 inbound | A38 inbound | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 5613 | op-snap---monthly-publication-february-2025.pdf | 430 | 2025-02 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Sheldon Heath Road | Sheldon Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4744736 | -1.7892633 | |
| 5616 | op-snap---monthly-publication-february-2025.pdf | 433 | 2025-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Booth Street | Booth Street | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5039035 | -1.9447084 | |
| 5618 | op-snap---monthly-publication-february-2025.pdf | 435 | 2025-02 | Car | Kia | Rio | Silver | Driving without Due Care and Attention | None | Heybarnes Road | Heybarnes Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4677423 | -1.8351236 | |
| 5619 | op-snap---monthly-publication-february-2025.pdf | 436 | 2025-02 | Car | Peugeot | 107 | Black | Driving without Due Care and Attention | None | Church Road | Church Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4624743 | -1.7763934 | |
| 5625 | op-snap---monthly-publication-february-2025.pdf | 442 | 2025-02 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4308271 | -1.920078 | |
| 5674 | op-snap---monthly-publication-february-2025.pdf | 491 | 2025-02 | Car | Volkswagen | GOLF R | Black | Driving without Due Care and Attention | None | Bishopgate Stret | Bishopgate Stret | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 5676 | op-snap---monthly-publication-february-2025.pdf | 493 | 2025-02 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Bath Row | Bath Row | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.472238 | -1.9127983 | |
| 5686 | op-snap---monthly-publication-february-2025.pdf | 503 | 2025-02 | Car | Seat | Arona | Grey | Driving without Due Care and Attention | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4967329 | -1.8097462 | |
| 5692 | op-snap---monthly-publication-february-2025.pdf | 509 | 2025-02 | Car | BMW | 218i | Grey | Driving without Due Care and Attention | None | M5 South, J1 | M5 South, J1 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 5715 | op-snap---monthly-publication-february-2025.pdf | 532 | 2025-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | M5 S/B approaching Jn3 | M5 Southbound approaching Jn3 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 5723 | op-snap---monthly-publication-february-2025.pdf | 540 | 2025-02 | Car | Mini | Cooper | White | Driving without Due Care and Attention | None | Spies Lane | Spies Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4618792 | -2.0130081 | |
| 5752 | op-snap---monthly-publication-february-2025.pdf | 569 | 2025-02 | Pedal Bike | Seat | Leon | White | Driving without Due Care and Attention | None | Showel Green Lane | Showel Green Lane | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 5754 | op-snap---monthly-publication-february-2025.pdf | 571 | 2025-02 | Pedal Bike | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 5791 | op-snap---monthly-publication-february-2025.pdf | 608 | 2025-02 | Car | Volkswagen | Transporter | White | Driving without Due Care and Attention | None | Hamstead Road Birmingham | Hamstead Road Birmingham | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5073301 | -1.9199406 | |
| 5796 | op-snap---monthly-publication-february-2025.pdf | 613 | 2025-02 | Car | Volkswagen | Passatt | Black | Driving without Due Care and Attention | None | Green Lane Bordsley Green | Green Lane Bordsley Green | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 5829 | op-snap---monthly-publication-february-2025.pdf | 646 | 2025-02 | Pedal Bike | Volkswagen | Tiguan | Black | Driving without Due Care and Attention | None | Greenfield Road Harborne | Greenfield Road Harborne | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4577374 | -1.9533202 | |
| 5830 | op-snap---monthly-publication-february-2025.pdf | 647 | 2025-02 | Pedal Bike | Cupra | Black | Driving without Due Care and Attention | None | Greenfield Road Harborne | Greenfield Road Harborne | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4577374 | -1.9533202 | ||
| 5832 | op-snap---monthly-publication-february-2025.pdf | 649 | 2025-02 | Pedal Bike | Mercedes-Benz | GLE | Black | Driving without Due Care and Attention | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4695793 | -1.9378608 | |
| 5834 | op-snap---monthly-publication-february-2025.pdf | 651 | 2025-02 | Pedal Bike | TX | Black | Driving without Due Care and Attention | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4695793 | -1.9378608 | ||
| 5840 | op-snap---monthly-publication-february-2025.pdf | 657 | 2025-02 | Car | Renault | Van | White | Driving without Due Care and Attention | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.473883 | -1.9198244 | |
| 5858 | op-snap---monthly-publication-february-2025.pdf | 675 | 2025-02 | Car | Fiat | 500 | White | Driving without Due Care and Attention | None | Russel Road | Russel Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4297153 | -1.934958 | |
| 5929 | op-snap---monthly-publication-february-2025.pdf | 746 | 2025-02 | Car | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | A456 at M5 Jn3 roundabout | A456 at M5 Jn3 roundabout | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4537468 | -2.0080889 | |
| 5934 | op-snap---monthly-publication-february-2025.pdf | 751 | 2025-02 | Car | Toyota | Verso | Blue | Driving without Due Care and Attention | None | Hawthorne Road | Hawthorne Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4195457 | -1.9441049 | |
| 5935 | op-snap---monthly-publication-february-2025.pdf | 752 | 2025-02 | Car | Peugeot | Independance | Silver | Driving without Due Care and Attention | None | Soho Hill | Soho Hill | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4983151 | -1.9186252 | |
| 5937 | op-snap---monthly-publication-february-2025.pdf | 754 | 2025-02 | Car | Toyota | AURIS | Red | Driving without Due Care and Attention | None | BOOTH STREET | Booth Street | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5039035 | -1.9447084 | |
| 5941 | op-snap---monthly-publication-february-2025.pdf | 758 | 2025-02 | Car | Audi | Q7 | Black | Driving without Due Care and Attention | None | Walter Street | Walter Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4973929 | -1.8742203 | |
| 5980 | op-snap---monthly-publication-february-2025.pdf | 797 | 2025-02 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | A45 Airport and Station Exit | Airport and Station Exit | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4474175 | -1.735823 | |
| 5995 | op-snap---monthly-publication-february-2025.pdf | 812 | 2025-02 | Car | Vauxhall | VIVARO | Grey | Driving without Due Care and Attention | None | LEACH GREEN | Leach Green | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.392246 | -2.0101736 | |
| 5999 | op-snap---monthly-publication-february-2025.pdf | 816 | 2025-02 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Highgate Middleway | Highgate Middleway | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4661171 | -1.8832818 | |
| 6002 | op-snap---monthly-publication-february-2025.pdf | 819 | 2025-02 | Pedal Bike | Peugeot | 208 | Blue | Driving without Due Care and Attention | None | Digbeth High Street | Digbeth High Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4745895 | -1.8821244 | |
| 6057 | op-snap---monthly-publication-february-2025.pdf | 874 | 2025-02 | Other | Honda | Jazz | Green | Driving without Due Care and Attention | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5265939 | -1.8509884 | |
| 6097 | op-snap---monthly-publication-february-2025.pdf | 914 | 2025-02 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Jockey Road | Jockey Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5512291 | -1.8357776 | |
| 6105 | op-snap---monthly-publication-february-2025.pdf | 922 | 2025-02 | Car | Audi | Q3 | Silver | Driving without Due Care and Attention | None | M6 South J7-J6 | M6 South J7-J6 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 6137 | op-snap---monthly-publication-february-2025.pdf | 954 | 2025-02 | Pedal Bike | Toyota | MPV | Grey | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4308271 | -1.920078 | |
| 6138 | op-snap---monthly-publication-february-2025.pdf | 955 | 2025-02 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Springfield Road | Springfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4327486 | -1.8844997 | |
| 6177 | op-snap---monthly-publication-february-2025.pdf | 994 | 2025-02 | Pedal Bike | Mercedes-Benz | A class | Grey | Driving without Due Care and Attention | None | Calthorpe Road | Calthorpe Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5142235 | -1.9073557 |
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);