home / opsnap

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 = "2026-01" 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

vehicle_make 27

  • BMW 13
  • Ford 12
  • Mercedes-Benz 11
  • Audi 9
  • Volkswagen 9
  • Vauxhall 7
  • Toyota 6
  • Peugeot 5
  • Land Rover 4
  • Renault 4
  • Kia 3
  • Nissan 3
  • Porsche 3
  • Seat 3
  • Skoda 3
  • Honda 2
  • Hyundai 2
  • Volvo 2
  • Chevrolet 1
  • Cupra 1
  • Daf 1
  • Fiat 1
  • Isuzu 1
  • Iveco 1
  • Mitsubishi 1
  • Scania 1
  • Tesla 1

council_area 8

  • Birmingham 64
  • Coventry 21
  • Out of Force Area 19
  • Sandwell 3
  • Solihull 2
  • Dudley 1
  • Unknown 1
  • Walsall 1

reporter_transport_mode 7

  • Pedal Bike 58
  • Car 37
  • Pedestrian 9
  • Other 5
  • Bus 1
  • Motorbike 1
  • other 1

disposal 7

  • Fixed Penalty 64
  • NFA 40
  • Court 2
  • Education 2
  • Other Action Taken 2
  • Duplicate Submission 1
  • Warning Letter 1

offence 1

  • Using a Mobile Phone Whilst Driving · 112 ✖

month 1

  • 2026-01 · 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
10543 op-snap---monthly-publication-january-2026.pdf   4 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10547 op-snap---monthly-publication-january-2026.pdf   8 2026-01 Pedal Bike Mercedes-Benz Vito White Using a Mobile Phone Whilst Driving No Insurance Stoney Stanton Road Stoney Stanton Road Coventry Coventry Duplicate Submission Duplicate Submission   52.4221152 -1.4959475
10548 op-snap---monthly-publication-january-2026.pdf   9 2026-01 Car Mercedes-Benz A200 Black Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry NFA No Independent Evidence Available   52.4070602 -1.4732469
10561 op-snap---monthly-publication-january-2026.pdf   22 2026-01 Pedal Bike Iveco Daily White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10562 op-snap---monthly-publication-january-2026.pdf   23 2026-01 Pedal Bike Mercedes-Benz CITAN White Using a Mobile Phone Whilst Driving None Hipswell Highway Hipswell Highway Coventry Coventry Fixed Penalty N/A   52.4119456 -1.4589896
10564 op-snap---monthly-publication-january-2026.pdf   25 2026-01 Pedal Bike Ford Transit Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
10565 op-snap---monthly-publication-january-2026.pdf   26 2026-01 Pedal Bike BMW M3 Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10573 op-snap---monthly-publication-january-2026.pdf   34 2026-01 Car Land Rover Discovery Grey Using a Mobile Phone Whilst Driving None A48 Gloucester Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.405214 -1.9708282
10610 op-snap---monthly-publication-january-2026.pdf   71 2026-01 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None Stourbridge Road Wombourne Stourbridge Road Wombourne Out of Force Area Out of Force Area NFA Out of Force      
10636 op-snap---monthly-publication-january-2026.pdf   97 2026-01 Pedestrian Porsche Cayman Blue Using a Mobile Phone Whilst Driving None Merry Hill Car Park Merry Hill Car Park Dudley Dudley NFA No Independent Evidence Available      
10644 op-snap---monthly-publication-january-2026.pdf   105 2026-01 other Honda Civic Grey Using a Mobile Phone Whilst Driving None Appleby Grove Appleby Grove Birmingham Birmingham NFA No Independent Evidence Available      
10656 op-snap---monthly-publication-january-2026.pdf   117 2026-01 Other Daf Truck White Using a Mobile Phone Whilst Driving None Northcote Road Northcote Road Birmingham Birmingham NFA No Independent Evidence Available   52.4862344 -1.8128298
10669 op-snap---monthly-publication-january-2026.pdf   130 2026-01 Car Vauxhall Insignia Silver Using a Mobile Phone Whilst Driving None Hollyhedge Road Hollyhedge Road Sandwell Sandwell Fixed Penalty N/A   52.5360974 -1.9837968
10739 op-snap---monthly-publication-january-2026.pdf   200 2026-01 Car Ford Fiesta Red Using a Mobile Phone Whilst Driving None Boardsley Middleway Boardsley Middleway Birmingham Birmingham NFA No VRM      
10740 op-snap---monthly-publication-january-2026.pdf   201 2026-01 Car Ford Ka White Using a Mobile Phone Whilst Driving None B4215 Ross on Wye Ross on Wye Out of Force Area Out of Force Area NFA Out of Force      
10753 op-snap---monthly-publication-january-2026.pdf   214 2026-01 Other Vauxhall Vivaro Black Using a Mobile Phone Whilst Driving None Fifield Road Fifield Road Birmingham Birmingham NFA No Independent Evidence Available      
10754 op-snap---monthly-publication-january-2026.pdf   215 2026-01 Pedestrian Scania   White Using a Mobile Phone Whilst Driving None Hagley Road near Highfield Road Hagley Road near Highfield Road Birmingham Birmingham Fixed Penalty N/A   52.471836 -1.9401037
10777 op-snap---monthly-publication-january-2026.pdf   238 2026-01 Car Chevrolet Cruz Black Using a Mobile Phone Whilst Driving None Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
10800 op-snap---monthly-publication-january-2026.pdf   261 2026-01 Pedal Bike Ford Ecosport Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
10815 op-snap---monthly-publication-january-2026.pdf   276 2026-01 Pedal Bike Fiat Doblo Silver Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
10832 op-snap---monthly-publication-january-2026.pdf   293 2026-01 Car Nissan E-NV200 White Using a Mobile Phone Whilst Driving None Broad Lane Broad Lane Birmingham Birmingham Fixed Penalty N/A   52.4135483 -1.9035033
10848 op-snap---monthly-publication-january-2026.pdf   309 2026-01 Car Ford Fiesta Red Using a Mobile Phone Whilst Driving None Warwick Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3813073 -1.5639569
10855 op-snap---monthly-publication-january-2026.pdf   316 2026-01 Pedestrian Volkswagen Polo Red Using a Mobile Phone Whilst Driving None Ninevah Road Ninevah Road Birmingham Birmingham NFA No Independent Evidence Available      
10905 op-snap---monthly-publication-january-2026.pdf   366 2026-01 Car BMW 6 Series Black Using a Mobile Phone Whilst Driving None M6 J14 M6 J14 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
10933 op-snap---monthly-publication-january-2026.pdf   394 2026-01 Car Peugeot 2008 Allure White Using a Mobile Phone Whilst Driving None Heathway Road Heathway Road Birmingham Birmingham Fixed Penalty N/A   52.560818 -1.7948304
10955 op-snap---monthly-publication-january-2026.pdf   416 2026-01 Pedestrian Skoda Rapid blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
10992 op-snap---monthly-publication-january-2026.pdf   453 2026-01 Pedal Bike BMW 740LD Blue Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4591339 -1.9601054
10993 op-snap---monthly-publication-january-2026.pdf   454 2026-01 Pedal Bike Mercedes-Benz GLA 200 Black Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham Fixed Penalty N/A   52.4422505 -1.8539684
11034 op-snap---monthly-publication-january-2026.pdf   495 2026-01 Car Kia EV - 9 Blue Using a Mobile Phone Whilst Driving None M6 South M6 South Metropolitan Borough of Walsall Walsall Other Action Taken N/A   52.6170728 -2.030393
11052 op-snap---monthly-publication-january-2026.pdf   513 2026-01 Pedestrian Audi A5 White Using a Mobile Phone Whilst Driving None Silver Street Silver Street Birmingham Birmingham NFA No Independent Evidence Available   52.433129 -1.8963794
11061 op-snap---monthly-publication-january-2026.pdf   522 2026-01 Car Nissan Juke Silver Using a Mobile Phone Whilst Driving None M1 J15 Northhampton M1 J15 Northhampton Out of Force Area Out of Force Area NFA Out of Force      
11062 op-snap---monthly-publication-january-2026.pdf   523 2026-01 Pedal Bike Tesla Model Y White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
11069 op-snap---monthly-publication-january-2026.pdf   530 2026-01 Pedal Bike Volkswagen Touran Black Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Fixed Penalty N/A   52.4398245 -1.8469786
11073 op-snap---monthly-publication-january-2026.pdf   534 2026-01 Pedal Bike Ford Kuga White Using a Mobile Phone Whilst Driving None Priory Road, Edgbaston Priory Road, Edgbaston Birmingham Birmingham Fixed Penalty N/A   52.4556998 -1.9102592
11076 op-snap---monthly-publication-january-2026.pdf   537 2026-01 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
11077 op-snap---monthly-publication-january-2026.pdf   538 2026-01 Pedal Bike Renault Megane Gold Using a Mobile Phone Whilst Driving No Seat Belt Alcester Road Alcester Road Birmingham Birmingham Court N/A   52.4470686 -1.8880749
11078 op-snap---monthly-publication-january-2026.pdf   539 2026-01 Pedal Bike Skoda Roomster Silver Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
11082 op-snap---monthly-publication-january-2026.pdf   543 2026-01 Car Honda   Red Using a Mobile Phone Whilst Driving None M60 M60 Out of Force Area Out of Force Area NFA Out of Force      
11090 op-snap---monthly-publication-january-2026.pdf   551 2026-01 Pedestrian Renault Clio Blue Using a Mobile Phone Whilst Driving None out of force blackpool Out Of Force Blackpool Out of Force Area Out of Force Area NFA Out of Force      
11110 op-snap---monthly-publication-january-2026.pdf   571 2026-01 Pedal Bike Audi Q2 Black Using a Mobile Phone Whilst Driving None Bristol Street Bristol Street Birmingham Birmingham Fixed Penalty N/A   52.4691145 -1.9003257
11113 op-snap---monthly-publication-january-2026.pdf   574 2026-01 Pedal Bike BMW 420D Blue Using a Mobile Phone Whilst Driving None Aston Web Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
11114 op-snap---monthly-publication-january-2026.pdf   575 2026-01 Pedal Bike Volkswagen Taigo Grey Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
11115 op-snap---monthly-publication-january-2026.pdf   576 2026-01 Pedal Bike Mercedes-Benz B180 Blue Using a Mobile Phone Whilst Driving None Metchley Lane, Harborne Metchley Lane, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11116 op-snap---monthly-publication-january-2026.pdf   577 2026-01 Pedal Bike Peugeot 207 Black Using a Mobile Phone Whilst Driving None Metchley Lane, Harborne Metchley Lane, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11165 op-snap---monthly-publication-january-2026.pdf   626 2026-01 Pedal Bike Peugeot 208.. Grey Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
11166 op-snap---monthly-publication-january-2026.pdf   627 2026-01 Pedal Bike Audi Q3 Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11167 op-snap---monthly-publication-january-2026.pdf   628 2026-01 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
11170 op-snap---monthly-publication-january-2026.pdf   631 2026-01 Car Vauxhall Viva Red Using a Mobile Phone Whilst Driving None Cranmore Road Cranmore Road Birmingham Birmingham Fixed Penalty N/A      
11209 op-snap---monthly-publication-january-2026.pdf   670 2026-01 Pedal Bike Ford Focus Silver Using a Mobile Phone Whilst Driving None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A   52.4274335 -1.5002381
11212 op-snap---monthly-publication-january-2026.pdf   673 2026-01 Pedal Bike Volkswagen Touran Silver Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11215 op-snap---monthly-publication-january-2026.pdf   676 2026-01 Pedal Bike BMW 320D White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11216 op-snap---monthly-publication-january-2026.pdf   677 2026-01 Pedal Bike Renault Megane Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
11217 op-snap---monthly-publication-january-2026.pdf   678 2026-01 Pedal Bike BMW 120 SPORT Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11225 op-snap---monthly-publication-january-2026.pdf   686 2026-01 Bus Toyota Prius White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
11276 op-snap---monthly-publication-january-2026.pdf   737 2026-01 Car Ford Fiesta Black Using a Mobile Phone Whilst Driving None Regent Place Regent Place Birmingham Birmingham NFA Not in Public Interest   52.4860376 -1.9095854
11288 op-snap---monthly-publication-january-2026.pdf   749 2026-01 Other BMW 4 series Black Using a Mobile Phone Whilst Driving None Leeds Leeds Out of Force Area Out of Force Area NFA Out of Force   52.4799028 -1.8973135
11316 op-snap---monthly-publication-january-2026.pdf   777 2026-01 Car Ford Transit 350 White Using a Mobile Phone Whilst Driving None Graham St Graham Street Birmingham Birmingham NFA No Independent Evidence Available   52.4843802 -1.9108415
11341 op-snap---monthly-publication-january-2026.pdf   802 2026-01 Car BMW X5 Grey Using a Mobile Phone Whilst Driving None Sharmans Cross Road Sharmans Cross Road Solihull Solihull Fixed Penalty N/A   52.4167172 -1.7990388
11346 op-snap---monthly-publication-january-2026.pdf   807 2026-01 Car Volvo   Silver Using a Mobile Phone Whilst Driving None High Street High Street Out of Force Area Out of Force Area NFA Out of Force   52.4993921 -1.8955888
11353 op-snap---monthly-publication-january-2026.pdf   814 2026-01 Car Kia Niro Grey Using a Mobile Phone Whilst Driving None Enfield, London Enfield, London Out of Force Area Out of Force Area NFA Out of Force      
11377 op-snap---monthly-publication-january-2026.pdf   838 2026-01 Car Volvo XC90 Silver Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11378 op-snap---monthly-publication-january-2026.pdf   839 2026-01 Pedestrian Land Rover Discovery Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11379 op-snap---monthly-publication-january-2026.pdf   840 2026-01 Car Porsche Cayenne Black Using a Mobile Phone Whilst Driving None Woodgate Lane Woodgate Lane Birmingham Birmingham Fixed Penalty N/A   52.4424238 -2.010981
11380 op-snap---monthly-publication-january-2026.pdf   841 2026-01 Pedestrian Audi Q5 Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11391 op-snap---monthly-publication-january-2026.pdf   852 2026-01 Car Toyota Yaris White Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
11434 op-snap---monthly-publication-january-2026.pdf   895 2026-01 Pedal Bike Mercedes-Benz A200 White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
11435 op-snap---monthly-publication-january-2026.pdf   896 2026-01 Pedal Bike Mercedes-Benz QB 350 Black Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
11436 op-snap---monthly-publication-january-2026.pdf   897 2026-01 Pedal Bike Porsche Cayenne Grey Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
11475 op-snap---monthly-publication-january-2026.pdf   936 2026-01 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11494 op-snap---monthly-publication-january-2026.pdf   955 2026-01 Car BMW X5 Black Using a Mobile Phone Whilst Driving None A6182 Doncatser Doncatser Out of Force Area Out of Force Area NFA Out of Force      
11509 op-snap---monthly-publication-january-2026.pdf   970 2026-01 Car Toyota Prius Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Offence   52.471632 -1.9456776
11513 op-snap---monthly-publication-january-2026.pdf   974 2026-01 Other   Unknown   Using a Mobile Phone Whilst Driving None Unknown   Unknown Unknown NFA No VRM      
11543 op-snap---monthly-publication-january-2026.pdf   1004 2026-01 Car Ford Transit White Using a Mobile Phone Whilst Driving No Insurance M25 Dartford M25 Dartford Out of Force Area Out of Force Area NFA Out of Force   52.6162979 -2.0165105
11551 op-snap---monthly-publication-january-2026.pdf   1012 2026-01 Pedal Bike Vauxhall Corsa Black Using a Mobile Phone Whilst Driving None Priory Road Priory Road Birmingham Birmingham Fixed Penalty N/A   52.4132696 -1.8555008
11555 op-snap---monthly-publication-january-2026.pdf   1016 2026-01 Pedal Bike Toyota CH-R Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11558 op-snap---monthly-publication-january-2026.pdf   1019 2026-01 Pedal Bike Vauxhall Corsa White Using a Mobile Phone Whilst Driving None A45, Coventry A45, Coventry Coventry Coventry NFA No Independent Evidence Available   52.3791309 -1.4740067
11565 op-snap---monthly-publication-january-2026.pdf   1026 2026-01 Pedal Bike Hyundai Tucson Blue Using a Mobile Phone Whilst Driving None A45 A45 Coventry Coventry Fixed Penalty N/A      
11569 op-snap---monthly-publication-january-2026.pdf   1030 2026-01 Pedal Bike BMW 1 series White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11574 op-snap---monthly-publication-january-2026.pdf   1035 2026-01 Car Hyundai Tucson Grey Using a Mobile Phone Whilst Driving None Blackberry Lane Blackberry Lane Coventry Coventry Fixed Penalty N/A   52.4254016 -1.4665041
11624 op-snap---monthly-publication-january-2026.pdf   1085 2026-01 Other       Using a Mobile Phone Whilst Driving None No exact location given. Taken from social media. No exact location given. Taken from social media Birmingham Birmingham NFA No Independent Evidence Available      
11648 op-snap---monthly-publication-january-2026.pdf   1109 2026-01 Car Toyota Aygo Red Using a Mobile Phone Whilst Driving None George Street Newcastle George Street Newcastle Out of Force Area Out of Force Area NFA Out of Force      
11653 op-snap---monthly-publication-january-2026.pdf   1114 2026-01 Car Peugeot 3008.. Grey Using a Mobile Phone Whilst Driving None M5 Jct 6 M5 Junction 6 Out of Force Area Out of Force Area NFA Out of Force      
11683 op-snap---monthly-publication-january-2026.pdf   1144 2026-01 Car Audi TT Grey Using a Mobile Phone Whilst Driving None M53 Mersey Side M53 Mersey Side Out of Force Area Out of Force Area NFA Out of Force      
11695 op-snap---monthly-publication-january-2026.pdf   1156 2026-01 Pedal Bike Isuzu   Red Using a Mobile Phone Whilst Driving None Village Lane Village Lane Out of Force Area Out of Force Area NFA Out of Force   52.590241 -1.8306656
11732 op-snap---monthly-publication-january-2026.pdf   1193 2026-01 Car Seat . Green Using a Mobile Phone Whilst Driving None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
11733 op-snap---monthly-publication-january-2026.pdf   1194 2026-01 Car Land Rover Defender Black Using a Mobile Phone Whilst Driving None M3 near Bracknell M3 near Bracknell Out of Force Area Out of Force Area NFA Out of Force      
11757 op-snap---monthly-publication-january-2026.pdf   1218 2026-01 Pedal Bike Audi S5 Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
11759 op-snap---monthly-publication-january-2026.pdf   1220 2026-01 Pedal Bike Volkswagen Golf White Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Other Action Taken N/A   52.4679402 -1.881408
11766 op-snap---monthly-publication-january-2026.pdf   1227 2026-01 Pedal Bike BMW 320i Grey Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
11768 op-snap---monthly-publication-january-2026.pdf   1229 2026-01 Pedal Bike Audi Q7 Black Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
11769 op-snap---monthly-publication-january-2026.pdf   1230 2026-01 Pedal Bike Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
11777 op-snap---monthly-publication-january-2026.pdf   1238 2026-01 Car Volkswagen Touran Grey Using a Mobile Phone Whilst Driving None Best Street Cradley Heath Best Street Cradley Heath Sandwell Sandwell Fixed Penalty N/A      
11778 op-snap---monthly-publication-january-2026.pdf   1239 2026-01 Car Volkswagen Golf Black Using a Mobile Phone Whilst Driving No Insurance Old Croft Lane Old Croft Lane Birmingham Birmingham Court N/A   52.496737 -1.7773905
11788 op-snap---monthly-publication-january-2026.pdf   1249 2026-01 Car Seat Ibiza Red Using a Mobile Phone Whilst Driving None Birmingham Road Birmingham Road Birmingham Birmingham Fixed Penalty N/A   52.5505398 -1.8252993
11839 op-snap---monthly-publication-january-2026.pdf   1300 2026-01 Car Vauxhall Astra Black Using a Mobile Phone Whilst Driving No vehicle excise licence M42 M42 Solihull Solihull NFA No Offence      
11841 op-snap---monthly-publication-january-2026.pdf   1302 2026-01 Pedal Bike BMW X3.. Grey Using a Mobile Phone Whilst Driving None Pebble Mill Road Pebble Mill Road Birmingham Birmingham Fixed Penalty N/A   52.4512925 -1.9124618
11842 op-snap---monthly-publication-january-2026.pdf   1303 2026-01 Pedal Bike Mitsubishi Outlander Blue Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
11863 op-snap---monthly-publication-january-2026.pdf   1324 2026-01 Pedal Bike Skoda Kodiaq Blue Using a Mobile Phone Whilst Driving None Stonehouse Hill Stonehouse Hill Birmingham Birmingham NFA No Independent Evidence Available   52.4448348 -1.9713792
11865 op-snap---monthly-publication-january-2026.pdf   1326 2026-01 Pedal Bike Mercedes-Benz E220 Black Using a Mobile Phone Whilst Driving No Insurance A435 Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
11866 op-snap---monthly-publication-january-2026.pdf   1327 2026-01 Pedal Bike Ford Focus White Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408

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