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,300 rows where reporter_transport_mode = "Car" 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 540
- Contravening a Red Traffic Light 240
- Driving without Reasonable Consideration 87
- Stop a vehicle within pelican pedestrian crossing limits 75
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 66
- Cause vehicle to be left in a dangerous position 54
- Using a Mobile Phone Whilst Driving 43
- Misc - Non Traffic Offences 40
- Stop a vehicle on pedestrian crossing 24
- VRM fails to conform to Regulations 22
- Dangerous Driving 15
- Cause unnecessary obstruction by motor vehicle 13
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 11
- Contravene Lane Closure Red X 10
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 10
- Drive on hard shoulder 9
- Motor vehicle fail to accord precedence at a pelican crossing 5
- Drive a vehicle other than on the carriageway of a motorway 4
- Fail to display front VRM plate 3
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 3
- No Seat Belt 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- Vehicle overtake within crossing limits 3
- Driver not in position to have Proper Control 2
- Motor vehicle fail to comply with endorsable sect 2
- Motor vehicle fail to comply with solid white line road markings 2
- No Insurance 2
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 2
- Use vehicle on a road without valid test certificate 2
- DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 1
- …
council_area 22
- Birmingham 713
- Out of Force Area 140
- Coventry 79
- Sandwell 75
- Wolverhampton 71
- Dudley 63
- Solihull 61
- Walsall 50
- Sutton Coldfield 28
- Halesowen 8
- )Birmingham 1
- 3B2Irmingham 1
- Ao4U0T9 O7F Force Area 1
- Aorueta Of Force 1
- Area 1
- Bafifromrdin Grhoaamd 1
- Hbeiramthingham 1
- Idseudtt Obny Cprol)Dfield 1
- Ouruyt Of Force Area 1
- Scoouvtehn Try 1
- Two Bolrvaedrmhaomrep Rtooand 1
- Woaurtd Osf Dfeovrcoen Area 1
month 14
disposal 7
- NFA 515
- Warning Letter 264
- Education 241
- Fixed Penalty 174
- Court 90
- Other Action Taken 11
- RTC - Actioned 5
vehicle_make 1
- BMW · 1,300 ✖
reporter_transport_mode 1
- Car · 1,300 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||
| 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 | |||
| 8734 | op-snap---monthly-publication-february-2026.pdf | 1481 | 2026-02 | Car | BMW | X5.. | Grey | Contravening a Red Traffic Light | None | Bloxwich Lane | Bloxwich Lane | Walsall | Walsall | Education | N/A | 52.6020474 | -2.014682 | ||
| 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 | ||
| 8689 | op-snap---monthly-publication-february-2026.pdf | 1436 | 2026-02 | Car | BMW | X6 | White | Driving without Due Care and Attention | None | Birmingham Road (A34) | Birmingham Road (A34) | Walsall | Walsall | Court | N/A | 52.5675147 | -1.9513505 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 8599 | op-snap---monthly-publication-february-2026.pdf | 1346 | 2026-02 | Car | BMW | 435D | Black | Driving without Due Care and Attention | None | Lower Queen | Lower Queen | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.560777 | -1.8219813 | ||
| 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 | ||
| 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 | ||||
| 8479 | op-snap---monthly-publication-february-2026.pdf | 1226 | 2026-02 | Car | BMW | 330D | White | Contravening a Red Traffic Light | None | Bunns Lane | Bunns Lane | Dudley | Dudley | Education | N/A | 52.5111371 | -2.0643295 | ||
| 8472 | op-snap---monthly-publication-february-2026.pdf | 1219 | 2026-02 | Car | BMW | 3 series | Black | Using a Mobile Phone Whilst Driving | None | M4 | M4 | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 8471 | op-snap---monthly-publication-february-2026.pdf | 1218 | 2026-02 | Car | BMW | 330 E | Grey | Driving without Due Care and Attention | No Insurance | Goldthorn Hill | Goldthorn Hill | Wolverhampton | Wolverhampton | NFA | 52.5690522 | -2.1388773 | |||
| 8469 | op-snap---monthly-publication-february-2026.pdf | 1216 | 2026-02 | Car | BMW | 320D | Black | Driving without Due Care and Attention | None | Leamore Lane | Leamore Lane | Walsall | Walsall | Education | N/A | 52.6056653 | -2.0050776 | ||
| 8458 | op-snap---monthly-publication-february-2026.pdf | 1205 | 2026-02 | Car | BMW | 5 series | White | Using a Mobile Phone Whilst Driving | None | Kidderminster Road | Kidderminster Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.5000055 | -2.1844503 | ||
| 8439 | op-snap---monthly-publication-february-2026.pdf | 1186 | 2026-02 | Car | BMW | X5 | White | Driving without Due Care and Attention | None | M5 | M5 | Sandwell | Sandwell | Education | N/A | ||||
| 8432 | op-snap---monthly-publication-february-2026.pdf | 1179 | 2026-02 | Car | BMW | M135i | Blue | Contravening a Red Traffic Light | None | Coleshill Road | Coleshill Road | Sutton Coldfield | Sutton Coldfield | Education | N/A | 52.5613155 | -1.8139826 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 8355 | op-snap---monthly-publication-february-2026.pdf | 1102 | 2026-02 | Car | BMW | 435 | Black | Contravening a Red Traffic Light | None | Robin Hood Lane | Robin Hood Lane | Solihull | Solihull | Education | N/A | 52.422933 | -1.8352662 | ||
| 8344 | op-snap---monthly-publication-february-2026.pdf | 1091 | 2026-02 | Car | BMW | 330... | White | Contravening a Red Traffic Light | None | M6 Jct 9 Slip | M6 Junction 9 Slip | Sandwell | Sandwell | Education | N/A | 52.676119 | -2.0858425 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 8266 | op-snap---monthly-publication-february-2026.pdf | 1013 | 2026-02 | Car | BMW | 7 | Grey | Driving without Due Care and Attention | None | M42 towards Solihull | M42 towards Solihull | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 8249 | op-snap---monthly-publication-february-2026.pdf | 996 | 2026-02 | Car | BMW | 120 Sport | White | Using a Mobile Phone Whilst Driving | None | Scimitar Way | Scimitar Way | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3836203 | -1.4862458 | ||
| 8245 | op-snap---monthly-publication-february-2026.pdf | 992 | 2026-02 | Car | BMW | 5 Series | Blue | Driving without Due Care and Attention | None | Coventry Ring Road | Coventry Ring Road | Coventry | Coventry | NFA | No Independent Evidence Available | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 8163 | op-snap---monthly-publication-february-2026.pdf | 910 | 2026-02 | Car | BMW | 420i | White | Stop a vehicle on pedestrian crossing | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 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 | ||
| 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 | ||
| 8092 | op-snap---monthly-publication-february-2026.pdf | 839 | 2026-02 | Car | BMW | 320d | Red | Contravening a Red Traffic Light | None | Oxley Moor Road | Oxley Moor Road | Wolverhampton | Wolverhampton | Education | N/A | 52.6158347 | -2.1377689 | ||
| 8091 | op-snap---monthly-publication-february-2026.pdf | 838 | 2026-02 | Car | BMW | 116d | Black | Driving without Due Care and Attention | None | M6 EB J4 | M6 Eb J4 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6912891 | -2.1046372 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7996 | op-snap---monthly-publication-february-2026.pdf | 743 | 2026-02 | Car | BMW | 120D | Black | Contravening a Red Traffic Light | None | Tollhouse Way | Tollhouse Way | Sandwell | Sandwell | Education | N/A | 52.5003461 | -1.9782389 | ||
| 7926 | op-snap---monthly-publication-february-2026.pdf | 673 | 2026-02 | Car | BMW | X5 | White | Driving without Due Care and Attention | None | Stafford Rd | Stafford Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6291998 | -2.126312 | ||
| 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 | ||
| 7882 | op-snap---monthly-publication-february-2026.pdf | 629 | 2026-02 | Car | BMW | 318D | Black | Driving without Due Care and Attention | None | London Road | London Road | Coventry | Coventry | Education | N/A | 52.3916468 | -1.4925995 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 7693 | op-snap---monthly-publication-february-2026.pdf | 440 | 2026-02 | Car | BMW | X Drive | Black | Driving without Due Care and Attention | None | M5 Southbound | M5 Southbound | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 7635 | op-snap---monthly-publication-february-2026.pdf | 382 | 2026-02 | Car | BMW | 520.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | High Street Tettenhall | High Street Tettenhall | Wolverhampton | Wolverhampton | Education | N/A | 52.5980906 | -2.168057 | ||
| 7604 | op-snap---monthly-publication-february-2026.pdf | 351 | 2026-02 | Car | BMW | X5 | Grey | Driving without Due Care and Attention | None | M6 Junction 15 | M6 Junction 15 | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.6760749 | -2.0862582 | ||
| 7572 | op-snap---monthly-publication-february-2026.pdf | 319 | 2026-02 | Car | BMW | 325D | Black | Contravening a Red Traffic Light | None | Danford Lane at Blossomfield Road | Danford Lane at Blossomfield Road | Solihull | Solihull | Education | N/A | 52.4092804 | -1.8056214 | ||
| 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 | ||
| 7497 | op-snap---monthly-publication-february-2026.pdf | 244 | 2026-02 | Car | BMW | X1 | Blue | Driving without Due Care and Attention | None | Torcross Avenue | Torcross Avenue | Coventry | Coventry | Education | N/A | 52.4218194 | -1.46546 | ||
| 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 | ||
| 7423 | op-snap---monthly-publication-february-2026.pdf | 170 | 2026-02 | Car | BMW | 3 series | Green | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Springfield Lane / Greenfield Lane | Springfield Lane / Greenfield Lane | Wolverhampton | Wolverhampton | NFA | No VRM | 52.6345604 | -2.1196834 | ||
| 7408 | op-snap---monthly-publication-february-2026.pdf | 155 | 2026-02 | Car | BMW | 118I | Grey | Driving without Due Care and Attention | None | Hall Green Road | Hall Green Road | Sandwell | Sandwell | Court | N/A | 52.5457385 | -1.9935809 | ||
| 7374 | op-snap---monthly-publication-february-2026.pdf | 121 | 2026-02 | Car | BMW | X5 | Black | Contravening a Red Traffic Light | None | M5 jct 1 slip | M5 jct 1 slip | Sandwell | Sandwell | Warning Letter | N/A | ||||
| 7356 | op-snap---monthly-publication-february-2026.pdf | 103 | 2026-02 | Car | BMW | M340i | Grey | Driving without Due Care and Attention | None | Great North Road, Retford | Great North Road, Retford | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 11943 | op-snap---monthly-publication-january-2026.pdf | 1404 | 2026-01 | Car | BMW | 530 | Black | Cause vehicle to be left in a dangerous position | None | hurstcroft road | Hurstcroft Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4830179 | -1.783876 | ||
| 11923 | op-snap---monthly-publication-january-2026.pdf | 1384 | 2026-01 | Car | BMW | 118i | Grey | Driving without Due Care and Attention | None | Galton Road | Galton Road | Sandwell | Sandwell | Education | N/A | 52.4700791 | -1.9751575 | ||
| 11895 | op-snap---monthly-publication-january-2026.pdf | 1356 | 2026-01 | Car | BMW | 118i | White | Driving without Due Care and Attention | None | Farquhar Road | Farquhar Road | Birmingham | Birmingham | Education | N/A | 52.4561477 | -1.931477 | ||
| 11891 | op-snap---monthly-publication-january-2026.pdf | 1352 | 2026-01 | Car | BMW | 1 Series | White | Contravening a Red Traffic Light | None | Hunter Road | Hunter Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 11851 | op-snap---monthly-publication-january-2026.pdf | 1312 | 2026-01 | Car | BMW | 420.. | Silver | Contravening a Red Traffic Light | None | M42 Jct 5 slip. | M42 Junction 5 slip | Solihull | Solihull | Warning Letter | N/A | ||||
| 11843 | op-snap---monthly-publication-january-2026.pdf | 1304 | 2026-01 | Car | BMW | M340 | White | Driving without Due Care and Attention | None | Dayus Square | Dayus Square | Birmingham | Birmingham | Education | N/A | 52.4846586 | -1.9140974 | ||
| 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 | ||
| 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 | ||
| 11775 | op-snap---monthly-publication-january-2026.pdf | 1236 | 2026-01 | Car | BMW | 218I | White | Driving without Due Care and Attention | None | Stourbridge Road | Stourbridge Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 11693 | op-snap---monthly-publication-january-2026.pdf | 1154 | 2026-01 | Car | BMW | 530.. | Blue | Contravening a Red Traffic Light | None | Howard Road Kings Heath | Howard Road Kings Heath | Birmingham | Birmingham | Education | N/A | 52.4281582 | -1.8932772 | ||
| 11680 | op-snap---monthly-publication-january-2026.pdf | 1141 | 2026-01 | Car | BMW | M135i | Black | Driving without Due Care and Attention | No Insurance | Cox Street | Cox Street | Coventry | Coventry | Court | N/A | 52.4092228 | -1.5034119 | ||
| 11647 | op-snap---monthly-publication-january-2026.pdf | 1108 | 2026-01 | Car | BMW | 430.. | Black | Driving without Due Care and Attention | None | Gulson Road | Gulson Road | Coventry | Coventry | Court | N/A | 52.4076795 | -1.4911676 | ||
| 11641 | op-snap---monthly-publication-january-2026.pdf | 1102 | 2026-01 | Car | BMW | X3 | Black | Driving without Due Care and Attention | None | Strourbridge Ring Road | Strourbridge Ring Road | Dudley | Dudley | Education | N/A | ||||
| 11618 | op-snap---monthly-publication-january-2026.pdf | 1079 | 2026-01 | Car | BMW | 320d | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | 52.4929304 | -1.8229092 | ||
| 11604 | op-snap---monthly-publication-january-2026.pdf | 1065 | 2026-01 | Car | BMW | 420d | Black | Driving without Due Care and Attention | None | Gilbertson Avenue | Gilbertson Avenue | Birmingham | Birmingham | Education | N/A | ||||
| 11602 | op-snap---monthly-publication-january-2026.pdf | 1063 | 2026-01 | Car | BMW | 318 I M | Blue | Contravening a Red Traffic Light | None | Friary Road / Oxhill Road junction | Friary Road / Oxhill Road junction | Birmingham | Birmingham | Education | N/A | 52.5162814 | -1.9395798 | ||
| 11598 | op-snap---monthly-publication-january-2026.pdf | 1059 | 2026-01 | Car | BMW | M3 | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No Independent Evidence Available | 52.4191184 | -1.8326637 | ||
| 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 | ||
| 11577 | op-snap---monthly-publication-january-2026.pdf | 1038 | 2026-01 | Car | BMW | 1 SERIS | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Solihull | Solihull | NFA | No VRM | 52.4191184 | -1.8326637 | ||
| 11564 | op-snap---monthly-publication-january-2026.pdf | 1025 | 2026-01 | Car | BMW | X5 | Blue | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11563 | op-snap---monthly-publication-january-2026.pdf | 1024 | 2026-01 | Car | BMW | 330.. | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Education | N/A | 52.502683 | -1.9033516 | ||
| 11541 | op-snap---monthly-publication-january-2026.pdf | 1002 | 2026-01 | Car | BMW | 5 Series | Blue | Driving without Due Care and Attention | None | M6 J3A | M6 J3A | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.6912652 | -2.1043715 | ||
| 11518 | op-snap---monthly-publication-january-2026.pdf | 979 | 2026-01 | Car | BMW | 320d | Blue | Driving without Due Care and Attention | None | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Education | N/A | 52.4519414 | -1.831688 | ||
| 11496 | op-snap---monthly-publication-january-2026.pdf | 957 | 2026-01 | Car | BMW | 640.. | White | Contravening a Red Traffic Light | None | A34 Grey Friars | Grey Friars | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11494 | op-snap---monthly-publication-january-2026.pdf | 955 | 2026-01 | Car | BMW | X5 | Black | Using a Mobile Phone Whilst Driving | None | A6182 Doncatser | Doncatser | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 11483 | op-snap---monthly-publication-january-2026.pdf | 944 | 2026-01 | Car | BMW | 520d | White | Driving without Due Care and Attention | None | Highfields Road, Burntwood | Highfields Road, Burntwood | Out of Force Area | Out of Force Area | NFA | Out of Force |
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);