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

473 rows where month = "2025-03" and offence = "Driving without Due Care and Attention" 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 58
  • BMW 48
  • Mercedes-Benz 45
  • Ford 42
  • Audi 40
  • Vauxhall 33
  • Toyota 25
  • Seat 22
  • Honda 14
  • Nissan 13
  • Peugeot 11
  • Skoda 11
  • Hyundai 10
  • Volvo 9
  • Citroen 8
  • Land Rover 8
  • Renault 7
  • Kia 6
  • Lexus 6
  • Daf 5
  • Fiat 5
  • Alfa Romeo 3
  • Mazda 3
  • Porsche 3
  • Yamaha 3
  • Jaguar 2
  • Mini 2
  • Mitsubishi 2
  • Dacia 1
  • Isuzu 1
  • …

council_area 11

  • Birmingham 237
  • Out of Force Area 53
  • Coventry 46
  • Dudley 33
  • Walsall 25
  • Solihull 23
  • Sandwell 22
  • Wolverhampton 16
  • Sutton Coldfield 11
  • Metropolitan Borough Of Dudley 3
  • Ao)Ut Of Force Area 1

reporter_transport_mode 9

  • Car 382
  • Pedal Bike 44
  • Pedestrian 23
  • Other 14
  • Motorbike 5
  • Lorry 2
  • Bus 1
  • Horse Rider 1
  • car 1

disposal 7

  • Warning Letter 112
  • NFA 105
  • Fixed Penalty 98
  • Education 92
  • Court 54
  • Other Action Taken 7
  • RTC - Actioned 5

offence 1

  • Driving without Due Care and Attention · 473 ✖

month 1

  • 2025-03 · 473 ✖
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
16272 op-snap---monthly-publication-march-2025.pdf   29 2025-03 Car Toyota Aygo Black Driving without Due Care and Attention None Harborne Parkl Road Harborne Parkl Road     Court N/A Yes - Via Email    
16274 op-snap---monthly-publication-march-2025.pdf   31 2025-03 Car Skoda Fabia Silver Driving without Due Care and Attention None Market Rasen, near Lincoln Market Rasen, near Lincoln Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16280 op-snap---monthly-publication-march-2025.pdf   37 2025-03 Car BMW 125 Black Driving without Due Care and Attention None Cole Bank Road Cole Bank Road Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4349375 -1.8510007
16282 op-snap---monthly-publication-march-2025.pdf   39 2025-03 Pedal Bike Volkswagen Polo Grey Driving without Due Care and Attention None Fairfield Kidderminster Fairfield Kidderminster Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16287 op-snap---monthly-publication-march-2025.pdf   44 2025-03 Car BMW M235i Black Driving without Due Care and Attention None M6 j7 to 6 M6 j7 to 6 Birmingham Birmingham Education N/A Yes - Via Email 52.676119 -2.0858425
16297 op-snap---monthly-publication-march-2025.pdf   54 2025-03 Other Seat Altea Silver Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5112053 -2.0833165
16299 op-snap---monthly-publication-march-2025.pdf   56 2025-03 Other Toyota Prius White Driving without Due Care and Attention None Tower Street Tower Street Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5112053 -2.0833165
16303 op-snap---monthly-publication-march-2025.pdf   60 2025-03 Car Honda Civic Black Driving without Due Care and Attention None Minworth Island Minworth Island Birmingham Birmingham NFA No VRM Yes - Via Email 52.5316279 -1.7762358
16309 op-snap---monthly-publication-march-2025.pdf   66 2025-03 Car Honda CRV Black Driving without Due Care and Attention None Alvechurch Highway, Bromsgrove Alvechurch Highway, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16310 op-snap---monthly-publication-march-2025.pdf   67 2025-03 Car Fiat 500 Black Driving without Due Care and Attention None Roughill Drive Roughill Drive Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16317 op-snap---monthly-publication-march-2025.pdf   74 2025-03 Car Toyota Yaris Black Driving without Due Care and Attention None Tippity Green Oldbury Tippity Green Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4839613 -2.0496171
16326 op-snap---monthly-publication-march-2025.pdf   83 2025-03 Car Audi Q2 White Driving without Due Care and Attention None Lawrence Saunders Road Lawrence Saunders Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4190356 -1.5238966
16327 op-snap---monthly-publication-march-2025.pdf   84 2025-03 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Stivichall Croft Stivichall Croft Coventry Coventry Education N/A Yes - Via Email 52.387363 -1.522136
16333 op-snap---monthly-publication-march-2025.pdf   90 2025-03 Car Volkswagen Golf Silver Driving without Due Care and Attention No vehicle excise licence Stratford Road Stratford Road Birmingham Birmingham Court N/A Yes - Via Email 52.4203897 -1.8338574
16340 op-snap---monthly-publication-march-2025.pdf   97 2025-03 Car Audi A5 White Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Education N/A Yes - Via Email 52.5148331 -1.79231
16353 op-snap---monthly-publication-march-2025.pdf   110 2025-03 Other Hyundai I10 Blue Driving without Due Care and Attention None Stone Steet Stone Steet Dudley Dudley Education N/A Yes - Via Email    
16365 op-snap---monthly-publication-march-2025.pdf   122 2025-03 Car Hyundai I30 White Driving without Due Care and Attention None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4926487 -1.8879638
16366 op-snap---monthly-publication-march-2025.pdf   123 2025-03 Car Mercedes-Benz GLA Grey Driving without Due Care and Attention No vehicle excise licence Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Court N/A Yes - Via Email 52.4861917 -1.8829748
16372 op-snap---monthly-publication-march-2025.pdf   129 2025-03 Car Vauxhall Corsa Black Driving without Due Care and Attention None M6 J7 M6 J7 Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.676119 -2.0858425
16379 op-snap---monthly-publication-march-2025.pdf   136 2025-03 Pedestrian Mercedes-Benz A180 Grey Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham Education N/A Yes - Via Email 52.4398245 -1.8469786
16380 op-snap---monthly-publication-march-2025.pdf   137 2025-03 Pedal Bike Daf Truck - Concrete Mixer Green Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
16381 op-snap---monthly-publication-march-2025.pdf   138 2025-03 Pedal Bike Alfa Romeo Giulietta Red Driving without Due Care and Attention None Lichfield Road, Sutton Coldfield Lichfield Road, Sutton Coldfield Birmingham Birmingham Education N/A Yes - Via Email 52.5724042 -1.8239307
16383 op-snap---monthly-publication-march-2025.pdf   140 2025-03 Pedal Bike Ford Focus Red Driving without Due Care and Attention None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4047807 -2.0101216
16389 op-snap---monthly-publication-march-2025.pdf   146 2025-03 Car Volkswagen TRoc Black Driving without Due Care and Attention None Ringway Highway Ringway Highway Coventry Coventry Fixed Penalty N/A Yes - Via Email    
16393 op-snap---monthly-publication-march-2025.pdf   150 2025-03 Pedestrian Volkswagen Polo White Driving without Due Care and Attention None Collingwood Avenue Collingwood Avenue Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email    
16403 op-snap---monthly-publication-march-2025.pdf   160 2025-03 Car Land Rover Freedlander Grey Driving without Due Care and Attention None Moseley Road Moseley Road Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.5782924 -2.0742911
16414 op-snap---monthly-publication-march-2025.pdf   171 2025-03 Motorbike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Vicar Street at Dudley Road Sedgley Vicar Street at Dudley Road Sedgley Dudley Dudley Education N/A Yes - Via Email 52.5081139 -2.0856851
16415 op-snap---monthly-publication-march-2025.pdf   172 2025-03 Car Daf BUS White Driving without Due Care and Attention None Ducan Edawards Way Ducan Edawards Way Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
16418 op-snap---monthly-publication-march-2025.pdf   175 2025-03 Car Audi S8 White Driving without Due Care and Attention No Insurance Kite Hardwick, Warwickshire Kite Hardwick, Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16420 op-snap---monthly-publication-march-2025.pdf   177 2025-03 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
16422 op-snap---monthly-publication-march-2025.pdf   179 2025-03 Car Volkswagen T Roc Grey Driving without Due Care and Attention None Oxleys Road Oxleys Road Sutton Coldfield Sutton Coldfield Court N/A Yes - Via Email    
16423 op-snap---monthly-publication-march-2025.pdf   180 2025-03 Car BMW 118 Blue Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email    
16434 op-snap---monthly-publication-march-2025.pdf   191 2025-03 Car Seat Arona White Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry Education N/A Yes - Via Email 52.4235908 -1.5226276
16438 op-snap---monthly-publication-march-2025.pdf   195 2025-03 Car Vauxhall UK Silver Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Sutton Coldfield Sutton Coldfield NFA No VRM Yes - Via Email    
16448 op-snap---monthly-publication-march-2025.pdf   205 2025-03 Car Dacia Sandero Green Driving without Due Care and Attention None Mackadown Lane Mackadown Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4708415 -1.7675939
16451 op-snap---monthly-publication-march-2025.pdf   208 2025-03 car Seat Leon Black Driving without Due Care and Attention None Biddings Lane, Biddings Lane Wolverhampton Wolverhampton NFA No VRM Yes - Via Email 52.5498138 -2.0913674
16453 op-snap---monthly-publication-march-2025.pdf   210 2025-03 Car Vauxhall Astra Blue Driving without Due Care and Attention Use vehicle on a road without valid test certificate Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5194011 -1.8008643
16455 op-snap---monthly-publication-march-2025.pdf   212 2025-03 Car Ford Focus White Driving without Due Care and Attention None Longford Road Longford Road Coventry Coventry NFA No VRM Yes - Via Email 52.445164 -1.4879298
16460 op-snap---monthly-publication-march-2025.pdf   217 2025-03 Car Vauxhall Zafira Silver Driving without Due Care and Attention None A45, B4137 Roundabout A45, B4137 Roundabout Birmingham Birmingham Education N/A Yes - Via Email    
16463 op-snap---monthly-publication-march-2025.pdf   220 2025-03 Pedestrian Ford Focus Silver Driving without Due Care and Attention None School Road, Kings Heath School Road, Kings Heath Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4384417 -1.8875299
16465 op-snap---monthly-publication-march-2025.pdf   222 2025-03 Car Audi A1 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A Yes - Via Email 52.4203897 -1.8338574
16467 op-snap---monthly-publication-march-2025.pdf   224 2025-03 Pedal Bike Tesla   Black Driving without Due Care and Attention None Barton Lodge Road Barton Lodge Road Solihull Solihull NFA No Offence Yes - Via Email    
16478 op-snap---monthly-publication-march-2025.pdf   235 2025-03 Pedal Bike Skoda Rapid Black Driving without Due Care and Attention None Stonehouse Road Stonehouse Road Sutton Coldfield Sutton Coldfield Other Action Taken N/A Yes - Via Email 52.5554307 -1.8439169
16482 op-snap---monthly-publication-march-2025.pdf   239 2025-03 Car Volkswagen Passat Grey Driving without Due Care and Attention None a5 A5 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16495 op-snap---monthly-publication-march-2025.pdf   252 2025-03 Car Lexus ES Grey Driving without Due Care and Attention None Whittemere Street Whittemere Street Walsall Walsall Fixed Penalty N/A Yes - Via Email    
16511 op-snap---monthly-publication-march-2025.pdf   268 2025-03 Car Ford cmax Silver Driving without Due Care and Attention None Birmingham Road Birmingham Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5723244 -1.9607214
16520 op-snap---monthly-publication-march-2025.pdf   277 2025-03 Car Volkswagen T-Roc Blue Driving without Due Care and Attention None Wing Foot Way Wing Foot Way Birmingham Birmingham Education n/a Yes - Via Email    
16529 op-snap---monthly-publication-march-2025.pdf   286 2025-03 Car Citroen Birlingo White Driving without Due Care and Attention None Castle Hill Castle Hill Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5140573 -2.0798069
16531 op-snap---monthly-publication-march-2025.pdf   288 2025-03 Motorbike Isuzu D-max White Driving without Due Care and Attention None Aston Expressway Aston Expressway Birmingham Birmingham RTC - Actioned N/A Yes - Via Email 52.493793 -1.8881773
16532 op-snap---monthly-publication-march-2025.pdf   289 2025-03 Car Vauxhall Corsa White Driving without Due Care and Attention Use vehicle on a road without valid test certificate Longwood Road Longwood Road Birmingham Birmingham Court N/A Yes - Via Email 52.3932557 -2.0108733
16549 op-snap---monthly-publication-march-2025.pdf   306 2025-03 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Broadway North Broadway North Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5886007 -1.9741222
16551 op-snap---monthly-publication-march-2025.pdf   308 2025-03 Pedal Bike Land Rover Evoque Red Driving without Due Care and Attention None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16554 op-snap---monthly-publication-march-2025.pdf   311 2025-03 Car Volkswagen Golf Blue Driving without Due Care and Attention None Brynanston Road Brynanston Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email    
16555 op-snap---monthly-publication-march-2025.pdf   312 2025-03 Car BMW N/K Black Driving without Due Care and Attention None Kenpas Highway Kenpas Highway Coventry Coventry NFA No VRM Yes - Via Email 52.3833661 -1.5265665
16556 op-snap---monthly-publication-march-2025.pdf   313 2025-03 Car BMW 518D Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A Yes - Via Email 52.4390303 -1.9512931
16562 op-snap---monthly-publication-march-2025.pdf   319 2025-03 Car Volkswagen Polo Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Court N/A Yes - Via Email 52.4726661 -1.8769032
16564 op-snap---monthly-publication-march-2025.pdf   321 2025-03 Car Mercedes-Benz C220 Grey Driving without Due Care and Attention No Insurance Coleshll Road Coleshll Road Birmingham Birmingham Court N/A Yes - Via Email    
16574 op-snap---monthly-publication-march-2025.pdf   331 2025-03 Car Volkswagen GOLF White Driving without Due Care and Attention None BUXTON ROAD Buxton Road Wolverhampton Wolverhampton Warning Letter Outside of 14 Days NIP Yes - Via Email    
16575 op-snap---monthly-publication-march-2025.pdf   332 2025-03 Car BMW 318 Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate A45 Coventry Road Coventry Road Birmingham Birmingham Court N/A Yes - Via Email 52.4726661 -1.8769032
16576 op-snap---monthly-publication-march-2025.pdf   333 2025-03 Car BMW 520D Black Driving without Due Care and Attention None B4086 Warickshire Warickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16577 op-snap---monthly-publication-march-2025.pdf   334 2025-03 Car Toyota Avensis Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
16595 op-snap---monthly-publication-march-2025.pdf   352 2025-03 Car BMW 116 D Black Driving without Due Care and Attention None COLE HALL LANE Cole Hall Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4877244 -1.787883
16603 op-snap---monthly-publication-march-2025.pdf   360 2025-03 Car Ford Focus Grey Driving without Due Care and Attention None Shrewsbury area Shrewsbury area Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16606 op-snap---monthly-publication-march-2025.pdf   363 2025-03 Car BMW 320I Orange Driving without Due Care and Attention None Greaves Avenue Greaves Avenue Walsall Walsall Fixed Penalty N/A   52.5773135 -1.9525262
16607 op-snap---monthly-publication-march-2025.pdf   364 2025-03 Car Land Rover Evoque White Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4198291 -1.9241732
16610 op-snap---monthly-publication-march-2025.pdf   367 2025-03 Car Toyota AVENSIS Silver Driving without Due Care and Attention None HARBORNE ROAD Harborne Road Birmingham Birmingham Education N/A Yes - Via Email 52.4718503 -1.9195423
16612 op-snap---monthly-publication-march-2025.pdf   369 2025-03 Car Audi A4 White Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4161736 -1.8619692
16613 op-snap---monthly-publication-march-2025.pdf   370 2025-03 Car Audi A4 White Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4709298 -1.8722585
16615 op-snap---monthly-publication-march-2025.pdf   372 2025-03 Other BMW 118 White Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A Yes - Via Email    
16616 op-snap---monthly-publication-march-2025.pdf   373 2025-03 Other Mercedes-Benz 180 Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A Yes - Via Email    
16623 op-snap---monthly-publication-march-2025.pdf   380 2025-03 Car Renault Master Grey Driving without Due Care and Attention None M42 Southbound, between Jn 7 and 6 M42 Southbound, between Junction 7 and 6 Birmingham Birmingham Court N/A Yes - Via Email    
16624 op-snap---monthly-publication-march-2025.pdf   381 2025-03 Car Yamaha R6 Blue Driving without Due Care and Attention None High Street High Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5254588 -1.8373064
16631 op-snap---monthly-publication-march-2025.pdf   388 2025-03 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Harrier Way Birmingham Harrier Way Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16636 op-snap---monthly-publication-march-2025.pdf   393 2025-03 Car Vauxhall Corsa White Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4468506 -1.9395619
16639 op-snap---monthly-publication-march-2025.pdf   396 2025-03 Car Kia Sportage Brown Driving without Due Care and Attention None Hortonwood Road Telford Hortonwood Road Telford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16657 op-snap---monthly-publication-march-2025.pdf   414 2025-03 Car Volkswagen Golf White Driving without Due Care and Attention None Stechford Lane Stechford Lane Birmingham Birmingham NFA No VRM Yes - Via Email 52.4930549 -1.8179571
16667 op-snap---monthly-publication-march-2025.pdf   424 2025-03 Car Nissan Juke Black Driving without Due Care and Attention None Heaton Street Heaton Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4940041 -1.9162925
16669 op-snap---monthly-publication-march-2025.pdf   426 2025-03 Car Vauxhall Mokka White Driving without Due Care and Attention None Summerhill Street Summerhill Street Birmingham Birmingham Education N/A Yes - Via Email    
16686 op-snap---monthly-publication-march-2025.pdf   443 2025-03 Lorry Land Rover Discovery Grey Driving without Due Care and Attention None M6 jct 9 heading onto M6 south M6 jct 9 heading onto M6 south Birmingham Birmingham Education N/A Yes - Via Email 52.676119 -2.0858425
16688 op-snap---monthly-publication-march-2025.pdf   445 2025-03 Car Vauxhall Astra Blue Driving without Due Care and Attention None A45 Poets Corner Poets Corner Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4647091 -1.8588833
16703 op-snap---monthly-publication-march-2025.pdf   460 2025-03 Car Ford Transit White Driving without Due Care and Attention None B4380 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.6195535 -2.0193824
16704 op-snap---monthly-publication-march-2025.pdf   461 2025-03 Car     Black Driving without Due Care and Attention None Blowers Green Road Blowers Green Road Dudley Dudley NFA Misc Inc Crimes Yes - Via Email 52.5048062 -2.0904536
16715 op-snap---monthly-publication-march-2025.pdf   472 2025-03 Car Citroen Berlingo 1000 Grey Driving without Due Care and Attention None A446 Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
16718 op-snap---monthly-publication-march-2025.pdf   475 2025-03 Car Honda Jazz Grey Driving without Due Care and Attention None B4102 Blossomfield Road Blossomfield Road Solihull Solihull Education N/A Yes - Via Email 52.4144779 -1.7848758
16723 op-snap---monthly-publication-march-2025.pdf   480 2025-03 Car Porsche Cayenne Silver Driving without Due Care and Attention None A51 Little Haywood, Staffs Little Haywood, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16728 op-snap---monthly-publication-march-2025.pdf   485 2025-03 Car Volkswagen Golf Blue Driving without Due Care and Attention None Lichfield Road Lichfield Road Metropolitan Borough of Walsall Walsall Court N/A Yes - Via Email 52.6095168 -2.0493009
16729 op-snap---monthly-publication-march-2025.pdf   486 2025-03 Car Hyundai I10. White Driving without Due Care and Attention None A47 Erdington (Near Fort Shopping Centre) Erdington (Near Fort Shopping Centre) Birmingham Birmingham Warning Letter N/A Yes - Via Email    
16730 op-snap---monthly-publication-march-2025.pdf   487 2025-03 Car BMW R1200RT Red Driving without Due Care and Attention None A525 Whitchurch, Staffs. Whitchurch, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16731 op-snap---monthly-publication-march-2025.pdf   488 2025-03 Car Daf Tractor White Driving without Due Care and Attention None Wolverhampton Road, Kidderminstrer Wolverhampton Road, Kidderminstrer Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16732 op-snap---monthly-publication-march-2025.pdf   489 2025-03 Car Ford Transit White Driving without Due Care and Attention None Packington Avenue Packington Avenue Birmingham Birmingham Court N/A Yes - Via Email 52.490564 -1.7770011
16741 op-snap---monthly-publication-march-2025.pdf   498 2025-03 Pedestrian Honda Civic Yellow Driving without Due Care and Attention None Amesbury Road Amesbury Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4465507 -1.8957752
16744 op-snap---monthly-publication-march-2025.pdf   501 2025-03 Car Vauxhall Corsa White Driving without Due Care and Attention None Stonebridge Highway Stonebridge Highway Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3782187 -1.478696
16747 op-snap---monthly-publication-march-2025.pdf   504 2025-03 Car Mercedes-Benz AMG A35 Grey Driving without Due Care and Attention None Cheltenham Road Cheltenham Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16750 op-snap---monthly-publication-march-2025.pdf   507 2025-03 Car Audi Rs3 Green Driving without Due Care and Attention None Springfield Rd Springfield Road Birmingham Birmingham Court N/A Yes - Via Email 52.4327486 -1.8844997
16751 op-snap---monthly-publication-march-2025.pdf   508 2025-03 Pedestrian Ford Fista White Driving without Due Care and Attention None Tower Street, Dudley Tower Street, Dudley Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5112053 -2.0833165
16756 op-snap---monthly-publication-march-2025.pdf   513 2025-03 Pedestrian Volvo XC40 Black Driving without Due Care and Attention None Herbert Road Herbert Road Solihull Solihull Education N/A Yes - Via Email 52.413399 -1.7818177
16759 op-snap---monthly-publication-march-2025.pdf   516 2025-03 Car Daf Artic White Driving without Due Care and Attention None A45, London Road, Stretton on Dunsmore A45, London Road, Stretton on Dunsmore Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16764 op-snap---monthly-publication-march-2025.pdf   521 2025-03 Car   Royal Alloy Grey Driving without Due Care and Attention None Pelsall Road, Brownhills Pelsall Road, Brownhills Walsall Walsall Warning Letter N/A Yes - Via Email 52.6486073 -1.9363667
16770 op-snap---monthly-publication-march-2025.pdf   527 2025-03 Car   UK   Driving without Due Care and Attention None Yeman Road Yeman Road Sandwell Sandwell NFA No VRM Yes - Via Email 52.4829268 -1.9932127
16771 op-snap---monthly-publication-march-2025.pdf   528 2025-03 Car Ford Transit White Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email 52.5083238 -1.8332287

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