reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

Data license: ODbL · Data source: West Midlands Police

id
{'label': 'ID'}
source_file
{'label': 'Source PDF'}
source_page
{'label': 'Page'}
source_row
{'label': 'Row'}
month
{'label': 'Month'}
reporter_transport_mode
{'label': 'Reporter'}
vehicle_make
{'label': 'Make'}
vehicle_model
{'label': 'Model'}
vehicle_colour
{'label': 'Colour'}
offence
{'label': 'Offence'}
second_offence
{'label': 'Second offence'}
offence_location_raw
{'label': 'Location (raw)'}
offence_location
{'label': 'Location'}
council_area_raw
{'label': 'Council (raw)'}
council_area
{'label': 'Council area'}
disposal
{'label': 'Outcome'}
nfa_rationale
{'label': 'NFA reason'}
witness_contacted
{'label': 'Witness contacted'}
latitude
{'label': 'Lat'}
longitude
{'label': 'Lng'}

123 rows where month = "2025-10" 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 5

disposal 4

offence 1

  • Using a Mobile Phone Whilst Driving · 123 ✖

month 1

  • 2025-10 · 123 ✖
id source_file source_page source_row month ▲ reporter_transport_mode vehicle_make vehicle_model vehicle_colour offence second_offence offence_location_raw offence_location council_area_raw council_area disposal nfa_rationale witness_contacted latitude longitude
22060 op-snap---monthly-publication-october-2025.pdf   10 2025-10 Pedestrian Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5359496 -1.8324115
22061 op-snap---monthly-publication-october-2025.pdf   11 2025-10 Pedal Bike Peugeot Rifter White Using a Mobile Phone Whilst Driving None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Fixed Penalty N/A   52.4134557 -1.4442138
22074 op-snap---monthly-publication-october-2025.pdf   24 2025-10 Car Audi Q7 Black Using a Mobile Phone Whilst Driving None UK Uk Wolverhampton Wolverhampton NFA No Offence   52.5857245 -2.1300952
22077 op-snap---monthly-publication-october-2025.pdf   27 2025-10 Other Ford Fiesta Black Using a Mobile Phone Whilst Driving None Unknown       NFA Misc Inc Crimes      
22089 op-snap---monthly-publication-october-2025.pdf   39 2025-10 Pedal Bike Nissan Juke Red Using a Mobile Phone Whilst Driving None Park Hill Road, Harborne Park Hill Road, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
22094 op-snap---monthly-publication-october-2025.pdf   44 2025-10 Pedal Bike Land Rover Range Rover Grey Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
22097 op-snap---monthly-publication-october-2025.pdf   47 2025-10 Pedal Bike Tesla Model White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
22100 op-snap---monthly-publication-october-2025.pdf   50 2025-10 Pedal Bike Volvo V 40 Red Using a Mobile Phone Whilst Driving None Umberslade Road Umberslade Road Birmingham Birmingham Fixed Penalty N/A   52.4304526 -1.9216716
22106 op-snap---monthly-publication-october-2025.pdf   56 2025-10 Pedal Bike Kia Sportage Green Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
22109 op-snap---monthly-publication-october-2025.pdf   59 2025-10 Pedal Bike Mercedes-Benz A250 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
22148 op-snap---monthly-publication-october-2025.pdf   98 2025-10 Pedal Bike Audi TT. Blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22149 op-snap---monthly-publication-october-2025.pdf   99 2025-10 Pedal Bike Ford Transit White Using a Mobile Phone Whilst Driving None Pebble Mill Road Pebble Mill Road Birmingham Birmingham Fixed Penalty N/A   52.4512925 -1.9124618
22150 op-snap---monthly-publication-october-2025.pdf   100 2025-10 Pedal Bike Peugeot 508.. Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
22151 op-snap---monthly-publication-october-2025.pdf   101 2025-10 Pedal Bike Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22152 op-snap---monthly-publication-october-2025.pdf   102 2025-10 Pedal Bike Honda Civic Grey Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22168 op-snap---monthly-publication-october-2025.pdf   118 2025-10 Car Ford Focus Red Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Independent Evidence Available   52.471632 -1.9456776
22186 op-snap---monthly-publication-october-2025.pdf   136 2025-10 Pedal Bike Volkswagen CC Black Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22187 op-snap---monthly-publication-october-2025.pdf   137 2025-10 Pedal Bike Renault Traffic Green Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
22188 op-snap---monthly-publication-october-2025.pdf   138 2025-10 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None St Marys Road Street Marys Road Birmingham Birmingham Fixed Penalty N/A      
22189 op-snap---monthly-publication-october-2025.pdf   139 2025-10 Pedal Bike Mercedes-Benz GLA White Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543
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
22221 op-snap---monthly-publication-october-2025.pdf   171 2025-10 Car Seat Ibiza Silver Using a Mobile Phone Whilst Driving None Brays Road Brays Road Birmingham Birmingham NFA No Offence   52.4629816 -1.780277
22223 op-snap---monthly-publication-october-2025.pdf   173 2025-10 Car Renault   Grey Using a Mobile Phone Whilst Driving None Fox Hollies Road Fox Hollies Road Birmingham Birmingham NFA No Independent Evidence Available   52.5517052 -1.7825505
22230 op-snap---monthly-publication-october-2025.pdf   180 2025-10 Pedal Bike Kia Soul Blue Using a Mobile Phone Whilst Driving None Roman Way (Droitwich) Roman Way (Droitwich) Out of Force Area Out of Force Area NFA Out of Force      
22244 op-snap---monthly-publication-october-2025.pdf   194 2025-10 Car Lexus CT200H White Using a Mobile Phone Whilst Driving None UK Uk Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5019896 -2.0209184
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      
22273 op-snap---monthly-publication-october-2025.pdf   223 2025-10 Pedestrian BMW 320.. Beige Using a Mobile Phone Whilst Driving None Bishop Street Bishop Street Coventry Coventry Fixed Penalty N/A   52.411051 -1.5111644
22275 op-snap---monthly-publication-october-2025.pdf   225 2025-10 Car Seat Leon White Using a Mobile Phone Whilst Driving None New John St New John Street Birmingham Birmingham NFA No Independent Evidence Available   52.4920451 -1.8920402
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
22282 op-snap---monthly-publication-october-2025.pdf   232 2025-10 Car Man LDV Maxus White Using a Mobile Phone Whilst Driving None Goldthorn Hill Goldthorn Hill Wolverhampton Wolverhampton NFA Not in Public Interest   52.5690522 -2.1388773
22300 op-snap---monthly-publication-october-2025.pdf   250 2025-10 Pedestrian Lexus CT 200 H Grey Using a Mobile Phone Whilst Driving None A4400 Great Charles Street Queensway Great Charles Street Queensway Birmingham Birmingham Fixed Penalty N/A   52.4821283 -1.9037074
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
22321 op-snap---monthly-publication-october-2025.pdf   271 2025-10 Pedal Bike Mini Cooper Blue Using a Mobile Phone Whilst Driving None Icknield Port Road Icknield Port Road Birmingham Birmingham NFA No Independent Evidence Available   52.4792334 -1.92925
22338 op-snap---monthly-publication-october-2025.pdf   288 2025-10 Pedestrian Mercedes-Benz   Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22341 op-snap---monthly-publication-october-2025.pdf   291 2025-10 Pedal Bike Ford Focus Silver Using a Mobile Phone Whilst Driving None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham Fixed Penalty N/A   52.4580375 -1.9261777
22393 op-snap---monthly-publication-october-2025.pdf   343 2025-10 Pedal Bike Fiat 500 Grey Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22399 op-snap---monthly-publication-october-2025.pdf   349 2025-10 Pedal Bike BMW 118.. Grey Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
22400 op-snap---monthly-publication-october-2025.pdf   350 2025-10 Pedal Bike BMW 335I Black Using a Mobile Phone Whilst Driving None Harbourne Road Harborne Road Birmingham Birmingham Court N/A   52.4718503 -1.9195423
22402 op-snap---monthly-publication-october-2025.pdf   352 2025-10 Pedal Bike Toyota Aygo Green Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22412 op-snap---monthly-publication-october-2025.pdf   362 2025-10 Pedestrian Jaguar XJ50 Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22429 op-snap---monthly-publication-october-2025.pdf   379 2025-10 Pedal Bike Land Rover Range Rover Black Using a Mobile Phone Whilst Driving None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
22443 op-snap---monthly-publication-october-2025.pdf   393 2025-10 Pedal Bike Ford Kuga Grey Using a Mobile Phone Whilst Driving None Bell GreenRoad Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
22446 op-snap---monthly-publication-october-2025.pdf   396 2025-10 Motorbike Ford Transit Grey Using a Mobile Phone Whilst Driving None Black Country Route Black Country Route Wolverhampton Wolverhampton Fixed Penalty N/A   52.5642677 -2.0755469
22451 op-snap---monthly-publication-october-2025.pdf   401 2025-10 Pedestrian BMW X2 Blue Using a Mobile Phone Whilst Driving None Stoke Hospital Stoke Hospital Out of Force Area Out of Force Area NFA Out of Force      
22463 op-snap---monthly-publication-october-2025.pdf   413 2025-10 Car Ford Fiesta Blue Using a Mobile Phone Whilst Driving None A1M, Leeds A1M, Leeds Out of Force Area Out of Force Area NFA Out of Force      
22472 op-snap---monthly-publication-october-2025.pdf   422 2025-10 Pedal Bike Audi A3 Black Using a Mobile Phone Whilst Driving None Three Shires Oak Road Three Shires Oak Road Birmingham Birmingham Fixed Penalty N/A      
22478 op-snap---monthly-publication-october-2025.pdf   428 2025-10 Car Hyundai Tuscan Black Using a Mobile Phone Whilst Driving None Malvern Road, Worcester Malvern Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22502 op-snap---monthly-publication-october-2025.pdf   452 2025-10 Pedal Bike Toyota Aygo Black Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Warning Letter N/A   52.4398245 -1.8469786
22514 op-snap---monthly-publication-october-2025.pdf   464 2025-10 Car Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Chasepool Road Chasepool Road Out of Force Area Out of Force Area NFA Out of Force      
22515 op-snap---monthly-publication-october-2025.pdf   465 2025-10 Car Audi A3 White Using a Mobile Phone Whilst Driving None Wolverhampton Road Wolverhampton Road Walsall Walsall NFA No Independent Evidence Available   52.5867763 -2.0104342
22533 op-snap---monthly-publication-october-2025.pdf   483 2025-10 Pedal Bike Ford Fiesta Blue Using a Mobile Phone Whilst Driving None Russell Road Russell Road Birmingham Birmingham Fixed Penalty N/A   52.4398245 -1.8469786
22573 op-snap---monthly-publication-october-2025.pdf   523 2025-10 Pedal Bike Vauxhall mokka Black Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22574 op-snap---monthly-publication-october-2025.pdf   524 2025-10 Pedal Bike Mercedes-Benz 250 Red Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham Fixed Penalty N/A   52.4308271 -1.920078
22585 op-snap---monthly-publication-october-2025.pdf   535 2025-10 Pedal Bike Mini Cooper Silver Using a Mobile Phone Whilst Driving None Norfolk Road Norfolk Road Birmingham Birmingham Fixed Penalty N/A   52.4672547 -1.9435381
22589 op-snap---monthly-publication-october-2025.pdf   539 2025-10 Pedal Bike Seat Ibiza White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
22590 op-snap---monthly-publication-october-2025.pdf   540 2025-10 Pedal Bike Land Rover Evoque Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
22591 op-snap---monthly-publication-october-2025.pdf   541 2025-10 Pedal Bike Ford Focus Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
22600 op-snap---monthly-publication-october-2025.pdf   550 2025-10 Pedal Bike   Smart Red Using a Mobile Phone Whilst Driving None Lordwood Road Lordwood Road Birmingham Birmingham Fixed Penalty N/A      
22603 op-snap---monthly-publication-october-2025.pdf   553 2025-10 Pedal Bike Kia Sportage Grey Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
22604 op-snap---monthly-publication-october-2025.pdf   554 2025-10 Pedal Bike Audi A3 Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
22605 op-snap---monthly-publication-october-2025.pdf   555 2025-10 Pedal Bike Renault Capturd Grey Using a Mobile Phone Whilst Driving None Metchley lane Metchley lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
22615 op-snap---monthly-publication-october-2025.pdf   565 2025-10 Pedestrian Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Plough and Harrow Road Plough and Harrow Road Birmingham Birmingham Fixed Penalty N/A   52.5899123 -1.8057069
22639 op-snap---monthly-publication-october-2025.pdf   589 2025-10 Pedal Bike Toyota Avensis Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
22640 op-snap---monthly-publication-october-2025.pdf   590 2025-10 Pedal Bike Jaguar F Pace Black Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22641 op-snap---monthly-publication-october-2025.pdf   591 2025-10 Pedal Bike BMW X5 Black Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
22650 op-snap---monthly-publication-october-2025.pdf   600 2025-10 Car Toyota Yaris White Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
22653 op-snap---monthly-publication-october-2025.pdf   603 2025-10 Pedestrian Volkswagen Transporter White Using a Mobile Phone Whilst Driving None Plough and Harrow Road Plough and Harrow Road Birmingham Birmingham Warning Letter N/A   52.5899123 -1.8057069
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
22679 op-snap---monthly-publication-october-2025.pdf   629 2025-10 Pedal Bike Volkswagen Amorok Black Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
22689 op-snap---monthly-publication-october-2025.pdf   639 2025-10 Pedal Bike Mercedes-Benz clk200 Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
22691 op-snap---monthly-publication-october-2025.pdf   641 2025-10 Pedal Bike Volkswagen T Roc Grey Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
22692 op-snap---monthly-publication-october-2025.pdf   642 2025-10 Pedal Bike Kia Sportage Green Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
22693 op-snap---monthly-publication-october-2025.pdf   643 2025-10 Pedal Bike Volkswagen Transporter Grey Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543
22696 op-snap---monthly-publication-october-2025.pdf   646 2025-10 Car Mercedes-Benz AMG GLE Black Using a Mobile Phone Whilst Driving None Broadway North Broadway North Walsall Walsall Warning Letter N/A   52.5886007 -1.9741222
22704 op-snap---monthly-publication-october-2025.pdf   654 2025-10 Pedestrian Toyota Prius Grey Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
22719 op-snap---monthly-publication-october-2025.pdf   669 2025-10 Pedal Bike Ford Mustang Blue Using a Mobile Phone Whilst Driving None Leamington Road Leamington Road Coventry Coventry NFA No Independent Evidence Available   52.3921304 -1.5156601
22720 op-snap---monthly-publication-october-2025.pdf   670 2025-10 Pedal Bike Honda Jazz Grey Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Stoney Stanton Road Stoney Stanton Road Coventry Coventry Court N/A   52.4221152 -1.4959475
22735 op-snap---monthly-publication-october-2025.pdf   685 2025-10 Car Peugeot   Blue Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
22736 op-snap---monthly-publication-october-2025.pdf   686 2025-10 Car BMW 330i Grey Using a Mobile Phone Whilst Driving No vehicle excise licence Barbourne Road, Worcester Barbourne Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22743 op-snap---monthly-publication-october-2025.pdf   693 2025-10 Car Volkswagen Polo Silver Using a Mobile Phone Whilst Driving None M61 (Out of Force - Lancashire) M61 (Out of Force - Lancashire) Out of Force Area Out of Force Area NFA Out of Force      
22764 op-snap---monthly-publication-october-2025.pdf   714 2025-10 Pedal Bike Audi RS3 Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
22765 op-snap---monthly-publication-october-2025.pdf   715 2025-10 Pedal Bike Volkswagen Golf Red Using a Mobile Phone Whilst Driving None Highgate Middleway Highgate Middleway Birmingham Birmingham Fixed Penalty N/A   52.4661171 -1.8832818
22766 op-snap---monthly-publication-october-2025.pdf   716 2025-10 Pedal Bike Volkswagen Polo Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
22769 op-snap---monthly-publication-october-2025.pdf   719 2025-10 Car BMW 330e Black Using a Mobile Phone Whilst Driving None A6046 A6046 Out of Force Area Out of Force Area NFA Out of Force      
22774 op-snap---monthly-publication-october-2025.pdf   724 2025-10 Pedestrian Seat Ibiza Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
22776 op-snap---monthly-publication-october-2025.pdf   726 2025-10 Pedestrian Mercedes-Benz Citan White Using a Mobile Phone Whilst Driving None Springfield Road Springfield Road Birmingham Birmingham Fixed Penalty N/A   52.4327486 -1.8844997
22786 op-snap---monthly-publication-october-2025.pdf   736 2025-10 Other Rolls-Royce Cullinan Black Using a Mobile Phone Whilst Driving None UK Uk Birmingham Birmingham NFA No Independent Evidence Available   52.45124 -1.937937
22800 op-snap---monthly-publication-october-2025.pdf   750 2025-10 Pedestrian Mercedes-Benz   Grey Using a Mobile Phone Whilst Driving None Pleck Road Pleck Road Walsall Walsall NFA No Independent Evidence Available   52.5827033 -1.9960274
22812 op-snap---monthly-publication-october-2025.pdf   762 2025-10 Other BMW 430D Silver Using a Mobile Phone Whilst Driving None Moncrieffe St Moncrieffe Street Walsall Walsall NFA No Independent Evidence Available   52.5815341 -1.9691369
22822 op-snap---monthly-publication-october-2025.pdf   772 2025-10 Car Mitsubishi   Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Independent Evidence Available   52.471632 -1.9456776
22833 op-snap---monthly-publication-october-2025.pdf   783 2025-10 Car BMW M340d Grey Using a Mobile Phone Whilst Driving None Woodlands Road Woodlands Road Birmingham Birmingham NFA No Independent Evidence Available   52.444502 -1.8651818
22841 op-snap---monthly-publication-october-2025.pdf   791 2025-10 Pedal Bike Vauxhall   White Using a Mobile Phone Whilst Driving None A429 A429 Coventry Coventry Fixed Penalty N/A      
22842 op-snap---monthly-publication-october-2025.pdf   792 2025-10 Pedal Bike Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
22849 op-snap---monthly-publication-october-2025.pdf   799 2025-10 Pedal Bike Volvo EX40 Blue Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
22859 op-snap---monthly-publication-october-2025.pdf   809 2025-10 Car Ford Transit White Using a Mobile Phone Whilst Driving None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
22863 op-snap---monthly-publication-october-2025.pdf   813 2025-10 Pedal Bike Audi A4 Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
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
22879 op-snap---monthly-publication-october-2025.pdf   829 2025-10 Other Ford Transit Connect Grey Using a Mobile Phone Whilst Driving None Forth Avenue Forth Avenue Birmingham Birmingham Fixed Penalty N/A      
22891 op-snap---monthly-publication-october-2025.pdf   841 2025-10 Other Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Church Lane, Worcester Church Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22893 op-snap---monthly-publication-october-2025.pdf   843 2025-10 Pedal Bike Toyota Yaris Black Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543

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