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

174 rows where month = "2026-01" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Pedal Bike · 174 ✖

month 1

  • 2026-01 · 174 ✖
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
10543 op-snap---monthly-publication-january-2026.pdf   4 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10544 op-snap---monthly-publication-january-2026.pdf   5 2026-01 Pedal Bike Toyota Aygo Red Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
10547 op-snap---monthly-publication-january-2026.pdf   8 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving No Insurance Stoney Stanton Road Stoney Stanton Road Coventry Coventry Duplicate Submission Duplicate Submission   52.4221152 -1.4959475
10557 op-snap---monthly-publication-january-2026.pdf   18 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Robin Hood lane Robin Hood lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
10558 op-snap---monthly-publication-january-2026.pdf   19 2026-01 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention No vehicle excise licence Brook Lane Brook Lane Birmingham Birmingham Court N/A   52.4297007 -1.8668846
10561 op-snap---monthly-publication-january-2026.pdf   22 2026-01 Pedal Bike Iveco Daily White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10562 op-snap---monthly-publication-january-2026.pdf   23 2026-01 Pedal Bike Mercedes-Benz CITAN White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10564 op-snap---monthly-publication-january-2026.pdf   25 2026-01 Pedal Bike Ford Transit Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10565 op-snap---monthly-publication-january-2026.pdf   26 2026-01 Pedal Bike BMW M3 Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10567 op-snap---monthly-publication-january-2026.pdf   28 2026-01 Pedal Bike Vauxhall Astra Grey Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
10568 op-snap---monthly-publication-january-2026.pdf   29 2026-01 Pedal Bike BMW 120d Black Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10579 op-snap---monthly-publication-january-2026.pdf   40 2026-01 Pedal Bike Ford Transit Green Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham Warning Letter N/A      
10580 op-snap---monthly-publication-january-2026.pdf   41 2026-01 Pedal Bike Honda CR-V Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
10581 op-snap---monthly-publication-january-2026.pdf   42 2026-01 Pedal Bike   Bus   Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
10594 op-snap---monthly-publication-january-2026.pdf   55 2026-01 Pedal Bike Toyota yaris Red Duplicate Submission None stoney stanton road Stoney Stanton Road Birmingham Birmingham Duplicate Submission Duplicate Submission      
10595 op-snap---monthly-publication-january-2026.pdf   56 2026-01 Pedal Bike Hyundai i10 Grey Misc - Non Traffic Offences None lower essex street Lower Essex Street Birmingham Birmingham NFA No Offence   52.4716178 -1.8954045
10607 op-snap---monthly-publication-january-2026.pdf   68 2026-01 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Lower Broad Heath (worcester) Lower Broad Heath (worcester) Out of Force Area Out of Force Area NFA Out of Force      
10628 op-snap---monthly-publication-january-2026.pdf   89 2026-01 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Warning Letter N/A   52.4297007 -1.8668846
10647 op-snap---monthly-publication-january-2026.pdf   108 2026-01 Pedal Bike Mercedes-Benz Vito Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None New Street New Street Birmingham Birmingham NFA No Independent Evidence Available   52.4791344 -1.8986915
10661 op-snap---monthly-publication-january-2026.pdf   122 2026-01 Pedal Bike Volkswagen troc White Cause vehicle to be left in a dangerous position None far gosford strett Far Gosford Strett Coventry Coventry Warning Letter N/A      
10762 op-snap---monthly-publication-january-2026.pdf   223 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10800 op-snap---monthly-publication-january-2026.pdf   261 2026-01 Pedal Bike Ford Ecosport Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
10815 op-snap---monthly-publication-january-2026.pdf   276 2026-01 Pedal Bike Fiat Doblo Silver Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
10845 op-snap---monthly-publication-january-2026.pdf   306 2026-01 Pedal Bike   Irizar Coach Grey Driving without Due Care and Attention None Lawley Middleway, Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10884 op-snap---monthly-publication-january-2026.pdf   345 2026-01 Pedal Bike Volkswagen Crafter White Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10914 op-snap---monthly-publication-january-2026.pdf   375 2026-01 Pedal Bike Audi A7 Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon St Cov Earlsdon Street Cov Coventry Coventry Education N/A   52.3988977 -1.5323674
10916 op-snap---monthly-publication-january-2026.pdf   377 2026-01 Pedal Bike Hyundai Kona Blue Stop a vehicle within pelican pedestrian crossing limits None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
10918 op-snap---monthly-publication-january-2026.pdf   379 2026-01 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Pedmore Road Pedmore Road Dudley Dudley Fixed Penalty N/A   52.4897451 -2.1069141
10928 op-snap---monthly-publication-january-2026.pdf   389 2026-01 Pedal Bike Audi Q5 Grey Cause vehicle to be left in a dangerous position None Swarthmore Road Swarthmore Road Birmingham Birmingham Education N/A   52.4299657 -1.9599121
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
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10979 op-snap---monthly-publication-january-2026.pdf   440 2026-01 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10984 op-snap---monthly-publication-january-2026.pdf   445 2026-01 Pedal Bike Toyota MPV White Driving without Due Care and Attention None Reservoir Road, Edgbaston Reservoir Road, Edgbaston Birmingham Birmingham Education N/A   52.4771764 -1.93246
10992 op-snap---monthly-publication-january-2026.pdf   453 2026-01 Pedal Bike BMW 740LD Blue Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4591339 -1.9601054
10993 op-snap---monthly-publication-january-2026.pdf   454 2026-01 Pedal Bike Mercedes-Benz GLA 200 Black Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham Fixed Penalty N/A   52.4422505 -1.8539684
10994 op-snap---monthly-publication-january-2026.pdf   455 2026-01 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Education N/A   52.4682339 -1.8793662
11000 op-snap---monthly-publication-january-2026.pdf   461 2026-01 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
11009 op-snap---monthly-publication-january-2026.pdf   470 2026-01 Pedal Bike Mercedes-Benz sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Sydney Road Sydney Road Sandwell Sandwell Fixed Penalty N/A   52.4792941 -1.9810588
11042 op-snap---monthly-publication-january-2026.pdf   503 2026-01 Pedal Bike Audi A1 Grey Cause vehicle to be left in a dangerous position None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A   52.4327486 -1.8844997
11043 op-snap---monthly-publication-january-2026.pdf   504 2026-01 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11062 op-snap---monthly-publication-january-2026.pdf   523 2026-01 Pedal Bike Tesla Model Y White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
11065 op-snap---monthly-publication-january-2026.pdf   526 2026-01 Pedal Bike Renault HGV White Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Offence   52.4552785 -1.906384
11069 op-snap---monthly-publication-january-2026.pdf   530 2026-01 Pedal Bike Volkswagen Touran Black Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Fixed Penalty N/A   52.4398245 -1.8469786
11073 op-snap---monthly-publication-january-2026.pdf   534 2026-01 Pedal Bike Ford Kuga White Using a Mobile Phone Whilst Driving None Priory Road, Edgbaston Priory Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A   52.4556998 -1.9102592
11076 op-snap---monthly-publication-january-2026.pdf   537 2026-01 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
11077 op-snap---monthly-publication-january-2026.pdf   538 2026-01 Pedal Bike Renault Megane Gold Using a Mobile Phone Whilst Driving No Seat Belt Alcester Road Alcester Road Birmingham Birmingham Court N/A   52.4470686 -1.8880749
11078 op-snap---monthly-publication-january-2026.pdf   539 2026-01 Pedal Bike Skoda Roomster Silver Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
11080 op-snap---monthly-publication-january-2026.pdf   541 2026-01 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Slade Road, Edgbaston Slade Road, Edgbaston Birmingham Birmingham Education N/A      
11081 op-snap---monthly-publication-january-2026.pdf   542 2026-01 Pedal Bike Honda C-RV Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Coat of Arms Bridge Road Coat of Arms Bridge Road Coventry Coventry Fixed Penalty N/A   52.3887077 -1.5308677
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11097 op-snap---monthly-publication-january-2026.pdf   558 2026-01 Pedal Bike Ford Kuga Silver Driving without Due Care and Attention None Eachway Lane Eachway Lane Birmingham Birmingham Education N/A   52.3882492 -2.0091218
11098 op-snap---monthly-publication-january-2026.pdf   559 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry NFA Not in Public Interest   52.4073149 -1.5250454
11109 op-snap---monthly-publication-january-2026.pdf   570 2026-01 Pedal Bike Lexus UX250 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
11110 op-snap---monthly-publication-january-2026.pdf   571 2026-01 Pedal Bike Audi Q2 Black Using a Mobile Phone Whilst Driving None Bristol Street Bristol Street Birmingham Birmingham Fixed Penalty N/A   52.4691145 -1.9003257
11113 op-snap---monthly-publication-january-2026.pdf   574 2026-01 Pedal Bike BMW 420D Blue Using a Mobile Phone Whilst Driving None Aston Web Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
11114 op-snap---monthly-publication-january-2026.pdf   575 2026-01 Pedal Bike Volkswagen Taigo Grey Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
11115 op-snap---monthly-publication-january-2026.pdf   576 2026-01 Pedal Bike Mercedes-Benz B180 Blue Using a Mobile Phone Whilst Driving None Metchley Lane, Harborne Metchley Lane, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11116 op-snap---monthly-publication-january-2026.pdf   577 2026-01 Pedal Bike Peugeot 207 Black Using a Mobile Phone Whilst Driving None Metchley Lane, Harborne Metchley Lane, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11119 op-snap---monthly-publication-january-2026.pdf   580 2026-01 Pedal Bike Honda Civic Blue Contravening a Red Traffic Light None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry NFA No Independent Evidence Available   52.4352 -1.5194238
11120 op-snap---monthly-publication-january-2026.pdf   581 2026-01 Pedal Bike Ford Transit Blue Driving without Due Care and Attention None Burnaby Road at Beake Avenue Burnaby Road at Beake Avenue Coventry Coventry Education N/A   52.4352 -1.5194238
11121 op-snap---monthly-publication-january-2026.pdf   582 2026-01 Pedal Bike BMW 320D Black Contravening a Red Traffic Light None A45 slip road Allesley Green to Birmingham A45 slip road Allesley Green to Birmingham Coventry Coventry Warning Letter N/A      
11136 op-snap---monthly-publication-january-2026.pdf   597 2026-01 Pedal Bike BMW 335D Blue Stop a vehicle within pelican pedestrian crossing limits None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
11165 op-snap---monthly-publication-january-2026.pdf   626 2026-01 Pedal Bike Peugeot 208.. Grey Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
11166 op-snap---monthly-publication-january-2026.pdf   627 2026-01 Pedal Bike Audi Q3 Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11167 op-snap---monthly-publication-january-2026.pdf   628 2026-01 Pedal Bike Nissan Qashqai Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11194 op-snap---monthly-publication-january-2026.pdf   655 2026-01 Pedal Bike BMW 428i Blue Driving without Due Care and Attention None Fosse Way, Warwick Fosse Way, Warwick Out of Force Area Out of Force Area NFA Out of Force      
11209 op-snap---monthly-publication-january-2026.pdf   670 2026-01 Pedal Bike Ford Focus Silver Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
11212 op-snap---monthly-publication-january-2026.pdf   673 2026-01 Pedal Bike Volkswagen Touran Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11213 op-snap---monthly-publication-january-2026.pdf   674 2026-01 Pedal Bike Mg hatchback White Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
11215 op-snap---monthly-publication-january-2026.pdf   676 2026-01 Pedal Bike BMW 320D White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11216 op-snap---monthly-publication-january-2026.pdf   677 2026-01 Pedal Bike Renault Megane Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11217 op-snap---monthly-publication-january-2026.pdf   678 2026-01 Pedal Bike BMW 120 SPORT Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11253 op-snap---monthly-publication-january-2026.pdf   714 2026-01 Pedal Bike Land Rover Sport Black Stop a vehicle on pedestrian crossing None Earlsdon Street Earlsdon Street Coventry Coventry Education N/A   52.3988977 -1.5323674
11273 op-snap---monthly-publication-january-2026.pdf   734 2026-01 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Hearsall Common Hearsall Common Coventry Coventry Warning Letter N/A   52.402753 -1.5385829
11279 op-snap---monthly-publication-january-2026.pdf   740 2026-01 Pedal Bike Mitsubishi Outlander Silver Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11283 op-snap---monthly-publication-january-2026.pdf   744 2026-01 Pedal Bike Volkswagen Passat Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
11285 op-snap---monthly-publication-january-2026.pdf   746 2026-01 Pedal Bike Volvo V40.. Grey Driving without Due Care and Attention None Cranmore Boulevard Cranmore Boulevard Solihull Solihull Education N/A   52.3947549 -1.8141729
11286 op-snap---monthly-publication-january-2026.pdf   747 2026-01 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham NFA No Offence   52.4695793 -1.9378608
11309 op-snap---monthly-publication-january-2026.pdf   770 2026-01 Pedal Bike Mercedes-Benz 180 Black Stop a vehicle within pelican pedestrian crossing limits None Gooch Street Gooch Street Birmingham Birmingham Education N/A   52.4686609 -1.8945007
11315 op-snap---monthly-publication-january-2026.pdf   776 2026-01 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None The Broadway The Broadway Dudley Dudley Warning Letter N/A   52.515445 -2.0885791
11336 op-snap---monthly-publication-january-2026.pdf   797 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
11344 op-snap---monthly-publication-january-2026.pdf   805 2026-01 Pedal Bike Porsche Panamera Black Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham Education N/A   52.4591339 -1.9601054
11351 op-snap---monthly-publication-january-2026.pdf   812 2026-01 Pedal Bike Citroen C3 Black Driving without Due Care and Attention None Hollyfast Lane Hollyfast Lane Coventry Coventry Warning Letter N/A   52.4517652 -1.5578662
11356 op-snap---monthly-publication-january-2026.pdf   817 2026-01 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Wenlock Road, Shrewsbury Wenlock Road, Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
11367 op-snap---monthly-publication-january-2026.pdf   828 2026-01 Pedal Bike BMW X4 Blue Driving without Due Care and Attention None South Road South Road Birmingham Birmingham Warning Letter N/A   52.4972567 -1.9214327
11368 op-snap---monthly-publication-january-2026.pdf   829 2026-01 Pedal Bike Mercedes-Benz C300 Black Driving without Due Care and Attention None Quinton Interchange Quinton Interchange Dudley Dudley Education N/A   52.4539668 -2.0119854
11402 op-snap---monthly-publication-january-2026.pdf   863 2026-01 Pedal Bike Kia Sportage Black Driving without Due Care and Attention None Park Road Park Road Birmingham Birmingham Warning Letter N/A   52.5641687 -1.8272087
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
11427 op-snap---monthly-publication-january-2026.pdf   888 2026-01 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
11432 op-snap---monthly-publication-january-2026.pdf   893 2026-01 Pedal Bike Honda Civic Grey Driving without Due Care and Attention None Belford Road Belford Road Out of Force Area Out of Force Area NFA Out of Force      
11434 op-snap---monthly-publication-january-2026.pdf   895 2026-01 Pedal Bike Mercedes-Benz A200 White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
11435 op-snap---monthly-publication-january-2026.pdf   896 2026-01 Pedal Bike Mercedes-Benz QB 350 Black Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
11436 op-snap---monthly-publication-january-2026.pdf   897 2026-01 Pedal Bike Porsche Cayenne Grey Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
11451 op-snap---monthly-publication-january-2026.pdf   912 2026-01 Pedal Bike Audi A3 Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671

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