opsnap: reports: 121 rows where month = "2025-07", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" 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'}

121 rows where month = "2025-07", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" 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
11982	op-snap---monthly-publication-july-2025.pdf	34	2025-07	Pedal Bike		Scania	White	Driving without Due Care and Attention	None	Cornets End Lane	Cornets End Lane	Coventry	Coventry	Education	N/A
11983	op-snap---monthly-publication-july-2025.pdf	35	2025-07	Pedal Bike	Peugeot	208	Black	Driving without Due Care and Attention	None	Broad Lane	Broad Lane	Coventry	Coventry	Education	N/A	52.4074716	-1.5620671
11991	op-snap---monthly-publication-july-2025.pdf	43	2025-07	Pedal Bike	Audi	A3	Silver	Driving without Due Care and Attention	None	Wolverhampton Road	Wolverhampton Road	Wolverhampton	Wolverhampton	Education	N/A	52.5968709	-2.0954054
11992	op-snap---monthly-publication-july-2025.pdf	44	2025-07	Pedal Bike	Kia	Rio	Silver	Driving without Due Care and Attention	None	A38 Tyburn Road	Tyburn Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5113867	-1.8337258
12010	op-snap---monthly-publication-july-2025.pdf	62	2025-07	Pedal Bike	Volvo	V40	Blue	Driving without Due Care and Attention	None	Meer End Road	Meer End Road	Solihull	Solihull	Education	N/A	52.373396	-1.6335409
12038	op-snap---monthly-publication-july-2025.pdf	90	2025-07	Pedal Bike	Ford	Transit	White	Driving without Due Care and Attention	None	Olton Road	Olton Road	Solihull	Solihull	NFA	Outside of 14 Days NIP	52.4193964	-1.8252207
12040	op-snap---monthly-publication-july-2025.pdf	92	2025-07	Pedal Bike	BMW	520..	Black	Driving without Due Care and Attention	None	St Bernards Road	Street Bernards Road	Solihull	Solihull	NFA	Outside of 14 Days NIP
12049	op-snap---monthly-publication-july-2025.pdf	101	2025-07	Pedal Bike	BMW	320d	Black	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Court	N/A	52.5292752	-1.7618805
12067	op-snap---monthly-publication-july-2025.pdf	119	2025-07	Pedal Bike	Toyota	Aygo	Silver	Driving without Due Care and Attention	None	Bickenhill Road	Bickenhill Road	Solihull	Solihull	Court	N/A	52.4640893	-1.7362681
12073	op-snap---monthly-publication-july-2025.pdf	125	2025-07	Pedal Bike	Vauxhall	astra	Red	Driving without Due Care and Attention	None	Forest Road	Forest Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4467275	-1.8804014
12087	op-snap---monthly-publication-july-2025.pdf	139	2025-07	Pedal Bike	BMW	116..	White	Driving without Due Care and Attention	None	Bearwood Road	Bearwood Road	Sandwell	Sandwell	Education	N/A	52.4725977	-1.9684448
12121	op-snap---monthly-publication-july-2025.pdf	173	2025-07	Pedal Bike	Honda	Jazz	Blue	Driving without Due Care and Attention	None	Dorchester Road	Dorchester Road	Solihull	Solihull	Court	N/A	52.4157911	-1.7926505
12125	op-snap---monthly-publication-july-2025.pdf	177	2025-07	Pedal Bike	Audi	Q5	Blue	Driving without Due Care and Attention	None	Bookvale Road	Bookvale Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
12126	op-snap---monthly-publication-july-2025.pdf	178	2025-07	Pedal Bike	Citroen	C3	Blue	Driving without Due Care and Attention	None	City Road	City Road	Birmingham	Birmingham	NFA	No Offence	52.4763176	-1.9584897
12130	op-snap---monthly-publication-july-2025.pdf	182	2025-07	Pedal Bike	Skoda		Black	Driving without Due Care and Attention	None	Witton Road, Witton Lane	Witton Road, Witton Lane	Birmingham	Birmingham	NFA	No VRM
12132	op-snap---monthly-publication-july-2025.pdf	184	2025-07	Pedal Bike	Daf		White	Driving without Due Care and Attention	None	Gooch st at Bissell St	Gooch st at Bissell Street	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4696234	-1.8952392
12133	op-snap---monthly-publication-july-2025.pdf	185	2025-07	Pedal Bike	Volvo	Bus	Red	Driving without Due Care and Attention	None	Moorend Avenue	Moorend Avenue	Birmingham	Birmingham	NFA	No Offence
12174	op-snap---monthly-publication-july-2025.pdf	226	2025-07	Pedal Bike	Ford	B-Max	Blue	Driving without Due Care and Attention	None	Streetsbrook Road	Streetsbrook Road	Solihull	Solihull	Education	N/A	52.4223176	-1.8253145
12179	op-snap---monthly-publication-july-2025.pdf	231	2025-07	Pedal Bike	Honda	Jazz	Blue	Driving without Due Care and Attention	None	Ampton Road	Ampton Road	Birmingham	Birmingham	Education	N/A	52.4632489	-1.917458
12195	op-snap---monthly-publication-july-2025.pdf	247	2025-07	Pedal Bike	Mini	cooper	Blue	Driving without Due Care and Attention	None	Bewdley	Bewdley	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4330724	-1.9181313
12218	op-snap---monthly-publication-july-2025.pdf	270	2025-07	Pedal Bike	Jaguar	XE	Black	Driving without Due Care and Attention	None	Lichfield Road	Lichfield Road	Sutton Coldfield	Sutton Coldfield	Education	N/A	52.5872149	-1.8300386
12224	op-snap---monthly-publication-july-2025.pdf	276	2025-07	Pedal Bike	Seat	Ibiza	Black	Driving without Due Care and Attention	None	Dads Lane	Dads Lane	Birmingham	Birmingham	Education	N/A	52.4375913	-1.9068522
12227	op-snap---monthly-publication-july-2025.pdf	279	2025-07	Pedal Bike	Chevrolet	Chrysler	Black	Driving without Due Care and Attention	None	Danford Lane	Danford Lane	Solihull	Solihull	Education	N/A	52.4092804	-1.8056214
12241	op-snap---monthly-publication-july-2025.pdf	293	2025-07	Pedal Bike	Vauxhall	Meriva	White	Driving without Due Care and Attention	None	Linden Road	Linden Road	Solihull	Solihull	NFA	Outside of 14 Days NIP
12242	op-snap---monthly-publication-july-2025.pdf	294	2025-07	Pedal Bike	Vauxhall	Corsa	Grey	Driving without Due Care and Attention	None	Gibbins Road	Gibbins Road	Birmingham	Birmingham	NFA	Outside of 14 DAYS Late Submission	52.4390303	-1.9512931
12244	op-snap---monthly-publication-july-2025.pdf	296	2025-07	Pedal Bike	Hyundai	I10	Red	Driving without Due Care and Attention	None	Shenley Hill	Shenley Hill	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4267534	-1.9790765
12245	op-snap---monthly-publication-july-2025.pdf	297	2025-07	Pedal Bike	Volkswagen	Passat	Blue	Driving without Due Care and Attention	None	Alwold Road	Alwold Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4436471	-1.9604594
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
12273	op-snap---monthly-publication-july-2025.pdf	325	2025-07	Pedal Bike	Ford	Transit	White	Driving without Due Care and Attention	None	Haxelhurst Road	Haxelhurst Road	Birmingham	Birmingham	NFA	No Offence
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
12327	op-snap---monthly-publication-july-2025.pdf	379	2025-07	Pedal Bike	Ford	Fiesta	Blue	Driving without Due Care and Attention	None	Hazelhurts Road	Hazelhurts Road	Birmingham	Birmingham	NFA	Not in Public Interest
12353	op-snap---monthly-publication-july-2025.pdf	405	2025-07	Pedal Bike	Audi	A6...	Black	Driving without Due Care and Attention	None	Butts Road	Butts Road	Walsall	Walsall	NFA	Not in Public Interest	52.592263	-1.9743536
12380	op-snap---monthly-publication-july-2025.pdf	432	2025-07	Pedal Bike	Audi	A3	Black	Driving without Due Care and Attention	None	Moor Green Lane	Moor Green Lane	Birmingham	Birmingham	Education	N/A	52.4374665	-1.9119895
12391	op-snap---monthly-publication-july-2025.pdf	443	2025-07	Pedal Bike	Peugeot	2008	Grey	Driving without Due Care and Attention	None	Coventry Road	Coventry Road	Coventry	Coventry	Education	N/A	52.4111289	-1.5094345
12400	op-snap---monthly-publication-july-2025.pdf	452	2025-07	Pedal Bike	Toyota	Auris	Black	Driving without Due Care and Attention	None	May Lane	May Lane	Birmingham	Birmingham	Education	N/A	52.4197342	-1.8839613
12417	op-snap---monthly-publication-july-2025.pdf	469	2025-07	Pedal Bike	Renault	Captur	Silver	Driving without Due Care and Attention	None	Upper Hill Street	Upper Hill Street	Coventry	Coventry	NFA	No Offence	52.4106808	-1.5185684
12420	op-snap---monthly-publication-july-2025.pdf	472	2025-07	Pedal Bike	Land Rover	Discovery	Silver	Driving without Due Care and Attention	None	Bridgenorth Road	Bridgenorth Road	Out of Force Area	Out of Force Area	NFA	Out of Force
12422	op-snap---monthly-publication-july-2025.pdf	474	2025-07	Pedal Bike	Mazda	6...	Red	Driving without Due Care and Attention	None	Melrose Avenue	Melrose Avenue	Sutton Coldfield	Sutton Coldfield	NFA	No Offence	52.5511462	-1.8479052
12457	op-snap---monthly-publication-july-2025.pdf	509	2025-07	Pedal Bike	BMW	M135i	Grey	Driving without Due Care and Attention	None	Shilton Lane	Shilton Lane	Coventry	Coventry	NFA	Outside of 14 Days NIP	52.4425711	-1.4532921
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
12462	op-snap---monthly-publication-july-2025.pdf	514	2025-07	Pedal Bike	Audi	Q3	White	Driving without Due Care and Attention	None	Kenilworth Road Knowle	Kenilworth Road Knowle	Solihull	Solihull	Education	N/A	52.3877147	-1.732243
12485	op-snap---monthly-publication-july-2025.pdf	537	2025-07	Pedal Bike	Vauxhall	Zafira	Silver	Driving without Due Care and Attention	None	Thruxton, Herefordshire	Thruxton, Herefordshire	Out of Force Area	Out of Force Area	NFA	Out of Force
12504	op-snap---monthly-publication-july-2025.pdf	556	2025-07	Pedal Bike	Nissan	Micra	Black	Driving without Due Care and Attention	None	Talbot Street, Hockley	Talbot Street, Hockley	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.4956227	-1.9324692
12513	op-snap---monthly-publication-july-2025.pdf	565	2025-07	Pedal Bike	BMW	X3	Blue	Driving without Due Care and Attention	None	Norton Rd Stourbridge	Norton Road Stourbridge	Metropolitan Borough of Dudley	Metropolitan Borough Of Dudley	NFA	No Offence	52.4388442	-2.1645703
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
12525	op-snap---monthly-publication-july-2025.pdf	577	2025-07	Pedal Bike	Mg	3	Silver	Driving without Due Care and Attention	None	Hagley Road West	Hagley Road West	Sandwell	Sandwell	Education	N/A	52.4634145	-1.9969046
12542	op-snap---monthly-publication-july-2025.pdf	594	2025-07	Pedal Bike	Vauxhall	Insignia	Grey	Driving without Due Care and Attention	None	Enville Road, Kingswinford	Enville Road, Kingswinford	Sandwell	Sandwell	Education	N/A
12562	op-snap---monthly-publication-july-2025.pdf	614	2025-07	Pedal Bike	Nissan	Note	Grey	Driving without Due Care and Attention	None	Oakfield Road	Oakfield Road	Birmingham	Birmingham	Education	N/A	52.4464556	-1.9200958
12610	op-snap---monthly-publication-july-2025.pdf	662	2025-07	Pedal Bike	Land Rover	Freelander	Black	Driving without Due Care and Attention	None	Robin Hood Island	Robin Hood Island	Birmingham	Birmingham	NFA	No Offence	52.4220705	-1.8372335
12620	op-snap---monthly-publication-july-2025.pdf	672	2025-07	Pedal Bike	Land Rover	Range Rover	White	Driving without Due Care and Attention	None	Redhill Road	Redhill Road	Birmingham	Birmingham	Education	N/A	52.4618364	-1.8328803
12624	op-snap---monthly-publication-july-2025.pdf	676	2025-07	Pedal Bike	Skoda	Fabia	Grey	Driving without Due Care and Attention	None	Merritts Hill	Merritts Hill	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.424853	-1.9814275
12639	op-snap---monthly-publication-july-2025.pdf	691	2025-07	Pedal Bike	Mercedes-Benz	E class	Blue	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
12641	op-snap---monthly-publication-july-2025.pdf	693	2025-07	Pedal Bike	Volkswagen	Polo	Blue	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
12646	op-snap---monthly-publication-july-2025.pdf	698	2025-07	Pedal Bike	Vauxhall	Astra	Silver	Driving without Due Care and Attention	None	Norman Place Road	Norman Place Road	Coventry	Coventry	NFA	No Offence	52.4285935	-1.5370895
12663	op-snap---monthly-publication-july-2025.pdf	715	2025-07	Pedal Bike	Mini	cooper	Blue	Driving without Due Care and Attention	No Insurance	William Street	William Street	Birmingham	Birmingham	Court	N/A	52.4737583	-1.9124023
12697	op-snap---monthly-publication-july-2025.pdf	749	2025-07	Pedal Bike	Ford	Focus	Silver	Driving without Due Care and Attention	None	Valley Road, Earlswood	Valley Road, Earlswood	Out of Force Area	Out of Force Area	NFA	Out of Force
12703	op-snap---monthly-publication-july-2025.pdf	755	2025-07	Pedal Bike	Fiat	500	Blue	Driving without Due Care and Attention	None	Olton Road	Olton Road	Solihull	Solihull	Education	N/A	52.4193964	-1.8252207
12705	op-snap---monthly-publication-july-2025.pdf	757	2025-07	Pedal Bike	Seat	Leon	Black	Driving without Due Care and Attention	None	Queensbridge Road	Queensbridge Road	Birmingham	Birmingham	Education	N/A	52.4415108	-1.8971434
12710	op-snap---monthly-publication-july-2025.pdf	762	2025-07	Pedal Bike	Ford	Transit	Blue	Driving without Due Care and Attention	No Insurance	Grange Road	Grange Road	Birmingham	Birmingham	Court	N/A	52.5065077	-1.892207
12712	op-snap---monthly-publication-july-2025.pdf	764	2025-07	Pedal Bike	Honda	Jazz	Blue	Driving without Due Care and Attention	None	West Heath Road	West Heath Road	Birmingham	Birmingham	Education	N/A	52.402785	-1.9620058
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
12719	op-snap---monthly-publication-july-2025.pdf	771	2025-07	Pedal Bike	BMW		Black	Driving without Due Care and Attention	None	Packwood Road	Packwood Road	Solihull	Solihull	NFA	No Offence	52.3617789	-1.7409895
12724	op-snap---monthly-publication-july-2025.pdf	776	2025-07	Pedal Bike	Audi	A4..	White	Driving without Due Care and Attention	None	Hagley Road (5 ways underpass)	Hagley Road (5 ways underpass)	Birmingham	Birmingham	Education	N/A
12730	op-snap---monthly-publication-july-2025.pdf	782	2025-07	Pedal Bike	Ford	Focus	Grey	Driving without Due Care and Attention	None	Close Pass	Close Pass	Dudley	Dudley	NFA	Outside of 14 Days NIP
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
12760	op-snap---monthly-publication-july-2025.pdf	812	2025-07	Pedal Bike	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
12761	op-snap---monthly-publication-july-2025.pdf	813	2025-07	Pedal Bike	Toyota	Prius	Silver	Driving without Due Care and Attention	None	Northfiled Road	Northfiled Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
12762	op-snap---monthly-publication-july-2025.pdf	814	2025-07	Pedal Bike	Volkswagen	Passatt	Blue	Driving without Due Care and Attention	None	Lordswood Road	Lordswood Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4591339	-1.9601054
12763	op-snap---monthly-publication-july-2025.pdf	815	2025-07	Pedal Bike	Vauxhall	Corsa	Red	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
12764	op-snap---monthly-publication-july-2025.pdf	816	2025-07	Pedal Bike	Iveco	Daily	White	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
12765	op-snap---monthly-publication-july-2025.pdf	817	2025-07	Pedal Bike	Mercedes-Benz	GLC 220	Black	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
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
12767	op-snap---monthly-publication-july-2025.pdf	819	2025-07	Pedal Bike	Mg	zs	Yellow	Driving without Due Care and Attention	None	Lordswood roundabout	Lordswood roundabout	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
12768	op-snap---monthly-publication-july-2025.pdf	820	2025-07	Pedal Bike		Perodua	Black	Driving without Due Care and Attention	None	The Barley lea	The Barley lea	Coventry	Coventry	NFA	Outside of 14 Days NIP	52.3952661	-1.4705187
12775	op-snap---monthly-publication-july-2025.pdf	827	2025-07	Pedal Bike	Renault		Blue	Driving without Due Care and Attention	None	Gravelly Lane	Gravelly Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.534608	-1.8379769
12912	op-snap---monthly-publication-july-2025.pdf	964	2025-07	Pedal Bike	BMW	116	Silver	Driving without Due Care and Attention	None	Highfield Road	Highfield Road	Wolverhampton	Wolverhampton	NFA	No Offence	52.5570756	-2.073188
12914	op-snap---monthly-publication-july-2025.pdf	966	2025-07	Pedal Bike	Ford	Transit	Silver	Driving without Due Care and Attention	None	Willenhall Road	Willenhall Road	Wolverhampton	Wolverhampton	NFA	Outside of 14 Days NIP	52.5836778	-2.0894997
12929	op-snap---monthly-publication-july-2025.pdf	981	2025-07	Pedal Bike	Volkswagen	golf	Black	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Education	N/A	52.5292752	-1.7618805
12931	op-snap---monthly-publication-july-2025.pdf	983	2025-07	Pedal Bike	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Education	N/A	52.5292752	-1.7618805
12949	op-snap---monthly-publication-july-2025.pdf	1001	2025-07	Pedal Bike	BMW	335..	Blue	Driving without Due Care and Attention	None	Gibbins Road	Gibbins Road	Birmingham	Birmingham	NFA	No Offence	52.4390303	-1.9512931
12951	op-snap---monthly-publication-july-2025.pdf	1003	2025-07	Pedal Bike	Mercedes-Benz	E220	Grey	Driving without Due Care and Attention	None	Chester Road, Streetly	Chester Road, Streetly	Sutton Coldfield	Sutton Coldfield	NFA	Outside of 14 Days NIP
12983	op-snap---monthly-publication-july-2025.pdf	1035	2025-07	Pedal Bike	Toyota	Aygo	Red	Driving without Due Care and Attention	None	Chester Road	Chester Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5359496	-1.8324115
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
13047	op-snap---monthly-publication-july-2025.pdf	1099	2025-07	Pedal Bike	Land Rover	Range Rover	Grey	Driving without Due Care and Attention	None	Queensbridge Road	Queensbridge Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4415108	-1.8971434
13066	op-snap---monthly-publication-july-2025.pdf	1118	2025-07	Pedal Bike	Toyota	Prius	Silver	Driving without Due Care and Attention	None	War Lane, harborne	War Lane, harborne	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4569552	-1.9616483
13067	op-snap---monthly-publication-july-2025.pdf	1119	2025-07	Pedal Bike	Ford	Fiesta	White	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
13069	op-snap---monthly-publication-july-2025.pdf	1121	2025-07	Pedal Bike	Audi	Q6	Black	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
13070	op-snap---monthly-publication-july-2025.pdf	1122	2025-07	Pedal Bike	Volkswagen	Polo	White	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
13071	op-snap---monthly-publication-july-2025.pdf	1123	2025-07	Pedal Bike	Mini	Cooper	Green	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
13072	op-snap---monthly-publication-july-2025.pdf	1124	2025-07	Pedal Bike	Toyota	Corolla	Black	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4167654	-1.9411244
13074	op-snap---monthly-publication-july-2025.pdf	1126	2025-07	Pedal Bike	Ford	Fusion	Black	Driving without Due Care and Attention	None	Stonehouse Hill	Stonehouse Hill	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4448348	-1.9713792
13075	op-snap---monthly-publication-july-2025.pdf	1127	2025-07	Pedal Bike			Blue	Driving without Due Care and Attention	None	War Lane Harbourne	War Lane Harbourne	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
13076	op-snap---monthly-publication-july-2025.pdf	1128	2025-07	Pedal Bike	Volkswagen	Tiguan	Blue	Driving without Due Care and Attention	None	Alwood Road	Alwood Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
13077	op-snap---monthly-publication-july-2025.pdf	1129	2025-07	Pedal Bike	Seat	Ibiza	White	Driving without Due Care and Attention	None	Alwood Road	Alwood Road	Birmingham	Birmingham	NFA	No Offence
13078	op-snap---monthly-publication-july-2025.pdf	1130	2025-07	Pedal Bike	Ford	Transit	Grey	Driving without Due Care and Attention	None	Aston Webb Boulevard	Aston Webb Boulevard	Birmingham	Birmingham	NFA	No Offence	52.4468506	-1.9395619
13079	op-snap---monthly-publication-july-2025.pdf	1131	2025-07	Pedal Bike	Peugeot	Expert	White	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	NFA	No Offence	52.4167654	-1.9411244
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
13082	op-snap---monthly-publication-july-2025.pdf	1134	2025-07	Pedal Bike	Nissan	Qashqai	Grey	Driving without Due Care and Attention	None	War lane	War lane	Birmingham	Birmingham	Education	N/A	52.4569552	-1.9616483

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