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'}
14,157 rows where reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, nfa_rationale, witness_contacted
vehicle_make >30
- Ford 1,476
- Volkswagen 1,468
- BMW 1,300
- Mercedes-Benz 1,294
- Audi 1,250
- Toyota 1,147
- Vauxhall 826
- Nissan 542
- Seat 469
- Peugeot 436
- Land Rover 322
- Honda 318
- Renault 291
- Skoda 286
- Hyundai 285
- Citroen 246
- Kia 215
- Volvo 192
- Fiat 127
- Mini 116
- Mg 91
- Porsche 88
- Mazda 85
- Tesla 85
- Jaguar 78
- Suzuki 78
- Daf 75
- Lexus 67
- Yamaha 55
- Mitsubishi 54
- …
offence >30
- Driving without Due Care and Attention 5,123
- Contravening a Red Traffic Light 2,675
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 910
- Driving without Reasonable Consideration 893
- Stop a vehicle within pelican pedestrian crossing limits 884
- Cause vehicle to be left in a dangerous position 705
- Using a Mobile Phone Whilst Driving 633
- Misc - Non Traffic Offences 472
- Stop a vehicle on pedestrian crossing 315
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 205
- Cause unnecessary obstruction by motor vehicle 199
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 137
- VRM fails to conform to Regulations 110
- Contravene Lane Closure Red X 98
- Drive on hard shoulder 94
- Dangerous Driving 79
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 75
- Motor vehicle fail to accord precedence at a pelican crossing 50
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 45
- Driving a vehicle wholly or partly on a footpath 41
- Drive a vehicle other than on the carriageway of a motorway 38
- No Insurance 33
- Vehicle overtake within crossing limits 32
- Driver not in position to have Proper Control 30
- Prohibited vehicle in offside lane of motorway 28
- No Seat Belt 25
- Motor vehicle fail to comply with solid white line road markings 20
- Fail to display front VRM plate 15
- Motor vehicle fail to comply with endorsable sect 15
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 14
- …
council_area >30
- Birmingham 7,846
- Out of Force Area 1,443
- Coventry 900
- Sandwell 816
- Wolverhampton 681
- Solihull 673
- Dudley 662
- Walsall 572
- Sutton Coldfield 349
- Halesowen 51
- Metropolitan Borough 17
- Metropolitan Borough Of Dudley 11
- Area 9
- Out Of Force Area 7
- Mbirmingham 5
- Boiurmt Oinf Gfhoarmce 4
- Edldu Dalveey Brierley Hill 3
- Soauntd Owf Eflolrce 3
- Aorueta Of Force 2
- Hbeiramthingham 2
- Ubdirymaridn Gghraomve 2
- Ysandwell 2
- )Birmingham 1
- 0C1Oventry 1
- 3B2Irmingham 1
- 4C4O4V)Entry 1
- 6B Itromwianrgdhsa Smalford C 1
- Abdirmingham 1
- Abyirmingham 1
- Ao)Ut Of Force Area 1
- …
month 14
disposal 8
- NFA 5,560
- Warning Letter 3,227
- Education 2,526
- Fixed Penalty 1,887
- Court 755
- Other Action Taken 99
- RTC - Actioned 95
- Duplicate Submission 8
reporter_transport_mode 1
- Car · 14,157 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8887 | op-snap---monthly-publication-february-2026.pdf | 1634 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Benton Road | Benton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4589836 | -1.8637054 | ||
| 8884 | op-snap---monthly-publication-february-2026.pdf | 1631 | 2026-02 | Car | Honda | civic | Red | Stop a vehicle within pelican pedestrian crossing limits | None | high street, tettenhall | High Street, Tettenhall | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8883 | op-snap---monthly-publication-february-2026.pdf | 1630 | 2026-02 | Car | Volkswagen | golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8882 | op-snap---monthly-publication-february-2026.pdf | 1629 | 2026-02 | Car | Ford | mondeo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4957234 | -1.8538937 | ||
| 8881 | op-snap---monthly-publication-february-2026.pdf | 1628 | 2026-02 | Car | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4957234 | -1.8538937 | ||
| 8880 | op-snap---monthly-publication-february-2026.pdf | 1627 | 2026-02 | Car | Vauxhall | movano | White | Misc - Non Traffic Offences | None | park lane | Park Lane | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.5687807 | -2.0165653 | ||
| 8879 | op-snap---monthly-publication-february-2026.pdf | 1626 | 2026-02 | Car | Audi | Q4 | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8873 | op-snap---monthly-publication-february-2026.pdf | 1620 | 2026-02 | Car | Volvo | c30 | Grey | Misc - Non Traffic Offences | None | windsor close | Windsor Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.404722 | -2.0141058 | ||
| 8870 | op-snap---monthly-publication-february-2026.pdf | 1617 | 2026-02 | Car | Jaecoo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | kineton green road | Kineton Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4259601 | -1.8794696 | |||
| 8869 | op-snap---monthly-publication-february-2026.pdf | 1616 | 2026-02 | Car | Jaguar | FPACE | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | southfield avenue | Southfield Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4833844 | -1.9484535 | ||
| 8868 | op-snap---monthly-publication-february-2026.pdf | 1615 | 2026-02 | Car | Volkswagen | polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | icknield port road | Icknield Port Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4792334 | -1.92925 | ||
| 8867 | op-snap---monthly-publication-february-2026.pdf | 1614 | 2026-02 | Car | Honda | FRV | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8866 | op-snap---monthly-publication-february-2026.pdf | 1613 | 2026-02 | Car | Volkswagen | polo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8865 | op-snap---monthly-publication-february-2026.pdf | 1612 | 2026-02 | Car | Nissan | leaf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8864 | op-snap---monthly-publication-february-2026.pdf | 1611 | 2026-02 | Car | Toyota | yaris | Green | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8863 | op-snap---monthly-publication-february-2026.pdf | 1610 | 2026-02 | Car | Skoda | Kamiq | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | witton road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 8852 | op-snap---monthly-publication-february-2026.pdf | 1599 | 2026-02 | Car | Land Rover | defender | Black | Cause vehicle to be left in a dangerous position | none | high street, kingswinford | High Street, Kingswinford | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 8849 | op-snap---monthly-publication-february-2026.pdf | 1596 | 2026-02 | Car | Renault | master | White | Stop a vehicle within pelican pedestrian crossing limits | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8847 | op-snap---monthly-publication-february-2026.pdf | 1594 | 2026-02 | Car | Nissan | qashqai | Grey | Misc - Non Traffic Offences | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 8846 | op-snap---monthly-publication-february-2026.pdf | 1593 | 2026-02 | Car | Mercedes-Benz | slk | White | Misc - Non Traffic Offences | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 8842 | op-snap---monthly-publication-february-2026.pdf | 1589 | 2026-02 | Car | Peugeot | 2008 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | 52.4967329 | -1.8097462 | ||
| 8841 | op-snap---monthly-publication-february-2026.pdf | 1588 | 2026-02 | Car | Nissan | navara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8840 | op-snap---monthly-publication-february-2026.pdf | 1587 | 2026-02 | Car | Ford | mondeo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8838 | op-snap---monthly-publication-february-2026.pdf | 1585 | 2026-02 | Car | Toyota | aygo | White | Cause vehicle to be left in a dangerous position | None | De Montfort road | De Montfort road | Coventry | Coventry | Warning Letter | N/A | ||||
| 8829 | op-snap---monthly-publication-february-2026.pdf | 1576 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8828 | op-snap---monthly-publication-february-2026.pdf | 1575 | 2026-02 | Car | Skoda | fabia | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8826 | op-snap---monthly-publication-february-2026.pdf | 1573 | 2026-02 | Car | BMW | 320i | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | colehsill road | Colehsill Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8820 | op-snap---monthly-publication-february-2026.pdf | 1567 | 2026-02 | Car | Toyota | Hilux | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 8819 | op-snap---monthly-publication-february-2026.pdf | 1566 | 2026-02 | Car | Mazda | 2 GT | Grey | Driving without Due Care and Attention | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 8811 | op-snap---monthly-publication-february-2026.pdf | 1558 | 2026-02 | Car | Mini | Cooper | Silver | Driving without Due Care and Attention | None | Chester Road, Kingshurst | Chester Road, Kingshurst | Solihull | Solihull | Education | N/A | 52.5013241 | -1.7644355 | ||
| 8810 | op-snap---monthly-publication-february-2026.pdf | 1557 | 2026-02 | Car | Lexus | NX450 | Black | Driving without Due Care and Attention | None | Chester Road, Castle Bromwich | Chester Road, Castle Bromwich | Birmingham | Birmingham | Court | N/A | ||||
| 8809 | op-snap---monthly-publication-february-2026.pdf | 1556 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Brickhouse Lane | Brickhouse Lane | Sandwell | Sandwell | Court | N/A | 52.5331011 | -2.0206711 | ||
| 8808 | op-snap---monthly-publication-february-2026.pdf | 1555 | 2026-02 | Car | Jeep | Avenger | Beige | Driving without Due Care and Attention | None | Tollbar End Roundabout | Tollbar End Roundabout | Coventry | Coventry | Court | N/A | ||||
| 8807 | op-snap---monthly-publication-february-2026.pdf | 1554 | 2026-02 | Car | Toyota | Yaris | White | Driving without Due Care and Attention | None | Bickenhill Road | Bickenhill Road | Birmingham | Birmingham | Education | N/A | ||||
| 8806 | op-snap---monthly-publication-february-2026.pdf | 1553 | 2026-02 | Car | Skoda | Kodiaq | Black | Misc - Non Traffic Offences | None | Freehold Street | Freehold Street | Coventry | Coventry | RTC - Actioned | N/A | 52.4164191 | -1.4928534 | ||
| 8805 | op-snap---monthly-publication-february-2026.pdf | 1552 | 2026-02 | Car | Mercedes-Benz | Splinter | White | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 8804 | op-snap---monthly-publication-february-2026.pdf | 1551 | 2026-02 | Car | Ford | transit | Black | Driving without Reasonable Consideration | None | A45 Heartlands parkway | Heartlands parkway | Birmingham | Birmingham | Warning Letter | N/A | 52.5038363 | -1.8432663 | ||
| 8803 | op-snap---monthly-publication-february-2026.pdf | 1550 | 2026-02 | Car | Toyota | Prius | Blue | Driving without Due Care and Attention | None | M6 motorway, Staffs | M6 motorway, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8802 | op-snap---monthly-publication-february-2026.pdf | 1549 | 2026-02 | Car | Toyota | Hilux | Brown | Driving without Due Care and Attention | None | M6 Jct 18 | M6 Junction 18 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8801 | op-snap---monthly-publication-february-2026.pdf | 1548 | 2026-02 | Car | Volkswagen | golf | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | washwood hetah road | Washwood Hetah Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8800 | op-snap---monthly-publication-february-2026.pdf | 1547 | 2026-02 | Car | Audi | s3 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8799 | op-snap---monthly-publication-february-2026.pdf | 1546 | 2026-02 | Car | Nissan | qashqai | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8798 | op-snap---monthly-publication-february-2026.pdf | 1545 | 2026-02 | Car | Audi | a1 | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8797 | op-snap---monthly-publication-february-2026.pdf | 1544 | 2026-02 | Car | Mini | cooper | Red | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8796 | op-snap---monthly-publication-february-2026.pdf | 1543 | 2026-02 | Car | Mercedes-Benz | c220 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8795 | op-snap---monthly-publication-february-2026.pdf | 1542 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 8794 | op-snap---monthly-publication-february-2026.pdf | 1541 | 2026-02 | Car | Mercedes-Benz | c220 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | victoria street | Victoria Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4751651 | -1.8559775 | ||
| 8793 | op-snap---monthly-publication-february-2026.pdf | 1540 | 2026-02 | Car | Misc - Non Traffic Offences | None | np | Np | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||||
| 8788 | op-snap---monthly-publication-february-2026.pdf | 1535 | 2026-02 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Somerset Road / Richmond Hill Road | Somerset Road / Richmond Hill Road | Birmingham | Birmingham | Education | N/A | 52.5161872 | -1.9315221 | ||
| 8786 | op-snap---monthly-publication-february-2026.pdf | 1533 | 2026-02 | Car | Volkswagen | Transporter | White | VRM fails to conform to Regulations | None | Huntingtree Road | Huntingtree Road | Dudley | Dudley | Fixed Penalty | N/A | 52.4484682 | -2.0689885 | ||
| 8785 | op-snap---monthly-publication-february-2026.pdf | 1532 | 2026-02 | Car | BMW | X3 | White | Driving without Due Care and Attention | None | Bromford Road / Bromford Lane | Bromford Road / Bromford Lane | Birmingham | Birmingham | NFA | No VRM | 52.503036 | -1.8289972 | ||
| 8784 | op-snap---monthly-publication-february-2026.pdf | 1531 | 2026-02 | Car | Honda | CBR 600 | Yellow | Driving without Due Care and Attention | None | Carters Lane | Carters Lane | Birmingham | Birmingham | Court | N/A | 52.4445826 | -2.013123 | ||
| 8783 | op-snap---monthly-publication-february-2026.pdf | 1530 | 2026-02 | Car | Toyota | Rav 4 | Silver | Driving without Due Care and Attention | None | Duncan Edwards Way | Duncan Edwards Way | Dudley | Dudley | NFA | No Independent Evidence Available | 52.5047428 | -2.0823754 | ||
| 8780 | op-snap---monthly-publication-february-2026.pdf | 1527 | 2026-02 | Car | Audi | Q6 | White | Driving without Due Care and Attention | None | A454 Black Country Route | Black Country Route | Walsall | Walsall | Education | N/A | 52.5736488 | -2.0492151 | ||
| 8779 | op-snap---monthly-publication-february-2026.pdf | 1526 | 2026-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Kelvin Way | Kelvin Way | Sandwell | Sandwell | RTC - Actioned | N/A | 52.5090464 | -1.9938896 | ||
| 8778 | op-snap---monthly-publication-february-2026.pdf | 1525 | 2026-02 | Car | Volvo | V40 | Black | Driving without Due Care and Attention | None | Sydenham Road, Sparkbrook | Sydenham Road, Sparkbrook | Birmingham | Birmingham | Education | N/A | 52.460903 | -1.8617548 | ||
| 8777 | op-snap---monthly-publication-february-2026.pdf | 1524 | 2026-02 | Car | Dacia | Spring | Orange | Driving without Due Care and Attention | None | Stourbridge Road, Kidderminster. West Mercia | Stourbridge Road, Kidderminster. West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8776 | op-snap---monthly-publication-february-2026.pdf | 1523 | 2026-02 | Car | Toyota | ESTIMA | Black | Driving without Due Care and Attention | No Insurance | Warwick Road / Battery Way | Warwick Road / Battery Way | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.551985 | -1.860445 | ||
| 8775 | op-snap---monthly-publication-february-2026.pdf | 1522 | 2026-02 | Car | Yutong | White | Driving without Due Care and Attention | None | Camp Hill Circus | Camp Hill Circus | Birmingham | Birmingham | Education | N/A | 52.4682339 | -1.8793662 | |||
| 8774 | op-snap---monthly-publication-february-2026.pdf | 1521 | 2026-02 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Lower Hillmorton Road | Lower Hillmorton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8773 | op-snap---monthly-publication-february-2026.pdf | 1520 | 2026-02 | Car | Volkswagen | Golf | Red | Driving without Due Care and Attention | None | Stamford Avenue | Stamford Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8771 | op-snap---monthly-publication-february-2026.pdf | 1518 | 2026-02 | Car | Toyota | Prius | White | Driving without Reasonable Consideration | None | Newton Road Great Barr | Newton Road Great Barr | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5429259 | -1.9534939 | ||
| 8770 | op-snap---monthly-publication-february-2026.pdf | 1517 | 2026-02 | Car | Land Rover | discovery | Black | Driving a vehicle wholly or partly on a footpath | None | Hollyfield Road | Hollyfield Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5620486 | -1.8030784 | ||
| 8767 | op-snap---monthly-publication-february-2026.pdf | 1514 | 2026-02 | Car | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Heath Street Winson Green | Heath Street Winson Green | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4869563 | -1.9351596 | ||
| 8765 | op-snap---monthly-publication-february-2026.pdf | 1512 | 2026-02 | Car | Volvo | XC40 | Black | Driving without Due Care and Attention | None | Marsh Hill | Marsh Hill | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5246617 | -1.8687505 | ||
| 8764 | op-snap---monthly-publication-february-2026.pdf | 1511 | 2026-02 | Car | Volkswagen | Beetle | Black | Driving without Due Care and Attention | None | Brookvale Road | Brookvale Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5219365 | -1.8755325 | ||
| 8763 | op-snap---monthly-publication-february-2026.pdf | 1510 | 2026-02 | Car | Tesla | model 3 | Grey | Driving without Reasonable Consideration | None | Jn3 M42, West Mercia | Jn3 M42, West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8762 | op-snap---monthly-publication-february-2026.pdf | 1509 | 2026-02 | Car | Fiat | Panda | White | Driving without Due Care and Attention | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Education | N/A | 52.4397168 | -1.9260414 | ||
| 8761 | op-snap---monthly-publication-february-2026.pdf | 1508 | 2026-02 | Car | Hyundai | Ioniq | Black | Driving without Due Care and Attention | None | Stafford Street | Stafford Street | Dudley | Dudley | NFA | No Offence | 52.5095163 | -2.0898951 | ||
| 8759 | op-snap---monthly-publication-february-2026.pdf | 1506 | 2026-02 | Car | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Bath Street Hereford (West Mercia) | Bath Street Hereford (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8757 | op-snap---monthly-publication-february-2026.pdf | 1504 | 2026-02 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | John Macadam Way Hastings. | John Macadam Way Hastings | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8754 | op-snap---monthly-publication-february-2026.pdf | 1501 | 2026-02 | Car | Multiple | Contravening a Red Traffic Light | None | Middleton Hall Road | Middleton Hall Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4149989 | -1.9345999 | ||||
| 8752 | op-snap---monthly-publication-february-2026.pdf | 1499 | 2026-02 | Car | Tesla | Model 3 | White | Driving without Due Care and Attention | None | Cresswell Crescent | Cresswell Crescent | Walsall | Walsall | Warning Letter | N/A | 52.6264494 | -2.0202765 | ||
| 8750 | op-snap---monthly-publication-february-2026.pdf | 1497 | 2026-02 | Car | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hancock Road | Hancock Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4854257 | -1.8436094 | ||
| 8748 | op-snap---monthly-publication-february-2026.pdf | 1495 | 2026-02 | Car | Mercedes-Benz | S220D | Blue | Misc - Non Traffic Offences | No vehicle excise licence | Moseley Road | Moseley Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4679402 | -1.881408 | ||
| 8746 | op-snap---monthly-publication-february-2026.pdf | 1493 | 2026-02 | Car | BMW | 5 series | Grey | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | 52.4552785 | -1.906384 | |||
| 8745 | op-snap---monthly-publication-february-2026.pdf | 1492 | 2026-02 | Car | Ford | Connect | White | Driving without Due Care and Attention | None | Middlemore Road | Middlemore Road | Sandwell | Sandwell | Duplicate Submission | Duplicate Submission | 52.5056493 | -1.9624063 | ||
| 8744 | op-snap---monthly-publication-february-2026.pdf | 1491 | 2026-02 | Car | Ford | Connect | White | Driving without Due Care and Attention | None | Middlemore Road | Middlemore Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5056493 | -1.9624063 | ||
| 8743 | op-snap---monthly-publication-february-2026.pdf | 1490 | 2026-02 | Car | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | No Insurance | Woodland Road | Woodland Road | Birmingham | Birmingham | Court | N/A | 52.4108681 | -1.9611917 | ||
| 8742 | op-snap---monthly-publication-february-2026.pdf | 1489 | 2026-02 | Car | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Austin Road | Austin Road | Birmingham | Birmingham | Education | N/A | 52.5086851 | -1.9532014 | ||
| 8741 | op-snap---monthly-publication-february-2026.pdf | 1488 | 2026-02 | Car | Renault | Traffic | Grey | Driving without Due Care and Attention | None | Hawford Lock Lane (West Mercia) | Hawford Lock Lane (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8740 | op-snap---monthly-publication-february-2026.pdf | 1487 | 2026-02 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4216321 | -1.855984 | ||
| 8739 | op-snap---monthly-publication-february-2026.pdf | 1486 | 2026-02 | Car | Seat | Ateca | Silver | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | Court | N/A | ||||
| 8734 | op-snap---monthly-publication-february-2026.pdf | 1481 | 2026-02 | Car | BMW | X5.. | Grey | Contravening a Red Traffic Light | None | Bloxwich Lane | Bloxwich Lane | Walsall | Walsall | Education | N/A | 52.6020474 | -2.014682 | ||
| 8729 | op-snap---monthly-publication-february-2026.pdf | 1476 | 2026-02 | Car | Land Rover | discovery | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 8727 | op-snap---monthly-publication-february-2026.pdf | 1474 | 2026-02 | Car | Seat | ateca | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8726 | op-snap---monthly-publication-february-2026.pdf | 1473 | 2026-02 | Car | Fiat | panda | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 8705 | op-snap---monthly-publication-february-2026.pdf | 1452 | 2026-02 | Car | Cupra | Ateca | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | garretts green lane | Garretts Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4675802 | -1.7905748 | ||
| 8704 | op-snap---monthly-publication-february-2026.pdf | 1451 | 2026-02 | Car | BMW | 520d | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | garrets green lane | Garrets Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4657981 | -1.7964101 | ||
| 8703 | op-snap---monthly-publication-february-2026.pdf | 1450 | 2026-02 | Car | Peugeot | 3008 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 8702 | op-snap---monthly-publication-february-2026.pdf | 1449 | 2026-02 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Highbridge Road | Highbridge Road | Dudley | Dudley | Court | N/A | 52.485907 | -2.0953009 | ||
| 8698 | op-snap---monthly-publication-february-2026.pdf | 1445 | 2026-02 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 8697 | op-snap---monthly-publication-february-2026.pdf | 1444 | 2026-02 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | Southam Road | Southam Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4334787 | -1.8516882 | |||
| 8695 | op-snap---monthly-publication-february-2026.pdf | 1442 | 2026-02 | Car | Mercedes-Benz | A Class | Black | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 8694 | op-snap---monthly-publication-february-2026.pdf | 1441 | 2026-02 | Car | Vauxhall | Corsa | White | Using a Mobile Phone Whilst Driving | None | UK | Uk | Other Action Taken | N/A | 52.5019896 | -2.0209184 | ||||
| 8693 | op-snap---monthly-publication-february-2026.pdf | 1440 | 2026-02 | Car | Volkswagen | Arteon | Grey | Driving without Due Care and Attention | None | Hallow Road | Hallow Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8692 | op-snap---monthly-publication-february-2026.pdf | 1439 | 2026-02 | Car | Lexus | RZ | Black | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 8691 | op-snap---monthly-publication-february-2026.pdf | 1438 | 2026-02 | Car | Audi | Q3 | White | Driving without Due Care and Attention | None | Dads Lane | Dads Lane | Birmingham | Birmingham | Education | N/A | 52.4375913 | -1.9068522 | ||
| 8689 | op-snap---monthly-publication-february-2026.pdf | 1436 | 2026-02 | Car | BMW | X6 | White | Driving without Due Care and Attention | None | Birmingham Road (A34) | Birmingham Road (A34) | Walsall | Walsall | Court | N/A | 52.5675147 | -1.9513505 | ||
| 8688 | op-snap---monthly-publication-february-2026.pdf | 1435 | 2026-02 | Car | Seat | Ibiza | Red | Driving without Due Care and Attention | None | Upton Road | Upton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4773477 | -1.8187617 |
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);