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'}
120 rows where council_area = "Out of Force Area" and month = "2025-04" 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 Reasonable Consideration 57
- Driving without Due Care and Attention 31
- Contravening a Red Traffic Light 11
- Using a Mobile Phone Whilst Driving 7
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
- Dangerous Driving 3
- Drive on hard shoulder 2
- Misc - Non Traffic Offences 2
- Contravene Lane Closure Red X 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 1
- Motor vehicle fail to comply with solid white line road markings 1
- Prohibited vehicle in offside lane of motorway 1
reporter_transport_mode 5
- Car 102
- Pedal Bike 13
- Other 3
- Bus 1
- Pedestrian 1
disposal 2
- NFA 119
- Fixed Penalty 1
month 1
- 2025-04 · 120 ✖
council_area 1
- Out of Force Area · 120 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | op-snap---monthly-publication-april-2025.pdf | 24 | 2025-04 | Car | Volkswagen | Touareg | Black | Driving without Due Care and Attention | None | Telford out of force | Telford out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 30 | op-snap---monthly-publication-april-2025.pdf | 29 | 2025-04 | Pedal Bike | Iveco | DAILY | White | Driving without Reasonable Consideration | None | LYNN LANE,SHENSTONE | Lynn Lane, Shenstone | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 42 | op-snap---monthly-publication-april-2025.pdf | 41 | 2025-04 | Car | Ford | Puma | Black | Driving without Due Care and Attention | None | A45 Ryton | Ryton | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 86 | op-snap---monthly-publication-april-2025.pdf | 85 | 2025-04 | Pedal Bike | Land Rover | Evoque | Silver | Driving without Reasonable Consideration | None | Off force | Off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 114 | op-snap---monthly-publication-april-2025.pdf | 113 | 2025-04 | Car | BMW | M3 | Grey | 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 | ||
| 116 | op-snap---monthly-publication-april-2025.pdf | 115 | 2025-04 | Car | Volvo | Coach | White | Driving without Reasonable Consideration | None | A438 Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 132 | op-snap---monthly-publication-april-2025.pdf | 131 | 2025-04 | Car | BMW | 3 SERIES | Red | Driving without Due Care and Attention | None | A46 EVESHAM | A46 Evesham | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3834358 | -1.5524039 | ||
| 138 | op-snap---monthly-publication-april-2025.pdf | 137 | 2025-04 | Car | Vauxhall | Astra | Black | Driving without Due Care and Attention | None | Langley Mill | Langley Mill | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5812845 | -1.7849785 | ||
| 151 | op-snap---monthly-publication-april-2025.pdf | 150 | 2025-04 | Car | Volkswagen | White | Driving without Due Care and Attention | None | WARWICK ROAD, LEEK | Warwick Road, Leek | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 158 | op-snap---monthly-publication-april-2025.pdf | 157 | 2025-04 | Car | White | Driving without Due Care and Attention | None | Uttoxeter | Uttoxeter | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.601821 | -2.1396359 | ||||
| 309 | op-snap---monthly-publication-april-2025.pdf | 308 | 2025-04 | Car | Mercedes-Benz | C180 | Silver | Using a Mobile Phone Whilst Driving | None | M1 J17 | M1 J17 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 378 | op-snap---monthly-publication-april-2025.pdf | 377 | 2025-04 | Other | Kia | Xceed | Red | Driving without Due Care and Attention | None | Blackwell Street | Blackwell Street | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 517 | op-snap---monthly-publication-april-2025.pdf | 516 | 2025-04 | Car | Ford | Puma | White | Driving without Due Care and Attention | None | A5 Telford | Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | ||
| 531 | op-snap---monthly-publication-april-2025.pdf | 530 | 2025-04 | Car | Land Rover | 4 | Silver | Driving without Due Care and Attention | None | CAMPDEN ROAD,STRATFORD | Campden Road, Stratford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 541 | op-snap---monthly-publication-april-2025.pdf | 540 | 2025-04 | Other | Mercedes-Benz | Truck | White | Using a Mobile Phone Whilst Driving | None | M25 motorway | M25 motorway | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.490826 | -1.8882034 | ||
| 549 | op-snap---monthly-publication-april-2025.pdf | 548 | 2025-04 | Car | Red | Driving without Due Care and Attention | None | SCUNTHORPE | Scunthorpe | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 553 | op-snap---monthly-publication-april-2025.pdf | 552 | 2025-04 | Car | Daf | TRUCKS | WHITE | Driving without Due Care and Attention | None | ILLINGTON, SCUNTHOURPE | Illington, Scunthourpe | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 555 | op-snap---monthly-publication-april-2025.pdf | 554 | 2025-04 | Car | Iveco | Ambulance | Yellow | Driving without Due Care and Attention | None | A42 Northbound, Nottinghamshire | Northbound, Nottinghamshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 584 | op-snap---monthly-publication-april-2025.pdf | 583 | 2025-04 | Car | Skoda | Octivia | Red | Driving without Due Care and Attention | None | A456 Bewdley | Bewdley | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4330724 | -1.9181313 | ||
| 599 | op-snap---monthly-publication-april-2025.pdf | 598 | 2025-04 | Car | Ford | Mondeo | Blue | Driving without Reasonable Consideration | None | A50 in Staffordshire | A50 in Staffordshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 602 | op-snap---monthly-publication-april-2025.pdf | 601 | 2025-04 | Car | Mini | Cooper | White | Driving without Reasonable Consideration | None | M40 in Warwickshire | M40 in Warwickshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 613 | op-snap---monthly-publication-april-2025.pdf | 612 | 2025-04 | Car | UK | Black | Driving without Due Care and Attention | None | St Georges Way | Street Georges Way | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 633 | op-snap---monthly-publication-april-2025.pdf | 632 | 2025-04 | Car | BMW | 1 series | White | Drive on hard shoulder | None | A5 in Telford | A5 in Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 652 | op-snap---monthly-publication-april-2025.pdf | 651 | 2025-04 | Car | HGV | White | Prohibited vehicle in offside lane of motorway | None | M6 ?? | M6 ?? | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5264087 | -1.8897131 | |||
| 654 | op-snap---monthly-publication-april-2025.pdf | 653 | 2025-04 | Car | Nissan | XTrail | Black | Misc - Non Traffic Offences | None | M40 Warwickshire | M40 Warwickshire | Out of Force Area | Out of Force Area | NFA | No Offence | 52.3976134 | -1.4337873 | ||
| 665 | op-snap---monthly-publication-april-2025.pdf | 664 | 2025-04 | Car | Driving without Due Care and Attention | None | M27 Southampton | M27 Southampton | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5894368 | -2.122999 | |||||
| 683 | op-snap---monthly-publication-april-2025.pdf | 682 | 2025-04 | Car | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Cofton Hackett, West Mercia | Cofton Hackett, West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 685 | op-snap---monthly-publication-april-2025.pdf | 684 | 2025-04 | Car | Suburau | Green | Driving without Due Care and Attention | None | Tilstock Roundabout (Shropshire) | Tilstock Roundabout (Shropshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 687 | op-snap---monthly-publication-april-2025.pdf | 686 | 2025-04 | Car | Audi | A5 | White | Driving without Due Care and Attention | None | A494 Wales | Wales | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 688 | op-snap---monthly-publication-april-2025.pdf | 687 | 2025-04 | Car | Ford | Transit | White | Drive on hard shoulder | None | M5 Junction 4 slip | M5 Junction 4 slip | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 714 | op-snap---monthly-publication-april-2025.pdf | 713 | 2025-04 | Car | Toyota | Rav 4 | Blue | Driving without Due Care and Attention | None | A49 Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 720 | op-snap---monthly-publication-april-2025.pdf | 719 | 2025-04 | Car | Hyundai | Santa | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic | equipment None | A49 Northbound Hereford | Northbound Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 733 | op-snap---monthly-publication-april-2025.pdf | 732 | 2025-04 | Pedal Bike | Land Rover | Defender | Black | Driving without Reasonable Consideration | None | A500 Staffs | Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 755 | op-snap---monthly-publication-april-2025.pdf | 754 | 2025-04 | Car | Honda | Civic | Blue | Contravening a Red Traffic Light | None | A460 Cannock | Cannock | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 756 | op-snap---monthly-publication-april-2025.pdf | 755 | 2025-04 | Car | Toyota | Landcruiser | Grey | Contravening a Red Traffic Light | None | Telford | Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4979333 | -1.9664857 | ||
| 766 | op-snap---monthly-publication-april-2025.pdf | 765 | 2025-04 | Car | Volkswagen | Caddy | Grey | Driving without Due Care and Attention | None | Tamworth Road | Tamworth Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5856221 | -1.790692 | ||
| 773 | op-snap---monthly-publication-april-2025.pdf | 772 | 2025-04 | Car | Land Rover | Discovery | Grey | Contravening a Red Traffic Light | None | Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 797 | op-snap---monthly-publication-april-2025.pdf | 796 | 2025-04 | Car | Jaguar | XF | Black | Driving without Due Care and Attention | None | A435 Redditch | Redditch | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4072158 | -1.9277937 | ||
| 808 | op-snap---monthly-publication-april-2025.pdf | 807 | 2025-04 | Other | Misc - Non Traffic Offences | None | Unknown. | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | ||||||||
| 882 | op-snap---monthly-publication-april-2025.pdf | 881 | 2025-04 | Car | Volkswagen | Golf | Blue | Driving without Reasonable Consideration | None | Leasingham bypass , Lincoln | Leasingham bypass , Lincoln | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 898 | op-snap---monthly-publication-april-2025.pdf | 897 | 2025-04 | Car | Nissan | Qashqai | White | Driving without Reasonable Consideration | None | Gleneagle's Avenue , Leicester | Gleneagle's Avenue , Leicester | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 931 | op-snap---monthly-publication-april-2025.pdf | 930 | 2025-04 | Car | Vauxhall | Black | Driving without Reasonable Consideration | None | Henley Road , B4089 | Henley Road , B4089 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4343442 | -1.4716402 | |||
| 944 | op-snap---monthly-publication-april-2025.pdf | 943 | 2025-04 | Car | Audi | Black | Driving without Reasonable Consideration | None | B4176 Rabbit Run towards Bridgnorth | Rabbit Run towards Bridgnorth | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 958 | op-snap---monthly-publication-april-2025.pdf | 957 | 2025-04 | Car | Volkswagen | Tiguan | White | Using a Mobile Phone Whilst Driving | None | Rodborough Drive , Worcester | Rodborough Drive , Worcester | Out of Force Area | Out of Force Area | NFA | No Offence | ||||
| 966 | op-snap---monthly-publication-april-2025.pdf | 965 | 2025-04 | Car | Ford | Explorer | White | Driving without Reasonable Consideration | None | Lowerwick , Worcester | Lowerwick , Worcester | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 979 | op-snap---monthly-publication-april-2025.pdf | 978 | 2025-04 | Car | Off road bike | Black | Driving without Reasonable Consideration | none | West Hill Field , Bridlington | West Hill Field , Bridlington | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1013 | op-snap---monthly-publication-april-2025.pdf | 1012 | 2025-04 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | A511 Ashby Bypass | Ashby Bypass | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1046 | op-snap---monthly-publication-april-2025.pdf | 1045 | 2025-04 | Car | Toyota | Yaris | Grey | Driving without Reasonable Consideration | None | SOlitaire Avenue , WOrcester | SOlitaire Avenue , WOrcester | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1108 | op-snap---monthly-publication-april-2025.pdf | 1107 | 2025-04 | Car | Ford | White | Driving without Reasonable Consideration | None | Stoke Road , Bromsgrove | Stoke Road , Bromsgrove | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1115 | op-snap---monthly-publication-april-2025.pdf | 1114 | 2025-04 | Car | Toyota | Yaris | White | Driving without Reasonable Consideration | None | Mill Road , Rugby | Mill Road , Rugby | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1116 | op-snap---monthly-publication-april-2025.pdf | 1115 | 2025-04 | Car | Toyota | HILLUX | Green | Driving without Reasonable Consideration | None | A556 , WHitchurch | A556 , WHitchurch | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.394829 | -1.5774929 | ||
| 1117 | op-snap---monthly-publication-april-2025.pdf | 1116 | 2025-04 | Car | Vauxhall | Corsa | Black | Driving without Reasonable Consideration | None | M6 North Bound close to Junction 10 | M6 North Bound close to Junction 10 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1135 | op-snap---monthly-publication-april-2025.pdf | 1134 | 2025-04 | Car | Skoda | Blue | Driving without Reasonable Consideration | None | Jinnah Road , Redditch | Jinnah Road , Redditch | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1170 | op-snap---monthly-publication-april-2025.pdf | 1169 | 2025-04 | Car | Isuzu | Blue | Driving without Reasonable Consideration | None | A41 towards Cosford | A41 towards Cosford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1201 | op-snap---monthly-publication-april-2025.pdf | 1200 | 2025-04 | Car | Ford | Grey | Driving without Reasonable Consideration | None | Banbury Road towards Stratford upon Avon | Banbury Road towards Stratford upon Avon | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1202 | op-snap---monthly-publication-april-2025.pdf | 1201 | 2025-04 | Car | Land Rover | Discovery | Blue | Driving without Reasonable Consideration | None | Warwick Road , Stratford | Warwick Road , Stratford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1203 | op-snap---monthly-publication-april-2025.pdf | 1202 | 2025-04 | Car | Motorbike | Contravening a Red Traffic Light | None | Main road heading towards Quarry Bank | Main road heading towards Quarry Bank | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||||
| 1263 | op-snap---monthly-publication-april-2025.pdf | 1262 | 2025-04 | Car | Peugeot | Grey | Driving without Reasonable Consideration | None | Trench Lock , Telford | Trench Lock , Telford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1275 | op-snap---monthly-publication-april-2025.pdf | 1274 | 2025-04 | Pedal Bike | Volkswagen | Polo | White | Driving without Reasonable Consideration | None | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||||
| 1279 | op-snap---monthly-publication-april-2025.pdf | 1278 | 2025-04 | Car | Ford | Transit Van | White | Driving without Reasonable Consideration | None | Harrogate Road , Harrogate | Harrogate Road , Harrogate | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1286 | op-snap---monthly-publication-april-2025.pdf | 1285 | 2025-04 | Pedal Bike | Audi | A1 | White | Driving without Due Care and Attention | None | WOOTEN WAWEN ROAD | Wooten Wawen Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1291 | op-snap---monthly-publication-april-2025.pdf | 1290 | 2025-04 | Car | Ford | NP | Silver | Driving without Due Care and Attention | None | M54 JCT 4 | M54 Jct 4 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1309 | op-snap---monthly-publication-april-2025.pdf | 1308 | 2025-04 | Car | Seat | Leon | Grey | Driving without Due Care and Attention | None | Astwood Lane | Astwood Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1317 | op-snap---monthly-publication-april-2025.pdf | 1316 | 2025-04 | Car | Volkswagen | Tiguan Allspace | Black | Dangerous Driving | None | M5 inside Lane Northbound | M5 inside Lane Northbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1326 | op-snap---monthly-publication-april-2025.pdf | 1325 | 2025-04 | Car | Toyota | Yaris | blue | Driving without Due Care and Attention | None | North bound off slip road to Ashby | North bound off slip road to Ashby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1328 | op-snap---monthly-publication-april-2025.pdf | 1327 | 2025-04 | Car | other | Driving without Reasonable Consideration | None | sugden lane | Sugden Lane | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||||
| 1335 | op-snap---monthly-publication-april-2025.pdf | 1334 | 2025-04 | Car | Suzuki | Swift | Grey | Driving without Reasonable Consideration | None | M6 Southbound Junction 3 heading towards Junction 3A | M6 Southbound Junction 3 heading towards Junction 3A | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1336 | op-snap---monthly-publication-april-2025.pdf | 1335 | 2025-04 | Bus | Van / Lorry | White | Dangerous Driving | None | Near Whitgrave Stafford | Near Whitgrave Stafford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1341 | op-snap---monthly-publication-april-2025.pdf | 1340 | 2025-04 | Car | Audi | A5 | Blue | Using a Mobile Phone Whilst Driving | None | M42 Between 6 and 5 | M42 Between 6 and 5 | Out of Force Area | Out of Force Area | Fixed Penalty | N/A | ||||
| 1363 | op-snap---monthly-publication-april-2025.pdf | 1362 | 2025-04 | Car | Skoda | Blue | Driving without Reasonable Consideration | None | A47 heading towardfs Bromford | A47 heading towardfs Bromford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1365 | op-snap---monthly-publication-april-2025.pdf | 1364 | 2025-04 | Car | BMW | White | Driving without Reasonable Consideration | None | A47 heading towards Bromford | A47 heading towards Bromford | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1366 | op-snap---monthly-publication-april-2025.pdf | 1365 | 2025-04 | Car | Honda | Jazz | Orange | Driving without Reasonable Consideration | None | M42 | M42 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1374 | op-snap---monthly-publication-april-2025.pdf | 1373 | 2025-04 | Pedal Bike | Triumph TR6 | Red | Driving without Reasonable Consideration | None | Station Road , Dorridge | Station Road , Dorridge | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.3807865 | -1.7446497 | |||
| 1376 | op-snap---monthly-publication-april-2025.pdf | 1375 | 2025-04 | Car | Isuzu | Pick Up | Blue | Driving without Reasonable Consideration | None | A49 , Shrewsbury | A49 , Shrewsbury | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.6195535 | -2.0193824 | ||
| 1379 | op-snap---monthly-publication-april-2025.pdf | 1378 | 2025-04 | Car | Skoda | NP | Red | Contravening a Red Traffic Light | None | Minworth traffic island heading towards Walmley | Minworth traffic island heading towards Walmley | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1389 | op-snap---monthly-publication-april-2025.pdf | 1388 | 2025-04 | Car | Toyota | NP | Blue | Driving without Due Care and Attention | None | Junction of A426 and technology drive, rugby | Junction of A426 and technology drive, rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1410 | op-snap---monthly-publication-april-2025.pdf | 1409 | 2025-04 | Car | NP | Silver | Driving without Reasonable Consideration | None | M6 South @ Junction 4a with M42 | M6 South @ Junction 4a with M42 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1421 | op-snap---monthly-publication-april-2025.pdf | 1420 | 2025-04 | Pedal Bike | Peugeot | Boxer | White | Dangerous Driving | None | Barboune road, left side lane | Barboune road, left side lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1439 | op-snap---monthly-publication-april-2025.pdf | 1438 | 2025-04 | Car | BMW | NP | Silver | Using a Mobile Phone Whilst Driving | None | M42. Lane 1 | M42. Lane 1 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4028859 | -1.75593 | ||
| 1458 | op-snap---monthly-publication-april-2025.pdf | 1457 | 2025-04 | Pedal Bike | Volkswagen | Polo | Silver | Driving without Reasonable Consideration | None | Redditch Road towards Redditch | Redditch Road towards Redditch | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1460 | op-snap---monthly-publication-april-2025.pdf | 1459 | 2025-04 | Car | Ford | Fiesta | Blue | Driving without Reasonable Consideration | None | Duggins Lane | Duggins Lane | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.3964189 | -1.5989088 | ||
| 1464 | op-snap---monthly-publication-april-2025.pdf | 1463 | 2025-04 | Car | Audi | NP | Black | Driving without Reasonable Consideration | None | High Street , Albrighton | High Street , Albrighton | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1468 | op-snap---monthly-publication-april-2025.pdf | 1467 | 2025-04 | Car | Toyota | Voxy | Black | Driving without Reasonable Consideration | None | A462 High Street | High Street | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4993921 | -1.8955888 | ||
| 1471 | op-snap---monthly-publication-april-2025.pdf | 1470 | 2025-04 | Car | Audi | NP | Grey | Driving without Reasonable Consideration | None | Kidderminster road A456 | Kidderminster road A456 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4331313 | -2.1702262 | ||
| 1491 | op-snap---monthly-publication-april-2025.pdf | 1490 | 2025-04 | Car | Audi | A6 | Grey | Driving without Reasonable Consideration | None | A444 Stoke | Stoke | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4211905 | -1.4854094 | ||
| 1499 | op-snap---monthly-publication-april-2025.pdf | 1498 | 2025-04 | Pedal Bike | Nissan | Qashqai | White | Driving without Reasonable Consideration | None | Newman Bridge , Worcestershire | Newman Bridge , Worcestershire | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1529 | op-snap---monthly-publication-april-2025.pdf | 1528 | 2025-04 | Car | NP | Blue | Driving without Reasonable Consideration | None | 6 Ways Worcestr | 6 Ways Worcestr | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1533 | op-snap---monthly-publication-april-2025.pdf | 1532 | 2025-04 | Pedal Bike | Hyundai | NP | Grey | Driving without Due Care and Attention | None | Slip road leading from A435 to Ullehall | Slip road leading from A435 to Ullehall | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 1552 | op-snap---monthly-publication-april-2025.pdf | 1551 | 2025-04 | Pedal Bike | Ford | Kuga | White | Driving without Reasonable Consideration | None | Stoke Green | Stoke Green | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | 52.4047116 | -1.4813418 | ||
| 1577 | op-snap---monthly-publication-april-2025.pdf | 1576 | 2025-04 | Car | Skoda | Kodiaq | Black | Driving without Reasonable Consideration | None | Birchfield Road , Redditch | Birchfield Road , Redditch | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1579 | op-snap---monthly-publication-april-2025.pdf | 1578 | 2025-04 | Car | HGV | Red | Driving without Reasonable Consideration | None | M42 South Junction 4 | M42 South Junction 4 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1608 | op-snap---monthly-publication-april-2025.pdf | 1607 | 2025-04 | Pedal Bike | Renault | Kadjar | Silver | Driving without Reasonable Consideration | None | A449 | A449 | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1613 | op-snap---monthly-publication-april-2025.pdf | 1612 | 2025-04 | Pedal Bike | Ford | KUGA | Grey | Driving without Reasonable Consideration | None | Technolgy Drive , Rugby | Technolgy Drive , Rugby | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1623 | op-snap---monthly-publication-april-2025.pdf | 1622 | 2025-04 | Car | SUBARU IMPREZA | Blue | Driving without Due Care and Attention | None | Harewood End | Harewood End | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 1642 | op-snap---monthly-publication-april-2025.pdf | 1641 | 2025-04 | Car | NP | Black | Driving without Reasonable Consideration | None | Eardiston , Tenbury Wells | Eardiston , Tenbury Wells | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | |||||
| 1643 | op-snap---monthly-publication-april-2025.pdf | 1642 | 2025-04 | Car | NP | Driving without Reasonable Consideration | None | A45 heading towards Northhampton | A45 heading towards Northhampton | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||||
| 1645 | op-snap---monthly-publication-april-2025.pdf | 1644 | 2025-04 | Car | Audi | A3 | Silver | Driving without Reasonable Consideration | None | B4103 Sounthbound heading towards Kenilworth | Sounthbound heading towards Kenilworth | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1650 | op-snap---monthly-publication-april-2025.pdf | 1649 | 2025-04 | Car | Ford | FOCUS | Blue | Motor vehicle fail to comply with solid white line road markings | None | A59 Sawley road | Sawley road | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1676 | op-snap---monthly-publication-april-2025.pdf | 1675 | 2025-04 | Car | Ford | Fiesta | Blue | Driving without Reasonable Consideration | None | Stanklyn Lane , Kidderminster | Stanklyn Lane , Kidderminster | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 1677 | op-snap---monthly-publication-april-2025.pdf | 1676 | 2025-04 | Car | Volkswagen | Tigan | White | Driving without Reasonable Consideration | None | Birchley Island Roundabout | Birchley Island Roundabout | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP |
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);