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'}
128 rows where offence = "Driving a vehicle wholly or partly on a footpath" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 27
month 14
council_area 10
- Birmingham 78
- Coventry 9
- Out of Force Area 8
- Wolverhampton 8
- Sandwell 6
- Sutton Coldfield 6
- Dudley 5
- Walsall 4
- Solihull 3
- Halesowen 1
disposal 7
- Fixed Penalty 48
- NFA 37
- Warning Letter 30
- Other Action Taken 5
- Duplicate Submission 4
- Court 2
- Education 2
reporter_transport_mode 5
- Pedestrian 47
- Car 41
- Other 31
- Pedal Bike 7
- car 2
offence 1
- Driving a vehicle wholly or partly on a footpath · 128 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7290 | op-snap---monthly-publication-february-2026.pdf | 37 | 2026-02 | Other | Mercedes-Benz | c class | Grey | Driving a vehicle wholly or partly on a footpath | None | kingstanding road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | ||
| 7362 | op-snap---monthly-publication-february-2026.pdf | 109 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5521118 | -1.8845138 | ||
| 7438 | op-snap---monthly-publication-february-2026.pdf | 185 | 2026-02 | Other | Mercedes-Benz | E220 | Black | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5521118 | -1.8845138 | ||
| 7479 | op-snap---monthly-publication-february-2026.pdf | 226 | 2026-02 | Other | Mercedes-Benz | E220 | Black | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5521118 | -1.8845138 | ||
| 7510 | op-snap---monthly-publication-february-2026.pdf | 257 | 2026-02 | Pedestrian | ssangyong | Blue | Driving a vehicle wholly or partly on a footpath | None | Causeway Green Road | Causeway Green Road | Sandwell | Sandwell | Warning Letter | N/A | 52.4831146 | -2.0169818 | |||
| 7610 | op-snap---monthly-publication-february-2026.pdf | 357 | 2026-02 | Car | Skoda | Fabia | Black | Driving a vehicle wholly or partly on a footpath | None | Princess Way Blackpool. | Princess Way Blackpool | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7657 | op-snap---monthly-publication-february-2026.pdf | 404 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | ||
| 7659 | op-snap---monthly-publication-february-2026.pdf | 406 | 2026-02 | Other | Nissan | Qashqai | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 7660 | op-snap---monthly-publication-february-2026.pdf | 407 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Duplicate Submission | Duplicate Submission | 52.5521118 | -1.8845138 | ||
| 7668 | op-snap---monthly-publication-february-2026.pdf | 415 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 7704 | op-snap---monthly-publication-february-2026.pdf | 451 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 7719 | op-snap---monthly-publication-february-2026.pdf | 466 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5521118 | -1.8845138 | ||
| 7728 | op-snap---monthly-publication-february-2026.pdf | 475 | 2026-02 | Other | Mercedes-Benz | E-class | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | ||
| 7791 | op-snap---monthly-publication-february-2026.pdf | 538 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5521118 | -1.8845138 | ||
| 7842 | op-snap---monthly-publication-february-2026.pdf | 589 | 2026-02 | Other | Mercedes-Benz | E220 | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.5521118 | -1.8845138 | ||
| 8217 | op-snap---monthly-publication-february-2026.pdf | 964 | 2026-02 | Car | Mercedes-Benz | C200.. | Grey | Driving a vehicle wholly or partly on a footpath | None | Washwood Heath Road at Drews Lane. | Washwood Heath Road at Drews Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4949047 | -1.8544884 | ||
| 8222 | op-snap---monthly-publication-february-2026.pdf | 969 | 2026-02 | Car | Peugeot | Bipper | White | Driving a vehicle wholly or partly on a footpath | None | Falmouth, Cornwall | Falmouth, Cornwall | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8304 | op-snap---monthly-publication-february-2026.pdf | 1051 | 2026-02 | Pedestrian | Jaguar | F Pace | Black | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane | Highters Heath Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4100972 | -1.8742772 | ||
| 8317 | op-snap---monthly-publication-february-2026.pdf | 1064 | 2026-02 | Other | Ford | Transit | White | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane. | Highters Heath Lane | Birmingham | Birmingham | NFA | No VRM | 52.4100972 | -1.8742772 | ||
| 8340 | op-snap---monthly-publication-february-2026.pdf | 1087 | 2026-02 | Other | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane | Highters Heath Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4100972 | -1.8742772 | |||||
| 8345 | op-snap---monthly-publication-february-2026.pdf | 1092 | 2026-02 | Other | Kia | Sportage | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.5521118 | -1.8845138 | ||
| 8770 | op-snap---monthly-publication-february-2026.pdf | 1517 | 2026-02 | Car | Land Rover | discovery | Black | Driving a vehicle wholly or partly on a footpath | None | Hollyfield Road | Hollyfield Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5620486 | -1.8030784 | ||
| 10712 | op-snap---monthly-publication-january-2026.pdf | 173 | 2026-01 | Other | Mercedes-Benz | Grey | Driving a vehicle wholly or partly on a footpath | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5521118 | -1.8845138 | |||
| 10755 | op-snap---monthly-publication-january-2026.pdf | 216 | 2026-01 | Pedestrian | Peugeot | 3008 | Blue | Driving a vehicle wholly or partly on a footpath | None | Bromley Lane | Bromley Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4893583 | -2.1529025 | ||
| 11174 | op-snap---monthly-publication-january-2026.pdf | 635 | 2026-01 | Pedestrian | Toyota | Prius | Grey | Driving a vehicle wholly or partly on a footpath | None | Lichfield Road Mere Green | Lichfield Road Mere Green | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5872149 | -1.8300386 | ||
| 11661 | op-snap---monthly-publication-january-2026.pdf | 1122 | 2026-01 | Pedestrian | Ford | Focus | Green | Driving a vehicle wholly or partly on a footpath | None | Clay Lane | Clay Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4509038 | -1.8083784 | ||
| 11667 | op-snap---monthly-publication-january-2026.pdf | 1128 | 2026-01 | Pedestrian | Toyota | Auris | Silver | Driving a vehicle wholly or partly on a footpath | None | Maypole Lane | Maypole Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4046925 | -1.8764112 | ||
| 11689 | op-snap---monthly-publication-january-2026.pdf | 1150 | 2026-01 | Car | Audi | A3.. | Grey | Driving a vehicle wholly or partly on a footpath | None | Granville Street | Granville Street | Birmingham | Birmingham | Court | N/A | 52.4762076 | -1.9124263 | ||
| 11925 | op-snap---monthly-publication-january-2026.pdf | 1386 | 2026-01 | Other | Mercedes-Benz | c class | Grey | Driving a vehicle wholly or partly on a footpath | None | kingstanding road | Kingstanding Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 4792 | op-snap---monthly-publication-december-2025.pdf | 920 | 2025-12 | Pedestrian | Honda | WW 125 | Grey | Driving a vehicle wholly or partly on a footpath | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4216321 | -1.855984 | ||
| 4834 | op-snap---monthly-publication-december-2025.pdf | 962 | 2025-12 | Car | Volvo | V40 | White | Driving a vehicle wholly or partly on a footpath | None | Wobaston Road | Wobaston Road | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.628768 | -2.1306154 | ||
| 4924 | op-snap---monthly-publication-december-2025.pdf | 1052 | 2025-12 | Pedestrian | Ford | B-Max | Silver | Driving a vehicle wholly or partly on a footpath | None | Conybere Street | Conybere Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4659206 | -1.8894973 | ||
| 20681 | op-snap---monthly-publication-november-2025.pdf | 223 | 2025-11 | Other | Ford | Fiesta | Silver | Driving a vehicle wholly or partly on a footpath | None | West Morland Road | West Morland Road | Coventry | Coventry | Warning Letter | N/A | ||||
| 20752 | op-snap---monthly-publication-november-2025.pdf | 294 | 2025-11 | Car | Audi | A6 | Black | Driving a vehicle wholly or partly on a footpath | None | Reservoir Road | Reservoir Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5242452 | -1.8572541 | ||
| 21534 | op-snap---monthly-publication-november-2025.pdf | 1076 | 2025-11 | Pedestrian | Land Rover | Defender | Green | Driving a vehicle wholly or partly on a footpath | None | Kings Heath High Street, Alcester Road | Kings Heath High Street, Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 22085 | op-snap---monthly-publication-october-2025.pdf | 35 | 2025-10 | Pedal Bike | Mg | HS | White | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 22086 | op-snap---monthly-publication-october-2025.pdf | 36 | 2025-10 | Pedal Bike | Hyundai | Ioniq | Grey | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 22087 | op-snap---monthly-publication-october-2025.pdf | 37 | 2025-10 | Pedal Bike | Nissan | X-Trail | Black | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6083917 | -2.1033365 | ||
| 22182 | op-snap---monthly-publication-october-2025.pdf | 132 | 2025-10 | Car | Bajaj | Black | Driving a vehicle wholly or partly on a footpath | None | Oxford Road | Oxford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4456323 | -1.8858352 | |||
| 22339 | op-snap---monthly-publication-october-2025.pdf | 289 | 2025-10 | Car | Ford | Transit | Blue | Driving a vehicle wholly or partly on a footpath | None | South Road Wollaston | South Road Wollaston | Dudley | Dudley | Warning Letter | N/A | 52.4520277 | -2.1653372 | ||
| 22861 | op-snap---monthly-publication-october-2025.pdf | 811 | 2025-10 | Pedal Bike | Mg | Trophy | White | Driving a vehicle wholly or partly on a footpath | None | Clevedon Road | Clevedon Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4618531 | -1.894645 | ||
| 22961 | op-snap---monthly-publication-october-2025.pdf | 911 | 2025-10 | Car | Volkswagen | Golf | Grey | Driving a vehicle wholly or partly on a footpath | None | Bridgeman Street | Bridgeman Street | Walsall | Walsall | Warning Letter | N/A | 52.583034 | -1.9839161 | ||
| 22965 | op-snap---monthly-publication-october-2025.pdf | 915 | 2025-10 | Pedestrian | KTM | Orange | Driving a vehicle wholly or partly on a footpath | None | Northycote Lane | Northycote Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6340387 | -2.1102234 | |||
| 23004 | op-snap---monthly-publication-october-2025.pdf | 954 | 2025-10 | Pedestrian | Audi | A1 | Black | Driving a vehicle wholly or partly on a footpath | None | Clifford Bridge Road | Clifford Bridge Road | Coventry | Coventry | Other Action Taken | N/A | 52.4134557 | -1.4442138 | ||
| 23015 | op-snap---monthly-publication-october-2025.pdf | 965 | 2025-10 | Pedestrian | Mercedes-Benz | Vito | White | Driving a vehicle wholly or partly on a footpath | None | Braces Lane | Braces Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23851 | op-snap---monthly-publication-september-2025.pdf | 70 | 2025-09 | Pedestrian | Yamaha | 125 | Blue | Driving a vehicle wholly or partly on a footpath | None | Cotteridge Park | Cotteridge Park | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4214441 | -1.928416 | ||
| 24002 | op-snap---monthly-publication-september-2025.pdf | 221 | 2025-09 | Car | Kia | Xceed | Silver | Driving a vehicle wholly or partly on a footpath | None | Oxford Road | Oxford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4456323 | -1.8858352 | ||
| 24069 | op-snap---monthly-publication-september-2025.pdf | 288 | 2025-09 | Car | Citroen | C2 | Black | Driving a vehicle wholly or partly on a footpath | None | Hill Top, West Bromwich | Hill Top, West Bromwich | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5389478 | -2.0112156 | ||
| 24241 | op-snap---monthly-publication-september-2025.pdf | 460 | 2025-09 | Pedestrian | Mercedes-Benz | SLK 200 | Black | Driving a vehicle wholly or partly on a footpath | None | Tenbury Road Kings Heath | Tenbury Road Kings Heath | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4264041 | -1.8966768 | ||
| 24271 | op-snap---monthly-publication-september-2025.pdf | 490 | 2025-09 | Car | Citroen | C3 | Black | Driving a vehicle wholly or partly on a footpath | None | Grove Lane, Handsworth | Grove Lane, Handsworth | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5094412 | -1.9304582 | ||
| 24273 | op-snap---monthly-publication-september-2025.pdf | 492 | 2025-09 | Car | Mercedes-Benz | Sprinter | Blue | Driving a vehicle wholly or partly on a footpath | None | A41 Birmingham Road | Birmingham Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5461417 | -1.9334193 | ||
| 24409 | op-snap---monthly-publication-september-2025.pdf | 628 | 2025-09 | Pedestrian | Vauxhall | Corsa | Black | Driving a vehicle wholly or partly on a footpath | None | Marsh Lane | Marsh Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.527277 | -1.8519677 | ||
| 24502 | op-snap---monthly-publication-september-2025.pdf | 721 | 2025-09 | Car | Citroen | C1 | Red | Driving a vehicle wholly or partly on a footpath | None | South Road, Northfield | South Road, Northfield | Birmingham | Birmingham | Education | N/A | 52.4074768 | -1.9720667 | ||
| 24557 | op-snap---monthly-publication-september-2025.pdf | 776 | 2025-09 | Car | Toyota | Auris | Blue | Driving a vehicle wholly or partly on a footpath | None | Marsh Lane | Marsh Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.527277 | -1.8519677 | ||
| 24558 | op-snap---monthly-publication-september-2025.pdf | 777 | 2025-09 | Car | Citroen | C3 | Black | Driving a vehicle wholly or partly on a footpath | None | Marsh Lane | Marsh Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.527277 | -1.8519677 | ||
| 24806 | op-snap---monthly-publication-september-2025.pdf | 1025 | 2025-09 | Car | Toyota | Prius | Brown | Driving a vehicle wholly or partly on a footpath | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5083238 | -1.8332287 | ||
| 24811 | op-snap---monthly-publication-september-2025.pdf | 1030 | 2025-09 | Pedal Bike | Mercedes-Benz | Sprinter | White | Driving a vehicle wholly or partly on a footpath | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4468506 | -1.9395619 | ||
| 24823 | op-snap---monthly-publication-september-2025.pdf | 1042 | 2025-09 | Other | Nissan | Note | Red | Driving a vehicle wholly or partly on a footpath | None | Empire Road, Tile Hill | Empire Road, Tile Hill | Coventry | Coventry | Warning Letter | N/A | 52.4073518 | -1.5831621 | ||
| 24878 | op-snap---monthly-publication-september-2025.pdf | 1097 | 2025-09 | Pedestrian | Yamaha | Black | Driving a vehicle wholly or partly on a footpath | None | Langley Walk | Langley Walk | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4723508 | -1.9072403 | |||
| 24942 | op-snap---monthly-publication-september-2025.pdf | 1161 | 2025-09 | Car | Volkswagen | Polo | Silver | Driving a vehicle wholly or partly on a footpath | None | Raddlebarn Road | Raddlebarn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4397168 | -1.9260414 | ||
| 2070 | op-snap---monthly-publication-august-2025.pdf | 45 | 2025-08 | Pedal Bike | Byd | Bus | Grey | Driving a vehicle wholly or partly on a footpath | None | Loda Lane | Loda Lane | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 2073 | op-snap---monthly-publication-august-2025.pdf | 48 | 2025-08 | Car | UK | Silver | Driving a vehicle wholly or partly on a footpath | None | Longford Road | Longford Road | Coventry | Coventry | NFA | Not in Public Interest | 52.445164 | -1.4879298 | |||
| 2374 | op-snap---monthly-publication-august-2025.pdf | 349 | 2025-08 | Other | motorbike | black | Driving a vehicle wholly or partly on a footpath | None | Hollingberry Lane | Hollingberry Lane | Sutton Coldfield | Sutton Coldfield | NFA | No VRM | 52.5545601 | -1.8009691 | |||
| 2771 | op-snap---monthly-publication-august-2025.pdf | 746 | 2025-08 | Other | Quad | Blue | Driving a vehicle wholly or partly on a footpath | None | Hatchford Walk | Hatchford Walk | Solihull | Solihull | NFA | No VRM | 52.4726612 | -1.7349637 | |||
| 2821 | op-snap---monthly-publication-august-2025.pdf | 796 | 2025-08 | Car | Peugeot | 2008 | White | Driving a vehicle wholly or partly on a footpath | None | Anchorage Road | Anchorage Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5699381 | -1.8249539 | ||
| 3081 | op-snap---monthly-publication-august-2025.pdf | 1056 | 2025-08 | Car | Vauxhall | Insignia | Grey | Driving a vehicle wholly or partly on a footpath | None | Cannock Road | Cannock Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6083917 | -2.1033365 | ||
| 3151 | op-snap---monthly-publication-august-2025.pdf | 1126 | 2025-08 | Car | Seat | Ibiza | Blue | Driving a vehicle wholly or partly on a footpath | None | Church Hill | Church Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4112239 | -1.9643143 | ||
| 12101 | op-snap---monthly-publication-july-2025.pdf | 153 | 2025-07 | Car | Hyundai | I40 | Black | Driving a vehicle wholly or partly on a footpath | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 12805 | op-snap---monthly-publication-july-2025.pdf | 857 | 2025-07 | car | Renault | trucks | Orange | Driving a vehicle wholly or partly on a footpath | None | Green Lanes | Green Lanes | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5375034 | -1.8313115 | ||
| 12855 | op-snap---monthly-publication-july-2025.pdf | 907 | 2025-07 | Car | Ford | Fiesat | Silver | Driving a vehicle wholly or partly on a footpath | None | Holbrook Lane | Holbrook Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.436155 | -1.5064002 | ||
| 13117 | op-snap---monthly-publication-july-2025.pdf | 1169 | 2025-07 | Car | Ford | transit | Silver | Driving a vehicle wholly or partly on a footpath | None | Coppice Lane | Coppice Lane | Dudley | Dudley | Fixed Penalty | N/A | 52.4781025 | -2.098027 | ||
| 13185 | op-snap---monthly-publication-july-2025.pdf | 1237 | 2025-07 | Car | Ford | transit | White | Driving a vehicle wholly or partly on a footpath | None | High Street | High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5254588 | -1.8373064 | ||
| 13186 | op-snap---monthly-publication-july-2025.pdf | 1238 | 2025-07 | Other | Peugeot | Partner | White | Driving a vehicle wholly or partly on a footpath | None | High Street Princes End Tipton | High Street Princes End Tipton | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5437324 | -2.0596147 | ||
| 13219 | op-snap---monthly-publication-july-2025.pdf | 1271 | 2025-07 | Other | Toyota | Prius | White | Driving a vehicle wholly or partly on a footpath | None | High Street Princes End | High Street Princes End | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5437324 | -2.0596147 | ||
| 13236 | op-snap---monthly-publication-july-2025.pdf | 1288 | 2025-07 | Car | Yamaha | XP500 | Grey | Driving a vehicle wholly or partly on a footpath | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 13239 | op-snap---monthly-publication-july-2025.pdf | 1291 | 2025-07 | Other | Audi | A4 | Blue | Driving a vehicle wholly or partly on a footpath | None | Tedstone Road | Tedstone Road | Birmingham | Birmingham | NFA | No Offence | 52.4568414 | -1.9826577 | ||
| 13993 | op-snap---monthly-publication-july-2025.pdf | 2045 | 2025-07 | Car | Nissan | Juke | White | Driving a vehicle wholly or partly on a footpath | None | High street, princes end | High street, princes end | Dudley | Dudley | Warning Letter | N/A | 52.5260689 | -2.0738642 | ||
| 15081 | op-snap---monthly-publication-june-2025.pdf | 1010 | 2025-06 | Other | Audi | Black | Driving a vehicle wholly or partly on a footpath | None | Fir Tree Road | Fir Tree Road | Walsall | Walsall | NFA | No Independent Evidence Available | |||||
| 15152 | op-snap---monthly-publication-june-2025.pdf | 1081 | 2025-06 | Other | BMW | X2 | Black | Driving a vehicle wholly or partly on a footpath | None | Valbourne Road | Valbourne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4165707 | -1.9062691 | ||
| 15176 | op-snap---monthly-publication-june-2025.pdf | 1105 | 2025-06 | Pedestrian | Peugeot | Partner | White | Driving a vehicle wholly or partly on a footpath | None | Allesley Hall Drive | Allesley Hall Drive | Coventry | Coventry | Warning Letter | N/A | 52.4177276 | -1.5557037 | ||
| 15552 | op-snap---monthly-publication-june-2025.pdf | 1481 | 2025-06 | Car | Land Rover | Grey | Driving a vehicle wholly or partly on a footpath | None | Boucher Street | Boucher Street | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 15595 | op-snap---monthly-publication-june-2025.pdf | 1524 | 2025-06 | Car | Nissan | Micra | Blue | Driving a vehicle wholly or partly on a footpath | None | Howard Road | Howard Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5154198 | -1.9135452 | ||
| 15611 | op-snap---monthly-publication-june-2025.pdf | 1540 | 2025-06 | Car | Peugeot | 207 | Grey | Driving a vehicle wholly or partly on a footpath | None | Coleshill Road | Coleshill Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5613155 | -1.8139826 | ||
| 19237 | op-snap---monthly-publication-may-2025.pdf | 599 | 2025-05 | Car | Motorcycle | Grey | Driving a vehicle wholly or partly on a footpath | None | Highters Heath Lane | Highters Heath Lane | Birmingham | Birmingham | Other Action Taken | nN/A | 52.4100972 | -1.8742772 | |||
| 19950 | op-snap---monthly-publication-may-2025.pdf | 1312 | 2025-05 | Pedestrian | Seat | NP | White | Driving a vehicle wholly or partly on a footpath | None | Kings heath high street | Kings heath high street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4391028 | -1.893289 | ||
| 19951 | op-snap---monthly-publication-may-2025.pdf | 1313 | 2025-05 | Pedestrian | Mercedes-Benz | NP | Silver | Driving a vehicle wholly or partly on a footpath | None | Alcester Road , Birmingham | Alcester Road , Birmingham | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.452635 | -1.8874738 | ||
| 19996 | op-snap---monthly-publication-may-2025.pdf | 1358 | 2025-05 | Pedestrian | BMW | NP | Black | Driving a vehicle wholly or partly on a footpath | None | A435 | A435 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 20155 | op-snap---monthly-publication-may-2025.pdf | 1517 | 2025-05 | Pedestrian | Toyota | Yaris | Silver | Driving a vehicle wholly or partly on a footpath | None | Dog Kennel Lane | Dog Kennel Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.4901007 | -1.9986317 | ||
| 20157 | op-snap---monthly-publication-may-2025.pdf | 1519 | 2025-05 | Pedestrian | DB11 | White | Driving a vehicle wholly or partly on a footpath | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Warning Letter | N/A | 52.4656414 | -1.9852276 | |||
| 50 | op-snap---monthly-publication-april-2025.pdf | 49 | 2025-04 | Pedestrian | Volkswagen | Golf | White | Driving a vehicle wholly or partly on a footpath | None | Windsor Street South | Windsor Street South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4850068 | -1.8801252 | ||
| 190 | op-snap---monthly-publication-april-2025.pdf | 189 | 2025-04 | Other | Volkswagen | Crafter | Red | Driving a vehicle wholly or partly on a footpath | None | Smallbrook Queensway | Smallbrook Queensway | Birmingham | Birmingham | NFA | No Offence | 52.4772584 | -1.8965734 | ||
| 196 | op-snap---monthly-publication-april-2025.pdf | 195 | 2025-04 | Car | Suzuki | Alto.. | Red | Driving a vehicle wholly or partly on a footpath | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 1540 | op-snap---monthly-publication-april-2025.pdf | 1539 | 2025-04 | Pedestrian | Mercedes-Benz | NP | White | Driving a vehicle wholly or partly on a footpath | None | Grange road, kings heath | Grange road, kings heath | Birmingham | Birmingham | NFA | Outside of 14 DAYS NIP | 52.4365305 | -1.8936456 | ||
| 1583 | op-snap---monthly-publication-april-2025.pdf | 1582 | 2025-04 | Pedestrian | Mercedes-Benz | NP | Black | Driving a vehicle wholly or partly on a footpath | None | HARE AND HOUNDS, HIGH STREET KINGS HEATH | Hare And Hounds, High Street Kings Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4346757 | -1.8929687 | ||
| 1652 | op-snap---monthly-publication-april-2025.pdf | 1651 | 2025-04 | Pedestrian | Ford | Fiesta | Blue | Driving a vehicle wholly or partly on a footpath | None | Barnfield Avenue | Barnfield Avenue | Coventry | Coventry | NFA | Outside of 14 DAYs NIP | 52.4261207 | -1.5659557 | ||
| 1674 | op-snap---monthly-publication-april-2025.pdf | 1673 | 2025-04 | Pedestrian | Toyota | NP | Blue | Driving a vehicle wholly or partly on a footpath | None | Turners Lane , Brierley Hill | Turners Lane , Brierley Hill | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4721372 | -2.1243522 | ||
| 16391 | op-snap---monthly-publication-march-2025.pdf | 148 | 2025-03 | Pedestrian | Moped | Grey | Driving a vehicle wholly or partly on a footpath | None | Edbaston Reservoir | Edbaston Reservoir | Birmingham | Birmingham | Other Action Taken | N/A | Yes - Via Email | ||||
| 16392 | op-snap---monthly-publication-march-2025.pdf | 149 | 2025-03 | Pedestrian | Aprilla SR 50 | Blue | Driving a vehicle wholly or partly on a footpath | None | Edbaston Reservoir | Edbaston Reservoir | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | ||||
| 16570 | op-snap---monthly-publication-march-2025.pdf | 327 | 2025-03 | Pedestrian | M/Cycle | White | Driving a vehicle wholly or partly on a footpath | None | Daw End Lane | Daw End Lane | Walsall | Walsall | NFA | No VRM | Yes - Via Email | 52.6068849 | -1.9611652 | ||
| 16651 | op-snap---monthly-publication-march-2025.pdf | 408 | 2025-03 | Pedestrian | Ford | Transit | Grey | Driving a vehicle wholly or partly on a footpath | No vehicle excise licence | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | Fixed Penalty | N/A | Yes - Via Email | 52.4167172 | -1.7990388 |
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);