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", offence = "Using a Mobile Phone Whilst Driving" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, latitude, longitude
vehicle_make 29
month 14
disposal 2
- NFA 127
- Fixed Penalty 1
reporter_transport_mode 1
- Car · 128 ✖
offence 1
- Using a Mobile Phone Whilst Driving · 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7314 | op-snap---monthly-publication-february-2026.pdf | 61 | 2026-02 | Car | Kia | Ceed | Silver | Using a Mobile Phone Whilst Driving | None | Moorfield Road | Moorfield Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4981538 | -1.7875516 | ||
| 7352 | op-snap---monthly-publication-february-2026.pdf | 99 | 2026-02 | Car | Volkswagen | Tiguan | White | Using a Mobile Phone Whilst Driving | None | M621 (Greater Manchester) | M621 (Greater Manchester) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7456 | op-snap---monthly-publication-february-2026.pdf | 203 | 2026-02 | Car | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | Rugy Road Rugby | Rugy Road Rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7639 | op-snap---monthly-publication-february-2026.pdf | 386 | 2026-02 | Car | Ford | Transit | Black | Using a Mobile Phone Whilst Driving | None | A529 Hinstock | Hinstock | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7860 | op-snap---monthly-publication-february-2026.pdf | 607 | 2026-02 | Car | Land Rover | Range | White | Using a Mobile Phone Whilst Driving | None | A19 | A19 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8108 | op-snap---monthly-publication-february-2026.pdf | 855 | 2026-02 | Car | Vauxhall | Astra | Blue | Using a Mobile Phone Whilst Driving | None | Wyrley Brook Retail Park | Wyrley Brook Retail Park | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8199 | op-snap---monthly-publication-february-2026.pdf | 946 | 2026-02 | Car | Van | White | Using a Mobile Phone Whilst Driving | None | Desford Road | Desford Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8361 | op-snap---monthly-publication-february-2026.pdf | 1108 | 2026-02 | Car | Nissan | note | Red | Using a Mobile Phone Whilst Driving | None | A460 four ashes | A460 four ashes | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3828826 | -1.7624844 | ||
| 8381 | op-snap---monthly-publication-february-2026.pdf | 1128 | 2026-02 | Car | Volkswagen | Polo | Blue | Using a Mobile Phone Whilst Driving | None | A5 Nuneaton | Nuneaton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4014214 | -1.5189806 | ||
| 8415 | op-snap---monthly-publication-february-2026.pdf | 1162 | 2026-02 | Car | Mercedes-Benz | sprinter | White | Using a Mobile Phone Whilst Driving | None | M42 J3 | M42 J3 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4846642 | -1.9297585 | ||
| 8472 | op-snap---monthly-publication-february-2026.pdf | 1219 | 2026-02 | Car | BMW | 3 series | Black | Using a Mobile Phone Whilst Driving | None | M4 | M4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8545 | op-snap---monthly-publication-february-2026.pdf | 1292 | 2026-02 | Car | Kia | Red | Using a Mobile Phone Whilst Driving | None | Burton Upon Trent | Burton Upon Trent | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 8582 | op-snap---monthly-publication-february-2026.pdf | 1329 | 2026-02 | Car | Skoda | Fabia | Blue | Using a Mobile Phone Whilst Driving | None | Town Walls, Shrewbury | Town Walls, Shrewbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8588 | op-snap---monthly-publication-february-2026.pdf | 1335 | 2026-02 | Car | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | M6 J18-19 | M6 J18-19 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 8666 | op-snap---monthly-publication-february-2026.pdf | 1413 | 2026-02 | Car | Ford | White | Using a Mobile Phone Whilst Driving | None | IIminster Road | IIminster Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 10573 | op-snap---monthly-publication-january-2026.pdf | 34 | 2026-01 | Car | Land Rover | Discovery | Grey | Using a Mobile Phone Whilst Driving | None | A48 Gloucester | Gloucester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.405214 | -1.9708282 | ||
| 10610 | op-snap---monthly-publication-january-2026.pdf | 71 | 2026-01 | Car | Toyota | Corolla | Grey | Using a Mobile Phone Whilst Driving | None | Stourbridge Road Wombourne | Stourbridge Road Wombourne | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10740 | op-snap---monthly-publication-january-2026.pdf | 201 | 2026-01 | Car | Ford | Ka | White | Using a Mobile Phone Whilst Driving | None | B4215 Ross on Wye | Ross on Wye | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10848 | op-snap---monthly-publication-january-2026.pdf | 309 | 2026-01 | Car | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Warwick | Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3813073 | -1.5639569 | ||
| 10905 | op-snap---monthly-publication-january-2026.pdf | 366 | 2026-01 | Car | BMW | 6 Series | Black | Using a Mobile Phone Whilst Driving | None | M6 J14 | M6 J14 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 11061 | op-snap---monthly-publication-january-2026.pdf | 522 | 2026-01 | Car | Nissan | Juke | Silver | Using a Mobile Phone Whilst Driving | None | M1 J15 Northhampton | M1 J15 Northhampton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11082 | op-snap---monthly-publication-january-2026.pdf | 543 | 2026-01 | Car | Honda | Red | Using a Mobile Phone Whilst Driving | None | M60 | M60 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 11346 | op-snap---monthly-publication-january-2026.pdf | 807 | 2026-01 | Car | Volvo | Silver | Using a Mobile Phone Whilst Driving | None | High Street | High Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4993921 | -1.8955888 | |||
| 11353 | op-snap---monthly-publication-january-2026.pdf | 814 | 2026-01 | Car | Kia | Niro | Grey | Using a Mobile Phone Whilst Driving | None | Enfield, London | Enfield, London | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11494 | op-snap---monthly-publication-january-2026.pdf | 955 | 2026-01 | Car | BMW | X5 | Black | Using a Mobile Phone Whilst Driving | None | A6182 Doncatser | Doncatser | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11543 | op-snap---monthly-publication-january-2026.pdf | 1004 | 2026-01 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | No Insurance | M25 Dartford | M25 Dartford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6162979 | -2.0165105 | ||
| 11648 | op-snap---monthly-publication-january-2026.pdf | 1109 | 2026-01 | Car | Toyota | Aygo | Red | Using a Mobile Phone Whilst Driving | None | George Street Newcastle | George Street Newcastle | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11653 | op-snap---monthly-publication-january-2026.pdf | 1114 | 2026-01 | Car | Peugeot | 3008.. | Grey | Using a Mobile Phone Whilst Driving | None | M5 Jct 6 | M5 Junction 6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11683 | op-snap---monthly-publication-january-2026.pdf | 1144 | 2026-01 | Car | Audi | TT | Grey | Using a Mobile Phone Whilst Driving | None | M53 Mersey Side | M53 Mersey Side | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11732 | op-snap---monthly-publication-january-2026.pdf | 1193 | 2026-01 | Car | Seat | . | Green | Using a Mobile Phone Whilst Driving | None | Stratford Upon Avon | Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3499075 | -1.7812051 | ||
| 11733 | op-snap---monthly-publication-january-2026.pdf | 1194 | 2026-01 | Car | Land Rover | Defender | Black | Using a Mobile Phone Whilst Driving | None | M3 near Bracknell | M3 near Bracknell | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 3999 | op-snap---monthly-publication-december-2025.pdf | 127 | 2025-12 | Car | Bentley | Grey | Using a Mobile Phone Whilst Driving | None | M42 West Mercia | M42 West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4059 | op-snap---monthly-publication-december-2025.pdf | 187 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Using a Mobile Phone Whilst Driving | None | M1 / M45 Watford Gap | M1 / M45 Watford Gap | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4412 | op-snap---monthly-publication-december-2025.pdf | 540 | 2025-12 | Car | Honda | CR-V | Black | Using a Mobile Phone Whilst Driving | No Insurance | Battlefield Road | Battlefield Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4628 | op-snap---monthly-publication-december-2025.pdf | 756 | 2025-12 | Car | Renault | Captur | Black | Using a Mobile Phone Whilst Driving | None | M5 Southbound, jn 6 to 7 | M5 Southbound, jn 6 to 7 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4797 | op-snap---monthly-publication-december-2025.pdf | 925 | 2025-12 | Car | Toyota | Corolla | Grey | Using a Mobile Phone Whilst Driving | None | M40 near Banbury | M40 near Banbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4822 | op-snap---monthly-publication-december-2025.pdf | 950 | 2025-12 | Car | Ford | White | Using a Mobile Phone Whilst Driving | Driving without Due Care and | M At2t5ention | M At2t5ention | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 4836 | op-snap---monthly-publication-december-2025.pdf | 964 | 2025-12 | Car | Land Rover | Sport | Blue | Using a Mobile Phone Whilst Driving | No Insurance | M42, nothing more specific | M42, nothing more specific | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4837 | op-snap---monthly-publication-december-2025.pdf | 965 | 2025-12 | Car | Volkswagen | Red | Using a Mobile Phone Whilst Driving | None | Warrington | Warrington | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5389668 | -1.856967 | |||
| 4883 | op-snap---monthly-publication-december-2025.pdf | 1011 | 2025-12 | Car | Volkswagen | Crafter | white | Using a Mobile Phone Whilst Driving | None | M5 jn4-jn5 | M5 jn4-jn5 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4885 | op-snap---monthly-publication-december-2025.pdf | 1013 | 2025-12 | Car | Toyota | Auris | Black | Using a Mobile Phone Whilst Driving | None | A6 in Leicester | A6 in Leicester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4917 | op-snap---monthly-publication-december-2025.pdf | 1045 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | M1 NB J10, Luton | M1 Northbound J10, Luton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4928 | op-snap---monthly-publication-december-2025.pdf | 1056 | 2025-12 | Car | Mercedes-Benz | Splinter | White | Using a Mobile Phone Whilst Driving | None | M1 J10 | M1 J10 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 5000 | op-snap---monthly-publication-december-2025.pdf | 1128 | 2025-12 | Car | BMW | Purple | Using a Mobile Phone Whilst Driving | None | Guildford | Guildford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4970635 | -1.9013006 | |||
| 5056 | op-snap---monthly-publication-december-2025.pdf | 1184 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Arbury Road | Arbury Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3979577 | -1.8129541 | ||
| 20569 | op-snap---monthly-publication-november-2025.pdf | 111 | 2025-11 | Car | Honda | Silver | Using a Mobile Phone Whilst Driving | None | M6 Toll NB | M6 Toll Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20592 | op-snap---monthly-publication-november-2025.pdf | 134 | 2025-11 | Car | Jeep | Avenger | Using a Mobile Phone Whilst Driving | None | M40 J4 | M40 J4 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20657 | op-snap---monthly-publication-november-2025.pdf | 199 | 2025-11 | Car | Renault | Trafic | White | Using a Mobile Phone Whilst Driving | None | Tomkinson Road | Tomkinson Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20738 | op-snap---monthly-publication-november-2025.pdf | 280 | 2025-11 | Car | Vauxhall | Meriva | Black | Using a Mobile Phone Whilst Driving | None | Burley Road, Leeds | Burley Road, Leeds | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20852 | op-snap---monthly-publication-november-2025.pdf | 394 | 2025-11 | Car | Genesis | Black | Using a Mobile Phone Whilst Driving | None | M1 Junction 18 | M1 Junction 18 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 20967 | op-snap---monthly-publication-november-2025.pdf | 509 | 2025-11 | Car | Volkswagen | Golf | Blue | Using a Mobile Phone Whilst Driving | None | Springfield Road, Worcester | Springfield Road, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21037 | op-snap---monthly-publication-november-2025.pdf | 579 | 2025-11 | Car | Mercedes-Benz | Black | Using a Mobile Phone Whilst Driving | None | Brighton Road | Brighton Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4543156 | -1.8840717 | |||
| 21065 | op-snap---monthly-publication-november-2025.pdf | 607 | 2025-11 | Car | Mercedes-Benz | EQE | Black | Using a Mobile Phone Whilst Driving | None | M1. | M1 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21487 | op-snap---monthly-publication-november-2025.pdf | 1029 | 2025-11 | Car | Mitsubishi | L200 | White | Using a Mobile Phone Whilst Driving | None | Hereford City Centre | Hereford City Centre | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21636 | op-snap---monthly-publication-november-2025.pdf | 1178 | 2025-11 | Car | Volvo | XC90 | White | Using a Mobile Phone Whilst Driving | None | A43 | A43 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21945 | op-snap---monthly-publication-november-2025.pdf | 1487 | 2025-11 | Car | Honda | CR-V | Grey | Using a Mobile Phone Whilst Driving | None | M25 - Jct 15-16 (Thames Valley) | M25 - Junction 15-16 (Thames Valley) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22244 | op-snap---monthly-publication-october-2025.pdf | 194 | 2025-10 | Car | Lexus | CT200H | White | Using a Mobile Phone Whilst Driving | None | UK | Uk | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | 52.5019896 | -2.0209184 | ||
| 22463 | op-snap---monthly-publication-october-2025.pdf | 413 | 2025-10 | Car | Ford | Fiesta | Blue | Using a Mobile Phone Whilst Driving | None | A1M, Leeds | A1M, Leeds | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22478 | op-snap---monthly-publication-october-2025.pdf | 428 | 2025-10 | Car | Hyundai | Tuscan | Black | Using a Mobile Phone Whilst Driving | None | Malvern Road, Worcester | Malvern Road, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22514 | op-snap---monthly-publication-october-2025.pdf | 464 | 2025-10 | Car | Vauxhall | Corsa | Grey | Using a Mobile Phone Whilst Driving | None | Chasepool Road | Chasepool Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22736 | op-snap---monthly-publication-october-2025.pdf | 686 | 2025-10 | Car | BMW | 330i | Grey | Using a Mobile Phone Whilst Driving | No vehicle excise licence | Barbourne Road, Worcester | Barbourne Road, Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22743 | op-snap---monthly-publication-october-2025.pdf | 693 | 2025-10 | Car | Volkswagen | Polo | Silver | Using a Mobile Phone Whilst Driving | None | M61 (Out of Force - Lancashire) | M61 (Out of Force - Lancashire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22769 | op-snap---monthly-publication-october-2025.pdf | 719 | 2025-10 | Car | BMW | 330e | Black | Using a Mobile Phone Whilst Driving | None | A6046 | A6046 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22859 | op-snap---monthly-publication-october-2025.pdf | 809 | 2025-10 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | M40 | M40 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22917 | op-snap---monthly-publication-october-2025.pdf | 867 | 2025-10 | Car | Volkswagen | Polo | Silver | Using a Mobile Phone Whilst Driving | None | M6 SB J16 - Stoke | M6 Southbound J16 - Stoke | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22925 | op-snap---monthly-publication-october-2025.pdf | 875 | 2025-10 | Car | Mercedes-Benz | Grey | Using a Mobile Phone Whilst Driving | None | Wilnecote | Wilnecote | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5213778 | -1.9046931 | |||
| 22977 | op-snap---monthly-publication-october-2025.pdf | 927 | 2025-10 | Car | Mercedes-Benz | A200 | White | Using a Mobile Phone Whilst Driving | None | M5 near to Jct 8 North | M5 near to Junction 8 North | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23020 | op-snap---monthly-publication-october-2025.pdf | 970 | 2025-10 | Car | Volkswagen | Multivan | Black | Using a Mobile Phone Whilst Driving | None | Strawberry Hill, Teddington | Strawberry Hill, Teddington | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23085 | op-snap---monthly-publication-october-2025.pdf | 1035 | 2025-10 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | M1 | M1 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23841 | op-snap---monthly-publication-september-2025.pdf | 60 | 2025-09 | Car | Ford | Ranger | White | Using a Mobile Phone Whilst Driving | None | M25 (Surrey?) | M25 (Surrey?) | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5579918 | -1.8904833 | ||
| 23989 | op-snap---monthly-publication-september-2025.pdf | 208 | 2025-09 | Car | John Deere tractor | Green | Using a Mobile Phone Whilst Driving | None | A5 Royal Redgate Roundabout, Warwickshire | Royal Redgate Roundabout, Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 24041 | op-snap---monthly-publication-september-2025.pdf | 260 | 2025-09 | Car | Renault | Clio | Silver | Using a Mobile Phone Whilst Driving | None | Walsingham Drive | Walsingham Drive | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24206 | op-snap---monthly-publication-september-2025.pdf | 425 | 2025-09 | Car | Ford | transit | White | Using a Mobile Phone Whilst Driving | None | M40 | M40 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24236 | op-snap---monthly-publication-september-2025.pdf | 455 | 2025-09 | Car | Mitsubishi | Outlander | Silver | Using a Mobile Phone Whilst Driving | None | Evesham High Street | Evesham High Street | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24275 | op-snap---monthly-publication-september-2025.pdf | 494 | 2025-09 | Car | Volkswagen | Golf | Grey | Using a Mobile Phone Whilst Driving | None | M6 near to Stafford | M6 near to Stafford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24286 | op-snap---monthly-publication-september-2025.pdf | 505 | 2025-09 | Car | Honda | Civic | Grey | Using a Mobile Phone Whilst Driving | None | M5 Jct 4 | M5 Junction 4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24489 | op-snap---monthly-publication-september-2025.pdf | 708 | 2025-09 | Car | Iveco | HGV | White | Using a Mobile Phone Whilst Driving | None | M1 Southbound jn 40-41 | M1 Southbound jn 40-41 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24566 | op-snap---monthly-publication-september-2025.pdf | 785 | 2025-09 | Car | Suzuki | Vitara | Silver | Using a Mobile Phone Whilst Driving | None | Norman Way | Norman Way | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24587 | op-snap---monthly-publication-september-2025.pdf | 806 | 2025-09 | Car | Volkswagen | Golf | White | Using a Mobile Phone Whilst Driving | None | M5 North Bromsgrove (West Mercia) | M5 North Bromsgrove (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24697 | op-snap---monthly-publication-september-2025.pdf | 916 | 2025-09 | Car | Mini | Aceman | Black | Using a Mobile Phone Whilst Driving | None | New Road Rugeley | New Road Rugeley | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 24782 | op-snap---monthly-publication-september-2025.pdf | 1001 | 2025-09 | Car | Renault | Motor Caravan | Blue | Using a Mobile Phone Whilst Driving | None | M6 SB J19-18 - Cheshire | M6 Southbound J19-18 - Cheshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 2114 | op-snap---monthly-publication-august-2025.pdf | 89 | 2025-08 | Car | Mercedes-Benz | Sprinter | Blue | Using a Mobile Phone Whilst Driving | None | M6 Staffs | M6 Staffs | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.6170728 | -2.030393 | ||
| 2128 | op-snap---monthly-publication-august-2025.pdf | 103 | 2025-08 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | A5 (Brownhills) | A5 (Brownhills) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2281 | op-snap---monthly-publication-august-2025.pdf | 256 | 2025-08 | Car | Jaguar | F-Pace | Grey | Using a Mobile Phone Whilst Driving | None | M5 Worcester | M5 Worcester | Out of Force Are | Out of Force Area | NFA | Out of Force | 52.5908671 | -1.8140277 | ||
| 2310 | op-snap---monthly-publication-august-2025.pdf | 285 | 2025-08 | Car | Ford | Fiesta | White | Using a Mobile Phone Whilst Driving | None | M5 NB J7-6 | M5 Northbound J7-6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2462 | op-snap---monthly-publication-august-2025.pdf | 437 | 2025-08 | Car | BMW | 116I | Grey | Using a Mobile Phone Whilst Driving | None | M62 Mnachester | M62 Mnachester | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2519 | op-snap---monthly-publication-august-2025.pdf | 494 | 2025-08 | Car | Audi | A3.. | Blue | Using a Mobile Phone Whilst Driving | None | Somewhere on the M6. | Somewhere on the M6 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2522 | op-snap---monthly-publication-august-2025.pdf | 497 | 2025-08 | Car | BMW | 520D | Silver | Using a Mobile Phone Whilst Driving | None | A444 (West Mercia) | A444 (West Mercia) | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2602 | op-snap---monthly-publication-august-2025.pdf | 577 | 2025-08 | Car | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | M1 | M1 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2866 | op-snap---monthly-publication-august-2025.pdf | 841 | 2025-08 | Car | Honda | Civic | Black | Using a Mobile Phone Whilst Driving | None | Jct 1 on the M1. | Junction 1 on the M1 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2892 | op-snap---monthly-publication-august-2025.pdf | 867 | 2025-08 | Car | Lamborghini | Ferrari F355 | Red | Using a Mobile Phone Whilst Driving | None | B4211 Upton Upon Severn | Upton Upon Severn | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2898 | op-snap---monthly-publication-august-2025.pdf | 873 | 2025-08 | Car | Volkswagen | Polo | White | Using a Mobile Phone Whilst Driving | None | A14.... | A14 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2957 | op-snap---monthly-publication-august-2025.pdf | 932 | 2025-08 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | Jct 3 M5 | Junction 3 M5 | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 2970 | op-snap---monthly-publication-august-2025.pdf | 945 | 2025-08 | Car | BMW | 3 series | Grey | Using a Mobile Phone Whilst Driving | None | Between Hagley and Blakedown in West Mercia | Between Hagley and Blakedown in West Mercia | Out of Force Are | Out of Force Area | NFA | Out of Force | ||||
| 3039 | op-snap---monthly-publication-august-2025.pdf | 1014 | 2025-08 | Car | Volkswagen | Caddy | White | Using a Mobile Phone Whilst Driving | None | A513 Kings Bromley | Kings Bromley | Out of Force Are | 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 | ||||
| 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 | ||||
| 13014 | op-snap---monthly-publication-july-2025.pdf | 1066 | 2025-07 | Car | Nissan | Juke | Grey | Using a Mobile Phone Whilst Driving | None | B4362 , Mortimers Cross | B4362 , Mortimers Cross | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 13090 | op-snap---monthly-publication-july-2025.pdf | 1142 | 2025-07 | Car | Vauxhall | Zafira | Blue | Using a Mobile Phone Whilst Driving | None | M1 | M1 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 13128 | op-snap---monthly-publication-july-2025.pdf | 1180 | 2025-07 | Car | Land Rover | Black | Using a Mobile Phone Whilst Driving | None | Somewhere in Manchester | Somewhere in Manchester | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available |
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);