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

275 rows where month = "2025-02", 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 · 275 ✖

offence 1

  • Driving without Due Care and Attention · 275 ✖

month 1

  • 2025-02 · 275 ✖
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
5197 op-snap---monthly-publication-february-2025.pdf   14 2025-02 Car Audi QUATTRO Black Driving without Due Care and Attention None HOLDER ROAD Holder Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4655509 -1.8219
5219 op-snap---monthly-publication-february-2025.pdf   36 2025-02 Car Audi A3 Black Driving without Due Care and Attention None Sewall Highway Sewall Highway Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4318623 -1.4804069
5220 op-snap---monthly-publication-february-2025.pdf   37 2025-02 Car Mercedes-Benz S 350 DL AMG Blue Driving without Due Care and Attention None M42 J11 to J10, TAMWORTH M42 J11 to J10, TAMWORTH Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5227 op-snap---monthly-publication-february-2025.pdf   44 2025-02 Car Mercedes-Benz SPRINTER White Driving without Due Care and Attention None BLACK COUNTRY ROUTE Black Country Route Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
5229 op-snap---monthly-publication-february-2025.pdf   46 2025-02 Car Toyota Aygo Orange Driving without Due Care and Attention None Great Hampton Street Great Hampton Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4910446 -1.9105163
5256 op-snap---monthly-publication-february-2025.pdf   73 2025-02 Car Honda CIVIC BLACK Driving without Due Care and Attention No vehicle excise licence BROMFORD LANE Bromford Lane Birmingham Birmingham Court N/A Yes - Via Email 52.5083238 -1.8332287
5265 op-snap---monthly-publication-february-2025.pdf   82 2025-02 Car Toyota Yaris   Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.4149064 -1.7832364
5266 op-snap---monthly-publication-february-2025.pdf   83 2025-02 Car Volkswagen Polo Silver Driving without Due Care and Attention None Grange Road Grange Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4285724 -1.8019101
5271 op-snap---monthly-publication-february-2025.pdf   88 2025-02 Car Fiat 500 Black Driving without Due Care and Attention None Mackadown Lane Mackadown Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4708415 -1.7675939
5278 op-snap---monthly-publication-february-2025.pdf   95 2025-02 Car Volkswagen T-cross Black Driving without Due Care and Attention None Birchfield Lane Birchfield Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5280 op-snap---monthly-publication-february-2025.pdf   97 2025-02 Car Ford Kuga Grey Driving without Due Care and Attention None Moseley Road Moseley Road Wolverhampton Wolverhampton Court N/A Yes - Via Email 52.5782924 -2.0742911
5290 op-snap---monthly-publication-february-2025.pdf   107 2025-02 Car BMW 320d White Driving without Due Care and Attention None M6 NB J3 M6 Northbound J3 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5291 op-snap---monthly-publication-february-2025.pdf   108 2025-02 Car Skoda Fabia Blue Driving without Due Care and Attention None Bentley Bridge Way towards Backhou Bentley Bridge Way towards Backhou sWe oLlavneerh Ra/mApton Swe Ollavneerh Ra/Mapton Fixed Penalty N/A Yes - Via Email    
5294 op-snap---monthly-publication-february-2025.pdf   111 2025-02 Car Mitsubishi Outlander Blue Driving without Due Care and Attention None M6 Northbound / J10 M6 Northbound / J10 Walsall Walsall Warning Letter N/A Yes - Via Email    
5297 op-snap---monthly-publication-february-2025.pdf   114 2025-02 Car Mercedes-Benz E220 Grey Driving without Due Care and Attention None FRIARY ROAD Friary Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5162814 -1.9395798
5298 op-snap---monthly-publication-february-2025.pdf   115 2025-02 Car Volkswagen GOLF R Black Driving without Due Care and Attention None HIGH STREET, ASTON High Street, Aston Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4973154 -1.8956143
5299 op-snap---monthly-publication-february-2025.pdf   116 2025-02 Car Toyota COROLLA Black Driving without Due Care and Attention None VILLA STREET Villa Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.500382 -1.913307
5302 op-snap---monthly-publication-february-2025.pdf   119 2025-02 Car Audi RS3 Grey Driving without Due Care and Attention None Dawley Telford Dawley Telford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5304 op-snap---monthly-publication-february-2025.pdf   121 2025-02 Car Vauxhall Vivaro White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
5306 op-snap---monthly-publication-february-2025.pdf   123 2025-02 Car Hyundai I20 Blue Driving without Due Care and Attention None ELEANORA STREET, STOKE ON TRENT Eleanora Street, Stoke On Trent Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5314 op-snap---monthly-publication-february-2025.pdf   131 2025-02 Car Nissan Qashqai White Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull NFA No Independent Evidence Available Yes - Via Email 52.4149064 -1.7832364
5323 op-snap---monthly-publication-february-2025.pdf   140 2025-02 Car Ford Fiesat Silver Driving without Due Care and Attention None Stoney Lane Stoney Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4745488 -1.8065911
5324 op-snap---monthly-publication-february-2025.pdf   141 2025-02 Car Toyota PRIUS Silver Driving without Due Care and Attention None PORTLAND ROAD Portland Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4737014 -1.9412436
5331 op-snap---monthly-publication-february-2025.pdf   148 2025-02 Car Volkswagen Polo White Driving without Due Care and Attention No Insurance Church Lane Church Lane Birmingham Birmingham Court N/A Yes - Via Email 52.5030217 -1.8764632
5332 op-snap---monthly-publication-february-2025.pdf   149 2025-02 Car Mercedes-Benz C220 Executive Black Driving without Due Care and Attention None Wolverhampton Road,Sedgley Wolverhampton Road, Sedgley Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5562134 -2.1227301
5333 op-snap---monthly-publication-february-2025.pdf   150 2025-02 Car Mercedes-Benz CLA220 Black Driving without Due Care and Attention None Hagley Rd, Edgbaston Hagley Road, Edgbaston Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4719401 -1.9323711
5353 op-snap---monthly-publication-february-2025.pdf   170 2025-02 Car Porsche Taycan Black Driving without Due Care and Attention None M42 SB J3a M42 Southbound J3a Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5354 op-snap---monthly-publication-february-2025.pdf   171 2025-02 Car Peugeot 2008 White Driving without Due Care and Attention None Alcester Road at Salisbury Road Alcester Road at Salisbury Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4467548 -1.8880528
5356 op-snap---monthly-publication-february-2025.pdf   173 2025-02 Car Vauxhall CORSA White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5357 op-snap---monthly-publication-february-2025.pdf   174 2025-02 Car Mercedes-Benz C CLASS White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5358 op-snap---monthly-publication-february-2025.pdf   175 2025-02 Car Audi A3 White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5359 op-snap---monthly-publication-february-2025.pdf   176 2025-02 Car Seat LEON White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5360 op-snap---monthly-publication-february-2025.pdf   177 2025-02 Car Volkswagen TIGUAN Blue Driving without Due Care and Attention No vehicle excise licence Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5361 op-snap---monthly-publication-february-2025.pdf   178 2025-02 Car Audi A5 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5363 op-snap---monthly-publication-february-2025.pdf   180 2025-02 Car Audi RS3 Silver Driving without Due Care and Attention Use vehicle on a road without valid test certificate Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5364 op-snap---monthly-publication-february-2025.pdf   181 2025-02 Car Hyundai I40 White Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5365 op-snap---monthly-publication-february-2025.pdf   182 2025-02 Car Audi A3 Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4816806 -1.8788939
5368 op-snap---monthly-publication-february-2025.pdf   185 2025-02 Car Ford TRANSIT White Driving without Due Care and Attention None MONICA ROAD Monica Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4714936 -1.8386654
5369 op-snap---monthly-publication-february-2025.pdf   186 2025-02 Car Hyundai Kona Black Driving without Due Care and Attention None College Road College Road Birmingham Birmingham Court N/A Yes - Via Email 52.5151832 -1.9361664
5370 op-snap---monthly-publication-february-2025.pdf   187 2025-02 Car Lexus CT Red Driving without Due Care and Attention None Park Road Park Road Birmingham Birmingham Court N/A Yes - Via Email 52.5641687 -1.8272087
5378 op-snap---monthly-publication-february-2025.pdf   195 2025-02 Car Suzuki GSF1250 Black Driving without Due Care and Attention No Insurance BRANDWOOD Brandwood Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4167623 -1.8959344
5415 op-snap---monthly-publication-february-2025.pdf   232 2025-02 Car Daf   Orange Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4073149 -1.5250454
5421 op-snap---monthly-publication-february-2025.pdf   238 2025-02 Car Volkswagen Passat White Driving without Due Care and Attention None Halesowen Street Halesowen Street Dudley Dudley NFA Not in Public Interest Yes - Via Email 52.4727697 -2.041607
5423 op-snap---monthly-publication-february-2025.pdf   240 2025-02 Car Renault Kadjar Red Driving without Due Care and Attention None Warstones Drive Warstones Drive Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.5684465 -2.1668138
5424 op-snap---monthly-publication-february-2025.pdf   241 2025-02 Car Mercedes-Benz E220 Grey Driving without Due Care and Attention None MORRISONS CRA PARK, WEDNESBUR Morrisons Cra Park, Wednesbur YSandwell Ysandwell Fixed Penalty N/A Yes - Via Email    
5440 op-snap---monthly-publication-february-2025.pdf   257 2025-02 Car Volkswagen Golf Grey Driving without Due Care and Attention None Broadway North Broadway North Walsall Walsall Warning Letter N/A Yes - Via Email 52.5886007 -1.9741222
5441 op-snap---monthly-publication-february-2025.pdf   258 2025-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Rubery Lane Rubery Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4007375 -2.0158237
5445 op-snap---monthly-publication-february-2025.pdf   262 2025-02 Car Honda 125 Blue Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.5133725 -1.9193405
5446 op-snap---monthly-publication-february-2025.pdf   263 2025-02 Car   Scania White Driving without Due Care and Attention None Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield NFA No Offence Yes - Via Email 52.5535276 -1.8302584
5447 op-snap---monthly-publication-february-2025.pdf   264 2025-02 Car   MAN   Driving without Due Care and Attention None Alston Street Alston Street Birmingham Birmingham Education N/A Yes - Via Email 52.4772629 -1.9267359
5450 op-snap---monthly-publication-february-2025.pdf   267 2025-02 Car Volvo XC90 Green Driving without Due Care and Attention None M6 from junction 10A M6 from junction 10A Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
5459 op-snap---monthly-publication-february-2025.pdf   276 2025-02 Car Ford S-max Black Driving without Due Care and Attention No Insurance Vicarage Road Vicarage Road Birmingham Birmingham Court N/A Yes - Via Email 52.470423 -1.9304786
5463 op-snap---monthly-publication-february-2025.pdf   280 2025-02 Car Ford Mondeo Silver Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull Education N/A Yes - Via Email    
5466 op-snap---monthly-publication-february-2025.pdf   283 2025-02 Car Ford Mondeo Silver Driving without Due Care and Attention None Coventry Eastern Bypass Coventry Eastern Bypass Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.3793117 -1.4625379
5468 op-snap---monthly-publication-february-2025.pdf   285 2025-02 Car Suzuki BALENO White Driving without Due Care and Attention None A38 A38 Sutton Coldfield Sutton Coldfield Warning Letter Outside of 14 Days NIP Yes - Via Email    
5482 op-snap---monthly-publication-february-2025.pdf   299 2025-02 Car Ford Focus White Driving without Due Care and Attention None Coventry Road, Bedworth Coventry Road, Bedworth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4560333 -1.485617
5484 op-snap---monthly-publication-february-2025.pdf   301 2025-02 Car Renault Clio White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A Yes - Via Email 52.5359496 -1.8324115
5492 op-snap---monthly-publication-february-2025.pdf   309 2025-02 Car Kia Picanto Blue Driving without Due Care and Attention None Old Horns Crescent, Birmingham Old Horns Crescent, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5506799 -1.9100116
5493 op-snap---monthly-publication-february-2025.pdf   310 2025-02 Car Tesla Model 3 White Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A Yes - Via Email 52.4149064 -1.7832364
5494 op-snap---monthly-publication-february-2025.pdf   311 2025-02 Car Seat Ibiza White Driving without Due Care and Attention None M6 North prior to junction 10 M6 North prior to junction 10 Walsall Walsall Fixed Penalty N/A Yes - Via Email    
5496 op-snap---monthly-publication-february-2025.pdf   313 2025-02 Car Volkswagen Toureg Black Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Education N/A Yes - Via Email    
5497 op-snap---monthly-publication-february-2025.pdf   314 2025-02 Car Lexus CT White Driving without Due Care and Attention No Insurance Warwick Road, Olton Warwick Road, Olton Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5498 op-snap---monthly-publication-february-2025.pdf   315 2025-02 Car Kia EV9 Black Driving without Due Care and Attention None St Marys Row Street Marys Row Birmingham Birmingham Education N/A Yes - Via Email    
5505 op-snap---monthly-publication-february-2025.pdf   322 2025-02 Car Mercedes-Benz GLB 200 AMG White Driving without Due Care and Attention None Hamstead Hill Hamstead Hill Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5274116 -1.9287273
5524 op-snap---monthly-publication-february-2025.pdf   341 2025-02 Car Land Rover Defender Grey Driving without Due Care and Attention None Broad Lane, Bloxwich Broad Lane, Bloxwich Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6263759 -2.0189428
5529 op-snap---monthly-publication-february-2025.pdf   346 2025-02 Car Kia Rio Black Driving without Due Care and Attention None Scarsdale Road Scarsdale Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.540994 -1.9027862
5531 op-snap---monthly-publication-february-2025.pdf   348 2025-02 Car Peugeot 208 Grey Driving without Due Care and Attention None Harbury Lane, Leamingtong Spa Harbury Lane, Leamingtong Spa Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5538 op-snap---monthly-publication-february-2025.pdf   355 2025-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Rowleys Green Roundabout Rowleys Green Roundabout Coventry Coventry Warning Letter N/A Yes - Via Email 52.4486967 -1.4991069
5545 op-snap---monthly-publication-february-2025.pdf   362 2025-02 Car Toyota PRIUS White Driving without Due Care and Attention None ASTON EXPRESSWAY Aston Expressway Birmingham Birmingham Education N/A Yes - Via Email 52.493793 -1.8881773
5547 op-snap---monthly-publication-february-2025.pdf   364 2025-02 Car Vauxhall SIGNUM Grey Driving without Due Care and Attention None FOXOAK STREET Foxoak Street Sandwell Sandwell Warning Letter N/A Yes - Via Email    
5562 op-snap---monthly-publication-february-2025.pdf   379 2025-02 Car Vauxhall ASTRA Silver Driving without Due Care and Attention None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Education N/A Yes - Via Email 52.466118 -1.8982999
5563 op-snap---monthly-publication-february-2025.pdf   380 2025-02 Car Suzuki SX4 Grey Driving without Due Care and Attention None Throne Road Throne Road Sandwell Sandwell Education N/A Yes - Via Email 52.4875572 -2.0284052
5574 op-snap---monthly-publication-february-2025.pdf   391 2025-02 Car Volkswagen Passat Black Driving without Due Care and Attention None Green Lane Green Lane Birmingham Birmingham Court N/A Yes - Via Email 52.4618966 -1.9955421
5578 op-snap---monthly-publication-february-2025.pdf   395 2025-02 Car BMW X5 Black Driving without Due Care and Attention None Cole Bank Road Birmingham Cole Bank Road Birmingham Birmingham Birmingham NFA No VRM Yes - Via Email 52.4349375 -1.8510007
5579 op-snap---monthly-publication-february-2025.pdf   396 2025-02 Car Seat Leon Grey Driving without Due Care and Attention None Cooks Lane Birmingham Cooks Lane Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.482758 -1.7603097
5583 op-snap---monthly-publication-february-2025.pdf   400 2025-02 Car BMW 118D Black Driving without Due Care and Attention None M6, Junction 6 M6, Junction 6 Birmingham Birmingham Court N/A Yes - Via Email 52.6760749 -2.0862582
5586 op-snap---monthly-publication-february-2025.pdf   403 2025-02 Car Ford Mondeo Black Driving without Due Care and Attention No Insurance Halford Lane, Coventry Halford Lane, Coventry Coventry Coventry Court N/A Yes - Via Email 52.4398231 -1.526811
5589 op-snap---monthly-publication-february-2025.pdf   406 2025-02 Car BMW 5 Series Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5590 op-snap---monthly-publication-february-2025.pdf   407 2025-02 Car   Lex Moto Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5591 op-snap---monthly-publication-february-2025.pdf   408 2025-02 Car Volkswagen Golf R White Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5592 op-snap---monthly-publication-february-2025.pdf   409 2025-02 Car Toyota Yaris Silver Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5359496 -1.8324115
5595 op-snap---monthly-publication-february-2025.pdf   412 2025-02 Car   MAN Grey Driving without Due Care and Attention None M6 junction 6-4 M6 junction 6-4 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.676119 -2.0858425
5596 op-snap---monthly-publication-february-2025.pdf   413 2025-02 Car Renault Trucks White Driving without Due Care and Attention None Junction 6 M6 Southbound Junction 6 M6 Southbound Birmingham Birmingham NFA No offence Yes - Via Email    
5600 op-snap---monthly-publication-february-2025.pdf   417 2025-02 Car Ford Fiesta Blue Driving without Due Care and Attention None Highters Heath Road Highters Heath Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4120728 -1.8622915
5605 op-snap---monthly-publication-february-2025.pdf   422 2025-02 Car Mercedes-Benz 400 AMG Black Driving without Due Care and Attention None Portway Road Portway Road Birmingham Birmingham Education N/A Yes - Via Email    
5611 op-snap---monthly-publication-february-2025.pdf   428 2025-02 Car Toyota Auris White Driving without Due Care and Attention None A38 inbound A38 inbound Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5613 op-snap---monthly-publication-february-2025.pdf   430 2025-02 Car Seat Leon Grey Driving without Due Care and Attention None Sheldon Heath Road Sheldon Heath Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4744736 -1.7892633
5616 op-snap---monthly-publication-february-2025.pdf   433 2025-02 Car Toyota Prius White Driving without Due Care and Attention None Booth Street Booth Street Birmingham Birmingham Education N/A Yes - Via Email 52.5039035 -1.9447084
5617 op-snap---monthly-publication-february-2025.pdf   434 2025-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None M42 WB J2 M42 Wb J2 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4945433 -2.0190848
5618 op-snap---monthly-publication-february-2025.pdf   435 2025-02 Car Kia Rio Silver Driving without Due Care and Attention None Heybarnes Road Heybarnes Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4677423 -1.8351236
5619 op-snap---monthly-publication-february-2025.pdf   436 2025-02 Car Peugeot 107 Black Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4624743 -1.7763934
5625 op-snap---monthly-publication-february-2025.pdf   442 2025-02 Car Vauxhall Corsa Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Court N/A Yes - Via Email 52.4308271 -1.920078
5645 op-snap---monthly-publication-february-2025.pdf   462 2025-02 Car Mercedes-Benz Benz Black Driving without Due Care and Attention None Yew Tree Walsall Yew Tree Walsall Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.559139 -1.9601491
5652 op-snap---monthly-publication-february-2025.pdf   469 2025-02 Car Volkswagen Jetta Grey Driving without Due Care and Attention None Oxford Street Oxford Street Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.5651361 -2.0707545
5674 op-snap---monthly-publication-february-2025.pdf   491 2025-02 Car Volkswagen GOLF R Black Driving without Due Care and Attention None Bishopgate Stret Bishopgate Stret Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email    
5676 op-snap---monthly-publication-february-2025.pdf   493 2025-02 Car Volkswagen Golf White Driving without Due Care and Attention None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.472238 -1.9127983
5686 op-snap---monthly-publication-february-2025.pdf   503 2025-02 Car Seat Arona Grey Driving without Due Care and Attention None Coleshill Road Coleshill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4967329 -1.8097462
5691 op-snap---monthly-publication-february-2025.pdf   508 2025-02 Car BMW M140I Blue Driving without Due Care and Attention None Frankley Hill Lane Frankley Hill Lane Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4212768 -2.0127161
5692 op-snap---monthly-publication-february-2025.pdf   509 2025-02 Car BMW 218i Grey Driving without Due Care and Attention None M5 South, J1 M5 South, J1 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5694 op-snap---monthly-publication-february-2025.pdf   511 2025-02 Car     Orange Driving without Due Care and Attention None A459 SALTWELLS A459 Saltwells Dudley Dudley NFA No VRM Yes - Via Email 52.479633 -2.0918494

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