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'}
1,243 rows where council_area = "Birmingham" 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, nfa_rationale, witness_contacted
offence >30
- Driving without Due Care and Attention 323
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 201
- Contravening a Red Traffic Light 139
- Cause vehicle to be left in a dangerous position 118
- Stop a vehicle within pelican pedestrian crossing limits 86
- Using a Mobile Phone Whilst Driving 85
- Driving without Reasonable Consideration 78
- Misc - Non Traffic Offences 37
- Stop a vehicle on pedestrian crossing 37
- Cause unnecessary obstruction by motor vehicle 20
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 20
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 19
- VRM fails to conform to Regulations 16
- Contravene Lane Closure Red X 10
- Dangerous Driving 8
- Fail to display front VRM plate 5
- Drive / Ride / Lead an animal on a footpath 4
- Drive on hard shoulder 4
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 4
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 4
- Vehicle overtake within crossing limits 4
- Motor vehicle fail to accord precedence at a pelican crossing 3
- No Insurance 3
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Driving a vehicle wholly or partly on a footpath 2
- Drive a motor vehicle when the VRM fails to conform to regulations. 1
- Driver not in position to have Proper Control 1
- MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
- Motor vehicle fail to accord precedence at a pelic 1
- …
month 14
reporter_transport_mode 8
- Car 713
- Pedestrian 330
- Pedal Bike 157
- Other 34
- Lorry 4
- Motorbike 3
- Bus 1
- Van 1
disposal 7
- Warning Letter 366
- NFA 352
- Fixed Penalty 248
- Education 204
- Court 56
- Other Action Taken 13
- RTC - Actioned 4
vehicle_make 1
- BMW · 1,243 ✖
council_area 1
- Birmingham · 1,243 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7305 | op-snap---monthly-publication-february-2026.pdf | 52 | 2026-02 | Pedal Bike | BMW | Black | Driving without Due Care and Attention | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Education | N/A | 52.4415108 | -1.8971434 | |||
| 7335 | op-snap---monthly-publication-february-2026.pdf | 82 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 7342 | op-snap---monthly-publication-february-2026.pdf | 89 | 2026-02 | Car | BMW | 116D | Red | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5170745 | -1.9012542 | ||
| 7345 | op-snap---monthly-publication-february-2026.pdf | 92 | 2026-02 | Car | BMW | X4 | White | Driving without Due Care and Attention | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 7373 | op-snap---monthly-publication-february-2026.pdf | 120 | 2026-02 | Pedestrian | BMW | 116d | White | Cause vehicle to be left in a dangerous position | None | Ellesmere Road | Ellesmere Road | Birmingham | Birmingham | Education | N/A | 52.4881533 | -1.8553625 | ||
| 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 | ||
| 7447 | op-snap---monthly-publication-february-2026.pdf | 194 | 2026-02 | Pedestrian | BMW | 218I | White | Stop a vehicle on pedestrian crossing | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 7458 | op-snap---monthly-publication-february-2026.pdf | 205 | 2026-02 | Car | BMW | 3 series | white | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brixham Road | Brixham Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4861697 | -1.9479823 | ||
| 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 | ||
| 7599 | op-snap---monthly-publication-february-2026.pdf | 346 | 2026-02 | Pedestrian | BMW | X Drive | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 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 | ||
| 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 | ||
| 7710 | op-snap---monthly-publication-february-2026.pdf | 457 | 2026-02 | Car | BMW | X3 M | Grey | Driving without Due Care and Attention | None | Heath Way | Heath Way | Birmingham | Birmingham | Education | N/A | 52.4963549 | -1.7806171 | ||
| 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 | ||
| 7725 | op-snap---monthly-publication-february-2026.pdf | 472 | 2026-02 | Car | BMW | 3 series | Black | Contravene Lane Closure Red X | None | M6 SB, before Jn 6 | M6 Southbound, before Junction 6 | Birmingham | Birmingham | Education | N/A | 52.6760749 | -2.0862582 | ||
| 7795 | op-snap---monthly-publication-february-2026.pdf | 542 | 2026-02 | Car | BMW | X1 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Kitts Green Road | Kitts Green Road | Birmingham | Birmingham | Education | N/A | 52.4815372 | -1.7766518 | ||
| 7804 | op-snap---monthly-publication-february-2026.pdf | 551 | 2026-02 | Other | BMW | 1 Series | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Education | N/A | 52.5265939 | -1.8509884 | ||
| 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 | ||
| 7897 | op-snap---monthly-publication-february-2026.pdf | 644 | 2026-02 | Other | BMW | 1 series | Black | Cause vehicle to be left in a dangerous position | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Education | N/A | 52.5265939 | -1.8509884 | ||
| 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 | ||
| 8037 | op-snap---monthly-publication-february-2026.pdf | 784 | 2026-02 | Car | BMW | 320i | Grey | Driving without Due Care and Attention | None | Holloway Circus Queensway | Holloway Circus Queensway | Birmingham | Birmingham | NFA | No Offence | 52.4751679 | -1.9006538 | ||
| 8038 | op-snap---monthly-publication-february-2026.pdf | 785 | 2026-02 | Car | BMW | X3.. | White | Misc - Non Traffic Offences | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.471632 | -1.9456776 | ||
| 8053 | op-snap---monthly-publication-february-2026.pdf | 800 | 2026-02 | Car | BMW | 320D | Silver | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5531351 | -1.8852761 | ||
| 8073 | op-snap---monthly-publication-february-2026.pdf | 820 | 2026-02 | Car | BMW | 4 series | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 8074 | op-snap---monthly-publication-february-2026.pdf | 821 | 2026-02 | Car | BMW | 4 series | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Education | N/A | 52.5517052 | -1.7825505 | ||
| 8098 | op-snap---monthly-publication-february-2026.pdf | 845 | 2026-02 | Car | BMW | 520.. | White | Driving without Due Care and Attention | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | Education | N/A | 52.5038363 | -1.8432663 | ||
| 8112 | op-snap---monthly-publication-february-2026.pdf | 859 | 2026-02 | Car | BMW | 320d | Blue | Driving without Due Care and Attention | None | Hockley Circus | Hockley Circus | Birmingham | Birmingham | Education | N/A | 52.4952382 | -1.9146705 | ||
| 8117 | op-snap---monthly-publication-february-2026.pdf | 864 | 2026-02 | Other | BMW | 525d | Silver | Misc - Non Traffic Offences | None | Spring Road | Spring Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.444262 | -1.8362585 | ||
| 8120 | op-snap---monthly-publication-february-2026.pdf | 867 | 2026-02 | Other | BMW | 220.. | Grey | Misc - Non Traffic Offences | None | Spring Road | Spring Road | Birmingham | Birmingham | Other Action Taken | N/A | 52.444262 | -1.8362585 | ||
| 8133 | op-snap---monthly-publication-february-2026.pdf | 880 | 2026-02 | Pedestrian | BMW | X6 | White | Stop a vehicle within pelican pedestrian crossing limits | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 8134 | op-snap---monthly-publication-february-2026.pdf | 881 | 2026-02 | Pedestrian | BMW | 320.. | White | Cause vehicle to be left in a dangerous position | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 8151 | op-snap---monthly-publication-february-2026.pdf | 898 | 2026-02 | Pedestrian | BMW | 435D | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4308271 | -1.920078 | ||
| 8175 | op-snap---monthly-publication-february-2026.pdf | 922 | 2026-02 | Car | BMW | X5 | Black | VRM fails to conform to Regulations | None | Victoria Road | Victoria Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5615573 | -1.820549 | ||
| 8188 | op-snap---monthly-publication-february-2026.pdf | 935 | 2026-02 | Car | BMW | 320.. | Blue | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 8229 | op-snap---monthly-publication-february-2026.pdf | 976 | 2026-02 | Pedestrian | BMW | 530.. | Green | 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 | ||
| 8232 | op-snap---monthly-publication-february-2026.pdf | 979 | 2026-02 | Pedestrian | BMW | 520D | Black | Cause vehicle to be left in a dangerous position | None | Sandwell Road at Grafton Road | Sandwell Road at Grafton Road | Birmingham | Birmingham | Education | N/A | 52.512234 | -1.9484634 | ||
| 8252 | op-snap---monthly-publication-february-2026.pdf | 999 | 2026-02 | Car | BMW | S1000 XR | Grey | Driving without Due Care and Attention | Contravening a Red Traffic Light | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Court | N/A | 52.5012458 | -1.8780942 | ||
| 8256 | op-snap---monthly-publication-february-2026.pdf | 1003 | 2026-02 | Pedestrian | BMW | 520d | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 8284 | op-snap---monthly-publication-february-2026.pdf | 1031 | 2026-02 | Other | 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 | NFA | No Independent Evidence Available | ||||
| 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 | ||
| 8325 | op-snap---monthly-publication-february-2026.pdf | 1072 | 2026-02 | Pedestrian | BMW | 1 | White | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 8334 | op-snap---monthly-publication-february-2026.pdf | 1081 | 2026-02 | Pedestrian | BMW | X4 | Black | Driving without Due Care and Attention | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Education | N/A | 52.4762433 | -1.9176665 | ||
| 8341 | op-snap---monthly-publication-february-2026.pdf | 1088 | 2026-02 | Car | BMW | X5 | Grey | Drive on hard shoulder | None | M6 motorway at the A38 exit, jn 6 | M6 motorway at the A38 exit, jn 6 | Birmingham | Birmingham | Education | N/A | ||||
| 8380 | op-snap---monthly-publication-february-2026.pdf | 1127 | 2026-02 | Car | BMW | 320D | 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 | ||
| 8395 | op-snap---monthly-publication-february-2026.pdf | 1142 | 2026-02 | Car | BMW | 420D | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Witton Road | Witton Road | Birmingham | Birmingham | Education | N/A | 52.513336 | -1.8833226 | ||
| 8407 | op-snap---monthly-publication-february-2026.pdf | 1154 | 2026-02 | Car | BMW | 220.. | Grey | Driving without Due Care and Attention | No Insurance | Spring Road Tysley | Spring Road Tysley | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8421 | op-snap---monthly-publication-february-2026.pdf | 1168 | 2026-02 | Car | BMW | 330.. | Black | Driving without Due Care and Attention | None | A34 Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 8497 | op-snap---monthly-publication-february-2026.pdf | 1244 | 2026-02 | Car | BMW | 1 Series | Blue | Driving without Due Care and Attention | No Insurance | M6 | M6 | Birmingham | Birmingham | Other Action Taken | N/A | ||||
| 8516 | op-snap---monthly-publication-february-2026.pdf | 1263 | 2026-02 | Car | BMW | 320I | Black | Driving without Due Care and Attention | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Court | N/A | 52.4216321 | -1.855984 | ||
| 8601 | op-snap---monthly-publication-february-2026.pdf | 1348 | 2026-02 | Car | BMW | m3 | Grey | 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 | ||
| 8612 | op-snap---monthly-publication-february-2026.pdf | 1359 | 2026-02 | Pedal Bike | BMW | 118d | Silver | Driving without Due Care and Attention | None | Aston Webb Boulevard | Aston Webb Boulevard | Birmingham | Birmingham | Education | N/A | 52.4468506 | -1.9395619 | ||
| 8638 | op-snap---monthly-publication-february-2026.pdf | 1385 | 2026-02 | Pedestrian | BMW | 320I | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | tividale hall road | Tividale Hall Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8640 | op-snap---monthly-publication-february-2026.pdf | 1387 | 2026-02 | Pedestrian | BMW | 118i | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | deepmore road | Deepmore Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 8648 | op-snap---monthly-publication-february-2026.pdf | 1395 | 2026-02 | Car | BMW | 520D | 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 | ||
| 8649 | op-snap---monthly-publication-february-2026.pdf | 1396 | 2026-02 | Car | BMW | 318i | 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 | ||
| 8685 | op-snap---monthly-publication-february-2026.pdf | 1432 | 2026-02 | Car | BMW | 520D | Blue | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Education | N/A | 52.5012458 | -1.8780942 | ||
| 8700 | op-snap---monthly-publication-february-2026.pdf | 1447 | 2026-02 | Pedal Bike | BMW | 1 Series | Blue | Driving without Due Care and Attention | None | Dads Lane | Dads Lane | Birmingham | Birmingham | Court | N/A | 52.4375913 | -1.9068522 | ||
| 8704 | op-snap---monthly-publication-february-2026.pdf | 1451 | 2026-02 | Car | BMW | 520d | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | garrets green lane | Garrets Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4657981 | -1.7964101 | ||
| 8708 | op-snap---monthly-publication-february-2026.pdf | 1455 | 2026-02 | Pedestrian | BMW | roadster | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brighton road | Brighton road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543156 | -1.8840717 | ||
| 8746 | op-snap---monthly-publication-february-2026.pdf | 1493 | 2026-02 | Car | BMW | 5 series | Grey | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | 52.4552785 | -1.906384 | |||
| 8785 | op-snap---monthly-publication-february-2026.pdf | 1532 | 2026-02 | Car | BMW | X3 | White | Driving without Due Care and Attention | None | Bromford Road / Bromford Lane | Bromford Road / Bromford Lane | Birmingham | Birmingham | NFA | No VRM | 52.503036 | -1.8289972 | ||
| 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 | ||||
| 8826 | op-snap---monthly-publication-february-2026.pdf | 1573 | 2026-02 | Car | BMW | 320i | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | colehsill road | Colehsill Road | Birmingham | Birmingham | Warning Letter | 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 | ||
| 10640 | op-snap---monthly-publication-january-2026.pdf | 101 | 2026-01 | Other | BMW | 3 series | blue | Driving without Due Care and Attention | None | Star City car park | Star City car park | Birmingham | Birmingham | Education | N/A | ||||
| 10641 | op-snap---monthly-publication-january-2026.pdf | 102 | 2026-01 | Other | BMW | 3 series | black | Driving without Due Care and Attention | None | Star City car park | Star City car park | Birmingham | Birmingham | Education | N/A | ||||
| 10672 | op-snap---monthly-publication-january-2026.pdf | 133 | 2026-01 | Car | BMW | 320d | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | High Street, Deritend | High Street, Deritend | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4746492 | -1.8839977 | ||
| 10692 | op-snap---monthly-publication-january-2026.pdf | 153 | 2026-01 | Other | BMW | X3.. | White | Misc - Non Traffic Offences | None | Canal Court | Canal Court | Birmingham | Birmingham | Warning Letter | N/A | 52.4486586 | -1.8085554 | ||
| 10768 | op-snap---monthly-publication-january-2026.pdf | 229 | 2026-01 | Car | BMW | X6 | White | Driving without Due Care and Attention | None | Green lane | Green lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4618966 | -1.9955421 | ||
| 10784 | op-snap---monthly-publication-january-2026.pdf | 245 | 2026-01 | Car | BMW | 320d | 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 | ||
| 10796 | op-snap---monthly-publication-january-2026.pdf | 257 | 2026-01 | Pedestrian | BMW | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodstock Rd Moseley | Woodstock Road Moseley | Birmingham | Birmingham | Warning Letter | N/A | 52.4486205 | -1.8740822 | |||
| 10860 | op-snap---monthly-publication-january-2026.pdf | 321 | 2026-01 | Pedestrian | BMW | 420D | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poston Croft | Poston Croft | Birmingham | Birmingham | Warning Letter | N/A | 52.4134513 | -1.8988349 | ||
| 10881 | op-snap---monthly-publication-january-2026.pdf | 342 | 2026-01 | Car | BMW | 520 D | White | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 10891 | op-snap---monthly-publication-january-2026.pdf | 352 | 2026-01 | Car | BMW | 118D | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 10949 | op-snap---monthly-publication-january-2026.pdf | 410 | 2026-01 | Car | BMW | 118D | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 10992 | op-snap---monthly-publication-january-2026.pdf | 453 | 2026-01 | Pedal Bike | BMW | 740LD | Blue | Using a Mobile Phone Whilst Driving | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4591339 | -1.9601054 | ||
| 11004 | op-snap---monthly-publication-january-2026.pdf | 465 | 2026-01 | Other | BMW | X3 M | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cambridge Crescent | Cambridge Crescent | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4652475 | -1.9056734 | ||
| 11007 | op-snap---monthly-publication-january-2026.pdf | 468 | 2026-01 | Other | BMW | White | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Canal Court | Canal Court | Birmingham | Birmingham | NFA | No VRM | 52.4486586 | -1.8085554 | |||
| 11011 | op-snap---monthly-publication-january-2026.pdf | 472 | 2026-01 | Car | BMW | 1 Series | Blue | Driving without Due Care and Attention | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Education | N/A | 52.4656414 | -1.9852276 | ||
| 11015 | op-snap---monthly-publication-january-2026.pdf | 476 | 2026-01 | Car | BMW | M3 | Black | Driving without Due Care and Attention | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.505832 | -1.92002 | ||
| 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 | ||||
| 11091 | op-snap---monthly-publication-january-2026.pdf | 552 | 2026-01 | Pedal Bike | BMW | z4 | Red | Driving without Due Care and Attention | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Education | N/A | 52.4150779 | -1.930901 | ||
| 11096 | op-snap---monthly-publication-january-2026.pdf | 557 | 2026-01 | Pedestrian | BMW | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4170522 | -1.8906187 | |||
| 11103 | op-snap---monthly-publication-january-2026.pdf | 564 | 2026-01 | Car | BMW | 118D | White | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 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 | ||
| 11136 | op-snap---monthly-publication-january-2026.pdf | 597 | 2026-01 | Pedal Bike | BMW | 335D | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | Education | N/A | 52.4390303 | -1.9512931 | ||
| 11145 | op-snap---monthly-publication-january-2026.pdf | 606 | 2026-01 | Car | BMW | M3 | White | Driving without Due Care and Attention | Contravening a Red Traffic Light | Linden Rd | Linden Road | Birmingham | Birmingham | Court | N/A | 52.4263156 | -1.9351622 | ||
| 11156 | op-snap---monthly-publication-january-2026.pdf | 617 | 2026-01 | Pedestrian | BMW | X5 | Black | Cause vehicle to be left in a dangerous position | None | Anglesey Street | Anglesey Street | Birmingham | Birmingham | Education | N/A | 52.5000379 | -1.9102942 | ||
| 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 | ||
| 11172 | op-snap---monthly-publication-january-2026.pdf | 633 | 2026-01 | Car | BMW | X1 | White | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 11236 | op-snap---monthly-publication-january-2026.pdf | 697 | 2026-01 | Other | BMW | 520D | Black | 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 | ||||
| 11263 | op-snap---monthly-publication-january-2026.pdf | 724 | 2026-01 | Pedestrian | BMW | 1 series | Black | Misc - Non Traffic Offences | None | Freer Road | Freer Road | Birmingham | Birmingham | NFA | No Offence | 52.5074462 | -1.8979307 | ||
| 11281 | op-snap---monthly-publication-january-2026.pdf | 742 | 2026-01 | Pedal Bike | BMW | 320D | White | Driving without Due Care and Attention | None | Wrentham Street | Wrentham Street | Birmingham | Birmingham | Education | N/A | 52.4708757 | -1.8966158 | ||
| 11296 | op-snap---monthly-publication-january-2026.pdf | 757 | 2026-01 | Pedestrian | BMW | 116d | White | Misc - Non Traffic Offences | None | Maitland Road | Maitland Road | Birmingham | Birmingham | NFA | No Offence | 52.4868494 | -1.8448776 |
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);