opsnap: reports: 592 rows where month = "2025-09" 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'}

592 rows where month = "2025-09" 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
23781	op-snap---monthly-publication-september-2025.pdf	0	2025-09	Other	Skoda	Fabia	White	Driving without Due Care and Attention	None	Waterfron main car park	Waterfron main car park	Dudley	Dudley	Warning Letter	N/A
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
23788	op-snap---monthly-publication-september-2025.pdf	7	2025-09	Pedal Bike	Mercedes-Benz	Sprinter	Silver	Driving without Due Care and Attention	None	Moor Green lane	Moor Green lane	Birmingham	Birmingham	Education	N/A	52.4374665	-1.9119895
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
23792	op-snap---monthly-publication-september-2025.pdf	11	2025-09	Other		Unknown		Driving without Due Care and Attention	None	Unknown		Out of Force Area	Out of Force Area	NFA	Out of Force
23793	op-snap---monthly-publication-september-2025.pdf	12	2025-09	Other	Vauxhall	Grandland	Red	Driving without Due Care and Attention	None	Norwood Road	Norwood Road	Dudley	Dudley	Fixed Penalty	N/A	52.4831397	-2.1309273
23794	op-snap---monthly-publication-september-2025.pdf	13	2025-09	Other	Volkswagen	Polo	Blue	Driving without Due Care and Attention	None	Norwood Road	Norwood Road	Dudley	Dudley	Fixed Penalty	N/A	52.4831397	-2.1309273
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
23802	op-snap---monthly-publication-september-2025.pdf	21	2025-09	Pedal Bike	Kia	Sportage	Green	Driving without Due Care and Attention	None	Belgrave Road	Belgrave Road	Birmingham	Birmingham	Education	N/A	52.4669004	-1.9011385
23806	op-snap---monthly-publication-september-2025.pdf	25	2025-09	Other		Moto bike	Blue	Driving without Due Care and Attention	None	Poplar Avenue	Poplar Avenue	Walsall	Walsall	NFA	No VRM	52.5945052	-2.0227343
23807	op-snap---monthly-publication-september-2025.pdf	26	2025-09	Horse Rider	Volvo	V70	Blue	Driving without Due Care and Attention	No vehicle excise licence	Dark lane, Wythall	Dark lane, Wythall	Birmingham	Birmingham	NFA	No Independent Evidence Available
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
23810	op-snap---monthly-publication-september-2025.pdf	29	2025-09	Pedestrian	Kia	Rio	Red	Driving without Due Care and Attention	None	Cannock Road	Cannock Road	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.6083917	-2.1033365
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
23820	op-snap---monthly-publication-september-2025.pdf	39	2025-09	Pedal Bike	Skoda	SUV	Grey	Driving without Due Care and Attention	None	Weston Road Evesham	Weston Road Evesham	Out of Force Area	Out of Force Area	NFA	Out of Force
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
23855	op-snap---monthly-publication-september-2025.pdf	74	2025-09	Pedal Bike	Peugeot	107	Silver	Driving without Due Care and Attention	None	Wolverhampton Rd , jn with Dimmock Street	Wolverhampton Road , jn with Dimmock Street	Wolverhampton	Wolverhampton	Education	N/A
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
23859	op-snap---monthly-publication-september-2025.pdf	78	2025-09	Other	Volkswagen	Golf	Silver	Driving without Due Care and Attention	None	Western Avenue	Western Avenue	Wolverhampton	Wolverhampton	NFA	No Offence
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
23881	op-snap---monthly-publication-september-2025.pdf	100	2025-09	Pedal Bike	Land Rover	Evoque	White	Driving without Due Care and Attention	None	Corporation Street	Corporation Street	Coventry	Coventry	Warning Letter	N/A	52.4086244	-1.515132
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
23903	op-snap---monthly-publication-september-2025.pdf	122	2025-09	Other	BMW	X6	White	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.4203897	-1.8338574
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
23914	op-snap---monthly-publication-september-2025.pdf	133	2025-09	Other	Kia	Picanto	Yellow	Driving without Due Care and Attention	None	Waterfront Car Park	Waterfront Car Park	Dudley	Dudley	Court	N/A
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
23918	op-snap---monthly-publication-september-2025.pdf	137	2025-09	Other		Teyin	Black	Driving without Due Care and Attention	No Insurance	Waterfront Merry Hill	Waterfront Merry Hill	Dudley	Dudley	Court	N/A	52.4874176	-2.1129449
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
23920	op-snap---monthly-publication-september-2025.pdf	139	2025-09	Other	Peugeot	208 Active	Black	Driving without Due Care and Attention	None	Watson Road	Watson Road	Birmingham	Birmingham	Fixed Penalty	N/A	52.4897107	-1.839943
23924	op-snap---monthly-publication-september-2025.pdf	143	2025-09	Other	Volkswagen	Sharan	Silver	Driving without Due Care and Attention	None	M5	M5	Sandwell	Sandwell	NFA	No Independent Evidence Available
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
23946	op-snap---monthly-publication-september-2025.pdf	165	2025-09	Pedal Bike	Mitsubishi	L200	Red	Driving without Due Care and Attention	None	Hereford	Hereford	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4047807	-2.0101216
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
23964	op-snap---monthly-publication-september-2025.pdf	183	2025-09	Pedal Bike	Mercedes-Benz	C220	Grey	Driving without Due Care and Attention	None	Evesham	Evesham	Out of Force Area	Out of Force Area	NFA	Out of Force	52.3837388	-1.5529669
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
23974	op-snap---monthly-publication-september-2025.pdf	193	2025-09	Pedal Bike		M/C	Black	Driving without Due Care and Attention	None	Lickey Road	Lickey Road	Birmingham	Birmingham	NFA	No VRM	52.3868298	-2.0003781
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

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