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

104 rows where council_area = "Sandwell" and month = "2025-04" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 7

month 1

  • 2025-04 · 104 ✖

council_area 1

  • Sandwell · 104 ✖
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
10 op-snap---monthly-publication-april-2025.pdf   9 2025-04 Lorry Volkswagen Golf White Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
15 op-snap---monthly-publication-april-2025.pdf   14 2025-04 Pedestrian Hyundai Iload Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stanley Road Stanley Road Sandwell Sandwell NFA No Offence   52.4660948 -1.9948939
43 op-snap---monthly-publication-april-2025.pdf   42 2025-04 Car Audi A3 Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Warning Letter N/A      
51 op-snap---monthly-publication-april-2025.pdf   50 2025-04 Car Skoda Octavia Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Court N/A   52.5461417 -1.9334193
52 op-snap---monthly-publication-april-2025.pdf   51 2025-04 Car BMW X5 Black Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
53 op-snap---monthly-publication-april-2025.pdf   52 2025-04 Car Ford Puma Blue Driving without Reasonable Consideration None Birmingham Road Birmingham Road Sandwell Sandwell Warning Letter N/A   52.5461417 -1.9334193
55 op-snap---monthly-publication-april-2025.pdf   54 2025-04 Pedal Bike Peugeot 207 Red Driving without Reasonable Consideration None Sandon Road Sandon Road Sandwell Sandwell Education N/A   52.4763582 -1.9676181
109 op-snap---monthly-publication-april-2025.pdf   108 2025-04 Car Rolls-Royce Wraith Black Using a Mobile Phone Whilst Driving None M5 SB J2 M5 Southbound J2 Sandwell Sandwell Fixed Penalty N/A   52.4945433 -2.0190848
164 op-snap---monthly-publication-april-2025.pdf   163 2025-04 Car Toyota Aygo Silver Drive a vehicle other than on the carriageway of a motorway None M5 M5 Sandwell Sandwell Education N/A      
260 op-snap---monthly-publication-april-2025.pdf   259 2025-04 Pedestrian Mercedes-Benz Vito Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Oak Road Oak Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5164198 -2.0032669
270 op-snap---monthly-publication-april-2025.pdf   269 2025-04 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Causeway Green Rd Causeway Green Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4831146 -2.0169818
274 op-snap---monthly-publication-april-2025.pdf   273 2025-04 Car Renault Clio Silver Driving without Due Care and Attention None B65 0RQ provided, M5 motorway N/B approaching Jn1 B65 0RQ provided, M5 motorway Northbound approaching Jn1 Sandwell Sandwell NFA Outside of 14 Days NIP      
296 op-snap---monthly-publication-april-2025.pdf   295 2025-04 Pedal Bike Kia Sportage Silver Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane Crankhall Lane Sandwell Sandwell Fixed Penalty N/A   52.5489715 -1.9927402
297 op-snap---monthly-publication-april-2025.pdf   296 2025-04 Pedal Bike Citroen C4 Black Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane Crankhall Lane Sandwell Sandwell Fixed Penalty N/A   52.5489715 -1.9927402
314 op-snap---monthly-publication-april-2025.pdf   313 2025-04 Car Volkswagen Passat Silver Driving without Due Care and Attention None Highgate Road Highgate Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4683595 -2.0596098
330 op-snap---monthly-publication-april-2025.pdf   329 2025-04 Car Peugeot Rifter Grey Contravening a Red Traffic Light None Wolverhampton Road Oldbury Wolverhampton Road Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5010052 -2.0306321
334 op-snap---monthly-publication-april-2025.pdf   333 2025-04 Pedal Bike BMW X6 White Driving without Reasonable Consideration None South Road, Stourbridge South Road, Stourbridge Sandwell Sandwell NFA Outside of 14 Days NIP      
400 op-snap---monthly-publication-april-2025.pdf   399 2025-04 Car Skoda Octavia Blue Driving without Reasonable Consideration None High Street, Cradley Heath High Street, Cradley Heath Sandwell Sandwell NFA Outside of 14 Days NIP   52.4757272 -2.043439
403 op-snap---monthly-publication-april-2025.pdf   402 2025-04 Car Land Rover Evoque Black VRM fails to conform to Regulations None Highgate Street, Oldhill Highgate Street, Oldhill Sandwell Sandwell Fixed Penalty N/A      
424 op-snap---monthly-publication-april-2025.pdf   423 2025-04 Car Volkswagen Transporter White Using a Mobile Phone Whilst Driving None Oldbury Rd Oldbury Road Sandwell Sandwell NFA No Independent Evidence Available   52.5018196 -1.9811249
435 op-snap---monthly-publication-april-2025.pdf   434 2025-04 Car Seat Leon Black Driving without Due Care and Attention None M5 M5 Sandwell Sandwell NFA Outside of 14 Days NIP      
471 op-snap---monthly-publication-april-2025.pdf   470 2025-04 Pedal Bike Iveco Truck White Using a Mobile Phone Whilst Driving None Tipton Road, Oldbury Tipton Road, Oldbury Sandwell Sandwell Fixed Penalty N/A   52.5324526 -2.0453612
473 op-snap---monthly-publication-april-2025.pdf   472 2025-04 Pedal Bike Volvo Bus White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Friar Park Road, Wednesbury Friar Park Road, Wednesbury Sandwell Sandwell Warning Letter N/A   52.5538676 -1.9965667
486 op-snap---monthly-publication-april-2025.pdf   485 2025-04 Car Ford Fiesta Silver Driving without Due Care and Attention None Black Lake Black Lake Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5341947 -2.0098521
494 op-snap---monthly-publication-april-2025.pdf   493 2025-04 Car Mini Cooper Red Driving without Due Care and Attention None All Saints WAY All Saints WAY Sandwell Sandwell Fixed Penalty N/A   52.5344405 -1.985568
550 op-snap---monthly-publication-april-2025.pdf   549 2025-04 Car Ford Ka Silver Driving without Due Care and Attention None M5 motorway, N/B near Jn2 M5 motorway, Northbound near Jn2 Sandwell Sandwell NFA Outside of 14 Days NIP      
557 op-snap---monthly-publication-april-2025.pdf   556 2025-04 Pedestrian Ford Transit White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Turners Lane, Brierley Hill Turners Lane, Brierley Hill Sandwell Sandwell Fixed Penalty N/A      
558 op-snap---monthly-publication-april-2025.pdf   557 2025-04 Car Vauxhall astra Black Driving without Due Care and Attention None Station Road Station Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4774652 -2.0337514
561 op-snap---monthly-publication-april-2025.pdf   560 2025-04 Car Toyota MPV Silver Contravening a Red Traffic Light None Black Lake Black Lake Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.5341947 -2.0098521
563 op-snap---monthly-publication-april-2025.pdf   562 2025-04 Pedal Bike Volkswagen Polo Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Friar Park Road Friar Park Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5538676 -1.9965667
565 op-snap---monthly-publication-april-2025.pdf   564 2025-04 Pedal Bike Audi A1 Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Friar Park Road Friar Park Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5538676 -1.9965667
566 op-snap---monthly-publication-april-2025.pdf   565 2025-04 Pedal Bike BMW M5   Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Friar Park Rd Friar Park Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5538676 -1.9965667
631 op-snap---monthly-publication-april-2025.pdf   630 2025-04 Pedestrian Mercedes-Benz Sprinter White Cause vehicle to be left in a dangerous position None Bertram Road Bertram Road Sandwell Sandwell Fixed Penalty N/A   52.4984114 -1.981609
632 op-snap---monthly-publication-april-2025.pdf   631 2025-04 Pedestrian Vauxhall Astra Silver Cause vehicle to be left in a dangerous position None St Albans Road Street Albans Road Sandwell Sandwell Fixed Penalty N/A      
684 op-snap---monthly-publication-april-2025.pdf   683 2025-04 Car Mercedes-Benz A class White Using a Mobile Phone Whilst Driving None Horseley Heath Horseley Heath Sandwell Sandwell NFA No Independent Evidence Available   52.5292478 -2.0422614
712 op-snap---monthly-publication-april-2025.pdf   711 2025-04 Car Nissan Qashqai Black Driving without Reasonable Consideration None Black Country Route Black Country Route Sandwell Sandwell Warning Letter N/A      
716 op-snap---monthly-publication-april-2025.pdf   715 2025-04 Car Vauxhall Vivaro White Contravening a Red Traffic Light None High Bullen High Bullen Sandwell Sandwell Fixed Penalty N/A   52.5532368 -2.0227385
778 op-snap---monthly-publication-april-2025.pdf   777 2025-04 Car Audi Q4.. Black Driving without Due Care and Attention None Birchley Island Oldbury Birchley Island Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.4926604 -2.0216743
795 op-snap---monthly-publication-april-2025.pdf   794 2025-04 Car BMW M135 Grey Driving without Reasonable Consideration None Black Country Route Black Country Route Sandwell Sandwell NFA Outside of 14 Days NIP      
846 op-snap---monthly-publication-april-2025.pdf   845 2025-04 Car     White Driver not in position to have Proper Control None Gorsty close , West Bromwich Gorsty close , West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5421428 -1.9749983
867 op-snap---monthly-publication-april-2025.pdf   866 2025-04 Pedestrian Volvo   Gold Drive / Ride / Lead an animal on a footpath None Bradleys Lane , Tipton Bradleys Lane , Tipton Sandwell Sandwell NFA Outside of 14 Days NIP      
956 op-snap---monthly-publication-april-2025.pdf   955 2025-04 Car Audi   Black Driving without Reasonable Consideration None High Street , Dudley High Street , Dudley Sandwell Sandwell NFA Outside of 14 Days NIP   52.5278614 -2.0712031
980 op-snap---monthly-publication-april-2025.pdf   979 2025-04 Car Mercedes-Benz Viano Grey Driving without Reasonable Consideration None A461 & A457 heading towards Dudley Port A461 & A457 heading towards Dudley Port Sandwell Sandwell NFA Outside of 14 Days NIP   52.5193521 -2.0559955
987 op-snap---monthly-publication-april-2025.pdf   986 2025-04 Car Toyota Estima White Contravening a Red Traffic Light None Coopers Lane , Smethwick Coopers Lane , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4915505 -1.9742227
991 op-snap---monthly-publication-april-2025.pdf   990 2025-04 Car Ford   Blue Driving without Reasonable Consideration None Lower City Road , Tividale Lower City Road , Tividale Sandwell Sandwell NFA Outside of 14 Days NIP   52.50942 -2.0371695
992 op-snap---monthly-publication-april-2025.pdf   991 2025-04 Car Volkswagen Estate Blue Driving without Reasonable Consideration None Booth Street , Smethwick Booth Street , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.5007123 -1.9518885
1042 op-snap---monthly-publication-april-2025.pdf   1041 2025-04 Pedestrian Volkswagen Caddy White Cause vehicle to be left in a dangerous position None Lavender Farm Nursery , bookfields Road , Oldbury Lavender Farm Nursery , bookfields Road , Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP      
1079 op-snap---monthly-publication-april-2025.pdf   1078 2025-04 Car Vauxhall   Silver Driving without Reasonable Consideration None Norwood Road Norwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4655265 -2.0494856
1080 op-snap---monthly-publication-april-2025.pdf   1079 2025-04 Car Volkswagen   Blue Driving without Reasonable Consideration None Norwood Road Norwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4655265 -2.0494856
1081 op-snap---monthly-publication-april-2025.pdf   1080 2025-04 Car Ford   Silver Driving without Reasonable Consideration None Norwood Road Norwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4655265 -2.0494856
1082 op-snap---monthly-publication-april-2025.pdf   1081 2025-04 Car Ford   Silver Driving without Reasonable Consideration None Norwood Road Norwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4655265 -2.0494856
1084 op-snap---monthly-publication-april-2025.pdf   1083 2025-04 Car Ford   White Driving without Reasonable Consideration None Norwood Road Norwood Road Sandwell Sandwell NFA Outside of 14 Days NIP   52.4655265 -2.0494856
1123 op-snap---monthly-publication-april-2025.pdf   1122 2025-04 Car Mg ZS Blue Using a Mobile Phone Whilst Driving None Portway Road , Rowley Regis Portway Road , Rowley Regis Sandwell Sandwell Fixed Penalty N/A      
1124 op-snap---monthly-publication-april-2025.pdf   1123 2025-04 Car Volvo XC60 Silver Cause vehicle to be left in a dangerous position None Clent Road , Oldbury Clent Road , Oldbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.4796168 -1.9761642
1138 op-snap---monthly-publication-april-2025.pdf   1137 2025-04 Car Vauxhall Corsa Grey Driving without Reasonable Consideration None Express way , West bromwich Express way , West bromwich Sandwell Sandwell NFA Outside of 14 Days NIP      
1172 op-snap---monthly-publication-april-2025.pdf   1171 2025-04 Pedal Bike   Bus Red Driving without Reasonable Consideration None JUnction Lordswood Road / Bearwood Road JUnction Lordswood Road / Bearwood Road Sandwell Sandwell NFA Outside of 14 Days NIP      
1174 op-snap---monthly-publication-april-2025.pdf   1173 2025-04 Pedestrian   NP Black Or Blue Cause vehicle to be left in a dangerous position None Lowry Close , Smethwick Lowry Close , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4951121 -1.9733297
1194 op-snap---monthly-publication-april-2025.pdf   1193 2025-04 Car Volkswagen Golf Black Using a Mobile Phone Whilst Driving None Holly Lane , Smethwick Holly Lane , Smethwick Sandwell Sandwell Fixed Penalty N/A   52.4968702 -1.98537
1212 op-snap---monthly-publication-april-2025.pdf   1211 2025-04 Car   NP Blue Cause vehicle to be left in a dangerous position None     Sandwell Sandwell NFA Outside of 14 Days NIP      
1226 op-snap---monthly-publication-april-2025.pdf   1225 2025-04 Car Ford KUGA Black Driving without Reasonable Consideration None M5 South , West Bromwich M5 South , West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5199167 -1.9934333
1237 op-snap---monthly-publication-april-2025.pdf   1236 2025-04 Car Volkswagen   Blue Driving without Reasonable Consideration None M5 Towards Junction 4 M5 Towards Junction 4 Sandwell Sandwell NFA Outside of 14 Days NIP      
1265 op-snap---monthly-publication-april-2025.pdf   1264 2025-04 Car Mercedes-Benz A Class White Driving without Reasonable Consideration None Perry Park Road , Rowley Regis Perry Park Road , Rowley Regis Sandwell Sandwell NFA Outside of 14 Days NIP   52.4717873 -2.0494663
1267 op-snap---monthly-publication-april-2025.pdf   1266 2025-04 Car Mercedes-Benz   Black Driving without Reasonable Consideration None M6 Southbound , Junction 10 M6 Southbound , Junction 10 Sandwell Sandwell NFA Outside of 14 Days NIP   52.676119 -2.0858425
1319 op-snap---monthly-publication-april-2025.pdf   1318 2025-04 Pedal Bike BMW 420 White Driving without Due Care and Attention None 73 Woden road east 73 Woden road east Sandwell Sandwell NFA Outside of 14 Days NIP   52.5607273 -2.0035558
1342 op-snap---monthly-publication-april-2025.pdf   1341 2025-04 Car Yamaha   Blue Driving without Reasonable Consideration None Horseley heath , Tipton Horseley heath , Tipton Sandwell Sandwell NFA Outside of 14 Days NIP   52.5292478 -2.0422614
1345 op-snap---monthly-publication-april-2025.pdf   1344 2025-04 Car Ford   Purple Cause vehicle to be left in a dangerous position None Rotton Park Road , Smethwick Rotton Park Road , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP      
1347 op-snap---monthly-publication-april-2025.pdf   1346 2025-04 Pedestrian Mercedes-Benz   Silver Cause vehicle to be left in a dangerous position None Rotten Park Road , Smethwick Rotten Park Road , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP      
1368 op-snap---monthly-publication-april-2025.pdf   1367 2025-04 Car Vauxhall   Black Contravening a Red Traffic Light None Portway Hill , Rowley regis Portway Hill , Rowley regis Sandwell Sandwell NFA Outside of 14 Days NIP   52.4943321 -2.0412126
1387 op-snap---monthly-publication-april-2025.pdf   1386 2025-04 Car Audi A1 Blue Dangerous Driving None M5 Southbound M5 Southbound Sandwell Sandwell NFA Outside of 14 Days NIP      
1390 op-snap---monthly-publication-april-2025.pdf   1389 2025-04 Car Mini Cooper Grey Driving without Due Care and Attention None Washwood heath road Washwood heath road Sandwell Sandwell NFA Outside of 14 Days NIP      
1391 op-snap---monthly-publication-april-2025.pdf   1390 2025-04 Car Honda NP Silver Stop a vehicle on pedestrian crossing None Washwood heath road Washwood heath road Sandwell Sandwell NFA Outside of 14 Days NIP      
1392 op-snap---monthly-publication-april-2025.pdf   1391 2025-04 Car Mercedes-Benz NP Black Stop a vehicle on pedestrian crossing None Washwood Heath road Washwood Heath road Sandwell Sandwell NFA Outside of 14 Days NIP      
1400 op-snap---monthly-publication-april-2025.pdf   1399 2025-04 Car Seat Ibiza Grey Using a Mobile Phone Whilst Driving None Crocketts Lane , Smethwick Crocketts Lane , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.493515 -1.966302
1408 op-snap---monthly-publication-april-2025.pdf   1407 2025-04 Car Ford Transit White Driving without Reasonable Consideration None Woodgate Lane , West Bromwich Woodgate Lane , West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP      
1441 op-snap---monthly-publication-april-2025.pdf   1440 2025-04 Car Honda NP Red Contravening a Red Traffic Light None High street smethwick High street smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4955266 -1.9697742
1442 op-snap---monthly-publication-april-2025.pdf   1441 2025-04 Motorbike Mercedes-Benz NP Black Contravening a Red Traffic Light None Oldbury road Oldbury road Sandwell Sandwell NFA Outside of 14 Days NIP   52.5018196 -1.9811249
1484 op-snap---monthly-publication-april-2025.pdf   1483 2025-04 Car Audi Q7 Black Contravening a Red Traffic Light None Holly Lane , Smethwick Holly Lane , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4968702 -1.98537
1487 op-snap---monthly-publication-april-2025.pdf   1486 2025-04 Car Suzuki Swift Red Driving without Reasonable Consideration None Telford Way , Smethwick Telford Way , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.5041001 -1.9769903
1489 op-snap---monthly-publication-april-2025.pdf   1488 2025-04 Pedal Bike Citroen C3 Black Driving without Reasonable Consideration None Crankhall Lane , Wednesbury Crankhall Lane , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5562019 -2.0028056
1490 op-snap---monthly-publication-april-2025.pdf   1489 2025-04 Pedal Bike Fiat Panda Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Pound Road , Wednesbury Pound Road , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5541213 -2.0098297
1493 op-snap---monthly-publication-april-2025.pdf   1492 2025-04 Car BMW NP White Driving without Reasonable Consideration None A457 Rolfe street junction , Smethwick Rolfe street junction , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP      
1524 op-snap---monthly-publication-april-2025.pdf   1523 2025-04 Van Volkswagen NP Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Adams Stret , West bromwich Adams Stret , West bromwich Sandwell Sandwell NFA Outside of 14 Days NIP      
1527 op-snap---monthly-publication-april-2025.pdf   1526 2025-04 Pedal Bike Ford Focus Black Stop a vehicle within pelican pedestrian crossing limits None Crankhall Lane , Wednesbury Crankhall Lane , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5562019 -2.0028056
1589 op-snap---monthly-publication-april-2025.pdf   1588 2025-04 Car Volkswagen Golf Grey Driving without Due Care and Attention None Greenside Way. westbromwhich Greenside Way. westbromwhich Sandwell Sandwell NFA Outside of 14 Days NIP      
1590 op-snap---monthly-publication-april-2025.pdf   1589 2025-04 Pedestrian   NP White Stop a vehicle on pedestrian crossing None Bertam road Bertam road Sandwell Sandwell NFA Outside of 14 Days NIP      
1636 op-snap---monthly-publication-april-2025.pdf   1635 2025-04 Car BMW NP Blue Driving without Reasonable Consideration None Black country new road ( A41 ) Black country new road ( A41 ) Sandwell Sandwell NFA Outside of 14 Days NIP   52.5501534 -2.0296946
1718 op-snap---monthly-publication-april-2025.pdf   1717 2025-04 Car Skoda KAMIQ White Driving without Due Care and Attention None M6 JCT 7 (southbound) off ramp M6 JCT 7 (southbound) off ramp Sandwell Sandwell NFA Outside of 14 Days NIP   52.676119 -2.0858425
1726 op-snap---monthly-publication-april-2025.pdf   1725 2025-04 Other   NP Black Using a Mobile Phone Whilst Driving None M6 Junction 10 M6 Junction 10 Sandwell Sandwell NFA No Independent Evidence Available   52.6760749 -2.0862582
1727 op-snap---monthly-publication-april-2025.pdf   1726 2025-04 Car Mini Countryman Grey Contravening a Red Traffic Light None Downing Street , Smethwick Downing Street , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.5002799 -1.9606742
1734 op-snap---monthly-publication-april-2025.pdf   1733 2025-04 Car Mg NP Black Driving without Reasonable Consideration None Stanhope Road , Smethwick Stanhope Road , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4856586 -1.9704663
1743 op-snap---monthly-publication-april-2025.pdf   1742 2025-04 Car Ford Mondeo Blue Driving without Reasonable Consideration None M5 North between J1 and M6 slip road M5 North between J1 and M6 slip road Sandwell Sandwell NFA Outside of 14 Days NIP      
1756 op-snap---monthly-publication-april-2025.pdf   1755 2025-04 Car Volkswagen Polo Silver Driving without Reasonable Consideration None A4123 A4123 Sandwell Sandwell NFA Outside of 14 Days NIP      
1769 op-snap---monthly-publication-april-2025.pdf   1768 2025-04 Car Kia Sportage Brown Stop a vehicle within pelican pedestrian crossing limits None CRankhall Lane , Wednesbury CRankhall Lane , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5562019 -2.0028056
1784 op-snap---monthly-publication-april-2025.pdf   1783 2025-04 Car   NP White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High STreet , Smethwick High STreet , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP   52.4932939 -1.9686077
1798 op-snap---monthly-publication-april-2025.pdf   1797 2025-04 Car Ford NP Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road , Smethwick Rotten Park Road , Smethwick Sandwell Sandwell NFA Outside of 14 Days NIP      
1807 op-snap---monthly-publication-april-2025.pdf   1806 2025-04 Car   NP White Using a Mobile Phone Whilst Driving None Kenrick Way, west bromwich Kenrick Way, west bromwich Sandwell Sandwell Fixed Penalty N/A   52.5071009 -1.9841087
1808 op-snap---monthly-publication-april-2025.pdf   1807 2025-04 Car   NP Black Driving without Due Care and Attention None Castle street Castle street Sandwell Sandwell NFA Outside of 14 Days NIP   52.5393903 -2.0143004
1811 op-snap---monthly-publication-april-2025.pdf   1810 2025-04 Pedestrian Peugeot NP Black Contravening a Red Traffic Light None All saints way All saints way Sandwell Sandwell NFA Outside of 14 Days NIP   52.5344405 -1.985568
1869 op-snap---monthly-publication-april-2025.pdf   1868 2025-04 Car Mercedes-Benz Benz Black Driving without Due Care and Attention None Between Brandhall road and parsons hill Between Brandhall road and parsons hill Sandwell Sandwell NFA Outside of 14 Days NIP      
1873 op-snap---monthly-publication-april-2025.pdf   1872 2025-04 Car   Lorry Green Driving without Due Care and Attention None M5 between jct 1 and jct 3 M5 between jct 1 and jct 3 Sandwell Sandwell NFA Outside of 14 Days NIP      

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