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'}
414 rows where disposal = "Fixed Penalty" and vehicle_make = "BMW" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, witness_contacted
offence 27
- Using a Mobile Phone Whilst Driving 114
- Driving without Due Care and Attention 65
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 44
- Contravening a Red Traffic Light 43
- Cause vehicle to be left in a dangerous position 35
- Stop a vehicle within pelican pedestrian crossing limits 31
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 22
- Stop a vehicle on pedestrian crossing 10
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 9
- VRM fails to conform to Regulations 9
- Driving without Reasonable Consideration 7
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5
- Contravene Lane Closure Red X 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 2
- Use vehicle on a road without valid test certificate 2
- Vehicle overtake within crossing limits 2
- Cause unnecessary obstruction by motor vehicle 1
- Drive on hard shoulder 1
- Driver not in position to have Proper Control 1
- Fail to Conform to Cycle Lane 1
- Fail to display front VRM plate 1
- Motor vehicle fail to accord precedence at a pelic 1
- No Insurance 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 1
- Waiting on a road in a prohibited area 1
month 14
council_area 12
- Birmingham 248
- Coventry 62
- Dudley 23
- Sandwell 19
- Sutton Coldfield 17
- Solihull 14
- Walsall 12
- Wolverhampton 12
- Halesowen 4
- )Birmingham 1
- Idseudtt Obny Cprol)Dfield 1
- Out of Force Area 1
reporter_transport_mode 6
- Car 174
- Pedestrian 126
- Pedal Bike 101
- Other 10
- Lorry 2
- Motorbike 1
vehicle_make 1
- BMW · 414 ✖
disposal 1
- Fixed Penalty · 414 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7263 | op-snap---monthly-publication-february-2026.pdf | 10 | 2026-02 | Car | BMW | 116.. | White | Using a Mobile Phone Whilst Driving | No Insurance | Cranmore Road | Cranmore Road | Solihull | Solihull | Fixed Penalty | N/A | 52.3989532 | -1.8125728 | ||
| 7400 | op-snap---monthly-publication-february-2026.pdf | 147 | 2026-02 | Pedal Bike | BMW | I4 | Grey | Using a Mobile Phone Whilst Driving | None | Granville Street | Granville Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762076 | -1.9124263 | ||
| 7529 | op-snap---monthly-publication-february-2026.pdf | 276 | 2026-02 | Car | BMW | 320 | White | Driving without Reasonable Consideration | None | Small Heath Bridge | Small Heath Bridge | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4675008 | -1.8693303 | ||
| 7550 | op-snap---monthly-publication-february-2026.pdf | 297 | 2026-02 | Pedal Bike | BMW | IX | Grey | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4591339 | -1.9601054 | ||
| 7595 | op-snap---monthly-publication-february-2026.pdf | 342 | 2026-02 | Pedal Bike | BMW | X1.. | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4119174 | -1.9735247 | ||
| 7629 | op-snap---monthly-publication-february-2026.pdf | 376 | 2026-02 | Pedestrian | BMW | 1 series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5154198 | -1.9135452 | ||
| 7651 | op-snap---monthly-publication-february-2026.pdf | 398 | 2026-02 | Pedal Bike | BMW | 640D | Blue | Using a Mobile Phone Whilst Driving | None | A429 nr A45 | A429 nr A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 7687 | op-snap---monthly-publication-february-2026.pdf | 434 | 2026-02 | Car | BMW | 320I | Grey | Contravening a Red Traffic Light | None | A34 Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 7714 | op-snap---monthly-publication-february-2026.pdf | 461 | 2026-02 | Pedal Bike | BMW | M3 | Red | Fail to display front VRM plate | None | Watford Road | Watford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4182952 | -1.9316395 | ||
| 7866 | op-snap---monthly-publication-february-2026.pdf | 613 | 2026-02 | Pedal Bike | BMW | m3 | Blue | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 7889 | op-snap---monthly-publication-february-2026.pdf | 636 | 2026-02 | Car | BMW | M340i | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ellesmere Road, Saltley | Ellesmere Road, Saltley | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4881533 | -1.8553625 | ||
| 7951 | op-snap---monthly-publication-february-2026.pdf | 698 | 2026-02 | Pedal Bike | BMW | 118.. | Black | Using a Mobile Phone Whilst Driving | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4103191 | -1.8670224 | ||
| 8023 | op-snap---monthly-publication-february-2026.pdf | 770 | 2026-02 | Pedal Bike | BMW | 520d | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 8215 | op-snap---monthly-publication-february-2026.pdf | 962 | 2026-02 | Car | BMW | X1 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Silverthorne Lane | Silverthorne Lane | Dudley | Dudley | Fixed Penalty | N/A | ||||
| 8309 | op-snap---monthly-publication-february-2026.pdf | 1056 | 2026-02 | Car | BMW | 420 | Black | Contravening a Red Traffic Light | None | Causeway Green Road | Causeway Green Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4831146 | -2.0169818 | ||
| 8312 | op-snap---monthly-publication-february-2026.pdf | 1059 | 2026-02 | Car | BMW | 320 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4929304 | -1.8229092 | ||
| 8335 | op-snap---monthly-publication-february-2026.pdf | 1082 | 2026-02 | Pedestrian | BMW | 320d | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lentons Lane | Lentons Lane | Coventry | Coventry | Fixed Penalty | N/A | 52.4503238 | -1.4546397 | ||
| 8387 | op-snap---monthly-publication-february-2026.pdf | 1134 | 2026-02 | Car | BMW | 730D | Black | Driving without Due Care and Attention | None | Oldbury Road | Oldbury Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5018196 | -1.9811249 | ||
| 8681 | op-snap---monthly-publication-february-2026.pdf | 1428 | 2026-02 | Car | BMW | 118 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 8822 | op-snap---monthly-publication-february-2026.pdf | 1569 | 2026-02 | Pedestrian | BMW | 320 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 8824 | op-snap---monthly-publication-february-2026.pdf | 1571 | 2026-02 | Pedestrian | BMW | 420 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 8827 | op-snap---monthly-publication-february-2026.pdf | 1574 | 2026-02 | Other | BMW | 118 | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5265939 | -1.8509884 | ||
| 10938 | op-snap---monthly-publication-january-2026.pdf | 399 | 2026-01 | Car | BMW | X1 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oakslade Road | Oakslade Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 11057 | op-snap---monthly-publication-january-2026.pdf | 518 | 2026-01 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Fixed Penalty | N/A | 52.4693896 | -2.1251602 | ||
| 11068 | op-snap---monthly-publication-january-2026.pdf | 529 | 2026-01 | Pedestrian | BMW | 5 series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 11113 | op-snap---monthly-publication-january-2026.pdf | 574 | 2026-01 | Pedal Bike | BMW | 420D | Blue | Using a Mobile Phone Whilst Driving | None | Aston Web Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468506 | -1.9395619 | ||
| 11160 | op-snap---monthly-publication-january-2026.pdf | 621 | 2026-01 | Car | BMW | 220d | White | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4656414 | -1.9852276 | ||
| 11162 | op-snap---monthly-publication-january-2026.pdf | 623 | 2026-01 | Car | BMW | 116D | White | No Insurance | None | Westfield Road, Acocks Green | Westfield Road, Acocks Green | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4479234 | -1.8296687 | ||
| 11215 | op-snap---monthly-publication-january-2026.pdf | 676 | 2026-01 | Pedal Bike | BMW | 320D | White | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 11217 | op-snap---monthly-publication-january-2026.pdf | 678 | 2026-01 | Pedal Bike | BMW | 120 SPORT | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 11341 | op-snap---monthly-publication-january-2026.pdf | 802 | 2026-01 | Car | BMW | X5 | Grey | Using a Mobile Phone Whilst Driving | None | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | Fixed Penalty | N/A | 52.4167172 | -1.7990388 | ||
| 11569 | op-snap---monthly-publication-january-2026.pdf | 1030 | 2026-01 | Pedal Bike | BMW | 1 series | White | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 11592 | op-snap---monthly-publication-january-2026.pdf | 1053 | 2026-01 | Car | BMW | 118I | Grey | Driving without Due Care and Attention | None | Birchley Island | Birchley Island | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4926604 | -2.0216743 | ||
| 11749 | op-snap---monthly-publication-january-2026.pdf | 1210 | 2026-01 | Car | BMW | X5 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.502683 | -1.9033516 | ||
| 11765 | op-snap---monthly-publication-january-2026.pdf | 1226 | 2026-01 | Car | BMW | 320D | Grey | Driving without Due Care and Attention | None | Styvechale Croft | Styvechale Croft | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 11766 | op-snap---monthly-publication-january-2026.pdf | 1227 | 2026-01 | Pedal Bike | BMW | 320i | Grey | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 11772 | op-snap---monthly-publication-january-2026.pdf | 1233 | 2026-01 | Car | BMW | 420 D | Black | VRM fails to conform to Regulations | None | Wallows Lane | Wallows Lane | Metropolitan Borough of Walsall | Walsall | Fixed Penalty | N/A | 52.5699435 | -2.0008354 | ||
| 11781 | op-snap---monthly-publication-january-2026.pdf | 1242 | 2026-01 | Car | BMW | 320.. | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Springfield Road | Springfield Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.4865171 | -1.9991074 | ||
| 11786 | op-snap---monthly-publication-january-2026.pdf | 1247 | 2026-01 | Pedestrian | BMW | 218 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11791 | op-snap---monthly-publication-january-2026.pdf | 1252 | 2026-01 | Car | BMW | 320 | Black | Driving without Due Care and Attention | None | Coneygree Road | Coneygree Road | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5166627 | -2.0629713 | ||
| 11799 | op-snap---monthly-publication-january-2026.pdf | 1260 | 2026-01 | Pedestrian | BMW | 320D | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No Insurance | Narrow Lane | Narrow Lane | Halesowen | Halesowen | Fixed Penalty | N/A | 52.5750843 | -2.0018786 | ||
| 11812 | op-snap---monthly-publication-january-2026.pdf | 1273 | 2026-01 | Pedestrian | BMW | X5.. | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | Fixed Penalty | N/A | ||||
| 11841 | op-snap---monthly-publication-january-2026.pdf | 1302 | 2026-01 | Pedal Bike | BMW | X3.. | Grey | Using a Mobile Phone Whilst Driving | None | Pebble Mill Road | Pebble Mill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4512925 | -1.9124618 | ||
| 11870 | op-snap---monthly-publication-january-2026.pdf | 1331 | 2026-01 | Pedal Bike | BMW | 320D | Grey | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 4016 | op-snap---monthly-publication-december-2025.pdf | 144 | 2025-12 | Pedal Bike | BMW | i4 | Green | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 4028 | op-snap---monthly-publication-december-2025.pdf | 156 | 2025-12 | Car | BMW | X4 | Red | Vehicle overtake within crossing limits | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 4031 | op-snap---monthly-publication-december-2025.pdf | 159 | 2025-12 | Car | BMW | 5 series | Black | Driving without Due Care and Attention | None | Fenton Street, Smethwick | Fenton Street, Smethwick | Sandwell | Sandwell | Fixed Penalty | N/A | 52.5003489 | -1.9788331 | ||
| 4154 | op-snap---monthly-publication-december-2025.pdf | 282 | 2025-12 | Pedal Bike | BMW | X5.. | Black | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 4160 | op-snap---monthly-publication-december-2025.pdf | 288 | 2025-12 | Pedal Bike | BMW | M4 | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 | ||
| 4301 | op-snap---monthly-publication-december-2025.pdf | 429 | 2025-12 | Pedal Bike | BMW | 5 series | Black | Using a Mobile Phone Whilst Driving | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 4356 | op-snap---monthly-publication-december-2025.pdf | 484 | 2025-12 | Pedal Bike | BMW | 120d | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 4428 | op-snap---monthly-publication-december-2025.pdf | 556 | 2025-12 | Pedal Bike | BMW | X3 | Black | Using a Mobile Phone Whilst Driving | None | A45 | A45 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 4474 | op-snap---monthly-publication-december-2025.pdf | 602 | 2025-12 | Car | BMW | ! Series | Black | Driving without Due Care and Attention | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5012458 | -1.8780942 | ||
| 4657 | op-snap---monthly-publication-december-2025.pdf | 785 | 2025-12 | Pedal Bike | BMW | 320d | White | Using a Mobile Phone Whilst Driving | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 4748 | op-snap---monthly-publication-december-2025.pdf | 876 | 2025-12 | Car | BMW | 218 | Grey | Using a Mobile Phone Whilst Driving | None | M6 South near Essington | M6 South near Essington | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 4841 | op-snap---monthly-publication-december-2025.pdf | 969 | 2025-12 | Car | BMW | 116.. | Grey | Using a Mobile Phone Whilst Driving | No vehicle excise licence | Chester Road | Chester Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 4858 | op-snap---monthly-publication-december-2025.pdf | 986 | 2025-12 | Pedestrian | BMW | M8 | Black | Using a Mobile Phone Whilst Driving | None | Regent Place | Regent Place | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 5008 | op-snap---monthly-publication-december-2025.pdf | 1136 | 2025-12 | Car | BMW | 435D | White | Driving without Due Care and Attention | Contravening a Red Traffic Li | gAh4t5 | g Ah4t5 | Coventry | Coventry | Fixed Penalty | N/A | ||||
| 20528 | op-snap---monthly-publication-november-2025.pdf | 70 | 2025-11 | Pedal Bike | BMW | 320d | White | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20535 | op-snap---monthly-publication-november-2025.pdf | 77 | 2025-11 | Car | BMW | 335D | Black | Driving without Due Care and Attention | None | Watercall Avenue | Watercall Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848987 | -1.511199 | ||
| 20583 | op-snap---monthly-publication-november-2025.pdf | 125 | 2025-11 | Car | BMW | 118I | Blue | Driving without Due Care and Attention | None | Heathfield Road | Heathfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5905365 | -1.8453418 | ||
| 20606 | op-snap---monthly-publication-november-2025.pdf | 148 | 2025-11 | Pedal Bike | BMW | X1 | White | Using a Mobile Phone Whilst Driving | None | Harborne High Street | Harborne High Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.459563 | -1.946922 | ||
| 20728 | op-snap---monthly-publication-november-2025.pdf | 270 | 2025-11 | Pedal Bike | BMW | X3 | Blue | Using a Mobile Phone Whilst Driving | None | Foleshill Road | Foleshill Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4274335 | -1.5002381 | ||
| 20757 | op-snap---monthly-publication-november-2025.pdf | 299 | 2025-11 | Pedal Bike | BMW | X1 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 20986 | op-snap---monthly-publication-november-2025.pdf | 528 | 2025-11 | Pedal Bike | BMW | 320.. | Black | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21112 | op-snap---monthly-publication-november-2025.pdf | 654 | 2025-11 | Pedal Bike | BMW | 520D | Black | Using a Mobile Phone Whilst Driving | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4381959 | -1.8907391 | ||
| 21385 | op-snap---monthly-publication-november-2025.pdf | 927 | 2025-11 | Pedal Bike | BMW | 218D | Grey | Using a Mobile Phone Whilst Driving | None | Moseley Av Cov | Moseley Avenue Cov | Coventry | Coventry | Fixed Penalty | N/A | 52.417344 | -1.5264979 | ||
| 21700 | op-snap---monthly-publication-november-2025.pdf | 1242 | 2025-11 | Pedal Bike | BMW | 120d | Blue | Using a Mobile Phone Whilst Driving | None | Bell Green Road | Bell Green Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4324855 | -1.4815548 | ||
| 21861 | op-snap---monthly-publication-november-2025.pdf | 1403 | 2025-11 | Pedal Bike | BMW | IX3 | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 21954 | op-snap---monthly-publication-november-2025.pdf | 1496 | 2025-11 | Pedal Bike | BMW | X5 | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 22008 | op-snap---monthly-publication-november-2025.pdf | 1550 | 2025-11 | Car | BMW | 330.. | Black | Contravening a Red Traffic Light | None | Reddings Lane at Battery Way | Reddings Lane at Battery Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4454569 | -1.8475135 | ||
| 22027 | op-snap---monthly-publication-november-2025.pdf | 1569 | 2025-11 | Pedal Bike | BMW | 3 series | Black | Using a Mobile Phone Whilst Driving | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4353506 | -1.8927483 | ||
| 22273 | op-snap---monthly-publication-october-2025.pdf | 223 | 2025-10 | Pedestrian | BMW | 320.. | Beige | Using a Mobile Phone Whilst Driving | None | Bishop Street | Bishop Street | Coventry | Coventry | Fixed Penalty | N/A | 52.411051 | -1.5111644 | ||
| 22306 | op-snap---monthly-publication-october-2025.pdf | 256 | 2025-10 | Car | BMW | 330d | Blue | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 22370 | op-snap---monthly-publication-october-2025.pdf | 320 | 2025-10 | Car | BMW | 116 | Grey | Driving without Due Care and Attention | None | Holyhead Road | Holyhead Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.505233 | -1.9446276 | ||
| 22399 | op-snap---monthly-publication-october-2025.pdf | 349 | 2025-10 | Pedal Bike | BMW | 118.. | Grey | Using a Mobile Phone Whilst Driving | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4718503 | -1.9195423 | ||
| 22562 | op-snap---monthly-publication-october-2025.pdf | 512 | 2025-10 | Car | BMW | X5 | Grey | Driving without Due Care and Attention | None | Kings Road | Kings Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5531351 | -1.8852761 | ||
| 22614 | op-snap---monthly-publication-october-2025.pdf | 564 | 2025-10 | Car | BMW | 118D | White | Driving without Due Care and Attention | None | Soho Road | Soho Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.502568 | -1.9305447 | ||
| 22638 | op-snap---monthly-publication-october-2025.pdf | 588 | 2025-10 | Car | BMW | 116i | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lower Queen Street | Lower Queen Street | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.5603978 | -1.8227403 | ||
| 22641 | op-snap---monthly-publication-october-2025.pdf | 591 | 2025-10 | Pedal Bike | BMW | X5 | Black | Using a Mobile Phone Whilst Driving | None | New Fosse Way | New Fosse Way | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4473373 | -1.9392405 | ||
| 22644 | op-snap---monthly-publication-october-2025.pdf | 594 | 2025-10 | Lorry | BMW | M140. | Black | Driving without Due Care and Attention | None | Keyway Junction Roundabout | Keyway Junction Roundabout | Wolverhampton | Wolverhampton | Fixed Penalty | N/A | ||||
| 22663 | op-snap---monthly-publication-october-2025.pdf | 613 | 2025-10 | Car | BMW | 320.. | White | Using a Mobile Phone Whilst Driving | None | M6 Jct 8 | M6 Junction 8 | Birmingham | Birmingham | Fixed Penalty | N/A | 52.6912891 | -2.1046372 | ||
| 22838 | op-snap---monthly-publication-october-2025.pdf | 788 | 2025-10 | Car | BMW | 320D | Black | Driving without Due Care and Attention | None | Newton Row | Newton Row | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 22843 | op-snap---monthly-publication-october-2025.pdf | 793 | 2025-10 | Car | BMW | 118.. | Orange | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5170745 | -1.9012542 | ||
| 23821 | op-snap---monthly-publication-september-2025.pdf | 40 | 2025-09 | Pedestrian | BMW | 4 series | White | Motor vehicle fail to accord precedence at a pelic | an crossing None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552785 | -1.906384 | ||
| 23986 | op-snap---monthly-publication-september-2025.pdf | 205 | 2025-09 | Car | BMW | 320.. | White | Driving without Due Care and Attention | None | Wash Lane Yardley Wood | Wash Lane Yardley Wood | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24134 | op-snap---monthly-publication-september-2025.pdf | 353 | 2025-09 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Hobbs Road | Hobbs Road | Sandwell | Sandwell | Fixed Penalty | N/A | ||||
| 24140 | op-snap---monthly-publication-september-2025.pdf | 359 | 2025-09 | Car | BMW | 118 | Grey | Driving without Due Care and Attention | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4468464 | -1.9454816 | ||
| 24148 | op-snap---monthly-publication-september-2025.pdf | 367 | 2025-09 | Pedal Bike | BMW | Black | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | |||
| 24283 | op-snap---monthly-publication-september-2025.pdf | 502 | 2025-09 | Pedestrian | BMW | 1 series | Black | Using a Mobile Phone Whilst Driving | None | Roundabout of Springfild Rd, Poplar Road, Kings Heath | Roundabout of Springfild Road, Poplar Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24511 | op-snap---monthly-publication-september-2025.pdf | 730 | 2025-09 | Pedal Bike | BMW | M135 | Grey | Driving without Due Care and Attention | None | Tanners Lane Coventry | Tanners Lane Coventry | Coventry | Coventry | Fixed Penalty | N/A | 52.4007746 | -1.5997847 | ||
| 24613 | op-snap---monthly-publication-september-2025.pdf | 832 | 2025-09 | Car | BMW | i4 | Grey | Using a Mobile Phone Whilst Driving | None | Wright Street, Halesowen | Wright Street, Halesowen | Halesowen | Halesowen | Fixed Penalty | N/A | 52.4514959 | -2.0468797 | ||
| 24668 | op-snap---monthly-publication-september-2025.pdf | 887 | 2025-09 | Car | BMW | 3 series | Blue | Contravening a Red Traffic Light | None | Reddings Lane and Battery Way junction | Reddings Lane and Battery Way junction | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4454569 | -1.8475135 | ||
| 24749 | op-snap---monthly-publication-september-2025.pdf | 968 | 2025-09 | Car | BMW | X4.. | Grey | Contravening a Red Traffic Light | None | Camp Hill Midlleway | Camp Hill Midlleway | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24772 | op-snap---monthly-publication-september-2025.pdf | 991 | 2025-09 | Car | BMW | M340D | Black | Driving without Due Care and Attention | None | Hall Street | Hall Street | Dudley | Dudley | Fixed Penalty | N/A | 52.5409774 | -2.1235921 | ||
| 24777 | op-snap---monthly-publication-september-2025.pdf | 996 | 2025-09 | Car | BMW | X3 | Black | Contravening a Red Traffic Light | None | Battery Road at Warwick Road | Battery Road at Warwick Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4429462 | -1.9379408 | ||
| 24805 | op-snap---monthly-publication-september-2025.pdf | 1024 | 2025-09 | Car | BMW | 116.. | Black | Driving without Due Care and Attention | None | Kitts Green Road | Kitts Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4815372 | -1.7766518 | ||
| 24947 | op-snap---monthly-publication-september-2025.pdf | 1166 | 2025-09 | Pedal Bike | BMW | 218I | White | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 2032 | op-snap---monthly-publication-august-2025.pdf | 7 | 2025-08 | Car | BMW | 525I | Grey | Driving without Due Care and Attention | None | Richmond Hill Road | Richmond Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4607238 | -1.935227 | ||
| 2117 | op-snap---monthly-publication-august-2025.pdf | 92 | 2025-08 | Car | BMW | SUV | Black | Using a Mobile Phone Whilst Driving | None | Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 | Middle lane of the M5 JUNCTION 1 AND M6 JUNCTION 8 | Sandwell | Sandwell | Fixed Penalty | N/A |
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);