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'}
497 rows where month = "2025-06", offence = "Driving without Due Care and Attention" 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
council_area 12
- Birmingham 238
- Out of Force Area 83
- Coventry 39
- Solihull 31
- Sandwell 27
- Wolverhampton 25
- Walsall 23
- Dudley 20
- Sutton Coldfield 6
- Metropolitan Borough 3
- Bdirmingham 1
- Halesowen 1
disposal 7
- NFA 253
- Education 88
- Warning Letter 67
- Court 54
- Fixed Penalty 23
- RTC - Actioned 11
- Other Action Taken 1
reporter_transport_mode 1
- Car · 497 ✖
offence 1
- Driving without Due Care and Attention · 497 ✖
month 1
- 2025-06 · 497 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 14297 | op-snap---monthly-publication-june-2025.pdf | 226 | 2025-06 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | KINGSTON ROAD | Kingston Road | Birmingham | Birmingham | Education | N/A | 52.4747333 | -1.8728345 | ||
| 14299 | op-snap---monthly-publication-june-2025.pdf | 228 | 2025-06 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 14300 | op-snap---monthly-publication-june-2025.pdf | 229 | 2025-06 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Oxbarn Avenue | Oxbarn Avenue | Wolverhampton | Wolverhampton | Education | N/A | 52.5726707 | -2.1604463 | ||
| 14303 | op-snap---monthly-publication-june-2025.pdf | 232 | 2025-06 | Car | Skoda | Kodiaq | Grey | Driving without Due Care and Attention | None | Summer Road | Summer Road | Birmingham | Birmingham | NFA | No Offence | 52.5221219 | -1.8440857 | ||
| 14312 | op-snap---monthly-publication-june-2025.pdf | 241 | 2025-06 | Car | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | Daventry | Daventry | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4613896 | -1.9938251 | ||
| 14315 | op-snap---monthly-publication-june-2025.pdf | 244 | 2025-06 | Car | Ford | TRANSIT | Grey | Driving without Due Care and Attention | None | SOHO ROAD | Soho Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.502568 | -1.9305447 | ||
| 14325 | op-snap---monthly-publication-june-2025.pdf | 254 | 2025-06 | Car | Honda | Civic | Blue | Driving without Due Care and Attention | None | Dingle Lane | Dingle Lane | Solihull | Solihull | Warning Letter | N/A | 52.4044204 | -1.7965379 | ||
| 14328 | op-snap---monthly-publication-june-2025.pdf | 257 | 2025-06 | Car | Renault | Captur? | Orange | Driving without Due Care and Attention | None | Lutley Lane | Lutley Lane | Dudley | Dudley | NFA | No VRM | 52.4418328 | -2.0871638 | ||
| 14335 | op-snap---monthly-publication-june-2025.pdf | 264 | 2025-06 | Car | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | Earls Way Halesowen | Earls Way Halesowen | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 14336 | op-snap---monthly-publication-june-2025.pdf | 265 | 2025-06 | Car | Mercedes-Benz | C300.. | Black | Driving without Due Care and Attention | None | Shutlock Lane | Shutlock Lane | Birmingham | Birmingham | Education | N/A | 52.4381927 | -1.9042054 | ||
| 14337 | op-snap---monthly-publication-june-2025.pdf | 266 | 2025-06 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | Highters Heath Lane, | Highters Heath Lane | Birmingham | Birmingham | Education | N/A | 52.4100972 | -1.8742772 | ||
| 14344 | op-snap---monthly-publication-june-2025.pdf | 273 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5170745 | -1.9012542 | ||
| 14345 | op-snap---monthly-publication-june-2025.pdf | 274 | 2025-06 | Car | Fiat | Punto | Blue | Driving without Due Care and Attention | None | Prologis Park | Prologis Park | Coventry | Coventry | NFA | No Offence | 52.4552589 | -1.5260803 | ||
| 14346 | op-snap---monthly-publication-june-2025.pdf | 275 | 2025-06 | Car | Honda | CHR | White | Driving without Due Care and Attention | None | 6 Ways RA | 6 Ways RA | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 14347 | op-snap---monthly-publication-june-2025.pdf | 276 | 2025-06 | Car | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | Bloomsbury Street | Bloomsbury Street | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4954065 | -1.871233 | ||
| 14348 | op-snap---monthly-publication-june-2025.pdf | 277 | 2025-06 | Car | Volkswagen | XC40. | Grey | Driving without Due Care and Attention | None | Lister Street | Lister Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4876423 | -1.8876093 | ||
| 14349 | op-snap---monthly-publication-june-2025.pdf | 278 | 2025-06 | Car | Volkswagen | Scirocco | White | Driving without Due Care and Attention | No Insurance | Burton Road, towards Sedgley | Burton Road, towards Sedgley | Dudley | Dudley | Court | N/A | ||||
| 14351 | op-snap---monthly-publication-june-2025.pdf | 280 | 2025-06 | Car | Audi | A1.. | Green | Driving without Due Care and Attention | None | Lancaster Way | Lancaster Way | Birmingham | Birmingham | NFA | No Offence | ||||
| 14356 | op-snap---monthly-publication-june-2025.pdf | 285 | 2025-06 | Car | Honda | Civic | Blue | Driving without Due Care and Attention | None | Gravelly Hill | Gravelly Hill | Birmingham | Birmingham | Education | N/A | 52.5153884 | -1.8527437 | ||
| 14357 | op-snap---monthly-publication-june-2025.pdf | 286 | 2025-06 | Car | Audi | A1 | Blue | Driving without Due Care and Attention | None | M6 Motorway to Salford Circus | M6 Motorway to Salford Circus | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14358 | op-snap---monthly-publication-june-2025.pdf | 287 | 2025-06 | Car | Peugeot | 2008.. | Grey | Driving without Due Care and Attention | None | Sutton New Road | Sutton New Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5260956 | -1.8379401 | ||
| 14361 | op-snap---monthly-publication-june-2025.pdf | 290 | 2025-06 | Car | Skoda | Octavia | Grey | Driving without Due Care and Attention | None | Ring Road Stourbridge | Ring Road Stourbridge | Dudley | Dudley | Education | N/A | 52.455785 | -2.1435102 | ||
| 14364 | op-snap---monthly-publication-june-2025.pdf | 293 | 2025-06 | Car | Volkswagen | Scirocco | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4203897 | -1.8338574 | ||
| 14367 | op-snap---monthly-publication-june-2025.pdf | 296 | 2025-06 | Car | Honda | CRV | Silver | Driving without Due Care and Attention | None | CASTLEFIELDS | Castlefields | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 14368 | op-snap---monthly-publication-june-2025.pdf | 297 | 2025-06 | Car | Porsche | Macan | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5359496 | -1.8324115 | ||
| 14371 | op-snap---monthly-publication-june-2025.pdf | 300 | 2025-06 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | Baginton | Baginton | Coventry | Coventry | NFA | Out of Force | 52.3800804 | -1.4748304 | |||
| 14379 | op-snap---monthly-publication-june-2025.pdf | 308 | 2025-06 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | MONTAGUE STREET | Montague Street | Birmingham | Birmingham | Education | N/A | 52.4816806 | -1.8788939 | ||
| 14380 | op-snap---monthly-publication-june-2025.pdf | 309 | 2025-06 | Car | Seat | IBIZA | Grey | Driving without Due Care and Attention | None | MONTAGUE STREET | Montague Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4816806 | -1.8788939 | ||
| 14381 | op-snap---monthly-publication-june-2025.pdf | 310 | 2025-06 | Car | Porsche | Grey | Driving without Due Care and Attention | None | Highfield Road towards Hagley Road | Highfield Road towards Hagley Road | Birmingham | Birmingham | NFA | No Offence | |||||
| 14385 | op-snap---monthly-publication-june-2025.pdf | 314 | 2025-06 | Car | BMW | 330 | Grey | Driving without Due Care and Attention | None | Montague St | Montague Street | Birmingham | Birmingham | Education | N/A | 52.4816806 | -1.8788939 | ||
| 14386 | op-snap---monthly-publication-june-2025.pdf | 315 | 2025-06 | Car | Audi | S3 | Blue | Driving without Due Care and Attention | None | Out of force - Oxford | Out of force - Oxford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14387 | op-snap---monthly-publication-june-2025.pdf | 316 | 2025-06 | Car | Renault | Master | White | 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 | ||||
| 14388 | op-snap---monthly-publication-june-2025.pdf | 317 | 2025-06 | Car | Audi | S3 | Blue | Driving without Due Care and Attention | None | Bordesley Green East at Richmond Roa | Bordesley Green East at Richmond Roa | Bdirmingham | Bdirmingham | NFA | Misc Inc Crimes | 52.480482 | -1.8298289 | ||
| 14389 | op-snap---monthly-publication-june-2025.pdf | 318 | 2025-06 | Car | BMW | 118i | White | Driving without Due Care and Attention | None | McKean Road | Mc Kean Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5077405 | -2.0124813 | ||
| 14390 | op-snap---monthly-publication-june-2025.pdf | 319 | 2025-06 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Green Lanes | Green Lanes | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5375034 | -1.8313115 | ||
| 14391 | op-snap---monthly-publication-june-2025.pdf | 320 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Dartmouth Road | Dartmouth Road | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | 52.5035988 | -1.972107 | ||
| 14392 | op-snap---monthly-publication-june-2025.pdf | 321 | 2025-06 | Car | Renault | Traffic | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | Warning Letter | N/A | 52.5692139 | -1.8799672 |
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);