opsnap: reports: 61 rows where disposal = "Warning Letter", month = "2025-12" and offence = "Driving without Due Care and Attention" sorted by month descending

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

61 rows where disposal = "Warning Letter", month = "2025-12" and offence = "Driving without Due Care and Attention" sorted by month descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id	source_file	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	latitude	longitude
3878	op-snap---monthly-publication-december-2025.pdf	6	2025-12	Car	Audi	A6	Black	Driving without Due Care and Attention	None	A41	A41	Sandwell	Sandwell	Warning Letter	N/A
3891	op-snap---monthly-publication-december-2025.pdf	19	2025-12	Pedal Bike	Ford	Mondeo	Silver	Driving without Due Care and Attention	None	Longdales Road	Longdales Road	Birmingham	Birmingham	Warning Letter	N/A	52.3947881	-1.9285109
3892	op-snap---monthly-publication-december-2025.pdf	20	2025-12	Pedal Bike	Nissan	Note	White	Driving without Due Care and Attention	None	Wychall Lane	Wychall Lane	Birmingham	Birmingham	Warning Letter	N/A	52.4090761	-1.9404121
4002	op-snap---monthly-publication-december-2025.pdf	130	2025-12	Car	BMW	3 Series	Grey	Driving without Due Care and Attention	None	Stafford St	Stafford Street	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5653849	-2.0755665
4003	op-snap---monthly-publication-december-2025.pdf	131	2025-12	Car	Jeep	Renegade	Black	Driving without Due Care and Attention	None	Grove Lane	Grove Lane	Sutton Coldfield	Sutton Coldfield	Warning Letter	N/A	52.5541631	-1.7509992
4011	op-snap---monthly-publication-december-2025.pdf	139	2025-12	Pedal Bike	Land Rover	Velar	Black	Driving without Due Care and Attention	None	High Street, Deritend	High Street, Deritend	Birmingham	Birmingham	Warning Letter	N/A	52.4746492	-1.8839977
4027	op-snap---monthly-publication-december-2025.pdf	155	2025-12	Pedal Bike	Vauxhall	Insignia	Black	Driving without Due Care and Attention	None	A491 Hagley Road	Hagley Road	Dudley	Dudley	Warning Letter	N/A	52.4514139	-2.1423625
4061	op-snap---monthly-publication-december-2025.pdf	189	2025-12	Car	Renault	Clio	Blue	Driving without Due Care and Attention	None	A41 Black Country New Road	Black Country New Road	Sandwell	Sandwell	Warning Letter	N/A	52.5527191	-2.0312967
4065	op-snap---monthly-publication-december-2025.pdf	193	2025-12	Car	Ford	Transit	Blue	Driving without Due Care and Attention	None	Kingstanding Road	Kingstanding Road	Birmingham	Birmingham	Warning Letter	N/A	52.5521118	-1.8845138
4069	op-snap---monthly-publication-december-2025.pdf	197	2025-12	Car	Kia	Picanto	White	Driving without Due Care and Attention	None	Castlegate Way	Castlegate Way	Dudley	Dudley	Warning Letter	N/A	52.5143403	-2.0723636
4105	op-snap---monthly-publication-december-2025.pdf	233	2025-12	Car	Kia	Niro..	Black	Driving without Due Care and Attention	None	Hawthorn Road	Hawthorn Road	Birmingham	Birmingham	Warning Letter	N/A	52.5436609	-1.8214668
4106	op-snap---monthly-publication-december-2025.pdf	234	2025-12	Car	Ford	Fiesta	Blue	Driving without Due Care and Attention	None	M6 Motorway	M6 Motorway	Walsall	Walsall	Warning Letter	N/A	52.6151447	-2.0290522
4115	op-snap---monthly-publication-december-2025.pdf	243	2025-12	Car	Kia	Sportage	Yellow	Driving without Due Care and Attention	None	New Cross Hospital	New Cross Hospital	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.6000052	-2.0954966
4118	op-snap---monthly-publication-december-2025.pdf	246	2025-12	Car	Citroen	Berlingo	Black	Driving without Due Care and Attention	None	Ambergate Road Bilston	Ambergate Road Bilston	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5597351	-2.081298
4134	op-snap---monthly-publication-december-2025.pdf	262	2025-12	Car	Volkswagen	Golf	Grey	Driving without Due Care and Attention	None	Nechells Lane	Nechells Lane	Wolverhampton	Wolverhampton	Warning Letter	N/A
4151	op-snap---monthly-publication-december-2025.pdf	279	2025-12	Car	Lexus	Lexus	Silver	Driving without Due Care and Attention	None	Castle Vale	Castle Vale	Birmingham	Birmingham	Warning Letter	N/A	52.5212593	-1.7845494
4184	op-snap---monthly-publication-december-2025.pdf	312	2025-12	Car	Lexus	RX	Black	Driving without Due Care and Attention	None	The Boulevard Brierley Hill	The Boulevard Brierley Hill	Dudley	Dudley	Warning Letter	N/A	52.4788849	-2.1125394
4263	op-snap---monthly-publication-december-2025.pdf	391	2025-12	Car	Nissan	Juke	Blue	Driving without Due Care and Attention	None	Highfield Road	Highfield Road	Birmingham	Birmingham	Warning Letter	N/A	52.4216321	-1.855984
4264	op-snap---monthly-publication-december-2025.pdf	392	2025-12	Car	Skoda	Octavia	White	Driving without Due Care and Attention	None	Arden Oak Road	Arden Oak Road	Birmingham	Birmingham	Warning Letter	N/A	52.4533929	-1.7703309
4305	op-snap---monthly-publication-december-2025.pdf	433	2025-12	Car	Seat	Leon	Silver	Driving without Due Care and Attention	None	A452	A452	Birmingham	Birmingham	Warning Letter	N/A
4313	op-snap---monthly-publication-december-2025.pdf	441	2025-12	Pedal Bike	Ford	Kuga	Blue	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	Warning Letter	N/A	52.4167654	-1.9411244
4328	op-snap---monthly-publication-december-2025.pdf	456	2025-12	Pedal Bike	Iveco	Daily	White	Driving without Due Care and Attention	None	Lady Byron Lane	Lady Byron Lane	Solihull	Solihull	Warning Letter	N/A	52.4026126	-1.7503668
4330	op-snap---monthly-publication-december-2025.pdf	458	2025-12	Pedal Bike	Hyundai	I40..	White	Driving without Due Care and Attention	None	Bristol Road	Bristol Road	Birmingham	Birmingham	Warning Letter	N/A	52.4543565	-1.9114004
4383	op-snap---monthly-publication-december-2025.pdf	511	2025-12	Car	Land Rover	Range Rover	Black	Driving without Due Care and Attention	None	Pershore Road	Pershore Road	Birmingham	Birmingham	Warning Letter	N/A	52.4308271	-1.920078
4398	op-snap---monthly-publication-december-2025.pdf	526	2025-12	Car	Audi	A4	Silver	Driving without Due Care and Attention	None	Hunters Road	Hunters Road	Birmingham	Birmingham	Warning Letter	N/A	52.5011362	-1.9175837
4467	op-snap---monthly-publication-december-2025.pdf	595	2025-12	Car	Citroen	Berlingo	Green	Driving without Due Care and Attention	None	Longbridge Lane	Longbridge Lane	Birmingham	Birmingham	Warning Letter	N/A	52.3962003	-1.9821252
4552	op-snap---monthly-publication-december-2025.pdf	680	2025-12	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Tollhouse Way	Tollhouse Way	Sandwell	Sandwell	Warning Letter	N/A	52.5003461	-1.9782389
4583	op-snap---monthly-publication-december-2025.pdf	711	2025-12	Car	Honda	Civic	Red	Driving without Due Care and Attention	None	Broad Lane South	Broad Lane South	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5995308	-2.0598045
4587	op-snap---monthly-publication-december-2025.pdf	715	2025-12	Car	Volvo	S90	Grey	Driving without Due Care and Attention	None	Blackhalve Lane	Blackhalve Lane	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.6139368	-2.0960778
4591	op-snap---monthly-publication-december-2025.pdf	719	2025-12	Car	Volkswagen	Golf	White	Driving without Due Care and Attention	None	M6 NB	M6 Northbound	Walsall	Walsall	Warning Letter	N/A
4592	op-snap---monthly-publication-december-2025.pdf	720	2025-12	Pedestrian	Audi	s3	Blue	Driving without Due Care and Attention	None	south parade	South Parade	Sutton Coldfield	Sutton Coldfield	Warning Letter	N/A	52.5618877	-1.8226794
4604	op-snap---monthly-publication-december-2025.pdf	732	2025-12	Car	Seat	Arona	White	Driving without Due Care and Attention	None	Hagley Road A456	Hagley Road A456	Birmingham	Birmingham	Warning Letter	N/A	52.471632	-1.9456776
4609	op-snap---monthly-publication-december-2025.pdf	737	2025-12	Car	Volkswagen	Taigo	Black	Driving without Due Care and Attention	None	Bloxwich Lane	Bloxwich Lane	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5869808	-2.0100405
4621	op-snap---monthly-publication-december-2025.pdf	749	2025-12	Car	BMW	840i	Black	Driving without Due Care and Attention	None	M5 NB J1	M5 Northbound J1	Sandwell	Sandwell	Warning Letter	N/A
4626	op-snap---monthly-publication-december-2025.pdf	754	2025-12	Pedal Bike	Alfa Romeo	Giulietta	White	Driving without Due Care and Attention	None	Stonehouse Hill, California	Stonehouse Hill, California	Birmingham	Birmingham	Warning Letter	N/A	52.4457793	-1.97093
4630	op-snap---monthly-publication-december-2025.pdf	758	2025-12	Car	Volkswagen	Scirocco	Black	Driving without Due Care and Attention	None	M6/M5 slip	M6/M5 slip	Sandwell	Sandwell	Warning Letter	N/A
4634	op-snap---monthly-publication-december-2025.pdf	762	2025-12	Pedal Bike	Jaguar	XF	Blue	Driving without Due Care and Attention	None	Lowhill Lane, Rednal	Lowhill Lane, Rednal	Birmingham	Birmingham	Warning Letter	N/A	52.3875654	-1.9924345
4642	op-snap---monthly-publication-december-2025.pdf	770	2025-12	Car	Nissan	Note	Blue	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
4655	op-snap---monthly-publication-december-2025.pdf	783	2025-12	Car	Vauxhall	Zafira	Brown	Driving without Due Care and Attention	None	Birchfield Road	Birchfield Road	Birmingham	Birmingham	Warning Letter	N/A	52.5170745	-1.9012542
4664	op-snap---monthly-publication-december-2025.pdf	792	2025-12	Car	Peugeot	208	Silver	Driving without Due Care and Attention	None	Warwick Road	Warwick Road	Solihull	Solihull	Warning Letter	N/A	52.4428606	-1.812114
4679	op-snap---monthly-publication-december-2025.pdf	807	2025-12	Car	Ford	Fiesta	Blue	Driving without Due Care and Attention	None	M42	M42	Birmingham	Birmingham	Warning Letter	N/A
4689	op-snap---monthly-publication-december-2025.pdf	817	2025-12	Car	Mercedes-Benz	CLA180	Silver	Driving without Due Care and Attention	None	M6	M6	Birmingham	Birmingham	Warning Letter	N/A
4705	op-snap---monthly-publication-december-2025.pdf	833	2025-12	Pedal Bike	Ford	Fiesta	Grey	Driving without Due Care and Attention	None	Wheelers Lane	Wheelers Lane	Birmingham	Birmingham	Warning Letter	N/A	52.4306504	-1.878052
4727	op-snap---monthly-publication-december-2025.pdf	855	2025-12	Pedal Bike	Mazda	CX3	Silver	Driving without Due Care and Attention	None	Broad Lane	Broad Lane	Coventry	Coventry	Warning Letter	N/A	52.4074716	-1.5620671
4728	op-snap---monthly-publication-december-2025.pdf	856	2025-12	Pedal Bike	Ford	Transit	White	Driving without Due Care and Attention	None	Broad Lane	Broad Lane	Coventry	Coventry	Warning Letter	N/A	52.4074716	-1.5620671
4771	op-snap---monthly-publication-december-2025.pdf	899	2025-12	Pedal Bike	Citroen	Dispatch	White	Driving without Due Care and Attention	None	Station Road	Station Road	Sutton Coldfield	Sutton Coldfield	Warning Letter	N/A	52.5463049	-1.8271004
4800	op-snap---monthly-publication-december-2025.pdf	928	2025-12	Car	Kia	Sportage	Blue	Driving without Due Care and Attention	None	M6	M6	Walsall	Walsall	Warning Letter	N/A
4818	op-snap---monthly-publication-december-2025.pdf	946	2025-12	Pedal Bike	Audi	A5	White	Driving without Due Care and Attention	None	Oak Tree Lane, Selly Oak	Oak Tree Lane, Selly Oak	Birmingham	Birmingham	Warning Letter	N/A	52.4386794	-1.939894
4833	op-snap---monthly-publication-december-2025.pdf	961	2025-12	Car	Mercedes-Benz	Sprinter	Blue	Driving without Due Care and Attention	None	Park Lane, Wednesbury	Park Lane, Wednesbury	Walsall	Walsall	Warning Letter	N/A	52.5687807	-2.0165653
4864	op-snap---monthly-publication-december-2025.pdf	992	2025-12	Pedal Bike	Vauxhall	Grandland	Brown	Driving without Due Care and Attention	None	Heath Street, Stourbridge	Heath Street, Stourbridge	Dudley	Dudley	Warning Letter	N/A	52.4528944	-2.152138
4886	op-snap---monthly-publication-december-2025.pdf	1014	2025-12	Car	Ford	Transit	White	Driving without Due Care and Attention	None	A34 Stratford Road	Stratford Road	Solihull	Solihull	Warning Letter	N/A	52.4191184	-1.8326637
4900	op-snap---monthly-publication-december-2025.pdf	1028	2025-12	Car	Nissan	Micra	Blue	Driving without Due Care and Attention	None	Dudley Road	Dudley Road	Sandwell	Sandwell	Warning Letter	N/A	52.4877352	-1.9494469
4912	op-snap---monthly-publication-december-2025.pdf	1040	2025-12	Other	Mercedes-Benz	C-class	Black	Driving without Due Care and Attention	None	Waterfront Car Park	Waterfront Car Park	Dudley	Dudley	Warning Letter	N/A
4916	op-snap---monthly-publication-december-2025.pdf	1044	2025-12	Pedal Bike	Mercedes-Benz	C350	Grey	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
4920	op-snap---monthly-publication-december-2025.pdf	1048	2025-12	Car	Volkswagen	Tiguan	Black	Driving without Due Care and Attention	None	Church Road	Church Road	Birmingham	Birmingham	Warning Letter	N/A	52.4624743	-1.7763934
4963	op-snap---monthly-publication-december-2025.pdf	1091	2025-12	Car	BMW	1 series	Blue	Driving without Due Care and Attention	None	Warstock Road	Warstock Road	Birmingham	Birmingham	Warning Letter	N/A	52.413031	-1.8782144
4985	op-snap---monthly-publication-december-2025.pdf	1113	2025-12	Car	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Tyburn Road	Tyburn Road	Birmingham	Birmingham	Warning Letter	N/A	52.5113867	-1.8337258
4998	op-snap---monthly-publication-december-2025.pdf	1126	2025-12	Car	Peugeot	308cc	Red	Driving without Due Care and Attention	None	Pedmore Road	Pedmore Road	Dudley	Dudley	Warning Letter	N/A	52.4897451	-2.1069141
5007	op-snap---monthly-publication-december-2025.pdf	1135	2025-12	Car	Mini	Cooper	Grey	Driving without Due Care and Attention	None	Green Lane	Green Lane	Solihull	Solihull	Warning Letter	N/A	52.5069826	-1.7643766
5078	op-snap---monthly-publication-december-2025.pdf	1206	2025-12	Car	Volvo	XC40	Black	Driving without Due Care and Attention	None	Black Country New Road	Black Country New Road	Dudley	Dudley	Warning Letter	N/A
5169	op-snap---monthly-publication-december-2025.pdf	1297	2025-12	Car	Jaguar	XF	Black	Driving without Due Care and Attention	None	Church Street	Church Street	Walsall	Walsall	Warning Letter	N/A	52.5863038	-2.0494462

Advanced export

JSON shape: default, array, newline-delimited, object

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