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

150 rows where disposal = "Warning Letter", month = "2025-07" 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
11960	op-snap---monthly-publication-july-2025.pdf	12	2025-07	Pedal Bike	Vauxhall	Zafira	Black	Driving without Due Care and Attention	None	Bearwood Road	Bearwood Road	Birmingham	Birmingham	Warning Letter	N/A	52.4762784	-1.9678366
11980	op-snap---monthly-publication-july-2025.pdf	32	2025-07	Car	Mercedes-Benz	A Class	Black	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	Warning Letter	N/A	52.5359496	-1.8324115
12003	op-snap---monthly-publication-july-2025.pdf	55	2025-07	Car	Audi	A6	Black	Driving without Due Care and Attention	None	Coventry Road	Coventry Road	Birmingham	Birmingham	Warning Letter	N/A	52.4726661	-1.8769032
12070	op-snap---monthly-publication-july-2025.pdf	122	2025-07	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	Warning Letter	N/A	52.5919543	-1.8517118
12088	op-snap---monthly-publication-july-2025.pdf	140	2025-07	Car	Nissan	Qashqai	Grey	Driving without Due Care and Attention	None	Montague Street	Montague Street	Birmingham	Birmingham	Warning Letter	N/A	52.4816806	-1.8788939
12111	op-snap---monthly-publication-july-2025.pdf	163	2025-07	Car	BMW	3 SERIES	Grey	Driving without Due Care and Attention	None	Fox Hollies Road	Fox Hollies Road	Birmingham	Birmingham	Warning Letter	N/A	52.5517052	-1.7825505
12164	op-snap---monthly-publication-july-2025.pdf	216	2025-07	Car	Audi	A4...	Black	Driving without Due Care and Attention	None	A452 Pype Hayes	Pype Hayes	Birmingham	Birmingham	Warning Letter	N/A	52.5275673	-1.8101068
12178	op-snap---monthly-publication-july-2025.pdf	230	2025-07	Pedestrian	Vauxhall	Zafira	Beige	Driving without Due Care and Attention	None	Outside Coventry Market	Outside Coventry Market	Coventry	Coventry	Warning Letter	N/A
12198	op-snap---monthly-publication-july-2025.pdf	250	2025-07	Car	BMW		Grey	Driving without Due Care and Attention	None	Vicarage Road	Vicarage Road	Birmingham	Birmingham	Warning Letter	N/A	52.470423	-1.9304786
12213	op-snap---monthly-publication-july-2025.pdf	265	2025-07	Car	BMW	318..	White	Driving without Due Care and Attention	None	Bath Row	Bath Row	Birmingham	Birmingham	Warning Letter	N/A	52.472238	-1.9127983
12219	op-snap---monthly-publication-july-2025.pdf	271	2025-07	Other	BMW	330..	White	Driving without Due Care and Attention	None	Waterfrnt Car Park	Waterfrnt Car Park	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A
12221	op-snap---monthly-publication-july-2025.pdf	273	2025-07	Car	Nissan	GT-R	Blue	Driving without Due Care and Attention	None	Rumbush Lane	Rumbush Lane	Birmingham	Birmingham	Warning Letter	N/A
12222	op-snap---monthly-publication-july-2025.pdf	274	2025-07	Car	Mitsubishi	Mirage	White	Driving without Due Care and Attention	None	St Mary's Row	Street Mary's Row	Birmingham	Birmingham	Warning Letter	N/A
12239	op-snap---monthly-publication-july-2025.pdf	291	2025-07	Car	Toyota	Prius	Silver	Driving without Due Care and Attention	None	Stafford Road	Stafford Road	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.6291998	-2.126312
12256	op-snap---monthly-publication-july-2025.pdf	308	2025-07	Motorbike	Vauxhall	Corsa	Silver	Driving without Due Care and Attention	None	New Cross Hospital	New Cross Hospital	Wolverhampton	Wolverhampton	Warning Letter	N/A	52.6000052	-2.0954966
12270	op-snap---monthly-publication-july-2025.pdf	322	2025-07	Pedal Bike	BMW	220i	White	Driving without Due Care and Attention	None	Woodbourne Road	Woodbourne Road	Birmingham	Birmingham	Warning Letter	N/A	52.4702361	-1.951945
12277	op-snap---monthly-publication-july-2025.pdf	329	2025-07	Pedal Bike	Audi	RSQ8	Grey	Driving without Due Care and Attention	None	Cornwall Street	Cornwall Street	Birmingham	Birmingham	Warning Letter	N/A	52.4815054	-1.9032499
12302	op-snap---monthly-publication-july-2025.pdf	354	2025-07	Car	Mercedes-Benz	GLA	Red	Driving without Due Care and Attention	None	Stockfield Road	Stockfield Road	Birmingham	Birmingham	Warning Letter	N/A	52.4519414	-1.831688
12303	op-snap---monthly-publication-july-2025.pdf	355	2025-07	Car	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Warwick Road	Warwick Road	Birmingham	Birmingham	Warning Letter	N/A	52.4555288	-1.8613929
12310	op-snap---monthly-publication-july-2025.pdf	362	2025-07	Car	Toyota	Corolla	Blue	Driving without Due Care and Attention	None	M5 Junction 1 Island	M5 Junction 1 Island	Sandwell	Sandwell	Warning Letter	N/A
12342	op-snap---monthly-publication-july-2025.pdf	394	2025-07	Car	Chevrolet	L200	Black	Driving without Due Care and Attention	None	Alcester Road South	Alcester Road South	Birmingham	Birmingham	Warning Letter	N/A	52.4170522	-1.8906187
12351	op-snap---monthly-publication-july-2025.pdf	403	2025-07	Car	Volkswagen	Polo	Black	Driving without Due Care and Attention	None	Hagley Road West	Hagley Road West	Birmingham	Birmingham	Warning Letter	N/A	52.4656414	-1.9852276
12359	op-snap---monthly-publication-july-2025.pdf	411	2025-07	Car	Kia	Proceed	Blue	Driving without Due Care and Attention	None	A435 (towards Brackenbury Road)	A435 (towards Brackenbury Road)	Sutton Coldfield	Sutton Coldfield	Warning Letter	N/A
12388	op-snap---monthly-publication-july-2025.pdf	440	2025-07	Car	Volkswagen	Amarok	Blue	Driving without Due Care and Attention	None	Alcester Road	Alcester Road	Birmingham	Birmingham	Warning Letter	N/A	52.4470686	-1.8880749
12390	op-snap---monthly-publication-july-2025.pdf	442	2025-07	Car	Suzuki	Swift	Orange	Driving without Due Care and Attention	None	York Road	York Road	Birmingham	Birmingham	Warning Letter	N/A	52.5231321	-1.8415573
12392	op-snap---monthly-publication-july-2025.pdf	444	2025-07	Other	Volkswagen	Polo	Blue	Driving without Due Care and Attention	None	Arden Road	Arden Road	Birmingham	Birmingham	Warning Letter	N/A	52.4515759	-1.8296192
12396	op-snap---monthly-publication-july-2025.pdf	448	2025-07	Other	Seat	Leon	Black	Driving without Due Care and Attention	None	Waterfront carpark 7	Waterfront carpark 7	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A
12397	op-snap---monthly-publication-july-2025.pdf	449	2025-07	Car	Toyota	CHR	Silver	Driving without Due Care and Attention	None	Brackenbury Road	Brackenbury Road	Birmingham	Birmingham	Warning Letter	N/A	52.5407924	-1.8709807
12432	op-snap---monthly-publication-july-2025.pdf	484	2025-07	Car	Mercedes-Benz	A180	Grey	Driving without Due Care and Attention	None	A458 Stourbridge Ring Road	Stourbridge Ring Road	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A	52.4590366	-2.1465735
12459	op-snap---monthly-publication-july-2025.pdf	511	2025-07	Pedal Bike	Vauxhall	Insignia	White	Driving without Due Care and Attention	None	Stoney Stanton Road	Stoney Stanton Road	Coventry	Coventry	Warning Letter	N/A	52.4221152	-1.4959475
12477	op-snap---monthly-publication-july-2025.pdf	529	2025-07	Car	Ford	Kuga	Silver	Driving without Due Care and Attention	None	Oakenshaw Road	Oakenshaw Road	Solihull	Solihull	Warning Letter	N/A	52.4017754	-1.8151522
12478	op-snap---monthly-publication-july-2025.pdf	530	2025-07	Car	Mercedes-Benz	A	Green	Driving without Due Care and Attention	None	Chester Road	Chester Road	Sutton Coldfield	Sutton Coldfield	Warning Letter	N/A	52.5359496	-1.8324115
12480	op-snap---monthly-publication-july-2025.pdf	532	2025-07	Car	Ford	Kuga	White	Driving without Due Care and Attention	None	Monument Road	Monument Road	Birmingham	Birmingham	Warning Letter	N/A	52.4731312	-1.930947
12487	op-snap---monthly-publication-july-2025.pdf	539	2025-07	Other	Honda	C90MG	Red	Driving without Due Care and Attention	None	Bullring Sedgley	Bullring Sedgley	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A	52.5411442	-2.1221913
12505	op-snap---monthly-publication-july-2025.pdf	557	2025-07	Car	Skoda	Citigo	Red	Driving without Due Care and Attention	None	Stivichall Roundabout	Stivichall Roundabout	Coventry	Coventry	Warning Letter	N/A	52.3776818	-1.4982138
12517	op-snap---monthly-publication-july-2025.pdf	569	2025-07	Pedal Bike	Kia	Sportage	Silver	Driving without Due Care and Attention	None	Talbot Street	Talbot Street	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A	52.4956227	-1.9324692
12522	op-snap---monthly-publication-july-2025.pdf	574	2025-07	Car	Land Rover	Vogue	Black	Driving without Due Care and Attention	None	Leighswood Road	Leighswood Road	Walsall	Walsall	Warning Letter	N/A	52.6071662	-1.9231466
12533	op-snap---monthly-publication-july-2025.pdf	585	2025-07	Car	Skoda	Superb	Silver	Driving without Due Care and Attention	None	Bromford lane	Bromford lane	Birmingham	Birmingham	Warning Letter	N/A	52.5083238	-1.8332287
12537	op-snap---monthly-publication-july-2025.pdf	589	2025-07	Car	Ford	Transit	Grey	Driving without Due Care and Attention	None	Wellington Road	Wellington Road	Walsall	Walsall	Warning Letter	N/A	52.5676426	-1.9505165
12544	op-snap---monthly-publication-july-2025.pdf	596	2025-07	Car	Audi	A1	Beige	Driving without Due Care and Attention	None	New John Street	New John Street	Birmingham	Birmingham	Warning Letter	N/A	52.4920451	-1.8920402
12616	op-snap---monthly-publication-july-2025.pdf	668	2025-07	Car	Mazda	2..	Grey	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	Warning Letter	N/A	52.4203897	-1.8338574
12655	op-snap---monthly-publication-july-2025.pdf	707	2025-07	Car	Audi	A3	White	Driving without Due Care and Attention	None	Moorend Avenue	Moorend Avenue	Birmingham	Birmingham	Warning Letter	N/A
12671	op-snap---monthly-publication-july-2025.pdf	723	2025-07	Car	Vauxhall	Corsa	Silver	Driving without Due Care and Attention	None	Holbrook Lane	Holbrook Lane	Coventry	Coventry	Warning Letter	N/A	52.436155	-1.5064002
12714	op-snap---monthly-publication-july-2025.pdf	766	2025-07	Pedal Bike	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Wuchall Road Northfield	Wuchall Road Northfield	Birmingham	Birmingham	Warning Letter	N/A
12745	op-snap---monthly-publication-july-2025.pdf	797	2025-07	Car	Volkswagen	Golf GTI	Blue	Driving without Due Care and Attention	None	Kenrick Way	Kenrick Way	Sandwell	Sandwell	Warning Letter	N/A	52.5079468	-1.9755194
12747	op-snap---monthly-publication-july-2025.pdf	799	2025-07	Pedal Bike	Nissan	Note	Grey	Driving without Due Care and Attention	None	Brierley Hill Road	Brierley Hill Road	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A	52.4811151	-2.1456435
12749	op-snap---monthly-publication-july-2025.pdf	801	2025-07	Car	Mercedes-Benz	Splinter	Red	Driving without Due Care and Attention	None	Water Orton Road	Water Orton Road	Birmingham	Birmingham	Warning Letter	N/A	52.5153394	-1.7573409
12766	op-snap---monthly-publication-july-2025.pdf	818	2025-07	Pedal Bike	Mercedes-Benz	CLA	Grey	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Solihull	Solihull	Warning Letter	N/A	52.4191184	-1.8326637
12789	op-snap---monthly-publication-july-2025.pdf	841	2025-07	Car	BMW	X4..	Grey	Driving without Due Care and Attention	None	M6 Jct 10	M6 Junction 10	Walsall	Walsall	Warning Letter	N/A	52.676119	-2.0858425
12791	op-snap---monthly-publication-july-2025.pdf	843	2025-07	Other	BMW	135..	Blue	Driving without Due Care and Attention	None	Beacon Park Farm	Beacon Park Farm	Walsall	Walsall	Warning Letter	N/A
12806	op-snap---monthly-publication-july-2025.pdf	858	2025-07	Other	BMW	116..	Black	Driving without Due Care and Attention	None	Waterfront Way	Waterfront Way	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A	52.5846796	-1.9935385
12852	op-snap---monthly-publication-july-2025.pdf	904	2025-07	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Tysley Hill Rd	Tysley Hill Road	Birmingham	Birmingham	Warning Letter	N/A
12880	op-snap---monthly-publication-july-2025.pdf	932	2025-07	Car	Volvo	Bus	Red	Driving without Due Care and Attention	None	Dudley Road, Tipton	Dudley Road, Tipton	Sandwell	Sandwell	Warning Letter	N/A	52.5238596	-2.0740455
12881	op-snap---monthly-publication-july-2025.pdf	933	2025-07	Car	Toyota	Yaris	Red	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	Warning Letter	N/A	52.5919543	-1.8517118
12913	op-snap---monthly-publication-july-2025.pdf	965	2025-07	Car	BMW	X2	Black	Driving without Due Care and Attention	None	Valbourne Road	Valbourne Road	Birmingham	Birmingham	Warning Letter	N/A	52.4165707	-1.9062691
12939	op-snap---monthly-publication-july-2025.pdf	991	2025-07	Car	Audi	A3	Black	Driving without Due Care and Attention	None	Kelsley Lane	Kelsley Lane	Solihull	Solihull	Warning Letter	N/A
13024	op-snap---monthly-publication-july-2025.pdf	1076	2025-07	Pedal Bike	Toyota	Auris	Silver	Driving without Due Care and Attention	None	Darlsaton Road (Wednesbury)	Darlsaton Road (Wednesbury)	Sandwell	Sandwell	Warning Letter	N/A
13042	op-snap---monthly-publication-july-2025.pdf	1094	2025-07	Car	Mercedes-Benz	C 220	Black	Driving without Due Care and Attention	None	M6 North	M6 North	Birmingham	Birmingham	Warning Letter	N/A	52.5143137	-1.7683873
13053	op-snap---monthly-publication-july-2025.pdf	1105	2025-07	Other	Ford	Focus	Blue	Driving without Due Care and Attention	None	Waterfront Way Car park 7	Waterfront Way Car park 7	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	Warning Letter	N/A
13080	op-snap---monthly-publication-july-2025.pdf	1132	2025-07	Pedal Bike	Fiat	Spider	Blue	Driving without Due Care and Attention	None	War lane	War lane	Birmingham	Birmingham	Warning Letter	N/A	52.4569552	-1.9616483
13081	op-snap---monthly-publication-july-2025.pdf	1133	2025-07	Pedal Bike	Peugeot	van	White	Driving without Due Care and Attention	None	War lane	War lane	Birmingham	Birmingham	Warning Letter	N/A	52.4569552	-1.9616483
13085	op-snap---monthly-publication-july-2025.pdf	1137	2025-07	Car	Mercedes-Benz		Silver	Driving without Due Care and Attention	None	Radford Road	Radford Road	Coventry	Coventry	Warning Letter	N/A	52.4235908	-1.5226276
13159	op-snap---monthly-publication-july-2025.pdf	1211	2025-07	Car	BMW		Grey	Driving without Due Care and Attention	None	Dartmouth Circus	Dartmouth Circus	Birmingham	Birmingham	Warning Letter	N/A	52.4926487	-1.8879638
13167	op-snap---monthly-publication-july-2025.pdf	1219	2025-07	Pedal Bike	Land Rover	Defender	Green	Driving without Due Care and Attention	None	Lavender Hall Lane	Lavender Hall Lane	Coventry	Coventry	Warning Letter	N/A
13168	op-snap---monthly-publication-july-2025.pdf	1220	2025-07	Pedal Bike	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Lavender Hall Lane	Lavender Hall Lane	Coventry	Coventry	Warning Letter	N/A
13198	op-snap---monthly-publication-july-2025.pdf	1250	2025-07	Car	Scania	Tractor	White	Driving without Due Care and Attention	None	Toll Bar End	Toll Bar End	Coventry	Coventry	Warning Letter	N/A	52.377406	-1.4651313
13224	op-snap---monthly-publication-july-2025.pdf	1276	2025-07	Car	BMW	218i	White	Driving without Due Care and Attention	None	A45	A45	Coventry	Coventry	Warning Letter	N/A
13229	op-snap---monthly-publication-july-2025.pdf	1281	2025-07	Car	Audi	S4	Black	Driving without Due Care and Attention	None	Kingston Road	Kingston Road	Birmingham	Birmingham	Warning Letter	N/A	52.4747333	-1.8728345
13232	op-snap---monthly-publication-july-2025.pdf	1284	2025-07	Car	Mercedes-Benz	C220	Black	Driving without Due Care and Attention	None	A45 Smallheath Highway	Smallheath Highway	Birmingham	Birmingham	Warning Letter	N/A
13233	op-snap---monthly-publication-july-2025.pdf	1285	2025-07	Car	Renault	Megane	Silver	Driving without Due Care and Attention	None	A45 Smallheath Highway	Smallheath Highway	Birmingham	Birmingham	Warning Letter	N/A
13246	op-snap---monthly-publication-july-2025.pdf	1298	2025-07	Car	Cupra	Born ev	Grey	Driving without Due Care and Attention	None	Hamstead Road	Hamstead Road	Birmingham	Birmingham	Warning Letter	N/A	52.505832	-1.92002
13249	op-snap---monthly-publication-july-2025.pdf	1301	2025-07	Car	Dacia	Sandero	White	Driving without Due Care and Attention	None	A45 Sir Henry Parkes Road	Sir Henry Parkes Road	Coventry	Coventry	Warning Letter	N/A	52.3900568	-1.5550766
13253	op-snap---monthly-publication-july-2025.pdf	1305	2025-07	Car	Seat	Leon	Black	Driving without Due Care and Attention	None	Allman Road at Holly Lane	Allman Road at Holly Lane	Birmingham	Birmingham	Warning Letter	N/A	52.5227985	-1.8270199
13310	op-snap---monthly-publication-july-2025.pdf	1362	2025-07	Pedestrian	Ford	Focus	Silver	Driving without Due Care and Attention	None	Waterfront Way, Dudley	Waterfront Way, Dudley	Dudley	Dudley	Warning Letter	N/A	52.4880905	-2.1164794
13319	op-snap---monthly-publication-july-2025.pdf	1371	2025-07	Pedal Bike	Mercedes-Benz	GLE	Green	Driving without Due Care and Attention	None	Stoney Stanton Road	Stoney Stanton Road	Coventry	Coventry	Warning Letter	N/A	52.4221152	-1.4959475
13321	op-snap---monthly-publication-july-2025.pdf	1373	2025-07	Car	BMW	520D	Blue	Driving without Due Care and Attention	None	M42 Northbound	M42 Northbound	Birmingham	Birmingham	Warning Letter	N/A
13323	op-snap---monthly-publication-july-2025.pdf	1375	2025-07	Pedal Bike	Daf	Tipper	Blue	Driving without Due Care and Attention	None	Stoney Stanton Lane	Stoney Stanton Lane	Coventry	Coventry	Warning Letter	N/A	52.4211068	-1.4966527
13325	op-snap---monthly-publication-july-2025.pdf	1377	2025-07	Pedal Bike	Mercedes-Benz	Coach	White	Driving without Due Care and Attention	None	Stoney Stanton Lane	Stoney Stanton Lane	Coventry	Coventry	Warning Letter	N/A	52.4211068	-1.4966527
13330	op-snap---monthly-publication-july-2025.pdf	1382	2025-07	Car	Toyota	Proace	White	Driving without Due Care and Attention	None	M6 North	M6 North	Birmingham	Birmingham	Warning Letter	N/A	52.5143137	-1.7683873
13336	op-snap---monthly-publication-july-2025.pdf	1388	2025-07	Car	Byd	Seal	Grey	Driving without Due Care and Attention	None	Upper Holland Road	Upper Holland Road	Birmingham	Birmingham	Warning Letter	N/A	52.561	-1.8187105
13382	op-snap---monthly-publication-july-2025.pdf	1434	2025-07	Car	Volkswagen	caddy	White	Driving without Due Care and Attention	None	worcester road	Worcester Road	Out of Force Area	Out of Force Area	Warning Letter	N/A	52.5860898	-2.0339138
13401	op-snap---monthly-publication-july-2025.pdf	1453	2025-07	Car	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Cooks Lane	Cooks Lane	Birmingham	Birmingham	Warning Letter	N/A	52.482758	-1.7603097
13410	op-snap---monthly-publication-july-2025.pdf	1462	2025-07	Car	Citroen	C4	Blue	Driving without Due Care and Attention	None	Cheveral Avenue	Cheveral Avenue	Coventry	Coventry	Warning Letter	N/A	52.4257402	-1.5185037
13419	op-snap---monthly-publication-july-2025.pdf	1471	2025-07	Car	BMW	730	Beige	Driving without Due Care and Attention	None	Yardley Wood Road	Yardley Wood Road	Birmingham	Birmingham	Warning Letter	N/A	52.4103191	-1.8670224
13432	op-snap---monthly-publication-july-2025.pdf	1484	2025-07	Car	Volkswagen	Tiguan	Black	Driving without Due Care and Attention	None	Blackford Road	Blackford Road	Solihull	Solihull	Warning Letter	N/A	52.3971653	-1.8189489
13438	op-snap---monthly-publication-july-2025.pdf	1490	2025-07	Other	Honda	Civic	Black	Driving without Due Care and Attention	None	Lozells Street	Lozells Street	Birmingham	Birmingham	Warning Letter	N/A	52.5007454	-1.9067107
13470	op-snap---monthly-publication-july-2025.pdf	1522	2025-07	Pedestrian	Ford	Fiesta	Black	Driving without Due Care and Attention	None	Regent Place	Regent Place	Birmingham	Birmingham	Warning Letter	N/A	52.4860376	-1.9095854
13534	op-snap---monthly-publication-july-2025.pdf	1586	2025-07	Car	Nissan	note	silver	Driving without Due Care and Attention	None	Russel Road	Russel Road	Wolverhampton	Wolverhampton	Warning Letter	N/A
13536	op-snap---monthly-publication-july-2025.pdf	1588	2025-07	Pedestrian	Ford	focus	Silver	Driving without Due Care and Attention	None	Falstaff road	Falstaff road	Solihull	Solihull	Warning Letter	N/A	52.4042425	-1.8243195
13556	op-snap---monthly-publication-july-2025.pdf	1608	2025-07	Car	Kia	Sportage	Silver	Driving without Due Care and Attention	None	Lombard Street	Lombard Street	Birmingham	Birmingham	Warning Letter	N/A	52.4707728	-1.8872607
13569	op-snap---monthly-publication-july-2025.pdf	1621	2025-07	Car	Ford	Focus	Black	Driving without Due Care and Attention	None	Express Way, West Brom	Express Way, West Brom	Sandwell	Sandwell	Warning Letter	N/A
13572	op-snap---monthly-publication-july-2025.pdf	1624	2025-07	Car	Kia	Rio	White	Driving without Due Care and Attention	None	Stourbridge Ring Road	Stourbridge Ring Road	Dudley	Dudley	Warning Letter	N/A	52.4590366	-2.1465735
13574	op-snap---monthly-publication-july-2025.pdf	1626	2025-07	Car	BMW	320D	White	Driving without Due Care and Attention	None	Birmingham Road	Birmingham Road	Birmingham	Birmingham	Warning Letter	N/A	52.5505398	-1.8252993
13604	op-snap---monthly-publication-july-2025.pdf	1656	2025-07	Pedal Bike	Volkswagen	GOLF	Blue	Driving without Due Care and Attention	None	Station Road	Station Road	Birmingham	Birmingham	Warning Letter	N/A	52.5054559	-1.9506109
13610	op-snap---monthly-publication-july-2025.pdf	1662	2025-07	Car	Mercedes-Benz	A class	Silver	Driving without Due Care and Attention	None	M40	M40	Out of Force Area	Out of Force Area	Warning Letter	N/A
13651	op-snap---monthly-publication-july-2025.pdf	1703	2025-07	Car	Volkswagen	Fox	Black	Driving without Due Care and Attention	None	High Street, Dudley	High Street, Dudley	Dudley	Dudley	Warning Letter	N/A	52.4503499	-2.0504997
13662	op-snap---monthly-publication-july-2025.pdf	1714	2025-07	Pedestrian	Ford	Focus	Blue	Driving without Due Care and Attention	none	Tower Street	Tower Street	Dudley	Dudley	Warning Letter	N/A	52.5112053	-2.0833165
13663	op-snap---monthly-publication-july-2025.pdf	1715	2025-07	Pedestrian	Chysler	Grand yVoyager	Silver	Driving without Due Care and Attention	None	School Road	School Road	Birmingham	Birmingham	Warning Letter	N/A	52.4161736	-1.8619692
13681	op-snap---monthly-publication-july-2025.pdf	1733	2025-07	Pedestrian	Hyundai	Kona	Grey	Driving without Due Care and Attention	None	Norwood Road	Norwood Road	Dudley	Dudley	Warning Letter	N/A	52.4831397	-2.1309273
13685	op-snap---monthly-publication-july-2025.pdf	1737	2025-07	Car	Tesla	Model 3	Red	Driving without Due Care and Attention	None	Birmingham road	Birmingham road	Birmingham	Birmingham	Warning Letter	N/A	52.5505398	-1.8252993

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