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'}
465 rows where reporter_transport_mode = "Pedestrian" and vehicle_make = "Audi" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale, witness_contacted
offence 26
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 192
- Cause vehicle to be left in a dangerous position 94
- Misc - Non Traffic Offences 24
- Driving without Due Care and Attention 23
- Stop a vehicle within pelican pedestrian crossing limits 21
- Contravening a Red Traffic Light 20
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 20
- Using a Mobile Phone Whilst Driving 15
- Cause unnecessary obstruction by motor vehicle 14
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 8
- Stop a vehicle on pedestrian crossing 7
- Driving without Reasonable Consideration 5
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- VRM fails to conform to Regulations 4
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 2
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
- CCaauussee vuenhniecclee stsoa brye olebfstt irnu cat dioann gbeyr mouost opro vseithioicnle 1
- Contravene Lane Closure Red X 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- Waiting on a road in a prohibited area 1
- section 36 traffic sign -other than manned or 1
council_area 18
- Birmingham 296
- Sandwell 32
- Coventry 26
- Sutton Coldfield 24
- Dudley 22
- Wolverhampton 18
- Solihull 14
- Walsall 13
- Out of Force Area 9
- Metropolitan Borough Of Dudley 3
- Ds Rutotoand Coldfield 1
- Ebtir Bmirimngihnaghmam 1
- Halesowen 1
- Iewlda Lrsoalald, Rushall 1
- Mcoy)Ventry 1
- Metropolitan Borough 1
- Tshawnidcwkell 1
- Wallalsall 1
month 14
disposal 6
- Warning Letter 187
- Fixed Penalty 119
- NFA 119
- Education 30
- Court 6
- Other Action Taken 4
vehicle_make 1
- Audi · 465 ✖
reporter_transport_mode 1
- Pedestrian · 465 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8823 | op-snap---monthly-publication-february-2026.pdf | 1570 | 2026-02 | Pedestrian | Audi | A1 | Yellow | 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 | ||||
| 8792 | op-snap---monthly-publication-february-2026.pdf | 1539 | 2026-02 | 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 | ||
| 8719 | op-snap---monthly-publication-february-2026.pdf | 1466 | 2026-02 | Pedestrian | Audi | a4 | White | 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 | ||
| 8631 | op-snap---monthly-publication-february-2026.pdf | 1378 | 2026-02 | Pedestrian | Audi | q3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broadmeadow road | Broadmeadow Road | Solihull | Solihull | Warning Letter | N/A | ||||
| 8403 | op-snap---monthly-publication-february-2026.pdf | 1150 | 2026-02 | Pedestrian | Audi | A5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dovey Road | Dovey Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4412998 | -1.8577032 | ||
| 8283 | op-snap---monthly-publication-february-2026.pdf | 1030 | 2026-02 | Pedestrian | Audi | A5 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Burbury Street | Burbury Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5010617 | -1.9095433 | ||
| 8211 | op-snap---monthly-publication-february-2026.pdf | 958 | 2026-02 | Pedestrian | Audi | Q2 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street | Wills Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.500453 | -1.9141126 | ||
| 8176 | op-snap---monthly-publication-february-2026.pdf | 923 | 2026-02 | Pedestrian | Audi | A3 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westfield Road | Westfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4362187 | -1.8987821 | ||
| 8153 | op-snap---monthly-publication-february-2026.pdf | 900 | 2026-02 | Pedestrian | Audi | A6 | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 8137 | op-snap---monthly-publication-february-2026.pdf | 884 | 2026-02 | Pedestrian | Audi | A3 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Lyndon Road | Lyndon Road | Solihull | Solihull | Education | N/A | 52.4527113 | -1.789438 | ||
| 8124 | op-snap---monthly-publication-february-2026.pdf | 871 | 2026-02 | Pedestrian | Audi | Q3 | Grey | Cause vehicle to be left in a dangerous position | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7916 | op-snap---monthly-publication-february-2026.pdf | 663 | 2026-02 | Pedestrian | Audi | A4 | blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monkspath Hall Road / Whitefields Road | Monkspath Hall Road / Whitefields Road | Solihull | Solihull | Warning Letter | N/A | 52.3909753 | -1.8020771 | ||
| 7891 | op-snap---monthly-publication-february-2026.pdf | 638 | 2026-02 | Pedestrian | Audi | A6 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7851 | op-snap---monthly-publication-february-2026.pdf | 598 | 2026-02 | Pedestrian | Audi | S3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 7802 | op-snap---monthly-publication-february-2026.pdf | 549 | 2026-02 | Pedestrian | Audi | A4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingswood Road | Kingswood Road | Dudley | Dudley | Warning Letter | N/A | 52.4876186 | -2.175395 | ||
| 7777 | op-snap---monthly-publication-february-2026.pdf | 524 | 2026-02 | Pedestrian | Audi | A1.. | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monk Road | Monk Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4914132 | -1.8307035 | ||
| 7771 | op-snap---monthly-publication-february-2026.pdf | 518 | 2026-02 | Pedestrian | Audi | Q5 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Berwood Road | Berwood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5342947 | -1.8155375 | ||
| 7689 | op-snap---monthly-publication-february-2026.pdf | 436 | 2026-02 | Pedestrian | Audi | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Robin Hood lane | Robin Hood lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4221526 | -1.8425617 | |||
| 7645 | op-snap---monthly-publication-february-2026.pdf | 392 | 2026-02 | Pedestrian | Audi | RSQ8 | Black | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 7583 | op-snap---monthly-publication-february-2026.pdf | 330 | 2026-02 | Pedestrian | Audi | A4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Unknown Location | Unknown Location | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 7525 | op-snap---monthly-publication-february-2026.pdf | 272 | 2026-02 | Pedestrian | Audi | Spyder | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | ||
| 7449 | op-snap---monthly-publication-february-2026.pdf | 196 | 2026-02 | Pedestrian | Audi | Q2.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street | Wills Street | Birmingham | Birmingham | Warning Letter | N/A | 52.500453 | -1.9141126 | ||
| 7432 | op-snap---monthly-publication-february-2026.pdf | 179 | 2026-02 | Pedestrian | Audi | A5 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Gayfield Av | Gayfield Avenue | Metropolitan Borough of Dudley | Metropolitan Borough Of Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 7431 | op-snap---monthly-publication-february-2026.pdf | 178 | 2026-02 | Pedestrian | Audi | A4 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 7296 | op-snap---monthly-publication-february-2026.pdf | 43 | 2026-02 | Pedestrian | Audi | A3.. | Black | Cause vehicle to be left in a dangerous position | None | Ulverscroft Road | Ulverscroft Road | Coventry | Coventry | Education | N/A | 52.3913543 | -1.508629 | ||
| 11816 | op-snap---monthly-publication-january-2026.pdf | 1277 | 2026-01 | Pedestrian | Audi | A6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 11811 | op-snap---monthly-publication-january-2026.pdf | 1272 | 2026-01 | Pedestrian | Audi | Q4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 11801 | op-snap---monthly-publication-january-2026.pdf | 1262 | 2026-01 | Pedestrian | Audi | A5 | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11755 | op-snap---monthly-publication-january-2026.pdf | 1216 | 2026-01 | Pedestrian | Audi | Q2 | Grey | Driving without Due Care and Attention | None | Cotford Road | Cotford Road | Birmingham | Birmingham | Education | N/A | 52.4062317 | -1.8814294 | ||
| 11751 | op-snap---monthly-publication-january-2026.pdf | 1212 | 2026-01 | Pedestrian | Audi | A4 | Red | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 11738 | op-snap---monthly-publication-january-2026.pdf | 1199 | 2026-01 | Pedestrian | Audi | A1 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Drayton Road | Drayton Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4321165 | -1.8902667 | ||
| 11692 | op-snap---monthly-publication-january-2026.pdf | 1153 | 2026-01 | Pedestrian | Audi | A1 | Silver | Misc - Non Traffic Offences | Use vehicle on a road without valid test certificate | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 11581 | op-snap---monthly-publication-january-2026.pdf | 1042 | 2026-01 | Pedestrian | Audi | Q3 | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 11580 | op-snap---monthly-publication-january-2026.pdf | 1041 | 2026-01 | Pedestrian | Audi | Q8 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Berwood Road | Berwood Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5342947 | -1.8155375 | ||
| 11534 | op-snap---monthly-publication-january-2026.pdf | 995 | 2026-01 | Pedestrian | Audi | A3 | Grey | Cause vehicle to be left in a dangerous position | None | St Saviours Road | Street Saviours Road | Birmingham | Birmingham | Education | N/A | ||||
| 11506 | op-snap---monthly-publication-january-2026.pdf | 967 | 2026-01 | Pedestrian | Audi | A4 | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 11448 | op-snap---monthly-publication-january-2026.pdf | 909 | 2026-01 | Pedestrian | Audi | Q3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bells Lane | Bells Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4053419 | -1.8944602 | ||
| 11380 | op-snap---monthly-publication-january-2026.pdf | 841 | 2026-01 | Pedestrian | Audi | Q5 | Grey | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Education | N/A | 52.4324855 | -1.4815548 | ||
| 11297 | op-snap---monthly-publication-january-2026.pdf | 758 | 2026-01 | Pedestrian | Audi | A5 | Black | Stop a vehicle on pedestrian crossing | None | Oxford Street | Oxford Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4769326 | -1.8875782 | ||
| 11228 | op-snap---monthly-publication-january-2026.pdf | 689 | 2026-01 | Pedestrian | Audi | A5 | White | 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 | ||
| 11139 | op-snap---monthly-publication-january-2026.pdf | 600 | 2026-01 | Pedestrian | Audi | Q4 | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | The Oval School | The Oval School | Birmingham | Birmingham | Other Action Taken | N/A | 52.4801359 | -1.7963993 | ||
| 11133 | op-snap---monthly-publication-january-2026.pdf | 594 | 2026-01 | Pedestrian | Audi | A5 | White | Cause vehicle to be left in a dangerous position | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Education | N/A | ||||
| 11052 | op-snap---monthly-publication-january-2026.pdf | 513 | 2026-01 | Pedestrian | Audi | A5 | White | Using a Mobile Phone Whilst Driving | None | Silver Street | Silver Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.433129 | -1.8963794 | ||
| 11014 | op-snap---monthly-publication-january-2026.pdf | 475 | 2026-01 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Warning Letter | N/A | ||||
| 10988 | op-snap---monthly-publication-january-2026.pdf | 449 | 2026-01 | Pedestrian | Audi | A3 | Blue | Driving without Due Care and Attention | None | Boleyn Road | Boleyn Road | Birmingham | Birmingham | NFA | No Offence | 52.4030543 | -2.0296756 | ||
| 10974 | op-snap---monthly-publication-january-2026.pdf | 435 | 2026-01 | Pedestrian | Audi | Q3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wooten Road | Wooten Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 10942 | op-snap---monthly-publication-january-2026.pdf | 403 | 2026-01 | Pedestrian | Audi | Q3 | White | Cause vehicle to be left in a dangerous position | None | Greswole Road | Greswole Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 10906 | op-snap---monthly-publication-january-2026.pdf | 367 | 2026-01 | Pedestrian | Audi | A3 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Earlsdon Avenue | Earlsdon Avenue | Coventry | Coventry | Education | N/A | 52.4047134 | -1.5351834 | ||
| 10900 | op-snap---monthly-publication-january-2026.pdf | 361 | 2026-01 | Pedestrian | Audi | Q6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chestnut Close | Chestnut Close | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4531575 | -1.8221982 | ||
| 10893 | op-snap---monthly-publication-january-2026.pdf | 354 | 2026-01 | Pedestrian | Audi | A6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 10717 | op-snap---monthly-publication-january-2026.pdf | 178 | 2026-01 | Pedestrian | Audi | A1.. | Grey | Stop a vehicle on pedestrian crossing | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 10709 | op-snap---monthly-publication-january-2026.pdf | 170 | 2026-01 | Pedestrian | Audi | Q5.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barclay Road | Barclay Road | Sandwell | Sandwell | Other Action Taken | N/A | 52.4722765 | -1.9787531 | ||
| 10586 | op-snap---monthly-publication-january-2026.pdf | 47 | 2026-01 | Pedestrian | Audi | r8 | Black | Misc - Non Traffic Offences | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.473986 | -1.9147087 | ||
| 5143 | op-snap---monthly-publication-december-2025.pdf | 1271 | 2025-12 | Pedestrian | Audi | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Horsford Road West Mercia | Horsford Road West Mercia | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 5029 | op-snap---monthly-publication-december-2025.pdf | 1157 | 2025-12 | Pedestrian | Audi | q5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | barclay road | Barclay Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 5016 | op-snap---monthly-publication-december-2025.pdf | 1144 | 2025-12 | Pedestrian | Audi | r8 | Blue | Cause vehicle to be left in a dangerous position | None | drayton road | Drayton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4321165 | -1.8902667 | ||
| 5015 | op-snap---monthly-publication-december-2025.pdf | 1143 | 2025-12 | Pedestrian | Audi | rs4 | Blue | Cause vehicle to be left in a dangerous position | None | drayton road | Drayton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4321165 | -1.8902667 | ||
| 5011 | op-snap---monthly-publication-december-2025.pdf | 1139 | 2025-12 | Pedestrian | Audi | a4 | Grey | Cause vehicle to be left in a dangerous position | None | halesowne road | Halesowne Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4950 | op-snap---monthly-publication-december-2025.pdf | 1078 | 2025-12 | Pedestrian | Audi | a4 | Silver | Cause vehicle to be left in a dangerous position | None | poplar road | Poplar Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.436035 | -1.891685 | ||
| 4780 | op-snap---monthly-publication-december-2025.pdf | 908 | 2025-12 | Pedestrian | Audi | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Rd | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | |||
| 4697 | op-snap---monthly-publication-december-2025.pdf | 825 | 2025-12 | Pedestrian | Audi | q7 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 4671 | op-snap---monthly-publication-december-2025.pdf | 799 | 2025-12 | Pedestrian | Audi | A4 | Grey | Misc - Non Traffic Offences | None | M6 | M6 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4649 | op-snap---monthly-publication-december-2025.pdf | 777 | 2025-12 | Pedestrian | Audi | q2 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | shirley road | Shirley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4198291 | -1.9241732 | ||
| 4610 | op-snap---monthly-publication-december-2025.pdf | 738 | 2025-12 | Pedestrian | Audi | a3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 4592 | op-snap---monthly-publication-december-2025.pdf | 720 | 2025-12 | Pedestrian | Audi | s3 | Blue | Driving without Due Care and Attention | None | south parade | South Parade | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5618877 | -1.8226794 | ||
| 4577 | op-snap---monthly-publication-december-2025.pdf | 705 | 2025-12 | Pedestrian | Audi | A6 | Grey | Driving without Due Care and Attention | None | Golden Hillock Road | Golden Hillock Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4622646 | -1.8599985 | ||
| 4440 | op-snap---monthly-publication-december-2025.pdf | 568 | 2025-12 | Pedestrian | Audi | a4 | White | Misc - Non Traffic Offences | None | chilcote close | Chilcote Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4167178 | -1.8457291 | ||
| 4337 | op-snap---monthly-publication-december-2025.pdf | 465 | 2025-12 | Pedestrian | Audi | a4 | Black | Misc - Non Traffic Offences | None | regendt road | Regendt Road | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 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 | ||
| 4114 | op-snap---monthly-publication-december-2025.pdf | 242 | 2025-12 | Pedestrian | Audi | Q3 | Black | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Langbank Avenue | Langbank Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3903106 | -1.4556064 | ||
| 3979 | op-snap---monthly-publication-december-2025.pdf | 107 | 2025-12 | Pedestrian | Audi | q3 | Black | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 3947 | op-snap---monthly-publication-december-2025.pdf | 75 | 2025-12 | Pedestrian | Audi | Q7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyndon Road | Lyndon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5649901 | -1.8274858 | ||
| 22007 | op-snap---monthly-publication-november-2025.pdf | 1549 | 2025-11 | Pedestrian | Audi | A4 | Grey | Cause vehicle to be left in a dangerous position | None | Kingswood Road | Kingswood Road | Dudley | Dudley | Warning Letter | N/A | 52.4876186 | -2.175395 | ||
| 21991 | op-snap---monthly-publication-november-2025.pdf | 1533 | 2025-11 | Pedestrian | Audi | Q3 | Grey | Cause vehicle to be left in a dangerous position | None | Timberley Lane | Timberley Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4982049 | -1.7736502 | ||
| 21892 | op-snap---monthly-publication-november-2025.pdf | 1434 | 2025-11 | Pedestrian | Audi | a5 | Red | Misc - Non Traffic Offences | None | woodthorpe lane | Woodthorpe Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 21885 | op-snap---monthly-publication-november-2025.pdf | 1427 | 2025-11 | Pedestrian | Audi | q2 | Blue | Misc - Non Traffic Offences | None | beechwood road | Beechwood Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.5114235 | -2.0697761 | ||
| 21866 | op-snap---monthly-publication-november-2025.pdf | 1408 | 2025-11 | Pedestrian | Audi | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | wheelers lane | Wheelers Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4306504 | -1.878052 | |||
| 21846 | op-snap---monthly-publication-november-2025.pdf | 1388 | 2025-11 | Pedestrian | Audi | a1 | Black | Cause vehicle to be left in a dangerous position | None | Nursery road | Nursery road | Birmingham | Birmingham | Warning Letter | N/A | 52.4979836 | -1.9118163 | ||
| 21825 | op-snap---monthly-publication-november-2025.pdf | 1367 | 2025-11 | Pedestrian | Audi | a1 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | regent place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 21819 | op-snap---monthly-publication-november-2025.pdf | 1361 | 2025-11 | Pedestrian | Audi | q3 | Black | Cause vehicle to be left in a dangerous position | None | worcester close | Worcester Close | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5921575 | -1.8139344 | ||
| 21565 | op-snap---monthly-publication-november-2025.pdf | 1107 | 2025-11 | Pedestrian | Audi | A1 | Black | Using a Mobile Phone Whilst Driving | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4720132 | -1.9142946 | ||
| 21542 | op-snap---monthly-publication-november-2025.pdf | 1084 | 2025-11 | Pedestrian | Audi | a6 | Black | Misc - Non Traffic Offences | None | steelhouse lane | Steelhouse Lane | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.5810948 | -2.1178808 | ||
| 21502 | op-snap---monthly-publication-november-2025.pdf | 1044 | 2025-11 | Pedestrian | Audi | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | clarence road | Clarence Road | Dudley | Dudley | Warning Letter | N/A | 52.4974708 | -2.0777087 | |||
| 21485 | op-snap---monthly-publication-november-2025.pdf | 1027 | 2025-11 | Pedestrian | Audi | a3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | langley primary scholl | Langley Primary Scholl | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21483 | op-snap---monthly-publication-november-2025.pdf | 1025 | 2025-11 | Pedestrian | Audi | a3 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | langley primary school | Langley Primary School | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21370 | op-snap---monthly-publication-november-2025.pdf | 912 | 2025-11 | Pedestrian | Audi | Silver | Misc - Non Traffic Offences | None | fenton road | Fenton Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4331816 | -1.5630141 | |||
| 21357 | op-snap---monthly-publication-november-2025.pdf | 899 | 2025-11 | Pedestrian | Audi | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | antrobus road | Antrobus Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5457851 | -1.8457052 | |||
| 21347 | op-snap---monthly-publication-november-2025.pdf | 889 | 2025-11 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Rd | Street Bernards Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 21321 | op-snap---monthly-publication-november-2025.pdf | 863 | 2025-11 | Pedestrian | Audi | s3 | Grey | Cause vehicle to be left in a dangerous position | None | kings heath high street | Kings Heath High Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4391028 | -1.893289 | ||
| 21200 | op-snap---monthly-publication-november-2025.pdf | 742 | 2025-11 | Pedestrian | Audi | Q2 | 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 | ||
| 21181 | op-snap---monthly-publication-november-2025.pdf | 723 | 2025-11 | Pedestrian | Audi | A3 | 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 | ||
| 21135 | op-snap---monthly-publication-november-2025.pdf | 677 | 2025-11 | Pedestrian | Audi | RSQ8 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4456462 | -1.827993 | ||
| 21087 | op-snap---monthly-publication-november-2025.pdf | 629 | 2025-11 | Pedestrian | Audi | Q7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | White Farm road | White Farm road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5965459 | -1.8476527 | ||
| 21076 | op-snap---monthly-publication-november-2025.pdf | 618 | 2025-11 | Pedestrian | Audi | q3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | hill villiage road | Hill Village Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5959906 | -1.8345802 | ||
| 21023 | op-snap---monthly-publication-november-2025.pdf | 565 | 2025-11 | Pedestrian | Audi | RSQ3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High street, Tettenhall | High street, Tettenhall | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5980906 | -2.168057 | ||
| 20975 | op-snap---monthly-publication-november-2025.pdf | 517 | 2025-11 | Pedestrian | Audi | A6 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Jaffray Road | Jaffray Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5178114 | -1.8456833 | ||
| 20899 | op-snap---monthly-publication-november-2025.pdf | 441 | 2025-11 | Pedestrian | Audi | A5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Westley Road | Westley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4456462 | -1.827993 | ||
| 20897 | op-snap---monthly-publication-november-2025.pdf | 439 | 2025-11 | Pedestrian | Audi | A3 | Grey | Misc - Non Traffic Offences | None | Whittington Oval | Whittington Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4800782 | -1.7942034 | ||
| 20861 | op-snap---monthly-publication-november-2025.pdf | 403 | 2025-11 | Pedestrian | Audi | a3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | woodbridge road | Woodbridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4482076 | -1.8864335 | ||
| 20841 | op-snap---monthly-publication-november-2025.pdf | 383 | 2025-11 | Pedestrian | Audi | a1 | Blue | Cause vehicle to be left in a dangerous position | None | waterloo road | Waterloo Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4622159 | -1.8253401 |
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);