opsnap: reports: 332 rows where council_area = "Birmingham", disposal = "Court" 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'}

332 rows where council_area = "Birmingham", disposal = "Court" 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
7427	op-snap---monthly-publication-february-2026.pdf	174	2026-02	Pedal Bike	Chysler	Grand Voyager	Grey	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	Court	N/A	52.4203897	-1.8338574
7442	op-snap---monthly-publication-february-2026.pdf	189	2026-02	Pedal Bike	Mercedes-Benz	E220	Silver	Driving without Due Care and Attention	None	Bradford Street	Bradford Street	Birmingham	Birmingham	Court	N/A	52.4708802	-1.8792135
7590	op-snap---monthly-publication-february-2026.pdf	337	2026-02	Car	Volkswagen	Polo	White	Driving without Due Care and Attention	None	Cole Bank Road	Cole Bank Road	Birmingham	Birmingham	Court	N/A	52.4349375	-1.8510007
7593	op-snap---monthly-publication-february-2026.pdf	340	2026-02	Car	Seat	Ibiza	Grey	Driving without Due Care and Attention	None	Walford Road	Walford Road	Birmingham	Birmingham	Court	N/A	52.4594072	-1.8658859
7805	op-snap---monthly-publication-february-2026.pdf	552	2026-02	Car	Land Rover	Evoque	White	Driving without Due Care and Attention	None	Shirley Road	Shirley Road	Birmingham	Birmingham	Court	N/A	52.4198291	-1.9241732
7839	op-snap---monthly-publication-february-2026.pdf	586	2026-02	Pedal Bike	Skoda	Octavia	Blue	Driving without Due Care and Attention	No Insurance	Dads Lane	Dads Lane	Birmingham	Birmingham	Court	N/A	52.4375913	-1.9068522
7849	op-snap---monthly-publication-february-2026.pdf	596	2026-02	Pedal Bike	Mercedes-Benz	A180	Grey	Driving without Due Care and Attention	None	Gillhurst Road	Gillhurst Road	Birmingham	Birmingham	Court	N/A	52.467676	-1.9548345
7912	op-snap---monthly-publication-february-2026.pdf	659	2026-02	Pedestrian	Volkswagen	Polo	Green	Driving without Due Care and Attention	None	Wedgewood Road	Wedgewood Road	Birmingham	Birmingham	Court	N/A	52.4560365	-1.9936623
8015	op-snap---monthly-publication-february-2026.pdf	762	2026-02	Pedal Bike	Audi	A3	Green	Driving without Due Care and Attention	None	Pritchatts Road, Edgbaston	Pritchatts Road, Edgbaston	Birmingham	Birmingham	Court	N/A	52.4563161	-1.934895
8045	op-snap---monthly-publication-february-2026.pdf	792	2026-02	Car	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Battery Way	Battery Way	Birmingham	Birmingham	Court	N/A	52.4493988	-1.8476406
8065	op-snap---monthly-publication-february-2026.pdf	812	2026-02	Car	Volkswagen	Golf	Grey	Driving without Due Care and Attention	No Insurance	A45 Small Heath Highway	Small Heath Highway	Birmingham	Birmingham	Court	N/A	52.4709298	-1.8722585
8209	op-snap---monthly-publication-february-2026.pdf	956	2026-02	Car	Mercedes-Benz	C220 D	Black	Driving without Due Care and Attention	None	Lawley MIddleway	Lawley MIddleway	Birmingham	Birmingham	Court	N/A	52.4801772	-1.8769185
8252	op-snap---monthly-publication-february-2026.pdf	999	2026-02	Car	BMW	S1000 XR	Grey	Driving without Due Care and Attention	Contravening a Red Traffic Light	Lichfield Road	Lichfield Road	Birmingham	Birmingham	Court	N/A	52.5012458	-1.8780942
8289	op-snap---monthly-publication-february-2026.pdf	1036	2026-02	Car	Honda	Civic	Black	Driving without Due Care and Attention	None	Robin Hood Lane	Robin Hood Lane	Birmingham	Birmingham	Court	N/A	52.4221526	-1.8425617
8333	op-snap---monthly-publication-february-2026.pdf	1080	2026-02	Car	Peugeot	Partner	White	Driving without Due Care and Attention	No Insurance	Cooks Lane	Cooks Lane	Birmingham	Birmingham	Court	N/A	52.482758	-1.7603097
8357	op-snap---monthly-publication-february-2026.pdf	1104	2026-02	Pedal Bike	Toyota	Prius	White	Driving without Due Care and Attention	None	Sandpits	Sandpits	Birmingham	Birmingham	Court	N/A	52.482308	-1.9133277
8412	op-snap---monthly-publication-february-2026.pdf	1159	2026-02	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	No Insurance	Norrington Road	Norrington Road	Birmingham	Birmingham	Court	N/A	52.4114918	-1.9900683
8419	op-snap---monthly-publication-february-2026.pdf	1166	2026-02	Car	Mercedes-Benz	Sprinter	White	Driving without Due Care and Attention	None	Suffolk Street Queensway	Suffolk Street Queensway	Birmingham	Birmingham	Court	N/A	52.4760986	-1.9018641
8480	op-snap---monthly-publication-february-2026.pdf	1227	2026-02	Car	Volkswagen	golf	Red	Driving without Due Care and Attention	None	Watery Lane Middleway	Watery Lane Middleway	Birmingham	Birmingham	Court	N/A	52.4752679	-1.8748608
8502	op-snap---monthly-publication-february-2026.pdf	1249	2026-02	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Moor Lane at Brookvale Road (Perry Barr)	Moor Lane at Brookvale Road (Perry Barr)	Birmingham	Birmingham	Court	N/A	52.5276389	-1.8831953
8516	op-snap---monthly-publication-february-2026.pdf	1263	2026-02	Car	BMW	320I	Black	Driving without Due Care and Attention	None	Highfield Road	Highfield Road	Birmingham	Birmingham	Court	N/A	52.4216321	-1.855984
8518	op-snap---monthly-publication-february-2026.pdf	1265	2026-02	Car	Honda	Civic	Silver	Driving without Due Care and Attention	None	Hurst Lane North	Hurst Lane North	Birmingham	Birmingham	Court	N/A	52.4994582	-1.7644778
8519	op-snap---monthly-publication-february-2026.pdf	1266	2026-02	Car	Volkswagen	Jetta	Grey	Driving without Due Care and Attention	None	Hurst Lane North	Hurst Lane North	Birmingham	Birmingham	Court	N/A	52.4994582	-1.7644778
8524	op-snap---monthly-publication-february-2026.pdf	1271	2026-02	Pedal Bike	Dacia	Duster	Orange	Driving without Due Care and Attention	None	Camp Hill Circus	Camp Hill Circus	Birmingham	Birmingham	Court	N/A	52.4682339	-1.8793662
8654	op-snap---monthly-publication-february-2026.pdf	1401	2026-02	Car	Volkswagen	T Roc	Black	Driving without Due Care and Attention	None	Collingwood Drive	Collingwood Drive	Birmingham	Birmingham	Court	N/A
8674	op-snap---monthly-publication-february-2026.pdf	1421	2026-02	Car	Volkswagen	Passat	Black	Driving without Due Care and Attention	No Insurance	Walford Road	Walford Road	Birmingham	Birmingham	Court	N/A	52.4594072	-1.8658859
8700	op-snap---monthly-publication-february-2026.pdf	1447	2026-02	Pedal Bike	BMW	1 Series	Blue	Driving without Due Care and Attention	None	Dads Lane	Dads Lane	Birmingham	Birmingham	Court	N/A	52.4375913	-1.9068522
8743	op-snap---monthly-publication-february-2026.pdf	1490	2026-02	Car	Vauxhall	Corsa	Silver	Driving without Due Care and Attention	No Insurance	Woodland Road	Woodland Road	Birmingham	Birmingham	Court	N/A	52.4108681	-1.9611917
8747	op-snap---monthly-publication-february-2026.pdf	1494	2026-02	Pedal Bike	Toyota	Prius	Silver	Driving without Due Care and Attention	None	Valentine Road	Valentine Road	Birmingham	Birmingham	Court	N/A	52.4381959	-1.8907391
8784	op-snap---monthly-publication-february-2026.pdf	1531	2026-02	Car	Honda	CBR 600	Yellow	Driving without Due Care and Attention	None	Carters Lane	Carters Lane	Birmingham	Birmingham	Court	N/A	52.4445826	-2.013123
8810	op-snap---monthly-publication-february-2026.pdf	1557	2026-02	Car	Lexus	NX450	Black	Driving without Due Care and Attention	None	Chester Road, Castle Bromwich	Chester Road, Castle Bromwich	Birmingham	Birmingham	Court	N/A
8816	op-snap---monthly-publication-february-2026.pdf	1563	2026-02	Pedal Bike	Audi	A5	Silver	Driving without Due Care and Attention	No Insurance	Lawley Middleway	Lawley Middleway	Birmingham	Birmingham	Court	N/A	52.4801772	-1.8769185
10558	op-snap---monthly-publication-january-2026.pdf	19	2026-01	Pedal Bike	Volkswagen	Polo	Black	Driving without Due Care and Attention	No vehicle excise licence	Brook Lane	Brook Lane	Birmingham	Birmingham	Court	N/A	52.4297007	-1.8668846
10922	op-snap---monthly-publication-january-2026.pdf	383	2026-01	Car	Volkswagen	Polo	White	Driving without Due Care and Attention	None	Olton Boulevard	Olton Boulevard	Birmingham	Birmingham	Court	N/A	52.443439	-1.8180486
11027	op-snap---monthly-publication-january-2026.pdf	488	2026-01	Car	Suzuki	GSXS 125	Black	Driving without Due Care and Attention	Drive otherwise than in accordance with a licence	Bristol Road South	Bristol Road South	Birmingham	Birmingham	Court	N/A	52.4119174	-1.9735247
11050	op-snap---monthly-publication-january-2026.pdf	511	2026-01	Car	Toyota	Corolla	silver	Driving without Due Care and Attention	None	Sutton Road, Erdington	Sutton Road, Erdington	Birmingham	Birmingham	Court	N/A	52.5339483	-1.8285296
11132	op-snap---monthly-publication-january-2026.pdf	593	2026-01	Pedestrian	Peugeot	307..	Silver	Driving without Due Care and Attention	No Insurance	Stonor Road	Stonor Road	Birmingham	Birmingham	Court	N/A	52.4176973	-1.8351247
11145	op-snap---monthly-publication-january-2026.pdf	606	2026-01	Car	BMW	M3	White	Driving without Due Care and Attention	Contravening a Red Traffic Light	Linden Rd	Linden Road	Birmingham	Birmingham	Court	N/A	52.4263156	-1.9351622
11164	op-snap---monthly-publication-january-2026.pdf	625	2026-01	Car	Toyota	Prius	White	Driving without Due Care and Attention	Driving without Due Care and Attention	Five Ways Roundabout, Birmingham	Five Ways Roundabout, Birmingham	Birmingham	Birmingham	Court	N/A
11206	op-snap---monthly-publication-january-2026.pdf	667	2026-01	Car	Audi	A5	Grey	Driving without Due Care and Attention	None	Golden Hillock Road	Golden Hillock Road	Birmingham	Birmingham	Court	N/A	52.4622646	-1.8599985
11208	op-snap---monthly-publication-january-2026.pdf	669	2026-01	Car	Nissan	Qashqai	Black	Driving without Due Care and Attention	None	Washwood Heath Road	Washwood Heath Road	Birmingham	Birmingham	Court	N/A	52.4929304	-1.8229092
11295	op-snap---monthly-publication-january-2026.pdf	756	2026-01	Other	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	George Street	George Street	Birmingham	Birmingham	Court	N/A	52.5048075	-1.9545728
11321	op-snap---monthly-publication-january-2026.pdf	782	2026-01	Car	Renault	Captur	Black	Driving without Due Care and Attention	Use vehicle on a road without valid test certificate	Grosvenor Road	Grosvenor Road	Birmingham	Birmingham	Court	N/A	52.4613204	-1.9681665
11363	op-snap---monthly-publication-january-2026.pdf	824	2026-01	Car	Vauxhall	Insignia	Black	Driving without Due Care and Attention	Contravening a Red Traffic Light	Rotton Park Road	Rotton Park Road	Birmingham	Birmingham	Court	N/A	52.4851072	-1.9468115
11382	op-snap---monthly-publication-january-2026.pdf	843	2026-01	Car	Chysler		Black	Driving without Due Care and Attention	None	Warwick Road at Stockfield Road	Warwick Road at Stockfield Road	Birmingham	Birmingham	Court	N/A	52.551985	-1.860445
11396	op-snap---monthly-publication-january-2026.pdf	857	2026-01	Car	BMW	M4	Red	Driving without Due Care and Attention	No Insurance	Holiday Street	Holiday Street	Birmingham	Birmingham	Court	N/A	52.4757071	-1.8988573
11460	op-snap---monthly-publication-january-2026.pdf	921	2026-01	Pedal Bike	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Brook lane	Brook lane	Birmingham	Birmingham	Court	N/A	52.4297007	-1.8668846
11754	op-snap---monthly-publication-january-2026.pdf	1215	2026-01	Car	Hyundai	Bayon	Grey	Driving without Due Care and Attention	None	Clay Lane	Clay Lane	Birmingham	Birmingham	Court	N/A	52.4509038	-1.8083784
11767	op-snap---monthly-publication-january-2026.pdf	1228	2026-01	Van	Kia	Sportage	Green	Driving without Due Care and Attention	None	Shirley Road	Shirley Road	Birmingham	Birmingham	Court	N/A	52.4198291	-1.9241732
11806	op-snap---monthly-publication-january-2026.pdf	1267	2026-01	Car	Audi	A3	Black	Driving without Due Care and Attention	None	Cole Bank Rd, Sarehole Mill	Cole Bank Road, Sarehole Mill	Birmingham	Birmingham	Court	N/A
11836	op-snap---monthly-publication-january-2026.pdf	1297	2026-01	Car	Ford	Eco Sport	Grey	Driving without Due Care and Attention	None	Allens Croft Road	Allens Croft Road	Birmingham	Birmingham	Court	N/A	52.4242527	-1.910803
11838	op-snap---monthly-publication-january-2026.pdf	1299	2026-01	Pedal Bike	Lamborghini	Urus	Blue	Driving without Due Care and Attention	No Insurance	Northfield Road	Northfield Road	Birmingham	Birmingham	Court	N/A	52.4167654	-1.9411244
11873	op-snap---monthly-publication-january-2026.pdf	1334	2026-01	Pedal Bike	Mercedes-Benz	C220	Blue	Driving without Due Care and Attention	No Insurance	Augustus Road	Augustus Road	Birmingham	Birmingham	Court	N/A	52.4695793	-1.9378608
3987	op-snap---monthly-publication-december-2025.pdf	115	2025-12	Pedal Bike	Volkswagen	Golf	Silver	Driving without Due Care and Attention	None	Sarehole Road	Sarehole Road	Birmingham	Birmingham	Court	N/A	52.4422505	-1.8539684
3996	op-snap---monthly-publication-december-2025.pdf	124	2025-12	Car	Mercedes-Benz	AMG	Grey	Driving without Due Care and Attention	No Insurance	High Street Kings Heath	High Street Kings Heath	Birmingham	Birmingham	Court	N/A	52.4375456	-1.8926849
4041	op-snap---monthly-publication-december-2025.pdf	169	2025-12	Pedal Bike	Renault	Kadjar	Black	Driving without Due Care and Attention	None	Lincoln Street	Lincoln Street	Birmingham	Birmingham	Court	N/A	52.459298	-1.8933648
4062	op-snap---monthly-publication-december-2025.pdf	190	2025-12	Other	Audi	A5	Black	Driving without Due Care and Attention	None	Gopsal Street	Gopsal Street	Birmingham	Birmingham	Court	N/A	52.4837913	-1.8822888
4088	op-snap---monthly-publication-december-2025.pdf	216	2025-12	Car	Mercedes-Benz	c250	Black	Driving without Due Care and Attention	None	Shaftmoor Lane	Shaftmoor Lane	Birmingham	Birmingham	Court	N/A	52.4418944	-1.8407335
4090	op-snap---monthly-publication-december-2025.pdf	218	2025-12	Car	Peugeot	3008..	Grey	Driving without Due Care and Attention	None	Birmingham Fort Parkway	Birmingham Fort Parkway	Birmingham	Birmingham	Court	N/A	52.5084571	-1.8214016
4119	op-snap---monthly-publication-december-2025.pdf	247	2025-12	Car	Seat	Leon	Grey	Driving without Due Care and Attention	None	Buckland End Lane	Buckland End Lane	Birmingham	Birmingham	Court	N/A
4152	op-snap---monthly-publication-december-2025.pdf	280	2025-12	Pedal Bike	Audi	A4	White	Driving without Due Care and Attention	No Insurance	Tyburn Road	Tyburn Road	Birmingham	Birmingham	Court	N/A	52.5113867	-1.8337258
4186	op-snap---monthly-publication-december-2025.pdf	314	2025-12	Car	Volvo	XC90	Blue	Driving without Due Care and Attention	No Insurance	Richmond Road	Richmond Road	Birmingham	Birmingham	Court	N/A	52.566947	-1.8291809
4190	op-snap---monthly-publication-december-2025.pdf	318	2025-12	Car	Peugeot	208	Black	Driving without Due Care and Attention	None	A38 Aston Expressway	Aston Expressway	Birmingham	Birmingham	Court	N/A	52.493793	-1.8881773
4307	op-snap---monthly-publication-december-2025.pdf	435	2025-12	Car	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Longbridge Lane	Longbridge Lane	Birmingham	Birmingham	Court	N/A	52.3962003	-1.9821252
4351	op-snap---monthly-publication-december-2025.pdf	479	2025-12	Car	Volvo	V40..	Blue	Driving without Due Care and Attention	None	Greenholm Road	Greenholm Road	Birmingham	Birmingham	Court	N/A	52.5356973	-1.8929646
4402	op-snap---monthly-publication-december-2025.pdf	530	2025-12	Car	Volkswagen	Crafter	White	Driving without Due Care and Attention	None	Small Heath Highway	Small Heath Highway	Birmingham	Birmingham	Court	N/A	52.4709298	-1.8722585
4431	op-snap---monthly-publication-december-2025.pdf	559	2025-12	Car	Volkswagen	Arteon	Blue	Driving without Due Care and Attention	None	Newport Road, Castle Bromwich	Newport Road, Castle Bromwich	Birmingham	Birmingham	Court	N/A
4539	op-snap---monthly-publication-december-2025.pdf	667	2025-12	Car		Maserati	Blue	Driving without Due Care and Attention	None	A38m	A38m	Birmingham	Birmingham	Court	N/A
4730	op-snap---monthly-publication-december-2025.pdf	858	2025-12	Car	Tesla	Model Y	White	Driving without Due Care and Attention	None	Bunbury Road	Bunbury Road	Birmingham	Birmingham	Court	N/A	52.4142089	-1.9587147
4826	op-snap---monthly-publication-december-2025.pdf	954	2025-12	Car	Seat	MII	Black	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	Court	N/A	52.4203897	-1.8338574
4968	op-snap---monthly-publication-december-2025.pdf	1096	2025-12	Car	Vauxhall	Insignia	Black	Driving without Due Care and Attention	None	Bristol Road South	Bristol Road South	Birmingham	Birmingham	Court	N/A	52.4119174	-1.9735247
5046	op-snap---monthly-publication-december-2025.pdf	1174	2025-12	Car	Mercedes-Benz	C220	white	Driving without Due Care and Attention	None	Cattel Road	Cattel Road	Birmingham	Birmingham	Court	N/A
5047	op-snap---monthly-publication-december-2025.pdf	1175	2025-12	Car	Toyota	Aygo	Black	Driving without Due Care and Attention	None	Warwick Road	Warwick Road	Birmingham	Birmingham	Court	N/A	52.4555288	-1.8613929
5058	op-snap---monthly-publication-december-2025.pdf	1186	2025-12	Car	Renault	Trafic	White	Driving without Due Care and Attention	None	Queslett Road	Queslett Road	Birmingham	Birmingham	Court	N/A	52.5458699	-1.9304484
20478	op-snap---monthly-publication-november-2025.pdf	20	2025-11	Car	Seat	Leon	Black	Driving without Due Care and Attention	None	M6	M6	Birmingham	Birmingham	Court	N/A
20506	op-snap---monthly-publication-november-2025.pdf	48	2025-11	Car	Volvo	Lorry	White	Driving without Due Care and Attention	None	M42 Motorway	M42 Motorway	Birmingham	Birmingham	Court	N/A	52.490826	-1.8882034
20579	op-snap---monthly-publication-november-2025.pdf	121	2025-11	Car	Vauxhall	Corsa	Grey	Driving without Due Care and Attention	No Insurance	Kingsbury Road	Kingsbury Road	Birmingham	Birmingham	Court	N/A	52.5292752	-1.7618805
20584	op-snap---monthly-publication-november-2025.pdf	126	2025-11	Car	Audi	A4	White	Driving without Due Care and Attention	No Insurance	Stonehouse Lane	Stonehouse Lane	Birmingham	Birmingham	Court	N/A	52.4440435	-1.9818872
20598	op-snap---monthly-publication-november-2025.pdf	140	2025-11	Other	Ford	Transit	Black	Driving without Due Care and Attention	None	The Deers Leap	The Deers Leap	Birmingham	Birmingham	Court	N/A	52.5601871	-1.8928907
20611	op-snap---monthly-publication-november-2025.pdf	153	2025-11	Car	Ford	Focus	Blue	Driving without Due Care and Attention	None	Northfield Road	Northfield Road	Birmingham	Birmingham	Court	N/A	52.4167654	-1.9411244
20619	op-snap---monthly-publication-november-2025.pdf	161	2025-11	Car	Vauxhall	Crossland	Black	Driving without Due Care and Attention	None	Tixall Road	Tixall Road	Birmingham	Birmingham	Court	N/A	52.4193312	-1.8517995
20634	op-snap---monthly-publication-november-2025.pdf	176	2025-11	Car	Ford	Transit	White	Driving without Due Care and Attention	None	M6	M6	Birmingham	Birmingham	Court	N/A
20672	op-snap---monthly-publication-november-2025.pdf	214	2025-11	Car	Volkswagen	Sharan	Black	Driving without Due Care and Attention	No Insurance	St Margarets Road	Street Margarets Road	Birmingham	Birmingham	Court	N/A
20740	op-snap---monthly-publication-november-2025.pdf	282	2025-11	Car	BMW	120d	Black	Driving without Due Care and Attention	No Insurance	Barnes Hill	Barnes Hill	Birmingham	Birmingham	Court	N/A	52.4401325	-1.9785938
20745	op-snap---monthly-publication-november-2025.pdf	287	2025-11	Car	Jaguar	XF	Silver	Driving without Due Care and Attention	No vehicle excise licence	Bromford Lane	Bromford Lane	Birmingham	Birmingham	Court	N/A	52.5083238	-1.8332287
20786	op-snap---monthly-publication-november-2025.pdf	328	2025-11	Car	Volkswagen	Golf	Grey	Driving without Due Care and Attention	No Insurance	Hamstead Hill	Hamstead Hill	Birmingham	Birmingham	Court	N/A	52.5274116	-1.9287273
20820	op-snap---monthly-publication-november-2025.pdf	362	2025-11	Car	Volkswagen	Caddy	White	Driving without Due Care and Attention	None	Edgewood Road	Edgewood Road	Birmingham	Birmingham	Court	N/A	52.3904074	-2.0028084
20845	op-snap---monthly-publication-november-2025.pdf	387	2025-11	Car	Ford	Fiesta	Orange	Driving without Due Care and Attention	None	Walmey Ash Road	Walmey Ash Road	Birmingham	Birmingham	Court	N/A
21049	op-snap---monthly-publication-november-2025.pdf	591	2025-11	Pedestrian	Yamaha	GPD125	Red	Driving without Due Care and Attention	None	Newtown St	Newtown Street	Birmingham	Birmingham	Court	N/A	52.4964717	-1.8963477
21326	op-snap---monthly-publication-november-2025.pdf	868	2025-11	Car	Land Rover	Land Rover	Black	Driving without Due Care and Attention	None	Billesley Lane	Billesley Lane	Birmingham	Birmingham	Court	N/A	52.4344402	-1.8845368
21327	op-snap---monthly-publication-november-2025.pdf	869	2025-11	Car	Volkswagen	Polo	White	Driving without Due Care and Attention	None	Beacon Road	Beacon Road	Birmingham	Birmingham	Court	N/A	52.545172	-1.836877
21403	op-snap---monthly-publication-november-2025.pdf	945	2025-11	Car	Nissan	QASQHAI	Silver	Driving without Due Care and Attention	None	Reddings LANE	Reddings LANE	Birmingham	Birmingham	Court	N/A	52.4506039	-1.8463952
21417	op-snap---monthly-publication-november-2025.pdf	959	2025-11	Car	Volkswagen	Golf	Blue	Driving without Due Care and Attention	None	Small Heath Highway	Small Heath Highway	Birmingham	Birmingham	Court	N/A	52.4709298	-1.8722585
21516	op-snap---monthly-publication-november-2025.pdf	1058	2025-11	Pedal Bike	Hyundai	i10	Black	Driving without Due Care and Attention	Use vehicle on a road without valid test certificate	Camp Hill Road	Camp Hill Road	Birmingham	Birmingham	Court	N/A	52.4306415	-1.9041558
21560	op-snap---monthly-publication-november-2025.pdf	1102	2025-11	Pedal Bike	Ford	Transit	White	Driving without Due Care and Attention	None	Stratford Road	Stratford Road	Birmingham	Birmingham	Court	N/A	52.4203897	-1.8338574
21563	op-snap---monthly-publication-november-2025.pdf	1105	2025-11	Pedal Bike	Vauxhall	Corsa	Black	Driving without Due Care and Attention	No Insurance	Leach Green Lane	Leach Green Lane	Birmingham	Birmingham	Court	N/A	52.392246	-2.0101736
21576	op-snap---monthly-publication-november-2025.pdf	1118	2025-11	Car	Peugeot	208	Blue	Driving without Due Care and Attention	None	Burney Lane	Burney Lane	Birmingham	Birmingham	Court	N/A	52.489521	-1.8206611
21587	op-snap---monthly-publication-november-2025.pdf	1129	2025-11	Car	Mercedes-Benz	CLA 200	Blue	Driving without Due Care and Attention	None	Heathfield Road	Heathfield Road	Birmingham	Birmingham	Court	N/A	52.5905365	-1.8453418
21673	op-snap---monthly-publication-november-2025.pdf	1215	2025-11	Car	BMW	530 D	Blue	Driving without Due Care and Attention	None	M6	M6	Birmingham	Birmingham	Court	N/A
21757	op-snap---monthly-publication-november-2025.pdf	1299	2025-11	Pedal Bike	Toyota	Prius	White	Driving without Due Care and Attention	None	Hill Street	Hill Street	Birmingham	Birmingham	Court	N/A	52.4777765	-1.901321

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