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'}
717 rows where month = "2025-06" and offence = "Driving without Due Care and Attention" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
council_area 12
- Birmingham 366
- Out of Force Area 89
- Coventry 57
- Solihull 45
- Sandwell 38
- Dudley 36
- Walsall 32
- Wolverhampton 29
- Sutton Coldfield 16
- Metropolitan Borough 6
- Halesowen 2
- Bdirmingham 1
reporter_transport_mode 8
- Car 497
- Pedal Bike 149
- Other 31
- Pedestrian 27
- Lorry 6
- Motorbike 3
- Van 2
- car 2
disposal 7
- NFA 332
- Education 169
- Warning Letter 103
- Court 66
- Fixed Penalty 31
- RTC - Actioned 14
- Other Action Taken 2
offence 1
- Driving without Due Care and Attention · 717 ✖
month 1
- 2025-06 · 717 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14072 | op-snap---monthly-publication-june-2025.pdf | 1 | 2025-06 | Pedestrian | Seat | Leon | Grey | Driving without Due Care and Attention | None | Cotterills Road | Cotterills Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14076 | op-snap---monthly-publication-june-2025.pdf | 5 | 2025-06 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Little Aston Road | Little Aston Road | Walsall | Walsall | Education | N/A | 52.6049535 | -1.9142772 | ||
| 14088 | op-snap---monthly-publication-june-2025.pdf | 17 | 2025-06 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Shenley Fields Road | Shenley Fields Road | Birmingham | Birmingham | NFA | No VRM | 52.4373076 | -1.9543847 | ||
| 14089 | op-snap---monthly-publication-june-2025.pdf | 18 | 2025-06 | Car | BMW | 218I | Grey | Driving without Due Care and Attention | None | M42 Junction with M6 | M42 Junction with M6 | Birmingham | Birmingham | Education | N/A | ||||
| 14090 | op-snap---monthly-publication-june-2025.pdf | 19 | 2025-06 | Car | Seat | Leon | Red | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Court | N/A | 52.4726661 | -1.8769032 | ||
| 14093 | op-snap---monthly-publication-june-2025.pdf | 22 | 2025-06 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Shadowbrook lane | Shadowbrook lane | Solihull | Solihull | RTC - Actioned | N/A | 52.4306532 | -1.723655 | ||
| 14094 | op-snap---monthly-publication-june-2025.pdf | 23 | 2025-06 | Car | Seat | Altea | Silver | Driving without Due Care and Attention | None | Stonebridge Highway | Stonebridge Highway | Coventry | Coventry | Court | N/A | 52.3782187 | -1.478696 | ||
| 14095 | op-snap---monthly-publication-june-2025.pdf | 24 | 2025-06 | Pedal Bike | Mercedes-Benz | E300 | White | Driving without Due Care and Attention | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 14100 | op-snap---monthly-publication-june-2025.pdf | 29 | 2025-06 | Car | BMW | X6 | White | Driving without Due Care and Attention | None | Rowleys Green Roundabout | Rowleys Green Roundabout | Coventry | Coventry | Warning Letter | N/A | 52.4486967 | -1.4991069 | ||
| 14103 | op-snap---monthly-publication-june-2025.pdf | 32 | 2025-06 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | m5 Jct 6 (West Mercia) | m5 Junction 6 (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14106 | op-snap---monthly-publication-june-2025.pdf | 35 | 2025-06 | Car | Mini | Cooper | Black | Driving without Due Care and Attention | None | Out of force - Uttoxeter | Out of force - Uttoxeter | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14107 | op-snap---monthly-publication-june-2025.pdf | 36 | 2025-06 | Car | Kia | Picanto | White | Driving without Due Care and Attention | None | Tissington, Derbyshire | Tissington, Derbyshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14109 | op-snap---monthly-publication-june-2025.pdf | 38 | 2025-06 | Pedal Bike | Volvo | Red | Driving without Due Care and Attention | None | B4151 towards Walsall | B4151 towards Walsall | Walsall | Walsall | Education | N/A | |||||
| 14111 | op-snap---monthly-publication-june-2025.pdf | 40 | 2025-06 | Car | BMW | M | Grey | Driving without Due Care and Attention | None | CAKMORE ROAD | Cakmore Road | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 14112 | op-snap---monthly-publication-june-2025.pdf | 41 | 2025-06 | Pedestrian | Mercedes-Benz | GLB | Black | Driving without Due Care and Attention | None | Perry Barr Train Station | Perry Barr Train Station | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 14114 | op-snap---monthly-publication-june-2025.pdf | 43 | 2025-06 | Car | Peugeot | 308.. | White | Driving without Due Care and Attention | None | Great Colmore Street | Great Colmore Street | Birmingham | Birmingham | Education | N/A | 52.4712405 | -1.9028414 | ||
| 14117 | op-snap---monthly-publication-june-2025.pdf | 46 | 2025-06 | Pedal Bike | Jaguar | XF | Red | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Education | N/A | 52.4718503 | -1.9195423 | ||
| 14118 | op-snap---monthly-publication-june-2025.pdf | 47 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 14119 | op-snap---monthly-publication-june-2025.pdf | 48 | 2025-06 | Pedal Bike | Toyota | Prius | White | Driving without Due Care and Attention | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4718503 | -1.9195423 | ||
| 14120 | op-snap---monthly-publication-june-2025.pdf | 49 | 2025-06 | Pedal Bike | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Genners Lane | Genners Lane | Birmingham | Birmingham | Education | N/A | 52.4282602 | -1.9861769 | ||
| 14122 | op-snap---monthly-publication-june-2025.pdf | 51 | 2025-06 | Pedal Bike | Hyundai | I10 | White | Driving without Due Care and Attention | None | Poplar Road | Poplar Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4744337 | -1.9677475 | ||
| 14124 | op-snap---monthly-publication-june-2025.pdf | 53 | 2025-06 | Car | Lamborghini | Urus | Grey | Driving without Due Care and Attention | None | M6 near Nuneaton, Warwickshire | M6 near Nuneaton, Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14125 | op-snap---monthly-publication-june-2025.pdf | 54 | 2025-06 | Car | BMW | 420d | Black | Driving without Due Care and Attention | None | Much Park Street | Much Park Street | Coventry | Coventry | Court | N/A | 52.4061531 | -1.505845 | ||
| 14128 | op-snap---monthly-publication-june-2025.pdf | 57 | 2025-06 | Car | Skoda | FABIA | BLUE | Driving without Due Care and Attention | None | A457 ROLFE STREET | A457 Rolfe Street | Birmingham | Birmingham | Court | N/A | ||||
| 14133 | op-snap---monthly-publication-june-2025.pdf | 62 | 2025-06 | Car | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.418488 | -1.5472387 | ||
| 14134 | op-snap---monthly-publication-june-2025.pdf | 63 | 2025-06 | Pedal Bike | Audi | A1 | White | Driving without Due Care and Attention | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Education | N/A | 52.5131355 | -2.0651615 | ||
| 14138 | op-snap---monthly-publication-june-2025.pdf | 67 | 2025-06 | Lorry | Jaguar | XF | Blue | Driving without Due Care and Attention | None | Bickenhill Interchange | Bickenhill Interchange | Solihull | Solihull | Education | N/A | 52.4457674 | -1.7082354 | ||
| 14139 | op-snap---monthly-publication-june-2025.pdf | 68 | 2025-06 | Pedal Bike | Peugeot | 2008 | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5359496 | -1.8324115 | ||
| 14141 | op-snap---monthly-publication-june-2025.pdf | 70 | 2025-06 | Car | Volkswagen | Polo | Grey | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 14142 | op-snap---monthly-publication-june-2025.pdf | 71 | 2025-06 | Car | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | M5 j3 to 2 | M5 j3 to 2 | Sandwell | Sandwell | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 14143 | op-snap---monthly-publication-june-2025.pdf | 72 | 2025-06 | Car | Hyundai | Bayon | Black | Driving without Due Care and Attention | None | Farnborough Road | Farnborough Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5148331 | -1.79231 | ||
| 14147 | op-snap---monthly-publication-june-2025.pdf | 76 | 2025-06 | Pedal Bike | BMW | IX8 | White | Driving without Due Care and Attention | None | Clarence Road | Clarence Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5940902 | -1.843503 | ||
| 14149 | op-snap---monthly-publication-june-2025.pdf | 78 | 2025-06 | Car | BMW | 320D | Black | Driving without Due Care and Attention | None | Bordsley Circus | Bordsley Circus | Birmingham | Birmingham | Education | N/A | ||||
| 14151 | op-snap---monthly-publication-june-2025.pdf | 80 | 2025-06 | Car | Toyota | UK | Black | Driving without Due Care and Attention | None | Farnborough Road | Farnborough Road | Birmingham | Birmingham | NFA | No Offence | 52.5148331 | -1.79231 | ||
| 14152 | op-snap---monthly-publication-june-2025.pdf | 81 | 2025-06 | Car | Volkswagen | MOVE | Black | Driving without Due Care and Attention | None | DUDLEY STREET | Dudley Street | Dudley | Dudley | Education | N/A | 52.540391 | -2.1211076 | ||
| 14153 | op-snap---monthly-publication-june-2025.pdf | 82 | 2025-06 | car | Seat | Ibiza | White | Driving without Due Care and Attention | None | Coventry ring road | Coventry ring road | Coventry | Coventry | NFA | No Offence | ||||
| 14154 | op-snap---monthly-publication-june-2025.pdf | 83 | 2025-06 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | A38 Aston expressway | Aston expressway | Birmingham | Birmingham | Education | N/A | 52.493793 | -1.8881773 | ||
| 14160 | op-snap---monthly-publication-june-2025.pdf | 89 | 2025-06 | Pedestrian | Fiat | 500 | Blue | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5390972 | -1.9319478 | ||
| 14163 | op-snap---monthly-publication-june-2025.pdf | 92 | 2025-06 | Other | Mitsubishi | ASX | Blue | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Education | N/A | 52.5390972 | -1.9319478 | ||
| 14164 | op-snap---monthly-publication-june-2025.pdf | 93 | 2025-06 | Car | Vauxhall | Insignia | White | Driving without Due Care and Attention | None | A41 West Bromwich | West Bromwich | Sandwell | Sandwell | Education | N/A | 52.5186579 | -1.9923114 | ||
| 14166 | op-snap---monthly-publication-june-2025.pdf | 95 | 2025-06 | Pedestrian | Suzuki | UF50 | Blue | Driving without Due Care and Attention | No Insurance | HARCOURT DRIVE | Harcourt Drive | Sutton Coldfield | Sutton Coldfield | Court | N/A | 52.594171 | -1.8454056 | ||
| 14171 | op-snap---monthly-publication-june-2025.pdf | 100 | 2025-06 | Pedestrian | Toyota | Aygo | White | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 14173 | op-snap---monthly-publication-june-2025.pdf | 102 | 2025-06 | Pedestrian | Kia | Picanto | Red | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 14174 | op-snap---monthly-publication-june-2025.pdf | 103 | 2025-06 | Car | Vauxhall | Mokka | Black | Driving without Due Care and Attention | None | Stratford Upon Avon | Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3499075 | -1.7812051 | ||
| 14176 | op-snap---monthly-publication-june-2025.pdf | 105 | 2025-06 | Car | Audi | RS 3.. | Grey | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 14179 | op-snap---monthly-publication-june-2025.pdf | 108 | 2025-06 | Pedal Bike | BMW | X5 | Silver | Driving without Due Care and Attention | None | Danford Lane | Danford Lane | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 14182 | op-snap---monthly-publication-june-2025.pdf | 111 | 2025-06 | Car | Grey | Driving without Due Care and Attention | None | RUITON STREET | Ruiton Street | Birmingham | Birmingham | NFA | No Offence | ||||||
| 14183 | op-snap---monthly-publication-june-2025.pdf | 112 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14184 | op-snap---monthly-publication-june-2025.pdf | 113 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14185 | op-snap---monthly-publication-june-2025.pdf | 114 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14186 | op-snap---monthly-publication-june-2025.pdf | 115 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14187 | op-snap---monthly-publication-june-2025.pdf | 116 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14188 | op-snap---monthly-publication-june-2025.pdf | 117 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14189 | op-snap---monthly-publication-june-2025.pdf | 118 | 2025-06 | Car | NP | Driving without Due Care and Attention | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 14190 | op-snap---monthly-publication-june-2025.pdf | 119 | 2025-06 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | Ebrook Road | Ebrook Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5557273 | -1.8159805 | ||
| 14191 | op-snap---monthly-publication-june-2025.pdf | 120 | 2025-06 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | The Straits | The Straits | Dudley | Dudley | NFA | Misc Inc Crimes | 52.526275 | -2.1436065 | ||
| 14192 | op-snap---monthly-publication-june-2025.pdf | 121 | 2025-06 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Kings Road | Kings Road | Birmingham | Birmingham | Court | N/A | 52.5531351 | -1.8852761 | ||
| 14193 | op-snap---monthly-publication-june-2025.pdf | 122 | 2025-06 | Car | Seat | IBIZA | White | Driving without Due Care and Attention | None | A457 TOLLHOUSE WAY | A457 Tollhouse Way | Birmingham | Birmingham | Education | N/A | ||||
| 14194 | op-snap---monthly-publication-june-2025.pdf | 123 | 2025-06 | Pedal Bike | BMW | 320d | White | Driving without Due Care and Attention | None | The Broadway | The Broadway | Dudley | Dudley | Court | N/A | 52.515445 | -2.0885791 | ||
| 14196 | op-snap---monthly-publication-june-2025.pdf | 125 | 2025-06 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Waste Lane | Waste Lane | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.437361 | -1.5371291 | ||
| 14197 | op-snap---monthly-publication-june-2025.pdf | 126 | 2025-06 | Car | Vauxhall | Vivaro | Grey | Driving without Due Care and Attention | None | King Street Wellington (Telford) | King Street Wellington (Telford) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14202 | op-snap---monthly-publication-june-2025.pdf | 131 | 2025-06 | Car | Hyundai | I10 | Red | Driving without Due Care and Attention | None | Trysul Road | Trysul Road | Wolverhampton | Wolverhampton | Court | N/A | ||||
| 14203 | op-snap---monthly-publication-june-2025.pdf | 132 | 2025-06 | Car | BMW | 440i | Blue | Driving without Due Care and Attention | None | Warwick Road | Warwick Road | Solihull | Solihull | Warning Letter | N/A | 52.4428606 | -1.812114 | ||
| 14204 | op-snap---monthly-publication-june-2025.pdf | 133 | 2025-06 | Other | BMW | 116.. | Black | Driving without Due Care and Attention | No Insurance | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Court | N/A | 52.5390972 | -1.9319478 | ||
| 14208 | op-snap---monthly-publication-june-2025.pdf | 137 | 2025-06 | Car | Ford | FIESTA | Silver | Driving without Due Care and Attention | None | NEW ROWLEY ROAD | New Rowley Road | Dudley | Dudley | NFA | No Offence | 52.4985531 | -2.0680023 | ||
| 14209 | op-snap---monthly-publication-june-2025.pdf | 138 | 2025-06 | Car | Dacia | Sandero | Orange | Driving without Due Care and Attention | None | A46 Coventry Eastern Bypass | Coventry Eastern Bypass | Coventry | Coventry | Education | N/A | 52.3793117 | -1.4625379 | ||
| 14211 | op-snap---monthly-publication-june-2025.pdf | 140 | 2025-06 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 14213 | op-snap---monthly-publication-june-2025.pdf | 142 | 2025-06 | Car | Audi | s3 | Grey | Driving without Due Care and Attention | None | M6 J7 to 6 | M6 J7 to 6 | Birmingham | Birmingham | Fixed Penalty | N/A | 52.676119 | -2.0858425 | ||
| 14214 | op-snap---monthly-publication-june-2025.pdf | 143 | 2025-06 | Pedestrian | Ford | Icecream van | White | Driving without Due Care and Attention | None | Breedon Road | Breedon Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4191978 | -1.9251219 | ||
| 14215 | op-snap---monthly-publication-june-2025.pdf | 144 | 2025-06 | Car | BMW | 125 D. | Grey | Driving without Due Care and Attention | None | Church Avenue Amblecotte | Church Avenue Amblecotte | Dudley | Dudley | Education | N/A | ||||
| 14216 | op-snap---monthly-publication-june-2025.pdf | 145 | 2025-06 | Pedal Bike | Ford | fiesta | Black | Driving without Due Care and Attention | None | The Broadway | The Broadway | Metropolitan Borough | Metropolitan Borough | Warning Letter | N/A | 52.5108588 | -1.8919435 | ||
| 14217 | op-snap---monthly-publication-june-2025.pdf | 146 | 2025-06 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Stonebridge Island | Stonebridge Island | Coventry | Coventry | Warning Letter | N/A | 52.4459998 | -1.6949291 | ||
| 14220 | op-snap---monthly-publication-june-2025.pdf | 149 | 2025-06 | Motorbike | Seat | Cupra | Black | Driving without Due Care and Attention | None | Station Road, Rowley Regis | Station Road, Rowley Regis | Sandwell | Sandwell | Warning Letter | N/A | 52.4712548 | -2.0554193 | ||
| 14221 | op-snap---monthly-publication-june-2025.pdf | 150 | 2025-06 | Car | Toyota | AYGO | RED | Driving without Due Care and Attention | None | GOLF LANE LEAMINGTON | Golf Lane Leamington | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14226 | op-snap---monthly-publication-june-2025.pdf | 155 | 2025-06 | Other | Mitsubishi | Outlander | Grey | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Education | N/A | 52.5390972 | -1.9319478 | ||
| 14228 | op-snap---monthly-publication-june-2025.pdf | 157 | 2025-06 | Other | Ford | Transit | Black | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Education | N/A | 52.5390972 | -1.9319478 | ||
| 14233 | op-snap---monthly-publication-june-2025.pdf | 162 | 2025-06 | Car | Mercedes-Benz | A35 | Black | Driving without Due Care and Attention | None | Moseley Road | Moseley Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5782924 | -2.0742911 | ||
| 14236 | op-snap---monthly-publication-june-2025.pdf | 165 | 2025-06 | Car | Cupra | White | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5170745 | -1.9012542 | |||
| 14238 | op-snap---monthly-publication-june-2025.pdf | 167 | 2025-06 | Pedal Bike | Audi | Q5 | Black | Driving without Due Care and Attention | None | Salibsury Road | Salibsury Road | Birmingham | Birmingham | Education | N/A | ||||
| 14243 | op-snap---monthly-publication-june-2025.pdf | 172 | 2025-06 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Brighton Road | Brighton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4543156 | -1.8840717 | ||
| 14244 | op-snap---monthly-publication-june-2025.pdf | 173 | 2025-06 | Pedal Bike | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4943878 | -1.8504211 | ||
| 14245 | op-snap---monthly-publication-june-2025.pdf | 174 | 2025-06 | Car | Mercedes-Benz | E320 | Black | Driving without Due Care and Attention | None | M6 SB J10 | M6 Southbound J10 | Wolverhampton | Wolverhampton | Education | N/A | 52.676119 | -2.0858425 | ||
| 14250 | op-snap---monthly-publication-june-2025.pdf | 179 | 2025-06 | Car | Mercedes-Benz | CLS | Black | Driving without Due Care and Attention | None | Gibbet Hill Road | Gibbet Hill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3837797 | -1.5666584 | ||
| 14251 | op-snap---monthly-publication-june-2025.pdf | 180 | 2025-06 | Pedestrian | Seat | Leon | Grey | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 14253 | op-snap---monthly-publication-june-2025.pdf | 182 | 2025-06 | Car | Audi | A4 | Black | Driving without Due Care and Attention | None | School Road | School Road | Birmingham | Birmingham | Education | N/A | 52.4161736 | -1.8619692 | ||
| 14259 | op-snap---monthly-publication-june-2025.pdf | 188 | 2025-06 | Car | Volkswagen | Passat | Grey | Driving without Due Care and Attention | None | conagree road | Conagree Road | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | ||||
| 14261 | op-snap---monthly-publication-june-2025.pdf | 190 | 2025-06 | Pedal Bike | Honda | Civic | Black | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 14264 | op-snap---monthly-publication-june-2025.pdf | 193 | 2025-06 | Car | Toyota | Prius | Red | Driving without Due Care and Attention | None | St Michaels Rd | Street Michaels Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14271 | op-snap---monthly-publication-june-2025.pdf | 200 | 2025-06 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Station Road | Station Road | Sandwell | Sandwell | NFA | No VRM | 52.4774652 | -2.0337514 | ||
| 14274 | op-snap---monthly-publication-june-2025.pdf | 203 | 2025-06 | Car | Suzuki | GSX 1250 | Black | Driving without Due Care and Attention | No vehicle excise licence | M54 motorway, nr Jn1 | M54 motorway, nr Jn1 | Out of Force Area | Out of Force Area | Court | N/A | ||||
| 14276 | op-snap---monthly-publication-june-2025.pdf | 205 | 2025-06 | Car | Hyundai | IX20.. | White | Driving without Due Care and Attention | None | Umberslade Road | Umberslade Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4304526 | -1.9216716 | ||
| 14277 | op-snap---monthly-publication-june-2025.pdf | 206 | 2025-06 | Pedal Bike | BMW | X3 | Blue | Driving without Due Care and Attention | No Insurance | Woden Road South | Woden Road South | Sandwell | Sandwell | Court | N/A | 52.546752 | -2.0155769 | ||
| 14278 | op-snap---monthly-publication-june-2025.pdf | 207 | 2025-06 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | Warwickshire Bypass A46 | Warwickshire Bypass A46 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14279 | op-snap---monthly-publication-june-2025.pdf | 208 | 2025-06 | Car | Audi | S3 | Grey | Driving without Due Care and Attention | None | Richmond Road | Richmond Road | Solihull | Solihull | Court | N/A | 52.4430188 | -1.8022218 | ||
| 14281 | op-snap---monthly-publication-june-2025.pdf | 210 | 2025-06 | Pedal Bike | BMW | X1 | Grey | Driving without Due Care and Attention | No Insurance | Holders Lane | Holders Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4446701 | -1.9056872 | ||
| 14282 | op-snap---monthly-publication-june-2025.pdf | 211 | 2025-06 | Pedal Bike | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 14286 | op-snap---monthly-publication-june-2025.pdf | 215 | 2025-06 | Pedal Bike | Volkswagen | Sharan | Silver | Driving without Due Care and Attention | None | Old Dickens Heath Road | Old Dickens Heath Road | Solihull | Solihull | Warning Letter | N/A | 52.3864791 | -1.8355922 | ||
| 14288 | op-snap---monthly-publication-june-2025.pdf | 217 | 2025-06 | Pedal Bike | Honda | E | Black | Driving without Due Care and Attention | None | Cliff Rock Road | Cliff Rock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3937169 | -2.0011078 | ||
| 14290 | op-snap---monthly-publication-june-2025.pdf | 219 | 2025-06 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5692139 | -1.8799672 | ||
| 14296 | op-snap---monthly-publication-june-2025.pdf | 225 | 2025-06 | Car | Peugeot | 208 | Grey | Driving without Due Care and Attention | None | KINGSTON ROAD | Kingston Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4747333 | -1.8728345 |
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);