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

137 rows where month = "2025-11" 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, nfa_rationale

reporter_transport_mode 7

disposal 3

offence 1

  • Using a Mobile Phone Whilst Driving · 137 ✖

month 1

  • 2025-11 · 137 ✖
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
20466 op-snap---monthly-publication-november-2025.pdf   8 2025-11 Car Renault   White Using a Mobile Phone Whilst Driving None M1 M1     NFA Out of Force      
20470 op-snap---monthly-publication-november-2025.pdf   12 2025-11 Pedal Bike   Taxi Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
20484 op-snap---monthly-publication-november-2025.pdf   26 2025-11 Car Toyota Yaris Black Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
20528 op-snap---monthly-publication-november-2025.pdf   70 2025-11 Pedal Bike BMW 320d White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
20529 op-snap---monthly-publication-november-2025.pdf   71 2025-11 Pedal Bike Peugeot 3008 Blue Using a Mobile Phone Whilst Driving none Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20530 op-snap---monthly-publication-november-2025.pdf   72 2025-11 Pedal Bike Land Rover Discovery Black Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
20533 op-snap---monthly-publication-november-2025.pdf   75 2025-11 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
20546 op-snap---monthly-publication-november-2025.pdf   88 2025-11 Pedal Bike Volkswagen Tiguan Grey Using a Mobile Phone Whilst Driving None Salisbury Road, Moseley Salisbury Road, Moseley Birmingham Birmingham Fixed Penalty N/A   52.4490203 -1.8955977
20547 op-snap---monthly-publication-november-2025.pdf   89 2025-11 Pedal Bike Volkswagen Tiguan White Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
20553 op-snap---monthly-publication-november-2025.pdf   95 2025-11 Car Volkswagen Amarok Black Using a Mobile Phone Whilst Driving None Watery Lane Middleway Watery Lane Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4752679 -1.8748608
20555 op-snap---monthly-publication-november-2025.pdf   97 2025-11 Car Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Belmont Row Belmont Row Birmingham Birmingham NFA No Independent Evidence Available   52.4840765 -1.8819479
20566 op-snap---monthly-publication-november-2025.pdf   108 2025-11 Pedestrian Dacia sandro Grey Using a Mobile Phone Whilst Driving None Shenley Lane Shenley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.430111 -1.9753703
20569 op-snap---monthly-publication-november-2025.pdf   111 2025-11 Car Honda   Silver Using a Mobile Phone Whilst Driving None M6 Toll NB M6 Toll Northbound Out of Force Area Out of Force Area NFA Out of Force      
20587 op-snap---monthly-publication-november-2025.pdf   129 2025-11 Pedal Bike Nissan Micra Blue Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
20590 op-snap---monthly-publication-november-2025.pdf   132 2025-11 Other Mercedes-Benz A180.. Silver Using a Mobile Phone Whilst Driving No Insurance Newton Road Newton Road Birmingham Birmingham Fixed Penalty N/A   52.4541102 -1.8710993
20592 op-snap---monthly-publication-november-2025.pdf   134 2025-11 Car Jeep Avenger   Using a Mobile Phone Whilst Driving None M40 J4 M40 J4 Out of Force Area Out of Force Area NFA Out of Force      
20605 op-snap---monthly-publication-november-2025.pdf   147 2025-11 Pedal Bike Seat Terraco Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
20606 op-snap---monthly-publication-november-2025.pdf   148 2025-11 Pedal Bike BMW X1 White Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
20618 op-snap---monthly-publication-november-2025.pdf   160 2025-11 Pedestrian Renault Megane Grey Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
20622 op-snap---monthly-publication-november-2025.pdf   164 2025-11 Other   Unknown   Using a Mobile Phone Whilst Driving None Unknown       NFA No VRM      
20642 op-snap---monthly-publication-november-2025.pdf   184 2025-11 Pedal Bike Dacia DUSTER Blue Using a Mobile Phone Whilst Driving None Far Gosfrod St Far Gosfrod Street Coventry Coventry Fixed Penalty N/A      
20654 op-snap---monthly-publication-november-2025.pdf   196 2025-11 Car   Dennis Bin lorry White Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
20657 op-snap---monthly-publication-november-2025.pdf   199 2025-11 Car Renault Trafic White Using a Mobile Phone Whilst Driving None Tomkinson Road Tomkinson Road Out of Force Area Out of Force Area NFA Out of Force      
20678 op-snap---monthly-publication-november-2025.pdf   220 2025-11 Car Ford Focus Black Using a Mobile Phone Whilst Driving None Bramah Way Tipton Bramah Way Tipton Sandwell Sandwell NFA No Independent Evidence Available   52.5315656 -2.0388495
20680 op-snap---monthly-publication-november-2025.pdf   222 2025-11 Pedal Bike Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
20682 op-snap---monthly-publication-november-2025.pdf   224 2025-11 Motorbike Fiat 500l White Using a Mobile Phone Whilst Driving None Mount Pleasant Mount Pleasant Dudley Dudley Fixed Penalty N/A   52.4734063 -2.1135639
20683 op-snap---monthly-publication-november-2025.pdf   225 2025-11 Pedestrian Nissan Note Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
20685 op-snap---monthly-publication-november-2025.pdf   227 2025-11 Pedal Bike Renault Clio Red Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20686 op-snap---monthly-publication-november-2025.pdf   228 2025-11 Pedal Bike Vauxhall Astra Blue Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20687 op-snap---monthly-publication-november-2025.pdf   229 2025-11 Pedal Bike Ford Fiesta Red Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
20688 op-snap---monthly-publication-november-2025.pdf   230 2025-11 Pedal Bike Kia Sportage White Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
20704 op-snap---monthly-publication-november-2025.pdf   246 2025-11 Pedal Bike Mercedes-Benz E250 Silver Using a Mobile Phone Whilst Driving None Far Gosford St Far Gosford Street Coventry Coventry Fixed Penalty N/A   52.4071231 -1.4985178
20713 op-snap---monthly-publication-november-2025.pdf   255 2025-11 Car Mercedes-Benz A Class White Using a Mobile Phone Whilst Driving None Sutton New Road Sutton New Road Birmingham Birmingham NFA No Independent Evidence Available   52.5260956 -1.8379401
20726 op-snap---monthly-publication-november-2025.pdf   268 2025-11 Pedal Bike Volkswagen Transporter Silver Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
20728 op-snap---monthly-publication-november-2025.pdf   270 2025-11 Pedal Bike BMW X3 Blue Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
20730 op-snap---monthly-publication-november-2025.pdf   272 2025-11 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
20738 op-snap---monthly-publication-november-2025.pdf   280 2025-11 Car Vauxhall Meriva Black Using a Mobile Phone Whilst Driving None Burley Road, Leeds Burley Road, Leeds Out of Force Area Out of Force Area NFA Out of Force      
20742 op-snap---monthly-publication-november-2025.pdf   284 2025-11 Pedal Bike Peugeot 208 Red Using a Mobile Phone Whilst Driving None Hebburn Hebburn Out of Force Area Out of Force Area NFA Out of Force      
20757 op-snap---monthly-publication-november-2025.pdf   299 2025-11 Pedal Bike BMW X1 Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
20758 op-snap---monthly-publication-november-2025.pdf   300 2025-11 Pedal Bike Audi Q3 Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20760 op-snap---monthly-publication-november-2025.pdf   302 2025-11 Motorbike BMW 320D Grey Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4591339 -1.9601054
20766 op-snap---monthly-publication-november-2025.pdf   308 2025-11 Pedal Bike Nissan X-Trail Black Using a Mobile Phone Whilst Driving None Longmore Street Longmore Street Birmingham Birmingham Fixed Penalty N/A   52.464484 -1.8923374
20767 op-snap---monthly-publication-november-2025.pdf   309 2025-11 Pedal Bike Suzuki Swift Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
20773 op-snap---monthly-publication-november-2025.pdf   315 2025-11 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving No vehicle excise licence Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20779 op-snap---monthly-publication-november-2025.pdf   321 2025-11 Car Hyundai I10 White Using a Mobile Phone Whilst Driving None Brass House Lane Brass House Lane Sandwell Sandwell Fixed Penalty N/A      
20785 op-snap---monthly-publication-november-2025.pdf   327 2025-11 Pedal Bike Land Rover Freelander Silver Using a Mobile Phone Whilst Driving None Black Haynes Road Black Haynes Road Birmingham Birmingham Fixed Penalty N/A   52.4260755 -1.9679443
20808 op-snap---monthly-publication-november-2025.pdf   350 2025-11 Car BMW 118D Black Using a Mobile Phone Whilst Driving None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
20818 op-snap---monthly-publication-november-2025.pdf   360 2025-11 Pedal Bike Fiat Punto Blue Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
20819 op-snap---monthly-publication-november-2025.pdf   361 2025-11 Pedal Bike Tesla Model Y Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
20821 op-snap---monthly-publication-november-2025.pdf   363 2025-11 Pedal Bike Citroen C3 Black Using a Mobile Phone Whilst Driving None Bristol Street Bristol Street Birmingham Birmingham Fixed Penalty N/A   52.4691145 -1.9003257
20822 op-snap---monthly-publication-november-2025.pdf   364 2025-11 Pedal Bike Lexus NX 300H Red Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Court N/A   52.4543565 -1.9114004
20823 op-snap---monthly-publication-november-2025.pdf   365 2025-11 Pedal Bike Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
20850 op-snap---monthly-publication-november-2025.pdf   392 2025-11 Other       Using a Mobile Phone Whilst Driving None UK Uk     NFA No Offence   52.5019896 -2.0209184
20852 op-snap---monthly-publication-november-2025.pdf   394 2025-11 Car   Genesis Black Using a Mobile Phone Whilst Driving None M1 Junction 18 M1 Junction 18 Out of Force Area Out of Force Area NFA Out of Force      
20857 op-snap---monthly-publication-november-2025.pdf   399 2025-11 Car Suzuki Ibiza Grey Using a Mobile Phone Whilst Driving None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA No Offence   52.4415108 -1.8971434
20967 op-snap---monthly-publication-november-2025.pdf   509 2025-11 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Springfield Road, Worcester Springfield Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
20982 op-snap---monthly-publication-november-2025.pdf   524 2025-11 Pedestrian Suzuki Celerio White Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
20983 op-snap---monthly-publication-november-2025.pdf   525 2025-11 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None Church Lane Church Lane Coventry Coventry Fixed Penalty N/A   52.4202618 -1.6010473
20986 op-snap---monthly-publication-november-2025.pdf   528 2025-11 Pedal Bike BMW 320.. Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
21004 op-snap---monthly-publication-november-2025.pdf   546 2025-11 Pedal Bike Fiat 500 Abarth Yellow Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
21006 op-snap---monthly-publication-november-2025.pdf   548 2025-11 Pedal Bike Volkswagen Golf Silver Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4943878 -1.8504211
21037 op-snap---monthly-publication-november-2025.pdf   579 2025-11 Car Mercedes-Benz   Black Using a Mobile Phone Whilst Driving None Brighton Road Brighton Road Out of Force Area Out of Force Area NFA Out of Force   52.4543156 -1.8840717
21053 op-snap---monthly-publication-november-2025.pdf   595 2025-11 Lorry   Subara Blue Using a Mobile Phone Whilst Driving None NJTP South, New Jersey, New York, USA NJTP South, New Jersey, New York, USA Out of Force Area Out of Force Area NFA Out of Force      
21057 op-snap---monthly-publication-november-2025.pdf   599 2025-11 Pedal Bike Tesla Model Y Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
21065 op-snap---monthly-publication-november-2025.pdf   607 2025-11 Car Mercedes-Benz EQE Black Using a Mobile Phone Whilst Driving None M1. M1 Out of Force Area Out of Force Area NFA Out of Force      
21080 op-snap---monthly-publication-november-2025.pdf   622 2025-11 Car Toyota Aygo White Using a Mobile Phone Whilst Driving None Birmingham Road Dudley Birmingham Road Dudley Dudley Dudley Fixed Penalty N/A   52.5130612 -2.0648903
21083 op-snap---monthly-publication-november-2025.pdf   625 2025-11 Pedal Bike Audi Q5 Silver Using a Mobile Phone Whilst Driving No Seat Belt Boleyn Road, Rubery Boleyn Road, Rubery Birmingham Birmingham Fixed Penalty N/A      
21109 op-snap---monthly-publication-november-2025.pdf   651 2025-11 Pedal Bike Peugeot 308.. Blue Using a Mobile Phone Whilst Driving None Tile Hill Lane Tile Hill Lane Coventry Coventry Fixed Penalty N/A   52.4041117 -1.5595662
21110 op-snap---monthly-publication-november-2025.pdf   652 2025-11 Pedal Bike Mercedes-Benz C220.. White Using a Mobile Phone Whilst Driving None A45 at Sir Henry Parkes Drive A45 at Sir Henry Parkes Drive Coventry Coventry Fixed Penalty N/A      
21111 op-snap---monthly-publication-november-2025.pdf   653 2025-11 Pedal Bike Fiat Ducato Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
21112 op-snap---monthly-publication-november-2025.pdf   654 2025-11 Pedal Bike BMW 520D Black Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
21269 op-snap---monthly-publication-november-2025.pdf   811 2025-11 Car Peugeot Bipper White Using a Mobile Phone Whilst Driving None Cinder Road Cinder Road Dudley Dudley Fixed Penalty N/A   52.5128626 -2.1348738
21316 op-snap---monthly-publication-november-2025.pdf   858 2025-11 Motorbike Hyundai   Black Using a Mobile Phone Whilst Driving None Queensway Island Queensway Island Out of Force Area Out of Force Area NFA Out of Force      
21364 op-snap---monthly-publication-november-2025.pdf   906 2025-11 Other Ford Transit Silver Using a Mobile Phone Whilst Driving None Beaconside Stafford Beaconside Stafford Out of Force Area Out of Force Area NFA Out of Force      
21366 op-snap---monthly-publication-november-2025.pdf   908 2025-11 Other Nissan Qashqai Purple Using a Mobile Phone Whilst Driving None Southgate, Cradley Heath Southgate, Cradley Heath Sandwell Sandwell NFA Not in Public Interest   52.4705111 -2.0807857
21369 op-snap---monthly-publication-november-2025.pdf   911 2025-11 Pedal Bike Nissan Qashqai Silver Using a Mobile Phone Whilst Driving None Hinckley Road Hinckley Road Coventry Coventry Fixed Penalty N/A   52.435502 -1.4327166
21382 op-snap---monthly-publication-november-2025.pdf   924 2025-11 Pedal Bike Volkswagen ID4 Red Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A   52.4134557 -1.4442138
21384 op-snap---monthly-publication-november-2025.pdf   926 2025-11 Pedal Bike Renault Megane Black Using a Mobile Phone Whilst Driving None Hinckley Road Hinckley Road Coventry Coventry Fixed Penalty N/A   52.435502 -1.4327166
21385 op-snap---monthly-publication-november-2025.pdf   927 2025-11 Pedal Bike BMW 218D Grey Using a Mobile Phone Whilst Driving None Moseley Av Cov Moseley Avenue Cov Coventry Coventry Fixed Penalty N/A   52.417344 -1.5264979
21410 op-snap---monthly-publication-november-2025.pdf   952 2025-11 Motorbike Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Court Oak Road Court Oak Road Birmingham Birmingham NFA No Independent Evidence Available   52.4604383 -1.9760104
21468 op-snap---monthly-publication-november-2025.pdf   1010 2025-11 Pedal Bike Ford Ranger Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
21469 op-snap---monthly-publication-november-2025.pdf   1011 2025-11 Other Volkswagen Polo Silver Using a Mobile Phone Whilst Driving None Dawlish Road Dawlish Road Birmingham Birmingham Fixed Penalty N/A   52.4438979 -1.9316285
21487 op-snap---monthly-publication-november-2025.pdf   1029 2025-11 Car Mitsubishi L200 White Using a Mobile Phone Whilst Driving None Hereford City Centre Hereford City Centre Out of Force Area Out of Force Area NFA Out of Force      
21505 op-snap---monthly-publication-november-2025.pdf   1047 2025-11 Pedal Bike Mercedes-Benz E220 White Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
21506 op-snap---monthly-publication-november-2025.pdf   1048 2025-11 Pedal Bike Citroen Relay White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
21510 op-snap---monthly-publication-november-2025.pdf   1052 2025-11 Pedal Bike Nissan Juke Black Using a Mobile Phone Whilst Driving None Earlsdon Avenue North Earlsdon Avenue North Coventry Coventry Fixed Penalty N/A   52.4025196 -1.5327802
21511 op-snap---monthly-publication-november-2025.pdf   1053 2025-11 Car Land Rover Range Grey Using a Mobile Phone Whilst Driving None Highgate Road Highgate Road Birmingham Birmingham NFA No Independent Evidence Available   52.4606652 -1.8791145
21515 op-snap---monthly-publication-november-2025.pdf   1057 2025-11 Pedal Bike Audi Q5 Black Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
21524 op-snap---monthly-publication-november-2025.pdf   1066 2025-11 Car Mercedes-Benz B Class Black Using a Mobile Phone Whilst Driving None Holliday Street Holliday Street Birmingham Birmingham Fixed Penalty N/A   52.4780205 -1.9047506
21525 op-snap---monthly-publication-november-2025.pdf   1067 2025-11 Car Vauxhall Mokka Blue Using a Mobile Phone Whilst Driving None Stephson Street Stephson Street Walsall Walsall NFA No Independent Evidence Available      
21547 op-snap---monthly-publication-november-2025.pdf   1089 2025-11 Car Toyota Yaris Silver Using a Mobile Phone Whilst Driving None Broadway Broadway Walsall Walsall Fixed Penalty N/A   52.5719937 -1.9639882
21552 op-snap---monthly-publication-november-2025.pdf   1094 2025-11 Pedestrian Toyota Aygo White Using a Mobile Phone Whilst Driving None Hagley Road, Birmingham Hagley Road, Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4720702 -1.9367526
21557 op-snap---monthly-publication-november-2025.pdf   1099 2025-11 Car Maxus E Deliver White Using a Mobile Phone Whilst Driving None Park Lane Park Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4986532 -1.8873443
21565 op-snap---monthly-publication-november-2025.pdf   1107 2025-11 Pedestrian Audi A1 Black Using a Mobile Phone Whilst Driving None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A   52.4720132 -1.9142946
21566 op-snap---monthly-publication-november-2025.pdf   1108 2025-11 Pedestrian Kia Sportage Blue Using a Mobile Phone Whilst Driving None Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A   52.4096725 -1.487901
21579 op-snap---monthly-publication-november-2025.pdf   1121 2025-11 Pedestrian Volkswagen ID4 Grey Using a Mobile Phone Whilst Driving None Heaton Road, Solihull Heaton Road, Solihull Solihull Solihull Fixed Penalty N/A   52.4284827 -1.7951002
21583 op-snap---monthly-publication-november-2025.pdf   1125 2025-11 Car Kia Sportage White Using a Mobile Phone Whilst Driving None Suffolk Street Suffolk Street Birmingham Birmingham NFA No Independent Evidence Available   52.4749336 -1.9003475
21586 op-snap---monthly-publication-november-2025.pdf   1128 2025-11 Pedestrian Nissan Micra Silver Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham Fixed Penalty N/A   52.4298554 -1.9086629
21610 op-snap---monthly-publication-november-2025.pdf   1152 2025-11 Other Ford Kuga Blue Using a Mobile Phone Whilst Driving None Brentwood Av Brentwood Avenue Coventry Coventry NFA No Independent Evidence Available   52.3747077 -1.5106466
21636 op-snap---monthly-publication-november-2025.pdf   1178 2025-11 Car Volvo XC90 White Using a Mobile Phone Whilst Driving None A43 A43 Out of Force Area Out of Force Area NFA Out of Force      

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