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'}
473 rows where month = "2025-06" 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 17
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 218
- Cause vehicle to be left in a dangerous position 94
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 28
- Driving without Due Care and Attention 27
- Stop a vehicle within pelican pedestrian crossing limits 22
- Contravening a Red Traffic Light 15
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 14
- Misc - Non Traffic Offences 13
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 13
- Using a Mobile Phone Whilst Driving 11
- Stop a vehicle on pedestrian crossing 8
- Driving without Reasonable Consideration 2
- Motor vehicle fail to accord precedence at a pelican crossing 2
- No Seat Belt 2
- VRM fails to conform to Regulations 2
- Driving a vehicle wholly or partly on a footpath 1
- Keeping a vehicle with registration marks obscured 1
council_area 13
- Birmingham 292
- Sandwell 41
- Wolverhampton 34
- Sutton Coldfield 23
- Solihull 20
- Walsall 18
- Coventry 15
- Dudley 12
- Out of Force Area 9
- Metropolitan Borough 5
- Mcoy)Ventry 2
- Coe Ulot Coaf Tfioonrce Area 1
- Halesowen 1
disposal 7
- NFA 250
- Warning Letter 139
- Fixed Penalty 53
- Education 28
- Court 1
- Other Action Taken 1
- RTC - Actioned 1
reporter_transport_mode 1
- Pedestrian · 473 ✖
month 1
- 2025-06 · 473 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14071 | op-snap---monthly-publication-june-2025.pdf | 0 | 2025-06 | Pedestrian | Dodge | Blue | Cause vehicle to be left in a dangerous position | None | Heath Green Road | Heath Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4873353 | -1.9407986 | |||
| 14072 | op-snap---monthly-publication-june-2025.pdf | 1 | 2025-06 | Pedestrian | Seat | Leon | Grey | Driving without Due Care and Attention | None | Cotterills Road | Cotterills Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14074 | op-snap---monthly-publication-june-2025.pdf | 3 | 2025-06 | Pedestrian | BMW | 118I | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tenbury Road | Tenbury Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4264041 | -1.8966768 | ||
| 14080 | op-snap---monthly-publication-june-2025.pdf | 9 | 2025-06 | Pedestrian | Ford | Transit | Silver | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14081 | op-snap---monthly-publication-june-2025.pdf | 10 | 2025-06 | Pedestrian | Nissan | micra | Grey | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14082 | op-snap---monthly-publication-june-2025.pdf | 11 | 2025-06 | Pedestrian | Toyota | Prius | White | Contravening a Red Traffic Light | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14083 | op-snap---monthly-publication-june-2025.pdf | 12 | 2025-06 | Pedestrian | Skoda | Octavia | White | No Seat Belt | None | Broadway North | Broadway North | Walsall | Walsall | Education | N/A | 52.5886007 | -1.9741222 | ||
| 14085 | op-snap---monthly-publication-june-2025.pdf | 14 | 2025-06 | Pedestrian | BMW | 520d | Black | Stop a vehicle on pedestrian crossing | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Education | N/A | 52.4353506 | -1.8927483 | ||
| 14091 | op-snap---monthly-publication-june-2025.pdf | 20 | 2025-06 | Pedestrian | BMW | X1 | White | Using a Mobile Phone Whilst Driving | None | alcester Road | alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14092 | op-snap---monthly-publication-june-2025.pdf | 21 | 2025-06 | Pedestrian | Toyota | HIACE | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | BOWDEN ROAD | Bowden Road | Birmingham | Birmingham | Fixed Penalty | N/A | ||||
| 14112 | op-snap---monthly-publication-june-2025.pdf | 41 | 2025-06 | Pedestrian | Mercedes-Benz | GLB | Black | Driving without Due Care and Attention | None | Perry Barr Train Station | Perry Barr Train Station | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 14126 | op-snap---monthly-publication-june-2025.pdf | 55 | 2025-06 | Pedestrian | Volkswagen | Golf | White | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bilston Street | Bilston Street | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.5838892 | -2.1231759 | ||
| 14136 | op-snap---monthly-publication-june-2025.pdf | 65 | 2025-06 | Pedestrian | Tesla | Model Y | Blue | Contravening a Red Traffic Light | None | Portland Road | Portland Road | Birmingham | Birmingham | Education | N/A | 52.4737014 | -1.9412436 | ||
| 14160 | op-snap---monthly-publication-june-2025.pdf | 89 | 2025-06 | Pedestrian | Fiat | 500 | Blue | Driving without Due Care and Attention | None | Spouthouse Lane | Spouthouse Lane | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5390972 | -1.9319478 | ||
| 14166 | op-snap---monthly-publication-june-2025.pdf | 95 | 2025-06 | Pedestrian | Suzuki | UF50 | Blue | Driving without Due Care and Attention | No Insurance | HARCOURT DRIVE | Harcourt Drive | Sutton Coldfield | Sutton Coldfield | Court | N/A | 52.594171 | -1.8454056 | ||
| 14171 | op-snap---monthly-publication-june-2025.pdf | 100 | 2025-06 | Pedestrian | Toyota | Aygo | White | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 14172 | op-snap---monthly-publication-june-2025.pdf | 101 | 2025-06 | Pedestrian | Audi | SQ5 | Black | Cause vehicle to be left in a dangerous position | None | Coventry Road A45 | Coventry Road A45 | Birmingham | Birmingham | Warning Letter | N/A | 52.4516899 | -1.7753139 | ||
| 14173 | op-snap---monthly-publication-june-2025.pdf | 102 | 2025-06 | Pedestrian | Kia | Picanto | Red | Driving without Due Care and Attention | None | Spouthouse Lane at Old Walsall Road | Spouthouse Lane at Old Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5390972 | -1.9319478 | ||
| 14175 | op-snap---monthly-publication-june-2025.pdf | 104 | 2025-06 | Pedestrian | Vauxhall | CORSA | Black | Misc - Non Traffic Offences | None | SPOUTHOUSE LANE | Spouthouse Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5390972 | -1.9319478 | ||
| 14214 | op-snap---monthly-publication-june-2025.pdf | 143 | 2025-06 | Pedestrian | Ford | Icecream van | White | Driving without Due Care and Attention | None | Breedon Road | Breedon Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4191978 | -1.9251219 | ||
| 14223 | op-snap---monthly-publication-june-2025.pdf | 152 | 2025-06 | Pedestrian | Peugeot | Partner | White | Driving without Reasonable Consideration | None | Coventry Road | Coventry Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4726661 | -1.8769032 | ||
| 14251 | op-snap---monthly-publication-june-2025.pdf | 180 | 2025-06 | Pedestrian | Seat | Leon | Grey | Driving without Due Care and Attention | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 14254 | op-snap---monthly-publication-june-2025.pdf | 183 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Brown | Using a Mobile Phone Whilst Driving | None | Islington Row | Islington Row | Birmingham | Birmingham | Fixed Penalty | N/A | 52.472238 | -1.9127983 | ||
| 14255 | op-snap---monthly-publication-june-2025.pdf | 184 | 2025-06 | Pedestrian | Hyundai | I10 | Red | Contravening a Red Traffic Light | None | Coombs Road | Coombs Road | Halesowen | Halesowen | Fixed Penalty | N/A | 52.4596073 | -2.0500011 | ||
| 14267 | op-snap---monthly-publication-june-2025.pdf | 196 | 2025-06 | Pedestrian | Alfa Romeo | Mito | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | NFA | No Independent Evidence Available | 52.561 | -1.8187105 | ||
| 14273 | op-snap---monthly-publication-june-2025.pdf | 202 | 2025-06 | Pedestrian | Mercedes-Benz | A180. | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | No Insurance | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Fixed Penalty | N/A | 52.561 | -1.8187105 | ||
| 14275 | op-snap---monthly-publication-june-2025.pdf | 204 | 2025-06 | Pedestrian | Vauxhall | Mokka | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Upper Holland Rd | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 14304 | op-snap---monthly-publication-june-2025.pdf | 233 | 2025-06 | Pedestrian | Tesla | Model y | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 14308 | op-snap---monthly-publication-june-2025.pdf | 237 | 2025-06 | Pedestrian | BMW | 420I | Black | Misc - Non Traffic Offences | None | Frederick St | Frederick Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4863384 | -1.9123011 | ||
| 14310 | op-snap---monthly-publication-june-2025.pdf | 239 | 2025-06 | Pedestrian | Vauxhall | Mokka | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4860376 | -1.9095854 | ||
| 14318 | op-snap---monthly-publication-june-2025.pdf | 247 | 2025-06 | Pedestrian | Mercedes-Benz | C220 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4470686 | -1.8880749 | ||
| 14319 | op-snap---monthly-publication-june-2025.pdf | 248 | 2025-06 | Pedestrian | Ford | Kuga | Blue | Cause vehicle to be left in a dangerous position | None | Pineapple Road | Pineapple Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4303068 | -1.9077938 | ||
| 14322 | op-snap---monthly-publication-june-2025.pdf | 251 | 2025-06 | Pedestrian | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood Leisure Centre | Ladywood Leisure Centre | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4790242 | -1.9274592 | ||
| 14323 | op-snap---monthly-publication-june-2025.pdf | 252 | 2025-06 | Pedestrian | Audi | A6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monument Road | Monument Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4731312 | -1.930947 | ||
| 14331 | op-snap---monthly-publication-june-2025.pdf | 260 | 2025-06 | Pedestrian | Volkswagen | Golf | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | Warning Letter | N/A | 52.4860376 | -1.9095854 | ||
| 14352 | op-snap---monthly-publication-june-2025.pdf | 281 | 2025-06 | Pedestrian | Ford | Fiesta | Red | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14355 | op-snap---monthly-publication-june-2025.pdf | 284 | 2025-06 | Pedestrian | Audi | A3 | Grey | Using a Mobile Phone Whilst Driving | None | Plough and Harrow Road | Plough and Harrow Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5899123 | -1.8057069 | ||
| 14360 | op-snap---monthly-publication-june-2025.pdf | 289 | 2025-06 | Pedestrian | Ford | Fiesta | Black | Contravening a Red Traffic Light | None | Friary Road | Friary Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5162814 | -1.9395798 | ||
| 14373 | op-snap---monthly-publication-june-2025.pdf | 302 | 2025-06 | Pedestrian | Toyota | Prius | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherbourne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14382 | op-snap---monthly-publication-june-2025.pdf | 311 | 2025-06 | Pedestrian | Audi | A4 | Blue | Driving without Due Care and Attention | None | CHESTER ROAD | Chester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5359496 | -1.8324115 | ||
| 14429 | op-snap---monthly-publication-june-2025.pdf | 358 | 2025-06 | Pedestrian | Mercedes-Benz | C220 | Black | Motor vehicle fail to accord precedence at a pelican crossing | None | Heath Lane | Heath Lane | Metropolitan Borough | Metropolitan Borough | Warning Letter | N/A | 52.5369717 | -1.9907285 | ||
| 14431 | op-snap---monthly-publication-june-2025.pdf | 360 | 2025-06 | Pedestrian | Nissan | Xtrail | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4762433 | -1.9176665 | ||
| 14437 | op-snap---monthly-publication-june-2025.pdf | 366 | 2025-06 | Pedestrian | Kia | Ceed | White | Driving without Due Care and Attention | None | Sharmans Cross Road | Sharmans Cross Road | Solihull | Solihull | NFA | Outside of 14 DAYS Late Submission | 52.4167172 | -1.7990388 | ||
| 14438 | op-snap---monthly-publication-june-2025.pdf | 367 | 2025-06 | Pedestrian | Audi | A1 | Black | Driving without Due Care and Attention | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4762433 | -1.9176665 | ||
| 14459 | op-snap---monthly-publication-june-2025.pdf | 388 | 2025-06 | Pedestrian | Mitsubishi | L200 | Black | Driving without Due Care and Attention | None | Six Ashes Road | Six Ashes Road | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14510 | op-snap---monthly-publication-june-2025.pdf | 439 | 2025-06 | Pedestrian | Iveco | Daily | White | Driving without Due Care and Attention | None | Minerva Road | Minerva Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4894131 | -1.8524068 | ||
| 14515 | op-snap---monthly-publication-june-2025.pdf | 444 | 2025-06 | Pedestrian | BMW | 4 Series | Black | Driving without Due Care and Attention | None | Sherbourne Road | Sherbourne Road | Birmingham | Birmingham | RTC - Actioned | N/A | 52.4495478 | -1.8235444 | ||
| 14537 | op-snap---monthly-publication-june-2025.pdf | 466 | 2025-06 | Pedestrian | BMW | 116d | Black | Using a Mobile Phone Whilst Driving | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4470686 | -1.8880749 | ||
| 14538 | op-snap---monthly-publication-june-2025.pdf | 467 | 2025-06 | Pedestrian | Ford | fiesta | Pink | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Mitchell Avenue | Mitchell Avenue | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3940834 | -1.5696642 | ||
| 14541 | op-snap---monthly-publication-june-2025.pdf | 470 | 2025-06 | Pedestrian | Ford | Kuga | Blue | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14542 | op-snap---monthly-publication-june-2025.pdf | 471 | 2025-06 | Pedestrian | BMW | 320D.. | Black | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14543 | op-snap---monthly-publication-june-2025.pdf | 472 | 2025-06 | Pedestrian | Renault | Clio | Silver | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Warning Letter | N/A | 52.6068849 | -1.9611652 | ||
| 14547 | op-snap---monthly-publication-june-2025.pdf | 476 | 2025-06 | Pedestrian | Renault | Trafic | Beige | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14548 | op-snap---monthly-publication-june-2025.pdf | 477 | 2025-06 | Pedestrian | Mercedes-Benz | A200 | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14549 | op-snap---monthly-publication-june-2025.pdf | 478 | 2025-06 | Pedestrian | Toyota | Auris | White | Contravening a Red Traffic Light | None | Daw End Lane | Daw End Lane | Walsall | Walsall | Education | N/A | 52.6068849 | -1.9611652 | ||
| 14551 | op-snap---monthly-publication-june-2025.pdf | 480 | 2025-06 | Pedestrian | Mercedes-Benz | C350 | White | Driving without Due Care and Attention | None | Montague St | Montague Street | Birmingham | Birmingham | Education | N/A | 52.4816806 | -1.8788939 | ||
| 14562 | op-snap---monthly-publication-june-2025.pdf | 491 | 2025-06 | Pedestrian | BMW | 430D M | Black | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Peel Street, Willenhall | Peel Street, Willenhall | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | ||||
| 14569 | op-snap---monthly-publication-june-2025.pdf | 498 | 2025-06 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14570 | op-snap---monthly-publication-june-2025.pdf | 499 | 2025-06 | Pedestrian | Land Rover | Defednder | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14572 | op-snap---monthly-publication-june-2025.pdf | 501 | 2025-06 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Breedon Road | Breedon Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4191978 | -1.9251219 | ||
| 14591 | op-snap---monthly-publication-june-2025.pdf | 520 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Grey | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4027335 | -1.876125 | ||
| 14592 | op-snap---monthly-publication-june-2025.pdf | 521 | 2025-06 | Pedestrian | Seat | Ibiza | Blue | Cause vehicle to be left in a dangerous position | None | Ashdale Drive | Ashdale Drive | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4027335 | -1.876125 | ||
| 14603 | op-snap---monthly-publication-june-2025.pdf | 532 | 2025-06 | Pedestrian | Skoda | Octavia | Grey | Stop a vehicle within pelican pedestrian crossing limits | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Education | N/A | 52.4865107 | -1.9386263 | ||
| 14605 | op-snap---monthly-publication-june-2025.pdf | 534 | 2025-06 | Pedestrian | Renault | Megane | Silver | Stop a vehicle within pelican pedestrian crossing limits | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 14607 | op-snap---monthly-publication-june-2025.pdf | 536 | 2025-06 | Pedestrian | BMW | X5 | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Dudley Road | Dudley Road | Birmingham | Birmingham | NFA | No VRM | 52.4865107 | -1.9386263 | ||
| 14608 | op-snap---monthly-publication-june-2025.pdf | 537 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Friary Gardens | Friary Gardens | Birmingham | Birmingham | Warning Letter | N/A | 52.5156395 | -1.9424976 | ||
| 14610 | op-snap---monthly-publication-june-2025.pdf | 539 | 2025-06 | Pedestrian | BMW | X5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14611 | op-snap---monthly-publication-june-2025.pdf | 540 | 2025-06 | Pedestrian | Audi | A1 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14612 | op-snap---monthly-publication-june-2025.pdf | 541 | 2025-06 | Pedestrian | Mercedes-Benz | C250 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14614 | op-snap---monthly-publication-june-2025.pdf | 543 | 2025-06 | Pedestrian | Volkswagen | Golf | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cavendish Road | Cavendish Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4855226 | -1.9449143 | ||
| 14616 | op-snap---monthly-publication-june-2025.pdf | 545 | 2025-06 | Pedestrian | BMW | I4 | White | Stop a vehicle within pelican pedestrian crossing limits | None | A38 Tyburn Road | Tyburn Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5113867 | -1.8337258 | ||
| 14619 | op-snap---monthly-publication-june-2025.pdf | 548 | 2025-06 | Pedestrian | Seat | Alto | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplar Road | Poplar Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.436035 | -1.891685 | ||
| 14620 | op-snap---monthly-publication-june-2025.pdf | 549 | 2025-06 | Pedestrian | Vauxhall | Combo | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Valentine Road | Valentine Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4381959 | -1.8907391 | ||
| 14621 | op-snap---monthly-publication-june-2025.pdf | 550 | 2025-06 | Pedestrian | Mercedes-Benz | E220 | Black | Cause vehicle to be left in a dangerous position | None | Fawley Grove | Fawley Grove | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4218642 | -1.9133601 | ||
| 14622 | op-snap---monthly-publication-june-2025.pdf | 551 | 2025-06 | Pedestrian | Toyota | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Great Charles Street | Great Charles Street | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4837518 | -1.901874 | |||
| 14625 | op-snap---monthly-publication-june-2025.pdf | 554 | 2025-06 | Pedestrian | Land Rover | Range Rover | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Fixed Penalty | N/A | 52.3848122 | -1.5204351 | ||
| 14626 | op-snap---monthly-publication-june-2025.pdf | 555 | 2025-06 | Pedestrian | Audi | Q3 | White | Cause vehicle to be left in a dangerous position | None | Spring Lane | Spring Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5182019 | -1.8336169 | ||
| 14627 | op-snap---monthly-publication-june-2025.pdf | 556 | 2025-06 | Pedestrian | Volkswagen | Golf | Black | Cause vehicle to be left in a dangerous position | None | Station Road | Station Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5054559 | -1.9506109 | ||
| 14630 | op-snap---monthly-publication-june-2025.pdf | 559 | 2025-06 | Pedestrian | Vauxhall | corsa | Black | Cause vehicle to be left in a dangerous position | None | Tidbury Green Lane | Tidbury Green Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 14631 | op-snap---monthly-publication-june-2025.pdf | 560 | 2025-06 | Pedestrian | Ford | Transit | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Bradley Road | Bradley Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4977329 | -1.7706928 | ||
| 14632 | op-snap---monthly-publication-june-2025.pdf | 561 | 2025-06 | Pedestrian | Daf | White | Cause vehicle to be left in a dangerous position | None | Station Road to Franklin Road | Station Road to Franklin Road | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 14633 | op-snap---monthly-publication-june-2025.pdf | 562 | 2025-06 | Pedestrian | Iveco | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avenue Road, Kings Heath | Avenue Road, Kings Heath | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4328354 | -1.8999608 | |||
| 14635 | op-snap---monthly-publication-june-2025.pdf | 564 | 2025-06 | Pedestrian | Porsche | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Rd | Howard Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.5154198 | -1.9135452 | |||
| 14644 | op-snap---monthly-publication-june-2025.pdf | 573 | 2025-06 | Pedestrian | Audi | Q5 | White | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 14646 | op-snap---monthly-publication-june-2025.pdf | 575 | 2025-06 | Pedestrian | Ford | Puma | White | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 14648 | op-snap---monthly-publication-june-2025.pdf | 577 | 2025-06 | Pedestrian | Nissan | Qashqai | Black | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 14649 | op-snap---monthly-publication-june-2025.pdf | 578 | 2025-06 | Pedestrian | Porsche | Panamera | White | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 14650 | op-snap---monthly-publication-june-2025.pdf | 579 | 2025-06 | Pedestrian | Mercedes-Benz | GLA | Grey | Cause vehicle to be left in a dangerous position | None | Station Road | Station Road | Solihull | Solihull | NFA | Out of Force | 52.3927253 | -1.6455823 | ||
| 14655 | op-snap---monthly-publication-june-2025.pdf | 584 | 2025-06 | Pedestrian | Land Rover | Discovery | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Longmore Road | Longmore Road | Solihull | Solihull | NFA | Not in Public Interest | 52.4078616 | -1.8211577 | ||
| 14659 | op-snap---monthly-publication-june-2025.pdf | 588 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cuin Road | Cuin Road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 14660 | op-snap---monthly-publication-june-2025.pdf | 589 | 2025-06 | Pedestrian | Ford | Fiesta | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Colmore Road | Colmore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4296373 | -1.8993161 | ||
| 14661 | op-snap---monthly-publication-june-2025.pdf | 590 | 2025-06 | Pedestrian | Land Rover | Velar | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Rd | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 14662 | op-snap---monthly-publication-june-2025.pdf | 591 | 2025-06 | Pedestrian | Honda | CRV | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Rd | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 14663 | op-snap---monthly-publication-june-2025.pdf | 592 | 2025-06 | Pedestrian | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highwood Avenue | Highwood Avenue | Solihull | Solihull | Warning Letter | N/A | 52.434852 | -1.7860069 | ||
| 14664 | op-snap---monthly-publication-june-2025.pdf | 593 | 2025-06 | Pedestrian | Nissan | Qashqai | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Highwood Avenue | Highwood Avenue | Solihull | Solihull | Warning Letter | N/A | 52.434852 | -1.7860069 | ||
| 14665 | op-snap---monthly-publication-june-2025.pdf | 594 | 2025-06 | Pedestrian | Volkswagen | T-Roc | White | Stop a vehicle within pelican pedestrian crossing limits | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | Education | N/A | 52.5206297 | -1.9208426 | ||
| 14666 | op-snap---monthly-publication-june-2025.pdf | 595 | 2025-06 | Pedestrian | Peugeot | Partner | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hagley Road West | Hagley Road West | Birmingham | Birmingham | Warning Letter | N/A | 52.4656414 | -1.9852276 | ||
| 14668 | op-snap---monthly-publication-june-2025.pdf | 597 | 2025-06 | Pedestrian | Audi | A1... | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Mitchell Avenue (Near to Charter Acade | Mitchell Avenue (Near to Charter Acade | mCoy)ventry | Mcoy)Ventry | NFA | No Independent Evidence Available | ||||
| 14669 | op-snap---monthly-publication-june-2025.pdf | 598 | 2025-06 | Pedestrian | Volvo | XC60 | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Mitchell Avenue (Near to Charter Acade | Mitchell Avenue (Near to Charter Acade | mCoy)ventry | Mcoy)Ventry | NFA | No Independent Evidence Available | ||||
| 14701 | op-snap---monthly-publication-june-2025.pdf | 630 | 2025-06 | Pedestrian | Jaguar | XE Sport | Red | Driving without Reasonable Consideration | None | Cotsymore Road | Cotsymore Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A |
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);