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

25 rows where month = "2025-01", reporter_transport_mode = "Pedal Bike" 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

offence 8

  • Driving without Reasonable Consideration 9
  • Using a Mobile Phone Whilst Driving 5
  • Stop a vehicle within pelican pedestrian crossing limits 4
  • Contravening a Red Traffic Light 2
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Driving without Due Care and Attention 1
  • Stop a vehicle on pedestrian crossing 1
  • Use a vehicle / cycle on a road and contravene a local traffic order other than parking 1

disposal 5

  • Education 11
  • Fixed Penalty 10
  • NFA 2
  • Court 1
  • Warning Letter 1

council_area 5

  • Coventry 12
  • Birmingham 9
  • Out of Force Area 2
  • Dudley 1
  • Sutton Coldfield 1

vehicle_make 1

  • Toyota · 25 ✖

reporter_transport_mode 1

  • Pedal Bike · 25 ✖

month 1

  • 2025-01 · 25 ✖
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
8905 op-snap---monthly-publication-january-2025.pdf   13 2025-01 Pedal Bike Toyota Prius White Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road, Coventry Stoney Stanton Road, Coventry Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
8945 op-snap---monthly-publication-january-2025.pdf   53 2025-01 Pedal Bike Toyota MPV Black Stop a vehicle on pedestrian crossing None Pershore Road Pershore Road Birmingham Birmingham Education N/A Yes - Via Email 52.4308271 -1.920078
8968 op-snap---monthly-publication-january-2025.pdf   76 2025-01 Pedal Bike Toyota Noah Blue Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Walsgrave Road Walsgrave Road Coventry Coventry Warning Letter N/A Yes - Via Email 52.4096725 -1.487901
9144 op-snap---monthly-publication-january-2025.pdf   252 2025-01 Pedal Bike Toyota Rav 4 Black Driving without Due Care and Attention None Droitwich Road Droitwich Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9240 op-snap---monthly-publication-january-2025.pdf   348 2025-01 Pedal Bike Toyota Avenis Red Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4324855 -1.4815548
9284 op-snap---monthly-publication-january-2025.pdf   392 2025-01 Pedal Bike Toyota Auris White Driving without Reasonable Consideration None The Ridgeway The Ridgeway Birmingham Birmingham Education N/A Yes - Via Email 52.5252536 -1.8765786
9311 op-snap---monthly-publication-january-2025.pdf   419 2025-01 Pedal Bike Toyota Prius Blue Stop a vehicle within pelican pedestrian crossing limits None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A Yes - Via Email 52.4071231 -1.4985178
9341 op-snap---monthly-publication-january-2025.pdf   449 2025-01 Pedal Bike Toyota Yaris Red Using a Mobile Phone Whilst Driving None Northfield Road Northfield Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4167654 -1.9411244
9397 op-snap---monthly-publication-january-2025.pdf   505 2025-01 Pedal Bike Toyota Verso Black Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A Yes - Via Email 52.4103191 -1.8670224
9600 op-snap---monthly-publication-january-2025.pdf   708 2025-01 Pedal Bike Toyota Corrolla Black Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A Yes - Via Email 52.4221152 -1.4959475
9613 op-snap---monthly-publication-january-2025.pdf   721 2025-01 Pedal Bike Toyota Yaris White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Foleshill Road Foleshill Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4274335 -1.5002381
9636 op-snap---monthly-publication-january-2025.pdf   744 2025-01 Pedal Bike Toyota Corolla White Stop a vehicle within pelican pedestrian crossing limits None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4221152 -1.4959475
9646 op-snap---monthly-publication-january-2025.pdf   754 2025-01 Pedal Bike Toyota chr Grey Driving without Reasonable Consideration None A4101 upton upon severn A4101 upton upon severn Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
9666 op-snap---monthly-publication-january-2025.pdf   774 2025-01 Pedal Bike Toyota Prius Silver Using a Mobile Phone Whilst Driving None Edgbaston Road Edgbaston Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4552785 -1.906384
9930 op-snap---monthly-publication-january-2025.pdf   1038 2025-01 Pedal Bike Toyota Prius Blue Contravening a Red Traffic Light None Lockhurst Lane Lockhurst Lane Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4255689 -1.5023841
9931 op-snap---monthly-publication-january-2025.pdf   1039 2025-01 Pedal Bike Toyota C-HR White Driving without Reasonable Consideration None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield Education N/A Yes - Via Email 52.5872149 -1.8300386
9966 op-snap---monthly-publication-january-2025.pdf   1074 2025-01 Pedal Bike Toyota Prius White Driving without Reasonable Consideration None Dutton Road Dutton Road Coventry Coventry Education N/A Yes - Via Email 52.4447067 -1.458495
9992 op-snap---monthly-publication-january-2025.pdf   1100 2025-01 Pedal Bike Toyota Auris White Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4943878 -1.8504211
10011 op-snap---monthly-publication-january-2025.pdf   1119 2025-01 Pedal Bike Toyota COROLLA Black Using a Mobile Phone Whilst Driving None AUGUSTUS ROAD Augustus Road Birmingham Birmingham Court N/A Yes - Via Email 52.4695793 -1.9378608
10023 op-snap---monthly-publication-january-2025.pdf   1131 2025-01 Pedal Bike Toyota Aygo Black Driving without Reasonable Consideration None Little Bromwich Road Little Bromwich Road Birmingham Birmingham Education N/A Yes - Via Email 52.4777017 -1.8246255
10067 op-snap---monthly-publication-january-2025.pdf   1175 2025-01 Pedal Bike Toyota Prius White Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Walsgrave Road Walsgrave Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.4096725 -1.487901
10145 op-snap---monthly-publication-january-2025.pdf   1253 2025-01 Pedal Bike Toyota Prius Silver Driving without Reasonable Consideration None Hagley Road, Stourbridge Hagley Road, Stourbridge Dudley Dudley Education N/A Yes - Via Email 52.4357078 -2.1323185
10168 op-snap---monthly-publication-january-2025.pdf   1276 2025-01 Pedal Bike Toyota PRIUS White Contravening a Red Traffic Light None A38 BRISTOL ROAD A38 Bristol Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4476938 -1.9256632
10524 op-snap---monthly-publication-january-2025.pdf   1632 2025-01 Pedal Bike Toyota PRIUS Silver Driving without Reasonable Consideration None GIBEETT HILL ROAD Gibeett Hill Road Coventry Coventry Education N/A Yes - Via Email    
10532 op-snap---monthly-publication-january-2025.pdf   1640 2025-01 Pedal Bike Toyota Corolla Silver Driving without Reasonable Consideration None Beake Avenue Beake Avenue Coventry Coventry Education N/A Yes - Via Email 52.4388246 -1.5229308

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