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

145 rows where disposal = "Warning Letter", offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Pedal Bike · 145 ✖

offence 1

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

disposal 1

  • Warning Letter · 145 ✖
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
7309 op-snap---monthly-publication-february-2026.pdf   56 2026-02 Pedal Bike Nissan Qashqai Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wheelers Lane Wheelers Lane Birmingham Birmingham Warning Letter N/A   52.4306504 -1.878052
7382 op-snap---monthly-publication-february-2026.pdf   129 2026-02 Pedal Bike Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lordswood Road Lordswood Road Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
7468 op-snap---monthly-publication-february-2026.pdf   215 2026-02 Pedal Bike Audi A5 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
7540 op-snap---monthly-publication-february-2026.pdf   287 2026-02 Pedal Bike Mazda 2 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7542 op-snap---monthly-publication-february-2026.pdf   289 2026-02 Pedal Bike Volkswagen Golf Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7544 op-snap---monthly-publication-february-2026.pdf   291 2026-02 Pedal Bike Kia Ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7545 op-snap---monthly-publication-february-2026.pdf   292 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7553 op-snap---monthly-publication-february-2026.pdf   300 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7554 op-snap---monthly-publication-february-2026.pdf   301 2026-02 Pedal Bike Toyota Yaris Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7555 op-snap---monthly-publication-february-2026.pdf   302 2026-02 Pedal Bike Ford Transit Orange Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7557 op-snap---monthly-publication-february-2026.pdf   304 2026-02 Pedal Bike Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7558 op-snap---monthly-publication-february-2026.pdf   305 2026-02 Pedal Bike Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
8789 op-snap---monthly-publication-february-2026.pdf   1536 2026-02 Pedal Bike Peugeot 207 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bristol road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
8790 op-snap---monthly-publication-february-2026.pdf   1537 2026-02 Pedal Bike Jaguar fpace Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bristol road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
8871 op-snap---monthly-publication-february-2026.pdf   1618 2026-02 Pedal Bike Seat altea Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None gordon road Gordon Road Coventry Coventry Warning Letter N/A      
8872 op-snap---monthly-publication-february-2026.pdf   1619 2026-02 Pedal Bike Volvo V40 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Coventry Coventry Warning Letter N/A      
11403 op-snap---monthly-publication-january-2026.pdf   864 2026-01 Pedal Bike Toyota Verso Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
11405 op-snap---monthly-publication-january-2026.pdf   866 2026-01 Pedal Bike Mercedes-Benz Vito Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
11901 op-snap---monthly-publication-january-2026.pdf   1362 2026-01 Pedal Bike Nissan qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None wheelers lane Wheelers Lane Birmingham Birmingham Warning Letter N/A   52.4306504 -1.878052
4331 op-snap---monthly-publication-december-2025.pdf   459 2025-12 Pedal Bike Renault Master White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
4340 op-snap---monthly-publication-december-2025.pdf   468 2025-12 Pedal Bike Toyota Prius Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
4459 op-snap---monthly-publication-december-2025.pdf   587 2025-12 Pedal Bike Toyota Prius Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
4460 op-snap---monthly-publication-december-2025.pdf   588 2025-12 Pedal Bike Volkswagen Polo Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
4526 op-snap---monthly-publication-december-2025.pdf   654 2025-12 Pedal Bike Vauxhall combo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None walsagrave road Walsagrave Road Coventry Coventry Warning Letter N/A      
4528 op-snap---monthly-publication-december-2025.pdf   656 2025-12 Pedal Bike Nissan micra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
4529 op-snap---monthly-publication-december-2025.pdf   657 2025-12 Pedal Bike BMW 520D Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None daventry road Daventry Road Coventry Coventry Warning Letter N/A   52.3930931 -1.4976428
5090 op-snap---monthly-publication-december-2025.pdf   1218 2025-12 Pedal Bike Peugeot 3008 grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ludstone Road Ludstone Road Birmingham Birmingham Warning Letter N/A   52.4400405 -1.9758361
5135 op-snap---monthly-publication-december-2025.pdf   1263 2025-12 Pedal Bike Ford Transit Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hadley Street Hadley Street Sandwell Sandwell Warning Letter N/A   52.4863612 -2.0105376
20843 op-snap---monthly-publication-november-2025.pdf   385 2025-11 Pedal Bike Vauxhall insignia Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
20867 op-snap---monthly-publication-november-2025.pdf   409 2025-11 Pedal Bike Seat Arona Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
20937 op-snap---monthly-publication-november-2025.pdf   479 2025-11 Pedal Bike Vauxhall Vivaro Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road A38 Bristol Road A38 Birmingham Birmingham Warning Letter N/A   52.428519 -1.9518769
20948 op-snap---monthly-publication-november-2025.pdf   490 2025-11 Pedal Bike Hyundai I20 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Bernards Rd Street Bernards Road Birmingham Birmingham Warning Letter N/A      
21028 op-snap---monthly-publication-november-2025.pdf   570 2025-11 Pedal Bike Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Foleshill Road Foleshill Road Coventry Coventry Warning Letter N/A   52.4274335 -1.5002381
21029 op-snap---monthly-publication-november-2025.pdf   571 2025-11 Pedal Bike Peugeot 308 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Foleshill Road Foleshill Road Coventry Coventry Warning Letter N/A   52.4274335 -1.5002381
21101 op-snap---monthly-publication-november-2025.pdf   643 2025-11 Pedal Bike Ford Mondeo Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silverthorne Lane Silverthorne Lane Birmingham Birmingham Warning Letter N/A      
21116 op-snap---monthly-publication-november-2025.pdf   658 2025-11 Pedal Bike Mercedes-Benz A35 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
21127 op-snap---monthly-publication-november-2025.pdf   669 2025-11 Pedal Bike Honda   Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
21195 op-snap---monthly-publication-november-2025.pdf   737 2025-11 Pedal Bike Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None A38 Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
21214 op-snap---monthly-publication-november-2025.pdf   756 2025-11 Pedal Bike Renault Captur White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Camp Lane Camp Lane Birmingham Birmingham Warning Letter N/A   52.5144871 -1.9539012
21342 op-snap---monthly-publication-november-2025.pdf   884 2025-11 Pedal Bike Volkswagen passat Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Queen victoria road Queen victoria road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
21351 op-snap---monthly-publication-november-2025.pdf   893 2025-11 Pedal Bike Nissan Qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
21789 op-snap---monthly-publication-november-2025.pdf   1331 2025-11 Pedal Bike Ford focus Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lodge hill road Lodge Hill Road Birmingham Birmingham Warning Letter N/A   52.4390011 -1.9455485
21894 op-snap---monthly-publication-november-2025.pdf   1436 2025-11 Pedal Bike Volkswagen golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
21895 op-snap---monthly-publication-november-2025.pdf   1437 2025-11 Pedal Bike Nissan note Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None far gosford street Far Gosford Street Coventry Coventry Warning Letter N/A   52.4071231 -1.4985178
22001 op-snap---monthly-publication-november-2025.pdf   1543 2025-11 Pedal Bike Citroen Relay White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
22004 op-snap---monthly-publication-november-2025.pdf   1546 2025-11 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
22005 op-snap---monthly-publication-november-2025.pdf   1547 2025-11 Pedal Bike Kia Ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
22006 op-snap---monthly-publication-november-2025.pdf   1548 2025-11 Pedal Bike Skoda Octavia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
22105 op-snap---monthly-publication-october-2025.pdf   55 2025-10 Pedal Bike Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23129 op-snap---monthly-publication-october-2025.pdf   1079 2025-10 Pedal Bike Ford Transit Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23130 op-snap---monthly-publication-october-2025.pdf   1080 2025-10 Pedal Bike Ford Focus Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23160 op-snap---monthly-publication-october-2025.pdf   1110 2025-10 Pedal Bike BMW 5 series Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23161 op-snap---monthly-publication-october-2025.pdf   1111 2025-10 Pedal Bike Peugeot Partner White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23162 op-snap---monthly-publication-october-2025.pdf   1112 2025-10 Pedal Bike Toyota Caolla Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23163 op-snap---monthly-publication-october-2025.pdf   1113 2025-10 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23165 op-snap---monthly-publication-october-2025.pdf   1115 2025-10 Pedal Bike Peugeot 2008 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23166 op-snap---monthly-publication-october-2025.pdf   1116 2025-10 Pedal Bike Ford Focus Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
23298 op-snap---monthly-publication-october-2025.pdf   1248 2025-10 Pedal Bike BMW 218 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
23342 op-snap---monthly-publication-october-2025.pdf   1292 2025-10 Pedal Bike Volkswagen sharan Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area none stoney stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
23456 op-snap---monthly-publication-october-2025.pdf   1406 2025-10 Pedal Bike Mercedes-Benz s350 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None kent street Kent Street Birmingham Birmingham Warning Letter N/A   52.4717099 -1.897463
23486 op-snap---monthly-publication-october-2025.pdf   1436 2025-10 Pedal Bike Audi S3 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None carver street Carver Street Birmingham Birmingham Warning Letter N/A   52.4857687 -1.915613
23522 op-snap---monthly-publication-october-2025.pdf   1472 2025-10 Pedal Bike Toyota auris Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
23672 op-snap---monthly-publication-october-2025.pdf   1622 2025-10 Pedal Bike Volkswagen Golf White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Friar Park Friar Park Sandwell Sandwell Warning Letter N/A   52.5522333 -1.9878275
23689 op-snap---monthly-publication-october-2025.pdf   1639 2025-10 Pedal Bike Nissan Pulsar Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bakers Butts Lane Bakers Butts Lane Coventry Coventry Warning Letter N/A      
23763 op-snap---monthly-publication-october-2025.pdf   1713 2025-10 Pedal Bike Mercedes-Benz sprinter Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None worcester street Worcester Street Wolverhampton Wolverhampton Warning Letter N/A   52.5816193 -2.13143
2384 op-snap---monthly-publication-august-2025.pdf   359 2025-08 Pedal Bike Toyota Prius Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Corportaion Street Corportaion Street Birmingham Birmingham Warning Letter N/A      
3443 op-snap---monthly-publication-august-2025.pdf   1418 2025-08 Pedal Bike Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
3444 op-snap---monthly-publication-august-2025.pdf   1419 2025-08 Pedal Bike Nissan Qashqai Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton road Stoney Stanton road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
3529 op-snap---monthly-publication-august-2025.pdf   1504 2025-08 Pedal Bike Other Jeep Avenger Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
3807 op-snap---monthly-publication-august-2025.pdf   1782 2025-08 Pedal Bike Toyota Prius White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Victoria Road Victoria Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5615573 -1.820549
3863 op-snap---monthly-publication-august-2025.pdf   1838 2025-08 Pedal Bike BMW X1 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3864 op-snap---monthly-publication-august-2025.pdf   1839 2025-08 Pedal Bike Audi A3 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3865 op-snap---monthly-publication-august-2025.pdf   1840 2025-08 Pedal Bike Ford C max Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3866 op-snap---monthly-publication-august-2025.pdf   1841 2025-08 Pedal Bike Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3867 op-snap---monthly-publication-august-2025.pdf   1842 2025-08 Pedal Bike Honda Jazz Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3868 op-snap---monthly-publication-august-2025.pdf   1843 2025-08 Pedal Bike Fiat Punto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3869 op-snap---monthly-publication-august-2025.pdf   1844 2025-08 Pedal Bike Volkswagen Golf R Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
13361 op-snap---monthly-publication-july-2025.pdf   1413 2025-07 Pedal Bike Land Rover SVR Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Edgbaston Street Edgbaston Street Birmingham Birmingham Warning Letter N/A   52.4764509 -1.8958723
13385 op-snap---monthly-publication-july-2025.pdf   1437 2025-07 Pedal Bike Toyota Hilux Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barnsley Road Barnsley Road Birmingham Birmingham Warning Letter N/A   52.4743497 -1.965737
13409 op-snap---monthly-publication-july-2025.pdf   1461 2025-07 Pedal Bike Audi a3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Duncroft Avenue Duncroft Avenue Coventry Coventry Warning Letter N/A   52.4285538 -1.5345395
13513 op-snap---monthly-publication-july-2025.pdf   1565 2025-07 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Horseley heath Horseley heath Dudley Dudley Warning Letter N/A   52.525777 -2.0464686
13514 op-snap---monthly-publication-july-2025.pdf   1566 2025-07 Pedal Bike Ford focus White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
13520 op-snap---monthly-publication-july-2025.pdf   1572 2025-07 Pedal Bike BMW 318D White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
13522 op-snap---monthly-publication-july-2025.pdf   1574 2025-07 Pedal Bike BMW 318I Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
13791 op-snap---monthly-publication-july-2025.pdf   1843 2025-07 Pedal Bike BMW 730D Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Binley Road Binley Road Coventry Coventry Warning Letter N/A   52.4070602 -1.4732469
13838 op-snap---monthly-publication-july-2025.pdf   1890 2025-07 Pedal Bike Volkswagen golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13894 op-snap---monthly-publication-july-2025.pdf   1946 2025-07 Pedal Bike Honda civic Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13903 op-snap---monthly-publication-july-2025.pdf   1955 2025-07 Pedal Bike Ford transit Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
14609 op-snap---monthly-publication-june-2025.pdf   538 2025-06 Pedal Bike BMW 420i Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Far Gosford Street Far Gosford Street Coventry Coventry Warning Letter N/A   52.4071231 -1.4985178
14918 op-snap---monthly-publication-june-2025.pdf   847 2025-06 Pedal Bike Skoda Zodiaq White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Scotland Lane Scotland Lane Birmingham Birmingham Warning Letter N/A   52.4277732 -2.0022005
15370 op-snap---monthly-publication-june-2025.pdf   1299 2025-06 Pedal Bike Nissan Almera Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gristhorpe Road, Selly Oak Gristhorpe Road, Selly Oak Birmingham Birmingham Warning Letter N/A   52.434716 -1.9254196
15908 op-snap---monthly-publication-june-2025.pdf   1837 2025-06 Pedal Bike Toyota Yaris Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
16156 op-snap---monthly-publication-june-2025.pdf   2085 2025-06 Pedal Bike BMW 320D Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoney Stanton Stoney Stanton Coventry Coventry Warning Letter N/A   52.4196813 -1.4978941
16176 op-snap---monthly-publication-june-2025.pdf   2105 2025-06 Pedal Bike Ford fiesta Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
16218 op-snap---monthly-publication-june-2025.pdf   2147 2025-06 Pedal Bike Daf Trucks White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Chester Road Chester Road Solihull Solihull Warning Letter N/A   52.5021946 -1.7719526
18955 op-snap---monthly-publication-may-2025.pdf   317 2025-05 Pedal Bike Renault Master Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford St Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
18973 op-snap---monthly-publication-may-2025.pdf   335 2025-05 Pedal Bike Volkswagen Transporter Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wolverhampton Road West Walsall Wolverhampton Road West Walsall Walsall Walsall Warning Letter N/A   52.586437 -2.0276998
19066 op-snap---monthly-publication-may-2025.pdf   428 2025-05 Pedal Bike Jaguar iPace Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Swarthmaore Road Swarthmaore Road Birmingham Birmingham Warning Letter N/A      
19127 op-snap---monthly-publication-may-2025.pdf   489 2025-05 Pedal Bike Vauxhall Astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
19150 op-snap---monthly-publication-may-2025.pdf   512 2025-05 Pedal Bike Audi A1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gosford Street Gosford Street Coventry Coventry Warning Letter N/A   52.4068712 -1.4994695

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