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'}
128 rows where council_area = "Out of Force Area" and month = "2025-06" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 28
offence 14
- Driving without Due Care and Attention 89
- Contravening a Red Traffic Light 10
- Driving without Reasonable Consideration 8
- Using a Mobile Phone Whilst Driving 5
- Misc - Non Traffic Offences 4
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2
- Cause vehicle to be left in a dangerous position 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- Contravene Lane Closure Red X 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Drive on hard shoulder 1
- No Seat Belt 1
- Stop a vehicle within pelican pedestrian crossing limits 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
reporter_transport_mode 6
- Car 110
- Pedestrian 9
- Pedal Bike 6
- Motorbike 1
- Other 1
- car 1
disposal 3
- NFA 126
- Court 1
- Warning Letter 1
month 1
- 2025-06 · 128 ✖
council_area 1
- Out of Force Area · 128 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14078 | op-snap---monthly-publication-june-2025.pdf | 7 | 2025-06 | Car | Renault | Van | Blue | Driving without Reasonable Consideration | None | M5 | M5 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14101 | op-snap---monthly-publication-june-2025.pdf | 30 | 2025-06 | Car | BMW | M3 | Blue | Using a Mobile Phone Whilst Driving | None | M6 somewhere | M6 somewhere | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 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 | ||
| 14123 | op-snap---monthly-publication-june-2025.pdf | 52 | 2025-06 | Pedal Bike | Citroen | C3 | Grey | Using a Mobile Phone Whilst Driving | None | Popular Road | Popular Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.454374 | -1.8774689 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||||
| 14195 | op-snap---monthly-publication-june-2025.pdf | 124 | 2025-06 | Car | Ford | transit | white | Using a Mobile Phone Whilst Driving | None | Coventry Road, Sapcote, Leicestershire | Coventry Road, Sapcote, Leicestershire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 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 | ||||
| 14237 | op-snap---monthly-publication-june-2025.pdf | 166 | 2025-06 | Car | Mini | COOPER D | White | Contravening a Red Traffic Light | None | DALEHOUSE LANE KENILWORTH | Dalehouse Lane Kenilworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14249 | op-snap---monthly-publication-june-2025.pdf | 178 | 2025-06 | Car | BMW | 1 series | White | Driving without Reasonable Consideration | None | Leamington Spa | Leamington Spa | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 14268 | op-snap---monthly-publication-june-2025.pdf | 197 | 2025-06 | Car | Kawasaki | Black | Misc - Non Traffic Offences | Fail to stop, Fail to report | Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | |||
| 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 | ||||
| 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 | ||||
| 14298 | op-snap---monthly-publication-june-2025.pdf | 227 | 2025-06 | Car | Daf | HGV | White | Driving without Reasonable Consideration | None | Newport Road | Newport Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5024739 | -1.7975977 | ||
| 14311 | op-snap---monthly-publication-june-2025.pdf | 240 | 2025-06 | Car | BMW | 5 series | Silver | Contravening a Red Traffic Light | None | Burton on Trent | Burton on Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 14314 | op-snap---monthly-publication-june-2025.pdf | 243 | 2025-06 | Car | Renault | CAPTUR | Brown | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | STOKE ON TRENT | Stoke On Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||||
| 14398 | op-snap---monthly-publication-june-2025.pdf | 327 | 2025-06 | Car | Ford | Transit | Green | Driving without Due Care and Attention | None | Goose Lane West Sussex | Goose Lane West Sussex | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14421 | op-snap---monthly-publication-june-2025.pdf | 350 | 2025-06 | Car | Ford | Focus | Red | Driving without Due Care and Attention | None | Slade Road | Slade Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5245181 | -1.8591675 | ||
| 14435 | op-snap---monthly-publication-june-2025.pdf | 364 | 2025-06 | Car | Fiat | 500 | White | Contravening a Red Traffic Light | None | Worcester Road | Worcester Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5860898 | -2.0339138 | ||
| 14459 | op-snap---monthly-publication-june-2025.pdf | 388 | 2025-06 | Pedestrian | Mitsubishi | L200 | Black | Driving without Due Care and Attention | None | Six Ashes Road | Six Ashes Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14466 | op-snap---monthly-publication-june-2025.pdf | 395 | 2025-06 | Car | Man | Blue | Driving without Due Care and Attention | None | M6 Somewhere | M6 Somewhere | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 14470 | op-snap---monthly-publication-june-2025.pdf | 399 | 2025-06 | Car | Audi | A4 | Blue | Driving without Due Care and Attention | None | Telford | Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | ||
| 14471 | op-snap---monthly-publication-june-2025.pdf | 400 | 2025-06 | Car | BMW | 3 series | Black | Driving without Due Care and Attention | None | M5 Junction 4 North | M5 Junction 4 North | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14494 | op-snap---monthly-publication-june-2025.pdf | 423 | 2025-06 | Car | Audi | A5 | White | Driving without Due Care and Attention | None | M48 | M48 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14501 | op-snap---monthly-publication-june-2025.pdf | 430 | 2025-06 | Car | BMW | 320.. | Grey | Driving without Due Care and Attention | None | A460 at Mill Lane (Staffs?) | A460 at Mill Lane (Staffs?) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14510 | op-snap---monthly-publication-june-2025.pdf | 439 | 2025-06 | Pedestrian | Iveco | Daily | White | Driving without Due Care and Attention | None | Minerva Road | Minerva Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4894131 | -1.8524068 | ||
| 14522 | op-snap---monthly-publication-june-2025.pdf | 451 | 2025-06 | Car | Volvo | V50.. | Silver | Driving without Due Care and Attention | None | Hylton Road Worcester | Hylton Road Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14532 | op-snap---monthly-publication-june-2025.pdf | 461 | 2025-06 | Car | Vauxhall | Insignia | Black | Driving without Due Care and Attention | None | A49 Leomister to Ludlow (WEst Mercia) | Leomister to Ludlow (WEst Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14678 | op-snap---monthly-publication-june-2025.pdf | 607 | 2025-06 | Car | Mitsubishi | Shogun | Black | No Seat Belt | None | Worcestershire | Worcestershire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14685 | op-snap---monthly-publication-june-2025.pdf | 614 | 2025-06 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | No Insurance | Woodrow Drive (Redditch Hospital) | Woodrow Drive (Redditch Hospital) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14712 | op-snap---monthly-publication-june-2025.pdf | 641 | 2025-06 | Car | Scania lorry | Blue | Driving without Due Care and Attention | None | M1 Northbound | M1 Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4316701 | -2.0178238 | |||
| 14713 | op-snap---monthly-publication-june-2025.pdf | 642 | 2025-06 | Car | Ford | Transit | Silver | Driving without Due Care and Attention | None | A509. | A509 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14721 | op-snap---monthly-publication-june-2025.pdf | 650 | 2025-06 | Car | Daf | Horsebox | White | Driving without Due Care and Attention | None | Banbury Road | Banbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14736 | op-snap---monthly-publication-june-2025.pdf | 665 | 2025-06 | Car | Kia | White | Contravening a Red Traffic Light | None | Telford | Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | |||
| 14742 | op-snap---monthly-publication-june-2025.pdf | 671 | 2025-06 | Car | Audi | A1 | Black | Contravening a Red Traffic Light | None | West Mercia | West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5827653 | -2.0983246 | ||
| 14743 | op-snap---monthly-publication-june-2025.pdf | 672 | 2025-06 | Car | Peugeot | 2008 | Grey | Driving without Due Care and Attention | None | A500 | A500 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14768 | op-snap---monthly-publication-june-2025.pdf | 697 | 2025-06 | Car | Skoda | Octavia | Blue | Driving without Due Care and Attention | None | Whittington Road | Whittington Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4462022 | -2.1607257 | ||
| 14784 | op-snap---monthly-publication-june-2025.pdf | 713 | 2025-06 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | M6 SB J2 | M6 Southbound J2 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14810 | op-snap---monthly-publication-june-2025.pdf | 739 | 2025-06 | Car | Mitsubishi | L200 | Black | Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway | None | M6 NB J1 | M6 Northbound J1 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14818 | op-snap---monthly-publication-june-2025.pdf | 747 | 2025-06 | Car | Vauxhall | Vivaro | Grey | Driving without Due Care and Attention | None | Worcester Road | Worcester Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5860898 | -2.0339138 | ||
| 14834 | op-snap---monthly-publication-june-2025.pdf | 763 | 2025-06 | Car | Mini | Cooper | Orange | Driving without Due Care and Attention | None | Sheffield | Sheffield | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5412142 | -1.8326716 | ||
| 14842 | op-snap---monthly-publication-june-2025.pdf | 771 | 2025-06 | Car | Seat | Blue | Driving without Reasonable Consideration | None | Oxford | Oxford | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 14849 | op-snap---monthly-publication-june-2025.pdf | 778 | 2025-06 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Watling Street | Watling Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562907 | -1.9111505 | ||
| 14858 | op-snap---monthly-publication-june-2025.pdf | 787 | 2025-06 | Car | Audi | A8 | Blue | Driving without Due Care and Attention | None | Gallow Hill | Gallow Hill | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14862 | op-snap---monthly-publication-june-2025.pdf | 791 | 2025-06 | Pedal Bike | Tesla | White | Driving without Due Care and Attention | None | Hillsborough | Hillsborough | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4764378 | -1.9522637 | |||
| 14885 | op-snap---monthly-publication-june-2025.pdf | 814 | 2025-06 | Car | UK | Driving without Due Care and Attention | None | Stockton Road | Stockton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4163443 | -1.4992768 | ||||
| 14894 | op-snap---monthly-publication-june-2025.pdf | 823 | 2025-06 | Car | BMW | 330d | Black | Contravening a Red Traffic Light | None | Much Wenlock Road | Much Wenlock Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14899 | op-snap---monthly-publication-june-2025.pdf | 828 | 2025-06 | Pedestrian | Zonte | Red | Driving without Due Care and Attention | None | Coventry Road Kenilworth | Coventry Road Kenilworth | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3954514 | -1.5222001 | |||
| 14909 | op-snap---monthly-publication-june-2025.pdf | 838 | 2025-06 | Car | Volkswagen | golf | Silver | Driving without Due Care and Attention | None | A46 Evesham Road | Evesham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14920 | op-snap---monthly-publication-june-2025.pdf | 849 | 2025-06 | Car | Hyundai | Tucson | Red | Driving without Due Care and Attention | None | Marton | Marton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4965761 | -1.872591 | ||
| 14938 | op-snap---monthly-publication-june-2025.pdf | 867 | 2025-06 | Car | Hyundai | I30 | Grey | Driving without Due Care and Attention | None | A206 Greenhithe | Greenhithe | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14953 | op-snap---monthly-publication-june-2025.pdf | 882 | 2025-06 | Pedestrian | Volkswagen | T Roc | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Snake Lane (Alvechurch) | Snake Lane (Alvechurch) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14977 | op-snap---monthly-publication-june-2025.pdf | 906 | 2025-06 | Car | Toyota | Rav4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Henley in Arden | Henley in Arden | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15047 | op-snap---monthly-publication-june-2025.pdf | 976 | 2025-06 | Car | Porsche | 918 | Blue | Driving without Due Care and Attention | None | B4393 | B4393 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3994858 | -1.4923603 | ||
| 15057 | op-snap---monthly-publication-june-2025.pdf | 986 | 2025-06 | Car | Skoda | Kodiaq | Black | Driving without Due Care and Attention | None | Clifton Lane | Clifton Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.543372 | -1.9825616 | ||
| 15069 | op-snap---monthly-publication-june-2025.pdf | 998 | 2025-06 | Car | Vauxhall | astra | Black | Driving without Due Care and Attention | None | Hartle Road | Hartle Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15076 | op-snap---monthly-publication-june-2025.pdf | 1005 | 2025-06 | Car | BMW | 1 SERIES | White | Driving without Due Care and Attention | None | WARWICKSHIRE JUMC 1 M6 | Warwickshire Jumc 1 M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15077 | op-snap---monthly-publication-june-2025.pdf | 1006 | 2025-06 | Car | Seat | Ibiza | Blue | Driving without Due Care and Attention | None | Bonehill Road | Bonehill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15098 | op-snap---monthly-publication-june-2025.pdf | 1027 | 2025-06 | Car | Volkswagen | T-Cross | Black | Driving without Due Care and Attention | None | A456 kidderminster | A456 kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4331313 | -2.1702262 | ||
| 15110 | op-snap---monthly-publication-june-2025.pdf | 1039 | 2025-06 | Car | Vauxhall | ZAFIRA | Black | Driving without Due Care and Attention | None | A442 TELFORD | A442 Telford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.5722935 | -2.1694816 | ||
| 15111 | op-snap---monthly-publication-june-2025.pdf | 1040 | 2025-06 | Car | BMW | 3 series | White | Driving without Due Care and Attention | None | A460 Cannock Staffordshire | Cannock Staffordshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15115 | op-snap---monthly-publication-june-2025.pdf | 1044 | 2025-06 | Pedal Bike | Renault | Kangoo | White | Driving without Reasonable Consideration | None | Sutton Park Road | Sutton Park Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5298146 | -1.7902196 | ||
| 15139 | op-snap---monthly-publication-june-2025.pdf | 1068 | 2025-06 | Pedal Bike | Kia | Sorento | Silver | Driving without Reasonable Consideration | None | Henley In Arden (Wottoon Wawen) | Henley In Arden (Wottoon Wawen) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15140 | op-snap---monthly-publication-june-2025.pdf | 1069 | 2025-06 | Car | BMW | 520 | Black | Driving without Due Care and Attention | None | M5 J4-3 NB | M5 J4-3 Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15146 | op-snap---monthly-publication-june-2025.pdf | 1075 | 2025-06 | Car | Hyundai | Kona | Red | Driving without Due Care and Attention | None | M42 | M42 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15157 | op-snap---monthly-publication-june-2025.pdf | 1086 | 2025-06 | Car | Honda | VFR800 | Black | Driving without Due Care and Attention | None | ALCESTER HEATH WARWICKSHIRE | Alcester Heath Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15162 | op-snap---monthly-publication-june-2025.pdf | 1091 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | M6 NB J16 | M6 Northbound J16 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15200 | op-snap---monthly-publication-june-2025.pdf | 1129 | 2025-06 | Pedal Bike | Skoda | Octavia | White | Driving without Reasonable Consideration | None | Myton Road | Myton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4106096 | -1.4829312 | ||
| 15205 | op-snap---monthly-publication-june-2025.pdf | 1134 | 2025-06 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Ross Road, Hereford | Ross Road, Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15231 | op-snap---monthly-publication-june-2025.pdf | 1160 | 2025-06 | Car | Mercedes-Benz | GLC | Blue | Driving without Due Care and Attention | None | Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 15238 | op-snap---monthly-publication-june-2025.pdf | 1167 | 2025-06 | Other | Audi | A3 | White | Using a Mobile Phone Whilst Driving | None | M69 | M69 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15279 | op-snap---monthly-publication-june-2025.pdf | 1208 | 2025-06 | Car | Nissan | Note | Silver | Driving without Due Care and Attention | None | Queens Road | Queens Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5204609 | -1.8617336 | ||
| 15280 | op-snap---monthly-publication-june-2025.pdf | 1209 | 2025-06 | Car | Seat | TARRACO | Black | Driving without Due Care and Attention | None | M5 N/B JUNCTION 27 TAUNTON | M5 Northbound JUNCTION 27 TAUNTON | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15288 | op-snap---monthly-publication-june-2025.pdf | 1217 | 2025-06 | Car | BMW | 730 | Black | Driving without Due Care and Attention | None | Pickard Way | Pickard Way | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15304 | op-snap---monthly-publication-june-2025.pdf | 1233 | 2025-06 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | M5 Southbound | M5 Southbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15332 | op-snap---monthly-publication-june-2025.pdf | 1261 | 2025-06 | Pedestrian | Ford | Fiesta | Red | Cause vehicle to be left in a dangerous position | None | no address provided | No Address Provided | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 15365 | op-snap---monthly-publication-june-2025.pdf | 1294 | 2025-06 | Car | Ford | Fiesta | Blue | Misc - Non Traffic Offences | None | Fosse Way, Warwick | Fosse Way, Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15368 | op-snap---monthly-publication-june-2025.pdf | 1297 | 2025-06 | Pedestrian | Vauxhall | Corsa | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Clifton Down, Bristol | Clifton Down, Bristol | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15405 | op-snap---monthly-publication-june-2025.pdf | 1334 | 2025-06 | Car | Audi | A4 | Grey | Driving without Due Care and Attention | None | West Mercia | West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5827653 | -2.0983246 | ||
| 15416 | op-snap---monthly-publication-june-2025.pdf | 1345 | 2025-06 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Basset Pole | Basset Pole | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15423 | op-snap---monthly-publication-june-2025.pdf | 1352 | 2025-06 | Car | Vauxhall | Blue | Driving without Due Care and Attention | None | Ortongate Shopping Centre | Ortongate Shopping Centre | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 15447 | op-snap---monthly-publication-june-2025.pdf | 1376 | 2025-06 | Car | Kia | Red | Driving without Due Care and Attention | None | Crookbarrow Road | Crookbarrow Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 15458 | op-snap---monthly-publication-june-2025.pdf | 1387 | 2025-06 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Watling Street | Watling Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562907 | -1.9111505 | ||
| 15461 | op-snap---monthly-publication-june-2025.pdf | 1390 | 2025-06 | Car | Ford | Ranger | Orange | Driving without Due Care and Attention | None | M54 Motorway | M54 Motorway | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.490826 | -1.8882034 | ||
| 15479 | op-snap---monthly-publication-june-2025.pdf | 1408 | 2025-06 | Motorbike | Volkswagen | Polo | Silver | Driving without Reasonable Consideration | None | Commandery Road, Worcester | Commandery Road, Worcester | Out of Force Area | 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);