home / opsnap

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

129 rows where council_area = "Birmingham", 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, nfa_rationale

vehicle_make 29

  • Toyota 18
  • BMW 16
  • Volkswagen 16
  • Mercedes-Benz 14
  • Audi 9
  • Ford 8
  • Vauxhall 5
  • Renault 4
  • Mg 3
  • Nissan 3
  • Seat 3
  • Skoda 3
  • Tesla 3
  • Citroen 2
  • Honda 2
  • Hyundai 2
  • Lexus 2
  • Mini 2
  • Peugeot 2
  • Volvo 2
  • Dacia 1
  • Fiat 1
  • Jaguar 1
  • Kia 1
  • Land Rover 1
  • Mazda 1
  • Mitsubishi 1
  • Scania 1
  • Suzuki 1

month 14

  • 2025-03 16
  • 2025-01 15
  • 2025-02 15
  • 2025-07 13
  • 2025-10 11
  • 2025-06 8
  • 2025-11 8
  • 2025-04 7
  • 2025-08 7
  • 2026-02 7
  • 2025-09 6
  • 2025-12 6
  • 2025-05 5
  • 2026-01 5

disposal 4

  • Fixed Penalty 94
  • NFA 21
  • Warning Letter 8
  • Court 6

reporter_transport_mode 1

  • Pedestrian · 129 ✖

offence 1

  • Using a Mobile Phone Whilst Driving · 129 ✖

council_area 1

  • Birmingham · 129 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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      
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
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
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
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
15664 op-snap---monthly-publication-june-2025.pdf   1593 2025-06 Pedestrian Volvo XC40 Black Using a Mobile Phone Whilst Driving None Duram Road Duram Road Birmingham Birmingham NFA No Independent Evidence Available      
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
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
20294 op-snap---monthly-publication-may-2025.pdf   1656 2025-05 Pedestrian Kia Sportage White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A   52.471632 -1.9456776
45 op-snap---monthly-publication-april-2025.pdf   44 2025-04 Pedestrian Citroen C4 White Using a Mobile Phone Whilst Driving None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
46 op-snap---monthly-publication-april-2025.pdf   45 2025-04 Pedestrian Volkswagen T-roc Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham NFA No Independent Evidence Available   52.471632 -1.9456776
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
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
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
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
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
17603 op-snap---monthly-publication-march-2025.pdf   1360 2025-03 Pedestrian Tesla   White Using a Mobile Phone Whilst Driving None Pershore Road Pershore Road Birmingham Birmingham NFA No Offence Yes - Via Email 52.4308271 -1.920078
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
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
18252 op-snap---monthly-publication-march-2025.pdf   2009 2025-03 Pedestrian Toyota Hi Ace Red Using a Mobile Phone Whilst Driving None Alum Rock Road Alum Rock Road Birmingham Birmingham NFA No Independent Evidence Available Yes - Via Email 52.4883936 -1.8310056
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
18450 op-snap---monthly-publication-march-2025.pdf   2207 2025-03 Pedestrian Seat Alhambra White Using a Mobile Phone Whilst Driving None Hurst Street Hurst Street Birmingham Birmingham NFA No Offence Yes - Via Email 52.4714381 -1.893243
18592 op-snap---monthly-publication-march-2025.pdf   2349 2025-03 Pedestrian Volkswagen Corsa Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4470686 -1.8880749
5533 op-snap---monthly-publication-february-2025.pdf   350 2025-02 Pedestrian Mercedes-Benz 300 Grey Using a Mobile Phone Whilst Driving None Upper Clifton Road Upper Clifton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5664481 -1.8270564

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