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'}
250 rows where disposal = "NFA", 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 14
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 105
- Cause vehicle to be left in a dangerous position 66
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 15
- Driving without Due Care and Attention 14
- Misc - Non Traffic Offences 13
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 9
- Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 9
- Stop a vehicle within pelican pedestrian crossing limits 5
- Using a Mobile Phone Whilst Driving 5
- Contravening a Red Traffic Light 4
- Stop a vehicle on pedestrian crossing 2
- Motor vehicle fail to accord precedence at a pelican crossing 1
- No Seat Belt 1
- VRM fails to conform to Regulations 1
council_area 12
- Birmingham 147
- Sandwell 27
- Wolverhampton 23
- Sutton Coldfield 14
- Solihull 12
- Out of Force Area 8
- Dudley 7
- Coventry 6
- Mcoy)Ventry 2
- Walsall 2
- Coe Ulot Coaf Tfioonrce Area 1
- Metropolitan Borough 1
reporter_transport_mode 1
- Pedestrian · 250 ✖
month 1
- 2025-06 · 250 ✖
disposal 1
- NFA · 250 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 14847 | op-snap---monthly-publication-june-2025.pdf | 776 | 2025-06 | Pedestrian | Volkswagen | Golf | Black | 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 Offence | 52.4762433 | -1.9176665 | ||
| 14857 | op-snap---monthly-publication-june-2025.pdf | 786 | 2025-06 | Pedestrian | Vauxhall | Corsa | Grey | Using a Mobile Phone Whilst Driving | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 14866 | op-snap---monthly-publication-june-2025.pdf | 795 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Buttery Road | Buttery Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4968875 | -1.9838564 | ||
| 14872 | op-snap---monthly-publication-june-2025.pdf | 801 | 2025-06 | Pedestrian | Toyota | Prius | White | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Sherborne Street | Sherborne Street | Birmingham | Birmingham | NFA | No Offence | 52.4762433 | -1.9176665 | ||
| 14899 | op-snap---monthly-publication-june-2025.pdf | 828 | 2025-06 | Pedestrian | Zonte | Red | Driving without Due Care and Attention | None | Coventry Road Kenilworth | Coventry Road Kenilworth | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.3954514 | -1.5222001 | |||
| 14942 | op-snap---monthly-publication-june-2025.pdf | 871 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Booth St | Booth Street | Metropolitan Borough | Metropolitan Borough | NFA | No Independent Evidence Available | 52.5039035 | -1.9447084 | ||
| 14949 | op-snap---monthly-publication-june-2025.pdf | 878 | 2025-06 | Pedestrian | Toyota | Prius | Black | Cause vehicle to be left in a dangerous position | None | Pitmaston Road | Pitmaston Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4254701 | -1.8322218 | ||
| 14953 | op-snap---monthly-publication-june-2025.pdf | 882 | 2025-06 | Pedestrian | Volkswagen | T Roc | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Snake Lane (Alvechurch) | Snake Lane (Alvechurch) | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14954 | op-snap---monthly-publication-june-2025.pdf | 883 | 2025-06 | Pedestrian | Audi | A3 | Black | Misc - Non Traffic Offences | None | St Bernards Road | Street Bernards Road | Solihull | Solihull | NFA | No Offence | ||||
| 14955 | op-snap---monthly-publication-june-2025.pdf | 884 | 2025-06 | Pedestrian | Toyota | Yaris | Black | Driving without Due Care and Attention | None | Birchfield Road | Birchfield Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5170745 | -1.9012542 | ||
| 14970 | op-snap---monthly-publication-june-2025.pdf | 899 | 2025-06 | Pedestrian | Jaguar | xe | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6095019 | -2.0915196 | ||
| 14979 | op-snap---monthly-publication-june-2025.pdf | 908 | 2025-06 | Pedestrian | Honda | Civic | Blue | Misc - Non Traffic Offences | None | Bedford Road | Bedford Road | Sutton Coldfield | Sutton Coldfield | NFA | No Offence | 52.5751987 | -1.8081729 | ||
| 14991 | op-snap---monthly-publication-june-2025.pdf | 920 | 2025-06 | Pedestrian | Tesla | White | Cause vehicle to be left in a dangerous position | None | Vivian Road | Vivian Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4579568 | -1.9510865 | |||
| 15003 | op-snap---monthly-publication-june-2025.pdf | 932 | 2025-06 | Pedestrian | Toyota | Auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4506039 | -1.8463952 | ||
| 15004 | op-snap---monthly-publication-june-2025.pdf | 933 | 2025-06 | Pedestrian | Peugeot | Expert | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Addison Road | Addison Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4313296 | -1.8882575 | ||
| 15005 | op-snap---monthly-publication-june-2025.pdf | 934 | 2025-06 | Pedestrian | Audi | S4 | Grey | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Bishopgate Street | Bishopgate Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15073 | op-snap---monthly-publication-june-2025.pdf | 1002 | 2025-06 | Pedestrian | Ford | Fiesta | Silver | Driving without Due Care and Attention | None | Newfield Crescent | Newfield Crescent | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 15075 | op-snap---monthly-publication-june-2025.pdf | 1004 | 2025-06 | Pedestrian | Toyota | PRIUS | GREY | Contravening a Red Traffic Light | None | PERCY ROAD | Percy Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4506155 | -1.8585325 | ||
| 15104 | op-snap---monthly-publication-june-2025.pdf | 1033 | 2025-06 | Pedestrian | Unknown | Black | Driving without Due Care and Attention | None | Chester Road | Chester Road | Walsall | Walsall | NFA | No VRM | 52.5692139 | -1.8799672 | |||
| 15150 | op-snap---monthly-publication-june-2025.pdf | 1079 | 2025-06 | Pedestrian | Toyota | Previa | White | Contravening a Red Traffic Light | None | Tyburn Road | Tyburn Road | Birmingham | Birmingham | NFA | No VRM | 52.5113867 | -1.8337258 | ||
| 15159 | op-snap---monthly-publication-june-2025.pdf | 1088 | 2025-06 | Pedestrian | Land Rover | SPORT | Red | Misc - Non Traffic Offences | KOMLA CLOSE | Komla Close | Birmingham | Birmingham | NFA | Misc Inc Crimes | |||||
| 15230 | op-snap---monthly-publication-june-2025.pdf | 1159 | 2025-06 | Pedestrian | Ford | Transit | White | Driving without Due Care and Attention | None | Breedon Road | Breedon Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4191978 | -1.9251219 | ||
| 15262 | op-snap---monthly-publication-june-2025.pdf | 1191 | 2025-06 | Pedestrian | Hyundai | Tucson | Grey | Motor vehicle fail to accord precedence at a pelican crossing | None | Bentley Heath | Bentley Heath | Wolverhampton | Wolverhampton | NFA | No Independent Evidence Available | 52.5968429 | -2.0898197 | ||
| 15308 | op-snap---monthly-publication-june-2025.pdf | 1237 | 2025-06 | Pedestrian | Vauxhall | Astra | Grey | Cause vehicle to be left in a dangerous position | None | Greenhill Road | Greenhill Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5142714 | -1.9419168 | ||
| 15311 | op-snap---monthly-publication-june-2025.pdf | 1240 | 2025-06 | Pedestrian | Mercedes-Benz | C180 | Black | Cause vehicle to be left in a dangerous position | None | Bangham Pitt Road | Bangham Pitt Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15312 | op-snap---monthly-publication-june-2025.pdf | 1241 | 2025-06 | Pedestrian | Renault | Captur | Grey | 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 | ||
| 15313 | op-snap---monthly-publication-june-2025.pdf | 1242 | 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 | ||
| 15319 | op-snap---monthly-publication-june-2025.pdf | 1248 | 2025-06 | Pedestrian | Volkswagen | Tiguan | Black | Stop a vehicle on pedestrian crossing | None | Roses Lane | Roses Lane | Birmingham | Birmingham | NFA | No Offence | ||||
| 15320 | op-snap---monthly-publication-june-2025.pdf | 1249 | 2025-06 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cannon Hill Road | Cannon Hill Road | Birmingham | Birmingham | NFA | No Offence | 52.4569873 | -1.8971744 | ||
| 15322 | op-snap---monthly-publication-june-2025.pdf | 1251 | 2025-06 | Pedestrian | Vauxhall | Astra | Grey | Cause vehicle to be left in a dangerous position | None | Greenhill Road | Greenhill Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5142714 | -1.9419168 | ||
| 15329 | op-snap---monthly-publication-june-2025.pdf | 1258 | 2025-06 | Pedestrian | Vauxhall | Astra | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bills More Green | Bills More Green | Solihull | Solihull | NFA | Outside of 14 Days NIP | ||||
| 15332 | op-snap---monthly-publication-june-2025.pdf | 1261 | 2025-06 | Pedestrian | Ford | Fiesta | Red | Cause vehicle to be left in a dangerous position | None | no address provided | No Address Provided | Out of Force Area | Out of Force Area | NFA | Outside of 14 Days NIP | ||||
| 15338 | op-snap---monthly-publication-june-2025.pdf | 1267 | 2025-06 | Pedestrian | Mercedes-Benz | C220 | Silver | Cause vehicle to be left in a dangerous position | None | Lakey Lane | Lakey Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4311142 | -1.8324795 | ||
| 15340 | op-snap---monthly-publication-june-2025.pdf | 1269 | 2025-06 | Pedestrian | Ford | fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | No Offence | 52.4470686 | -1.8880749 | ||
| 15346 | op-snap---monthly-publication-june-2025.pdf | 1275 | 2025-06 | Pedestrian | Land Rover | Sport | Black | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Frederick Street | Frederick Street | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4863384 | -1.9123011 | ||
| 15351 | op-snap---monthly-publication-june-2025.pdf | 1280 | 2025-06 | Pedestrian | Toyota | Aygo | Blue | No Seat Belt | None | Daw End Lane | Daw End Lane | Walsall | Walsall | NFA | No Independent Evidence Available | 52.6068849 | -1.9611652 | ||
| 15352 | op-snap---monthly-publication-june-2025.pdf | 1281 | 2025-06 | Pedestrian | Citroen | DS3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | NFA | No Offence | 52.4307 | -1.8494663 | ||
| 15353 | op-snap---monthly-publication-june-2025.pdf | 1282 | 2025-06 | Pedestrian | BMW | 118d | Blue | Cause vehicle to be left in a dangerous position | None | UK | Uk | Coventry | Coventry | NFA | Outside of 14 Days NIP | 52.3994858 | -1.4923603 | ||
| 15354 | op-snap---monthly-publication-june-2025.pdf | 1283 | 2025-06 | Pedestrian | Jaguar | XF | Blue | Cause vehicle to be left in a dangerous position | None | Castle Road West | Castle Road West | Wolverhampton | Wolverhampton | NFA | Outside of 14 DAYS Late Submission | 52.4683483 | -1.9909763 | ||
| 15355 | op-snap---monthly-publication-june-2025.pdf | 1284 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Londerry Lane | Londerry Lane | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 15356 | op-snap---monthly-publication-june-2025.pdf | 1285 | 2025-06 | Pedestrian | Skoda | Yeti | Beige | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4552055 | -1.9461279 | ||
| 15357 | op-snap---monthly-publication-june-2025.pdf | 1286 | 2025-06 | Pedestrian | Toyota | Prius | Silver | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4552055 | -1.9461279 | ||
| 15358 | op-snap---monthly-publication-june-2025.pdf | 1287 | 2025-06 | Pedestrian | Nissan | Juke | White | 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 | ||
| 15359 | op-snap---monthly-publication-june-2025.pdf | 1288 | 2025-06 | Pedestrian | Volkswagen | Golf | Blue | Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment | None | Metchley Lane | Metchley Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4552055 | -1.9461279 | ||
| 15360 | op-snap---monthly-publication-june-2025.pdf | 1289 | 2025-06 | Pedestrian | Ford | Fiesta | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mary Vale Road | Mary Vale Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.425105 | -1.9312861 | ||
| 15361 | op-snap---monthly-publication-june-2025.pdf | 1290 | 2025-06 | Pedestrian | Volkswagen | Passat | Grey | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | York Road | York Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5231321 | -1.8415573 | ||
| 15362 | op-snap---monthly-publication-june-2025.pdf | 1291 | 2025-06 | Pedestrian | Renault | Clio | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4470686 | -1.8880749 | ||
| 15363 | op-snap---monthly-publication-june-2025.pdf | 1292 | 2025-06 | Pedestrian | Vauxhall | Mokka | White | Misc - Non Traffic Offences | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15368 | op-snap---monthly-publication-june-2025.pdf | 1297 | 2025-06 | Pedestrian | Vauxhall | Corsa | Black | Stop a vehicle within pelican pedestrian crossing limits | None | Clifton Down, Bristol | Clifton Down, Bristol | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 15371 | op-snap---monthly-publication-june-2025.pdf | 1300 | 2025-06 | Pedestrian | Audi | Q5 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6095019 | -2.0915196 | ||
| 15372 | op-snap---monthly-publication-june-2025.pdf | 1301 | 2025-06 | Pedestrian | Toyota | C-HR | Purple | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6095019 | -2.0915196 | ||
| 15373 | op-snap---monthly-publication-june-2025.pdf | 1302 | 2025-06 | Pedestrian | Ford | Kuga | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6095019 | -2.0915196 | ||
| 15374 | op-snap---monthly-publication-june-2025.pdf | 1303 | 2025-06 | Pedestrian | Hyundai | i10 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6095019 | -2.0915196 | ||
| 15375 | op-snap---monthly-publication-june-2025.pdf | 1304 | 2025-06 | Pedestrian | Volkswagen | Tiguan | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6095019 | -2.0915196 | ||
| 15377 | op-snap---monthly-publication-june-2025.pdf | 1306 | 2025-06 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hollybank Road | Hollybank Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4236341 | -1.8787502 | ||
| 15379 | op-snap---monthly-publication-june-2025.pdf | 1308 | 2025-06 | Pedestrian | Audi | A3 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6095019 | -2.0915196 | ||
| 15380 | op-snap---monthly-publication-june-2025.pdf | 1309 | 2025-06 | Pedestrian | Hyundai | I10 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long Mill South | Long Mill South | Wolverhampton | Wolverhampton | NFA | Outside of 14 Days NIP | 52.6095019 | -2.0915196 | ||
| 15381 | op-snap---monthly-publication-june-2025.pdf | 1310 | 2025-06 | Pedestrian | Peugeot | Partner | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Rolfe St | Rolfe Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15382 | op-snap---monthly-publication-june-2025.pdf | 1311 | 2025-06 | Pedestrian | Ford | C Max | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Fern Road | Fern Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5215217 | -1.8359393 | ||
| 15383 | op-snap---monthly-publication-june-2025.pdf | 1312 | 2025-06 | Pedestrian | Peugeot | Partner | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kenilworth Road | Kenilworth Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5124557 | -1.8917609 | ||
| 15385 | op-snap---monthly-publication-june-2025.pdf | 1314 | 2025-06 | Pedestrian | Fiat | 500 | Black | Cause vehicle to be left in a dangerous position | None | Poplar Road | Poplar Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.436035 | -1.891685 | ||
| 15386 | op-snap---monthly-publication-june-2025.pdf | 1315 | 2025-06 | Pedestrian | Toyota | Auris | White | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Regent Place | Regent Place | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4860376 | -1.9095854 | ||
| 15387 | op-snap---monthly-publication-june-2025.pdf | 1316 | 2025-06 | Pedestrian | Jeep | Blue | Cause vehicle to be left in a dangerous position | None | Balaclava Road | Balaclava Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4337176 | -1.896658 | |||
| 15388 | op-snap---monthly-publication-june-2025.pdf | 1317 | 2025-06 | Pedestrian | Ford | S Max | Silver | Cause vehicle to be left in a dangerous position | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4833672 | -1.7871439 | ||
| 15389 | op-snap---monthly-publication-june-2025.pdf | 1318 | 2025-06 | Pedestrian | Vauxhall | Astra | Blue | Cause vehicle to be left in a dangerous position | None | Winschombe Road | Winschombe Road | Solihull | Solihull | NFA | Outside of 14 Days NIP |
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);