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'}
86 rows where council_area = "Out of Force Area", disposal = "NFA" and month = "2025-05" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale, latitude, longitude
vehicle_make 24
offence 12
- Driving without Due Care and Attention 44
- Using a Mobile Phone Whilst Driving 12
- Driving without Reasonable Consideration 9
- Contravening a Red Traffic Light 5
- Misc - Non Traffic Offences 5
- Motor vehicle fail to comply with solid white line road markings 5
- Drive a vehicle other than on the carriageway of a motorway 1
- Drive on hard shoulder 1
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
- No Seat Belt 1
- Stop a vehicle on pedestrian crossing 1
- VRM fails to conform to Regulations 1
reporter_transport_mode 6
- Car 68
- Pedal Bike 12
- Pedestrian 3
- Lorry 1
- Motorbike 1
- Other 1
month 1
- 2025-05 · 86 ✖
disposal 1
- NFA · 86 ✖
council_area 1
- Out of Force Area · 86 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18680 | op-snap---monthly-publication-may-2025.pdf | 42 | 2025-05 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 18701 | op-snap---monthly-publication-may-2025.pdf | 63 | 2025-05 | Car | Volkswagen | Tiguan | Blue | Driving without Due Care and Attention | None | A449 Worcestershire | Worcestershire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18712 | op-snap---monthly-publication-may-2025.pdf | 74 | 2025-05 | Car | Ford | Transit | Black | Driving without Due Care and Attention | None | Lillington Avenue | Lillington Avenue | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18742 | op-snap---monthly-publication-may-2025.pdf | 104 | 2025-05 | Car | Tesla | Model 3 | Grey | Driving without Due Care and Attention | None | M42 EB J2 | M42 Eb J2 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4945433 | -2.0190848 | ||
| 18750 | op-snap---monthly-publication-may-2025.pdf | 112 | 2025-05 | Car | Mercedes-Benz | C220 | Black | Stop a vehicle on pedestrian crossing | None | Charford Road Bromsgrove | Charford Road Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18751 | op-snap---monthly-publication-may-2025.pdf | 113 | 2025-05 | Car | Suzuki | White | Driving without Due Care and Attention | None | Kettering | Kettering | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 18849 | op-snap---monthly-publication-may-2025.pdf | 211 | 2025-05 | Pedal Bike | Scancia | Red | Driving without Reasonable Consideration | None | Ventura Park | Ventura Park | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 18870 | op-snap---monthly-publication-may-2025.pdf | 232 | 2025-05 | Car | Skoda | Octivia | Grey | Using a Mobile Phone Whilst Driving | None | A5 Shrewbury | Shrewbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18871 | op-snap---monthly-publication-may-2025.pdf | 233 | 2025-05 | Car | Volvo | C40 | Black | Driving without Due Care and Attention | None | M42 Jn3 | M42 Jn3 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18903 | op-snap---monthly-publication-may-2025.pdf | 265 | 2025-05 | Car | Suzuki | Vitara | Grey | Contravening a Red Traffic Light | None | A5/A49 Meolbrace (Shrewsbury) | A5/A49 Meolbrace (Shrewsbury) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18916 | op-snap---monthly-publication-may-2025.pdf | 278 | 2025-05 | Car | Mercedes-Benz | C200 | Black | Driving without Due Care and Attention | None | Worksop | Worksop | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18943 | op-snap---monthly-publication-may-2025.pdf | 305 | 2025-05 | Car | Suzuki | XR 125 | Silver | Driving without Reasonable Consideration | None | A444 off M6 Jn3 | A444 off M6 Jn3 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18965 | op-snap---monthly-publication-may-2025.pdf | 327 | 2025-05 | Car | Audi | A4 | Grey | Driving without Due Care and Attention | None | A449 | A449 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18966 | op-snap---monthly-publication-may-2025.pdf | 328 | 2025-05 | Car | Nissan | Primera | Silver | Driving without Due Care and Attention | None | M1 | M1 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 18971 | op-snap---monthly-publication-may-2025.pdf | 333 | 2025-05 | Car | Mercedes-Benz | 220D | Silver | Drive a vehicle other than on the carriageway of a motorway | None | Junction 1 M5 | Junction 1 M5 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5011082 | -2.0100407 | ||
| 18988 | op-snap---monthly-publication-may-2025.pdf | 350 | 2025-05 | Pedestrian | Seat | Leon | Silver | Driving without Due Care and Attention | None | Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | ||
| 18999 | op-snap---monthly-publication-may-2025.pdf | 361 | 2025-05 | Car | Mercedes-Benz | A200 | Grey | Driving without Due Care and Attention | None | B4393 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 19005 | op-snap---monthly-publication-may-2025.pdf | 367 | 2025-05 | Car | Fiat | Doblo | White | Contravening a Red Traffic Light | None | Enville Road | Enville Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5620597 | -2.174396 | ||
| 19021 | op-snap---monthly-publication-may-2025.pdf | 383 | 2025-05 | Car | Mg | ZS | Red | Misc - Non Traffic Offences | None | Alder Road Shifnal | Alder Road Shifnal | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19037 | op-snap---monthly-publication-may-2025.pdf | 399 | 2025-05 | Pedal Bike | Ford | Transit | White | Driving without Due Care and Attention | None | Malvern area | Malvern area | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19038 | op-snap---monthly-publication-may-2025.pdf | 400 | 2025-05 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Malvern area | Malvern area | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19054 | op-snap---monthly-publication-may-2025.pdf | 416 | 2025-05 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | No Insurance | Hinksford Lane Swindon | Hinksford Lane Swindon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5079592 | -2.1966932 | ||
| 19061 | op-snap---monthly-publication-may-2025.pdf | 423 | 2025-05 | Car | Mercedes-Benz | BENZ | White | Using a Mobile Phone Whilst Driving | Driving without Due C | aAre5 aOnUdT A OtteFn FtiOonRCE | a Are5 a On Ud T A Otte Fn Fti Oon RCE | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19062 | op-snap---monthly-publication-may-2025.pdf | 424 | 2025-05 | Car | Mercedes-Benz | E220 | White | Driving without Due Care and Attention | None | A5 (Out of Force) | A5 (Out of Force) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19112 | op-snap---monthly-publication-may-2025.pdf | 474 | 2025-05 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Shawbirch Roundabout | Shawbirch Roundabout | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19114 | op-snap---monthly-publication-may-2025.pdf | 476 | 2025-05 | Car | Ford | Tourneo | Grey | Using a Mobile Phone Whilst Driving | None | Castle Lane | Castle Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4398581 | -1.7869538 | ||
| 19120 | op-snap---monthly-publication-may-2025.pdf | 482 | 2025-05 | Car | Honda | CBR 500 | Black | Driving without Due Care and Attention | None | A46 | A46 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19160 | op-snap---monthly-publication-may-2025.pdf | 522 | 2025-05 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Weeford Interchange, Staffordshire | Weeford Interchange, Staffordshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19176 | op-snap---monthly-publication-may-2025.pdf | 538 | 2025-05 | Car | Alfa Romeo | . | Red | Driving without Reasonable Consideration | None | Bognop road | Bognop road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19229 | op-snap---monthly-publication-may-2025.pdf | 591 | 2025-05 | Car | Honda | CRV | Red | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 19243 | op-snap---monthly-publication-may-2025.pdf | 605 | 2025-05 | Lorry | Mercedes-Benz | Aston Martin | Green | Using a Mobile Phone Whilst Driving | No Insurance | M40 to M42 junction | M40 to M42 junction | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19252 | op-snap---monthly-publication-may-2025.pdf | 614 | 2025-05 | Car | Audi | A5 | Blue | Driving without Due Care and Attention | None | Birmingham Road Lichfield | Birmingham Road Lichfield | Out of Force Area | Out of Force Area | NFA | no offence | 52.5675481 | -1.8213094 | ||
| 19277 | op-snap---monthly-publication-may-2025.pdf | 639 | 2025-05 | Car | Ford | Mustang | Yellow | Driving without Due Care and Attention | None | Bromsgrove | Bromsgrove | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4728322 | -1.897536 | ||
| 19284 | op-snap---monthly-publication-may-2025.pdf | 646 | 2025-05 | Pedestrian | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Shottery Road, Stratford Upon Avon | Shottery Road, Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19296 | op-snap---monthly-publication-may-2025.pdf | 658 | 2025-05 | Car | Porsche | Cayman | Grey | Driving without Due Care and Attention | None | M1 Lutterworth | M1 Lutterworth | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4173372 | -1.4677589 | ||
| 19316 | op-snap---monthly-publication-may-2025.pdf | 678 | 2025-05 | Car | Audi | A5 | Grey | Driving without Due Care and Attention | None | Station Road, Stafford | Station Road, Stafford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5033053 | -1.9308616 | ||
| 19351 | op-snap---monthly-publication-may-2025.pdf | 713 | 2025-05 | Other | Bus | Green | Driving without Due Care and Attention | None | UK | Uk | Out of Force Area | Out of Force Area | NFA | No VRM | 52.5019896 | -2.0209184 | |||
| 19355 | op-snap---monthly-publication-may-2025.pdf | 717 | 2025-05 | Car | Skoda | fabia | Grey | Driving without Due Care and Attention | None | B4424 Towards Worcester | Towards Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19358 | op-snap---monthly-publication-may-2025.pdf | 720 | 2025-05 | Car | Ford | Transit | Grey | 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 | ||
| 19395 | op-snap---monthly-publication-may-2025.pdf | 757 | 2025-05 | Pedestrian | Honda | Civic | Silver | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 19397 | op-snap---monthly-publication-may-2025.pdf | 759 | 2025-05 | Car | Mini | Cooper | White | Using a Mobile Phone Whilst Driving | None | M6 NB J14 | M6 Northbound J14 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19421 | op-snap---monthly-publication-may-2025.pdf | 783 | 2025-05 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | M69 to M6 j2 nb | M69 to M6 j2 nb | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19435 | op-snap---monthly-publication-may-2025.pdf | 797 | 2025-05 | Car | Mg | HS | Silver | Driving without Due Care and Attention | None | M6 NB J25 Wigan | M6 Northbound J25 Wigan | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19477 | op-snap---monthly-publication-may-2025.pdf | 839 | 2025-05 | Car | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | M6 SB jn2 | M6 Southbound jn2 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19478 | op-snap---monthly-publication-may-2025.pdf | 840 | 2025-05 | Car | bike | Misc - Non Traffic Offences | None | Telford | Telford | Out of Force Area | Out of Force Area | NFA | No Offence | 52.4979333 | -1.9664857 | ||||
| 19487 | op-snap---monthly-publication-may-2025.pdf | 849 | 2025-05 | Car | Volkswagen | Golf | Silver | Driving without Due Care and Attention | None | M40 Gayle Common | M40 Gayle Common | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19505 | op-snap---monthly-publication-may-2025.pdf | 867 | 2025-05 | Car | BMW | X5 | 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 | ||
| 19524 | op-snap---monthly-publication-may-2025.pdf | 886 | 2025-05 | Pedal Bike | Mercedes-Benz | CLA 220 | Grey | Driving without Reasonable Consideration | None | A458 Bridgnorth | Bridgnorth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19525 | op-snap---monthly-publication-may-2025.pdf | 887 | 2025-05 | Car | Citroen | C3 | White | Drive on hard shoulder | None | M6 Southbound nr Jn10A | M6 Southbound nr Jn10A | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19537 | op-snap---monthly-publication-may-2025.pdf | 899 | 2025-05 | Car | BMW | 3 series | Silver | Driving without Due Care and Attention | None | Langley... | Langley | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4934857 | -2.0054314 | ||
| 19538 | op-snap---monthly-publication-may-2025.pdf | 900 | 2025-05 | Car | Nissan | X Trail | Grey | Driving without Due Care and Attention | None | Bury | Bury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5011112 | -2.0356886 | ||
| 19553 | op-snap---monthly-publication-may-2025.pdf | 915 | 2025-05 | Car | Ford | Transit Connect | White | Driving without Due Care and Attention | None | Bedworth, Warwickshire | Bedworth, Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19565 | op-snap---monthly-publication-may-2025.pdf | 927 | 2025-05 | Car | Skoda | Octavia | Black | Driving without Due Care and Attention | None | Nantwich, Cheshire | Nantwich, Cheshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19571 | op-snap---monthly-publication-may-2025.pdf | 933 | 2025-05 | Car | Daf | Truck | Using a Mobile Phone Whilst Driving | Use vehicle on a road | wMi4th0o Wut avrawliidc ktest certificate | w Mi4th0o Wut avrawliidc ktest certificate | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 19607 | op-snap---monthly-publication-may-2025.pdf | 969 | 2025-05 | Car | Peugeot | 308 | White | Using a Mobile Phone Whilst Driving | Driving without Due C | aTree lfaonrdd Attention | a Tree lfaonrdd Attention | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19619 | op-snap---monthly-publication-may-2025.pdf | 981 | 2025-05 | Car | Peugeot | 2008.. | Silver | Driving without Due Care and Attention | None | St Davids Way (Nuneaton) | Street Davids Way (Nuneaton) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19637 | op-snap---monthly-publication-may-2025.pdf | 999 | 2025-05 | Car | Peugeot | black | Black | Driving without Due Care and Attention | None | M50 motorway, mid wales | M50 motorway, mid wales | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19639 | op-snap---monthly-publication-may-2025.pdf | 1001 | 2025-05 | Car | Dacia | Duster | Blue | Driving without Reasonable Consideration | None | Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | ||
| 19657 | op-snap---monthly-publication-may-2025.pdf | 1019 | 2025-05 | Car | Audi | A6 | Silver | Using a Mobile Phone Whilst Driving | None | A34 Stafford | Stafford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6014882 | -2.1310443 | ||
| 19659 | op-snap---monthly-publication-may-2025.pdf | 1021 | 2025-05 | Pedal Bike | Mercedes-Benz | GLC 250 | White | Motor vehicle fail to comply with solid white line road markings | None | Wesbury Road | Wesbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19660 | op-snap---monthly-publication-may-2025.pdf | 1022 | 2025-05 | Pedal Bike | Ford | C-Max | Blue | Motor vehicle fail to comply with solid white line road markings | None | Wesbury Road | Wesbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19661 | op-snap---monthly-publication-may-2025.pdf | 1023 | 2025-05 | Pedal Bike | Ford | Ecosport | Grey | Motor vehicle fail to comply with solid white line road markings | None | Wesbury Road | Wesbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19662 | op-snap---monthly-publication-may-2025.pdf | 1024 | 2025-05 | Pedal Bike | Mazda | MX5 | Red | Motor vehicle fail to comply with solid white line road markings | None | Webury Road | Webury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19663 | op-snap---monthly-publication-may-2025.pdf | 1025 | 2025-05 | Pedal Bike | Audi | Q2 | Silver | Motor vehicle fail to comply with solid white line road markings | None | Wesbury Road | Wesbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19696 | op-snap---monthly-publication-may-2025.pdf | 1058 | 2025-05 | Car | Volkswagen | Passat | Blue | No Seat Belt | None | Grimsby | Grimsby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19710 | op-snap---monthly-publication-may-2025.pdf | 1072 | 2025-05 | Motorbike | Vauxhall | Astra | Black | VRM fails to conform to Regulations | None | Measham - off force | Measham - off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19744 | op-snap---monthly-publication-may-2025.pdf | 1106 | 2025-05 | Car | Volkswagen | Polo | Black | Misc - Non Traffic Offences | None | A44, West mercia | A44, West mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19844 | op-snap---monthly-publication-may-2025.pdf | 1206 | 2025-05 | Car | Audi | A3 | Silver | Misc - Non Traffic Offences | None | A5 Nuneaton | Nuneaton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4014214 | -1.5189806 | ||
| 19928 | op-snap---monthly-publication-may-2025.pdf | 1290 | 2025-05 | Car | Peugeot | 207 | Blue | Driving without Due Care and Attention | None | The bryn, sarnau | The bryn, sarnau | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19954 | op-snap---monthly-publication-may-2025.pdf | 1316 | 2025-05 | Car | Audi | A4 Cabriolet | Silver | Driving without Due Care and Attention | None | A449, worcester | A449, worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5908671 | -1.8140277 | ||
| 19977 | op-snap---monthly-publication-may-2025.pdf | 1339 | 2025-05 | Car | Ford | NP | Green | Contravening a Red Traffic Light | None | jtc with comberton road | Jtc With Comberton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 19992 | op-snap---monthly-publication-may-2025.pdf | 1354 | 2025-05 | Car | Volkswagen | NP | Grey | Driving without Due Care and Attention | None | A452 Stourbridge road | Stourbridge road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.501035 | -2.107981 | ||
| 20012 | op-snap---monthly-publication-may-2025.pdf | 1374 | 2025-05 | Car | Vauxhall | NP | White | Driving without Reasonable Consideration | None | A456 towards Kidderminster | A456 towards Kidderminster | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 20013 | op-snap---monthly-publication-may-2025.pdf | 1375 | 2025-05 | Car | Skoda | NP | Blue | Driving without Reasonable Consideration | None | Innage Lane , Brignorth | Innage Lane , Brignorth | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 20014 | op-snap---monthly-publication-may-2025.pdf | 1376 | 2025-05 | Car | Ford | NP | Blue | Driving without Reasonable Consideration | None | A454 towards Bridgnorth | A454 towards Bridgnorth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20018 | op-snap---monthly-publication-may-2025.pdf | 1380 | 2025-05 | Car | Tractor | Blue | Using a Mobile Phone Whilst Driving | None | A489 Eaton to Lydham | Eaton to Lydham | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20056 | op-snap---monthly-publication-may-2025.pdf | 1418 | 2025-05 | Car | Ford | NP | Grey | Driving without Due Care and Attention | None | A518, JUNCTION IN MUXTON | A518, Junction In Muxton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20063 | op-snap---monthly-publication-may-2025.pdf | 1425 | 2025-05 | Pedal Bike | Mercedes-Benz | Benz | Red | Driving without Due Care and Attention | None | kenilworth road | Kenilworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5124557 | -1.8917609 | ||
| 20074 | op-snap---monthly-publication-may-2025.pdf | 1436 | 2025-05 | Car | NP | White | Using a Mobile Phone Whilst Driving | None | M42 | M42 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20107 | op-snap---monthly-publication-may-2025.pdf | 1469 | 2025-05 | Car | Volkswagen | Wagon golf | Red | Driving without Due Care and Attention | None | Malinsgate island | Malinsgate island | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20110 | op-snap---monthly-publication-may-2025.pdf | 1472 | 2025-05 | Car | Ford | ranger | Silver | Driving without Due Care and Attention | None | Cottage farm rd, b77 | Cottage farm rd, b77 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.439898 | -1.5279772 | ||
| 20118 | op-snap---monthly-publication-may-2025.pdf | 1480 | 2025-05 | Pedal Bike | Nissan | NP | Silver | Driving without Due Care and Attention | None | Castle hill road | Castle hill road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4688431 | -1.9992051 | ||
| 20121 | op-snap---monthly-publication-may-2025.pdf | 1483 | 2025-05 | Car | BMW | NP | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | 29 ansley road | 29 Ansley Road | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 20224 | op-snap---monthly-publication-may-2025.pdf | 1586 | 2025-05 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Station Road, Ketley | Station Road, Ketley | Out of Force Area | Out of Force Area | NFA | No VRM | ||||
| 20253 | op-snap---monthly-publication-may-2025.pdf | 1615 | 2025-05 | Car | Mercedes-Benz | tourismo | White | Using a Mobile Phone Whilst Driving | None | M40 | M40 | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | ||||
| 20452 | op-snap---monthly-publication-may-2025.pdf | 1814 | 2025-05 | Car | Misc - Non Traffic Offences | None | Market Drayton | Market Drayton | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes |
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);