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'}
205 rows where council_area = "Birmingham", month = "2025-05" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, nfa_rationale
vehicle_make 27
offence 16
- Cause vehicle to be left in a dangerous position 48
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 46
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 22
- Driving without Due Care and Attention 19
- Misc - Non Traffic Offences 15
- Stop a vehicle on pedestrian crossing 11
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 9
- Stop a vehicle within pelican pedestrian crossing limits 7
- Contravening a Red Traffic Light 6
- No Insurance 5
- Using a Mobile Phone Whilst Driving 5
- Driving a vehicle wholly or partly on a footpath 4
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 4
- Fail to display front VRM plate 2
- Dangerous Driving 1
- Fail to Conform to Cycle Lane 1
disposal 5
- NFA 72
- Warning Letter 72
- Fixed Penalty 38
- Education 19
- Court 4
reporter_transport_mode 1
- Pedestrian · 205 ✖
month 1
- 2025-05 · 205 ✖
council_area 1
- Birmingham · 205 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18645 | op-snap---monthly-publication-may-2025.pdf | 7 | 2025-05 | Pedestrian | Audi | A5.. | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 18661 | op-snap---monthly-publication-may-2025.pdf | 23 | 2025-05 | Pedestrian | Vauxhall | Combo | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Kingstanding Road | Kingstanding Road | Birmingham | Birmingham | Education | N/A | 52.5521118 | -1.8845138 | ||
| 18694 | op-snap---monthly-publication-may-2025.pdf | 56 | 2025-05 | Pedestrian | Hyundai | I30 | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 18696 | op-snap---monthly-publication-may-2025.pdf | 58 | 2025-05 | Pedestrian | Audi | A6.. | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | No Offence | 52.4203897 | -1.8338574 | ||
| 18697 | op-snap---monthly-publication-may-2025.pdf | 59 | 2025-05 | Pedestrian | BMW | M3 | White | Driving without Due Care and Attention | None | Miller Street | Miller Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4933043 | -1.8927828 | ||
| 18727 | op-snap---monthly-publication-may-2025.pdf | 89 | 2025-05 | Pedestrian | Ferrari | Red | Fail to display front VRM plate | None | Yardley Wood Road | Yardley Wood Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4103191 | -1.8670224 | |||
| 18733 | op-snap---monthly-publication-may-2025.pdf | 95 | 2025-05 | Pedestrian | Renault | CAPTUR | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | PETERSFIELD ROAD | Petersfield Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4307 | -1.8494663 | ||
| 18737 | op-snap---monthly-publication-may-2025.pdf | 99 | 2025-05 | Pedestrian | Hyundai | Tucson | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Windsor Street South | Windsor Street South | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4850068 | -1.8801252 | ||
| 18738 | op-snap---monthly-publication-may-2025.pdf | 100 | 2025-05 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4878246 | -1.9421047 | ||
| 18739 | op-snap---monthly-publication-may-2025.pdf | 101 | 2025-05 | Pedestrian | Toyota | YARIS | Black | Contravening a Red Traffic Light | None | WARSTONE LANE | Warstone Lane | Birmingham | Birmingham | Education | N/A | 52.4870496 | -1.912873 | ||
| 18740 | op-snap---monthly-publication-may-2025.pdf | 102 | 2025-05 | Pedestrian | BMW | 218M | White | Contravening a Red Traffic Light | None | WARSTONE LANE | Warstone Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4870496 | -1.912873 | ||
| 18741 | op-snap---monthly-publication-may-2025.pdf | 103 | 2025-05 | Pedestrian | Mercedes-Benz | BENZ | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | NEWHALL HILL | Newhall Hill | Birmingham | Birmingham | Education | N/A | 52.4832761 | -1.9110049 | ||
| 18743 | op-snap---monthly-publication-may-2025.pdf | 105 | 2025-05 | Pedestrian | Toyota | Prius | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863384 | -1.9123011 | ||
| 18744 | op-snap---monthly-publication-may-2025.pdf | 106 | 2025-05 | Pedestrian | Mercedes-Benz | CLA | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863384 | -1.9123011 | ||
| 18746 | op-snap---monthly-publication-may-2025.pdf | 108 | 2025-05 | Pedestrian | Vauxhall | Zafira | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Regent Place | Regent Place | Birmingham | Birmingham | Court | N/A | 52.4860376 | -1.9095854 | ||
| 18776 | op-snap---monthly-publication-may-2025.pdf | 138 | 2025-05 | Pedestrian | Audi | a3 | Red | Using a Mobile Phone Whilst Driving | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 18800 | op-snap---monthly-publication-may-2025.pdf | 162 | 2025-05 | Pedestrian | London Taxi | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Heath Road | Heath Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4220874 | -1.9409615 | |||
| 18827 | op-snap---monthly-publication-may-2025.pdf | 189 | 2025-05 | Pedestrian | Yamaha | GPD125 | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Bishopgate Street | Bishopgate Street | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 18833 | op-snap---monthly-publication-may-2025.pdf | 195 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4236341 | -1.8787502 | ||
| 18841 | op-snap---monthly-publication-may-2025.pdf | 203 | 2025-05 | Pedestrian | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | St Marys Road | Street Marys Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 18851 | op-snap---monthly-publication-may-2025.pdf | 213 | 2025-05 | Pedestrian | BMW | 320I | Grey | Cause vehicle to be left in a dangerous position | None | High St Kings Heath | High Street Kings Heath | Birmingham | Birmingham | Education | N/A | 52.4375456 | -1.8926849 | ||
| 18857 | op-snap---monthly-publication-may-2025.pdf | 219 | 2025-05 | Pedestrian | Nissan | Qashqai | Black | Cause vehicle to be left in a dangerous position | None | Laxey Road | Laxey Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4830314 | -1.9491993 | ||
| 18866 | op-snap---monthly-publication-may-2025.pdf | 228 | 2025-05 | Pedestrian | Seat | Ibiza | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | NFA | No Offence | 52.4578511 | -1.9734988 | ||
| 18869 | op-snap---monthly-publication-may-2025.pdf | 231 | 2025-05 | Pedestrian | Ford | Transit | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lightswood Hill | Lightswood Hill | Birmingham | Birmingham | NFA | No Offence | ||||
| 18876 | op-snap---monthly-publication-may-2025.pdf | 238 | 2025-05 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Islington Row Middleway | Islington Row Middleway | Birmingham | Birmingham | Warning Letter | N/A | 52.4720132 | -1.9142946 | ||
| 18879 | op-snap---monthly-publication-may-2025.pdf | 241 | 2025-05 | Pedestrian | Toyota | Auris | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Sherborne St | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 18910 | op-snap---monthly-publication-may-2025.pdf | 272 | 2025-05 | Pedestrian | Volkswagen | Golf | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.471632 | -1.9456776 | ||
| 18948 | op-snap---monthly-publication-may-2025.pdf | 310 | 2025-05 | Pedestrian | Toyota | PROACE | White | Cause vehicle to be left in a dangerous position | None | BUNBURY ROAD | Bunbury Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4142089 | -1.9587147 | ||
| 18960 | op-snap---monthly-publication-may-2025.pdf | 322 | 2025-05 | Pedestrian | Volkswagen | Golf | Grey | Cause vehicle to be left in a dangerous position | None | Whittington Oval | Whittington Oval | Birmingham | Birmingham | Education | N/A | 52.4800782 | -1.7942034 | ||
| 18962 | op-snap---monthly-publication-may-2025.pdf | 324 | 2025-05 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 18964 | op-snap---monthly-publication-may-2025.pdf | 326 | 2025-05 | Pedestrian | Ford | Ecosport | Blue | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.4470686 | -1.8880749 | ||
| 18970 | op-snap---monthly-publication-may-2025.pdf | 332 | 2025-05 | Pedestrian | Vauxhall | Mokka | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | City Road | City Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4763176 | -1.9584897 | ||
| 18986 | op-snap---monthly-publication-may-2025.pdf | 348 | 2025-05 | Pedestrian | BMW | Silver | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | NFA | No VRM | 52.4762433 | -1.9176665 | |||
| 18996 | op-snap---monthly-publication-may-2025.pdf | 358 | 2025-05 | Pedestrian | Mercedes-Benz | CLA 180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tennal Road | Tennal Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4578511 | -1.9734988 | ||
| 18997 | op-snap---monthly-publication-may-2025.pdf | 359 | 2025-05 | Pedestrian | Vauxhall | Astra | Black | Cause vehicle to be left in a dangerous position | No Insurance | Ashdale Drive, Hollywood | Ashdale Drive, Hollywood | Birmingham | Birmingham | Court | N/A | ||||
| 19009 | op-snap---monthly-publication-may-2025.pdf | 371 | 2025-05 | Pedestrian | Mercedes-Benz | c200 | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Metchley Lane | Metchley Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4552055 | -1.9461279 | ||
| 19045 | op-snap---monthly-publication-may-2025.pdf | 407 | 2025-05 | Pedestrian | Misc - Non Traffic Offences | None | WILLOW AVENUE | Willow Avenue | Birmingham | Birmingham | NFA | No Offence | 52.4792236 | -1.9652858 | |||||
| 19046 | op-snap---monthly-publication-may-2025.pdf | 408 | 2025-05 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Battery Way | Battery Way | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4493988 | -1.8476406 | ||
| 19086 | op-snap---monthly-publication-may-2025.pdf | 448 | 2025-05 | Pedestrian | Mitsubishi | Fuso | White | Misc - Non Traffic Offences | None | Addison Road | Addison Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4313296 | -1.8882575 | ||
| 19091 | op-snap---monthly-publication-may-2025.pdf | 453 | 2025-05 | Pedestrian | Mini | COOPER | White | Driving without Due Care and Attention | None | GIBBONS ROAD | Gibbons Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5917726 | -1.8257003 | ||
| 19130 | op-snap---monthly-publication-may-2025.pdf | 492 | 2025-05 | Pedestrian | BMW | M4 | White | Driving without Due Care and Attention | None | Valentine Road | Valentine Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4381959 | -1.8907391 | ||
| 19132 | op-snap---monthly-publication-may-2025.pdf | 494 | 2025-05 | Pedestrian | Vauxhall | Astra | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Old Oscott Hill | Old Oscott Hill | Birmingham | Birmingham | Education | N/A | 52.5483174 | -1.8891127 | ||
| 19134 | op-snap---monthly-publication-may-2025.pdf | 496 | 2025-05 | Pedestrian | Audi | A3 | Grey | Stop a vehicle on pedestrian crossing | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 19136 | op-snap---monthly-publication-may-2025.pdf | 498 | 2025-05 | Pedestrian | Audi | A4 | White | Stop a vehicle on pedestrian crossing | No vehicle excise lice | nOceLTON BOULEVARD | n Oce LTON BOULEVARD | Birmingham | Birmingham | Education | N/A | ||||
| 19137 | op-snap---monthly-publication-may-2025.pdf | 499 | 2025-05 | Pedestrian | Toyota | COROLLA | Black | Stop a vehicle on pedestrian crossing | none | SHAFTMOOR LANE | Shaftmoor Lane | Birmingham | Birmingham | Education | N/A | 52.4418944 | -1.8407335 | ||
| 19138 | op-snap---monthly-publication-may-2025.pdf | 500 | 2025-05 | Pedestrian | Volkswagen | TOURAN | White | Stop a vehicle on pedestrian crossing | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Education | N/A | 52.443439 | -1.8180486 | ||
| 19139 | op-snap---monthly-publication-may-2025.pdf | 501 | 2025-05 | Pedestrian | Toyota | RAV 4 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | OLTON BOULEVARD | Olton Boulevard | Birmingham | Birmingham | Fixed Penalty | N/A | 52.443439 | -1.8180486 | ||
| 19145 | op-snap---monthly-publication-may-2025.pdf | 507 | 2025-05 | Pedestrian | Mercedes-Benz | Vito | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodville Road | Woodville Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4616763 | -1.9653016 | ||
| 19148 | op-snap---monthly-publication-may-2025.pdf | 510 | 2025-05 | Pedestrian | Toyota | YARIS | Grey | Cause vehicle to be left in a dangerous position | None | WOODVILLE ROAD | Woodville Road | Birmingham | Birmingham | Education | N/A | 52.4616763 | -1.9653016 | ||
| 19155 | op-snap---monthly-publication-may-2025.pdf | 517 | 2025-05 | Pedestrian | Suzuki | Splash | Grey | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4668753 | -1.8996143 | ||
| 19156 | op-snap---monthly-publication-may-2025.pdf | 518 | 2025-05 | Pedestrian | Nissan | Juke | Grey | Contravening a Red Traffic Light | None | Belgrave Middleway | Belgrave Middleway | Birmingham | Birmingham | Education | N/A | 52.4668753 | -1.8996143 | ||
| 19158 | op-snap---monthly-publication-may-2025.pdf | 520 | 2025-05 | Pedestrian | Ford | Fiesta | Red | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Carver Street | Carver Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4857687 | -1.915613 | ||
| 19159 | op-snap---monthly-publication-may-2025.pdf | 521 | 2025-05 | Pedestrian | Ford | Galaxy | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Regent Parade | Regent Parade | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4863585 | -1.9094435 | ||
| 19161 | op-snap---monthly-publication-may-2025.pdf | 523 | 2025-05 | Pedestrian | Nissan | Qashqai | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19163 | op-snap---monthly-publication-may-2025.pdf | 525 | 2025-05 | Pedestrian | Volkswagen | T-Roc | Grey | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4027335 | -1.876125 | ||
| 19165 | op-snap---monthly-publication-may-2025.pdf | 527 | 2025-05 | Pedestrian | Peugeot | 108 | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19167 | op-snap---monthly-publication-may-2025.pdf | 529 | 2025-05 | Pedestrian | Ford | S Max | White | Stop a vehicle within pelican pedestrian crossing limits | None | Allens Croft Road | Allens Croft Road | Birmingham | Birmingham | Education | N/A | 52.4242527 | -1.910803 | ||
| 19168 | op-snap---monthly-publication-may-2025.pdf | 530 | 2025-05 | Pedestrian | Toyota | Prius | White | Stop a vehicle within pelican pedestrian crossing limits | None | Allens Croft Road | Allens Croft Road | Birmingham | Birmingham | Education | N/A | 52.4242527 | -1.910803 | ||
| 19171 | op-snap---monthly-publication-may-2025.pdf | 533 | 2025-05 | Pedestrian | Vauxhall | CORSA | Silver | Fail to Conform to Cycle Lane | None | CANN HILL ROAD | Cann Hill Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 19174 | op-snap---monthly-publication-may-2025.pdf | 536 | 2025-05 | Pedestrian | Ford | Fiesta | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 19198 | op-snap---monthly-publication-may-2025.pdf | 560 | 2025-05 | Pedestrian | Dangerous Driving | none | Commonside road | Commonside road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||||
| 19202 | op-snap---monthly-publication-may-2025.pdf | 564 | 2025-05 | Pedestrian | Audi | A3 | Blue | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Education | N/A | 52.4027335 | -1.876125 | ||
| 19204 | op-snap---monthly-publication-may-2025.pdf | 566 | 2025-05 | Pedestrian | Ford | Focus | Grey | Cause vehicle to be left in a dangerous position | None | Ashdale Road | Ashdale Road | Birmingham | Birmingham | Education | N/A | ||||
| 19205 | op-snap---monthly-publication-may-2025.pdf | 567 | 2025-05 | Pedestrian | Volkswagen | Troc | Grey | Cause vehicle to be left in a dangerous position | None | Ashdale Road | Ashdale Road | Birmingham | Birmingham | Court | N/A | ||||
| 19217 | op-snap---monthly-publication-may-2025.pdf | 579 | 2025-05 | Pedestrian | Toyota | Corolla | White | Stop a vehicle on pedestrian crossing | None | Bordsley Green | Bordsley Green | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19218 | op-snap---monthly-publication-may-2025.pdf | 580 | 2025-05 | Pedestrian | Ford | Ecosport | Black | Using a Mobile Phone Whilst Driving | None | Northfield Road | Northfield Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4167654 | -1.9411244 | ||
| 19250 | op-snap---monthly-publication-may-2025.pdf | 612 | 2025-05 | Pedestrian | Ford | Transit | White | Driving without Due Care and Attention | None | Old Walsall Road/ Spouthouse Lane | Old Walsall Road/ Spouthouse Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5294399 | -1.9282714 | ||
| 19279 | op-snap---monthly-publication-may-2025.pdf | 641 | 2025-05 | Pedestrian | Hyundai | I10 | Blue | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Education | N/A | 52.4027335 | -1.876125 | ||
| 19281 | op-snap---monthly-publication-may-2025.pdf | 643 | 2025-05 | Pedestrian | Volkswagen | T-Roc | Grey | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Court | N/A | 52.4027335 | -1.876125 | ||
| 19322 | op-snap---monthly-publication-may-2025.pdf | 684 | 2025-05 | Pedestrian | Mini | Cooper | Red | Misc - Non Traffic Offences | None | Lichfield Road | Lichfield Road | Birmingham | Birmingham | NFA | No Offence | 52.5012458 | -1.8780942 | ||
| 19363 | op-snap---monthly-publication-may-2025.pdf | 725 | 2025-05 | Pedestrian | Mercedes-Benz | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4762433 | -1.9176665 | |||
| 19365 | op-snap---monthly-publication-may-2025.pdf | 727 | 2025-05 | Pedestrian | Audi | A3 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Francis Road | Francis Road | Birmingham | Birmingham | Education | N/A | 52.4798453 | -1.8147402 | ||
| 19451 | op-snap---monthly-publication-may-2025.pdf | 813 | 2025-05 | Pedestrian | BMW | Grey | Misc - Non Traffic Offences | None | Avenue Road | Avenue Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4941712 | -1.8795158 | |||
| 19462 | op-snap---monthly-publication-may-2025.pdf | 824 | 2025-05 | Pedestrian | BMW | 7 Series | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Regent St | Regent Street | Birmingham | Birmingham | Education | N/A | 52.4291721 | -1.9250565 | ||
| 19523 | op-snap---monthly-publication-may-2025.pdf | 885 | 2025-05 | Pedestrian | Ford | Focus | Black | Using a Mobile Phone Whilst Driving | None | Woodbridge Road | Woodbridge Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4482076 | -1.8864335 | ||
| 19556 | op-snap---monthly-publication-may-2025.pdf | 918 | 2025-05 | Pedestrian | Land Rover | Velar | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Vittoria Street | Vittoria Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4851181 | -1.9106263 | ||
| 19624 | op-snap---monthly-publication-may-2025.pdf | 986 | 2025-05 | Pedestrian | Renault | Megane | Blue | Driving without Due Care and Attention | None | A45 | A45 | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19647 | op-snap---monthly-publication-may-2025.pdf | 1009 | 2025-05 | Pedestrian | BMW | ? | Blue | Driving without Due Care and Attention | None | REDDINGS LANE | Reddings Lane | Birmingham | Birmingham | NFA | No VRM | 52.4506039 | -1.8463952 | ||
| 19652 | op-snap---monthly-publication-may-2025.pdf | 1014 | 2025-05 | Pedestrian | Audi | A4 | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4520441 | -1.8787544 | ||
| 19664 | op-snap---monthly-publication-may-2025.pdf | 1026 | 2025-05 | Pedestrian | Toyota | Yaris | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Alcester Road South | Alcester Road South | Birmingham | Birmingham | NFA | No Offence | 52.4170522 | -1.8906187 | ||
| 19691 | op-snap---monthly-publication-may-2025.pdf | 1053 | 2025-05 | Pedestrian | BMW | 3 Series | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Salsbury Road | Salsbury Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19693 | op-snap---monthly-publication-may-2025.pdf | 1055 | 2025-05 | Pedestrian | Volkswagen | Golf | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Salisbury Road | Salisbury Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4943878 | -1.8504211 | ||
| 19694 | op-snap---monthly-publication-may-2025.pdf | 1056 | 2025-05 | Pedestrian | Volkswagen | Troc | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pershore Road South | Pershore Road South | Birmingham | Birmingham | Warning Letter | N/A | 52.4150779 | -1.930901 | ||
| 19695 | op-snap---monthly-publication-may-2025.pdf | 1057 | 2025-05 | Pedestrian | Nissan | Navara | Silver | Misc - Non Traffic Offences | None | Heeley Road | Heeley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4401847 | -1.9331572 | ||
| 19698 | op-snap---monthly-publication-may-2025.pdf | 1060 | 2025-05 | Pedestrian | Audi | A3 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Private Land | Private Land | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 19712 | op-snap---monthly-publication-may-2025.pdf | 1074 | 2025-05 | Pedestrian | Toyota | Yaris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bagnall Road | Bagnall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4611092 | -1.8825745 | ||
| 19713 | op-snap---monthly-publication-may-2025.pdf | 1075 | 2025-05 | Pedestrian | Ford | Focus | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Manor Road | Manor Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5619179 | -1.8297455 | ||
| 19720 | op-snap---monthly-publication-may-2025.pdf | 1082 | 2025-05 | Pedestrian | Peugeot | Expert | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Formans Road | Formans Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4482024 | -1.8507493 | ||
| 19743 | op-snap---monthly-publication-may-2025.pdf | 1105 | 2025-05 | Pedestrian | Mercedes-Benz | C class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Agnes Road | Street Agnes Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19749 | op-snap---monthly-publication-may-2025.pdf | 1111 | 2025-05 | Pedestrian | Mercedes-Benz | Van | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barn lane | Barn lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4307492 | -1.8828708 | ||
| 19753 | op-snap---monthly-publication-may-2025.pdf | 1115 | 2025-05 | Pedestrian | BMW | 325i | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | South Road | South Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4972567 | -1.9214327 | ||
| 19775 | op-snap---monthly-publication-may-2025.pdf | 1137 | 2025-05 | Pedestrian | Vauxhall | Insignia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodgreen road | Woodgreen road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4637236 | -1.9981359 | ||
| 19776 | op-snap---monthly-publication-may-2025.pdf | 1138 | 2025-05 | Pedestrian | Peugeot | Boxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Crosswells Road | Crosswells Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 19778 | op-snap---monthly-publication-may-2025.pdf | 1140 | 2025-05 | Pedestrian | Honda | Civic | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lozells Street | Lozells Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.5007454 | -1.9067107 | ||
| 19796 | op-snap---monthly-publication-may-2025.pdf | 1158 | 2025-05 | Pedestrian | Ford | ST | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chiswell Road | Chiswell Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4878246 | -1.9421047 | ||
| 19797 | op-snap---monthly-publication-may-2025.pdf | 1159 | 2025-05 | Pedestrian | BMW | 420.. | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 19798 | op-snap---monthly-publication-may-2025.pdf | 1160 | 2025-05 | Pedestrian | Kia | Rio | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Winton Street | Winton Street | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 19799 | op-snap---monthly-publication-may-2025.pdf | 1161 | 2025-05 | Pedestrian | Dacia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotton Park Road | Rotton Park Road | Birmingham | Birmingham | NFA | No Offence | 52.4851072 | -1.9468115 | |||
| 19824 | op-snap---monthly-publication-may-2025.pdf | 1186 | 2025-05 | Pedestrian | Volkswagen | Transporter | Blue | Stop a vehicle on pedestrian crossing | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 19831 | op-snap---monthly-publication-may-2025.pdf | 1193 | 2025-05 | Pedestrian | Alfa Romeo | 220 | white | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road at Baker Street | Stratford Road at Baker Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4203897 | -1.8338574 |
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);