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

169 rows where disposal = "Fixed Penalty", 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, council_area_raw, witness_contacted

reporter_transport_mode 1

  • Pedestrian · 169 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 169 ✖

disposal 1

  • Fixed Penalty · 169 ✖
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
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
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
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
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
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
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
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
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
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
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      
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
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
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
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
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      
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
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
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
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
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
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
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
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
15653 op-snap---monthly-publication-june-2025.pdf   1582 2025-06 Pedestrian Nissan Micra Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
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
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
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
286 op-snap---monthly-publication-april-2025.pdf   285 2025-04 Pedestrian Vauxhall Mokka Black Using a Mobile Phone Whilst Driving None Poplar Road Kings Heath Poplar Road Kings Heath Birmingham Birmingham Fixed Penalty N/A   52.436035 -1.891685
351 op-snap---monthly-publication-april-2025.pdf   350 2025-04 Pedestrian Yamaha Taxi Black Using a Mobile Phone Whilst Driving None Lichfield Street Lichfield Street Walsall Walsall Fixed Penalty N/A   52.5882772 -1.9761264
429 op-snap---monthly-publication-april-2025.pdf   428 2025-04 Pedestrian Vauxhall Zafira Black Using a Mobile Phone Whilst Driving None Alcester Rd Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
673 op-snap---monthly-publication-april-2025.pdf   672 2025-04 Pedestrian Toyota Corrolla Black Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham Fixed Penalty N/A   52.4591339 -1.9601054
696 op-snap---monthly-publication-april-2025.pdf   695 2025-04 Pedestrian Volkswagen ID3 Blue Using a Mobile Phone Whilst Driving None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Fixed Penalty N/A   52.396476 -1.5561348
769 op-snap---monthly-publication-april-2025.pdf   768 2025-04 Pedestrian   Tivoli Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
832 op-snap---monthly-publication-april-2025.pdf   831 2025-04 Pedestrian Mercedes-Benz C300 Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
1069 op-snap---monthly-publication-april-2025.pdf   1068 2025-04 Pedestrian Volkswagen   Black Using a Mobile Phone Whilst Driving None Woodway Lane , Coventry Woodway Lane , Coventry Coventry Coventry Fixed Penalty N/A   52.4292329 -1.447102
1228 op-snap---monthly-publication-april-2025.pdf   1227 2025-04 Pedestrian Ford Fiesta Black Using a Mobile Phone Whilst Driving None Poplar Road , Kings Heath Poplar Road , Kings Heath Birmingham Birmingham Fixed Penalty N/A   52.436035 -1.891685
1587 op-snap---monthly-publication-april-2025.pdf   1586 2025-04 Pedestrian Ford Fiesta Silver Using a Mobile Phone Whilst Driving None 43 queens street 43 Queens Street Wolverhampton Wolverhampton Fixed Penalty N/A      
1714 op-snap---monthly-publication-april-2025.pdf   1713 2025-04 Pedestrian Mercedes-Benz 220D Silver 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
16273 op-snap---monthly-publication-march-2025.pdf   30 2025-03 Pedestrian Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Billesley Lane Billesley Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4344402 -1.8845368
16335 op-snap---monthly-publication-march-2025.pdf   92 2025-03 Pedestrian Vauxhall Vivaro White Using a Mobile Phone Whilst Driving None Daw End Lane at Lichfield Road Daw End Lane at Lichfield Road Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6057559 -1.9583791
16433 op-snap---monthly-publication-march-2025.pdf   190 2025-03 Pedestrian Land Rover Evoque Black Using a Mobile Phone Whilst Driving None Brookwillow Road Brookwillow Road Halesowen Halesowen Fixed Penalty N/A Yes - Via Email 52.4401092 -2.0748163
16614 op-snap---monthly-publication-march-2025.pdf   371 2025-03 Pedestrian Mercedes-Benz C200 Grey Using a Mobile Phone Whilst Driving None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
16621 op-snap---monthly-publication-march-2025.pdf   378 2025-03 Pedestrian Audi A6 Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
16917 op-snap---monthly-publication-march-2025.pdf   674 2025-03 Pedestrian Audi Q4 Grey Using a Mobile Phone Whilst Driving None The Plough and Harrow Road The Plough and Harrow Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5899123 -1.8057069
16982 op-snap---monthly-publication-march-2025.pdf   739 2025-03 Pedestrian   Hackney Carriage Black Using a Mobile Phone Whilst Driving None Northfield Road, Cotterdiege. Northfield Road, Cotterdiege Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17052 op-snap---monthly-publication-march-2025.pdf   809 2025-03 Pedestrian BMW 440 I Blue Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
17091 op-snap---monthly-publication-march-2025.pdf   848 2025-03 Pedestrian Renault Megane Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4381959 -1.8907391
17100 op-snap---monthly-publication-march-2025.pdf   857 2025-03 Pedestrian Mercedes-Benz Curtain side White Using a Mobile Phone Whilst Driving None A435 High Street, Kings Heath High Street, Kings Heath Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4353506 -1.8927483
17721 op-snap---monthly-publication-march-2025.pdf   1478 2025-03 Pedestrian Seat Ibiza White Using a Mobile Phone Whilst Driving None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17723 op-snap---monthly-publication-march-2025.pdf   1480 2025-03 Pedestrian Vauxhall Corsa Red Using a Mobile Phone Whilst Driving None Daw End Lane Daw End Lane Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6068849 -1.9611652
17840 op-snap---monthly-publication-march-2025.pdf   1597 2025-03 Pedestrian Dacia Sandera White Using a Mobile Phone Whilst Driving None Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4096725 -1.487901
18132 op-snap---monthly-publication-march-2025.pdf   1889 2025-03 Pedestrian Mercedes-Benz GLC 300 White Using a Mobile Phone Whilst Driving None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4720132 -1.9142946
18134 op-snap---monthly-publication-march-2025.pdf   1891 2025-03 Pedestrian Skoda Octavia White Using a Mobile Phone Whilst Driving None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4720132 -1.9142946
18158 op-snap---monthly-publication-march-2025.pdf   1915 2025-03 Pedestrian Porsche Macan Brown Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
18162 op-snap---monthly-publication-march-2025.pdf   1919 2025-03 Pedestrian Skoda Fabia Blue Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
18178 op-snap---monthly-publication-march-2025.pdf   1935 2025-03 Pedestrian Toyota MPV Silver Using a Mobile Phone Whilst Driving None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4720132 -1.9142946
18239 op-snap---monthly-publication-march-2025.pdf   1996 2025-03 Pedestrian Mercedes-Benz Smart Car Black Using a Mobile Phone Whilst Driving None Northfield Road, Cotteridge Northfield Road, Cotteridge Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4170842 -1.9346962
18268 op-snap---monthly-publication-march-2025.pdf   2025 2025-03 Pedestrian Citroen C1 Grey Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
18271 op-snap---monthly-publication-march-2025.pdf   2028 2025-03 Pedestrian Audi A3 Black Using a Mobile Phone Whilst Driving None Woodway Lane Woodway Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4275505 -1.4448681
18293 op-snap---monthly-publication-march-2025.pdf   2050 2025-03 Pedestrian Mg 4 Blue Using a Mobile Phone Whilst Driving None Aston Webb Blvd Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4468506 -1.9395619

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