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

29 rows where month = "2025-02", offence = "Contravening a Red Traffic Light" and vehicle_make = "Ford" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

council_area 8

  • Birmingham 12
  • Walsall 5
  • Sandwell 4
  • Coventry 2
  • Out of Force Area 2
  • Wolverhampton 2
  • Dudley 1
  • Sutton Coldfield 1

reporter_transport_mode 6

  • Car 22
  • Pedestrian 3
  • Bus 1
  • Lorry 1
  • Motorbike 1
  • Pedal Bike 1

disposal 5

  • Fixed Penalty 12
  • Education 10
  • NFA 3
  • Warning Letter 3
  • Court 1

vehicle_make 1

  • Ford · 29 ✖

offence 1

  • Contravening a Red Traffic Light · 29 ✖

month 1

  • 2025-02 · 29 ✖
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
5206 op-snap---monthly-publication-february-2025.pdf   23 2025-02 Car Ford Focus Blue Contravening a Red Traffic Light None Gressel Lane Gressel Lane Birmingham Birmingham NFA No VRM Yes - Via Email 52.4839418 -1.7623613
5208 op-snap---monthly-publication-february-2025.pdf   25 2025-02 Car Ford Transit White Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4552785 -1.906384
5222 op-snap---monthly-publication-february-2025.pdf   39 2025-02 Car Ford Transit Black Contravening a Red Traffic Light None B4137 Cuckoo Road Cuckoo Road Birmingham Birmingham Education N/A Yes - Via Email 52.5049023 -1.8603659
5224 op-snap---monthly-publication-february-2025.pdf   41 2025-02 Car Ford FIESTA Black Contravening a Red Traffic Light Driving without Due Care and Attention BRADLEYS LANE Bradleys Lane Sandwell Sandwell Court N/A Yes - Via Email    
5300 op-snap---monthly-publication-february-2025.pdf   117 2025-02 Car Ford Fiesta Silver Contravening a Red Traffic Light None Brandwood Park Road Brandwood Park Road Birmingham Birmingham Education N/A Yes - Via Email 52.4138206 -1.9041686
5322 op-snap---monthly-publication-february-2025.pdf   139 2025-02 Pedal Bike Ford KUGA Grey Contravening a Red Traffic Light None HAGLEY ROAD Hagley Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.471632 -1.9456776
5620 op-snap---monthly-publication-february-2025.pdf   437 2025-02 Car Ford Transit White Contravening a Red Traffic Light None Long Bank Long Bank Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5785967 -2.0581007
5741 op-snap---monthly-publication-february-2025.pdf   558 2025-02 Car Ford Fiesta White Contravening a Red Traffic Light None Bordesley Circus Bordesley Circus Birmingham Birmingham Education N/A Yes - Via Email 52.4728608 -1.8754722
5939 op-snap---monthly-publication-february-2025.pdf   756 2025-02 Car Ford Focus Grey Contravening a Red Traffic Light None Shenley Lane Shenley Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Telephone 52.430111 -1.9753703
5967 op-snap---monthly-publication-february-2025.pdf   784 2025-02 Car Ford Fiesta White Contravening a Red Traffic Light None Bloxwich Lane, Walsall Bloxwich Lane, Walsall Walsall Walsall Education N/A Yes - Via Email 52.6020474 -2.014682
5998 op-snap---monthly-publication-february-2025.pdf   815 2025-02 Car Ford Fiesta Silver Contravening a Red Traffic Light None A456 Kidderminster Road Hagley Kidderminster Road Hagley Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
6184 op-snap---monthly-publication-february-2025.pdf   1001 2025-02 Car Ford Transit Red Contravening a Red Traffic Light None Newton Road Great Barr Newton Road Great Barr Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5428813 -1.9551642
6193 op-snap---monthly-publication-february-2025.pdf   1010 2025-02 Car Ford Transit White Contravening a Red Traffic Light No Insurance Lichfield Road Walsall Lichfield Road Walsall Walsall Walsall Fixed Penalty N/A Yes - Via Email 52.6099659 -2.0445263
6204 op-snap---monthly-publication-february-2025.pdf   1021 2025-02 Pedestrian Ford Transit Blue Contravening a Red Traffic Light None Daw End Lane, Walsall Daw End Lane, Walsall Walsall Walsall Warning Letter N/A Yes - Via Email 52.6070366 -1.96132
6273 op-snap---monthly-publication-february-2025.pdf   1090 2025-02 Pedestrian Ford Focus Blue Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Education N/A Yes - Via Email 52.6068849 -1.9611652
6276 op-snap---monthly-publication-february-2025.pdf   1093 2025-02 Pedestrian Ford Transit White Contravening a Red Traffic Light None Daw End Lane Daw End Lane Walsall Walsall Education N/A Yes - Via Email 52.6068849 -1.9611652
6340 op-snap---monthly-publication-february-2025.pdf   1157 2025-02 Car Ford Mondeo Blue Contravening a Red Traffic Light None Stroubrdige Road Dudley Stroubrdige Road Dudley Dudley Dudley Education N/A Yes - Via Email    
6397 op-snap---monthly-publication-february-2025.pdf   1214 2025-02 Car Ford C-Max Silver Contravening a Red Traffic Light None Boldmere Road, jn Jockey Road Boldmere Road, jn Jockey Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email    
6449 op-snap---monthly-publication-february-2025.pdf   1266 2025-02 Bus Ford Transit Silver Contravening a Red Traffic Light None M^ Slip J9 Wednesbury M^ Slip J9 Wednesbury Sandwell Sandwell Fixed Penalty N/A Yes - Via Email    
6488 op-snap---monthly-publication-february-2025.pdf   1305 2025-02 Motorbike Ford FOCUS Red Contravening a Red Traffic Light None BELLS LANE Bells Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4053419 -1.8944602
6779 op-snap---monthly-publication-february-2025.pdf   1596 2025-02 Car Ford Puma Black Contravening a Red Traffic Light None Aldridge Road Aldridge Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5368764 -1.8976461
6788 op-snap---monthly-publication-february-2025.pdf   1605 2025-02 Car Ford Kuga Blue Contravening a Red Traffic Light None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.473883 -1.9198244
6803 op-snap---monthly-publication-february-2025.pdf   1620 2025-02 Car Ford Focus White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5113867 -1.8337258
6904 op-snap---monthly-publication-february-2025.pdf   1721 2025-02 Car Ford KUGA Black Contravening a Red Traffic Light None ST ANDREWS RING ROAD St Andrews Ring Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email    
6933 op-snap---monthly-publication-february-2025.pdf   1750 2025-02 Car Ford van White Contravening a Red Traffic Light None High Street, Brierley Hill High Street, Brierley Hill Sandwell Sandwell Education N/A Yes - Via Email    
7123 op-snap---monthly-publication-february-2025.pdf   1940 2025-02 Lorry Ford Transit White Contravening a Red Traffic Light None London Road A45 London Road A45 Coventry Coventry Warning Letter N/A Yes - Via Email 52.3766914 -1.463664
7148 op-snap---monthly-publication-february-2025.pdf   1965 2025-02 Car Ford KA Black Contravening a Red Traffic Light None NEW BIRMINGHAM ROAD New Birmingham Road Wolverhampton Wolverhampton Fixed Penalty N/A Yes - Via Email 52.549727 -2.0955847
7165 op-snap---monthly-publication-february-2025.pdf   1982 2025-02 Car Ford Fiesta Green Contravening a Red Traffic Light None Brinklow Road Brinklow Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4028059 -1.4461048
7239 op-snap---monthly-publication-february-2025.pdf   2056 2025-02 Car Ford Fiesta Blue Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Education N/A Yes - Via Email 52.5919543 -1.8517118

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