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

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

month 1

  • 2025-10 · 235 ✖
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
22061 op-snap---monthly-publication-october-2025.pdf   11 2025-10 Pedal Bike Peugeot Rifter White Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A   52.4134557 -1.4442138
22063 op-snap---monthly-publication-october-2025.pdf   13 2025-10 Pedal Bike Volkswagen Up White Driving without Due Care and Attention None Abbey Road Abbey Road Birmingham Birmingham Warning Letter N/A   52.5162302 -1.8593733
22065 op-snap---monthly-publication-october-2025.pdf   15 2025-10 Pedal Bike Audi   Black Driving without Reasonable Consideration None Castle Road Castle Road Out of Force Area Out of Force Area NFA Out of Force   52.4358056 -1.9593904
22079 op-snap---monthly-publication-october-2025.pdf   29 2025-10 Pedal Bike Mercedes-Benz E320 Silver Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham Education N/A   52.4381959 -1.8907391
22083 op-snap---monthly-publication-october-2025.pdf   33 2025-10 Pedal Bike Nissan Note Blue Driving without Due Care and Attention None Inchlaggan Road Inchlaggan Road Wolverhampton Wolverhampton Education N/A   52.6049304 -2.10742
22084 op-snap---monthly-publication-october-2025.pdf   34 2025-10 Pedal Bike Volkswagen Passat Silver Driving without Due Care and Attention None Birchall Street Digbeth Birchall Street Digbeth Birmingham Birmingham Fixed Penalty N/A   52.4723412 -1.8874708
22085 op-snap---monthly-publication-october-2025.pdf   35 2025-10 Pedal Bike Mg HS White Driving a vehicle wholly or partly on a footpath None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
22086 op-snap---monthly-publication-october-2025.pdf   36 2025-10 Pedal Bike Hyundai Ioniq Grey Driving a vehicle wholly or partly on a footpath None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
22087 op-snap---monthly-publication-october-2025.pdf   37 2025-10 Pedal Bike Nissan X-Trail Black Driving a vehicle wholly or partly on a footpath None Cannock Road Cannock Road Wolverhampton Wolverhampton Education N/A   52.6083917 -2.1033365
22089 op-snap---monthly-publication-october-2025.pdf   39 2025-10 Pedal Bike Nissan Juke Red Using a Mobile Phone Whilst Driving None Park Hill Road, Harborne Park Hill Road, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
22094 op-snap---monthly-publication-october-2025.pdf   44 2025-10 Pedal Bike Land Rover Range Rover Grey Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
22095 op-snap---monthly-publication-october-2025.pdf   45 2025-10 Pedal Bike Volkswagen ID Yellow Driving without Reasonable Consideration None Weoley Park Weoley Park Birmingham Birmingham NFA No Offence   52.4353726 -1.9460178
22096 op-snap---monthly-publication-october-2025.pdf   46 2025-10 Pedal Bike Mercedes-Benz CLA 250 Grey Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
22097 op-snap---monthly-publication-october-2025.pdf   47 2025-10 Pedal Bike Tesla Model White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
22099 op-snap---monthly-publication-october-2025.pdf   49 2025-10 Pedal Bike Ford B Max Black Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
22100 op-snap---monthly-publication-october-2025.pdf   50 2025-10 Pedal Bike Volvo V 40 Red Using a Mobile Phone Whilst Driving None Umberslade Road Umberslade Road Birmingham Birmingham Fixed Penalty N/A   52.4304526 -1.9216716
22102 op-snap---monthly-publication-october-2025.pdf   52 2025-10 Pedal Bike BMW 435.. Black Driving without Due Care and Attention None Allesley Road Allesley Road Coventry Coventry NFA Outside of 14 Days NIP   52.412663 -1.5443742
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
22106 op-snap---monthly-publication-october-2025.pdf   56 2025-10 Pedal Bike Kia Sportage Green Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
22108 op-snap---monthly-publication-october-2025.pdf   58 2025-10 Pedal Bike Yamaha R6 Blue Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
22109 op-snap---monthly-publication-october-2025.pdf   59 2025-10 Pedal Bike Mercedes-Benz A250 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
22110 op-snap---monthly-publication-october-2025.pdf   60 2025-10 Pedal Bike Volkswagen Transporter Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
22111 op-snap---monthly-publication-october-2025.pdf   61 2025-10 Pedal Bike Citroen   Silver Driving without Reasonable Consideration None Earlsdon Ave Earlsdon Ave Coventry Coventry NFA No Independent Evidence Available   52.4047134 -1.5351834
22112 op-snap---monthly-publication-october-2025.pdf   62 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Five Ways Roundabout Five Ways Roundabout Birmingham Birmingham Education N/A      
22122 op-snap---monthly-publication-october-2025.pdf   72 2025-10 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Hurst Road Hurst Road Coventry Coventry NFA No Offence   52.4496884 -1.4816181
22147 op-snap---monthly-publication-october-2025.pdf   97 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None A456 Halesowen Halesowen Dudley Dudley Warning Letter N/A   52.4492074 -2.0514646
22148 op-snap---monthly-publication-october-2025.pdf   98 2025-10 Pedal Bike Audi TT. Blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22149 op-snap---monthly-publication-october-2025.pdf   99 2025-10 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Pebble Mill Road Pebble Mill Road Birmingham Birmingham Fixed Penalty N/A   52.4512925 -1.9124618
22150 op-snap---monthly-publication-october-2025.pdf   100 2025-10 Pedal Bike Peugeot 508.. Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
22151 op-snap---monthly-publication-october-2025.pdf   101 2025-10 Pedal Bike Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22152 op-snap---monthly-publication-october-2025.pdf   102 2025-10 Pedal Bike Honda Civic Grey Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22156 op-snap---monthly-publication-october-2025.pdf   106 2025-10 Pedal Bike Land Rover Sport Black Driving without Due Care and Attention None Streetsbrook Road, Shirley Streetsbrook Road, Shirley Solihull Solihull Court N/A   52.4223176 -1.8253145
22157 op-snap---monthly-publication-october-2025.pdf   107 2025-10 Pedal Bike Mazda 3 Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
22186 op-snap---monthly-publication-october-2025.pdf   136 2025-10 Pedal Bike Volkswagen CC Black Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22187 op-snap---monthly-publication-october-2025.pdf   137 2025-10 Pedal Bike Renault Traffic Green Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
22188 op-snap---monthly-publication-october-2025.pdf   138 2025-10 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None St Marys Road Street Marys Road Birmingham Birmingham Fixed Penalty N/A      
22189 op-snap---monthly-publication-october-2025.pdf   139 2025-10 Pedal Bike Mercedes-Benz GLA White Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543
22190 op-snap---monthly-publication-october-2025.pdf   140 2025-10 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Cornets End Lane Cornets End Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4269547 -1.6668911
22193 op-snap---monthly-publication-october-2025.pdf   143 2025-10 Pedal Bike Audi A3 Grey Driving without Reasonable Consideration None Broad Lane Broad Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4074716 -1.5620671
22195 op-snap---monthly-publication-october-2025.pdf   145 2025-10 Pedal Bike Dennis Alexander White Driving without Due Care and Attention None Sharmans Cross Sharmans Cross Solihull Solihull NFA Outside of 14 Days NIP   52.4151594 -1.8062462
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22204 op-snap---monthly-publication-october-2025.pdf   154 2025-10 Pedal Bike   Bus Grey Driving without Due Care and Attention None White Street White Street Birmingham Birmingham NFA No VRM   52.4555554 -1.8782841
22230 op-snap---monthly-publication-october-2025.pdf   180 2025-10 Pedal Bike Kia Soul Blue Using a Mobile Phone Whilst Driving None Roman Way (Droitwich) Roman Way (Droitwich) Out of Force Area Out of Force Area NFA Out of Force      
22237 op-snap---monthly-publication-october-2025.pdf   187 2025-10 Pedal Bike BMW 320.. Black Driving without Due Care and Attention None Longford Road Longford Road Birmingham Birmingham Education N/A   52.5524121 -1.8764968
22271 op-snap---monthly-publication-october-2025.pdf   221 2025-10 Pedal Bike Daf Lorry white Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4144409 -1.5990259
22285 op-snap---monthly-publication-october-2025.pdf   235 2025-10 Pedal Bike Lexus ES300 Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5020639 -1.9026192
22286 op-snap---monthly-publication-october-2025.pdf   236 2025-10 Pedal Bike Nissan Qashqai Silver Driving without Due Care and Attention None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
22295 op-snap---monthly-publication-october-2025.pdf   245 2025-10 Pedal Bike Hyundai I20 Black Driving without Due Care and Attention None Brookvale Road Brookvale Road Birmingham Birmingham NFA No VRM   52.5219365 -1.8755325
22311 op-snap---monthly-publication-october-2025.pdf   261 2025-10 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Corporation Road Corporation Road Coventry Coventry Education N/A      
22312 op-snap---monthly-publication-october-2025.pdf   262 2025-10 Pedal Bike Mercedes-Benz Sprinter Yellow Contravening a Red Traffic Light No vehicle excise licence Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
22321 op-snap---monthly-publication-october-2025.pdf   271 2025-10 Pedal Bike Mini Cooper Blue Using a Mobile Phone Whilst Driving None Icknield Port Road Icknield Port Road Birmingham Birmingham NFA No Independent Evidence Available   52.4792334 -1.92925
22322 op-snap---monthly-publication-october-2025.pdf   272 2025-10 Pedal Bike     Black Misc - Non Traffic Offences None Earlsdon Avenue South Earlsdon Avenue South Coventry Coventry NFA No VRM   52.3960991 -1.5255671
22324 op-snap---monthly-publication-october-2025.pdf   274 2025-10 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham Education N/A   52.4580375 -1.9261777
22328 op-snap---monthly-publication-october-2025.pdf   278 2025-10 Pedal Bike Toyota   Black Driving without Due Care and Attention None 6 Ways 6 Ways Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4728311 -1.9185712
22336 op-snap---monthly-publication-october-2025.pdf   286 2025-10 Pedal Bike   Bus White Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull NFA No Offence   52.4144779 -1.7848758
22341 op-snap---monthly-publication-october-2025.pdf   291 2025-10 Pedal Bike Ford Focus Silver Using a Mobile Phone Whilst Driving None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham Fixed Penalty N/A   52.4580375 -1.9261777
22343 op-snap---monthly-publication-october-2025.pdf   293 2025-10 Pedal Bike Mini Cooper Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Sir Harrys Road Sir Harrys Road Birmingham Birmingham Fixed Penalty N/A   52.4587457 -1.9077277
22345 op-snap---monthly-publication-october-2025.pdf   295 2025-10 Pedal Bike Hyundai Ioniq White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
22346 op-snap---monthly-publication-october-2025.pdf   296 2025-10 Pedal Bike Peugeot 2008.. Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5359496 -1.8324115
22357 op-snap---monthly-publication-october-2025.pdf   307 2025-10 Pedal Bike Kia Niro White Driving without Due Care and Attention None Hales Street Hales Street Coventry Coventry Fixed Penalty N/A   52.4110271 -1.5074539
22360 op-snap---monthly-publication-october-2025.pdf   310 2025-10 Pedal Bike Peugeot Expert Silver Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
22371 op-snap---monthly-publication-october-2025.pdf   321 2025-10 Pedal Bike Vauxhall Mokka White Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
22373 op-snap---monthly-publication-october-2025.pdf   323 2025-10 Pedal Bike BMW M340 Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
22377 op-snap---monthly-publication-october-2025.pdf   327 2025-10 Pedal Bike Mercedes-Benz GLB Black Driving without Due Care and Attention None Constance Road, Edgbaston Constance Road, Edgbaston Birmingham Birmingham Education N/A   52.45815 -1.9008028
22385 op-snap---monthly-publication-october-2025.pdf   335 2025-10 Pedal Bike Kia Picanto Blue Driving without Due Care and Attention None Boleyn Road, Rubery Boleyn Road, Rubery Birmingham Birmingham NFA No Offence      
22386 op-snap---monthly-publication-october-2025.pdf   336 2025-10 Pedal Bike   Wrightbus Blue Driving without Due Care and Attention None Gannow Green Lane Gannow Green Lane Birmingham Birmingham NFA No Offence   52.4023845 -2.0336492
22393 op-snap---monthly-publication-october-2025.pdf   343 2025-10 Pedal Bike Fiat 500 Grey Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22399 op-snap---monthly-publication-october-2025.pdf   349 2025-10 Pedal Bike BMW 118.. Grey Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
22400 op-snap---monthly-publication-october-2025.pdf   350 2025-10 Pedal Bike BMW 335I Black Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Court N/A   52.4718503 -1.9195423
22402 op-snap---monthly-publication-october-2025.pdf   352 2025-10 Pedal Bike Toyota Aygo Green Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22405 op-snap---monthly-publication-october-2025.pdf   355 2025-10 Pedal Bike Ford Transit white Driving without Due Care and Attention None Clevedon Road Clevedon Road Birmingham Birmingham Education N/A   52.4618531 -1.894645
22408 op-snap---monthly-publication-october-2025.pdf   358 2025-10 Pedal Bike Toyota Yaris Blue Driving without Due Care and Attention None Cartland Road Cartland Road Birmingham Birmingham Education N/A   52.4298554 -1.9086629
22415 op-snap---monthly-publication-october-2025.pdf   365 2025-10 Pedal Bike Vauxhall Grandland White Driving without Due Care and Attention None A452 Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
22429 op-snap---monthly-publication-october-2025.pdf   379 2025-10 Pedal Bike Land Rover Range Rover Black Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
22430 op-snap---monthly-publication-october-2025.pdf   380 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Wychwood Avenue Wychwood Avenue Solihull Solihull NFA No Independent Evidence Available   52.3973125 -1.7370127
22431 op-snap---monthly-publication-october-2025.pdf   381 2025-10 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Balsall Street Balsall Street Solihull Solihull Education N/A   52.3826029 -1.6998649
22433 op-snap---monthly-publication-october-2025.pdf   383 2025-10 Pedal Bike Audi   grey Driving without Due Care and Attention None B4101 Balsall Street Balsall Street Birmingham Birmingham Warning Letter N/A   52.4579985 -1.8916996
22435 op-snap---monthly-publication-october-2025.pdf   385 2025-10 Pedal Bike Vauxhall Astra Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
22437 op-snap---monthly-publication-october-2025.pdf   387 2025-10 Pedal Bike Renault Master White Driving without Due Care and Attention None Wood Lane, Lower Stonnall Wood Lane, Lower Stonnall Out of Force Area Out of Force Area NFA Out of Force      
22443 op-snap---monthly-publication-october-2025.pdf   393 2025-10 Pedal Bike Ford Kuga Grey Using a Mobile Phone Whilst Driving None Bell GreenRoad Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
22444 op-snap---monthly-publication-october-2025.pdf   394 2025-10 Pedal Bike BMW 320d Silver Driving without Due Care and Attention None Coventry Road, Tamworth Coventry Road, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22447 op-snap---monthly-publication-october-2025.pdf   397 2025-10 Pedal Bike Volkswagen Polo Orange Driving without Due Care and Attention None Moseley Avenue Moseley Avenue Coventry Coventry Education N/A   52.417344 -1.5264979
22448 op-snap---monthly-publication-october-2025.pdf   398 2025-10 Pedal Bike Mini Mini Black Driving without Due Care and Attention None Four Pounds Avenue Four Pounds Avenue Coventry Coventry Warning Letter N/A   52.413228 -1.5323652
22449 op-snap---monthly-publication-october-2025.pdf   399 2025-10 Pedal Bike Renault Clio White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Offence   52.4047134 -1.5351834
22453 op-snap---monthly-publication-october-2025.pdf   403 2025-10 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Birmingham Birmingham Education N/A   52.4223176 -1.8253145
22472 op-snap---monthly-publication-october-2025.pdf   422 2025-10 Pedal Bike Audi A3 Black Using a Mobile Phone Whilst Driving None Three Shires Oak Road Three Shires Oak Road Birmingham Birmingham Fixed Penalty N/A      
22487 op-snap---monthly-publication-october-2025.pdf   437 2025-10 Pedal Bike Mercedes-Benz C220 Black Driving without Due Care and Attention None Mary Vale Road Mary Vale Road Birmingham Birmingham Warning Letter N/A   52.425105 -1.9312861
22490 op-snap---monthly-publication-october-2025.pdf   440 2025-10 Pedal Bike Toyota Yaris White Driver not in position to have Proper Control None Valentine Road Valentine Road Birmingham Birmingham Education N/A   52.4381959 -1.8907391
22502 op-snap---monthly-publication-october-2025.pdf   452 2025-10 Pedal Bike Toyota Aygo Black Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Warning Letter N/A   52.4398245 -1.8469786
22509 op-snap---monthly-publication-october-2025.pdf   459 2025-10 Pedal Bike   Subaru Blue Driving without Due Care and Attention None Holders Lane Holders Lane Birmingham Birmingham Education N/A   52.4446701 -1.9056872
22511 op-snap---monthly-publication-october-2025.pdf   461 2025-10 Pedal Bike Vauxhall Insignia Silver Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
22518 op-snap---monthly-publication-october-2025.pdf   468 2025-10 Pedal Bike Seat Alhambra Black Contravening a Red Traffic Light None A38 A38 Birmingham Birmingham NFA Outside of 14 Days NIP      
22519 op-snap---monthly-publication-october-2025.pdf   469 2025-10 Pedal Bike Seat Arona Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
22533 op-snap---monthly-publication-october-2025.pdf   483 2025-10 Pedal Bike Ford Fiesta Blue Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Fixed Penalty N/A   52.4398245 -1.8469786
22535 op-snap---monthly-publication-october-2025.pdf   485 2025-10 Pedal Bike Kia Sorento Grey Driving without Due Care and Attention None Maxstoke Road Maxstoke Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.547658 -1.8493169
22546 op-snap---monthly-publication-october-2025.pdf   496 2025-10 Pedal Bike Mercedes-Benz C220 Grey Driving without Due Care and Attention None Hales Street / White Street Hales Street / White Street Coventry Coventry NFA No Offence   52.4107158 -1.5078486
22573 op-snap---monthly-publication-october-2025.pdf   523 2025-10 Pedal Bike Vauxhall mokka Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22574 op-snap---monthly-publication-october-2025.pdf   524 2025-10 Pedal Bike Mercedes-Benz 250 Red Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22575 op-snap---monthly-publication-october-2025.pdf   525 2025-10 Pedal Bike Vauxhall Vivaro Blue Driving without Due Care and Attention None Wagon Lane Wagon Lane Birmingham Birmingham Education N/A   52.4546868 -1.793848
22585 op-snap---monthly-publication-october-2025.pdf   535 2025-10 Pedal Bike Mini Cooper Silver Using a Mobile Phone Whilst Driving None Norfolk Road Norfolk Road Birmingham Birmingham Fixed Penalty N/A   52.4672547 -1.9435381

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