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'}
453 rows where disposal = "NFA", month = "2025-08" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
offence 22
- Driving without Due Care and Attention 239
- Contravening a Red Traffic Light 90
- Using a Mobile Phone Whilst Driving 39
- Misc - Non Traffic Offences 36
- Driving without Reasonable Consideration 12
- Cause vehicle to be left in a dangerous position 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 4
- Drive on hard shoulder 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Contravene Lane Closure Red X 2
- Drive / Ride / Lead an animal on a footpath 2
- Dangerous Driving 1
- Driving a vehicle wholly or partly on a footpath 1
- Duplicate Submission 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Insurance 1
- No vehicle excise licence 1
- Prohibited vehicle in offside lane of motorway 1
- Stop a vehicle on pedestrian crossing 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
council_area 10
- Birmingham 158
- Out of Force Area 147
- Walsall 34
- Coventry 28
- Wolverhampton 23
- Solihull 19
- Sandwell 18
- Dudley 11
- Sutton Coldfield 11
- Halesowen 3
reporter_transport_mode 1
- Car · 453 ✖
month 1
- 2025-08 · 453 ✖
disposal 1
- NFA · 453 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2033 | op-snap---monthly-publication-august-2025.pdf | 8 | 2025-08 | Car | Nissan | Interstar | White | Using a Mobile Phone Whilst Driving | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6166864 | -1.9660822 | ||
| 2034 | op-snap---monthly-publication-august-2025.pdf | 9 | 2025-08 | Car | Audi | A5 | Grey | Contravening a Red Traffic Light | None | Bradford Road | Bradford Road | Birmingham | Birmingham | NFA | No Offence | 52.5024148 | -1.7961753 | ||
| 2036 | op-snap---monthly-publication-august-2025.pdf | 11 | 2025-08 | Car | Ford | Focus | White | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6166864 | -1.9660822 | ||
| 2040 | op-snap---monthly-publication-august-2025.pdf | 15 | 2025-08 | Car | Man | HGV | Blue | Using a Mobile Phone Whilst Driving | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6166864 | -1.9660822 | ||
| 2041 | op-snap---monthly-publication-august-2025.pdf | 16 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.505832 | -1.92002 | ||
| 2042 | op-snap---monthly-publication-august-2025.pdf | 17 | 2025-08 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Walsall | Walsall | NFA | No Offence | 52.6166864 | -1.9660822 | ||
| 2043 | op-snap---monthly-publication-august-2025.pdf | 18 | 2025-08 | Car | Seat | Ibiza | Silver | Misc - Non Traffic Offences | None | Perry Avenue | Perry Avenue | Birmingham | Birmingham | NFA | No Offence | 52.5264237 | -1.908301 | ||
| 2045 | op-snap---monthly-publication-august-2025.pdf | 20 | 2025-08 | Car | Volvo | S60 | Blue | Misc - Non Traffic Offences | None | Waslall Road | Waslall Road | Walsall | Walsall | NFA | No Offence | ||||
| 2046 | op-snap---monthly-publication-august-2025.pdf | 21 | 2025-08 | Car | Land Rover | Discovery | Blue | Contravening a Red Traffic Light | None | Shirley Road | Shirley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4198291 | -1.9241732 | ||
| 2050 | op-snap---monthly-publication-august-2025.pdf | 25 | 2025-08 | Car | Iveco | White | Contravening a Red Traffic Light | None | A34 | A34 | Birmingham | Birmingham | NFA | No Offence | |||||
| 2052 | op-snap---monthly-publication-august-2025.pdf | 27 | 2025-08 | Car | Unknown | Blue | Misc - Non Traffic Offences | None | A444 | A444 | Coventry | Coventry | NFA | No Offence | |||||
| 2057 | op-snap---monthly-publication-august-2025.pdf | 32 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | City Road at Rotten Park Road | City Road at Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4763176 | -1.9584897 | ||
| 2059 | op-snap---monthly-publication-august-2025.pdf | 34 | 2025-08 | Car | Audi | A3 | Blue | Contravening a Red Traffic Light | None | Homer Road | Homer Road | Out of Force Are | Out of Force Area | NFA | No Independent Evidence Available | ||||
| 2061 | op-snap---monthly-publication-august-2025.pdf | 36 | 2025-08 | Car | Subaru | Grey | Driving without Due Care and Attention | None | Meeting House Lane | Meeting House Lane | Coventry | Coventry | NFA | No Offence | |||||
| 2062 | op-snap---monthly-publication-august-2025.pdf | 37 | 2025-08 | Car | BMW | M4 | Grey | Contravening a Red Traffic Light | None | Iiford High Road | Iiford High Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2063 | op-snap---monthly-publication-august-2025.pdf | 38 | 2025-08 | Car | Land Rover | Evoque | Grey | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 2066 | op-snap---monthly-publication-august-2025.pdf | 41 | 2025-08 | Car | Renault | HGV | Orange | Drive / Ride / Lead an animal on a footpath | None | Green Lane | Green Lane | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4618966 | -1.9955421 | ||
| 2073 | op-snap---monthly-publication-august-2025.pdf | 48 | 2025-08 | Car | UK | Silver | Driving a vehicle wholly or partly on a footpath | None | Longford Road | Longford Road | Coventry | Coventry | NFA | Not in Public Interest | 52.445164 | -1.4879298 | |||
| 2078 | op-snap---monthly-publication-august-2025.pdf | 53 | 2025-08 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Offence | 52.4214017 | -1.4870278 | ||
| 2083 | op-snap---monthly-publication-august-2025.pdf | 58 | 2025-08 | Car | Daf | Truck | Orange | Contravening a Red Traffic Light | None | B4154 | B4154 | Walsall | Walsall | NFA | No Offence | 52.5532445 | -1.9092118 | ||
| 2085 | op-snap---monthly-publication-august-2025.pdf | 60 | 2025-08 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Charnwood Close | Charnwood Close | Birmingham | Birmingham | NFA | No Offence | 52.4095185 | -2.0031237 | ||
| 2087 | op-snap---monthly-publication-august-2025.pdf | 62 | 2025-08 | Car | Lorry | White | Contravening a Red Traffic Light | None | A449 Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | NFA | No VRM | 52.6291998 | -2.126312 | |||
| 2093 | op-snap---monthly-publication-august-2025.pdf | 68 | 2025-08 | Car | Volkswagen | Polo | Black | Contravening a Red Traffic Light | None | Ringway St Johns | Ringway Street Johns | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 2095 | op-snap---monthly-publication-august-2025.pdf | 70 | 2025-08 | Car | Skoda | Rapid | Grey | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 2096 | op-snap---monthly-publication-august-2025.pdf | 71 | 2025-08 | Car | Mg | ZS Trophy | Silver | Using a Mobile Phone Whilst Driving | None | A34 Jct 9 | Junction 9 | Walsall | Walsall | NFA | No Independent Evidence Available | 52.56499 | -1.9863008 | ||
| 2097 | op-snap---monthly-publication-august-2025.pdf | 72 | 2025-08 | Car | Audi | Grey | Driving without Due Care and Attention | None | Sky Blue Way | Sky Blue Way | Coventry | Coventry | NFA | Not in Public Interest | 52.4085943 | -1.4943275 | |||
| 2098 | op-snap---monthly-publication-august-2025.pdf | 73 | 2025-08 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 2100 | op-snap---monthly-publication-august-2025.pdf | 75 | 2025-08 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Foleshill | Foleshill | Coventry | Coventry | NFA | Not in Public Interest | 52.4335692 | -1.4944742 | |||
| 2101 | op-snap---monthly-publication-august-2025.pdf | 76 | 2025-08 | Car | Mercedes-Benz | Black | Driving without Due Care and Attention | None | A425 Southam | Southam | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2103 | op-snap---monthly-publication-august-2025.pdf | 78 | 2025-08 | Car | Ford | Mondeo | Blue | Driving without Due Care and Attention | None | A5 Telford | Telford | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | ||
| 2104 | op-snap---monthly-publication-august-2025.pdf | 79 | 2025-08 | Car | Mercedes-Benz | C200 | White | Drive on hard shoulder | None | M6 | M6 | Birmingham | Birmingham | NFA | No VRM | ||||
| 2106 | op-snap---monthly-publication-august-2025.pdf | 81 | 2025-08 | Car | Polestar | Silver | Driving without Due Care and Attention | No Insurance | A52 Bottesford | Bottesford | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2113 | op-snap---monthly-publication-august-2025.pdf | 88 | 2025-08 | Car | Vauxhall | Astra | Black | Driving without Due Care and Attention | None | Quinton Road | Quinton Road | Birmingham | Birmingham | NFA | No Offence | 52.447826 | -1.9574468 | ||
| 2114 | op-snap---monthly-publication-august-2025.pdf | 89 | 2025-08 | Car | Mercedes-Benz | Sprinter | Blue | Using a Mobile Phone Whilst Driving | None | M6 Staffs | M6 Staffs | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.6170728 | -2.030393 | ||
| 2115 | op-snap---monthly-publication-august-2025.pdf | 90 | 2025-08 | Car | Peugeot | White | Driving without Due Care and Attention | None | M42 | M42 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2120 | op-snap---monthly-publication-august-2025.pdf | 95 | 2025-08 | Car | BMW | 320d | Black | Driving without Due Care and Attention | None | Merry Hill | Merry Hill | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4817646 | -2.1113435 | ||
| 2121 | op-snap---monthly-publication-august-2025.pdf | 96 | 2025-08 | Car | Ford | Transit | Black | Driving without Due Care and Attention | None | Illshaw Heath Road | Illshaw Heath Road | Solihull | Solihull | NFA | No Offence | 52.3735755 | -1.8129528 | ||
| 2124 | op-snap---monthly-publication-august-2025.pdf | 99 | 2025-08 | Car | Mercedes-Benz | White | Driving without Due Care and Attention | None | Horseshoes Lane | Horseshoes Lane | Solihull | Solihull | NFA | No VRM | |||||
| 2125 | op-snap---monthly-publication-august-2025.pdf | 100 | 2025-08 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Bromsgrove Road (Studley) | Bromsgrove Road (Studley) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2128 | op-snap---monthly-publication-august-2025.pdf | 103 | 2025-08 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | A5 (Brownhills) | A5 (Brownhills) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2131 | op-snap---monthly-publication-august-2025.pdf | 106 | 2025-08 | Car | Mercedes-Benz | N/K | Silver | Driving without Due Care and Attention | None | B4121 Barnes Hill | Barnes Hill | Birmingham | Birmingham | NFA | No VRM | 52.4401325 | -1.9785938 | ||
| 2132 | op-snap---monthly-publication-august-2025.pdf | 107 | 2025-08 | Car | Tesla | Model Y | Blue | Using a Mobile Phone Whilst Driving | None | M6 NB 10-10A | M6 Northbound 10-10A | Wolverhampton | Wolverhampton | NFA | Out of Force | ||||
| 2134 | op-snap---monthly-publication-august-2025.pdf | 109 | 2025-08 | Car | Dacia | Stepway | Grey | Driving without Due Care and Attention | None | Daventry Road | Daventry Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2142 | op-snap---monthly-publication-august-2025.pdf | 117 | 2025-08 | Car | Audi | Q5 | Grey | Driving without Due Care and Attention | None | Shutt Lane | Shutt Lane | Solihull | Solihull | NFA | No Offence | 52.367795 | -1.8250635 | ||
| 2145 | op-snap---monthly-publication-august-2025.pdf | 120 | 2025-08 | Car | Mercedes-Benz | Vito | Grey | Driving without Due Care and Attention | None | M42 NB J7 | M42 Northbound J7 | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | ||||
| 2148 | op-snap---monthly-publication-august-2025.pdf | 123 | 2025-08 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Bloxwich Road | Bloxwich Road | Walsall | Walsall | NFA | No VRM | 52.6099132 | -1.9970978 | ||
| 2149 | op-snap---monthly-publication-august-2025.pdf | 124 | 2025-08 | Car | Motorbike | Black | Driving without Due Care and Attention | None | Kingswinford High Street | Kingswinford High Street | Dudley | Dudley | NFA | No VRM | 52.4972711 | -2.1679401 | |||
| 2150 | op-snap---monthly-publication-august-2025.pdf | 125 | 2025-08 | Car | Mercedes-Benz | AMG C | Black | Driving without Due Care and Attention | None | M6 (T2 Toll) | M6 (T2 Toll) | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2151 | op-snap---monthly-publication-august-2025.pdf | 126 | 2025-08 | Car | Audi | S3 | Grey | Driving without Due Care and Attention | None | M6 (T2 Toll) | M6 (T2 Toll) | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2153 | op-snap---monthly-publication-august-2025.pdf | 128 | 2025-08 | Car | Hyundai | I10 | Red | Driving without Due Care and Attention | None | Bickenhill Lane | Bickenhill Lane | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 2156 | op-snap---monthly-publication-august-2025.pdf | 131 | 2025-08 | Car | Tesla | Model 3 | Grey | Contravening a Red Traffic Light | None | Europa Way | Europa Way | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2158 | op-snap---monthly-publication-august-2025.pdf | 133 | 2025-08 | Car | Mercedes-Benz | C class | Silver | Contravening a Red Traffic Light | No Insurance | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4555288 | -1.8613929 | ||
| 2160 | op-snap---monthly-publication-august-2025.pdf | 135 | 2025-08 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Bromsgrove | Bromsgrove | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.4728322 | -1.897536 | ||
| 2162 | op-snap---monthly-publication-august-2025.pdf | 137 | 2025-08 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5292752 | -1.7618805 | ||
| 2164 | op-snap---monthly-publication-august-2025.pdf | 139 | 2025-08 | Car | Mg | 4SE | Grey | Driving without Due Care and Attention | None | Queensway | Queensway | Birmingham | Birmingham | NFA | No Offence | 52.4856447 | -1.8972389 | ||
| 2168 | op-snap---monthly-publication-august-2025.pdf | 143 | 2025-08 | Car | Hyundai | i30 | Grey | Using a Mobile Phone Whilst Driving | None | M5 Oldbury | M5 Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5000242 | -2.0118933 | ||
| 2169 | op-snap---monthly-publication-august-2025.pdf | 144 | 2025-08 | Car | Honda | CRV | Black | Driving without Due Care and Attention | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4668753 | -1.8996143 | ||
| 2174 | op-snap---monthly-publication-august-2025.pdf | 149 | 2025-08 | Car | Audi | A4 | Black | Driving without Due Care and Attention | None | Monmouth Drive | Monmouth Drive | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5575249 | -1.8640053 | ||
| 2176 | op-snap---monthly-publication-august-2025.pdf | 151 | 2025-08 | Car | Mercedes-Benz | A220 | White | Driving without Due Care and Attention | None | M5 J2 NB | M5 J2 Northbound | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4945433 | -2.0190848 | ||
| 2177 | op-snap---monthly-publication-august-2025.pdf | 152 | 2025-08 | Car | Toyota | Prius | White | Driving without Due Care and Attention | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6043868 | -2.1046385 | ||
| 2178 | op-snap---monthly-publication-august-2025.pdf | 153 | 2025-08 | Car | Mercedes-Benz | benz | Silver | Driving without Due Care and Attention | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6043868 | -2.1046385 | ||
| 2179 | op-snap---monthly-publication-august-2025.pdf | 154 | 2025-08 | Car | Mercedes-Benz | A Class | White | Driving without Due Care and Attention | None | Ringway, Whitefriars | Ringway, Whitefriars | Coventry | Coventry | NFA | Not in Public Interest | ||||
| 2181 | op-snap---monthly-publication-august-2025.pdf | 156 | 2025-08 | Car | Honda | Black | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | NFA | Not in Public Interest | |||||
| 2182 | op-snap---monthly-publication-august-2025.pdf | 157 | 2025-08 | Car | Audi | RS3 | Grey | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No VRM | 52.4622646 | -1.8599985 | ||
| 2183 | op-snap---monthly-publication-august-2025.pdf | 158 | 2025-08 | Car | Volkswagen | Passat | Black | Driving without Due Care and Attention | None | City Road | City Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4763176 | -1.9584897 | ||
| 2188 | op-snap---monthly-publication-august-2025.pdf | 163 | 2025-08 | Car | Tesla | Grey | Driving without Due Care and Attention | None | Newbold Road | Newbold Road | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2192 | op-snap---monthly-publication-august-2025.pdf | 167 | 2025-08 | Car | Mercedes-Benz | B200 | Red | Contravening a Red Traffic Light | None | Lime Lane | Lime Lane | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2197 | op-snap---monthly-publication-august-2025.pdf | 172 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Waverly Road | Waverly Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 2198 | op-snap---monthly-publication-august-2025.pdf | 173 | 2025-08 | Car | Mercedes-Benz | C class | Silver | Misc - Non Traffic Offences | None | Green Lane | Green Lane | Walsall | Walsall | NFA | No Offence | 52.5995834 | -1.9971273 | ||
| 2207 | op-snap---monthly-publication-august-2025.pdf | 182 | 2025-08 | Car | Land Rover | Vogue | White | Contravening a Red Traffic Light | None | Henwood Road Jct | Henwood Road Junction | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 2209 | op-snap---monthly-publication-august-2025.pdf | 184 | 2025-08 | Car | Saab | Silver | Driving without Due Care and Attention | None | Dunchurch | Dunchurch | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2213 | op-snap---monthly-publication-august-2025.pdf | 188 | 2025-08 | Car | Mercedes-Benz | CLA 220 | White | Driving without Due Care and Attention | None | Darlaston Road | Darlaston Road | Walsall | Walsall | NFA | Not in Public Interest | 52.5635181 | -2.0322876 | ||
| 2218 | op-snap---monthly-publication-august-2025.pdf | 193 | 2025-08 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | No Insurance | Pensnett Drive | Pensnett Drive | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 2222 | op-snap---monthly-publication-august-2025.pdf | 197 | 2025-08 | Car | Mercedes-Benz | A180 | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4203897 | -1.8338574 | ||
| 2226 | op-snap---monthly-publication-august-2025.pdf | 201 | 2025-08 | Car | Ford | C-MAX ZETEC | White | Contravening a Red Traffic Light | None | Princess Alice Drive | Princess Alice Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5496104 | -1.860796 | ||
| 2228 | op-snap---monthly-publication-august-2025.pdf | 203 | 2025-08 | Car | Mercedes-Benz | CLC180 | Silver | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 2230 | op-snap---monthly-publication-august-2025.pdf | 205 | 2025-08 | Car | Lexus | NX 300H | Black | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 2232 | op-snap---monthly-publication-august-2025.pdf | 207 | 2025-08 | Car | Nissan | Micra | Silver | Misc - Non Traffic Offences | None | Aberdeen St | Aberdeen Street | Birmingham | Birmingham | NFA | No Offence | 52.4892114 | -1.9359778 | ||
| 2237 | op-snap---monthly-publication-august-2025.pdf | 212 | 2025-08 | Car | BMW | 530.. | White | Driving without Due Care and Attention | None | Childs Way Milton Keynes | Childs Way Milton Keynes | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2239 | op-snap---monthly-publication-august-2025.pdf | 214 | 2025-08 | Car | Hyundai | Blue | Using a Mobile Phone Whilst Driving | None | M6 SB 5-4A | M6 Southbound 5-4A | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||
| 2243 | op-snap---monthly-publication-august-2025.pdf | 218 | 2025-08 | Car | Land Rover | Land Rover | Grey | Driving without Due Care and Attention | None | M40 | M40 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2244 | op-snap---monthly-publication-august-2025.pdf | 219 | 2025-08 | Car | BMW | X5 | Black | Driving without Due Care and Attention | None | M4/m42 | M4/m42 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2245 | op-snap---monthly-publication-august-2025.pdf | 220 | 2025-08 | Car | Toyota | Yaris | Silver | Misc - Non Traffic Offences | None | Wobaston Road | Wobaston Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.628768 | -2.1306154 | ||
| 2246 | op-snap---monthly-publication-august-2025.pdf | 221 | 2025-08 | Car | Hyundai | Grey | Driving without Due Care and Attention | None | Redhill, Telford | Redhill, Telford | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2248 | op-snap---monthly-publication-august-2025.pdf | 223 | 2025-08 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | M40 towards Jct 15 | M40 towards Junction 15 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2249 | op-snap---monthly-publication-august-2025.pdf | 224 | 2025-08 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | A452 | A452 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2253 | op-snap---monthly-publication-august-2025.pdf | 228 | 2025-08 | Car | BMW | X5 | Grey | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||||
| 2255 | op-snap---monthly-publication-august-2025.pdf | 230 | 2025-08 | Car | Ford | Grey | Driving without Due Care and Attention | None | A45 | A45 | Coventry | Coventry | NFA | Not in Public Interest | |||||
| 2256 | op-snap---monthly-publication-august-2025.pdf | 231 | 2025-08 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | M42 | M42 | Birmingham | Birmingham | NFA | No VRM | ||||
| 2258 | op-snap---monthly-publication-august-2025.pdf | 233 | 2025-08 | Car | Misc - Non Traffic Offences | None | Manor way | Manor way | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||||
| 2259 | op-snap---monthly-publication-august-2025.pdf | 234 | 2025-08 | Car | Scania | White | Driving without Due Care and Attention | None | M42 NB J9 | M42 Northbound J9 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2262 | op-snap---monthly-publication-august-2025.pdf | 237 | 2025-08 | Car | Mercedes-Benz | AMG A35 | Yellow | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 2264 | op-snap---monthly-publication-august-2025.pdf | 239 | 2025-08 | Car | Vauxhall | Insignia | Silver | Using a Mobile Phone Whilst Driving | None | West Bromwich Ringway | West Bromwich Ringway | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.516463 | -1.9937537 | ||
| 2265 | op-snap---monthly-publication-august-2025.pdf | 240 | 2025-08 | Car | Red | Driving without Due Care and Attention | None | Haughton | Haughton | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||||
| 2267 | op-snap---monthly-publication-august-2025.pdf | 242 | 2025-08 | Car | Iveco | Daily | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Aberdeen Road | Aberdeen Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4901584 | -1.9379878 | ||
| 2270 | op-snap---monthly-publication-august-2025.pdf | 245 | 2025-08 | Car | Unknown | Silver | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No VRM | 52.5113867 | -1.8337258 | |||
| 2272 | op-snap---monthly-publication-august-2025.pdf | 247 | 2025-08 | Car | Unknown | Silver | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No VRM | 52.4203897 | -1.8338574 | |||
| 2273 | op-snap---monthly-publication-august-2025.pdf | 248 | 2025-08 | Car | Misc - Non Traffic Offences | None | Gorge Road | Gorge Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.5446873 | -2.1069829 | |||||
| 2275 | op-snap---monthly-publication-august-2025.pdf | 250 | 2025-08 | Car | Toyota | Prius | Silver | Driving without Reasonable Consideration | None | Alum Rock Road | Alum Rock Road | Birmingham | Birmingham | NFA | No Offence | 52.4883936 | -1.8310056 | ||
| 2281 | op-snap---monthly-publication-august-2025.pdf | 256 | 2025-08 | Car | Jaguar | F-Pace | Grey | Using a Mobile Phone Whilst Driving | None | M5 Worcester | M5 Worcester | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.5908671 | -1.8140277 |
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);