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'}
421 rows where reporter_transport_mode = "Pedestrian" and vehicle_make = "Vauxhall" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 27
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 181
- Cause vehicle to be left in a dangerous position 78
- Misc - Non Traffic Offences 31
- Contravening a Red Traffic Light 22
- Stop a vehicle within pelican pedestrian crossing limits 22
- Driving without Due Care and Attention 14
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 14
- Using a Mobile Phone Whilst Driving 12
- Cause unnecessary obstruction by motor vehicle 10
- Stop a vehicle on pedestrian crossing 9
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- Motor vehicle fail to accord precedence at a pelican crossing 3
- No Insurance 2
- No Seat Belt 2
- No vehicle excise licence 2
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 1
- Contravene Lane Closure Red X 1
- Dangerous Driving 1
- Drive a vehicle on common land 1
- Driver not in position to have Proper Control 1
- Driving a vehicle wholly or partly on a footpath 1
- Driving without Reasonable Consideration 1
- Fail to Conform to Cycle Lane 1
- MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
- Motor vehicle fail to comply with a non endorsab 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
month 14
council_area 13
- Birmingham 253
- Dudley 43
- Sandwell 32
- Coventry 20
- Walsall 20
- Wolverhampton 17
- Sutton Coldfield 16
- Out of Force Area 7
- Metropolitan Borough Of Dudley 5
- Solihull 5
- Bbrirommiwngichham 1
- Halesowen 1
- Nbs Irrmdingham 1
disposal 8
- Warning Letter 178
- NFA 116
- Fixed Penalty 86
- Education 27
- Court 11
- Duplicate Submission 1
- Other Action Taken 1
- RTC - Actioned 1
vehicle_make 1
- Vauxhall · 421 ✖
reporter_transport_mode 1
- Pedestrian · 421 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8851 | op-snap---monthly-publication-february-2026.pdf | 1598 | 2026-02 | Pedestrian | Vauxhall | corsa | Grey | Misc - Non Traffic Offences | None | birmingham road | Birmingham Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5505398 | -1.8252993 | ||
| 8834 | op-snap---monthly-publication-february-2026.pdf | 1581 | 2026-02 | Pedestrian | Vauxhall | astra | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | willies road | Willies Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8723 | op-snap---monthly-publication-february-2026.pdf | 1470 | 2026-02 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | moor green lane | Moor Green Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4374665 | -1.9119895 | ||
| 8722 | op-snap---monthly-publication-february-2026.pdf | 1469 | 2026-02 | Pedestrian | Vauxhall | combo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | stoney stanton road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 8717 | op-snap---monthly-publication-february-2026.pdf | 1464 | 2026-02 | Pedestrian | Vauxhall | corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | rockingham gardens | Rockingham Gardens | Birmingham | Birmingham | Warning Letter | N/A | 52.5690681 | -1.8271174 | ||
| 8714 | op-snap---monthly-publication-february-2026.pdf | 1461 | 2026-02 | Pedestrian | Vauxhall | vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | kingstanding road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 8637 | op-snap---monthly-publication-february-2026.pdf | 1384 | 2026-02 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dale close | Dale Close | Birmingham | Birmingham | Warning Letter | N/A | 52.4215728 | -1.8433062 | ||
| 8625 | op-snap---monthly-publication-february-2026.pdf | 1372 | 2026-02 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | fallows road | Fallows Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613056 | -1.8636034 | ||
| 8482 | op-snap---monthly-publication-february-2026.pdf | 1229 | 2026-02 | Pedestrian | Vauxhall | Adam | Black | Driving without Due Care and Attention | None | Mcdonalds Car Park | Mcdonalds Car Park | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 8281 | op-snap---monthly-publication-february-2026.pdf | 1028 | 2026-02 | Pedestrian | Vauxhall | Astra | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street Lozells | Wills Street Lozells | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.500453 | -1.9141126 | ||
| 8280 | op-snap---monthly-publication-february-2026.pdf | 1027 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street Lozells | Wills Street Lozells | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.500453 | -1.9141126 | ||
| 8048 | op-snap---monthly-publication-february-2026.pdf | 795 | 2026-02 | Pedestrian | Vauxhall | Mokka | Grey | Contravening a Red Traffic Light | None | Stratford Upon Avon | Stratford Upon Avon | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3499075 | -1.7812051 | ||
| 7999 | op-snap---monthly-publication-february-2026.pdf | 746 | 2026-02 | Pedestrian | Vauxhall | Mokka | Blue | Misc - Non Traffic Offences | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 7982 | op-snap---monthly-publication-february-2026.pdf | 729 | 2026-02 | Pedestrian | Vauxhall | Corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tixall Road | Tixall Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4193312 | -1.8517995 | ||
| 7973 | op-snap---monthly-publication-february-2026.pdf | 720 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Cause vehicle to be left in a dangerous position | None | Institute Road | Institute Road | Birmingham | Birmingham | Education | N/A | 52.4334781 | -1.8892337 | ||
| 7840 | op-snap---monthly-publication-february-2026.pdf | 587 | 2026-02 | Pedestrian | Vauxhall | Insignia | Black | Cause vehicle to be left in a dangerous position | None | Cherry Orchard Road, Handsworth | Cherry Orchard Road, Handsworth | Birmingham | Birmingham | Fixed Penalty | N/A | 52.524872 | -1.9253914 | ||
| 7671 | op-snap---monthly-publication-february-2026.pdf | 418 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Drapers Fields | Drapers Fields | Coventry | Coventry | Fixed Penalty | N/A | 52.4144091 | -1.5109203 | ||
| 7518 | op-snap---monthly-publication-february-2026.pdf | 265 | 2026-02 | Pedestrian | Vauxhall | Crossland | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 7465 | op-snap---monthly-publication-february-2026.pdf | 212 | 2026-02 | Pedestrian | Vauxhall | Corsa | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Moor Green Lane | Moor Green Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4374665 | -1.9119895 | ||
| 7446 | op-snap---monthly-publication-february-2026.pdf | 193 | 2026-02 | Pedestrian | Vauxhall | Corsa | Red | Cause vehicle to be left in a dangerous position | None | Dowar Road / Irvine Road | Dowar Road / Irvine Road | Birmingham | Birmingham | Education | N/A | 52.3932301 | -1.9992819 | ||
| 7437 | op-snap---monthly-publication-february-2026.pdf | 184 | 2026-02 | Pedestrian | Vauxhall | Vivaro | White | Stop a vehicle within pelican pedestrian crossing limits | None | Mill Street | Mill Street | Dudley | Dudley | Education | N/A | 52.4779239 | -2.1561956 | ||
| 7316 | op-snap---monthly-publication-february-2026.pdf | 63 | 2026-02 | Pedestrian | Vauxhall | Corsa | Silver | Cause vehicle to be left in a dangerous position | None | Heeley Road | Heeley Road | Birmingham | Birmingham | Education | N/A | 52.4401847 | -1.9331572 | ||
| 7307 | op-snap---monthly-publication-february-2026.pdf | 54 | 2026-02 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 11832 | op-snap---monthly-publication-january-2026.pdf | 1293 | 2026-01 | Pedestrian | Vauxhall | Movano | 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 | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 11771 | op-snap---monthly-publication-january-2026.pdf | 1232 | 2026-01 | Pedestrian | Vauxhall | Vivaro | Silver | Cause vehicle to be left in a dangerous position | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 11737 | op-snap---monthly-publication-january-2026.pdf | 1198 | 2026-01 | Pedestrian | Vauxhall | Crossland | Red | Cause vehicle to be left in a dangerous position | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Education | N/A | 52.4321165 | -1.8902667 | ||
| 11725 | op-snap---monthly-publication-january-2026.pdf | 1186 | 2026-01 | Pedestrian | Vauxhall | Zafira | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stockwell Road | Stockwell Road | Birmingham | Birmingham | NFA | No Offence | 52.5157939 | -1.938322 | ||
| 11699 | op-snap---monthly-publication-january-2026.pdf | 1160 | 2026-01 | Pedestrian | Vauxhall | Mokka | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 11677 | op-snap---monthly-publication-january-2026.pdf | 1138 | 2026-01 | Pedestrian | Vauxhall | Grandland X | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4721372 | -2.1243522 | ||
| 11668 | op-snap---monthly-publication-january-2026.pdf | 1129 | 2026-01 | Pedestrian | Vauxhall | Zafira | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Startford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 11493 | op-snap---monthly-publication-january-2026.pdf | 954 | 2026-01 | Pedestrian | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | High Street | High Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5254588 | -1.8373064 | ||
| 11469 | op-snap---monthly-publication-january-2026.pdf | 930 | 2026-01 | Pedestrian | Vauxhall | Corsa | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | A435 Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 11458 | op-snap---monthly-publication-january-2026.pdf | 919 | 2026-01 | Pedestrian | Vauxhall | Mokka | Red | Stop a vehicle on pedestrian crossing | None | Bourneville Lane | Bourneville Lane | Birmingham | Birmingham | Education | N/A | ||||
| 11447 | op-snap---monthly-publication-january-2026.pdf | 908 | 2026-01 | Pedestrian | Vauxhall | Mokka | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Worlds End Lane | Worlds End Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4555997 | -1.9882443 | ||
| 11426 | op-snap---monthly-publication-january-2026.pdf | 887 | 2026-01 | Pedestrian | Vauxhall | Corsa | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No vehicle excise licence | Wolfenden Way (West Yorkshire) | Wolfenden Way (West Yorkshire) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11311 | op-snap---monthly-publication-january-2026.pdf | 772 | 2026-01 | Pedestrian | Vauxhall | Astra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Duplicate Submission | Duplicate Submission | 52.4693896 | -2.1251602 | ||
| 11226 | op-snap---monthly-publication-january-2026.pdf | 687 | 2026-01 | Pedestrian | Vauxhall | Astra | Silver | Cause vehicle to be left in a dangerous position | None | Gayfield Ave | Gayfield Ave | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 11223 | op-snap---monthly-publication-january-2026.pdf | 684 | 2026-01 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Ave | Gayfield Ave | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 11222 | op-snap---monthly-publication-january-2026.pdf | 683 | 2026-01 | Pedestrian | Vauxhall | Corsa | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Ave | Gayfield Ave | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 11049 | op-snap---monthly-publication-january-2026.pdf | 510 | 2026-01 | Pedestrian | Vauxhall | Astra | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 10995 | op-snap---monthly-publication-january-2026.pdf | 456 | 2026-01 | Pedestrian | Vauxhall | Astra | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Devonshire Road | Devonshire Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5163419 | -1.9288926 | ||
| 10981 | op-snap---monthly-publication-january-2026.pdf | 442 | 2026-01 | Pedestrian | Vauxhall | Viva | Red | Misc - Non Traffic Offences | None | Fontley Close | Fontley Close | Birmingham | Birmingham | NFA | No Offence | 52.4760797 | -1.7952034 | ||
| 10841 | op-snap---monthly-publication-january-2026.pdf | 302 | 2026-01 | Pedestrian | Vauxhall | Insignia | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | none | Belgrade Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4668753 | -1.8996143 | ||
| 10614 | op-snap---monthly-publication-january-2026.pdf | 75 | 2026-01 | Pedestrian | Vauxhall | insgnia | black | Cause vehicle to be left in a dangerous position | None | alcester road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 5112 | op-snap---monthly-publication-december-2025.pdf | 1240 | 2025-12 | Pedestrian | Vauxhall | Vivaro | Silver | Motor vehicle fail to accord precedence at a pelican crossing | None | Woodbridge Road | Woodbridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4482076 | -1.8864335 | ||
| 5111 | op-snap---monthly-publication-december-2025.pdf | 1239 | 2025-12 | Pedestrian | Vauxhall | Astra | Black | Stop a vehicle on pedestrian crossing | None | Timberley Lane | Timberley Lane | Birmingham | Birmingham | Education | N/A | 52.4982049 | -1.7736502 | ||
| 5095 | op-snap---monthly-publication-december-2025.pdf | 1223 | 2025-12 | Pedestrian | Vauxhall | Corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 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 | ||
| 5040 | op-snap---monthly-publication-december-2025.pdf | 1168 | 2025-12 | Pedestrian | Vauxhall | astra | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | st benedicts road | St Benedicts Road | Birmingham | Birmingham | Warning Letter | N/A | 52.47035 | -1.8428703 | ||
| 5023 | op-snap---monthly-publication-december-2025.pdf | 1151 | 2025-12 | Pedestrian | Vauxhall | grandland | White | Misc - Non Traffic Offences | None | robin hood lane | Robin Hood Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4221526 | -1.8425617 | ||
| 5017 | op-snap---monthly-publication-december-2025.pdf | 1145 | 2025-12 | Pedestrian | Vauxhall | astra | Brown | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | none | aintree way | Aintree Way | Dudley | Dudley | NFA | Misc Inc Crimes | 52.5154873 | -2.1115464 | ||
| 5014 | op-snap---monthly-publication-december-2025.pdf | 1142 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | ash street | Ash Street | Dudley | Dudley | Warning Letter | N/A | 52.6194553 | -1.9924281 | ||
| 5013 | op-snap---monthly-publication-december-2025.pdf | 1141 | 2025-12 | Pedestrian | Vauxhall | astra | Red | Cause vehicle to be left in a dangerous position | None | halesowne road | Halesowne Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4939 | op-snap---monthly-publication-december-2025.pdf | 1067 | 2025-12 | Pedestrian | Vauxhall | astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 4773 | op-snap---monthly-publication-december-2025.pdf | 901 | 2025-12 | Pedestrian | Vauxhall | Meriva | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Sherbourne St | Sherborne Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4762433 | -1.9176665 | ||
| 4654 | op-snap---monthly-publication-december-2025.pdf | 782 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | lower queen street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 4652 | op-snap---monthly-publication-december-2025.pdf | 780 | 2025-12 | Pedestrian | Vauxhall | astra | Blue | Misc - Non Traffic Offences | None | richard atreet | Richard Atreet | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 4651 | op-snap---monthly-publication-december-2025.pdf | 779 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | ||
| 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 | ||
| 4573 | op-snap---monthly-publication-december-2025.pdf | 701 | 2025-12 | Pedestrian | Vauxhall | Mervia | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Corner of Geraldine Rd and Deaki | Corner of Geraldine Road and Deaki | nBs iRrmdingham | Nbs Irrmdingham | Warning Letter | N/A | ||||
| 4510 | op-snap---monthly-publication-december-2025.pdf | 638 | 2025-12 | Pedestrian | Vauxhall | mokka | Gold | Misc - Non Traffic Offences | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | ||
| 4324 | op-snap---monthly-publication-december-2025.pdf | 452 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Stop a vehicle within pelican pedestrian crossing limits | None | bristol road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 4297 | op-snap---monthly-publication-december-2025.pdf | 425 | 2025-12 | Pedestrian | Vauxhall | grandland | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lime grove | Lime Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.5042965 | -1.9074069 | ||
| 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 | ||
| 4257 | op-snap---monthly-publication-december-2025.pdf | 385 | 2025-12 | Pedestrian | Vauxhall | corsa | Black | Misc - Non Traffic Offences | None | fox hollies road | Fox Hollies Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5517052 | -1.7825505 | ||
| 4236 | op-snap---monthly-publication-december-2025.pdf | 364 | 2025-12 | Pedestrian | Vauxhall | Insignia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hall Green Road | Hall Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.473444 | -1.8094123 | ||
| 4229 | op-snap---monthly-publication-december-2025.pdf | 357 | 2025-12 | Pedestrian | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | |||
| 4228 | op-snap---monthly-publication-december-2025.pdf | 356 | 2025-12 | Pedestrian | Vauxhall | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | |||
| 4199 | op-snap---monthly-publication-december-2025.pdf | 327 | 2025-12 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Duplicate Submission | 52.4693896 | -2.1251602 | ||
| 4193 | op-snap---monthly-publication-december-2025.pdf | 321 | 2025-12 | Pedestrian | Vauxhall | Meriva | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marks Crescent | Street Marks Crescent | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 3945 | op-snap---monthly-publication-december-2025.pdf | 73 | 2025-12 | Pedestrian | Vauxhall | Insignia | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Scafell Road | Scafell Road | Dudley | Dudley | Warning Letter | N/A | 52.4592579 | -2.1385749 | ||
| 3941 | op-snap---monthly-publication-december-2025.pdf | 69 | 2025-12 | Pedestrian | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Birdwell Croft | Birdwell Croft | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.425424 | -1.8903528 | ||
| 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 | |||
| 21988 | op-snap---monthly-publication-november-2025.pdf | 1530 | 2025-11 | Pedestrian | Vauxhall | Insignia | Black | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21986 | op-snap---monthly-publication-november-2025.pdf | 1528 | 2025-11 | Pedestrian | Vauxhall | Zafira | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21871 | op-snap---monthly-publication-november-2025.pdf | 1413 | 2025-11 | Pedestrian | Vauxhall | grandland | Blue | Misc - Non Traffic Offences | None | turners lane | Turners Lane | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4721372 | -2.1243522 | ||
| 21844 | op-snap---monthly-publication-november-2025.pdf | 1386 | 2025-11 | Pedestrian | Vauxhall | corsa | Black | Cause vehicle to be left in a dangerous position | None | coombe parkl | Coombe Parkl | Coventry | Coventry | Warning Letter | N/A | ||||
| 21840 | op-snap---monthly-publication-november-2025.pdf | 1382 | 2025-11 | Pedestrian | Vauxhall | vivaro | Grey | Cause vehicle to be left in a dangerous position | None | kingstanding road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 21817 | op-snap---monthly-publication-november-2025.pdf | 1359 | 2025-11 | Pedestrian | Vauxhall | zafiara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | Duplicate Submission | 52.4307 | -1.8494663 | ||
| 21816 | op-snap---monthly-publication-november-2025.pdf | 1358 | 2025-11 | Pedestrian | Vauxhall | zafiara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | Duplicate Submission | 52.4307 | -1.8494663 | ||
| 21815 | op-snap---monthly-publication-november-2025.pdf | 1357 | 2025-11 | Pedestrian | Vauxhall | zafiara | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | petersfield road | Petersfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4307 | -1.8494663 | ||
| 21810 | op-snap---monthly-publication-november-2025.pdf | 1352 | 2025-11 | Pedestrian | Vauxhall | zafira | White | Misc - Non Traffic Offences | None | wootton road | Wootton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.3905192 | -1.968829 | ||
| 21794 | op-snap---monthly-publication-november-2025.pdf | 1336 | 2025-11 | Pedestrian | Vauxhall | astra | Grey | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 21537 | op-snap---monthly-publication-november-2025.pdf | 1079 | 2025-11 | Pedestrian | Vauxhall | corsa | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | stratford road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 21466 | op-snap---monthly-publication-november-2025.pdf | 1008 | 2025-11 | Pedestrian | Vauxhall | zafira | Black | Cause vehicle to be left in a dangerous position | None | petersfield road | Petersfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4307 | -1.8494663 | ||
| 21464 | op-snap---monthly-publication-november-2025.pdf | 1006 | 2025-11 | Pedestrian | Vauxhall | vivaro | White | Cause vehicle to be left in a dangerous position | None | northway | Northway | Dudley | Dudley | Warning Letter | N/A | 52.548846 | -2.1297656 | ||
| 21463 | op-snap---monthly-publication-november-2025.pdf | 1005 | 2025-11 | Pedestrian | Vauxhall | zafiara | Grey | Cause vehicle to be left in a dangerous position | None | wake green road | Wake Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4437078 | -1.8783408 | ||
| 21407 | op-snap---monthly-publication-november-2025.pdf | 949 | 2025-11 | Pedestrian | Vauxhall | Grandland | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4721372 | -2.1243522 | ||
| 21377 | op-snap---monthly-publication-november-2025.pdf | 919 | 2025-11 | Pedestrian | Vauxhall | zafira | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | pershore road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 21376 | op-snap---monthly-publication-november-2025.pdf | 918 | 2025-11 | Pedestrian | Vauxhall | astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | tiverton road | Tiverton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4400034 | -1.9295885 | ||
| 21375 | op-snap---monthly-publication-november-2025.pdf | 917 | 2025-11 | Pedestrian | Vauxhall | corsa | Red | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 21362 | op-snap---monthly-publication-november-2025.pdf | 904 | 2025-11 | Pedestrian | Vauxhall | Grey | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | |||
| 21350 | op-snap---monthly-publication-november-2025.pdf | 892 | 2025-11 | Pedestrian | Vauxhall | Mokka | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Deepdale Avenue | Deepdale Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4532939 | -1.7809918 | ||
| 21349 | op-snap---monthly-publication-november-2025.pdf | 891 | 2025-11 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brenton Rd, Penn | Brenton Road, Penn | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5562533 | -2.1523175 | ||
| 21339 | op-snap---monthly-publication-november-2025.pdf | 881 | 2025-11 | Pedestrian | Vauxhall | astra | Black | Misc - Non Traffic Offences | None | abbey road | Abbey Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4530622 | -2.0800139 | ||
| 21331 | op-snap---monthly-publication-november-2025.pdf | 873 | 2025-11 | Pedestrian | Vauxhall | antara | Grey | Cause vehicle to be left in a dangerous position | None | high street quarry bank | High Street Quarry Bank | Dudley | Dudley | Warning Letter | N/A | 52.4583107 | -2.1169703 | ||
| 21257 | op-snap---monthly-publication-november-2025.pdf | 799 | 2025-11 | Pedestrian | Vauxhall | Corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Quarry Road | Quarry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4339016 | -1.9681726 | ||
| 21232 | op-snap---monthly-publication-november-2025.pdf | 774 | 2025-11 | Pedestrian | Vauxhall | Agila | Silver | Misc - Non Traffic Offences | None | Fenton Road | Fenton Road | Coventry | Coventry | NFA | No Offence | 52.4331816 | -1.5630141 | ||
| 21230 | op-snap---monthly-publication-november-2025.pdf | 772 | 2025-11 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 21201 | op-snap---monthly-publication-november-2025.pdf | 743 | 2025-11 | Pedestrian | Vauxhall | Astra | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Clarence Road | Clarence Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5940902 | -1.843503 |
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);