opsnap: reports: 430 rows where month = "2025-09", offence = "Driving without Due Care and Attention" and reporter_transport

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

430 rows where month = "2025-09", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" 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
23785	op-snap---monthly-publication-september-2025.pdf	4	2025-09	Car		U/K	White	Driving without Due Care and Attention	None	M6.	M6	Birmingham	Birmingham	RTC - Actioned	N/A
23786	op-snap---monthly-publication-september-2025.pdf	5	2025-09	Car	Tesla	Model 3	Grey	Driving without Due Care and Attention	None	Coventry Road, Small Heath	Coventry Road, Small Heath	Birmingham	Birmingham	Warning Letter	N/A	52.4650893	-1.8425008
23787	op-snap---monthly-publication-september-2025.pdf	6	2025-09	Car	Hyundai	Bayon	Blue	Driving without Due Care and Attention	None	Dartmouth Middleway	Dartmouth Middleway	Birmingham	Birmingham	RTC - Actioned	N/A	52.4861917	-1.8829748
23789	op-snap---monthly-publication-september-2025.pdf	8	2025-09	Car		Jaecoo	Silver	Driving without Due Care and Attention	None	B4154 Norton Road - Pelsall	Norton Road - Pelsall	Walsall	Walsall	Education	N/A	52.6337623	-1.9674818
23795	op-snap---monthly-publication-september-2025.pdf	14	2025-09	Car	Renault	Clio	Blue	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	Court	N/A	52.4203897	-1.8338574
23797	op-snap---monthly-publication-september-2025.pdf	16	2025-09	Car	Ford	Focus	Blue	Driving without Due Care and Attention	None	Lugtrout Lane	Lugtrout Lane	Solihull	Solihull	NFA	Outside of 14 DAYS Late Submission	52.4227108	-1.7443257
23798	op-snap---monthly-publication-september-2025.pdf	17	2025-09	Car	BMW	3	Blue	Driving without Due Care and Attention	None	Lugtrout Lane	Lugtrout Lane	Solihull	Solihull	NFA	Outside of 14 DAYS Late Submission	52.4227108	-1.7443257
23799	op-snap---monthly-publication-september-2025.pdf	18	2025-09	Car	Volvo		Black	Driving without Due Care and Attention	None	Camp Hill	Camp Hill	Birmingham	Birmingham	Warning Letter	N/A	52.4702894	-1.8786299
23808	op-snap---monthly-publication-september-2025.pdf	27	2025-09	Car	Toyota	Prius	Black	Driving without Due Care and Attention	None	Gravelly Lane	Gravelly Lane	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.534608	-1.8379769
23809	op-snap---monthly-publication-september-2025.pdf	28	2025-09	Car	BMW	M4 Comp	Blue	Driving without Due Care and Attention	None	A45 approaching M42	A45 approaching M42	Solihull	Solihull	Court	N/A
23812	op-snap---monthly-publication-september-2025.pdf	31	2025-09	Car	Toyota	Yaris	Silver	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	NFA	No Offence	52.5919543	-1.8517118
23815	op-snap---monthly-publication-september-2025.pdf	34	2025-09	Car	Skoda	Octavia	Blue	Driving without Due Care and Attention	None	Consitiution Hill	Consitiution Hill	Birmingham	Birmingham	Education	N/A
23816	op-snap---monthly-publication-september-2025.pdf	35	2025-09	Car	Audi	A3	Grey	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	NFA	Outside of 14 DAYS Late Submission	52.4203897	-1.8338574
23817	op-snap---monthly-publication-september-2025.pdf	36	2025-09	Car	Volkswagen	Touran	Red	Driving without Due Care and Attention	None	Bloxwich Road	Bloxwich Road	Walsall	Walsall	Court	N/A	52.6099132	-1.9970978
23823	op-snap---monthly-publication-september-2025.pdf	42	2025-09	Car	Audi	A3	White	Driving without Due Care and Attention	None	A52 Skegness	Skegness	Out of Force Area	Out of Force Area	NFA	Out of Force
23827	op-snap---monthly-publication-september-2025.pdf	46	2025-09	Car	BMW	M140I	Black	Driving without Due Care and Attention	None	Tipton Road	Tipton Road	Sandwell	Sandwell	Court	N/A	52.5157798	-2.0437191
23838	op-snap---monthly-publication-september-2025.pdf	57	2025-09	Car	Volvo	HGV	Red	Driving without Due Care and Attention	None	M42?	M42?	Solihull	Solihull	NFA	Outside of 14 DAYS Late Submission	52.3757082	-1.7893409
23840	op-snap---monthly-publication-september-2025.pdf	59	2025-09	Car	Nissan	Primastar	Grey	Driving without Due Care and Attention	None	A4036 Merry Hill	Merry Hill	Dudley	Dudley	NFA	Outside of 14 DAYS Late Submission	52.4817646	-2.1113435
23842	op-snap---monthly-publication-september-2025.pdf	61	2025-09	Car	Renault	clio	Black	Driving without Due Care and Attention	None	A5 - Staffs	A5 - Staffs	Out of Force Area	Out of Force Area	NFA	Out of Force	52.6562446	-1.9182118
23844	op-snap---monthly-publication-september-2025.pdf	63	2025-09	Car	Ford	B Max	Gold	Driving without Due Care and Attention	None	Castle Bromwich Interchange	Castle Bromwich Interchange	Birmingham	Birmingham	Warning Letter	N/A
23846	op-snap---monthly-publication-september-2025.pdf	65	2025-09	Car	Mercedes-Benz	Smart ForTwo	Black	Driving without Due Care and Attention	No Insurance	Roberts Street	Roberts Street	Dudley	Dudley	Court	N/A	52.5213135	-2.1197042
23848	op-snap---monthly-publication-september-2025.pdf	67	2025-09	Car	Mercedes-Benz		Black	Driving without Due Care and Attention	None	Shrewsbury	Shrewsbury	Out of Force Area	Out of Force Area	NFA	Out of Force	52.6195535	-2.0193824
23856	op-snap---monthly-publication-september-2025.pdf	75	2025-09	Car	Renault	Clio	Blue	Driving without Due Care and Attention	None	Birchley Island	Birchley Island	Sandwell	Sandwell	Education	N/A	52.4926604	-2.0216743
23857	op-snap---monthly-publication-september-2025.pdf	76	2025-09	Car	Vauxhall	Zafira	Black	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Court	N/A	52.5292752	-1.7618805
23860	op-snap---monthly-publication-september-2025.pdf	79	2025-09	Car	Skoda	Fabia	Grey	Driving without Due Care and Attention	None	Bridge Road at Atlas Mill Road (West Yorkshire)	Bridge Road at Atlas Mill Road (West Yorkshire)	Out of Force Area	Out of Force Area	NFA	Out of Force
23862	op-snap---monthly-publication-september-2025.pdf	81	2025-09	Car	Volkswagen	Golf	Red	Driving without Due Care and Attention	None	Wills Street	Wills Street	Birmingham	Birmingham	Warning Letter	N/A	52.500453	-1.9141126
23863	op-snap---monthly-publication-september-2025.pdf	82	2025-09	Car	Vauxhall	Corsa	Black	Driving without Due Care and Attention	None	Hamstead Road	Hamstead Road	Birmingham	Birmingham	Court	N/A	52.505832	-1.92002
23864	op-snap---monthly-publication-september-2025.pdf	83	2025-09	Car	Volkswagen	T-Roc	Silver	Driving without Due Care and Attention	None	Collingswood Drive	Collingswood Drive	Birmingham	Birmingham	Warning Letter	N/A
23866	op-snap---monthly-publication-september-2025.pdf	85	2025-09	Car	BMW	520..	Black	Driving without Due Care and Attention	None	Newport Road (Staffs)	Newport Road (Staffs)	Out of Force Area	Out of Force Area	NFA	Out of Force
23869	op-snap---monthly-publication-september-2025.pdf	88	2025-09	Car	Volkswagen		White	Driving without Due Care and Attention	None	Hednesford	Hednesford	Out of Force Area	Out of Force Area	NFA	Out of Force	52.6580164	-1.9487512
23870	op-snap---monthly-publication-september-2025.pdf	89	2025-09	Car	Audi	RS 3	Black	Driving without Due Care and Attention	None	Wake Green Road	Wake Green Road	Birmingham	Birmingham	Court	N/A	52.4437078	-1.8783408
23871	op-snap---monthly-publication-september-2025.pdf	90	2025-09	Car	Audi	Q3	black	Driving without Due Care and Attention	None	West Bromwich Street, Oldbury Road	West Bromwich Street, Oldbury Road	Sandwell	Sandwell	Other Action Taken	N/A
23872	op-snap---monthly-publication-september-2025.pdf	91	2025-09	Car	Vauxhall	Mokka	White	Driving without Due Care and Attention	None	Wolverhampton Road	Wolverhampton Road	Birmingham	Birmingham	Warning Letter	N/A	52.463146	-1.9844677
23877	op-snap---monthly-publication-september-2025.pdf	96	2025-09	Car	Toyota	C-HR	Grey	Driving without Due Care and Attention	None	M6 at Junction 10	M6 at Junction 10	Walsall	Walsall	Court	N/A
23878	op-snap---monthly-publication-september-2025.pdf	97	2025-09	Car	BMW	330..	Black	Driving without Due Care and Attention	None	Stafford Road	Stafford Road	Out of Force Area	Out of Force Area	NFA	Out of Force	52.5039962	-1.9310883
23880	op-snap---monthly-publication-september-2025.pdf	99	2025-09	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Eardiston, towards Tenbury Wells, West Mercia	Eardiston, towards Tenbury Wells, West Mercia	Out of Force Area	Out of Force Area	NFA	Out of Force
23885	op-snap---monthly-publication-september-2025.pdf	104	2025-09	Car	Vauxhall	Corsa	White	Driving without Due Care and Attention	None	A42	A42	Out of Force Area	Out of Force Area	NFA	Out of Force
23888	op-snap---monthly-publication-september-2025.pdf	107	2025-09	Car				Driving without Due Care and Attention	None	Princess Alice	Princess Alice	Sutton Coldfield	Sutton Coldfield	NFA	No Independent Evidence Available	52.5499257	-1.859279
23889	op-snap---monthly-publication-september-2025.pdf	108	2025-09	Car	Mercedes-Benz	A35 AMG	Yellow	Driving without Due Care and Attention	None	Alcester Road	Alcester Road	Birmingham	Birmingham	Education	N/A	52.4470686	-1.8880749
23890	op-snap---monthly-publication-september-2025.pdf	109	2025-09	Car	Chevrolet	Orlando	Silver	Driving without Due Care and Attention	None	Duncan Edwards Way	Duncan Edwards Way	Dudley	Dudley	Warning Letter	N/A	52.5047428	-2.0823754
23891	op-snap---monthly-publication-september-2025.pdf	110	2025-09	Car	Nissan	Qashqai	Red	Driving without Due Care and Attention	None	Heathfield Road	Heathfield Road	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.5905365	-1.8453418
23895	op-snap---monthly-publication-september-2025.pdf	114	2025-09	Car	Daf	Lorry	Red	Driving without Due Care and Attention	None	M42	M42	Solihull	Solihull	NFA	No Independent Evidence Available
23897	op-snap---monthly-publication-september-2025.pdf	116	2025-09	Car	Land Rover	Evoque	Black	Driving without Due Care and Attention	None	M6-M1	M6-M1	Out of Force Area	Out of Force Area	NFA	Out of Force	52.5223936	-1.8804806
23898	op-snap---monthly-publication-september-2025.pdf	117	2025-09	Car	BMW	3 series	Black	Driving without Due Care and Attention	None	Aldridge Road	Aldridge Road	Birmingham	Birmingham	Education	N/A	52.5368764	-1.8976461
23905	op-snap---monthly-publication-september-2025.pdf	124	2025-09	Car	BMW		Silver	Driving without Due Care and Attention	None	Tamworth Road	Tamworth Road	Coventry	Coventry	NFA	No Offence	52.4380313	-1.5339558
23907	op-snap---monthly-publication-september-2025.pdf	126	2025-09	Car	Porsche	NP	Silver	Driving without Due Care and Attention	None	Oxhill to Banbury	Oxhill to Banbury	Out of Force Area	Out of Force Area	NFA	Out of Force
23908	op-snap---monthly-publication-september-2025.pdf	127	2025-09	Car	BMW	X3	Grey	Driving without Due Care and Attention	None	Cartland Road	Cartland Road	Birmingham	Birmingham	Court	N/A	52.4298554	-1.9086629
23911	op-snap---monthly-publication-september-2025.pdf	130	2025-09	Car	Ford	Mach	Black	Driving without Due Care and Attention	None	Littleton Street East	Littleton Street East	Walsall	Walsall	Education	N/A	52.5887823	-1.9801166
23912	op-snap---monthly-publication-september-2025.pdf	131	2025-09	Car	Mitsubishi		Black	Driving without Due Care and Attention	None	Over Causeway	Over Causeway	Out of Force Area	Out of Force Area	NFA	Out of Force
23915	op-snap---monthly-publication-september-2025.pdf	134	2025-09	Car	Ford	Mondeo	Black	Driving without Due Care and Attention	None	A45 to Stonbridge	A45 to Stonbridge	Birmingham	Birmingham	Fixed Penalty	N/A
23916	op-snap---monthly-publication-september-2025.pdf	135	2025-09	Car	Ford	Fusion	Black	Driving without Due Care and Attention	None	Melton Avenue	Melton Avenue	Birmingham	Birmingham	Fixed Penalty	N/A
23917	op-snap---monthly-publication-september-2025.pdf	136	2025-09	Car	Suzuki	GSXS	Black	Driving without Due Care and Attention	None	A449	A449	Dudley	Dudley	Warning Letter	N/A
23919	op-snap---monthly-publication-september-2025.pdf	138	2025-09	Car	Hyundai	Tuscon	Grey	Driving without Due Care and Attention	None	Bridgnorth Road	Bridgnorth Road	Dudley	Dudley	Court	N/A	52.4603456	-2.1716457
23927	op-snap---monthly-publication-september-2025.pdf	146	2025-09	Car	Mercedes-Benz	A200	Black	Driving without Due Care and Attention	None	Bradley Road (Donnington)	Bradley Road (Donnington)	Out of Force Area	Out of Force Area	NFA	Out of Force
23931	op-snap---monthly-publication-september-2025.pdf	150	2025-09	Car	BMW	118..	White	Driving without Due Care and Attention	None	Matalan roundabout (Redditch)	Matalan roundabout (Redditch)	Out of Force Area	Out of Force Area	NFA	Out of Force
23932	op-snap---monthly-publication-september-2025.pdf	151	2025-09	Car	Audi	Q7..	Grey	Driving without Due Care and Attention	None	Spitfire island	Spitfire island	Birmingham	Birmingham	Education	N/A	52.5138106	-1.797297
23936	op-snap---monthly-publication-september-2025.pdf	155	2025-09	Car	Volvo	S90	Blue	Driving without Due Care and Attention	None	Robin Hood Island	Robin Hood Island	Birmingham	Birmingham	Warning Letter	N/A	52.4220705	-1.8372335
23938	op-snap---monthly-publication-september-2025.pdf	157	2025-09	Car	Volvo	XC60	Silver	Driving without Due Care and Attention	None	A444	A444	Out of Force Area	Out of Force Area	NFA	Out of Force
23940	op-snap---monthly-publication-september-2025.pdf	159	2025-09	Car	Skoda	Yeti	Black	Driving without Due Care and Attention	None	A5 Wodcote Roundabout	Wodcote Roundabout	Out of Force Area	Out of Force Area	NFA	Out of Force
23943	op-snap---monthly-publication-september-2025.pdf	162	2025-09	Car	Seat	Ibiza	Black	Driving without Due Care and Attention	None	Yardley Green Road	Yardley Green Road	Birmingham	Birmingham	Education	N/A	52.4764154	-1.8311418
23945	op-snap---monthly-publication-september-2025.pdf	164	2025-09	Car	Nissan	Qashqai	Grey	Driving without Due Care and Attention	None	Bosworth Drive	Bosworth Drive	Birmingham	Birmingham	Fixed Penalty	N/A	52.4779726	-1.7596871
23947	op-snap---monthly-publication-september-2025.pdf	166	2025-09	Car	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	Ulverley Green Road	Ulverley Green Road	Solihull	Solihull	Education	N/A	52.4367749	-1.80129
23949	op-snap---monthly-publication-september-2025.pdf	168	2025-09	Car	Ford	Transit	White	Driving without Due Care and Attention	None	M1	M1	Out of Force Area	Out of Force Area	NFA	Out of Force
23952	op-snap---monthly-publication-september-2025.pdf	171	2025-09	Car	Ford	Transit	Grey	Driving without Due Care and Attention	None	Wagon Lane	Wagon Lane	Solihull	Solihull	Education	N/A	52.4525076	-1.7981031
23953	op-snap---monthly-publication-september-2025.pdf	172	2025-09	Car	Audi	RS4	Grey	Driving without Due Care and Attention	None	A34 Cannock	Cannock	Out of Force Area	Out of Force Area	NFA	Out of Force
23955	op-snap---monthly-publication-september-2025.pdf	174	2025-09	Car	Toyota	Corolla	Black	Driving without Due Care and Attention	None	Warwick Road Acocks Green	Warwick Road Acocks Green	Birmingham	Birmingham	Education	N/A	52.4468495	-1.8244484
23957	op-snap---monthly-publication-september-2025.pdf	176	2025-09	Car	Land Rover	Evoque	White	Driving without Due Care and Attention	None	Bradford Road	Bradford Road	Birmingham	Birmingham	NFA	No Offence	52.5024148	-1.7961753
23958	op-snap---monthly-publication-september-2025.pdf	177	2025-09	Car	Seat	Ibiza	Grey	Driving without Due Care and Attention	None	A45 Coventry Road	Coventry Road	Birmingham	Birmingham	Education	N/A	52.4726661	-1.8769032
23959	op-snap---monthly-publication-september-2025.pdf	178	2025-09	Car	Land Rover	Evoque	Black	Driving without Due Care and Attention	None	Chester road at Jct with Buckingham road	Chester road at Junction with Buckingham road	Solihull	Solihull	Fixed Penalty	N/A	52.5035196	-1.7754844
23960	op-snap---monthly-publication-september-2025.pdf	179	2025-09	Car	Mg	3 Trophy	White	Driving without Due Care and Attention	None	B4173	B4173	Birmingham	Birmingham	NFA	Misc Inc Crimes	52.4496153	-1.8646204
23962	op-snap---monthly-publication-september-2025.pdf	181	2025-09	Car	Volkswagen	Passatt	Grey	Driving without Due Care and Attention	None	A590	A590	Out of Force Area	Out of Force Area	NFA	Out of Force
23966	op-snap---monthly-publication-september-2025.pdf	185	2025-09	Car		NP		Driving without Due Care and Attention	None	Out of force - Telford	Out of force - Telford	Out of Force Area	Out of Force Area	NFA	Out of Force
23968	op-snap---monthly-publication-september-2025.pdf	187	2025-09	Car	Vauxhall	Zafira	Blue	Driving without Due Care and Attention	None	Binley Road	Binley Road	Coventry	Coventry	NFA	No Offence	52.4070602	-1.4732469
23971	op-snap---monthly-publication-september-2025.pdf	190	2025-09	Car	Volvo	XC60	Grey	Driving without Due Care and Attention	None	Not detailed.	Not detailed	Out of Force Area	Out of Force Area	NFA	Out of Force
23972	op-snap---monthly-publication-september-2025.pdf	191	2025-09	Car	Volkswagen	Caddy	Blue	Driving without Due Care and Attention	None	M40 near Warwick	M40 near Warwick	Out of Force Area	Out of Force Area	NFA	Out of Force	52.3755033	-1.6086853
23973	op-snap---monthly-publication-september-2025.pdf	192	2025-09	Car	Vauxhall	Insignia	Silver	Driving without Due Care and Attention	None	M6 SB J7	M6 Southbound J7	Birmingham	Birmingham	NFA	No Offence	52.676119	-2.0858425
23975	op-snap---monthly-publication-september-2025.pdf	194	2025-09	Car	Vauxhall	Astra	Silver	Driving without Due Care and Attention	None	George Street Ringway, Bedworth	George Street Ringway, Bedworth	Out of Force Area	Out of Force Area	NFA	Out of Force
23976	op-snap---monthly-publication-september-2025.pdf	195	2025-09	Car	BMW	320..	White	Driving without Due Care and Attention	None	A38 Aston Expressway	Aston Expressway	Birmingham	Birmingham	Education	N/A	52.493793	-1.8881773
23977	op-snap---monthly-publication-september-2025.pdf	196	2025-09	Car	Peugeot	Boxer	White	Driving without Due Care and Attention	None	Griff Roundabout, Nuneaton	Griff Roundabout, Nuneaton	Out of Force Area	Out of Force Area	NFA	Out of Force
23978	op-snap---monthly-publication-september-2025.pdf	197	2025-09	Car	Ford	Fiesta	Black	Driving without Due Care and Attention	None	Curzon Circus	Curzon Circus	Birmingham	Birmingham	Warning Letter	N/A
23981	op-snap---monthly-publication-september-2025.pdf	200	2025-09	Car		Husqvarna	White	Driving without Due Care and Attention	None	Melchett Road	Melchett Road	Birmingham	Birmingham	Education	N/A	52.413984	-1.9251511
23983	op-snap---monthly-publication-september-2025.pdf	202	2025-09	Car	Ford	Ka	Red	Driving without Due Care and Attention	None	Grange Road, Halesowen	Grange Road, Halesowen	Sandwell	Sandwell	Education	N/A
23984	op-snap---monthly-publication-september-2025.pdf	203	2025-09	Car	Mercedes-Benz	AMG C	White	Driving without Due Care and Attention	None	Lode Lane	Lode Lane	Solihull	Solihull	Education	N/A	52.4149064	-1.7832364
23985	op-snap---monthly-publication-september-2025.pdf	204	2025-09	Car	Ford	Fiesta	Blue	Driving without Due Care and Attention	None	M54 WB J3-6	M54 Wb J3-6	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4846642	-1.9297585
23986	op-snap---monthly-publication-september-2025.pdf	205	2025-09	Car	BMW	320..	White	Driving without Due Care and Attention	None	Wash Lane Yardley Wood	Wash Lane Yardley Wood	Birmingham	Birmingham	Fixed Penalty	N/A
23987	op-snap---monthly-publication-september-2025.pdf	206	2025-09	Car	Volvo	V90	White	Driving without Due Care and Attention	None	Broadmeadow Lane	Broadmeadow Lane	Birmingham	Birmingham	Education	N/A
23991	op-snap---monthly-publication-september-2025.pdf	210	2025-09	Car	Seat	Leon	Black	Driving without Due Care and Attention	None	Small Heath Highway	Small Heath Highway	Birmingham	Birmingham	NFA	No Offence	52.4709298	-1.8722585
23994	op-snap---monthly-publication-september-2025.pdf	213	2025-09	Car	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Fort Parkway	Fort Parkway	Birmingham	Birmingham	Court	N/A	52.50787	-1.8195713
23995	op-snap---monthly-publication-september-2025.pdf	214	2025-09	Car	Mercedes-Benz	Citan	Silver	Driving without Due Care and Attention	No Insurance	Spring Street Tipton	Spring Street Tipton	Sandwell	Sandwell	Fixed Penalty	N/A	52.5296804	-2.0574857
24001	op-snap---monthly-publication-september-2025.pdf	220	2025-09	Car	Audi	A6	Grey	Driving without Due Care and Attention	None	Turves Green, Longbridge	Turves Green, Longbridge	Birmingham	Birmingham	NFA	No Offence	52.3964205	-1.9697415
24003	op-snap---monthly-publication-september-2025.pdf	222	2025-09	Car	BMW	3 series	Silver	Driving without Due Care and Attention	None	Hurdis Road, Shirley	Hurdis Road, Shirley	Solihull	Solihull	Court	N/A	52.4086106	-1.8349619
24004	op-snap---monthly-publication-september-2025.pdf	223	2025-09	Car	Mercedes-Benz	A200	Purple	Driving without Due Care and Attention	None	Lickey Road	Lickey Road	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.3868298	-2.0003781
24008	op-snap---monthly-publication-september-2025.pdf	227	2025-09	Car	BMW	118i	Blue	Driving without Due Care and Attention	None	M6 SB J10	M6 Southbound J10	Wolverhampton	Wolverhampton	NFA	No Offence	52.676119	-2.0858425
24012	op-snap---monthly-publication-september-2025.pdf	231	2025-09	Car	Volkswagen	Golf	Grey	Driving without Due Care and Attention	None	Leamington Road	Leamington Road	Coventry	Coventry	Education	N/A	52.3921304	-1.5156601
24017	op-snap---monthly-publication-september-2025.pdf	236	2025-09	Car	Land Rover	Range Rover	Black	Driving without Due Care and Attention	None	Neachells Lane	Neachells Lane	Wolverhampton	Wolverhampton	NFA	No Offence	52.597459	-2.0791894
24019	op-snap---monthly-publication-september-2025.pdf	238	2025-09	Car	Mercedes-Benz	E200	Blue	Driving without Due Care and Attention	None	M6 Motorway	M6 Motorway	Coventry	Coventry	Education	N/A
24024	op-snap---monthly-publication-september-2025.pdf	243	2025-09	Car	Nissan	Qashqai	Black	Driving without Due Care and Attention	None	Deelands Road	Deelands Road	Birmingham	Birmingham	Warning Letter	N/A	52.3970488	-2.0184857
24028	op-snap---monthly-publication-september-2025.pdf	247	2025-09	Car	Audi	A3	Black	Driving without Due Care and Attention	None	Queslett Road	Queslett Road	Birmingham	Birmingham	NFA	Not in Public Interest	52.5458699	-1.9304484
24029	op-snap---monthly-publication-september-2025.pdf	248	2025-09	Car	Volkswagen	Passat	Black	Driving without Due Care and Attention	None	Gerrard Street	Gerrard Street	Birmingham	Birmingham	Warning Letter	N/A	52.5002335	-1.9032351
24030	op-snap---monthly-publication-september-2025.pdf	249	2025-09	Car	Audi	Q5	Blue	Driving without Due Care and Attention	None	Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032

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