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

123 rows where month = "2025-12" 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 4

offence 1

  • Using a Mobile Phone Whilst Driving · 123 ✖

month 1

  • 2025-12 · 123 ✖
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
3890 op-snap---monthly-publication-december-2025.pdf   18 2025-12 Pedestrian Tesla Model Y White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
3893 op-snap---monthly-publication-december-2025.pdf   21 2025-12 Car Ford puma Grey Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham Fixed Penalty N/A   52.4422505 -1.8539684
3909 op-snap---monthly-publication-december-2025.pdf   37 2025-12 Car Mercedes-Benz Benz White Using a Mobile Phone Whilst Driving None Alcester Street Alcester Street Birmingham Birmingham NFA No Independent Evidence Available   52.4696096 -1.8871873
3911 op-snap---monthly-publication-december-2025.pdf   39 2025-12 Car Renault Twingo Red Using a Mobile Phone Whilst Driving None Bloomfield Road Bloomfield Road Birmingham Birmingham NFA No Offence   52.4480767 -1.8755275
3912 op-snap---monthly-publication-december-2025.pdf   40 2025-12 Pedal Bike Audi TT Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
3921 op-snap---monthly-publication-december-2025.pdf   49 2025-12 Car Porsche Cayenne Black Using a Mobile Phone Whilst Driving None Kingstanding Road Kingstanding Road Birmingham Birmingham Fixed Penalty N/A   52.5521118 -1.8845138
3980 op-snap---monthly-publication-december-2025.pdf   108 2025-12 Car Ford C Maxx Black Using a Mobile Phone Whilst Driving None Ansty Road Ansty Road Coventry Coventry Fixed Penalty N/A   52.4205675 -1.4520187
3984 op-snap---monthly-publication-december-2025.pdf   112 2025-12 Pedal Bike Kia Venga Silver Using a Mobile Phone Whilst Driving None Stratford Road towards Shirley Stratford Road towards Shirley Birmingham Birmingham Fixed Penalty N/A      
3986 op-snap---monthly-publication-december-2025.pdf   114 2025-12 Pedestrian Mini Clubman Red Using a Mobile Phone Whilst Driving None Plough and Harrow Rd twds Hagle Plough and Harrow Road twds Hagle yB Riromaidngham Yb Riromaidngham Fixed Penalty N/A   52.5287826 -1.7759635
3988 op-snap---monthly-publication-december-2025.pdf   116 2025-12 Pedal Bike Mercedes-Benz A35 Blue Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
3999 op-snap---monthly-publication-december-2025.pdf   127 2025-12 Car   Bentley Grey Using a Mobile Phone Whilst Driving None M42 West Mercia M42 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4004 op-snap---monthly-publication-december-2025.pdf   132 2025-12 Car Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Coles Hill Road Coles Hill Road Birmingham Birmingham NFA No Independent Evidence Available      
4010 op-snap---monthly-publication-december-2025.pdf   138 2025-12 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4012 op-snap---monthly-publication-december-2025.pdf   140 2025-12 Pedal Bike Peugeot 208 Orange Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4015 op-snap---monthly-publication-december-2025.pdf   143 2025-12 Pedal Bike Mini Clubman White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4016 op-snap---monthly-publication-december-2025.pdf   144 2025-12 Pedal Bike BMW i4 Green Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4025 op-snap---monthly-publication-december-2025.pdf   153 2025-12 Car Hyundai Amica black Using a Mobile Phone Whilst Driving None M6 Junction 9 M6 Junction 9 Walsall Walsall Fixed Penalty N/A   52.676119 -2.0858425
4043 op-snap---monthly-publication-december-2025.pdf   171 2025-12 Car Ford   White Using a Mobile Phone Whilst Driving None Leamington Road Leamington Road Coventry Coventry NFA No Independent Evidence Available   52.3921304 -1.5156601
4044 op-snap---monthly-publication-december-2025.pdf   172 2025-12 Pedal Bike Jaguar F Pace Blue Using a Mobile Phone Whilst Driving None Park Hill Road Park Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
4045 op-snap---monthly-publication-december-2025.pdf   173 2025-12 Pedal Bike Mercedes-Benz CLA 250 Black Using a Mobile Phone Whilst Driving None Navigation Street Navigation Street Birmingham Birmingham Fixed Penalty N/A   52.4781877 -1.9011642
4047 op-snap---monthly-publication-december-2025.pdf   175 2025-12 Pedal Bike Renault Clio Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4049 op-snap---monthly-publication-december-2025.pdf   177 2025-12 Pedal Bike Renault   Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4050 op-snap---monthly-publication-december-2025.pdf   178 2025-12 Pedal Bike Nissan Qashqai Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4051 op-snap---monthly-publication-december-2025.pdf   179 2025-12 Pedal Bike Audi Q8 Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4055 op-snap---monthly-publication-december-2025.pdf   183 2025-12 Pedestrian Ford   Yellow Using a Mobile Phone Whilst Driving None Mallards Close Mallards Close Out of Force Area Out of Force Area NFA Out of Force      
4059 op-snap---monthly-publication-december-2025.pdf   187 2025-12 Car Vauxhall Vivaro Grey Using a Mobile Phone Whilst Driving None M1 / M45 Watford Gap M1 / M45 Watford Gap Out of Force Area Out of Force Area NFA Out of Force      
4071 op-snap---monthly-publication-december-2025.pdf   199 2025-12 Car Hyundai i20 Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4072 op-snap---monthly-publication-december-2025.pdf   200 2025-12 Car Mercedes-Benz 220 Black Using a Mobile Phone Whilst Driving None Harbourne High Street Harbourne High Street Birmingham Birmingham Fixed Penalty N/A      
4154 op-snap---monthly-publication-december-2025.pdf   282 2025-12 Pedal Bike BMW X5.. Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4156 op-snap---monthly-publication-december-2025.pdf   284 2025-12 Pedal Bike Vauxhall Mokka Black Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4162 op-snap---monthly-publication-december-2025.pdf   290 2025-12 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4163 op-snap---monthly-publication-december-2025.pdf   291 2025-12 Pedal Bike Nissan Juke Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4166 op-snap---monthly-publication-december-2025.pdf   294 2025-12 Car Seat Ibiza Blue Using a Mobile Phone Whilst Driving None A45 B'ham airport A45 B'ham airport Solihull Solihull NFA No Independent Evidence Available      
4176 op-snap---monthly-publication-december-2025.pdf   304 2025-12 Car Renault Master White Using a Mobile Phone Whilst Driving None Pale Street Upper Gornal Pale Street Upper Gornal Dudley Dudley Fixed Penalty N/A   52.525959 -2.1142205
4187 op-snap---monthly-publication-december-2025.pdf   315 2025-12 Other Land Rover SE Black Using a Mobile Phone Whilst Driving Use vehicle on a road withou tB viramlidin tgehsat mcertificate t B viramlidin tgehsat mcertificate Birmingham Birmingham NFA No Independent Evidence Available      
4192 op-snap---monthly-publication-december-2025.pdf   320 2025-12 Other Daf Lorry Black Using a Mobile Phone Whilst Driving No Insurance Motorway unknown Motorway unknown Out of Force Area Out of Force Area NFA No Independent Evidence Available      
4194 op-snap---monthly-publication-december-2025.pdf   322 2025-12 Pedal Bike BMW 520D Black Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham NFA No Independent Evidence Available   52.4422505 -1.8539684
4196 op-snap---monthly-publication-december-2025.pdf   324 2025-12 Pedal Bike Mercedes-Benz Splinter White Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4265 op-snap---monthly-publication-december-2025.pdf   393 2025-12 Car Renault G-ESPACE Grey Using a Mobile Phone Whilst Driving None Alder Drive Alder Drive Solihull Solihull Fixed Penalty N/A   52.4752281 -1.7368602
4281 op-snap---monthly-publication-december-2025.pdf   409 2025-12 Pedal Bike Porsche 911.. White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4282 op-snap---monthly-publication-december-2025.pdf   410 2025-12 Pedal Bike Seat Arona Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4283 op-snap---monthly-publication-december-2025.pdf   411 2025-12 Pedal Bike Mercedes-Benz CLA White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4284 op-snap---monthly-publication-december-2025.pdf   412 2025-12 Pedal Bike Hyundai Kona Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4288 op-snap---monthly-publication-december-2025.pdf   416 2025-12 Pedal Bike Renault Megane Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
4289 op-snap---monthly-publication-december-2025.pdf   417 2025-12 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry Fixed Penalty N/A   52.4070602 -1.4732469
4292 op-snap---monthly-publication-december-2025.pdf   420 2025-12 Pedal Bike Citroen C3 Black Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
4301 op-snap---monthly-publication-december-2025.pdf   429 2025-12 Pedal Bike BMW 5 series Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
4304 op-snap---monthly-publication-december-2025.pdf   432 2025-12 Pedal Bike Audi A1.. Grey Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
4314 op-snap---monthly-publication-december-2025.pdf   442 2025-12 Car Mini Countryman Black Using a Mobile Phone Whilst Driving None Bath Road Bath Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.5862527 -2.1378802
4326 op-snap---monthly-publication-december-2025.pdf   454 2025-12 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None M6 Motorway M6 Motorway Birmingham Birmingham Fixed Penalty N/A   52.5327447 -1.899844
4341 op-snap---monthly-publication-december-2025.pdf   469 2025-12 Pedal Bike Toyota Prius Black Using a Mobile Phone Whilst Driving None Bradford Street Bradford Street Birmingham Birmingham NFA No Offence   52.4708802 -1.8792135
4344 op-snap---monthly-publication-december-2025.pdf   472 2025-12 Pedestrian Toyota Prius white Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4345 op-snap---monthly-publication-december-2025.pdf   473 2025-12 Pedal Bike   Bentley Blue Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4346 op-snap---monthly-publication-december-2025.pdf   474 2025-12 Pedestrian Peugeot 2008 Black Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4347 op-snap---monthly-publication-december-2025.pdf   475 2025-12 Pedal Bike Mercedes-Benz A180.. Black Using a Mobile Phone Whilst Driving None Metchley Lane Harborne Metchley Lane Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4350 op-snap---monthly-publication-december-2025.pdf   478 2025-12 Pedal Bike Volkswagen Tiguan Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4352 op-snap---monthly-publication-december-2025.pdf   480 2025-12 Pedal Bike Porsche Taycan Grey Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4353 op-snap---monthly-publication-december-2025.pdf   481 2025-12 Pedal Bike Skoda Octavia Beige Using a Mobile Phone Whilst Driving None Aston Webb Blvd, Selly Oak Aston Webb Boulevard, Selly Oak Birmingham Birmingham Fixed Penalty N/A   52.4443904 -1.9419231
4354 op-snap---monthly-publication-december-2025.pdf   482 2025-12 Pedal Bike Audi E tron Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4356 op-snap---monthly-publication-december-2025.pdf   484 2025-12 Pedal Bike BMW 120d Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4357 op-snap---monthly-publication-december-2025.pdf   485 2025-12 Pedal Bike Volkswagen Caddy Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4358 op-snap---monthly-publication-december-2025.pdf   486 2025-12 Pedal Bike Skoda Kamiq Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4359 op-snap---monthly-publication-december-2025.pdf   487 2025-12 Pedal Bike Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
4360 op-snap---monthly-publication-december-2025.pdf   488 2025-12 Pedal Bike Mercedes-Benz E350 Blue Using a Mobile Phone Whilst Driving None     Birmingham Birmingham NFA No Independent Evidence Available      
4374 op-snap---monthly-publication-december-2025.pdf   502 2025-12 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4375 op-snap---monthly-publication-december-2025.pdf   503 2025-12 Pedal Bike Kia Ceed Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4389 op-snap---monthly-publication-december-2025.pdf   517 2025-12 Pedestrian Mini Cooper Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
4393 op-snap---monthly-publication-december-2025.pdf   521 2025-12 Car Citroen Berlingo Blue Using a Mobile Phone Whilst Driving None Cooks Lane Cooks Lane Birmingham Birmingham Fixed Penalty N/A   52.482758 -1.7603097
4404 op-snap---monthly-publication-december-2025.pdf   532 2025-12 Car Volkswagen Crafter Blue Using a Mobile Phone Whilst Driving none Eddish Road, Kitts Green Eddish Road, Kitts Green Birmingham Birmingham Fixed Penalty N/A   52.4833672 -1.7871439
4412 op-snap---monthly-publication-december-2025.pdf   540 2025-12 Car Honda CR-V Black Using a Mobile Phone Whilst Driving No Insurance Battlefield Road Battlefield Road Out of Force Area Out of Force Area NFA Out of Force      
4418 op-snap---monthly-publication-december-2025.pdf   546 2025-12 Pedal Bike Peugeot 3008.. Blue Using a Mobile Phone Whilst Driving None Sky Blue Way Sky Blue Way Coventry Coventry Fixed Penalty N/A   52.4085943 -1.4943275
4425 op-snap---monthly-publication-december-2025.pdf   553 2025-12 Car Ford Ranger Black Using a Mobile Phone Whilst Driving None Stratford Road near Union Road, S Stratford Road near Union Road, S hBiirrlmeyingham Hbiirrlmeyingham Fixed Penalty N/A   52.4532265 -1.8659356
4428 op-snap---monthly-publication-december-2025.pdf   556 2025-12 Pedal Bike BMW X3 Black Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
4537 op-snap---monthly-publication-december-2025.pdf   665 2025-12 Other BMW X3.. White Using a Mobile Phone Whilst Driving None Leamington Spa.. No other details Leamington Spa No other details .Birmingham .Birmingham NFA No Independent Evidence Available      
4550 op-snap---monthly-publication-december-2025.pdf   678 2025-12 Pedal Bike Mercedes-Benz SL400 Black Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
4553 op-snap---monthly-publication-december-2025.pdf   681 2025-12 Other BMW X1 Grey Using a Mobile Phone Whilst Driving None B4124 ROcky Lane B4124 ROcky Lane Birmingham Birmingham NFA No Independent Evidence Available      
4554 op-snap---monthly-publication-december-2025.pdf   682 2025-12 Pedal Bike Ford Transit Silver Using a Mobile Phone Whilst Driving None Granville Street Granville Street Birmingham Birmingham Fixed Penalty N/A   52.4762076 -1.9124263
4555 op-snap---monthly-publication-december-2025.pdf   683 2025-12 Pedal Bike Citroen C3.. Orange Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4556 op-snap---monthly-publication-december-2025.pdf   684 2025-12 Pedal Bike Kia Proceed White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4571 op-snap---monthly-publication-december-2025.pdf   699 2025-12 Pedal Bike Toyota Yaris Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
4588 op-snap---monthly-publication-december-2025.pdf   716 2025-12 Other Nissan Qashqai Grey Using a Mobile Phone Whilst Driving No Seat Belt Birmingham Birmingham Birmingham Birmingham Warning Letter N/A   52.4796992 -1.9026911
4628 op-snap---monthly-publication-december-2025.pdf   756 2025-12 Car Renault Captur Black Using a Mobile Phone Whilst Driving None M5 Southbound, jn 6 to 7 M5 Southbound, jn 6 to 7 Out of Force Area Out of Force Area NFA Out of Force      
4656 op-snap---monthly-publication-december-2025.pdf   784 2025-12 Pedal Bike Nissan Qashqai Red Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4657 op-snap---monthly-publication-december-2025.pdf   785 2025-12 Pedal Bike BMW 320d White Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4658 op-snap---monthly-publication-december-2025.pdf   786 2025-12 Pedal Bike Citroen C1 Blue Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4659 op-snap---monthly-publication-december-2025.pdf   787 2025-12 Pedal Bike   Smart Silver Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4677 op-snap---monthly-publication-december-2025.pdf   805 2025-12 Car Kia Ceed Black Using a Mobile Phone Whilst Driving None M6 M6 Walsall Walsall Fixed Penalty N/A      
4694 op-snap---monthly-publication-december-2025.pdf   822 2025-12 Pedal Bike Honda CRV Grey Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
4695 op-snap---monthly-publication-december-2025.pdf   823 2025-12 Pedal Bike Volkswagen Polo Grey Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
4739 op-snap---monthly-publication-december-2025.pdf   867 2025-12 Car Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Penns Lane Penns Lane Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5356148 -1.8191361
4748 op-snap---monthly-publication-december-2025.pdf   876 2025-12 Car BMW 218 Grey Using a Mobile Phone Whilst Driving None M6 South near Essington M6 South near Essington Wolverhampton Wolverhampton Fixed Penalty N/A      
4757 op-snap---monthly-publication-december-2025.pdf   885 2025-12 Car Audi TT Black Using a Mobile Phone Whilst Driving None Stonebridge Island Stonebridge Island Coventry Coventry NFA No Independent Evidence Available   52.4459998 -1.6949291
4797 op-snap---monthly-publication-december-2025.pdf   925 2025-12 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None M40 near Banbury M40 near Banbury Out of Force Area Out of Force Area NFA Out of Force      
4798 op-snap---monthly-publication-december-2025.pdf   926 2025-12 Car Saab 09-Mar Grey Using a Mobile Phone Whilst Driving None A45 near Stonebridge Island A45 near Stonebridge Island Solihull Solihull Fixed Penalty N/A      
4806 op-snap---monthly-publication-december-2025.pdf   934 2025-12 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
4808 op-snap---monthly-publication-december-2025.pdf   936 2025-12 Pedal Bike Lexus   White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
4811 op-snap---monthly-publication-december-2025.pdf   939 2025-12 Pedal Bike Hyundai i10 White Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4812 op-snap---monthly-publication-december-2025.pdf   940 2025-12 Pedal Bike Mercedes-Benz e220 White Using a Mobile Phone Whilst Driving None bell green road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
4822 op-snap---monthly-publication-december-2025.pdf   950 2025-12 Car   Ford White Using a Mobile Phone Whilst Driving Driving without Due Care and M At2t5ention M At2t5ention Out of Force Area Out of Force Area NFA Out of Force      
4830 op-snap---monthly-publication-december-2025.pdf   958 2025-12 Car Hyundai TUCSON White Using a Mobile Phone Whilst Driving None M6 near Willenhall M6 near Willenhall Walsall Walsall NFA No Independent Evidence Available      

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