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

382 rows where month = "2025-03", 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: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Car · 382 ✖

offence 1

  • Driving without Due Care and Attention · 382 ✖

month 1

  • 2025-03 · 382 ✖
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
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
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
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
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    
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
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    
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
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    
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
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
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
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
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    
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
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
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
16775 op-snap---monthly-publication-march-2025.pdf   532 2025-03 Car Vauxhall Corsa Black Driving without Due Care and Attention None Church Lane Church Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5030217 -1.8764632
16781 op-snap---monthly-publication-march-2025.pdf   538 2025-03 Car Audi Q7 Grey Driving without Due Care and Attention No Insurance ROTTEN PARK ROAD Rotten Park Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
16784 op-snap---monthly-publication-march-2025.pdf   541 2025-03 Car Kia Ceed Silver Driving without Due Care and Attention None Green Street, Coseley Green Street, Coseley Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
16788 op-snap---monthly-publication-march-2025.pdf   545 2025-03 Car Mercedes-Benz A250 Grey Driving without Due Care and Attention None A491 Stream Road/High Street Stream Road/High Street Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4871725 -2.1623764
16790 op-snap---monthly-publication-march-2025.pdf   547 2025-03 Car Audi A4 White Driving without Due Care and Attention No vehicle excise licence SCHOOL ROAD School Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4161736 -1.8619692
16795 op-snap---monthly-publication-march-2025.pdf   552 2025-03 Car Volkswagen Polo Black Driving without Due Care and Attention None Level Street, Brierley Hill Level Street, Brierley Hill Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4850236 -2.1088919
16796 op-snap---monthly-publication-march-2025.pdf   553 2025-03 Car Audi Q5 Black Driving without Due Care and Attention None Level Street, Brierley Hill Level Street, Brierley Hill Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4850236 -2.1088919
16797 op-snap---monthly-publication-march-2025.pdf   554 2025-03 Car Volkswagen GOLF Black Driving without Due Care and Attention None JUNCTION 10 M6 Junction 10 M6 Wolverhampton Wolverhampton Education N/A Yes - Via Email    
16801 op-snap---monthly-publication-march-2025.pdf   558 2025-03 Car Volkswagen Golf White Driving without Due Care and Attention None Stratford Road, Shirley. Stratford Road, Shirley Solihull Solihull Court N/A Yes - Via Email 52.4191731 -1.8324357
16802 op-snap---monthly-publication-march-2025.pdf   559 2025-03 Car Skoda Kodiaq Black Driving without Due Care and Attention None Severne Road, Accoks Green Severne Road, Accoks Green Birmingham Birmingham Court N/A Yes - Via Email    
16803 op-snap---monthly-publication-march-2025.pdf   560 2025-03 Car Nissan Juke White Driving without Due Care and Attention None Sherlock Street, Birmingham Sherlock Street, Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.4723406 -1.8933053
16808 op-snap---monthly-publication-march-2025.pdf   565 2025-03 Car BMW 120D Grey Driving without Due Care and Attention None Stourbridge Road Stourbridge Road Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5002997 -2.1081386
16810 op-snap---monthly-publication-march-2025.pdf   567 2025-03 Car Audi A4 Silver Driving without Due Care and Attention No Insurance Bradeley Lane, Coseley Bradeley Lane, Coseley Wolverhampton Wolverhampton NFA No VRM Yes - Via Email    
16811 op-snap---monthly-publication-march-2025.pdf   568 2025-03 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
16816 op-snap---monthly-publication-march-2025.pdf   573 2025-03 Car Volkswagen Tiguan White Driving without Due Care and Attention None A38 Bristol Street Bristol Street Birmingham Birmingham Education N/A Yes - Via Email 52.4691145 -1.9003257
16820 op-snap---monthly-publication-march-2025.pdf   577 2025-03 Car Ford Fiesta Grey Driving without Due Care and Attention None M5 South junction 1 to junction 2 M5 South junction 1 to junction 2 Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
16825 op-snap---monthly-publication-march-2025.pdf   582 2025-03 Car Honda Accord Silver Driving without Due Care and Attention None Hobs moat road Hobs moat road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4515649 -1.7820482
16840 op-snap---monthly-publication-march-2025.pdf   597 2025-03 Car Volvo V90 White Driving without Due Care and Attention None Wolverhampton Road J 2 off M5 Wolverhampton Road J 2 off M5 Sandwell Sandwell NFA No Offence Yes - Via Email    
16845 op-snap---monthly-publication-march-2025.pdf   602 2025-03 Car Mini Cooper Green Driving without Due Care and Attention None M42, Birmingham M42, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4796992 -1.9026911
16873 op-snap---monthly-publication-march-2025.pdf   630 2025-03 Car BMW 2 series Grey Driving without Due Care and Attention No Insurance M5 Southbound approaching Jn1 M5 Southbound approaching Jn1 Sandwell Sandwell Court N/A Yes - Via Email    
16878 op-snap---monthly-publication-march-2025.pdf   635 2025-03 Car Seat Mii. Silver Driving without Due Care and Attention none Kingstanding Road Kingstanding Road Birmingham Birmingham Education N/A Yes - Via Email 52.5521118 -1.8845138
16880 op-snap---monthly-publication-march-2025.pdf   637 2025-03 Car Skoda Kodiaq Blue Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.502683 -1.9033516
16881 op-snap---monthly-publication-march-2025.pdf   638 2025-03 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Green Street Green Street Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4737217 -1.8844945

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