opsnap: reports: 125 rows where disposal = "Education", 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'}

125 rows where disposal = "Education", 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
23982	op-snap---monthly-publication-september-2025.pdf	201	2025-09	Pedal Bike	Ford	Focus	Black	Driving without Due Care and Attention	No vehicle excise licence	Holly Lane, Marston Green	Holly Lane, Marston Green	Birmingham	Birmingham	Education	N/A
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
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
23990	op-snap---monthly-publication-september-2025.pdf	209	2025-09	Other	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Waterfront Car Park	Waterfront Car Park	Dudley	Dudley	Education	N/A
23998	op-snap---monthly-publication-september-2025.pdf	217	2025-09	Pedal Bike	Vauxhall	Corsa	Black	Driving without Due Care and Attention	None	Church Road Edgbaston	Church Road Edgbaston	Birmingham	Birmingham	Education	N/A	52.46114	-1.9180882
24010	op-snap---monthly-publication-september-2025.pdf	229	2025-09	Pedal Bike	BMW	118	Black	Driving without Due Care and Attention	None	Wylde Green Road	Wylde Green Road	Sutton Coldfield	Sutton Coldfield	Education	N/A	52.546976	-1.8098124
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
24015	op-snap---monthly-publication-september-2025.pdf	234	2025-09	Pedal Bike	BMW	120d	White	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Walsall	Walsall	Education	N/A	52.6166864	-1.9660822
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
24023	op-snap---monthly-publication-september-2025.pdf	242	2025-09	Pedal Bike	Ford	Focus	Red	Driving without Due Care and Attention	None	Tixall Road Shirley	Tixall Road Shirley	Birmingham	Birmingham	Education	N/A
24037	op-snap---monthly-publication-september-2025.pdf	256	2025-09	Pedal Bike	Hyundai	Tucson	Blue	Driving without Due Care and Attention	None	Chester Road North	Chester Road North	Birmingham	Birmingham	Education	N/A	52.548449	-1.8594603
24042	op-snap---monthly-publication-september-2025.pdf	261	2025-09	Pedal Bike	Tesla		Black	Driving without Due Care and Attention	None	Wylde Green Road	Wylde Green Road	Sutton Coldfield	Sutton Coldfield	Education	N/A	52.546976	-1.8098124
24050	op-snap---monthly-publication-september-2025.pdf	269	2025-09	Car	Mg	ZS	Grey	Driving without Due Care and Attention	None	Broadway Road	Broadway Road	Walsall	Walsall	Education	N/A	52.5740759	-1.9628886
24054	op-snap---monthly-publication-september-2025.pdf	273	2025-09	Car	BMW	S1000RR	White	Driving without Due Care and Attention	None	Sundial Lane	Sundial Lane	Birmingham	Birmingham	Education	N/A	52.5471217	-1.9336068
24081	op-snap---monthly-publication-september-2025.pdf	300	2025-09	Car	Seat	Leon	White	Driving without Due Care and Attention	None	Jimmy Hill Way	Jimmy Hill Way	Coventry	Coventry	Education	N/A	52.4214017	-1.4870278
24087	op-snap---monthly-publication-september-2025.pdf	306	2025-09	Car	Citroen	C3	Grey	Driving without Due Care and Attention	None	Moorend Avenue	Moorend Avenue	Birmingham	Birmingham	Education	N/A
24090	op-snap---monthly-publication-september-2025.pdf	309	2025-09	Pedal Bike	Hyundai	I20	Grey	Driving without Due Care and Attention	None	Turners Lane	Turners Lane	Dudley	Dudley	Education	N/A	52.4721372	-2.1243522
24105	op-snap---monthly-publication-september-2025.pdf	324	2025-09	Pedal Bike	Renault	Traffic	Black	Driving without Due Care and Attention	None	Kenilworth Road	Kenilworth Road	Solihull	Solihull	Education	N/A	52.4322443	-1.6746508
24106	op-snap---monthly-publication-september-2025.pdf	325	2025-09	Pedal Bike	Volvo	XC40	Black	Driving without Due Care and Attention	None	Gower Street	Gower Street	Walsall	Walsall	Education	N/A	52.5737189	-2.0065411
24109	op-snap---monthly-publication-september-2025.pdf	328	2025-09	Car	Kia	Sportage	Black	Driving without Due Care and Attention	None	Finchley Road	Finchley Road	Birmingham	Birmingham	Education	N/A	52.5488456	-1.8735092
24114	op-snap---monthly-publication-september-2025.pdf	333	2025-09	Pedal Bike	Peugeot	Partner	Grey	Driving without Due Care and Attention	None	Tipton Road	Tipton Road	Dudley	Dudley	Education	N/A	52.5198386	-2.0740876
24119	op-snap---monthly-publication-september-2025.pdf	338	2025-09	Pedal Bike	Mercedes-Benz	C220	Black	Driving without Due Care and Attention	None	Tat Bank Road	Tat Bank Road	Sandwell	Sandwell	Education	N/A	52.4979925	-2.0082232
24121	op-snap---monthly-publication-september-2025.pdf	340	2025-09	Pedal Bike	Seat	Leon	White	Driving without Due Care and Attention	None	Priory Road	Priory Road	Birmingham	Birmingham	Education	N/A	52.4132696	-1.8555008
24139	op-snap---monthly-publication-september-2025.pdf	358	2025-09	Car	Ford	Transit	Red	Driving without Due Care and Attention	None	Baldwin Lane	Baldwin Lane	Birmingham	Birmingham	Education	N/A	52.4151192	-1.84291
24156	op-snap---monthly-publication-september-2025.pdf	375	2025-09	Car	Seat	Alhambra	Silver	Driving without Due Care and Attention	None	Monument Road	Monument Road	Birmingham	Birmingham	Education	N/A	52.4731312	-1.930947
24165	op-snap---monthly-publication-september-2025.pdf	384	2025-09	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Chester Road North, Streetly	Chester Road North, Streetly	Sutton Coldfield	Sutton Coldfield	Education	N/A
24170	op-snap---monthly-publication-september-2025.pdf	389	2025-09	Car		Dennis lorry	White	Driving without Due Care and Attention	None	Stubbers Green Road / Brickyard Road	Stubbers Green Road / Brickyard Road	Walsall	Walsall	Education	N/A	52.615148	-1.9423921
24182	op-snap---monthly-publication-september-2025.pdf	401	2025-09	Car	Vauxhall	Corsa	Silver	Driving without Due Care and Attention	None	Walmley Road	Walmley Road	Sutton Coldfield	Sutton Coldfield	Education	N/A	52.5405351	-1.8002219
24198	op-snap---monthly-publication-september-2025.pdf	417	2025-09	Pedal Bike	BMW	2 series	Grey	Driving without Due Care and Attention	No vehicle excise licence	Clarence Road	Clarence Road	Sutton Coldfield	Sutton Coldfield	Education	N/A	52.5940902	-1.843503
24222	op-snap---monthly-publication-september-2025.pdf	441	2025-09	Motorbike	Chevrolet	Jeep Compass	Grey	Driving without Due Care and Attention	None	Roundabout, Allard Way / London Road / Humber Rd	Roundabout, Allard Way / London Road / Humber Road	Coventry	Coventry	Education	N/A
24243	op-snap---monthly-publication-september-2025.pdf	462	2025-09	Car	Ford	Focus	Blue	Driving without Due Care and Attention	None	M6 Jct 6 Southbound	M6 Junction 6 Southbound	Birmingham	Birmingham	Education	N/A	52.676119	-2.0858425
24245	op-snap---monthly-publication-september-2025.pdf	464	2025-09	Car	Toyota	Yaris	Blue	Driving without Due Care and Attention	None	Preston Road	Preston Road	Birmingham	Birmingham	Education	N/A	52.4633325	-1.8102488
24246	op-snap---monthly-publication-september-2025.pdf	465	2025-09	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Bromford Lane	Bromford Lane	Birmingham	Birmingham	Education	N/A	52.5083238	-1.8332287
24261	op-snap---monthly-publication-september-2025.pdf	480	2025-09	Car	BMW	1 Series	Black	Driving without Due Care and Attention	None	Waterfront Way	Waterfront Way	Dudley	Dudley	Education	N/A	52.4879006	-2.1188734
24268	op-snap---monthly-publication-september-2025.pdf	487	2025-09	Pedal Bike	Vauxhall	Combo	Grey	Driving without Due Care and Attention	None	Thorns Road	Thorns Road	Dudley	Dudley	Education	N/A	52.4628538	-2.1160108
24290	op-snap---monthly-publication-september-2025.pdf	509	2025-09	Car	Vauxhall	Vivaro	White	Driving without Due Care and Attention	None	All Saints Way	All Saints Way	Sandwell	Sandwell	Education	N/A	52.5344405	-1.985568
24303	op-snap---monthly-publication-september-2025.pdf	522	2025-09	Car	Volkswagen	Polo	Black	Driving without Due Care and Attention	None	Coventry Road	Coventry Road	Birmingham	Birmingham	Education	N/A	52.4726661	-1.8769032
24334	op-snap---monthly-publication-september-2025.pdf	553	2025-09	Car	BMW		White	Driving without Due Care and Attention	None	A491 High Street	High Street	Dudley	Dudley	Education	N/A	52.4779764	-2.1598371
24341	op-snap---monthly-publication-september-2025.pdf	560	2025-09	Pedal Bike	Volkswagen	Tiguan	Grey	Driving without Due Care and Attention	None	Breedon Road	Breedon Road	Birmingham	Birmingham	Education	N/A	52.4191978	-1.9251219
24343	op-snap---monthly-publication-september-2025.pdf	562	2025-09	Car	Mercedes-Benz	A Class	Red	Driving without Due Care and Attention	None	Robin Hood Lane	Robin Hood Lane	Birmingham	Birmingham	Education	N/A	52.4221526	-1.8425617
24356	op-snap---monthly-publication-september-2025.pdf	575	2025-09	Car	Toyota		Black	Driving without Due Care and Attention	None	A461 Lichfield Road	Lichfield Road	Walsall	Walsall	Education	N/A	52.6095168	-2.0493009
24357	op-snap---monthly-publication-september-2025.pdf	576	2025-09	Pedal Bike	Ford	Fiesta	Black	Driving without Due Care and Attention	None	Hob Lane	Hob Lane	Solihull	Solihull	Education	N/A	52.377539	-1.6201491
24363	op-snap---monthly-publication-september-2025.pdf	582	2025-09	Car	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	Halesowen Road	Halesowen Road	Dudley	Dudley	Education	N/A	52.4624413	-2.0175178
24368	op-snap---monthly-publication-september-2025.pdf	587	2025-09	Car	Seat	Leon	Blue	Driving without Due Care and Attention	None	Clay Lane	Clay Lane	Birmingham	Birmingham	Education	N/A	52.4509038	-1.8083784
24374	op-snap---monthly-publication-september-2025.pdf	593	2025-09	Pedal Bike	Nissan	Note	Blue	Driving without Due Care and Attention	None	Albany Road	Albany Road	Coventry	Coventry	Education	N/A	52.4006218	-1.5284125
24387	op-snap---monthly-publication-september-2025.pdf	606	2025-09	Pedal Bike	Mercedes-Benz	EQA	Blue	Driving without Due Care and Attention	None	Harborne Road	Harborne Road	Birmingham	Birmingham	Education	N/A	52.4718503	-1.9195423
24402	op-snap---monthly-publication-september-2025.pdf	621	2025-09	Car	Honda	civic	Black	Driving without Due Care and Attention	None	Bickenhill Lane	Bickenhill Lane	Birmingham	Birmingham	Education	N/A
24403	op-snap---monthly-publication-september-2025.pdf	622	2025-09	Car	Vauxhall	Zafira	Brown	Driving without Due Care and Attention	None	Bickenhill Lane	Bickenhill Lane	Birmingham	Birmingham	Education	N/A
24424	op-snap---monthly-publication-september-2025.pdf	643	2025-09	Other	Audi	A5	Grey	Driving without Due Care and Attention	None	Norwood Road	Norwood Road	Dudley	Dudley	Education	N/A	52.4831397	-2.1309273
24443	op-snap---monthly-publication-september-2025.pdf	662	2025-09	Pedal Bike	Vauxhall	Astra	Silver	Driving without Due Care and Attention	None	George Road	George Road	Birmingham	Birmingham	Education	N/A	52.5155831	-1.8598862
24457	op-snap---monthly-publication-september-2025.pdf	676	2025-09	Pedal Bike	Vauxhall	Astra	Red	Driving without Due Care and Attention	None	Holly Lane, Marston Green	Holly Lane, Marston Green	Birmingham	Birmingham	Education	N/A
24469	op-snap---monthly-publication-september-2025.pdf	688	2025-09	Car	BMW	X3	Black	Driving without Due Care and Attention	None	M42 junction 6	M42 junction 6	Solihull	Solihull	Education	N/A
24472	op-snap---monthly-publication-september-2025.pdf	691	2025-09	Pedal Bike	Skoda	Fabia	Silver	Driving without Due Care and Attention	None	Allesley Old Road	Allesley Old Road	Coventry	Coventry	Education	N/A	52.4103629	-1.5441218
24475	op-snap---monthly-publication-september-2025.pdf	694	2025-09	Pedal Bike	Mazda	3	Red	Driving without Due Care and Attention	None	The Firs	The Firs	Coventry	Coventry	Education	N/A	52.3965706	-1.523038
24491	op-snap---monthly-publication-september-2025.pdf	710	2025-09	Pedal Bike	Chysler	300C	Silver	Driving without Due Care and Attention	None	The Broadway	The Broadway	Dudley	Dudley	Education	N/A	52.515445	-2.0885791
24493	op-snap---monthly-publication-september-2025.pdf	712	2025-09	Pedal Bike	Land Rover	Evoque	Black	Driving without Due Care and Attention	None	A491 Hagley Road	Hagley Road	Dudley	Dudley	Education	N/A	52.4514139	-2.1423625
24496	op-snap---monthly-publication-september-2025.pdf	715	2025-09	Pedal Bike	Porsche	Cayman	White	Driving without Due Care and Attention	None	Great Bridge Road, Bilston	Great Bridge Road, Bilston	Wolverhampton	Wolverhampton	Education	N/A	52.5602666	-2.0579414
24501	op-snap---monthly-publication-september-2025.pdf	720	2025-09	Car	Audi	Q2	Grey	Driving without Due Care and Attention	None	Frankley Beeches Road	Frankley Beeches Road	Birmingham	Birmingham	Education	N/A	52.4094108	-1.9930633
24506	op-snap---monthly-publication-september-2025.pdf	725	2025-09	Other	Mini	Mini	White	Driving without Due Care and Attention	None	Parsons Street	Parsons Street	Dudley	Dudley	Education	N/A	52.511015	-2.0864656
24513	op-snap---monthly-publication-september-2025.pdf	732	2025-09	Pedal Bike	Seat	Leon	Grey	Driving without Due Care and Attention	None	Wall Hill Road	Wall Hill Road	Coventry	Coventry	Education	N/A	52.4459445	-1.5552508
24517	op-snap---monthly-publication-september-2025.pdf	736	2025-09	Car	Skoda	Fabia	Blue	Driving without Due Care and Attention	None	Dickens Heath Road	Dickens Heath Road	Solihull	Solihull	Education	N/A	52.3875525	-1.8339426
24518	op-snap---monthly-publication-september-2025.pdf	737	2025-09	Car	Hyundai	I30	Black	Driving without Due Care and Attention	None	Dickens Heath Road	Dickens Heath Road	Solihull	Solihull	Education	N/A	52.3875525	-1.8339426
24528	op-snap---monthly-publication-september-2025.pdf	747	2025-09	Car	Suzuki	IGNIS	White	Driving without Due Care and Attention	None	A45 Roundabout, junction with Park Hill Drive	Roundabout, junction with Park Hill Drive	Coventry	Coventry	Education	N/A	52.4486967	-1.4991069
24531	op-snap---monthly-publication-september-2025.pdf	750	2025-09	Pedal Bike	Volkswagen		Black	Driving without Due Care and Attention	None	Warstock Lane	Warstock Lane	Birmingham	Birmingham	Education	N/A	52.4175988	-1.8774655
24534	op-snap---monthly-publication-september-2025.pdf	753	2025-09	Car	Mercedes-Benz	GLC	white	Driving without Due Care and Attention	None	High Street, Wall Heath, Dudley	High Street, Wall Heath, Dudley	Dudley	Dudley	Education	N/A	52.5046529	-2.1784687
24548	op-snap---monthly-publication-september-2025.pdf	767	2025-09	Car	Mercedes-Benz		White	Driving without Due Care and Attention	None	M6 Motorway	M6 Motorway	Birmingham	Birmingham	Education	N/A	52.5327447	-1.899844
24550	op-snap---monthly-publication-september-2025.pdf	769	2025-09	Car	Seat	Leon	Grey	Driving without Due Care and Attention	None	Moor Street	Moor Street	Dudley	Dudley	Education	N/A	52.4816337	-2.1283208
24580	op-snap---monthly-publication-september-2025.pdf	799	2025-09	Car	Volkswagen	Transporter	Blue	Driving without Due Care and Attention	None	Allard Way	Allard Way	Birmingham	Birmingham	Education	N/A
24582	op-snap---monthly-publication-september-2025.pdf	801	2025-09	Car	Skoda	Fabia	Red	Driving without Due Care and Attention	None	Brandwood Road	Brandwood Road	Birmingham	Birmingham	Education	N/A	52.4139427	-1.9037653
24596	op-snap---monthly-publication-september-2025.pdf	815	2025-09	Pedal Bike	BMW	3 Series	White	Driving without Due Care and Attention	None	Chester Road North	Chester Road North	Walsall	Walsall	Education	N/A	52.654063	-1.9460461
24606	op-snap---monthly-publication-september-2025.pdf	825	2025-09	Car	Toyota	Yaris	Silver	Driving without Due Care and Attention	None	Tyburn House Island	Tyburn House Island	Birmingham	Birmingham	Education	N/A	52.5194011	-1.8008643
24607	op-snap---monthly-publication-september-2025.pdf	826	2025-09	Car	Volkswagen	Tiguan	Black	Driving without Due Care and Attention	None	High Street, Stourbridge	High Street, Stourbridge	Dudley	Dudley	Education	N/A	52.4570763	-2.1136199
24608	op-snap---monthly-publication-september-2025.pdf	827	2025-09	Pedal Bike	Audi	A5	Red	Driving without Due Care and Attention	None	Newton Road	Newton Road	Sandwell	Sandwell	Education	N/A	52.5428224	-1.9569444
24609	op-snap---monthly-publication-september-2025.pdf	828	2025-09	Pedal Bike	Peugeot	Boxer van	White	Driving without Due Care and Attention	None	Newton Road	Newton Road	Sandwell	Sandwell	Education	N/A	52.5428224	-1.9569444
24610	op-snap---monthly-publication-september-2025.pdf	829	2025-09	Pedal Bike	Daf	lorry	White	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	Education	N/A	52.5919543	-1.8517118
24614	op-snap---monthly-publication-september-2025.pdf	833	2025-09	Pedal Bike	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Bristol Road South	Bristol Road South	Birmingham	Birmingham	Education	N/A	52.4119174	-1.9735247
24615	op-snap---monthly-publication-september-2025.pdf	834	2025-09	Car	Volvo	S40	Grey	Driving without Due Care and Attention	None	A38 M	A38 M	Birmingham	Birmingham	Education	N/A	52.5092312	-1.8706799
24619	op-snap---monthly-publication-september-2025.pdf	838	2025-09	Pedal Bike	Hyundai	IX20	Blue	Driving without Due Care and Attention	None	Wood Green Road, Wednesbury	Wood Green Road, Wednesbury	Walsall	Walsall	Education	N/A
24628	op-snap---monthly-publication-september-2025.pdf	847	2025-09	Lorry	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	M6 Jn10 exit	M6 Jn10 exit	Walsall	Walsall	Education	N/A
24632	op-snap---monthly-publication-september-2025.pdf	851	2025-09	Other	Volkswagen	Polo	Silver	Driving without Due Care and Attention	None	Star City, Nechells	Star City, Nechells	Birmingham	Birmingham	Education	N/A	52.5054363	-1.8556273
24643	op-snap---monthly-publication-september-2025.pdf	862	2025-09	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Monyhull Hall Road	Monyhull Hall Road	Birmingham	Birmingham	Education	N/A	52.4126079	-1.905127
24646	op-snap---monthly-publication-september-2025.pdf	865	2025-09	Pedal Bike	Mg	ZS	Black	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Sandwell	Sandwell	Education	N/A	52.5439824	-1.9306805

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