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'}
528 rows where council_area = "Birmingham", disposal = "NFA" 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
reporter_transport_mode 9
- Car 468
- Pedal Bike 27
- Pedestrian 20
- Motorbike 4
- Other 3
- Bus 2
- Lorry 2
- Van 1
- car 1
offence 1
- Contravening a Red Traffic Light · 528 ✖
disposal 1
- NFA · 528 ✖
council_area 1
- Birmingham · 528 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7556 | op-snap---monthly-publication-february-2026.pdf | 303 | 2026-02 | Car | Daf | DAF Truck | White | Contravening a Red Traffic Light | None | Gibbins Road | Gibbins Road | Birmingham | Birmingham | NFA | No VRM | 52.4390303 | -1.9512931 | ||
| 7713 | op-snap---monthly-publication-february-2026.pdf | 460 | 2026-02 | Car | Volkswagen | Golf | Silver | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5505398 | -1.8252993 | ||
| 7766 | op-snap---monthly-publication-february-2026.pdf | 513 | 2026-02 | Car | Mercedes-Benz | CLA 180 | White | Contravening a Red Traffic Light | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 7858 | op-snap---monthly-publication-february-2026.pdf | 605 | 2026-02 | Car | Citroen | C1 | Black | Contravening a Red Traffic Light | None | Church Road | Church Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4624743 | -1.7763934 | ||
| 8008 | op-snap---monthly-publication-february-2026.pdf | 755 | 2026-02 | Car | Mercedes-Benz | White | Contravening a Red Traffic Light | None | Harbourne Road | Harborne Road | Birmingham | Birmingham | NFA | No VRM | 52.4718503 | -1.9195423 | |||
| 8082 | op-snap---monthly-publication-february-2026.pdf | 829 | 2026-02 | Car | Volkswagen | T-Cross | Black | Contravening a Red Traffic Light | None | Edwards Road | Edwards Road | Birmingham | Birmingham | NFA | 52.523745 | -1.8332475 | |||
| 8234 | op-snap---monthly-publication-february-2026.pdf | 981 | 2026-02 | Car | Audi | Q7 | White | Contravening a Red Traffic Light | None | Holloway Circus | Holloway Circus | Birmingham | Birmingham | NFA | No Offence | 52.474604 | -1.89977 | ||
| 8238 | op-snap---monthly-publication-february-2026.pdf | 985 | 2026-02 | Car | Alfa Romeo | Q7 | White | Contravening a Red Traffic Light | None | Holloway Circus | Holloway Circus | Birmingham | Birmingham | NFA | No Offence | 52.474604 | -1.89977 | ||
| 8474 | op-snap---monthly-publication-february-2026.pdf | 1221 | 2026-02 | Pedal Bike | Lexus | IS 300H | Silver | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4167654 | -1.9411244 | ||
| 8509 | op-snap---monthly-publication-february-2026.pdf | 1256 | 2026-02 | Car | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | NFA | 52.4167654 | -1.9411244 | |||
| 8575 | op-snap---monthly-publication-february-2026.pdf | 1322 | 2026-02 | Car | Porsche | Cayenne | Black | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 8680 | op-snap---monthly-publication-february-2026.pdf | 1427 | 2026-02 | Car | Mercedes-Benz | C220 | White | Contravening a Red Traffic Light | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | NFA | No Offence | 52.3962003 | -1.9821252 | ||
| 8699 | op-snap---monthly-publication-february-2026.pdf | 1446 | 2026-02 | Pedestrian | Toyota | Black | Contravening a Red Traffic Light | None | Cole Bank Road | Cole Bank Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4349375 | -1.8510007 | |||
| 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 | |||
| 8754 | op-snap---monthly-publication-february-2026.pdf | 1501 | 2026-02 | Car | Multiple | Contravening a Red Traffic Light | None | Middleton Hall Road | Middleton Hall Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4149989 | -1.9345999 | ||||
| 10571 | op-snap---monthly-publication-january-2026.pdf | 32 | 2026-01 | Car | Toyota | Estima | White | Contravening a Red Traffic Light | None | Bordesley Green Road | Bordesley Green Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4804926 | -1.8563658 | ||
| 10827 | op-snap---monthly-publication-january-2026.pdf | 288 | 2026-01 | Car | Vauxhall | Antara | White | Contravening a Red Traffic Light | None | Middleton Hall Road | Middleton Hall Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4149989 | -1.9345999 | ||
| 10945 | op-snap---monthly-publication-january-2026.pdf | 406 | 2026-01 | Car | Volkswagen | Passat | Black | Contravening a Red Traffic Light | None | Portland Road | Portland Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4737014 | -1.9412436 | ||
| 10952 | op-snap---monthly-publication-january-2026.pdf | 413 | 2026-01 | Car | Hyundai | Tuscan | Black | Contravening a Red Traffic Light | None | Walsall Road, Perry Barr | Walsall Road, Perry Barr | Birmingham | Birmingham | NFA | No Offence | 52.5290137 | -1.9098939 | ||
| 11065 | op-snap---monthly-publication-january-2026.pdf | 526 | 2026-01 | Pedal Bike | Renault | HGV | White | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Offence | 52.4552785 | -1.906384 | ||
| 11124 | op-snap---monthly-publication-january-2026.pdf | 585 | 2026-01 | Car | Vauxhall | Astra | Red | Contravening a Red Traffic Light | No Insurance | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5113867 | -1.8337258 | ||
| 11135 | op-snap---monthly-publication-january-2026.pdf | 596 | 2026-01 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | Mary Vale Road | Mary Vale Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.425105 | -1.9312861 | ||
| 11169 | op-snap---monthly-publication-january-2026.pdf | 630 | 2026-01 | Car | Mercedes-Benz | Citan | White | Contravening a Red Traffic Light | None | Darthmouth Middleway | Darthmouth Middleway | Birmingham | Birmingham | NFA | No Offence | ||||
| 11386 | op-snap---monthly-publication-january-2026.pdf | 847 | 2026-01 | Car | Mercedes-Benz | E350 | Silver | Contravening a Red Traffic Light | None | Water Orton Road | Water Orton Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5153394 | -1.7573409 | ||
| 11394 | op-snap---monthly-publication-january-2026.pdf | 855 | 2026-01 | Car | Honda | Jazz | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 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 | ||
| 11583 | op-snap---monthly-publication-january-2026.pdf | 1044 | 2026-01 | Pedal Bike | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | None | High street. Alcester Road | High street. Alcester Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 11718 | op-snap---monthly-publication-january-2026.pdf | 1179 | 2026-01 | Car | Toyota | Auris | Silver | Contravening a Red Traffic Light | None | Melchett Road | Melchett Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.413984 | -1.9251511 | ||
| 11829 | op-snap---monthly-publication-january-2026.pdf | 1290 | 2026-01 | Car | Audi | S3 | White | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 11859 | op-snap---monthly-publication-january-2026.pdf | 1320 | 2026-01 | Other | Ford | Transit | White | Contravening a Red Traffic Light | None | Avenue road | Avenue road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4941712 | -1.8795158 | ||
| 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 | ||
| 4008 | op-snap---monthly-publication-december-2025.pdf | 136 | 2025-12 | Car | Fiat | doblo | Red | Contravening a Red Traffic Light | None | Soho Hill | Soho Hill | Birmingham | Birmingham | NFA | No Offence | 52.4983151 | -1.9186252 | ||
| 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 | ||
| 4018 | op-snap---monthly-publication-december-2025.pdf | 146 | 2025-12 | Car | Mercedes-Benz | CLA | Red | Contravening a Red Traffic Light | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | NFA | No Offence | 52.4656414 | -1.9852276 | ||
| 4021 | op-snap---monthly-publication-december-2025.pdf | 149 | 2025-12 | Pedal Bike | Volkswagen | Polo | White | Contravening a Red Traffic Light | None | California Way | California Way | Birmingham | Birmingham | NFA | No VRM | 52.4454714 | -1.9753804 | ||
| 4037 | op-snap---monthly-publication-december-2025.pdf | 165 | 2025-12 | Car | Kia | Niro | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 4038 | op-snap---monthly-publication-december-2025.pdf | 166 | 2025-12 | Car | Volkswagen | Golf | White | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 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 | ||
| 4093 | op-snap---monthly-publication-december-2025.pdf | 221 | 2025-12 | Car | Seat | ibiza | Grey | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 4112 | op-snap---monthly-publication-december-2025.pdf | 240 | 2025-12 | Car | Mercedes-Benz | GLA | Black | Contravening a Red Traffic Light | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | NFA | No Offence | ||||
| 4121 | op-snap---monthly-publication-december-2025.pdf | 249 | 2025-12 | Car | Mercedes-Benz | C class | Black | Contravening a Red Traffic Light | None | Eastfield Road, Stechford | Eastfield Road, Stechford | Birmingham | Birmingham | NFA | No VRM | 52.486104 | -1.8218907 | ||
| 4164 | op-snap---monthly-publication-december-2025.pdf | 292 | 2025-12 | Car | Mercedes-Benz | A180.. | Blue | Contravening a Red Traffic Light | None | New Hampton | New Hampton | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4896402 | -1.9101083 | ||
| 4167 | op-snap---monthly-publication-december-2025.pdf | 295 | 2025-12 | Car | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Bordsley Circus Roundabout | Bordsley Circus Roundabout | Birmingham | Birmingham | NFA | No Offence | ||||
| 4177 | op-snap---monthly-publication-december-2025.pdf | 305 | 2025-12 | Car | Scania | Tractor | White | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 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 | ||
| 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 | ||
| 4312 | op-snap---monthly-publication-december-2025.pdf | 440 | 2025-12 | Car | Audi | A1 | White | Contravening a Red Traffic Light | None | B4124 Hamstread Hill | Hamstread Hill | Birmingham | Birmingham | NFA | No Offence | ||||
| 4315 | op-snap---monthly-publication-december-2025.pdf | 443 | 2025-12 | Car | various | Contravening a Red Traffic Light | None | Birmingham | Birmingham | Birmingham | Birmingham | NFA | No VRM | 52.4796992 | -1.9026911 | ||||
| 4406 | op-snap---monthly-publication-december-2025.pdf | 534 | 2025-12 | Car | Toyota | Prius | Silver | Contravening a Red Traffic Light | None | Grove Lane | Grove Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5055208 | -1.9328067 | ||
| 4435 | op-snap---monthly-publication-december-2025.pdf | 563 | 2025-12 | Car | Mercedes-Benz | C63 | White | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5919543 | -1.8517118 | ||
| 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 | |||
| 4508 | op-snap---monthly-publication-december-2025.pdf | 636 | 2025-12 | Car | Nissan | X-trail | Black | Contravening a Red Traffic Light | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4709298 | -1.8722585 | ||
| 4545 | op-snap---monthly-publication-december-2025.pdf | 673 | 2025-12 | Car | Volkswagen | Passat | Silver | Contravening a Red Traffic Light | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4656414 | -1.9852276 | ||
| 4622 | op-snap---monthly-publication-december-2025.pdf | 750 | 2025-12 | Car | Mercedes-Benz | C200 | Black | Contravening a Red Traffic Light | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 4632 | op-snap---monthly-publication-december-2025.pdf | 760 | 2025-12 | Car | Mg | HS Trophy | Grey | Contravening a Red Traffic Light | None | Longbridge Lane | Longbridge Lane | Birmingham | Birmingham | NFA | Not in Public Interest | 52.3962003 | -1.9821252 | ||
| 4691 | op-snap---monthly-publication-december-2025.pdf | 819 | 2025-12 | Car | Audi | A7 | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 4825 | op-snap---monthly-publication-december-2025.pdf | 953 | 2025-12 | Car | Audi | Grey | Contravening a Red Traffic Light | None | stratford road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | |||
| 4859 | op-snap---monthly-publication-december-2025.pdf | 987 | 2025-12 | Car | Volkswagen | Golf | Blue | Contravening a Red Traffic Light | No Insurance | Queensbirdge Road | Queensbirdge Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 5100 | op-snap---monthly-publication-december-2025.pdf | 1228 | 2025-12 | Car | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Offence | 52.5359496 | -1.8324115 | ||
| 5166 | op-snap---monthly-publication-december-2025.pdf | 1294 | 2025-12 | Car | Hyundai | I20 | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 20537 | op-snap---monthly-publication-november-2025.pdf | 79 | 2025-11 | Car | Mercedes-Benz | E250 | Silver | Contravening a Red Traffic Light | None | Lozells Road | Lozells Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.502683 | -1.9033516 | ||
| 20629 | op-snap---monthly-publication-november-2025.pdf | 171 | 2025-11 | Pedal Bike | Nissan | Qashqai | Black | Contravening a Red Traffic Light | None | Newport Road | Newport Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5027779 | -1.7982159 | ||
| 20666 | op-snap---monthly-publication-november-2025.pdf | 208 | 2025-11 | Car | Mercedes-Benz | Blue | Contravening a Red Traffic Light | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4967329 | -1.8097462 | |||
| 20735 | op-snap---monthly-publication-november-2025.pdf | 277 | 2025-11 | Car | Honda | CRV | Grey | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 20737 | op-snap---monthly-publication-november-2025.pdf | 279 | 2025-11 | Car | Audi | S3 | Black | Contravening a Red Traffic Light | None | Mackadown Lane | Mackadown Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4708415 | -1.7675939 | ||
| 20739 | op-snap---monthly-publication-november-2025.pdf | 281 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Oxhill Road Handsworth | Oxhill Road Handsworth | Birmingham | Birmingham | NFA | Not in Public Interest | 52.513857 | -1.9367367 | ||
| 20783 | op-snap---monthly-publication-november-2025.pdf | 325 | 2025-11 | Car | Mercedes-Benz | Vito | White | Contravening a Red Traffic Light | None | A450 Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4720132 | -1.9142946 | ||
| 20810 | op-snap---monthly-publication-november-2025.pdf | 352 | 2025-11 | Car | Renault | Scenic | Blue | Contravening a Red Traffic Light | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.513857 | -1.9367367 | ||
| 20812 | op-snap---monthly-publication-november-2025.pdf | 354 | 2025-11 | Car | BMW | 320D | Blue | Contravening a Red Traffic Light | None | Grove Lane | Grove Lane | Birmingham | Birmingham | NFA | No VRM | 52.5055208 | -1.9328067 | ||
| 20934 | op-snap---monthly-publication-november-2025.pdf | 476 | 2025-11 | Car | Honda | Jazz | Grey | Contravening a Red Traffic Light | None | Winson Green Road | Winson Green Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4870332 | -1.9373713 | ||
| 21056 | op-snap---monthly-publication-november-2025.pdf | 598 | 2025-11 | Car | Daf | Tipper | White | Contravening a Red Traffic Light | None | Walmley Road | Walmley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5534398 | -1.7987049 | ||
| 21062 | op-snap---monthly-publication-november-2025.pdf | 604 | 2025-11 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21063 | op-snap---monthly-publication-november-2025.pdf | 605 | 2025-11 | Car | Vauxhall | MPV | white | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No VRM | 52.471632 | -1.9456776 | ||
| 21272 | op-snap---monthly-publication-november-2025.pdf | 814 | 2025-11 | Car | Toyota | Auris | Silver | Contravening a Red Traffic Light | None | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 21393 | op-snap---monthly-publication-november-2025.pdf | 935 | 2025-11 | Car | Peugeot | 308 | White | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 21431 | op-snap---monthly-publication-november-2025.pdf | 973 | 2025-11 | Car | Mercedes-Benz | C220 | Black | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Offence | 52.4668753 | -1.8996143 | ||
| 21454 | op-snap---monthly-publication-november-2025.pdf | 996 | 2025-11 | Car | Volkswagen | Golf | Red | Contravening a Red Traffic Light | None | Aldridge Road | Aldridge Road | Birmingham | Birmingham | NFA | No VRM | 52.5368764 | -1.8976461 | ||
| 21512 | op-snap---monthly-publication-november-2025.pdf | 1054 | 2025-11 | Car | Hyundai | Ioniq | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | 52.471632 | -1.9456776 | ||
| 21514 | op-snap---monthly-publication-november-2025.pdf | 1056 | 2025-11 | Car | Ford | Focus | Silver | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5359496 | -1.8324115 | ||
| 21611 | op-snap---monthly-publication-november-2025.pdf | 1153 | 2025-11 | Car | Volkswagen | Caddy | White | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4167654 | -1.9411244 | ||
| 21813 | op-snap---monthly-publication-november-2025.pdf | 1355 | 2025-11 | Car | Mercedes-Benz | AMG | Black | Contravening a Red Traffic Light | None | Stratford Road, Robin Hood Island | Stratford Road, Robin Hood Island | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 21830 | op-snap---monthly-publication-november-2025.pdf | 1372 | 2025-11 | Car | Volkswagen | Caddy | Blue | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 21831 | op-snap---monthly-publication-november-2025.pdf | 1373 | 2025-11 | Car | Toyota | White | Contravening a Red Traffic Light | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.513857 | -1.9367367 | |||
| 21926 | op-snap---monthly-publication-november-2025.pdf | 1468 | 2025-11 | Car | Volkswagen | Passat | White | Contravening a Red Traffic Light | None | Dartmouth Circus | Dartmouth Circus | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4926487 | -1.8879638 | ||
| 22026 | op-snap---monthly-publication-november-2025.pdf | 1568 | 2025-11 | Pedestrian | Volkswagen | Black | Contravening a Red Traffic Light | None | Hill Street | Hill Street | Birmingham | Birmingham | NFA | No VRM | 52.4777765 | -1.901321 | |||
| 22143 | op-snap---monthly-publication-october-2025.pdf | 93 | 2025-10 | Car | Vauxhall | Adam | Red | Contravening a Red Traffic Light | None | Sutton Rd,Erdington | Sutton Road, Erdington | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5339483 | -1.8285296 | ||
| 22176 | op-snap---monthly-publication-october-2025.pdf | 126 | 2025-10 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | A452 Chester Road | Chester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5359496 | -1.8324115 | ||
| 22226 | op-snap---monthly-publication-october-2025.pdf | 176 | 2025-10 | Car | Renault | Clio | Silver | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 22258 | op-snap---monthly-publication-october-2025.pdf | 208 | 2025-10 | Car | Seat | Ibiza | White | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 22299 | op-snap---monthly-publication-october-2025.pdf | 249 | 2025-10 | Lorry | Mercedes-Benz | GLC 220 | Grey | Contravening a Red Traffic Light | None | Cole Hall Lane | Cole Hall Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4877244 | -1.787883 | ||
| 22303 | op-snap---monthly-publication-october-2025.pdf | 253 | 2025-10 | Lorry | Ford | Transit | White | Contravening a Red Traffic Light | None | Cole Hall Lane | Cole Hall Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4877244 | -1.787883 | ||
| 22335 | op-snap---monthly-publication-october-2025.pdf | 285 | 2025-10 | Other | Honda | Grey | Contravening a Red Traffic Light | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | No VRM | |||||
| 22342 | op-snap---monthly-publication-october-2025.pdf | 292 | 2025-10 | Car | Ford | Van | White | Contravening a Red Traffic Light | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | No Offence | 52.4679402 | -1.881408 | ||
| 22404 | op-snap---monthly-publication-october-2025.pdf | 354 | 2025-10 | Car | BMW | 116.. | Orange | Contravening a Red Traffic Light | None | Heartlands Parkway | Heartlands Parkway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5038363 | -1.8432663 | ||
| 22416 | op-snap---monthly-publication-october-2025.pdf | 366 | 2025-10 | Car | Volkswagen | Polo | Black | Contravening a Red Traffic Light | None | Dartmouth Middleway | Dartmouth Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4861917 | -1.8829748 | ||
| 22417 | op-snap---monthly-publication-october-2025.pdf | 367 | 2025-10 | Car | Ford | Focus | Blue | Contravening a Red Traffic Light | None | Dartmouth Middleway | Dartmouth Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4861917 | -1.8829748 | ||
| 22426 | op-snap---monthly-publication-october-2025.pdf | 376 | 2025-10 | Car | Contravening a Red Traffic Light | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5012458 | -1.8780942 | |||||
| 22427 | op-snap---monthly-publication-october-2025.pdf | 377 | 2025-10 | Pedestrian | Ford | Transit | blue | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 22456 | op-snap---monthly-publication-october-2025.pdf | 406 | 2025-10 | Motorbike | Tesla | Model 3 | Blue | Contravening a Red Traffic Light | None | Not provided | Not provided | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 22499 | op-snap---monthly-publication-october-2025.pdf | 449 | 2025-10 | Car | Volkswagen | Silver | Contravening a Red Traffic Light | None | Hurst Street | Hurst Street | Birmingham | Birmingham | NFA | No VRM | 52.4714381 | -1.893243 |
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);