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'}
496 rows where council_area = "Birmingham", disposal = "Warning Letter" and month = "2025-09" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence
vehicle_make >30
offence 26
- Cause unnecessary obstruction by motor vehicle 274
- Driving without Due Care and Attention 75
- Contravene Lane Closure Red X 30
- Cause vehicle to be left in a dangerous position 29
- Contravening a Red Traffic Light 17
- /C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 14
- Driving without Reasonable Consideration 8
- Motor vehicle fail to comply with endorsable sect 7
- Misc - Non Traffic Offences 5
- Motor vehicle fail to comply with a non endorsab 5
- Use a vehicle / cycle on a road and contravene a l 5
- / trailer outside of the Greater London area 4
- Stop a vehicle on pedestrian crossing 3
- VRM fails to conform to Regulations 3
- Driving a vehicle wholly or partly on a footpath 2
- Motor vehicle fail to accord precedence at a pelic 2
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
- Prohibited vehicle in offside lane of motorway 2
- Using a Mobile Phone Whilst Driving 2
- CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 1
- DCariuvsineg u wnnitehcoeusts aDruye o Cbasrteru acntido nA tbtye nmtiootnor vehicle 1
- No Seat Belt 1
- Stop a vehicle within pelican pedestrian crossing l 1
- Use a motor vehicle / trailer in a condition likely t 1
- VCaRuMse f auinlsn teoc ceossnaforyr mob tsot rRuecgtiuolnat bioyn msotor vehicle 1
- section 36 traffic sign -other than manned or 1
reporter_transport_mode 6
- Car 302
- Pedestrian 169
- Pedal Bike 19
- Other 4
- Lorry 1
- Motorbike 1
month 1
- 2025-09 · 496 ✖
disposal 1
- Warning Letter · 496 ✖
council_area 1
- Birmingham · 496 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||
| 23997 | op-snap---monthly-publication-september-2025.pdf | 216 | 2025-09 | Pedestrian | Seat | Leon | Black | Contravening a Red Traffic Light | None | Sandon Road | Sandon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4733908 | -1.9577579 | ||
| 24013 | op-snap---monthly-publication-september-2025.pdf | 232 | 2025-09 | Pedal Bike | Peugeot | 207 | Black | Driving without Reasonable Consideration | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 24057 | op-snap---monthly-publication-september-2025.pdf | 276 | 2025-09 | Car | Seat | Leon | Black | Driving without Due Care and Attention | None | Nursery Road | Nursery Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4979836 | -1.9118163 | ||
| 24060 | op-snap---monthly-publication-september-2025.pdf | 279 | 2025-09 | Car | Mercedes-Benz | c300 | Grey | Driving without Due Care and Attention | None | High Street, Newtown | High Street, Newtown | Birmingham | Birmingham | Warning Letter | N/A | 52.5000098 | -1.8959802 | ||
| 24062 | op-snap---monthly-publication-september-2025.pdf | 281 | 2025-09 | Car | Nissan | Qashqai | Black | Driving without Reasonable Consideration | None | Clifford Street, Newtown | Clifford Street, Newtown | Birmingham | Birmingham | Warning Letter | N/A | 52.4989738 | -1.9005402 | ||
| 24065 | op-snap---monthly-publication-september-2025.pdf | 284 | 2025-09 | Car | Volkswagen | Polo | White | section 36 traffic sign -other than manned or | None | Stoney lane | Stoney lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4745488 | -1.8065911 | ||
| 24082 | op-snap---monthly-publication-september-2025.pdf | 301 | 2025-09 | Car | Ford | Transit | White | Motor vehicle fail to comply with a non endorsab | le traffic sign - detectedN boyn meeans other than ACD | A45 | A45 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24093 | op-snap---monthly-publication-september-2025.pdf | 312 | 2025-09 | Pedal Bike | Volkswagen | XC60 | Black | Contravening a Red Traffic Light | None | Holly Lane | Holly Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5236889 | -1.8253311 | ||
| 24117 | op-snap---monthly-publication-september-2025.pdf | 336 | 2025-09 | Pedestrian | Hyundai | Tucson | Black | Using a Mobile Phone Whilst Driving | None | Raddlebarn Lane | Raddlebarn Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4372473 | -1.939828 | ||
| 24141 | op-snap---monthly-publication-september-2025.pdf | 360 | 2025-09 | Car | Volkswagen | Polo | Red | Driving without Due Care and Attention | None | Norman Road | Norman Road | Birmingham | Birmingham | Warning Letter | N/A | 52.411848 | -1.9590923 | ||
| 24150 | op-snap---monthly-publication-september-2025.pdf | 369 | 2025-09 | Pedestrian | Fiat | Ducato | White | Motor vehicle fail to accord precedence at a pelic | an crossing None | Highgate Street | Highgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4651149 | -1.889718 | ||
| 24157 | op-snap---monthly-publication-september-2025.pdf | 376 | 2025-09 | Car | Peugeot | Expert | White | Driving without Due Care and Attention | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | Warning Letter | N/A | 52.4760986 | -1.9018641 | ||
| 24171 | op-snap---monthly-publication-september-2025.pdf | 390 | 2025-09 | Car | Ford | Kuga | Grey | Driving without Due Care and Attention | None | Fox Hollies Road | Fox Hollies Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5517052 | -1.7825505 | ||
| 24184 | op-snap---monthly-publication-september-2025.pdf | 403 | 2025-09 | Car | Vauxhall | mokka | Blue | Driving without Due Care and Attention | None | The Crescent | The Crescent | Birmingham | Birmingham | Warning Letter | N/A | 52.4568799 | -1.8734416 | ||
| 24187 | op-snap---monthly-publication-september-2025.pdf | 406 | 2025-09 | Car | Suzuki | vitara | Grey | Driving without Due Care and Attention | None | Smallheath Highway | Smallheath Highway | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24189 | op-snap---monthly-publication-september-2025.pdf | 408 | 2025-09 | Car | Skoda | Fabia | Blue | Motor vehicle fail to comply with endorsable sect | ion 36 traffic sign -otheNr othnaen manned or automatic | Aeq4u5i pCmoveennttry Road | Aeq4u5i p Cmoveennttry Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24205 | op-snap---monthly-publication-september-2025.pdf | 424 | 2025-09 | Car | Scania | HGV | white | Driving without Reasonable Consideration | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5194011 | -1.8008643 | ||
| 24223 | op-snap---monthly-publication-september-2025.pdf | 442 | 2025-09 | Car | Mitsubishi | Shogun | Silver | Driving without Due Care and Attention | None | Billingsley Road | Billingsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4696617 | -1.7890822 | ||
| 24239 | op-snap---monthly-publication-september-2025.pdf | 458 | 2025-09 | Car | Peugeot | Boxer | White | Driving without Due Care and Attention | None | Billesley Lane | Billesley Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4344402 | -1.8845368 | ||
| 24240 | op-snap---monthly-publication-september-2025.pdf | 459 | 2025-09 | Pedal Bike | Toyota | Landcruiser | Silver | Driving without Due Care and Attention | None | Lordswood Road | Lordswood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4591339 | -1.9601054 | ||
| 24244 | op-snap---monthly-publication-september-2025.pdf | 463 | 2025-09 | Car | Mg | ZS | Grey | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24297 | op-snap---monthly-publication-september-2025.pdf | 516 | 2025-09 | Car | Audi | A3.. | Grey | Driving without Due Care and Attention | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5113867 | -1.8337258 | ||
| 24319 | op-snap---monthly-publication-september-2025.pdf | 538 | 2025-09 | Car | Skoda | Octavia | White | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5194011 | -1.8008643 | ||
| 24320 | op-snap---monthly-publication-september-2025.pdf | 539 | 2025-09 | Car | Ford | Transit | White | Driving without Reasonable Consideration | None | Gravelly Hil | Gravelly Hil | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24331 | op-snap---monthly-publication-september-2025.pdf | 550 | 2025-09 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Bowstone Road | Bowstone Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24336 | op-snap---monthly-publication-september-2025.pdf | 555 | 2025-09 | Car | Audi | S3 | Black | Driving without Reasonable Consideration | None | Meadway | Meadway | Birmingham | Birmingham | Warning Letter | N/A | 52.4783348 | -1.8007708 | ||
| 24362 | op-snap---monthly-publication-september-2025.pdf | 581 | 2025-09 | Car | Mercedes-Benz | C220 | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 24367 | op-snap---monthly-publication-september-2025.pdf | 586 | 2025-09 | Car | Skoda | Octavia | Silver | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24370 | op-snap---monthly-publication-september-2025.pdf | 589 | 2025-09 | Car | Toyota | Estima | Red | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24371 | op-snap---monthly-publication-september-2025.pdf | 590 | 2025-09 | Car | Volkswagen | Polo | White | Driving without Due Care and Attention | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24389 | op-snap---monthly-publication-september-2025.pdf | 608 | 2025-09 | Car | Volkswagen | Golf GTI | Black | Driving without Due Care and Attention | None | Camp Hill | Camp Hill | Birmingham | Birmingham | Warning Letter | N/A | 52.4702894 | -1.8786299 | ||
| 24392 | op-snap---monthly-publication-september-2025.pdf | 611 | 2025-09 | Pedal Bike | Vauxhall | Vivaro | Black | Driving without Due Care and Attention | None | Lichfield Road towards Dartmouth Circus | Lichfield Road towards Dartmouth Circus | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24396 | op-snap---monthly-publication-september-2025.pdf | 615 | 2025-09 | Car | BMW | 5 series | Grey | Driving without Due Care and Attention | None | M6 Northbound, nr Jn4 | M6 Northbound, nr Jn4 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24420 | op-snap---monthly-publication-september-2025.pdf | 639 | 2025-09 | Car | Seat | Leon | White | Driving without Due Care and Attention | None | Grove Road | Grove Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4453942 | -1.8644982 | ||
| 24427 | op-snap---monthly-publication-september-2025.pdf | 646 | 2025-09 | Car | Nissan | Qasqai | Grey | Driving without Due Care and Attention | None | Queslett Road | Queslett Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5458699 | -1.9304484 | ||
| 24450 | op-snap---monthly-publication-september-2025.pdf | 669 | 2025-09 | Car | Porsche | Macan | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 24479 | op-snap---monthly-publication-september-2025.pdf | 698 | 2025-09 | Car | Volkswagen | Polo | Black | Driving without Due Care and Attention | None | Quinton Expressway | Quinton Expressway | Birmingham | Birmingham | Warning Letter | N/A | 52.4491086 | -2.0131915 | ||
| 24486 | op-snap---monthly-publication-september-2025.pdf | 705 | 2025-09 | Car | Kia | Optima | White | Driving without Due Care and Attention | No vehicle excise licence | A38(M) inbound to Birmingham | A38(M) inbound to Birmingham | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24498 | op-snap---monthly-publication-september-2025.pdf | 717 | 2025-09 | Pedal Bike | Ford | Mondeo | Silver | Driving without Due Care and Attention | None | Umberslade Road, Stirchley | Umberslade Road, Stirchley | Birmingham | Birmingham | Warning Letter | N/A | 52.4304526 | -1.9216716 | ||
| 24557 | op-snap---monthly-publication-september-2025.pdf | 776 | 2025-09 | Car | Toyota | Auris | Blue | Driving a vehicle wholly or partly on a footpath | None | Marsh Lane | Marsh Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.527277 | -1.8519677 | ||
| 24558 | op-snap---monthly-publication-september-2025.pdf | 777 | 2025-09 | Car | Citroen | C3 | Black | Driving a vehicle wholly or partly on a footpath | None | Marsh Lane | Marsh Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.527277 | -1.8519677 | ||
| 24570 | op-snap---monthly-publication-september-2025.pdf | 789 | 2025-09 | Car | Peugeot | 2008 | Black | Contravening a Red Traffic Light | None | Leafield Road | Leafield Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24593 | op-snap---monthly-publication-september-2025.pdf | 812 | 2025-09 | Car | Land Rover | Discovery | Black | Driving without Due Care and Attention | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 24599 | op-snap---monthly-publication-september-2025.pdf | 818 | 2025-09 | Car | Mg | ZS | Black | Contravening a Red Traffic Light | None | Great Charles | Great Charles | Birmingham | Birmingham | Warning Letter | N/A | 52.4821283 | -1.9037074 | ||
| 24624 | op-snap---monthly-publication-september-2025.pdf | 843 | 2025-09 | Pedal Bike | Volkswagen | Golf | Blue | Driving without Due Care and Attention | None | Slade Road | Slade Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5894461 | -1.8082962 | ||
| 24660 | op-snap---monthly-publication-september-2025.pdf | 879 | 2025-09 | Pedestrian | Mercedes-Benz | A-class | Silver | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 24662 | op-snap---monthly-publication-september-2025.pdf | 881 | 2025-09 | Pedal Bike | Volkswagen | Golf | Grey | Driving without Due Care and Attention | None | Formans Road | Formans Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4482024 | -1.8507493 | ||
| 24692 | op-snap---monthly-publication-september-2025.pdf | 911 | 2025-09 | Car | Vauxhall | Grandland | Black | Driving without Reasonable Consideration | None | Robin Hood Island | Robin Hood Island | Birmingham | Birmingham | Warning Letter | N/A | 52.4220705 | -1.8372335 | ||
| 24731 | op-snap---monthly-publication-september-2025.pdf | 950 | 2025-09 | Car | Mercedes-Benz | S class | Silver | Driving without Due Care and Attention | None | Tyburn House Island | Tyburn House Island | Birmingham | Birmingham | Warning Letter | N/A | 52.5194011 | -1.8008643 | ||
| 24770 | op-snap---monthly-publication-september-2025.pdf | 989 | 2025-09 | Car | BMW | 3 series | Black | Driving without Due Care and Attention | None | B4121 | B4121 | Birmingham | Birmingham | Warning Letter | N/A | 52.4448693 | -1.9772096 | ||
| 24773 | op-snap---monthly-publication-september-2025.pdf | 992 | 2025-09 | Car | Volkswagen | Polo | Blue | Driving without Due Care and Attention | None | A34 | A34 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24775 | op-snap---monthly-publication-september-2025.pdf | 994 | 2025-09 | Pedal Bike | BMW | IX3 | Black | Driving without Due Care and Attention | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5292752 | -1.7618805 | ||
| 24776 | op-snap---monthly-publication-september-2025.pdf | 995 | 2025-09 | Car | BMW | !20 | Black | Contravening a Red Traffic Light | None | A45 Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 24789 | op-snap---monthly-publication-september-2025.pdf | 1008 | 2025-09 | Other | Seat | MII | Red | Driving without Due Care and Attention | None | St Margarets Avenue | Street Margarets Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24809 | op-snap---monthly-publication-september-2025.pdf | 1028 | 2025-09 | Pedal Bike | Vauxhall | Corsa | Silver | Driving without Due Care and Attention | None | Alwold Road | Alwold Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4436471 | -1.9604594 | ||
| 24816 | op-snap---monthly-publication-september-2025.pdf | 1035 | 2025-09 | Car | Nissan | Qashqai | White | Contravening a Red Traffic Light | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 24827 | op-snap---monthly-publication-september-2025.pdf | 1046 | 2025-09 | Car | Dennis Bus | Driving without Due Care and Attention | None | Adams Hill Road | Adams Hill Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4355492 | -2.0043534 | ||||
| 24834 | op-snap---monthly-publication-september-2025.pdf | 1053 | 2025-09 | Car | BMW | 325D | Black | Driving without Due Care and Attention | None | Fordbrook Lane | Fordbrook Lane | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24848 | op-snap---monthly-publication-september-2025.pdf | 1067 | 2025-09 | Car | Ford | Fiesta | Silver | Contravening a Red Traffic Light | None | Eastfield Road | Eastfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.486104 | -1.8218907 | ||
| 24869 | op-snap---monthly-publication-september-2025.pdf | 1088 | 2025-09 | Car | Hyundai | Kona | Grey | Driving without Reasonable Consideration | None | A45 | A45 | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24877 | op-snap---monthly-publication-september-2025.pdf | 1096 | 2025-09 | Car | Vauxhall | Corsa | Orange | Motor vehicle fail to accord precedence at a pelic | an crossing None | Green Lane | Green Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4618966 | -1.9955421 | ||
| 24883 | op-snap---monthly-publication-september-2025.pdf | 1102 | 2025-09 | Other | Seat | Leon | Red | Driving without Due Care and Attention | None | Star City | Star City | Birmingham | Birmingham | Warning Letter | N/A | 52.5054363 | -1.8556273 | ||
| 24890 | op-snap---monthly-publication-september-2025.pdf | 1109 | 2025-09 | Car | Citroen | C5 | Blue | Contravening a Red Traffic Light | None | Bristol Road | Bristol Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4543565 | -1.9114004 | ||
| 24892 | op-snap---monthly-publication-september-2025.pdf | 1111 | 2025-09 | Car | Mercedes-Benz | C350 | Blue | Driving without Due Care and Attention | None | M6 / M5 Junction | M6 / M5 Junction | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 24916 | op-snap---monthly-publication-september-2025.pdf | 1135 | 2025-09 | Car | Vauxhall | Corsa | Grey | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 24950 | op-snap---monthly-publication-september-2025.pdf | 1169 | 2025-09 | Pedestrian | Yamaha | GPD125 | Grey | Use a vehicle / cycle on a road and contravene a l | ocal traffic order other Nthoanne parking | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 24951 | op-snap---monthly-publication-september-2025.pdf | 1170 | 2025-09 | Pedestrian | Yamaha | VMOTO | Silver | Use a vehicle / cycle on a road and contravene a l | ocal traffic order other Nthoanne parking | Bishopsgate Street | Bishopsgate Street | Birmingham | Birmingham | Warning Letter | N/A | 52.473986 | -1.9147087 | ||
| 24952 | op-snap---monthly-publication-september-2025.pdf | 1171 | 2025-09 | Pedal Bike | Skoda | Scala | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5359496 | -1.8324115 | ||
| 24955 | op-snap---monthly-publication-september-2025.pdf | 1174 | 2025-09 | Car | Ford | transit | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | coleshill street | Coleshill Street | Birmingham | Birmingham | Warning Letter | N/A | 52.5645717 | -1.8214603 | ||
| 24958 | op-snap---monthly-publication-september-2025.pdf | 1177 | 2025-09 | Pedestrian | Peugeot | 2008 GT | Grey | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 24959 | op-snap---monthly-publication-september-2025.pdf | 1178 | 2025-09 | Car | Mercedes-Benz | GLE | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 24960 | op-snap---monthly-publication-september-2025.pdf | 1179 | 2025-09 | Car | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 24961 | op-snap---monthly-publication-september-2025.pdf | 1180 | 2025-09 | Car | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 24962 | op-snap---monthly-publication-september-2025.pdf | 1181 | 2025-09 | Car | Rolls-Royce | Ghost | Purple | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 24963 | op-snap---monthly-publication-september-2025.pdf | 1182 | 2025-09 | Car | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle | / trailer outside of the GNroenateer London area | Moor Meadow Road | Moor Meadow Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5730351 | -1.811074 | ||
| 24964 | op-snap---monthly-publication-september-2025.pdf | 1183 | 2025-09 | Pedestrian | Volvo | Tipper | White | Driving without Due Care and Attention | None | Honiley ROad | Honiley ROad | Birmingham | Birmingham | Warning Letter | N/A | 52.4789688 | -1.7931848 |
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);