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'}
739 rows where month = "2025-12" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
council_area >30
- Birmingham 369
- Out of Force Area 103
- Sandwell 52
- Wolverhampton 47
- Coventry 39
- Solihull 35
- Dudley 27
- Walsall 20
- Sutton Coldfield 17
- Edldu Dalveey Brierley Hill 3
- Halesowen 3
- Ubdirymaridn Gghraomve 2
- Abdirmingham 1
- Aofufts Opfo Floirccee) Area 1
- Aonudt B Olyf Tfhorce Area 1
- Eb Ihrmilli)Ngham 1
- Eb Ivrmaleingham 1
- Edwud Rleoyad 1
- Eorucita Of Force Area 1
- Hbiirrlmeyingham 1
- Hsoaunsdew Welaly 1
- Hsuolllihull 1
- Ibnigrtmoinngham 1
- Moeunt Dof Force Area 1
- Moeurtc Oiaf Force Area 1
- Moeust Voaf Lfleoyr)Ce Area 1
- Nboirrmtoinng.Ham 1
- Ouruyt Of Force Area 1
- Rbdir Mingham 1
- Rsoaanddwell 1
- …
offence 24
- Driving without Due Care and Attention 294
- Contravening a Red Traffic Light 133
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 105
- Cause vehicle to be left in a dangerous position 49
- Misc - Non Traffic Offences 47
- Using a Mobile Phone Whilst Driving 46
- Stop a vehicle within pelican pedestrian crossing limits 14
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 13
- Stop a vehicle on pedestrian crossing 6
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 5
- Contravene Lane Closure Red X 3
- Drive on hard shoulder 3
- Driving without Reasonable Consideration 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Vehicle overtake within crossing limits 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Driver not in position to have Proper Control 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 2
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Driving a vehicle wholly or partly on a footpath 1
- No Insurance 1
- No Seat Belt 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- VRM fails to conform to Regulations 1
disposal 7
- NFA 325
- Warning Letter 210
- Education 92
- Fixed Penalty 72
- Court 30
- Other Action Taken 6
- RTC - Actioned 4
reporter_transport_mode 1
- Car · 739 ✖
month 1
- 2025-12 · 739 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3872 | op-snap---monthly-publication-december-2025.pdf | 0 | 2025-12 | Car | Mitsubishi | Silver | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | A366 | A366 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 3873 | op-snap---monthly-publication-december-2025.pdf | 1 | 2025-12 | Car | Skoda | Octavia | Grey | Contravening a Red Traffic Light | None | M42 Jct 10 | M42 Junction 10 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 3874 | op-snap---monthly-publication-december-2025.pdf | 2 | 2025-12 | Car | Volvo | Exc30 | Blue | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 3875 | op-snap---monthly-publication-december-2025.pdf | 3 | 2025-12 | Car | Vauxhall | Astra | Grey | Driving without Due Care and Attention | None | Umberslade Road | Umberslade Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4304526 | -1.9216716 | ||
| 3877 | op-snap---monthly-publication-december-2025.pdf | 5 | 2025-12 | Car | BMW | 220M | Silver | Contravening a Red Traffic Light | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4170522 | -1.8906187 | ||
| 3878 | op-snap---monthly-publication-december-2025.pdf | 6 | 2025-12 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 3879 | op-snap---monthly-publication-december-2025.pdf | 7 | 2025-12 | Car | Renault | Lorry | White | Driving without Due Care and Attention | None | M6 | M6 | Coventry | Coventry | NFA | No Offence | ||||
| 3880 | op-snap---monthly-publication-december-2025.pdf | 8 | 2025-12 | Car | BMW | 1 Series | Black | 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 | ||
| 3881 | op-snap---monthly-publication-december-2025.pdf | 9 | 2025-12 | Car | Ford | Fiesta | Black | 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 | ||
| 3882 | op-snap---monthly-publication-december-2025.pdf | 10 | 2025-12 | Car | Cupra | Terramar | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.502683 | -1.9033516 | ||
| 3883 | op-snap---monthly-publication-december-2025.pdf | 11 | 2025-12 | Car | Toyota | White | 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 | |||
| 3886 | op-snap---monthly-publication-december-2025.pdf | 14 | 2025-12 | Car | Caetano | White | Driving without Due Care and Attention | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | |||
| 3887 | op-snap---monthly-publication-december-2025.pdf | 15 | 2025-12 | Car | Tesla | model Y | White | Contravening a Red Traffic Light | None | Monkspath Interchange | Monkspath Interchange | Solihull | Solihull | NFA | No Independent Evidence Available | 52.3792737 | -1.7869373 | ||
| 3888 | op-snap---monthly-publication-december-2025.pdf | 16 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barton Drive | Barton Drive | Solihull | Solihull | Warning Letter | N/A | 52.3770722 | -1.7420909 | ||
| 3889 | op-snap---monthly-publication-december-2025.pdf | 17 | 2025-12 | Car | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barton Drive | Barton Drive | Solihull | Solihull | NFA | No Offence | 52.3770722 | -1.7420909 | ||
| 3893 | op-snap---monthly-publication-december-2025.pdf | 21 | 2025-12 | Car | Ford | puma | Grey | Using a Mobile Phone Whilst Driving | None | Sarehole Road | Sarehole Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4422505 | -1.8539684 | ||
| 3894 | op-snap---monthly-publication-december-2025.pdf | 22 | 2025-12 | Car | Hyundai | Ioniq | 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 | ||
| 3895 | op-snap---monthly-publication-december-2025.pdf | 23 | 2025-12 | Car | Vauxhall | Corsa | Black | 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 | ||
| 3896 | op-snap---monthly-publication-december-2025.pdf | 24 | 2025-12 | Car | Vauxhall | Mokka | Black | 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 | ||
| 3897 | op-snap---monthly-publication-december-2025.pdf | 25 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Cause vehicle to be left in a dangerous position | None | West Bromwich High St | West Bromwich High Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5205106 | -1.9980473 | ||
| 3900 | op-snap---monthly-publication-december-2025.pdf | 28 | 2025-12 | Car | Fiat | 500 | White | Misc - Non Traffic Offences | None | M5, worcestershire | M5, worcestershire | Out of Force Area | Out of Force Area | NFA | No VRM | 52.432364 | -2.0176127 | ||
| 3904 | op-snap---monthly-publication-december-2025.pdf | 32 | 2025-12 | Car | Cupra | Formentor | Black | Contravening a Red Traffic Light | None | Dudley Road | Dudley Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4877352 | -1.9494469 | ||
| 3908 | op-snap---monthly-publication-december-2025.pdf | 36 | 2025-12 | Car | Land Rover | Sport | Black | Driving without Due Care and Attention | None | M6 South | M6 South | Sandwell | Sandwell | NFA | No VRM | 52.5228877 | -2.0650728 | ||
| 3909 | op-snap---monthly-publication-december-2025.pdf | 37 | 2025-12 | Car | Mercedes-Benz | Benz | White | Using a Mobile Phone Whilst Driving | None | Alcester Street | Alcester Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4696096 | -1.8871873 | ||
| 3911 | op-snap---monthly-publication-december-2025.pdf | 39 | 2025-12 | Car | Renault | Twingo | Red | Using a Mobile Phone Whilst Driving | None | Bloomfield Road | Bloomfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4480767 | -1.8755275 | ||
| 3915 | op-snap---monthly-publication-december-2025.pdf | 43 | 2025-12 | Car | BMW | X1 | Grey | 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 | ||
| 3916 | op-snap---monthly-publication-december-2025.pdf | 44 | 2025-12 | Car | Volkswagen | Tiguan | 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 | ||
| 3919 | op-snap---monthly-publication-december-2025.pdf | 47 | 2025-12 | Car | Vauxhall | Astra | White | Driving without Due Care and Attention | None | Chruch Lane | Chruch Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 3921 | op-snap---monthly-publication-december-2025.pdf | 49 | 2025-12 | Car | Porsche | Cayenne | Black | Using a Mobile Phone Whilst Driving | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | ||
| 3922 | op-snap---monthly-publication-december-2025.pdf | 50 | 2025-12 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 3934 | op-snap---monthly-publication-december-2025.pdf | 62 | 2025-12 | Car | Ford | Fiesta | 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 | ||
| 3935 | op-snap---monthly-publication-december-2025.pdf | 63 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | 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 | ||
| 3936 | op-snap---monthly-publication-december-2025.pdf | 64 | 2025-12 | Car | Mercedes-Benz | C220 | 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 | ||
| 3940 | op-snap---monthly-publication-december-2025.pdf | 68 | 2025-12 | Car | Audi | RS6 | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 3956 | op-snap---monthly-publication-december-2025.pdf | 84 | 2025-12 | Car | Toyota | Estima | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5550797 | -1.7950237 | ||
| 3957 | op-snap---monthly-publication-december-2025.pdf | 85 | 2025-12 | Car | Volkswagen | Touran | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 3958 | op-snap---monthly-publication-december-2025.pdf | 86 | 2025-12 | Car | Nissan | Note | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5001925 | -1.9481997 | ||
| 3959 | op-snap---monthly-publication-december-2025.pdf | 87 | 2025-12 | Car | Audi | A3 | Grey | 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 | ||
| 3965 | op-snap---monthly-publication-december-2025.pdf | 93 | 2025-12 | Car | Audi | q3 | Black | Misc - Non Traffic Offences | None | huntingtree road | Huntingtree Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4484682 | -2.0689885 | ||
| 3972 | op-snap---monthly-publication-december-2025.pdf | 100 | 2025-12 | Car | Toyota | prius | White | 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 | ||
| 3973 | op-snap---monthly-publication-december-2025.pdf | 101 | 2025-12 | Car | Citroen | berlingo | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3974 | op-snap---monthly-publication-december-2025.pdf | 102 | 2025-12 | Car | Volkswagen | golf | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 3975 | op-snap---monthly-publication-december-2025.pdf | 103 | 2025-12 | Car | Volkswagen | xc90 | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 3976 | op-snap---monthly-publication-december-2025.pdf | 104 | 2025-12 | Car | Ford | fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Other Action Taken | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 3977 | op-snap---monthly-publication-december-2025.pdf | 105 | 2025-12 | Car | Vauxhall | corsa | Red | Cause vehicle to be left in a dangerous position | None | washwood hath road | Washwood Hath Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3980 | op-snap---monthly-publication-december-2025.pdf | 108 | 2025-12 | Car | Ford | C Maxx | Black | Using a Mobile Phone Whilst Driving | None | Ansty Road | Ansty Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4205675 | -1.4520187 | ||
| 3981 | op-snap---monthly-publication-december-2025.pdf | 109 | 2025-12 | Car | Toyota | AYGO | White | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 3982 | op-snap---monthly-publication-december-2025.pdf | 110 | 2025-12 | Car | Byd | Seal | Black | Driving without Due Care and Attention | None | Claredon Road Watford | Claredon Road Watford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 3983 | op-snap---monthly-publication-december-2025.pdf | 111 | 2025-12 | Car | Mercedes-Benz | A35 | White | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 3985 | op-snap---monthly-publication-december-2025.pdf | 113 | 2025-12 | Car | Kia | Sportage | White | Driving without Due Care and Attention | None | M42 Junction 4 | M42 Junction 4 | Solihull | Solihull | Education | N/A | ||||
| 3989 | op-snap---monthly-publication-december-2025.pdf | 117 | 2025-12 | Car | Mercedes-Benz | C220 | White | Driving without Due Care and Attention | None | Lodge Road | Lodge Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5072626 | -1.8935604 | ||
| 3990 | op-snap---monthly-publication-december-2025.pdf | 118 | 2025-12 | Car | Mercedes-Benz | CLA220 | White | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 3991 | op-snap---monthly-publication-december-2025.pdf | 119 | 2025-12 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Factory Road | Factory Road | Dudley | Dudley | Education | N/A | 52.5324055 | -2.0739923 | ||
| 3992 | op-snap---monthly-publication-december-2025.pdf | 120 | 2025-12 | Car | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | Factory Road | Factory Road | Dudley | Dudley | Education | N/A | 52.5324055 | -2.0739923 | ||
| 3993 | op-snap---monthly-publication-december-2025.pdf | 121 | 2025-12 | Car | Citroen | Relay | White | Driving without Due Care and Attention | None | Pooles Lane | Pooles Lane | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 3996 | op-snap---monthly-publication-december-2025.pdf | 124 | 2025-12 | Car | Mercedes-Benz | AMG | Grey | Driving without Due Care and Attention | No Insurance | High Street Kings Heath | High Street Kings Heath | Birmingham | Birmingham | Court | N/A | 52.4375456 | -1.8926849 | ||
| 3997 | op-snap---monthly-publication-december-2025.pdf | 125 | 2025-12 | Car | Renault | Truck | White | Contravening a Red Traffic Light | None | Newport Road, Castle Bromwich | Newport Road, Castle Bromwich | Birmingham | Birmingham | Education | N/A | ||||
| 3999 | op-snap---monthly-publication-december-2025.pdf | 127 | 2025-12 | Car | Bentley | Grey | Using a Mobile Phone Whilst Driving | None | M42 West Mercia | M42 West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4000 | op-snap---monthly-publication-december-2025.pdf | 128 | 2025-12 | Car | Land Rover | Range Rover | Brown | Driving without Due Care and Attention | None | Goldieslie Road | Goldieslie Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5511935 | -1.8298782 | ||
| 4001 | op-snap---monthly-publication-december-2025.pdf | 129 | 2025-12 | Car | Skoda | Octavia | Black | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.6291998 | -2.126312 | ||
| 4002 | op-snap---monthly-publication-december-2025.pdf | 130 | 2025-12 | Car | BMW | 3 Series | Grey | Driving without Due Care and Attention | None | Stafford St | Stafford Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5653849 | -2.0755665 | ||
| 4003 | op-snap---monthly-publication-december-2025.pdf | 131 | 2025-12 | Car | Jeep | Renegade | Black | Driving without Due Care and Attention | None | Grove Lane | Grove Lane | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5541631 | -1.7509992 | ||
| 4004 | op-snap---monthly-publication-december-2025.pdf | 132 | 2025-12 | Car | Vauxhall | Corsa | Silver | Using a Mobile Phone Whilst Driving | None | Coles Hill Road | Coles Hill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4005 | op-snap---monthly-publication-december-2025.pdf | 133 | 2025-12 | Car | Renault | Capture | Red | Driving without Due Care and Attention | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4373076 | -1.9543847 | ||
| 4006 | op-snap---monthly-publication-december-2025.pdf | 134 | 2025-12 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | M42 | M42 | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4007 | op-snap---monthly-publication-december-2025.pdf | 135 | 2025-12 | Car | Audi | A5 | Silver | Contravening a Red Traffic Light | None | Church Hill Road | Church Hill Road | Solihull | Solihull | Education | N/A | 52.4078582 | -1.7777439 | ||
| 4008 | op-snap---monthly-publication-december-2025.pdf | 136 | 2025-12 | Car | Fiat | doblo | Red | Contravening a Red Traffic Light | None | Soho Hill | Soho Hill | Birmingham | Birmingham | NFA | No Offence | 52.4983151 | -1.9186252 | ||
| 4013 | op-snap---monthly-publication-december-2025.pdf | 141 | 2025-12 | Car | BMW | 3 series | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 4014 | op-snap---monthly-publication-december-2025.pdf | 142 | 2025-12 | Car | BMW | 2 series | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Education | N/A | 52.4191184 | -1.8326637 | ||
| 4018 | op-snap---monthly-publication-december-2025.pdf | 146 | 2025-12 | Car | Mercedes-Benz | CLA | Red | Contravening a Red Traffic Light | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | NFA | No Offence | 52.4656414 | -1.9852276 | ||
| 4019 | op-snap---monthly-publication-december-2025.pdf | 147 | 2025-12 | Car | HGV | Red | Driving without Due Care and Attention | None | M42 Westbound | M42 Westbound | Solihull | Solihull | NFA | No VRM | |||||
| 4024 | op-snap---monthly-publication-december-2025.pdf | 152 | 2025-12 | Car | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Holloway Bank | Holloway Bank | Sandwell | Sandwell | RTC - Actioned | N/A | 52.5430345 | -2.0152621 | ||
| 4025 | op-snap---monthly-publication-december-2025.pdf | 153 | 2025-12 | Car | Hyundai | Amica | black | Using a Mobile Phone Whilst Driving | None | M6 Junction 9 | M6 Junction 9 | Walsall | Walsall | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 4028 | op-snap---monthly-publication-december-2025.pdf | 156 | 2025-12 | Car | BMW | X4 | Red | Vehicle overtake within crossing limits | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 4029 | op-snap---monthly-publication-december-2025.pdf | 157 | 2025-12 | Car | Volkswagen | Tiguan | Grey | Driving without Due Care and Attention | None | B457 Locher StraBe von Licht Kom | Locher Stra Be von Licht Kom | mOeunt dof Force Area | Moeunt Dof Force Area | NFA | Out of Force | ||||
| 4030 | op-snap---monthly-publication-december-2025.pdf | 158 | 2025-12 | Car | Honda | Jazz | Grey | Contravening a Red Traffic Light | None | Wolverhampton Road at Portway | Wolverhampton Road at Portway | RSoaanddwell | Rsoaanddwell | Fixed Penalty | N/A | 52.4661511 | -1.9846785 | ||
| 4031 | op-snap---monthly-publication-december-2025.pdf | 159 | 2025-12 | Car | BMW | 5 series | Black | Driving without Due Care and Attention | None | Fenton Street, Smethwick | Fenton Street, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5003489 | -1.9788331 | ||
| 4032 | op-snap---monthly-publication-december-2025.pdf | 160 | 2025-12 | Car | BMW | 1 Series | Silver | Driving without Due Care and Attention | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.502683 | -1.9033516 | ||
| 4033 | op-snap---monthly-publication-december-2025.pdf | 161 | 2025-12 | Car | Iveco | HGV | White | Driving without Due Care and Attention | None | M5 Northbound | M5 Northbound | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 4034 | op-snap---monthly-publication-december-2025.pdf | 162 | 2025-12 | Car | Porsche | Boxster | White | Driving without Due Care and Attention | None | Black Country Route | Black Country Route | Wolverhampton | Wolverhampton | Education | N/A | 52.5642677 | -2.0755469 | ||
| 4036 | op-snap---monthly-publication-december-2025.pdf | 164 | 2025-12 | Car | BMW | 420 | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 4037 | op-snap---monthly-publication-december-2025.pdf | 165 | 2025-12 | Car | Kia | Niro | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 4038 | op-snap---monthly-publication-december-2025.pdf | 166 | 2025-12 | Car | Volkswagen | Golf | White | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 4039 | op-snap---monthly-publication-december-2025.pdf | 167 | 2025-12 | Car | Ford | Fiesta | White | Driving without Reasonable Consideration | None | Black Country New Road | Black Country New Road | Sandwell | Sandwell | Education | N/A | 52.5527191 | -2.0312967 | ||
| 4040 | op-snap---monthly-publication-december-2025.pdf | 168 | 2025-12 | Car | BMW | X1 | White | Driving without Due Care and Attention | None | A46 | A46 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4042 | op-snap---monthly-publication-december-2025.pdf | 170 | 2025-12 | Car | BMW | X5 | White | Contravening a Red Traffic Light | None | Newton Road | Newton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4541102 | -1.8710993 | ||
| 4043 | op-snap---monthly-publication-december-2025.pdf | 171 | 2025-12 | Car | Ford | White | Using a Mobile Phone Whilst Driving | None | Leamington Road | Leamington Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3921304 | -1.5156601 | |||
| 4046 | op-snap---monthly-publication-december-2025.pdf | 174 | 2025-12 | Car | BMW | 3 series | Grey | Driving without Due Care and Attention | None | West Mrob | West Mrob | Sandwell | Sandwell | NFA | No Offence | ||||
| 4048 | op-snap---monthly-publication-december-2025.pdf | 176 | 2025-12 | Car | Nissan | Qashqai | Red | Driving without Due Care and Attention | None | Lytton Way, Stevenage | Lytton Way, Stevenage | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4052 | op-snap---monthly-publication-december-2025.pdf | 180 | 2025-12 | Car | Vauxhall | Black | Driving without Due Care and Attention | None | Whitecross Road | Whitecross Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4053 | op-snap---monthly-publication-december-2025.pdf | 181 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Fenton Street | Fenton Street | Sandwell | Sandwell | NFA | No VRM | 52.5004036 | -1.9790049 | ||
| 4054 | op-snap---monthly-publication-december-2025.pdf | 182 | 2025-12 | Car | Skoda | Octavia | Black | Contravening a Red Traffic Light | None | Fenton Street | Fenton Street | Sandwell | Sandwell | Court | N/A | 52.5004036 | -1.9790049 | ||
| 4056 | op-snap---monthly-publication-december-2025.pdf | 184 | 2025-12 | Car | Porsche | Macan | Black | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5872149 | -1.8300386 | ||
| 4057 | op-snap---monthly-publication-december-2025.pdf | 185 | 2025-12 | Car | Scania | HGV | White | Driving without Due Care and Attention | None | M6 Jn11 | M6 Jn11 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5145911 | -1.8679162 | ||
| 4058 | op-snap---monthly-publication-december-2025.pdf | 186 | 2025-12 | Car | Toyota | Yaris | White | Contravening a Red Traffic Light | None | Beake Avenue | Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4388246 | -1.5229308 | ||
| 4059 | op-snap---monthly-publication-december-2025.pdf | 187 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Using a Mobile Phone Whilst Driving | None | M1 / M45 Watford Gap | M1 / M45 Watford Gap | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4060 | op-snap---monthly-publication-december-2025.pdf | 188 | 2025-12 | Car | Hyundai | Amica | Black | Driving without Due Care and Attention | None | Broad Lane | Broad Lane | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | 52.5784844 | -2.1596223 | ||
| 4061 | op-snap---monthly-publication-december-2025.pdf | 189 | 2025-12 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | A41 Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 4063 | op-snap---monthly-publication-december-2025.pdf | 191 | 2025-12 | Car | Jeep | Renegade | White | Misc - Non Traffic Offences | None | A4040 Island Road | Island Road | Sandwell | Sandwell | NFA | No Offence | 52.4634433 | -1.9965278 | ||
| 4065 | op-snap---monthly-publication-december-2025.pdf | 193 | 2025-12 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 |
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);