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

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

offence 1

  • Driving without Due Care and Attention · 221 ✖

month 1

  • 2025-01 · 221 ✖
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
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    
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
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
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
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
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
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
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
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    
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
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    
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
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
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
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    
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    
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    
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    
9350 op-snap---monthly-publication-january-2025.pdf   458 2025-01 Car Audi E-Tron White Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Dudley Dudley Education N/A Yes - Via Email 52.5000055 -2.1844503
9352 op-snap---monthly-publication-january-2025.pdf   460 2025-01 Car BMW 330D Black Driving without Due Care and Attention None Hollybank Road Hollybank Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4236341 -1.8787502
9361 op-snap---monthly-publication-january-2025.pdf   469 2025-01 Car Mercedes-Benz A250 White Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5458699 -1.9304484
9367 op-snap---monthly-publication-january-2025.pdf   475 2025-01 Car       Driving without Due Care and Attention None Hertford Road Hertford Road Solihull Solihull NFA Misc Inc Crimes Yes - Via Email    
9368 op-snap---monthly-publication-january-2025.pdf   476 2025-01 Car Mercedes-Benz A-180 Black Driving without Due Care and Attention None Saltley Viaduct Saltley Viaduct Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4920836 -1.8619149
9377 op-snap---monthly-publication-january-2025.pdf   485 2025-01 Car Toyota VERSO White Driving without Due Care and Attention None Gibbins Road, Selly Oak Gibbins Road, Selly Oak Birmingham Birmingham Court N/A Yes - Via Email 52.4390303 -1.9512931
9390 op-snap---monthly-publication-january-2025.pdf   498 2025-01 Car Volkswagen POLO Red Driving without Due Care and Attention None HAMSTEAD ROAD Hamstead Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.505832 -1.92002
9396 op-snap---monthly-publication-january-2025.pdf   504 2025-01 Car Volkswagen PASSAT Black Driving without Due Care and Attention None Park Road Park Road Dudley Dudley Court N/A Yes - Via Email 52.4566333 -2.1646355
9398 op-snap---monthly-publication-january-2025.pdf   506 2025-01 Car Honda Jazz Blue Driving without Due Care and Attention None A45 Island Poets Corner Island Poets Corner Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
9402 op-snap---monthly-publication-january-2025.pdf   510 2025-01 Car Ford TRANSIT Black Driving without Due Care and Attention None SPON END Spon End Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.5071465 -2.0049226
9404 op-snap---monthly-publication-january-2025.pdf   512 2025-01 Car Volkswagen PASSAT Brown Driving without Due Care and Attention None LEAMINGTON ROAD Leamington Road Coventry Coventry Education N/A Yes - Via Email 52.3921304 -1.5156601
9407 op-snap---monthly-publication-january-2025.pdf   515 2025-01 Car BMW X6 Black Driving without Due Care and Attention None M6 J3 M6 J3 Coventry Coventry NFA Out of Force Yes - Via Email 52.6912652 -2.1043715
9408 op-snap---monthly-publication-january-2025.pdf   516 2025-01 Car Yamaha YS 125 Red Driving without Due Care and Attention None High Street, Kingswinford High Street, Kingswinford Dudley Dudley Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4975687 -2.1672039
9409 op-snap---monthly-publication-january-2025.pdf   517 2025-01 Car Seat LEON CUPRA Grey Driving without Due Care and Attention None M42 SOUTH 3A TO 3 M42 South 3A To 3 Solihull Solihull NFA Out of Force Yes - Via Email    
9423 op-snap---monthly-publication-january-2025.pdf   531 2025-01 Car Kia Sportage Silver Driving without Due Care and Attention None Pelsall Road Pelsall Road Walsall Walsall Court N/A Yes - Via Email 52.6472723 -1.9393233
9431 op-snap---monthly-publication-january-2025.pdf   539 2025-01 Car Ford RANGER Black Driving without Due Care and Attention None BONEHILL ROAD,TAMWORTH Bonehill Road, Tamworth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9437 op-snap---monthly-publication-january-2025.pdf   545 2025-01 Car Ford FOCUS Blue Driving without Due Care and Attention None CLIFFORD BRIDGE Clifford Bridge Coventry Coventry Court N/A Yes - Via Email 52.4216147 -1.4476476
9440 op-snap---monthly-publication-january-2025.pdf   548 2025-01 Car Audi A4 Grey Driving without Due Care and Attention None Halfway House Lane, Bridgenorth Halfway House Lane, Bridgenorth Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9444 op-snap---monthly-publication-january-2025.pdf   552 2025-01 Car Volkswagen Polo Blue Driving without Due Care and Attention None Weir Lane, Worcester Weir Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9448 op-snap---monthly-publication-january-2025.pdf   556 2025-01 Car Mercedes-Benz A180 Red Driving without Due Care and Attention None BROADWAY Broadway Walsall Walsall Warning Letter N/A Yes - Via Email 52.5719937 -1.9639882
9460 op-snap---monthly-publication-january-2025.pdf   568 2025-01 Car BMW M2 Grey Driving without Due Care and Attention No Insurance FAR MOOR LANE, REDDITCH Far Moor Lane, Redditch Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9462 op-snap---monthly-publication-january-2025.pdf   570 2025-01 Car Vauxhall AGILA Black Driving without Due Care and Attention None HIGH STREET,KINGS HEATH High Street, Kings Heath Birmingham Birmingham Court N/A Yes - Via Email 52.4353506 -1.8927483
9473 op-snap---monthly-publication-january-2025.pdf   581 2025-01 Car Seat IBIZA White Driving without Due Care and Attention Contravening a Red Traffic Light CAKEMORE ROAD. ROWLEY REGIS Cakemore Road. Rowley Regis Sandwell Sandwell Court N/A Yes - Via Email    
9474 op-snap---monthly-publication-january-2025.pdf   582 2025-01 Car Ford FIESTA Grey Driving without Due Care and Attention None TESSALL LANE Tessall Lane Birmingham Birmingham NFA No VRM Yes - Via Email 52.4045186 -1.9891793
9477 op-snap---monthly-publication-january-2025.pdf   585 2025-01 Car       Driving without Due Care and Attention None Near Coventry Hospital Near Coventry Hospital Coventry Coventry RTC - Actioned N/A Yes - Via Email    
9482 op-snap---monthly-publication-january-2025.pdf   590 2025-01 Car Kia Pro Ceed Grey Driving without Due Care and Attention No Insurance Sharmans Cross Road Sharmans Cross Road Solihull Solihull Court N/A Yes - Via Email 52.4167172 -1.7990388
9503 op-snap---monthly-publication-january-2025.pdf   611 2025-01 Car Hyundai Ionic Silver Driving without Due Care and Attention None Watery Lane Middleway Watery Lane Middleway Birmingham Birmingham Education N/A Yes - Via Email 52.4752679 -1.8748608
9505 op-snap---monthly-publication-january-2025.pdf   613 2025-01 Car Mercedes-Benz E CLASS Black Driving without Due Care and Attention None FACTOR ROAD Factor Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
9507 op-snap---monthly-publication-january-2025.pdf   615 2025-01 Car Mini Cooper Red Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A Yes - Via Email 52.4203897 -1.8338574
9511 op-snap---monthly-publication-january-2025.pdf   619 2025-01 Car Seat Ibiza Red Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4668753 -1.8996143
9519 op-snap---monthly-publication-january-2025.pdf   627 2025-01 Car Hyundai TUCSAON Grey Driving without Due Care and Attention None M6 N/B M6 Northbound Birmingham Birmingham Education N/A Yes - Via Email    
9520 op-snap---monthly-publication-january-2025.pdf   628 2025-01 Car   Scania White Driving without Due Care and Attention None Coventry Eastern Bypass Coventry Eastern Bypass Birmingham Birmingham Education N/A 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);