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

256 rows where disposal = "Fixed Penalty", offence = "Using a Mobile Phone Whilst Driving" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw

reporter_transport_mode 1

  • Car · 256 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 256 ✖

disposal 1

  • Fixed Penalty · 256 ✖
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
7263 op-snap---monthly-publication-february-2026.pdf   10 2026-02 Car BMW 116.. White Using a Mobile Phone Whilst Driving No Insurance Cranmore Road Cranmore Road Solihull Solihull Fixed Penalty N/A   52.3989532 -1.8125728
7439 op-snap---monthly-publication-february-2026.pdf   186 2026-02 Car Renault Captur Black Using a Mobile Phone Whilst Driving None New Birmingham Road, Oldbury New Birmingham Road, Oldbury Sandwell Sandwell Fixed Penalty N/A   52.504392 -2.0346032
7676 op-snap---monthly-publication-february-2026.pdf   423 2026-02 Car Vauxhall Insignia Grey Using a Mobile Phone Whilst Driving None Embankment Merry Hill Embankment Merry Hill Dudley Dudley Fixed Penalty N/A   52.4814094 -2.1134278
7976 op-snap---monthly-publication-february-2026.pdf   723 2026-02 Car Toyota Prius Black Using a Mobile Phone Whilst Driving Driving without Due Care and Attention A45 Coventry Coventry Coventry Coventry Fixed Penalty N/A   52.400739 -1.5135474
8034 op-snap---monthly-publication-february-2026.pdf   781 2026-02 Car Volkswagen Multivan Grey Using a Mobile Phone Whilst Driving None M5 SB J2-3 M5 Southbound J2-3 Sandwell Sandwell Fixed Penalty N/A   52.4945433 -2.0190848
8093 op-snap---monthly-publication-february-2026.pdf   840 2026-02 Car Vauxhall Combo White Using a Mobile Phone Whilst Driving None M5 Jct 2 M5 Junction 2 Sandwell Sandwell Fixed Penalty N/A   52.4945433 -2.0190848
8104 op-snap---monthly-publication-february-2026.pdf   851 2026-02 Car Tesla model 3 White Using a Mobile Phone Whilst Driving None M6 (N) 5-6 M6 (N) 5-6 Birmingham Birmingham Fixed Penalty N/A   52.5143137 -1.7683873
8106 op-snap---monthly-publication-february-2026.pdf   853 2026-02 Car Seat Leon White Using a Mobile Phone Whilst Driving No vehicle excise licence Wobaston Road Wobaston Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.628768 -2.1306154
8191 op-snap---monthly-publication-february-2026.pdf   938 2026-02 Car Volkswagen T-Cross Blue Using a Mobile Phone Whilst Driving None Amington Road Amington Road Birmingham Birmingham Fixed Penalty N/A   52.4590109 -1.8272286
8437 op-snap---monthly-publication-february-2026.pdf   1184 2026-02 Car Audi A7 Silver Using a Mobile Phone Whilst Driving None Oliver Way Oliver Way Coventry Coventry Fixed Penalty N/A      
8489 op-snap---monthly-publication-february-2026.pdf   1236 2026-02 Car Peugeot 208 Grey Using a Mobile Phone Whilst Driving None Pershore Road South Pershore Road South Birmingham Birmingham Fixed Penalty N/A   52.4150779 -1.930901
8492 op-snap---monthly-publication-february-2026.pdf   1239 2026-02 Car Audi A3 grey Using a Mobile Phone Whilst Driving None Station Road, Balsall Common Station Road, Balsall Common Coventry Coventry Fixed Penalty N/A      
8670 op-snap---monthly-publication-february-2026.pdf   1417 2026-02 Car Ford Mondeo Grey Using a Mobile Phone Whilst Driving None M42 SB J5-4 M42 Southbound J5-4 Solihull Solihull Fixed Penalty N/A      
8692 op-snap---monthly-publication-february-2026.pdf   1439 2026-02 Car Lexus RZ Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
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
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
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
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      
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
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
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
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
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
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      
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
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
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
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
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      
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
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
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
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
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
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      
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      
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      
4841 op-snap---monthly-publication-december-2025.pdf   969 2025-12 Car BMW 116.. Grey Using a Mobile Phone Whilst Driving No vehicle excise licence Chester Road Chester Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5359496 -1.8324115
4843 op-snap---monthly-publication-december-2025.pdf   971 2025-12 Car Nissan Pulsar White Using a Mobile Phone Whilst Driving None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Fixed Penalty N/A   52.5038363 -1.8432663
5168 op-snap---monthly-publication-december-2025.pdf   1296 2025-12 Car Ford Transit White Using a Mobile Phone Whilst Driving None Leamore Leamore Walsall Walsall Fixed Penalty N/A   52.6017244 -2.0081529
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
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      
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
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
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
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
21711 op-snap---monthly-publication-november-2025.pdf   1253 2025-11 Car Volkswagen Tiguan White Using a Mobile Phone Whilst Driving None Bromford Road Bromford Road Birmingham Birmingham Fixed Penalty N/A   52.503036 -1.8289972
21957 op-snap---monthly-publication-november-2025.pdf   1499 2025-11 Car Land Rover Discovery Silver Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
21973 op-snap---monthly-publication-november-2025.pdf   1515 2025-11 Car Peugeot RCZ White Using a Mobile Phone Whilst Driving None M42 M42 Birmingham Birmingham Fixed Penalty N/A      
22217 op-snap---monthly-publication-october-2025.pdf   167 2025-10 Car Ford Focus Black Using a Mobile Phone Whilst Driving None London Road London Road Coventry Coventry Fixed Penalty N/A   52.3916468 -1.4925995
22270 op-snap---monthly-publication-october-2025.pdf   220 2025-10 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None A46 A46 Coventry Coventry Fixed Penalty N/A      
22278 op-snap---monthly-publication-october-2025.pdf   228 2025-10 Car Volkswagen T-Roc White Using a Mobile Phone Whilst Driving None Quarry Brow Quarry Brow Dudley Dudley Fixed Penalty N/A   52.5310856 -2.114838
22310 op-snap---monthly-publication-october-2025.pdf   260 2025-10 Car Vauxhall Meriva Blue Using a Mobile Phone Whilst Driving None Lozells Road Lozells Road Birmingham Birmingham Fixed Penalty N/A   52.502683 -1.9033516
22663 op-snap---monthly-publication-october-2025.pdf   613 2025-10 Car BMW 320.. White Using a Mobile Phone Whilst Driving None M6 Jct 8 M6 Junction 8 Birmingham Birmingham Fixed Penalty N/A   52.6912891 -2.1046372
22875 op-snap---monthly-publication-october-2025.pdf   825 2025-10 Car Citroen C4 Blue Using a Mobile Phone Whilst Driving None Tenbury Road Tenbury Road Birmingham Birmingham Fixed Penalty N/A   52.4264041 -1.8966768
22908 op-snap---monthly-publication-october-2025.pdf   858 2025-10 Car Toyota Yaris White Using a Mobile Phone Whilst Driving None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Fixed Penalty N/A   52.4702299 -1.9948976
22929 op-snap---monthly-publication-october-2025.pdf   879 2025-10 Car Volvo V40 Black Using a Mobile Phone Whilst Driving None Lawley Middleway Lawley Middleway Birmingham Birmingham Fixed Penalty N/A   52.4801772 -1.8769185
22972 op-snap---monthly-publication-october-2025.pdf   922 2025-10 Car Vauxhall Astra White Using a Mobile Phone Whilst Driving None D`Eyncourt Road D`Eyncourt Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.6080025 -2.0988316
23081 op-snap---monthly-publication-october-2025.pdf   1031 2025-10 Car Seat Leon Grey Using a Mobile Phone Whilst Driving None Wesley Road Wesley Road Wolverhampton Wolverhampton Fixed Penalty N/A      
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
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      
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      
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      
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
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
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
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
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
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
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
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
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      
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
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      
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
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
24762 op-snap---monthly-publication-september-2025.pdf   981 2025-09 Car Vauxhall aAstra White Using a Mobile Phone Whilst Driving None High Street High Street Birmingham Birmingham Fixed Penalty N/A   52.5254588 -1.8373064
24824 op-snap---monthly-publication-september-2025.pdf   1043 2025-09 Car Vauxhall Zafira White Using a Mobile Phone Whilst Driving None Gerald Road Gerald Road Dudley Dudley Fixed Penalty N/A   52.4655739 -2.1614353
24829 op-snap---monthly-publication-september-2025.pdf   1048 2025-09 Car Volkswagen Crafter Silver Using a Mobile Phone Whilst Driving None Windward Way Windward Way Birmingham Birmingham Fixed Penalty N/A      
24905 op-snap---monthly-publication-september-2025.pdf   1124 2025-09 Car Nissan X Trail Silver Using a Mobile Phone Whilst Driving None High Street High Street Sandwell Sandwell Fixed Penalty N/A   52.5128738 -1.9842054
2081 op-snap---monthly-publication-august-2025.pdf   56 2025-08 Car Hyundai I10 White Using a Mobile Phone Whilst Driving None M42 South M42 South Solihull Solihull Fixed Penalty N/A   52.4473832 -1.7140496
2117 op-snap---monthly-publication-august-2025.pdf   92 2025-08 Car BMW SUV Black Using a Mobile Phone Whilst Driving None Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 Sandwell Sandwell Fixed Penalty N/A      
2133 op-snap---monthly-publication-august-2025.pdf   108 2025-08 Car Volkswagen Tiguan Grey Using a Mobile Phone Whilst Driving None M6 South 10a - 10 M6 South 10a - 10 Birmingham Birmingham Fixed Penalty N/A      
2157 op-snap---monthly-publication-august-2025.pdf   132 2025-08 Car Audi A3 Silver Using a Mobile Phone Whilst Driving None Romney WAY Romney WAY Birmingham Birmingham Fixed Penalty N/A      
2252 op-snap---monthly-publication-august-2025.pdf   227 2025-08 Car BMW   White Using a Mobile Phone Whilst Driving None M6 Motorway M6 Motorway Birmingham Birmingham Fixed Penalty N/A   52.5327447 -1.899844
2331 op-snap---monthly-publication-august-2025.pdf   306 2025-08 Car Nissan Micra Black Using a Mobile Phone Whilst Driving None A4148 A4148 Walsall Walsall Fixed Penalty N/A      
2350 op-snap---monthly-publication-august-2025.pdf   325 2025-08 Car Tesla Model Y Blue Using a Mobile Phone Whilst Driving None Bristol Road South Bristol Road South Birmingham Birmingham Fixed Penalty N/A   52.4119174 -1.9735247
2451 op-snap---monthly-publication-august-2025.pdf   426 2025-08 Car Tesla Model Y Grey Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Solihull Solihull Fixed Penalty N/A   52.4191184 -1.8326637
2509 op-snap---monthly-publication-august-2025.pdf   484 2025-08 Car Volkswagen Touran Black Using a Mobile Phone Whilst Driving None A45 Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A   52.4726661 -1.8769032
2521 op-snap---monthly-publication-august-2025.pdf   496 2025-08 Car Toyota Prius Grey Using a Mobile Phone Whilst Driving None Bordsley Circus Bordsley Circus Birmingham Birmingham Fixed Penalty N/A      

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