reports

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'}

331 rows where council_area = "Sandwell", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

month 14

reporter_transport_mode 1

  • Car · 331 ✖

offence 1

  • Driving without Due Care and Attention · 331 ✖

council_area 1

  • Sandwell · 331 ✖
id source_file source_page 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 witness_contacted 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
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      
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
7997 op-snap---monthly-publication-february-2026.pdf   744 2026-02 Car Ford Ranger White Driving without Due Care and Attention None Crocketts Lane Crocketts Lane Sandwell Sandwell Warning Letter N/A   52.493515 -1.966302
8033 op-snap---monthly-publication-february-2026.pdf   780 2026-02 Car Seat Leon Grey Driving without Due Care and Attention None Rounds Green Road Rounds Green Road Sandwell Sandwell Fixed Penalty N/A   52.5020873 -2.0262185
8088 op-snap---monthly-publication-february-2026.pdf   835 2026-02 Car Hyundai Tucson Blue Driving without Due Care and Attention None M5 Jn2 to A4123 M5 Jn2 to A4123 Sandwell Sandwell Warning Letter N/A      
8110 op-snap---monthly-publication-february-2026.pdf   857 2026-02 Car Vauxhall Mokka Grey Driving without Due Care and Attention None Black Country New Road Black Country New Road Sandwell Sandwell Education N/A   52.5527191 -2.0312967
8111 op-snap---monthly-publication-february-2026.pdf   858 2026-02 Car Vauxhall Insignia Grey Driving without Due Care and Attention None New Swan Lane New Swan Lane Sandwell Sandwell NFA No Offence   52.5293372 -2.0107584
8255 op-snap---monthly-publication-february-2026.pdf   1002 2026-02 Car Ford Fiesta Silver Driving without Due Care and Attention None Island Road Island Road Sandwell Sandwell Fixed Penalty N/A   52.4634433 -1.9965278
8297 op-snap---monthly-publication-february-2026.pdf   1044 2026-02 Car Audi RS3 Black Driving without Due Care and Attention None M5 (N) to M6 (S) slip road M5 (N) to M6 (S) slip road Sandwell Sandwell Fixed Penalty N/A      
8306 op-snap---monthly-publication-february-2026.pdf   1053 2026-02 Car Mercedes-Benz A200 Black Driving without Due Care and Attention   M5 Motorway Jn1 M5 Motorway Jn1 Sandwell Sandwell Education N/A      
8327 op-snap---monthly-publication-february-2026.pdf   1074 2026-02 Car Hyundai Ioniq 5 Grey Driving without Due Care and Attention None M5 M5 Sandwell Sandwell Warning Letter N/A      
8387 op-snap---monthly-publication-february-2026.pdf   1134 2026-02 Car BMW 730D Black Driving without Due Care and Attention None Oldbury Road Oldbury Road Sandwell Sandwell Fixed Penalty N/A   52.5018196 -1.9811249
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
8439 op-snap---monthly-publication-february-2026.pdf   1186 2026-02 Car BMW X5 White Driving without Due Care and Attention None M5 M5 Sandwell Sandwell Education N/A      
8454 op-snap---monthly-publication-february-2026.pdf   1201 2026-02 Car   Multiple   Driving without Due Care and Attention None Throne Road Throne Road Sandwell Sandwell NFA Misc Inc Crimes   52.4875572 -2.0284052
8478 op-snap---monthly-publication-february-2026.pdf   1225 2026-02 Car Volvo Recovery truck White Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA No Offence   52.4926604 -2.0216743
8673 op-snap---monthly-publication-february-2026.pdf   1420 2026-02 Car Vauxhall Combo White Driving without Due Care and Attention None Rowley Village Rowley Village Sandwell Sandwell Education N/A   52.48281 -2.042749
8675 op-snap---monthly-publication-february-2026.pdf   1422 2026-02 Car Iveco Daily White Driving without Due Care and Attention None Throne Road Throne Road Sandwell Sandwell NFA No Offence   52.4875572 -2.0284052
8676 op-snap---monthly-publication-february-2026.pdf   1423 2026-02 Car Ford Transit Black Driving without Due Care and Attention None Throne Road Throne Road Sandwell Sandwell NFA No Offence   52.4875572 -2.0284052
8677 op-snap---monthly-publication-february-2026.pdf   1424 2026-02 Car Volvo XC40 Blue Driving without Due Care and Attention None Throne Road Throne Road Sandwell Sandwell NFA No Offence   52.4875572 -2.0284052
8744 op-snap---monthly-publication-february-2026.pdf   1491 2026-02 Car Ford Connect White Driving without Due Care and Attention None Middlemore Road Middlemore Road Sandwell Sandwell Fixed Penalty N/A   52.5056493 -1.9624063
8745 op-snap---monthly-publication-february-2026.pdf   1492 2026-02 Car Ford Connect White Driving without Due Care and Attention None Middlemore Road Middlemore Road Sandwell Sandwell Duplicate Submission Duplicate Submission   52.5056493 -1.9624063
8779 op-snap---monthly-publication-february-2026.pdf   1526 2026-02 Car Ford Fiesta Blue Driving without Due Care and Attention None Kelvin Way Kelvin Way Sandwell Sandwell RTC - Actioned N/A   52.5090464 -1.9938896
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
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
10810 op-snap---monthly-publication-january-2026.pdf   271 2026-01 Car Mercedes-Benz G 63 Black Driving without Due Care and Attention None Church Lane Church Lane Sandwell Sandwell Education N/A   52.5311655 -2.0008707
10819 op-snap---monthly-publication-january-2026.pdf   280 2026-01 Car Mazda 2 Grey Driving without Due Care and Attention None McKean Road, Oldbury Mc Kean Road, Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.5077405 -2.0124813
10858 op-snap---monthly-publication-january-2026.pdf   319 2026-01 Car Vauxhall Insignia Black Driving without Due Care and Attention None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell Education N/A   52.5010052 -2.0306321
10939 op-snap---monthly-publication-january-2026.pdf   400 2026-01 Car BMW 320d Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Education N/A      
11038 op-snap---monthly-publication-january-2026.pdf   499 2026-01 Car Volkswagen Passat Black Driving without Due Care and Attention None Portland Road, Smethwick Portland Road, Smethwick Sandwell Sandwell Fixed Penalty N/A      
11039 op-snap---monthly-publication-january-2026.pdf   500 2026-01 Car Nissan X-Trail Black Driving without Due Care and Attention None Portland Road, Smethwick Portland Road, Smethwick Sandwell Sandwell Fixed Penalty N/A      
11117 op-snap---monthly-publication-january-2026.pdf   578 2026-01 Car Mercedes-Benz GLC 220 Grey Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell Warning Letter N/A   52.4926604 -2.0216743
11122 op-snap---monthly-publication-january-2026.pdf   583 2026-01 Car Fiat Ducato White Driving without Due Care and Attention None M5 Jct 1 M5 Junction 1 Sandwell Sandwell Warning Letter N/A      
11195 op-snap---monthly-publication-january-2026.pdf   656 2026-01 Car Mercedes-Benz C220 White Driving without Due Care and Attention None Rabone Lane Rabone Lane Sandwell Sandwell Fixed Penalty N/A   52.496577 -1.9614637
11262 op-snap---monthly-publication-january-2026.pdf   723 2026-01 Car Skoda Octavia Black Driving without Due Care and Attention None UK Uk Sandwell Sandwell NFA No Independent Evidence Available   52.5019896 -2.0209184
11345 op-snap---monthly-publication-january-2026.pdf   806 2026-01 Car Audi S3.. Silver Driving without Due Care and Attention No vehicle excise licence Jubilee Street Jubilee Street Sandwell Sandwell Fixed Penalty N/A   52.5395187 -1.9920471
11519 op-snap---monthly-publication-january-2026.pdf   980 2026-01 Car Daf Lorry White Driving without Due Care and Attention None M5/M6 junction M5/M6 junction Sandwell Sandwell NFA No Independent Evidence Available      
11536 op-snap---monthly-publication-january-2026.pdf   997 2026-01 Car Chevrolet Kalos Blue Driving without Due Care and Attention None A4040 A4040 Sandwell Sandwell Warning Letter N/A      
11592 op-snap---monthly-publication-january-2026.pdf   1053 2026-01 Car BMW 118I Grey Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell Fixed Penalty N/A   52.4926604 -2.0216743
11650 op-snap---monthly-publication-january-2026.pdf   1111 2026-01 Car Hyundai I30 Blue Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Sandwell Sandwell Education N/A   52.4702299 -1.9948976
11791 op-snap---monthly-publication-january-2026.pdf   1252 2026-01 Car BMW 320 Black Driving without Due Care and Attention None Coneygree Road Coneygree Road Sandwell Sandwell Fixed Penalty N/A   52.5166627 -2.0629713
11835 op-snap---monthly-publication-january-2026.pdf   1296 2026-01 Car Hyundai i40 Silver Driving without Due Care and Attention None Kenrick Way Kenrick Way Sandwell Sandwell NFA No Offence   52.5079468 -1.9755194
11876 op-snap---monthly-publication-january-2026.pdf   1337 2026-01 Car Volvo Lorry White Driving without Due Care and Attention None A4034 A4034 Sandwell Sandwell Warning Letter N/A      
11923 op-snap---monthly-publication-january-2026.pdf   1384 2026-01 Car BMW 118i Grey Driving without Due Care and Attention None Galton Road Galton Road Sandwell Sandwell Education N/A   52.4700791 -1.9751575
3878 op-snap---monthly-publication-december-2025.pdf   6 2025-12 Car Audi A6 Black Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
3908 op-snap---monthly-publication-december-2025.pdf   36 2025-12 Car Land Rover Sport Black Driving without Due Care and Attention None M6 South M6 South Sandwell Sandwell NFA No VRM   52.5228877 -2.0650728
4031 op-snap---monthly-publication-december-2025.pdf   159 2025-12 Car BMW 5 series Black Driving without Due Care and Attention None Fenton Street, Smethwick Fenton Street, Smethwick Sandwell Sandwell Fixed Penalty N/A   52.5003489 -1.9788331
4046 op-snap---monthly-publication-december-2025.pdf   174 2025-12 Car BMW 3 series Grey Driving without Due Care and Attention None West Mrob West Mrob Sandwell Sandwell NFA No Offence      
4061 op-snap---monthly-publication-december-2025.pdf   189 2025-12 Car Renault Clio Blue Driving without Due Care and Attention None A41 Black Country New Road Black Country New Road Sandwell Sandwell Warning Letter N/A   52.5527191 -2.0312967
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      
4110 op-snap---monthly-publication-december-2025.pdf   238 2025-12 Car Audi A3 Grey Driving without Due Care and Attention None Sandwell and Dudley train station Sandwell and Dudley train station Sandwell Sandwell NFA No Offence   52.5052877 -2.0173733
4262 op-snap---monthly-publication-december-2025.pdf   390 2025-12 Car Vauxhall Insignia Green Driving without Due Care and Attention None A41 A41 Sandwell Sandwell NFA No Independent Evidence Available      
4271 op-snap---monthly-publication-december-2025.pdf   399 2025-12 Car Vauxhall   Red Driving without Due Care and Attention None Oldbury Sainsbury Oldbury Sainsbury Sandwell Sandwell RTC - Actioned N/A   52.5041451 -2.0177654
4316 op-snap---monthly-publication-december-2025.pdf   444 2025-12 Car Ford     Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA No Independent Evidence Available   52.4877352 -1.9494469
4410 op-snap---monthly-publication-december-2025.pdf   538 2025-12 Car Toyota   Grey Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell NFA No VRM   52.5344405 -1.985568
4463 op-snap---monthly-publication-december-2025.pdf   591 2025-12 Car Mercedes-Benz   Black Driving without Due Care and Attention None Dog Kennel Lane Dog Kennel Lane Sandwell Sandwell NFA No VRM   52.4901007 -1.9986317
4552 op-snap---monthly-publication-december-2025.pdf   680 2025-12 Car Ford Transit White Driving without Due Care and Attention None Tollhouse Way Tollhouse Way Sandwell Sandwell Warning Letter N/A   52.5003461 -1.9782389
4608 op-snap---monthly-publication-december-2025.pdf   736 2025-12 Car Mercedes-Benz Citan White Driving without Due Care and Attention None Crankhall Lane Crankhall Lane Sandwell Sandwell Fixed Penalty N/A   52.5489715 -1.9927402
4621 op-snap---monthly-publication-december-2025.pdf   749 2025-12 Car BMW 840i Black Driving without Due Care and Attention None M5 NB J1 M5 Northbound J1 Sandwell Sandwell Warning Letter N/A      
4630 op-snap---monthly-publication-december-2025.pdf   758 2025-12 Car Volkswagen Scirocco Black Driving without Due Care and Attention None M6/M5 slip M6/M5 slip Sandwell Sandwell Warning Letter N/A      
4718 op-snap---monthly-publication-december-2025.pdf   846 2025-12 Car Ford Fiesta White Driving without Due Care and Attention None A41 A41 Sandwell Sandwell NFA No Independent Evidence Available      
4770 op-snap---monthly-publication-december-2025.pdf   898 2025-12 Car BMW M3 Orange Driving without Due Care and Attention None Hallens drive Hallens drive Sandwell Sandwell NFA No Independent Evidence Available   52.5503398 -2.0350718
4854 op-snap---monthly-publication-december-2025.pdf   982 2025-12 Car Volkswagen Polo Black Driving without Due Care and Attention No Insurance Oldbury Road, Smethwick Oldbury Road, Smethwick Sandwell Sandwell NFA No Independent Evidence Available   52.5010892 -1.9794257
4867 op-snap---monthly-publication-december-2025.pdf   995 2025-12 Car Kia EV9 Black Driving without Due Care and Attention None Navigation Roundabout A41 Navigation Roundabout A41 Sandwell Sandwell Fixed Penalty N/A   52.5318418 -2.0304157
4900 op-snap---monthly-publication-december-2025.pdf   1028 2025-12 Car Nissan Micra Blue Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
20469 op-snap---monthly-publication-november-2025.pdf   11 2025-11 Car Peugeot 2008 Orange Driving without Due Care and Attention None Great Bridge LIONS roundabout Great Bridge LIONS roundabout Sandwell Sandwell Education N/A      
20560 op-snap---monthly-publication-november-2025.pdf   102 2025-11 Car Volkswagen Tiguan White Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Sandwell Sandwell NFA No Offence   52.4702299 -1.9948976
20600 op-snap---monthly-publication-november-2025.pdf   142 2025-11 Car Vauxhall Astra Blue Driving without Due Care and Attention None Sedgley Road Sedgley Road Sandwell Sandwell Warning Letter N/A   52.5219813 -2.0581691
20624 op-snap---monthly-publication-november-2025.pdf   166 2025-11 Car BMW 3 Series White Driving without Due Care and Attention No Insurance Dudley Port Dudley Port Sandwell Sandwell Court N/A   52.524461 -2.0492538
20669 op-snap---monthly-publication-november-2025.pdf   211 2025-11 Car Audi Q3 Blue Driving without Due Care and Attention None Black Lake Black Lake Sandwell Sandwell Court N/A   52.5341947 -2.0098521
20671 op-snap---monthly-publication-november-2025.pdf   213 2025-11 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Rolfe Street Rolfe Street Sandwell Sandwell Education N/A   52.4972172 -1.9607539
20693 op-snap---monthly-publication-november-2025.pdf   235 2025-11 Car Toyota   Silver Driving without Due Care and Attention None Long Lane Long Lane Sandwell Sandwell Fixed Penalty N/A   52.4748171 -2.0377939
20720 op-snap---monthly-publication-november-2025.pdf   262 2025-11 Car Ford Focus Red Driving without Due Care and Attention No vehicle excise licence Corngreaves Road Corngreaves Road Sandwell Sandwell Education N/A   52.4686695 -2.0776976
20741 op-snap---monthly-publication-november-2025.pdf   283 2025-11 Car Seat Leon Silver Driving without Due Care and Attention None New Birmingham Road New Birmingham Road Sandwell Sandwell Warning Letter N/A   52.5113475 -2.0508304
20756 op-snap---monthly-publication-november-2025.pdf   298 2025-11 Car Scania Tractor White Driving without Due Care and Attention None Bilston Road Bilston Road Sandwell Sandwell NFA Not in Public Interest   52.5485881 -2.0510406
20775 op-snap---monthly-publication-november-2025.pdf   317 2025-11 Car Volkswagen T Cross Grey Driving without Due Care and Attention None Spon lane South Spon lane South Sandwell Sandwell Fixed Penalty N/A   52.5059028 -1.9920373
20939 op-snap---monthly-publication-november-2025.pdf   481 2025-11 Car BMW 420D Grey Driving without Due Care and Attention None Coopers Lane Coopers Lane Sandwell Sandwell Warning Letter N/A   52.4921093 -1.9705849
20953 op-snap---monthly-publication-november-2025.pdf   495 2025-11 Car Ford Focus Grey Driving without Due Care and Attention None Malin Streett Malin Streett Sandwell Sandwell NFA No Independent Evidence Available      
21273 op-snap---monthly-publication-november-2025.pdf   815 2025-11 Car Volkswagen Golf Silver Driving without Due Care and Attention None High Street Great Bridge... not sure where that is yet High Street Great Bridge. not sure where that is yet Sandwell Sandwell Education N/A      
21275 op-snap---monthly-publication-november-2025.pdf   817 2025-11 Car Mercedes-Benz A CLASS Grey Driving without Due Care and Attention None Birmingham Road Oldbury Birmingham Road Oldbury Sandwell Sandwell Warning Letter N/A   52.5025832 -2.0105737
21367 op-snap---monthly-publication-november-2025.pdf   909 2025-11 Car BMW 118d Black Driving without Due Care and Attention None All Saints Way All Saints Way Sandwell Sandwell RTC - Actioned N/A   52.5344405 -1.985568
21456 op-snap---monthly-publication-november-2025.pdf   998 2025-11 Car Seat Leon Grey Driving without Due Care and Attention None Claremont Street / Reddal Hill Road Claremont Street / Reddal Hill Road Sandwell Sandwell Court N/A   52.4755356 -2.0727906
21543 op-snap---monthly-publication-november-2025.pdf   1085 2025-11 Car Dennis Bus   Driving without Due Care and Attention None Dudley Stree, Carters Green, West Bromwich Dudley Stree, Carters Green, West Bromwich Sandwell Sandwell Education N/A      
21555 op-snap---monthly-publication-november-2025.pdf   1097 2025-11 Car Mercedes-Benz C250 Black Driving without Due Care and Attention None Londonderry Lane Londonderry Lane Sandwell Sandwell NFA No Offence   52.4910374 -1.9779539
21556 op-snap---monthly-publication-november-2025.pdf   1098 2025-11 Car Vauxhall Vivaro Silver Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell NFA No Offence   52.5428224 -1.9569444
21592 op-snap---monthly-publication-november-2025.pdf   1134 2025-11 Car Mercedes-Benz GLE 450 Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
21902 op-snap---monthly-publication-november-2025.pdf   1444 2025-11 Car Ford Focus Grey Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
21970 op-snap---monthly-publication-november-2025.pdf   1512 2025-11 Car Volkswagen Sharan Blue Driving without Due Care and Attention None A457 Oldbury Road Oldbury Road Sandwell Sandwell NFA No Offence   52.5018196 -1.9811249
22024 op-snap---monthly-publication-november-2025.pdf   1566 2025-11 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Regent Road Regent Road Sandwell Sandwell Warning Letter N/A   52.5106406 -2.0559963
22062 op-snap---monthly-publication-october-2025.pdf   12 2025-10 Car Land Rover Defender Black Driving without Due Care and Attention None M6 Motorway M6 Motorway Sandwell Sandwell Court N/A      
22125 op-snap---monthly-publication-october-2025.pdf   75 2025-10 Car Mg HS Silver Driving without Due Care and Attention None Portway Hill Portway Hill Sandwell Sandwell Fixed Penalty N/A   52.4990342 -2.0424359
22174 op-snap---monthly-publication-october-2025.pdf   124 2025-10 Car Mini Mini Grey Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.4877352 -1.9494469
22277 op-snap---monthly-publication-october-2025.pdf   227 2025-10 Car Vauxhall Astra Silver Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
22394 op-snap---monthly-publication-october-2025.pdf   344 2025-10 Car Citroen DS3.. Black Driving without Due Care and Attention None Station Road Station Road Sandwell Sandwell Warning Letter N/A   52.4774652 -2.0337514
22418 op-snap---monthly-publication-october-2025.pdf   368 2025-10 Car Audi A6 Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
22439 op-snap---monthly-publication-october-2025.pdf   389 2025-10 Car Mercedes-Benz GLC 300 Black Driving without Due Care and Attention None Hainge Road Hainge Road Sandwell Sandwell Education N/A   52.511993 -2.0394885
22452 op-snap---monthly-publication-october-2025.pdf   402 2025-10 Car Audi A5 Black Driving without Due Care and Attention None A41 A41 Sandwell Sandwell NFA Not in Public Interest      
22467 op-snap---monthly-publication-october-2025.pdf   417 2025-10 Car Mercedes-Benz A200 Red Driving without Due Care and Attention None Barnsley Road Barnsley Road Sandwell Sandwell Education N/A   52.4743497 -1.965737
22503 op-snap---monthly-publication-october-2025.pdf   453 2025-10 Car Nissan Note Silver Driving without Due Care and Attention No Insurance Cradley Heath train station Cradley Heath train station Sandwell Sandwell NFA Misc Inc Crimes      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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