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

18 rows where month = "2026-01", reporter_transport_mode = "Pedal Bike" and vehicle_make = "BMW" 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

vehicle_make 1

  • BMW · 18 ✖

reporter_transport_mode 1

  • Pedal Bike · 18 ✖

month 1

  • 2026-01 · 18 ✖
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
10565 op-snap---monthly-publication-january-2026.pdf   26 2026-01 Pedal Bike BMW M3 Grey Using a Mobile Phone Whilst Driving None Stoney Stanton Road Stoney Stanton Road Coventry Coventry NFA No Independent Evidence Available   52.4221152 -1.4959475
10568 op-snap---monthly-publication-january-2026.pdf   29 2026-01 Pedal Bike BMW 120d Black Contravening a Red Traffic Light None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10992 op-snap---monthly-publication-january-2026.pdf   453 2026-01 Pedal Bike BMW 740LD Blue Using a Mobile Phone Whilst Driving None Lordswood Road Lordswood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4591339 -1.9601054
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11113 op-snap---monthly-publication-january-2026.pdf   574 2026-01 Pedal Bike BMW 420D Blue Using a Mobile Phone Whilst Driving None Aston Web Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
11121 op-snap---monthly-publication-january-2026.pdf   582 2026-01 Pedal Bike BMW 320D Black Contravening a Red Traffic Light None A45 slip road Allesley Green to Birmingham A45 slip road Allesley Green to Birmingham Coventry Coventry Warning Letter N/A      
11136 op-snap---monthly-publication-january-2026.pdf   597 2026-01 Pedal Bike BMW 335D Blue Stop a vehicle within pelican pedestrian crossing limits None Gibbins Road Gibbins Road Birmingham Birmingham Education N/A   52.4390303 -1.9512931
11194 op-snap---monthly-publication-january-2026.pdf   655 2026-01 Pedal Bike BMW 428i Blue Driving without Due Care and Attention None Fosse Way, Warwick Fosse Way, Warwick Out of Force Area Out of Force Area NFA Out of Force      
11210 op-snap---monthly-publication-january-2026.pdf   671 2026-01 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Much Park Street Much Park Street Coventry Coventry Warning Letter N/A   52.4061531 -1.505845
11215 op-snap---monthly-publication-january-2026.pdf   676 2026-01 Pedal Bike BMW 320D White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11217 op-snap---monthly-publication-january-2026.pdf   678 2026-01 Pedal Bike BMW 120 SPORT Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11367 op-snap---monthly-publication-january-2026.pdf   828 2026-01 Pedal Bike BMW X4 Blue Driving without Due Care and Attention None South Road South Road Birmingham Birmingham Warning Letter N/A   52.4972567 -1.9214327
11569 op-snap---monthly-publication-january-2026.pdf   1030 2026-01 Pedal Bike BMW 1 series White Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Fixed Penalty N/A   52.4324855 -1.4815548
11766 op-snap---monthly-publication-january-2026.pdf   1227 2026-01 Pedal Bike BMW 320i Grey Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
11841 op-snap---monthly-publication-january-2026.pdf   1302 2026-01 Pedal Bike BMW X3.. Grey Using a Mobile Phone Whilst Driving None Pebble Mill Road Pebble Mill Road Birmingham Birmingham Fixed Penalty N/A   52.4512925 -1.9124618
11870 op-snap---monthly-publication-january-2026.pdf   1331 2026-01 Pedal Bike BMW 320D Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749

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