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

276 rows where disposal = "NFA", month = "2026-02" 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

  • Ford 31
  • Mercedes-Benz 27
  • Audi 20
  • Toyota 20
  • Volkswagen 19
  • BMW 17
  • Peugeot 16
  • Land Rover 13
  • Nissan 12
  • Vauxhall 10
  • Renault 9
  • Skoda 8
  • Kia 7
  • Seat 6
  • Hyundai 5
  • Alfa Romeo 4
  • Fiat 4
  • Mini 4
  • Volvo 4
  • Citroen 3
  • Honda 3
  • Porsche 3
  • Dacia 2
  • Lexus 2
  • Man 2
  • Mg 2
  • Daf 1
  • Iveco 1
  • Polestar 1
  • Scania 1
  • …

offence 18

  • Driving without Due Care and Attention 157
  • Contravening a Red Traffic Light 39
  • Misc - Non Traffic Offences 24
  • Using a Mobile Phone Whilst Driving 23
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 7
  • Driving without Reasonable Consideration 5
  • Stop a vehicle within pelican pedestrian crossing limits 4
  • Offence to be added 3
  • Contravene Lane Closure Red X 2
  • Driving a vehicle wholly or partly on a footpath 2
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 2
  • Cause vehicle to be left in a dangerous position 1
  • Fail to display rear VRM plate 1
  • No Seat Belt 1
  • Stop a vehicle on pedestrian crossing 1
  • Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
  • Use vehicle on a road without valid test certificate 1

council_area 10

  • Out of Force Area 139
  • Birmingham 67
  • Dudley 18
  • Sandwell 13
  • Walsall 12
  • Coventry 9
  • Solihull 9
  • Wolverhampton 5
  • Sutton Coldfield 3
  • Halesowen 1

reporter_transport_mode 1

  • Car · 276 ✖

month 1

  • 2026-02 · 276 ✖

disposal 1

  • NFA · 276 ✖
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
7256 op-snap---monthly-publication-february-2026.pdf   3 2026-02 Car Audi A5 Black Driving without Due Care and Attention None A38 A38 Out of Force Area Out of Force Area NFA Out of Force      
7258 op-snap---monthly-publication-february-2026.pdf   5 2026-02 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Delph Road, Delph Road Dudley Dudley NFA No Independent Evidence Available   52.4754271 -2.1310168
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      
7264 op-snap---monthly-publication-february-2026.pdf   11 2026-02 Car Land Rover Discovery Blue Offence to be added None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
7272 op-snap---monthly-publication-february-2026.pdf   19 2026-02 Car Mg HS Black Driving without Due Care and Attention None Russelsheim Way, Rugby Russelsheim Way, Rugby Out of Force Area Out of Force Area NFA Out of Force      
7273 op-snap---monthly-publication-february-2026.pdf   20 2026-02 Car Land Rover Range Rover Black Driving without Due Care and Attention None Footscray Road Footscray Road Out of Force Area Out of Force Area NFA Out of Force      
7276 op-snap---monthly-publication-february-2026.pdf   23 2026-02 Car Suzuki Jimny Red Driving without Due Care and Attention None Trumpet Terrace (Cumbria) Trumpet Terrace (Cumbria) Out of Force Area Out of Force Area NFA Out of Force      
7281 op-snap---monthly-publication-february-2026.pdf   28 2026-02 Car Mercedes-Benz G63 Black Driving without Due Care and Attention None M6 Toll T8 M6 Toll T8 Out of Force Area Out of Force Area NFA Out of Force   52.5804962 -1.7833098
7282 op-snap---monthly-publication-february-2026.pdf   29 2026-02 Car Toyota Prius White Driving without Due Care and Attention None Telford Trench Telford Trench Out of Force Area Out of Force Area NFA Out of Force      
7291 op-snap---monthly-publication-february-2026.pdf   38 2026-02 Car Peugeot 208 Black Driving without Due Care and Attention None St Peters Drive, Worcester Street Peters Drive, Worcester Out of Force Area Out of Force Area NFA Out of Force      
7304 op-snap---monthly-publication-february-2026.pdf   51 2026-02 Car     White Contravening a Red Traffic Light None High Street Wordesley High Street Wordesley Dudley Dudley NFA No Independent Evidence Available      
7311 op-snap---monthly-publication-february-2026.pdf   58 2026-02 Car Audi A7 Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Walsall Walsall NFA No Independent Evidence Available   52.5668693 -1.8879364
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
7319 op-snap---monthly-publication-february-2026.pdf   66 2026-02 Car Mercedes-Benz 160 White Driving without Due Care and Attention None Ringway Queens Ringway Queens Coventry Coventry NFA No Offence   52.4039782 -1.5161639
7322 op-snap---monthly-publication-february-2026.pdf   69 2026-02 Car Kia Rio White Driving without Due Care and Attention None A16 Kirton Kirton Out of Force Area Out of Force Area NFA Out of Force      
7338 op-snap---monthly-publication-february-2026.pdf   85 2026-02 Car Hyundai I30.. Black Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver None Bishopton Lane Bishopton Lane Out of Force Area Out of Force Area NFA Out of Force      
7342 op-snap---monthly-publication-february-2026.pdf   89 2026-02 Car BMW 116D Red Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
7344 op-snap---monthly-publication-february-2026.pdf   91 2026-02 Car Mini Cooper Black Driving without Due Care and Attention None Telford Way Telford Way Out of Force Area Out of Force Area NFA Out of Force   52.5060705 -1.9763452
7345 op-snap---monthly-publication-february-2026.pdf   92 2026-02 Car BMW X4 White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
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      
7356 op-snap---monthly-publication-february-2026.pdf   103 2026-02 Car BMW M340i Grey Driving without Due Care and Attention None Great North Road, Retford Great North Road, Retford Out of Force Area Out of Force Area NFA Out of Force      
7361 op-snap---monthly-publication-february-2026.pdf   108 2026-02 Car Vauxhall Corsa White Contravening a Red Traffic Light None Bilston Road Bilston Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5801329 -2.1138283
7372 op-snap---monthly-publication-february-2026.pdf   119 2026-02 Car Vauxhall corsa Red Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA No Offence   52.4779764 -2.1598371
7397 op-snap---monthly-publication-february-2026.pdf   144 2026-02 Car Kia Stonic Red Driving without Reasonable Consideration None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
7403 op-snap---monthly-publication-february-2026.pdf   150 2026-02 Car Skoda fabia Blue Driving without Due Care and Attention None A45, Kenilworth Road A45, Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
7412 op-snap---monthly-publication-february-2026.pdf   159 2026-02 Car Peugeot 208 Grey Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
7414 op-snap---monthly-publication-february-2026.pdf   161 2026-02 Car       Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No VRM   52.6166864 -1.9660822
7422 op-snap---monthly-publication-february-2026.pdf   169 2026-02 Car Skoda Fabia Blue Driving without Due Care and Attention None Vine Street (Cannock) Vine Street (Cannock) Out of Force Area Out of Force Area NFA Out of Force      
7423 op-snap---monthly-publication-february-2026.pdf   170 2026-02 Car BMW 3 series Green Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None Springfield Lane / Greenfield Lane Springfield Lane / Greenfield Lane Wolverhampton Wolverhampton NFA No VRM   52.6345604 -2.1196834
7434 op-snap---monthly-publication-february-2026.pdf   181 2026-02 Car Vauxhall Combo White Contravening a Red Traffic Light None Leek Road (A53) - Staffs Leek Road (A53) - Staffs Out of Force Area Out of Force Area NFA Out of Force      
7450 op-snap---monthly-publication-february-2026.pdf   197 2026-02 Car Fiat 500 Blue Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA     52.5867763 -2.0104342
7451 op-snap---monthly-publication-february-2026.pdf   198 2026-02 Car   multiple   Misc - Non Traffic Offences None Willes Road Willes Road Birmingham Birmingham NFA Misc Inc Crimes   52.4964973 -1.9367016
7452 op-snap---monthly-publication-february-2026.pdf   199 2026-02 Car Peugeot Expert White Misc - Non Traffic Offences None Hertford Way / Balkwell Crescent Hertford Way / Balkwell Crescent Solihull Solihull NFA Not in Public Interest   52.3778812 -1.7427424
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      
7466 op-snap---monthly-publication-february-2026.pdf   213 2026-02 Car Lexus   Black Fail to display rear VRM plate None Woodridge Handsworth Woodridge Handsworth Birmingham Birmingham NFA No VRM      
7467 op-snap---monthly-publication-february-2026.pdf   214 2026-02 Car Audi A5 White Contravening a Red Traffic Light None Trinty Road Warkwickshire Trinty Road Warkwickshire Out of Force Area Out of Force Area NFA Out of Force      
7475 op-snap---monthly-publication-february-2026.pdf   222 2026-02 Car Alfa Romeo Spider White Driving without Due Care and Attention None B4455 B4455 Out of Force Area Out of Force Area NFA Out of Force   52.3994858 -1.4923603
7480 op-snap---monthly-publication-february-2026.pdf   227 2026-02 Car Toyota C-HR Blue Driving without Due Care and Attention None Guarlford Road, Malvern Guarlford Road, Malvern Out of Force Area Out of Force Area NFA Out of Force      
7485 op-snap---monthly-publication-february-2026.pdf   232 2026-02 Car Peugeot 2008.. Blue Driving without Due Care and Attention None Island Road Island Road Birmingham Birmingham NFA No Offence   52.5095686 -1.9544485
7492 op-snap---monthly-publication-february-2026.pdf   239 2026-02 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Talgarth Road London Talgarth Road London Out of Force Area Out of Force Area NFA Out of Force      
7503 op-snap---monthly-publication-february-2026.pdf   250 2026-02 Car Fiat 500 White Driving without Due Care and Attention None M54 Motorway, jn4 M54 Motorway, jn4 Out of Force Area Out of Force Area NFA Out of Force      
7515 op-snap---monthly-publication-february-2026.pdf   262 2026-02 Car Mercedes-Benz C 220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Springfield Road Halesowen Springfield Road Halesowen Dudley Dudley NFA No Offence   52.4664617 -2.0319975
7524 op-snap---monthly-publication-february-2026.pdf   271 2026-02 Car Audi A4 Black Using a Mobile Phone Whilst Driving None Tesco Petrol Station, Stone Cross Tesco Petrol Station, Stone Cross Sandwell Sandwell NFA No Independent Evidence Available      
7534 op-snap---monthly-publication-february-2026.pdf   281 2026-02 Car Mercedes-Benz SLK200 Silver Driving without Due Care and Attention None A51 Birmingham Road Birmingham Road Out of Force Area Out of Force Area NFA Out of Force      
7537 op-snap---monthly-publication-february-2026.pdf   284 2026-02 Car Renault Megane Silver Driving without Due Care and Attention None Bradley Lane Bradley Lane Birmingham Birmingham NFA No VRM      
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      
7556 op-snap---monthly-publication-february-2026.pdf   303 2026-02 Car Daf DAF Truck White Contravening a Red Traffic Light None Gibbins Road Gibbins Road Birmingham Birmingham NFA No VRM   52.4390303 -1.9512931
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
7574 op-snap---monthly-publication-february-2026.pdf   321 2026-02 Car Volkswagen Taigo White Misc - Non Traffic Offences None A4040 Island Road Island Road Sandwell Sandwell NFA No Offence   52.4634433 -1.9965278
7588 op-snap---monthly-publication-february-2026.pdf   335 2026-02 Car       Stop a vehicle within pelican pedestrian crossing limits None Forman Road Forman Road Birmingham Birmingham NFA No Independent Evidence Available   52.4482084 -1.8578405
7589 op-snap---monthly-publication-february-2026.pdf   336 2026-02 Car Renault Clio Blue Misc - Non Traffic Offences None Basford (Staffs) Basford (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
7600 op-snap---monthly-publication-february-2026.pdf   347 2026-02 Car Peugeot 208 Silver Driving without Due Care and Attention None KENT Kent Out of Force Area Out of Force Area NFA Out of Force   52.4719651 -1.8980931
7604 op-snap---monthly-publication-february-2026.pdf   351 2026-02 Car BMW X5 Grey Driving without Due Care and Attention None M6 Junction 15 M6 Junction 15 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
7605 op-snap---monthly-publication-february-2026.pdf   352 2026-02 Car Mini Cooper Grey Misc - Non Traffic Offences None Harborne Lane Harborne Lane Birmingham Birmingham NFA No Offence   52.4468464 -1.9454816
7610 op-snap---monthly-publication-february-2026.pdf   357 2026-02 Car Skoda Fabia Black Driving a vehicle wholly or partly on a footpath None Princess Way Blackpool. Princess Way Blackpool Out of Force Area Out of Force Area NFA Out of Force      
7612 op-snap---monthly-publication-february-2026.pdf   359 2026-02 Car Skoda Fabia Black Driving without Due Care and Attention None Harborne Lane Harborne Lane Birmingham Birmingham NFA No Offence   52.4468464 -1.9454816
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
7618 op-snap---monthly-publication-february-2026.pdf   365 2026-02 Car Man TGE White Driving without Due Care and Attention None The Embankment The Embankment Dudley Dudley NFA No Offence   52.4826167 -2.1144546
7622 op-snap---monthly-publication-february-2026.pdf   369 2026-02 Car Kia Sportage Brown Driving without Due Care and Attention None M42 Jct 11 Roundabout M42 Junction 11 Roundabout Out of Force Area Out of Force Area NFA Out of Force      
7633 op-snap---monthly-publication-february-2026.pdf   380 2026-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Leicester Road Rugby (Warcs) Leicester Road Rugby (Warcs) 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      
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      
7642 op-snap---monthly-publication-february-2026.pdf   389 2026-02 Car Renault Trafic White Driving without Due Care and Attention None A38M A38M Birmingham Birmingham NFA No Offence      
7643 op-snap---monthly-publication-february-2026.pdf   390 2026-02 Car Toyota   Blue Contravening a Red Traffic Light None Technology Drive Technology Drive Out of Force Area Out of Force Area NFA Out of Force      
7647 op-snap---monthly-publication-february-2026.pdf   394 2026-02 Car   Dennis Bus Red Driving without Due Care and Attention None Sallbrook Queensway Sallbrook Queensway Birmingham Birmingham NFA Not in Public Interest      
7681 op-snap---monthly-publication-february-2026.pdf   428 2026-02 Car Hyundai Ionic Silver Driving without Due Care and Attention None A316 Sunbury Cross Sunbury Cross Out of Force Area Out of Force Area NFA Out of Force      
7684 op-snap---monthly-publication-february-2026.pdf   431 2026-02 Car Nissan Pixo Black Contravene Lane Closure Red X None A38m A38m Birmingham Birmingham NFA No Offence      
7688 op-snap---monthly-publication-february-2026.pdf   435 2026-02 Car Citroen Berlingo Silver Driving without Due Care and Attention None Wallows Lane Wallows Lane Walsall Walsall NFA No Offence   52.5699435 -2.0008354
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      
7691 op-snap---monthly-publication-february-2026.pdf   438 2026-02 Car Toyota   Grey Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
7692 op-snap---monthly-publication-february-2026.pdf   439 2026-02 Car Volkswagen Tiguan White Driving without Due Care and Attention None JCT 11 M6 Jct 11 M6 Walsall Walsall NFA No Offence      
7693 op-snap---monthly-publication-february-2026.pdf   440 2026-02 Car BMW X Drive Black Driving without Due Care and Attention None M5 Southbound M5 Southbound Out of Force Area Out of Force Area NFA Out of Force      
7695 op-snap---monthly-publication-february-2026.pdf   442 2026-02 Car Land Rover Evoque Black Driving without Due Care and Attention None M6 SB J19 M6 Southbound J19 Out of Force Area Out of Force Area NFA Out of Force      
7713 op-snap---monthly-publication-february-2026.pdf   460 2026-02 Car Volkswagen Golf Silver Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham NFA No Independent Evidence Available   52.5505398 -1.8252993
7717 op-snap---monthly-publication-february-2026.pdf   464 2026-02 Car Citroen C4 Blue Driving without Due Care and Attention None Oakham Road Oakham Road Dudley Dudley NFA No Offence   52.5030757 -2.0663819
7732 op-snap---monthly-publication-february-2026.pdf   479 2026-02 Car Toyota Yaris Blue Driving without Due Care and Attention No Insurance Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No Independent Evidence Available   52.4590366 -2.1465735
7738 op-snap---monthly-publication-february-2026.pdf   485 2026-02 Car Volkswagen Polo Purple Driving without Due Care and Attention No Insurance Meadway Road Meadway Road Birmingham Birmingham NFA No Independent Evidence Available   52.4758428 -1.7931767
7753 op-snap---monthly-publication-february-2026.pdf   500 2026-02 Car Honda CRV Black Driving without Due Care and Attention None Northampton Road, Rugby Northampton Road, Rugby Out of Force Area Out of Force Area NFA Out of Force      
7766 op-snap---monthly-publication-february-2026.pdf   513 2026-02 Car Mercedes-Benz CLA 180 White Contravening a Red Traffic Light None Witton Road Witton Road Birmingham Birmingham NFA No Offence   52.513336 -1.8833226
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
7778 op-snap---monthly-publication-february-2026.pdf   525 2026-02 Car       Contravening a Red Traffic Light None Sheet Road, Ludlow Sheet Road, Ludlow Out of Force Area Out of Force Area NFA Out of Force      
7788 op-snap---monthly-publication-february-2026.pdf   535 2026-02 Car Peugeot 3008 GT White Driving without Due Care and Attention None Mill Street Mill Street Out of Force Area Out of Force Area NFA Out of Force   52.5644402 -1.8228286
7798 op-snap---monthly-publication-february-2026.pdf   545 2026-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None A5 A5 Out of Force Area Out of Force Area NFA Out of Force      
7807 op-snap---monthly-publication-february-2026.pdf   554 2026-02 Car Peugeot 308 Black Driving without Due Care and Attention None Hales Road Hales Road Halesowen Halesowen NFA No Independent Evidence Available   52.5618636 -2.0115843
7813 op-snap---monthly-publication-february-2026.pdf   560 2026-02 Car Nissan Qashqai Black No Seat Belt None Coton Park Drive Coton Park Drive Out of Force Area Out of Force Area NFA Out of Force      
7818 op-snap---monthly-publication-february-2026.pdf   565 2026-02 Car Skoda Superb Blue Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
7827 op-snap---monthly-publication-february-2026.pdf   574 2026-02 Car Skoda Kodiaq Grey Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA Not in Public Interest   52.4779764 -2.1598371
7829 op-snap---monthly-publication-february-2026.pdf   576 2026-02 Car Peugeot 308.. Grey Using a Mobile Phone Whilst Driving None Cato Street Cato Street Birmingham Birmingham NFA No Independent Evidence Available   52.4904718 -1.8693759
7836 op-snap---monthly-publication-february-2026.pdf   583 2026-02 Car Kia Picanto Blue Driving without Due Care and Attention None Windsor to Watford Windsor to Watford Out of Force Area Out of Force Area NFA Out of Force      
7844 op-snap---monthly-publication-february-2026.pdf   591 2026-02 Car Mini One Black Driving without Due Care and Attention None A456 J3 M5 A456 J3 M5 Birmingham Birmingham NFA No Offence      
7846 op-snap---monthly-publication-february-2026.pdf   593 2026-02 Car Audi A1 White Driving without Due Care and Attention None Cole Valley Road Cole Valley Road Birmingham Birmingham NFA No Independent Evidence Available   52.4255079 -1.8570247
7858 op-snap---monthly-publication-february-2026.pdf   605 2026-02 Car Citroen C1 Black Contravening a Red Traffic Light None Church Road Church Road Birmingham Birmingham NFA No Independent Evidence Available   52.4624743 -1.7763934
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      
7863 op-snap---monthly-publication-february-2026.pdf   610 2026-02 Car Audi A5 Black Driving without Due Care and Attention None M5 between Bromsgrove and Worcester M5 between Bromsgrove and Worcester Out of Force Area Out of Force Area NFA Out of Force      
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      
7867 op-snap---monthly-publication-february-2026.pdf   614 2026-02 Car Seat Ibiza Black Cause vehicle to be left in a dangerous position None Hilton Road Hilton Road Out of Force Area Out of Force Area NFA Out of Force   52.5609419 -2.1099418
7877 op-snap---monthly-publication-february-2026.pdf   624 2026-02 Car Mg 3 White Driving without Due Care and Attention None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
7887 op-snap---monthly-publication-february-2026.pdf   634 2026-02 Car Audi A4 Black Driving without Due Care and Attention None Burman Street Burman Street Birmingham Birmingham NFA No Independent Evidence Available      
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      
7923 op-snap---monthly-publication-february-2026.pdf   670 2026-02 Car Land Rover Discovery Silver Driving without Due Care and Attention None Holt, Worcester to Hallow Holt, Worcester to Hallow 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);