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

30 rows where month = "2025-09", offence = "Contravening a Red Traffic Light" and vehicle_make = "Toyota" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_model, vehicle_colour, offence_location_raw, offence_location, council_area_raw, nfa_rationale, latitude, longitude

council_area 6

  • Birmingham 15
  • Wolverhampton 6
  • Dudley 3
  • Walsall 3
  • Coventry 2
  • Out of Force Area 1

disposal 4

  • NFA 13
  • Fixed Penalty 7
  • Education 5
  • Warning Letter 5

reporter_transport_mode 3

  • Car 23
  • Pedestrian 6
  • Pedal Bike 1

vehicle_make 1

  • Toyota · 30 ✖

offence 1

  • Contravening a Red Traffic Light · 30 ✖

month 1

  • 2025-09 · 30 ✖
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
23782 op-snap---monthly-publication-september-2025.pdf   1 2025-09 Car Toyota Yaris Black Contravening a Red Traffic Light None Central Way, Merry Hill Central Way, Merry Hill Dudley Dudley NFA No Offence      
23824 op-snap---monthly-publication-september-2025.pdf   43 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
23836 op-snap---monthly-publication-september-2025.pdf   55 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Warning Letter N/A   52.5083238 -1.8332287
23901 op-snap---monthly-publication-september-2025.pdf   120 2025-09 Car Toyota Auris Blue Contravening a Red Traffic Light None Selly Oak Road Selly Oak Road Birmingham Birmingham NFA No Offence   52.4263875 -1.9397954
23934 op-snap---monthly-publication-september-2025.pdf   153 2025-09 Car Toyota Verso Silver Contravening a Red Traffic Light None Suffolk Street Suffolk Street Birmingham Birmingham Fixed Penalty N/A   52.4749336 -1.9003475
24007 op-snap---monthly-publication-september-2025.pdf   226 2025-09 Car Toyota yaris Red Contravening a Red Traffic Light None Northfied Road Northfied Road Birmingham Birmingham Education N/A      
24048 op-snap---monthly-publication-september-2025.pdf   267 2025-09 Car Toyota C-HR Silver Contravening a Red Traffic Light None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
24113 op-snap---monthly-publication-september-2025.pdf   332 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Lichfield Road Lichfield Road Walsall Walsall Fixed Penalty N/A   52.6095168 -2.0493009
24228 op-snap---monthly-publication-september-2025.pdf   447 2025-09 Pedal Bike Toyota Prius White Contravening a Red Traffic Light None Queen Victoria Road and Rover Road Queen Victoria Road and Rover Road Coventry Coventry Fixed Penalty N/A   52.4070937 -1.5157687
24259 op-snap---monthly-publication-september-2025.pdf   478 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24260 op-snap---monthly-publication-september-2025.pdf   479 2025-09 Car Toyota Prius Silver Contravening a Red Traffic Light None Witton Road Witton Road Birmingham Birmingham Fixed Penalty N/A   52.513336 -1.8833226
24269 op-snap---monthly-publication-september-2025.pdf   488 2025-09 Car Toyota   Blue Contravening a Red Traffic Light None Castle Gate Island Castle Gate Island Dudley Dudley NFA No Independent Evidence Available   52.5136155 -2.0733909
24452 op-snap---monthly-publication-september-2025.pdf   671 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Wolverhampton Road Wolverhampton Road Walsall Walsall Warning Letter N/A   52.5867763 -2.0104342
24478 op-snap---monthly-publication-september-2025.pdf   697 2025-09 Car Toyota Corrola White Contravening a Red Traffic Light None Drews Lane Drews Lane Birmingham Birmingham NFA No VRM   52.5005017 -1.8353248
24542 op-snap---monthly-publication-september-2025.pdf   761 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
24564 op-snap---monthly-publication-september-2025.pdf   783 2025-09 Car Toyota   Silver Contravening a Red Traffic Light None Sheepcote Street Sheepcote Street Birmingham Birmingham NFA No Independent Evidence Available   52.4770877 -1.9154767
24592 op-snap---monthly-publication-september-2025.pdf   811 2025-09 Car Toyota Prius Silver Contravening a Red Traffic Light None Watery Lane, Lichfield Watery Lane, Lichfield Out of Force Area Out of Force Area NFA Out of Force      
24612 op-snap---monthly-publication-september-2025.pdf   831 2025-09 Car Toyota CHR White Contravening a Red Traffic Light None Birmingham New Road (Burntree) Birmingham New Road (Burntree) Dudley Dudley Fixed Penalty N/A      
24645 op-snap---monthly-publication-september-2025.pdf   864 2025-09 Car Toyota CHR White Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Fixed Penalty N/A   52.4668753 -1.8996143
24659 op-snap---monthly-publication-september-2025.pdf   878 2025-09 Car Toyota Corolla White Contravening a Red Traffic Light None Bordesley Green Road at Arden Road Bordesley Green Road at Arden Road Birmingham Birmingham Fixed Penalty N/A   52.4804926 -1.8563658
24700 op-snap---monthly-publication-september-2025.pdf   919 2025-09 Car Toyota Yaros Silver Contravening a Red Traffic Light None Cole Hall Lane Cole Hall Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4877244 -1.787883
24707 op-snap---monthly-publication-september-2025.pdf   926 2025-09 Pedestrian Toyota   Black Contravening a Red Traffic Light None Bushbury Road Bushbury Road Wolverhampton Wolverhampton NFA No Offence   52.5988194 -2.1026037
24732 op-snap---monthly-publication-september-2025.pdf   951 2025-09 Car Toyota Yaris Silver Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
24755 op-snap---monthly-publication-september-2025.pdf   974 2025-09 Pedestrian Toyota Corolla Black Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
24787 op-snap---monthly-publication-september-2025.pdf   1006 2025-09 Car Toyota Corolla Silver Contravening a Red Traffic Light None Willenhall Road Willenhall Road Walsall Walsall Education N/A   52.5771198 -2.0320614
24858 op-snap---monthly-publication-september-2025.pdf   1077 2025-09 Pedestrian Toyota Yaris Grey Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24859 op-snap---monthly-publication-september-2025.pdf   1078 2025-09 Pedestrian Toyota Auris Blue Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24882 op-snap---monthly-publication-september-2025.pdf   1101 2025-09 Car Toyota Estima White Contravening a Red Traffic Light None Islington Row Middleway Islington Row Middleway Birmingham Birmingham Education N/A   52.4720132 -1.9142946
24886 op-snap---monthly-publication-september-2025.pdf   1105 2025-09 Pedestrian Toyota Estima White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365
24926 op-snap---monthly-publication-september-2025.pdf   1145 2025-09 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Cannock Road Cannock Road Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6083917 -2.1033365

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