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

277 rows where month = "2025-07" 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

disposal 5

reporter_transport_mode 1

  • Pedal Bike · 277 ✖

month 1

  • 2025-07 · 277 ✖
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
11960 op-snap---monthly-publication-july-2025.pdf   12 2025-07 Pedal Bike Vauxhall Zafira Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
11965 op-snap---monthly-publication-july-2025.pdf   17 2025-07 Pedal Bike Mazda Three Black Using a Mobile Phone Whilst Driving None Sherlock Street Sherlock Street Birmingham Birmingham NFA No Independent Evidence Available   52.4702385 -1.895011
11982 op-snap---monthly-publication-july-2025.pdf   34 2025-07 Pedal Bike   Scania White Driving without Due Care and Attention None Cornets End Lane Cornets End Lane Coventry Coventry Education N/A      
11983 op-snap---monthly-publication-july-2025.pdf   35 2025-07 Pedal Bike Peugeot 208 Black Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11985 op-snap---monthly-publication-july-2025.pdf   37 2025-07 Pedal Bike Honda Insight Silver Driving without Reasonable Consideration None Parsonage Street, West Bromwich Parsonage Street, West Bromwich Sandwell Sandwell Warning Letter N/A   52.5306821 -1.9875151
11986 op-snap---monthly-publication-july-2025.pdf   38 2025-07 Pedal Bike Ford Fiesta Brown Contravening a Red Traffic Light None Broomfield Road Broomfield Road Coventry Coventry NFA No Offence   52.4034143 -1.5300449
11991 op-snap---monthly-publication-july-2025.pdf   43 2025-07 Pedal Bike Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
11992 op-snap---monthly-publication-july-2025.pdf   44 2025-07 Pedal Bike Kia Rio Silver Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
11993 op-snap---monthly-publication-july-2025.pdf   45 2025-07 Pedal Bike Volkswagen Caddy White Using a Mobile Phone Whilst Driving None Suffolk Street Suffolk Street Birmingham Birmingham Fixed Penalty N/A   52.4749336 -1.9003475
11999 op-snap---monthly-publication-july-2025.pdf   51 2025-07 Pedal Bike Toyota Yaris Silver Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
12004 op-snap---monthly-publication-july-2025.pdf   56 2025-07 Pedal Bike Kia Sportage Grey Driving without Reasonable Consideration None Ridgacre Road Ridgacre Road Birmingham Birmingham Education N/A   52.4593367 -2.0000298
12005 op-snap---monthly-publication-july-2025.pdf   57 2025-07 Pedal Bike Ford Transit White Contravening a Red Traffic Light None Harborne Road Harborne Road Birmingham Birmingham NFA No Independent Evidence Available   52.4718503 -1.9195423
12006 op-snap---monthly-publication-july-2025.pdf   58 2025-07 Pedal Bike Peugeot 308 Grey Contravening a Red Traffic Light None Beauty Bank Beauty Bank Sandwell Sandwell NFA No Offence   52.4707042 -2.0596027
12010 op-snap---monthly-publication-july-2025.pdf   62 2025-07 Pedal Bike Volvo V40 Blue Driving without Due Care and Attention None Meer End Road Meer End Road Solihull Solihull Education N/A   52.373396 -1.6335409
12011 op-snap---monthly-publication-july-2025.pdf   63 2025-07 Pedal Bike Mini Cooper White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
12012 op-snap---monthly-publication-july-2025.pdf   64 2025-07 Pedal Bike Hyundai Ioniq 5 Blue Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
12015 op-snap---monthly-publication-july-2025.pdf   67 2025-07 Pedal Bike Ford Focus Blue Using a Mobile Phone Whilst Driving None Winchester Drive, Chelmsley Wood Winchester Drive, Chelmsley Wood Birmingham Birmingham Fixed Penalty N/A      
12020 op-snap---monthly-publication-july-2025.pdf   72 2025-07 Pedal Bike Mercedes-Benz GLC220 Black Using a Mobile Phone Whilst Driving None Bramble Street Bramble Street Coventry Coventry Fixed Penalty N/A   52.4071693 -1.4960723
12024 op-snap---monthly-publication-july-2025.pdf   76 2025-07 Pedal Bike Daf Taxi Black Using a Mobile Phone Whilst Driving None Humber Road, Humber Road Coventry Coventry Fixed Penalty N/A   52.4050667 -1.4866877
12026 op-snap---monthly-publication-july-2025.pdf   78 2025-07 Pedal Bike Toyota Prius Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12040 op-snap---monthly-publication-july-2025.pdf   92 2025-07 Pedal Bike BMW 520.. Black Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull NFA Outside of 14 Days NIP      
12049 op-snap---monthly-publication-july-2025.pdf   101 2025-07 Pedal Bike BMW 320d Black Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
12054 op-snap---monthly-publication-july-2025.pdf   106 2025-07 Pedal Bike Omoda 5 Noble Black Using a Mobile Phone Whilst Driving none Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Fixed Penalty N/A   52.4760986 -1.9018641
12055 op-snap---monthly-publication-july-2025.pdf   107 2025-07 Pedal Bike Vauxhall Astra White Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
12056 op-snap---monthly-publication-july-2025.pdf   108 2025-07 Pedal Bike Hyundai I20 White Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
12057 op-snap---monthly-publication-july-2025.pdf   109 2025-07 Pedal Bike Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
12059 op-snap---monthly-publication-july-2025.pdf   111 2025-07 Pedal Bike BMW 4 series White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
12067 op-snap---monthly-publication-july-2025.pdf   119 2025-07 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Solihull Solihull Court N/A   52.4640893 -1.7362681
12073 op-snap---monthly-publication-july-2025.pdf   125 2025-07 Pedal Bike Vauxhall astra Red Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4467275 -1.8804014
12082 op-snap---monthly-publication-july-2025.pdf   134 2025-07 Pedal Bike Land Rover Range Rover Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
12086 op-snap---monthly-publication-july-2025.pdf   138 2025-07 Pedal Bike BMW 320i Silver Using a Mobile Phone Whilst Driving None Granville Street Granville Street Birmingham Birmingham Fixed Penalty N/A   52.4762076 -1.9124263
12087 op-snap---monthly-publication-july-2025.pdf   139 2025-07 Pedal Bike BMW 116.. White Driving without Due Care and Attention None Bearwood Road Bearwood Road Sandwell Sandwell Education N/A   52.4725977 -1.9684448
12089 op-snap---monthly-publication-july-2025.pdf   141 2025-07 Pedal Bike BMW 120.. Grey Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
12090 op-snap---monthly-publication-july-2025.pdf   142 2025-07 Pedal Bike Vauxhall Zafira Black Using a Mobile Phone Whilst Driving None Metchley Road Metchley Road Birmingham Birmingham Fixed Penalty N/A   52.4527174 -1.9590253
12093 op-snap---monthly-publication-july-2025.pdf   145 2025-07 Pedal Bike BMW 330e Blue Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
12100 op-snap---monthly-publication-july-2025.pdf   152 2025-07 Pedal Bike Skoda Kamiq White Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham Court N/A   52.5113867 -1.8337258
12117 op-snap---monthly-publication-july-2025.pdf   169 2025-07 Pedal Bike Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Lionel Street Lionel Street Birmingham Birmingham Fixed Penalty N/A   52.4821516 -1.9058355
12118 op-snap---monthly-publication-july-2025.pdf   170 2025-07 Pedal Bike Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Newhall Street Newhall Street Birmingham Birmingham NFA No Independent Evidence Available   52.4830482 -1.905069
12121 op-snap---monthly-publication-july-2025.pdf   173 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Dorchester Road Dorchester Road Solihull Solihull Court N/A   52.4157911 -1.7926505
12125 op-snap---monthly-publication-july-2025.pdf   177 2025-07 Pedal Bike Audi Q5 Blue Driving without Due Care and Attention None Bookvale Road Bookvale Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12126 op-snap---monthly-publication-july-2025.pdf   178 2025-07 Pedal Bike Citroen C3 Blue Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA No Offence   52.4763176 -1.9584897
12130 op-snap---monthly-publication-july-2025.pdf   182 2025-07 Pedal Bike Skoda   Black Driving without Due Care and Attention None Witton Road, Witton Lane Witton Road, Witton Lane Birmingham Birmingham NFA No VRM      
12132 op-snap---monthly-publication-july-2025.pdf   184 2025-07 Pedal Bike Daf   White Driving without Due Care and Attention None Gooch st at Bissell St Gooch st at Bissell Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4696234 -1.8952392
12133 op-snap---monthly-publication-july-2025.pdf   185 2025-07 Pedal Bike Volvo Bus Red Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham NFA No Offence      
12137 op-snap---monthly-publication-july-2025.pdf   189 2025-07 Pedal Bike Renault Captur Blue Using a Mobile Phone Whilst Driving None Winchester Road Winchester Road Birmingham Birmingham Fixed Penalty N/A   52.5111504 -1.8987154
12138 op-snap---monthly-publication-july-2025.pdf   190 2025-07 Pedal Bike Ford Fiesta Black Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
12168 op-snap---monthly-publication-july-2025.pdf   220 2025-07 Pedal Bike Tesla Model 3 White Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
12169 op-snap---monthly-publication-july-2025.pdf   221 2025-07 Pedal Bike Hyundai i30 Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment No vehicle excise licence Leicester Row Leicester Row Coventry Coventry Court N/A   52.414317 -1.5104573
12174 op-snap---monthly-publication-july-2025.pdf   226 2025-07 Pedal Bike Ford B-Max Blue Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12175 op-snap---monthly-publication-july-2025.pdf   227 2025-07 Pedal Bike Volkswagen Golf Grey Contravening a Red Traffic Light None Haslucks Green Road Haslucks Green Road Solihull Solihull Education N/A   52.4145149 -1.8301272
12179 op-snap---monthly-publication-july-2025.pdf   231 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Ampton Road Ampton Road Birmingham Birmingham Education N/A   52.4632489 -1.917458
12195 op-snap---monthly-publication-july-2025.pdf   247 2025-07 Pedal Bike Mini cooper Blue Driving without Due Care and Attention None Bewdley Bewdley Out of Force Area Out of Force Area NFA Out of Force   52.4330724 -1.9181313
12196 op-snap---monthly-publication-july-2025.pdf   248 2025-07 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Priory Road Priory Road Birmingham Birmingham Fixed Penalty N/A   52.4132696 -1.8555008
12218 op-snap---monthly-publication-july-2025.pdf   270 2025-07 Pedal Bike Jaguar XE Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5872149 -1.8300386
12223 op-snap---monthly-publication-july-2025.pdf   275 2025-07 Pedal Bike Volkswagen Touran Black Using a Mobile Phone Whilst Driving None Cheddar Road Cheddar Road Birmingham Birmingham Fixed Penalty N/A   52.4592888 -1.8961525
12224 op-snap---monthly-publication-july-2025.pdf   276 2025-07 Pedal Bike Seat Ibiza Black Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
12227 op-snap---monthly-publication-july-2025.pdf   279 2025-07 Pedal Bike Chevrolet Chrysler Black Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
12241 op-snap---monthly-publication-july-2025.pdf   293 2025-07 Pedal Bike Vauxhall Meriva White Driving without Due Care and Attention None Linden Road Linden Road Solihull Solihull NFA Outside of 14 Days NIP      
12242 op-snap---monthly-publication-july-2025.pdf   294 2025-07 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4390303 -1.9512931
12244 op-snap---monthly-publication-july-2025.pdf   296 2025-07 Pedal Bike Hyundai I10 Red Driving without Due Care and Attention None Shenley Hill Shenley Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4267534 -1.9790765
12245 op-snap---monthly-publication-july-2025.pdf   297 2025-07 Pedal Bike Volkswagen Passat Blue Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4436471 -1.9604594
12266 op-snap---monthly-publication-july-2025.pdf   318 2025-07 Pedal Bike BMW X6 Grey Contravening a Red Traffic Light None New John Street New John Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4920451 -1.8920402
12268 op-snap---monthly-publication-july-2025.pdf   320 2025-07 Pedal Bike Citroen Dispatch Silver Using a Mobile Phone Whilst Driving None Burleton Road Burleton Road Birmingham Birmingham Fixed Penalty N/A   52.4771213 -1.7620536
12270 op-snap---monthly-publication-july-2025.pdf   322 2025-07 Pedal Bike BMW 220i White Driving without Due Care and Attention None Woodbourne Road Woodbourne Road Birmingham Birmingham Warning Letter N/A   52.4702361 -1.951945
12271 op-snap---monthly-publication-july-2025.pdf   323 2025-07 Pedal Bike Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Newton Road Newton Road Birmingham Birmingham Fixed Penalty N/A   52.4541102 -1.8710993
12273 op-snap---monthly-publication-july-2025.pdf   325 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Haxelhurst Road Haxelhurst Road Birmingham Birmingham NFA No Offence      
12276 op-snap---monthly-publication-july-2025.pdf   328 2025-07 Pedal Bike Toyota Rav 4 Grey Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
12277 op-snap---monthly-publication-july-2025.pdf   329 2025-07 Pedal Bike Audi RSQ8 Grey Driving without Due Care and Attention None Cornwall Street Cornwall Street Birmingham Birmingham Warning Letter N/A   52.4815054 -1.9032499
12286 op-snap---monthly-publication-july-2025.pdf   338 2025-07 Pedal Bike Mercedes-Benz SL320 Green Using a Mobile Phone Whilst Driving None Longmore Street Longmore Street Birmingham Birmingham Fixed Penalty N/A   52.464484 -1.8923374
12287 op-snap---monthly-publication-july-2025.pdf   339 2025-07 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None 6 ways roundabout 6 Ways Roundabout Birmingham Birmingham Warning Letter N/A      
12327 op-snap---monthly-publication-july-2025.pdf   379 2025-07 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Hazelhurts Road Hazelhurts Road Birmingham Birmingham NFA Not in Public Interest      
12339 op-snap---monthly-publication-july-2025.pdf   391 2025-07 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Foles Hill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
12348 op-snap---monthly-publication-july-2025.pdf   400 2025-07 Pedal Bike Audi   Black Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
12349 op-snap---monthly-publication-july-2025.pdf   401 2025-07 Pedal Bike Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
12350 op-snap---monthly-publication-july-2025.pdf   402 2025-07 Pedal Bike Mitsubishi Colt Black Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4943878 -1.8504211
12352 op-snap---monthly-publication-july-2025.pdf   404 2025-07 Pedal Bike Nissan Juke Silver Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
12353 op-snap---monthly-publication-july-2025.pdf   405 2025-07 Pedal Bike Audi A6... Black Driving without Due Care and Attention None Butts Road Butts Road Walsall Walsall NFA Not in Public Interest   52.592263 -1.9743536
12354 op-snap---monthly-publication-july-2025.pdf   406 2025-07 Pedal Bike Audi A5 Grey Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
12356 op-snap---monthly-publication-july-2025.pdf   408 2025-07 Pedal Bike BMW 3 series White Driving without Reasonable Consideration No Insurance Butts Road Butts Road Walsall Walsall Fixed Penalty N/A   52.592263 -1.9743536
12366 op-snap---monthly-publication-july-2025.pdf   418 2025-07 Pedal Bike BMW 120 Grey Using a Mobile Phone Whilst Driving None Aston Webb Aston Webb Birmingham Birmingham Fixed Penalty N/A   52.4468669 -1.9397041
12367 op-snap---monthly-publication-july-2025.pdf   419 2025-07 Pedal Bike Kia Sportage Silver Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
12368 op-snap---monthly-publication-july-2025.pdf   420 2025-07 Pedal Bike Seat ATECA Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
12369 op-snap---monthly-publication-july-2025.pdf   421 2025-07 Pedal Bike Mini XCountryman Silver Using a Mobile Phone Whilst Driving None Harborne high st Harborne high st Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
12370 op-snap---monthly-publication-july-2025.pdf   422 2025-07 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
12374 op-snap---monthly-publication-july-2025.pdf   426 2025-07 Pedal Bike Audi A3 White Using a Mobile Phone Whilst Driving None Warwick Road Warwick Road Birmingham Birmingham NFA No Independent Evidence Available   52.4555288 -1.8613929
12376 op-snap---monthly-publication-july-2025.pdf   428 2025-07 Pedal Bike Ford Fiesta ST Red Using a Mobile Phone Whilst Driving None Moor Green Lane Moor Green Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4374665 -1.9119895
12380 op-snap---monthly-publication-july-2025.pdf   432 2025-07 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
12391 op-snap---monthly-publication-july-2025.pdf   443 2025-07 Pedal Bike Peugeot 2008 Grey Driving without Due Care and Attention None Coventry Road Coventry Road Coventry Coventry Education N/A   52.4111289 -1.5094345
12400 op-snap---monthly-publication-july-2025.pdf   452 2025-07 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None May Lane May Lane Birmingham Birmingham Education N/A   52.4197342 -1.8839613
12408 op-snap---monthly-publication-july-2025.pdf   460 2025-07 Pedal Bike Renault Trafic Silver Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
12409 op-snap---monthly-publication-july-2025.pdf   461 2025-07 Pedal Bike Mercedes-Benz GLA Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
12417 op-snap---monthly-publication-july-2025.pdf   469 2025-07 Pedal Bike Renault Captur Silver Driving without Due Care and Attention None Upper Hill Street Upper Hill Street Coventry Coventry NFA No Offence   52.4106808 -1.5185684
12420 op-snap---monthly-publication-july-2025.pdf   472 2025-07 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Bridgenorth Road Bridgenorth Road Out of Force Area Out of Force Area NFA Out of Force      
12422 op-snap---monthly-publication-july-2025.pdf   474 2025-07 Pedal Bike Mazda 6... Red Driving without Due Care and Attention None Melrose Avenue Melrose Avenue Sutton Coldfield Sutton Coldfield NFA No Offence   52.5511462 -1.8479052
12423 op-snap---monthly-publication-july-2025.pdf   475 2025-07 Pedal Bike Ford fiesta Silver Dangerous Driving None Worcester, West Mercia Force area Worcester, West Mercia Force area Out of Force Area Out of Force Area NFA Out of Force      
12435 op-snap---monthly-publication-july-2025.pdf   487 2025-07 Pedal Bike Ford Transit Red Using a Mobile Phone Whilst Driving None Pineapple Road Pineapple Road Birmingham Birmingham NFA No Independent Evidence Available   52.4303068 -1.9077938
12457 op-snap---monthly-publication-july-2025.pdf   509 2025-07 Pedal Bike BMW M135i Grey Driving without Due Care and Attention None Shilton Lane Shilton Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4425711 -1.4532921
12458 op-snap---monthly-publication-july-2025.pdf   510 2025-07 Pedal Bike BMW 330e Black Using a Mobile Phone Whilst Driving Driving without Due Care and AStttoennetiyo nStanton Road AStttoennetiyo n Stanton Road Coventry Coventry Court N/A      
12459 op-snap---monthly-publication-july-2025.pdf   511 2025-07 Pedal Bike Vauxhall Insignia White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475

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