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-01", offence = "Driving without Due Care and Attention" and vehicle_make = "Volkswagen" 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, latitude, longitude

council_area 7

  • Birmingham 15
  • Coventry 7
  • Dudley 3
  • Out Of Force Area 1
  • Out of Force Area 1
  • Sandwell 1
  • Walsall 1

disposal 5

  • Court 8
  • Fixed Penalty 8
  • Education 6
  • NFA 5
  • Warning Letter 2

reporter_transport_mode 4

  • Car 21
  • Pedal Bike 4
  • Pedestrian 2
  • car 2

vehicle_make 1

  • Volkswagen · 29 ✖

offence 1

  • Driving without Due Care and Attention · 29 ✖

month 1

  • 2025-01 · 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
8910 op-snap---monthly-publication-january-2025.pdf   18 2025-01 Pedal Bike Volkswagen POLO Black Driving without Due Care and Attention None HEATH LANE Heath Lane Dudley Dudley Education N/A Yes - Via Email 52.4495524 -2.1459067
8943 op-snap---monthly-publication-january-2025.pdf   51 2025-01 Car Volkswagen Golf Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4203897 -1.8338574
8987 op-snap---monthly-publication-january-2025.pdf   95 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Leamore Lane Leamore Lane Walsall Walsall Court N/A Yes - Via Email 52.6056653 -2.0050776
9063 op-snap---monthly-publication-january-2025.pdf   171 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None The Green, Kings Norton The Green, Kings Norton Birmingham Birmingham NFA No Offence Yes - Via Email 52.4065866 -1.9308921
9095 op-snap---monthly-publication-january-2025.pdf   203 2025-01 Car Volkswagen Sharan Black Driving without Due Care and Attention None Villa Road, Handsworth Villa Road, Handsworth Birmingham Birmingham Education N/A Yes - Via Email    
9109 op-snap---monthly-publication-january-2025.pdf   217 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Causeway Green Road Causeway Green Road Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.4831146 -2.0169818
9135 op-snap---monthly-publication-january-2025.pdf   243 2025-01 Car Volkswagen Passat Grey Driving without Due Care and Attention None Vanguard Avenue Vanguard Avenue Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4031729 -1.5564338
9363 op-snap---monthly-publication-january-2025.pdf   471 2025-01 car Volkswagen POLO Blue Driving without Due Care and Attention None SIX WAYS ROUNDABOUT,ASTON Six Ways Roundabout, Aston Birmingham Birmingham Warning Letter N/A Yes - Via Email    
9390 op-snap---monthly-publication-january-2025.pdf   498 2025-01 Car Volkswagen POLO Red Driving without Due Care and Attention None HAMSTEAD ROAD Hamstead Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.505832 -1.92002
9396 op-snap---monthly-publication-january-2025.pdf   504 2025-01 Car Volkswagen PASSAT Black Driving without Due Care and Attention None Park Road Park Road Dudley Dudley Court N/A Yes - Via Email 52.4566333 -2.1646355
9404 op-snap---monthly-publication-january-2025.pdf   512 2025-01 Car Volkswagen PASSAT Brown Driving without Due Care and Attention None LEAMINGTON ROAD Leamington Road Coventry Coventry Education N/A Yes - Via Email 52.3921304 -1.5156601
9444 op-snap---monthly-publication-january-2025.pdf   552 2025-01 Car Volkswagen Polo Blue Driving without Due Care and Attention None Weir Lane, Worcester Weir Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9619 op-snap---monthly-publication-january-2025.pdf   727 2025-01 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Quorn Way Quorn Way Coventry Coventry Education N/A Yes - Via Email 52.3934973 -1.4536866
9647 op-snap---monthly-publication-january-2025.pdf   755 2025-01 Car Volkswagen Passatt Silver Driving without Due Care and Attention None Birmingham Rd Birmingham Road Birmingham Birmingham Court N/A Yes - Via Email 52.5505398 -1.8252993
9664 op-snap---monthly-publication-january-2025.pdf   772 2025-01 Car Volkswagen Polo Blue Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A Yes - Via Email 52.4726661 -1.8769032
9897 op-snap---monthly-publication-january-2025.pdf   1005 2025-01 Car Volkswagen Golf White Driving without Due Care and Attention VRM fails to conform to Regulations Bordesley Middleway Bordesley Middleway Birmingham Birmingham Court N/A Yes - Via Email 52.4704236 -1.8769606
9946 op-snap---monthly-publication-january-2025.pdf   1054 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Grange Lane Grange Lane Dudley Dudley NFA No VRM Yes - Via Email 52.4505457 -2.1266938
9973 op-snap---monthly-publication-january-2025.pdf   1081 2025-01 Car Volkswagen Crafter White Driving without Due Care and Attention None Dunedin Road Dunedin Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5523958 -1.8871457
10002 op-snap---monthly-publication-january-2025.pdf   1110 2025-01 Pedal Bike Volkswagen TIGUAN White Driving without Due Care and Attention None Farnborough Road Farnborough Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5148331 -1.79231
10057 op-snap---monthly-publication-january-2025.pdf   1165 2025-01 Pedestrian Volkswagen Golf Grey Driving without Due Care and Attention None Foleshill Road/Arbury Avenue Foleshill Road/Arbury Avenue Coventry Coventry Education N/A Yes - Via Email 52.4253508 -1.5018457
10143 op-snap---monthly-publication-january-2025.pdf   1251 2025-01 Car Volkswagen Golf Grey Driving without Due Care and Attention No Insurance Water Orton Road Water Orton Road Birmingham Birmingham Court N/A Yes - Via Email 52.5153394 -1.7573409
10211 op-snap---monthly-publication-january-2025.pdf   1319 2025-01 Car Volkswagen Sharan Silver Driving without Due Care and Attention Use vehicle on a road without valid test c eBr4t1if2ic4a tteowards Hagley Road e Br4t1if2ic4a tteowards Hagley Road Birmingham Birmingham Court N/A Yes - Via Email    
10258 op-snap---monthly-publication-january-2025.pdf   1366 2025-01 Pedestrian Volkswagen Golf Black Driving without Due Care and Attention None Calthorpe Road Calthorpe Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5142235 -1.9073557
10275 op-snap---monthly-publication-january-2025.pdf   1383 2025-01 Car Volkswagen GOLF R Black Driving without Due Care and Attention None FLETCHAMSTEAD HIGHWAY Fletchamstead Highway Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.396476 -1.5561348
10297 op-snap---monthly-publication-january-2025.pdf   1405 2025-01 Car Volkswagen golf Blue Driving without Due Care and Attention None Queens Rd Queens Road Birmingham Birmingham NFA Misc Inc Crimes Yes - Via Email 52.4750331 -1.798374
10301 op-snap---monthly-publication-january-2025.pdf   1409 2025-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Kenpas Highway Kenpas Highway Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.3833661 -1.5265665
10304 op-snap---monthly-publication-january-2025.pdf   1412 2025-01 Car Volkswagen T-Roc Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A Yes - Via Email 52.4203897 -1.8338574
10348 op-snap---monthly-publication-january-2025.pdf   1456 2025-01 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention Keeping a vehicle with registration marks Sopbosncu Ernedd Sopbosncu Ernedd Coventry Coventry Court N/A Yes - Via Email    
10530 op-snap---monthly-publication-january-2025.pdf   1638 2025-01 car Volkswagen   White Driving without Due Care and Attention None Off force Off force Out of Force Area Out Of Force Area NFA Out of Force 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);