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

122 rows where month = "2025-10", offence = "Driving without Due Care and Attention" 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 · 122 ✖

offence 1

  • Driving without Due Care and Attention · 122 ✖

month 1

  • 2025-10 · 122 ✖
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
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
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
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
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
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
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
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
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
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      
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
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
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
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      
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
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
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
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
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
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
22594 op-snap---monthly-publication-october-2025.pdf   544 2025-10 Pedal Bike Renault Trafic Grey Driving without Due Care and Attention None May Lane May Lane Birmingham Birmingham Education N/A   52.4197342 -1.8839613
22595 op-snap---monthly-publication-october-2025.pdf   545 2025-10 Pedal Bike Audi Q3 Silver Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
22596 op-snap---monthly-publication-october-2025.pdf   546 2025-10 Pedal Bike Toyota Prius Black Driving without Due Care and Attention None Church Road Church Road Birmingham Birmingham Education N/A   52.4624743 -1.7763934
22598 op-snap---monthly-publication-october-2025.pdf   548 2025-10 Pedal Bike Volkswagen Fox Black Driving without Due Care and Attention None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
22606 op-snap---monthly-publication-october-2025.pdf   556 2025-10 Pedal Bike Ford Transit White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham NFA No VRM   52.4708757 -1.8966158
22607 op-snap---monthly-publication-october-2025.pdf   557 2025-10 Pedal Bike Skoda   Grey Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham NFA No Independent Evidence Available   52.4436471 -1.9604594
22608 op-snap---monthly-publication-october-2025.pdf   558 2025-10 Pedal Bike Lamborghini Urus Orange Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
22609 op-snap---monthly-publication-october-2025.pdf   559 2025-10 Pedal Bike Kia Xceed Silver Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
22621 op-snap---monthly-publication-october-2025.pdf   571 2025-10 Pedal Bike Mercedes-Benz A35 Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22622 op-snap---monthly-publication-october-2025.pdf   572 2025-10 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Shorncliffe Road Shorncliffe Road Coventry Coventry NFA Outside of 14 Days NIP   52.4243896 -1.5433694
22623 op-snap---monthly-publication-october-2025.pdf   573 2025-10 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None West Hill Road West Hill Road Coventry Coventry Education N/A   52.3994858 -1.4923603
22627 op-snap---monthly-publication-october-2025.pdf   577 2025-10 Pedal Bike Mercedes-Benz C220 Silver Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5872149 -1.8300386
22637 op-snap---monthly-publication-october-2025.pdf   587 2025-10 Pedal Bike Toyota Auris Black Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
22645 op-snap---monthly-publication-october-2025.pdf   595 2025-10 Pedal Bike Renault Trafic Yellow Driving without Due Care and Attention None Main Road, Lower Quinton, near Stratford Main Road, Lower Quinton, near Stratford Out of Force Area Out of Force Area NFA Out of Force      
22654 op-snap---monthly-publication-october-2025.pdf   604 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bakers Lane Bakers Lane Birmingham Birmingham NFA No Offence   52.5632567 -1.8782299
22655 op-snap---monthly-publication-october-2025.pdf   605 2025-10 Pedal Bike Ford Transit White Driving without Due Care and Attention None Chester Road A452 Chester Road A452 Birmingham Birmingham NFA No Offence   52.5338529 -1.8296813
22668 op-snap---monthly-publication-october-2025.pdf   618 2025-10 Pedal Bike Skoda Octavia Black Driving without Due Care and Attention None St Agnes Road Street Agnes Road Birmingham Birmingham NFA No Independent Evidence Available      
22674 op-snap---monthly-publication-october-2025.pdf   624 2025-10 Pedal Bike Land Rover Land Rover Black Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
22677 op-snap---monthly-publication-october-2025.pdf   627 2025-10 Pedal Bike Nissan Qashqai Grey Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
22682 op-snap---monthly-publication-october-2025.pdf   632 2025-10 Pedal Bike Renault Capture Grey Driving without Due Care and Attention None Easemore Road Redditch Easemore Road Redditch Out of Force Area Out of Force Area NFA Out of Force      
22683 op-snap---monthly-publication-october-2025.pdf   633 2025-10 Pedal Bike Audi   Blue Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Court N/A   52.4221526 -1.8425617
22685 op-snap---monthly-publication-october-2025.pdf   635 2025-10 Pedal Bike Vauxhall Astra Black Driving without Due Care and Attention None Highfield Road Hall Green Highfield Road Hall Green Birmingham Birmingham Education N/A   52.4259801 -1.8449998
22687 op-snap---monthly-publication-october-2025.pdf   637 2025-10 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5359496 -1.8324115
22688 op-snap---monthly-publication-october-2025.pdf   638 2025-10 Pedal Bike Mercedes-Benz GLC 220 Silver Driving without Due Care and Attention None School Road Kings Heath School Road Kings Heath Birmingham Birmingham Warning Letter N/A   52.4384417 -1.8875299
22690 op-snap---monthly-publication-october-2025.pdf   640 2025-10 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22699 op-snap---monthly-publication-october-2025.pdf   649 2025-10 Pedal Bike Mazda 3 Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
22701 op-snap---monthly-publication-october-2025.pdf   651 2025-10 Pedal Bike Hyundai i20 Grey Driving without Due Care and Attention None Shard End Crescent Shard End Crescent Birmingham Birmingham Court N/A   52.4927744 -1.7781391
22713 op-snap---monthly-publication-october-2025.pdf   663 2025-10 Pedal Bike Volkswagen T-Roc Black Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
22714 op-snap---monthly-publication-october-2025.pdf   664 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield NFA No Offence      
22718 op-snap---monthly-publication-october-2025.pdf   668 2025-10 Pedal Bike Ford B-Max White Driving without Due Care and Attention None Leamington Road Leamington Road Coventry Coventry Education N/A   52.3921304 -1.5156601
22731 op-snap---monthly-publication-october-2025.pdf   681 2025-10 Pedal Bike Land Rover Range Rover White Driving without Due Care and Attention None Park Way Park Way Birmingham Birmingham Education N/A   52.3990593 -2.0053459
22750 op-snap---monthly-publication-october-2025.pdf   700 2025-10 Pedal Bike Audi A7 Black Driving without Due Care and Attention None Wednesfield Way Wednesfield Way Wolverhampton Wolverhampton Education N/A   52.59548 -2.0896906
22781 op-snap---monthly-publication-october-2025.pdf   731 2025-10 Pedal Bike BMW 218I Grey Driving without Due Care and Attention None Highlands Road Highlands Road Solihull Solihull Education N/A   52.3909869 -1.8032499
22787 op-snap---monthly-publication-october-2025.pdf   737 2025-10 Pedal Bike Volkswagen Caddy Grey Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
22810 op-snap---monthly-publication-october-2025.pdf   760 2025-10 Pedal Bike Mercedes-Benz Sprinter Black Driving without Due Care and Attention None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
22830 op-snap---monthly-publication-october-2025.pdf   780 2025-10 Pedal Bike Toyota Corolla Silver Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
22847 op-snap---monthly-publication-october-2025.pdf   797 2025-10 Pedal Bike Audi   Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22867 op-snap---monthly-publication-october-2025.pdf   817 2025-10 Pedal Bike Mini Mini Silver Driving without Due Care and Attention None A3400 Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
22868 op-snap---monthly-publication-october-2025.pdf   818 2025-10 Pedal Bike Mercedes-Benz C220d Silver Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
22897 op-snap---monthly-publication-october-2025.pdf   847 2025-10 Pedal Bike BMW X5 Blue Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
22903 op-snap---monthly-publication-october-2025.pdf   853 2025-10 Pedal Bike Ford S-Max White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
22904 op-snap---monthly-publication-october-2025.pdf   854 2025-10 Pedal Bike Mercedes-Benz A180.. Grey Driving without Due Care and Attention None High Street Harborne High Street Harborne Birmingham Birmingham Warning Letter N/A   52.4612733 -1.9430543
22905 op-snap---monthly-publication-october-2025.pdf   855 2025-10 Pedal Bike Ford Transit White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
22922 op-snap---monthly-publication-october-2025.pdf   872 2025-10 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None School Road School Road Solihull Solihull Warning Letter N/A   52.3517888 -1.7783232
22927 op-snap---monthly-publication-october-2025.pdf   877 2025-10 Pedal Bike Ford Custom Silver Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
22939 op-snap---monthly-publication-october-2025.pdf   889 2025-10 Pedal Bike BMW X2` Blue Driving without Due Care and Attention None St Nicholas St Street Nicholas Street Coventry Coventry Education N/A   52.4133001 -1.5126792
22944 op-snap---monthly-publication-october-2025.pdf   894 2025-10 Pedal Bike Hyundai I10 White Driving without Due Care and Attention None Walsall Road Walsall Road Sandwell Sandwell Education N/A   52.5439824 -1.9306805

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