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'}
403 rows where disposal = "Warning Letter" and offence = "Contravening a Red Traffic Light" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make >30
month 14
council_area 14
- Birmingham 214
- Coventry 38
- Walsall 36
- Wolverhampton 30
- Sandwell 27
- Solihull 23
- Sutton Coldfield 13
- Dudley 12
- Metropolitan Borough 3
- Out of Force Area 3
- Awll Alsall 1
- Ewetalsall 1
- Gwe)Alsall 1
- Halesowen 1
reporter_transport_mode 6
- Car 336
- Pedestrian 33
- Pedal Bike 28
- Lorry 3
- Motorbike 2
- Bus 1
offence 1
- Contravening a Red Traffic Light · 403 ✖
disposal 1
- Warning Letter · 403 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7271 | op-snap---monthly-publication-february-2026.pdf | 18 | 2026-02 | Car | Mazda | 6.. | Red | Contravening a Red Traffic Light | None | Sedgley Road West | Sedgley Road West | Sandwell | Sandwell | Warning Letter | N/A | 52.5296941 | -2.0777252 | ||
| 7293 | op-snap---monthly-publication-february-2026.pdf | 40 | 2026-02 | Pedal Bike | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Bristol Road South | Bristol Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4119174 | -1.9735247 | ||
| 7301 | op-snap---monthly-publication-february-2026.pdf | 48 | 2026-02 | Pedal Bike | Mercedes-Benz | GL350 | White | Contravening a Red Traffic Light | None | Penn Road | Penn Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5599616 | -2.1556338 | ||
| 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 | ||||
| 7411 | op-snap---monthly-publication-february-2026.pdf | 158 | 2026-02 | Car | Nissan | Juke | Black | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 7615 | op-snap---monthly-publication-february-2026.pdf | 362 | 2026-02 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | A491 | A491 | Dudley | Dudley | Warning Letter | N/A | ||||
| 7630 | op-snap---monthly-publication-february-2026.pdf | 377 | 2026-02 | Car | Mitsubishi | Outlander | Black | Contravening a Red Traffic Light | None | Stourbridge Road | Stourbridge Road | Dudley | Dudley | Warning Letter | N/A | 52.5002997 | -2.1081386 | ||
| 7631 | op-snap---monthly-publication-february-2026.pdf | 378 | 2026-02 | Pedal Bike | Mercedes-Benz | GLA 200 | Grey | Contravening a Red Traffic Light | None | Mere Green Road | Mere Green Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5874888 | -1.8297106 | ||
| 7757 | op-snap---monthly-publication-february-2026.pdf | 504 | 2026-02 | Car | Nissan | Ariya | Grey | Contravening a Red Traffic Light | None | Sheaf Lane at Coventry Road | Sheaf Lane at Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4521337 | -1.7818858 | ||
| 7764 | op-snap---monthly-publication-february-2026.pdf | 511 | 2026-02 | Car | Nissan | X-Trail | Blue | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 7811 | op-snap---monthly-publication-february-2026.pdf | 558 | 2026-02 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | A444/Coventry Rd roundabout | A444/Coventry Road roundabout | Coventry | Coventry | Warning Letter | N/A | 52.4471432 | -1.4975901 | ||
| 7822 | op-snap---monthly-publication-february-2026.pdf | 569 | 2026-02 | Car | Hyundai | Getz | Blue | Contravening a Red Traffic Light | None | Princes Way | Princes Way | Solihull | Solihull | Warning Letter | N/A | 52.4130801 | -1.784461 | ||
| 7963 | op-snap---monthly-publication-february-2026.pdf | 710 | 2026-02 | Car | Hyundai | I30.. | Blue | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | 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 | ||
| 8089 | op-snap---monthly-publication-february-2026.pdf | 836 | 2026-02 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | Warning Letter | N/A | 52.505832 | -1.92002 | ||
| 8267 | op-snap---monthly-publication-february-2026.pdf | 1014 | 2026-02 | Car | Ford | Toureno | Grey | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Solihull | Solihull | Warning Letter | N/A | 52.4428606 | -1.812114 | ||
| 8495 | op-snap---monthly-publication-february-2026.pdf | 1242 | 2026-02 | Car | Toyota | C-HR | Grey | Contravening a Red Traffic Light | None | Bristol Road, Longbridge | Bristol Road, Longbridge | Birmingham | Birmingham | Warning Letter | N/A | 52.3959871 | -2.0019629 | ||
| 8561 | op-snap---monthly-publication-february-2026.pdf | 1308 | 2026-02 | Car | Volkswagen | Golf | White | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8562 | op-snap---monthly-publication-february-2026.pdf | 1309 | 2026-02 | Car | Land Rover | Freelander | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8563 | op-snap---monthly-publication-february-2026.pdf | 1310 | 2026-02 | Car | Mercedes-Benz | Sprinter | White | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8564 | op-snap---monthly-publication-february-2026.pdf | 1311 | 2026-02 | Car | Nissan | Juke | Black | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8565 | op-snap---monthly-publication-february-2026.pdf | 1312 | 2026-02 | Car | Audi | Q5 | Grey | Contravening a Red Traffic Light | No vehicle excise licence | Northfield Road | Northfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4167654 | -1.9411244 | ||
| 8740 | op-snap---monthly-publication-february-2026.pdf | 1487 | 2026-02 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | None | Highfield Road | Highfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4216321 | -1.855984 | ||
| 10919 | op-snap---monthly-publication-january-2026.pdf | 380 | 2026-01 | Car | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Hagley Road at Highfield Road | Hagley Road at Highfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471836 | -1.9401037 | ||
| 10963 | op-snap---monthly-publication-january-2026.pdf | 424 | 2026-01 | Car | Scania | Tipper | Yellow | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5131355 | -2.0651615 | ||
| 11121 | op-snap---monthly-publication-january-2026.pdf | 582 | 2026-01 | Pedal Bike | BMW | 320D | Black | Contravening a Red Traffic Light | None | A45 slip road Allesley Green to Birmingham | A45 slip road Allesley Green to Birmingham | Coventry | Coventry | Warning Letter | N/A | ||||
| 11201 | op-snap---monthly-publication-january-2026.pdf | 662 | 2026-01 | Car | Vauxhall | Astra | White | Contravening a Red Traffic Light | None | Ickneild Street | Ickneild Street | Birmingham | Birmingham | Warning Letter | N/A | 52.3992394 | -1.919918 | ||
| 11312 | op-snap---monthly-publication-january-2026.pdf | 773 | 2026-01 | Car | Toyota | Prius | White | Contravening a Red Traffic Light | None | Walsgrave Road | Walsgrave Road | Coventry | Coventry | Warning Letter | N/A | 52.4096725 | -1.487901 | ||
| 11373 | op-snap---monthly-publication-january-2026.pdf | 834 | 2026-01 | Pedestrian | Toyota | Prius | White | Contravening a Red Traffic Light | None | Stephenson Road | Stephenson Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 11439 | op-snap---monthly-publication-january-2026.pdf | 900 | 2026-01 | Car | Hyundai | I 10.. | White | Contravening a Red Traffic Light | None | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.482758 | -1.7603097 | ||
| 11452 | op-snap---monthly-publication-january-2026.pdf | 913 | 2026-01 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Tamworth Road | Tamworth Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5724303 | -1.8191247 | ||
| 11634 | op-snap---monthly-publication-january-2026.pdf | 1095 | 2026-01 | Car | Fiat | Punto | Orange | Contravening a Red Traffic Light | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5458699 | -1.9304484 | ||
| 11645 | op-snap---monthly-publication-january-2026.pdf | 1106 | 2026-01 | Pedestrian | Renault | Clio | Orange | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 11722 | op-snap---monthly-publication-january-2026.pdf | 1183 | 2026-01 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4308271 | -1.920078 | ||
| 11776 | op-snap---monthly-publication-january-2026.pdf | 1237 | 2026-01 | Car | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Minworth Island | Minworth Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5316279 | -1.7762358 | ||
| 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 | ||||
| 11872 | op-snap---monthly-publication-january-2026.pdf | 1333 | 2026-01 | Pedal Bike | Nissan | Qashqai | Silver | Contravening a Red Traffic Light | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4695793 | -1.9378608 | ||
| 11886 | op-snap---monthly-publication-january-2026.pdf | 1347 | 2026-01 | Car | Audi | A4 | Black | Contravening a Red Traffic Light | None | Penn Road | Penn Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5599616 | -2.1556338 | ||
| 11890 | op-snap---monthly-publication-january-2026.pdf | 1351 | 2026-01 | Car | Vauxhall | Insignia | Silver | Contravening a Red Traffic Light | None | Ring Road St Davids | Ring Road Street Davids | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 11893 | op-snap---monthly-publication-january-2026.pdf | 1354 | 2026-01 | Car | Renault | Master | Grey | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 3981 | op-snap---monthly-publication-december-2025.pdf | 109 | 2025-12 | Car | Toyota | AYGO | White | Contravening a Red Traffic Light | None | Streetsbrook Road | Streetsbrook Road | Solihull | Solihull | Warning Letter | N/A | 52.4223176 | -1.8253145 | ||
| 3990 | op-snap---monthly-publication-december-2025.pdf | 118 | 2025-12 | Car | Mercedes-Benz | CLA220 | White | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 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 | ||
| 4266 | op-snap---monthly-publication-december-2025.pdf | 394 | 2025-12 | Car | Audi | A3.. | White | Contravening a Red Traffic Light | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 4268 | op-snap---monthly-publication-december-2025.pdf | 396 | 2025-12 | Car | Scania | Lorry | White | Contravening a Red Traffic Light | None | Islington Road | Islington Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 4272 | op-snap---monthly-publication-december-2025.pdf | 400 | 2025-12 | Car | Jaguar | E Pace | Grey | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 4306 | op-snap---monthly-publication-december-2025.pdf | 434 | 2025-12 | Car | Mini | Clubman | Grey | Contravening a Red Traffic Light | None | Chester Road North | Chester Road North | Birmingham | Birmingham | Warning Letter | N/A | 52.548449 | -1.8594603 | ||
| 4327 | op-snap---monthly-publication-december-2025.pdf | 455 | 2025-12 | Car | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Fletchemstead Highway A45 | Fletchemstead Highway A45 | Coventry | Coventry | Warning Letter | N/A | ||||
| 4385 | op-snap---monthly-publication-december-2025.pdf | 513 | 2025-12 | Car | Audi | Q3 | Silver | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Battery Way | Battery Way | Birmingham | Birmingham | Warning Letter | N/A | 52.4493988 | -1.8476406 | ||
| 4582 | op-snap---monthly-publication-december-2025.pdf | 710 | 2025-12 | Car | Land Rover | Evoque | Black | Contravening a Red Traffic Light | None | West Bromwich Interchange | West Bromwich Interchange | Sandwell | Sandwell | Warning Letter | N/A | 52.5109262 | -1.9753718 | ||
| 4618 | op-snap---monthly-publication-december-2025.pdf | 746 | 2025-12 | Pedal Bike | Skoda | Karoq | Blue | Contravening a Red Traffic Light | None | Gibbins Road, Selly Oak | Gibbins Road, Selly Oak | Birmingham | Birmingham | Warning Letter | N/A | 52.4390303 | -1.9512931 | ||
| 4692 | op-snap---monthly-publication-december-2025.pdf | 820 | 2025-12 | Pedal Bike | Audi | A4 | White | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5012458 | -1.8780942 | ||
| 4738 | op-snap---monthly-publication-december-2025.pdf | 866 | 2025-12 | Car | Toyota | Yaris | Black | Contravening a Red Traffic Light | None | Gordon Road | Gordon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4615944 | -1.9476861 | ||
| 4754 | op-snap---monthly-publication-december-2025.pdf | 882 | 2025-12 | Car | Volkswagen | Passatt | Black | Contravening a Red Traffic Light | None | A41, Smethwick | A41, Smethwick | Sandwell | Sandwell | Warning Letter | N/A | 52.5098817 | -1.9621109 | ||
| 4827 | op-snap---monthly-publication-december-2025.pdf | 955 | 2025-12 | Car | Renault | Captur | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 4911 | op-snap---monthly-publication-december-2025.pdf | 1039 | 2025-12 | Car | Nissan | Micra | Silver | Contravening a Red Traffic Light | None | New Birmingham Road | New Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5123958 | -2.0585145 | ||
| 4921 | op-snap---monthly-publication-december-2025.pdf | 1049 | 2025-12 | Car | Ford | Focus | Red | Contravening a Red Traffic Light | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5292752 | -1.7618805 | ||
| 4965 | op-snap---monthly-publication-december-2025.pdf | 1093 | 2025-12 | Car | Vauxhall | Mokka | Black | Contravening a Red Traffic Light | None | Stroubridge Road | Stroubridge Road | Dudley | Dudley | Warning Letter | N/A | ||||
| 4980 | op-snap---monthly-publication-december-2025.pdf | 1108 | 2025-12 | Car | Vauxhall | Mokka | Orange | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 5002 | op-snap---monthly-publication-december-2025.pdf | 1130 | 2025-12 | Pedal Bike | Kia | Sportage | White | Contravening a Red Traffic Light | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Warning Letter | N/A | 52.4221152 | -1.4959475 | ||
| 5049 | op-snap---monthly-publication-december-2025.pdf | 1177 | 2025-12 | Car | Vauxhall | Zafira | Brown | Contravening a Red Traffic Light | None | Blackhalve Lane | Blackhalve Lane | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6139368 | -2.0960778 | ||
| 5060 | op-snap---monthly-publication-december-2025.pdf | 1188 | 2025-12 | Car | Citroen | C1 | Red | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 20496 | op-snap---monthly-publication-november-2025.pdf | 38 | 2025-11 | Car | Mercedes-Benz | C220.. | Black | Contravening a Red Traffic Light | None | Tollbar End Cov | Tollbar End Cov | Coventry | Coventry | Warning Letter | N/A | 52.377406 | -1.4651313 | ||
| 20516 | op-snap---monthly-publication-november-2025.pdf | 58 | 2025-11 | Car | Seat | Leon | Grey | Contravening a Red Traffic Light | None | Wolverhampton Ring Road | Wolverhampton Ring Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5868722 | -2.1217519 | ||
| 20543 | op-snap---monthly-publication-november-2025.pdf | 85 | 2025-11 | Car | Mercedes-Benz | E200 | Black | Contravening a Red Traffic Light | None | Old Walsall Rd, Great Barr | Old Walsall Road, Great Barr | Walsall | Walsall | Warning Letter | N/A | 52.5523033 | -1.9111356 | ||
| 20551 | op-snap---monthly-publication-november-2025.pdf | 93 | 2025-11 | Motorbike | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Pedmore Road | Pedmore Road | Dudley | Dudley | Warning Letter | N/A | 52.4897451 | -2.1069141 | ||
| 20571 | op-snap---monthly-publication-november-2025.pdf | 113 | 2025-11 | Car | Toyota | Prius | Black | Contravening a Red Traffic Light | None | Barras Lane | Barras Lane | Coventry | Coventry | Warning Letter | N/A | 52.4109877 | -1.5203488 | ||
| 20638 | op-snap---monthly-publication-november-2025.pdf | 180 | 2025-11 | Pedal Bike | Mg | 5.. | White | Contravening a Red Traffic Light | None | Harborne Road | Harborne Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4718503 | -1.9195423 | ||
| 20673 | op-snap---monthly-publication-november-2025.pdf | 215 | 2025-11 | Car | Toyota | MPV | Black | Contravening a Red Traffic Light | None | Lower Rushall Street | Lower Rushall Street | Walsall | Walsall | Warning Letter | N/A | 52.588273 | -1.9750947 | ||
| 20755 | op-snap---monthly-publication-november-2025.pdf | 297 | 2025-11 | Car | Toyota | MPV | White | Contravening a Red Traffic Light | None | Drews Lane | Drews Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5005017 | -1.8353248 | ||
| 20797 | op-snap---monthly-publication-november-2025.pdf | 339 | 2025-11 | Car | Toyota | Verso | Green | Contravening a Red Traffic Light | None | A34 Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Warning Letter | N/A | 52.4220705 | -1.8372335 | ||
| 20849 | op-snap---monthly-publication-november-2025.pdf | 391 | 2025-11 | Car | Audi | A4 | Grey | Contravening a Red Traffic Light | None | Black Country New Road | Black Country New Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5527191 | -2.0312967 | ||
| 20954 | op-snap---monthly-publication-november-2025.pdf | 496 | 2025-11 | Car | Volvo | XC60 | Grey | Contravening a Red Traffic Light | None | A34 Stratford Road | Stratford Road | Solihull | Solihull | Warning Letter | N/A | 52.4191184 | -1.8326637 | ||
| 21014 | op-snap---monthly-publication-november-2025.pdf | 556 | 2025-11 | Car | Mercedes-Benz | E220 | Black | Contravening a Red Traffic Light | None | Pleck Road | Pleck Road | Walsall | Walsall | Warning Letter | N/A | 52.5827033 | -1.9960274 | ||
| 21252 | op-snap---monthly-publication-november-2025.pdf | 794 | 2025-11 | Car | Hyundai | i10 | Blue | Contravening a Red Traffic Light | None | Nelson Street, West Bromwich | Nelson Street, West Bromwich | Sandwell | Sandwell | Warning Letter | N/A | 52.5264068 | -1.994278 | ||
| 21305 | op-snap---monthly-publication-november-2025.pdf | 847 | 2025-11 | Car | Jaguar | I Pace | White | Contravening a Red Traffic Light | None | Damson Parkway | Damson Parkway | Solihull | Solihull | Warning Letter | N/A | 52.437016 | -1.7578446 | ||
| 21430 | op-snap---monthly-publication-november-2025.pdf | 972 | 2025-11 | Car | Toyota | Prius | White | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4668753 | -1.8996143 | ||
| 21470 | op-snap---monthly-publication-november-2025.pdf | 1012 | 2025-11 | Car | BMW | IX | White | Contravening a Red Traffic Light | None | Fulford Hall Road | Fulford Hall Road | Solihull | Solihull | Warning Letter | N/A | 52.378404 | -1.8539375 | ||
| 21491 | op-snap---monthly-publication-november-2025.pdf | 1033 | 2025-11 | Car | Nissan | Qashqai | Grey | Contravening a Red Traffic Light | None | London Road | London Road | Coventry | Coventry | Warning Letter | N/A | 52.3916468 | -1.4925995 | ||
| 21766 | op-snap---monthly-publication-november-2025.pdf | 1308 | 2025-11 | Car | Mercedes-Benz | C300 | Grey | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 21769 | op-snap---monthly-publication-november-2025.pdf | 1311 | 2025-11 | Car | Daf | Truck | White | Contravening a Red Traffic Light | None | Bromford Island | Bromford Island | Birmingham | Birmingham | Warning Letter | No Independent Evidence Available | ||||
| 21836 | op-snap---monthly-publication-november-2025.pdf | 1378 | 2025-11 | Car | Toyota | Corolla | White | Contravening a Red Traffic Light | None | Toll Bar End | Toll Bar End | Coventry | Coventry | Warning Letter | N/A | 52.377406 | -1.4651313 | ||
| 21952 | op-snap---monthly-publication-november-2025.pdf | 1494 | 2025-11 | Car | Toyota | Aygo | Red | Contravening a Red Traffic Light | None | A4114 Holyhead Road | Holyhead Road | Coventry | Coventry | Warning Letter | N/A | 52.418488 | -1.5472387 | ||
| 21969 | op-snap---monthly-publication-november-2025.pdf | 1511 | 2025-11 | Car | Audi | Q7 | Grey | Contravening a Red Traffic Light | None | Friary Road | Friary Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5162814 | -1.9395798 | ||
| 22053 | op-snap---monthly-publication-october-2025.pdf | 3 | 2025-10 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | None | A45 Birmingham Road | Birmingham Road | Coventry | Coventry | Warning Letter | N/A | 52.4272882 | -1.5753221 | ||
| 22104 | op-snap---monthly-publication-october-2025.pdf | 54 | 2025-10 | Car | Porsche | Macan | Black | Contravening a Red Traffic Light | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.513857 | -1.9367367 | ||
| 22162 | op-snap---monthly-publication-october-2025.pdf | 112 | 2025-10 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | A41 | A41 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 22170 | op-snap---monthly-publication-october-2025.pdf | 120 | 2025-10 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Dudley | Dudley | Warning Letter | N/A | 52.5131355 | -2.0651615 | ||
| 22191 | op-snap---monthly-publication-october-2025.pdf | 141 | 2025-10 | Car | Peugeot | 2008 | Grey | Contravening a Red Traffic Light | None | Stafford Road | Stafford Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6291998 | -2.126312 | ||
| 22206 | op-snap---monthly-publication-october-2025.pdf | 156 | 2025-10 | Car | Audi | Q5 | Black | Contravening a Red Traffic Light | None | Wentworth Way | Wentworth Way | Birmingham | Birmingham | Warning Letter | N/A | 52.4474041 | -1.9733473 | ||
| 22236 | op-snap---monthly-publication-october-2025.pdf | 186 | 2025-10 | Car | Nissan | Micra | Blue | Contravening a Red Traffic Light | None | Aldridge Road | Aldridge Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5368764 | -1.8976461 | ||
| 22245 | op-snap---monthly-publication-october-2025.pdf | 195 | 2025-10 | Car | Mercedes-Benz | GLE | Black | Contravening a Red Traffic Light | None | Birchley Island Oldbury | Birchley Island Oldbury | Sandwell | Sandwell | Warning Letter | N/A | 52.4926604 | -2.0216743 | ||
| 22276 | op-snap---monthly-publication-october-2025.pdf | 226 | 2025-10 | Car | Ford | Transit | White | Contravening a Red Traffic Light | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 22284 | op-snap---monthly-publication-october-2025.pdf | 234 | 2025-10 | Car | Hyundai | I20 | White | Contravening a Red Traffic Light | None | Heartlands Parkway | Heartlands Parkway | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | ||||
| 22329 | op-snap---monthly-publication-october-2025.pdf | 279 | 2025-10 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 22348 | op-snap---monthly-publication-october-2025.pdf | 298 | 2025-10 | Car | Audi | A4 | Black | Contravening a Red Traffic Light | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.3962003 | -1.9821252 | ||
| 22380 | op-snap---monthly-publication-october-2025.pdf | 330 | 2025-10 | Car | Land Rover | Range Rover | Grey | Contravening a Red Traffic Light | None | Holyhead Road Wednesbury | Holyhead Road Wednesbury | Sandwell | Sandwell | Warning Letter | N/A | 52.5567885 | -2.035824 | ||
| 22382 | op-snap---monthly-publication-october-2025.pdf | 332 | 2025-10 | Car | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | None | Grove Lane | Grove Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5055208 | -1.9328067 | ||
| 22461 | op-snap---monthly-publication-october-2025.pdf | 411 | 2025-10 | Car | BMW | 120d | Black | Contravening a Red Traffic Light | None | Whitehouse Common Road | Whitehouse Common Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.574907 | -1.8032902 | ||
| 22513 | op-snap---monthly-publication-october-2025.pdf | 463 | 2025-10 | Car | Citroen | DS3 | Black | Contravening a Red Traffic Light | None | Jockey Road | Jockey Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5512291 | -1.8357776 |
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);