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'}
191 rows where council_area = "Out of Force Area" and month = "2025-08" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale, latitude, longitude
vehicle_make 29
- Ford 23
- BMW 22
- Vauxhall 17
- Audi 15
- Mercedes-Benz 15
- Volkswagen 11
- Land Rover 8
- Toyota 8
- Renault 6
- Honda 5
- Skoda 4
- Volvo 4
- Citroen 3
- Fiat 3
- Hyundai 3
- Nissan 3
- Peugeot 3
- Seat 3
- Tesla 3
- Iveco 2
- Jaguar 2
- Mini 2
- Suzuki 2
- Alfa Romeo 1
- Dacia 1
- Daf 1
- Lamborghini 1
- Mitsubishi 1
- Scania 1
offence 16
- Driving without Due Care and Attention 125
- Contravening a Red Traffic Light 21
- Using a Mobile Phone Whilst Driving 16
- Driving without Reasonable Consideration 7
- Misc - Non Traffic Offences 4
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
- Cause vehicle to be left in a dangerous position 3
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Prohibited vehicle in offside lane of motorway 2
- Drive on hard shoulder 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 endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Motor vehicle fail to comply with solid white line road markings 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
reporter_transport_mode 9
- Car 147
- Pedestrian 16
- Pedal Bike 11
- Other 9
- Lorry 3
- Van 2
- Horse Rider 1
- Motorbike 1
- car 1
disposal 2
- NFA 190
- Warning Letter 1
month 1
- 2025-08 · 191 ✖
council_area 1
- Out of Force Area · 191 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||||
| 2111 | op-snap---monthly-publication-august-2025.pdf | 86 | 2025-08 | Other | Alfa Romeo | Guilia | Black | Driving without Due Care and Attention | None | Unknown, towards Hereford | Unknown, towards Hereford | Out of Force Are | Out of Force Area | NFA | No Independent Evidence Available | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 2167 | op-snap---monthly-publication-august-2025.pdf | 142 | 2025-08 | Pedal Bike | Vauxhall | combo | White | Driving without Due Care and Attention | None | A451 Great Whitley | Great Whitley | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 2199 | op-snap---monthly-publication-august-2025.pdf | 174 | 2025-08 | Lorry | Renault | Silver | Driving without Reasonable Consideration | None | Gloucester Road | Gloucester Road | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 2254 | op-snap---monthly-publication-august-2025.pdf | 229 | 2025-08 | Pedestrian | Unknown | Driving without Due Care and Attention | None | Churchfields | Churchfields | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||||
| 2257 | op-snap---monthly-publication-august-2025.pdf | 232 | 2025-08 | Pedestrian | Bus | Blue | Contravening a Red Traffic Light | None | Easemore Road | Easemore Road | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 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 | |||||
| 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 | ||||||
| 2274 | op-snap---monthly-publication-august-2025.pdf | 249 | 2025-08 | Pedestrian | Land Rover | Range | Blue | Driving without Due Care and Attention | None | Henry Street, Rugby | Henry Street, Rugby | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 2286 | op-snap---monthly-publication-august-2025.pdf | 261 | 2025-08 | Car | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | None | M42 J9 | M42 J9 | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.3601724 | -1.8062199 | ||
| 2297 | op-snap---monthly-publication-august-2025.pdf | 272 | 2025-08 | Car | Renault | White | Driving without Due Care and Attention | None | M1 | M1 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2310 | op-snap---monthly-publication-august-2025.pdf | 285 | 2025-08 | Car | Ford | Fiesta | White | Using a Mobile Phone Whilst Driving | None | M5 NB J7-6 | M5 Northbound J7-6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2311 | op-snap---monthly-publication-august-2025.pdf | 286 | 2025-08 | Pedal Bike | Bus | Blue | Driving without Reasonable Consideration | None | Church Hill Way, Redditch | Church Hill Way, Redditch | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2318 | op-snap---monthly-publication-august-2025.pdf | 293 | 2025-08 | Car | Driving without Due Care and Attention | None | Long Lane, Worksop | Long Lane, Worksop | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||||
| 2328 | op-snap---monthly-publication-august-2025.pdf | 303 | 2025-08 | Car | Vauxhall | Vivaro | Black | Driving without Due Care and Attention | None | Tamworth | Tamworth | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.5724303 | -1.8191247 | ||
| 2336 | op-snap---monthly-publication-august-2025.pdf | 311 | 2025-08 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | A453 (Tamworth) | A453 (Tamworth) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2362 | op-snap---monthly-publication-august-2025.pdf | 337 | 2025-08 | Car | Volvo | V40.. | Red | Driving without Due Care and Attention | None | A46 Stratford | Stratford | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2364 | op-snap---monthly-publication-august-2025.pdf | 339 | 2025-08 | Other | Fiat | Fiorino | White | Driving without Reasonable Consideration | None | Northwood (Shrewsbury) | Northwood (Shrewsbury) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2379 | op-snap---monthly-publication-august-2025.pdf | 354 | 2025-08 | Van | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Pershore Lane | Pershore Lane | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2381 | op-snap---monthly-publication-august-2025.pdf | 356 | 2025-08 | Car | Ford | Focus | Blue | Driving without Due Care and Attention | None | A36 Deptford | Deptford | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2395 | op-snap---monthly-publication-august-2025.pdf | 370 | 2025-08 | Pedal Bike | Vauxhall | Astra | Black | Driving without Due Care and Attention | None | Sandy Lane, Old Milverton | Sandy Lane, Old Milverton | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2403 | op-snap---monthly-publication-august-2025.pdf | 378 | 2025-08 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Offenham Road Evesham | Offenham Road Evesham | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2405 | op-snap---monthly-publication-august-2025.pdf | 380 | 2025-08 | Car | Citroen | Relay | White | Driving without Due Care and Attention | None | M42 | M42 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2414 | op-snap---monthly-publication-august-2025.pdf | 389 | 2025-08 | Lorry | Vauxhall | Astra | Blue | Driving without Due Care and Attention | None | A14 | A14 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2419 | op-snap---monthly-publication-august-2025.pdf | 394 | 2025-08 | Car | KAWASAKI | Black | Driving without Due Care and Attention | None | Worcester | Worcester | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | |||
| 2420 | op-snap---monthly-publication-august-2025.pdf | 395 | 2025-08 | Car | Land Rover | Discovery | Red | Driving without Due Care and Attention | None | Derby | Derby | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2431 | op-snap---monthly-publication-august-2025.pdf | 406 | 2025-08 | Van | Iveco | Coach | Black | Prohibited vehicle in offside lane of motorway | None | M5 Motorway, Worcester area | M5 Motorway, Worcester area | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2434 | op-snap---monthly-publication-august-2025.pdf | 409 | 2025-08 | Car | Land Rover | SDV6 | White | Driving without Due Care and Attention | None | Burnage Lane, Stockport | Burnage Lane, Stockport | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2436 | op-snap---monthly-publication-august-2025.pdf | 411 | 2025-08 | Car | Audi | A5 | White | Driving without Due Care and Attention | None | A52 Nottingham | Nottingham | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2462 | op-snap---monthly-publication-august-2025.pdf | 437 | 2025-08 | Car | BMW | 116I | Grey | Using a Mobile Phone Whilst Driving | None | M62 Mnachester | M62 Mnachester | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2475 | op-snap---monthly-publication-august-2025.pdf | 450 | 2025-08 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | M45 | M45 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2482 | op-snap---monthly-publication-august-2025.pdf | 457 | 2025-08 | Car | BMW | 335d | Blue | Driving without Due Care and Attention | None | Sheepwash Road | Sheepwash Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2496 | op-snap---monthly-publication-august-2025.pdf | 471 | 2025-08 | Car | BMW | 535D | Grey | Driving without Due Care and Attention | None | M6 | M6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2505 | op-snap---monthly-publication-august-2025.pdf | 480 | 2025-08 | Car | Sachs | Red | Contravening a Red Traffic Light | None | Gallingale View, Stoke | Gallingale View, Stoke | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2512 | op-snap---monthly-publication-august-2025.pdf | 487 | 2025-08 | Car | Hyundai | Ionic | Silver | Driving without Due Care and Attention | None | M6 (near to Keele Services) | M6 (near to Keele Services) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2519 | op-snap---monthly-publication-august-2025.pdf | 494 | 2025-08 | Car | Audi | A3.. | Blue | Using a Mobile Phone Whilst Driving | None | Somewhere on the M6. | Somewhere on the M6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2522 | op-snap---monthly-publication-august-2025.pdf | 497 | 2025-08 | Car | BMW | 520D | Silver | Using a Mobile Phone Whilst Driving | None | A444 (West Mercia) | A444 (West Mercia) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2550 | op-snap---monthly-publication-august-2025.pdf | 525 | 2025-08 | Car | Audi | A1 | Grey | Driving without Reasonable Consideration | None | Woodgreen Drive (Worcester) | Woodgreen Drive (Worcester) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2553 | op-snap---monthly-publication-august-2025.pdf | 528 | 2025-08 | Pedal Bike | Mitsubishi | Blue | Driving without Due Care and Attention | None | Stretton Sugwas | Stretton Sugwas | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2558 | op-snap---monthly-publication-august-2025.pdf | 533 | 2025-08 | Car | BMW | White | Contravening a Red Traffic Light | None | A444 | A444 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2559 | op-snap---monthly-publication-august-2025.pdf | 534 | 2025-08 | Car | Mercedes-Benz | Grey | Contravening a Red Traffic Light | None | A444 | A444 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2563 | op-snap---monthly-publication-august-2025.pdf | 538 | 2025-08 | car | Ford | White | Driving without Due Care and Attention | None | Little Stretton | Little Stretton | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2568 | op-snap---monthly-publication-august-2025.pdf | 543 | 2025-08 | Car | Vauxhall | Van | White | Driving without Due Care and Attention | None | M69, near Coventry | M69, near Coventry | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2575 | op-snap---monthly-publication-august-2025.pdf | 550 | 2025-08 | Car | BMW | 1 Series | White | Contravening a Red Traffic Light | None | A4097 | A4097 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2576 | op-snap---monthly-publication-august-2025.pdf | 551 | 2025-08 | Pedal Bike | Suzuki | Yellow | Driving without Reasonable Consideration | None | Llley Lane | Llley Lane | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2582 | op-snap---monthly-publication-august-2025.pdf | 557 | 2025-08 | Car | Fiat | 500 | Grey | Contravening a Red Traffic Light | None | Bulkington | Bulkington | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2602 | op-snap---monthly-publication-august-2025.pdf | 577 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | M1 | M1 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2608 | op-snap---monthly-publication-august-2025.pdf | 583 | 2025-08 | Car | Seat | Ateca | Black | Contravening a Red Traffic Light | None | Barrow Road | Barrow Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2611 | op-snap---monthly-publication-august-2025.pdf | 586 | 2025-08 | Pedal Bike | Vauxhall | Vivaro | Blue | Driving without Due Care and Attention | None | Lichfield Street (Saffordshire) | Lichfield Street (Saffordshire) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2618 | op-snap---monthly-publication-august-2025.pdf | 593 | 2025-08 | Car | Tesla | White | Driving without Due Care and Attention | None | A46 | A46 | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2629 | op-snap---monthly-publication-august-2025.pdf | 604 | 2025-08 | Car | BMW | 320.. | White | Driving without Due Care and Attention | None | Castle Farm Way Priorslee | Castle Farm Way Priorslee | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2635 | op-snap---monthly-publication-august-2025.pdf | 610 | 2025-08 | Car | Ford | Focus ST | White | Driving without Due Care and Attention | None | Water Orton Bridge | Water Orton Bridge | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2636 | op-snap---monthly-publication-august-2025.pdf | 611 | 2025-08 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | M54 J1-2 EB | M54 J1-2 Eb | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2640 | op-snap---monthly-publication-august-2025.pdf | 615 | 2025-08 | Motorbike | Mercedes-Benz | A180 | White | Driving without Due Care and Attention | None | Tom Hill, Tanworth in Arden | Tom Hill, Tanworth in Arden | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2644 | op-snap---monthly-publication-august-2025.pdf | 619 | 2025-08 | Car | Toyota | Rav4 | Grey | Driving without Due Care and Attention | None | Malvern | Malvern | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.4093693 | -1.7713445 | ||
| 2649 | op-snap---monthly-publication-august-2025.pdf | 624 | 2025-08 | Car | Fiat | Ducato | White | Driving without Due Care and Attention | None | A40 Monmouth | Monmouth | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2651 | op-snap---monthly-publication-august-2025.pdf | 626 | 2025-08 | Car | Mercedes-Benz | CLA200 | Grey | Driving without Due Care and Attention | None | Bilton Road (Rugby) | Bilton Road (Rugby) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2652 | op-snap---monthly-publication-august-2025.pdf | 627 | 2025-08 | Car | Ford | White | Driving without Due Care and Attention | None | Littleworth Road | Littleworth Road | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2663 | op-snap---monthly-publication-august-2025.pdf | 638 | 2025-08 | Car | Iveco | Daily | White | Driving without Due Care and Attention | None | M40.. | M40 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2665 | op-snap---monthly-publication-august-2025.pdf | 640 | 2025-08 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Hartle Lane | Hartle Lane | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2673 | op-snap---monthly-publication-august-2025.pdf | 648 | 2025-08 | Car | Audi | S4 | Blue | Driving without Due Care and Attention | None | M6 junction 3 Warwickshire | M6 junction 3 Warwickshire | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2677 | op-snap---monthly-publication-august-2025.pdf | 652 | 2025-08 | Other | Volvo | HGV | White | Using a Mobile Phone Whilst Driving | None | A19 Cleveland | Cleveland | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2682 | op-snap---monthly-publication-august-2025.pdf | 657 | 2025-08 | Car | Peugeot | White | Contravening a Red Traffic Light | None | M5 Bromsgrove | M5 Bromsgrove | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.432364 | -2.0176127 | |||
| 2689 | op-snap---monthly-publication-august-2025.pdf | 664 | 2025-08 | Lorry | Audi | TT | Blue | Driving without Due Care and Attention | None | A421 | A421 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2711 | op-snap---monthly-publication-august-2025.pdf | 686 | 2025-08 | Car | Skoda | Octivia | Black | Driving without Due Care and Attention | None | Towcester Road | Towcester Road | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2716 | op-snap---monthly-publication-august-2025.pdf | 691 | 2025-08 | Car | Drive on hard shoulder | None | M62 Widnes | M62 Widnes | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||||
| 2719 | op-snap---monthly-publication-august-2025.pdf | 694 | 2025-08 | Pedal Bike | Mercedes-Benz | Vito | Black | Driving without Due Care and Attention | None | Upper Brook St | Upper Brook Street | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2725 | op-snap---monthly-publication-august-2025.pdf | 700 | 2025-08 | Pedal Bike | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Tithe Barn Lane | Tithe Barn Lane | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2729 | op-snap---monthly-publication-august-2025.pdf | 704 | 2025-08 | Car | Hyundai | Ionic | Blue | Driving without Due Care and Attention | None | A45 Northampton | Northampton | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2744 | op-snap---monthly-publication-august-2025.pdf | 719 | 2025-08 | Car | Mercedes-Benz | A180.. | Grey | Driving without Due Care and Attention | None | M1 North towards jct 29. (Derbyshire) | M1 North towards jct 29. (Derbyshire) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2746 | op-snap---monthly-publication-august-2025.pdf | 721 | 2025-08 | Car | Ford | Ranger | White | Contravening a Red Traffic Light | None | A449 W`ton | A449 W`ton | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2748 | op-snap---monthly-publication-august-2025.pdf | 723 | 2025-08 | Car | Aprillia | Grey | Driving without Due Care and Attention | None | A423 (Warwickshire) | A423 (Warwickshire) | Out of Force Are | Out of Force Area | NFA | Out of Force | |||||
| 2751 | op-snap---monthly-publication-august-2025.pdf | 726 | 2025-08 | Car | Daf | Trucks | Red | Prohibited vehicle in offside lane of motorway | None | M5 Bridgewater | M5 Bridgewater | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2752 | op-snap---monthly-publication-august-2025.pdf | 727 | 2025-08 | Car | Vauxhall | Mokka | White | Driving without Due Care and Attention | None | A442 Telford | Telford | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | ||
| 2758 | op-snap---monthly-publication-august-2025.pdf | 733 | 2025-08 | Car | Toyota | Avensis | White | Driving without Due Care and Attention | None | A50 (Nottingham) | A50 (Nottingham) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2760 | op-snap---monthly-publication-august-2025.pdf | 735 | 2025-08 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | Stanley Matthews Way (Stoke) Staffs | Stanley Matthews Way (Stoke) Staffs | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2761 | op-snap---monthly-publication-august-2025.pdf | 736 | 2025-08 | Car | BMW | 4 Series | Green | Driving without Due Care and Attention | None | A528 | A528 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2762 | op-snap---monthly-publication-august-2025.pdf | 737 | 2025-08 | Car | BMW | N/K | Black | Driving without Due Care and Attention | None | M6 South Jct 19 | M6 South Junction 19 | Out of Force Are | Out of Force Area | NFA | Out of Force |
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);