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

237 rows where offence = "Using a Mobile Phone Whilst Driving" and reporter_transport_mode = "Pedestrian" 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

reporter_transport_mode 1

  • Pedestrian · 237 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 237 ✖
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
7416 op-snap---monthly-publication-february-2026.pdf   163 2026-02 Pedestrian Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Green Lane Green Lane Birmingham Birmingham Fixed Penalty N/A   52.4618966 -1.9955421
7602 op-snap---monthly-publication-february-2026.pdf   349 2026-02 Pedestrian Mg HS.. White Using a Mobile Phone Whilst Driving None Calthorpe Road Calthorpe Road Birmingham Birmingham Fixed Penalty N/A   52.5142235 -1.9073557
7859 op-snap---monthly-publication-february-2026.pdf   606 2026-02 Pedestrian Hyundai Ioniq Grey Using a Mobile Phone Whilst Driving None Park Street Park Street Birmingham Birmingham Fixed Penalty N/A   52.4814275 -1.8888778
8325 op-snap---monthly-publication-february-2026.pdf   1072 2026-02 Pedestrian BMW 1 White Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
8328 op-snap---monthly-publication-february-2026.pdf   1075 2026-02 Pedestrian Mercedes-Benz C220 Silver Using a Mobile Phone Whilst Driving None Bushbury Lane Bushbury Lane Wolverhampton Wolverhampton Fixed Penalty N/A   52.6107589 -2.1231693
8342 op-snap---monthly-publication-february-2026.pdf   1089 2026-02 Pedestrian Ford Etransit White Using a Mobile Phone Whilst Driving None Woodleigh Avenue Woodleigh Avenue Birmingham Birmingham Fixed Penalty N/A   52.4501564 -1.9468853
8539 op-snap---monthly-publication-february-2026.pdf   1286 2026-02 Pedestrian Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
8653 op-snap---monthly-publication-february-2026.pdf   1400 2026-02 Pedestrian Volkswagen golf Black Using a Mobile Phone Whilst Driving Use vehicle on a road without valid test certificate Friston Avenue Friston Avenue Birmingham Birmingham Court N/A   52.4744592 -1.9198786
10636 op-snap---monthly-publication-january-2026.pdf   97 2026-01 Pedestrian Porsche Cayman Blue Using a Mobile Phone Whilst Driving None Merry Hill Car Park Merry Hill Car Park Dudley Dudley NFA No Independent Evidence Available      
10754 op-snap---monthly-publication-january-2026.pdf   215 2026-01 Pedestrian Scania   White Using a Mobile Phone Whilst Driving None Hagley Road near Highfield Road Hagley Road near Highfield Road Birmingham Birmingham Fixed Penalty N/A   52.471836 -1.9401037
10855 op-snap---monthly-publication-january-2026.pdf   316 2026-01 Pedestrian Volkswagen Polo Red Using a Mobile Phone Whilst Driving None Ninevah Road Ninevah Road Birmingham Birmingham NFA No Independent Evidence Available      
10955 op-snap---monthly-publication-january-2026.pdf   416 2026-01 Pedestrian Skoda Rapid blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
11052 op-snap---monthly-publication-january-2026.pdf   513 2026-01 Pedestrian Audi A5 White Using a Mobile Phone Whilst Driving None Silver Street Silver Street Birmingham Birmingham NFA No Independent Evidence Available   52.433129 -1.8963794
11090 op-snap---monthly-publication-january-2026.pdf   551 2026-01 Pedestrian Renault Clio Blue Using a Mobile Phone Whilst Driving None out of force blackpool Out Of Force Blackpool Out of Force Area Out of Force Area NFA Out of Force      
11378 op-snap---monthly-publication-january-2026.pdf   839 2026-01 Pedestrian Land Rover Discovery Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11380 op-snap---monthly-publication-january-2026.pdf   841 2026-01 Pedestrian Audi Q5 Grey Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11919 op-snap---monthly-publication-january-2026.pdf   1380 2026-01 Pedestrian Seat Ateca Grey Using a Mobile Phone Whilst Driving None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A   52.4726661 -1.8769032
3890 op-snap---monthly-publication-december-2025.pdf   18 2025-12 Pedestrian Tesla Model Y White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
3986 op-snap---monthly-publication-december-2025.pdf   114 2025-12 Pedestrian Mini Clubman Red Using a Mobile Phone Whilst Driving None Plough and Harrow Rd twds Hagle Plough and Harrow Road twds Hagle yB Riromaidngham Yb Riromaidngham Fixed Penalty N/A   52.5287826 -1.7759635
4055 op-snap---monthly-publication-december-2025.pdf   183 2025-12 Pedestrian Ford   Yellow Using a Mobile Phone Whilst Driving None Mallards Close Mallards Close Out of Force Area Out of Force Area NFA Out of Force      
4344 op-snap---monthly-publication-december-2025.pdf   472 2025-12 Pedestrian Toyota Prius white Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4346 op-snap---monthly-publication-december-2025.pdf   474 2025-12 Pedestrian Peugeot 2008 Black Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4389 op-snap---monthly-publication-december-2025.pdf   517 2025-12 Pedestrian Mini Cooper Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
4839 op-snap---monthly-publication-december-2025.pdf   967 2025-12 Pedestrian Volkswagen Sharan Red Using a Mobile Phone Whilst Driving None Green lane Green lane Birmingham Birmingham Fixed Penalty N/A   52.4618966 -1.9955421
4858 op-snap---monthly-publication-december-2025.pdf   986 2025-12 Pedestrian BMW M8 Black Using a Mobile Phone Whilst Driving None Regent Place Regent Place Birmingham Birmingham Fixed Penalty N/A   52.4860376 -1.9095854
20566 op-snap---monthly-publication-november-2025.pdf   108 2025-11 Pedestrian Dacia sandro Grey Using a Mobile Phone Whilst Driving None Shenley Lane Shenley Lane Birmingham Birmingham NFA No Independent Evidence Available   52.430111 -1.9753703
20618 op-snap---monthly-publication-november-2025.pdf   160 2025-11 Pedestrian Renault Megane Grey Using a Mobile Phone Whilst Driving None Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
20683 op-snap---monthly-publication-november-2025.pdf   225 2025-11 Pedestrian Nissan Note Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
20982 op-snap---monthly-publication-november-2025.pdf   524 2025-11 Pedestrian Suzuki Celerio White Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
21552 op-snap---monthly-publication-november-2025.pdf   1094 2025-11 Pedestrian Toyota Aygo White Using a Mobile Phone Whilst Driving None Hagley Road, Birmingham Hagley Road, Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4720702 -1.9367526
21565 op-snap---monthly-publication-november-2025.pdf   1107 2025-11 Pedestrian Audi A1 Black Using a Mobile Phone Whilst Driving None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A   52.4720132 -1.9142946
21566 op-snap---monthly-publication-november-2025.pdf   1108 2025-11 Pedestrian Kia Sportage Blue Using a Mobile Phone Whilst Driving None Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A   52.4096725 -1.487901
21579 op-snap---monthly-publication-november-2025.pdf   1121 2025-11 Pedestrian Volkswagen ID4 Grey Using a Mobile Phone Whilst Driving None Heaton Road, Solihull Heaton Road, Solihull Solihull Solihull Fixed Penalty N/A   52.4284827 -1.7951002
21586 op-snap---monthly-publication-november-2025.pdf   1128 2025-11 Pedestrian Nissan Micra Silver Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham Fixed Penalty N/A   52.4298554 -1.9086629
22011 op-snap---monthly-publication-november-2025.pdf   1553 2025-11 Pedestrian Tesla Model 3 Grey Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
22012 op-snap---monthly-publication-november-2025.pdf   1554 2025-11 Pedestrian Lexus NH Black Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham Fixed Penalty N/A   52.4543565 -1.9114004
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
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
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
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
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
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      
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
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
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
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
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
22943 op-snap---monthly-publication-october-2025.pdf   893 2025-10 Pedestrian Toyota Prius Silver Using a Mobile Phone Whilst Driving None Trinity Road Trinity Road Birmingham Birmingham NFA No Independent Evidence Available   52.5812323 -1.8234706
23061 op-snap---monthly-publication-october-2025.pdf   1011 2025-10 Pedestrian Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Plough & Harrow Road Plough & Harrow Road Birmingham Birmingham Fixed Penalty N/A   52.4736525 -1.9304206
23062 op-snap---monthly-publication-october-2025.pdf   1012 2025-10 Pedestrian Volkswagen Golf 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
24073 op-snap---monthly-publication-september-2025.pdf   292 2025-09 Pedestrian Fiat Doblo White Using a Mobile Phone Whilst Driving None Allesley Old Road Allesley Old Road Coventry Coventry Fixed Penalty N/A   52.4103629 -1.5441218
24117 op-snap---monthly-publication-september-2025.pdf   336 2025-09 Pedestrian Hyundai Tucson Black Using a Mobile Phone Whilst Driving None Raddlebarn Lane Raddlebarn Lane Birmingham Birmingham Warning Letter N/A   52.4372473 -1.939828
24177 op-snap---monthly-publication-september-2025.pdf   396 2025-09 Pedestrian Nissan Micra Green Using a Mobile Phone Whilst Driving No Seat Belt Littleton Street West Littleton Street West Walsall Walsall Other Action Taken N/A   52.588379 -1.9843635
24283 op-snap---monthly-publication-september-2025.pdf   502 2025-09 Pedestrian BMW 1 series Black Using a Mobile Phone Whilst Driving None Roundabout of Springfild Rd, Poplar Road, Kings Heath Roundabout of Springfild Road, Poplar Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A      
24500 op-snap---monthly-publication-september-2025.pdf   719 2025-09 Pedestrian BMW 1 series White Using a Mobile Phone Whilst Driving None Vicarage Road, Kings Heath Vicarage Road, Kings Heath Birmingham Birmingham NFA No VRM   52.4301512 -1.8996659
24572 op-snap---monthly-publication-september-2025.pdf   791 2025-09 Pedestrian     White Using a Mobile Phone Whilst Driving None Baron Avenue, Kettering Baron Avenue, Kettering Out of Force Area Out of Force Area NFA Out of Force      
24576 op-snap---monthly-publication-september-2025.pdf   795 2025-09 Pedestrian Land Rover   Black Using a Mobile Phone Whilst Driving None Walsall Road Walsall Road Walsall Walsall NFA No VRM   52.6166864 -1.9660822
24611 op-snap---monthly-publication-september-2025.pdf   830 2025-09 Pedestrian Toyota Corolla Grey Using a Mobile Phone Whilst Driving None Friston Avenue Friston Avenue Birmingham Birmingham Fixed Penalty N/A   52.4744592 -1.9198786
24733 op-snap---monthly-publication-september-2025.pdf   952 2025-09 Pedestrian Land Rover Sport Grey Using a Mobile Phone Whilst Driving None Widney Lane Widney Lane Solihull Solihull Fixed Penalty N/A   52.3975737 -1.7857722
24751 op-snap---monthly-publication-september-2025.pdf   970 2025-09 Pedestrian Ford Transit White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
24801 op-snap---monthly-publication-september-2025.pdf   1020 2025-09 Pedestrian Audi Q5 White Using a Mobile Phone Whilst Driving None Binley Road Binley Road Coventry Coventry Fixed Penalty N/A   52.4070602 -1.4732469
24845 op-snap---monthly-publication-september-2025.pdf   1064 2025-09 Pedestrian Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Sherlock Street Sherlock Street Birmingham Birmingham NFA No Independent Evidence Available   52.4702385 -1.895011
24913 op-snap---monthly-publication-september-2025.pdf   1132 2025-09 Pedestrian Mercedes-Benz   Yellow Using a Mobile Phone Whilst Driving None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
2204 op-snap---monthly-publication-august-2025.pdf   179 2025-08 Pedestrian Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Hadley Road Hadley Road Birmingham Birmingham Court N/A   52.4419793 -1.9297441
2268 op-snap---monthly-publication-august-2025.pdf   243 2025-08 Pedestrian Toyota Corolla Black Using a Mobile Phone Whilst Driving None Broad Street Broad Street Birmingham Birmingham Fixed Penalty N/A   52.4749212 -1.9147497
2344 op-snap---monthly-publication-august-2025.pdf   319 2025-08 Pedestrian Ford Transit White Using a Mobile Phone Whilst Driving None Hagley Road West Hagley Road West Birmingham Birmingham NFA No Independent Evidence Available   52.4656414 -1.9852276
2481 op-snap---monthly-publication-august-2025.pdf   456 2025-08 Pedestrian Renault Traffic White Using a Mobile Phone Whilst Driving None Radford Road Radford Road Coventry Coventry Fixed Penalty N/A   52.4235908 -1.5226276
2793 op-snap---monthly-publication-august-2025.pdf   768 2025-08 Pedestrian Volkswagen   Black Using a Mobile Phone Whilst Driving None South Bank Road South Bank Road Coventry Coventry NFA Misc Inc Crimes      
2794 op-snap---monthly-publication-august-2025.pdf   769 2025-08 Pedestrian Mercedes-Benz A Class Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Independent Evidence Available   52.471632 -1.9456776
2864 op-snap---monthly-publication-august-2025.pdf   839 2025-08 Pedestrian Peugeot E 3008 White Using a Mobile Phone Whilst Driving None Warwick Road Warwick Road Birmingham Birmingham Fixed Penalty N/A   52.4555288 -1.8613929
2994 op-snap---monthly-publication-august-2025.pdf   969 2025-08 Pedestrian BMW 1 Series Grey Using a Mobile Phone Whilst Driving None Woodstock Road Woodstock Road Birmingham Birmingham Fixed Penalty N/A   52.4486205 -1.8740822
3131 op-snap---monthly-publication-august-2025.pdf   1106 2025-08 Pedestrian Volvo Tipper White Using a Mobile Phone Whilst Driving None Hilmorton Road Hilmorton Road Solihull Solihull NFA No Offence      
3816 op-snap---monthly-publication-august-2025.pdf   1791 2025-08 Pedestrian Audi A3 Black Using a Mobile Phone Whilst Driving None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
12058 op-snap---monthly-publication-july-2025.pdf   110 2025-07 Pedestrian Seat Leon White Using a Mobile Phone Whilst Driving None A46 A46 Coventry Coventry Fixed Penalty N/A      
12205 op-snap---monthly-publication-july-2025.pdf   257 2025-07 Pedestrian Toyota Corolla White Using a Mobile Phone Whilst Driving None Stephenson Street Stephenson Street Birmingham Birmingham NFA No Independent Evidence Available   52.4787219 -1.9004997
12251 op-snap---monthly-publication-july-2025.pdf   303 2025-07 Pedestrian Toyota Yaris Blue Using a Mobile Phone Whilst Driving None Charles Road Charles Road Birmingham Birmingham Fixed Penalty N/A   52.5094492 -1.9113648
12252 op-snap---monthly-publication-july-2025.pdf   304 2025-07 Pedestrian Ford Ranger Grey Using a Mobile Phone Whilst Driving None Grange Road Grange Road Solihull Solihull Fixed Penalty N/A   52.4285724 -1.8019101
12254 op-snap---monthly-publication-july-2025.pdf   306 2025-07 Pedestrian Toyota Aygo Green Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham Fixed Penalty N/A   52.4298554 -1.9086629
12255 op-snap---monthly-publication-july-2025.pdf   307 2025-07 Pedestrian Audi A6 White Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham NFA No Independent Evidence Available   52.4298554 -1.9086629
12257 op-snap---monthly-publication-july-2025.pdf   309 2025-07 Pedestrian Mercedes-Benz A200 Blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
12259 op-snap---monthly-publication-july-2025.pdf   311 2025-07 Pedestrian Volkswagen Up Blue 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
12272 op-snap---monthly-publication-july-2025.pdf   324 2025-07 Pedestrian Honda FSH125 White Using a Mobile Phone Whilst Driving None Moore Streer Moore Streer Birmingham Birmingham NFA No Offence      
12377 op-snap---monthly-publication-july-2025.pdf   429 2025-07 Pedestrian BMW X5 Grey Using a Mobile Phone Whilst Driving None M6 South M6 South Wolverhampton Wolverhampton Fixed Penalty N/A   52.5649086 -2.1705292
12476 op-snap---monthly-publication-july-2025.pdf   528 2025-07 Pedestrian Audi SQ5 Black Using a Mobile Phone Whilst Driving None A458 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
12552 op-snap---monthly-publication-july-2025.pdf   604 2025-07 Pedestrian BMW 320d Blue Using a Mobile Phone Whilst Driving None Wrentham Street Wrentham Street Birmingham Birmingham Fixed Penalty N/A   52.4708757 -1.8966158
12599 op-snap---monthly-publication-july-2025.pdf   651 2025-07 Pedestrian BMW 118.. Grey 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
12673 op-snap---monthly-publication-july-2025.pdf   725 2025-07 Pedestrian Renault Zoe 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
12773 op-snap---monthly-publication-july-2025.pdf   825 2025-07 Pedestrian Toyota   White Using a Mobile Phone Whilst Driving None Fazeley Street Fazeley Street Birmingham Birmingham NFA No Offence   52.4798316 -1.8863917
12903 op-snap---monthly-publication-july-2025.pdf   955 2025-07 Pedestrian BMW 320D Black Using a Mobile Phone Whilst Driving None High Street, Harborne High Street, Harborne Birmingham Birmingham Fixed Penalty N/A   52.4612733 -1.9430543
12906 op-snap---monthly-publication-july-2025.pdf   958 2025-07 Pedestrian Volkswagen Tiguan Silver Using a Mobile Phone Whilst Driving None Moseley Road, Willenhall Moseley Road, Willenhall Wolverhampton Wolverhampton Warning Letter N/A   52.5735847 -2.061316
13048 op-snap---monthly-publication-july-2025.pdf   1100 2025-07 Pedestrian Toyota Verso Black Using a Mobile Phone Whilst Driving None Heath Way Heath Way Birmingham Birmingham Fixed Penalty N/A   52.4963549 -1.7806171
13900 op-snap---monthly-publication-july-2025.pdf   1952 2025-07 Pedestrian Volkswagen Tcross White Using a Mobile Phone Whilst Driving None unknown   Out of Force Area Out of Force Area Warning Letter N/A      
14091 op-snap---monthly-publication-june-2025.pdf   20 2025-06 Pedestrian BMW X1 White Using a Mobile Phone Whilst Driving None alcester Road alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
14254 op-snap---monthly-publication-june-2025.pdf   183 2025-06 Pedestrian Mercedes-Benz A180 Brown Using a Mobile Phone Whilst Driving None Islington Row Islington Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
14355 op-snap---monthly-publication-june-2025.pdf   284 2025-06 Pedestrian Audi A3 Grey 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
14537 op-snap---monthly-publication-june-2025.pdf   466 2025-06 Pedestrian BMW 116d Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
14857 op-snap---monthly-publication-june-2025.pdf   786 2025-06 Pedestrian Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
15123 op-snap---monthly-publication-june-2025.pdf   1052 2025-06 Pedestrian Volkswagen transporter Yellow Using a Mobile Phone Whilst Driving None Gooch Street Gooch Street Birmingham Birmingham Fixed Penalty N/A   52.4686609 -1.8945007
15515 op-snap---monthly-publication-june-2025.pdf   1444 2025-06 Pedestrian Citroen Berlingo White Using a Mobile Phone Whilst Driving None Cranhall Lane Cranhall Lane Sandwell Sandwell NFA No Independent Evidence Available      

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