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

13 rows where disposal = "NFA", month = "2025-05" and vehicle_make = "Renault" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_model, vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 4

vehicle_make 1

  • Renault · 13 ✖

month 1

  • 2025-05 · 13 ✖

disposal 1

  • NFA · 13 ✖
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
18733 op-snap---monthly-publication-may-2025.pdf   95 2025-05 Pedestrian Renault CAPTUR Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None PETERSFIELD ROAD Petersfield Road Birmingham Birmingham NFA No Independent Evidence Available   52.4307 -1.8494663
18798 op-snap---monthly-publication-may-2025.pdf   160 2025-05 Other Renault Kadjar Blue Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen Nt one Norwood Road Norwood Road Dudley Dudley NFA Outside of 14 Days NIP   52.4831397 -2.1309273
18891 op-snap---monthly-publication-may-2025.pdf   253 2025-05 Pedal Bike Renault Austral Grey Driving without Reasonable Consideration None Erdington Road Erdington Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5133989 -1.8448231
18900 op-snap---monthly-publication-may-2025.pdf   262 2025-05 Car Renault Captur Blue Driving without Due Care and Attention None Primrose Lane Primrose Lane Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.6126833 -2.1053084
18924 op-snap---monthly-publication-may-2025.pdf   286 2025-05 Car Renault Megane Blue Driving without Reasonable Consideration None A4100 Quarry Bank Quarry Bank Dudley Dudley NFA No Offence   52.4733135 -2.1014635
19030 op-snap---monthly-publication-may-2025.pdf   392 2025-05 Car Renault Traffic Black Driving without Due Care and Attention None M1 Southbound at M6 join (Leiceste M1 Southbound at M6 join (Leiceste rsOhuirte o)f Force Area Rsohuirte O)F Force Area NFA Out of Force      
19073 op-snap---monthly-publication-may-2025.pdf   435 2025-05 Car Renault Traffic White Contravening a Red Traffic Light None Stivichall Roundabout Stivichall Roundabout Coventry Coventry NFA Outside of 14 Days NIP   52.3776818 -1.4982138
19903 op-snap---monthly-publication-may-2025.pdf   1265 2025-05 Pedal Bike Renault NP Grey Driving without Due Care and Attention None hoggs lane, frankley Hoggs Lane, Frankley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4158643 -1.9846878
19907 op-snap---monthly-publication-may-2025.pdf   1269 2025-05 Pedal Bike Renault NP White Driving without Due Care and Attention None RAB A38, lickey road RAB A38, lickey road Birmingham Birmingham NFA Outside of 14 Days NIP      
19998 op-snap---monthly-publication-may-2025.pdf   1360 2025-05 Car Renault Clio blue Contravening a Red Traffic Light None Icknield street Icknield street birmingham Birmingham NFA Outside of 14 Days NIP   52.5709191 -1.8759339
20038 op-snap---monthly-publication-may-2025.pdf   1400 2025-05 Other Renault NP White Contravening a Red Traffic Light None King street dudley King street dudley Dudley Dudley NFA Outside of 14 Days NIP   52.5087377 -2.0845627
20092 op-snap---monthly-publication-may-2025.pdf   1454 2025-05 Car Renault Scenic Red Driving without Due Care and Attention None A4141 A4141 Solihull Solihull NFA Outside of 14 Days NIP      
20334 op-snap---monthly-publication-may-2025.pdf   1696 2025-05 Pedal Bike Renault clio Blue Driving without Due Care and Attention None Tyseley Tyseley Birmingham Birmingham NFA No VRM   52.4539238 -1.8385604

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