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'}
78 rows where council_area = "Birmingham" and 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, nfa_rationale
vehicle_make 24
month 14
disposal 7
- Fixed Penalty 30
- NFA 20
- Warning Letter 17
- Duplicate Submission 4
- Other Action Taken 4
- Court 2
- Education 1
reporter_transport_mode 5
- Pedestrian 28
- Car 24
- Other 23
- Pedal Bike 2
- car 1
offence 1
- Driving a vehicle wholly or partly on a footpath · 78 ✖
council_area 1
- Birmingham · 78 ✖
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 16872 | op-snap---monthly-publication-march-2025.pdf | 629 | 2025-03 | car | Renault | Master | Red | Driving a vehicle wholly or partly on a footpath | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.502683 | -1.9033516 | |
| 17112 | op-snap---monthly-publication-march-2025.pdf | 869 | 2025-03 | Car | Mitsubishi | Barbarian | Black | Driving a vehicle wholly or partly on a footpath | None | Reservoir Road | Reservoir Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5242452 | -1.8572541 | |
| 17710 | op-snap---monthly-publication-march-2025.pdf | 1467 | 2025-03 | Car | Mini | COOPER | Grey | Driving a vehicle wholly or partly on a footpath | No Insurance | STRATFORD ROAD | Stratford Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4203897 | -1.8338574 | |
| 17957 | op-snap---monthly-publication-march-2025.pdf | 1714 | 2025-03 | Pedestrian | Honda | Gullwing | Black | Driving a vehicle wholly or partly on a footpath | None | Valentine Road, Kings Heath | Valentine Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4381959 | -1.8907391 | |
| 18173 | op-snap---monthly-publication-march-2025.pdf | 1930 | 2025-03 | Pedestrian | Chevrolet | Cruze | Grey | Driving a vehicle wholly or partly on a footpath | None | School Road LTN | School Road LTN | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 18552 | op-snap---monthly-publication-march-2025.pdf | 2309 | 2025-03 | Pedestrian | Lexus | NX 350H | Black | Driving a vehicle wholly or partly on a footpath | None | Rea Street | Rea Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4734695 | -1.8890674 | |
| 18553 | op-snap---monthly-publication-march-2025.pdf | 2310 | 2025-03 | Pedestrian | Ford | BC15URH | Black | Driving a vehicle wholly or partly on a footpath | None | Rea Street | Rea Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4734695 | -1.8890674 | |
| 18555 | op-snap---monthly-publication-march-2025.pdf | 2312 | 2025-03 | Pedestrian | Toyota | Pirus | White | Driving a vehicle wholly or partly on a footpath | None | Rea Street | Rea Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4734695 | -1.8890674 | |
| 5202 | op-snap---monthly-publication-february-2025.pdf | 19 | 2025-02 | Pedestrian | Nissan | Juke | Black | Driving a vehicle wholly or partly on a footpath | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 5204 | op-snap---monthly-publication-february-2025.pdf | 21 | 2025-02 | Pedestrian | Ford | Fiesta | Black | Driving a vehicle wholly or partly on a footpath | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 6237 | op-snap---monthly-publication-february-2025.pdf | 1054 | 2025-02 | Other | Ford | Transit | Green | Driving a vehicle wholly or partly on a footpath | No Insurance | Friary Road | Friary Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | Yes - Via Email | 52.5162814 | -1.9395798 | |
| 6636 | op-snap---monthly-publication-february-2025.pdf | 1453 | 2025-02 | Pedestrian | Renault | Traffic | White | Driving a vehicle wholly or partly on a footpath | None | A4040 Linden Road at Franklin Road | Linden Road at Franklin Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4258654 | -1.9347755 | |
| 6821 | op-snap---monthly-publication-february-2025.pdf | 1638 | 2025-02 | Car | Vauxhall | CROSSLAND | Blue | Driving a vehicle wholly or partly on a footpath | None | OLD CHURCH ROAD | Old Church Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4529004 | -1.9554069 | |
| 6908 | op-snap---monthly-publication-february-2025.pdf | 1725 | 2025-02 | Pedestrian | Honda | M/C | White | Driving a vehicle wholly or partly on a footpath | None | Geranium Grove | Geranium Grove | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4836233 | -1.8425591 | |
| 6960 | op-snap---monthly-publication-february-2025.pdf | 1777 | 2025-02 | Other | Peugeot | Exert Tepee | White | Driving a vehicle wholly or partly on a footpath | None | Friary Road | Friary Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5162814 | -1.9395798 | |
| 9626 | op-snap---monthly-publication-january-2025.pdf | 734 | 2025-01 | Car | Toyota | Prius | Blue | Driving a vehicle wholly or partly on a footpath | None | Booth Street | Booth Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5039035 | -1.9447084 | |
| 9911 | op-snap---monthly-publication-january-2025.pdf | 1019 | 2025-01 | Car | Vauxhall | CORSA | Black | Driving a vehicle wholly or partly on a footpath | None | COVENTRY ROAD | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 |
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);