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

112 rows where month = "2025-09" 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 8

offence 1

  • Using a Mobile Phone Whilst Driving · 112 ✖

month 1

  • 2025-09 · 112 ✖
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
23814 op-snap---monthly-publication-september-2025.pdf   33 2025-09 Pedal Bike Ford Fusion silver Using a Mobile Phone Whilst Driving None Barford Road to Coplow St Barford Road to Coplow Street Birmingham Birmingham Fixed Penalty N/A      
23828 op-snap---monthly-publication-september-2025.pdf   47 2025-09 Pedal Bike BMW X3.. Grey Using a Mobile Phone Whilst Driving None Burnaby Road Burnaby Road Coventry Coventry NFA No Independent Evidence Available   52.4352 -1.5194238
23829 op-snap---monthly-publication-september-2025.pdf   48 2025-09 Car Honda C-RV Grey Using a Mobile Phone Whilst Driving None Londonderry Road Londonderry Road Sandwell Sandwell Fixed Penalty N/A   52.4879743 -1.9926164
23833 op-snap---monthly-publication-september-2025.pdf   52 2025-09 Car Ford KA White Using a Mobile Phone Whilst Driving None Stockfield Road Stockfield Road Birmingham Birmingham Fixed Penalty N/A   52.4519414 -1.831688
23834 op-snap---monthly-publication-september-2025.pdf   53 2025-09 Car Ford Focus Black Using a Mobile Phone Whilst Driving None Sutherland Avenue Sutherland Avenue Sandwell Sandwell NFA No Independent Evidence Available      
23835 op-snap---monthly-publication-september-2025.pdf   54 2025-09 Pedal Bike Audi RS5 Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Court N/A   52.4221152 -1.4959475
23841 op-snap---monthly-publication-september-2025.pdf   60 2025-09 Car Ford Ranger White Using a Mobile Phone Whilst Driving None M25 (Surrey?) M25 (Surrey?) Out of Force Area Out of Force Area NFA Out of Force   52.5579918 -1.8904833
23849 op-snap---monthly-publication-september-2025.pdf   68 2025-09 Car Seat Leon Black Using a Mobile Phone Whilst Driving None Yardely Wood Road Yardely Wood Road Birmingham Birmingham Fixed Penalty N/A      
23867 op-snap---monthly-publication-september-2025.pdf   86 2025-09 Pedal Bike Land Rover Sport Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
23892 op-snap---monthly-publication-september-2025.pdf   111 2025-09 Car Peugeot 208.. Blue Using a Mobile Phone Whilst Driving None University Locks (Outside Co-Op) University Locks (Outside Co-Op) Birmingham Birmingham NFA No Independent Evidence Available      
23902 op-snap---monthly-publication-september-2025.pdf   121 2025-09 Car Mercedes-Benz CLS Silver Using a Mobile Phone Whilst Driving None Rickman Drive Rickman Drive Birmingham Birmingham NFA No Independent Evidence Available   52.4701606 -1.9013018
23904 op-snap---monthly-publication-september-2025.pdf   123 2025-09 Pedal Bike Porsche Panamera Black Using a Mobile Phone Whilst Driving None Park Hill Road Park Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
23906 op-snap---monthly-publication-september-2025.pdf   125 2025-09 Pedal Bike Renault Kangoo White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
23926 op-snap---monthly-publication-september-2025.pdf   145 2025-09 Car Toyota Yaris Black Using a Mobile Phone Whilst Driving None M6 M6 Birmingham Birmingham NFA No Offence      
23935 op-snap---monthly-publication-september-2025.pdf   154 2025-09 Car Vauxhall Astra Black Using a Mobile Phone Whilst Driving None M6 Motorway, Southbound M6 Motorway, Southbound Birmingham Birmingham Fixed Penalty N/A      
23937 op-snap---monthly-publication-september-2025.pdf   156 2025-09 Other Ford eTransit White Using a Mobile Phone Whilst Driving None Forest Close Forest Close Walsall Walsall NFA No Independent Evidence Available   52.5738095 -1.8904163
23951 op-snap---monthly-publication-september-2025.pdf   170 2025-09 Pedal Bike Ford Kuga Grey Using a Mobile Phone Whilst Driving None Pershore at Cartland Pershore at Cartland Birmingham Birmingham Fixed Penalty N/A   52.4244988 -1.9217197
23970 op-snap---monthly-publication-september-2025.pdf   189 2025-09 Pedal Bike Ford Focus Red Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
23989 op-snap---monthly-publication-september-2025.pdf   208 2025-09 Car   John Deere tractor Green Using a Mobile Phone Whilst Driving None A5 Royal Redgate Roundabout, Warwickshire Royal Redgate Roundabout, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
24016 op-snap---monthly-publication-september-2025.pdf   235 2025-09 Pedal Bike Ford Mustang E Red Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
24025 op-snap---monthly-publication-september-2025.pdf   244 2025-09 Car Vauxhall Combo Grey Using a Mobile Phone Whilst Driving None A491 Hagley Road, Stourbridge Hagley Road, Stourbridge Sandwell Sandwell Fixed Penalty N/A      
24038 op-snap---monthly-publication-september-2025.pdf   257 2025-09 Car Land Rover Defender Black Using a Mobile Phone Whilst Driving None M6?? M6?? Birmingham Birmingham NFA No Independent Evidence Available   52.5264754 -1.8895798
24039 op-snap---monthly-publication-september-2025.pdf   258 2025-09 Bus Ford C Max Red Using a Mobile Phone Whilst Driving None M6 Jct 1 M6 Junction 1 Out of Force Area Out of Force Area NFA Out of Force      
24041 op-snap---monthly-publication-september-2025.pdf   260 2025-09 Car Renault Clio Silver Using a Mobile Phone Whilst Driving None Walsingham Drive Walsingham Drive Out of Force Area Out of Force Area NFA Out of Force      
24051 op-snap---monthly-publication-september-2025.pdf   270 2025-09 Motorbike Ford Transit White Using a Mobile Phone Whilst Driving None Mucklow Hill Mucklow Hill Birmingham Birmingham Fixed Penalty N/A      
24073 op-snap---monthly-publication-september-2025.pdf   292 2025-09 Pedestrian Fiat Doblo White Using a Mobile Phone Whilst Driving None Allesley Old Road Allesley Old Road Coventry Coventry Fixed Penalty N/A   52.4103629 -1.5441218
24088 op-snap---monthly-publication-september-2025.pdf   307 2025-09 Car Peugeot 2008.. Grey Using a Mobile Phone Whilst Driving None Park Road at Parkes Hall Road Park Road at Parkes Hall Road Dudley Dudley Fixed Penalty N/A   52.4566333 -2.1646355
24096 op-snap---monthly-publication-september-2025.pdf   315 2025-09 Car Hyundai i20 Grey Using a Mobile Phone Whilst Driving None A45 Birmingham Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4796992 -1.9026911
24098 op-snap---monthly-publication-september-2025.pdf   317 2025-09 Car Ford Transit White Using a Mobile Phone Whilst Driving None High Street Bloxwich High Street Bloxwich Walsall Walsall NFA No Independent Evidence Available   52.6124215 -2.0022243
24099 op-snap---monthly-publication-september-2025.pdf   318 2025-09 Motorbike Mercedes-Benz EQA250 Grey Using a Mobile Phone Whilst Driving None Chawn Park Drive Chawn Park Drive Dudley Dudley Warning Letter N/A   52.4453636 -2.1319058
24117 op-snap---monthly-publication-september-2025.pdf   336 2025-09 Pedestrian Hyundai Tucson Black Using a Mobile Phone Whilst Driving None Raddlebarn Lane Raddlebarn Lane Birmingham Birmingham Warning Letter N/A   52.4372473 -1.939828
24120 op-snap---monthly-publication-september-2025.pdf   339 2025-09 Pedal Bike Ford Transit Blue Using a Mobile Phone Whilst Driving None Coundon Wedge Drive Coundon Wedge Drive Coventry Coventry Fixed Penalty N/A   52.4385402 -1.5483746
24132 op-snap---monthly-publication-september-2025.pdf   351 2025-09 Car Audi A4.. White Using a Mobile Phone Whilst Driving None Chester Road Brownhills Chester Road Brownhills Walsall Walsall Fixed Penalty N/A   52.6298869 -1.9079971
24148 op-snap---monthly-publication-september-2025.pdf   367 2025-09 Pedal Bike BMW   Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
24149 op-snap---monthly-publication-september-2025.pdf   368 2025-09 14695 Honda   Blue Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
24169 op-snap---monthly-publication-september-2025.pdf   388 2025-09 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Grovelly Lane Grovelly Lane Birmingham Birmingham Fixed Penalty N/A      
24173 op-snap---monthly-publication-september-2025.pdf   392 2025-09 Car Ford Transit Silver Using a Mobile Phone Whilst Driving None Grayswood Avenue Grayswood Avenue Coventry Coventry Fixed Penalty N/A   52.4174998 -1.5458389
24177 op-snap---monthly-publication-september-2025.pdf   396 2025-09 Pedestrian Nissan Micra Green Using a Mobile Phone Whilst Driving No Seat Belt Littleton Street West Littleton Street West Walsall Walsall Other Action Taken N/A   52.588379 -1.9843635
24178 op-snap---monthly-publication-september-2025.pdf   397 2025-09 Pedal Bike Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Chester Road, Stonnall Chester Road, Stonnall Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available      
24183 op-snap---monthly-publication-september-2025.pdf   402 2025-09 Pedal Bike Ford Fiesta Red Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
24206 op-snap---monthly-publication-september-2025.pdf   425 2025-09 Car Ford transit White Using a Mobile Phone Whilst Driving None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
24208 op-snap---monthly-publication-september-2025.pdf   427 2025-09 Car Man   White Using a Mobile Phone Whilst Driving None M6 Motorway M6 Motorway     NFA Misc Inc Crimes   52.5327447 -1.899844
24209 op-snap---monthly-publication-september-2025.pdf   428 2025-09 Car Toyota Yaris Grey Using a Mobile Phone Whilst Driving None Stafford Road Stafford Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.6291998 -2.126312
24219 op-snap---monthly-publication-september-2025.pdf   438 2025-09 Other   uk   Using a Mobile Phone Whilst Driving None UK Uk Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5019896 -2.0209184
24231 op-snap---monthly-publication-september-2025.pdf   450 2025-09 Car Toyota Prius White Using a Mobile Phone Whilst Driving None Bordesley Middleway Bordesley Middleway Birmingham Birmingham Fixed Penalty N/A   52.4704236 -1.8769606
24236 op-snap---monthly-publication-september-2025.pdf   455 2025-09 Car Mitsubishi Outlander Silver Using a Mobile Phone Whilst Driving None Evesham High Street Evesham High Street Out of Force Area Out of Force Area NFA Out of Force      
24248 op-snap---monthly-publication-september-2025.pdf   467 2025-09 Car Citroen C3 White Using a Mobile Phone Whilst Driving None Grange Road, Halesowen Grange Road, Halesowen Sandwell Sandwell NFA No Independent Evidence Available      
24252 op-snap---monthly-publication-september-2025.pdf   471 2025-09 Other BMW 3 Series Silver Using a Mobile Phone Whilst Driving None Unknown       NFA No Independent Evidence Available      
24253 op-snap---monthly-publication-september-2025.pdf   472 2025-09 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Temple Street Temple Street Wolverhampton Wolverhampton Fixed Penalty N/A   52.5630989 -2.0687582
24275 op-snap---monthly-publication-september-2025.pdf   494 2025-09 Car Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None M6 near to Stafford M6 near to Stafford Out of Force Area Out of Force Area NFA Out of Force      
24283 op-snap---monthly-publication-september-2025.pdf   502 2025-09 Pedestrian BMW 1 series Black Using a Mobile Phone Whilst Driving None Roundabout of Springfild Rd, Poplar Road, Kings Heath Roundabout of Springfild Road, Poplar Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A      
24284 op-snap---monthly-publication-september-2025.pdf   503 2025-09 Other Mercedes-Benz C220.. Silver Using a Mobile Phone Whilst Driving None Moncrieffe Street Moncrieffe Street Walsall Walsall NFA No Offence   52.5815341 -1.9691369
24286 op-snap---monthly-publication-september-2025.pdf   505 2025-09 Car Honda Civic Grey Using a Mobile Phone Whilst Driving None M5 Jct 4 M5 Junction 4 Out of Force Area Out of Force Area NFA Out of Force      
24291 op-snap---monthly-publication-september-2025.pdf   510 2025-09 Car Land Rover Freelander Black Using a Mobile Phone Whilst Driving None Brookside Avenue Brookside Avenue Coventry Coventry NFA No Independent Evidence Available   52.411064 -1.5578725
24301 op-snap---monthly-publication-september-2025.pdf   520 2025-09 Car Mercedes-Benz E200. Silver Using a Mobile Phone Whilst Driving None Cranmore Boulevard Cranmore Boulevard Birmingham Birmingham NFA No Independent Evidence Available      
24316 op-snap---monthly-publication-september-2025.pdf   535 2025-09 Car Peugeot 208 White Using a Mobile Phone Whilst Driving None Birmingham new Road Birmingham new Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
24325 op-snap---monthly-publication-september-2025.pdf   544 2025-09 Other Scania   White Using a Mobile Phone Whilst Driving None Brettell Lane Brettell Lane Dudley Dudley Warning Letter N/A   52.4706676 -2.1545486
24340 op-snap---monthly-publication-september-2025.pdf   559 2025-09 Pedal Bike Toyota   Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
24349 op-snap---monthly-publication-september-2025.pdf   568 2025-09 Pedal Bike Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry NFA No Independent Evidence Available   52.4324855 -1.4815548
24365 op-snap---monthly-publication-september-2025.pdf   584 2025-09 Car Ford Galaxy Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
24366 op-snap---monthly-publication-september-2025.pdf   585 2025-09 Other Audi A6 White Using a Mobile Phone Whilst Driving None Unknown       NFA No Offence      
24369 op-snap---monthly-publication-september-2025.pdf   588 2025-09 Other Ford Transit White Using a Mobile Phone Whilst Driving None Compton Close Compton Close Solihull Solihull Warning Letter N/A   52.4167285 -1.811636
24380 op-snap---monthly-publication-september-2025.pdf   599 2025-09 Pedal Bike Tesla model 3 Grey Using a Mobile Phone Whilst Driving None Augustus Road, Edgbaston Augustus Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
24385 op-snap---monthly-publication-september-2025.pdf   604 2025-09 Car Cupra Born Grey Using a Mobile Phone Whilst Driving None M5 Northbound milemarker 1.0 M5 Northbound milemarker 1.0 Sandwell Sandwell Fixed Penalty N/A      
24416 op-snap---monthly-publication-september-2025.pdf   635 2025-09 Car Land Rover Range Rover Grey Using a Mobile Phone Whilst Driving None Gate Street Gate Street Dudley Dudley NFA No Independent Evidence Available   52.5381741 -2.1180164
24423 op-snap---monthly-publication-september-2025.pdf   642 2025-09 Car Mercedes-Benz CLK220 Silver Using a Mobile Phone Whilst Driving None Hobs Moat Road Hobs Moat Road Birmingham Birmingham Fixed Penalty N/A   52.4515649 -1.7820482
24426 op-snap---monthly-publication-september-2025.pdf   645 2025-09 Pedal Bike Mercedes-Benz S350 Black Using a Mobile Phone Whilst Driving None Harborne Road, Edgbaston Harborne Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
24430 op-snap---monthly-publication-september-2025.pdf   649 2025-09 Other Audi   White Using a Mobile Phone Whilst Driving None M5 M5     NFA No VRM      
24433 op-snap---monthly-publication-september-2025.pdf   652 2025-09 Car Peugeot Boxer Green Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
24437 op-snap---monthly-publication-september-2025.pdf   656 2025-09 Car Suzuki Alto Silver Using a Mobile Phone Whilst Driving None Foxoak Street Foxoak Street Dudley Dudley NFA No Independent Evidence Available      
24447 op-snap---monthly-publication-september-2025.pdf   666 2025-09 Pedal Bike Volkswagen Transporter Black Using a Mobile Phone Whilst Driving None Newhall Street Newhall Street Birmingham Birmingham Fixed Penalty N/A   52.4830482 -1.905069
24448 op-snap---monthly-publication-september-2025.pdf   667 2025-09 Pedal Bike Isuzu Grafter White Using a Mobile Phone Whilst Driving None Silhill Hall Road Silhill Hall Road Solihull Solihull NFA No Independent Evidence Available   52.4201252 -1.7916238
24461 op-snap---monthly-publication-september-2025.pdf   680 2025-09 Car Peugeot 3008 Black Using a Mobile Phone Whilst Driving None Black Lake Black Lake Sandwell Sandwell NFA No Offence   52.5341947 -2.0098521
24473 op-snap---monthly-publication-september-2025.pdf   692 2025-09 Pedal Bike Skoda Kamiq Grey Using a Mobile Phone Whilst Driving None High St High Street Birmingham Birmingham Fixed Penalty N/A   52.5254588 -1.8373064
24487 op-snap---monthly-publication-september-2025.pdf   706 2025-09 Pedal Bike Mercedes-Benz CLA220 Silver Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
24489 op-snap---monthly-publication-september-2025.pdf   708 2025-09 Car Iveco HGV White Using a Mobile Phone Whilst Driving None M1 Southbound jn 40-41 M1 Southbound jn 40-41 Out of Force Area Out of Force Area NFA Out of Force      
24500 op-snap---monthly-publication-september-2025.pdf   719 2025-09 Pedestrian BMW 1 series White Using a Mobile Phone Whilst Driving None Vicarage Road, Kings Heath Vicarage Road, Kings Heath Birmingham Birmingham NFA No VRM   52.4301512 -1.8996659
24510 op-snap---monthly-publication-september-2025.pdf   729 2025-09 Pedal Bike Hyundai I10 Red Using a Mobile Phone Whilst Driving None Lynchgate Road Lynchgate Road Coventry Coventry Fixed Penalty N/A   52.3894664 -1.5558269
24544 op-snap---monthly-publication-september-2025.pdf   763 2025-09 Car Renault   White Using a Mobile Phone Whilst Driving None A47 A47     NFA No Independent Evidence Available      
24566 op-snap---monthly-publication-september-2025.pdf   785 2025-09 Car Suzuki Vitara Silver Using a Mobile Phone Whilst Driving None Norman Way Norman Way Out of Force Area Out of Force Area NFA Out of Force      
24567 op-snap---monthly-publication-september-2025.pdf   786 2025-09 Pedal Bike Land Rover Range Rover Grey Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
24568 op-snap---monthly-publication-september-2025.pdf   787 2025-09 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Cross Cheaping RA Cross Cheaping RA Coventry Coventry NFA No Independent Evidence Available      
24572 op-snap---monthly-publication-september-2025.pdf   791 2025-09 Pedestrian     White Using a Mobile Phone Whilst Driving None Baron Avenue, Kettering Baron Avenue, Kettering Out of Force Area Out of Force Area NFA Out of Force      
24575 op-snap---monthly-publication-september-2025.pdf   794 2025-09 Other Toyota Prius Black Using a Mobile Phone Whilst Driving None Newbold Road (Rugby) Warwickshire Newbold Road (Rugby) Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
24576 op-snap---monthly-publication-september-2025.pdf   795 2025-09 Pedestrian Land Rover   Black Using a Mobile Phone Whilst Driving None Walsall Road Walsall Road Walsall Walsall NFA No VRM   52.6166864 -1.9660822
24587 op-snap---monthly-publication-september-2025.pdf   806 2025-09 Car Volkswagen Golf White Using a Mobile Phone Whilst Driving None M5 North Bromsgrove (West Mercia) M5 North Bromsgrove (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
24600 op-snap---monthly-publication-september-2025.pdf   819 2025-09 Car Audi A5 Blue Using a Mobile Phone Whilst Driving None Dudley Road Dudley Road Birmingham Birmingham NFA No Offence   52.4865107 -1.9386263
24601 op-snap---monthly-publication-september-2025.pdf   820 2025-09 Car Audi   Grey Using a Mobile Phone Whilst Driving None Blackberry Lane Blackberry Lane Coventry Coventry Fixed Penalty N/A   52.4254016 -1.4665041
24605 op-snap---monthly-publication-september-2025.pdf   824 2025-09 Car Vauxhall Astra Silver Using a Mobile Phone Whilst Driving None Studland Road Studland Road Birmingham Birmingham Fixed Penalty N/A   52.434707 -1.8354573
24611 op-snap---monthly-publication-september-2025.pdf   830 2025-09 Pedestrian Toyota Corolla Grey Using a Mobile Phone Whilst Driving None Friston Avenue Friston Avenue Birmingham Birmingham Fixed Penalty N/A   52.4744592 -1.9198786
24613 op-snap---monthly-publication-september-2025.pdf   832 2025-09 Car BMW i4 Grey Using a Mobile Phone Whilst Driving None Wright Street, Halesowen Wright Street, Halesowen Halesowen Halesowen Fixed Penalty N/A   52.4514959 -2.0468797
24627 op-snap---monthly-publication-september-2025.pdf   846 2025-09 Car Mercedes-Benz E 350 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
24635 op-snap---monthly-publication-september-2025.pdf   854 2025-09 Car Ford Kuga Grey Using a Mobile Phone Whilst Driving None Stafford Road, Bloxwich Stafford Road, Bloxwich Walsall Walsall NFA No Independent Evidence Available   52.6329291 -2.0080068
24650 op-snap---monthly-publication-september-2025.pdf   869 2025-09 Pedal Bike Fiat 500 Red Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
24651 op-snap---monthly-publication-september-2025.pdf   870 2025-09 Pedal Bike Audi Q7 Black Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
24691 op-snap---monthly-publication-september-2025.pdf   910 2025-09 Other Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Arbury Road College in Nuneaton Arbury Road College in Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
24697 op-snap---monthly-publication-september-2025.pdf   916 2025-09 Car Mini Aceman Black Using a Mobile Phone Whilst Driving None New Road Rugeley New Road Rugeley Out of Force Area Out of Force Area NFA Out of Force      
24706 op-snap---monthly-publication-september-2025.pdf   925 2025-09 Car Skoda   Black Using a Mobile Phone Whilst Driving None Warwick Road Warwick Road Birmingham Birmingham NFA No Independent Evidence Available   52.4555288 -1.8613929
24733 op-snap---monthly-publication-september-2025.pdf   952 2025-09 Pedestrian Land Rover Sport Grey Using a Mobile Phone Whilst Driving None Widney Lane Widney Lane Solihull Solihull Fixed Penalty N/A   52.3975737 -1.7857722
24751 op-snap---monthly-publication-september-2025.pdf   970 2025-09 Pedestrian Ford Transit White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776

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