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'}
308 rows where month = "2025-05" and reporter_transport_mode = "Pedestrian" 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 21
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 68
- Cause vehicle to be left in a dangerous position 63
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 31
- Driving without Due Care and Attention 29
- Contravening a Red Traffic Light 25
- Misc - Non Traffic Offences 17
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 14
- Stop a vehicle on pedestrian crossing 13
- Stop a vehicle within pelican pedestrian crossing limits 10
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 8
- Using a Mobile Phone Whilst Driving 7
- Driving a vehicle wholly or partly on a footpath 5
- No Insurance 5
- Fail to display front VRM plate 3
- Dangerous Driving 2
- Motor vehicle fail to comply with solid white line road markings 2
- No Seat Belt 2
- Fail to Conform to Cycle Lane 1
- Keeping a vehicle with registration marks obscured 1
- Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
- Waiting on a road in a prohibited area 1
council_area 12
- Birmingham 205
- Walsall 19
- Coventry 16
- Sutton Coldfield 16
- Dudley 14
- Sandwell 14
- Solihull 10
- Out of Force Area 5
- Banirdm Tinhgeh Qaem Hospital 4
- Ds Rutotoand Coldfield 2
- Wolverhampton 2
- Askoelsihpuellare Drive 1
disposal 6
- NFA 120
- Warning Letter 101
- Fixed Penalty 51
- Education 28
- Court 4
- Other Action Taken 4
reporter_transport_mode 1
- Pedestrian · 308 ✖
month 1
- 2025-05 · 308 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18641 | op-snap---monthly-publication-may-2025.pdf | 3 | 2025-05 | Pedestrian | Citroen | c5 | Silver | No Seat Belt | None | Hannah Road | Hannah Road | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 18642 | op-snap---monthly-publication-may-2025.pdf | 4 | 2025-05 | Pedestrian | Citroen | C5 | Silver | Using a Mobile Phone Whilst Driving | None | Hannah Road | Hannah Road | Wolverhampton | Wolverhampton | NFA | Not in Public Interest | ||||
| 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 | ||
| 18653 | op-snap---monthly-publication-may-2025.pdf | 15 | 2025-05 | Pedestrian | Volvo | XC60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clent Road | Clent Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4725947 | -1.9952306 | ||
| 18655 | op-snap---monthly-publication-may-2025.pdf | 17 | 2025-05 | Pedestrian | Mercedes-Benz | C220 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road | Castle Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.5258312 | -2.0768625 | ||
| 18656 | op-snap---monthly-publication-may-2025.pdf | 18 | 2025-05 | Pedestrian | Kia | Sportage | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheatley Road | Wheatley Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4705903 | -1.9933164 | ||
| 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 | ||
| 18665 | op-snap---monthly-publication-may-2025.pdf | 27 | 2025-05 | Pedestrian | 720s | Orange | Fail to display front VRM plate | None | Anchorage Road | Anchorage Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 Days NIP | 52.5699381 | -1.8249539 | |||
| 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 | ||
| 18706 | op-snap---monthly-publication-may-2025.pdf | 68 | 2025-05 | Pedestrian | Nissan | Qashqai | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Field Lane | Field Lane | Dudley | Dudley | NFA | Not in Public Interest | 52.4469063 | -2.1430048 | ||
| 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 | ||
| 18745 | op-snap---monthly-publication-may-2025.pdf | 107 | 2025-05 | Pedestrian | BMW | 1 Series | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Turners Lane | Turners Lane | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4721372 | -2.1243522 | ||
| 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 | ||
| 18747 | op-snap---monthly-publication-may-2025.pdf | 109 | 2025-05 | Pedestrian | Volvo | S60 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Trossachs Road | Trossachs Road | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.412542 | -1.5757615 | ||
| 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 | ||
| 18777 | op-snap---monthly-publication-may-2025.pdf | 139 | 2025-05 | Pedestrian | Land Rover | SPORT | Black | Stop a vehicle within pelican pedestrian crossing limits | No Insurance | EARLSDON STREET | Earlsdon Street | Coventry | Coventry | Education | N/A | 52.3988977 | -1.5323674 | ||
| 18799 | op-snap---monthly-publication-may-2025.pdf | 161 | 2025-05 | Pedestrian | Iveco | White | Use a motor vehicle / trailer in a condition likely to cause danger of injury | None | Birmingham Road Aldridge | Birmingham Road Aldridge | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5766298 | -1.9685663 | |||
| 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 | |||
| 18802 | op-snap---monthly-publication-may-2025.pdf | 164 | 2025-05 | Pedestrian | Lexus | 300 H | White | Stop a vehicle within pelican pedestrian crossing limits | None | Stoney Stanton Road | Stoney Stanton Road | Coventry | Coventry | Fixed Penalty | N/A | 52.4221152 | -1.4959475 | ||
| 18817 | op-snap---monthly-publication-may-2025.pdf | 179 | 2025-05 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hey Lane | Hey Lane | Solihull | Solihull | NFA | No VRM | ||||
| 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 | ||||
| 18832 | op-snap---monthly-publication-may-2025.pdf | 194 | 2025-05 | Pedestrian | Peugeot | BVoxer | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broadway | Broadway | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3999339 | -1.5249817 | ||
| 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 | ||
| 18859 | op-snap---monthly-publication-may-2025.pdf | 221 | 2025-05 | Pedestrian | Toyota | Prius | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Acces Road between Metchley Lane | Acces Road between Metchley Lane | Banirdm tinhgeh QaEm Hospital | Banirdm Tinhgeh Qaem Hospital | NFA | Outside of 14 Days NIP | ||||
| 18860 | op-snap---monthly-publication-may-2025.pdf | 222 | 2025-05 | Pedestrian | Peugeot | 108 | Red | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Acces Road between Metchley Lane | Acces Road between Metchley Lane | Banirdm tinhgeh QaEm Hospital | Banirdm Tinhgeh Qaem Hospital | Other Action Taken | nN/A | ||||
| 18863 | op-snap---monthly-publication-may-2025.pdf | 225 | 2025-05 | Pedestrian | Renault | U/K | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Acces Road between Metchley Lane | Acces Road between Metchley Lane | Banirdm tinhgeh QaEm Hospital | Banirdm Tinhgeh Qaem Hospital | Other Action Taken | nN/A | ||||
| 18864 | op-snap---monthly-publication-may-2025.pdf | 226 | 2025-05 | Pedestrian | U/K | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen | Nt one | Acces Road between Metchley Lane | Acces Road between Metchley Lane | Banirdm tinhgeh QaEm Hospital | Banirdm Tinhgeh Qaem Hospital | Other Action Taken | nN/A | |||||
| 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 | ||
| 18883 | op-snap---monthly-publication-may-2025.pdf | 245 | 2025-05 | Pedestrian | Ford | Transit | Blue | No Seat Belt | None | A$148 Walsall | A$148 Walsall | Walsall | Walsall | Warning Letter | N/A | 52.629207 | -1.9300274 | ||
| 18884 | op-snap---monthly-publication-may-2025.pdf | 246 | 2025-05 | Pedestrian | Jaguar | XF... | Grey | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18887 | op-snap---monthly-publication-may-2025.pdf | 249 | 2025-05 | Pedestrian | BMW | 535 D | Silver | Contravening a Red Traffic Light | None | A4148 Walsall | Walsall | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5841365 | -1.9852679 | ||
| 18889 | op-snap---monthly-publication-may-2025.pdf | 251 | 2025-05 | Pedestrian | Audi | A5 | Grey | Contravening a Red Traffic Light | None | A4148 | A4148 | Walsall | Walsall | NFA | Outside of 14 Days NIP | ||||
| 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 | ||
| 18940 | op-snap---monthly-publication-may-2025.pdf | 302 | 2025-05 | Pedestrian | Mercedes-Benz | E class | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Halford Lane | Halford Lane | Coventry | Coventry | Education | N/A | 52.4398231 | -1.526811 | ||
| 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 | |||
| 18988 | op-snap---monthly-publication-may-2025.pdf | 350 | 2025-05 | Pedestrian | Seat | Leon | Silver | Driving without Due Care and Attention | None | Worcester | Worcester | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3101165 | -2.0442678 | ||
| 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 | ||
| 19032 | op-snap---monthly-publication-may-2025.pdf | 394 | 2025-05 | Pedestrian | Land Rover | Range Rover | Black | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19033 | op-snap---monthly-publication-may-2025.pdf | 395 | 2025-05 | Pedestrian | Ford | Puma | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19035 | op-snap---monthly-publication-may-2025.pdf | 397 | 2025-05 | Pedestrian | Vauxhall | Corsa | Red | Contravening a Red Traffic Light | None | Lichfield Street | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19039 | op-snap---monthly-publication-may-2025.pdf | 401 | 2025-05 | Pedestrian | Toyota | MPV | White | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||
| 19040 | op-snap---monthly-publication-may-2025.pdf | 402 | 2025-05 | Pedestrian | Grey | Contravening a Red Traffic Light | None | LICHFIELD STREET | Lichfield Street | Walsall | Walsall | NFA | Outside of 14 Days NIP | 52.5882772 | -1.9761264 | ||||
| 19041 | op-snap---monthly-publication-may-2025.pdf | 403 | 2025-05 | Pedestrian | Ford | various makes | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rockingham Gardens | Rockingham Gardens | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.5690681 | -1.8271174 | ||
| 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 | ||
| 19093 | op-snap---monthly-publication-may-2025.pdf | 455 | 2025-05 | Pedestrian | Skoda | Fabia | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 19095 | op-snap---monthly-publication-may-2025.pdf | 457 | 2025-05 | Pedestrian | Renault | Clio | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 19096 | op-snap---monthly-publication-may-2025.pdf | 458 | 2025-05 | Pedestrian | Contravening a Red Traffic Light | None | PEDMORE ROAD | Pedmore Road | Dudley | Dudley | NFA | No VRM | 52.4897451 | -2.1069141 | |||||
| 19105 | op-snap---monthly-publication-may-2025.pdf | 467 | 2025-05 | Pedestrian | Peugeot | 308 | Silver | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Longford Bridge Road | Longford Bridge Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.4524222 | -1.485562 | ||
| 19116 | op-snap---monthly-publication-may-2025.pdf | 478 | 2025-05 | Pedestrian | Volkswagen | polo | White | Driving without Due Care and Attention | None | Robin Hood Road | Robin Hood Road | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4781594 | -2.1049925 | ||
| 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 | ||
| 19162 | op-snap---monthly-publication-may-2025.pdf | 524 | 2025-05 | Pedestrian | Fiat | 500 | Blue | Cause vehicle to be left in a dangerous position | None | GAYFIELD AVENUE | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 19164 | op-snap---monthly-publication-may-2025.pdf | 526 | 2025-05 | Pedestrian | Toyota | COROLLA | Silver | Cause vehicle to be left in a dangerous position | None | GAYFIELD AVENUE | Gayfield Avenue | Dudley | Dudley | Education | N/A | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 19179 | op-snap---monthly-publication-may-2025.pdf | 541 | 2025-05 | Pedestrian | Vauxhall | Zafira | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Woodland Street | Woodland Street | Sandwell | Sandwell | Other Action Taken | nN/A | ||||
| 19189 | op-snap---monthly-publication-may-2025.pdf | 551 | 2025-05 | Pedestrian | Mercedes-Benz | Sprinter | White | Using a Mobile Phone Whilst Driving | None | Bosty Lane | Bosty Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5948329 | -1.927787 | ||
| 19190 | op-snap---monthly-publication-may-2025.pdf | 552 | 2025-05 | Pedestrian | Ford | Focus | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 |
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);