opsnap: reports: 127 rows where disposal = "Warning Letter", 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'}

127 rows where disposal = "Warning Letter", 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
24032	op-snap---monthly-publication-september-2025.pdf	251	2025-09	Other	Nissan	Qashqai	Black	Driving without Due Care and Attention	None	Dean Road	Dean Road	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5932146	-2.102601
24035	op-snap---monthly-publication-september-2025.pdf	254	2025-09	Car	Audi	A3	Black	Driving without Due Care and Attention	None	Boldmere Road	Boldmere Road	Birmingham	Birmingham	Warning Letter	N/A	52.548309	-1.8411769
24057	op-snap---monthly-publication-september-2025.pdf	276	2025-09	Car	Seat	Leon	Black	Driving without Due Care and Attention	None	Nursery Road	Nursery Road	Birmingham	Birmingham	Warning Letter	N/A	52.4979836	-1.9118163
24060	op-snap---monthly-publication-september-2025.pdf	279	2025-09	Car	Mercedes-Benz	c300	Grey	Driving without Due Care and Attention	None	High Street, Newtown	High Street, Newtown	Birmingham	Birmingham	Warning Letter	N/A	52.5000098	-1.8959802
24086	op-snap---monthly-publication-september-2025.pdf	305	2025-09	Car	BMW	116	Silver	Driving without Due Care and Attention	None	Wolverhampton Road	Wolverhampton Road	Sandwell	Sandwell	Warning Letter	N/A	52.4702299	-1.9948976
24102	op-snap---monthly-publication-september-2025.pdf	321	2025-09	Car	Mg	HS	Red	Driving without Due Care and Attention	None	M6 SB J4a - 4	M6 Southbound J4a - 4	Coventry	Coventry	Warning Letter	N/A	52.6912652	-2.1043715
24108	op-snap---monthly-publication-september-2025.pdf	327	2025-09	Pedal Bike	Land Rover	Range Rover	White	Driving without Due Care and Attention	None	Devon Road	Devon Road	Sandwell	Sandwell	Warning Letter	N/A	52.4674008	-1.9805667
24118	op-snap---monthly-publication-september-2025.pdf	337	2025-09	Car	Vauxhall	Astra	White	Driving without Due Care and Attention	None	M6 Coventry	M6 Coventry	Coventry	Coventry	Warning Letter	N/A	52.4457805	-1.454783
24141	op-snap---monthly-publication-september-2025.pdf	360	2025-09	Car	Volkswagen	Polo	Red	Driving without Due Care and Attention	None	Norman Road	Norman Road	Birmingham	Birmingham	Warning Letter	N/A	52.411848	-1.9590923
24153	op-snap---monthly-publication-september-2025.pdf	372	2025-09	Car	Toyota	Corolla	Grey	Driving without Due Care and Attention	None	Central Six retail park	Central Six retail park	Coventry	Coventry	Warning Letter	N/A	52.4022899	-1.5191819
24157	op-snap---monthly-publication-september-2025.pdf	376	2025-09	Car	Peugeot	Expert	White	Driving without Due Care and Attention	None	Suffolk Street Queensway	Suffolk Street Queensway	Birmingham	Birmingham	Warning Letter	N/A	52.4760986	-1.9018641
24164	op-snap---monthly-publication-september-2025.pdf	383	2025-09	Car	Audi	Q6	Grey	Driving without Due Care and Attention	None	Ulverley Green Lane	Ulverley Green Lane	Solihull	Solihull	Warning Letter	N/A
24171	op-snap---monthly-publication-september-2025.pdf	390	2025-09	Car	Ford	Kuga	Grey	Driving without Due Care and Attention	None	Fox Hollies Road	Fox Hollies Road	Birmingham	Birmingham	Warning Letter	N/A	52.5517052	-1.7825505
24176	op-snap---monthly-publication-september-2025.pdf	395	2025-09	Pedal Bike	Volkswagen	Tiguan	Grey	Driving without Due Care and Attention	None	Stonnal Road Aldridge	Stonnal Road Aldridge	Walsall	Walsall	Warning Letter	N/A
24181	op-snap---monthly-publication-september-2025.pdf	400	2025-09	Pedestrian	Volvo	V50	Blue	Driving without Due Care and Attention	None	Farrington Road	Farrington Road	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5550312	-2.1191799
24184	op-snap---monthly-publication-september-2025.pdf	403	2025-09	Car	Vauxhall	mokka	Blue	Driving without Due Care and Attention	None	The Crescent	The Crescent	Birmingham	Birmingham	Warning Letter	N/A	52.4568799	-1.8734416
24187	op-snap---monthly-publication-september-2025.pdf	406	2025-09	Car	Suzuki	vitara	Grey	Driving without Due Care and Attention	None	Smallheath Highway	Smallheath Highway	Birmingham	Birmingham	Warning Letter	N/A
24193	op-snap---monthly-publication-september-2025.pdf	412	2025-09	Pedal Bike	Mg	4..	Grey	Driving without Due Care and Attention	None	Beake Avenue	Beake Avenue	Coventry	Coventry	Warning Letter	N/A	52.4388246	-1.5229308
24202	op-snap---monthly-publication-september-2025.pdf	421	2025-09	Car	Ford	Transit	Silver	Driving without Due Care and Attention	None	Coventry Highway	Coventry Highway	Coventry	Coventry	Warning Letter	N/A	52.4034983	-1.5600081
24218	op-snap---monthly-publication-september-2025.pdf	437	2025-09	Pedal Bike	Peugeot	208	Black	Driving without Due Care and Attention	None	Inchlaggon Road	Inchlaggon Road	Wolverhampton	Wolverhampton	Warning Letter	N/A
24223	op-snap---monthly-publication-september-2025.pdf	442	2025-09	Car	Mitsubishi	Shogun	Silver	Driving without Due Care and Attention	None	Billingsley Road	Billingsley Road	Birmingham	Birmingham	Warning Letter	N/A	52.4696617	-1.7890822
24230	op-snap---monthly-publication-september-2025.pdf	449	2025-09	Car	Land Rover	Evoque	White	Driving without Due Care and Attention	None	High Street / A491, Audnam, Stourbridge	High Street / A491, Audnam, Stourbridge	Dudley	Dudley	Warning Letter	N/A	52.4722518	-2.1552954
24239	op-snap---monthly-publication-september-2025.pdf	458	2025-09	Car	Peugeot	Boxer	White	Driving without Due Care and Attention	None	Billesley Lane	Billesley Lane	Birmingham	Birmingham	Warning Letter	N/A	52.4344402	-1.8845368
24240	op-snap---monthly-publication-september-2025.pdf	459	2025-09	Pedal Bike	Toyota	Landcruiser	Silver	Driving without Due Care and Attention	None	Lordswood Road	Lordswood Road	Birmingham	Birmingham	Warning Letter	N/A	52.4591339	-1.9601054
24244	op-snap---monthly-publication-september-2025.pdf	463	2025-09	Car	Mg	ZS	Grey	Driving without Due Care and Attention	None	A45 Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032
24262	op-snap---monthly-publication-september-2025.pdf	481	2025-09	Car	Ford	Galaxy	Black	Driving without Due Care and Attention	None	Grove Street	Grove Street	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.5930351	-2.1050815
24265	op-snap---monthly-publication-september-2025.pdf	484	2025-09	Car	Nissan	Qashqai	Orange	Driving without Due Care and Attention	None	Butts Road	Butts Road	Coventry	Coventry	Warning Letter	N/A	52.4073149	-1.5250454
24272	op-snap---monthly-publication-september-2025.pdf	491	2025-09	Car	Vauxhall	Corsa	Red	Driving without Due Care and Attention	None	Reservoir Place	Reservoir Place	Walsall	Walsall	Warning Letter	N/A	52.5770818	-2.0074916
24281	op-snap---monthly-publication-september-2025.pdf	500	2025-09	Car	Mercedes-Benz	Sprinter	Yellow	Driving without Due Care and Attention	Use vehicle on a road without valid test certificate	Ringway, Swanswell	Ringway, Swanswell	Coventry	Coventry	Warning Letter	N/A
24297	op-snap---monthly-publication-september-2025.pdf	516	2025-09	Car	Audi	A3..	Grey	Driving without Due Care and Attention	None	Tyburn Road	Tyburn Road	Birmingham	Birmingham	Warning Letter	N/A	52.5113867	-1.8337258
24319	op-snap---monthly-publication-september-2025.pdf	538	2025-09	Car	Skoda	Octavia	White	Driving without Due Care and Attention	None	Tyburn House Island	Tyburn House Island	Birmingham	Birmingham	Warning Letter	N/A	52.5194011	-1.8008643
24331	op-snap---monthly-publication-september-2025.pdf	550	2025-09	Car	Volkswagen	Polo	Black	Driving without Due Care and Attention	None	Bowstone Road	Bowstone Road	Birmingham	Birmingham	Warning Letter	N/A
24362	op-snap---monthly-publication-september-2025.pdf	581	2025-09	Car	Mercedes-Benz	C220	Black	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
24367	op-snap---monthly-publication-september-2025.pdf	586	2025-09	Car	Skoda	Octavia	Silver	Driving without Due Care and Attention	None	A45 Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032
24370	op-snap---monthly-publication-september-2025.pdf	589	2025-09	Car	Toyota	Estima	Red	Driving without Due Care and Attention	None	A45 Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032
24371	op-snap---monthly-publication-september-2025.pdf	590	2025-09	Car	Volkswagen	Polo	White	Driving without Due Care and Attention	None	A45 Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032
24389	op-snap---monthly-publication-september-2025.pdf	608	2025-09	Car	Volkswagen	Golf GTI	Black	Driving without Due Care and Attention	None	Camp Hill	Camp Hill	Birmingham	Birmingham	Warning Letter	N/A	52.4702894	-1.8786299
24392	op-snap---monthly-publication-september-2025.pdf	611	2025-09	Pedal Bike	Vauxhall	Vivaro	Black	Driving without Due Care and Attention	None	Lichfield Road towards Dartmouth Circus	Lichfield Road towards Dartmouth Circus	Birmingham	Birmingham	Warning Letter	N/A
24396	op-snap---monthly-publication-september-2025.pdf	615	2025-09	Car	BMW	5 series	Grey	Driving without Due Care and Attention	None	M6 Northbound, nr Jn4	M6 Northbound, nr Jn4	Birmingham	Birmingham	Warning Letter	N/A
24399	op-snap---monthly-publication-september-2025.pdf	618	2025-09	Car	Dacia	Duster	Grey	Driving without Due Care and Attention	None	Richard St	Richard Street	Wolverhampton	Wolverhampton	Warning Letter	N/A
24406	op-snap---monthly-publication-september-2025.pdf	625	2025-09	Car	Vauxhall	Zafira	Brown	Driving without Due Care and Attention	None	Bickenhill Lane	Bickenhill Lane	Solihull	Solihull	Warning Letter	N/A	52.4490463	-1.7296897
24420	op-snap---monthly-publication-september-2025.pdf	639	2025-09	Car	Seat	Leon	White	Driving without Due Care and Attention	None	Grove Road	Grove Road	Birmingham	Birmingham	Warning Letter	N/A	52.4453942	-1.8644982
24427	op-snap---monthly-publication-september-2025.pdf	646	2025-09	Car	Nissan	Qasqai	Grey	Driving without Due Care and Attention	None	Queslett Road	Queslett Road	Birmingham	Birmingham	Warning Letter	N/A	52.5458699	-1.9304484
24436	op-snap---monthly-publication-september-2025.pdf	655	2025-09	Car	Hyundai	I30	Silver	Driving without Due Care and Attention	None	Manor Park	Manor Park	Dudley	Dudley	Warning Letter	N/A	52.4961407	-2.1668754
24450	op-snap---monthly-publication-september-2025.pdf	669	2025-09	Car	Porsche	Macan	Grey	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
24462	op-snap---monthly-publication-september-2025.pdf	681	2025-09	Car	Volkswagen	Tiguan	Silver	Driving without Due Care and Attention	None	Sewall Highway	Sewall Highway	Coventry	Coventry	Warning Letter	N/A	52.4318623	-1.4804069
24474	op-snap---monthly-publication-september-2025.pdf	693	2025-09	Motorbike	BMW	X3	Black	Driving without Due Care and Attention	None	Sharespeare Drive	Sharespeare Drive	Solihull	Solihull	Warning Letter	N/A
24479	op-snap---monthly-publication-september-2025.pdf	698	2025-09	Car	Volkswagen	Polo	Black	Driving without Due Care and Attention	None	Quinton Expressway	Quinton Expressway	Birmingham	Birmingham	Warning Letter	N/A	52.4491086	-2.0131915
24486	op-snap---monthly-publication-september-2025.pdf	705	2025-09	Car	Kia	Optima	White	Driving without Due Care and Attention	No vehicle excise licence	A38(M) inbound to Birmingham	A38(M) inbound to Birmingham	Birmingham	Birmingham	Warning Letter	N/A
24494	op-snap---monthly-publication-september-2025.pdf	713	2025-09	Pedal Bike	Citroen	C4 Picasso	Red	Driving without Due Care and Attention	None	Potters Lane, Wednesbury	Potters Lane, Wednesbury	Wolverhampton	Wolverhampton	Warning Letter	N/A
24498	op-snap---monthly-publication-september-2025.pdf	717	2025-09	Pedal Bike	Ford	Mondeo	Silver	Driving without Due Care and Attention	None	Umberslade Road, Stirchley	Umberslade Road, Stirchley	Birmingham	Birmingham	Warning Letter	N/A	52.4304526	-1.9216716
24512	op-snap---monthly-publication-september-2025.pdf	731	2025-09	Pedal Bike	Scania	Coach	Green	Driving without Due Care and Attention	None	Balsall Street East, Balsall Common	Balsall Street East, Balsall Common	Coventry	Coventry	Warning Letter	N/A
24514	op-snap---monthly-publication-september-2025.pdf	733	2025-09	Car	BMW	M3	Blue	Driving without Due Care and Attention	None	Pleck Road	Pleck Road	Walsall	Walsall	Warning Letter	N/A	52.5827033	-1.9960274
24520	op-snap---monthly-publication-september-2025.pdf	739	2025-09	Pedal Bike	Renault	Zoe	Blue	Driving without Due Care and Attention	None	Queen Victoria Road	Queen Victoria Road	Coventry	Coventry	Warning Letter	N/A	52.4063195	-1.5157306
24584	op-snap---monthly-publication-september-2025.pdf	803	2025-09	Other	Audi	A1	Black	Driving without Due Care and Attention	None	Waterfront car park 7	Waterfront car park 7	Dudley	Dudley	Warning Letter	N/A
24586	op-snap---monthly-publication-september-2025.pdf	805	2025-09	Other	Audi	A4	Grey	Driving without Due Care and Attention	None	Waterfron car park 7	Waterfron car park 7	Dudley	Dudley	Warning Letter	N/A
24593	op-snap---monthly-publication-september-2025.pdf	812	2025-09	Car	Land Rover	Discovery	Black	Driving without Due Care and Attention	None	Hagley Road	Hagley Road	Birmingham	Birmingham	Warning Letter	N/A	52.471632	-1.9456776
24622	op-snap---monthly-publication-september-2025.pdf	841	2025-09	Lorry	Peugeot	2008..	Black	Driving without Due Care and Attention	None	Willenhall Road - Neachalls Lane	Willenhall Road - Neachalls Lane	Wolverhampton	Wolverhampton	Warning Letter	N/A
24624	op-snap---monthly-publication-september-2025.pdf	843	2025-09	Pedal Bike	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Slade Road	Slade Road	Birmingham	Birmingham	Warning Letter	N/A	52.5894461	-1.8082962
24660	op-snap---monthly-publication-september-2025.pdf	879	2025-09	Pedestrian	Mercedes-Benz	A-class	Silver	Driving without Due Care and Attention	None	Regent Place	Regent Place	Birmingham	Birmingham	Warning Letter	N/A	52.4860376	-1.9095854
24662	op-snap---monthly-publication-september-2025.pdf	881	2025-09	Pedal Bike	Volkswagen	Golf	Grey	Driving without Due Care and Attention	None	Formans Road	Formans Road	Birmingham	Birmingham	Warning Letter	N/A	52.4482024	-1.8507493
24686	op-snap---monthly-publication-september-2025.pdf	905	2025-09	Pedal Bike	Audi	A1	Green	Driving without Due Care and Attention	None	Marshall Lake Road	Marshall Lake Road	Solihull	Solihull	Warning Letter	N/A	52.3975426	-1.818252
24731	op-snap---monthly-publication-september-2025.pdf	950	2025-09	Car	Mercedes-Benz	S class	Silver	Driving without Due Care and Attention	None	Tyburn House Island	Tyburn House Island	Birmingham	Birmingham	Warning Letter	N/A	52.5194011	-1.8008643
24770	op-snap---monthly-publication-september-2025.pdf	989	2025-09	Car	BMW	3 series	Black	Driving without Due Care and Attention	None	B4121	B4121	Birmingham	Birmingham	Warning Letter	N/A	52.4448693	-1.9772096
24771	op-snap---monthly-publication-september-2025.pdf	990	2025-09	Other	Volkswagen	EOS	Black	Driving without Due Care and Attention	None	Merry Hill Main Car Park	Merry Hill Main Car Park	Dudley	Dudley	Warning Letter	N/A
24773	op-snap---monthly-publication-september-2025.pdf	992	2025-09	Car	Volkswagen	Polo	Blue	Driving without Due Care and Attention	None	A34	A34	Birmingham	Birmingham	Warning Letter	N/A
24775	op-snap---monthly-publication-september-2025.pdf	994	2025-09	Pedal Bike	BMW	IX3	Black	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Warning Letter	N/A	52.5292752	-1.7618805
24789	op-snap---monthly-publication-september-2025.pdf	1008	2025-09	Other	Seat	MII	Red	Driving without Due Care and Attention	None	St Margarets Avenue	Street Margarets Avenue	Birmingham	Birmingham	Warning Letter	N/A
24795	op-snap---monthly-publication-september-2025.pdf	1014	2025-09	Car	Kia	Venga	Silver	Driving without Due Care and Attention	None	Bowers Lane	Bowers Lane	Dudley	Dudley	Warning Letter	N/A
24809	op-snap---monthly-publication-september-2025.pdf	1028	2025-09	Pedal Bike	Vauxhall	Corsa	Silver	Driving without Due Care and Attention	None	Alwold Road	Alwold Road	Birmingham	Birmingham	Warning Letter	N/A	52.4436471	-1.9604594
24827	op-snap---monthly-publication-september-2025.pdf	1046	2025-09	Car		Dennis Bus		Driving without Due Care and Attention	None	Adams Hill Road	Adams Hill Road	Birmingham	Birmingham	Warning Letter	N/A	52.4355492	-2.0043534
24834	op-snap---monthly-publication-september-2025.pdf	1053	2025-09	Car	BMW	325D	Black	Driving without Due Care and Attention	None	Fordbrook Lane	Fordbrook Lane	Birmingham	Birmingham	Warning Letter	N/A
24838	op-snap---monthly-publication-september-2025.pdf	1057	2025-09	Other	Seat	Leon	White	Driving without Due Care and Attention	None	Waterfront Main Car Park	Waterfront Main Car Park	Dudley	Dudley	Warning Letter	N/A
24839	op-snap---monthly-publication-september-2025.pdf	1058	2025-09	Other	Yamaha	Aprilia 125	Black	Driving without Due Care and Attention	None	Waterfront Main Car Park	Waterfront Main Car Park	Dudley	Dudley	Warning Letter	N/A
24864	op-snap---monthly-publication-september-2025.pdf	1083	2025-09	Car		Bentley	Green	Driving without Due Care and Attention	None	A45	A45	Coventry	Coventry	Warning Letter	N/A
24870	op-snap---monthly-publication-september-2025.pdf	1089	2025-09	Car	BMW	320..	White	Driving without Due Care and Attention	None	Mucklow Hill	Mucklow Hill	Dudley	Dudley	Warning Letter	N/A	52.461008	-2.0345574
24875	op-snap---monthly-publication-september-2025.pdf	1094	2025-09	Other	Ford	Fiesta	Red	Driving without Due Care and Attention	None	Waterfront Way	Waterfront Way	Dudley	Dudley	Warning Letter	N/A	52.4879006	-2.1188734
24876	op-snap---monthly-publication-september-2025.pdf	1095	2025-09	Other	Ford	Fiesta	Black	Driving without Due Care and Attention	None	Waterfront Way	Waterfront Way	Dudley	Dudley	Warning Letter	N/A	52.4879006	-2.1188734
24883	op-snap---monthly-publication-september-2025.pdf	1102	2025-09	Other	Seat	Leon	Red	Driving without Due Care and Attention	None	Star City	Star City	Birmingham	Birmingham	Warning Letter	N/A	52.5054363	-1.8556273
24892	op-snap---monthly-publication-september-2025.pdf	1111	2025-09	Car	Mercedes-Benz	C350	Blue	Driving without Due Care and Attention	None	M6 / M5 Junction	M6 / M5 Junction	Birmingham	Birmingham	Warning Letter	N/A
24900	op-snap---monthly-publication-september-2025.pdf	1119	2025-09	Car	Renault	Trafic	Black	Driving without Due Care and Attention	None	Duncan Edwards Way	Duncan Edwards Way	Dudley	Dudley	Warning Letter	N/A	52.5047428	-2.0823754
24910	op-snap---monthly-publication-september-2025.pdf	1129	2025-09	Car	Mercedes-Benz	A200	Grey	Driving without Due Care and Attention	None	a4150	A4150	Wolverhampton	Wolverhampton	Warning Letter	N/A
24916	op-snap---monthly-publication-september-2025.pdf	1135	2025-09	Car	Vauxhall	Corsa	Grey	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
24925	op-snap---monthly-publication-september-2025.pdf	1144	2025-09	Car	Mini	Cooper	Red	Driving without Due Care and Attention	None	Four Pound Avenue	Four Pound Avenue	Coventry	Coventry	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);