opsnap: reports: 652 rows where 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'}

652 rows where 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
7270	op-snap---monthly-publication-february-2026.pdf	17	2026-02	Car	Volkswagen	Golf	Black	Driving without Due Care and Attention	None	Hydes Road	Hydes Road	Sandwell	Sandwell	Court	N/A	52.5538064	-2.0139199
7278	op-snap---monthly-publication-february-2026.pdf	25	2026-02	Lorry	Mercedes-Benz	C220	Grey	Driving without Due Care and Attention	None	M6 north	M6 north	Solihull	Solihull	Court	N/A	52.4991559	-1.7380439
7370	op-snap---monthly-publication-february-2026.pdf	117	2026-02	Car	Honda	Jazz	Red	Driving without Due Care and Attention	None	Birchfield Island Olbury	Birchfield Island Olbury	Sandwell	Sandwell	Court	N/A
7378	op-snap---monthly-publication-february-2026.pdf	125	2026-02	Bus	Vauxhall	Astra	Grey	Driving without Due Care and Attention	None	Aston Road	Aston Road	Wolverhampton	Wolverhampton	Court	N/A
7393	op-snap---monthly-publication-february-2026.pdf	140	2026-02	Car	Toyota	Auris	Grey	Driving without Due Care and Attention	No Insurance	Crampers Field	Crampers Field	Coventry	Coventry	Court	N/A	52.4176927	-1.5257854
7408	op-snap---monthly-publication-february-2026.pdf	155	2026-02	Car	BMW	118I	Grey	Driving without Due Care and Attention	None	Hall Green Road	Hall Green Road	Sandwell	Sandwell	Court	N/A	52.5457385	-1.9935809
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
7716	op-snap---monthly-publication-february-2026.pdf	463	2026-02	Motorbike	Kia	Ceed	Red	Driving without Due Care and Attention	None	Quarry Bank HS	Quarry Bank HS	Dudley	Dudley	Court	N/A	52.4733135	-2.1014635
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
7847	op-snap---monthly-publication-february-2026.pdf	594	2026-02	Car	Citroen	C1	White	Driving without Due Care and Attention	None	B4155 Lichfield Road	Lichfield Road	Walsall	Walsall	Court	N/A	52.6095168	-2.0493009
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
7879	op-snap---monthly-publication-february-2026.pdf	626	2026-02	Car	Land Rover	Evoque	Black	Driving without Due Care and Attention	None	Cannock Road	Cannock Road	Walsall	Walsall	Court	N/A	52.610689	-2.0405006
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
7994	op-snap---monthly-publication-february-2026.pdf	741	2026-02	Car	Toyota	Corrolla	Black	Driving without Due Care and Attention	None	Halesowen Road	Halesowen Road	Halesowen	Halesowen	Court	N/A	52.4624413	-2.0175178
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
8264	op-snap---monthly-publication-february-2026.pdf	1011	2026-02	Car	Isuzu		Grey	Driving without Due Care and Attention	Contravening a Red Traffic Light	Cannock Road Wolvs	Cannock Road Wolvs	Wolverhampton	Wolverhampton	Court	N/A
8269	op-snap---monthly-publication-february-2026.pdf	1016	2026-02	Car	Ford	Transit	Blue	Driving without Due Care and Attention	No Insurance	Halesowen Road Netherton	Halesowen Road Netherton	Dudley	Dudley	Court	N/A	52.4904317	-2.0833451
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
8294	op-snap---monthly-publication-february-2026.pdf	1041	2026-02	Car	Audi	A5	Black	Driving without Due Care and Attention	No Insurance	Coventry Eastern Bypass	Coventry Eastern Bypass	Coventry	Coventry	Court	N/A	52.3793117	-1.4625379
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
8375	op-snap---monthly-publication-february-2026.pdf	1122	2026-02	Car	Ford	Fiesta	Purple	Driving without Due Care and Attention	None	Newborough Road	Newborough Road	Solihull	Solihull	Court	N/A	52.4123031	-1.83781
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
8429	op-snap---monthly-publication-february-2026.pdf	1176	2026-02	Car	Ford	Fiesta	Silver	Driving without Due Care and Attention	None	Dudley Port at Sedgley Road	Dudley Port at Sedgley Road	Sandwell	Sandwell	Court	N/A	52.524461	-2.0492538
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
8500	op-snap---monthly-publication-february-2026.pdf	1247	2026-02	Lorry	Mercedes-Benz	S320	Black	Driving without Due Care and Attention	No Insurance	Wood Green Road	Wood Green Road	Sandwell	Sandwell	Court	N/A	52.5628617	-2.0055157
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
8503	op-snap---monthly-publication-february-2026.pdf	1250	2026-02	Other	BMW	335d	Black	Driving without Due Care and Attention	No Insurance	Showcase Cinema	Showcase Cinema	Dudley	Dudley	Court	N/A	52.5169253	-2.070981
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
8537	op-snap---monthly-publication-february-2026.pdf	1284	2026-02	Car	Yamaha		Black	Driving without Due Care and Attention	None	Longmoor at Westwood Sutton	Longmoor at Westwood Sutton	Sutton Coldfield	Sutton Coldfield	Court	N/A	52.5603693	-1.8619416
8558	op-snap---monthly-publication-february-2026.pdf	1305	2026-02	Pedal Bike	Ford	Cmax	Blue	Driving without Due Care and Attention	None	Cranmore Bvd	Cranmore Bvd	Solihull	Solihull	Court	N/A	52.3947549	-1.8141729
8652	op-snap---monthly-publication-february-2026.pdf	1399	2026-02	Car	Jaecoo	7 Luxury	Black	Driving without Due Care and Attention	None	Solihull Lane	Solihull Lane	Solihull	Solihull	Court	N/A	52.4548328	-1.7947304
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
8689	op-snap---monthly-publication-february-2026.pdf	1436	2026-02	Car	BMW	X6	White	Driving without Due Care and Attention	None	Birmingham Road (A34)	Birmingham Road (A34)	Walsall	Walsall	Court	N/A	52.5675147	-1.9513505
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
8702	op-snap---monthly-publication-february-2026.pdf	1449	2026-02	Car	Volkswagen	Golf	White	Driving without Due Care and Attention	None	Highbridge Road	Highbridge Road	Dudley	Dudley	Court	N/A	52.485907	-2.0953009
8739	op-snap---monthly-publication-february-2026.pdf	1486	2026-02	Car	Seat	Ateca	Silver	Driving without Due Care and Attention	None	A45	A45	Coventry	Coventry	Court	N/A
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
8808	op-snap---monthly-publication-february-2026.pdf	1555	2026-02	Car	Jeep	Avenger	Beige	Driving without Due Care and Attention	None	Tollbar End Roundabout	Tollbar End Roundabout	Coventry	Coventry	Court	N/A
8809	op-snap---monthly-publication-february-2026.pdf	1556	2026-02	Car	Ford	Transit	White	Driving without Due Care and Attention	None	Brickhouse Lane	Brickhouse Lane	Sandwell	Sandwell	Court	N/A	52.5331011	-2.0206711
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
10646	op-snap---monthly-publication-january-2026.pdf	107	2026-01	Car	BMW	318D	White	Driving without Due Care and Attention	None	Underhill Lane	Underhill Lane	Wolverhampton	Wolverhampton	Court	N/A	52.6184526	-2.0954562
10657	op-snap---monthly-publication-january-2026.pdf	118	2026-01	Car	BMW	318..	Silver	Driving without Due Care and Attention	No Insurance	A41 Birmingham Road	Birmingham Road	Sandwell	Sandwell	Court	N/A	52.5461417	-1.9334193
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
11063	op-snap---monthly-publication-january-2026.pdf	524	2026-01	Car	Peugeot	Boxvan	White	Driving without Due Care and Attention	None	New Road, Halesowen	New Road, Halesowen	Dudley	Dudley	Court	N/A	52.4514694	-2.0500697
11111	op-snap---monthly-publication-january-2026.pdf	572	2026-01	Car	Mercedes-Benz	C250	Black	Driving without Due Care and Attention	None	Lincoln Road, Solihull	Lincoln Road, Solihull	Solihull	Solihull	Court	N/A	52.4438344	-1.810878
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
11140	op-snap---monthly-publication-january-2026.pdf	601	2026-01	Car	Volkswagen	Transporter	Grey	Driving without Due Care and Attention		Coleshill Heath Road	Coleshill Heath Road	Solihull	Solihull	Court	N/A	52.4667242	-1.7283592
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
11205	op-snap---monthly-publication-january-2026.pdf	666	2026-01	Car	Toyota	Aygo	Black	Driving without Due Care and Attention	None	Warwick Road	Warwick Road	Solihull	Solihull	Court	N/A	52.4428606	-1.812114
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
11398	op-snap---monthly-publication-january-2026.pdf	859	2026-01	Other	BMW	Z4	Blue	Driving without Due Care and Attention	No Insurance	Waterfront Car Park	Waterfront Car Park	Dudley	Dudley	Court	N/A
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
11537	op-snap---monthly-publication-january-2026.pdf	998	2026-01	Car	Audi	S3	Grey	Driving without Due Care and Attention	None	Wobaston Road	Wobaston Road	Wolverhampton	Wolverhampton	Court	N/A	52.628768	-2.1306154
11553	op-snap---monthly-publication-january-2026.pdf	1014	2026-01	Pedal Bike	Jaguar	F Pace	Black	Driving without Due Care and Attention	No Insurance	Stoney Stanton road	Stoney Stanton road	Coventry	Coventry	Court	N/A	52.4221152	-1.4959475
11647	op-snap---monthly-publication-january-2026.pdf	1108	2026-01	Car	BMW	430..	Black	Driving without Due Care and Attention	None	Gulson Road	Gulson Road	Coventry	Coventry	Court	N/A	52.4076795	-1.4911676
11680	op-snap---monthly-publication-january-2026.pdf	1141	2026-01	Car	BMW	M135i	Black	Driving without Due Care and Attention	No Insurance	Cox Street	Cox Street	Coventry	Coventry	Court	N/A	52.4092228	-1.5034119
11688	op-snap---monthly-publication-january-2026.pdf	1149	2026-01	Car	Vauxhall	MOKKA	Black	Driving without Due Care and Attention	None	Lodge Lane	Lodge Lane	Dudley	Dudley	Court	N/A	52.4953929	-2.1814598
11728	op-snap---monthly-publication-january-2026.pdf	1189	2026-01	Car	Kia	Sedona	Black	Driving without Due Care and Attention	No Insurance	Cannock Road	Cannock Road	Wolverhampton	Wolverhampton	Court	N/A	52.6083917	-2.1033365
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
11834	op-snap---monthly-publication-january-2026.pdf	1295	2026-01	Pedal Bike	Suzuki	Swift	Blue	Driving without Due Care and Attention	None	White Street	White Street	Coventry	Coventry	Court	N/A	52.4122951	-1.5045181
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
4087	op-snap---monthly-publication-december-2025.pdf	215	2025-12	Car	Audi	A3	White	Driving without Due Care and Attention	Use vehicle on a road withou	tO vladlbidu rtye sRtd certificate	t O vladlbidu rtye s Rtd certificate	Sandwell	Sandwell	Court	N/A
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
4107	op-snap---monthly-publication-december-2025.pdf	235	2025-12	Car	Toyota	Corolla	White	Driving without Due Care and Attention	None	London Road	London Road	Coventry	Coventry	Court	N/A	52.3916468	-1.4925995

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