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'}
410 rows where council_area = "Birmingham", reporter_transport_mode = "Pedestrian" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 25
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 191
- Cause vehicle to be left in a dangerous position 88
- Stop a vehicle within pelican pedestrian crossing limits 22
- Driving without Due Care and Attention 17
- Misc - Non Traffic Offences 17
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 15
- Cause unnecessary obstruction by motor vehicle 11
- Using a Mobile Phone Whilst Driving 8
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 7
- Contravening a Red Traffic Light 6
- Stop a vehicle on pedestrian crossing 5
- Driving a vehicle wholly or partly on a footpath 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- Driving without Reasonable Consideration 2
- No Insurance 2
- Use vehicle on a road without valid test certificate 2
- VRM fails to conform to Regulations 2
- / trailer outside of the Greater London area 1
- Drive a vehicle on common land 1
- Duplicate Submission 1
- Fail to display front VRM plate 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 1
- No Seat Belt 1
- Person in charge cause veh / trailer to be left to involve danger to road user 1
month 14
disposal 6
- Warning Letter 166
- Fixed Penalty 112
- NFA 104
- Education 24
- Court 3
- Other Action Taken 1
vehicle_make 1
- Ford · 410 ✖
reporter_transport_mode 1
- Pedestrian · 410 ✖
council_area 1
- Birmingham · 410 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7320 | op-snap---monthly-publication-february-2026.pdf | 67 | 2026-02 | Pedestrian | Ford | S-Max | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 7406 | op-snap---monthly-publication-february-2026.pdf | 153 | 2026-02 | Pedestrian | Ford | Transit | White | Stop a vehicle on pedestrian crossing | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 7428 | op-snap---monthly-publication-february-2026.pdf | 175 | 2026-02 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Twford Road | Twford Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7469 | op-snap---monthly-publication-february-2026.pdf | 216 | 2026-02 | Pedestrian | Ford | C Maxx | 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 | ||||
| 7483 | op-snap---monthly-publication-february-2026.pdf | 230 | 2026-02 | Pedestrian | Ford | Ecosport | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tividale Hall Road | Tividale Hall Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7511 | op-snap---monthly-publication-february-2026.pdf | 258 | 2026-02 | Pedestrian | Ford | Tourneo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cubley Road | Cubley Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.43878 | -1.8509412 | ||
| 7530 | op-snap---monthly-publication-february-2026.pdf | 277 | 2026-02 | Pedestrian | Ford | Fiesta | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Yardley Green Road | Yardley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4764154 | -1.8311418 | ||
| 7598 | op-snap---monthly-publication-february-2026.pdf | 345 | 2026-02 | Pedestrian | Ford | Fiesta | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7706 | op-snap---monthly-publication-february-2026.pdf | 453 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friary Road | Friary Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5162814 | -1.9395798 | ||
| 7737 | op-snap---monthly-publication-february-2026.pdf | 484 | 2026-02 | Pedestrian | Ford | Transit | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 7800 | op-snap---monthly-publication-february-2026.pdf | 547 | 2026-02 | Pedestrian | Ford | Transit van | White | Cause vehicle to be left in a dangerous position | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Education | N/A | 52.513857 | -1.9367367 | ||
| 7850 | op-snap---monthly-publication-february-2026.pdf | 597 | 2026-02 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7883 | op-snap---monthly-publication-february-2026.pdf | 630 | 2026-02 | Pedestrian | Ford | Transit | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Tiverton Road | Tiverton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4400034 | -1.9295885 | ||
| 7903 | op-snap---monthly-publication-february-2026.pdf | 650 | 2026-02 | Pedestrian | Ford | B Max | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Montgomery Street | Montgomery Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4644472 | -1.8668879 | ||
| 7914 | op-snap---monthly-publication-february-2026.pdf | 661 | 2026-02 | Pedestrian | Ford | Focus | Black | Driving without Due Care and Attention | None | Wedgewood Road | Wedgewood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4560365 | -1.9936623 | ||
| 8127 | op-snap---monthly-publication-february-2026.pdf | 874 | 2026-02 | Pedestrian | Ford | Tourneo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cubley Road | Cubley Road | Birmingham | Birmingham | NFA | No Offence | 52.43878 | -1.8509412 | ||
| 8180 | op-snap---monthly-publication-february-2026.pdf | 927 | 2026-02 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road | York Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5231321 | -1.8415573 | ||
| 8287 | op-snap---monthly-publication-february-2026.pdf | 1034 | 2026-02 | Pedestrian | Ford | Focus | Silver | Cause vehicle to be left in a dangerous position | None | Burbury Street | Burbury Street | Birmingham | Birmingham | Education | N/A | 52.5010617 | -1.9095433 | ||
| 8292 | op-snap---monthly-publication-february-2026.pdf | 1039 | 2026-02 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513857 | -1.9367367 | ||
| 8293 | op-snap---monthly-publication-february-2026.pdf | 1040 | 2026-02 | Pedestrian | Ford | B-Max | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513857 | -1.9367367 | ||
| 8342 | op-snap---monthly-publication-february-2026.pdf | 1089 | 2026-02 | Pedestrian | Ford | Etransit | White | Using a Mobile Phone Whilst Driving | None | Woodleigh Avenue | Woodleigh Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4501564 | -1.9468853 | ||
| 8413 | op-snap---monthly-publication-february-2026.pdf | 1160 | 2026-02 | Pedestrian | Ford | Focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monica Road at Kings Cliff Road | Monica Road at Kings Cliff Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4714936 | -1.8386654 | ||
| 8609 | op-snap---monthly-publication-february-2026.pdf | 1356 | 2026-02 | Pedestrian | Ford | Fiesta | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Warple Road | Warple Road | Birmingham | Birmingham | Warning Letter | N/A | 52.457865 | -2.000085 | ||
| 8621 | op-snap---monthly-publication-february-2026.pdf | 1368 | 2026-02 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | willis street | Willis Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8639 | op-snap---monthly-publication-february-2026.pdf | 1386 | 2026-02 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | berwood | Berwood | Birmingham | Birmingham | Warning Letter | N/A | 52.5314135 | -1.8193863 | ||
| 8831 | op-snap---monthly-publication-february-2026.pdf | 1578 | 2026-02 | Pedestrian | Ford | fiesta | Grey | VRM fails to conform to Regulations | None | egghill road | Egghill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.408976 | -2.0002999 | ||
| 8858 | op-snap---monthly-publication-february-2026.pdf | 1605 | 2026-02 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dyas road | Dyas Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5424796 | -1.8885732 | ||
| 8860 | op-snap---monthly-publication-february-2026.pdf | 1607 | 2026-02 | Pedestrian | Ford | Kuga | 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 | ||
| 10658 | op-snap---monthly-publication-january-2026.pdf | 119 | 2026-01 | Pedestrian | Ford | transit | Red | Cause vehicle to be left in a dangerous position | None | soho road | Soho Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502568 | -1.9305447 | ||
| 10674 | op-snap---monthly-publication-january-2026.pdf | 135 | 2026-01 | Pedestrian | Ford | ecosport | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | broad meadow lane | Broad Meadow Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.410787 | -1.918202 | ||
| 10934 | op-snap---monthly-publication-january-2026.pdf | 395 | 2026-01 | Pedestrian | Ford | Focus | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 11041 | op-snap---monthly-publication-january-2026.pdf | 502 | 2026-01 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kings Heath | Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4388601 | -1.8936667 | ||
| 11107 | op-snap---monthly-publication-january-2026.pdf | 568 | 2026-01 | Pedestrian | Ford | C Max | Grey | Cause vehicle to be left in a dangerous position | none | Bilbrook Grove | Bilbrook Grove | Birmingham | Birmingham | Education | N/A | 52.4411759 | -1.9734441 | ||
| 11152 | op-snap---monthly-publication-january-2026.pdf | 613 | 2026-01 | Pedestrian | Ford | Focus | White | Cause vehicle to be left in a dangerous position | None | Nursery Road | Nursery Road | Birmingham | Birmingham | Education | N/A | 52.4979836 | -1.9118163 | ||
| 11154 | op-snap---monthly-publication-january-2026.pdf | 615 | 2026-01 | Pedestrian | Ford | Mondeo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Nursery Road | Nursery Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4979836 | -1.9118163 | ||
| 11158 | op-snap---monthly-publication-january-2026.pdf | 619 | 2026-01 | Pedestrian | Ford | B-max | Blue | Cause vehicle to be left in a dangerous position | None | Nursery Road, Hockley | Nursery Road, Hockley | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5008517 | -1.9238292 | ||
| 11257 | op-snap---monthly-publication-january-2026.pdf | 718 | 2026-01 | Pedestrian | Ford | Focus | Blue | Misc - Non Traffic Offences | None | Freer Road | Freer Road | Birmingham | Birmingham | NFA | No Offence | 52.5074462 | -1.8979307 | ||
| 11343 | op-snap---monthly-publication-january-2026.pdf | 804 | 2026-01 | Pedestrian | Ford | Fiesta | Blue | Cause vehicle to be left in a dangerous position | None | Hobmoor Road | Hobmoor Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4709249 | -1.8295416 | ||
| 11359 | op-snap---monthly-publication-january-2026.pdf | 820 | 2026-01 | Pedestrian | Ford | S Max | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Portman Road | Portman Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4306424 | -1.8844833 | ||
| 11474 | op-snap---monthly-publication-january-2026.pdf | 935 | 2026-01 | Pedestrian | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wills Street, Lozells | Wills Street, Lozells | Birmingham | Birmingham | Fixed Penalty | N/A | 52.500453 | -1.9141126 | ||
| 11546 | op-snap---monthly-publication-january-2026.pdf | 1007 | 2026-01 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Raglan Road / Clarence Road | Raglan Road / Clarence Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.458316 | -1.9026302 | ||
| 11660 | op-snap---monthly-publication-january-2026.pdf | 1121 | 2026-01 | Pedestrian | Ford | Transit | White | 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 | ||
| 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 | ||
| 11717 | op-snap---monthly-publication-january-2026.pdf | 1178 | 2026-01 | Pedestrian | Ford | Puma | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Featherstone Road Kings Heath | Featherstone Road Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4258604 | -1.8926205 | ||
| 11744 | op-snap---monthly-publication-january-2026.pdf | 1205 | 2026-01 | Pedestrian | Ford | Focus | White | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5206297 | -1.9208426 | ||
| 11855 | op-snap---monthly-publication-january-2026.pdf | 1316 | 2026-01 | Pedestrian | Ford | Toureno | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cubley Road | Cubley Road | Birmingham | Birmingham | NFA | No Offence | 52.43878 | -1.8509412 | ||
| 11909 | op-snap---monthly-publication-january-2026.pdf | 1370 | 2026-01 | Pedestrian | Ford | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | school road | School Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4161736 | -1.8619692 | |||
| 4128 | op-snap---monthly-publication-december-2025.pdf | 256 | 2025-12 | Pedestrian | Ford | S Max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | No Offence | 52.4700545 | -1.834436 | ||
| 4232 | op-snap---monthly-publication-december-2025.pdf | 360 | 2025-12 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 4240 | op-snap---monthly-publication-december-2025.pdf | 368 | 2025-12 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | NFA | No Offence | 52.4616763 | -1.9653016 | ||
| 4241 | op-snap---monthly-publication-december-2025.pdf | 369 | 2025-12 | Pedestrian | Ford | Focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Apsley Road | Apsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4633793 | -1.9102892 | ||
| 4371 | op-snap---monthly-publication-december-2025.pdf | 499 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | hunters road | Hunters Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5011362 | -1.9175837 | ||
| 4458 | op-snap---monthly-publication-december-2025.pdf | 586 | 2025-12 | Pedestrian | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Apsley Road | Apsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4633793 | -1.9102892 | ||
| 4487 | op-snap---monthly-publication-december-2025.pdf | 615 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 4490 | op-snap---monthly-publication-december-2025.pdf | 618 | 2025-12 | Pedestrian | Ford | transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4865107 | -1.9386263 | ||
| 4493 | op-snap---monthly-publication-december-2025.pdf | 621 | 2025-12 | Pedestrian | Ford | KA | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queens Street | Lower Queens Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 4945 | op-snap---monthly-publication-december-2025.pdf | 1073 | 2025-12 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | outmore road | Outmore Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4767211 | -1.7814678 | ||
| 4979 | op-snap---monthly-publication-december-2025.pdf | 1107 | 2025-12 | Pedestrian | Ford | cmax | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bilbrock road | Bilbrock Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4991 | op-snap---monthly-publication-december-2025.pdf | 1119 | 2025-12 | Pedestrian | Ford | fiesta | Grey | Cause vehicle to be left in a dangerous position | None | popular road | Popular Road | Birmingham | Birmingham | Warning Letter | N/A | 52.454374 | -1.8774689 | ||
| 5030 | op-snap---monthly-publication-december-2025.pdf | 1158 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 5039 | op-snap---monthly-publication-december-2025.pdf | 1167 | 2025-12 | Pedestrian | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | bunbury road | Bunbury Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4142089 | -1.9587147 | ||
| 5130 | op-snap---monthly-publication-december-2025.pdf | 1258 | 2025-12 | Pedestrian | Ford | ST 3 ST-3 TDCI | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 5134 | op-snap---monthly-publication-december-2025.pdf | 1262 | 2025-12 | Pedestrian | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 20458 | op-snap---monthly-publication-november-2025.pdf | 0 | 2025-11 | Pedestrian | Ford | focus | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5162302 | -1.8593733 | ||
| 20902 | op-snap---monthly-publication-november-2025.pdf | 444 | 2025-11 | Pedestrian | Ford | Kuga | White | Driving without Due Care and Attention | None | Wootton Road | Wootton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3905192 | -1.968829 | ||
| 20908 | op-snap---monthly-publication-november-2025.pdf | 450 | 2025-11 | Pedestrian | Ford | Fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane | Holly Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5236889 | -1.8253311 | ||
| 20980 | op-snap---monthly-publication-november-2025.pdf | 522 | 2025-11 | Pedestrian | Ford | Kuga | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 20995 | op-snap---monthly-publication-november-2025.pdf | 537 | 2025-11 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | world end road | World End Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5016121 | -1.8288575 | ||
| 21095 | op-snap---monthly-publication-november-2025.pdf | 637 | 2025-11 | Pedestrian | Ford | Transit | White | 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 | ||
| 21098 | op-snap---monthly-publication-november-2025.pdf | 640 | 2025-11 | Pedestrian | Ford | Focus | Silver | 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 | ||
| 21123 | op-snap---monthly-publication-november-2025.pdf | 665 | 2025-11 | Pedestrian | Ford | Transit | White | 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 | ||
| 21196 | op-snap---monthly-publication-november-2025.pdf | 738 | 2025-11 | Pedestrian | Ford | Fiesta | 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 | ||
| 21263 | op-snap---monthly-publication-november-2025.pdf | 805 | 2025-11 | Pedestrian | Ford | Fiesta | Black | 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 | ||
| 21287 | op-snap---monthly-publication-november-2025.pdf | 829 | 2025-11 | Pedestrian | Ford | fiesta | Silver | Misc - Non Traffic Offences | None | sir hiltons road | Sir Hiltons Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.3932637 | -1.9575554 | ||
| 21340 | op-snap---monthly-publication-november-2025.pdf | 882 | 2025-11 | Pedestrian | Ford | transit | White | Misc - Non Traffic Offences | None | handsworth road | Handsworth Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5137414 | -1.9222827 | ||
| 21479 | op-snap---monthly-publication-november-2025.pdf | 1021 | 2025-11 | Pedestrian | Ford | fiesta | White | Cause vehicle to be left in a dangerous position | None | nursery road | Nursery Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4979836 | -1.9118163 | ||
| 21656 | op-snap---monthly-publication-november-2025.pdf | 1198 | 2025-11 | Pedestrian | Ford | cmax | Red | Cause vehicle to be left in a dangerous position | None | startford road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 21851 | op-snap---monthly-publication-november-2025.pdf | 1393 | 2025-11 | Pedestrian | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | regent road | Regent Road | Birmingham | Birmingham | Education | N/A | 52.5077359 | -1.9452509 | ||
| 21870 | op-snap---monthly-publication-november-2025.pdf | 1412 | 2025-11 | Pedestrian | Ford | transit | Grey | Driving without Due Care and Attention | None | regent place | Regent Place | Birmingham | Birmingham | Education | N/A | 52.4860376 | -1.9095854 | ||
| 22427 | op-snap---monthly-publication-october-2025.pdf | 377 | 2025-10 | Pedestrian | Ford | Transit | blue | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 23104 | op-snap---monthly-publication-october-2025.pdf | 1054 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Patrons Road | Patrons Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 23109 | op-snap---monthly-publication-october-2025.pdf | 1059 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Victoria Road | Victoria Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5615573 | -1.820549 | ||
| 23134 | op-snap---monthly-publication-october-2025.pdf | 1084 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Rd | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 23135 | op-snap---monthly-publication-october-2025.pdf | 1085 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Rd | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 23155 | op-snap---monthly-publication-october-2025.pdf | 1105 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradshaw Avenue | Bradshaw Avenue | Birmingham | Birmingham | Warning Letter | N/A | 52.4018255 | -1.9490522 | ||
| 23209 | op-snap---monthly-publication-october-2025.pdf | 1159 | 2025-10 | Pedestrian | Ford | SMAX | White | Cause vehicle to be left in a dangerous position | None | grove road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 23224 | op-snap---monthly-publication-october-2025.pdf | 1174 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coppice Road | Coppice Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4485158 | -1.8806 | ||
| 23260 | op-snap---monthly-publication-october-2025.pdf | 1210 | 2025-10 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Yardley Wood | Yardley Wood | Birmingham | Birmingham | Warning Letter | N/A | 52.421023 | -1.8545598 | ||
| 23267 | op-snap---monthly-publication-october-2025.pdf | 1217 | 2025-10 | Pedestrian | Ford | Galaxy | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 23409 | op-snap---monthly-publication-october-2025.pdf | 1359 | 2025-10 | Pedestrian | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wentworth Road | Wentworth Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5773229 | -1.8324449 | ||
| 23417 | op-snap---monthly-publication-october-2025.pdf | 1367 | 2025-10 | Pedestrian | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road | York Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5231321 | -1.8415573 | ||
| 23436 | op-snap---monthly-publication-october-2025.pdf | 1386 | 2025-10 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road | York Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5231321 | -1.8415573 | ||
| 23444 | op-snap---monthly-publication-october-2025.pdf | 1394 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4471223 | -1.8664309 | ||
| 23457 | op-snap---monthly-publication-october-2025.pdf | 1407 | 2025-10 | Pedestrian | Ford | fiesta | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | mosely road | Mosely Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23466 | op-snap---monthly-publication-october-2025.pdf | 1416 | 2025-10 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | reddings lane | Reddings Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4506039 | -1.8463952 | ||
| 23516 | op-snap---monthly-publication-october-2025.pdf | 1466 | 2025-10 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Tower Hill | Tower Hill | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5335541 | -1.9186098 | ||
| 23537 | op-snap---monthly-publication-october-2025.pdf | 1487 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | Warning Letter | N/A | 52.4471223 | -1.8664309 | ||
| 23539 | op-snap---monthly-publication-october-2025.pdf | 1489 | 2025-10 | Pedestrian | Ford | S max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 23573 | op-snap---monthly-publication-october-2025.pdf | 1523 | 2025-10 | Pedestrian | Ford | White | 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 |
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);