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'}
971 rows where council_area = "Birmingham" and month = "2025-09" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make >30
offence >30
- Cause unnecessary obstruction by motor vehicle 303
- Driving without Due Care and Attention 252
- Contravening a Red Traffic Light 117
- Using a Mobile Phone Whilst Driving 48
- Misc - Non Traffic Offences 46
- Contravene Lane Closure Red X 37
- Cause vehicle to be left in a dangerous position 33
- Driving without Reasonable Consideration 23
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 17
- Motor vehicle fail to comply with endorsable sect 14
- Driving a vehicle wholly or partly on a footpath 12
- Motor vehicle fail to comply with a non endorsab 10
- Use a vehicle / cycle on a road and contravene a l 8
- / trailer outside of the Greater London area 7
- Motor vehicle fail to accord precedence at a pelic 5
- Drive a vehicle other than on the carriageway of a 4
- VRM fails to conform to Regulations 4
- Drive on hard shoulder 3
- Prohibited vehicle in offside lane of motorway 3
- Stop a vehicle on pedestrian crossing 3
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 2
- Dangerous Driving 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Stop a vehicle within pelican pedestrian crossing l 2
- section 36 traffic sign -other than manned or 2
- CCaauussee vuenhniecclee stsoa brye olebfstt irnu cat dioann gbeyr mouost opro vseithioicnle 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
- …
reporter_transport_mode 8
- Car 635
- Pedestrian 233
- Pedal Bike 79
- Other 16
- Motorbike 4
- Lorry 2
- 14695 1
- Horse Rider 1
disposal 7
- Warning Letter 496
- NFA 220
- Education 116
- Fixed Penalty 89
- Court 33
- Other Action Taken 9
- RTC - Actioned 8
month 1
- 2025-09 · 971 ✖
council_area 1
- Birmingham · 971 ✖
| 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 | ||
| 23788 | op-snap---monthly-publication-september-2025.pdf | 7 | 2025-09 | Pedal Bike | Mercedes-Benz | Sprinter | Silver | Driving without Due Care and Attention | None | Moor Green lane | Moor Green lane | Birmingham | Birmingham | Education | N/A | 52.4374665 | -1.9119895 | ||
| 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 | |||
| 23800 | op-snap---monthly-publication-september-2025.pdf | 19 | 2025-09 | Pedal Bike | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | West Heath Road | West Heath Road | Birmingham | Birmingham | Education | N/A | 52.402785 | -1.9620058 | ||
| 23801 | op-snap---monthly-publication-september-2025.pdf | 20 | 2025-09 | Pedal Bike | BMW | Blue | Driving without Reasonable Consideration | None | West Heath Road | West Heath Road | Birmingham | Birmingham | Education | N/A | 52.402785 | -1.9620058 | |||
| 23802 | op-snap---monthly-publication-september-2025.pdf | 21 | 2025-09 | Pedal Bike | Kia | Sportage | Green | Driving without Due Care and Attention | None | Belgrave Road | Belgrave Road | Birmingham | Birmingham | Education | N/A | 52.4669004 | -1.9011385 | ||
| 23807 | op-snap---monthly-publication-september-2025.pdf | 26 | 2025-09 | Horse Rider | Volvo | V70 | Blue | Driving without Due Care and Attention | No vehicle excise licence | Dark lane, Wythall | Dark lane, Wythall | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 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 | ||
| 23814 | op-snap---monthly-publication-september-2025.pdf | 33 | 2025-09 | Pedal Bike | Ford | Fusion | silver | Using a Mobile Phone Whilst Driving | None | Barford Road to Coplow St | Barford Road to Coplow Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 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 | ||
| 23821 | op-snap---monthly-publication-september-2025.pdf | 40 | 2025-09 | Pedestrian | BMW | 4 series | White | Motor vehicle fail to accord precedence at a pelic | an crossing None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552785 | -1.906384 | ||
| 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 | ||
| 23831 | op-snap---monthly-publication-september-2025.pdf | 50 | 2025-09 | Pedestrian | Seat | Leon | Red | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moseley Road | Moseley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4679402 | -1.881408 | ||
| 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 | ||||
| 23851 | op-snap---monthly-publication-september-2025.pdf | 70 | 2025-09 | Pedestrian | Yamaha | 125 | Blue | Driving a vehicle wholly or partly on a footpath | None | Cotteridge Park | Cotteridge Park | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4214441 | -1.928416 | ||
| 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 | ||||
| 23867 | op-snap---monthly-publication-september-2025.pdf | 86 | 2025-09 | Pedal Bike | Land Rover | Sport | Grey | Using a Mobile Phone Whilst Driving | None | Augustus Road | Augustus Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4695793 | -1.9378608 | ||
| 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 | ||
| 23903 | op-snap---monthly-publication-september-2025.pdf | 122 | 2025-09 | Other | BMW | X6 | White | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4203897 | -1.8338574 | ||
| 23904 | op-snap---monthly-publication-september-2025.pdf | 123 | 2025-09 | Pedal Bike | Porsche | Panamera | Black | Using a Mobile Phone Whilst Driving | None | Park Hill Road | Park Hill Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4612518 | -1.9515542 | ||
| 23906 | op-snap---monthly-publication-september-2025.pdf | 125 | 2025-09 | Pedal Bike | Renault | Kangoo | White | Using a Mobile Phone Whilst Driving | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 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 | ||
| 23909 | op-snap---monthly-publication-september-2025.pdf | 128 | 2025-09 | Pedal Bike | Skoda | Rapid | Grey | Driving without Reasonable Consideration | None | New Street | New Street | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4791344 | -1.8986915 | ||
| 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 | ||||
| 23920 | op-snap---monthly-publication-september-2025.pdf | 139 | 2025-09 | Other | Peugeot | 208 Active | Black | Driving without Due Care and Attention | None | Watson Road | Watson Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4897107 | -1.839943 | ||
| 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 | ||||
| 23928 | op-snap---monthly-publication-september-2025.pdf | 147 | 2025-09 | Pedestrian | Audi | A4 | Black | Misc - Non Traffic Offences | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4307 | -1.8494663 | ||
| 23929 | op-snap---monthly-publication-september-2025.pdf | 148 | 2025-09 | Pedestrian | Ford | Focus | Grey | Misc - Non Traffic Offences | None | Petersfeild Road | Petersfeild Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 23930 | op-snap---monthly-publication-september-2025.pdf | 149 | 2025-09 | Pedestrian | Toyota | Prius | Silver | Misc - Non Traffic Offences | None | Peterfield Road | Peterfield Road | 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 | ||||
| 23941 | op-snap---monthly-publication-september-2025.pdf | 160 | 2025-09 | Other | Fiat | 500 | Green | No Seat Belt | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4700545 | -1.834436 | ||
| 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 | ||||
| 23951 | op-snap---monthly-publication-september-2025.pdf | 170 | 2025-09 | Pedal Bike | Ford | Kuga | Grey | Using a Mobile Phone Whilst Driving | None | Pershore at Cartland | Pershore at Cartland | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4244988 | -1.9217197 | ||
| 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 | ||
| 23961 | op-snap---monthly-publication-september-2025.pdf | 180 | 2025-09 | Pedal Bike | Peugeot | Partner | White | Driving without Reasonable Consideration | None | Merritts Hill | Merritts Hill | Birmingham | Birmingham | Education | N/A | 52.424853 | -1.9814275 | ||
| 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 | ||
| 23970 | op-snap---monthly-publication-september-2025.pdf | 189 | 2025-09 | Pedal Bike | Ford | Focus | Red | Using a Mobile Phone Whilst Driving | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5359496 | -1.8324115 | ||
| 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 | ||
| 23974 | op-snap---monthly-publication-september-2025.pdf | 193 | 2025-09 | Pedal Bike | M/C | Black | Driving without Due Care and Attention | None | Lickey Road | Lickey Road | Birmingham | Birmingham | NFA | No VRM | 52.3868298 | -2.0003781 | |||
| 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 | |||
| 23982 | op-snap---monthly-publication-september-2025.pdf | 201 | 2025-09 | Pedal Bike | Ford | Focus | Black | Driving without Due Care and Attention | No vehicle excise licence | Holly Lane, Marston Green | Holly Lane, Marston Green | Birmingham | Birmingham | Education | N/A | ||||
| 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 |
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);