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'}
94 rows where month = "2025-06", offence = "Cause vehicle to be left in a dangerous position" and reporter_transport_mode = "Pedestrian" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, council_area_raw, nfa_rationale
vehicle_make 25
council_area 9
- Birmingham 57
- Sandwell 17
- Solihull 5
- Dudley 4
- Coventry 3
- Sutton Coldfield 3
- Out of Force Area 2
- Wolverhampton 2
- Walsall 1
disposal 3
- NFA 66
- Warning Letter 27
- Fixed Penalty 1
reporter_transport_mode 1
- Pedestrian · 94 ✖
offence 1
- Cause vehicle to be left in a dangerous position · 94 ✖
month 1
- 2025-06 · 94 ✖
| id | source_file | source_page | source_row | month ▲ | reporter_transport_mode | vehicle_make | vehicle_model | vehicle_colour | offence | second_offence | offence_location_raw | offence_location | council_area_raw | council_area | disposal | nfa_rationale | witness_contacted | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14071 | op-snap---monthly-publication-june-2025.pdf | 0 | 2025-06 | Pedestrian | Dodge | Blue | Cause vehicle to be left in a dangerous position | None | Heath Green Road | Heath Green Road | Birmingham | Birmingham | Fixed Penalty | N/A | 52.4873353 | -1.9407986 | |||
| 14172 | op-snap---monthly-publication-june-2025.pdf | 101 | 2025-06 | Pedestrian | Audi | SQ5 | Black | Cause vehicle to be left in a dangerous position | None | Coventry Road A45 | Coventry Road A45 | Birmingham | Birmingham | Warning Letter | N/A | 52.4516899 | -1.7753139 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 14632 | op-snap---monthly-publication-june-2025.pdf | 561 | 2025-06 | Pedestrian | Daf | White | Cause vehicle to be left in a dangerous position | None | Station Road to Franklin Road | Station Road to Franklin Road | Birmingham | Birmingham | Warning Letter | N/A | |||||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 15384 | op-snap---monthly-publication-june-2025.pdf | 1313 | 2025-06 | Pedestrian | Ford | Fiesta | Red | Cause vehicle to be left in a dangerous position | None | Wentworth Rooad | Wentworth Rooad | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 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 | ||
| 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 | ||||
| 15390 | op-snap---monthly-publication-june-2025.pdf | 1319 | 2025-06 | Pedestrian | Toyota | Prius | 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 | ||
| 15391 | op-snap---monthly-publication-june-2025.pdf | 1320 | 2025-06 | Pedestrian | Dacia | Sandero | Silver | Cause vehicle to be left in a dangerous position | None | Manor Road | Manor Road | Birmingham | Birmingham | NFA | Out of Force | 52.5619179 | -1.8297455 | ||
| 15394 | op-snap---monthly-publication-june-2025.pdf | 1323 | 2025-06 | Pedestrian | Mercedes-Benz | GLB 220 | Blue | 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 | ||
| 15438 | op-snap---monthly-publication-june-2025.pdf | 1367 | 2025-06 | Pedestrian | Nissan | Pilsar | Grey | Cause vehicle to be left in a dangerous position | None | Naseby Drive | Naseby Drive | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4413419 | -2.0782707 | ||
| 15777 | op-snap---monthly-publication-june-2025.pdf | 1706 | 2025-06 | Pedestrian | Honda | Jazz | Blue | Cause vehicle to be left in a dangerous position | None | Overton Close | Overton Close | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4228124 | -1.8330277 | ||
| 15802 | op-snap---monthly-publication-june-2025.pdf | 1731 | 2025-06 | Pedestrian | Citroen | Berlingo | 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 | ||
| 15804 | op-snap---monthly-publication-june-2025.pdf | 1733 | 2025-06 | Pedestrian | Honda | Jazz | Brown | Cause vehicle to be left in a dangerous position | None | All Saints Road | All Saints Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4918459 | -1.9192303 | ||
| 15806 | op-snap---monthly-publication-june-2025.pdf | 1735 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | All Saints Road | All Saints Road | Birmingham | Birmingham | NFA | No VRM | 52.4918459 | -1.9192303 | ||
| 15807 | op-snap---monthly-publication-june-2025.pdf | 1736 | 2025-06 | Pedestrian | Seat | Leon | Black | Cause vehicle to be left in a dangerous position | None | Vicarage Road | Vicarage Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.470423 | -1.9304786 | ||
| 15814 | op-snap---monthly-publication-june-2025.pdf | 1743 | 2025-06 | Pedestrian | Renault | Clio | Blue | Cause vehicle to be left in a dangerous position | None | Church Road | Church Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4624743 | -1.7763934 | ||
| 15816 | op-snap---monthly-publication-june-2025.pdf | 1745 | 2025-06 | Pedestrian | Ford | Silver | Cause vehicle to be left in a dangerous position | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 15817 | op-snap---monthly-publication-june-2025.pdf | 1746 | 2025-06 | Pedestrian | Honda | Black | Cause vehicle to be left in a dangerous position | None | Rotten Park Road | Rotten Park Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | |||||
| 15826 | op-snap---monthly-publication-june-2025.pdf | 1755 | 2025-06 | Pedestrian | Mercedes-Benz | C250 | White | Cause vehicle to be left in a dangerous position | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4353506 | -1.8927483 | ||
| 15837 | op-snap---monthly-publication-june-2025.pdf | 1766 | 2025-06 | Pedestrian | BMW | 1 Series | Grey | Cause vehicle to be left in a dangerous position | None | Dovehouse Lane | Dovehouse Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4319915 | -1.7915192 | ||
| 15838 | op-snap---monthly-publication-june-2025.pdf | 1767 | 2025-06 | Pedestrian | BMW | 320 | Black | Cause vehicle to be left in a dangerous position | None | Dovehouse Lane | Dovehouse Lane | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4319915 | -1.7915192 | ||
| 15839 | op-snap---monthly-publication-june-2025.pdf | 1768 | 2025-06 | Pedestrian | Vauxhall | Black | Cause vehicle to be left in a dangerous position | None | Cherry Orchard Road | Cherry Orchard Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5206297 | -1.9208426 | |||
| 15857 | op-snap---monthly-publication-june-2025.pdf | 1786 | 2025-06 | Pedestrian | Ford | galaxy | Grey | Cause vehicle to be left in a dangerous position | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | No Independent Evidence Available | 52.4456462 | -1.827993 | ||
| 15919 | op-snap---monthly-publication-june-2025.pdf | 1848 | 2025-06 | Pedestrian | Mercedes-Benz | sprinter | White | Cause vehicle to be left in a dangerous position | None | Fosbrooke Road | Fosbrooke Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4700545 | -1.834436 | ||
| 15928 | op-snap---monthly-publication-june-2025.pdf | 1857 | 2025-06 | Pedestrian | Ford | Transit | Blue | Cause vehicle to be left in a dangerous position | None | Dovehouse Parade | Dovehouse Parade | Solihull | Solihull | NFA | Outside of 14 Days NIP | 52.4292175 | -1.7980801 | ||
| 15929 | op-snap---monthly-publication-june-2025.pdf | 1858 | 2025-06 | Pedestrian | BMW | 525d | Black | Cause vehicle to be left in a dangerous position | None | Algernon Road | Algernon Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4861056 | -1.9453359 | ||
| 15931 | op-snap---monthly-publication-june-2025.pdf | 1860 | 2025-06 | Pedestrian | Seat | Leon | Black | Cause vehicle to be left in a dangerous position | None | Holly Lane | Holly Lane | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4992354 | -1.9835418 | ||
| 15932 | op-snap---monthly-publication-june-2025.pdf | 1861 | 2025-06 | Pedestrian | Vauxhall | Corsa | Silver | 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 | ||
| 15955 | op-snap---monthly-publication-june-2025.pdf | 1884 | 2025-06 | Pedestrian | Volkswagen | Touareg | Black | Cause vehicle to be left in a dangerous position | None | Holly Lane | Holly Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5236889 | -1.8253311 | ||
| 15997 | op-snap---monthly-publication-june-2025.pdf | 1926 | 2025-06 | Pedestrian | BMW | 318d | Blue | 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 | ||
| 15998 | op-snap---monthly-publication-june-2025.pdf | 1927 | 2025-06 | Pedestrian | Volvo | XC90 | Silver | 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 | ||
| 15999 | op-snap---monthly-publication-june-2025.pdf | 1928 | 2025-06 | Pedestrian | Volkswagen | Golf | 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 | ||
| 16000 | op-snap---monthly-publication-june-2025.pdf | 1929 | 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 | ||
| 16001 | op-snap---monthly-publication-june-2025.pdf | 1930 | 2025-06 | Pedestrian | Volkswagen | T-Cross | Grey | 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 | ||
| 16002 | op-snap---monthly-publication-june-2025.pdf | 1931 | 2025-06 | Pedestrian | Mercedes-Benz | A180 | Grey | Cause vehicle to be left in a dangerous position | None | Cape Street | Cape Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4876445 | -1.9433963 | ||
| 16015 | op-snap---monthly-publication-june-2025.pdf | 1944 | 2025-06 | Pedestrian | BMW | 330E | Black | Cause vehicle to be left in a dangerous position | None | Hurstcroft Road | Hurstcroft Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4830179 | -1.783876 | ||
| 16018 | op-snap---monthly-publication-june-2025.pdf | 1947 | 2025-06 | Pedestrian | Audi | A4 | Silver | Cause vehicle to be left in a dangerous position | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.513857 | -1.9367367 | ||
| 16021 | op-snap---monthly-publication-june-2025.pdf | 1950 | 2025-06 | Pedestrian | Mercedes-Benz | E220 | Silver | Cause vehicle to be left in a dangerous position | None | Oxhill Road | Oxhill Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.513857 | -1.9367367 | ||
| 16025 | op-snap---monthly-publication-june-2025.pdf | 1954 | 2025-06 | Pedestrian | Peugeot | 2008.. | Black | Cause vehicle to be left in a dangerous position | None | York Road Kings Heath | York Road Kings Heath | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.434526 | -1.8935819 | ||
| 16032 | op-snap---monthly-publication-june-2025.pdf | 1961 | 2025-06 | Pedestrian | Volkswagen | Golf | Blue | Cause vehicle to be left in a dangerous position | None | Burlington Road | Burlington Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4744358 | -1.8427399 | ||
| 16035 | op-snap---monthly-publication-june-2025.pdf | 1964 | 2025-06 | Pedestrian | Ford | S-Max | Grey | Cause vehicle to be left in a dangerous position | None | Cotton Lane | Cotton Lane | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4411893 | -1.8821635 | ||
| 16039 | op-snap---monthly-publication-june-2025.pdf | 1968 | 2025-06 | Pedestrian | Mercedes-Benz | C200 | Black | Cause vehicle to be left in a dangerous position | None | Westley Road | Westley Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4456462 | -1.827993 | ||
| 16040 | op-snap---monthly-publication-june-2025.pdf | 1969 | 2025-06 | Pedestrian | Audi | Q4 | Black | Cause vehicle to be left in a dangerous position | None | Bladwins Road | Bladwins Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 16049 | op-snap---monthly-publication-june-2025.pdf | 1978 | 2025-06 | Pedestrian | Mercedes-Benz | Black | Cause vehicle to be left in a dangerous position | None | Castle Road West | Castle Road West | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | 52.4686934 | -1.9974957 | |||
| 16064 | op-snap---monthly-publication-june-2025.pdf | 1993 | 2025-06 | Pedestrian | Suzuki | Swift | Blue | Cause vehicle to be left in a dangerous position | None | Broad lanes Kings heath | Broad lanes Kings heath | Birmingham | Birmingham | NFA | No Offence | ||||
| 16066 | op-snap---monthly-publication-june-2025.pdf | 1995 | 2025-06 | Pedestrian | BMW | 530D | Silver | Cause vehicle to be left in a dangerous position | None | Reddings Lane | Reddings Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4506039 | -1.8463952 | ||
| 16068 | op-snap---monthly-publication-june-2025.pdf | 1997 | 2025-06 | Pedestrian | Porsche | Cayenne | Grey | Cause vehicle to be left in a dangerous position | None | Alcester Road | Alcester Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4470686 | -1.8880749 | ||
| 16069 | op-snap---monthly-publication-june-2025.pdf | 1998 | 2025-06 | Pedestrian | Hyundai | I30 | Red | Cause vehicle to be left in a dangerous position | None | Dovehouse Lane | Dovehouse Lane | Coventry | Coventry | Warning Letter | N/A | ||||
| 16071 | op-snap---monthly-publication-june-2025.pdf | 2000 | 2025-06 | Pedestrian | Land Rover | Range Rover | White | Cause vehicle to be left in a dangerous position | None | Yew Tree Lane | Yew Tree Lane | Dudley | Dudley | Warning Letter | N/A | 52.5474844 | -2.0788584 | ||
| 16072 | op-snap---monthly-publication-june-2025.pdf | 2001 | 2025-06 | Pedestrian | Volkswagen | Touran | Grey | Cause vehicle to be left in a dangerous position | None | Grange Road, Moseley | Grange Road, Moseley | Birmingham | Birmingham | Warning Letter | N/A | 52.4335502 | -1.9008154 | ||
| 16078 | op-snap---monthly-publication-june-2025.pdf | 2007 | 2025-06 | Pedestrian | Seat | Ateca | Black | Cause vehicle to be left in a dangerous position | None | Allens Croft | Allens Croft | Birmingham | Birmingham | Warning Letter | N/A | 52.421113 | -1.9142342 | ||
| 16080 | op-snap---monthly-publication-june-2025.pdf | 2009 | 2025-06 | Pedestrian | Kia | Sportage | Black | Cause vehicle to be left in a dangerous position | None | Outside Leckie School, Walsall | Outside Leckie School, Walsall | Walsall | Walsall | Warning Letter | N/A | ||||
| 16081 | op-snap---monthly-publication-june-2025.pdf | 2010 | 2025-06 | Pedestrian | Volkswagen | Crafter | White | Cause vehicle to be left in a dangerous position | None | Greets Green Road | Greets Green Road | Sandwell | Sandwell | Warning Letter | N/A | 52.5204189 | -2.0183456 | ||
| 16086 | op-snap---monthly-publication-june-2025.pdf | 2015 | 2025-06 | Pedestrian | Ford | Focus ST | Blue | Cause vehicle to be left in a dangerous position | None | Maney Corner | Maney Corner | Birmingham | Birmingham | Warning Letter | N/A | 52.5569597 | -1.8263727 | ||
| 16087 | op-snap---monthly-publication-june-2025.pdf | 2016 | 2025-06 | Pedestrian | Land Rover | Defender | Black | Cause vehicle to be left in a dangerous position | None | Sutton Coldfield | Sutton Coldfield | Birmingham | Birmingham | Warning Letter | N/A | 52.5623089 | -1.8239794 | ||
| 16091 | op-snap---monthly-publication-june-2025.pdf | 2020 | 2025-06 | Pedestrian | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.5489715 | -1.9927402 | ||
| 16092 | op-snap---monthly-publication-june-2025.pdf | 2021 | 2025-06 | Pedestrian | Mercedes-Benz | Sprinter | White | Cause vehicle to be left in a dangerous position | None | Crankhall Lane | Crankhall Lane | Sandwell | Sandwell | Warning Letter | N/A | 52.5489715 | -1.9927402 | ||
| 16108 | op-snap---monthly-publication-june-2025.pdf | 2037 | 2025-06 | Pedestrian | Mercedes-Benz | Vito | Black | Cause vehicle to be left in a dangerous position | None | Castle Road East | Castle Road East | Sandwell | Sandwell | Warning Letter | N/A | 52.4687472 | -1.9893922 | ||
| 16109 | op-snap---monthly-publication-june-2025.pdf | 2038 | 2025-06 | Pedestrian | Kia | Sould | White | Cause vehicle to be left in a dangerous position | None | William Shrewsbury Primary School | William Shrewsbury Primary School | Out of Force Area | Out of Force Area | Warning Letter | N/A | ||||
| 16120 | op-snap---monthly-publication-june-2025.pdf | 2049 | 2025-06 | Pedestrian | Ford | Focus | Black | Cause vehicle to be left in a dangerous position | None | Ham Lane | Ham Lane | Dudley | Dudley | Warning Letter | N/A | 52.5092904 | -2.1617173 | ||
| 16139 | op-snap---monthly-publication-june-2025.pdf | 2068 | 2025-06 | Pedestrian | Ford | Ranger | Black | Cause vehicle to be left in a dangerous position | None | Windward Way | Windward Way | Coventry | Coventry | Warning Letter | N/A | ||||
| 16140 | op-snap---monthly-publication-june-2025.pdf | 2069 | 2025-06 | Pedestrian | Honda | civic | Black | Cause vehicle to be left in a dangerous position | None | Apsley Road | Apsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4633793 | -1.9102892 | ||
| 16165 | op-snap---monthly-publication-june-2025.pdf | 2094 | 2025-06 | Pedestrian | Land Rover | Range Rover | Black | Cause vehicle to be left in a dangerous position | None | Oakwood Road | Oakwood Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4458966 | -1.8658543 | ||
| 16168 | op-snap---monthly-publication-june-2025.pdf | 2097 | 2025-06 | Pedestrian | BMW | 320 | White | Cause vehicle to be left in a dangerous position | None | Florence Road | Florence Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5358059 | -1.8289953 | ||
| 16231 | op-snap---monthly-publication-june-2025.pdf | 2160 | 2025-06 | Pedestrian | Citroen | DS3 | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 16235 | op-snap---monthly-publication-june-2025.pdf | 2164 | 2025-06 | Pedestrian | Vauxhall | Vivaro | Yellow | Cause vehicle to be left in a dangerous position | None | Broome Road | Broome Road | Wolverhampton | Wolverhampton | Warning Letter | N/A | 52.6086338 | -2.1185884 | ||
| 16236 | op-snap---monthly-publication-june-2025.pdf | 2165 | 2025-06 | Pedestrian | Rolls-Royce | Ghost | Blue | Cause vehicle to be left in a dangerous position | None | Brimingham Road, Sutton Coldfield | Brimingham Road, Sutton Coldfield | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | ||||
| 16240 | op-snap---monthly-publication-june-2025.pdf | 2169 | 2025-06 | Pedestrian | Mercedes-Benz | C200 | Black | Cause vehicle to be left in a dangerous position | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5361464 | -1.8270283 | ||
| 16241 | op-snap---monthly-publication-june-2025.pdf | 2170 | 2025-06 | Pedestrian | Toyota | Prius | Green | Cause vehicle to be left in a dangerous position | None | Birmingham Road | Birmingham Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.5361464 | -1.8270283 |
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);