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'}
105 rows where disposal = "NFA", month = "2025-10" 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 24
offence 11
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 52
- Misc - Non Traffic Offences 26
- Cause vehicle to be left in a dangerous position 7
- Driving without Due Care and Attention 6
- Contravening a Red Traffic Light 3
- Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 3
- Using a Mobile Phone Whilst Driving 3
- Use a vehicle / cycle on a road and contravene a local traffic order other than parking 2
- Driving a vehicle wholly or partly on a footpath 1
- Motor vehicle fail to accord precedence at a pelican crossing 1
- No Insurance 1
council_area 10
- Birmingham 56
- Out of Force Area 19
- Dudley 8
- Coventry 6
- Sandwell 6
- Walsall 3
- Wolverhampton 3
- Solihull 2
- Halesowen 1
- Sutton Coldfield 1
reporter_transport_mode 1
- Pedestrian · 105 ✖
month 1
- 2025-10 · 105 ✖
disposal 1
- NFA · 105 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22076 | op-snap---monthly-publication-october-2025.pdf | 26 | 2025-10 | Pedestrian | Ford | Transit | Grey | Contravening a Red Traffic Light | None | Raynor Road | Raynor Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6043868 | -2.1046385 | ||
| 22124 | op-snap---monthly-publication-october-2025.pdf | 74 | 2025-10 | Pedestrian | Volvo | V60 | Gold | Use a vehicle / cycle on a road and contravene a local traffic order other than parking | None | Lye By Pass | Lye By Pass | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4589885 | -2.1160387 | ||
| 22163 | op-snap---monthly-publication-october-2025.pdf | 113 | 2025-10 | Pedestrian | multiple | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Church Lane, Tipton | Upper Church Lane, Tipton | Sandwell | Sandwell | NFA | No Independent Evidence Available | 52.5372015 | -2.0598546 | ||||
| 22210 | op-snap---monthly-publication-october-2025.pdf | 160 | 2025-10 | Pedestrian | Subara | Blue | Driving without Due Care and Attention | None | Tesco Car Park, Stourbridge | Tesco Car Park, Stourbridge | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4530893 | -2.0628772 | |||
| 22220 | op-snap---monthly-publication-october-2025.pdf | 170 | 2025-10 | Pedestrian | BMW | 330e | 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 | Not in Public Interest | 52.4762433 | -1.9176665 | ||
| 22235 | op-snap---monthly-publication-october-2025.pdf | 185 | 2025-10 | Pedestrian | White | Driving without Due Care and Attention | None | Newtown | Newtown | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4978509 | -1.8963733 | ||||
| 22297 | op-snap---monthly-publication-october-2025.pdf | 247 | 2025-10 | Pedestrian | BMW | 218i | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road, Wednesbury | Hobbs Road, Wednesbury | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 22340 | op-snap---monthly-publication-october-2025.pdf | 290 | 2025-10 | Pedestrian | Nissan | Pulsar | Silver | Motor vehicle fail to accord precedence at a pelican crossing | None | Warstones Road | Warstones Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 22420 | op-snap---monthly-publication-october-2025.pdf | 370 | 2025-10 | Pedestrian | Tractor | Red | Misc - Non Traffic Offences | None | Wall Hill Road | Wall Hill Road | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4459445 | -1.5552508 | |||
| 22427 | op-snap---monthly-publication-october-2025.pdf | 377 | 2025-10 | Pedestrian | Ford | Transit | blue | Contravening a Red Traffic Light | None | Edgbaston Road | Edgbaston Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4552785 | -1.906384 | ||
| 22451 | op-snap---monthly-publication-october-2025.pdf | 401 | 2025-10 | Pedestrian | BMW | X2 | Blue | Using a Mobile Phone Whilst Driving | None | Stoke Hospital | Stoke Hospital | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22486 | op-snap---monthly-publication-october-2025.pdf | 436 | 2025-10 | Pedestrian | Hyundai | I10 | Red | Contravening a Red Traffic Light | None | Berwick Road, Shrewsbury | Berwick Road, Shrewsbury | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 22488 | op-snap---monthly-publication-october-2025.pdf | 438 | 2025-10 | Pedestrian | Audi | A4 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Pershore Road | Pershore Road | Birmingham | Birmingham | NFA | No Offence | 52.4308271 | -1.920078 | ||
| 22491 | op-snap---monthly-publication-october-2025.pdf | 441 | 2025-10 | Pedestrian | Seat | Ibiza | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Church Street | Church Street | Birmingham | Birmingham | NFA | No Offence | 52.5020781 | -1.9122368 | ||
| 22629 | op-snap---monthly-publication-october-2025.pdf | 579 | 2025-10 | Pedestrian | Land Rover | Velar | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hobbs Road, Wednesbury | Hobbs Road, Wednesbury | Walsall | Walsall | NFA | No Independent Evidence Available | ||||
| 22752 | op-snap---monthly-publication-october-2025.pdf | 702 | 2025-10 | Pedestrian | Ford | Kuga | White | Driving without Due Care and Attention | Use vehicle on a road without valid test certificate | Longmore Road, Shirley | Longmore Road, Shirley | Solihull | Solihull | NFA | No Offence | 52.4078616 | -1.8211577 | ||
| 22796 | op-snap---monthly-publication-october-2025.pdf | 746 | 2025-10 | Pedestrian | Audi | SQ7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Streetly Road | Streetly Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.528829 | -1.8586141 | ||
| 22800 | op-snap---monthly-publication-october-2025.pdf | 750 | 2025-10 | Pedestrian | Mercedes-Benz | Grey | Using a Mobile Phone Whilst Driving | None | Pleck Road | Pleck Road | Walsall | Walsall | NFA | No Independent Evidence Available | 52.5827033 | -1.9960274 | |||
| 22801 | op-snap---monthly-publication-october-2025.pdf | 751 | 2025-10 | Pedestrian | BMW | Grey | Driving without Due Care and Attention | None | Newport Road | Newport Road | Coventry | Coventry | NFA | Outside of 14 DAYS Late Submission | 52.4373088 | -1.504993 | |||
| 22928 | op-snap---monthly-publication-october-2025.pdf | 878 | 2025-10 | Pedestrian | Mercedes-Benz | A Class | White | Driving without Due Care and Attention | None | Priory Road | Priory Road | Birmingham | Birmingham | NFA | No Offence | 52.4132696 | -1.8555008 | ||
| 22943 | op-snap---monthly-publication-october-2025.pdf | 893 | 2025-10 | Pedestrian | Toyota | Prius | Silver | Using a Mobile Phone Whilst Driving | None | Trinity Road | Trinity Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5812323 | -1.8234706 | ||
| 23009 | op-snap---monthly-publication-october-2025.pdf | 959 | 2025-10 | Pedestrian | Renault | Scenic | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hertford Way | Hertford Way | Solihull | Solihull | NFA | Not in Public Interest | 52.3778812 | -1.7427424 | ||
| 23015 | op-snap---monthly-publication-october-2025.pdf | 965 | 2025-10 | Pedestrian | Mercedes-Benz | Vito | White | Driving a vehicle wholly or partly on a footpath | None | Braces Lane | Braces Lane | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23104 | op-snap---monthly-publication-october-2025.pdf | 1054 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Patrons Road | Patrons Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 23111 | op-snap---monthly-publication-october-2025.pdf | 1061 | 2025-10 | Pedestrian | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hagley Road | Hagley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.471632 | -1.9456776 | ||||
| 23145 | op-snap---monthly-publication-october-2025.pdf | 1095 | 2025-10 | Pedestrian | Other | Misc - Non Traffic Offences | None | warwickshire | Warwickshire | Out of Force Area | Out of Force Area | NFA | Misc Inc Crimes | 52.4318492 | -1.7319529 | ||||
| 23153 | op-snap---monthly-publication-october-2025.pdf | 1103 | 2025-10 | Pedestrian | Other | Lorry | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Tibbington Road | Tibbington Road | Sandwell | Sandwell | NFA | No VRM | 52.5388686 | -2.0687475 | ||
| 23154 | op-snap---monthly-publication-october-2025.pdf | 1104 | 2025-10 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coalville | Coalville | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23168 | op-snap---monthly-publication-october-2025.pdf | 1118 | 2025-10 | Pedestrian | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Warwick Road | Warwick Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4555288 | -1.8613929 | ||||
| 23185 | op-snap---monthly-publication-october-2025.pdf | 1135 | 2025-10 | Pedestrian | Ford | Fiesta | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Tettenhall | High Street, Tettenhall | Wolverhampton | Wolverhampton | NFA | Misc Inc Crimes | 52.5980906 | -2.168057 | ||
| 23186 | op-snap---monthly-publication-october-2025.pdf | 1136 | 2025-10 | Pedestrian | Toyota | Avensis | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5333535 | -1.9189815 | ||
| 23187 | op-snap---monthly-publication-october-2025.pdf | 1137 | 2025-10 | Pedestrian | Audi | A4 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5333535 | -1.9189815 | ||
| 23188 | op-snap---monthly-publication-october-2025.pdf | 1138 | 2025-10 | Pedestrian | Mercedes-Benz | 180 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5333535 | -1.9189815 | ||
| 23191 | op-snap---monthly-publication-october-2025.pdf | 1141 | 2025-10 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Billsmore Green | Billsmore Green | Out of Force Area | Out of Force Area | NFA | No VRM | 52.4301865 | -1.7747746 | |||||
| 23199 | op-snap---monthly-publication-october-2025.pdf | 1149 | 2025-10 | Pedestrian | Citroen | xsara | Blue | Misc - Non Traffic Offences | None | fairfield road | Fairfield Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4747846 | -2.0270674 | ||
| 23202 | op-snap---monthly-publication-october-2025.pdf | 1152 | 2025-10 | Pedestrian | Mg | zs | White | Cause vehicle to be left in a dangerous position | None | hurstcroft road | Hurstcroft Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4830179 | -1.783876 | ||
| 23205 | op-snap---monthly-publication-october-2025.pdf | 1155 | 2025-10 | Pedestrian | BMW | 118d | Blue | Cause vehicle to be left in a dangerous position | None | charter avenue | Charter Avenue | Coventry | Coventry | NFA | Misc Inc Crimes | 52.3928409 | -1.5888076 | ||
| 23215 | op-snap---monthly-publication-october-2025.pdf | 1165 | 2025-10 | Pedestrian | Seat | Arona | Blue | Misc - Non Traffic Offences | None | Outside the Oval School | Outside the Oval School | Birmingham | Birmingham | NFA | No Offence | ||||
| 23219 | op-snap---monthly-publication-october-2025.pdf | 1169 | 2025-10 | Pedestrian | Other | Misc - Non Traffic Offences | None | Stock Wood Lodge Farm | Stock Wood Lodge Farm | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||||
| 23229 | op-snap---monthly-publication-october-2025.pdf | 1179 | 2025-10 | Pedestrian | Driving without Due Care and Attention | None | Norwood Road | Norwood Road | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4831397 | -2.1309273 | |||||
| 23236 | op-snap---monthly-publication-october-2025.pdf | 1186 | 2025-10 | Pedestrian | BMW | 3 Series | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4929304 | -1.8229092 | ||
| 23247 | op-snap---monthly-publication-october-2025.pdf | 1197 | 2025-10 | Pedestrian | Volkswagen | Golf | Black | Misc - Non Traffic Offences | None | Unknown | Coventry | Coventry | NFA | No Independent Evidence Available | |||||
| 23248 | op-snap---monthly-publication-october-2025.pdf | 1198 | 2025-10 | Pedestrian | Volkswagen | Golf | Black | Misc - Non Traffic Offences | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 23249 | op-snap---monthly-publication-october-2025.pdf | 1199 | 2025-10 | Pedestrian | Mg | HS | Silver | Misc - Non Traffic Offences | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 23252 | op-snap---monthly-publication-october-2025.pdf | 1202 | 2025-10 | Pedestrian | Toyota | Yaris | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Eddish Road | Eddish Road | Birmingham | Birmingham | NFA | No Offence | 52.4833672 | -1.7871439 | ||
| 23267 | op-snap---monthly-publication-october-2025.pdf | 1217 | 2025-10 | Pedestrian | Ford | Galaxy | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Unknown | Birmingham | Birmingham | NFA | No Independent Evidence Available | |||||
| 23271 | op-snap---monthly-publication-october-2025.pdf | 1221 | 2025-10 | Pedestrian | Lexus | ct200 | Blue | Misc - Non Traffic Offences | None | station road | Station Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5054559 | -1.9506109 | ||
| 23278 | op-snap---monthly-publication-october-2025.pdf | 1228 | 2025-10 | Pedestrian | Audi | a5 | White | Cause vehicle to be left in a dangerous position | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 23289 | op-snap---monthly-publication-october-2025.pdf | 1239 | 2025-10 | Pedestrian | Mg | hs | Black | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23291 | op-snap---monthly-publication-october-2025.pdf | 1241 | 2025-10 | Pedestrian | Audi | a3 | Grey | Misc - Non Traffic Offences | None | wellfield road | Wellfield Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4244197 | -1.8309669 | ||
| 23300 | op-snap---monthly-publication-october-2025.pdf | 1250 | 2025-10 | Pedestrian | Other | Caravan | White | Misc - Non Traffic Offences | None | New John Street | New John Street | Halesowen | Halesowen | NFA | No Offence | 52.4920451 | -1.8920402 | ||
| 23302 | op-snap---monthly-publication-october-2025.pdf | 1252 | 2025-10 | Pedestrian | BMW | X3 | Silver | Misc - Non Traffic Offences | None | Bradshaw Avenue | Bradshaw Avenue | Birmingham | Birmingham | NFA | No Offence | 52.4018255 | -1.9490522 | ||
| 23316 | op-snap---monthly-publication-october-2025.pdf | 1266 | 2025-10 | Pedestrian | Mini | one | Silver | Misc - Non Traffic Offences | None | Beech avenue | Beech avenue | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.5434265 | -1.9721357 | ||
| 23318 | op-snap---monthly-publication-october-2025.pdf | 1268 | 2025-10 | Pedestrian | Mercedes-Benz | transporter | White | Misc - Non Traffic Offences | None | york road | York Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5231321 | -1.8415573 | ||
| 23332 | op-snap---monthly-publication-october-2025.pdf | 1282 | 2025-10 | Pedestrian | Vauxhall | Corsa | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Moseley Road | Moseley Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4679402 | -1.881408 | ||
| 23354 | op-snap---monthly-publication-october-2025.pdf | 1304 | 2025-10 | Pedestrian | Ford | E-Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Daventry Road | Daventry Road | Coventry | Coventry | NFA | Misc Inc Crimes | 52.3930931 | -1.4976428 | ||
| 23366 | op-snap---monthly-publication-october-2025.pdf | 1316 | 2025-10 | Pedestrian | Seat | arona | White | Misc - Non Traffic Offences | None | out of force | Out Of Force | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23385 | op-snap---monthly-publication-october-2025.pdf | 1335 | 2025-10 | Pedestrian | Mg | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Daisy Close | Daisy Close | Coventry | Coventry | NFA | No Offence | 52.4024631 | -1.4690557 | |||
| 23388 | op-snap---monthly-publication-october-2025.pdf | 1338 | 2025-10 | Pedestrian | Ford | Fiesta | Silver | Cause vehicle to be left in a dangerous position | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 23393 | op-snap---monthly-publication-october-2025.pdf | 1343 | 2025-10 | Pedestrian | Seat | Leon | Black | Misc - Non Traffic Offences | None | Outmore Road | Outmore Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4767211 | -1.7814678 | ||
| 23407 | op-snap---monthly-publication-october-2025.pdf | 1357 | 2025-10 | Pedestrian | Daf | Yellow | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Wheelwright Lane | Wheelwright Lane | Coventry | Coventry | NFA | Misc Inc Crimes | 52.4484571 | -1.5109455 | |||
| 23408 | op-snap---monthly-publication-october-2025.pdf | 1358 | 2025-10 | Pedestrian | Audi | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bridge Street | Bridge Street | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.477534 | -1.908097 | |||
| 23410 | op-snap---monthly-publication-october-2025.pdf | 1360 | 2025-10 | Pedestrian | Peugeot | 3008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ravenshurst Road | Ravenshurst Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23413 | op-snap---monthly-publication-october-2025.pdf | 1363 | 2025-10 | Pedestrian | Cupra | Born | Blue | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | Ryland Street | Ryland Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4757111 | -1.9189009 | ||
| 23416 | op-snap---monthly-publication-october-2025.pdf | 1366 | 2025-10 | Pedestrian | Volkswagen | Passat | Grey | Misc - Non Traffic Offences | None | Hannafore Road | Hannafore Road | Birmingham | Birmingham | NFA | No Offence | 52.4823037 | -1.9449404 | ||
| 23422 | op-snap---monthly-publication-october-2025.pdf | 1372 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Hereford | Hereford | Out of Force Area | Out of Force Area | NFA | Out of Force | 52.4047807 | -2.0101216 | |||||
| 23440 | op-snap---monthly-publication-october-2025.pdf | 1390 | 2025-10 | Pedestrian | Audi | Q5 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | York Road | York Road | Birmingham | Birmingham | NFA | No Offence | 52.5231321 | -1.8415573 | ||
| 23444 | op-snap---monthly-publication-october-2025.pdf | 1394 | 2025-10 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lyons Grove | Lyons Grove | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4471223 | -1.8664309 | ||
| 23445 | op-snap---monthly-publication-october-2025.pdf | 1395 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Borrington Road, Kidderminster | Borrington Road, Kidderminster | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 23451 | op-snap---monthly-publication-october-2025.pdf | 1401 | 2025-10 | Pedestrian | Hyundai | i30 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | garrats lane | Garrats Lane | Dudley | Dudley | NFA | Misc Inc Crimes | ||||
| 23454 | op-snap---monthly-publication-october-2025.pdf | 1404 | 2025-10 | Pedestrian | Vauxhall | vivaro | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | abbey road | Abbey Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5162302 | -1.8593733 | ||
| 23466 | op-snap---monthly-publication-october-2025.pdf | 1416 | 2025-10 | Pedestrian | Ford | focus | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | reddings lane | Reddings Lane | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4506039 | -1.8463952 | ||
| 23477 | op-snap---monthly-publication-october-2025.pdf | 1427 | 2025-10 | Pedestrian | Vauxhall | vivaro | White | Misc - Non Traffic Offences | None | lyons grove | Lyons Grove | Birmingham | Birmingham | NFA | No Offence | 52.4471223 | -1.8664309 | ||
| 23480 | op-snap---monthly-publication-october-2025.pdf | 1430 | 2025-10 | Pedestrian | Vauxhall | astra | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | gayfield avenue | Gayfield Avenue | Dudley | Dudley | NFA | Misc Inc Crimes | 52.4693896 | -2.1251602 | ||
| 23496 | op-snap---monthly-publication-october-2025.pdf | 1446 | 2025-10 | Pedestrian | Mercedes-Benz | E300 | Black | Cause vehicle to be left in a dangerous position | None | Robin Hood Land | Robin Hood Land | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23500 | op-snap---monthly-publication-october-2025.pdf | 1450 | 2025-10 | Pedestrian | Volkswagen | Touran | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | heartlands hospital | Heartlands Hospital | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4762622 | -1.8276197 | ||
| 23501 | op-snap---monthly-publication-october-2025.pdf | 1451 | 2025-10 | Pedestrian | Jeep | avenger | Yellow | Misc - Non Traffic Offences | None | yorkmead primary | Yorkmead Primary | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23516 | op-snap---monthly-publication-october-2025.pdf | 1466 | 2025-10 | Pedestrian | Ford | Transit | Silver | Cause vehicle to be left in a dangerous position | None | Tower Hill | Tower Hill | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5335541 | -1.9186098 | ||
| 23548 | op-snap---monthly-publication-october-2025.pdf | 1498 | 2025-10 | Pedestrian | 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 | NFA | Misc Inc Crimes | 52.4851181 | -1.9106263 | ||||
| 23565 | op-snap---monthly-publication-october-2025.pdf | 1515 | 2025-10 | Pedestrian | Kia | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Worcester Road. OOF | Worcester Road. OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23595 | op-snap---monthly-publication-october-2025.pdf | 1545 | 2025-10 | Pedestrian | Hyundai | Tucson | Black | Misc - Non Traffic Offences | None | Columbia Close | Columbia Close | Birmingham | Birmingham | NFA | No Offence | 52.4632515 | -1.9032924 | ||
| 23613 | op-snap---monthly-publication-october-2025.pdf | 1563 | 2025-10 | Pedestrian | Ford | Puma | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Russell Road | Russell Road | Birmingham | Birmingham | NFA | No Offence | 52.4398245 | -1.8469786 | ||
| 23614 | op-snap---monthly-publication-october-2025.pdf | 1564 | 2025-10 | Pedestrian | Kia | Stonic | Grey | No Insurance | None | Anglessey Primary School | Anglessey Primary School | Birmingham | Birmingham | NFA | No Independent Evidence Available | ||||
| 23625 | op-snap---monthly-publication-october-2025.pdf | 1575 | 2025-10 | Pedestrian | Citroen | C3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplare Road | Poplare Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | ||||
| 23626 | op-snap---monthly-publication-october-2025.pdf | 1576 | 2025-10 | Pedestrian | Toyota | Auris | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lower Queen Street | Lower Queen Street | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5603978 | -1.8227403 | ||
| 23635 | op-snap---monthly-publication-october-2025.pdf | 1585 | 2025-10 | Pedestrian | BMW | 3 Series | Black | Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD | None | High St | High Street | Birmingham | Birmingham | NFA | No Offence | 52.5254588 | -1.8373064 | ||
| 23651 | op-snap---monthly-publication-october-2025.pdf | 1601 | 2025-10 | Pedestrian | Volkswagen | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St, Clee Hill OOF | High Street, Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23652 | op-snap---monthly-publication-october-2025.pdf | 1602 | 2025-10 | Pedestrian | Volkswagen | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St, Clee Hill OOF | High Street, Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||
| 23657 | op-snap---monthly-publication-october-2025.pdf | 1607 | 2025-10 | Pedestrian | Vauxhall | Elite | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whithymoor Primary School | Whithymoor Primary School | Sandwell | Sandwell | NFA | Misc Inc Crimes | ||||
| 23664 | op-snap---monthly-publication-october-2025.pdf | 1614 | 2025-10 | Pedestrian | Ford | Fiesta | Purple | Cause vehicle to be left in a dangerous position | None | Kingstanding road | Kingstanding road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5521118 | -1.8845138 | ||
| 23665 | op-snap---monthly-publication-october-2025.pdf | 1615 | 2025-10 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Alcester Road | Alcester Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4470686 | -1.8880749 | |||||
| 23677 | op-snap---monthly-publication-october-2025.pdf | 1627 | 2025-10 | Pedestrian | Lexus | Black | Misc - Non Traffic Offences | None | Telford Gardens | Telford Gardens | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5722935 | -2.1694816 | |||
| 23683 | op-snap---monthly-publication-october-2025.pdf | 1633 | 2025-10 | Pedestrian | Land Rover | Discovery | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High St Clee Hill OOF | High Street Clee Hill OOF | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 23685 | op-snap---monthly-publication-october-2025.pdf | 1635 | 2025-10 | Pedestrian | Volkswagen | Golf | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5333535 | -1.9189815 | ||
| 23686 | op-snap---monthly-publication-october-2025.pdf | 1636 | 2025-10 | Pedestrian | Vauxhall | Astra | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5333535 | -1.9189815 | ||
| 23687 | op-snap---monthly-publication-october-2025.pdf | 1637 | 2025-10 | Pedestrian | Mini | Cooper | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5333535 | -1.9189815 | ||
| 23688 | op-snap---monthly-publication-october-2025.pdf | 1638 | 2025-10 | Pedestrian | Mercedes-Benz | A180 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Law Cliff Road | Law Cliff Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.5333535 | -1.9189815 | ||
| 23693 | op-snap---monthly-publication-october-2025.pdf | 1643 | 2025-10 | Pedestrian | Porsche | Macan | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Abbey Road | Abbey Road | Sandwell | Sandwell | NFA | Misc Inc Crimes | 52.47753 | -1.9774758 | ||
| 23703 | op-snap---monthly-publication-october-2025.pdf | 1653 | 2025-10 | Pedestrian | Misc - Non Traffic Offences | None | Out of force | Out of force | Out of Force Area | Out of Force Area | NFA | Out of Force | |||||||
| 23751 | op-snap---monthly-publication-october-2025.pdf | 1701 | 2025-10 | Pedestrian | Mercedes-Benz | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Clee Hill High St OOF | Clee Hill High Street OOF | Out of Force Area | Out of Force Area | NFA | Out of Force |
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);