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

142 rows where council_area = "Sandwell", disposal = "NFA" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 9

offence 1

  • Driving without Due Care and Attention · 142 ✖

disposal 1

  • NFA · 142 ✖

council_area 1

  • Sandwell · 142 ✖
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
8094 op-snap---monthly-publication-february-2026.pdf   841 2026-02 Bus Volkswagen Golf Silver Driving without Due Care and Attention None West Brom Ringway West Brom Ringway Sandwell Sandwell NFA No VRM      
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
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
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
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
10980 op-snap---monthly-publication-january-2026.pdf   441 2026-01 Other   Unknown Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell NFA No VRM   52.5538064 -2.0139199
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
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      
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
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
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      
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      
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
4349 op-snap---monthly-publication-december-2025.pdf   477 2025-12 Van Audi A3 Black Driving without Due Care and Attention None Regent Road, Tividale Regent Road, Tividale Sandwell Sandwell NFA No Offence   52.5063797 -2.0552807
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
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
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
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
20805 op-snap---monthly-publication-november-2025.pdf   347 2025-11 Pedestrian Volkswagen Crafter Grey Driving without Due Care and Attention None Market Place Market Place Sandwell Sandwell NFA No Independent Evidence Available   52.5303627 -2.0353018
20813 op-snap---monthly-publication-november-2025.pdf   355 2025-11 Other Fiat 500 White Driving without Due Care and Attention None Oldbury Road Oldbury Road Sandwell Sandwell NFA No Independent Evidence Available   52.5018196 -1.9811249
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      
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      
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
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
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      
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      
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      
22756 op-snap---monthly-publication-october-2025.pdf   706 2025-10 Car Vauxhall Zafira Black Driving without Due Care and Attention None Pennyhill Lane Pennyhill Lane Sandwell Sandwell NFA No VRM   52.5379481 -1.9791804
22799 op-snap---monthly-publication-october-2025.pdf   749 2025-10 Lorry Daf lorry White Driving without Due Care and Attention None A4034 Oldbury Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.5039074 -2.0163917
22821 op-snap---monthly-publication-october-2025.pdf   771 2025-10 Car Volvo XC90 Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
22858 op-snap---monthly-publication-october-2025.pdf   808 2025-10 Car BMW 420d Black Driving without Due Care and Attention None M5 slip to M6 M5 slip to M6 Sandwell Sandwell NFA No Independent Evidence Available      
22882 op-snap---monthly-publication-october-2025.pdf   832 2025-10 Car Honda Civic Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA Misc Inc Crimes      
22889 op-snap---monthly-publication-october-2025.pdf   839 2025-10 Car BMW 118i Black Driving without Due Care and Attention None High Street, Smethwick High Street, Smethwick Sandwell Sandwell NFA No Offence   52.4955266 -1.9697742
23029 op-snap---monthly-publication-october-2025.pdf   979 2025-10 Pedal Bike Porsche Macan Grey Driving without Due Care and Attention None Friday Lane Friday Lane Sandwell Sandwell NFA No Offence      
23924 op-snap---monthly-publication-september-2025.pdf   143 2025-09 Other Volkswagen Sharan Silver Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Independent Evidence Available      
24104 op-snap---monthly-publication-september-2025.pdf   323 2025-09 Car Citroen C3.. Grey Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Offence      
24204 op-snap---monthly-publication-september-2025.pdf   423 2025-09 Car Ford Transit White Driving without Due Care and Attention None Haden Hill Road Haden Hill Road Sandwell Sandwell NFA No Offence   52.4678892 -2.0623009
24257 op-snap---monthly-publication-september-2025.pdf   476 2025-09 Car Renault Captur Black Driving without Due Care and Attention None M5 Slip Oldbury M5 Slip Oldbury Sandwell Sandwell NFA No Independent Evidence Available      
24391 op-snap---monthly-publication-september-2025.pdf   610 2025-09 Car Citroen Berlingo White Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA No VRM   52.4877352 -1.9494469
24395 op-snap---monthly-publication-september-2025.pdf   614 2025-09 Car Vauxhall Zafira Grey Driving without Due Care and Attention None Mincing Lane, Oldbury Mincing Lane, Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.4818028 -2.0312761
24413 op-snap---monthly-publication-september-2025.pdf   632 2025-09 Car Land Rover Defender Black Driving without Due Care and Attention None Churchbridge Churchbridge Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.4938109 -2.0217545
24525 op-snap---monthly-publication-september-2025.pdf   744 2025-09 Lorry Scania Coach Yellow Driving without Due Care and Attention None M5 J2-1 M5 J2-1 Sandwell Sandwell NFA No Offence   52.4945433 -2.0190848
24672 op-snap---monthly-publication-september-2025.pdf   891 2025-09 Car Kia Picanto Black Driving without Due Care and Attention None M5 motorway M5 motorway Sandwell Sandwell NFA No Independent Evidence Available   52.5368223 -1.96752
24674 op-snap---monthly-publication-september-2025.pdf   893 2025-09 Car Land Rover Evoque Black Driving without Due Care and Attention None M5 (S) towards Stourbridge M5 (S) towards Stourbridge Sandwell Sandwell NFA Outside of 14 Days NIP      
24746 op-snap---monthly-publication-september-2025.pdf   965 2025-09 Car BMW   Grey Driving without Due Care and Attention None Coopers Lane Coopers Lane Sandwell Sandwell NFA No Independent Evidence Available   52.4921093 -1.9705849
24944 op-snap---monthly-publication-september-2025.pdf   1163 2025-09 Pedal Bike Mercedes-Benz E220 Grey Driving without Due Care and Attention None High Street High Street Sandwell Sandwell NFA No Offence   52.5128738 -1.9842054
25032 op-snap---monthly-publication-september-2025.pdf   1251 2025-09 Car Suzuki vitara Black Driving without Due Care and Attention None cross Street cross Street Sandwell Sandwell NFA Misc Inc Crimes   52.4736128 -2.0420286
2176 op-snap---monthly-publication-august-2025.pdf   151 2025-08 Car Mercedes-Benz A220 White Driving without Due Care and Attention None M5 J2 NB M5 J2 Northbound Sandwell Sandwell NFA Outside of 14 Days NIP   52.4945433 -2.0190848
2282 op-snap---monthly-publication-august-2025.pdf   257 2025-08 Car Cupra Formentor Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell NFA No Offence   52.5461417 -1.9334193
2337 op-snap---monthly-publication-august-2025.pdf   312 2025-08 Car Ford Focus White Driving without Due Care and Attention None Station Road Station Road Sandwell Sandwell NFA No Offence   52.4774652 -2.0337514
2338 op-snap---monthly-publication-august-2025.pdf   313 2025-08 Car Land Rover Vogue Black Driving without Due Care and Attention None Station Road Station Road Sandwell Sandwell NFA No Offence   52.4774652 -2.0337514
2353 op-snap---monthly-publication-august-2025.pdf   328 2025-08 Car BMW   Silver Driving without Due Care and Attention None Brasshouse Lane Smethwick Brasshouse Lane Smethwick Sandwell Sandwell NFA No VRM   52.5006605 -1.9694988
2452 op-snap---monthly-publication-august-2025.pdf   427 2025-08 Car Honda CRV Silver Driving without Due Care and Attention None Oak Road Oak Road Sandwell Sandwell NFA No Independent Evidence Available   52.5164198 -2.0032669
2666 op-snap---monthly-publication-august-2025.pdf   641 2025-08 Car Volkswagen Golf Silver Driving without Due Care and Attention None Black Counrty Route Black Counrty Route Sandwell Sandwell NFA No Independent Evidence Available      
2702 op-snap---monthly-publication-august-2025.pdf   677 2025-08 Car Volkswagen Tiguan Silver Driving without Due Care and Attention None Upper High Street Cradley Heath Upper High Street Cradley Heath Sandwell Sandwell NFA No Independent Evidence Available   52.4739318 -2.0795086
2756 op-snap---monthly-publication-august-2025.pdf   731 2025-08 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Lawrence Lane Lawrence Lane Sandwell Sandwell NFA Misc Inc Crimes   52.4739838 -2.0696749
2803 op-snap---monthly-publication-august-2025.pdf   778 2025-08 Pedestrian Toyota Corolla Silver Driving without Due Care and Attention None High Street Smethwick High Street Smethwick Sandwell Sandwell NFA No Independent Evidence Available   52.4955266 -1.9697742
2836 op-snap---monthly-publication-august-2025.pdf   811 2025-08 Car Mercedes-Benz   Grey Driving without Due Care and Attention None M5 J1 M5 J1 Sandwell Sandwell NFA Outside of 14 Days NIP      
2968 op-snap---monthly-publication-august-2025.pdf   943 2025-08 Car     Blue Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA No Independent Evidence Available      
2979 op-snap---monthly-publication-august-2025.pdf   954 2025-08 Car Audi   Black Driving without Due Care and Attention None Birchfield Lane Birchfield Lane Sandwell Sandwell NFA No VRM   52.4924316 -2.0237076
3020 op-snap---monthly-publication-august-2025.pdf   995 2025-08 Car Seat Leon Grey Driving without Due Care and Attention None Manor Road Manor Road Sandwell Sandwell NFA No Independent Evidence Available   52.4902234 -1.983624
3060 op-snap---monthly-publication-august-2025.pdf   1035 2025-08 Car Volkswagen Golf White Driving without Due Care and Attention None Windmill Lane Windmill Lane Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.4915066 -1.956978
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
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      
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
12622 op-snap---monthly-publication-july-2025.pdf   674 2025-07 Car Seat Ibiza Red Driving without Due Care and Attention None Archer Way Archer Way Sandwell Sandwell NFA No Independent Evidence Available   52.4761026 -2.0372023
12715 op-snap---monthly-publication-july-2025.pdf   767 2025-07 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Thorne Road Thorne Road Sandwell Sandwell NFA No Independent Evidence Available   52.5133025 -2.0221414
12722 op-snap---monthly-publication-july-2025.pdf   774 2025-07 Car Peugeot Expert White Driving without Due Care and Attention None A462 Owen Road Owen Road Sandwell Sandwell NFA Outside of 14 Days NIP      
12734 op-snap---monthly-publication-july-2025.pdf   786 2025-07 Motorbike Ford Transit Blue Driving without Due Care and Attention None M5 Northbound M5 Northbound Sandwell Sandwell NFA Outside of 14 Days NIP      
12777 op-snap---monthly-publication-july-2025.pdf   829 2025-07 Car Ford   Blue Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA No Independent Evidence Available   52.4877352 -1.9494469
12787 op-snap---monthly-publication-july-2025.pdf   839 2025-07 Car Skoda Kodiaq Silver Driving without Due Care and Attention None Cronehills Linkway Cronehills Linkway Sandwell Sandwell NFA No Independent Evidence Available   52.5216057 -1.9934283
12828 op-snap---monthly-publication-july-2025.pdf   880 2025-07 Pedestrian Suzuki Jimmy Blue Driving without Due Care and Attention None Red House Avenue Red House Avenue Sandwell Sandwell NFA No Offence   52.5540383 -2.0075594
12897 op-snap---monthly-publication-july-2025.pdf   949 2025-07 Car Volkswagen Passatt Black Driving without Due Care and Attention None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell NFA No Independent Evidence Available   52.5010052 -2.0306321
12930 op-snap---monthly-publication-july-2025.pdf   982 2025-07 Car Vauxhall Astra Grey Driving without Due Care and Attention None Oldbury Ringway Oldbury Ringway Sandwell Sandwell NFA No Offence   52.5021337 -2.0133861
13035 op-snap---monthly-publication-july-2025.pdf   1087 2025-07 Car Vauxhall   Blue Driving without Due Care and Attention None High Street , Princess End , Tipton High Street , Princess End , Tipton Sandwell Sandwell NFA Outside of 14 Days NIP      
13036 op-snap---monthly-publication-july-2025.pdf   1088 2025-07 Car Kia   Orange Driving without Due Care and Attention None High Street Princess End , Tipton High Street Princess End , Tipton Sandwell Sandwell NFA Outside of 14 Days NIP      
13088 op-snap---monthly-publication-july-2025.pdf   1140 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Toll End Road Tipton Toll End Road Tipton Sandwell Sandwell NFA No Offence   52.5404048 -2.0400078
13156 op-snap---monthly-publication-july-2025.pdf   1208 2025-07 Car Renault Clio Silver Driving without Due Care and Attention None Dudley Road Wednesbury Dudley Road Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5519203 -2.0246866
13158 op-snap---monthly-publication-july-2025.pdf   1210 2025-07 Car Vauxhall Astra White Driving without Due Care and Attention None Parkway Roundabout Wednesbury Parkway Roundabout Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5478186 -2.0297122
13234 op-snap---monthly-publication-july-2025.pdf   1286 2025-07 Car Seat Leon Grey Driving without Due Care and Attention None Birchley Island Birchley Island Sandwell Sandwell NFA No Offence   52.4926604 -2.0216743
13960 op-snap---monthly-publication-july-2025.pdf   2012 2025-07 Car Yamaha   Blue Driving without Due Care and Attention None Farley Park, Whitehall Road Farley Park, Whitehall Road Sandwell Sandwell NFA No VRM   52.5235228 -2.0278023
13964 op-snap---monthly-publication-july-2025.pdf   2016 2025-07 Car Porsche 911 Turbo Silver Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell NFA Not in Public Interest   52.5461417 -1.9334193
14142 op-snap---monthly-publication-june-2025.pdf   71 2025-06 Car Volkswagen Golf Silver Driving without Due Care and Attention None M5 j3 to 2 M5 j3 to 2 Sandwell Sandwell NFA Out of Force   52.4846642 -1.9297585
14259 op-snap---monthly-publication-june-2025.pdf   188 2025-06 Car Volkswagen Passat Grey Driving without Due Care and Attention None conagree road Conagree Road Sandwell Sandwell NFA Outside of 14 DAYS Late Submission      
14271 op-snap---monthly-publication-june-2025.pdf   200 2025-06 Car Ford Fiesta White Driving without Due Care and Attention None Station Road Station Road Sandwell Sandwell NFA No VRM   52.4774652 -2.0337514
14335 op-snap---monthly-publication-june-2025.pdf   264 2025-06 Car Vauxhall Corsa White Driving without Due Care and Attention None Earls Way Halesowen Earls Way Halesowen Sandwell Sandwell NFA Outside of 14 Days NIP      
14391 op-snap---monthly-publication-june-2025.pdf   320 2025-06 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Dartmouth Road Dartmouth Road Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5035988 -1.972107
14672 op-snap---monthly-publication-june-2025.pdf   601 2025-06 Car BMW 120 D Black Driving without Due Care and Attention None Horsely Road (Tipton) Horsely Road (Tipton) Sandwell Sandwell NFA No Offence      
14723 op-snap---monthly-publication-june-2025.pdf   652 2025-06 Other BMW M140i Black Driving without Due Care and Attention None Astbury Avenue Astbury Avenue Sandwell Sandwell NFA No Independent Evidence Available   52.4844701 -1.9740168
15106 op-snap---monthly-publication-june-2025.pdf   1035 2025-06 Car Audi Q2 Silver Driving without Due Care and Attention None WEST BROMWICH ROAD West Bromwich Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5186777 -1.9998654
15138 op-snap---monthly-publication-june-2025.pdf   1067 2025-06 Car Dacia   Brown Driving without Due Care and Attention None Roway Lane Roway Lane Sandwell Sandwell NFA Outside of 14 Days NIP   52.5112108 -2.0241948

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