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

349 rows where disposal = "NFA", 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
11948	op-snap---monthly-publication-july-2025.pdf	0	2025-07	Car	Ford	Focus	Silver	Driving without Due Care and Attention	None	Russell Road	Russell Road	Birmingham	Birmingham	NFA	No Offence	52.4398245	-1.8469786
11959	op-snap---monthly-publication-july-2025.pdf	11	2025-07	Car	Renault	Clio	Silver	Driving without Due Care and Attention	None	M54 - M6 Link	M54 - M6 Link	Wolverhampton	Wolverhampton	NFA	Outside of 14 Days NIP
11967	op-snap---monthly-publication-july-2025.pdf	19	2025-07	Pedestrian	Seat	Leon	Blue	Driving without Due Care and Attention	None	Heath Road South	Heath Road South	Birmingham	Birmingham	NFA	No VRM	52.415858	-1.9632649
11971	op-snap---monthly-publication-july-2025.pdf	23	2025-07	Car	Skoda	Enyaq	Blue	Driving without Due Care and Attention	None	A44 Worcester	Worcester	Out of Force Area	Out of Force Area	NFA	Out of Force	52.3101165	-2.0442678
11972	op-snap---monthly-publication-july-2025.pdf	24	2025-07	Car	Volkswagen		Grey	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.4203897	-1.8338574
11973	op-snap---monthly-publication-july-2025.pdf	25	2025-07	Car	Volvo	XC40	Black	Driving without Due Care and Attention	None	Birchley Island	Birchley Island	Sandwell	Sandwell	NFA	No Offence	52.4926604	-2.0216743
11974	op-snap---monthly-publication-july-2025.pdf	26	2025-07	Pedestrian	Kia	Sportage	White	Driving without Due Care and Attention	None	Heath Road	Heath Road	Wolverhampton	Wolverhampton	NFA	Outside of 14 DAYS Late Submission	52.5977729	-2.1078698
11976	op-snap---monthly-publication-july-2025.pdf	28	2025-07	Car	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Monmouth Road	Monmouth Road	Sutton Coldfield	Sutton Coldfield	NFA	Outside of 14 Days NIP	52.5569466	-1.8694159
11978	op-snap---monthly-publication-july-2025.pdf	30	2025-07	Car	Vauxhall	Corsa	Red	Driving without Due Care and Attention	None	Queensbury, Bradford	Queensbury, Bradford	Out of Force Area	Out of Force Area	NFA	Out of Force
11979	op-snap---monthly-publication-july-2025.pdf	31	2025-07	Car	Porsche	Cayman	Silver	Driving without Due Care and Attention	None	Stratford Road, Wellesbourne	Stratford Road, Wellesbourne	Out of Force Area	Out of Force Area	NFA	Out of Force
11984	op-snap---monthly-publication-july-2025.pdf	36	2025-07	Car	Mercedes-Benz	Sprinter	Blue	Driving without Due Care and Attention	None	Off force - west mercia	Off force - west mercia	Out of Force Area	Out of Force Area	NFA	Out of Force
11987	op-snap---monthly-publication-july-2025.pdf	39	2025-07	Car	Ford	Focus	Black	Driving without Due Care and Attention	None	Hagley Road	Hagley Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.471632	-1.9456776
11990	op-snap---monthly-publication-july-2025.pdf	42	2025-07	Car	Ford	Mondeo	Blue	Driving without Due Care and Attention	None	A5189 Burton upon Trent	Burton upon Trent	Out of Force Area	Out of Force Area	NFA	Out of Force
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
11995	op-snap---monthly-publication-july-2025.pdf	47	2025-07	Car	Mercedes-Benz		Grey	Driving without Due Care and Attention	None	Rocky Lane	Rocky Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5285859	-1.9100513
11996	op-snap---monthly-publication-july-2025.pdf	48	2025-07	Car	Seat		Red	Driving without Due Care and Attention	None	Rabone Lane	Rabone Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4998908	-1.952631
12000	op-snap---monthly-publication-july-2025.pdf	52	2025-07	Car	Audi	A6	Silver	Driving without Due Care and Attention	None	Bilford Road	Bilford Road	Out of Force Area	Out of Force Area	NFA	Out of Force
12019	op-snap---monthly-publication-july-2025.pdf	71	2025-07	Car	Mg	Trophy	Grey	Driving without Due Care and Attention	None	Kenilworth Road	Kenilworth Road	Coventry	Coventry	NFA	No Offence	52.3833298	-1.5379214
12022	op-snap---monthly-publication-july-2025.pdf	74	2025-07	Car	Mazda	3 series	White	Driving without Due Care and Attention	None	M5 motorway nr Jn1	M5 motorway nr Jn1	Sandwell	Sandwell	NFA	No Independent Evidence Available
12023	op-snap---monthly-publication-july-2025.pdf	75	2025-07	Car	Audi	Q3	Blue	Driving without Due Care and Attention	None	M43 WB J3	M43 Wb J3	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4846642	-1.9297585
12025	op-snap---monthly-publication-july-2025.pdf	77	2025-07	Car	Nissan	Qashqai	Black	Driving without Due Care and Attention	None	Beehive Hill	Beehive Hill	Out of Force Area	Out of Force Area	NFA	Out of Force	52.5518914	-2.0227634
12027	op-snap---monthly-publication-july-2025.pdf	79	2025-07	Car	Audi	A6	Black	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	NFA	Outside of 14 DAYS Late Submission	52.4203897	-1.8338574
12035	op-snap---monthly-publication-july-2025.pdf	87	2025-07	Car	BMW		Black	Driving without Due Care and Attention	None	Neachells Lane	Neachells Lane	Wolverhampton	Wolverhampton	NFA	Outside of 14 DAYS Late Submission	52.597459	-2.0791894
12036	op-snap---monthly-publication-july-2025.pdf	88	2025-07	Car	Suzuki	Swift	Blue	Driving without Due Care and Attention	None	Wednesfield Road	Wednesfield Road	Wolverhampton	Wolverhampton	NFA	Outside of 14 DAYS Late Submission	52.5885601	-2.122003
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
12039	op-snap---monthly-publication-july-2025.pdf	91	2025-07	Motorbike	Vauxhall	Corsa	Grey	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5919543	-1.8517118
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
12044	op-snap---monthly-publication-july-2025.pdf	96	2025-07	Car	Volkswagen	Caddy	White	Driving without Due Care and Attention	None	Thornhill Road,	Thornhill Road	Sutton Coldfield	Sutton Coldfield	NFA	Outside of 14 Days NIP	52.5690586	-1.8794686
12047	op-snap---monthly-publication-july-2025.pdf	99	2025-07	Car	Ford	Minibus	White	Driving without Due Care and Attention	None	Thornhill Road,	Thornhill Road	Sutton Coldfield	Sutton Coldfield	NFA	Outside of 14 Days NIP	52.5690586	-1.8794686
12052	op-snap---monthly-publication-july-2025.pdf	104	2025-07	Car	Volkswagen	Golf R	Black	Driving without Due Care and Attention	None	Genners Lane	Genners Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4282602	-1.9861769
12053	op-snap---monthly-publication-july-2025.pdf	105	2025-07	Car	Audi	RS3	Blue	Driving without Due Care and Attention	None	Genners Lane	Genners Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4282602	-1.9861769
12061	op-snap---monthly-publication-july-2025.pdf	113	2025-07	Car	Alfa Romeo	Polo	Black	Driving without Due Care and Attention	None	Montague Street	Montague Street	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4816806	-1.8788939
12064	op-snap---monthly-publication-july-2025.pdf	116	2025-07	Car	Citroen	Berlingo	White	Driving without Due Care and Attention	None	Daventry Road	Daventry Road	Coventry	Coventry	NFA	Outside of 14 Days NIP	52.3930931	-1.4976428
12072	op-snap---monthly-publication-july-2025.pdf	124	2025-07	Car	Volvo	V40..	Grey	Driving without Due Care and Attention	None	East Midway	East Midway	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
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
12074	op-snap---monthly-publication-july-2025.pdf	126	2025-07	Car	Volvo	XC90	Black	Driving without Due Care and Attention	None	M6 Warwickshire	M6 Warwickshire	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4572944	-1.4815973
12076	op-snap---monthly-publication-july-2025.pdf	128	2025-07	Other	Mercedes-Benz	C class	Blue	Driving without Due Care and Attention	None	Star City	Star City	Birmingham	Birmingham	NFA	Not in Public Interest	52.5054363	-1.8556273
12078	op-snap---monthly-publication-july-2025.pdf	130	2025-07	Motorbike	Nissan	Qashqai	Black	Driving without Due Care and Attention	None	Aldersley Road	Aldersley Road	Wolverhampton	Wolverhampton	NFA	Outside of 14 Days NIP	52.6058472	-2.1521123
12079	op-snap---monthly-publication-july-2025.pdf	131	2025-07	Car	BMW		Black	Driving without Due Care and Attention	None	Church Lane	Church Lane	Out of Force Area	Out of Force Area	NFA	Out of Force	52.5133161	-1.9278283
12091	op-snap---monthly-publication-july-2025.pdf	143	2025-07	Car	Mg	ZS	Black	Driving without Due Care and Attention	None	A4540 Bordesley Middleway	Bordesley Middleway	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4704236	-1.8769606
12092	op-snap---monthly-publication-july-2025.pdf	144	2025-07	Pedestrian			White	Driving without Due Care and Attention	None	Millennium Place	Millennium Place	Coventry	Coventry	NFA	No VRM	52.4105671	-1.5087697
12096	op-snap---monthly-publication-july-2025.pdf	148	2025-07	Car	Vauxhall	Insignia	Red	Driving without Due Care and Attention	None	M6 Motorway	M6 Motorway	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5327447	-1.899844
12099	op-snap---monthly-publication-july-2025.pdf	151	2025-07	Pedestrian	Nissan	Juke	Red	Driving without Due Care and Attention	None	Golden Hillock Road	Golden Hillock Road	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.4622646	-1.8599985
12107	op-snap---monthly-publication-july-2025.pdf	159	2025-07	Pedestrian	Mini	Mini	Blue	Driving without Due Care and Attention	None	Thorns Road	Thorns Road	Dudley	Dudley	NFA	Outside of 14 Days NIP	52.4628538	-2.1160108
12110	op-snap---monthly-publication-july-2025.pdf	162	2025-07	Car	Audi	Q7..	Grey	Driving without Due Care and Attention	None	Slip road London	Slip road London	Out of Force Area	Out of Force Area	NFA	Out of Force
12113	op-snap---monthly-publication-july-2025.pdf	165	2025-07	Car	Kia	GT..	Grey	Driving without Due Care and Attention	None	B4101 Coventry	Coventry	Coventry	Coventry	NFA	Outside of 14 Days NIP	52.400739	-1.5135474
12114	op-snap---monthly-publication-july-2025.pdf	166	2025-07	Other	Citroen	Berlingo	White	Driving without Due Care and Attention	None	Ward Street	Ward Street	Walsall	Walsall	NFA	Outside of 14 Days NIP	52.5918096	-2.0485738
12116	op-snap---monthly-publication-july-2025.pdf	168	2025-07	Car	Ford	Ranger	White	Driving without Due Care and Attention	None	Tile Hill Lane	Tile Hill Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
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
12127	op-snap---monthly-publication-july-2025.pdf	179	2025-07	Car	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Bitterscote Drive	Bitterscote Drive	Out of Force Area	Out of Force Area	NFA	Out of Force
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
12139	op-snap---monthly-publication-july-2025.pdf	191	2025-07	Car	Vauxhall	Movano	White	Driving without Due Care and Attention	None	B4115 near Rocky Lane	B4115 near Rocky Lane	Out of Force Area	Out of Force Area	NFA	Out of Force
12142	op-snap---monthly-publication-july-2025.pdf	194	2025-07	Car	Tesla	model 3	white	Driving without Due Care and Attention	None	A41, Newport, West Mercia	A41, Newport, West Mercia	Out of Force Area	Out of Force Area	NFA	Out of Force
12144	op-snap---monthly-publication-july-2025.pdf	196	2025-07	Car	BMW	M140i	White	Driving without Due Care and Attention	None	Langley Road	Langley Road	Sandwell	Sandwell	NFA	No Offence	52.488131	-2.0079901
12155	op-snap---monthly-publication-july-2025.pdf	207	2025-07	Car	Porsche		Black	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	NFA	No Offence	52.4203897	-1.8338574
12157	op-snap---monthly-publication-july-2025.pdf	209	2025-07	Car	Mercedes-Benz	E220	Black	Driving without Due Care and Attention	None	Ediburgh	Ediburgh	Out of Force Area	Out of Force Area	NFA	Out of Force
12161	op-snap---monthly-publication-july-2025.pdf	213	2025-07	Car	Volkswagen	Up	White	Driving without Due Care and Attention	None	Swan Lane	Swan Lane	Dudley	Dudley	NFA	No VRM	52.4790844	-2.1511181
12171	op-snap---monthly-publication-july-2025.pdf	223	2025-07	Car	Seat	Ibiza	Green	Driving without Due Care and Attention	None	Pershore Road	Pershore Road	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4653873	-1.8988344
12190	op-snap---monthly-publication-july-2025.pdf	242	2025-07	Other	BMW	116d	White	Driving without Due Care and Attention	None	Waterfront	Waterfront	Dudley	Dudley	NFA	No Offence	52.4874281	-2.1117204
12192	op-snap---monthly-publication-july-2025.pdf	244	2025-07	Car	Mercedes-Benz		Black	Driving without Due Care and Attention	None	Stream Road	Stream Road	Dudley	Dudley	NFA	Outside of 14 Days NIP	52.4871725	-2.1623764
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
12201	op-snap---monthly-publication-july-2025.pdf	253	2025-07	Car	Peugeot	206	Grey	Driving without Due Care and Attention	No Insurance	Barn Lane	Barn Lane	Birmingham	Birmingham	NFA	No Independent Evidence Available	52.4307492	-1.8828708
12214	op-snap---monthly-publication-july-2025.pdf	266	2025-07	Pedestrian	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Bernard Road	Bernard Road	Out of Force Area	Out of Force Area	NFA	No Independent Evidence Available	52.4777838	-1.9587163
12225	op-snap---monthly-publication-july-2025.pdf	277	2025-07	Car	Mg	Style	Grey	Driving without Due Care and Attention	None	Pedmore Road	Pedmore Road	Dudley	Dudley	NFA	No Independent Evidence Available	52.4897451	-2.1069141
12228	op-snap---monthly-publication-july-2025.pdf	280	2025-07	Car	Mercedes-Benz	C class	Blue	Driving without Due Care and Attention	None	Monkspath Hall Road East	Monkspath Hall Road East	Solihull	Solihull	NFA	Outside of 14 Days NIP
12229	op-snap---monthly-publication-july-2025.pdf	281	2025-07	Car		Kymco	Red	Driving without Due Care and Attention	None	Cheadle - Off force	Cheadle - Off force	Out of Force Area	Out of Force Area	NFA	Out of Force
12231	op-snap---monthly-publication-july-2025.pdf	283	2025-07	Car	Mercedes-Benz	A class	White	Driving without Due Care and Attention	None	Ledbury, West Mercia	Ledbury, West Mercia	Out of Force Area	Out of Force Area	NFA	Out of Force
12236	op-snap---monthly-publication-july-2025.pdf	288	2025-07	Car		Motorcycle	White	Driving without Due Care and Attention	None	Millenium Plaza	Millenium Plaza	Coventry	Coventry	NFA	No VRM
12238	op-snap---monthly-publication-july-2025.pdf	290	2025-07	Car	Mini	Cooper	Grey	Driving without Due Care and Attention	None	Walwyn Road	Walwyn Road	Out of Force Area	Out of Force Area	NFA	Out of Force
12240	op-snap---monthly-publication-july-2025.pdf	292	2025-07	Car	Renault	Clio	Grey	Driving without Due Care and Attention	None	Astwood Road	Astwood Road	Out of Force Area	Out of Force Area	NFA	Outside of 14 Days NIP
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
12246	op-snap---monthly-publication-july-2025.pdf	298	2025-07	Car	Mini	Mini	Yellow	Driving without Due Care and Attention	None	Coventry	Coventry	Coventry	Coventry	NFA	No Independent Evidence Available	52.400739	-1.5135474
12250	op-snap---monthly-publication-july-2025.pdf	302	2025-07	Car	Audi	A4	Grey	Driving without Due Care and Attention	None	Collector Road	Collector Road	Birmingham	Birmingham	NFA	No VRM	52.5139393	-1.7600186
12253	op-snap---monthly-publication-july-2025.pdf	305	2025-07	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Droitwich	Droitwich	Out of Force Area	Out of Force Area	NFA	Out of Force
12260	op-snap---monthly-publication-july-2025.pdf	312	2025-07	Car	Toyota	Estima	Black	Driving without Due Care and Attention	None	M6 Motorway	M6 Motorway	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5327447	-1.899844
12262	op-snap---monthly-publication-july-2025.pdf	314	2025-07	Car	Toyota	Corolla	Grey	Driving without Due Care and Attention	None	Bishopgate Street	Bishopgate Street	Birmingham	Birmingham	NFA	No Offence
12264	op-snap---monthly-publication-july-2025.pdf	316	2025-07	Car	Peugeot	308	Silver	Driving without Due Care and Attention	None	Five Ways Island	Five Ways Island	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
12265	op-snap---monthly-publication-july-2025.pdf	317	2025-07	Car	Volvo	XC60	Black	Driving without Due Care and Attention	None	Woodland Avenue	Woodland Avenue	Dudley	Dudley	NFA	No Offence	52.5194345	-2.0858926
12267	op-snap---monthly-publication-july-2025.pdf	319	2025-07	Car	Kia	Picanto	Silver	Driving without Due Care and Attention	None	Leigh Road	Leigh Road	Walsall	Walsall	NFA	Outside of 14 Days NIP	52.594756	-1.9663792
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
12274	op-snap---monthly-publication-july-2025.pdf	326	2025-07	Car		Infiniti	Grey	Driving without Due Care and Attention	None	Barlborough Interchange	Barlborough Interchange	Out of Force Area	Out of Force Area	NFA	Out of Force
12275	op-snap---monthly-publication-july-2025.pdf	327	2025-07	Car	Skoda	Superb	White	Driving without Due Care and Attention	None	Litchfield Road	Litchfield Road	Walsall	Walsall	NFA	No Independent Evidence Available
12278	op-snap---monthly-publication-july-2025.pdf	330	2025-07	Car	Land Rover	Defender	Black	Driving without Due Care and Attention	None	M6 South (jct 10A - 10)	M6 South (jct 10A - 10)	Wolverhampton	Wolverhampton	NFA	Outside of 14 Days NIP
12290	op-snap---monthly-publication-july-2025.pdf	342	2025-07	Car	BMW	X5	Black	Driving without Due Care and Attention	None	Lancaster Street	Lancaster Street	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4888759	-1.8941126
12291	op-snap---monthly-publication-july-2025.pdf	343	2025-07	Car	Citroen	C4	Silver	Driving without Due Care and Attention	None	Walsall Road	Walsall Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5919543	-1.8517118
12292	op-snap---monthly-publication-july-2025.pdf	344	2025-07	Car	Peugeot	Boxer van	White	Driving without Due Care and Attention	None	Smite lane, Worcester	Smite lane, Worcester	Out of Force Area	Out of Force Area	NFA	Out of Force
12293	op-snap---monthly-publication-july-2025.pdf	345	2025-07	Car	Mercedes-Benz	GLE	Black	Driving without Due Care and Attention	None	Dyas Road, Kingstanding	Dyas Road, Kingstanding	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5440194	-1.892884
12294	op-snap---monthly-publication-july-2025.pdf	346	2025-07	Car	Toyota	Verso	Black	Driving without Due Care and Attention	None	Newbury Roaad	Newbury Roaad	Birmingham	Birmingham	NFA	Outside of 14 Days NIP
12297	op-snap---monthly-publication-july-2025.pdf	349	2025-07	Car	Nissan	Micra	Red	Driving without Due Care and Attention	None	Tesco, Blackpool	Tesco, Blackpool	Out of Force Area	Out of Force Area	NFA	Out of Force
12298	op-snap---monthly-publication-july-2025.pdf	350	2025-07	Car	Ford	Fiesta	Black	Driving without Due Care and Attention	None	Fleetwood FY7 7JL	Fleetwood FY7 7JL	Out of Force Area	Out of Force Area	NFA	Out of Force	52.4743461	-1.7895289
12299	op-snap---monthly-publication-july-2025.pdf	351	2025-07	Car	Volkswagen	Golf	Grey	Driving without Due Care and Attention	None	Jubilee Tower, Lancaster	Jubilee Tower, Lancaster	Out of Force Area	Out of Force Area	NFA	Out of Force
12309	op-snap---monthly-publication-july-2025.pdf	361	2025-07	Lorry	Iveco	Daily	Yellow	Driving without Due Care and Attention	None	M6 Toll	M6 Toll	Out of Force Area	Out of Force Area	NFA	Out of Force	52.5804962	-1.7833098
12313	op-snap---monthly-publication-july-2025.pdf	365	2025-07	Car	Volkswagen	Craftor	White	Driving without Due Care and Attention	None	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.5292752	-1.7618805
12319	op-snap---monthly-publication-july-2025.pdf	371	2025-07	Car	Seat	Leon	Black	Driving without Due Care and Attention	None	Billesley Lane	Billesley Lane	Birmingham	Birmingham	NFA	Outside of 14 Days NIP	52.4344402	-1.8845368

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