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

133 rows where disposal = "Fixed Penalty", month = "2025-02" and offence = "Using a Mobile Phone Whilst Driving" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw

reporter_transport_mode 5

offence 1

  • Using a Mobile Phone Whilst Driving · 133 ✖

month 1

  • 2025-02 · 133 ✖

disposal 1

  • Fixed Penalty · 133 ✖
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
5313 op-snap---monthly-publication-february-2025.pdf   130 2025-02 Car Mercedes-Benz G350 Black Using a Mobile Phone Whilst Driving None HIGH STREET, HARBORNE High Street, Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4612733 -1.9430543
5339 op-snap---monthly-publication-february-2025.pdf   156 2025-02 Pedal Bike Toyota Estima Grey Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5430 op-snap---monthly-publication-february-2025.pdf   247 2025-02 Pedal Bike Peugeot 3008 Grey Using a Mobile Phone Whilst Driving None Park Hill Rd Park Hill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4612518 -1.9515542
5433 op-snap---monthly-publication-february-2025.pdf   250 2025-02 Pedal Bike Audi RS E-tron Grey Using a Mobile Phone Whilst Driving None Park Hill Road, Harborne Park Hill Road, Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4612518 -1.9515542
5435 op-snap---monthly-publication-february-2025.pdf   252 2025-02 Pedal Bike Volkswagen T-Cross Grey Using a Mobile Phone Whilst Driving None Nursery Road, Harborne Nursery Road, Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.462096 -1.9436144
5436 op-snap---monthly-publication-february-2025.pdf   253 2025-02 Pedal Bike Mini Cooper Green Using a Mobile Phone Whilst Driving None Bristol Road, Edgbaston Bristol Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4561817 -1.9097774
5437 op-snap---monthly-publication-february-2025.pdf   254 2025-02 Pedal Bike Vauxhall Corsa White Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619
5439 op-snap---monthly-publication-february-2025.pdf   256 2025-02 Pedal Bike Land Rover Defender Black Using a Mobile Phone Whilst Driving No Insurance St Mary's Road, Harborne Street Mary's Road, Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5512 op-snap---monthly-publication-february-2025.pdf   329 2025-02 Pedal Bike Volkswagen T-Cross Blue Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5513 op-snap---monthly-publication-february-2025.pdf   330 2025-02 Pedal Bike Mini Cooper Blue Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5515 op-snap---monthly-publication-february-2025.pdf   332 2025-02 Pedestrian Honda CR-V Grey Using a Mobile Phone Whilst Driving None Upper Clifton Road Upper Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5664481 -1.8270564
5534 op-snap---monthly-publication-february-2025.pdf   351 2025-02 Pedestrian Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Clifton Roaf Clifton Roaf Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5535 op-snap---monthly-publication-february-2025.pdf   352 2025-02 Pedal Bike Vauxhall Adam White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
5537 op-snap---monthly-publication-february-2025.pdf   354 2025-02 Pedal Bike Mercedes-Benz CLA 200 White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
5539 op-snap---monthly-publication-february-2025.pdf   356 2025-02 Pedal Bike Ford Mustang Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4718503 -1.9195423
5559 op-snap---monthly-publication-february-2025.pdf   376 2025-02 Pedal Bike Mercedes-Benz A CLASS Black Using a Mobile Phone Whilst Driving None NEW FOSSE WAY New Fosse Way Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4473373 -1.9392405
5573 op-snap---monthly-publication-february-2025.pdf   390 2025-02 Pedestrian Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
5626 op-snap---monthly-publication-february-2025.pdf   443 2025-02 Car Vauxhall Astra Grey Using a Mobile Phone Whilst Driving None Bristol Road South Bristol Road South Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4119174 -1.9735247
5629 op-snap---monthly-publication-february-2025.pdf   446 2025-02 Pedal Bike Lexus NX300h Red Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4543565 -1.9114004
5630 op-snap---monthly-publication-february-2025.pdf   447 2025-02 Pedal Bike Porsche Boxter Silver Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4473373 -1.9392405
5631 op-snap---monthly-publication-february-2025.pdf   448 2025-02 Pedal Bike Toyota Proace White Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4612733 -1.9430543
5831 op-snap---monthly-publication-february-2025.pdf   648 2025-02 Pedestrian Mercedes-Benz E220d Blue Using a Mobile Phone Whilst Driving None Portland Road Portland Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4737014 -1.9412436
5849 op-snap---monthly-publication-february-2025.pdf   666 2025-02 Car Citroen Berlingo White Using a Mobile Phone Whilst Driving No vehicle excise licence A45 Coventry Road, Sheldon Coventry Road, Sheldon Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4516212 -1.7687473
5854 op-snap---monthly-publication-february-2025.pdf   671 2025-02 Car Mini cooper Yellow Using a Mobile Phone Whilst Driving None M5 J3 Birmingham M5 J3 Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4846642 -1.9297585
5863 op-snap---monthly-publication-february-2025.pdf   680 2025-02 Pedal Bike Mazda 3 Blue Using a Mobile Phone Whilst Driving None Park Hill Road Harbourne Park Hill Road Harbourne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5865 op-snap---monthly-publication-february-2025.pdf   682 2025-02 Pedal Bike Renault Clio Black Using a Mobile Phone Whilst Driving None Nursery Road Harbourne Nursery Road Harbourne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5867 op-snap---monthly-publication-february-2025.pdf   684 2025-02 Pedal Bike Jaguar I-Pace Black Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4718503 -1.9195423
5868 op-snap---monthly-publication-february-2025.pdf   685 2025-02 Pedal Bike Nissan Leaf Grey Using a Mobile Phone Whilst Driving No Insurance     Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5869 op-snap---monthly-publication-february-2025.pdf   686 2025-02 Pedal Bike Ford KA Red Using a Mobile Phone Whilst Driving None Nursery Road Harbourne Nursery Road Harbourne Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
5871 op-snap---monthly-publication-february-2025.pdf   688 2025-02 Pedestrian BMW 120d White Using a Mobile Phone Whilst Driving None Clifton Road Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
5875 op-snap---monthly-publication-february-2025.pdf   692 2025-02 Pedestrian Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Clifton Road Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
5887 op-snap---monthly-publication-february-2025.pdf   704 2025-02 Pedal Bike Toyota Corolla Silver Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5888 op-snap---monthly-publication-february-2025.pdf   705 2025-02 Pedal Bike Vauxhall Vivaro Grey Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5890 op-snap---monthly-publication-february-2025.pdf   707 2025-02 Pedal Bike Mg HS Grey Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5893 op-snap---monthly-publication-february-2025.pdf   710 2025-02 Pedal Bike Nissan Note Grey Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5894 op-snap---monthly-publication-february-2025.pdf   711 2025-02 Pedal Bike Honda Jazz Silver Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5897 op-snap---monthly-publication-february-2025.pdf   714 2025-02 Pedal Bike Toyota YARIS Silver Using a Mobile Phone Whilst Driving None WOODWAY LANE Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5900 op-snap---monthly-publication-february-2025.pdf   717 2025-02 Pedal Bike Kia PICANTO Red Using a Mobile Phone Whilst Driving None WOODWAY LANE Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
5901 op-snap---monthly-publication-february-2025.pdf   718 2025-02 Pedal Bike Kia NIRO Red Using a Mobile Phone Whilst Driving None CLIFFORD BRIDGE ROAD Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
5949 op-snap---monthly-publication-february-2025.pdf   766 2025-02 Car Toyota Hilux Grey Using a Mobile Phone Whilst Driving None Stourbridge Road, Dudley Stourbridge Road, Dudley Dudley Dudley Fixed Penalty N/A Yes - Via Email 52.5052291 -2.0972973
5956 op-snap---monthly-publication-february-2025.pdf   773 2025-02 Pedal Bike Nissan Micra White Using a Mobile Phone Whilst Driving None Woodway Lane, Coventry Woodway Lane, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.425388 -1.4441933
5958 op-snap---monthly-publication-february-2025.pdf   775 2025-02 Pedal Bike Tesla Model 3 White Using a Mobile Phone Whilst Driving None Augustus Road Birmingham Augustus Road Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
5964 op-snap---monthly-publication-february-2025.pdf   781 2025-02 Pedal Bike Land Rover   Black Using a Mobile Phone Whilst Driving None Clifford Bridge, Coventry Clifford Bridge, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
5988 op-snap---monthly-publication-february-2025.pdf   805 2025-02 Lorry Volkswagen ID4 Grey Using a Mobile Phone Whilst Driving None M42 S/B between jns 7A and 6 M42 Southbound between jns 7A and 6 Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6001 op-snap---monthly-publication-february-2025.pdf   818 2025-02 Pedal Bike Audi A1 Black Using a Mobile Phone Whilst Driving None Homer Road Solihull Homer Road Solihull Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5856224 -1.8167904
6005 op-snap---monthly-publication-february-2025.pdf   822 2025-02 Pedal Bike Mercedes-Benz GLA 200 White Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4718503 -1.9195423
6006 op-snap---monthly-publication-february-2025.pdf   823 2025-02 Pedestrian Volkswagen XC90 Grey Using a Mobile Phone Whilst Driving None Bell Green Road Coventry Bell Green Road Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4361538 -1.4756447
6008 op-snap---monthly-publication-february-2025.pdf   825 2025-02 Pedestrian Seat Arona White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
6011 op-snap---monthly-publication-february-2025.pdf   828 2025-02 Pedestrian Ford Transit Silver Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4324855 -1.4815548
6013 op-snap---monthly-publication-february-2025.pdf   830 2025-02 Pedal Bike Ford Focus Blue Using a Mobile Phone Whilst Driving None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4760986 -1.9018641
6015 op-snap---monthly-publication-february-2025.pdf   832 2025-02 Pedal Bike Audi A1 Blue Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619
6017 op-snap---monthly-publication-february-2025.pdf   834 2025-02 Pedal Bike Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Metchley Lane, Birmingham Metchley Lane, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4552055 -1.9461279
6018 op-snap---monthly-publication-february-2025.pdf   835 2025-02 Pedal Bike Volvo C40 Black Using a Mobile Phone Whilst Driving None Vivian Road, Birmingham Vivian Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4579568 -1.9510865
6019 op-snap---monthly-publication-february-2025.pdf   836 2025-02 Pedal Bike BMW I5 E Drive Blue Using a Mobile Phone Whilst Driving None Blackberry Lane Coventry Blackberry Lane Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4254016 -1.4665041
6022 op-snap---monthly-publication-february-2025.pdf   839 2025-02 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Far Gosford Street, Far Gosford Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4071231 -1.4985178
6024 op-snap---monthly-publication-february-2025.pdf   841 2025-02 Pedestrian Toyota Corolla Black Using a Mobile Phone Whilst Driving None B19 Towards Alum Rock Road Towards Alum Rock Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6048 op-snap---monthly-publication-february-2025.pdf   865 2025-02 Pedestrian Peugeot 2008 Grey Using a Mobile Phone Whilst Driving None Allesley Old Road Allesley Old Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4103629 -1.5441218
6059 op-snap---monthly-publication-february-2025.pdf   876 2025-02 Pedal Bike Land Rover Discovery 4 White Using a Mobile Phone Whilst Driving None Clifford Bridge Coventry Clifford Bridge Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6062 op-snap---monthly-publication-february-2025.pdf   879 2025-02 Pedal Bike Volkswagen Caddy White Using a Mobile Phone Whilst Driving None Clifford Bridge Coventry Clifford Bridge Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6065 op-snap---monthly-publication-february-2025.pdf   882 2025-02 Pedal Bike Ford Fiesta Black Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6066 op-snap---monthly-publication-february-2025.pdf   883 2025-02 Pedal Bike Seat Cupra Grey Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6067 op-snap---monthly-publication-february-2025.pdf   884 2025-02 Pedal Bike Toyota Yaris Black Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6068 op-snap---monthly-publication-february-2025.pdf   885 2025-02 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6070 op-snap---monthly-publication-february-2025.pdf   887 2025-02 Pedal Bike BMW M5 Blue Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4134557 -1.4442138
6072 op-snap---monthly-publication-february-2025.pdf   889 2025-02 Pedal Bike Land Rover Evoque White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
6078 op-snap---monthly-publication-february-2025.pdf   895 2025-02 Pedal Bike Audi Q8 E-Tron Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
6113 op-snap---monthly-publication-february-2025.pdf   930 2025-02 Pedal Bike Peugeot 208 Grey Using a Mobile Phone Whilst Driving None Harborne Park Road Harborne Park Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4511778 -1.9518939
6211 op-snap---monthly-publication-february-2025.pdf   1028 2025-02 Pedal Bike Ford TRANSIT White Using a Mobile Phone Whilst Driving None GLOUCESTER WAY Gloucester Way Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
6227 op-snap---monthly-publication-february-2025.pdf   1044 2025-02 Pedestrian Skoda Fabia Black Using a Mobile Phone Whilst Driving None Clifton Road, Sutton Coldfield Clifton Road, Sutton Coldfield Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.562277 -1.8308276
6229 op-snap---monthly-publication-february-2025.pdf   1046 2025-02 Pedestrian Skoda Roomster Red Using a Mobile Phone Whilst Driving None Clifton Road, Sutton Coldfield Clifton Road, Sutton Coldfield Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5636072 -1.8297629
6231 op-snap---monthly-publication-february-2025.pdf   1048 2025-02 Pedestrian Mini COOPER Silver Using a Mobile Phone Whilst Driving None DIGBY ROAD Digby Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5573003 -1.8317101
6232 op-snap---monthly-publication-february-2025.pdf   1049 2025-02 Pedestrian Vauxhall CORSA Black Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
6233 op-snap---monthly-publication-february-2025.pdf   1050 2025-02 Pedestrian Ford KUGA Black Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
6235 op-snap---monthly-publication-february-2025.pdf   1052 2025-02 Pedestrian Skoda OCTAVIA Blue Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
6236 op-snap---monthly-publication-february-2025.pdf   1053 2025-02 Pedestrian Mercedes-Benz 250 AMG Black Using a Mobile Phone Whilst Driving None Allesley Road Allesley Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.412663 -1.5443742
6241 op-snap---monthly-publication-february-2025.pdf   1058 2025-02 Pedal Bike Land Rover Velar Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4695793 -1.9378608
6243 op-snap---monthly-publication-february-2025.pdf   1060 2025-02 Pedal Bike Mazda cx5 Blue Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619
6244 op-snap---monthly-publication-february-2025.pdf   1061 2025-02 Pedal Bike BMW 118 Grey Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619
6329 op-snap---monthly-publication-february-2025.pdf   1146 2025-02 Pedestrian BMW 3 SERIES Silver Using a Mobile Phone Whilst Driving None C LIFTON ROAD C Lifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email    
6365 op-snap---monthly-publication-february-2025.pdf   1182 2025-02 Pedestrian Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Far Gosford Street Far Gosford Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4071231 -1.4985178
6393 op-snap---monthly-publication-february-2025.pdf   1210 2025-02 Pedestrian Citroen PURE Grey Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
6394 op-snap---monthly-publication-february-2025.pdf   1211 2025-02 Pedestrian Ford FIESTA Silver Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5609895 -1.8319819
6396 op-snap---monthly-publication-february-2025.pdf   1213 2025-02 Car Ford Transit White Using a Mobile Phone Whilst Driving None Lawley Middleway Birmingham Lawley Middleway Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4856388 -1.8823789
6425 op-snap---monthly-publication-february-2025.pdf   1242 2025-02 Pedestrian Mercedes-Benz GLE White Using a Mobile Phone Whilst Driving None Boldmere Road Boldmere Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.548309 -1.8411769
6436 op-snap---monthly-publication-february-2025.pdf   1253 2025-02 Car Ford Focus Black Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Dudley Road Dudley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4865107 -1.9386263
6494 op-snap---monthly-publication-february-2025.pdf   1311 2025-02 Pedal Bike Mercedes-Benz 220 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
6541 op-snap---monthly-publication-february-2025.pdf   1358 2025-02 Pedestrian Ford Fiesta Red Using a Mobile Phone Whilst Driving None Hinckley Road Hinckley Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.435502 -1.4327166
6555 op-snap---monthly-publication-february-2025.pdf   1372 2025-02 Pedal Bike Volkswagen T-Roc Blue Using a Mobile Phone Whilst Driving No Insurance Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4308271 -1.920078
6566 op-snap---monthly-publication-february-2025.pdf   1383 2025-02 Pedestrian Mazda 2 Orange Using a Mobile Phone Whilst Driving None CLIFTON ROAD Clifton Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4564397 -1.8838999
6574 op-snap---monthly-publication-february-2025.pdf   1391 2025-02 Pedestrian Land Rover Evoque Blue Using a Mobile Phone Whilst Driving None Clifton Road Clifton Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4564397 -1.8838999
6575 op-snap---monthly-publication-february-2025.pdf   1392 2025-02 Pedestrian Mitsubishi Colt Silver Using a Mobile Phone Whilst Driving None Clifton Road Clifton Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4564397 -1.8838999
6590 op-snap---monthly-publication-february-2025.pdf   1407 2025-02 Pedestrian Volkswagen Touran White Using a Mobile Phone Whilst Driving None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A Yes - Via Email 52.5361464 -1.8270283
6594 op-snap---monthly-publication-february-2025.pdf   1411 2025-02 Pedal Bike Ford fiesta Red Using a Mobile Phone Whilst Driving None Gooch Street Birmingham Gooch Street Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4671612 -1.8933216
6617 op-snap---monthly-publication-february-2025.pdf   1434 2025-02 Pedal Bike Ford Transit tipper White Using a Mobile Phone Whilst Driving None Engleton Road Engleton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4236807 -1.5231464
6627 op-snap---monthly-publication-february-2025.pdf   1444 2025-02 Pedal Bike Toyota C-HR White Using a Mobile Phone Whilst Driving None A4400 Great Charles Street Queensw Great Charles Street Queensw aByirmingham Abyirmingham Fixed Penalty N/A Yes - Via Email    
6662 op-snap---monthly-publication-february-2025.pdf   1479 2025-02 Car Peugeot Expert taxi Black Using a Mobile Phone Whilst Driving None A456 Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
6690 op-snap---monthly-publication-february-2025.pdf   1507 2025-02 Pedal Bike Citroen Berlingo Beige Using a Mobile Phone Whilst Driving None Bristol Street Birmingham Bristol Street Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4691145 -1.9003257
6727 op-snap---monthly-publication-february-2025.pdf   1544 2025-02 Car Audi A3 White Using a Mobile Phone Whilst Driving None Corporation Street Corporation Street Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4086244 -1.515132
6728 op-snap---monthly-publication-february-2025.pdf   1545 2025-02 Pedestrian Volkswagen T-ROC Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
6750 op-snap---monthly-publication-february-2025.pdf   1567 2025-02 Pedestrian Peugeot 3008 Grey Using a Mobile Phone Whilst Driving None Templar Avenue, Templar Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4004407 -1.5709058

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