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

281 rows where month = "2025-02" and offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" 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, witness_contacted

disposal 5

reporter_transport_mode 4

offence 1

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 281 ✖

month 1

  • 2025-02 · 281 ✖
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
5188 op-snap---monthly-publication-february-2025.pdf   5 2025-02 Pedestrian Honda Jazz Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Mary Vale Road Mary Vale Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.425105 -1.9312861
5190 op-snap---monthly-publication-february-2025.pdf   7 2025-02 Car BMW 225XE White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None MARSHAM ROAD Marsham Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4117052 -1.888565
5201 op-snap---monthly-publication-february-2025.pdf   18 2025-02 Pedestrian Nissan note Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Long Acre Long Acre Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5051253 -1.8646383
5207 op-snap---monthly-publication-february-2025.pdf   24 2025-02 Pedestrian Nissan QASHQUI Orange Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None WARSTOCK ROAD Warstock Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.413031 -1.8782144
5237 op-snap---monthly-publication-february-2025.pdf   54 2025-02 Pedestrian BMW 520D Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None YARDLEY ROAD Yardley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4613544 -1.8160137
5238 op-snap---monthly-publication-february-2025.pdf   55 2025-02 Pedestrian Chysler 300c Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None STEYNING ROAD Steyning Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4584283 -1.8061982
5240 op-snap---monthly-publication-february-2025.pdf   57 2025-02 Pedestrian Mercedes-Benz E250 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COVENTRY ROAD Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
5241 op-snap---monthly-publication-february-2025.pdf   58 2025-02 Pedestrian Volkswagen TIGUAN Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COVENTRY ROAD Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
5243 op-snap---monthly-publication-february-2025.pdf   60 2025-02 Pedestrian Ford Focus Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sunnymead Road Sunnymead Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4613773 -1.798656
5244 op-snap---monthly-publication-february-2025.pdf   61 2025-02 Pedestrian Ford Kuga White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sunnymead Road Sunnymead Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4613773 -1.798656
5246 op-snap---monthly-publication-february-2025.pdf   63 2025-02 Pedestrian Vauxhall CORSA Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ALCESTER ROAD, KINGS HEATH Alcester Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4467439 -1.8881358
5247 op-snap---monthly-publication-february-2025.pdf   64 2025-02 Pedestrian Honda Jazz Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No vehicle excise licence Ollerton Road Ollerton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.463896 -1.7981935
5258 op-snap---monthly-publication-february-2025.pdf   75 2025-02 Pedal Bike Ford Fiesta Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tangmere Drive Tangmere Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5161771 -1.7930308
5267 op-snap---monthly-publication-february-2025.pdf   84 2025-02 Pedestrian Mercedes-Benz A180 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
5269 op-snap---monthly-publication-february-2025.pdf   86 2025-02 Pedestrian Toyota Yaris White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
5274 op-snap---monthly-publication-february-2025.pdf   91 2025-02 Pedestrian Jaguar F PACE Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area VRM fails to conform to Regulations STAPENHALL ROAD Stapenhall Road Solihull Solihull Court N/A Yes - Via Email 52.3858325 -1.7932085
5275 op-snap---monthly-publication-february-2025.pdf   92 2025-02 Pedestrian Nissan QASHQAI Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None STAPENHALL ROAD Stapenhall Road Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.3858325 -1.7932085
5276 op-snap---monthly-publication-february-2025.pdf   93 2025-02 Pedestrian Mercedes-Benz GLC220 GREY Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area VRM fails to conform to Regulations STAPENHALL ROAD Stapenhall Road Solihull Solihull Court N/A Yes - Via Email 52.3858325 -1.7932085
5277 op-snap---monthly-publication-february-2025.pdf   94 2025-02 Pedestrian BMW X3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area VRM fails to conform to Regulations STAPENHALL ROAD Stapenhall Road Solihull Solihull Court N/A Yes - Via Email 52.3858325 -1.7932085
5284 op-snap---monthly-publication-february-2025.pdf   101 2025-02 Pedestrian Volvo S40 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Poplar Road Poplar Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.436035 -1.891685
5287 op-snap---monthly-publication-february-2025.pdf   104 2025-02 Car Audi A3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Brook Lane Brook Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4297007 -1.8668846
5293 op-snap---monthly-publication-february-2025.pdf   110 2025-02 Pedal Bike   Alexander Dennis - Bus Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cherry Tree Avenue, Walsall. Cherry Tree Avenue, Walsall Walsall Walsall Fixed Penalty N/A Yes - Via Email    
5307 op-snap---monthly-publication-february-2025.pdf   124 2025-02 Pedal Bike Vauxhall GRANDLAND Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None BELCHERS LANE Belchers Lane Birmingham Birmingham NFA No Offence Yes - Via Email 52.4800061 -1.833007
5309 op-snap---monthly-publication-february-2025.pdf   126 2025-02 Pedestrian Mercedes-Benz C220 Executive Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Poplar Road Poplar Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.436035 -1.891685
5325 op-snap---monthly-publication-february-2025.pdf   142 2025-02 Car       Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Farlie Close Farlie Close Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5335 op-snap---monthly-publication-february-2025.pdf   152 2025-02 Pedestrian Volvo S40 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Poplar Rd Kings Heath Poplar Road Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.436035 -1.891685
5338 op-snap---monthly-publication-february-2025.pdf   155 2025-02 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Warstock Road Warstock Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.413031 -1.8782144
5349 op-snap---monthly-publication-february-2025.pdf   166 2025-02 Pedestrian Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wills Street Wills Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.500453 -1.9141126
5350 op-snap---monthly-publication-february-2025.pdf   167 2025-02 Pedestrian Skoda Fabia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wills Street Wills Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.500453 -1.9141126
5355 op-snap---monthly-publication-february-2025.pdf   172 2025-02 Pedestrian Skoda Fabia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4103191 -1.8670224
5380 op-snap---monthly-publication-february-2025.pdf   197 2025-02 Pedestrian Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barrington Road Barrington Road Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5381 op-snap---monthly-publication-february-2025.pdf   198 2025-02 Pedestrian Ford FOCUS Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None WOODVILLE ROAD Woodville Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4616763 -1.9653016
5387 op-snap---monthly-publication-february-2025.pdf   204 2025-02 Pedestrian Volkswagen GOLF R Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COVENTRY ROAD Coventry Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4726661 -1.8769032
5388 op-snap---monthly-publication-february-2025.pdf   205 2025-02 Pedestrian Audi S3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance COVENTRY ROAD Coventry Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4726661 -1.8769032
5389 op-snap---monthly-publication-february-2025.pdf   206 2025-02 Pedestrian Mercedes-Benz SPRINTER White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ELMAY ROAD Elmay Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4669633 -1.7864116
5390 op-snap---monthly-publication-february-2025.pdf   207 2025-02 Pedestrian Nissan QASHQAI Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None HORRELL ROAD Horrell Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.464186 -1.7873409
5391 op-snap---monthly-publication-february-2025.pdf   208 2025-02 Pedestrian Kia PICANTO Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COCKSHUT HILL ROAD Cockshut Hill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5392 op-snap---monthly-publication-february-2025.pdf   209 2025-02 Pedestrian Volvo V40 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5393 op-snap---monthly-publication-february-2025.pdf   210 2025-02 Pedestrian Seat Ateca Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5394 op-snap---monthly-publication-february-2025.pdf   211 2025-02 Pedestrian Ford C MAX Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None COCKSHUT HILL ROAD Cockshut Hill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5397 op-snap---monthly-publication-february-2025.pdf   214 2025-02 Pedestrian Volkswagen TAIGO Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None BARROWS LANE Barrows Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4665114 -1.8010003
5399 op-snap---monthly-publication-february-2025.pdf   216 2025-02 Pedestrian Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grange Road Grange Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5065077 -1.892207
5401 op-snap---monthly-publication-february-2025.pdf   218 2025-02 Car Mercedes-Benz C200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Audley Road Audley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4876917 -1.7963729
5405 op-snap---monthly-publication-february-2025.pdf   222 2025-02 Pedestrian Nissan JUKE White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None WESTLEY ROAD Westley Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4456462 -1.827993
5481 op-snap---monthly-publication-february-2025.pdf   298 2025-02 Pedestrian Nissan NOTE White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None GLENVILLE DRIVE Glenville Drive Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5265939 -1.8509884
5483 op-snap---monthly-publication-february-2025.pdf   300 2025-02 Pedestrian Vauxhall   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None GLENVILLE DRIVEW Glenville Drivew Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5606 op-snap---monthly-publication-february-2025.pdf   423 2025-02 Pedestrian Jaguar E pace White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street Kings Heath High Street Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4375456 -1.8926849
5614 op-snap---monthly-publication-february-2025.pdf   431 2025-02 Car Audi Q4 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Brooks Road Brooks Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5427104 -1.8202297
5615 op-snap---monthly-publication-february-2025.pdf   432 2025-02 Pedestrian Volkswagen Touran Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordesley Green East Bordesley Green East Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4802441 -1.8327073
5635 op-snap---monthly-publication-february-2025.pdf   452 2025-02 Pedestrian Honda Civic Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None York Road, Kings Heath York Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.434526 -1.8935819
5638 op-snap---monthly-publication-february-2025.pdf   455 2025-02 Pedestrian Toyota Aygo Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Twyning Road Twyning Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4299797 -1.9191042
5639 op-snap---monthly-publication-february-2025.pdf   456 2025-02 Pedestrian Dacia Sandero Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ramsey Road, Oldbury Ramsey Road, Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
5640 op-snap---monthly-publication-february-2025.pdf   457 2025-02 Pedestrian Volvo XC60 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Clent Road, Oldbury Clent Road, Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
5641 op-snap---monthly-publication-february-2025.pdf   458 2025-02 Pedestrian Mercedes-Benz B180 Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Clent Road, Oldbury Clent Road, Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
5653 op-snap---monthly-publication-february-2025.pdf   470 2025-02 Pedestrian Volkswagen Crafter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Walter Road Walter Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4958886 -1.9822933
5655 op-snap---monthly-publication-february-2025.pdf   472 2025-02 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Walter Road Walter Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4958886 -1.9822933
5679 op-snap---monthly-publication-february-2025.pdf   496 2025-02 Pedestrian Volkswagen T-Roc White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Belchers Lane Belchers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4800061 -1.833007
5687 op-snap---monthly-publication-february-2025.pdf   504 2025-02 Car Volvo XC60 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Paul Street (U/K exact location) Paul Street (U/K exact location) Dudley Dudley NFA No Independent Evidence Available Yes - Via Email 52.5450419 -2.1005009
5688 op-snap---monthly-publication-february-2025.pdf   505 2025-02 Pedestrian BMW 320 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area Use vehicle on a road without valid test certificate Mary Vale Rd Mary Vale Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.425105 -1.9312861
5700 op-snap---monthly-publication-february-2025.pdf   517 2025-02 Pedestrian Nissan Micra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Station Road, Kings Heath Station Road, Kings Heath Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4374113 -1.8931579
5704 op-snap---monthly-publication-february-2025.pdf   521 2025-02 Pedestrian Citroen DS4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fernwood Road, Sutton Coldfield Fernwood Road, Sutton Coldfield Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5436316 -1.8476656
5706 op-snap---monthly-publication-february-2025.pdf   523 2025-02 Pedestrian Mazda 2 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5151832 -1.9361664
5708 op-snap---monthly-publication-february-2025.pdf   525 2025-02 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Rd Eddish Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4833672 -1.7871439
5709 op-snap---monthly-publication-february-2025.pdf   526 2025-02 Pedestrian Seat LEON Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None BELCHERS LANE Belchers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4800061 -1.833007
5712 op-snap---monthly-publication-february-2025.pdf   529 2025-02 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street, Kings Heath High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
5719 op-snap---monthly-publication-february-2025.pdf   536 2025-02 Pedestrian Toyota Estima White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Spring Road Spring Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.444262 -1.8362585
5720 op-snap---monthly-publication-february-2025.pdf   537 2025-02 Pedestrian BMW 116D Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shirley Road Shirley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4198291 -1.9241732
5726 op-snap---monthly-publication-february-2025.pdf   543 2025-02 Car Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Street, Lozells Church Street, Lozells Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4997378 -1.9113714
5728 op-snap---monthly-publication-february-2025.pdf   545 2025-02 Pedestrian Mercedes-Benz A200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Edmund Road Edmund Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4876113 -1.8542201
5732 op-snap---monthly-publication-february-2025.pdf   549 2025-02 Pedestrian Citroen C1 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grange Road Grange Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5065077 -1.892207
5755 op-snap---monthly-publication-february-2025.pdf   572 2025-02 Pedal Bike Audi Q7 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ladypool Road, Balsall Heath Ladypool Road, Balsall Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4520441 -1.8787544
5759 op-snap---monthly-publication-february-2025.pdf   576 2025-02 Car Volkswagen CC Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ASlcester Road Birmingham ASlcester Road Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email    
5760 op-snap---monthly-publication-february-2025.pdf   577 2025-02 Pedestrian Isuzu Truck White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotton Park Road Rotton Park Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4851072 -1.9468115
5764 op-snap---monthly-publication-february-2025.pdf   581 2025-02 Pedestrian Audi A1 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Watford Road Watford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4182952 -1.9316395
5765 op-snap---monthly-publication-february-2025.pdf   582 2025-02 Pedestrian Toyota Aygo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4702299 -1.9948976
5769 op-snap---monthly-publication-february-2025.pdf   586 2025-02 Pedestrian Ford Focus Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordesley Green East Bordesley Green East Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4802441 -1.8327073
5773 op-snap---monthly-publication-february-2025.pdf   590 2025-02 Pedestrian Audi A1 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordesley Green East Bordesley Green East Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4802441 -1.8327073
5779 op-snap---monthly-publication-february-2025.pdf   596 2025-02 Pedestrian Hyundai Tucson Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area none Dewsbury Avenue Coventry Dewsbury Avenue Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.3848122 -1.5204351
5782 op-snap---monthly-publication-february-2025.pdf   599 2025-02 Pedestrian BMW X7 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bordesley Green East Bordesley Green East Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4802441 -1.8327073
5789 op-snap---monthly-publication-february-2025.pdf   606 2025-02 Pedestrian Volkswagen Crafter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hamstead Road Birmingham Hamstead Road Birmingham Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5073301 -1.9199406
5805 op-snap---monthly-publication-february-2025.pdf   622 2025-02 Pedestrian Audi A4 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Yardley Green Road at Blakeland Stre Yardley Green Road at Blakeland Stre eBtir Bmirimngihnaghmam Ebtir Bmirimngihnaghmam Fixed Penalty N/A Yes - Via Email 52.4762013 -1.8193754
5809 op-snap---monthly-publication-february-2025.pdf   626 2025-02 Pedestrian Mercedes-Benz EQC Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.3848122 -1.5204351
5810 op-snap---monthly-publication-february-2025.pdf   627 2025-02 Pedestrian Mercedes-Benz E220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.3848122 -1.5204351
5813 op-snap---monthly-publication-february-2025.pdf   630 2025-02 Pedestrian BMW X6 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry Warning Letter N/A Yes - Via Email 52.3848122 -1.5204351
5820 op-snap---monthly-publication-february-2025.pdf   637 2025-02 Pedestrian Peugeot 508 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moo Street, Coventry Moo Street, Coventry Coventry Coventry Warning Letter N/A Yes - Via Email    
5824 op-snap---monthly-publication-february-2025.pdf   641 2025-02 Pedestrian   Maxus van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High Street, Smethwick High Street, Smethwick Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4955266 -1.9697742
5825 op-snap---monthly-publication-february-2025.pdf   642 2025-02 Pedestrian Volkswagen Polo Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bertram Road, Smethwick Bertram Road, Smethwick Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4984114 -1.981609
5826 op-snap---monthly-publication-february-2025.pdf   643 2025-02 Pedestrian Renault Van White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Buttery Road, Smethwick Buttery Road, Smethwick Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4968875 -1.9838564
5845 op-snap---monthly-publication-february-2025.pdf   662 2025-02 Pedestrian Land Rover Evoque White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Jockey Rd Jockey Road Sutton Coldfield Sutton Coldfield Warning Letter N/A Yes - Via Email 52.5535276 -1.8302584
5915 op-snap---monthly-publication-february-2025.pdf   732 2025-02 Pedestrian Audi A1 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None GROVE ROAD Grove Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4453942 -1.8644982
5917 op-snap---monthly-publication-february-2025.pdf   734 2025-02 Pedestrian Mercedes-Benz Vito Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gateside Road Coventry Gateside Road Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.4400759 -1.4966907
5918 op-snap---monthly-publication-february-2025.pdf   735 2025-02 Pedestrian Toyota Yaris Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gateside Road Coventry Gateside Road Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.4400759 -1.4966907
5919 op-snap---monthly-publication-february-2025.pdf   736 2025-02 Pedestrian Peugeot 308 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gateside Road Coventry Gateside Road Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.4400759 -1.4966907
5920 op-snap---monthly-publication-february-2025.pdf   737 2025-02 Pedestrian BMW X1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gateside Road Coventry Gateside Road Coventry Coventry Coventry Warning Letter N/A Yes - Via Email 52.4400759 -1.4966907
5922 op-snap---monthly-publication-february-2025.pdf   739 2025-02 Pedestrian Toyota Corolla Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Vicarage Road, Kings heath Vicarage Road, Kings heath Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4301512 -1.8996659
5923 op-snap---monthly-publication-february-2025.pdf   740 2025-02 Pedal Bike Lamborghini Urus Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Carver Street Carver Street Birmingham Birmingham Court N/A Yes - Via Email 52.4857687 -1.915613
5926 op-snap---monthly-publication-february-2025.pdf   743 2025-02 Pedestrian Vauxhall Insignia Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Trysull Road Wolverhampton Trysull Road Wolverhampton Wolverhampton Wolverhampton Warning Letter N/A Yes - Via Email 52.572883 -2.1644116
5945 op-snap---monthly-publication-february-2025.pdf   762 2025-02 Pedestrian Volkswagen Golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradshaw Avenue, Bradshaw Avenue Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4018255 -1.9490522
5993 op-snap---monthly-publication-february-2025.pdf   810 2025-02 Pedal Bike Mercedes-Benz   Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ladypool Rd Ladypool Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4520441 -1.8787544
5996 op-snap---monthly-publication-february-2025.pdf   813 2025-02 Pedestrian Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5265939 -1.8509884

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