opsnap: reports: 403 rows where council_area = "Sandwell" 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'}

403 rows where council_area = "Sandwell" 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
7270	op-snap---monthly-publication-february-2026.pdf	17	2026-02	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Hydes Road	Hydes Road	Sandwell	Sandwell	Court	N/A	52.5538064	-2.0139199
7370	op-snap---monthly-publication-february-2026.pdf	117	2026-02	Car	Honda	Jazz	Red	Driving without Due Care and Attention	None	Birchfield Island Olbury	Birchfield Island Olbury	Sandwell	Sandwell	Court	N/A
7408	op-snap---monthly-publication-february-2026.pdf	155	2026-02	Car	BMW	118I	Grey	Driving without Due Care and Attention	None	Hall Green Road	Hall Green Road	Sandwell	Sandwell	Court	N/A	52.5457385	-1.9935809
7971	op-snap---monthly-publication-february-2026.pdf	718	2026-02	Lorry	Mercedes-Benz	C300	Blue	Driving without Due Care and Attention	None	All saints Way	All saints Way	Sandwell	Sandwell	Education	N/A	52.5344405	-1.985568
7997	op-snap---monthly-publication-february-2026.pdf	744	2026-02	Car	Ford	Ranger	White	Driving without Due Care and Attention	None	Crocketts Lane	Crocketts Lane	Sandwell	Sandwell	Warning Letter	N/A	52.493515	-1.966302
8033	op-snap---monthly-publication-february-2026.pdf	780	2026-02	Car	Seat	Leon	Grey	Driving without Due Care and Attention	None	Rounds Green Road	Rounds Green Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.5020873	-2.0262185
8088	op-snap---monthly-publication-february-2026.pdf	835	2026-02	Car	Hyundai	Tucson	Blue	Driving without Due Care and Attention	None	M5 Jn2 to A4123	M5 Jn2 to A4123	Sandwell	Sandwell	Warning Letter	N/A
8094	op-snap---monthly-publication-february-2026.pdf	841	2026-02	Bus	Volkswagen	Golf	Silver	Driving without Due Care and Attention	None	West Brom Ringway	West Brom Ringway	Sandwell	Sandwell	NFA	No VRM
8110	op-snap---monthly-publication-february-2026.pdf	857	2026-02	Car	Vauxhall	Mokka	Grey	Driving without Due Care and Attention	None	Black Country New Road	Black Country New Road	Sandwell	Sandwell	Education	N/A	52.5527191	-2.0312967
8111	op-snap---monthly-publication-february-2026.pdf	858	2026-02	Car	Vauxhall	Insignia	Grey	Driving without Due Care and Attention	None	New Swan Lane	New Swan Lane	Sandwell	Sandwell	NFA	No Offence	52.5293372	-2.0107584
8161	op-snap---monthly-publication-february-2026.pdf	908	2026-02	Lorry	Ford	Transit	White	Driving without Due Care and Attention	None	Birmingham Road	Birmingham Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.5461417	-1.9334193
8255	op-snap---monthly-publication-february-2026.pdf	1002	2026-02	Car	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	Island Road	Island Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.4634433	-1.9965278
8297	op-snap---monthly-publication-february-2026.pdf	1044	2026-02	Car	Audi	RS3	Black	Driving without Due Care and Attention	None	M5 (N) to M6 (S) slip road	M5 (N) to M6 (S) slip road	Sandwell	Sandwell	Fixed Penalty	N/A
8306	op-snap---monthly-publication-february-2026.pdf	1053	2026-02	Car	Mercedes-Benz	A200	Black	Driving without Due Care and Attention		M5 Motorway Jn1	M5 Motorway Jn1	Sandwell	Sandwell	Education	N/A
8327	op-snap---monthly-publication-february-2026.pdf	1074	2026-02	Car	Hyundai	Ioniq 5	Grey	Driving without Due Care and Attention	None	M5	M5	Sandwell	Sandwell	Warning Letter	N/A
8387	op-snap---monthly-publication-february-2026.pdf	1134	2026-02	Car	BMW	730D	Black	Driving without Due Care and Attention	None	Oldbury Road	Oldbury Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.5018196	-1.9811249
8429	op-snap---monthly-publication-february-2026.pdf	1176	2026-02	Car	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	Dudley Port at Sedgley Road	Dudley Port at Sedgley Road	Sandwell	Sandwell	Court	N/A	52.524461	-2.0492538
8439	op-snap---monthly-publication-february-2026.pdf	1186	2026-02	Car	BMW	X5	White	Driving without Due Care and Attention	None	M5	M5	Sandwell	Sandwell	Education	N/A
8454	op-snap---monthly-publication-february-2026.pdf	1201	2026-02	Car		Multiple		Driving without Due Care and Attention	None	Throne Road	Throne Road	Sandwell	Sandwell	NFA	Misc Inc Crimes	52.4875572	-2.0284052
8478	op-snap---monthly-publication-february-2026.pdf	1225	2026-02	Car	Volvo	Recovery truck	White	Driving without Due Care and Attention	None	Birchley Island	Birchley Island	Sandwell	Sandwell	NFA	No Offence	52.4926604	-2.0216743
8500	op-snap---monthly-publication-february-2026.pdf	1247	2026-02	Lorry	Mercedes-Benz	S320	Black	Driving without Due Care and Attention	No Insurance	Wood Green Road	Wood Green Road	Sandwell	Sandwell	Court	N/A	52.5628617	-2.0055157
8508	op-snap---monthly-publication-february-2026.pdf	1255	2026-02	Pedal Bike	Skoda	Octavia	White	Driving without Due Care and Attention	None	Abbey Road	Abbey Road	Sandwell	Sandwell	Education	N/A	52.47753	-1.9774758
8673	op-snap---monthly-publication-february-2026.pdf	1420	2026-02	Car	Vauxhall	Combo	White	Driving without Due Care and Attention	None	Rowley Village	Rowley Village	Sandwell	Sandwell	Education	N/A	52.48281	-2.042749
8675	op-snap---monthly-publication-february-2026.pdf	1422	2026-02	Car	Iveco	Daily	White	Driving without Due Care and Attention	None	Throne Road	Throne Road	Sandwell	Sandwell	NFA	No Offence	52.4875572	-2.0284052
8676	op-snap---monthly-publication-february-2026.pdf	1423	2026-02	Car	Ford	Transit	Black	Driving without Due Care and Attention	None	Throne Road	Throne Road	Sandwell	Sandwell	NFA	No Offence	52.4875572	-2.0284052
8677	op-snap---monthly-publication-february-2026.pdf	1424	2026-02	Car	Volvo	XC40	Blue	Driving without Due Care and Attention	None	Throne Road	Throne Road	Sandwell	Sandwell	NFA	No Offence	52.4875572	-2.0284052
8744	op-snap---monthly-publication-february-2026.pdf	1491	2026-02	Car	Ford	Connect	White	Driving without Due Care and Attention	None	Middlemore Road	Middlemore Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.5056493	-1.9624063
8745	op-snap---monthly-publication-february-2026.pdf	1492	2026-02	Car	Ford	Connect	White	Driving without Due Care and Attention	None	Middlemore Road	Middlemore Road	Sandwell	Sandwell	Duplicate Submission	Duplicate Submission	52.5056493	-1.9624063
8779	op-snap---monthly-publication-february-2026.pdf	1526	2026-02	Car	Ford	Fiesta	Blue	Driving without Due Care and Attention	None	Kelvin Way	Kelvin Way	Sandwell	Sandwell	RTC - Actioned	N/A	52.5090464	-1.9938896
8782	op-snap---monthly-publication-february-2026.pdf	1529	2026-02	Pedestrian	BMW	118..	Blue	Driving without Due Care and Attention	None	Perry Street at Potters Lane Wednesbury	Perry Street at Potters Lane Wednesbury	Sandwell	Sandwell	Warning Letter	N/A	52.5004634	-1.9710382
8809	op-snap---monthly-publication-february-2026.pdf	1556	2026-02	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Brickhouse Lane	Brickhouse Lane	Sandwell	Sandwell	Court	N/A	52.5331011	-2.0206711
10657	op-snap---monthly-publication-january-2026.pdf	118	2026-01	Car	BMW	318..	Silver	Driving without Due Care and Attention	No Insurance	A41 Birmingham Road	Birmingham Road	Sandwell	Sandwell	Court	N/A	52.5461417	-1.9334193
10776	op-snap---monthly-publication-january-2026.pdf	237	2026-01	Other				Driving without Due Care and Attention	None	Broadmoor Road	Broadmoor Road	Sandwell	Sandwell	RTC - Actioned	N/A
10810	op-snap---monthly-publication-january-2026.pdf	271	2026-01	Car	Mercedes-Benz	G 63	Black	Driving without Due Care and Attention	None	Church Lane	Church Lane	Sandwell	Sandwell	Education	N/A	52.5311655	-2.0008707
10819	op-snap---monthly-publication-january-2026.pdf	280	2026-01	Car	Mazda	2	Grey	Driving without Due Care and Attention	None	McKean Road, Oldbury	Mc Kean Road, Oldbury	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5077405	-2.0124813
10858	op-snap---monthly-publication-january-2026.pdf	319	2026-01	Car	Vauxhall	Insignia	Black	Driving without Due Care and Attention	None	Wolverhampton Road Oldbury	Wolverhampton Road Oldbury	Sandwell	Sandwell	Education	N/A	52.5010052	-2.0306321
10939	op-snap---monthly-publication-january-2026.pdf	400	2026-01	Car	BMW	320d	Black	Driving without Due Care and Attention	None	M5 SB J1-2	M5 Southbound J1-2	Sandwell	Sandwell	Education	N/A
10980	op-snap---monthly-publication-january-2026.pdf	441	2026-01	Other		Unknown	Black	Driving without Due Care and Attention	None	Hydes Road	Hydes Road	Sandwell	Sandwell	NFA	No VRM	52.5538064	-2.0139199
11038	op-snap---monthly-publication-january-2026.pdf	499	2026-01	Car	Volkswagen	Passat	Black	Driving without Due Care and Attention	None	Portland Road, Smethwick	Portland Road, Smethwick	Sandwell	Sandwell	Fixed Penalty	N/A
11039	op-snap---monthly-publication-january-2026.pdf	500	2026-01	Car	Nissan	X-Trail	Black	Driving without Due Care and Attention	None	Portland Road, Smethwick	Portland Road, Smethwick	Sandwell	Sandwell	Fixed Penalty	N/A
11117	op-snap---monthly-publication-january-2026.pdf	578	2026-01	Car	Mercedes-Benz	GLC 220	Grey	Driving without Due Care and Attention	None	Birchley Island	Birchley Island	Sandwell	Sandwell	Warning Letter	N/A	52.4926604	-2.0216743
11122	op-snap---monthly-publication-january-2026.pdf	583	2026-01	Car	Fiat	Ducato	White	Driving without Due Care and Attention	None	M5 Jct 1	M5 Junction 1	Sandwell	Sandwell	Warning Letter	N/A
11195	op-snap---monthly-publication-january-2026.pdf	656	2026-01	Car	Mercedes-Benz	C220	White	Driving without Due Care and Attention	None	Rabone Lane	Rabone Lane	Sandwell	Sandwell	Fixed Penalty	N/A	52.496577	-1.9614637
11262	op-snap---monthly-publication-january-2026.pdf	723	2026-01	Car	Skoda	Octavia	Black	Driving without Due Care and Attention	None	UK	Uk	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5019896	-2.0209184
11345	op-snap---monthly-publication-january-2026.pdf	806	2026-01	Car	Audi	S3..	Silver	Driving without Due Care and Attention	No vehicle excise licence	Jubilee Street	Jubilee Street	Sandwell	Sandwell	Fixed Penalty	N/A	52.5395187	-1.9920471
11519	op-snap---monthly-publication-january-2026.pdf	980	2026-01	Car	Daf	Lorry	White	Driving without Due Care and Attention	None	M5/M6 junction	M5/M6 junction	Sandwell	Sandwell	NFA	No Independent Evidence Available
11536	op-snap---monthly-publication-january-2026.pdf	997	2026-01	Car	Chevrolet	Kalos	Blue	Driving without Due Care and Attention	None	A4040	A4040	Sandwell	Sandwell	Warning Letter	N/A
11584	op-snap---monthly-publication-january-2026.pdf	1045	2026-01	Pedal Bike	Ford	Transit	White	Driving without Due Care and Attention	None	Heath Lane	Heath Lane	Sandwell	Sandwell	Education	N/A	52.5369717	-1.9907285
11592	op-snap---monthly-publication-january-2026.pdf	1053	2026-01	Car	BMW	118I	Grey	Driving without Due Care and Attention	None	Birchley Island	Birchley Island	Sandwell	Sandwell	Fixed Penalty	N/A	52.4926604	-2.0216743
11650	op-snap---monthly-publication-january-2026.pdf	1111	2026-01	Car	Hyundai	I30	Blue	Driving without Due Care and Attention	None	Wolverhampton Road	Wolverhampton Road	Sandwell	Sandwell	Education	N/A	52.4702299	-1.9948976
11791	op-snap---monthly-publication-january-2026.pdf	1252	2026-01	Car	BMW	320	Black	Driving without Due Care and Attention	None	Coneygree Road	Coneygree Road	Sandwell	Sandwell	Fixed Penalty	N/A	52.5166627	-2.0629713
11835	op-snap---monthly-publication-january-2026.pdf	1296	2026-01	Car	Hyundai	i40	Silver	Driving without Due Care and Attention	None	Kenrick Way	Kenrick Way	Sandwell	Sandwell	NFA	No Offence	52.5079468	-1.9755194
11876	op-snap---monthly-publication-january-2026.pdf	1337	2026-01	Car	Volvo	Lorry	White	Driving without Due Care and Attention	None	A4034	A4034	Sandwell	Sandwell	Warning Letter	N/A
11923	op-snap---monthly-publication-january-2026.pdf	1384	2026-01	Car	BMW	118i	Grey	Driving without Due Care and Attention	None	Galton Road	Galton Road	Sandwell	Sandwell	Education	N/A	52.4700791	-1.9751575
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
3908	op-snap---monthly-publication-december-2025.pdf	36	2025-12	Car	Land Rover	Sport	Black	Driving without Due Care and Attention	None	M6 South	M6 South	Sandwell	Sandwell	NFA	No VRM	52.5228877	-2.0650728
4031	op-snap---monthly-publication-december-2025.pdf	159	2025-12	Car	BMW	5 series	Black	Driving without Due Care and Attention	None	Fenton Street, Smethwick	Fenton Street, Smethwick	Sandwell	Sandwell	Fixed Penalty	N/A	52.5003489	-1.9788331
4046	op-snap---monthly-publication-december-2025.pdf	174	2025-12	Car	BMW	3 series	Grey	Driving without Due Care and Attention	None	West Mrob	West Mrob	Sandwell	Sandwell	NFA	No Offence
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
4087	op-snap---monthly-publication-december-2025.pdf	215	2025-12	Car	Audi	A3	White	Driving without Due Care and Attention	Use vehicle on a road withou	tO vladlbidu rtye sRtd certificate	t O vladlbidu rtye s Rtd certificate	Sandwell	Sandwell	Court	N/A
4110	op-snap---monthly-publication-december-2025.pdf	238	2025-12	Car	Audi	A3	Grey	Driving without Due Care and Attention	None	Sandwell and Dudley train station	Sandwell and Dudley train station	Sandwell	Sandwell	NFA	No Offence	52.5052877	-2.0173733
4262	op-snap---monthly-publication-december-2025.pdf	390	2025-12	Car	Vauxhall	Insignia	Green	Driving without Due Care and Attention	None	A41	A41	Sandwell	Sandwell	NFA	No Independent Evidence Available
4271	op-snap---monthly-publication-december-2025.pdf	399	2025-12	Car	Vauxhall		Red	Driving without Due Care and Attention	None	Oldbury Sainsbury	Oldbury Sainsbury	Sandwell	Sandwell	RTC - Actioned	N/A	52.5041451	-2.0177654
4316	op-snap---monthly-publication-december-2025.pdf	444	2025-12	Car	Ford			Driving without Due Care and Attention	None	Dudley Road	Dudley Road	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.4877352	-1.9494469
4349	op-snap---monthly-publication-december-2025.pdf	477	2025-12	Van	Audi	A3	Black	Driving without Due Care and Attention	None	Regent Road, Tividale	Regent Road, Tividale	Sandwell	Sandwell	NFA	No Offence	52.5063797	-2.0552807
4410	op-snap---monthly-publication-december-2025.pdf	538	2025-12	Car	Toyota		Grey	Driving without Due Care and Attention	None	All Saints Way	All Saints Way	Sandwell	Sandwell	NFA	No VRM	52.5344405	-1.985568
4463	op-snap---monthly-publication-december-2025.pdf	591	2025-12	Car	Mercedes-Benz		Black	Driving without Due Care and Attention	None	Dog Kennel Lane	Dog Kennel Lane	Sandwell	Sandwell	NFA	No VRM	52.4901007	-1.9986317
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
4608	op-snap---monthly-publication-december-2025.pdf	736	2025-12	Car	Mercedes-Benz	Citan	White	Driving without Due Care and Attention	None	Crankhall Lane	Crankhall Lane	Sandwell	Sandwell	Fixed Penalty	N/A	52.5489715	-1.9927402
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
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
4718	op-snap---monthly-publication-december-2025.pdf	846	2025-12	Car	Ford	Fiesta	White	Driving without Due Care and Attention	None	A41	A41	Sandwell	Sandwell	NFA	No Independent Evidence Available
4770	op-snap---monthly-publication-december-2025.pdf	898	2025-12	Car	BMW	M3	Orange	Driving without Due Care and Attention	None	Hallens drive	Hallens drive	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5503398	-2.0350718
4854	op-snap---monthly-publication-december-2025.pdf	982	2025-12	Car	Volkswagen	Polo	Black	Driving without Due Care and Attention	No Insurance	Oldbury Road, Smethwick	Oldbury Road, Smethwick	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5010892	-1.9794257
4867	op-snap---monthly-publication-december-2025.pdf	995	2025-12	Car	Kia	EV9	Black	Driving without Due Care and Attention	None	Navigation Roundabout A41	Navigation Roundabout A41	Sandwell	Sandwell	Fixed Penalty	N/A	52.5318418	-2.0304157
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
20469	op-snap---monthly-publication-november-2025.pdf	11	2025-11	Car	Peugeot	2008	Orange	Driving without Due Care and Attention	None	Great Bridge LIONS roundabout	Great Bridge LIONS roundabout	Sandwell	Sandwell	Education	N/A
20560	op-snap---monthly-publication-november-2025.pdf	102	2025-11	Car	Volkswagen	Tiguan	White	Driving without Due Care and Attention	None	Wolverhampton Road	Wolverhampton Road	Sandwell	Sandwell	NFA	No Offence	52.4702299	-1.9948976
20600	op-snap---monthly-publication-november-2025.pdf	142	2025-11	Car	Vauxhall	Astra	Blue	Driving without Due Care and Attention	None	Sedgley Road	Sedgley Road	Sandwell	Sandwell	Warning Letter	N/A	52.5219813	-2.0581691
20624	op-snap---monthly-publication-november-2025.pdf	166	2025-11	Car	BMW	3 Series	White	Driving without Due Care and Attention	No Insurance	Dudley Port	Dudley Port	Sandwell	Sandwell	Court	N/A	52.524461	-2.0492538
20669	op-snap---monthly-publication-november-2025.pdf	211	2025-11	Car	Audi	Q3	Blue	Driving without Due Care and Attention	None	Black Lake	Black Lake	Sandwell	Sandwell	Court	N/A	52.5341947	-2.0098521
20671	op-snap---monthly-publication-november-2025.pdf	213	2025-11	Car	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Rolfe Street	Rolfe Street	Sandwell	Sandwell	Education	N/A	52.4972172	-1.9607539
20693	op-snap---monthly-publication-november-2025.pdf	235	2025-11	Car	Toyota		Silver	Driving without Due Care and Attention	None	Long Lane	Long Lane	Sandwell	Sandwell	Fixed Penalty	N/A	52.4748171	-2.0377939
20720	op-snap---monthly-publication-november-2025.pdf	262	2025-11	Car	Ford	Focus	Red	Driving without Due Care and Attention	No vehicle excise licence	Corngreaves Road	Corngreaves Road	Sandwell	Sandwell	Education	N/A	52.4686695	-2.0776976
20741	op-snap---monthly-publication-november-2025.pdf	283	2025-11	Car	Seat	Leon	Silver	Driving without Due Care and Attention	None	New Birmingham Road	New Birmingham Road	Sandwell	Sandwell	Warning Letter	N/A	52.5113475	-2.0508304
20756	op-snap---monthly-publication-november-2025.pdf	298	2025-11	Car	Scania	Tractor	White	Driving without Due Care and Attention	None	Bilston Road	Bilston Road	Sandwell	Sandwell	NFA	Not in Public Interest	52.5485881	-2.0510406
20775	op-snap---monthly-publication-november-2025.pdf	317	2025-11	Car	Volkswagen	T Cross	Grey	Driving without Due Care and Attention	None	Spon lane South	Spon lane South	Sandwell	Sandwell	Fixed Penalty	N/A	52.5059028	-1.9920373
20805	op-snap---monthly-publication-november-2025.pdf	347	2025-11	Pedestrian	Volkswagen	Crafter	Grey	Driving without Due Care and Attention	None	Market Place	Market Place	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5303627	-2.0353018
20813	op-snap---monthly-publication-november-2025.pdf	355	2025-11	Other	Fiat	500	White	Driving without Due Care and Attention	None	Oldbury Road	Oldbury Road	Sandwell	Sandwell	NFA	No Independent Evidence Available	52.5018196	-1.9811249
20939	op-snap---monthly-publication-november-2025.pdf	481	2025-11	Car	BMW	420D	Grey	Driving without Due Care and Attention	None	Coopers Lane	Coopers Lane	Sandwell	Sandwell	Warning Letter	N/A	52.4921093	-1.9705849
20953	op-snap---monthly-publication-november-2025.pdf	495	2025-11	Car	Ford	Focus	Grey	Driving without Due Care and Attention	None	Malin Streett	Malin Streett	Sandwell	Sandwell	NFA	No Independent Evidence Available
21273	op-snap---monthly-publication-november-2025.pdf	815	2025-11	Car	Volkswagen	Golf	Silver	Driving without Due Care and Attention	None	High Street Great Bridge... not sure where that is yet	High Street Great Bridge. not sure where that is yet	Sandwell	Sandwell	Education	N/A
21275	op-snap---monthly-publication-november-2025.pdf	817	2025-11	Car	Mercedes-Benz	A CLASS	Grey	Driving without Due Care and Attention	None	Birmingham Road Oldbury	Birmingham Road Oldbury	Sandwell	Sandwell	Warning Letter	N/A	52.5025832	-2.0105737
21367	op-snap---monthly-publication-november-2025.pdf	909	2025-11	Car	BMW	118d	Black	Driving without Due Care and Attention	None	All Saints Way	All Saints Way	Sandwell	Sandwell	RTC - Actioned	N/A	52.5344405	-1.985568
21456	op-snap---monthly-publication-november-2025.pdf	998	2025-11	Car	Seat	Leon	Grey	Driving without Due Care and Attention	None	Claremont Street / Reddal Hill Road	Claremont Street / Reddal Hill Road	Sandwell	Sandwell	Court	N/A	52.4755356	-2.0727906
21543	op-snap---monthly-publication-november-2025.pdf	1085	2025-11	Car	Dennis	Bus		Driving without Due Care and Attention	None	Dudley Stree, Carters Green, West Bromwich	Dudley Stree, Carters Green, West Bromwich	Sandwell	Sandwell	Education	N/A
21555	op-snap---monthly-publication-november-2025.pdf	1097	2025-11	Car	Mercedes-Benz	C250	Black	Driving without Due Care and Attention	None	Londonderry Lane	Londonderry Lane	Sandwell	Sandwell	NFA	No Offence	52.4910374	-1.9779539
21556	op-snap---monthly-publication-november-2025.pdf	1098	2025-11	Car	Vauxhall	Vivaro	Silver	Driving without Due Care and Attention	None	Newton Road	Newton Road	Sandwell	Sandwell	NFA	No Offence	52.5428224	-1.9569444
21592	op-snap---monthly-publication-november-2025.pdf	1134	2025-11	Car	Mercedes-Benz	GLE 450	Black	Driving without Due Care and Attention	None	M5	M5	Sandwell	Sandwell	NFA	No Offence
21902	op-snap---monthly-publication-november-2025.pdf	1444	2025-11	Car	Ford	Focus	Grey	Driving without Due Care and Attention	None	A41	A41	Sandwell	Sandwell	Warning Letter	N/A

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