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

19 rows where council_area = "Sandwell", disposal = "Fixed Penalty" and vehicle_make = "Vauxhall" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, offence_location_raw, offence_location, latitude, longitude

month 10

  • 2025-02 6
  • 2025-01 3
  • 2025-04 2
  • 2025-09 2
  • 2025-03 1
  • 2025-05 1
  • 2025-06 1
  • 2025-08 1
  • 2026-01 1
  • 2026-02 1

offence 8

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 5
  • Using a Mobile Phone Whilst Driving 5
  • Cause vehicle to be left in a dangerous position 3
  • Contravening a Red Traffic Light 2
  • Contravene Lane Closure Red X 1
  • Driving without Due Care and Attention 1
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
  • No Insurance 1

reporter_transport_mode 4

  • Car 10
  • Pedestrian 7
  • Lorry 1
  • Pedal Bike 1

vehicle_make 1

  • Vauxhall · 19 ✖

disposal 1

  • Fixed Penalty · 19 ✖

council_area 1

  • Sandwell · 19 ✖
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
8093 op-snap---monthly-publication-february-2026.pdf   840 2026-02 Car Vauxhall Combo White Using a Mobile Phone Whilst Driving None M5 Jct 2 M5 Junction 2 Sandwell Sandwell Fixed Penalty N/A   52.4945433 -2.0190848
10669 op-snap---monthly-publication-january-2026.pdf   130 2026-01 Car Vauxhall Insignia Silver Using a Mobile Phone Whilst Driving None Hollyhedge Road Hollyhedge Road Sandwell Sandwell Fixed Penalty N/A   52.5360974 -1.9837968
24025 op-snap---monthly-publication-september-2025.pdf   244 2025-09 Car Vauxhall Combo Grey Using a Mobile Phone Whilst Driving None A491 Hagley Road, Stourbridge Hagley Road, Stourbridge Sandwell Sandwell Fixed Penalty N/A      
24083 op-snap---monthly-publication-september-2025.pdf   302 2025-09 Car Vauxhall Astra Grey Contravene Lane Closure Red X None Foundry Lane Smethwick Foundry Lane Smethwick Sandwell Sandwell Fixed Penalty N/A   52.4988697 -1.9484561
2718 op-snap---monthly-publication-august-2025.pdf   693 2025-08 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Mincing Lane Mincing Lane Sandwell Sandwell Fixed Penalty N/A   52.4830242 -2.0339971
14497 op-snap---monthly-publication-june-2025.pdf   426 2025-06 Lorry Vauxhall Vivaro Silver No Insurance None Stafford Road, Darlaston Stafford Road, Darlaston Sandwell Sandwell Fixed Penalty N/A      
18865 op-snap---monthly-publication-may-2025.pdf   227 2025-05 Car Vauxhall corsa Black Using a Mobile Phone Whilst Driving None Pound Road Pound Road Sandwell Sandwell Fixed Penalty N/A   52.5541213 -2.0098297
632 op-snap---monthly-publication-april-2025.pdf   631 2025-04 Pedestrian Vauxhall Astra Silver Cause vehicle to be left in a dangerous position None St Albans Road Street Albans Road Sandwell Sandwell Fixed Penalty N/A      
716 op-snap---monthly-publication-april-2025.pdf   715 2025-04 Car Vauxhall Vivaro White Contravening a Red Traffic Light None High Bullen High Bullen Sandwell Sandwell Fixed Penalty N/A   52.5532368 -2.0227385
17136 op-snap---monthly-publication-march-2025.pdf   893 2025-03 Pedal Bike Vauxhall Corsa Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Carrington Road Carrington Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5519066 -1.9860981
5643 op-snap---monthly-publication-february-2025.pdf   460 2025-02 Car Vauxhall Grandland Black Cause vehicle to be left in a dangerous position None Wheatley Road Oldbury Wheatley Road Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5187804 -2.0102148
6364 op-snap---monthly-publication-february-2025.pdf   1181 2025-02 Pedestrian Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road East Castle Road East Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4687472 -1.9893922
6928 op-snap---monthly-publication-february-2025.pdf   1745 2025-02 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road East Castle Road East Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4687472 -1.9893922
6932 op-snap---monthly-publication-february-2025.pdf   1749 2025-02 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ramsay Road Ramsay Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4723061 -1.9942558
7005 op-snap---monthly-publication-february-2025.pdf   1822 2025-02 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Castle Road East Castle Road East Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4687472 -1.9893922
7006 op-snap---monthly-publication-february-2025.pdf   1823 2025-02 Car Vauxhall Vivaro Silver Using a Mobile Phone Whilst Driving None Kingswinford Road Kingswinford Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
9725 op-snap---monthly-publication-january-2025.pdf   833 2025-01 Car Vauxhall Corsa White Contravening a Red Traffic Light None Junction with A41 Bypass Junction with A41 Bypass Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
10270 op-snap---monthly-publication-january-2025.pdf   1378 2025-01 Pedestrian Vauxhall ASTRA White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance ST ALBANS ROAD St Albans Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4979354 -1.9791633
10283 op-snap---monthly-publication-january-2025.pdf   1391 2025-01 Pedestrian Vauxhall Astra Black Cause vehicle to be left in a dangerous position None Clent Road, Oldbury Clent Road, Oldbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    

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