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

184 rows where month = "2025-12" 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 · 184 ✖

month 1

  • 2025-12 · 184 ✖
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
3884 op-snap---monthly-publication-december-2025.pdf   12 2025-12 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Education N/A   52.5690586 -1.8794686
3891 op-snap---monthly-publication-december-2025.pdf   19 2025-12 Pedal Bike Ford Mondeo Silver Driving without Due Care and Attention None Longdales Road Longdales Road Birmingham Birmingham Warning Letter N/A   52.3947881 -1.9285109
3892 op-snap---monthly-publication-december-2025.pdf   20 2025-12 Pedal Bike Nissan Note White Driving without Due Care and Attention None Wychall Lane Wychall Lane Birmingham Birmingham Warning Letter N/A   52.4090761 -1.9404121
3910 op-snap---monthly-publication-december-2025.pdf   38 2025-12 Pedal Bike Kia   Blue Driving without Due Care and Attention None Woodville Road Woodville Road Birmingham Birmingham NFA No Offence   52.4616763 -1.9653016
3912 op-snap---monthly-publication-december-2025.pdf   40 2025-12 Pedal Bike Audi TT Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
3920 op-snap---monthly-publication-december-2025.pdf   48 2025-12 Pedal Bike Audi Q7 White Driving without Due Care and Attention None Yardley Green Lane Yardley Green Lane Birmingham Birmingham Fixed Penalty N/A   52.4551082 -1.8103696
3932 op-snap---monthly-publication-december-2025.pdf   60 2025-12 Pedal Bike Ford   Red Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Walmley Ash Road Walmley Ash Road Birmingham Birmingham Warning Letter N/A   52.5376726 -1.7973346
3984 op-snap---monthly-publication-december-2025.pdf   112 2025-12 Pedal Bike Kia Venga Silver Using a Mobile Phone Whilst Driving None Stratford Road towards Shirley Stratford Road towards Shirley Birmingham Birmingham Fixed Penalty N/A      
3987 op-snap---monthly-publication-december-2025.pdf   115 2025-12 Pedal Bike Volkswagen Golf Silver Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Court N/A   52.4422505 -1.8539684
3988 op-snap---monthly-publication-december-2025.pdf   116 2025-12 Pedal Bike Mercedes-Benz A35 Blue Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
3994 op-snap---monthly-publication-december-2025.pdf   122 2025-12 Pedal Bike Kia Sportage Blue Driving without Due Care and Attention None Cressage Cressage Out of Force Area Out of Force Area NFA Out of Force   52.40435 -1.9677367
3995 op-snap---monthly-publication-december-2025.pdf   123 2025-12 Pedal Bike Volkswagen   Red Driving without Due Care and Attention None Atcham Atcham Out of Force Area Out of Force Area NFA Out of Force      
4009 op-snap---monthly-publication-december-2025.pdf   137 2025-12 Pedal Bike Volkswagen TRoc Silver Driving without Due Care and Attention none Longmoor Street Longmoor Street Birmingham Birmingham Fixed Penalty N/A      
4010 op-snap---monthly-publication-december-2025.pdf   138 2025-12 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4011 op-snap---monthly-publication-december-2025.pdf   139 2025-12 Pedal Bike Land Rover Velar Black Driving without Due Care and Attention None High Street, Deritend High Street, Deritend Birmingham Birmingham Warning Letter N/A   52.4746492 -1.8839977
4012 op-snap---monthly-publication-december-2025.pdf   140 2025-12 Pedal Bike Peugeot 208 Orange Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4015 op-snap---monthly-publication-december-2025.pdf   143 2025-12 Pedal Bike Mini Clubman White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4016 op-snap---monthly-publication-december-2025.pdf   144 2025-12 Pedal Bike BMW i4 Green Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4017 op-snap---monthly-publication-december-2025.pdf   145 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Westward Way Westward Way Coventry Coventry Education N/A      
4020 op-snap---monthly-publication-december-2025.pdf   148 2025-12 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
4021 op-snap---monthly-publication-december-2025.pdf   149 2025-12 Pedal Bike Volkswagen Polo White Contravening a Red Traffic Light None California Way California Way Birmingham Birmingham NFA No VRM   52.4454714 -1.9753804
4027 op-snap---monthly-publication-december-2025.pdf   155 2025-12 Pedal Bike Vauxhall Insignia Black Driving without Due Care and Attention None A491 Hagley Road Hagley Road Dudley Dudley Warning Letter N/A   52.4514139 -2.1423625
4041 op-snap---monthly-publication-december-2025.pdf   169 2025-12 Pedal Bike Renault Kadjar Black Driving without Due Care and Attention None Lincoln Street Lincoln Street Birmingham Birmingham Court N/A   52.459298 -1.8933648
4044 op-snap---monthly-publication-december-2025.pdf   172 2025-12 Pedal Bike Jaguar F Pace Blue Using a Mobile Phone Whilst Driving None Park Hill Road Park Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
4045 op-snap---monthly-publication-december-2025.pdf   173 2025-12 Pedal Bike Mercedes-Benz CLA 250 Black Using a Mobile Phone Whilst Driving None Navigation Street Navigation Street Birmingham Birmingham Fixed Penalty N/A   52.4781877 -1.9011642
4047 op-snap---monthly-publication-december-2025.pdf   175 2025-12 Pedal Bike Renault Clio Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4049 op-snap---monthly-publication-december-2025.pdf   177 2025-12 Pedal Bike Renault   Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4050 op-snap---monthly-publication-december-2025.pdf   178 2025-12 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
4051 op-snap---monthly-publication-december-2025.pdf   179 2025-12 Pedal Bike Audi Q8 Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4079 op-snap---monthly-publication-december-2025.pdf   207 2025-12 Pedal Bike Toyota Rav4 Black Driving without Due Care and Attention None Spiceland Road Northfield Spiceland Road Northfield Birmingham Birmingham NFA No Independent Evidence Available   52.4243001 -1.9747504
4080 op-snap---monthly-publication-december-2025.pdf   208 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
4082 op-snap---monthly-publication-december-2025.pdf   210 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Duplicate Submission   52.5827653 -2.0983246
4086 op-snap---monthly-publication-december-2025.pdf   214 2025-12 Pedal Bike Volkswagen UP Red Driving without Due Care and Attention None Swanswwell St Swanswwell Street Coventry Coventry Education N/A      
4099 op-snap---monthly-publication-december-2025.pdf   227 2025-12 Pedal Bike BMW 335.. Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Raddlebarn Road Raddlebarn Road Birmingham Birmingham Warning Letter N/A   52.4397168 -1.9260414
4117 op-snap---monthly-publication-december-2025.pdf   245 2025-12 Pedal Bike Volkswagen Touran Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Independent Evidence Available   52.4422505 -1.8539684
4138 op-snap---monthly-publication-december-2025.pdf   266 2025-12 Pedal Bike Mitsubishi Outlander Red Driving without Due Care and Attention None Monkspath Hall Rd Monkspath Hall Road Solihull Solihull Fixed Penalty N/A   52.3900358 -1.8026595
4152 op-snap---monthly-publication-december-2025.pdf   280 2025-12 Pedal Bike Audi A4 White Driving without Due Care and Attention No Insurance Tyburn Road Tyburn Road Birmingham Birmingham Court N/A   52.5113867 -1.8337258
4154 op-snap---monthly-publication-december-2025.pdf   282 2025-12 Pedal Bike BMW X5.. Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4155 op-snap---monthly-publication-december-2025.pdf   283 2025-12 Pedal Bike Hyundai i30 Black Driving without Due Care and Attention None Stratford Road and Farm Road jun Stratford Road and Farm Road jun cBtiiromningham Cbtiiromningham Fixed Penalty N/A   52.4532265 -1.8659356
4156 op-snap---monthly-publication-december-2025.pdf   284 2025-12 Pedal Bike Vauxhall Mokka Black Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4157 op-snap---monthly-publication-december-2025.pdf   285 2025-12 Pedal Bike Seat Ibiza Black Contravening a Red Traffic Light None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
4160 op-snap---monthly-publication-december-2025.pdf   288 2025-12 Pedal Bike BMW M4 Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4161 op-snap---monthly-publication-december-2025.pdf   289 2025-12 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Sarehold Road Sarehold Road Birmingham Birmingham Education N/A      
4162 op-snap---monthly-publication-december-2025.pdf   290 2025-12 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4163 op-snap---monthly-publication-december-2025.pdf   291 2025-12 Pedal Bike Nissan Juke Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4183 op-snap---monthly-publication-december-2025.pdf   311 2025-12 Pedal Bike Volvo XC90 White Driving without Due Care and Attention None Charles Henry Street Charles Henry Street Birmingham Birmingham Education N/A   52.4709195 -1.8888591
4194 op-snap---monthly-publication-december-2025.pdf   322 2025-12 Pedal Bike BMW 520D Black Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Independent Evidence Available   52.4422505 -1.8539684
4195 op-snap---monthly-publication-december-2025.pdf   323 2025-12 Pedal Bike Tesla Model Y White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
4196 op-snap---monthly-publication-december-2025.pdf   324 2025-12 Pedal Bike Mercedes-Benz Splinter White Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4281 op-snap---monthly-publication-december-2025.pdf   409 2025-12 Pedal Bike Porsche 911.. White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4282 op-snap---monthly-publication-december-2025.pdf   410 2025-12 Pedal Bike Seat Arona Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4283 op-snap---monthly-publication-december-2025.pdf   411 2025-12 Pedal Bike Mercedes-Benz CLA White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4284 op-snap---monthly-publication-december-2025.pdf   412 2025-12 Pedal Bike Hyundai Kona Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4288 op-snap---monthly-publication-december-2025.pdf   416 2025-12 Pedal Bike Renault Megane Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
4289 op-snap---monthly-publication-december-2025.pdf   417 2025-12 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry Fixed Penalty N/A   52.4070602 -1.4732469
4290 op-snap---monthly-publication-december-2025.pdf   418 2025-12 Pedal Bike Mitsubishi ASX.. Black Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Fixed Penalty N/A   52.5242452 -1.8572541
4291 op-snap---monthly-publication-december-2025.pdf   419 2025-12 Pedal Bike Skoda Superb Grey Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Fixed Penalty N/A   52.5242452 -1.8572541
4292 op-snap---monthly-publication-december-2025.pdf   420 2025-12 Pedal Bike Citroen C3 Black Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
4301 op-snap---monthly-publication-december-2025.pdf   429 2025-12 Pedal Bike BMW 5 series Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
4302 op-snap---monthly-publication-december-2025.pdf   430 2025-12 Pedal Bike Volvo V60 Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Fixed Penalty N/A   52.4094108 -1.9930633
4304 op-snap---monthly-publication-december-2025.pdf   432 2025-12 Pedal Bike Audi A1.. Grey Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
4311 op-snap---monthly-publication-december-2025.pdf   439 2025-12 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Hereford Road Shrewsbury Hereford Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4313 op-snap---monthly-publication-december-2025.pdf   441 2025-12 Pedal Bike Ford Kuga Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
4320 op-snap---monthly-publication-december-2025.pdf   448 2025-12 Pedal Bike Skoda Enyaq Grey Driving without Due Care and Attention None Bourneville Lane Bourneville Lane Birmingham Birmingham Education N/A      
4328 op-snap---monthly-publication-december-2025.pdf   456 2025-12 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Lady Byron Lane Lady Byron Lane Solihull Solihull Warning Letter N/A   52.4026126 -1.7503668
4330 op-snap---monthly-publication-december-2025.pdf   458 2025-12 Pedal Bike Hyundai I40.. White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
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
4341 op-snap---monthly-publication-december-2025.pdf   469 2025-12 Pedal Bike Toyota Prius Black Using a Mobile Phone Whilst Driving None Bradford Street Bradford Street Birmingham Birmingham NFA No Offence   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
4345 op-snap---monthly-publication-december-2025.pdf   473 2025-12 Pedal Bike   Bentley Blue Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4347 op-snap---monthly-publication-december-2025.pdf   475 2025-12 Pedal Bike Mercedes-Benz A180.. Black Using a Mobile Phone Whilst Driving None Metchley Lane Harborne Metchley Lane Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4348 op-snap---monthly-publication-december-2025.pdf   476 2025-12 Pedal Bike Audi Q3 Black Use a motor vehicle / trailer in a condition likely to cause danger of injury None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4350 op-snap---monthly-publication-december-2025.pdf   478 2025-12 Pedal Bike Volkswagen Tiguan Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4352 op-snap---monthly-publication-december-2025.pdf   480 2025-12 Pedal Bike Porsche Taycan Grey Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4353 op-snap---monthly-publication-december-2025.pdf   481 2025-12 Pedal Bike Skoda Octavia Beige Using a Mobile Phone Whilst Driving None Aston Webb Blvd, Selly Oak Aston Webb Boulevard, Selly Oak Birmingham Birmingham Fixed Penalty N/A   52.4443904 -1.9419231
4354 op-snap---monthly-publication-december-2025.pdf   482 2025-12 Pedal Bike Audi E tron Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4356 op-snap---monthly-publication-december-2025.pdf   484 2025-12 Pedal Bike BMW 120d Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4357 op-snap---monthly-publication-december-2025.pdf   485 2025-12 Pedal Bike Volkswagen Caddy Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4358 op-snap---monthly-publication-december-2025.pdf   486 2025-12 Pedal Bike Skoda Kamiq Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4359 op-snap---monthly-publication-december-2025.pdf   487 2025-12 Pedal Bike Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
4360 op-snap---monthly-publication-december-2025.pdf   488 2025-12 Pedal Bike Mercedes-Benz E350 Blue Using a Mobile Phone Whilst Driving None     Birmingham Birmingham NFA No Independent Evidence Available      
4374 op-snap---monthly-publication-december-2025.pdf   502 2025-12 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4375 op-snap---monthly-publication-december-2025.pdf   503 2025-12 Pedal Bike Kia Ceed Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4377 op-snap---monthly-publication-december-2025.pdf   505 2025-12 Pedal Bike   NP   Misc - Non Traffic Offences None Mellowdew Road Mellowdew Road Coventry Coventry NFA Misc Inc Crimes   52.4128327 -1.4672401
4378 op-snap---monthly-publication-december-2025.pdf   506 2025-12 Pedal Bike   U/K White Driving without Due Care and Attention None Belgrave Road Belgrave Road Coventry Coventry NFA No Independent Evidence Available   52.4141017 -1.4571973
4379 op-snap---monthly-publication-december-2025.pdf   507 2025-12 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Offence   52.5113867 -1.8337258
4388 op-snap---monthly-publication-december-2025.pdf   516 2025-12 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Corners End Lane Corners End Lane Solihull Solihull NFA No Offence      
4391 op-snap---monthly-publication-december-2025.pdf   519 2025-12 Pedal Bike Ford Fiesta Silver Driving without Due Care and Attention None South Road South Road Dudley Dudley Fixed Penalty N/A   52.4530371 -2.1660216
4413 op-snap---monthly-publication-december-2025.pdf   541 2025-12 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Frankly Beeches Road Frankly Beeches Road Birmingham Birmingham NFA No Offence      
4414 op-snap---monthly-publication-december-2025.pdf   542 2025-12 Pedal Bike Audi A4.. Black Driving without Due Care and Attention None Church Road Northfield Church Road Northfield Birmingham Birmingham NFA No Offence   52.4143428 -1.966939
4415 op-snap---monthly-publication-december-2025.pdf   543 2025-12 Pedal Bike Honda Civic Silver Driving without Due Care and Attention None Tessal Lane Tessal Lane Birmingham Birmingham Education N/A      
4418 op-snap---monthly-publication-december-2025.pdf   546 2025-12 Pedal Bike Peugeot 3008.. Blue Using a Mobile Phone Whilst Driving None Sky Blue Way Sky Blue Way Coventry Coventry Fixed Penalty N/A   52.4085943 -1.4943275
4426 op-snap---monthly-publication-december-2025.pdf   554 2025-12 Pedal Bike Peugeot 3008.. Blue Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Fixed Penalty N/A   52.4068712 -1.4994695
4428 op-snap---monthly-publication-december-2025.pdf   556 2025-12 Pedal Bike BMW X3 Black Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
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
4451 op-snap---monthly-publication-december-2025.pdf   579 2025-12 Pedal Bike Volkswagen Polo Silver Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
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
4468 op-snap---monthly-publication-december-2025.pdf   596 2025-12 Pedal Bike   NP   Misc - Non Traffic Offences None Unknown       NFA No VRM      

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