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

17 rows where disposal = "NFA", month = "2025-07" and vehicle_make = "Skoda" 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

  • Skoda · 17 ✖

month 1

  • 2025-07 · 17 ✖

disposal 1

  • NFA · 17 ✖
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
11969 op-snap---monthly-publication-july-2025.pdf   21 2025-07 Car Skoda Kamiq White Contravening a Red Traffic Light None Robin Hood Lane Robin Hood Lane Birmingham Birmingham NFA No Offence   52.4221526 -1.8425617
11971 op-snap---monthly-publication-july-2025.pdf   23 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None A44 Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
12043 op-snap---monthly-publication-july-2025.pdf   95 2025-07 Car Skoda Fabia White Contravening a Red Traffic Light None Wolverhampton Road Wolverhampton Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4702299 -1.9948976
12130 op-snap---monthly-publication-july-2025.pdf   182 2025-07 Pedal Bike Skoda   Black Driving without Due Care and Attention None Witton Road, Witton Lane Witton Road, Witton Lane Birmingham Birmingham NFA No VRM      
12202 op-snap---monthly-publication-july-2025.pdf   254 2025-07 Pedestrian Skoda   Black Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
12275 op-snap---monthly-publication-july-2025.pdf   327 2025-07 Car Skoda Superb White Driving without Due Care and Attention None Litchfield Road Litchfield Road Walsall Walsall NFA No Independent Evidence Available      
12437 op-snap---monthly-publication-july-2025.pdf   489 2025-07 Car Skoda Enyaq Black Driving without Due Care and Attention None Kings Road Kings Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5531351 -1.8852761
12460 op-snap---monthly-publication-july-2025.pdf   512 2025-07 Car Skoda Kodiaq Black Contravening a Red Traffic Light None Greenside Way Greenside Way Walsall Walsall NFA Outside of 14 Days NIP   52.5593422 -1.9734672
12472 op-snap---monthly-publication-july-2025.pdf   524 2025-07 Car Skoda Octavia Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
12509 op-snap---monthly-publication-july-2025.pdf   561 2025-07 Car Skoda Enyaq Blue Driving without Due Care and Attention None M6 NB Liverpool M6 Northbound Liverpool Out of Force Area Out of Force Area NFA Out of Force      
12624 op-snap---monthly-publication-july-2025.pdf   676 2025-07 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
12643 op-snap---monthly-publication-july-2025.pdf   695 2025-07 Car Skoda Octavia White Contravening a Red Traffic Light None A38 (Minworth Island) A38 (Minworth Island) Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.530527 -1.7748252
12653 op-snap---monthly-publication-july-2025.pdf   705 2025-07 Pedal Bike Skoda C3 Blue Driving without Reasonable Consideration None City Road City Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4763176 -1.9584897
12787 op-snap---monthly-publication-july-2025.pdf   839 2025-07 Car Skoda Kodiaq Silver Driving without Due Care and Attention None Cronehills Linkway Cronehills Linkway Sandwell Sandwell NFA No Independent Evidence Available   52.5216057 -1.9934283
12842 op-snap---monthly-publication-july-2025.pdf   894 2025-07 Car Skoda Citigo White Contravening a Red Traffic Light None All Saints Way , Great Barr All Saints Way , Great Barr Birmingham Birmingham NFA Outside of 14 Days NIP      
12865 op-snap---monthly-publication-july-2025.pdf   917 2025-07 Car Skoda fabia Red Driving without Due Care and Attention None Bells Lane Bells Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4053419 -1.8944602
12924 op-snap---monthly-publication-july-2025.pdf   976 2025-07 Car Skoda Fabia Black Driving without Reasonable Consideration None Cole Hall Lane , Birmingham Cole Hall Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883

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