home / opsnap

reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

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'}

404 rows where disposal = "NFA", month = "2025-09" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

  • Volkswagen 44
  • Ford 39
  • BMW 35
  • Audi 33
  • Mercedes-Benz 30
  • Toyota 27
  • Vauxhall 26
  • Land Rover 22
  • Peugeot 12
  • Renault 12
  • Honda 9
  • Nissan 9
  • Seat 9
  • Skoda 9
  • Citroen 5
  • Daf 5
  • Mazda 5
  • Mini 5
  • Porsche 5
  • Suzuki 5
  • Volvo 5
  • Fiat 4
  • Hyundai 4
  • Kia 3
  • Mg 3
  • Dacia 2
  • Iveco 2
  • Jaguar 2
  • Mitsubishi 2
  • Tesla 2
  • …

offence 29

  • Driving without Due Care and Attention 194
  • Contravening a Red Traffic Light 80
  • Misc - Non Traffic Offences 31
  • Using a Mobile Phone Whilst Driving 30
  • Cause unnecessary obstruction by motor vehicle 19
  • Driving without Reasonable Consideration 10
  • Cause vehicle to be left in a dangerous position 5
  • Motor vehicle fail to comply with endorsable sect 5
  • Drive on hard shoulder 4
  • Contravene Lane Closure Red X 3
  • Dangerous Driving 2
  • Motor vehicle fail to comply with a non endorsab 2
  • Motor vehicle fail to comply with solid white line 2
  • Prohibited vehicle in offside lane of motorway 2
  • DCariuvsee o unn hnaercde ssshaoruyl doebrstruction by motor vehicle 1
  • DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
  • Drive / stop / cause to remain at rest a motor veh 1
  • Drive a vehicle other than on the carriageway of a 1
  • Driver not in position to have Proper Control 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Fail to Conform to Cycle Lane 1
  • Fail to display front VRM plate 1
  • MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
  • Motor vehicle fail to accord precedence at a pelic 1
  • Stop a vehicle within pelican pedestrian crossing l 1
  • Use a motor vehicle / trailer in a condition likely t 1
  • Use a vehicle / cycle on a road and contravene a l 1
  • Use on a road a motor vehicle / trailer in such a c 1
  • VRM fails to conform to Regulations 1

council_area 10

  • Birmingham 146
  • Out of Force Area 144
  • Coventry 28
  • Dudley 21
  • Sandwell 20
  • Solihull 18
  • Walsall 10
  • Wolverhampton 9
  • Sutton Coldfield 4
  • Halesowen 2

reporter_transport_mode 1

  • Car · 404 ✖

month 1

  • 2025-09 · 404 ✖

disposal 1

  • NFA · 404 ✖
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
23782 op-snap---monthly-publication-september-2025.pdf   1 2025-09 Car Toyota Yaris Black Contravening a Red Traffic Light None Central Way, Merry Hill Central Way, Merry Hill Dudley Dudley NFA No Offence      
23790 op-snap---monthly-publication-september-2025.pdf   9 2025-09 Car Volkswagen Crafter Grey Driving without Reasonable Consideration None St Peters Driv, Worcester Street Peters Driv, Worcester Out of Force Area Out of Force Area NFA Out of Force      
23796 op-snap---monthly-publication-september-2025.pdf   15 2025-09 Car Fiat 500.. White Contravening a Red Traffic Light None Sheaf Lane Sheaf Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4540536 -1.7819436
23797 op-snap---monthly-publication-september-2025.pdf   16 2025-09 Car Ford Focus Blue Driving without Due Care and Attention None Lugtrout Lane Lugtrout Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4227108 -1.7443257
23798 op-snap---monthly-publication-september-2025.pdf   17 2025-09 Car BMW 3 Blue Driving without Due Care and Attention None Lugtrout Lane Lugtrout Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4227108 -1.7443257
23808 op-snap---monthly-publication-september-2025.pdf   27 2025-09 Car Toyota Prius Black Driving without Due Care and Attention None Gravelly Lane Gravelly Lane Birmingham Birmingham NFA No Independent Evidence Available   52.534608 -1.8379769
23812 op-snap---monthly-publication-september-2025.pdf   31 2025-09 Car Toyota Yaris Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
23816 op-snap---monthly-publication-september-2025.pdf   35 2025-09 Car Audi A3 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4203897 -1.8338574
23823 op-snap---monthly-publication-september-2025.pdf   42 2025-09 Car Audi A3 White Driving without Due Care and Attention None A52 Skegness Skegness Out of Force Area Out of Force Area NFA Out of Force      
23834 op-snap---monthly-publication-september-2025.pdf   53 2025-09 Car Ford Focus Black Using a Mobile Phone Whilst Driving None Sutherland Avenue Sutherland Avenue Sandwell Sandwell NFA No Independent Evidence Available      
23838 op-snap---monthly-publication-september-2025.pdf   57 2025-09 Car Volvo HGV Red Driving without Due Care and Attention None M42? M42? Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.3757082 -1.7893409
23840 op-snap---monthly-publication-september-2025.pdf   59 2025-09 Car Nissan Primastar Grey Driving without Due Care and Attention None A4036 Merry Hill Merry Hill Dudley Dudley NFA Outside of 14 DAYS Late Submission   52.4817646 -2.1113435
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
23842 op-snap---monthly-publication-september-2025.pdf   61 2025-09 Car Renault clio Black Driving without Due Care and Attention None A5 - Staffs A5 - Staffs Out of Force Area Out of Force Area NFA Out of Force   52.6562446 -1.9182118
23845 op-snap---monthly-publication-september-2025.pdf   64 2025-09 Car Renault   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Balkwill Crescent Balkwill Crescent Solihull Solihull NFA No Offence   52.3786268 -1.7420081
23848 op-snap---monthly-publication-september-2025.pdf   67 2025-09 Car Mercedes-Benz   Black Driving without Due Care and Attention None Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
23852 op-snap---monthly-publication-september-2025.pdf   71 2025-09 Car Mercedes-Benz CLA 200 Black Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham NFA No Independent Evidence Available   52.4726661 -1.8769032
23860 op-snap---monthly-publication-september-2025.pdf   79 2025-09 Car Skoda Fabia Grey Driving without Due Care and Attention None Bridge Road at Atlas Mill Road (West Yorkshire) Bridge Road at Atlas Mill Road (West Yorkshire) Out of Force Area Out of Force Area NFA Out of Force      
23865 op-snap---monthly-publication-september-2025.pdf   84 2025-09 Car Audi A3 Black Driving without Reasonable Consideration None M6 J12 M6 J12 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
23866 op-snap---monthly-publication-september-2025.pdf   85 2025-09 Car BMW 520.. Black Driving without Due Care and Attention None Newport Road (Staffs) Newport Road (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
23869 op-snap---monthly-publication-september-2025.pdf   88 2025-09 Car Volkswagen   White Driving without Due Care and Attention None Hednesford Hednesford Out of Force Area Out of Force Area NFA Out of Force   52.6580164 -1.9487512
23875 op-snap---monthly-publication-september-2025.pdf   94 2025-09 Car Ford Kuga Black Misc - Non Traffic Offences None Tachbrook Rd, Leamington Spa Tachbrook Road, Leamington Spa Out of Force Area Out of Force Area NFA Out of Force      
23878 op-snap---monthly-publication-september-2025.pdf   97 2025-09 Car BMW 330.. Black 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
23879 op-snap---monthly-publication-september-2025.pdf   98 2025-09 Car Renault Scenic Blue Misc - Non Traffic Offences None Hertford Way . Balkwill Crescent Hertford Way . Balkwill Crescent Solihull Solihull NFA No Offence      
23880 op-snap---monthly-publication-september-2025.pdf   99 2025-09 Car Ford Transit White Driving without Due Care and Attention None Eardiston, towards Tenbury Wells, West Mercia Eardiston, towards Tenbury Wells, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
23884 op-snap---monthly-publication-september-2025.pdf   103 2025-09 Car   Polestar Black Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull NFA No Offence   52.4490463 -1.7296897
23885 op-snap---monthly-publication-september-2025.pdf   104 2025-09 Car Vauxhall Corsa White Driving without Due Care and Attention None A42 A42 Out of Force Area Out of Force Area NFA Out of Force      
23888 op-snap---monthly-publication-september-2025.pdf   107 2025-09 Car       Driving without Due Care and Attention None Princess Alice Princess Alice Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5499257 -1.859279
23891 op-snap---monthly-publication-september-2025.pdf   110 2025-09 Car Nissan Qashqai Red Driving without Due Care and Attention None Heathfield Road Heathfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.5905365 -1.8453418
23892 op-snap---monthly-publication-september-2025.pdf   111 2025-09 Car Peugeot 208.. Blue Using a Mobile Phone Whilst Driving None University Locks (Outside Co-Op) University Locks (Outside Co-Op) Birmingham Birmingham NFA No Independent Evidence Available      
23895 op-snap---monthly-publication-september-2025.pdf   114 2025-09 Car Daf Lorry Red Driving without Due Care and Attention None M42 M42 Solihull Solihull NFA No Independent Evidence Available      
23897 op-snap---monthly-publication-september-2025.pdf   116 2025-09 Car Land Rover Evoque Black Driving without Due Care and Attention None M6-M1 M6-M1 Out of Force Area Out of Force Area NFA Out of Force   52.5223936 -1.8804806
23901 op-snap---monthly-publication-september-2025.pdf   120 2025-09 Car Toyota Auris Blue Contravening a Red Traffic Light None Selly Oak Road Selly Oak Road Birmingham Birmingham NFA No Offence   52.4263875 -1.9397954
23902 op-snap---monthly-publication-september-2025.pdf   121 2025-09 Car Mercedes-Benz CLS Silver Using a Mobile Phone Whilst Driving None Rickman Drive Rickman Drive Birmingham Birmingham NFA No Independent Evidence Available   52.4701606 -1.9013018
23905 op-snap---monthly-publication-september-2025.pdf   124 2025-09 Car BMW   Silver Driving without Due Care and Attention None Tamworth Road Tamworth Road Coventry Coventry NFA No Offence   52.4380313 -1.5339558
23907 op-snap---monthly-publication-september-2025.pdf   126 2025-09 Car Porsche NP Silver Driving without Due Care and Attention None Oxhill to Banbury Oxhill to Banbury Out of Force Area Out of Force Area NFA Out of Force      
23912 op-snap---monthly-publication-september-2025.pdf   131 2025-09 Car Mitsubishi   Black Driving without Due Care and Attention None Over Causeway Over Causeway Out of Force Area Out of Force Area NFA Out of Force      
23923 op-snap---monthly-publication-september-2025.pdf   142 2025-09 Car Vauxhall Mokka White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5083238 -1.8332287
23926 op-snap---monthly-publication-september-2025.pdf   145 2025-09 Car Toyota Yaris Black Using a Mobile Phone Whilst Driving None M6 M6 Birmingham Birmingham NFA No Offence      
23927 op-snap---monthly-publication-september-2025.pdf   146 2025-09 Car Mercedes-Benz A200 Black Driving without Due Care and Attention None Bradley Road (Donnington) Bradley Road (Donnington) Out of Force Area Out of Force Area NFA Out of Force      
23931 op-snap---monthly-publication-september-2025.pdf   150 2025-09 Car BMW 118.. White Driving without Due Care and Attention None Matalan roundabout (Redditch) Matalan roundabout (Redditch) Out of Force Area Out of Force Area NFA Out of Force      
23938 op-snap---monthly-publication-september-2025.pdf   157 2025-09 Car Volvo XC60 Silver Driving without Due Care and Attention None A444 A444 Out of Force Area Out of Force Area NFA Out of Force      
23940 op-snap---monthly-publication-september-2025.pdf   159 2025-09 Car Skoda Yeti Black Driving without Due Care and Attention None A5 Wodcote Roundabout Wodcote Roundabout Out of Force Area Out of Force Area NFA Out of Force      
23944 op-snap---monthly-publication-september-2025.pdf   163 2025-09 Car BMW 120d Grey Cause vehicle to be left in a dangerous position None May Lane May Lane Out of Force Area Out of Force Area NFA Out of Force   52.4197342 -1.8839613
23949 op-snap---monthly-publication-september-2025.pdf   168 2025-09 Car Ford Transit White Driving without Due Care and Attention None M1 M1 Out of Force Area Out of Force Area NFA Out of Force      
23953 op-snap---monthly-publication-september-2025.pdf   172 2025-09 Car Audi RS4 Grey Driving without Due Care and Attention None A34 Cannock Cannock Out of Force Area Out of Force Area NFA Out of Force      
23954 op-snap---monthly-publication-september-2025.pdf   173 2025-09 Car Volkswagen Tiguan Grey Contravening a Red Traffic Light No Insurance Six Ways, Lozells Six Ways, Lozells Birmingham Birmingham NFA No Independent Evidence Available   52.5022359 -1.8984899
23957 op-snap---monthly-publication-september-2025.pdf   176 2025-09 Car Land Rover Evoque White Driving without Due Care and Attention None Bradford Road Bradford Road Birmingham Birmingham NFA No Offence   52.5024148 -1.7961753
23960 op-snap---monthly-publication-september-2025.pdf   179 2025-09 Car Mg 3 Trophy White Driving without Due Care and Attention None B4173 B4173 Birmingham Birmingham NFA Misc Inc Crimes   52.4496153 -1.8646204
23962 op-snap---monthly-publication-september-2025.pdf   181 2025-09 Car Volkswagen Passatt Grey Driving without Due Care and Attention None A590 A590 Out of Force Area Out of Force Area NFA Out of Force      
23966 op-snap---monthly-publication-september-2025.pdf   185 2025-09 Car   NP   Driving without Due Care and Attention None Out of force - Telford Out of force - Telford Out of Force Area Out of Force Area NFA Out of Force      
23968 op-snap---monthly-publication-september-2025.pdf   187 2025-09 Car Vauxhall Zafira Blue Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry NFA No Offence   52.4070602 -1.4732469
23971 op-snap---monthly-publication-september-2025.pdf   190 2025-09 Car Volvo XC60 Grey Driving without Due Care and Attention None Not detailed. Not detailed Out of Force Area Out of Force Area NFA Out of Force      
23972 op-snap---monthly-publication-september-2025.pdf   191 2025-09 Car Volkswagen Caddy Blue Driving without Due Care and Attention None M40 near Warwick M40 near Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3755033 -1.6086853
23973 op-snap---monthly-publication-september-2025.pdf   192 2025-09 Car Vauxhall Insignia Silver Driving without Due Care and Attention None M6 SB J7 M6 Southbound J7 Birmingham Birmingham NFA No Offence   52.676119 -2.0858425
23975 op-snap---monthly-publication-september-2025.pdf   194 2025-09 Car Vauxhall Astra Silver Driving without Due Care and Attention None George Street Ringway, Bedworth George Street Ringway, Bedworth Out of Force Area Out of Force Area NFA Out of Force      
23977 op-snap---monthly-publication-september-2025.pdf   196 2025-09 Car Peugeot Boxer White Driving without Due Care and Attention None Griff Roundabout, Nuneaton Griff Roundabout, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
23979 op-snap---monthly-publication-september-2025.pdf   198 2025-09 Car Toyota Yaris Black Driving without Reasonable Consideration None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA No Offence   52.4650893 -1.8425008
23985 op-snap---monthly-publication-september-2025.pdf   204 2025-09 Car Ford Fiesta Blue Driving without Due Care and Attention None M54 WB J3-6 M54 Wb J3-6 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
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      
23991 op-snap---monthly-publication-september-2025.pdf   210 2025-09 Car Seat Leon Black Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham NFA No Offence   52.4709298 -1.8722585
24000 op-snap---monthly-publication-september-2025.pdf   219 2025-09 Car Seat Ibiza Blue Use a motor vehicle / trailer in a condition likely t o cause danger of injuryNone A435 Redditch Redditch Out of Force Area Out of Force Area NFA Out of Force   52.4072158 -1.9277937
24001 op-snap---monthly-publication-september-2025.pdf   220 2025-09 Car Audi A6 Grey Driving without Due Care and Attention None Turves Green, Longbridge Turves Green, Longbridge Birmingham Birmingham NFA No Offence   52.3964205 -1.9697415
24002 op-snap---monthly-publication-september-2025.pdf   221 2025-09 Car Kia Xceed Silver Driving a vehicle wholly or partly on a footpath None Oxford Road Oxford Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4456323 -1.8858352
24004 op-snap---monthly-publication-september-2025.pdf   223 2025-09 Car Mercedes-Benz A200 Purple Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
24008 op-snap---monthly-publication-september-2025.pdf   227 2025-09 Car BMW 118i Blue Driving without Due Care and Attention None M6 SB J10 M6 Southbound J10 Wolverhampton Wolverhampton NFA No Offence   52.676119 -2.0858425
24014 op-snap---monthly-publication-september-2025.pdf   233 2025-09 Car Land Rover Sport Grey Drive on hard shoulder None M1 Jn 23-22 Southbound M1 Junction 23-22 Southbound Out of Force Area Out of Force Area NFA Out of Force      
24017 op-snap---monthly-publication-september-2025.pdf   236 2025-09 Car Land Rover Range Rover Black Driving without Due Care and Attention None Neachells Lane Neachells Lane Wolverhampton Wolverhampton NFA No Offence   52.597459 -2.0791894
24027 op-snap---monthly-publication-september-2025.pdf   246 2025-09 Car Audi A4.. White Contravening a Red Traffic Light None Diglis Road (Worcester) Diglis Road (Worcester) Out of Force Area Out of Force Area NFA Out of Force      
24028 op-snap---monthly-publication-september-2025.pdf   247 2025-09 Car Audi A3 Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham NFA Not in Public Interest   52.5458699 -1.9304484
24033 op-snap---monthly-publication-september-2025.pdf   252 2025-09 Car Vauxhall MOKKA Black Driving without Due Care and Attention None Wolverton Road Wolverton Road Birmingham Birmingham NFA Out of Force   52.3900767 -1.9976014
24036 op-snap---monthly-publication-september-2025.pdf   255 2025-09 Car Vauxhall corsa Black Contravening a Red Traffic Light None Walmley Road Walmley Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5405351 -1.8002219
24038 op-snap---monthly-publication-september-2025.pdf   257 2025-09 Car Land Rover Defender Black Using a Mobile Phone Whilst Driving None M6?? M6?? Birmingham Birmingham NFA No Independent Evidence Available   52.5264754 -1.8895798
24040 op-snap---monthly-publication-september-2025.pdf   259 2025-09 Car Audi     Driving without Due Care and Attention None M54 M54 Out of Force Area Out of Force Area NFA Not in Public Interest      
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      
24044 op-snap---monthly-publication-september-2025.pdf   263 2025-09 Car BMW 520d Brown Driving without Due Care and Attention None A518 Stafford Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6014882 -2.1310443
24047 op-snap---monthly-publication-september-2025.pdf   266 2025-09 Car Renault Trafic White Driving without Due Care and Attention None Christchurch Way, Stone Christchurch Way, Stone Out of Force Area Out of Force Area NFA Out of Force      
24052 op-snap---monthly-publication-september-2025.pdf   271 2025-09 Car Peugeot Traveller Black Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
24053 op-snap---monthly-publication-september-2025.pdf   272 2025-09 Car     Silver Contravening a Red Traffic Light None M54 J4 Shrewsbury M54 J4 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
24055 op-snap---monthly-publication-september-2025.pdf   274 2025-09 Car     Brown Driving without Due Care and Attention None Town Walls Town Walls Out of Force Area Out of Force Area NFA Out of Force      
24058 op-snap---monthly-publication-september-2025.pdf   277 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA No Offence      
24061 op-snap---monthly-publication-september-2025.pdf   280 2025-09 Car Porsche Cayenne Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA No Offence      
24068 op-snap---monthly-publication-september-2025.pdf   287 2025-09 Car Mini One Blue Driving without Due Care and Attention None Barn Lane Barn Lane Solihull Solihull NFA No Offence   52.449441 -1.8026941
24074 op-snap---monthly-publication-september-2025.pdf   293 2025-09 Car Ford Fiesta Brown Use on a road a motor vehicle / trailer in such a c ondition it caused / wasN lioknleey to cause danger A5 Quarry HIll Quarry HIll Out of Force Area Out of Force Area NFA Out of Force      
24075 op-snap---monthly-publication-september-2025.pdf   294 2025-09 Car Land Rover Range Black Driving without Reasonable Consideration None Hereford Ring Road Hereford Ring Road Out of Force Area Out of Force Area NFA Out of Force      
24076 op-snap---monthly-publication-september-2025.pdf   295 2025-09 Car Ford Focus Red Contravening a Red Traffic Light None Foundry Lane Foundry Lane Birmingham Birmingham NFA No VRM      
24080 op-snap---monthly-publication-september-2025.pdf   299 2025-09 Car   Triumph Tiger White Fail to Conform to Cycle Lane None Aylestone Hill, Hereford Aylestone Hill, Hereford Out of Force Area Out of Force Area NFA Out of Force      
24084 op-snap---monthly-publication-september-2025.pdf   303 2025-09 Car Ford Transit Grey Driving without Due Care and Attention None M6 NB J4-4A M6 Northbound J4-4A Coventry Coventry NFA Not in Public Interest   52.6912652 -2.1043715
24085 op-snap---monthly-publication-september-2025.pdf   304 2025-09 Car Audi Q5 Silver Driving without Due Care and Attention None Hollybank Road Hollybank Road Birmingham Birmingham NFA No VRM   52.4236341 -1.8787502
24089 op-snap---monthly-publication-september-2025.pdf   308 2025-09 Car Suzuki Vitara Black Contravening a Red Traffic Light None Roman Road Hereford Roman Road Hereford Out of Force Area Out of Force Area NFA Out of Force      
24098 op-snap---monthly-publication-september-2025.pdf   317 2025-09 Car Ford Transit White Using a Mobile Phone Whilst Driving None High Street Bloxwich High Street Bloxwich Walsall Walsall NFA No Independent Evidence Available   52.6124215 -2.0022243
24101 op-snap---monthly-publication-september-2025.pdf   320 2025-09 Car BMW M4 Black Driving without Due Care and Attention None Aymestrey Aymestrey Out of Force Area Out of Force Area NFA Out of Force      
24103 op-snap---monthly-publication-september-2025.pdf   322 2025-09 Car Renault Kangoo Blue Driving without Due Care and Attention None A449 (Comhampton West Mercia) A449 (Comhampton West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
24104 op-snap---monthly-publication-september-2025.pdf   323 2025-09 Car Citroen C3.. Grey Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
24110 op-snap---monthly-publication-september-2025.pdf   329 2025-09 Car Volkswagen Tranporter White Driving without Due Care and Attention None Wilnecote Lane Wilnecote Lane Out of Force Area Out of Force Area NFA Out of Force      
24112 op-snap---monthly-publication-september-2025.pdf   331 2025-09 Car Suzuki Alto Pink Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA No Offence   52.505832 -1.92002
24123 op-snap---monthly-publication-september-2025.pdf   342 2025-09 Car Nissan NV400 White Driving without Due Care and Attention None Birmingham Road (Shenstone) Staffs Birmingham Road (Shenstone) Staffs Out of Force Area Out of Force Area NFA Out of Force      
24124 op-snap---monthly-publication-september-2025.pdf   343 2025-09 Car   UNKNOWN   Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
24125 op-snap---monthly-publication-september-2025.pdf   344 2025-09 Car Volkswagen Amarok Silver Drive / stop / cause to remain at rest a motor veh icle drawing a trailer in Nooffnsiede lane of a motorway M5 Strensham M5 Strensham Out of Force Area Out of Force Area NFA Out of Force   52.4527853 -1.8925015
24126 op-snap---monthly-publication-september-2025.pdf   345 2025-09 Car Tesla Model 3 White Driving without Due Care and Attention None Hurlfield Road Hurlfield Road Out of Force Area Out of Force Area NFA Out of Force      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);