reports
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'}
121 rows where council_area = "Sandwell" and month = "2025-07" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 26
offence 15
- Driving without Due Care and Attention 50
- Cause vehicle to be left in a dangerous position 19
- Contravening a Red Traffic Light 17
- Driving without Reasonable Consideration 9
- Using a Mobile Phone Whilst Driving 7
- Dangerous Driving 3
- Misc - Non Traffic Offences 3
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 3
- Drive on hard shoulder 2
- Driving a vehicle wholly or partly on a footpath 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Drive / Ride / Lead an animal on a footpath 1
- Keeping a vehicle with registration marks obscured 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
reporter_transport_mode 8
- Car 83
- Pedestrian 20
- Pedal Bike 8
- Other 6
- Bus 1
- Motorbike 1
- Van 1
- car 1
disposal 6
- NFA 47
- Warning Letter 36
- Education 23
- Fixed Penalty 8
- Court 6
- RTC - Actioned 1
month 1
- 2025-07 · 121 ✖
council_area 1
- Sandwell · 121 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11951 | op-snap---monthly-publication-july-2025.pdf | 3 | 2025-07 | Car | BMW | M340 | Blue | Driving without Due Care and Attention | None | Downing Street | Downing Street | Sandwell | Sandwell | Court | N/A | 52.5015329 | -1.9556094 | ||
| 11953 | op-snap---monthly-publication-july-2025.pdf | 5 | 2025-07 | Car | Ford | Fiesta | Orange | Driving without Reasonable Consideration | None | Oldbury Ring Way | Oldbury Ring Way | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 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 | ||
| 11985 | op-snap---monthly-publication-july-2025.pdf | 37 | 2025-07 | Pedal Bike | Honda | Insight | Silver | Driving without Reasonable Consideration | None | Parsonage Street, West Bromwich | Parsonage Street, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5306821 | -1.9875151 | ||
| 12006 | op-snap---monthly-publication-july-2025.pdf | 58 | 2025-07 | Pedal Bike | Peugeot | 308 | Grey | Contravening a Red Traffic Light | None | Beauty Bank | Beauty Bank | Sandwell | Sandwell | NFA | No Offence | 52.4707042 | -2.0596027 | ||
| 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 | ||||
| 12041 | op-snap---monthly-publication-july-2025.pdf | 93 | 2025-07 | Car | Toyota | Yaris | Silver | Contravening a Red Traffic Light | None | A4123 Tividale | Tividale | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5077595 | -2.044305 | ||
| 12043 | op-snap---monthly-publication-july-2025.pdf | 95 | 2025-07 | Car | Skoda | Fabia | White | Contravening a Red Traffic Light | None | Wolverhampton Road | Wolverhampton Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4702299 | -1.9948976 | ||
| 12071 | op-snap---monthly-publication-july-2025.pdf | 123 | 2025-07 | Car | Vauxhall | Zafira | Silver | Misc - Non Traffic Offences | None | M5 | M5 | Sandwell | Sandwell | RTC - Actioned | N/A | ||||
| 12084 | op-snap---monthly-publication-july-2025.pdf | 136 | 2025-07 | Car | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | High Street | High Street | Sandwell | Sandwell | Education | N/A | 52.5128738 | -1.9842054 | ||
| 12087 | op-snap---monthly-publication-july-2025.pdf | 139 | 2025-07 | Pedal Bike | BMW | 116.. | White | Driving without Due Care and Attention | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Education | N/A | 52.4725977 | -1.9684448 | ||
| 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 | ||
| 12172 | op-snap---monthly-publication-july-2025.pdf | 224 | 2025-07 | Car | Citroen | Berlingo | White | Driving without Due Care and Attention | None | Fordge Lane Cradley Heath | Fordge Lane Cradley Heath | Sandwell | Sandwell | Education | N/A | ||||
| 12181 | op-snap---monthly-publication-july-2025.pdf | 233 | 2025-07 | Car | Ford | Puma | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Broadwell Road | Broadwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5043614 | -2.0104333 | ||
| 12182 | op-snap---monthly-publication-july-2025.pdf | 234 | 2025-07 | Car | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Braodwell Road | Braodwell Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | ||||
| 12279 | op-snap---monthly-publication-july-2025.pdf | 331 | 2025-07 | Car | Peugeot | 2008.... | Red | Driving without Due Care and Attention | None | M6 South Jct 7 | M6 South Junction 7 | Sandwell | Sandwell | Education | N/A | ||||
| 12282 | op-snap---monthly-publication-july-2025.pdf | 334 | 2025-07 | Car | Volkswagen | Caddy | Grey | Driving without Due Care and Attention | None | Ross | Ross | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4782131 | -2.0464064 | ||
| 12283 | op-snap---monthly-publication-july-2025.pdf | 335 | 2025-07 | Car | Volkswagen | Crafter | White | Contravening a Red Traffic Light | None | Portway Road | Portway Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5527219 | -2.0296243 | ||
| 12305 | op-snap---monthly-publication-july-2025.pdf | 357 | 2025-07 | Car | Toyota | Rav 4. | Blue | Contravening a Red Traffic Light | None | Dudley Road Rowley Regis | Dudley Road Rowley Regis | Sandwell | Sandwell | Education | N/A | 52.4952912 | -2.0641749 | ||
| 12310 | op-snap---monthly-publication-july-2025.pdf | 362 | 2025-07 | Car | Toyota | Corolla | Blue | Driving without Due Care and Attention | None | M5 Junction 1 Island | M5 Junction 1 Island | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 12357 | op-snap---monthly-publication-july-2025.pdf | 409 | 2025-07 | Bus | Mercedes-Benz | C220.. | Silver | Driving without Due Care and Attention | None | Newton Road | Newton Road | Sandwell | Sandwell | Education | N/A | 52.5428224 | -1.9569444 | ||
| 12358 | op-snap---monthly-publication-july-2025.pdf | 410 | 2025-07 | Car | Peugeot | 3008 | Black | Contravening a Red Traffic Light | None | Wolverhampton Road, Oldbury | Wolverhampton Road, Oldbury | Sandwell | Sandwell | Education | N/A | 52.5028787 | -2.0328384 | ||
| 12395 | op-snap---monthly-publication-july-2025.pdf | 447 | 2025-07 | Car | Seat | Arona | Blue | Driving without Reasonable Consideration | None | M5 Junction 1 | M5 Junction 1 | Sandwell | Sandwell | Education | N/A | ||||
| 12399 | op-snap---monthly-publication-july-2025.pdf | 451 | 2025-07 | Car | Kia | EV3 | Black | Using a Mobile Phone Whilst Driving | None | M6 NB J8 | M6 Northbound J8 | Sandwell | Sandwell | Fixed Penalty | N/A | 52.6760749 | -2.0862582 | ||
| 12424 | op-snap---monthly-publication-july-2025.pdf | 476 | 2025-07 | Car | Audi | SQ5 | Black | Driving without Due Care and Attention | None | Vicarage Road | Vicarage Road | Sandwell | Sandwell | Education | N/A | 52.5573855 | -2.0133095 | ||
| 12443 | op-snap---monthly-publication-july-2025.pdf | 495 | 2025-07 | Car | Fiat | 500 L | Black | Driving without Due Care and Attention | None | Garratts Lane | Garratts Lane | Sandwell | Sandwell | Education | N/A | 52.4783554 | -2.0611589 | ||
| 12496 | op-snap---monthly-publication-july-2025.pdf | 548 | 2025-07 | Other | BMW | M3 | Blue | Driving without Due Care and Attention | None | Main Car Park, Waterfront | Main Car Park, Waterfront | Sandwell | Sandwell | Education | N/A | ||||
| 12498 | op-snap---monthly-publication-july-2025.pdf | 550 | 2025-07 | Other | Hyundai | i20 | Grey | Driving without Due Care and Attention | No Insurance | Main Car Park, Waterfront | Main Car Park, Waterfront | Sandwell | Sandwell | Court | N/A | ||||
| 12520 | op-snap---monthly-publication-july-2025.pdf | 572 | 2025-07 | Car | Vauxhall | White | Driving without Due Care and Attention | None | Newbury Lane | Newbury Lane | Sandwell | Sandwell | Education | N/A | 52.4994655 | -2.0285102 | |||
| 12521 | op-snap---monthly-publication-july-2025.pdf | 573 | 2025-07 | Other | Volkswagen | Caddy | Silver | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Sandwell | Sandwell | Education | N/A | 52.4655265 | -2.0494856 | ||
| 12525 | op-snap---monthly-publication-july-2025.pdf | 577 | 2025-07 | Pedal Bike | Mg | 3 | Silver | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Sandwell | Sandwell | Education | N/A | 52.4634145 | -1.9969046 | ||
| 12542 | op-snap---monthly-publication-july-2025.pdf | 594 | 2025-07 | Pedal Bike | Vauxhall | Insignia | Grey | Driving without Due Care and Attention | None | Enville Road, Kingswinford | Enville Road, Kingswinford | Sandwell | Sandwell | Education | N/A | ||||
| 12555 | op-snap---monthly-publication-july-2025.pdf | 607 | 2025-07 | Car | Peugeot | Grey | Driving without Due Care and Attention | None | Churchbridge | Churchbridge | Sandwell | Sandwell | Education | N/A | 52.4938109 | -2.0217545 | |||
| 12557 | op-snap---monthly-publication-july-2025.pdf | 609 | 2025-07 | Car | Ford | Focus | Silver | Drive on hard shoulder | Use vehicle on a road without | Mva5li dN oterstht bcoeurtnifdic aaftteer Jn1 | Mva5li d N oterstht bcoeurtnifdic aaftteer Jn1 | Sandwell | Sandwell | Court | N/A | ||||
| 12570 | op-snap---monthly-publication-july-2025.pdf | 622 | 2025-07 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Rabone Lane | Rabone Lane | Sandwell | Sandwell | Education | N/A | 52.496577 | -1.9614637 | ||
| 12586 | op-snap---monthly-publication-july-2025.pdf | 638 | 2025-07 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5439824 | -1.9306805 | ||
| 12600 | op-snap---monthly-publication-july-2025.pdf | 652 | 2025-07 | Pedestrian | Vauxhall | Corsa | White | Driving without Due Care and Attention | None | M5 Motorway J1 | M5 Motorway J1 | Sandwell | Sandwell | Education | N/A | ||||
| 12601 | op-snap---monthly-publication-july-2025.pdf | 653 | 2025-07 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | A41 Great Barr | Great Barr | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5506235 | -1.9358809 | ||
| 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 | ||
| 12647 | op-snap---monthly-publication-july-2025.pdf | 699 | 2025-07 | Car | Mercedes-Benz | 220.. | Silver | Using a Mobile Phone Whilst Driving | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4722765 | -1.9787531 | ||
| 12713 | op-snap---monthly-publication-july-2025.pdf | 765 | 2025-07 | Car | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | Driving without Due Care and | AWttoeondtisoentton | AWttoeondtisoentton | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 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 | ||||
| 12726 | op-snap---monthly-publication-july-2025.pdf | 778 | 2025-07 | Car | Nissan | Juke | Red | Using a Mobile Phone Whilst Driving | None | All Saints Way | All Saints Way | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5344405 | -1.985568 | ||
| 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 | ||||
| 12739 | op-snap---monthly-publication-july-2025.pdf | 791 | 2025-07 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Oldbury Road | Oldbury Road | Sandwell | Sandwell | Court | N/A | 52.5018196 | -1.9811249 | ||
| 12745 | op-snap---monthly-publication-july-2025.pdf | 797 | 2025-07 | Car | Volkswagen | Golf GTI | Blue | Driving without Due Care and Attention | None | Kenrick Way | Kenrick Way | Sandwell | Sandwell | Warning Letter | N/A | 52.5079468 | -1.9755194 | ||
| 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 | ||
| 12801 | op-snap---monthly-publication-july-2025.pdf | 853 | 2025-07 | Car | Nissan | Juke | Black | Using a Mobile Phone Whilst Driving | None | New Swan Lane | New Swan Lane | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5293372 | -2.0107584 | ||
| 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 | ||
| 12832 | op-snap---monthly-publication-july-2025.pdf | 884 | 2025-07 | Car | Hyundai | ioniq | White | Driving without Reasonable Consideration | None | M5 West Brom | M5 West Brom | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12847 | op-snap---monthly-publication-july-2025.pdf | 899 | 2025-07 | car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | All Saits Way | All Saits Way | Sandwell | Sandwell | Education | N/A | ||||
| 12880 | op-snap---monthly-publication-july-2025.pdf | 932 | 2025-07 | Car | Volvo | Bus | Red | Driving without Due Care and Attention | None | Dudley Road, Tipton | Dudley Road, Tipton | Sandwell | Sandwell | Warning Letter | N/A | 52.5238596 | -2.0740455 | ||
| 12895 | op-snap---monthly-publication-july-2025.pdf | 947 | 2025-07 | Car | Renault | clio | Red | Driving without Reasonable Consideration | None | Walsall Road , West Bromwich | Walsall Road , West Bromwich | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5366137 | -1.9867997 | ||
| 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 | ||
| 12921 | op-snap---monthly-publication-july-2025.pdf | 973 | 2025-07 | Van | Audi | TT | Silver | Using a Mobile Phone Whilst Driving | None | M5 North Towards Junction 6 | M5 North Towards Junction 6 | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 12928 | op-snap---monthly-publication-july-2025.pdf | 980 | 2025-07 | Car | Black | Using a Mobile Phone Whilst Driving | None | Halesowen Road | Halesowen Road | Sandwell | Sandwell | NFA | No VRM | 52.4727241 | -2.0645309 | ||||
| 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 | ||
| 12934 | op-snap---monthly-publication-july-2025.pdf | 986 | 2025-07 | Car | N/K | Green | Misc - Non Traffic Offences | None | Oldbury Ringway | Oldbury Ringway | Sandwell | Sandwell | NFA | No VRM | 52.5021337 | -2.0133861 | |||
| 12971 | op-snap---monthly-publication-july-2025.pdf | 1023 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 12988 | op-snap---monthly-publication-july-2025.pdf | 1040 | 2025-07 | Pedestrian | Vauxhall | Van | White | Dangerous Driving | None | High Street , Princess End | High Street , Princess End | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 12989 | op-snap---monthly-publication-july-2025.pdf | 1041 | 2025-07 | Car | Toyota | Corolla | Silver | Driving without Reasonable Consideration | None | Walsall Road , Stone Cross | Walsall Road , Stone Cross | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.54591 | -1.9841049 | ||
| 12990 | op-snap---monthly-publication-july-2025.pdf | 1042 | 2025-07 | Car | Van | White | Dangerous Driving | None | High Street , Princess End , Tipton | High Street , Princess End , Tipton | Sandwell | Sandwell | Warning Letter | N/A | |||||
| 12991 | op-snap---monthly-publication-july-2025.pdf | 1043 | 2025-07 | Car | Land Rover | Grey | Driving without Reasonable Consideration | None | Spring Lane South | Spring Lane South | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13008 | op-snap---monthly-publication-july-2025.pdf | 1060 | 2025-07 | Car | Mercedes-Benz | White | Keeping a vehicle with registration marks obscured | None | M5 North Junction 3 - 2 | M5 North Junction 3 - 2 | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | |||||
| 13009 | op-snap---monthly-publication-july-2025.pdf | 1061 | 2025-07 | Car | Vauxhall | Vivaro | White | Driving without Reasonable Consideration | None | Cakemore Road , Rowley regis | Cakemore Road , Rowley regis | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 13015 | op-snap---monthly-publication-july-2025.pdf | 1067 | 2025-07 | Pedal Bike | Ford | Independance | Blue | Driving without Reasonable Consideration | None | Friar Park Road , Wednesbury | Friar Park Road , Wednesbury | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5538676 | -1.9965667 | ||
| 13022 | op-snap---monthly-publication-july-2025.pdf | 1074 | 2025-07 | Car | Mercedes-Benz | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | McKean Road Oldbury | Mc Kean Road Oldbury | Sandwell | Sandwell | NFA | No Independent Evidence Available | |||||
| 13024 | op-snap---monthly-publication-july-2025.pdf | 1076 | 2025-07 | Pedal Bike | Toyota | Auris | Silver | Driving without Due Care and Attention | None | Darlsaton Road (Wednesbury) | Darlsaton Road (Wednesbury) | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13026 | op-snap---monthly-publication-july-2025.pdf | 1078 | 2025-07 | Car | Hyundai | i10 | White | Driving without Due Care and Attention | None | Sandwell | Sandwell | Education | N/A | ||||||
| 13031 | op-snap---monthly-publication-july-2025.pdf | 1083 | 2025-07 | Car | Honda | Accord | Black | Contravening a Red Traffic Light | None | Halesowen Road , Old Hill | Halesowen Road , Old Hill | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4712653 | -2.0623799 | ||
| 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 | ||
| 13089 | op-snap---monthly-publication-july-2025.pdf | 1141 | 2025-07 | Car | Vauxhall | Insignia | Grey | Driving without Due Care and Attention | No Insurance | Throne Road | Throne Road | Sandwell | Sandwell | Court | N/A | 52.4875572 | -2.0284052 | ||
| 13104 | op-snap---monthly-publication-july-2025.pdf | 1156 | 2025-07 | Car | Renault | Clio | Grey | Contravening a Red Traffic Light | None | Owen Street Tipton | Owen Street Tipton | Sandwell | Sandwell | Education | N/A | 52.529375 | -2.0627257 | ||
| 13116 | op-snap---monthly-publication-july-2025.pdf | 1168 | 2025-07 | Car | Audi | A6 | Black | Driving without Due Care and Attention | None | M5 N, link to M6 S | M5 N, link to M6 S | Sandwell | Sandwell | Court | N/A | ||||
| 13123 | op-snap---monthly-publication-july-2025.pdf | 1175 | 2025-07 | Car | Volkswagen | Golf | Black | Misc - Non Traffic Offences | No Insurance | Tipton Road | Tipton Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5157798 | -2.0437191 | ||
| 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 | ||
| 13186 | op-snap---monthly-publication-july-2025.pdf | 1238 | 2025-07 | Other | Peugeot | Partner | White | Driving a vehicle wholly or partly on a footpath | None | High Street Princes End Tipton | High Street Princes End Tipton | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5437324 | -2.0596147 | ||
| 13187 | op-snap---monthly-publication-july-2025.pdf | 1239 | 2025-07 | Other | Peugeot | Partner | White | Drive / Ride / Lead an animal on a footpath | None | High Street Princes End Tipton | High Street Princes End Tipton | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5437324 | -2.0596147 | ||
| 13191 | op-snap---monthly-publication-july-2025.pdf | 1243 | 2025-07 | Car | Ford | Focus | White | Drive on hard shoulder | None | M5 J1 NB | M5 J1 Northbound | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | ||||
| 13219 | op-snap---monthly-publication-july-2025.pdf | 1271 | 2025-07 | Other | Toyota | Prius | White | Driving a vehicle wholly or partly on a footpath | None | High Street Princes End | High Street Princes End | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5437324 | -2.0596147 | ||
| 13220 | op-snap---monthly-publication-july-2025.pdf | 1272 | 2025-07 | Car | Citroen | C4 | White | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Sandwell | Sandwell | Education | N/A | 52.5461417 | -1.9334193 | ||
| 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 | ||
| 13241 | op-snap---monthly-publication-july-2025.pdf | 1293 | 2025-07 | Car | BMW | X4 | White | Driving without Due Care and Attention | None | Thimblemill Road | Thimblemill Road | Sandwell | Sandwell | Education | N/A | 52.4801354 | -1.9749821 | ||
| 13250 | op-snap---monthly-publication-july-2025.pdf | 1302 | 2025-07 | Car | Renault | Clio | White | Contravening a Red Traffic Light | None | Birmingham New Road | Birmingham New Road | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | 52.5151598 | -2.064717 | ||
| 13302 | op-snap---monthly-publication-july-2025.pdf | 1354 | 2025-07 | Car | Ford | Mondeo | Green | Cause vehicle to be left in a dangerous position | None | Castle Road West | Castle Road West | Sandwell | Sandwell | Warning Letter | N/A | 52.4686934 | -1.9974957 | ||
| 13305 | op-snap---monthly-publication-july-2025.pdf | 1357 | 2025-07 | Pedestrian | Hyundai | Santa Fe | Black | Cause vehicle to be left in a dangerous position | None | Hagley Road South | Hagley Road South | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13306 | op-snap---monthly-publication-july-2025.pdf | 1358 | 2025-07 | Pedestrian | Mercedes-Benz | B170 | Black | Cause vehicle to be left in a dangerous position | None | Dog Kennel Lane | Dog Kennel Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4901007 | -1.9986317 | ||
| 13307 | op-snap---monthly-publication-july-2025.pdf | 1359 | 2025-07 | Pedestrian | Ford | Galaxy | Grey | Cause vehicle to be left in a dangerous position | None | Reddings Lane | Reddings Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13308 | op-snap---monthly-publication-july-2025.pdf | 1360 | 2025-07 | Pedestrian | BMW | X3 | White | Cause vehicle to be left in a dangerous position | None | Reddings Lane | Reddings Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13315 | op-snap---monthly-publication-july-2025.pdf | 1367 | 2025-07 | Car | Toyota | Corolla | Grey | Cause vehicle to be left in a dangerous position | None | Roberts Street | Roberts Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13317 | op-snap---monthly-publication-july-2025.pdf | 1369 | 2025-07 | Car | Vauxhall | Mokka | Red | Cause vehicle to be left in a dangerous position | None | Roberts Street | Roberts Street | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 13326 | op-snap---monthly-publication-july-2025.pdf | 1378 | 2025-07 | Pedestrian | Audi | A4 | Silver | Cause vehicle to be left in a dangerous position | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 13327 | op-snap---monthly-publication-july-2025.pdf | 1379 | 2025-07 | Pedestrian | Fiat | 500 | Black | Cause vehicle to be left in a dangerous position | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 13328 | op-snap---monthly-publication-july-2025.pdf | 1380 | 2025-07 | Pedestrian | Ford | Focus | Grey | Cause vehicle to be left in a dangerous position | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 | ||
| 13329 | op-snap---monthly-publication-july-2025.pdf | 1381 | 2025-07 | Pedestrian | Vauxhall | Corsa | Blue | Cause vehicle to be left in a dangerous position | None | Dudley Road | Dudley Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4877352 | -1.9494469 |
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);