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'}
386 rows where council_area = "Birmingham", month = "2025-01" and reporter_transport_mode = "Car" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 30
offence 25
- Driving without Due Care and Attention 118
- Contravening a Red Traffic Light 73
- Driving without Reasonable Consideration 43
- Stop a vehicle within pelican pedestrian crossing limits 25
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 24
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 14
- Cause vehicle to be left in a dangerous position 13
- Using a Mobile Phone Whilst Driving 13
- Misc - Non Traffic Offences 11
- Stop a vehicle on pedestrian crossing 10
- Dangerous Driving 6
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 6
- VRM fails to conform to Regulations 6
- Motor vehicle fail to comply with a directional arrow sign 4
- Contravene Lane Closure Red X 3
- Motor vehicle fail to accord precedence at a pelican crossing 3
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 3
- Driver not in position to have Proper Control 2
- Driving a vehicle wholly or partly on a footpath 2
- Vehicle overtake within crossing limits 2
- Drive on hard shoulder 1
- Fail to Conform to Cycle Lane 1
- Keeping a vehicle with registration marks obscured 1
- Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
- Use vehicle on a road without valid test certificate 1
disposal 7
- Fixed Penalty 157
- Warning Letter 67
- Education 66
- NFA 49
- Court 36
- Other Action Taken 8
- RTC - Actioned 3
reporter_transport_mode 1
- Car · 386 ✖
month 1
- 2025-01 · 386 ✖
council_area 1
- Birmingham · 386 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8897 | op-snap---monthly-publication-january-2025.pdf | 5 | 2025-01 | Car | Audi | A1 | Blue | Driving without Due Care and Attention | None | MEADWAY | Meadway | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4783348 | -1.8007708 | |
| 8899 | op-snap---monthly-publication-january-2025.pdf | 7 | 2025-01 | Car | BMW | 4330D | Black | Driving without Due Care and Attention | None | STRATFORD ROAD | Stratford Road | BIRMINGHAM | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4203897 | -1.8338574 | |
| 8902 | op-snap---monthly-publication-january-2025.pdf | 10 | 2025-01 | Car | Audi | Black | Driving without Due Care and Attention | None | Pershore Road, Birmingham | Pershore Road, Birmingham | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4163285 | -1.9286689 | ||
| 8912 | op-snap---monthly-publication-january-2025.pdf | 20 | 2025-01 | Car | Seat | LEON | Black | Driving without Due Care and Attention | None | LONGBRIDGE LANE | Longbridge Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.3962003 | -1.9821252 | |
| 8916 | op-snap---monthly-publication-january-2025.pdf | 24 | 2025-01 | Car | BMW | 520D | Gold | Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 8917 | op-snap---monthly-publication-january-2025.pdf | 25 | 2025-01 | Car | Volkswagen | Transporter | Orange | Vehicle overtake within crossing limits | None | Slade Road | Slade Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5894461 | -1.8082962 | |
| 8924 | op-snap---monthly-publication-january-2025.pdf | 32 | 2025-01 | Car | BMW | UK | Grey | Using a Mobile Phone Whilst Driving | None | A5 | A5 | Birmingham | Birmingham | NFA | Out of Force | Yes - Via Email | |||
| 8925 | op-snap---monthly-publication-january-2025.pdf | 33 | 2025-01 | Car | Mercedes-Benz | C220 | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 8926 | op-snap---monthly-publication-january-2025.pdf | 34 | 2025-01 | Car | BMW | 320i | Black | Contravening a Red Traffic Light | None | Kings Road | Kings Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5531351 | -1.8852761 | |
| 8927 | op-snap---monthly-publication-january-2025.pdf | 35 | 2025-01 | Car | Audi | Q4 | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 8928 | op-snap---monthly-publication-january-2025.pdf | 36 | 2025-01 | Car | Vauxhall | Insignia | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 8929 | op-snap---monthly-publication-january-2025.pdf | 37 | 2025-01 | Car | Mazda | 6 | Blue | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 8930 | op-snap---monthly-publication-january-2025.pdf | 38 | 2025-01 | Car | Audi | s3 | Blue | Driving without Due Care and Attention | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5083238 | -1.8332287 | |
| 8931 | op-snap---monthly-publication-january-2025.pdf | 39 | 2025-01 | Car | Honda | Jazz | Silver | Stop a vehicle on pedestrian crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4967329 | -1.8097462 | |
| 8932 | op-snap---monthly-publication-january-2025.pdf | 40 | 2025-01 | Car | BMW | X7 | Black | Stop a vehicle on pedestrian crossing | None | Coleshill Road | Coleshill Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4967329 | -1.8097462 | |
| 8933 | op-snap---monthly-publication-january-2025.pdf | 41 | 2025-01 | Car | Toyota | Yaris | Blue | Driving without Due Care and Attention | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 8934 | op-snap---monthly-publication-january-2025.pdf | 42 | 2025-01 | Car | Mercedes-Benz | C43 | Grey | Driving without Due Care and Attention | None | Yew Tree Lane | Yew Tree Lane | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4631 | -1.8082055 | |
| 8942 | op-snap---monthly-publication-january-2025.pdf | 50 | 2025-01 | Car | Renault | TRANSIT | Grey | Driving without Due Care and Attention | None | MANOR WAY | Manor Way | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5211993 | -1.8242643 | |
| 8943 | op-snap---monthly-publication-january-2025.pdf | 51 | 2025-01 | Car | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4203897 | -1.8338574 | |
| 8946 | op-snap---monthly-publication-january-2025.pdf | 54 | 2025-01 | Car | Mercedes-Benz | GLB 200 | Black | Contravening a Red Traffic Light | None | Lickey Road | Lickey Road | Birmingham | Birmingham | NFA | Out of Force | Yes - Via Email | 52.3868298 | -2.0003781 | |
| 8949 | op-snap---monthly-publication-january-2025.pdf | 57 | 2025-01 | Car | Audi | A6 | Silver | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5458699 | -1.9304484 | |
| 8962 | op-snap---monthly-publication-january-2025.pdf | 70 | 2025-01 | Car | Mercedes-Benz | BENZ A180 | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | DUDLEY ROAD | Dudley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 8964 | op-snap---monthly-publication-january-2025.pdf | 72 | 2025-01 | Car | Fiat | PUNTO | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | SABELL ROAD | Sabell Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 8975 | op-snap---monthly-publication-january-2025.pdf | 83 | 2025-01 | Car | Audi | S3 | Yellow | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 8993 | op-snap---monthly-publication-january-2025.pdf | 101 | 2025-01 | Car | Peugeot | 207 | Silver | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.471632 | -1.9456776 | |
| 8994 | op-snap---monthly-publication-january-2025.pdf | 102 | 2025-01 | Car | Audi | RS6 | Black | Driving without Due Care and Attention | None | Shirley Road | Shirley Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4198291 | -1.9241732 | |
| 8998 | op-snap---monthly-publication-january-2025.pdf | 106 | 2025-01 | Car | Hyundai | TUCSON | Black | Stop a vehicle within pelican pedestrian crossing limits | None | HIGH STREET | High Street | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5254588 | -1.8373064 | |
| 9004 | op-snap---monthly-publication-january-2025.pdf | 112 | 2025-01 | Car | Tesla | THREE | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5095686 | -1.9544485 | |
| 9005 | op-snap---monthly-publication-january-2025.pdf | 113 | 2025-01 | Car | Daf | HGV | White | Driving without Reasonable Consideration | None | M6 | M6 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 9011 | op-snap---monthly-publication-january-2025.pdf | 119 | 2025-01 | Car | BMW | X5 | Blue | Driving without Due Care and Attention | None | M6 | M6 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 9014 | op-snap---monthly-publication-january-2025.pdf | 122 | 2025-01 | Car | Mercedes-Benz | Sprinter | White | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 9015 | op-snap---monthly-publication-january-2025.pdf | 123 | 2025-01 | Car | Ford | Iveco | White | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 9016 | op-snap---monthly-publication-january-2025.pdf | 124 | 2025-01 | Car | Vauxhall | Corsa | Grey | Contravene Lane Closure Red X | None | M6 | M6 | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 9019 | op-snap---monthly-publication-january-2025.pdf | 127 | 2025-01 | Car | BMW | 530E | White | Driving without Due Care and Attention | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4726661 | -1.8769032 | |
| 9020 | op-snap---monthly-publication-january-2025.pdf | 128 | 2025-01 | Car | Ford | Fiesta | Black | Driving without Reasonable Consideration | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5521118 | -1.8845138 | |
| 9021 | op-snap---monthly-publication-january-2025.pdf | 129 | 2025-01 | Car | Ford | TRANSIT | White | Contravening a Red Traffic Light | None | A452 CHESTER ROAD | A452 Chester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.5338529 | -1.8296813 | |
| 9023 | op-snap---monthly-publication-january-2025.pdf | 131 | 2025-01 | Car | Hyundai | TUCSON | Grey | Contravening a Red Traffic Light | None | Wolverhampton road | Wolverhampton road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.463146 | -1.9844677 | |
| 9024 | op-snap---monthly-publication-january-2025.pdf | 132 | 2025-01 | Car | Audi | Q3 | Silver | Driving without Due Care and Attention | None | Birchley island | Birchley island | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 9025 | op-snap---monthly-publication-january-2025.pdf | 133 | 2025-01 | Car | Renault | N/P | Drive on hard shoulder | None | M6 NORTH JCT 8-9 | M6 North Jct 8-9 | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | ||||
| 9033 | op-snap---monthly-publication-january-2025.pdf | 141 | 2025-01 | Car | Peugeot | 3008 | Blue | Driving without Reasonable Consideration | None | M42 J5-6 | M42 J5-6 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 9043 | op-snap---monthly-publication-january-2025.pdf | 151 | 2025-01 | Car | Daf | Truck | White | Stop a vehicle within pelican pedestrian crossing limits | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4103191 | -1.8670224 | |
| 9060 | op-snap---monthly-publication-january-2025.pdf | 168 | 2025-01 | Car | Seat | Unknown | Black | Driving without Due Care and Attention | None | Palmerston Road | Palmerston Road | Birmingham | Birmingham | RTC - Actioned | N/A | Yes - Via Email | 52.4599575 | -1.8708964 | |
| 9063 | op-snap---monthly-publication-january-2025.pdf | 171 | 2025-01 | Car | Volkswagen | Golf | Black | Driving without Due Care and Attention | None | The Green, Kings Norton | The Green, Kings Norton | Birmingham | Birmingham | NFA | No Offence | Yes - Via Email | 52.4065866 | -1.9308921 | |
| 9064 | op-snap---monthly-publication-january-2025.pdf | 172 | 2025-01 | Car | Nissan | Juke | White | Contravening a Red Traffic Light | None | Five Ways roundabout | Five Ways roundabout | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 9066 | op-snap---monthly-publication-january-2025.pdf | 174 | 2025-01 | Car | Renault | Master | White | Driving without Due Care and Attention | None | M42 Junction 9 | M42 Junction 9 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.3601724 | -1.8062199 | |
| 9069 | op-snap---monthly-publication-january-2025.pdf | 177 | 2025-01 | Car | Toyota | Noah | White | Contravening a Red Traffic Light | None | A45 | A45 | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 9072 | op-snap---monthly-publication-january-2025.pdf | 180 | 2025-01 | Car | Ford | Focus | Black | Driving without Reasonable Consideration | None | Queensbridge Road | Queensbridge Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4415108 | -1.8971434 | |
| 9080 | op-snap---monthly-publication-january-2025.pdf | 188 | 2025-01 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Himbleton Road Worcestershire | Himbleton Road Worcestershire | Birmingham | Birmingham | NFA | Out of Force | Yes - Via Email | |||
| 9085 | op-snap---monthly-publication-january-2025.pdf | 193 | 2025-01 | Car | Volkswagen | Golf | Black | Driving without Reasonable Consideration | None | Tyburn Island | Tyburn Island | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5193542 | -1.800381 | |
| 9086 | op-snap---monthly-publication-january-2025.pdf | 194 | 2025-01 | Car | Mercedes-Benz | A Class | Grey | Driving without Reasonable Consideration | None | M42 Warwickshire | M42 Warwickshire | Birmingham | Birmingham | NFA | Out of Force | Yes - Via Email | |||
| 9092 | op-snap---monthly-publication-january-2025.pdf | 200 | 2025-01 | Car | Daf | HGV | Blue | Driving without Reasonable Consideration | None | Unknown not given | Unknown not given | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | |||
| 9095 | op-snap---monthly-publication-january-2025.pdf | 203 | 2025-01 | Car | Volkswagen | Sharan | Black | Driving without Due Care and Attention | None | Villa Road, Handsworth | Villa Road, Handsworth | Birmingham | Birmingham | Education | N/A | Yes - Via Email | |||
| 9098 | op-snap---monthly-publication-january-2025.pdf | 206 | 2025-01 | Car | Ford | Focus | Silver | Driving without Due Care and Attention | No Insurance | Hunters Road, Lozells | Hunters Road, Lozells | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5011362 | -1.9175837 | |
| 9099 | op-snap---monthly-publication-january-2025.pdf | 207 | 2025-01 | Car | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Villa Road, Handsworth | Villa Road, Handsworth | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 9102 | op-snap---monthly-publication-january-2025.pdf | 210 | 2025-01 | Car | Mercedes-Benz | GL350 | Black | Driving without Due Care and Attention | None | A41 | A41 | Birmingham | Birmingham | Court | N/A | Yes - Via Email | |||
| 9106 | op-snap---monthly-publication-january-2025.pdf | 214 | 2025-01 | Car | Volvo | V40 | White | Contravening a Red Traffic Light | None | Island Road | Island Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5095686 | -1.9544485 | |
| 9107 | op-snap---monthly-publication-january-2025.pdf | 215 | 2025-01 | Car | Ford | Focus | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5095686 | -1.9544485 | |
| 9108 | op-snap---monthly-publication-january-2025.pdf | 216 | 2025-01 | Car | BMW | X5 | Black | Driving without Reasonable Consideration | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4203897 | -1.8338574 | |
| 9113 | op-snap---monthly-publication-january-2025.pdf | 221 | 2025-01 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Fort Parkway | Fort Parkway | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.50787 | -1.8195713 | |
| 9114 | op-snap---monthly-publication-january-2025.pdf | 222 | 2025-01 | Car | Mercedes-Benz | GLA | Black | Driver not in position to have Proper Control | None | Chester Road | Chester Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5359496 | -1.8324115 | |
| 9115 | op-snap---monthly-publication-january-2025.pdf | 223 | 2025-01 | Car | Mercedes-Benz | E220 | Grey | Cause vehicle to be left in a dangerous position | None | Station Road | Station Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.5054559 | -1.9506109 | |
| 9119 | op-snap---monthly-publication-january-2025.pdf | 227 | 2025-01 | Car | BMW | 520D | Blue | Driving without Reasonable Consideration | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5919543 | -1.8517118 | |
| 9120 | op-snap---monthly-publication-january-2025.pdf | 228 | 2025-01 | Car | Toyota | Yaris | black | Driving without Due Care and Attention | None | Chester Road North | Chester Road North | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.548449 | -1.8594603 | |
| 9121 | op-snap---monthly-publication-january-2025.pdf | 229 | 2025-01 | Car | Toyota | Yaris | Silver | Driving without Reasonable Consideration | No Insurance | Dudley Road | Dudley Road | Birmingham | Birmingham | Other Action Taken | eNn/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 9122 | op-snap---monthly-publication-january-2025.pdf | 230 | 2025-01 | Car | Seat | Ateca | Black | Driving without Reasonable Consideration | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 9125 | op-snap---monthly-publication-january-2025.pdf | 233 | 2025-01 | Car | Mini | Cooper | Blue | Driving without Due Care and Attention | None | Water Orton Road | Water Orton Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5153394 | -1.7573409 | |
| 9131 | op-snap---monthly-publication-january-2025.pdf | 239 | 2025-01 | Car | Mazda | 3 | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | Use vehicle on a road without valid test c | eArltciefisctaetre Road, Kings Heath | e Arltciefisctaetre Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | |||
| 9133 | op-snap---monthly-publication-january-2025.pdf | 241 | 2025-01 | Car | Mercedes-Benz | E220 | Blue | Driving without Reasonable Consideration | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4470686 | -1.8880749 | |
| 9143 | op-snap---monthly-publication-january-2025.pdf | 251 | 2025-01 | Car | Kia | Ceed | Blue | Driving without Due Care and Attention | None | Victoria St, Stourbridge | Victoria Street, Stourbridge | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | |||
| 9147 | op-snap---monthly-publication-january-2025.pdf | 255 | 2025-01 | Car | Nissan | Juke | Black | Contravening a Red Traffic Light | None | Harborne Lane | Harborne Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4468464 | -1.9454816 | |
| 9150 | op-snap---monthly-publication-january-2025.pdf | 258 | 2025-01 | Car | Mercedes-Benz | EQC 400 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Island Road | Island Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5095686 | -1.9544485 | |
| 9155 | op-snap---monthly-publication-january-2025.pdf | 263 | 2025-01 | Car | Renault | UNKNOWN | Blue | Driving without Due Care and Attention | None | Portland Road | Portland Road | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4737014 | -1.9412436 | |
| 9162 | op-snap---monthly-publication-january-2025.pdf | 270 | 2025-01 | Car | Nissan | Qashqai | Silver | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 9163 | op-snap---monthly-publication-january-2025.pdf | 271 | 2025-01 | Car | Toyota | Verso | White | Stop a vehicle on pedestrian crossing | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 9164 | op-snap---monthly-publication-january-2025.pdf | 272 | 2025-01 | Car | Seat | Leon | Black | Driving without Reasonable Consideration | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4203897 | -1.8338574 | |
| 9165 | op-snap---monthly-publication-january-2025.pdf | 273 | 2025-01 | Car | Toyota | Yaris | Blue | Misc - Non Traffic Offences | None | Collector Road | Collector Road | Birmingham | Birmingham | Other Action Taken | eNn/A | Yes - Via Email | 52.5139393 | -1.7600186 | |
| 9166 | op-snap---monthly-publication-january-2025.pdf | 274 | 2025-01 | Car | Volkswagen | Passat | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4929304 | -1.8229092 | |
| 9169 | op-snap---monthly-publication-january-2025.pdf | 277 | 2025-01 | Car | Toyota | Yaris | Grey | Driving without Due Care and Attention | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.513857 | -1.9367367 | |
| 9185 | op-snap---monthly-publication-january-2025.pdf | 293 | 2025-01 | Car | Peugeot | Black | Driving without Due Care and Attention | None | B4121 | B4121 | Birmingham | Birmingham | NFA | No VRM | Yes - Via Email | 52.4448693 | -1.9772096 | ||
| 9186 | op-snap---monthly-publication-january-2025.pdf | 294 | 2025-01 | Car | Mercedes-Benz | Sprinter | White | Driving without Due Care and Attention | None | Six Ways Lozells | Six Ways Lozells | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.502463 | -1.8995194 | |
| 9191 | op-snap---monthly-publication-january-2025.pdf | 299 | 2025-01 | Car | Ford | KA | Silver | Driving without Due Care and Attention | None | Newport Road | Newport Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.5027779 | -1.7982159 | |
| 9194 | op-snap---monthly-publication-january-2025.pdf | 302 | 2025-01 | Car | Honda | HR | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | GILBY ROAD | Gilby Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4763908 | -1.9225901 | |
| 9195 | op-snap---monthly-publication-january-2025.pdf | 303 | 2025-01 | Car | BMW | 330E | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | ISLAND ROAD | Island Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.5095686 | -1.9544485 | |
| 9198 | op-snap---monthly-publication-january-2025.pdf | 306 | 2025-01 | Car | Ford | FIESTA | Silver | Dangerous Driving | None | WARWICK ROAD | Warwick Road | Birmingham | Birmingham | Court | N/A | Yes - Via Email | 52.4555288 | -1.8613929 | |
| 9205 | op-snap---monthly-publication-january-2025.pdf | 313 | 2025-01 | Car | Volkswagen | GOLF | Black | Contravening a Red Traffic Light | None | WAKE GREEN ROAD | Wake Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4437078 | -1.8783408 | |
| 9207 | op-snap---monthly-publication-january-2025.pdf | 315 | 2025-01 | Car | Mercedes-Benz | SPRINTER | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | COLE HALL LANE | Cole Hall Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4877244 | -1.787883 | |
| 9208 | op-snap---monthly-publication-january-2025.pdf | 316 | 2025-01 | Car | Hyundai | I20 | Black | Driving without Reasonable Consideration | None | LEA VILLAGE ISLAND | Lea Village Island | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4836058 | -1.77661 | |
| 9211 | op-snap---monthly-publication-january-2025.pdf | 319 | 2025-01 | Car | Kia | Picanto | Red | Contravening a Red Traffic Light | None | Soho Road | Soho Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.502568 | -1.9305447 | |
| 9216 | op-snap---monthly-publication-january-2025.pdf | 324 | 2025-01 | Car | Renault | TRAFIC | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | EDDISH ROAD | Eddish Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4833672 | -1.7871439 | |
| 9221 | op-snap---monthly-publication-january-2025.pdf | 329 | 2025-01 | Car | BMW | 520 | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | SWAN ISLAND | Swan Island | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4616042 | -1.8154705 | |
| 9222 | op-snap---monthly-publication-january-2025.pdf | 330 | 2025-01 | Car | BMW | 530M | Grey | Driving without Reasonable Consideration | None | PRIORY ROAD | Priory Road | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4132696 | -1.8555008 | |
| 9226 | op-snap---monthly-publication-january-2025.pdf | 334 | 2025-01 | Car | Seat | Arona | Black | Driving without Due Care and Attention | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | Yes - Via Email | 52.4865107 | -1.9386263 | |
| 9235 | op-snap---monthly-publication-january-2025.pdf | 343 | 2025-01 | Car | Renault | Traffic | White | Cause vehicle to be left in a dangerous position | None | Eddish Road | Eddish Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4833672 | -1.7871439 | |
| 9246 | op-snap---monthly-publication-january-2025.pdf | 354 | 2025-01 | Car | Mercedes-Benz | CLA250 | White | Contravening a Red Traffic Light | None | Wheelwright Lane | Wheelwright Lane | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.5089309 | -1.8333828 | |
| 9248 | op-snap---monthly-publication-january-2025.pdf | 356 | 2025-01 | Car | Mercedes-Benz | CLA | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | BRISTOL ROAD | Bristol Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4543565 | -1.9114004 | |
| 9249 | op-snap---monthly-publication-january-2025.pdf | 357 | 2025-01 | Car | Vauxhall | Zafira | Blue | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Pershore Road | Pershore Road | Birmingham | Birmingham | Fixed Penalty | N/A | Yes - Via Email | 52.4308271 | -1.920078 | |
| 9255 | op-snap---monthly-publication-january-2025.pdf | 363 | 2025-01 | Car | Mercedes-Benz | BENZ | Black | Driving without Due Care and Attention | None | MONTAGUE STREET | Montague Street | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 9257 | op-snap---monthly-publication-january-2025.pdf | 365 | 2025-01 | Car | Land Rover | SPORT | Red | Driving without Due Care and Attention | None | MONTAGUE STREET | Montague Street | Birmingham | Birmingham | Education | N/A | Yes - Via Email | 52.4816806 | -1.8788939 | |
| 9258 | op-snap---monthly-publication-january-2025.pdf | 366 | 2025-01 | Car | Black | Driving without Due Care and Attention | None | STRATFORD ROAD | Stratford Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | Yes - Via Email | 52.4203897 | -1.8338574 | |||
| 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 |
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);