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'}
89 rows where council_area = "Out of Force Area", 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, nfa_rationale, latitude, longitude
vehicle_make 25
reporter_transport_mode 4
- Car 83
- Pedestrian 3
- Pedal Bike 2
- car 1
offence 1
- Driving without Due Care and Attention · 89 ✖
month 1
- 2025-06 · 89 ✖
council_area 1
- Out of Force Area · 89 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 15494 | op-snap---monthly-publication-june-2025.pdf | 1423 | 2025-06 | Car | Audi | S3 | White | Driving without Due Care and Attention | None | King Street Telford | King Street Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15522 | op-snap---monthly-publication-june-2025.pdf | 1451 | 2025-06 | Car | Toyota | Aygo | White | Driving without Due Care and Attention | None | B4348 Thruxton | Thruxton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15616 | op-snap---monthly-publication-june-2025.pdf | 1545 | 2025-06 | Car | Nissan | Leaf | White | Driving without Due Care and Attention | None | A423 Southam | Southam | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15646 | op-snap---monthly-publication-june-2025.pdf | 1575 | 2025-06 | Car | BMW | 520D | Gold | Driving without Due Care and Attention | None | A5 | A5 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15673 | op-snap---monthly-publication-june-2025.pdf | 1602 | 2025-06 | Car | Audi | S3 | Blue | Driving without Due Care and Attention | None | M1 SB J21 | M1 Southbound J21 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15678 | op-snap---monthly-publication-june-2025.pdf | 1607 | 2025-06 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bermuda Park | Bermuda Park | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15690 | op-snap---monthly-publication-june-2025.pdf | 1619 | 2025-06 | Car | Chysler | Limousine | Silver | Driving without Due Care and Attention | None | Leaminghton | Leaminghton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15703 | op-snap---monthly-publication-june-2025.pdf | 1632 | 2025-06 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Discovery Road, Stourport | Discovery Road, Stourport | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15718 | op-snap---monthly-publication-june-2025.pdf | 1647 | 2025-06 | Car | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Mansfield Road, Chesterfield | Mansfield Road, Chesterfield | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15729 | op-snap---monthly-publication-june-2025.pdf | 1658 | 2025-06 | Car | Renault | Trafic | White | Driving without Due Care and Attention | None | Tibberton, Worcestershire | Tibberton, Worcestershire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15735 | op-snap---monthly-publication-june-2025.pdf | 1664 | 2025-06 | Car | Audi | A5 | White | Driving without Due Care and Attention | None | M5 Jn 7. West Mercia | M5 Junction 7. West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15748 | op-snap---monthly-publication-june-2025.pdf | 1677 | 2025-06 | Car | Audi | A3 | White | Driving without Due Care and Attention | None | A44 Wyre Piddle | Wyre Piddle | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15755 | op-snap---monthly-publication-june-2025.pdf | 1684 | 2025-06 | car | BMW | 330 | Black | Driving without Due Care and Attention | No Insurance | A465 Wales | Wales | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15858 | op-snap---monthly-publication-june-2025.pdf | 1787 | 2025-06 | Car | Peugeot | 3008 | Blue | Driving without Due Care and Attention | None | Holt Heath, Ombersley | Holt Heath, Ombersley | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15893 | op-snap---monthly-publication-june-2025.pdf | 1822 | 2025-06 | Car | Audi | RS Q8 | Black | Driving without Due Care and Attention | None | Hollywood Bypass A435 | Hollywood Bypass A435 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 16237 | op-snap---monthly-publication-june-2025.pdf | 2166 | 2025-06 | Car | Mercedes-Benz | C220 | 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 |
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);