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'}
565 rows where vehicle_make = "Honda" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
offence 28
- Driving without Due Care and Attention 151
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 82
- Contravening a Red Traffic Light 66
- Cause vehicle to be left in a dangerous position 50
- Using a Mobile Phone Whilst Driving 42
- Stop a vehicle within pelican pedestrian crossing limits 40
- Driving without Reasonable Consideration 30
- Misc - Non Traffic Offences 27
- Stop a vehicle on pedestrian crossing 16
- 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
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 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 equipmen 4
- No Insurance 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 2
- Contravene Lane Closure Red X 2
- DCariuvsee o unn hnaercde ssshaoruyl doebrstruction by motor vehicle 1
- Drive / Ride / Lead an animal on a footpath 1
- Drive a vehicle on common land 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 solid white line road markings 1
- No Seat Belt 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use vehicle on a road without valid test certificate 1
- VRM fails to conform to Regulations 1
council_area 16
- Birmingham 365
- Out of Force Area 45
- Coventry 37
- Dudley 33
- Sandwell 24
- Solihull 17
- Walsall 13
- Wolverhampton 12
- Sutton Coldfield 10
- Out Of Force Area 2
- Awll Alsall 1
- Halesowen 1
- Metropolitan Borough 1
- Metropolitan Borough Of Dudley 1
- Owlvoelrvhearmhapmtopnton 1
- Rsoaanddwell 1
month 14
reporter_transport_mode 10
- Car 318
- Pedestrian 146
- Pedal Bike 76
- Other 17
- Lorry 3
- 14695 1
- Bus 1
- Motorbike 1
- car 1
- other 1
disposal 7
- NFA 184
- Warning Letter 149
- Fixed Penalty 108
- Education 94
- Court 20
- Other Action Taken 9
- RTC - Actioned 1
vehicle_make 1
- Honda · 565 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8884 | op-snap---monthly-publication-february-2026.pdf | 1631 | 2026-02 | Car | Honda | civic | Red | Stop a vehicle within pelican pedestrian crossing limits | None | high street, tettenhall | High Street, Tettenhall | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8867 | op-snap---monthly-publication-february-2026.pdf | 1614 | 2026-02 | Car | Honda | FRV | Grey | 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 | ||
| 8835 | op-snap---monthly-publication-february-2026.pdf | 1582 | 2026-02 | Pedestrian | Honda | civic | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | wills street | Wills Street | Birmingham | Birmingham | Warning Letter | N/A | 52.500453 | -1.9141126 | ||
| 8821 | op-snap---monthly-publication-february-2026.pdf | 1568 | 2026-02 | Pedal Bike | Honda | NSC | White | Driving without Due Care and Attention | None | Yew Tree Lane | Yew Tree Lane | Birmingham | Birmingham | NFA | No Offence | 52.4631 | -1.8082055 | ||
| 8784 | op-snap---monthly-publication-february-2026.pdf | 1531 | 2026-02 | Car | Honda | CBR 600 | Yellow | Driving without Due Care and Attention | None | Carters Lane | Carters Lane | Birmingham | Birmingham | Court | N/A | 52.4445826 | -2.013123 | ||
| 8712 | op-snap---monthly-publication-february-2026.pdf | 1459 | 2026-02 | Pedestrian | Honda | ww | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | bishopsgate street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 8711 | op-snap---monthly-publication-february-2026.pdf | 1458 | 2026-02 | Pedestrian | Honda | NSC | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | bishops gate street | Bishops Gate Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8701 | op-snap---monthly-publication-february-2026.pdf | 1448 | 2026-02 | Pedal Bike | Honda | Civic | Red | Using a Mobile Phone Whilst Driving | None | Park Hill Road | Park Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612518 | -1.9515542 | ||
| 8651 | op-snap---monthly-publication-february-2026.pdf | 1398 | 2026-02 | Car | Honda | civic | 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 | ||
| 8569 | op-snap---monthly-publication-february-2026.pdf | 1316 | 2026-02 | Car | Honda | Civic | Grey | Driving without Due Care and Attention | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | ||
| 8556 | op-snap---monthly-publication-february-2026.pdf | 1303 | 2026-02 | Car | Honda | Jazz | Red | Driving without Due Care and Attention | None | Wedges Mill M6 Toll entrance, Staffs | Wedges Mill M6 Toll entrance, Staffs | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8525 | op-snap---monthly-publication-february-2026.pdf | 1272 | 2026-02 | Car | Honda | jazz | Blue | No Insurance | Use vehicle on a road without valid test certificate | Upper Balsall Heath Road | Upper Balsall Heath Road | Birmingham | Birmingham | Court | N/A | 52.4603726 | -1.8856671 | ||
| 8518 | op-snap---monthly-publication-february-2026.pdf | 1265 | 2026-02 | Car | Honda | Civic | Silver | Driving without Due Care and Attention | None | Hurst Lane North | Hurst Lane North | Birmingham | Birmingham | Court | N/A | 52.4994582 | -1.7644778 | ||
| 8289 | op-snap---monthly-publication-february-2026.pdf | 1036 | 2026-02 | Car | Honda | Civic | Black | Driving without Due Care and Attention | None | Robin Hood Lane | Robin Hood Lane | Birmingham | Birmingham | Court | N/A | 52.4221526 | -1.8425617 | ||
| 8200 | op-snap---monthly-publication-february-2026.pdf | 947 | 2026-02 | Car | Honda | Jazz | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8143 | op-snap---monthly-publication-february-2026.pdf | 890 | 2026-02 | Car | Honda | Jazz | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 8101 | op-snap---monthly-publication-february-2026.pdf | 848 | 2026-02 | Car | Honda | Insight | Black | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 7960 | op-snap---monthly-publication-february-2026.pdf | 707 | 2026-02 | Pedal Bike | Honda | Jazz | Blue | Stop a vehicle on pedestrian crossing | None | Stoney Lane | Stoney Lane | Birmingham | Birmingham | Education | N/A | 52.4745488 | -1.8065911 | ||
| 7753 | op-snap---monthly-publication-february-2026.pdf | 500 | 2026-02 | Car | Honda | CRV | Black | Driving without Due Care and Attention | None | Northampton Road, Rugby | Northampton Road, Rugby | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 7580 | op-snap---monthly-publication-february-2026.pdf | 327 | 2026-02 | Car | Honda | CR-V | Blue | Contravening a Red Traffic Light | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Education | N/A | 52.437016 | -1.7578446 | ||
| 7547 | op-snap---monthly-publication-february-2026.pdf | 294 | 2026-02 | Car | Honda | Civic | Yellow | Contravening a Red Traffic Light | None | Monksfield Avenue | Monksfield Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 7543 | op-snap---monthly-publication-february-2026.pdf | 290 | 2026-02 | Pedal Bike | Honda | Civic | White | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 7424 | op-snap---monthly-publication-february-2026.pdf | 171 | 2026-02 | Pedestrian | Honda | Civic | Silver | Cause vehicle to be left in a dangerous position | No Insurance | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Education | N/A | 52.4700545 | -1.834436 | ||
| 7410 | op-snap---monthly-publication-february-2026.pdf | 157 | 2026-02 | Pedestrian | Honda | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.4679402 | -1.881408 | |||
| 7388 | op-snap---monthly-publication-february-2026.pdf | 135 | 2026-02 | Pedestrian | Honda | Civic | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 7380 | op-snap---monthly-publication-february-2026.pdf | 127 | 2026-02 | Pedal Bike | Honda | Civic | Grey | Driving without Due Care and Attention | None | War Lane | War Lane | Birmingham | Birmingham | Education | N/A | 52.4569552 | -1.9616483 | ||
| 7370 | op-snap---monthly-publication-february-2026.pdf | 117 | 2026-02 | Car | Honda | Jazz | Red | Driving without Due Care and Attention | None | Birchfield Island Olbury | Birchfield Island Olbury | Sandwell | Sandwell | Court | N/A | ||||
| 11794 | op-snap---monthly-publication-january-2026.pdf | 1255 | 2026-01 | Car | Honda | Jazz | 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 | ||||
| 11720 | op-snap---monthly-publication-january-2026.pdf | 1181 | 2026-01 | Car | Honda | Civic | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Bordesley Green East | Bordesley Green East | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4802441 | -1.8327073 | ||
| 11711 | op-snap---monthly-publication-january-2026.pdf | 1172 | 2026-01 | Other | Honda | Civic | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | Use vehicle on a road without valid test certificate | Berkeley Road East | Berkeley Road East | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4658801 | -1.8290005 | ||
| 11682 | op-snap---monthly-publication-january-2026.pdf | 1143 | 2026-01 | Car | Honda | Jazz | Blue | Driving without Due Care and Attention | None | Gravelly Hill | Gravelly Hill | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5153884 | -1.8527437 | ||
| 11656 | op-snap---monthly-publication-january-2026.pdf | 1117 | 2026-01 | Car | Honda | Civic | Black | Driving without Due Care and Attention | None | Turves Green Road | Turves Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4147044 | -1.9634093 | ||
| 11608 | op-snap---monthly-publication-january-2026.pdf | 1069 | 2026-01 | Car | Honda | FR.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11501 | op-snap---monthly-publication-january-2026.pdf | 962 | 2026-01 | Car | Honda | CRV | Grey | Driving without Due Care and Attention | None | Bonley Rd, Jimmy Hill Way Roundabout | Bonley Road, Jimmy Hill Way Roundabout | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 11432 | op-snap---monthly-publication-january-2026.pdf | 893 | 2026-01 | Pedal Bike | Honda | Civic | Grey | Driving without Due Care and Attention | None | Belford Road | Belford Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11414 | op-snap---monthly-publication-january-2026.pdf | 875 | 2026-01 | Car | Honda | CRV | Black | Contravening a Red Traffic Light | None | M54 J4 Telford | M54 J4 Telford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11394 | op-snap---monthly-publication-january-2026.pdf | 855 | 2026-01 | Car | Honda | Jazz | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 11355 | op-snap---monthly-publication-january-2026.pdf | 816 | 2026-01 | Car | Honda | Jazz | White | Cause vehicle to be left in a dangerous position | None | St Pauls Road | Street Pauls Road | Birmingham | Birmingham | Education | N/A | ||||
| 11347 | op-snap---monthly-publication-january-2026.pdf | 808 | 2026-01 | Car | Honda | Civic | Red | Cause vehicle to be left in a dangerous position | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Education | N/A | 52.468128 | -1.8848315 | ||
| 11323 | op-snap---monthly-publication-january-2026.pdf | 784 | 2026-01 | Car | Honda | Jazz | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11317 | op-snap---monthly-publication-january-2026.pdf | 778 | 2026-01 | Car | Honda | Jazz | Blue | Stop a vehicle within pelican pedestrian crossing limits | Use vehicle on a road without valid test certificate | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11246 | op-snap---monthly-publication-january-2026.pdf | 707 | 2026-01 | Car | Honda | Jazz | Blue | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Education | N/A | ||||
| 11191 | op-snap---monthly-publication-january-2026.pdf | 652 | 2026-01 | Car | Honda | CR-V | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11181 | op-snap---monthly-publication-january-2026.pdf | 642 | 2026-01 | Car | Honda | Civic | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11175 | op-snap---monthly-publication-january-2026.pdf | 636 | 2026-01 | Pedestrian | Honda | Jazz | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bradford Place Walsall | Bradford Place Walsall | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5831708 | -1.9837299 | ||
| 11119 | op-snap---monthly-publication-january-2026.pdf | 580 | 2026-01 | Pedal Bike | Honda | Civic | Blue | Contravening a Red Traffic Light | None | Burnaby Road at Beake Avenue | Burnaby Road at Beake Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4352 | -1.5194238 | ||
| 11082 | op-snap---monthly-publication-january-2026.pdf | 543 | 2026-01 | Car | Honda | Red | Using a Mobile Phone Whilst Driving | None | M60 | M60 | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 11081 | op-snap---monthly-publication-january-2026.pdf | 542 | 2026-01 | Pedal Bike | Honda | C-RV | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coat of Arms Bridge Road | Coat of Arms Bridge Road | Coventry | Coventry | Fixed Penalty | N/A | 52.3887077 | -1.5308677 | ||
| 11080 | op-snap---monthly-publication-january-2026.pdf | 541 | 2026-01 | Pedal Bike | Honda | Jazz | Blue | Driving without Due Care and Attention | None | Slade Road, Edgbaston | Slade Road, Edgbaston | Birmingham | Birmingham | Education | N/A | ||||
| 11018 | op-snap---monthly-publication-january-2026.pdf | 479 | 2026-01 | Pedestrian | Honda | Jazz | Red | Stop a vehicle within pelican pedestrian crossing limits | None | Kettlehouse Road | Kettlehouse Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5546392 | -1.8859041 | ||
| 11001 | op-snap---monthly-publication-january-2026.pdf | 462 | 2026-01 | Car | Honda | Accord | Silver | Contravening a Red Traffic Light | None | Western Road / Dudley Road | Western Road / Dudley Road | Birmingham | Birmingham | Education | N/A | 52.5461182 | -1.8340257 | ||
| 10929 | op-snap---monthly-publication-january-2026.pdf | 390 | 2026-01 | Pedal Bike | Honda | Civic | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Spiceland Road | Spiceland Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4243001 | -1.9747504 | ||
| 10912 | op-snap---monthly-publication-january-2026.pdf | 373 | 2026-01 | Car | Honda | Jazz | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | RobinHood Lane | Robin Hood Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4221526 | -1.8425617 | ||
| 10911 | op-snap---monthly-publication-january-2026.pdf | 372 | 2026-01 | Car | Honda | Jazz | Silver | Motor vehicle fail to accord precedence at a pelican crossing | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 10831 | op-snap---monthly-publication-january-2026.pdf | 292 | 2026-01 | Pedestrian | Honda | Jazz | White | Cause vehicle to be left in a dangerous position | None | Regent Road | Regent Road | Sandwell | Sandwell | Education | N/A | 52.5106406 | -2.0559963 | ||
| 10667 | op-snap---monthly-publication-january-2026.pdf | 128 | 2026-01 | Car | Honda | civic | 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 | ||
| 10662 | op-snap---monthly-publication-january-2026.pdf | 123 | 2026-01 | Pedestrian | Honda | jazz | Silver | Cause vehicle to be left in a dangerous position | None | pershore road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 10645 | op-snap---monthly-publication-january-2026.pdf | 106 | 2026-01 | Car | Honda | Blue | Driving without Due Care and Attention | None | New Road | New Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4119526 | -1.773235 | |||
| 10644 | op-snap---monthly-publication-january-2026.pdf | 105 | 2026-01 | other | Honda | Civic | Grey | Using a Mobile Phone Whilst Driving | None | Appleby Grove | Appleby Grove | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 10580 | op-snap---monthly-publication-january-2026.pdf | 41 | 2026-01 | Pedal Bike | Honda | CR-V | Blue | Driving without Due Care and Attention | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 10560 | op-snap---monthly-publication-january-2026.pdf | 21 | 2026-01 | Car | Honda | Civic | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | Education | N/A | 52.5692139 | -1.8799672 | ||
| 5033 | op-snap---monthly-publication-december-2025.pdf | 1161 | 2025-12 | Car | Honda | civic | Grey | Cause vehicle to be left in a dangerous position | None | bristol road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 5021 | op-snap---monthly-publication-december-2025.pdf | 1149 | 2025-12 | Pedestrian | Honda | crv | Blue | Misc - Non Traffic Offences | None | rowood drive | Rowood Drive | Solihull | Solihull | NFA | Misc Inc Crimes | 52.4285752 | -1.7757399 | ||
| 4860 | op-snap---monthly-publication-december-2025.pdf | 988 | 2025-12 | Pedal Bike | Honda | CR-V | Silver | Using a Mobile Phone Whilst Driving | None | Navigation Street | Navigation Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4781877 | -1.9011642 | ||
| 4847 | op-snap---monthly-publication-december-2025.pdf | 975 | 2025-12 | Car | Honda | Silver | Contravening a Red Traffic Light | None | A41 Birmingham Road | Birmingham Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5461417 | -1.9334193 | |||
| 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 | ||
| 4760 | op-snap---monthly-publication-december-2025.pdf | 888 | 2025-12 | Car | Honda | CRV | Blue | Driving without Due Care and Attention | None | Oakenshaw Road | Oakenshaw Road | Solihull | Solihull | Education | N/A | 52.4017754 | -1.8151522 | ||
| 4758 | op-snap---monthly-publication-december-2025.pdf | 886 | 2025-12 | Pedestrian | Honda | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Corporation Street | Corporation Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4895456 | -1.8900666 | |||
| 4706 | op-snap---monthly-publication-december-2025.pdf | 834 | 2025-12 | Pedestrian | Honda | CR-V | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | The Oval | The Oval | Birmingham | Birmingham | Warning Letter | N/A | 52.4577754 | -1.8692099 | ||
| 4704 | op-snap---monthly-publication-december-2025.pdf | 832 | 2025-12 | Pedal Bike | Honda | CRV | Grey | Driving without Due Care and Attention | None | Portman Road | Portman Road | Birmingham | Birmingham | Education | N/A | 52.4306424 | -1.8844833 | ||
| 4694 | op-snap---monthly-publication-december-2025.pdf | 822 | 2025-12 | Pedal Bike | Honda | CRV | Grey | Using a Mobile Phone Whilst Driving | None | Hill Street | Hill Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4777765 | -1.901321 | ||
| 4682 | op-snap---monthly-publication-december-2025.pdf | 810 | 2025-12 | Car | Honda | Civic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Garretts Green Lane | Garretts Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4675802 | -1.7905748 | ||
| 4674 | op-snap---monthly-publication-december-2025.pdf | 802 | 2025-12 | Pedestrian | Honda | Accord | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Colmore Road | Colmore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4296373 | -1.8993161 | ||
| 4673 | op-snap---monthly-publication-december-2025.pdf | 801 | 2025-12 | Pedestrian | Honda | Civic | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Colmore Road | Colmore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4296373 | -1.8993161 | ||
| 4627 | op-snap---monthly-publication-december-2025.pdf | 755 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5095686 | -1.9544485 | ||
| 4583 | op-snap---monthly-publication-december-2025.pdf | 711 | 2025-12 | Car | Honda | Civic | Red | Driving without Due Care and Attention | None | Broad Lane South | Broad Lane South | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5995308 | -2.0598045 | ||
| 4489 | op-snap---monthly-publication-december-2025.pdf | 617 | 2025-12 | Pedestrian | Honda | Grey | 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 | |||
| 4442 | op-snap---monthly-publication-december-2025.pdf | 570 | 2025-12 | Pedestrian | Honda | civic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | grove road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 4415 | op-snap---monthly-publication-december-2025.pdf | 543 | 2025-12 | Pedal Bike | Honda | Civic | Silver | Driving without Due Care and Attention | None | Tessal Lane | Tessal Lane | Birmingham | Birmingham | Education | N/A | ||||
| 4412 | op-snap---monthly-publication-december-2025.pdf | 540 | 2025-12 | Car | Honda | CR-V | Black | Using a Mobile Phone Whilst Driving | No Insurance | Battlefield Road | Battlefield Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4296 | op-snap---monthly-publication-december-2025.pdf | 424 | 2025-12 | Car | Honda | crv | Brown | 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 | ||
| 4260 | op-snap---monthly-publication-december-2025.pdf | 388 | 2025-12 | Pedestrian | Honda | jazz | Silver | Misc - Non Traffic Offences | None | cardigan street | Cardigan Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4849063 | -1.8846609 | ||
| 4227 | op-snap---monthly-publication-december-2025.pdf | 355 | 2025-12 | Car | Honda | Civic | Blue | 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 | ||
| 4149 | op-snap---monthly-publication-december-2025.pdf | 277 | 2025-12 | Pedestrian | Honda | Motorbike NSS | Blue | Drive / Ride / Lead an animal on a footpath | None | Whitington | Whitington | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 4123 | op-snap---monthly-publication-december-2025.pdf | 251 | 2025-12 | Car | Honda | Civic | Grey | Misc - Non Traffic Offences | None | Maple Tree Lane | Maple Tree Lane | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 4030 | op-snap---monthly-publication-december-2025.pdf | 158 | 2025-12 | Car | Honda | Jazz | Grey | Contravening a Red Traffic Light | None | Wolverhampton Road at Portway | Wolverhampton Road at Portway | RSoaanddwell | Rsoaanddwell | Fixed Penalty | N/A | 52.4661511 | -1.9846785 | ||
| 4010 | op-snap---monthly-publication-december-2025.pdf | 138 | 2025-12 | Pedal Bike | Honda | Civic | Blue | Using a Mobile Phone Whilst Driving | None | Moseley Road | Moseley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4679402 | -1.881408 | ||
| 21945 | op-snap---monthly-publication-november-2025.pdf | 1487 | 2025-11 | Car | Honda | CR-V | Grey | Using a Mobile Phone Whilst Driving | None | M25 - Jct 15-16 (Thames Valley) | M25 - Junction 15-16 (Thames Valley) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21890 | op-snap---monthly-publication-november-2025.pdf | 1432 | 2025-11 | Car | Honda | cb600 | Silver | Misc - Non Traffic Offences | None | alcester road south | Alcester Road South | Birmingham | Birmingham | Other Action Taken | Misc Inc Crimes | 52.4170522 | -1.8906187 | ||
| 21881 | op-snap---monthly-publication-november-2025.pdf | 1423 | 2025-11 | Car | Honda | Jazz | Red | Driving without Due Care and Attention | None | Handsworh Wood Road | Handsworh Wood Road | Birmingham | Birmingham | Education | N/A | ||||
| 21842 | op-snap---monthly-publication-november-2025.pdf | 1384 | 2025-11 | Car | Honda | civic | Brown | 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 | ||
| 21835 | op-snap---monthly-publication-november-2025.pdf | 1377 | 2025-11 | Pedal Bike | Honda | Silver | Driving without Due Care and Attention | None | Stourport Road | Stourport Road | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 21787 | op-snap---monthly-publication-november-2025.pdf | 1329 | 2025-11 | Pedestrian | Honda | crv | White | Misc - Non Traffic Offences | None | turners lane | Turners Lane | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4721372 | -2.1243522 | ||
| 21744 | op-snap---monthly-publication-november-2025.pdf | 1286 | 2025-11 | Car | Honda | stepwagon | Black | Cause vehicle to be left in a dangerous position | None | lozells road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 21669 | op-snap---monthly-publication-november-2025.pdf | 1211 | 2025-11 | Pedal Bike | Honda | Civic | White | Driving without Due Care and Attention | None | B4100 Banbury Road, Ashbourne Hill, Warwick | Banbury Road, Ashbourne Hill, Warwick | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21602 | op-snap---monthly-publication-november-2025.pdf | 1144 | 2025-11 | Car | Honda | jazz | Red | 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 | ||
| 21594 | op-snap---monthly-publication-november-2025.pdf | 1136 | 2025-11 | Car | Honda | Civic | Silver | Misc - Non Traffic Offences | None | A14 | A14 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 21580 | op-snap---monthly-publication-november-2025.pdf | 1122 | 2025-11 | Car | Honda | Civic | Grey | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 21453 | op-snap---monthly-publication-november-2025.pdf | 995 | 2025-11 | Car | Honda | JAzz | Grey | Driving without Due Care and Attention | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 21451 | op-snap---monthly-publication-november-2025.pdf | 993 | 2025-11 | Car | Honda | Civic | Red | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4111289 | -1.5094345 |
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);