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

289 rows where month = "2025-01" 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 28

reporter_transport_mode 9

offence 1

  • Driving without Due Care and Attention · 289 ✖

month 1

  • 2025-01 · 289 ✖
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
8892 op-snap---monthly-publication-january-2025.pdf   0 2025-01 Pedestrian Ford Focus ST Grey Driving without Due Care and Attention No Insurance Bishopsgate Street, Birmingham Bishopsgate Street, Birmingham Birmingham Birmingham Court N/A Yes - Via Email 52.4729735 -1.9122898
8895 op-snap---monthly-publication-january-2025.pdf   3 2025-01 Car Mitsubishi Colt Brown Driving without Due Care and Attention No Insurance LICHFIELD ROAD Lichfield Road Walsall Walsall Court N/A Yes - Via Email 52.6095168 -2.0493009
8897 op-snap---monthly-publication-january-2025.pdf   5 2025-01 Car Audi A1 Blue Driving without Due Care and Attention None MEADWAY Meadway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4783348 -1.8007708
8898 op-snap---monthly-publication-january-2025.pdf   6 2025-01 Car BMW 7 Series White Driving without Due Care and Attention None M6 Motorway near 10a Southbound M6 Motorway near 10a Southbound Walsall Walsall Warning Letter N/A Yes - Via Email    
8899 op-snap---monthly-publication-january-2025.pdf   7 2025-01 Car BMW 4330D Black Driving without Due Care and Attention None STRATFORD ROAD Stratford Road BIRMINGHAM Birmingham Fixed Penalty N/A Yes - Via Email 52.4203897 -1.8338574
8900 op-snap---monthly-publication-january-2025.pdf   8 2025-01 Car Mg HS Black Driving without Due Care and Attention None M6 Motorway near J9 Southbound M6 Motorway near J9 Southbound Walsall Walsall Fixed Penalty N/A Yes - Via Email    
8901 op-snap---monthly-publication-january-2025.pdf   9 2025-01 Pedestrian BMW M3 Black Driving without Due Care and Attention None WATERFRONT CAR PARK Waterfront Car Park Dudley Dudley Court N/A Yes - Via Email    
8902 op-snap---monthly-publication-january-2025.pdf   10 2025-01 Car Audi   Black Driving without Due Care and Attention None Pershore Road, Birmingham Pershore Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4163285 -1.9286689
8910 op-snap---monthly-publication-january-2025.pdf   18 2025-01 Pedal Bike Volkswagen POLO Black Driving without Due Care and Attention None HEATH LANE Heath Lane Dudley Dudley Education N/A Yes - Via Email 52.4495524 -2.1459067
8912 op-snap---monthly-publication-january-2025.pdf   20 2025-01 Car Seat LEON Black Driving without Due Care and Attention None LONGBRIDGE LANE Longbridge Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.3962003 -1.9821252
8918 op-snap---monthly-publication-january-2025.pdf   26 2025-01 Car Honda Civic Silver Driving without Due Care and Attention No Insurance Pedmore Road Pedmore Road Dudley Dudley Court N/A Yes - Via Email 52.4897451 -2.1069141
8920 op-snap---monthly-publication-january-2025.pdf   28 2025-01 Car Mercedes-Benz C220 Blue Driving without Due Care and Attention None M42 J3 M42 J3 Solihull Solihull NFA Out of Force Yes - Via Email 52.4846642 -1.9297585
8922 op-snap---monthly-publication-january-2025.pdf   30 2025-01 Pedal Bike BMW X2 Blue Driving without Due Care and Attention None Brandwood Road Brandwood Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4139427 -1.9037653
8930 op-snap---monthly-publication-january-2025.pdf   38 2025-01 Car Audi s3 Blue Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5083238 -1.8332287
8933 op-snap---monthly-publication-january-2025.pdf   41 2025-01 Car Toyota Yaris Blue Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
8934 op-snap---monthly-publication-january-2025.pdf   42 2025-01 Car Mercedes-Benz C43 Grey Driving without Due Care and Attention None Yew Tree Lane Yew Tree Lane Birmingham Birmingham NFA No Offence Yes - Via Email 52.4631 -1.8082055
8942 op-snap---monthly-publication-january-2025.pdf   50 2025-01 Car Renault TRANSIT Grey Driving without Due Care and Attention None MANOR WAY Manor Way Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5211993 -1.8242643
8943 op-snap---monthly-publication-january-2025.pdf   51 2025-01 Car Volkswagen Golf Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
8947 op-snap---monthly-publication-january-2025.pdf   55 2025-01 Pedestrian Ford Mustang Blue Driving without Due Care and Attention None Grey 7 Car park, Waterfront Merry Hill Grey 7 Car park, Waterfront Merry Hill Dudley Dudley Court N/A Yes - Via Email    
8949 op-snap---monthly-publication-january-2025.pdf   57 2025-01 Car Audi A6 Silver Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Court N/A Yes - Via Email 52.5458699 -1.9304484
8975 op-snap---monthly-publication-january-2025.pdf   83 2025-01 Car Audi S3 Yellow Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
8976 op-snap---monthly-publication-january-2025.pdf   84 2025-01 Car Renault Clio Blue Driving without Due Care and Attention None Alma Street Alma Street Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.5546385 -2.0062935
8977 op-snap---monthly-publication-january-2025.pdf   85 2025-01 Pedestrian Ford Fiesta Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
8987 op-snap---monthly-publication-january-2025.pdf   95 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Leamore Lane Leamore Lane Walsall Walsall Court N/A Yes - Via Email 52.6056653 -2.0050776
8989 op-snap---monthly-publication-january-2025.pdf   97 2025-01 Car   DACIA DUSTER White Driving without Due Care and Attention None DARLASTON ROAD Darlaston Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5635181 -2.0322876
8994 op-snap---monthly-publication-january-2025.pdf   102 2025-01 Car Audi RS6 Black Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4198291 -1.9241732
8996 op-snap---monthly-publication-january-2025.pdf   104 2025-01 Pedestrian BMW COMPETITION Blue Driving without Due Care and Attention None MERRYHILL CENTRE CAR PARK 7 Merryhill Centre Car Park 7 Dudley Dudley Court N/A Yes - Via Email    
9000 op-snap---monthly-publication-january-2025.pdf   108 2025-01 Pedestrian BMW COMPETITION Blue Driving without Due Care and Attention VRM fails to conform to Regulations MERRYHILL CENTRE CAR PARK 7 Merryhill Centre Car Park 7 Dudley Dudley Fixed Penalty N/A Yes - Via Email    
9001 op-snap---monthly-publication-january-2025.pdf   109 2025-01 Bus Daf bus Blue Driving without Due Care and Attention None Summer Row Summer Row Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4813439 -1.9074798
9009 op-snap---monthly-publication-january-2025.pdf   117 2025-01 Car Nissan TILDA Brown Driving without Due Care and Attention No Insurance EVERDON ROAD Everdon Road Coventry Coventry Court N/A Yes - Via Email 52.4400643 -1.5135763
9011 op-snap---monthly-publication-january-2025.pdf   119 2025-01 Car BMW X5 Blue Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9019 op-snap---monthly-publication-january-2025.pdf   127 2025-01 Car BMW 530E White Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
9022 op-snap---monthly-publication-january-2025.pdf   130 2025-01 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A Yes - Via Email 52.4543565 -1.9114004
9024 op-snap---monthly-publication-january-2025.pdf   132 2025-01 Car Audi Q3 Silver Driving without Due Care and Attention None Birchley island Birchley island Birmingham Birmingham Education N/A Yes - Via Email    
9034 op-snap---monthly-publication-january-2025.pdf   142 2025-01 Car Nissan Navara Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6095168 -2.0493009
9036 op-snap---monthly-publication-january-2025.pdf   144 2025-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5344405 -1.985568
9060 op-snap---monthly-publication-january-2025.pdf   168 2025-01 Car Seat Unknown Black Driving without Due Care and Attention None Palmerston Road Palmerston Road Birmingham Birmingham RTC - Actioned N/A Yes - Via Email 52.4599575 -1.8708964
9063 op-snap---monthly-publication-january-2025.pdf   171 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None The Green, Kings Norton The Green, Kings Norton Birmingham Birmingham NFA No Offence Yes - Via Email 52.4065866 -1.9308921
9066 op-snap---monthly-publication-january-2025.pdf   174 2025-01 Car Renault Master White Driving without Due Care and Attention None M42 Junction 9 M42 Junction 9 Birmingham Birmingham Court N/A Yes - Via Email 52.3601724 -1.8062199
9067 op-snap---monthly-publication-january-2025.pdf   175 2025-01 Pedestrian Jaguar UK Blue Driving without Due Care and Attention None unknown   Birmingham Birmingham NFA No VRM Yes - Via Email    
9068 op-snap---monthly-publication-january-2025.pdf   176 2025-01 Lorry Honda CTV Silver Driving without Due Care and Attention None A448 BROMSGROVE A448 Bromsgrove Birmingham Birmingham NFA Out of Force Yes - Via Email 52.4728322 -1.897536
9088 op-snap---monthly-publication-january-2025.pdf   196 2025-01 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A Yes - Via Email 52.4070602 -1.4732469
9094 op-snap---monthly-publication-january-2025.pdf   202 2025-01 Car Suzuki Swift Grey Driving without Due Care and Attention Use vehicle on a road without valid test c ePratrifkigcaattee Road e Pratrifkigcaattee Road Coventry Coventry Fixed Penalty N/A Yes - Via Email    
9095 op-snap---monthly-publication-january-2025.pdf   203 2025-01 Car Volkswagen Sharan Black Driving without Due Care and Attention None Villa Road, Handsworth Villa Road, Handsworth Birmingham Birmingham Education N/A Yes - Via Email    
9096 op-snap---monthly-publication-january-2025.pdf   204 2025-01 Pedestrian Mercedes-Benz CLA 220 White Driving without Due Care and Attention None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Education N/A Yes - Via Email 52.4418944 -1.8407335
9097 op-snap---monthly-publication-january-2025.pdf   205 2025-01 Pedestrian Ford Focus Grey Driving without Due Care and Attention No Insurance Sherborne Street Sherborne Street Birmingham Birmingham Court N/A Yes - Via Email 52.4762433 -1.9176665
9098 op-snap---monthly-publication-january-2025.pdf   206 2025-01 Car Ford Focus Silver Driving without Due Care and Attention No Insurance Hunters Road, Lozells Hunters Road, Lozells Birmingham Birmingham Court N/A Yes - Via Email 52.5011362 -1.9175837
9102 op-snap---monthly-publication-january-2025.pdf   210 2025-01 Car Mercedes-Benz GL350 Black Driving without Due Care and Attention None A41 A41 Birmingham Birmingham Court N/A Yes - Via Email    
9109 op-snap---monthly-publication-january-2025.pdf   217 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Causeway Green Road Causeway Green Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4831146 -2.0169818
9113 op-snap---monthly-publication-january-2025.pdf   221 2025-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Fort Parkway Fort Parkway Birmingham Birmingham Education N/A Yes - Via Email 52.50787 -1.8195713
9120 op-snap---monthly-publication-january-2025.pdf   228 2025-01 Car Toyota Yaris black Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.548449 -1.8594603
9123 op-snap---monthly-publication-january-2025.pdf   231 2025-01 Car Audi A1 Grey Driving without Due Care and Attention None Poundgate Lane Poundgate Lane Coventry Coventry Court N/A Yes - Via Email 52.3899397 -1.592199
9125 op-snap---monthly-publication-january-2025.pdf   233 2025-01 Car Mini Cooper Blue Driving without Due Care and Attention None Water Orton Road Water Orton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5153394 -1.7573409
9128 op-snap---monthly-publication-january-2025.pdf   236 2025-01 Car Citroen Space Tourer Orange Driving without Due Care and Attention None Highpark Avenue, Stourbridge Highpark Avenue, Stourbridge Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.4536084 -2.1694631
9135 op-snap---monthly-publication-january-2025.pdf   243 2025-01 Car Volkswagen Passat Grey Driving without Due Care and Attention None Vanguard Avenue Vanguard Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4031729 -1.5564338
9140 op-snap---monthly-publication-january-2025.pdf   248 2025-01 Pedestrian Mg ZS White Driving without Due Care and Attention None Regent Street Regent Street Birmingham Birmingham Education N/A Yes - Via Email 52.4291721 -1.9250565
9141 op-snap---monthly-publication-january-2025.pdf   249 2025-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Bordesley Green East Bordesley Green East Birmingham Birmingham Court N/A Yes - Via Email 52.4802441 -1.8327073
9143 op-snap---monthly-publication-january-2025.pdf   251 2025-01 Car Kia Ceed Blue Driving without Due Care and Attention None Victoria St, Stourbridge Victoria Street, Stourbridge Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9144 op-snap---monthly-publication-january-2025.pdf   252 2025-01 Pedal Bike Toyota Rav 4 Black Driving without Due Care and Attention None Droitwich Road Droitwich Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9155 op-snap---monthly-publication-january-2025.pdf   263 2025-01 Car Renault UNKNOWN Blue Driving without Due Care and Attention None Portland Road Portland Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4737014 -1.9412436
9156 op-snap---monthly-publication-january-2025.pdf   264 2025-01 Other Land Rover Sport Black Driving without Due Care and Attention None Glenville Street Glenville Street Birmingham Birmingham Court N/A Yes - Via Email    
9158 op-snap---monthly-publication-january-2025.pdf   266 2025-01 Pedal Bike BMW ? White Driving without Due Care and Attention None Birmingham Street, Stourbridge Birmingham Street, Stourbridge Dudley Dudley NFA No VRM Yes - Via Email 52.4571139 -2.1359828
9160 op-snap---monthly-publication-january-2025.pdf   268 2025-01 Lorry BMW X1 Silver Driving without Due Care and Attention None Holmer Road, HEREFORD Holmer Road, HEREFORD Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9169 op-snap---monthly-publication-january-2025.pdf   277 2025-01 Car Toyota Yaris Grey Driving without Due Care and Attention None Oxhill Road Oxhill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.513857 -1.9367367
9171 op-snap---monthly-publication-january-2025.pdf   279 2025-01 Pedestrian BMW 318 Black Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4762433 -1.9176665
9174 op-snap---monthly-publication-january-2025.pdf   282 2025-01 Other BMW 318D Silver Driving without Due Care and Attention None Grey 7 Car Park, Waterfront Way, Merry Hill Grey 7 Car Park, Waterfront Way, Merry Hill Dudley Dudley Fixed Penalty N/A Yes - Via Email    
9182 op-snap---monthly-publication-january-2025.pdf   290 2025-01 Car Peugeot 107 Black Driving without Due Care and Attention None Lillington Road Lillington Road Coventry Coventry RTC - Actioned N/A Yes - Via Email 52.4383714 -1.4621918
9183 op-snap---monthly-publication-january-2025.pdf   291 2025-01 Pedal Bike Honda Jazz Red Driving without Due Care and Attention None Stoneleigh Road, Stareton, Kenilworth, WARWICKSHIRE Stoneleigh Road, Stareton, Kenilworth, WARWICKSHIRE Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9185 op-snap---monthly-publication-january-2025.pdf   293 2025-01 Car Peugeot   Black Driving without Due Care and Attention None B4121 B4121 Birmingham Birmingham NFA No VRM Yes - Via Email 52.4448693 -1.9772096
9186 op-snap---monthly-publication-january-2025.pdf   294 2025-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Six Ways Lozells Six Ways Lozells Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.502463 -1.8995194
9191 op-snap---monthly-publication-january-2025.pdf   299 2025-01 Car Ford KA Silver Driving without Due Care and Attention None Newport Road Newport Road Birmingham Birmingham Education N/A Yes - Via Email 52.5027779 -1.7982159
9193 op-snap---monthly-publication-january-2025.pdf   301 2025-01 Car Toyota Auris White Driving without Due Care and Attention None A441 Birmingham Road, Alvechurch, WEST MERCIA. Birmingham Road, Alvechurch, WEST MERCIA Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9196 op-snap---monthly-publication-january-2025.pdf   304 2025-01 Pedal Bike Mini Cooper S Silver Driving without Due Care and Attention None A452 Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
9197 op-snap---monthly-publication-january-2025.pdf   305 2025-01 Pedal Bike Mercedes-Benz GLA 220 Blue Driving without Due Care and Attention None A452 Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
9226 op-snap---monthly-publication-january-2025.pdf   334 2025-01 Car Seat Arona Black Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4865107 -1.9386263
9233 op-snap---monthly-publication-january-2025.pdf   341 2025-01 Car Peugeot Allure Red Driving without Due Care and Attention None Worcester Street roundabout Worcester Street roundabout Dudley Dudley Warning Letter N/A Yes - Via Email    
9250 op-snap---monthly-publication-january-2025.pdf   358 2025-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9251 op-snap---monthly-publication-january-2025.pdf   359 2025-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9252 op-snap---monthly-publication-january-2025.pdf   360 2025-01 Pedestrian Ford Fiesta Grey Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9253 op-snap---monthly-publication-january-2025.pdf   361 2025-01 Pedestrian BMW 118 Red Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9254 op-snap---monthly-publication-january-2025.pdf   362 2025-01 Pedestrian Skoda Citigo Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A Yes - Via Email    
9255 op-snap---monthly-publication-january-2025.pdf   363 2025-01 Car Mercedes-Benz BENZ Black Driving without Due Care and Attention None MONTAGUE STREET Montague Street Birmingham Birmingham Education N/A Yes - Via Email 52.4816806 -1.8788939
9256 op-snap---monthly-publication-january-2025.pdf   364 2025-01 Car Ford Transit White Driving without Due Care and Attention None Deans Road Deans Road Wolverhampton Wolverhampton Education N/A Yes - Via Email 52.5930404 -2.1026254
9257 op-snap---monthly-publication-january-2025.pdf   365 2025-01 Car Land Rover SPORT Red Driving without Due Care and Attention None MONTAGUE STREET Montague Street Birmingham Birmingham Education N/A Yes - Via Email 52.4816806 -1.8788939
9258 op-snap---monthly-publication-january-2025.pdf   366 2025-01 Car     Black Driving without Due Care and Attention None STRATFORD ROAD Stratford Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4203897 -1.8338574
9266 op-snap---monthly-publication-january-2025.pdf   374 2025-01 Car Toyota AYGO White Driving without Due Care and Attention None BILLS LANE Bills Lane Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.3998632 -1.8392819
9267 op-snap---monthly-publication-january-2025.pdf   375 2025-01 Car Ford Transit Blue Driving without Due Care and Attention None Genners lane Genners lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4282602 -1.9861769
9268 op-snap---monthly-publication-january-2025.pdf   376 2025-01 Car Ford MONDEO Silver Driving without Due Care and Attention None A34 EARLS BARTON A34 Earls Barton Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9271 op-snap---monthly-publication-january-2025.pdf   379 2025-01 Pedal Bike Hyundai I10 Blue Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A Yes - Via Email 52.4223176 -1.8253145
9280 op-snap---monthly-publication-january-2025.pdf   388 2025-01 Car Vauxhall Astra Blue Driving without Due Care and Attention None White City Road White City Road Birmingham Birmingham Education N/A Yes - Via Email    
9289 op-snap---monthly-publication-january-2025.pdf   397 2025-01 Car Ford Transit White Driving without Due Care and Attention None Shenley Lane Shenley Lane Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.430111 -1.9753703
9292 op-snap---monthly-publication-january-2025.pdf   400 2025-01 Car Audi S3 Black Driving without Due Care and Attention None Caldwell Road Caldwell Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4847159 -1.8263643
9296 op-snap---monthly-publication-january-2025.pdf   404 2025-01 Car Audi SQ5 Blue 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
9297 op-snap---monthly-publication-january-2025.pdf   405 2025-01 Car Peugeot 308 Black Driving without Due Care and Attention None Old Birchills Old Birchills Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.5906268 -1.9967503
9298 op-snap---monthly-publication-january-2025.pdf   406 2025-01 Car Seat Ateca Silver 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
9305 op-snap---monthly-publication-january-2025.pdf   413 2025-01 Car BMW 320i Black Driving without Due Care and Attention None Hall Lane, Bilston Hall Lane, Bilston Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.6042914 -2.0594043
9323 op-snap---monthly-publication-january-2025.pdf   431 2025-01 Car Nissan Qashqai Grey Driving without Due Care and Attention None Longfellow Road Longfellow Road Coventry Coventry NFA No VRM Yes - Via Email 52.4102345 -1.4609881
9325 op-snap---monthly-publication-january-2025.pdf   433 2025-01 Car Vauxhall Movano White Driving without Due Care and Attention None Rushmead Grove Rushmead Grove Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.3929966 -2.0138354
9331 op-snap---monthly-publication-january-2025.pdf   439 2025-01 Car Audi Q? Black Driving without Due Care and Attention VRM fails to conform to Regulations Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A Yes - Via Email 52.5292752 -1.7618805
9345 op-snap---monthly-publication-january-2025.pdf   453 2025-01 Car Ford TRANSIT White Driving without Due Care and Attention NONE MALBOROUGH WAY, TAMWORTH Malborough Way, Tamworth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    

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