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'}
713 rows where council_area = "Birmingham", 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 29
- Driving without Due Care and Attention 248
- Contravening a Red Traffic Light 124
- Stop a vehicle within pelican pedestrian crossing limits 68
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 56
- Driving without Reasonable Consideration 49
- Cause vehicle to be left in a dangerous position 42
- Stop a vehicle on pedestrian crossing 23
- Misc - Non Traffic Offences 19
- Using a Mobile Phone Whilst Driving 13
- VRM fails to conform to Regulations 12
- Contravene Lane Closure Red X 9
- Cause unnecessary obstruction by motor vehicle 8
- Dangerous Driving 7
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 6
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 5
- Drive on hard shoulder 4
- Fail to display front VRM plate 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Drive a vehicle other than on the carriageway of a motorway 2
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 2
- Vehicle overtake within crossing limits 2
- Drive / Ride / Lead an animal on a footpath 1
- MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
- Motor vehicle fail to comply with endorsable sect 1
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
- Motor vehicle fail to comply with solid white line road markings 1
- No Insurance 1
- No Seat Belt 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
month 14
disposal 7
- NFA 229
- Warning Letter 185
- Education 141
- Fixed Penalty 101
- Court 45
- Other Action Taken 10
- RTC - Actioned 2
vehicle_make 1
- BMW · 713 ✖
reporter_transport_mode 1
- Car · 713 ✖
council_area 1
- Birmingham · 713 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 11370 | op-snap---monthly-publication-january-2026.pdf | 831 | 2026-01 | Car | BMW | X5.. | Blue | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Education | N/A | 52.4308271 | -1.920078 | ||
| 11390 | op-snap---monthly-publication-january-2026.pdf | 851 | 2026-01 | Car | BMW | 1 Series | Grey | Contravening a Red Traffic Light | None | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Education | N/A | 52.482758 | -1.7603097 | ||
| 11395 | op-snap---monthly-publication-january-2026.pdf | 856 | 2026-01 | Car | BMW | 218D | White | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 11396 | op-snap---monthly-publication-january-2026.pdf | 857 | 2026-01 | Car | BMW | M4 | Red | Driving without Due Care and Attention | No Insurance | Holiday Street | Holiday Street | Birmingham | Birmingham | Court | N/A | 52.4757071 | -1.8988573 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 3877 | op-snap---monthly-publication-december-2025.pdf | 5 | 2025-12 | Car | BMW | 220M | Silver | Contravening a Red Traffic Light | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4170522 | -1.8906187 | ||
| 3880 | op-snap---monthly-publication-december-2025.pdf | 8 | 2025-12 | Car | BMW | 1 Series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lozells Road | Lozells Road | Birmingham | Birmingham | Warning Letter | N/A | 52.502683 | -1.9033516 | ||
| 3915 | op-snap---monthly-publication-december-2025.pdf | 43 | 2025-12 | Car | BMW | X1 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513336 | -1.8833226 | ||
| 4013 | op-snap---monthly-publication-december-2025.pdf | 141 | 2025-12 | Car | BMW | 3 series | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 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 | ||
| 4032 | op-snap---monthly-publication-december-2025.pdf | 160 | 2025-12 | Car | BMW | 1 Series | Silver | Driving without Due Care and Attention | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.502683 | -1.9033516 | ||
| 4036 | op-snap---monthly-publication-december-2025.pdf | 164 | 2025-12 | Car | BMW | 420 | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 4042 | op-snap---monthly-publication-december-2025.pdf | 170 | 2025-12 | Car | BMW | X5 | White | Contravening a Red Traffic Light | None | Newton Road | Newton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4541102 | -1.8710993 | ||
| 4101 | op-snap---monthly-publication-december-2025.pdf | 229 | 2025-12 | Car | BMW | X3.. | Grey | Contravening a Red Traffic Light | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4170522 | -1.8906187 | ||
| 4146 | op-snap---monthly-publication-december-2025.pdf | 274 | 2025-12 | Car | BMW | 525D | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 4170 | op-snap---monthly-publication-december-2025.pdf | 298 | 2025-12 | Car | BMW | 1 Series | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Anthony Road | Anthony Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4843724 | -1.8470805 | ||
| 4182 | op-snap---monthly-publication-december-2025.pdf | 310 | 2025-12 | Car | BMW | 316 | Black | Driving without Due Care and Attention | None | Chester Road at Kingsbury Road | Chester Road at Kingsbury Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 4188 | op-snap---monthly-publication-december-2025.pdf | 316 | 2025-12 | Car | BMW | 118i | Black | Contravening a Red Traffic Light | None | Craddock Street | Craddock Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.490126 | -1.9129277 | ||
| 4247 | op-snap---monthly-publication-december-2025.pdf | 375 | 2025-12 | Car | BMW | 1 Series | 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 | ||
| 4261 | op-snap---monthly-publication-december-2025.pdf | 389 | 2025-12 | Car | BMW | 3 Series | Black | Contravening a Red Traffic Light | None | Spring HIll | Spring HIll | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4854232 | -1.9218159 | ||
| 4295 | op-snap---monthly-publication-december-2025.pdf | 423 | 2025-12 | Car | BMW | x3 | Black | Cause vehicle to be left in a dangerous position | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4370 | op-snap---monthly-publication-december-2025.pdf | 498 | 2025-12 | Car | BMW | 1 series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | sheldon heath road | Sheldon Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4744736 | -1.7892633 | ||
| 4396 | op-snap---monthly-publication-december-2025.pdf | 524 | 2025-12 | Car | BMW | 420D | Grey | Contravening a Red Traffic Light | None | Hamsread Road, Hockley | Hamsread Road, Hockley | Birmingham | Birmingham | Education | N/A | ||||
| 4429 | op-snap---monthly-publication-december-2025.pdf | 557 | 2025-12 | Car | BMW | 33D | Grey | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | 52.5027779 | -1.7982159 | ||
| 4432 | op-snap---monthly-publication-december-2025.pdf | 560 | 2025-12 | Car | BMW | 3 Series | Grey | Driving without Due Care and Attention | None | Farnborough Road | Farnborough Road | Birmingham | Birmingham | NFA | No Offence | 52.5148331 | -1.79231 | ||
| 4444 | op-snap---monthly-publication-december-2025.pdf | 572 | 2025-12 | Car | BMW | 116d | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4453 | op-snap---monthly-publication-december-2025.pdf | 581 | 2025-12 | Car | BMW | 1 Series | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 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 | ||
| 4497 | op-snap---monthly-publication-december-2025.pdf | 625 | 2025-12 | Car | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4967329 | -1.8097462 | ||
| 4499 | op-snap---monthly-publication-december-2025.pdf | 627 | 2025-12 | Car | BMW | X5 Sport | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | 132 Burnaby Rd | 132 Burnaby Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4504 | op-snap---monthly-publication-december-2025.pdf | 632 | 2025-12 | Car | BMW | White | Contravening a Red Traffic Light | None | Old Walsall Road | Old Walsall Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5294399 | -1.9282714 | |||
| 4506 | op-snap---monthly-publication-december-2025.pdf | 634 | 2025-12 | Car | BMW | 520 | Grey | Driving without Due Care and Attention | None | Motorway but are u/K | Motorway but are u/K | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 4640 | op-snap---monthly-publication-december-2025.pdf | 768 | 2025-12 | Car | BMW | Black | Driving without Due Care and Attention | None | Montgomery Street | Montgomery Street | Birmingham | Birmingham | NFA | No VRM | 52.4644472 | -1.8668879 | |||
| 4693 | op-snap---monthly-publication-december-2025.pdf | 821 | 2025-12 | Car | BMW | E220 | Black | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Education | N/A | 52.5458699 | -1.9304484 | ||
| 4783 | op-snap---monthly-publication-december-2025.pdf | 911 | 2025-12 | Car | BMW | Grey | Driving without Due Care and Attention | None | unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||||
| 4868 | op-snap---monthly-publication-december-2025.pdf | 996 | 2025-12 | Car | BMW | M3 | Yellow | Driving without Due Care and Attention | None | A38M | A38M | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 4963 | op-snap---monthly-publication-december-2025.pdf | 1091 | 2025-12 | Car | BMW | 1 series | Blue | Driving without Due Care and Attention | None | Warstock Road | Warstock Road | Birmingham | Birmingham | Warning Letter | N/A | 52.413031 | -1.8782144 | ||
| 4984 | op-snap---monthly-publication-december-2025.pdf | 1112 | 2025-12 | Car | BMW | X5 | Blue | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 5054 | op-snap---monthly-publication-december-2025.pdf | 1182 | 2025-12 | Car | BMW | 330.. | Grey | Contravening a Red Traffic Light | None | Great Barr Interchange | Great Barr Interchange | Birmingham | Birmingham | Court | N/A | 52.544549 | -1.9310678 | ||
| 5070 | op-snap---monthly-publication-december-2025.pdf | 1198 | 2025-12 | Car | BMW | 730 LD | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 5071 | op-snap---monthly-publication-december-2025.pdf | 1199 | 2025-12 | 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 |
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);