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'}
600 rows where disposal = "NFA", reporter_transport_mode = "Car" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 30
- Driving without Due Care and Attention 230
- Contravening a Red Traffic Light 118
- Driving without Reasonable Consideration 65
- Using a Mobile Phone Whilst Driving 42
- Misc - Non Traffic Offences 33
- Cause vehicle to be left in a dangerous position 27
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 22
- Stop a vehicle on pedestrian crossing 10
- Stop a vehicle within pelican pedestrian crossing limits 10
- Drive on hard shoulder 7
- Contravene Lane Closure Red X 4
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Motor vehicle fail to comply with solid white line road markings 3
- No Insurance 3
- Driver not in position to have Proper Control 2
- Fail to Conform to Cycle Lane 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- No Seat Belt 2
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 2
- Dangerous Driving 1
- Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
- Fail to display front VRM plate 1
- Fail to display rear VRM plate 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 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
- Use on a road a motor vehicle / trailer in such a c 1
- driving without due care/attention 1
council_area 18
- Birmingham 223
- Out of Force Area 178
- Coventry 43
- Sandwell 37
- Dudley 30
- Walsall 25
- Wolverhampton 21
- Solihull 19
- Sutton Coldfield 11
- Area 4
- Ebirmingham 1
- Gsautteto N Coldfield 1
- Halesowen 1
- Oguret Eonf Force Area 1
- Optuotn Of Force Area 1
- So Tuotp Of Force Area 1
- Sowutetor Nq Cueoeldnf Iseltdreet 1
- Ysandwell 1
month 14
vehicle_make 1
- Ford · 600 ✖
reporter_transport_mode 1
- Car · 600 ✖
disposal 1
- NFA · 600 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7259 | op-snap---monthly-publication-february-2026.pdf | 6 | 2026-02 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | A46 off force | A46 off force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7546 | op-snap---monthly-publication-february-2026.pdf | 293 | 2026-02 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Diss Aldi Carpark (Norfolk) | Diss Aldi Carpark (Norfolk) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7567 | op-snap---monthly-publication-february-2026.pdf | 314 | 2026-02 | Car | Ford | Transit | Grey | Driving without Due Care and Attention | None | Friary Road | Friary Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5162814 | -1.9395798 | ||
| 7617 | op-snap---monthly-publication-february-2026.pdf | 364 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | The Embankment | The Embankment | Dudley | Dudley | NFA | No Offence | 52.4826167 | -2.1144546 | ||
| 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 | ||||
| 7640 | op-snap---monthly-publication-february-2026.pdf | 387 | 2026-02 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Cheltenham Road, Bishop's Cleve | Cheltenham Road, Bishop's Cleve | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7690 | op-snap---monthly-publication-february-2026.pdf | 437 | 2026-02 | Car | Ford | KA | Silver | Driving without Due Care and Attention | None | Huffley Lane | Huffley Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7775 | op-snap---monthly-publication-february-2026.pdf | 522 | 2026-02 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Watling Street | Watling Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6562907 | -1.9111505 | ||
| 7864 | op-snap---monthly-publication-february-2026.pdf | 611 | 2026-02 | Car | Ford | Fiesta | Silver | Contravening a Red Traffic Light | None | Appleby Magna | Appleby Magna | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7915 | op-snap---monthly-publication-february-2026.pdf | 662 | 2026-02 | Car | Ford | Transit | white | Driving without Due Care and Attention | None | A5 near to Shrewsbury | A5 near to Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8012 | op-snap---monthly-publication-february-2026.pdf | 759 | 2026-02 | Car | Ford | Transit Connect | Black | Driving without Due Care and Attention | No Insurance | Fengate Roundabout, Peterborough | Fengate Roundabout, Peterborough | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8105 | op-snap---monthly-publication-february-2026.pdf | 852 | 2026-02 | Car | Ford | Transit | Silver | Misc - Non Traffic Offences | None | Wolverley Crescent, Lion Farm | Wolverley Crescent, Lion Farm | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4919463 | -2.0292691 | ||
| 8164 | op-snap---monthly-publication-february-2026.pdf | 911 | 2026-02 | Car | Ford | Fiesta | Black | Stop a vehicle on pedestrian crossing | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Offence | 52.502683 | -1.9033516 | ||
| 8189 | op-snap---monthly-publication-february-2026.pdf | 936 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | A1, Newcastle | A1, Newcastle | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5203232 | -1.7785979 | ||
| 8214 | op-snap---monthly-publication-february-2026.pdf | 961 | 2026-02 | Car | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Silverthorne Lane | Silverthorne Lane | Dudley | Dudley | NFA | No Offence | ||||
| 8248 | op-snap---monthly-publication-february-2026.pdf | 995 | 2026-02 | Car | Ford | Kuga | Black | Contravening a Red Traffic Light | None | B4632 | B4632 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3994858 | -1.4923603 | ||
| 8273 | op-snap---monthly-publication-february-2026.pdf | 1020 | 2026-02 | Car | Ford | Mondeo | White | Misc - Non Traffic Offences | None | Manor Way Halesowen | Manor Way Halesowen | Dudley | Dudley | NFA | Not in Public Interest | 52.443598 | -2.0464887 | ||
| 8311 | op-snap---monthly-publication-february-2026.pdf | 1058 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Chase Road | Chase Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6148036 | -2.0138379 | ||
| 8322 | op-snap---monthly-publication-february-2026.pdf | 1069 | 2026-02 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Wilderspool Causeway | Wilderspool Causeway | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8425 | op-snap---monthly-publication-february-2026.pdf | 1172 | 2026-02 | Car | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Europa Way (Warwickshire) | Europa Way (Warwickshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8428 | op-snap---monthly-publication-february-2026.pdf | 1175 | 2026-02 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | No Offence | 52.3778812 | -1.7427424 | ||
| 8455 | op-snap---monthly-publication-february-2026.pdf | 1202 | 2026-02 | Car | Ford | Transit | White | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | NFA | No Offence | ||||
| 8465 | op-snap---monthly-publication-february-2026.pdf | 1212 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M1, Brinsworth | M1, Brinsworth | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8473 | op-snap---monthly-publication-february-2026.pdf | 1220 | 2026-02 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Greenmoor Road | Greenmoor Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8578 | op-snap---monthly-publication-february-2026.pdf | 1325 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Bridlewood | Bridlewood | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5756112 | -1.8865562 | ||
| 8584 | op-snap---monthly-publication-february-2026.pdf | 1331 | 2026-02 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | Coldhams Lane, Cambridgeshire | Coldhams Lane, Cambridgeshire | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8587 | op-snap---monthly-publication-february-2026.pdf | 1334 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Whitchurch Road, Whitchurch | Whitchurch Road, Whitchurch | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8595 | op-snap---monthly-publication-february-2026.pdf | 1342 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | M5 J4 | M5 J4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | |||||
| 8676 | op-snap---monthly-publication-february-2026.pdf | 1423 | 2026-02 | Car | Ford | Transit | Black | Driving without Due Care and Attention | None | Throne Road | Throne Road | Sandwell | Sandwell | NFA | No Offence | 52.4875572 | -2.0284052 | ||
| 8882 | op-snap---monthly-publication-february-2026.pdf | 1629 | 2026-02 | Car | Ford | mondeo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4957234 | -1.8538937 | ||
| 10637 | op-snap---monthly-publication-january-2026.pdf | 98 | 2026-01 | Car | Ford | Ranger | White | Driving without Due Care and Attention | None | Collector Road | Collector Road | Birmingham | Birmingham | NFA | No Offence | 52.5139393 | -1.7600186 | ||
| 10654 | op-snap---monthly-publication-january-2026.pdf | 115 | 2026-01 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | Spring Bank, Hull | Spring Bank, Hull | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10668 | op-snap---monthly-publication-january-2026.pdf | 129 | 2026-01 | Car | Ford | Ranger | Black | Driving without Due Care and Attention | None | Royal Road | Royal Road | Birmingham | Birmingham | NFA | No Offence | 52.5609478 | -1.8170275 | ||
| 10679 | op-snap---monthly-publication-january-2026.pdf | 140 | 2026-01 | Car | Ford | Focus | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 10739 | op-snap---monthly-publication-january-2026.pdf | 200 | 2026-01 | Car | Ford | Fiesta | Red | Using a Mobile Phone Whilst Driving | None | Boardsley Middleway | Boardsley Middleway | Birmingham | Birmingham | NFA | No VRM | ||||
| 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 | ||||
| 10814 | op-snap---monthly-publication-january-2026.pdf | 275 | 2026-01 | Car | Ford | Ranger | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road, Handsworth | Island Road, Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.509612 | -1.9513666 | ||
| 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 | ||
| 10885 | op-snap---monthly-publication-january-2026.pdf | 346 | 2026-01 | Car | Ford | Galaxy | Blue | Driving without Due Care and Attention | None | Magna Park | Magna Park | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 10965 | op-snap---monthly-publication-january-2026.pdf | 426 | 2026-01 | Car | Ford | Fiesta | Grey | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4929304 | -1.8229092 | ||
| 11138 | op-snap---monthly-publication-january-2026.pdf | 599 | 2026-01 | Car | Ford | Ka | Red | Misc - Non Traffic Offences | None | McKean Road, Oldbury | Mc Kean Road, Oldbury | Sandwell | Sandwell | NFA | No Offence | 52.5077405 | -2.0124813 | ||
| 11144 | op-snap---monthly-publication-january-2026.pdf | 605 | 2026-01 | Car | Ford | Ecosport | Yellow | Driving without Due Care and Attention | None | A4117 Shaws Lane Warwick | Shaws Lane Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11214 | op-snap---monthly-publication-january-2026.pdf | 675 | 2026-01 | Car | Ford | Focus | Red | Contravening a Red Traffic Light | None | Telford Town Centre | Telford Town Centre | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11276 | op-snap---monthly-publication-january-2026.pdf | 737 | 2026-01 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4860376 | -1.9095854 | ||
| 11316 | op-snap---monthly-publication-january-2026.pdf | 777 | 2026-01 | Car | Ford | Transit 350 | White | Using a Mobile Phone Whilst Driving | None | Graham St | Graham Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4843802 | -1.9108415 | ||
| 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 | ||
| 11655 | op-snap---monthly-publication-january-2026.pdf | 1116 | 2026-01 | Car | Ford | Ka | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Vauxhall Road | Vauxhall Road | Birmingham | Birmingham | NFA | No Offence | 52.4834623 | -1.8796522 | ||
| 11666 | op-snap---monthly-publication-january-2026.pdf | 1127 | 2026-01 | Car | Ford | Transit | White | Misc - Non Traffic Offences | None | Catherine Close Bromsgrove (West Mercia) | Catherine Close Bromsgrove (West Mercia) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11714 | op-snap---monthly-publication-january-2026.pdf | 1175 | 2026-01 | Car | Ford | focus | Black | No Insurance | No vehicle excise licence | Slade Road | Slade Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.591066 | -1.8027604 | ||
| 11727 | op-snap---monthly-publication-january-2026.pdf | 1188 | 2026-01 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | NFA | No Offence | 52.5038363 | -1.8432663 | ||
| 11906 | op-snap---monthly-publication-january-2026.pdf | 1367 | 2026-01 | Car | Ford | galaxy | Silver | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | ||||
| 11922 | op-snap---monthly-publication-january-2026.pdf | 1383 | 2026-01 | Car | Ford | Transit | Yellow | Driving without Due Care and Attention | None | Satfford Road | Satfford Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 11941 | op-snap---monthly-publication-january-2026.pdf | 1402 | 2026-01 | Car | Ford | focus | Grey | Misc - Non Traffic Offences | None | eddish road | Eddish Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4833672 | -1.7871439 | ||
| 4043 | op-snap---monthly-publication-december-2025.pdf | 171 | 2025-12 | Car | Ford | White | Using a Mobile Phone Whilst Driving | None | Leamington Road | Leamington Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3921304 | -1.5156601 | |||
| 4084 | op-snap---monthly-publication-december-2025.pdf | 212 | 2025-12 | Car | Ford | Focus | Grey | Contravening a Red Traffic Light | None | Brockmoor High St | Brockmoor High Street | Dudley | Dudley | NFA | No Independent Evidence Available | ||||
| 4098 | op-snap---monthly-publication-december-2025.pdf | 226 | 2025-12 | Car | Ford | Ranger | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 4167 | op-snap---monthly-publication-december-2025.pdf | 295 | 2025-12 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Bordsley Circus Roundabout | Bordsley Circus Roundabout | Birmingham | Birmingham | NFA | No Offence | ||||
| 4171 | op-snap---monthly-publication-december-2025.pdf | 299 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.502683 | -1.9033516 | ||
| 4173 | op-snap---monthly-publication-december-2025.pdf | 301 | 2025-12 | Car | Ford | Transit | Blue | Misc - Non Traffic Offences | None | Wednesbury Oak Road | Wednesbury Oak Road | Sandwell | Sandwell | NFA | No Offence | 52.5461405 | -2.0536516 | ||
| 4181 | op-snap---monthly-publication-december-2025.pdf | 309 | 2025-12 | Car | Ford | Transit | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | A46 Warwick Road | Warwick Road | Coventry | Coventry | NFA | No VRM | 52.401916 | -1.5154953 | ||
| 4203 | op-snap---monthly-publication-december-2025.pdf | 331 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heronswood Road | Heronswood Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3873141 | -2.0016866 | ||
| 4316 | op-snap---monthly-publication-december-2025.pdf | 444 | 2025-12 | Car | Ford | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4877352 | -1.9494469 | ||||
| 4480 | op-snap---monthly-publication-december-2025.pdf | 608 | 2025-12 | Car | Ford | Fiesta | Blue | Contravening a Red Traffic Light | None | Ring Road Wolves | Ring Road Wolves | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 4718 | op-snap---monthly-publication-december-2025.pdf | 846 | 2025-12 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | A41 | A41 | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 4772 | op-snap---monthly-publication-december-2025.pdf | 900 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4804926 | -1.8563658 | ||
| 4807 | op-snap---monthly-publication-december-2025.pdf | 935 | 2025-12 | Car | Ford | Cmax | Blue | Driving without Due Care and Attention | None | Oakmoor Road | Oakmoor Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.4485736 | -1.4819358 | ||
| 4831 | op-snap---monthly-publication-december-2025.pdf | 959 | 2025-12 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | John Street Brierley Hill | John Street Brierley Hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4875113 | -2.1217558 | ||
| 4845 | op-snap---monthly-publication-december-2025.pdf | 973 | 2025-12 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Perry barr | Perry barr | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.516903 | -1.9012399 | ||
| 4849 | op-snap---monthly-publication-december-2025.pdf | 977 | 2025-12 | Car | Ford | Fiesta | Red | Driving without Due Care and Attention | None | Ring Road, Kidderminster | Ring Road, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4851 | op-snap---monthly-publication-december-2025.pdf | 979 | 2025-12 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Ledbury | Ledbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5415939 | -1.7925369 | ||
| 4892 | op-snap---monthly-publication-december-2025.pdf | 1020 | 2025-12 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | St George's Road, Telford | Street George's Road, Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4895 | op-snap---monthly-publication-december-2025.pdf | 1023 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | No VRM | 52.4235908 | -1.5226276 | ||
| 4896 | op-snap---monthly-publication-december-2025.pdf | 1024 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4899 | op-snap---monthly-publication-december-2025.pdf | 1027 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4902 | op-snap---monthly-publication-december-2025.pdf | 1030 | 2025-12 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Radford Road | Radford Road | Coventry | Coventry | NFA | Duplicate Submission | 52.4235908 | -1.5226276 | ||
| 4931 | op-snap---monthly-publication-december-2025.pdf | 1059 | 2025-12 | Car | Ford | Fiesta | Black | Using a Mobile Phone Whilst Driving | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 4996 | op-snap---monthly-publication-december-2025.pdf | 1124 | 2025-12 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | A5 Shrewsbury | Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6195535 | -2.0193824 | ||
| 5003 | op-snap---monthly-publication-december-2025.pdf | 1131 | 2025-12 | Car | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath | Washwood Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4957234 | -1.8538937 | ||
| 5048 | op-snap---monthly-publication-december-2025.pdf | 1176 | 2025-12 | Car | Ford | Fiesta | White | Driving without Due Care and Attention | None | Stafford Road | Stafford Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.5039962 | -1.9310883 | ||
| 5051 | op-snap---monthly-publication-december-2025.pdf | 1179 | 2025-12 | Car | Ford | Focus | Black | Driving without Due Care and Attention | None | A444 Jimmy Hill Way | Jimmy Hill Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4214017 | -1.4870278 | ||
| 5053 | op-snap---monthly-publication-december-2025.pdf | 1181 | 2025-12 | Car | Ford | Kuga | Grey | 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 | ||
| 5061 | op-snap---monthly-publication-december-2025.pdf | 1189 | 2025-12 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | M25 towards Milton Keynes | M25 towards Milton Keynes | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 5082 | op-snap---monthly-publication-december-2025.pdf | 1210 | 2025-12 | Car | Ford | Fiesta | Silver | Stop a vehicle on pedestrian crossing | None | UK | Uk | Out of Force Area | Out of Force Area | NFA | No Independent Evidence Available | 52.5019896 | -2.0209184 | ||
| 20462 | op-snap---monthly-publication-november-2025.pdf | 4 | 2025-11 | Car | Ford | Focus | Blue | Driving without Due Care and Attention | None | M6 NB 1 to 2 | M6 Northbound 1 to 2 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20503 | op-snap---monthly-publication-november-2025.pdf | 45 | 2025-11 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Junction 11 Staffs | Junction 11 Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20554 | op-snap---monthly-publication-november-2025.pdf | 96 | 2025-11 | Car | Ford | Kuga | Silver | Driving without Due Care and Attention | None | Clough Road. (Hull) | Clough Road. (Hull) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 20678 | op-snap---monthly-publication-november-2025.pdf | 220 | 2025-11 | Car | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | None | Bramah Way Tipton | Bramah Way Tipton | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5315656 | -2.0388495 | ||
| 20708 | op-snap---monthly-publication-november-2025.pdf | 250 | 2025-11 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4391028 | -1.893289 | ||
| 20739 | op-snap---monthly-publication-november-2025.pdf | 281 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Oxhill Road Handsworth | Oxhill Road Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.513857 | -1.9367367 | ||
| 20753 | op-snap---monthly-publication-november-2025.pdf | 295 | 2025-11 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Skidmore Road | Skidmore Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 20795 | op-snap---monthly-publication-november-2025.pdf | 337 | 2025-11 | Car | Ford | Ranger | Blue | Driving without Due Care and Attention | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5274116 | -1.9287273 | ||
| 20847 | op-snap---monthly-publication-november-2025.pdf | 389 | 2025-11 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | A452 | A452 | Birmingham | Birmingham | NFA | No Offence | ||||
| 20862 | op-snap---monthly-publication-november-2025.pdf | 404 | 2025-11 | Car | Ford | cmax | Black | Misc - Non Traffic Offences | None | gilpin close | Gilpin Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4990396 | -1.8229018 | ||
| 20953 | op-snap---monthly-publication-november-2025.pdf | 495 | 2025-11 | Car | Ford | Focus | Grey | Driving without Due Care and Attention | None | Malin Streett | Malin Streett | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 20957 | op-snap---monthly-publication-november-2025.pdf | 499 | 2025-11 | Car | Ford | ranger | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21062 | op-snap---monthly-publication-november-2025.pdf | 604 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21212 | op-snap---monthly-publication-november-2025.pdf | 754 | 2025-11 | Car | Ford | Transit | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bryanston Road | Bryanston Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4251326 | -1.8006633 | ||
| 21311 | op-snap---monthly-publication-november-2025.pdf | 853 | 2025-11 | Car | Ford | toureno | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 21398 | op-snap---monthly-publication-november-2025.pdf | 940 | 2025-11 | Car | Ford | explorer | Blue | Misc - Non Traffic Offences | None | titford road | Titford Road | Birmingham | Birmingham | 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);