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'}
85 rows where council_area = "Birmingham", offence = "Contravening a Red Traffic Light" and vehicle_make = "Vauxhall" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: source_file, vehicle_model, vehicle_colour, second_offence, nfa_rationale
month 14
disposal 6
- Education 30
- NFA 27
- Warning Letter 12
- Fixed Penalty 8
- Court 7
- Other Action Taken 1
reporter_transport_mode 5
- Car 76
- Pedal Bike 5
- Motorbike 2
- Pedestrian 1
- car 1
vehicle_make 1
- Vauxhall · 85 ✖
offence 1
- Contravening a Red Traffic Light · 85 ✖
council_area 1
- Birmingham · 85 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7260 | op-snap---monthly-publication-february-2026.pdf | 7 | 2026-02 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | Hamstead Hill | Hamstead Hill | Birmingham | Birmingham | Education | N/A | 52.5274116 | -1.9287273 | ||
| 7755 | op-snap---monthly-publication-february-2026.pdf | 502 | 2026-02 | Car | Vauxhall | Meriva | White | Contravening a Red Traffic Light | None | Hampstead Road at Victorian Way | Hampstead Road at Victorian Way | Birmingham | Birmingham | Education | N/A | 52.3993507 | -1.9640409 | ||
| 8424 | op-snap---monthly-publication-february-2026.pdf | 1171 | 2026-02 | Car | Vauxhall | corsa | Orange | Contravening a Red Traffic Light | None | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Education | N/A | 52.482758 | -1.7603097 | ||
| 8485 | op-snap---monthly-publication-february-2026.pdf | 1232 | 2026-02 | Car | Vauxhall | Insigna | White | Contravening a Red Traffic Light | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Education | N/A | 52.4520441 | -1.8787544 | ||
| 8555 | op-snap---monthly-publication-february-2026.pdf | 1302 | 2026-02 | Car | Vauxhall | Vivaro | Grey | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5083238 | -1.8332287 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 11401 | op-snap---monthly-publication-january-2026.pdf | 862 | 2026-01 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Friary Road | Friary Road | Birmingham | Birmingham | Education | N/A | 52.5162814 | -1.9395798 | ||
| 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 | ||||
| 11635 | op-snap---monthly-publication-january-2026.pdf | 1096 | 2026-01 | Car | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | No Insurance | Queslett Road | Queslett Road | Birmingham | Birmingham | Court | N/A | 52.5458699 | -1.9304484 | ||
| 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 | ||
| 20501 | op-snap---monthly-publication-november-2025.pdf | 43 | 2025-11 | Car | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Wake Green Road, Moseley | Wake Green Road, Moseley | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 20964 | op-snap---monthly-publication-november-2025.pdf | 506 | 2025-11 | Car | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Islington Row Middlway | Islington Row Middlway | Birmingham | Birmingham | Education | N/A | ||||
| 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 | ||
| 22016 | op-snap---monthly-publication-november-2025.pdf | 1558 | 2025-11 | Car | Vauxhall | Combo | Silver | Contravening a Red Traffic Light | None | Aldridge Road Perry Barr | Aldridge Road Perry Barr | Birmingham | Birmingham | Education | N/A | 52.5279749 | -1.8966405 | ||
| 22030 | op-snap---monthly-publication-november-2025.pdf | 1572 | 2025-11 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Richmond Road | Richmond Road | Birmingham | Birmingham | Education | N/A | 52.566947 | -1.8291809 | ||
| 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 | ||
| 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 | ||||
| 22216 | op-snap---monthly-publication-october-2025.pdf | 166 | 2025-10 | Car | Vauxhall | Zafira | Black | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Education | N/A | 52.5359496 | -1.8324115 | ||
| 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 | ||
| 22872 | op-snap---monthly-publication-october-2025.pdf | 822 | 2025-10 | Car | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Newbury Road A34 | Newbury Road A34 | Birmingham | Birmingham | Education | N/A | 52.4991241 | -1.8973166 | ||
| 22876 | op-snap---monthly-publication-october-2025.pdf | 826 | 2025-10 | Car | Vauxhall | Astra | Blue | Contravening a Red Traffic Light | None | Mackadown Lane | Mackadown Lane | Birmingham | Birmingham | Education | N/A | 52.4708415 | -1.7675939 | ||
| 22898 | op-snap---monthly-publication-october-2025.pdf | 848 | 2025-10 | Car | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4656414 | -1.9852276 | ||
| 23886 | op-snap---monthly-publication-september-2025.pdf | 105 | 2025-09 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | Newbury Road | Newbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4993019 | -1.8964495 | ||
| 23923 | op-snap---monthly-publication-september-2025.pdf | 142 | 2025-09 | Car | Vauxhall | Mokka | White | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5083238 | -1.8332287 | ||
| 24434 | op-snap---monthly-publication-september-2025.pdf | 653 | 2025-09 | Car | Vauxhall | Grandland X | White | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Education | N/A | 52.5083238 | -1.8332287 | ||
| 24666 | op-snap---monthly-publication-september-2025.pdf | 885 | 2025-09 | Car | Vauxhall | Grandland | Black | Contravening a Red Traffic Light | None | Cole Hall Lane | Cole Hall Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4877244 | -1.787883 | ||
| 24676 | op-snap---monthly-publication-september-2025.pdf | 895 | 2025-09 | Car | Vauxhall | Mokka | Black | Contravening a Red Traffic Light | None | Bromford Road | Bromford Road | Birmingham | Birmingham | NFA | No Offence | 52.503036 | -1.8289972 | ||
| 24760 | op-snap---monthly-publication-september-2025.pdf | 979 | 2025-09 | Car | Vauxhall | Corsa van | White | Contravening a Red Traffic Light | None | Chester Road, Castle Bromwich | Chester Road, Castle Bromwich | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 2080 | op-snap---monthly-publication-august-2025.pdf | 55 | 2025-08 | Car | Vauxhall | Combo | Red | Contravening a Red Traffic Light | None | A452 Collector Road | Collector Road | Birmingham | Birmingham | Education | N/A | 52.5139393 | -1.7600186 | ||
| 2280 | op-snap---monthly-publication-august-2025.pdf | 255 | 2025-08 | Car | Vauxhall | Insignia | White | Contravening a Red Traffic Light | None | City Road | City Road | Birmingham | Birmingham | Education | N/A | 52.4763176 | -1.9584897 | ||
| 2383 | op-snap---monthly-publication-august-2025.pdf | 358 | 2025-08 | Car | Vauxhall | Astra | Blue | Contravening a Red Traffic Light | None | A45 | A45 | Birmingham | Birmingham | Education | N/A | ||||
| 2415 | op-snap---monthly-publication-august-2025.pdf | 390 | 2025-08 | Car | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | No Insurance | Battery Way | Battery Way | Birmingham | Birmingham | Court | N/A | 52.4493988 | -1.8476406 | ||
| 2567 | op-snap---monthly-publication-august-2025.pdf | 542 | 2025-08 | Car | Vauxhall | Corsa | Blue | Contravening a Red Traffic Light | None | Wake Green Road at Yardley Wood Road | Wake Green Road at Yardley Wood Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4412136 | -1.8663546 | ||
| 2779 | op-snap---monthly-publication-august-2025.pdf | 754 | 2025-08 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | A5127 Gravely Hill North | Gravely Hill North | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 12456 | op-snap---monthly-publication-july-2025.pdf | 508 | 2025-07 | Car | Vauxhall | Silver | Contravening a Red Traffic Light | No Insurance | Sheaf Lane | Sheaf Lane | Birmingham | Birmingham | Other Action Taken | N/A | 52.4540536 | -1.7819436 | |||
| 12546 | op-snap---monthly-publication-july-2025.pdf | 598 | 2025-07 | Car | Vauxhall | Astra | Grey | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 12769 | op-snap---monthly-publication-july-2025.pdf | 821 | 2025-07 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Court | N/A | 52.4967329 | -1.8097462 | ||
| 12853 | op-snap---monthly-publication-july-2025.pdf | 905 | 2025-07 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Robinhood lane | Robinhood lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 12883 | op-snap---monthly-publication-july-2025.pdf | 935 | 2025-07 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Education | N/A | 52.4519414 | -1.831688 | ||
| 13209 | op-snap---monthly-publication-july-2025.pdf | 1261 | 2025-07 | Car | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Education | N/A | 52.5458699 | -1.9304484 | ||
| 14205 | op-snap---monthly-publication-june-2025.pdf | 134 | 2025-06 | car | Vauxhall | Astra | White | Contravening a Red Traffic Light | None | Yardley Road | Yardley Road | Birmingham | Birmingham | Education | N/A | 52.4613544 | -1.8160137 | ||
| 14333 | op-snap---monthly-publication-june-2025.pdf | 262 | 2025-06 | Car | Vauxhall | Zafira | Grey | Contravening a Red Traffic Light | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 14370 | op-snap---monthly-publication-june-2025.pdf | 299 | 2025-06 | Car | Vauxhall | Insignia | Grey | Contravening a Red Traffic Light | None | Cooks Lane | Cooks Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.482758 | -1.7603097 | ||
| 14400 | op-snap---monthly-publication-june-2025.pdf | 329 | 2025-06 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | Brighton Road | Brighton Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4543156 | -1.8840717 | ||
| 14536 | op-snap---monthly-publication-june-2025.pdf | 465 | 2025-06 | Car | Vauxhall | corsa | Silver | Contravening a Red Traffic Light | None | Church Road | Church Road | Birmingham | Birmingham | Education | N/A | 52.4624743 | -1.7763934 | ||
| 14702 | op-snap---monthly-publication-june-2025.pdf | 631 | 2025-06 | Car | Vauxhall | Astra | Blue | Contravening a Red Traffic Light | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Education | N/A | 52.5919543 | -1.8517118 | ||
| 14863 | op-snap---monthly-publication-june-2025.pdf | 792 | 2025-06 | Car | Vauxhall | Zafira | Silver | Contravening a Red Traffic Light | None | Old Walsall Road | Old Walsall Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.5294399 | -1.9282714 | ||
| 15125 | op-snap---monthly-publication-june-2025.pdf | 1054 | 2025-06 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | Education | N/A | 52.4543565 | -1.9114004 | ||
| 15174 | op-snap---monthly-publication-june-2025.pdf | 1103 | 2025-06 | Pedal Bike | Vauxhall | VIVARO | White | Contravening a Red Traffic Light | None | HARBORNE ROAD | Harborne Road | Birmingham | Birmingham | Education | N/A | 52.4718503 | -1.9195423 | ||
| 15208 | op-snap---monthly-publication-june-2025.pdf | 1137 | 2025-06 | Pedal Bike | Vauxhall | Mokka | Grey | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 | ||
| 15485 | op-snap---monthly-publication-june-2025.pdf | 1414 | 2025-06 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Education | N/A | 52.473883 | -1.9198244 | ||
| 15523 | op-snap---monthly-publication-june-2025.pdf | 1452 | 2025-06 | Car | Vauxhall | Vivaro | Black | Contravening a Red Traffic Light | None | Woodlands Park Road | Woodlands Park Road | Birmingham | Birmingham | Education | N/A | 52.4204382 | -1.9506973 | ||
| 15629 | op-snap---monthly-publication-june-2025.pdf | 1558 | 2025-06 | Car | Vauxhall | Mokka | Silver | Contravening a Red Traffic Light | None | New John Street West | New John Street West | Birmingham | Birmingham | Education | N/A | 52.4944784 | -1.9122329 | ||
| 15669 | op-snap---monthly-publication-june-2025.pdf | 1598 | 2025-06 | Car | Vauxhall | Zafira | Grey | Contravening a Red Traffic Light | None | Heathfield Road | Heathfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5905365 | -1.8453418 | ||
| 18814 | op-snap---monthly-publication-may-2025.pdf | 176 | 2025-05 | Car | Vauxhall | Corsa | Silver | Contravening a Red Traffic Light | None | Holloway Circus | Holloway Circus | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.474604 | -1.89977 | ||
| 19246 | op-snap---monthly-publication-may-2025.pdf | 608 | 2025-05 | Car | Vauxhall | Corsa | Silver | Contravening a Red Traffic Light | None | Kings Road, Kingstanding | Kings Road, Kingstanding | Birmingham | Birmingham | NFA | No Offence | 52.5531351 | -1.8852761 | ||
| 19286 | op-snap---monthly-publication-may-2025.pdf | 648 | 2025-05 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Questlett Road | Questlett Road | Birmingham | Birmingham | Education | N/A | ||||
| 19412 | op-snap---monthly-publication-may-2025.pdf | 774 | 2025-05 | Pedal Bike | Vauxhall | Astra | White | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 19937 | op-snap---monthly-publication-may-2025.pdf | 1299 | 2025-05 | Car | Vauxhall | np | Black | Contravening a Red Traffic Light | none | Hamstead road | Hamstead road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.505832 | -1.92002 | ||
| 65 | op-snap---monthly-publication-april-2025.pdf | 64 | 2025-04 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Bell Lane | Bell Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4178465 | -1.968864 | ||
| 977 | op-snap---monthly-publication-april-2025.pdf | 976 | 2025-04 | Car | Vauxhall | Ampera | White | Contravening a Red Traffic Light | None | Walsall Road , Perry Barr | Walsall Road , Perry Barr | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5219655 | -1.9010321 | ||
| 16622 | op-snap---monthly-publication-march-2025.pdf | 379 | 2025-03 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 16974 | op-snap---monthly-publication-march-2025.pdf | 731 | 2025-03 | Motorbike | Vauxhall | Insignia | Black | Contravening a Red Traffic Light | None | A38 | A38 | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | |||
| 17057 | op-snap---monthly-publication-march-2025.pdf | 814 | 2025-03 | Car | Vauxhall | White | Contravening a Red Traffic Light | None | Chester Road at Spitfire Island | Chester Road at Spitfire Island | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | ||
| 17202 | op-snap---monthly-publication-march-2025.pdf | 959 | 2025-03 | Pedal Bike | Vauxhall | Grandland | Blue | Contravening a Red Traffic Light | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4308271 | -1.920078 | |
| 17446 | op-snap---monthly-publication-march-2025.pdf | 1203 | 2025-03 | Car | Vauxhall | ASTRA | Black | Contravening a Red Traffic Light | None | THE CRESCENT | The Crescent | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4568799 | -1.8734416 | |
| 17457 | op-snap---monthly-publication-march-2025.pdf | 1214 | 2025-03 | Pedestrian | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | None | A452 | A452 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 17568 | op-snap---monthly-publication-march-2025.pdf | 1325 | 2025-03 | Car | Vauxhall | Vivaro | White | Contravening a Red Traffic Light | No Insurance | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4668753 | -1.8996143 | |
| 18027 | op-snap---monthly-publication-march-2025.pdf | 1784 | 2025-03 | Motorbike | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Gooch Street | Gooch Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4686609 | -1.8945007 | |
| 18333 | op-snap---monthly-publication-march-2025.pdf | 2090 | 2025-03 | Car | Vauxhall | Combo | White | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5505398 | -1.8252993 | |
| 5239 | op-snap---monthly-publication-february-2025.pdf | 56 | 2025-02 | Car | Vauxhall | Corsa | White | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.471632 | -1.9456776 | |
| 5556 | op-snap---monthly-publication-february-2025.pdf | 373 | 2025-02 | Car | Vauxhall | CORSA | Grey | Contravening a Red Traffic Light | None | HAGLEY ROAD | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.471632 | -1.9456776 | |
| 6349 | op-snap---monthly-publication-february-2025.pdf | 1166 | 2025-02 | Car | Vauxhall | Corsa | Grey | Contravening a Red Traffic Light | None | Monument Road [B4124], Ladywood | Monument Road [B4124], Ladywood | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4773692 | -1.9280585 | |
| 7157 | op-snap---monthly-publication-february-2025.pdf | 1974 | 2025-02 | Car | Vauxhall | Astra | Silver | Contravening a Red Traffic Light | None | Ladywood Middleway | Ladywood Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.473883 | -1.9198244 | |
| 9259 | op-snap---monthly-publication-january-2025.pdf | 367 | 2025-01 | Car | Vauxhall | ASTRA SRI | Grey | Contravening a Red Traffic Light | Driving without Due Care and Attention | BRISTOL ROAD | Bristol Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 9427 | op-snap---monthly-publication-january-2025.pdf | 535 | 2025-01 | Car | Vauxhall | Corsa | Silver | Contravening a Red Traffic Light | None | Lawley Middleway | Lawley Middleway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4801772 | -1.8769185 | |
| 9629 | op-snap---monthly-publication-january-2025.pdf | 737 | 2025-01 | Car | Vauxhall | Corsa | Black | Contravening a Red Traffic Light | Use vehicle on a road without valid test c | eWrtaifriwcaictek Road | e Wrtaifriwcaictek Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 9759 | op-snap---monthly-publication-january-2025.pdf | 867 | 2025-01 | Car | Vauxhall | CROSSLAND | White | Contravening a Red Traffic Light | No Insurance | SALFORD CIRCUS | Salford Circus | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5095071 | -1.8593732 | |
| 10310 | op-snap---monthly-publication-january-2025.pdf | 1418 | 2025-01 | Car | Vauxhall | VIVARO | Black | Contravening a Red Traffic Light | None | DUDDESTION ROAD | Duddestion Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 10311 | op-snap---monthly-publication-january-2025.pdf | 1419 | 2025-01 | Car | Vauxhall | TRANSPORTER | White | Contravening a Red Traffic Light | None | DUDDESTION ROAD | Duddestion Road | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | |||
| 10482 | op-snap---monthly-publication-january-2025.pdf | 1590 | 2025-01 | Car | Vauxhall | Astra | Black | Contravening a Red Traffic Light | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5292752 | -1.7618805 |
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);