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'}
635 rows where council_area = "Birmingham", month = "2025-09" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence >30
- Driving without Due Care and Attention 192
- Cause unnecessary obstruction by motor vehicle 164
- Contravening a Red Traffic Light 114
- Contravene Lane Closure Red X 35
- Misc - Non Traffic Offences 21
- Using a Mobile Phone Whilst Driving 19
- Driving without Reasonable Consideration 15
- Cause vehicle to be left in a dangerous position 12
- Motor vehicle fail to comply with endorsable sect 10
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 7
- Driving a vehicle wholly or partly on a footpath 7
- Drive a vehicle other than on the carriageway of a 4
- Motor vehicle fail to comply with a non endorsab 4
- Drive on hard shoulder 3
- Motor vehicle fail to accord precedence at a pelic 3
- Prohibited vehicle in offside lane of motorway 3
- Stop a vehicle on pedestrian crossing 3
- Use a vehicle / cycle on a road and contravene a l 3
- VRM fails to conform to Regulations 3
- Dangerous Driving 2
- / trailer outside of the Greater London area 1
- DCariuvsee o unn hnaercde ssshaoruyl doebrstruction by motor vehicle 1
- DCariuvsineg u wnnitehcoeusts aDruye o Cbasrteru acntido nA tbtye nmtiootnor vehicle 1
- Driver not in position to have Proper Control 1
- Fail to display front VRM plate 1
- MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 1
- Stop a vehicle within pelican pedestrian crossing l 1
- Use a motor vehicle / trailer in a condition likely t 1
- Use on a road a motor vehicle / trailer in such a c 1
- Vehicle overtake within crossing limits 1
- …
disposal 7
- Warning Letter 302
- NFA 146
- Education 90
- Fixed Penalty 54
- Court 30
- Other Action Taken 7
- RTC - Actioned 6
reporter_transport_mode 1
- Car · 635 ✖
month 1
- 2025-09 · 635 ✖
council_area 1
- Birmingham · 635 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23783 | op-snap---monthly-publication-september-2025.pdf | 2 | 2025-09 | Car | Skoda | Elroq | Blue | Contravening a Red Traffic Light | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5292752 | -1.7618805 | ||
| 23784 | op-snap---monthly-publication-september-2025.pdf | 3 | 2025-09 | Car | Cupra | Formentor | Black | Contravening a Red Traffic Light | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | 52.4203897 | -1.8338574 | ||
| 23785 | op-snap---monthly-publication-september-2025.pdf | 4 | 2025-09 | Car | U/K | White | Driving without Due Care and Attention | None | M6. | M6 | Birmingham | Birmingham | RTC - Actioned | N/A | |||||
| 23786 | op-snap---monthly-publication-september-2025.pdf | 5 | 2025-09 | Car | Tesla | Model 3 | Grey | Driving without Due Care and Attention | None | Coventry Road, Small Heath | Coventry Road, Small Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4650893 | -1.8425008 | ||
| 23787 | op-snap---monthly-publication-september-2025.pdf | 6 | 2025-09 | Car | Hyundai | Bayon | Blue | Driving without Due Care and Attention | None | Dartmouth Middleway | Dartmouth Middleway | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4861917 | -1.8829748 | ||
| 23795 | op-snap---monthly-publication-september-2025.pdf | 14 | 2025-09 | Car | Renault | Clio | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Court | N/A | 52.4203897 | -1.8338574 | ||
| 23796 | op-snap---monthly-publication-september-2025.pdf | 15 | 2025-09 | Car | Fiat | 500.. | White | Contravening a Red Traffic Light | None | Sheaf Lane | Sheaf Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4540536 | -1.7819436 | ||
| 23799 | op-snap---monthly-publication-september-2025.pdf | 18 | 2025-09 | Car | Volvo | Black | Driving without Due Care and Attention | None | Camp Hill | Camp Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4702894 | -1.8786299 | |||
| 23808 | op-snap---monthly-publication-september-2025.pdf | 27 | 2025-09 | Car | Toyota | Prius | Black | Driving without Due Care and Attention | None | Gravelly Lane | Gravelly Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.534608 | -1.8379769 | ||
| 23812 | op-snap---monthly-publication-september-2025.pdf | 31 | 2025-09 | Car | Toyota | Yaris | Silver | Driving without Due Care and Attention | None | Walsall Road | Walsall Road | Birmingham | Birmingham | NFA | No Offence | 52.5919543 | -1.8517118 | ||
| 23815 | op-snap---monthly-publication-september-2025.pdf | 34 | 2025-09 | Car | Skoda | Octavia | Blue | Driving without Due Care and Attention | None | Consitiution Hill | Consitiution Hill | Birmingham | Birmingham | Education | N/A | ||||
| 23816 | op-snap---monthly-publication-september-2025.pdf | 35 | 2025-09 | Car | Audi | A3 | Grey | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4203897 | -1.8338574 | ||
| 23818 | op-snap---monthly-publication-september-2025.pdf | 37 | 2025-09 | Car | Land Rover | Evoque | White | Contravening a Red Traffic Light | None | Spitfire Island | Spitfire Island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 23825 | op-snap---monthly-publication-september-2025.pdf | 44 | 2025-09 | Car | Nissan | X Trail | Black | Contravene Lane Closure Red X | None | Kings Heath High Street | Kings Heath High Street | Birmingham | Birmingham | Education | N/A | 52.4391028 | -1.893289 | ||
| 23833 | op-snap---monthly-publication-september-2025.pdf | 52 | 2025-09 | Car | Ford | KA | White | Using a Mobile Phone Whilst Driving | None | Stockfield Road | Stockfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4519414 | -1.831688 | ||
| 23836 | op-snap---monthly-publication-september-2025.pdf | 55 | 2025-09 | Car | Toyota | Prius | White | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 23837 | op-snap---monthly-publication-september-2025.pdf | 56 | 2025-09 | Car | Skoda | Octavia | Blue | Contravening a Red Traffic Light | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5083238 | -1.8332287 | ||
| 23844 | op-snap---monthly-publication-september-2025.pdf | 63 | 2025-09 | Car | Ford | B Max | Gold | Driving without Due Care and Attention | None | Castle Bromwich Interchange | Castle Bromwich Interchange | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23847 | op-snap---monthly-publication-september-2025.pdf | 66 | 2025-09 | Car | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Education | N/A | 52.5113867 | -1.8337258 | ||
| 23849 | op-snap---monthly-publication-september-2025.pdf | 68 | 2025-09 | Car | Seat | Leon | Black | Using a Mobile Phone Whilst Driving | None | Yardely Wood Road | Yardely Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23852 | op-snap---monthly-publication-september-2025.pdf | 71 | 2025-09 | Car | Mercedes-Benz | CLA 200 | Black | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4726661 | -1.8769032 | ||
| 23853 | op-snap---monthly-publication-september-2025.pdf | 72 | 2025-09 | Car | BMW | 330.. | Grey | Contravening a Red Traffic Light | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 23854 | op-snap---monthly-publication-september-2025.pdf | 73 | 2025-09 | Car | Volkswagen | Golf | Black | Contravening a Red Traffic Light | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Education | N/A | 52.4555288 | -1.8613929 | ||
| 23857 | op-snap---monthly-publication-september-2025.pdf | 76 | 2025-09 | Car | Vauxhall | Zafira | Black | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Court | N/A | 52.5292752 | -1.7618805 | ||
| 23858 | op-snap---monthly-publication-september-2025.pdf | 77 | 2025-09 | Car | Volvo | C30 | Grey | Use on a road a motor vehicle / trailer in such a c | ondition it caused / wasN lioknleey to cause danger | The Green, Kings Norton | The Green, Kings Norton | Birmingham | Birmingham | Court | N/A | 52.4065866 | -1.9308921 | ||
| 23861 | op-snap---monthly-publication-september-2025.pdf | 80 | 2025-09 | Car | Audi | SQ5 | Black | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Education | N/A | 52.4668753 | -1.8996143 | ||
| 23862 | op-snap---monthly-publication-september-2025.pdf | 81 | 2025-09 | Car | Volkswagen | Golf | Red | Driving without Due Care and Attention | None | Wills Street | Wills Street | Birmingham | Birmingham | Warning Letter | N/A | 52.500453 | -1.9141126 | ||
| 23863 | op-snap---monthly-publication-september-2025.pdf | 82 | 2025-09 | Car | Vauxhall | Corsa | Black | Driving without Due Care and Attention | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | Court | N/A | 52.505832 | -1.92002 | ||
| 23864 | op-snap---monthly-publication-september-2025.pdf | 83 | 2025-09 | Car | Volkswagen | T-Roc | Silver | Driving without Due Care and Attention | None | Collingswood Drive | Collingswood Drive | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23868 | op-snap---monthly-publication-september-2025.pdf | 87 | 2025-09 | Car | Audi | A3 | Grey | Contravening a Red Traffic Light | Use vehicle on a road without valid test certificate | Poets Corner | Poets Corner | Birmingham | Birmingham | Court | N/A | 52.4647091 | -1.8588833 | ||
| 23870 | op-snap---monthly-publication-september-2025.pdf | 89 | 2025-09 | Car | Audi | RS 3 | Black | Driving without Due Care and Attention | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Court | N/A | 52.4437078 | -1.8783408 | ||
| 23872 | op-snap---monthly-publication-september-2025.pdf | 91 | 2025-09 | Car | Vauxhall | Mokka | White | Driving without Due Care and Attention | None | Wolverhampton Road | Wolverhampton Road | Birmingham | Birmingham | Warning Letter | N/A | 52.463146 | -1.9844677 | ||
| 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 | ||
| 23889 | op-snap---monthly-publication-september-2025.pdf | 108 | 2025-09 | Car | Mercedes-Benz | A35 AMG | Yellow | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Education | N/A | 52.4470686 | -1.8880749 | ||
| 23891 | op-snap---monthly-publication-september-2025.pdf | 110 | 2025-09 | Car | Nissan | Qashqai | Red | Driving without Due Care and Attention | None | Heathfield Road | Heathfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5905365 | -1.8453418 | ||
| 23892 | op-snap---monthly-publication-september-2025.pdf | 111 | 2025-09 | Car | Peugeot | 208.. | Blue | Using a Mobile Phone Whilst Driving | None | University Locks (Outside Co-Op) | University Locks (Outside Co-Op) | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23893 | op-snap---monthly-publication-september-2025.pdf | 112 | 2025-09 | Car | Mercedes-Benz | C-class | Silver | Contravening a Red Traffic Light | No Insurance | Priory Road, Edgbaston | Priory Road, Edgbaston | Birmingham | Birmingham | Court | N/A | 52.4556998 | -1.9102592 | ||
| 23896 | op-snap---monthly-publication-september-2025.pdf | 115 | 2025-09 | Car | Misc - Non Traffic Offences | None | Cape Hill | Cape Hill | Birmingham | Birmingham | RTC - Actioned | N/A | |||||||
| 23898 | op-snap---monthly-publication-september-2025.pdf | 117 | 2025-09 | Car | BMW | 3 series | Black | Driving without Due Care and Attention | None | Aldridge Road | Aldridge Road | Birmingham | Birmingham | Education | N/A | 52.5368764 | -1.8976461 | ||
| 23901 | op-snap---monthly-publication-september-2025.pdf | 120 | 2025-09 | Car | Toyota | Auris | Blue | Contravening a Red Traffic Light | None | Selly Oak Road | Selly Oak Road | Birmingham | Birmingham | NFA | No Offence | 52.4263875 | -1.9397954 | ||
| 23902 | op-snap---monthly-publication-september-2025.pdf | 121 | 2025-09 | Car | Mercedes-Benz | CLS | Silver | Using a Mobile Phone Whilst Driving | None | Rickman Drive | Rickman Drive | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4701606 | -1.9013018 | ||
| 23908 | op-snap---monthly-publication-september-2025.pdf | 127 | 2025-09 | Car | BMW | X3 | Grey | Driving without Due Care and Attention | None | Cartland Road | Cartland Road | Birmingham | Birmingham | Court | N/A | 52.4298554 | -1.9086629 | ||
| 23910 | op-snap---monthly-publication-september-2025.pdf | 129 | 2025-09 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Birmingham Road | Birmingham Road | Birmingham | Birmingham | Education | N/A | 52.5505398 | -1.8252993 | |||
| 23913 | op-snap---monthly-publication-september-2025.pdf | 132 | 2025-09 | Car | Mercedes-Benz | Black | Contravening a Red Traffic Light | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | |||
| 23915 | op-snap---monthly-publication-september-2025.pdf | 134 | 2025-09 | Car | Ford | Mondeo | Black | Driving without Due Care and Attention | None | A45 to Stonbridge | A45 to Stonbridge | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23916 | op-snap---monthly-publication-september-2025.pdf | 135 | 2025-09 | Car | Ford | Fusion | Black | Driving without Due Care and Attention | None | Melton Avenue | Melton Avenue | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23921 | op-snap---monthly-publication-september-2025.pdf | 140 | 2025-09 | Car | Audi | A3 | Silver | Contravening a Red Traffic Light | None | Dads Lane | Dads Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4375913 | -1.9068522 | ||
| 23922 | op-snap---monthly-publication-september-2025.pdf | 141 | 2025-09 | Car | Toyota | Yaris | Red | Drive on hard shoulder | None | m42 | M42 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 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 | ||
| 23925 | op-snap---monthly-publication-september-2025.pdf | 144 | 2025-09 | Car | BMW | 218I | Blue | Motor vehicle fail to comply with endorsable sect | ion 36 traffic sign -otheNr othnaen manned or automatic | Keiqnugispbmueryn tRoad | Keiqnugispbmueryn t Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23926 | op-snap---monthly-publication-september-2025.pdf | 145 | 2025-09 | Car | Toyota | Yaris | Black | Using a Mobile Phone Whilst Driving | None | M6 | M6 | Birmingham | Birmingham | NFA | No Offence | ||||
| 23932 | op-snap---monthly-publication-september-2025.pdf | 151 | 2025-09 | Car | Audi | Q7.. | Grey | Driving without Due Care and Attention | None | Spitfire island | Spitfire island | Birmingham | Birmingham | Education | N/A | 52.5138106 | -1.797297 | ||
| 23934 | op-snap---monthly-publication-september-2025.pdf | 153 | 2025-09 | Car | Toyota | Verso | Silver | Contravening a Red Traffic Light | None | Suffolk Street | Suffolk Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4749336 | -1.9003475 | ||
| 23935 | op-snap---monthly-publication-september-2025.pdf | 154 | 2025-09 | Car | Vauxhall | Astra | Black | Using a Mobile Phone Whilst Driving | None | M6 Motorway, Southbound | M6 Motorway, Southbound | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23936 | op-snap---monthly-publication-september-2025.pdf | 155 | 2025-09 | Car | Volvo | S90 | Blue | Driving without Due Care and Attention | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Warning Letter | N/A | 52.4220705 | -1.8372335 | ||
| 23939 | op-snap---monthly-publication-september-2025.pdf | 158 | 2025-09 | Car | Mercedes-Benz | C250 | Silver | Motor vehicle fail to comply with endorsable sect | ion 36 traffic sign -otheNr othnaen manned or automatic | Weqaulsipamll Renotad | Weqaulsipamll Renotad | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23943 | op-snap---monthly-publication-september-2025.pdf | 162 | 2025-09 | Car | Seat | Ibiza | Black | Driving without Due Care and Attention | None | Yardley Green Road | Yardley Green Road | Birmingham | Birmingham | Education | N/A | 52.4764154 | -1.8311418 | ||
| 23945 | op-snap---monthly-publication-september-2025.pdf | 164 | 2025-09 | Car | Nissan | Qashqai | Grey | Driving without Due Care and Attention | None | Bosworth Drive | Bosworth Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4779726 | -1.7596871 | ||
| 23948 | op-snap---monthly-publication-september-2025.pdf | 167 | 2025-09 | Car | Land Rover | Sport | Grey | Drive a vehicle other than on the carriageway of a | motorway None | M6 Motorway, Southbound. Jn 7A | M6 Motorway, Southbound. Junction 7A | Birmingham | Birmingham | Education | N/A | ||||
| 23954 | op-snap---monthly-publication-september-2025.pdf | 173 | 2025-09 | Car | Volkswagen | Tiguan | Grey | Contravening a Red Traffic Light | No Insurance | Six Ways, Lozells | Six Ways, Lozells | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5022359 | -1.8984899 | ||
| 23955 | op-snap---monthly-publication-september-2025.pdf | 174 | 2025-09 | Car | Toyota | Corolla | Black | Driving without Due Care and Attention | None | Warwick Road Acocks Green | Warwick Road Acocks Green | Birmingham | Birmingham | Education | N/A | 52.4468495 | -1.8244484 | ||
| 23956 | op-snap---monthly-publication-september-2025.pdf | 175 | 2025-09 | Car | Ford | Focus | Black | Contravening a Red Traffic Light | None | Wake Green Road | Wake Green Road | Birmingham | Birmingham | Education | N/A | 52.4437078 | -1.8783408 | ||
| 23957 | op-snap---monthly-publication-september-2025.pdf | 176 | 2025-09 | Car | Land Rover | Evoque | White | Driving without Due Care and Attention | None | Bradford Road | Bradford Road | Birmingham | Birmingham | NFA | No Offence | 52.5024148 | -1.7961753 | ||
| 23958 | op-snap---monthly-publication-september-2025.pdf | 177 | 2025-09 | Car | Seat | Ibiza | Grey | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Education | N/A | 52.4726661 | -1.8769032 | ||
| 23960 | op-snap---monthly-publication-september-2025.pdf | 179 | 2025-09 | Car | Mg | 3 Trophy | White | Driving without Due Care and Attention | None | B4173 | B4173 | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4496153 | -1.8646204 | ||
| 23967 | op-snap---monthly-publication-september-2025.pdf | 186 | 2025-09 | Car | Skoda | Kodiaq | Silver | Contravening a Red Traffic Light | None | Holloway Head | Holloway Head | Birmingham | Birmingham | Education | N/A | 52.474258 | -1.9019723 | ||
| 23969 | op-snap---monthly-publication-september-2025.pdf | 188 | 2025-09 | Car | Nissan | Note | Orange | Contravening a Red Traffic Light | None | Broad Lane Kings Heath | Broad Lane Kings Heath | Birmingham | Birmingham | Education | N/A | 52.410787 | -1.918202 | ||
| 23973 | op-snap---monthly-publication-september-2025.pdf | 192 | 2025-09 | Car | Vauxhall | Insignia | Silver | Driving without Due Care and Attention | None | M6 SB J7 | M6 Southbound J7 | Birmingham | Birmingham | NFA | No Offence | 52.676119 | -2.0858425 | ||
| 23976 | op-snap---monthly-publication-september-2025.pdf | 195 | 2025-09 | Car | BMW | 320.. | White | Driving without Due Care and Attention | None | A38 Aston Expressway | Aston Expressway | Birmingham | Birmingham | Education | N/A | 52.493793 | -1.8881773 | ||
| 23978 | op-snap---monthly-publication-september-2025.pdf | 197 | 2025-09 | Car | Ford | Fiesta | Black | Driving without Due Care and Attention | None | Curzon Circus | Curzon Circus | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 23979 | op-snap---monthly-publication-september-2025.pdf | 198 | 2025-09 | Car | Toyota | Yaris | Black | Driving without Reasonable Consideration | None | Coventry Road, Small Heath | Coventry Road, Small Heath | Birmingham | Birmingham | NFA | No Offence | 52.4650893 | -1.8425008 | ||
| 23980 | op-snap---monthly-publication-september-2025.pdf | 199 | 2025-09 | Car | Polestar | Blue | Contravening a Red Traffic Light | No vehicle excise licence | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Education | N/A | 52.4103191 | -1.8670224 | |||
| 23981 | op-snap---monthly-publication-september-2025.pdf | 200 | 2025-09 | Car | Husqvarna | White | Driving without Due Care and Attention | None | Melchett Road | Melchett Road | Birmingham | Birmingham | Education | N/A | 52.413984 | -1.9251511 | |||
| 23986 | op-snap---monthly-publication-september-2025.pdf | 205 | 2025-09 | Car | BMW | 320.. | White | Driving without Due Care and Attention | None | Wash Lane Yardley Wood | Wash Lane Yardley Wood | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 23987 | op-snap---monthly-publication-september-2025.pdf | 206 | 2025-09 | Car | Volvo | V90 | White | Driving without Due Care and Attention | None | Broadmeadow Lane | Broadmeadow Lane | Birmingham | Birmingham | Education | N/A | ||||
| 23991 | op-snap---monthly-publication-september-2025.pdf | 210 | 2025-09 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Small Heath Highway | Small Heath Highway | Birmingham | Birmingham | NFA | No Offence | 52.4709298 | -1.8722585 | ||
| 23994 | op-snap---monthly-publication-september-2025.pdf | 213 | 2025-09 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Court | N/A | 52.50787 | -1.8195713 | ||
| 23996 | op-snap---monthly-publication-september-2025.pdf | 215 | 2025-09 | Car | BMW | 320.. | Silver | Contravening a Red Traffic Light | None | Calthorpe Road | Calthorpe Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5142235 | -1.9073557 | ||
| 24001 | op-snap---monthly-publication-september-2025.pdf | 220 | 2025-09 | Car | Audi | A6 | Grey | Driving without Due Care and Attention | None | Turves Green, Longbridge | Turves Green, Longbridge | Birmingham | Birmingham | NFA | No Offence | 52.3964205 | -1.9697415 | ||
| 24002 | op-snap---monthly-publication-september-2025.pdf | 221 | 2025-09 | Car | Kia | Xceed | Silver | Driving a vehicle wholly or partly on a footpath | None | Oxford Road | Oxford Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4456323 | -1.8858352 | ||
| 24004 | op-snap---monthly-publication-september-2025.pdf | 223 | 2025-09 | Car | Mercedes-Benz | A200 | Purple | Driving without Due Care and Attention | None | Lickey Road | Lickey Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.3868298 | -2.0003781 | ||
| 24005 | op-snap---monthly-publication-september-2025.pdf | 224 | 2025-09 | Car | Ford | Focus | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 24006 | op-snap---monthly-publication-september-2025.pdf | 225 | 2025-09 | Car | Peugeot | 308 | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Education | N/A | 52.4167654 | -1.9411244 | ||
| 24007 | op-snap---monthly-publication-september-2025.pdf | 226 | 2025-09 | Car | Toyota | yaris | Red | Contravening a Red Traffic Light | None | Northfied Road | Northfied Road | Birmingham | Birmingham | Education | N/A | ||||
| 24009 | op-snap---monthly-publication-september-2025.pdf | 228 | 2025-09 | Car | BMW | 5 series | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Court | N/A | 52.4167654 | -1.9411244 | ||
| 24011 | op-snap---monthly-publication-september-2025.pdf | 230 | 2025-09 | Car | Nissan | Qashqai | Grey | Contravening a Red Traffic Light | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Court | N/A | 52.4167654 | -1.9411244 | ||
| 24018 | op-snap---monthly-publication-september-2025.pdf | 237 | 2025-09 | Car | Honda | Civic | Grey | Contravening a Red Traffic Light | None | Castle Bromwich Interchange roundabout | Castle Bromwich Interchange roundabout | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24021 | op-snap---monthly-publication-september-2025.pdf | 240 | 2025-09 | Car | Mercedes-Benz | SLC 250 | White | Contravening a Red Traffic Light | None | Stratford Road Shirley | Stratford Road Shirley | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24024 | op-snap---monthly-publication-september-2025.pdf | 243 | 2025-09 | Car | Nissan | Qashqai | Black | Driving without Due Care and Attention | None | Deelands Road | Deelands Road | Birmingham | Birmingham | Warning Letter | N/A | 52.3970488 | -2.0184857 | ||
| 24028 | op-snap---monthly-publication-september-2025.pdf | 247 | 2025-09 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5458699 | -1.9304484 | ||
| 24029 | op-snap---monthly-publication-september-2025.pdf | 248 | 2025-09 | Car | Volkswagen | Passat | Black | Driving without Due Care and Attention | None | Gerrard Street | Gerrard Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5002335 | -1.9032351 | ||
| 24030 | op-snap---monthly-publication-september-2025.pdf | 249 | 2025-09 | Car | Audi | Q5 | Blue | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24033 | op-snap---monthly-publication-september-2025.pdf | 252 | 2025-09 | Car | Vauxhall | MOKKA | Black | Driving without Due Care and Attention | None | Wolverton Road | Wolverton Road | Birmingham | Birmingham | NFA | Out of Force | 52.3900767 | -1.9976014 | ||
| 24034 | op-snap---monthly-publication-september-2025.pdf | 253 | 2025-09 | Car | Land Rover | Range Rover | Black | Driving without Due Care and Attention | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Court | N/A | 52.4967329 | -1.8097462 | ||
| 24035 | op-snap---monthly-publication-september-2025.pdf | 254 | 2025-09 | Car | Audi | A3 | Black | Driving without Due Care and Attention | None | Boldmere Road | Boldmere Road | Birmingham | Birmingham | Warning Letter | N/A | 52.548309 | -1.8411769 | ||
| 24038 | op-snap---monthly-publication-september-2025.pdf | 257 | 2025-09 | Car | Land Rover | Defender | Black | Using a Mobile Phone Whilst Driving | None | M6?? | M6?? | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5264754 | -1.8895798 | ||
| 24045 | op-snap---monthly-publication-september-2025.pdf | 264 | 2025-09 | Car | Volkswagen | Golf | Grey | Driving without Due Care and Attention | No Insurance | Drews Lane, Erdington | Drews Lane, Erdington | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 24048 | op-snap---monthly-publication-september-2025.pdf | 267 | 2025-09 | Car | Toyota | C-HR | Silver | Contravening a Red Traffic Light | None | Five ways | Five ways | Birmingham | Birmingham | Warning Letter | N/A | 52.4710941 | -1.9130708 | ||
| 24049 | op-snap---monthly-publication-september-2025.pdf | 268 | 2025-09 | Car | Audi | Q2 | Black | Contravening a Red Traffic Light | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4720132 | -1.9142946 | ||
| 24052 | op-snap---monthly-publication-september-2025.pdf | 271 | 2025-09 | Car | Peugeot | Traveller | Black | Driving without Due Care and Attention | None | A38 Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4543565 | -1.9114004 |
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);