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'}
141 rows where disposal = "NFA", month = "2025-06" and offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale
vehicle_make 25
- Ford 19
- Audi 18
- Mercedes-Benz 14
- Volkswagen 14
- Vauxhall 12
- Peugeot 9
- Toyota 9
- BMW 8
- Hyundai 6
- Land Rover 4
- Nissan 4
- Citroen 3
- Honda 2
- Jaguar 2
- Porsche 2
- Volvo 2
- Alfa Romeo 1
- Byd 1
- Dacia 1
- Fiat 1
- Lexus 1
- Mg 1
- Mitsubishi 1
- Renault 1
- Seat 1
council_area 11
reporter_transport_mode 5
- Pedestrian 105
- Car 27
- Pedal Bike 6
- Other 2
- car 1
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 141 ✖
month 1
- 2025-06 · 141 ✖
disposal 1
- NFA · 141 ✖
| 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 | ||
| 14581 | op-snap---monthly-publication-june-2025.pdf | 510 | 2025-06 | Other | Volvo | XC90 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bromford Lane | Bromford Lane | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.5083238 | -1.8332287 | ||
| 14601 | op-snap---monthly-publication-june-2025.pdf | 530 | 2025-06 | Car | Hyundai | I20 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holly Lane, Erdington | Holly Lane, Erdington | Birmingham | Birmingham | NFA | No Offence | 52.5214354 | -1.8218582 | ||
| 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 | ||
| 14651 | op-snap---monthly-publication-june-2025.pdf | 580 | 2025-06 | Car | Ford | Fiesta | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Mary's Row | Street Mary's Row | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 14653 | op-snap---monthly-publication-june-2025.pdf | 582 | 2025-06 | Car | Vauxhall | Grandland | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Mary's Row | Street Mary's Row | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 14654 | op-snap---monthly-publication-june-2025.pdf | 583 | 2025-06 | Car | Audi | A6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Mary's Row | Street Mary's Row | Birmingham | Birmingham | NFA | Not in Public Interest | ||||
| 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 | ||
| 14667 | op-snap---monthly-publication-june-2025.pdf | 596 | 2025-06 | Car | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4203897 | -1.8338574 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 14969 | op-snap---monthly-publication-june-2025.pdf | 898 | 2025-06 | Car | Audi | A3 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.513336 | -1.8833226 | ||
| 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 | ||
| 14971 | op-snap---monthly-publication-june-2025.pdf | 900 | 2025-06 | Pedal Bike | 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 | ||
| 14977 | op-snap---monthly-publication-june-2025.pdf | 906 | 2025-06 | Car | Toyota | Rav4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Henley in Arden | Henley in Arden | Out of Force Area | Out of Force Area | NFA | Out of Force | ||||
| 14981 | op-snap---monthly-publication-june-2025.pdf | 910 | 2025-06 | Pedal Bike | Volkswagen | Arteon | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Legge | Legge | Birmingham | Birmingham | NFA | No Offence | 52.4843538 | -1.9127963 | ||
| 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 | ||
| 15253 | op-snap---monthly-publication-june-2025.pdf | 1182 | 2025-06 | Pedal Bike | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bristol Road | Bristol Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4543565 | -1.9114004 | ||
| 15309 | op-snap---monthly-publication-june-2025.pdf | 1238 | 2025-06 | Pedal Bike | Vauxhall | Corsa | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4760986 | -1.9018641 | ||
| 15316 | op-snap---monthly-publication-june-2025.pdf | 1245 | 2025-06 | Car | Volkswagen | Golf | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Booths Lane | Booths Lane | Birmingham | Birmingham | NFA | No Offence | 52.5426102 | -1.9049087 | ||
| 15318 | op-snap---monthly-publication-june-2025.pdf | 1247 | 2025-06 | Car | Mercedes-Benz | Sprinter | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Whitecrest | Whitecrest | Birmingham | Birmingham | NFA | No Offence | 52.5459473 | -1.9271077 | ||
| 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 | ||
| 15324 | op-snap---monthly-publication-june-2025.pdf | 1253 | 2025-06 | Other | Audi | A4 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brunswick Close | Brunswick Close | Wolverhampton | Wolverhampton | NFA | No Offence | ||||
| 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 | ||||
| 15331 | op-snap---monthly-publication-june-2025.pdf | 1260 | 2025-06 | Car | Vauxhall | Vivaro | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | NFA | Outside of 14 DAYS Late Submission | 52.505832 | -1.92002 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 15395 | op-snap---monthly-publication-june-2025.pdf | 1324 | 2025-06 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kingsbury Road | Kingsbury Road | Birmingham | Birmingham | NFA | No Offence | 52.5292752 | -1.7618805 | ||
| 15402 | op-snap---monthly-publication-june-2025.pdf | 1331 | 2025-06 | Pedestrian | Jaguar | XF | 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 | ||
| 15403 | op-snap---monthly-publication-june-2025.pdf | 1332 | 2025-06 | Pedestrian | Toyota | Aygo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 15404 | op-snap---monthly-publication-june-2025.pdf | 1333 | 2025-06 | Pedestrian | Hyundai | Santa Fe | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 15406 | op-snap---monthly-publication-june-2025.pdf | 1335 | 2025-06 | Car | BMW | x5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton road | Witton road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 15407 | op-snap---monthly-publication-june-2025.pdf | 1336 | 2025-06 | Car | Toyota | auris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton road | Witton road | Birmingham | Birmingham | NFA | No Offence | 52.513336 | -1.8833226 | ||
| 15412 | op-snap---monthly-publication-june-2025.pdf | 1341 | 2025-06 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 15413 | op-snap---monthly-publication-june-2025.pdf | 1342 | 2025-06 | Pedestrian | Toyota | auris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 15414 | op-snap---monthly-publication-june-2025.pdf | 1343 | 2025-06 | Pedestrian | Fiat | Panda | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | NFA | No Offence | 52.5154198 | -1.9135452 | ||
| 15415 | op-snap---monthly-publication-june-2025.pdf | 1344 | 2025-06 | Pedestrian | Audi | A3 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Avenue Road | Avenue Road | Birmingham | Birmingham | NFA | No Offence | 52.4941712 | -1.8795158 | ||
| 15677 | op-snap---monthly-publication-june-2025.pdf | 1606 | 2025-06 | Car | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broad Street | Broad Street | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4749212 | -1.9147497 | |||||
| 15776 | op-snap---monthly-publication-june-2025.pdf | 1705 | 2025-06 | Pedestrian | Vauxhall | Zafira | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Worlds End Lane | Worlds End Lane | Birmingham | Birmingham | NFA | No Offence | 52.4555997 | -1.9882443 | ||
| 15778 | op-snap---monthly-publication-june-2025.pdf | 1707 | 2025-06 | Pedestrian | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Chalgrove Crescent | Chalgrove Crescent | Solihull | Solihull | NFA | Not in Public Interest | 52.4016325 | -1.7830609 | |||||
| 15781 | op-snap---monthly-publication-june-2025.pdf | 1710 | 2025-06 | Pedestrian | Mg | HS | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cotysmore Road | Cotysmore Road | Sutton Coldfield | Sutton Coldfield | NFA | Not in Public Interest | 52.5712977 | -1.8098984 | ||
| 15782 | op-snap---monthly-publication-june-2025.pdf | 1711 | 2025-06 | Pedestrian | Citroen | Berlingo | Brown | 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 | ||
| 15783 | op-snap---monthly-publication-june-2025.pdf | 1712 | 2025-06 | Car | BMW | I7 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Witton Road | Witton Road | Birmingham | Birmingham | NFA | Not in Public Interest | 52.513336 | -1.8833226 | ||
| 15800 | op-snap---monthly-publication-june-2025.pdf | 1729 | 2025-06 | Car | Vauxhall | Vivaro | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15808 | op-snap---monthly-publication-june-2025.pdf | 1737 | 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 | No Offence | 52.4236341 | -1.8787502 | ||
| 15813 | op-snap---monthly-publication-june-2025.pdf | 1742 | 2025-06 | Pedestrian | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood | Ladywood | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4774932 | -1.9233654 | ||
| 15815 | op-snap---monthly-publication-june-2025.pdf | 1744 | 2025-06 | Pedestrian | Volkswagen | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladywood | Ladywood | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4774932 | -1.9233654 | |||
| 15822 | op-snap---monthly-publication-june-2025.pdf | 1751 | 2025-06 | Pedestrian | Audi | A1 | 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 | ||
| 15823 | op-snap---monthly-publication-june-2025.pdf | 1752 | 2025-06 | Pedestrian | Peugeot | 208 | White | 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 | ||
| 15824 | op-snap---monthly-publication-june-2025.pdf | 1753 | 2025-06 | Pedestrian | Ford | C-max | White | 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 | ||
| 15825 | op-snap---monthly-publication-june-2025.pdf | 1754 | 2025-06 | Pedestrian | Ford | Focus | Blue | 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 | ||
| 15827 | op-snap---monthly-publication-june-2025.pdf | 1756 | 2025-06 | Pedestrian | Vauxhall | Corsa | 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 | ||
| 15843 | op-snap---monthly-publication-june-2025.pdf | 1772 | 2025-06 | Pedestrian | Audi | Q5.. | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | Coat of Arms Road | Coat of Arms Road | Coventry | Coventry | NFA | No Independent Evidence Available | 52.3872957 | -1.524318 | |||
| 15849 | op-snap---monthly-publication-june-2025.pdf | 1778 | 2025-06 | Pedestrian | Honda | CR-V | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Coventry Road | Coventry Road | Birmingham | Birmingham | NFA | No Offence | 52.4726661 | -1.8769032 | ||
| 15850 | op-snap---monthly-publication-june-2025.pdf | 1779 | 2025-06 | Pedestrian | Peugeot | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Kenilworth Road Oldbury | Kenilworth Road Oldbury | Sandwell | Sandwell | NFA | No Offence | |||||
| 15851 | op-snap---monthly-publication-june-2025.pdf | 1780 | 2025-06 | Pedestrian | Alfa Romeo | Veloce | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road, Oldbury | Castle Road, Oldbury | Sandwell | Sandwell | NFA | No Offence | 52.4688234 | -1.9996131 | ||
| 15856 | op-snap---monthly-publication-june-2025.pdf | 1785 | 2025-06 | car | Vauxhall | Zafira | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Berry Crescent | Berry Crescent | Walsall | Walsall | NFA | No Offence | ||||
| 15860 | op-snap---monthly-publication-june-2025.pdf | 1789 | 2025-06 | Pedestrian | Ford | Focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | outside school. No more detail of offen | outside school. No more detail of offen | cOe ulot coaf tFioonrce Area | Coe Ulot Coaf Tfioonrce Area | NFA | No Offence | ||||
| 15863 | op-snap---monthly-publication-june-2025.pdf | 1792 | 2025-06 | Pedestrian | Audi | A1 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stanbrook Road | Stanbrook Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 15880 | op-snap---monthly-publication-june-2025.pdf | 1809 | 2025-06 | Pedestrian | Toyota | IQ... | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Leech heath Road | Leech heath Road | Birmingham | Birmingham | NFA | No Offence | ||||
| 15881 | op-snap---monthly-publication-june-2025.pdf | 1810 | 2025-06 | Pedestrian | BMW | 220 D | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Cambridge Road | Cambridge Road | Birmingham | Birmingham | NFA | Misc Inc Crimes | 52.4368662 | -1.8846451 | ||
| 15890 | op-snap---monthly-publication-june-2025.pdf | 1819 | 2025-06 | Pedestrian | Nissan | Qashqai | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Naseby Drive | Naseby Drive | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4413419 | -2.0782707 | ||
| 15891 | op-snap---monthly-publication-june-2025.pdf | 1820 | 2025-06 | Pedestrian | Seat | Leon | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Naseby Drive | Naseby Drive | Dudley | Dudley | NFA | No Independent Evidence Available | 52.4413419 | -2.0782707 | ||
| 15913 | op-snap---monthly-publication-june-2025.pdf | 1842 | 2025-06 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | Moor Green Primary School | Moor Green Primary School | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4382134 | -1.9078858 | |||
| 15914 | op-snap---monthly-publication-june-2025.pdf | 1843 | 2025-06 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | No Offence | 52.4687472 | -1.9893922 | ||
| 15915 | op-snap---monthly-publication-june-2025.pdf | 1844 | 2025-06 | Pedestrian | BMW | 3 series | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | No Offence | 52.4687472 | -1.9893922 | ||
| 15916 | op-snap---monthly-publication-june-2025.pdf | 1845 | 2025-06 | Pedestrian | Volkswagen | Sharan | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | No Offence | 52.4687472 | -1.9893922 | ||
| 15920 | op-snap---monthly-publication-june-2025.pdf | 1849 | 2025-06 | Pedestrian | Volkswagen | T-roc | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street | High Street | Birmingham | Birmingham | NFA | No Offence | 52.5254588 | -1.8373064 | ||
| 15924 | op-snap---monthly-publication-june-2025.pdf | 1853 | 2025-06 | Car | Mercedes-Benz | benz | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Long mill Avenue | Long mill Avenue | Wolverhampton | Wolverhampton | NFA | No Offence | 52.6097692 | -2.0917924 | ||
| 15926 | op-snap---monthly-publication-june-2025.pdf | 1855 | 2025-06 | Pedestrian | Volkswagen | T-Roc | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Battery Way | Battery Way | Birmingham | Birmingham | NFA | Not in Public Interest | 52.4493988 | -1.8476406 | ||
| 15946 | op-snap---monthly-publication-june-2025.pdf | 1875 | 2025-06 | Pedestrian | Mercedes-Benz | B Class | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | No Offence | 52.4687472 | -1.9893922 | ||
| 15947 | op-snap---monthly-publication-june-2025.pdf | 1876 | 2025-06 | Pedestrian | Mercedes-Benz | Vito | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 15948 | op-snap---monthly-publication-june-2025.pdf | 1877 | 2025-06 | Pedestrian | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 15949 | op-snap---monthly-publication-june-2025.pdf | 1878 | 2025-06 | Pedestrian | Peugeot | 206 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road Eat | Castle Road Eat | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 15950 | op-snap---monthly-publication-june-2025.pdf | 1879 | 2025-06 | Pedestrian | Volkswagen | Tiguan | Gold | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4687472 | -1.9893922 | ||
| 15951 | op-snap---monthly-publication-june-2025.pdf | 1880 | 2025-06 | Pedestrian | Mercedes-Benz | A class | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Harborne Road | Harborne Road | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4681362 | -1.9840752 | ||
| 15952 | op-snap---monthly-publication-june-2025.pdf | 1881 | 2025-06 | Pedestrian | Mercedes-Benz | HGV | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4520441 | -1.8787544 | ||
| 15953 | op-snap---monthly-publication-june-2025.pdf | 1882 | 2025-06 | Pedestrian | Volvo | V40 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Belchers Lane | Belchers Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4800061 | -1.833007 | ||
| 15954 | op-snap---monthly-publication-june-2025.pdf | 1883 | 2025-06 | Pedestrian | Peugeot | 208 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | St Marys Row | Street Marys Row | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15964 | op-snap---monthly-publication-june-2025.pdf | 1893 | 2025-06 | Pedal Bike | Porsche | 911 Turbo | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Carver Street | Carver Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4857687 | -1.915613 | ||
| 15965 | op-snap---monthly-publication-june-2025.pdf | 1894 | 2025-06 | Pedestrian | Hyundai | I10 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Poplar Road | Poplar Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.436035 | -1.891685 |
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);