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

166 rows where council_area = "Birmingham", 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, nfa_rationale

reporter_transport_mode 1

  • Pedal Bike · 166 ✖

offence 1

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

council_area 1

  • Birmingham · 166 ✖
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
7396 op-snap---monthly-publication-february-2026.pdf   143 2026-02 Pedal Bike Peugeot 3008 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lustone Road Lustone Road Birmingham Birmingham Fixed Penalty N/A      
7398 op-snap---monthly-publication-february-2026.pdf   145 2026-02 Pedal Bike Hyundai I30.. White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Marys Row Moseley Street Marys Row Moseley Birmingham Birmingham Education N/A      
7399 op-snap---monthly-publication-february-2026.pdf   146 2026-02 Pedal Bike Volkswagen Polo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham NFA No Independent Evidence Available      
7499 op-snap---monthly-publication-february-2026.pdf   246 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 Fixed Penalty N/A   52.4708802 -1.8792135
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
7559 op-snap---monthly-publication-february-2026.pdf   306 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 Duplicate Submission Duplicate Submission   52.4708802 -1.8792135
7560 op-snap---monthly-publication-february-2026.pdf   307 2026-02 Pedal Bike Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
7562 op-snap---monthly-publication-february-2026.pdf   309 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 NFA No Independent Evidence Available   52.4708802 -1.8792135
7563 op-snap---monthly-publication-february-2026.pdf   310 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
7564 op-snap---monthly-publication-february-2026.pdf   311 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 NFA No Independent Evidence Available   52.4708802 -1.8792135
7595 op-snap---monthly-publication-february-2026.pdf   342 2026-02 Pedal Bike BMW X1.. Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road South Bristol Road South Birmingham Birmingham Fixed Penalty N/A   52.4119174 -1.9735247
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
10929 op-snap---monthly-publication-january-2026.pdf   390 2026-01 Pedal Bike Honda Civic Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Spiceland Road Spiceland Road Birmingham Birmingham Fixed Penalty N/A   52.4243001 -1.9747504
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
11623 op-snap---monthly-publication-january-2026.pdf   1084 2026-01 Pedal Bike Toyota Aygo Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Knowle Road Sparkhill Knowle Road Sparkhill Birmingham Birmingham Duplicate Submission Duplicate Submission   52.44557 -1.8570546
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
4342 op-snap---monthly-publication-december-2025.pdf   470 2025-12 Pedal Bike       Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No VRM   52.4708802 -1.8792135
4447 op-snap---monthly-publication-december-2025.pdf   575 2025-12 Pedal Bike Audi     Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None winson street Winson Street Birmingham Birmingham NFA Misc Inc Crimes   52.4889098 -1.9443259
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
4956 op-snap---monthly-publication-december-2025.pdf   1084 2025-12 Pedal Bike Kia picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
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
5091 op-snap---monthly-publication-december-2025.pdf   1219 2025-12 Pedal Bike Mercedes-Benz A class White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Northfield Road, Harborne Northfield Road, Harborne Birmingham Birmingham NFA Not in Public Interest   52.4528036 -1.9658213
5096 op-snap---monthly-publication-december-2025.pdf   1224 2025-12 Pedal Bike Toyota Rav 4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA N/A   52.4708802 -1.8792135
5097 op-snap---monthly-publication-december-2025.pdf   1225 2025-12 Pedal Bike Nissan X Trail Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
5098 op-snap---monthly-publication-december-2025.pdf   1226 2025-12 Pedal Bike Mercedes-Benz GLE Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA N/A   52.4708802 -1.8792135
5099 op-snap---monthly-publication-december-2025.pdf   1227 2025-12 Pedal Bike Kia Picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
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      
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      
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
21696 op-snap---monthly-publication-november-2025.pdf   1238 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 NFA Misc Inc Crimes   52.4708802 -1.8792135
21697 op-snap---monthly-publication-november-2025.pdf   1239 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 NFA Misc Inc Crimes   52.4708802 -1.8792135
21727 op-snap---monthly-publication-november-2025.pdf   1269 2025-11 Pedal Bike Mercedes-Benz b200 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
21728 op-snap---monthly-publication-november-2025.pdf   1270 2025-11 Pedal Bike Seat leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
21729 op-snap---monthly-publication-november-2025.pdf   1271 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 NFA Misc Inc Crimes   52.4708802 -1.8792135
21731 op-snap---monthly-publication-november-2025.pdf   1273 2025-11 Pedal Bike Citroen c3 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford road Bradford Road Birmingham Birmingham NFA Misc Inc Crimes   52.5024148 -1.7961753
21732 op-snap---monthly-publication-november-2025.pdf   1274 2025-11 Pedal Bike Vauxhall mokka Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
21733 op-snap---monthly-publication-november-2025.pdf   1275 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 NFA Misc Inc Crimes   52.4708802 -1.8792135
21734 op-snap---monthly-publication-november-2025.pdf   1276 2025-11 Pedal Bike Mercedes-Benz cla 220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
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
22000 op-snap---monthly-publication-november-2025.pdf   1542 2025-11 Pedal Bike Iveco   White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
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
22002 op-snap---monthly-publication-november-2025.pdf   1544 2025-11 Pedal Bike Toyota Corolla White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
22003 op-snap---monthly-publication-november-2025.pdf   1545 2025-11 Pedal Bike Ford   Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   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
23164 op-snap---monthly-publication-october-2025.pdf   1114 2025-10 Pedal Bike Kia     Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No VRM   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
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
23583 op-snap---monthly-publication-october-2025.pdf   1533 2025-10 Pedal Bike Audi A4 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Carver Street Carver Street Birmingham Birmingham NFA Misc Inc Crimes   52.4857687 -1.915613
23699 op-snap---monthly-publication-october-2025.pdf   1649 2025-10 Pedal Bike       Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
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      
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
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
13521 op-snap---monthly-publication-july-2025.pdf   1573 2025-07 Pedal Bike Toyota Auris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   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
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
14981 op-snap---monthly-publication-june-2025.pdf   910 2025-06 Pedal Bike Volkswagen Arteon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Legge Legge Birmingham Birmingham NFA No Offence   52.4843538 -1.9127963
15253 op-snap---monthly-publication-june-2025.pdf   1182 2025-06 Pedal Bike Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Road Bristol Road Birmingham Birmingham NFA Not in Public Interest   52.4543565 -1.9114004
15309 op-snap---monthly-publication-june-2025.pdf   1238 2025-06 Pedal Bike Vauxhall Corsa Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham NFA Not in Public Interest   52.4760986 -1.9018641
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
15964 op-snap---monthly-publication-june-2025.pdf   1893 2025-06 Pedal Bike Porsche 911 Turbo Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Carver Street Carver Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4857687 -1.915613
16027 op-snap---monthly-publication-june-2025.pdf   1956 2025-06 Pedal Bike Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bristol Street Bristol Street Birmingham Birmingham NFA No Offence   52.4691145 -1.9003257
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
18649 op-snap---monthly-publication-may-2025.pdf   11 2025-05 Pedal Bike Nissan Qashqai Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Road Cannon Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4569873 -1.8971744

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