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'}
426 rows where council_area = "Birmingham", disposal = "Warning Letter" and vehicle_make = "Ford" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale
offence 30
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 172
- Driving without Due Care and Attention 67
- Cause vehicle to be left in a dangerous position 52
- Driving without Reasonable Consideration 26
- Cause unnecessary obstruction by motor vehicle 25
- Contravening a Red Traffic Light 23
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 14
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 10
- Using a Mobile Phone Whilst Driving 5
- Misc - Non Traffic Offences 4
- Stop a vehicle within pelican pedestrian crossing limits 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- Contravene Lane Closure Red X 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 2
- No Seat Belt 2
- Stop a vehicle on pedestrian crossing 2
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 1
- Dangerous Driving 1
- Drive a vehicle on common land 1
- Drive on hard shoulder 1
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- Motor vehicle fail to comply with a non endorsab 1
- No Insurance 1
- Person in charge cause veh / trailer to be left to involve danger to road user 1
- Use a motor vehicle / trailer in a condition likely t 1
- Use a vehicle / cycle on a road and contravene a l 1
- Use vehicle on a road without valid test certificate 1
- VRM fails to conform to Regulations 1
- Vehicle overtake within crossing limits 1
month 14
reporter_transport_mode 6
- Car 212
- Pedestrian 166
- Pedal Bike 40
- Other 6
- Lorry 1
- Van 1
vehicle_make 1
- Ford · 426 ✖
disposal 1
- Warning Letter · 426 ✖
council_area 1
- Birmingham · 426 ✖
| 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 | ||
| 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 | ||||
| 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 | ||||
| 7555 | op-snap---monthly-publication-february-2026.pdf | 302 | 2026-02 | Pedal Bike | Ford | Transit | Orange | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Braford Street | Braford Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 7557 | op-snap---monthly-publication-february-2026.pdf | 304 | 2026-02 | Pedal Bike | 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 | ||
| 7720 | op-snap---monthly-publication-february-2026.pdf | 467 | 2026-02 | Other | Ford | Kuga | 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 | ||||
| 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 | ||
| 8031 | op-snap---monthly-publication-february-2026.pdf | 778 | 2026-02 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Tessall Lane | Tessall Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4045186 | -1.9891793 | ||
| 8068 | op-snap---monthly-publication-february-2026.pdf | 815 | 2026-02 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | None | Lee Bank Middleway | Lee Bank Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4677721 | -1.9037358 | ||
| 8277 | op-snap---monthly-publication-february-2026.pdf | 1024 | 2026-02 | Car | Ford | Puma | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 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 | ||
| 8301 | op-snap---monthly-publication-february-2026.pdf | 1048 | 2026-02 | Car | Ford | Transit | White | Using a Mobile Phone Whilst Driving | None | M6 Motorway | M6 Motorway | Birmingham | Birmingham | Warning Letter | N/A | 52.5327447 | -1.899844 | ||
| 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 | ||||
| 8627 | op-snap---monthly-publication-february-2026.pdf | 1374 | 2026-02 | Car | Ford | fiesta | 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 | ||
| 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 | ||
| 8804 | op-snap---monthly-publication-february-2026.pdf | 1551 | 2026-02 | Car | Ford | transit | Black | Driving without Reasonable Consideration | None | A45 Heartlands parkway | Heartlands parkway | Birmingham | Birmingham | Warning Letter | N/A | 52.5038363 | -1.8432663 | ||
| 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 | ||
| 8840 | op-snap---monthly-publication-february-2026.pdf | 1587 | 2026-02 | Car | Ford | mondeo | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 8881 | op-snap---monthly-publication-february-2026.pdf | 1628 | 2026-02 | Car | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath | Washwood Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4957234 | -1.8538937 | ||
| 10579 | op-snap---monthly-publication-january-2026.pdf | 40 | 2026-01 | Pedal Bike | Ford | Transit | Green | Driving without Due Care and Attention | None | Alwood Road | Alwood Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 10621 | op-snap---monthly-publication-january-2026.pdf | 82 | 2026-01 | Van | Ford | transit | White | Cause vehicle to be left in a dangerous position | None | coltham road | Coltham Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 10665 | op-snap---monthly-publication-january-2026.pdf | 126 | 2026-01 | Car | Ford | focus | Grey | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 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 | ||
| 10936 | op-snap---monthly-publication-january-2026.pdf | 397 | 2026-01 | Car | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.473883 | -1.9198244 | ||
| 11019 | op-snap---monthly-publication-january-2026.pdf | 480 | 2026-01 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Linden Road | Linden Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263156 | -1.9351622 | ||
| 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 | ||
| 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 | ||
| 11452 | op-snap---monthly-publication-january-2026.pdf | 913 | 2026-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5724303 | -1.8191247 | ||
| 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 | ||
| 11743 | op-snap---monthly-publication-january-2026.pdf | 1204 | 2026-01 | Pedal Bike | Ford | Kuga | Black | Driving without Due Care and Attention | None | Lakey Lane | Lakey Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4311142 | -1.8324795 | ||
| 11776 | op-snap---monthly-publication-january-2026.pdf | 1237 | 2026-01 | Car | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Minworth Island | Minworth Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5316279 | -1.7762358 | ||
| 11802 | op-snap---monthly-publication-january-2026.pdf | 1263 | 2026-01 | Car | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4221526 | -1.8425617 | ||
| 11860 | op-snap---monthly-publication-january-2026.pdf | 1321 | 2026-01 | Car | Ford | Focus | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 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 | |||
| 3881 | op-snap---monthly-publication-december-2025.pdf | 9 | 2025-12 | Car | Ford | Fiesta | Black | 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 | ||
| 3891 | op-snap---monthly-publication-december-2025.pdf | 19 | 2025-12 | Pedal Bike | Ford | Mondeo | Silver | Driving without Due Care and Attention | None | Longdales Road | Longdales Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3947881 | -1.9285109 | ||
| 3932 | op-snap---monthly-publication-december-2025.pdf | 60 | 2025-12 | Pedal Bike | Ford | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walmley Ash Road | Walmley Ash Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5376726 | -1.7973346 | |||
| 3934 | op-snap---monthly-publication-december-2025.pdf | 62 | 2025-12 | Car | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4065 | op-snap---monthly-publication-december-2025.pdf | 193 | 2025-12 | Car | Ford | Transit | Blue | Driving without Due Care and Attention | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5521118 | -1.8845138 | ||
| 4142 | op-snap---monthly-publication-december-2025.pdf | 270 | 2025-12 | Car | Ford | Focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 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 | ||
| 4242 | op-snap---monthly-publication-december-2025.pdf | 370 | 2025-12 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5517052 | -1.7825505 | ||
| 4258 | op-snap---monthly-publication-december-2025.pdf | 386 | 2025-12 | Car | Ford | fusion | Blue | Cause vehicle to be left in a dangerous position | None | vauxhall road | Vauxhall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4834623 | -1.8796522 | ||
| 4294 | op-snap---monthly-publication-december-2025.pdf | 422 | 2025-12 | Car | Ford | transit | Blue | Cause vehicle to be left in a dangerous position | None | washwood heath | Washwood Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4957234 | -1.8538937 | ||
| 4313 | op-snap---monthly-publication-december-2025.pdf | 441 | 2025-12 | Pedal Bike | Ford | Kuga | Blue | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 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 | ||
| 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 | ||||
| 4576 | op-snap---monthly-publication-december-2025.pdf | 704 | 2025-12 | Car | Ford | SMAX | Gold | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.4027335 | -1.876125 | ||
| 4679 | op-snap---monthly-publication-december-2025.pdf | 807 | 2025-12 | Car | Ford | Fiesta | Blue | Driving without Due Care and Attention | None | M42 | M42 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4698 | op-snap---monthly-publication-december-2025.pdf | 826 | 2025-12 | Car | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lower queen street | Lower Queen Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5603978 | -1.8227403 | ||
| 4700 | op-snap---monthly-publication-december-2025.pdf | 828 | 2025-12 | Car | Ford | transit | White | Cause vehicle to be left in a dangerous position | None | victoria road | Victoria Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5615573 | -1.820549 | ||
| 4705 | op-snap---monthly-publication-december-2025.pdf | 833 | 2025-12 | Pedal Bike | Ford | Fiesta | Grey | Driving without Due Care and Attention | None | Wheelers Lane | Wheelers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4306504 | -1.878052 | ||
| 4765 | op-snap---monthly-publication-december-2025.pdf | 893 | 2025-12 | Car | Ford | Transit | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4921 | op-snap---monthly-publication-december-2025.pdf | 1049 | 2025-12 | Car | Ford | Focus | Red | Contravening a Red Traffic Light | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5292752 | -1.7618805 | ||
| 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 | ||
| 4977 | op-snap---monthly-publication-december-2025.pdf | 1105 | 2025-12 | Car | Ford | mondeo | White | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 5074 | op-snap---monthly-publication-december-2025.pdf | 1202 | 2025-12 | Car | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4830179 | -1.783876 | ||
| 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 | ||
| 20532 | op-snap---monthly-publication-november-2025.pdf | 74 | 2025-11 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Warren Farm Road | Warren Farm Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5424846 | -1.8794625 | ||
| 20539 | op-snap---monthly-publication-november-2025.pdf | 81 | 2025-11 | Car | Ford | Mondeo | Silver | Driving without Due Care and Attention | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4552785 | -1.906384 | ||
| 20599 | op-snap---monthly-publication-november-2025.pdf | 141 | 2025-11 | Car | Ford | Transit | White | Driving without Due Care and Attention | None | Newbury Road | Newbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4993019 | -1.8964495 | ||
| 20881 | op-snap---monthly-publication-november-2025.pdf | 423 | 2025-11 | Car | Ford | C max | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4762784 | -1.9678366 | ||
| 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 | ||
| 20919 | op-snap---monthly-publication-november-2025.pdf | 461 | 2025-11 | Car | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 20923 | op-snap---monthly-publication-november-2025.pdf | 465 | 2025-11 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 20924 | op-snap---monthly-publication-november-2025.pdf | 466 | 2025-11 | Car | Ford | Focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 21101 | op-snap---monthly-publication-november-2025.pdf | 643 | 2025-11 | Pedal Bike | Ford | Mondeo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Silverthorne Lane | Silverthorne Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 21147 | op-snap---monthly-publication-november-2025.pdf | 689 | 2025-11 | Car | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 21197 | op-snap---monthly-publication-november-2025.pdf | 739 | 2025-11 | Car | Ford | Galaxy | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 21224 | op-snap---monthly-publication-november-2025.pdf | 766 | 2025-11 | Car | Ford | Transit | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 21261 | op-snap---monthly-publication-november-2025.pdf | 803 | 2025-11 | Car | Ford | KA | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 21286 | op-snap---monthly-publication-november-2025.pdf | 828 | 2025-11 | Car | Ford | fiesta | Grey | Cause vehicle to be left in a dangerous position | None | college road | College Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5151832 | -1.9361664 | ||
| 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 | ||
| 21503 | op-snap---monthly-publication-november-2025.pdf | 1045 | 2025-11 | Car | Ford | Bmax | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | alcester road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 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 | ||
| 21789 | op-snap---monthly-publication-november-2025.pdf | 1331 | 2025-11 | Pedal Bike | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | lodge hill road | Lodge Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4390011 | -1.9455485 | ||
| 21889 | op-snap---monthly-publication-november-2025.pdf | 1431 | 2025-11 | Car | Ford | transit | White | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 22276 | op-snap---monthly-publication-october-2025.pdf | 226 | 2025-10 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 22329 | op-snap---monthly-publication-october-2025.pdf | 279 | 2025-10 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 22903 | op-snap---monthly-publication-october-2025.pdf | 853 | 2025-10 | Pedal Bike | Ford | S-Max | White | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 |
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);