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

5,123 rows where offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

vehicle_make >30

  • Volkswagen 594
  • BMW 540
  • Ford 499
  • Audi 497
  • Mercedes-Benz 455
  • Vauxhall 303
  • Toyota 289
  • Seat 179
  • Peugeot 149
  • Nissan 140
  • Hyundai 113
  • Land Rover 113
  • Skoda 113
  • Honda 105
  • Renault 104
  • Volvo 81
  • Citroen 79
  • Kia 73
  • Mini 49
  • Fiat 47
  • Suzuki 39
  • Mazda 37
  • Lexus 30
  • Mg 30
  • Porsche 30
  • Tesla 27
  • Yamaha 27
  • Daf 24
  • Jaguar 24
  • Mitsubishi 19
  • …

council_area >30

  • Birmingham 2,348
  • Out of Force Area 859
  • Coventry 387
  • Sandwell 331
  • Dudley 262
  • Solihull 260
  • Wolverhampton 240
  • Walsall 238
  • Sutton Coldfield 113
  • Halesowen 20
  • Area 6
  • Metropolitan Borough Of Dudley 4
  • Out Of Force Area 4
  • Metropolitan Borough 3
  • Aorueta Of Force 2
  • Soauntd Owf Eflolrce 2
  • )Birmingham 1
  • 4C4O4V)Entry 1
  • Abyirmingham 1
  • Ao)Ut Of Force Area 1
  • Aofufts Opfo Floirccee) Area 1
  • Aonudt B Olyf Tfhorce Area 1
  • Bboiurmt Oinf Gthhea Mjunction 1
  • Bdirmingham 1
  • Borirt Mrionagdham 1
  • Cst Arnadwell 1
  • Do Ujnt 3Of Force Area 1
  • Ds Bainrcdhwleeyll Island 1
  • Ebtisrm Cinogrhnamer 1
  • Eorucita Of Force Area 1
  • …

month 14

  • 2025-06 497
  • 2025-08 486
  • 2025-07 474
  • 2025-09 430
  • 2025-05 396
  • 2025-10 390
  • 2026-02 386
  • 2025-03 382
  • 2025-11 367
  • 2026-01 301
  • 2025-12 294
  • 2025-02 275
  • 2025-04 224
  • 2025-01 221

disposal 8

  • NFA 2,280
  • Warning Letter 887
  • Education 875
  • Court 506
  • Fixed Penalty 469
  • RTC - Actioned 64
  • Other Action Taken 40
  • Duplicate Submission 2

reporter_transport_mode 1

  • Car · 5,123 ✖

offence 1

  • Driving without Due Care and Attention · 5,123 ✖
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      
7257 op-snap---monthly-publication-february-2026.pdf   4 2026-02 Car Mazda CX30 Grey Driving without Due Care and Attention None High Street, Quarry Bank High Street, Quarry Bank Dudley Dudley Education N/A   52.4576453 -2.1150716
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      
7266 op-snap---monthly-publication-february-2026.pdf   13 2026-02 Car Mercedes-Benz CLA 250.. White Driving without Due Care and Attention None Solihull Bypass Solihull Bypass Solihull Solihull Fixed Penalty N/A   52.4207529 -1.7757467
7270 op-snap---monthly-publication-february-2026.pdf   17 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell Court N/A   52.5538064 -2.0139199
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      
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
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      
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
7346 op-snap---monthly-publication-february-2026.pdf   93 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
7347 op-snap---monthly-publication-february-2026.pdf   94 2026-02 Car Ford Transit White Driving without Due Care and Attention None Streetly Road, Short Heath Streetly Road, Short Heath Birmingham Birmingham Education N/A   52.5316018 -1.8581289
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      
7365 op-snap---monthly-publication-february-2026.pdf   112 2026-02 Car Toyota Prius Black Driving without Due Care and Attention None Booth Street, Handsworth Booth Street, Handsworth Birmingham Birmingham Education N/A   52.5039035 -1.9447084
7370 op-snap---monthly-publication-february-2026.pdf   117 2026-02 Car Honda Jazz Red Driving without Due Care and Attention None Birchfield Island Olbury Birchfield Island Olbury Sandwell Sandwell Court N/A      
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
7390 op-snap---monthly-publication-february-2026.pdf   137 2026-02 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None Church Street Church Street Birmingham Birmingham Education N/A   52.5020781 -1.9122368
7393 op-snap---monthly-publication-february-2026.pdf   140 2026-02 Car Toyota Auris Grey Driving without Due Care and Attention No Insurance Crampers Field Crampers Field Coventry Coventry Court N/A   52.4176927 -1.5257854
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
7404 op-snap---monthly-publication-february-2026.pdf   151 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None A34 Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
7407 op-snap---monthly-publication-february-2026.pdf   154 2026-02 Car Skoda Superb Black Driving without Due Care and Attention None Darmouth Middleway Darmouth Middleway Birmingham Birmingham Fixed Penalty N/A      
7408 op-snap---monthly-publication-february-2026.pdf   155 2026-02 Car BMW 118I Grey Driving without Due Care and Attention None Hall Green Road Hall Green Road Sandwell Sandwell Court N/A   52.5457385 -1.9935809
7413 op-snap---monthly-publication-february-2026.pdf   160 2026-02 Car Ford Kuga Green Driving without Due Care and Attention None Tipton Street Tipton Street Dudley Dudley RTC - Actioned N/A   52.5387558 -2.1179869
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
7418 op-snap---monthly-publication-february-2026.pdf   165 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Venture Way Venture Way Dudley Dudley Warning Letter N/A   52.4836603 -2.1189326
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      
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
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      
7484 op-snap---monthly-publication-february-2026.pdf   231 2026-02 Car Volkswagen T-Cross Grey Driving without Due Care and Attention None A4040 Church Lane, Perry barr Church Lane, Perry barr Birmingham Birmingham Warning Letter N/A   52.5130255 -1.9220091
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
7489 op-snap---monthly-publication-february-2026.pdf   236 2026-02 Car Toyota Yaris Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
7496 op-snap---monthly-publication-february-2026.pdf   243 2026-02 Car Hyundai I10 Silver Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Education N/A   52.4622646 -1.8599985
7497 op-snap---monthly-publication-february-2026.pdf   244 2026-02 Car BMW X1 Blue Driving without Due Care and Attention None Torcross Avenue Torcross Avenue Coventry Coventry Education N/A   52.4218194 -1.46546
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      
7505 op-snap---monthly-publication-february-2026.pdf   252 2026-02 Car Seat Cupra Grey Driving without Due Care and Attention None Sand Pits Sand Pits Birmingham Birmingham Education N/A      
7509 op-snap---monthly-publication-february-2026.pdf   256 2026-02 Car Skoda Octavia White Driving without Due Care and Attention None Fort Parkway Fort Parkway Birmingham Birmingham Education N/A   52.50787 -1.8195713
7513 op-snap---monthly-publication-february-2026.pdf   260 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None Newport Road Newport Road Birmingham Birmingham Education N/A   52.5027779 -1.7982159
7532 op-snap---monthly-publication-february-2026.pdf   279 2026-02 Car Lexus CT200 White Driving without Due Care and Attention None Cross Street South Cross Street South Wolverhampton Wolverhampton Education N/A   52.570955 -2.130838
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      
7535 op-snap---monthly-publication-february-2026.pdf   282 2026-02 Car Peugeot 206 Silver Driving without Due Care and Attention None Winding House Lane Winding House Lane Coventry Coventry Education N/A   52.4490457 -1.5001195
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      
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
7573 op-snap---monthly-publication-february-2026.pdf   320 2026-02 Car Peugeot 2008GT Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
7579 op-snap---monthly-publication-february-2026.pdf   326 2026-02 Car Kia Xceed Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
7590 op-snap---monthly-publication-february-2026.pdf   337 2026-02 Car Volkswagen Polo White Driving without Due Care and Attention None Cole Bank Road Cole Bank Road Birmingham Birmingham Court N/A   52.4349375 -1.8510007
7593 op-snap---monthly-publication-february-2026.pdf   340 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Walford Road Walford Road Birmingham Birmingham Court N/A   52.4594072 -1.8658859
7596 op-snap---monthly-publication-february-2026.pdf   343 2026-02 Car Citroen C3.. White Driving without Due Care and Attention None New John Street West New John Street West Birmingham Birmingham Education N/A   52.4944784 -1.9122329
7597 op-snap---monthly-publication-february-2026.pdf   344 2026-02 Car Citroen C3 Silver Driving without Due Care and Attention None Barnes Hill Barnes Hill Birmingham Birmingham Warning Letter N/A   52.4401325 -1.9785938
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
7603 op-snap---monthly-publication-february-2026.pdf   350 2026-02 Car Hyundai 130 Blue Driving without Due Care and Attention None A46 Coventry Coventry Coventry Coventry Education N/A   52.400739 -1.5135474
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
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
7614 op-snap---monthly-publication-february-2026.pdf   361 2026-02 Car Mg HS Red Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Warning Letter N/A   52.4881161 -2.1199108
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
7619 op-snap---monthly-publication-february-2026.pdf   366 2026-02 Car Skoda Octavia Grey Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
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      
7625 op-snap---monthly-publication-february-2026.pdf   372 2026-02 Car Mercedes-Benz CLA 220 Red Driving without Due Care and Attention None Coventry A45 W Coventry A45 W Coventry Coventry Education N/A   52.4314215 -1.5948907
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      
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      
7641 op-snap---monthly-publication-february-2026.pdf   388 2026-02 Car Peugeot 408 Silver Driving without Due Care and Attention None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield Education N/A   52.5575249 -1.8640053
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      
7644 op-snap---monthly-publication-february-2026.pdf   391 2026-02 Car Ford Transit Connect Black Driving without Due Care and Attention None Ambergate Road / Highfield Rd, Bilston Ambergate Road / Highfield Road, Bilston Wolverhampton Wolverhampton Education N/A   52.5597351 -2.081298
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      
7650 op-snap---monthly-publication-february-2026.pdf   397 2026-02 Car Ford Focus Silver Driving without Due Care and Attention Use vehicle on a road without valid test certificate Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
7658 op-snap---monthly-publication-february-2026.pdf   405 2026-02 Car Audi A4 Red Driving without Due Care and Attention None Hustcroft Road Hustcroft Road Birmingham Birmingham Education N/A      
7664 op-snap---monthly-publication-february-2026.pdf   411 2026-02 Car Peugeot 5008 Black Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
7665 op-snap---monthly-publication-february-2026.pdf   412 2026-02 Car Volkswagen Taigo White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
7675 op-snap---monthly-publication-february-2026.pdf   422 2026-02 Car Volkswagen Transporter Grey Driving without Due Care and Attention None A34 Walsall Road Walsall Road Birmingham Birmingham Fixed Penalty N/A   52.5919543 -1.8517118
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      
7685 op-snap---monthly-publication-february-2026.pdf   432 2026-02 Car Audi Q2 Blue Driving without Due Care and Attention None Leamore Lane Leamore Lane Walsall Walsall Education N/A   52.6056653 -2.0050776
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      
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      
7710 op-snap---monthly-publication-february-2026.pdf   457 2026-02 Car BMW X3 M Grey Driving without Due Care and Attention None Heath Way Heath Way Birmingham Birmingham Education N/A   52.4963549 -1.7806171
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
7718 op-snap---monthly-publication-february-2026.pdf   465 2026-02 Car Ford Transit White Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham Education N/A   52.471632 -1.9456776
7723 op-snap---monthly-publication-february-2026.pdf   470 2026-02 Car Kia EV3 Green Driving without Due Care and Attention None Tanworth Lane Tanworth Lane Solihull Solihull Education N/A   52.4014694 -1.8220541
7730 op-snap---monthly-publication-february-2026.pdf   477 2026-02 Car Audi S3 Blue Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
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
7742 op-snap---monthly-publication-february-2026.pdf   489 2026-02 Car Vauxhall Corsa Orange Driving without Due Care and Attention None High Street, Stourbridge High Street, Stourbridge Dudley Dudley Warning Letter N/A   52.4570763 -2.1136199
7752 op-snap---monthly-publication-february-2026.pdf   499 2026-02 Car Volkswagen V40.. Blue Driving without Due Care and Attention None Chadd Road Coseley Chadd Road Coseley Dudley Dudley Other Action Taken N/A      
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      
7754 op-snap---monthly-publication-february-2026.pdf   501 2026-02 Car Citroen Berlingo Silver Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Warning Letter N/A   52.396476 -1.5561348
7756 op-snap---monthly-publication-february-2026.pdf   503 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Warning Letter N/A   52.418488 -1.5472387
7769 op-snap---monthly-publication-february-2026.pdf   516 2026-02 Car Mercedes-Benz GLA black Driving without Due Care and Attention None Kenilworth Road, A452, nr Balsall Common Kenilworth Road, A452, nr Balsall Common Solihull Solihull Warning Letter N/A      
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
7779 op-snap---monthly-publication-february-2026.pdf   526 2026-02 Car Seat Ibiza Red Driving without Due Care and Attention None Curzon Circle Curzon Circle Birmingham Birmingham Warning Letter N/A   52.4834655 -1.8801763

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