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 month = "2025-10", offence = "Driving without Due Care and Attention" and vehicle_make = "Renault" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_model, vehicle_colour, council_area_raw, nfa_rationale

reporter_transport_mode 3

vehicle_make 1

  • Renault · 19 ✖

offence 1

  • Driving without Due Care and Attention · 19 ✖

month 1

  • 2025-10 · 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
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22203 op-snap---monthly-publication-october-2025.pdf   153 2025-10 Car Renault Megane White Driving without Due Care and Attention None Black Country Route Black Country Route Wolverhampton Wolverhampton Fixed Penalty N/A   52.5642677 -2.0755469
22375 op-snap---monthly-publication-october-2025.pdf   325 2025-10 Other Renault   Grey Driving without Due Care and Attention None Station Road Station Road Birmingham Birmingham NFA No Independent Evidence Available   52.5054559 -1.9506109
22388 op-snap---monthly-publication-october-2025.pdf   338 2025-10 Car Renault Twingo Black Driving without Due Care and Attention None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No VRM   52.4590366 -2.1465735
22437 op-snap---monthly-publication-october-2025.pdf   387 2025-10 Pedal Bike Renault Master White Driving without Due Care and Attention None Wood Lane, Lower Stonnall Wood Lane, Lower Stonnall Out of Force Area Out of Force Area NFA Out of Force      
22449 op-snap---monthly-publication-october-2025.pdf   399 2025-10 Pedal Bike Renault Clio White Driving without Due Care and Attention None Earlsdon Avenue Earlsdon Avenue Coventry Coventry NFA No Offence   52.4047134 -1.5351834
22534 op-snap---monthly-publication-october-2025.pdf   484 2025-10 Car Renault Clio Red Driving without Due Care and Attention None Webster Way Webster Way Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5445328 -1.7884784
22594 op-snap---monthly-publication-october-2025.pdf   544 2025-10 Pedal Bike Renault Trafic Grey Driving without Due Care and Attention None May Lane May Lane Birmingham Birmingham Education N/A   52.4197342 -1.8839613
22645 op-snap---monthly-publication-october-2025.pdf   595 2025-10 Pedal Bike Renault Trafic Yellow Driving without Due Care and Attention None Main Road, Lower Quinton, near Stratford Main Road, Lower Quinton, near Stratford Out of Force Area Out of Force Area NFA Out of Force      
22680 op-snap---monthly-publication-october-2025.pdf   630 2025-10 Car Renault Cement mixer White Driving without Due Care and Attention None Dunchurch Highway Dunchurch Highway Coventry Coventry NFA Outside of 14 DAYS Late Submission   52.4131902 -1.5650136
22682 op-snap---monthly-publication-october-2025.pdf   632 2025-10 Pedal Bike Renault Capture Grey Driving without Due Care and Attention None Easemore Road Redditch Easemore Road Redditch Out of Force Area Out of Force Area NFA Out of Force      
22733 op-snap---monthly-publication-october-2025.pdf   683 2025-10 Car Renault Megane Blue Driving without Due Care and Attention None M1 Southbound towards London M1 Southbound towards London Out of Force Area Out of Force Area NFA Out of Force      
22788 op-snap---monthly-publication-october-2025.pdf   738 2025-10 Car Renault HGV Blue Driving without Due Care and Attention None M42 Junction 6 M42 Junction 6 Birmingham Birmingham Education N/A      
22816 op-snap---monthly-publication-october-2025.pdf   766 2025-10 Car Renault Tractor White Driving without Due Care and Attention None The Broadway The Broadway Wolverhampton Wolverhampton NFA No Independent Evidence Available   52.6090076 -2.0515573
22818 op-snap---monthly-publication-october-2025.pdf   768 2025-10 Car Renault Lorry White Driving without Due Care and Attention None Tunnel Road Tunnel Road Birmingham Birmingham NFA No Offence   52.3995677 -1.9364122
22827 op-snap---monthly-publication-october-2025.pdf   777 2025-10 Car Renault   Grey Driving without Due Care and Attention None Easmore Road Redditch Easmore Road Redditch Out of Force Area Out of Force Area NFA Out of Force      
22880 op-snap---monthly-publication-october-2025.pdf   830 2025-10 Car Renault Clio Grey Driving without Due Care and Attention None Walsall Road Perry Barr Walsall Road Perry Barr Birmingham Birmingham NFA No Offence   52.5219655 -1.9010321
22910 op-snap---monthly-publication-october-2025.pdf   860 2025-10 Car Renault Clio Grey Driving without Due Care and Attention None A452 Collector Road Collector Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
22979 op-snap---monthly-publication-october-2025.pdf   929 2025-10 Car Renault Trafic grey Driving without Due Care and Attention None Court Lane Court Lane Birmingham Birmingham Warning Letter N/A   52.5338875 -1.847925

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