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

633 rows where 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, nfa_rationale, witness_contacted

month 14

reporter_transport_mode 1

  • Car · 633 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 633 ✖
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
7314 op-snap---monthly-publication-february-2026.pdf   61 2026-02 Car Kia Ceed Silver Using a Mobile Phone Whilst Driving None Moorfield Road Moorfield Road Out of Force Area Out of Force Area NFA Out of Force   52.4981538 -1.7875516
7352 op-snap---monthly-publication-february-2026.pdf   99 2026-02 Car Volkswagen Tiguan White Using a Mobile Phone Whilst Driving None M621 (Greater Manchester) M621 (Greater Manchester) Out of Force Area Out of Force Area NFA Out of Force      
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
7456 op-snap---monthly-publication-february-2026.pdf   203 2026-02 Car Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Rugy Road Rugby Rugy Road Rugby Out of Force Area Out of Force Area NFA Out of Force      
7524 op-snap---monthly-publication-february-2026.pdf   271 2026-02 Car Audi A4 Black Using a Mobile Phone Whilst Driving None Tesco Petrol Station, Stone Cross Tesco Petrol Station, Stone Cross Sandwell Sandwell NFA No Independent Evidence Available      
7639 op-snap---monthly-publication-february-2026.pdf   386 2026-02 Car Ford Transit Black Using a Mobile Phone Whilst Driving None A529 Hinstock Hinstock Out of Force Area Out of Force Area NFA Out of Force      
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
7829 op-snap---monthly-publication-february-2026.pdf   576 2026-02 Car Peugeot 308.. Grey Using a Mobile Phone Whilst Driving None Cato Street Cato Street Birmingham Birmingham NFA No Independent Evidence Available   52.4904718 -1.8693759
7860 op-snap---monthly-publication-february-2026.pdf   607 2026-02 Car Land Rover Range White Using a Mobile Phone Whilst Driving None A19 A19 Out of Force Area Out of Force Area NFA Out of Force      
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
8108 op-snap---monthly-publication-february-2026.pdf   855 2026-02 Car Vauxhall Astra Blue Using a Mobile Phone Whilst Driving None Wyrley Brook Retail Park Wyrley Brook Retail Park Out of Force Area Out of Force Area NFA Out of Force      
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
8199 op-snap---monthly-publication-february-2026.pdf   946 2026-02 Car   Van White Using a Mobile Phone Whilst Driving None Desford Road Desford Road Out of Force Area Out of Force Area NFA Out of Force      
8249 op-snap---monthly-publication-february-2026.pdf   996 2026-02 Car BMW 120 Sport White Using a Mobile Phone Whilst Driving None Scimitar Way Scimitar Way Coventry Coventry NFA No Independent Evidence Available   52.3836203 -1.4862458
8274 op-snap---monthly-publication-february-2026.pdf   1021 2026-02 Car Alfa Romeo Romeo Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
8301 op-snap---monthly-publication-february-2026.pdf   1048 2026-02 Car Ford Transit White Using a Mobile Phone Whilst Driving None M6 Motorway M6 Motorway Birmingham Birmingham Warning Letter N/A   52.5327447 -1.899844
8361 op-snap---monthly-publication-february-2026.pdf   1108 2026-02 Car Nissan note Red Using a Mobile Phone Whilst Driving None A460 four ashes A460 four ashes Out of Force Area Out of Force Area NFA Out of Force   52.3828826 -1.7624844
8381 op-snap---monthly-publication-february-2026.pdf   1128 2026-02 Car Volkswagen Polo Blue Using a Mobile Phone Whilst Driving None A5 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
8415 op-snap---monthly-publication-february-2026.pdf   1162 2026-02 Car Mercedes-Benz sprinter White Using a Mobile Phone Whilst Driving None M42 J3 M42 J3 Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
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      
8438 op-snap---monthly-publication-february-2026.pdf   1185 2026-02 Car Fiat 500 Green Using a Mobile Phone Whilst Driving None Dudley Road East Dudley Road East Birmingham Birmingham NFA No Offence      
8458 op-snap---monthly-publication-february-2026.pdf   1205 2026-02 Car BMW 5 series White Using a Mobile Phone Whilst Driving None Kidderminster Road Kidderminster Road Dudley Dudley NFA No Independent Evidence Available   52.5000055 -2.1844503
8467 op-snap---monthly-publication-february-2026.pdf   1214 2026-02 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Wollescote Road Wollescote Road Dudley Dudley NFA No Independent Evidence Available   52.4471527 -2.1236271
8472 op-snap---monthly-publication-february-2026.pdf   1219 2026-02 Car BMW 3 series Black Using a Mobile Phone Whilst Driving None M4 M4 Out of Force Area Out of Force Area NFA Out of Force      
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      
8545 op-snap---monthly-publication-february-2026.pdf   1292 2026-02 Car Kia   Red Using a Mobile Phone Whilst Driving None Burton Upon Trent Burton Upon Trent Out of Force Area Out of Force Area NFA Out of Force      
8582 op-snap---monthly-publication-february-2026.pdf   1329 2026-02 Car Skoda Fabia Blue Using a Mobile Phone Whilst Driving None Town Walls, Shrewbury Town Walls, Shrewbury Out of Force Area Out of Force Area NFA Out of Force      
8588 op-snap---monthly-publication-february-2026.pdf   1335 2026-02 Car Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None M6 J18-19 M6 J18-19 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
8660 op-snap---monthly-publication-february-2026.pdf   1407 2026-02 Car Land Rover Evoque White Using a Mobile Phone Whilst Driving None Shard End Crescent Shard End Crescent Birmingham Birmingham NFA No Independent Evidence Available   52.4927744 -1.7781391
8666 op-snap---monthly-publication-february-2026.pdf   1413 2026-02 Car Ford   White Using a Mobile Phone Whilst Driving None IIminster Road IIminster Road Out of Force Area Out of Force Area NFA Out of Force      
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      
8683 op-snap---monthly-publication-february-2026.pdf   1430 2026-02 Car Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Sheepcote Street Sheepcote Street Birmingham Birmingham Warning Letter N/A   52.4770877 -1.9154767
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
8694 op-snap---monthly-publication-february-2026.pdf   1441 2026-02 Car Vauxhall Corsa White Using a Mobile Phone Whilst Driving None UK Uk     Other Action Taken N/A   52.5019896 -2.0209184
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
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      
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      
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
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
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
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
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      
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      
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      
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
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
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
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
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
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
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      
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      
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      
11874 op-snap---monthly-publication-january-2026.pdf   1335 2026-01 Car Audi A4.. Black Using a Mobile Phone Whilst Driving None Hill Top Road Hill Top Road Sandwell Sandwell NFA No Offence   52.4782626 -1.9987277
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
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
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      
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
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      
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
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
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      
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
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      
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      

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