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'}
158 rows where council_area = "Out of Force Area", disposal = "NFA" and month = "2025-07" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence 16
- Driving without Due Care and Attention 95
- Driving without Reasonable Consideration 16
- Misc - Non Traffic Offences 11
- Using a Mobile Phone Whilst Driving 11
- Contravening a Red Traffic Light 7
- Drive on hard shoulder 6
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 2
- Dangerous Driving 2
- Contravene Lane Closure Red X 1
- Driver not in position to have Proper Control 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
- Prohibited vehicle in offside lane of motorway 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1
reporter_transport_mode 7
- Car 125
- Pedestrian 15
- Pedal Bike 8
- Other 7
- Horse Rider 1
- Lorry 1
- Motorbike 1
month 1
- 2025-07 · 158 ✖
disposal 1
- NFA · 158 ✖
council_area 1
- Out of Force Area · 158 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11950 | op-snap---monthly-publication-july-2025.pdf | 2 | 2025-07 | Car | Tesla | White | Contravening a Red Traffic Light | None | Ventura Park Road | Ventura Park Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 11971 | op-snap---monthly-publication-july-2025.pdf | 23 | 2025-07 | Car | Skoda | Enyaq | Blue | Driving without Due Care and Attention | None | A44 Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | ||
| 11978 | op-snap---monthly-publication-july-2025.pdf | 30 | 2025-07 | Car | Vauxhall | Corsa | Red | Driving without Due Care and Attention | None | Queensbury, Bradford | Queensbury, Bradford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11979 | op-snap---monthly-publication-july-2025.pdf | 31 | 2025-07 | Car | Porsche | Cayman | Silver | Driving without Due Care and Attention | None | Stratford Road, Wellesbourne | Stratford Road, Wellesbourne | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11984 | op-snap---monthly-publication-july-2025.pdf | 36 | 2025-07 | Car | Mercedes-Benz | Sprinter | Blue | Driving without Due Care and Attention | None | Off force - west mercia | Off force - west mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11990 | op-snap---monthly-publication-july-2025.pdf | 42 | 2025-07 | Car | Ford | Mondeo | Blue | Driving without Due Care and Attention | None | A5189 Burton upon Trent | Burton upon Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12000 | op-snap---monthly-publication-july-2025.pdf | 52 | 2025-07 | Car | Audi | A6 | Silver | Driving without Due Care and Attention | None | Bilford Road | Bilford Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12001 | op-snap---monthly-publication-july-2025.pdf | 53 | 2025-07 | Other | Daf | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wem High St, Shrewsbury | Wem High Street, Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 12023 | op-snap---monthly-publication-july-2025.pdf | 75 | 2025-07 | Car | Audi | Q3 | Blue | Driving without Due Care and Attention | None | M43 WB J3 | M43 Wb J3 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 12025 | op-snap---monthly-publication-july-2025.pdf | 77 | 2025-07 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Beehive Hill | Beehive Hill | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5518914 | -2.0227634 | ||
| 12062 | op-snap---monthly-publication-july-2025.pdf | 114 | 2025-07 | Car | Byd | Seal | Blue | Driving without Reasonable Consideration | None | Kenilworth Road | Kenilworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5124557 | -1.8917609 | ||
| 12065 | op-snap---monthly-publication-july-2025.pdf | 117 | 2025-07 | Car | BMW | 330E | Grey | Driving without Reasonable Consideration | None | M42 Junction 3 West Mercia | M42 Junction 3 West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 12069 | op-snap---monthly-publication-july-2025.pdf | 121 | 2025-07 | Car | Mini | Countryman | White | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5856221 | -1.790692 | ||
| 12074 | op-snap---monthly-publication-july-2025.pdf | 126 | 2025-07 | Car | Volvo | XC90 | Black | Driving without Due Care and Attention | None | M6 Warwickshire | M6 Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4572944 | -1.4815973 | ||
| 12079 | op-snap---monthly-publication-july-2025.pdf | 131 | 2025-07 | Car | BMW | Black | Driving without Due Care and Attention | None | Church Lane | Church Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5133161 | -1.9278283 | |||
| 12110 | op-snap---monthly-publication-july-2025.pdf | 162 | 2025-07 | Car | Audi | Q7.. | Grey | Driving without Due Care and Attention | None | Slip road London | Slip road London | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12119 | op-snap---monthly-publication-july-2025.pdf | 171 | 2025-07 | Other | Audi | A6.. | White | Misc - Non Traffic Offences | None | Not known. | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | |||||
| 12127 | op-snap---monthly-publication-july-2025.pdf | 179 | 2025-07 | Car | Volkswagen | Golf | White | Driving without Due Care and Attention | None | Bitterscote Drive | Bitterscote Drive | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12131 | op-snap---monthly-publication-july-2025.pdf | 183 | 2025-07 | Car | Nissan | Qashqai | White | Driver not in position to have Proper Control | None | M54 J1, M 10A | M54 J1, M 10A | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12135 | op-snap---monthly-publication-july-2025.pdf | 187 | 2025-07 | Pedestrian | Scania | Lorry | White | Misc - Non Traffic Offences | None | Stockton Road | Stockton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4163443 | -1.4992768 | ||
| 12139 | op-snap---monthly-publication-july-2025.pdf | 191 | 2025-07 | Car | Vauxhall | Movano | White | Driving without Due Care and Attention | None | B4115 near Rocky Lane | B4115 near Rocky Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12140 | op-snap---monthly-publication-july-2025.pdf | 192 | 2025-07 | Car | Volvo | Blue | Motor vehicle fail to comply with solid white line road markings | None | M42/M40 | M42/M40 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3628734 | -1.8040442 | |||
| 12142 | op-snap---monthly-publication-july-2025.pdf | 194 | 2025-07 | Car | Tesla | model 3 | white | Driving without Due Care and Attention | None | A41, Newport, West Mercia | A41, Newport, West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12157 | op-snap---monthly-publication-july-2025.pdf | 209 | 2025-07 | Car | Mercedes-Benz | E220 | Black | Driving without Due Care and Attention | None | Ediburgh | Ediburgh | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12171 | op-snap---monthly-publication-july-2025.pdf | 223 | 2025-07 | Car | Seat | Ibiza | Green | Driving without Due Care and Attention | None | Pershore Road | Pershore Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4653873 | -1.8988344 | ||
| 12195 | op-snap---monthly-publication-july-2025.pdf | 247 | 2025-07 | Pedal Bike | Mini | cooper | Blue | Driving without Due Care and Attention | None | Bewdley | Bewdley | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4330724 | -1.9181313 | ||
| 12214 | op-snap---monthly-publication-july-2025.pdf | 266 | 2025-07 | Pedestrian | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Bernard Road | Bernard Road | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | 52.4777838 | -1.9587163 | ||
| 12229 | op-snap---monthly-publication-july-2025.pdf | 281 | 2025-07 | Car | Kymco | Red | Driving without Due Care and Attention | None | Cheadle - Off force | Cheadle - Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 12231 | op-snap---monthly-publication-july-2025.pdf | 283 | 2025-07 | Car | Mercedes-Benz | A class | White | Driving without Due Care and Attention | None | Ledbury, West Mercia | Ledbury, West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12238 | op-snap---monthly-publication-july-2025.pdf | 290 | 2025-07 | Car | Mini | Cooper | Grey | Driving without Due Care and Attention | None | Walwyn Road | Walwyn Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12240 | op-snap---monthly-publication-july-2025.pdf | 292 | 2025-07 | Car | Renault | Clio | Grey | Driving without Due Care and Attention | None | Astwood Road | Astwood Road | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 12253 | op-snap---monthly-publication-july-2025.pdf | 305 | 2025-07 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Droitwich | Droitwich | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12274 | op-snap---monthly-publication-july-2025.pdf | 326 | 2025-07 | Car | Infiniti | Grey | Driving without Due Care and Attention | None | Barlborough Interchange | Barlborough Interchange | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 12292 | op-snap---monthly-publication-july-2025.pdf | 344 | 2025-07 | Car | Peugeot | Boxer van | White | Driving without Due Care and Attention | None | Smite lane, Worcester | Smite lane, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12297 | op-snap---monthly-publication-july-2025.pdf | 349 | 2025-07 | Car | Nissan | Micra | Red | Driving without Due Care and Attention | None | Tesco, Blackpool | Tesco, Blackpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12298 | op-snap---monthly-publication-july-2025.pdf | 350 | 2025-07 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Fleetwood FY7 7JL | Fleetwood FY7 7JL | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4743461 | -1.7895289 | ||
| 12299 | op-snap---monthly-publication-july-2025.pdf | 351 | 2025-07 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Jubilee Tower, Lancaster | Jubilee Tower, Lancaster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12309 | op-snap---monthly-publication-july-2025.pdf | 361 | 2025-07 | Lorry | Iveco | Daily | Yellow | Driving without Due Care and Attention | None | M6 Toll | M6 Toll | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5804962 | -1.7833098 | ||
| 12311 | op-snap---monthly-publication-july-2025.pdf | 363 | 2025-07 | Other | Audi | A6 | White | Using a Mobile Phone Whilst Driving | None | Manchester Road, Swindon | Manchester Road, Swindon | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12314 | op-snap---monthly-publication-july-2025.pdf | 366 | 2025-07 | Car | Renault | Master van | Green | Using a Mobile Phone Whilst Driving | No vehicle excise licence | M6, near Knutsford | M6, near Knutsford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12403 | op-snap---monthly-publication-july-2025.pdf | 455 | 2025-07 | Car | Mercedes-Benz | CLK-250 | Grey | Driving without Due Care and Attention | None | B4504 Redditch | Redditch | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4072158 | -1.9277937 | ||
| 12420 | op-snap---monthly-publication-july-2025.pdf | 472 | 2025-07 | Pedal Bike | Land Rover | Discovery | Silver | Driving without Due Care and Attention | None | Bridgenorth Road | Bridgenorth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12423 | op-snap---monthly-publication-july-2025.pdf | 475 | 2025-07 | Pedal Bike | Ford | fiesta | Silver | Dangerous Driving | None | Worcester, West Mercia Force area | Worcester, West Mercia Force area | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12444 | op-snap---monthly-publication-july-2025.pdf | 496 | 2025-07 | Pedestrian | Ford | Focus | Orange | Driving without Due Care and Attention | None | Off Force | Off Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12451 | op-snap---monthly-publication-july-2025.pdf | 503 | 2025-07 | Car | BMW | White | Driving without Due Care and Attention | None | M40 Motorway | M40 Motorway | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.490826 | -1.8882034 | |||
| 12452 | op-snap---monthly-publication-july-2025.pdf | 504 | 2025-07 | Pedestrian | BMW | M2 | White | Driving without Due Care and Attention | None | Tesco Blackpool | Tesco Blackpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12467 | op-snap---monthly-publication-july-2025.pdf | 519 | 2025-07 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | Tamworth | Tamworth | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5724303 | -1.8191247 | ||
| 12470 | op-snap---monthly-publication-july-2025.pdf | 522 | 2025-07 | Other | Driving without Due Care and Attention | None | Cowslip Road | Cowslip Road | Out of Force Area | Out of Force Area | NFA | No VRM | |||||||
| 12471 | op-snap---monthly-publication-july-2025.pdf | 523 | 2025-07 | Horse Rider | Ford | Fiesta | White | Driving without Due Care and Attention | None | Haselour Lane | Haselour Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12474 | op-snap---monthly-publication-july-2025.pdf | 526 | 2025-07 | Other | Audi | A6 | White | Using a Mobile Phone Whilst Driving | None | Swindon | Swindon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.480676 | -1.9595336 | ||
| 12476 | op-snap---monthly-publication-july-2025.pdf | 528 | 2025-07 | Pedestrian | Audi | SQ5 | Black | Using a Mobile Phone Whilst Driving | None | A458 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 12485 | op-snap---monthly-publication-july-2025.pdf | 537 | 2025-07 | Pedal Bike | Vauxhall | Zafira | Silver | Driving without Due Care and Attention | None | Thruxton, Herefordshire | Thruxton, Herefordshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12489 | op-snap---monthly-publication-july-2025.pdf | 541 | 2025-07 | Car | Audi | A3 | Black | Contravening a Red Traffic Light | None | Kidderminster road | Kidderminster road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4331313 | -2.1702262 | ||
| 12493 | op-snap---monthly-publication-july-2025.pdf | 545 | 2025-07 | Car | Driving without Due Care and Attention | None | High Lane | High Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4908428 | -1.9653065 | |||||
| 12495 | op-snap---monthly-publication-july-2025.pdf | 547 | 2025-07 | Car | Jaguar | Black | Driving without Due Care and Attention | None | Four Ashes Road | Four Ashes Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3828826 | -1.7624844 | |||
| 12499 | op-snap---monthly-publication-july-2025.pdf | 551 | 2025-07 | Car | Ford | Focus | Blue | Driving without Due Care and Attention | None | Nuneaton | Nuneaton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4014214 | -1.5189806 | ||
| 12509 | op-snap---monthly-publication-july-2025.pdf | 561 | 2025-07 | Car | Skoda | Enyaq | Blue | Driving without Due Care and Attention | None | M6 NB Liverpool | M6 Northbound Liverpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12510 | op-snap---monthly-publication-july-2025.pdf | 562 | 2025-07 | Car | Land Rover | Range | Black | Driving without Due Care and Attention | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12512 | op-snap---monthly-publication-july-2025.pdf | 564 | 2025-07 | Other | Hyundai | Matrix | Black | Dangerous Driving | None | B62 0LR Rubery | B62 0LR Rubery | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12530 | op-snap---monthly-publication-july-2025.pdf | 582 | 2025-07 | Car | Audi | TT | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Eardley Road, Streatham | Eardley Road, Streatham | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12535 | op-snap---monthly-publication-july-2025.pdf | 587 | 2025-07 | Car | Mercedes-Benz | C class | Black | Driving without Due Care and Attention | None | M6 nr Jn2 | M6 nr Jn2 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12536 | op-snap---monthly-publication-july-2025.pdf | 588 | 2025-07 | Car | Man | Lorry | White | Contravening a Red Traffic Light | None | Tern Hill | Tern Hill | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12565 | op-snap---monthly-publication-july-2025.pdf | 617 | 2025-07 | Car | Mercedes-Benz | Lorry | White | Driving without Due Care and Attention | None | A5 Watling Street | Watling Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562907 | -1.9111505 | ||
| 12567 | op-snap---monthly-publication-july-2025.pdf | 619 | 2025-07 | Pedal Bike | Honda | Jazz | Green | Driving without Reasonable Consideration | None | Saltway | Saltway | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12577 | op-snap---monthly-publication-july-2025.pdf | 629 | 2025-07 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | A441, Birmingham Road | A441, Birmingham Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5358009 | -1.8271588 | ||
| 12602 | op-snap---monthly-publication-july-2025.pdf | 654 | 2025-07 | Car | Nissan | Juke | Grey | Driving without Due Care and Attention | None | A49 Ludlow | Ludlow | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12609 | op-snap---monthly-publication-july-2025.pdf | 661 | 2025-07 | Car | Ford | Focus | Blue | Using a Mobile Phone Whilst Driving | None | A5271 (Staffs) | A5271 (Staffs) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12631 | op-snap---monthly-publication-july-2025.pdf | 683 | 2025-07 | Car | BMW | X5.. | Black | Driving without Due Care and Attention | None | A523 | A523 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12632 | op-snap---monthly-publication-july-2025.pdf | 684 | 2025-07 | Motorbike | Land Rover | Defender | Grey | Driving without Due Care and Attention | None | New Road Norton Lindsey | New Road Norton Lindsey | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12633 | op-snap---monthly-publication-july-2025.pdf | 685 | 2025-07 | Car | Ford | Galaxy | Black | Driving without Due Care and Attention | None | A38 Droitwich | Droitwich | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12657 | op-snap---monthly-publication-july-2025.pdf | 709 | 2025-07 | Car | Vauxhall | Astra | Silver | Driving without Due Care and Attention | None | M4 Eastbound J11 | M4 Eastbound J11 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12674 | op-snap---monthly-publication-july-2025.pdf | 726 | 2025-07 | Car | Volkswagen | Caddy | White | Driving without Due Care and Attention | None | A5 Wall Island | Wall Island | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12677 | op-snap---monthly-publication-july-2025.pdf | 729 | 2025-07 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | M62 | M62 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12680 | op-snap---monthly-publication-july-2025.pdf | 732 | 2025-07 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | A5 (Staffs) | A5 (Staffs) | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562775 | -1.9262309 | ||
| 12682 | op-snap---monthly-publication-july-2025.pdf | 734 | 2025-07 | Car | BMW | 330 | Black | Misc - Non Traffic Offences | None | A4110 Wigmore | Wigmore | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12683 | op-snap---monthly-publication-july-2025.pdf | 735 | 2025-07 | Car | Omoda | 5 NOBLE | Black | Driving without Due Care and Attention | None | Lincolnshire | Lincolnshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12688 | op-snap---monthly-publication-july-2025.pdf | 740 | 2025-07 | Car | BMW | 118 | Black | Driving without Reasonable Consideration | None | A514 Bedford | Bedford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12689 | op-snap---monthly-publication-july-2025.pdf | 741 | 2025-07 | Pedestrian | Jaguar | F Pace | Grey | Driving without Due Care and Attention | None | B4034 Stratford | Stratford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12697 | op-snap---monthly-publication-july-2025.pdf | 749 | 2025-07 | Pedal Bike | Ford | Focus | Silver | Driving without Due Care and Attention | None | Valley Road, Earlswood | Valley Road, Earlswood | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12704 | op-snap---monthly-publication-july-2025.pdf | 756 | 2025-07 | Car | Ford | S-Max | Black | Misc - Non Traffic Offences | None | Edinburgh Road, Nuneaton | Edinburgh Road, Nuneaton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12711 | op-snap---monthly-publication-july-2025.pdf | 763 | 2025-07 | Car | Mercedes-Benz | Blue | Driving without Due Care and Attention | None | Derby Road, Off Force | Derby Road, Off Force | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 12716 | op-snap---monthly-publication-july-2025.pdf | 768 | 2025-07 | Car | Ford | Ranger | Grey | Driving without Due Care and Attention | None | M74 | M74 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12717 | op-snap---monthly-publication-july-2025.pdf | 769 | 2025-07 | Car | Mercedes-Benz | Vito | Grey | Driving without Due Care and Attention | Driving without Due Care and | AMt5te4n (tOiount of Force) | AMt5te4n (t Oiount of Force) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12721 | op-snap---monthly-publication-july-2025.pdf | 773 | 2025-07 | Car | Audi | A5... | Grey | Driving without Due Care and Attention | None | A53 | A53 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12741 | op-snap---monthly-publication-july-2025.pdf | 793 | 2025-07 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | A483 (Welshpool) | A483 (Welshpool) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12748 | op-snap---monthly-publication-july-2025.pdf | 800 | 2025-07 | Car | Audi | S1 | Blue | Driving without Due Care and Attention | None | Moor Road (West Yorkshire) | Moor Road (West Yorkshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12752 | op-snap---monthly-publication-july-2025.pdf | 804 | 2025-07 | Car | Ford | Focus | Grey | Driving without Reasonable Consideration | None | Coventry Street, Kidderminster | Coventry Street, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12758 | op-snap---monthly-publication-july-2025.pdf | 810 | 2025-07 | Pedal Bike | Mini | Mini | Black | Using a Mobile Phone Whilst Driving | None | Belbroughton Road | Belbroughton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4413333 | -2.0647198 | ||
| 12794 | op-snap---monthly-publication-july-2025.pdf | 846 | 2025-07 | Pedestrian | Volkswagen | polo | Black | 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 | ||
| 12795 | op-snap---monthly-publication-july-2025.pdf | 847 | 2025-07 | Car | Hyundai | Kona | Grey | Driving without Due Care and Attention | None | M5 South (Frankley Services) | M5 South (Frankley Services) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12796 | op-snap---monthly-publication-july-2025.pdf | 848 | 2025-07 | Car | Nissan | Juke | Red | Contravening a Red Traffic Light | None | A38 Lichfield | Lichfield | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6708614 | -1.8442078 | ||
| 12809 | op-snap---monthly-publication-july-2025.pdf | 861 | 2025-07 | Car | Mercedes-Benz | A200.. | Black | Driving without Due Care and Attention | None | M62 | M62 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12815 | op-snap---monthly-publication-july-2025.pdf | 867 | 2025-07 | Pedestrian | Mercedes-Benz | S350 | Silver | Driving without Due Care and Attention | None | A3400 (Stratford Up on Avon) Warks | A3400 (Stratford Up on Avon) Warks | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12825 | op-snap---monthly-publication-july-2025.pdf | 877 | 2025-07 | Car | Vauxhall | Mokka | White | Driving without Due Care and Attention | None | Woodhouse Lane | Woodhouse Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12831 | op-snap---monthly-publication-july-2025.pdf | 883 | 2025-07 | Car | BMW | M140I | Grey | Driving without Due Care and Attention | None | A38 | A38 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12874 | op-snap---monthly-publication-july-2025.pdf | 926 | 2025-07 | Car | Vauxhall | Movano | Yellow | Driving without Due Care and Attention | No Insurance | M54 nr Telford | M54 nr Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12875 | op-snap---monthly-publication-july-2025.pdf | 927 | 2025-07 | Car | Volkswagen | Polo | Grey | Contravening a Red Traffic Light | None | Alexandra Hospital A441, Redditch | Alexandra Hospital A441, Redditch | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 12887 | op-snap---monthly-publication-july-2025.pdf | 939 | 2025-07 | Car | Audi | A5 | Red | Driving without Reasonable Consideration | None | M40 Southbound | M40 Southbound | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 12888 | op-snap---monthly-publication-july-2025.pdf | 940 | 2025-07 | Car | Scania | White | Driving without Reasonable Consideration | None | M6 Northbound | M6 Northbound | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4316701 | -2.0178238 | |||
| 12898 | op-snap---monthly-publication-july-2025.pdf | 950 | 2025-07 | Car | Mercedes-Benz | sprinter | Orange | Driving without Reasonable Consideration | None | Caynton Road | Caynton Road | 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);