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

120 rows where month = "2025-05" and offence = "Using a Mobile Phone Whilst Driving" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 8

disposal 4

offence 1

  • Using a Mobile Phone Whilst Driving · 120 ✖

month 1

  • 2025-05 · 120 ✖
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
18642 op-snap---monthly-publication-may-2025.pdf   4 2025-05 Pedestrian Citroen C5 Silver Using a Mobile Phone Whilst Driving None Hannah Road Hannah Road Wolverhampton Wolverhampton NFA Not in Public Interest      
18654 op-snap---monthly-publication-may-2025.pdf   16 2025-05 Pedal Bike Tesla   White Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
18659 op-snap---monthly-publication-may-2025.pdf   21 2025-05 Pedal Bike Land Rover Range Rover Green Using a Mobile Phone Whilst Driving None Widney Road Solihull Widney Road Solihull Solihull Solihull NFA Not in Public Interest   52.3795667 -1.7478958
18667 op-snap---monthly-publication-may-2025.pdf   29 2025-05 Car Fiat Diablo Blue Using a Mobile Phone Whilst Driving None St Chads Road at Willenhall Road Street Chads Road at Willenhall Road Wolverhampton Wolverhampton Fixed Penalty N/A      
18673 op-snap---monthly-publication-may-2025.pdf   35 2025-05 Car Ford Focus Black Using a Mobile Phone Whilst Driving None Field Road Field Road Walsall Walsall Fixed Penalty N/A   52.6185043 -1.9962803
18677 op-snap---monthly-publication-may-2025.pdf   39 2025-05 Car Tesla Model 3 White Using a Mobile Phone Whilst Driving None Olbury Road Olbury Road Sandwell Sandwell Fixed Penalty N/A      
18680 op-snap---monthly-publication-may-2025.pdf   42 2025-05 Car Ford Transit White Using a Mobile Phone Whilst Driving None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
18688 op-snap---monthly-publication-may-2025.pdf   50 2025-05 Car BMW X3.. Grey Using a Mobile Phone Whilst Driving None Seagar Street West Bromwich Seagar Street West Bromwich Sandwell Sandwell Fixed Penalty N/A   52.5223981 -1.9866132
18692 op-snap---monthly-publication-may-2025.pdf   54 2025-05 Car Honda Jazz Blue Using a Mobile Phone Whilst Driving None M5 North towards M6 M5 North towards M6 Sandwell Sandwell Fixed Penalty N/A      
18699 op-snap---monthly-publication-may-2025.pdf   61 2025-05 Pedal Bike Toyota Auris Blue Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
18702 op-snap---monthly-publication-may-2025.pdf   64 2025-05 Pedal Bike BMW 330d Black Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
18704 op-snap---monthly-publication-may-2025.pdf   66 2025-05 Pedal Bike Volkswagen Golf Grey Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
18705 op-snap---monthly-publication-may-2025.pdf   67 2025-05 Car Vauxhall Corsa Black Using a Mobile Phone Whilst Driving None Lord Street Walsall Lord Street Walsall Walsall Walsall Fixed Penalty N/A   52.5700579 -1.9889188
18713 op-snap---monthly-publication-may-2025.pdf   75 2025-05 Pedal Bike Seat ibiza Silver Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
18715 op-snap---monthly-publication-may-2025.pdf   77 2025-05 Car Toyota Rav 4 Grey Using a Mobile Phone Whilst Driving None Table Oak Lane Table Oak Lane Solihull Solihull NFA No Independent Evidence Available   52.36756 -1.6490909
18732 op-snap---monthly-publication-may-2025.pdf   94 2025-05 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None ring Road St Davids ring Road Street Davids Wolverhampton Wolverhampton Fixed Penalty N/A      
18764 op-snap---monthly-publication-may-2025.pdf   126 2025-05 Pedal Bike Toyota CH R White Using a Mobile Phone Whilst Driving No Insurance High Street Kings Heath High Street Kings Heath Birmingham Birmingham Court N/A   52.4375456 -1.8926849
18774 op-snap---monthly-publication-may-2025.pdf   136 2025-05 Pedal Bike Ford S-MAX Black Using a Mobile Phone Whilst Driving None ASTON WEBB, SELLY OAK Aston Webb, Selly Oak Birmingham Birmingham Fixed Penalty N/A   52.4468669 -1.9397041
18776 op-snap---monthly-publication-may-2025.pdf   138 2025-05 Pedestrian Audi a3 Red Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
18789 op-snap---monthly-publication-may-2025.pdf   151 2025-05 Pedal Bike Mini One Grey Using a Mobile Phone Whilst Driving None Shenley Lane Shenley Lane Birmingham Birmingham Fixed Penalty N/A   52.430111 -1.9753703
18792 op-snap---monthly-publication-may-2025.pdf   154 2025-05 Pedal Bike Mercedes-Benz G63.. Black Using a Mobile Phone Whilst Driving None Masshouse Lane Masshouse Lane Birmingham Birmingham Warning Letter N/A   52.4072996 -1.9273914
18840 op-snap---monthly-publication-may-2025.pdf   202 2025-05 Car Citroen Berlingo White Using a Mobile Phone Whilst Driving None Bull Ring Sedgley Bull Ring Sedgley Dudley Dudley Fixed Penalty N/A      
18862 op-snap---monthly-publication-may-2025.pdf   224 2025-05 Car Suzuki Swift Red Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
18865 op-snap---monthly-publication-may-2025.pdf   227 2025-05 Car Vauxhall corsa Black Using a Mobile Phone Whilst Driving None Pound Road Pound Road Sandwell Sandwell Fixed Penalty N/A   52.5541213 -2.0098297
18870 op-snap---monthly-publication-may-2025.pdf   232 2025-05 Car Skoda Octivia Grey Using a Mobile Phone Whilst Driving None A5 Shrewbury Shrewbury Out of Force Area Out of Force Area NFA Out of Force      
18875 op-snap---monthly-publication-may-2025.pdf   237 2025-05 Pedal Bike Renault clio Red Using a Mobile Phone Whilst Driving none Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
18881 op-snap---monthly-publication-may-2025.pdf   243 2025-05 Car BMW 320D Blue Using a Mobile Phone Whilst Driving None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Fixed Penalty N/A   52.5038363 -1.8432663
18893 op-snap---monthly-publication-may-2025.pdf   255 2025-05 Car Volkswagen Golf Silver Using a Mobile Phone Whilst Driving None A34 Walsall Road Walsall Road Walsall Walsall Fixed Penalty N/A   52.6166864 -1.9660822
18963 op-snap---monthly-publication-may-2025.pdf   325 2025-05 Pedal Bike Peugeot 408 Blue Using a Mobile Phone Whilst Driving None Highgate Middleway Highgate Middleway Birmingham Birmingham Fixed Penalty N/A   52.4661171 -1.8832818
18974 op-snap---monthly-publication-may-2025.pdf   336 2025-05 Pedal Bike Toyota Prius Grey Using a Mobile Phone Whilst Driving None Northfield Rd Northfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.4167654 -1.9411244
18979 op-snap---monthly-publication-may-2025.pdf   341 2025-05 Pedal Bike Volkswagen Passat Grey Using a Mobile Phone Whilst Driving None Myvod Road Myvod Road Sandwell Sandwell Fixed Penalty N/A   52.562989 -2.0085973
18987 op-snap---monthly-publication-may-2025.pdf   349 2025-05 car Honda 125 Silver Using a Mobile Phone Whilst Driving None Bromford Lane, West Bromwich Bromford Lane, West Bromwich Sandwell Sandwell Fixed Penalty N/A   52.5138332 -2.0029321
19012 op-snap---monthly-publication-may-2025.pdf   374 2025-05 Pedal Bike Toyota VERSO Silver Using a Mobile Phone Whilst Driving None OXFORD ROAD Oxford Road Birmingham Birmingham Fixed Penalty N/A   52.4456323 -1.8858352
19013 op-snap---monthly-publication-may-2025.pdf   375 2025-05 Pedal Bike Citroen C4 Black Using a Mobile Phone Whilst Driving None OXFORD ROAD Oxford Road Birmingham Birmingham Fixed Penalty N/A   52.4456323 -1.8858352
19057 op-snap---monthly-publication-may-2025.pdf   419 2025-05 Motorbike Toyota Yaris Blue Using a Mobile Phone Whilst Driving None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A   52.4327486 -1.8844997
19061 op-snap---monthly-publication-may-2025.pdf   423 2025-05 Car Mercedes-Benz BENZ White Using a Mobile Phone Whilst Driving Driving without Due C aAre5 aOnUdT A OtteFn FtiOonRCE a Are5 a On Ud T A Otte Fn Fti Oon RCE Out of Force Area Out of Force Area NFA Out of Force      
19065 op-snap---monthly-publication-may-2025.pdf   427 2025-05 Car Rolls-Royce Cullian Black Using a Mobile Phone Whilst Driving None M5 North Jct 3 M5 North Junction 3 Dudley Dudley Fixed Penalty N/A      
19071 op-snap---monthly-publication-may-2025.pdf   433 2025-05 Car BMW M4 Grey Using a Mobile Phone Whilst Driving NONE M6 JUNCTION 9 M6 Junction 9 Walsall Walsall Fixed Penalty N/A   52.676119 -2.0858425
19109 op-snap---monthly-publication-may-2025.pdf   471 2025-05 Pedal Bike Mercedes-Benz 180 Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
19114 op-snap---monthly-publication-may-2025.pdf   476 2025-05 Car Ford Tourneo Grey Using a Mobile Phone Whilst Driving None Castle Lane Castle Lane Out of Force Area Out of Force Area NFA Out of Force   52.4398581 -1.7869538
19121 op-snap---monthly-publication-may-2025.pdf   483 2025-05 Car Honda CRV Grey Using a Mobile Phone Whilst Driving None Harborne Lane Harborne Lane Birmingham Birmingham Fixed Penalty N/A   52.4468464 -1.9454816
19124 op-snap---monthly-publication-may-2025.pdf   486 2025-05 Pedal Bike Suzuki Ignis Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
19170 op-snap---monthly-publication-may-2025.pdf   532 2025-05 Pedal Bike Volvo XC40 Silver Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19172 op-snap---monthly-publication-may-2025.pdf   534 2025-05 Pedal Bike Nissan E-nV200 White Using a Mobile Phone Whilst Driving None Highgate Middleway Highgate Middleway Birmingham Birmingham Fixed Penalty N/A   52.4661171 -1.8832818
19173 op-snap---monthly-publication-may-2025.pdf   535 2025-05 Other Toyota Yaris Grey Using a Mobile Phone Whilst Driving None Walsall Road Walsall Road Birmingham Birmingham Fixed Penalty N/A   52.5919543 -1.8517118
19186 op-snap---monthly-publication-may-2025.pdf   548 2025-05 Car Ford Transit Grey Using a Mobile Phone Whilst Driving None Merry Hill Merry Hill Sandwell Sandwell Fixed Penalty N/A   52.5262964 -2.0021527
19189 op-snap---monthly-publication-may-2025.pdf   551 2025-05 Pedestrian Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Bosty Lane Bosty Lane Walsall Walsall NFA No Independent Evidence Available   52.5948329 -1.927787
19218 op-snap---monthly-publication-may-2025.pdf   580 2025-05 Pedestrian Ford Ecosport Black Using a Mobile Phone Whilst Driving None Northfield Road Northfield Road Birmingham Birmingham Fixed Penalty N/A   52.4167654 -1.9411244
19243 op-snap---monthly-publication-may-2025.pdf   605 2025-05 Lorry Mercedes-Benz Aston Martin Green Using a Mobile Phone Whilst Driving No Insurance M40 to M42 junction M40 to M42 junction Out of Force Area Out of Force Area NFA Out of Force      
19247 op-snap---monthly-publication-may-2025.pdf   609 2025-05 Car BMW 3 series White Using a Mobile Phone Whilst Driving None Wilkin Road, Brownhills Wilkin Road, Brownhills Walsall Walsall Fixed Penalty N/A   52.6580428 -1.9502105
19259 op-snap---monthly-publication-may-2025.pdf   621 2025-05 Pedal Bike Volkswagen T Roc.. White Using a Mobile Phone Whilst Driving None Elmdon Road Elmdon Road Birmingham Birmingham Fixed Penalty N/A   52.4418657 -1.9240253
19261 op-snap---monthly-publication-may-2025.pdf   623 2025-05 Pedal Bike Audi A3..` Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Offence   52.4308271 -1.920078
19274 op-snap---monthly-publication-may-2025.pdf   636 2025-05 Pedal Bike BMW 116I White Using a Mobile Phone Whilst Driving None Harborne High St Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
19275 op-snap---monthly-publication-may-2025.pdf   637 2025-05 Pedal Bike BMW X4 Blue Using a Mobile Phone Whilst Driving Use vehicle on a road wHiitghho uStt rveaelitd test certificate w Hiitghho u Stt rveaelitd test certificate Birmingham Birmingham Fixed Penalty N/A      
19287 op-snap---monthly-publication-may-2025.pdf   649 2025-05 Pedal Bike Toyota Yaris Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19288 op-snap---monthly-publication-may-2025.pdf   650 2025-05 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
19304 op-snap---monthly-publication-may-2025.pdf   666 2025-05 Pedal Bike Honda Civic Silver Using a Mobile Phone Whilst Driving None Oxford Road Oxford Road Birmingham Birmingham Fixed Penalty N/A   52.4456323 -1.8858352
19324 op-snap---monthly-publication-may-2025.pdf   686 2025-05 Car Toyota Rav4 White Using a Mobile Phone Whilst Driving None Jewellery Quarter Jewellery Quarter Birmingham Birmingham Fixed Penalty N/A   52.4879157 -1.9116096
19327 op-snap---monthly-publication-may-2025.pdf   689 2025-05 Pedal Bike Volkswagen Golf White Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A   52.4134557 -1.4442138
19329 op-snap---monthly-publication-may-2025.pdf   691 2025-05 Pedal Bike Suzuki Alto Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19330 op-snap---monthly-publication-may-2025.pdf   692 2025-05 Pedal Bike Vauxhall Corsa Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
19331 op-snap---monthly-publication-may-2025.pdf   693 2025-05 Pedal Bike Audi A6 Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19397 op-snap---monthly-publication-may-2025.pdf   759 2025-05 Car Mini Cooper White Using a Mobile Phone Whilst Driving None M6 NB J14 M6 Northbound J14 Out of Force Area Out of Force Area NFA Out of Force      
19398 op-snap---monthly-publication-may-2025.pdf   760 2025-05 Car Volvo XC90 Blue Using a Mobile Phone Whilst Driving None M42 NB 6 to 7 M42 Northbound 6 to 7 Solihull Solihull Fixed Penalty N/A      
19403 op-snap---monthly-publication-may-2025.pdf   765 2025-05 Van Toyota Corolla Silver Using a Mobile Phone Whilst Driving None M6 Southbound nr Jn2 M6 Southbound nr Jn2 Coventry Coventry Fixed Penalty N/A      
19415 op-snap---monthly-publication-may-2025.pdf   777 2025-05 Car Toyota CHR White Using a Mobile Phone Whilst Driving None Longbridge Lane Longbridge Lane Birmingham Birmingham NFA No Independent Evidence Available   52.3962003 -1.9821252
19443 op-snap---monthly-publication-may-2025.pdf   805 2025-05 Pedal Bike Vauxhall Adam Blue Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
19468 op-snap---monthly-publication-may-2025.pdf   830 2025-05 Car Vauxhall Zafira Black Using a Mobile Phone Whilst Driving None Edgbaston Rd Edgbaston Road Birmingham Birmingham Fixed Penalty N/A   52.4552785 -1.906384
19520 op-snap---monthly-publication-may-2025.pdf   882 2025-05 Car Volkswagen Polo Black Using a Mobile Phone Whilst Driving None Coventry Road A45 Coventry Road A45 Birmingham Birmingham Fixed Penalty N/A   52.4516899 -1.7753139
19523 op-snap---monthly-publication-may-2025.pdf   885 2025-05 Pedestrian Ford Focus Black Using a Mobile Phone Whilst Driving None Woodbridge Road Woodbridge Road Birmingham Birmingham Fixed Penalty N/A   52.4482076 -1.8864335
19531 op-snap---monthly-publication-may-2025.pdf   893 2025-05 Pedal Bike Audi Etron Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19533 op-snap---monthly-publication-may-2025.pdf   895 2025-05 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19534 op-snap---monthly-publication-may-2025.pdf   896 2025-05 Pedal Bike Audi A3 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
19540 op-snap---monthly-publication-may-2025.pdf   902 2025-05 Car Vauxhall Corsa Red Using a Mobile Phone Whilst Driving None Gravelly Hill N Gravelly Hill N Birmingham Birmingham Fixed Penalty N/A   52.5204663 -1.8459173
19546 op-snap---monthly-publication-may-2025.pdf   908 2025-05 Car Fiat Ducato White Using a Mobile Phone Whilst Driving None Holyhead Road Holyhead Road Coventry Coventry NFA No Independent Evidence Available   52.418488 -1.5472387
19571 op-snap---monthly-publication-may-2025.pdf   933 2025-05 Car Daf Truck   Using a Mobile Phone Whilst Driving Use vehicle on a road wMi4th0o Wut avrawliidc ktest certificate w Mi4th0o Wut avrawliidc ktest certificate Out of Force Area Out of Force Area NFA Out of Force      
19577 op-snap---monthly-publication-may-2025.pdf   939 2025-05 Car Ford Fiesta Red Using a Mobile Phone Whilst Driving No Seat Belt Narrowboat way Narrowboat way Dudley Dudley Court N/A   52.4914718 -2.1011818
19607 op-snap---monthly-publication-may-2025.pdf   969 2025-05 Car Peugeot 308 White Using a Mobile Phone Whilst Driving Driving without Due C aTree lfaonrdd Attention a Tree lfaonrdd Attention Out of Force Area Out of Force Area NFA Out of Force      
19625 op-snap---monthly-publication-may-2025.pdf   987 2025-05 Pedal Bike Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Bearwood Road Bearwood Road Sandwell Sandwell NFA No Independent Evidence Available   52.4725977 -1.9684448
19657 op-snap---monthly-publication-may-2025.pdf   1019 2025-05 Car Audi A6 Silver Using a Mobile Phone Whilst Driving None A34 Stafford Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6014882 -2.1310443
19669 op-snap---monthly-publication-may-2025.pdf   1031 2025-05 Pedal Bike Audi SQ2 Black Using a Mobile Phone Whilst Driving None Tile Cross Road Tile Cross Road Birmingham Birmingham Fixed Penalty N/A   52.4792894 -1.7605934
19674 op-snap---monthly-publication-may-2025.pdf   1036 2025-05 Pedal Bike Toyota Aygo Red Using a Mobile Phone Whilst Driving None New Union Street New Union Street Coventry Coventry Fixed Penalty N/A   52.4048717 -1.5098536
19676 op-snap---monthly-publication-may-2025.pdf   1038 2025-05 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None Princess Anne Retail Park Princess Anne Retail Park Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available      
19679 op-snap---monthly-publication-may-2025.pdf   1041 2025-05 Pedal Bike Ford Puma Grey Using a Mobile Phone Whilst Driving None Broad Lane Broad Lane Coventry Coventry Fixed Penalty N/A   52.4074716 -1.5620671
19680 op-snap---monthly-publication-may-2025.pdf   1042 2025-05 Pedal Bike Audi A5 Silver Using a Mobile Phone Whilst Driving None Meriden Road Meriden Road Coventry Coventry Fixed Penalty N/A   52.4233575 -1.4380372
19690 op-snap---monthly-publication-may-2025.pdf   1052 2025-05 Car Ford Transit White Using a Mobile Phone Whilst Driving None Sky Blue WAY Sky Blue WAY Coventry Coventry Warning Letter N/A   52.4085943 -1.4943275
19915 op-snap---monthly-publication-may-2025.pdf   1277 2025-05 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None JTC New strreet/frogmill road JTC New strreet/frogmill road Birmingham Birmingham NFA Out of Force      
19978 op-snap---monthly-publication-may-2025.pdf   1340 2025-05 Other Volkswagen Transporter Grey Using a Mobile Phone Whilst Driving None Wolverhampton road Wolverhampton road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.5968709 -2.0954054
20017 op-snap---monthly-publication-may-2025.pdf   1379 2025-05 Car Honda NSC White Using a Mobile Phone Whilst Driving None A458 Stourbridge ring road Stourbridge ring road Dudley Dudley Fixed Penalty N/A   52.4590366 -2.1465735
20018 op-snap---monthly-publication-may-2025.pdf   1380 2025-05 Car   Tractor Blue Using a Mobile Phone Whilst Driving None A489 Eaton to Lydham Eaton to Lydham Out of Force Area Out of Force Area NFA Out of Force      
20031 op-snap---monthly-publication-may-2025.pdf   1393 2025-05 Pedal Bike BMW NP Black Using a Mobile Phone Whilst Driving None Daw end lane Daw end lane Walsall Walsall Fixed Penalty N/A   52.6068849 -1.9611652
20032 op-snap---monthly-publication-may-2025.pdf   1394 2025-05 Pedal Bike Ford NP Grey Using a Mobile Phone Whilst Driving None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A   52.6068849 -1.9611652
20052 op-snap---monthly-publication-may-2025.pdf   1414 2025-05 Pedal Bike   golf Grey Using a Mobile Phone Whilst Driving None Smallbrook queensway Smallbrook queensway Birmingham Birmingham NFA Misc Inc Crimes   52.4772584 -1.8965734
20074 op-snap---monthly-publication-may-2025.pdf   1436 2025-05 Car   NP White Using a Mobile Phone Whilst Driving None M42 M42 Out of Force Area Out of Force Area NFA Out of Force      
20097 op-snap---monthly-publication-may-2025.pdf   1459 2025-05 Car Mini One convertible Blue Using a Mobile Phone Whilst Driving None tettenhall road Tettenhall Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.5883523 -2.1466187
20102 op-snap---monthly-publication-may-2025.pdf   1464 2025-05 Car Daf LF White Using a Mobile Phone Whilst Driving None A452 A452 Birmingham Birmingham NFA No Offence      
20117 op-snap---monthly-publication-may-2025.pdf   1479 2025-05 Car Ford Transit White Using a Mobile Phone Whilst Driving None a45 A45 Coventry Coventry Fixed Penalty N/A      
20134 op-snap---monthly-publication-may-2025.pdf   1496 2025-05 Pedestrian Honda Jazz Silver Using a Mobile Phone Whilst Driving None Radleys, Sheldon Radleys, Sheldon Birmingham Birmingham Warning Letter N/A   52.4674612 -1.773053
20141 op-snap---monthly-publication-may-2025.pdf   1503 2025-05 Car Honda FRV Grey Using a Mobile Phone Whilst Driving No Insurance A38(M) A38(M) Birmingham Birmingham Warning Letter N/A   52.4946291 -1.8874209
20142 op-snap---monthly-publication-may-2025.pdf   1504 2025-05 Pedal Bike Hyundai Getz Silver Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham NFA Misc Inc Crimes   52.4943878 -1.8504211

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