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'}
90 rows where council_area = "Sandwell" and month = "2025-12" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 24
offence 10
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 26
- Driving without Due Care and Attention 22
- Cause vehicle to be left in a dangerous position 14
- Contravening a Red Traffic Light 12
- Misc - Non Traffic Offences 9
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Driving without Reasonable Consideration 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 1
- Stop a vehicle on pedestrian crossing 1
disposal 6
- Warning Letter 41
- NFA 36
- Education 5
- Fixed Penalty 4
- Court 2
- RTC - Actioned 2
reporter_transport_mode 4
- Car 52
- Pedestrian 36
- Pedal Bike 1
- Van 1
month 1
- 2025-12 · 90 ✖
council_area 1
- Sandwell · 90 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 3897 | op-snap---monthly-publication-december-2025.pdf | 25 | 2025-12 | Car | Vauxhall | Vivaro | Grey | Cause vehicle to be left in a dangerous position | None | West Bromwich High St | West Bromwich High Street | Sandwell | Sandwell | Warning Letter | N/A | 52.5205106 | -1.9980473 | ||
| 3903 | op-snap---monthly-publication-december-2025.pdf | 31 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3904 | op-snap---monthly-publication-december-2025.pdf | 32 | 2025-12 | Car | Cupra | Formentor | Black | Contravening a Red Traffic Light | None | Dudley Road | Dudley Road | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.4877352 | -1.9494469 | ||
| 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 | ||
| 3913 | op-snap---monthly-publication-december-2025.pdf | 41 | 2025-12 | Pedestrian | Ghibli | Yellow | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | |||
| 3914 | op-snap---monthly-publication-december-2025.pdf | 42 | 2025-12 | Pedestrian | Porsche | Cayenne | Black | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 3917 | op-snap---monthly-publication-december-2025.pdf | 45 | 2025-12 | Pedestrian | Volkswagen | Golf | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | ||
| 3918 | op-snap---monthly-publication-december-2025.pdf | 46 | 2025-12 | Pedestrian | Vauxhall | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Shelsley Avenue | Shelsley Avenue | Sandwell | Sandwell | Warning Letter | N/A | 52.4906088 | -2.0317097 | |||
| 3926 | op-snap---monthly-publication-december-2025.pdf | 54 | 2025-12 | Pedestrian | Nissan | Note | White | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3927 | op-snap---monthly-publication-december-2025.pdf | 55 | 2025-12 | Pedestrian | Peugeot | 108 | Red | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3928 | op-snap---monthly-publication-december-2025.pdf | 56 | 2025-12 | Pedestrian | Mercedes-Benz | A Class | White | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3929 | op-snap---monthly-publication-december-2025.pdf | 57 | 2025-12 | Pedestrian | Citroen | C1 | Blue | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3930 | op-snap---monthly-publication-december-2025.pdf | 58 | 2025-12 | Pedestrian | Volkswagen | White | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | |||
| 3931 | op-snap---monthly-publication-december-2025.pdf | 59 | 2025-12 | Pedestrian | Ford | Focus | White | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 3938 | op-snap---monthly-publication-december-2025.pdf | 66 | 2025-12 | Pedestrian | Toyota | Auris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 3939 | op-snap---monthly-publication-december-2025.pdf | 67 | 2025-12 | Pedestrian | Kia | Niro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 3958 | op-snap---monthly-publication-december-2025.pdf | 86 | 2025-12 | Car | Nissan | Note | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anne Road | Anne Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5001925 | -1.9481997 | ||
| 4024 | op-snap---monthly-publication-december-2025.pdf | 152 | 2025-12 | Car | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Holloway Bank | Holloway Bank | Sandwell | Sandwell | RTC - Actioned | N/A | 52.5430345 | -2.0152621 | ||
| 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 | ||
| 4039 | op-snap---monthly-publication-december-2025.pdf | 167 | 2025-12 | Car | Ford | Fiesta | White | Driving without Reasonable Consideration | None | Black Country New Road | Black Country New Road | Sandwell | Sandwell | Education | N/A | 52.5527191 | -2.0312967 | ||
| 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 | ||||
| 4053 | op-snap---monthly-publication-december-2025.pdf | 181 | 2025-12 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Fenton Street | Fenton Street | Sandwell | Sandwell | NFA | No VRM | 52.5004036 | -1.9790049 | ||
| 4054 | op-snap---monthly-publication-december-2025.pdf | 182 | 2025-12 | Car | Skoda | Octavia | Black | Contravening a Red Traffic Light | None | Fenton Street | Fenton Street | Sandwell | Sandwell | Court | N/A | 52.5004036 | -1.9790049 | ||
| 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 | ||
| 4063 | op-snap---monthly-publication-december-2025.pdf | 191 | 2025-12 | Car | Jeep | Renegade | White | Misc - Non Traffic Offences | None | A4040 Island Road | Island Road | Sandwell | Sandwell | NFA | No Offence | 52.4634433 | -1.9965278 | ||
| 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 | ||
| 4123 | op-snap---monthly-publication-december-2025.pdf | 251 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Maple Tree Lane | Maple Tree Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4139 | op-snap---monthly-publication-december-2025.pdf | 267 | 2025-12 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4140 | op-snap---monthly-publication-december-2025.pdf | 268 | 2025-12 | Pedestrian | Mazda | CX-30 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4173 | op-snap---monthly-publication-december-2025.pdf | 301 | 2025-12 | Car | Ford | Transit | Blue | Misc - Non Traffic Offences | None | Wednesbury Oak Road | Wednesbury Oak Road | Sandwell | Sandwell | NFA | No Offence | 52.5461405 | -2.0536516 | ||
| 4215 | op-snap---monthly-publication-december-2025.pdf | 343 | 2025-12 | Pedestrian | Mitsubishi | Outlander | White | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | ||
| 4216 | op-snap---monthly-publication-december-2025.pdf | 344 | 2025-12 | Pedestrian | Ford | Focus | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | ||
| 4217 | op-snap---monthly-publication-december-2025.pdf | 345 | 2025-12 | Pedestrian | BMW | 3 Series | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4722765 | -1.9787531 | ||
| 4218 | op-snap---monthly-publication-december-2025.pdf | 346 | 2025-12 | Pedestrian | Nissan | Airya | Grey | Cause vehicle to be left in a dangerous position | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 4223 | op-snap---monthly-publication-december-2025.pdf | 351 | 2025-12 | Pedestrian | Mg | HS | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barncroft Road | Barncroft Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5061545 | -2.0570005 | ||
| 4224 | op-snap---monthly-publication-december-2025.pdf | 352 | 2025-12 | Pedestrian | Toyota | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barclay Road | Barclay Road | Sandwell | Sandwell | NFA | No Offence | 52.4722765 | -1.9787531 | |||
| 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 | |||
| 4275 | op-snap---monthly-publication-december-2025.pdf | 403 | 2025-12 | Pedestrian | Ford | fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4276 | op-snap---monthly-publication-december-2025.pdf | 404 | 2025-12 | Pedestrian | Vauxhall | zafiara | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4277 | op-snap---monthly-publication-december-2025.pdf | 405 | 2025-12 | Pedestrian | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | Warning Letter | N/A | 52.47753 | -1.9774758 | ||
| 4278 | op-snap---monthly-publication-december-2025.pdf | 406 | 2025-12 | Pedestrian | Land Rover | range rover | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 4309 | op-snap---monthly-publication-december-2025.pdf | 437 | 2025-12 | Car | Seat | Alhambra | White | Contravening a Red Traffic Light | None | Black Lake | Black Lake | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5341947 | -2.0098521 | ||
| 4310 | op-snap---monthly-publication-december-2025.pdf | 438 | 2025-12 | Car | Jaguar | XF | Silver | Misc - Non Traffic Offences | None | A4040 Island Road | Island Road | Sandwell | Sandwell | NFA | Not in Public Interest | 52.4634433 | -1.9965278 | ||
| 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 | ||||
| 4321 | op-snap---monthly-publication-december-2025.pdf | 449 | 2025-12 | Pedestrian | Toyota | prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 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 | |||
| 4502 | op-snap---monthly-publication-december-2025.pdf | 630 | 2025-12 | Car | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 4503 | op-snap---monthly-publication-december-2025.pdf | 631 | 2025-12 | Car | Audi | A4 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4634433 | -1.9965278 | ||
| 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 | ||
| 4582 | op-snap---monthly-publication-december-2025.pdf | 710 | 2025-12 | Car | Land Rover | Evoque | Black | Contravening a Red Traffic Light | None | West Bromwich Interchange | West Bromwich Interchange | Sandwell | Sandwell | Warning Letter | N/A | 52.5109262 | -1.9753718 | ||
| 4589 | op-snap---monthly-publication-december-2025.pdf | 717 | 2025-12 | Pedestrian | Renault | Clio | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq | Nuiopnmeent | Rosebery Road, Cape Hill | Rosebery Road, Cape Hill | Sandwell | Sandwell | Warning Letter | N/A | 52.4878382 | -1.9570553 | ||
| 4593 | op-snap---monthly-publication-december-2025.pdf | 721 | 2025-12 | Pedestrian | Vauxhall | insignia | White | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 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 | ||||
| 4650 | op-snap---monthly-publication-december-2025.pdf | 778 | 2025-12 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | apsley road | Apsley Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4651624 | -2.0105642 | |||||
| 4667 | op-snap---monthly-publication-december-2025.pdf | 795 | 2025-12 | Car | Ford | eco sport | Grey | Contravening a Red Traffic Light | None | Wednesbury J9 Roundabout | Wednesbury J9 Roundabout | Sandwell | Sandwell | Education | N/A | ||||
| 4668 | op-snap---monthly-publication-december-2025.pdf | 796 | 2025-12 | Pedestrian | Mercedes-Benz | GLC 220 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road | Hobbs Road | Sandwell | Sandwell | NFA | Duplicate Submission | ||||
| 4680 | op-snap---monthly-publication-december-2025.pdf | 808 | 2025-12 | Pedestrian | Mercedes-Benz | Sprinter | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Regent Road | Regent Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5106406 | -2.0559963 | ||
| 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 | ||||
| 4752 | op-snap---monthly-publication-december-2025.pdf | 880 | 2025-12 | Car | Hyundai | Tucson | Blue | Contravening a Red Traffic Light | None | West Bromwich Interchange | West Bromwich Interchange | Sandwell | Sandwell | NFA | Outside of 14 DAYS Late Submission | 52.5109262 | -1.9753718 | ||
| 4754 | op-snap---monthly-publication-december-2025.pdf | 882 | 2025-12 | Car | Volkswagen | Passatt | Black | Contravening a Red Traffic Light | None | A41, Smethwick | A41, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.5098817 | -1.9621109 | ||
| 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 | ||
| 4793 | op-snap---monthly-publication-december-2025.pdf | 921 | 2025-12 | Pedestrian | Toyota | Yaris | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moat Road | Moat Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4842946 | -2.0027774 | ||
| 4794 | op-snap---monthly-publication-december-2025.pdf | 922 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4795 | op-snap---monthly-publication-december-2025.pdf | 923 | 2025-12 | Car | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4796 | op-snap---monthly-publication-december-2025.pdf | 924 | 2025-12 | Car | Seat | Leon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Road | Church Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4857168 | -1.9703938 | ||
| 4820 | op-snap---monthly-publication-december-2025.pdf | 948 | 2025-12 | Car | Volkswagen | Golf | Grey | Contravening a Red Traffic Light | None | Haden Hill | Haden Hill | Sandwell | Sandwell | NFA | No VRM | 52.4675844 | -2.0577381 | ||
| 4847 | op-snap---monthly-publication-december-2025.pdf | 975 | 2025-12 | Car | Honda | Silver | Contravening a Red Traffic Light | None | A41 Birmingham Road | Birmingham Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5461417 | -1.9334193 | |||
| 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 | ||
| 4857 | op-snap---monthly-publication-december-2025.pdf | 985 | 2025-12 | Car | BMW | 320i | Grey | Misc - Non Traffic Offences | None | M5 jn1 | M5 jn1 | Sandwell | Sandwell | NFA | No Offence | ||||
| 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 | ||
| 4898 | op-snap---monthly-publication-december-2025.pdf | 1026 | 2025-12 | Car | Mercedes-Benz | E350 | White | Contravening a Red Traffic Light | None | Dudley Port | Dudley Port | Sandwell | Sandwell | NFA | No Offence | 52.524461 | -2.0492538 | ||
| 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 | ||
| 4946 | op-snap---monthly-publication-december-2025.pdf | 1074 | 2025-12 | Car | Peugeot | 3008 | Red | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4947 | op-snap---monthly-publication-december-2025.pdf | 1075 | 2025-12 | Car | Porsche | Cayenne | Silver | Misc - Non Traffic Offences | None | A4040 | A4040 | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4954 | op-snap---monthly-publication-december-2025.pdf | 1082 | 2025-12 | Pedestrian | Hyundai | tucson | Grey | Cause vehicle to be left in a dangerous position | None | tividale road | Tividale Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5144157 | -2.0586136 | ||
| 4969 | op-snap---monthly-publication-december-2025.pdf | 1097 | 2025-12 | Pedestrian | Mercedes-Benz | a200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.4722765 | -1.9787531 | ||
| 4970 | op-snap---monthly-publication-december-2025.pdf | 1098 | 2025-12 | Pedestrian | Peugeot | 5008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 4989 | op-snap---monthly-publication-december-2025.pdf | 1117 | 2025-12 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Tat Bank Road | Tat Bank Road | Sandwell | Sandwell | Education | N/A | 52.4979925 | -2.0082232 | ||
| 5093 | op-snap---monthly-publication-december-2025.pdf | 1221 | 2025-12 | Pedestrian | Vauxhall | Astra | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | No Offence | 52.47753 | -1.9774758 | ||
| 5123 | op-snap---monthly-publication-december-2025.pdf | 1251 | 2025-12 | Car | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Sedgley Road West | Sedgley Road West | Sandwell | Sandwell | NFA | N/A | 52.5296941 | -2.0777252 | ||
| 5124 | op-snap---monthly-publication-december-2025.pdf | 1252 | 2025-12 | Car | Toyota | Auris | White | Stop a vehicle on pedestrian crossing | None | High Street | High Street | Sandwell | Sandwell | Education | N/A | 52.5128738 | -1.9842054 | ||
| 5125 | op-snap---monthly-publication-december-2025.pdf | 1253 | 2025-12 | Car | Toyota | Prius | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Bearwood Road | Bearwood Road | Sandwell | Sandwell | Education | N/A | 52.4725977 | -1.9684448 | ||
| 5135 | op-snap---monthly-publication-december-2025.pdf | 1263 | 2025-12 | Pedal Bike | Ford | Transit | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hadley Street | Hadley Street | Sandwell | Sandwell | Warning Letter | N/A | 52.4863612 | -2.0105376 |
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);