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'}
173 rows where month = "2025-06" and offence = "Cause vehicle to be left in a dangerous position" sorted by month descending
This data as json, CSV (advanced)
Suggested facets: vehicle_colour, council_area_raw, nfa_rationale
vehicle_make 26
council_area 10
- Birmingham 109
- Sandwell 19
- Wolverhampton 11
- Dudley 10
- Solihull 7
- Coventry 6
- Sutton Coldfield 5
- Walsall 3
- Out of Force Area 2
- Nostuetr Of Force Area 1
reporter_transport_mode 4
- Pedestrian 94
- Car 62
- Pedal Bike 13
- Other 4
disposal 3
- NFA 109
- Warning Letter 63
- Fixed Penalty 1
offence 1
- Cause vehicle to be left in a dangerous position · 173 ✖
month 1
- 2025-06 · 173 ✖
| 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 | ||
| 14575 | op-snap---monthly-publication-june-2025.pdf | 504 | 2025-06 | Car | Mercedes-Benz | Sprinter | 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 | ||
| 14576 | op-snap---monthly-publication-june-2025.pdf | 505 | 2025-06 | Car | Ford | Galaxy | 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 | ||
| 14578 | op-snap---monthly-publication-june-2025.pdf | 507 | 2025-06 | Car | Mercedes-Benz | GLB 200 | 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 | ||
| 14579 | op-snap---monthly-publication-june-2025.pdf | 508 | 2025-06 | Car | Audi | A3 | 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 | ||
| 14580 | op-snap---monthly-publication-june-2025.pdf | 509 | 2025-06 | Car | Toyota | Yaris | Red | 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 | ||
| 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 | ||
| 14593 | op-snap---monthly-publication-june-2025.pdf | 522 | 2025-06 | Car | Mercedes-Benz | Sprinter | 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 | ||
| 14594 | op-snap---monthly-publication-june-2025.pdf | 523 | 2025-06 | Car | Mercedes-Benz | GLB220 | 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 | ||
| 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 | ||
| 14628 | op-snap---monthly-publication-june-2025.pdf | 557 | 2025-06 | Car | Vauxhall | Astra | Blue | Cause vehicle to be left in a dangerous position | None | Darwin Street | Darwin Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.468128 | -1.8848315 | ||
| 14629 | op-snap---monthly-publication-june-2025.pdf | 558 | 2025-06 | Car | Honda | 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 | |||
| 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 | |||||
| 14640 | op-snap---monthly-publication-june-2025.pdf | 569 | 2025-06 | Car | Ford | Cmax | Silver | 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 | ||
| 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 | ||
| 14652 | op-snap---monthly-publication-june-2025.pdf | 581 | 2025-06 | Pedal Bike | Ford | Transit | White | Cause vehicle to be left in a dangerous position | None | Hallen Drive | Hallen Drive | Sandwell | Sandwell | NFA | Outside of 14 Days NIP | ||||
| 14658 | op-snap---monthly-publication-june-2025.pdf | 587 | 2025-06 | Pedal Bike | Toyota | Auris | White | Cause vehicle to be left in a dangerous position | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4520441 | -1.8787544 | ||
| 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 | ||
| 14964 | op-snap---monthly-publication-june-2025.pdf | 893 | 2025-06 | Pedal Bike | Toyota | Corolla | White | Cause vehicle to be left in a dangerous position | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4693896 | -2.1251602 | ||
| 14965 | op-snap---monthly-publication-june-2025.pdf | 894 | 2025-06 | Pedal Bike | Vauxhall | Astra | Red | Cause vehicle to be left in a dangerous position | None | Gayfield Av | Gayfield Avenue | Dudley | Dudley | NFA | Outside of 14 Days NIP | 52.4693896 | -2.1251602 | ||
| 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 | ||
| 15310 | op-snap---monthly-publication-june-2025.pdf | 1239 | 2025-06 | Pedal Bike | Suzuki | Vitara | Red | Cause vehicle to be left in a dangerous position | None | Suffolk Street Queensway | Suffolk Street Queensway | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4760986 | -1.9018641 | ||
| 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 | ||
| 15321 | op-snap---monthly-publication-june-2025.pdf | 1250 | 2025-06 | Car | Ford | Mondeo | Silver | 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 | ||
| 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 | ||
| 15323 | op-snap---monthly-publication-june-2025.pdf | 1252 | 2025-06 | Car | Seat | Ibiza | Grey | 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 | ||
| 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 | ||
| 15342 | op-snap---monthly-publication-june-2025.pdf | 1271 | 2025-06 | Car | BMW | 218 | Black | Cause vehicle to be left in a dangerous position | None | Old Warwick Road | Old Warwick Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 15344 | op-snap---monthly-publication-june-2025.pdf | 1273 | 2025-06 | Car | Audi | A3 | Black | Cause vehicle to be left in a dangerous position | None | Clive Road / A456 | Clive Road / A456 | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4633336 | -1.9930123 | ||
| 15347 | op-snap---monthly-publication-june-2025.pdf | 1276 | 2025-06 | Pedal Bike | Peugeot | 3008 | Grey | Cause vehicle to be left in a dangerous position | None | Gristhorpe Road | Gristhorpe Road | Birmingham | Birmingham | Warning Letter | N/A | 52.434716 | -1.9254196 | ||
| 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 | ||
| 15393 | op-snap---monthly-publication-june-2025.pdf | 1322 | 2025-06 | Pedal Bike | Toyota | Prius | Black | Cause vehicle to be left in a dangerous position | None | College Road | College Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.5151832 | -1.9361664 | ||
| 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 | ||
| 15411 | op-snap---monthly-publication-june-2025.pdf | 1340 | 2025-06 | Pedal Bike | Peugeot | 3008 | Black | Cause vehicle to be left in a dangerous position | None | Hamstead Road | Hamstead Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.505832 | -1.92002 | ||
| 15420 | op-snap---monthly-publication-june-2025.pdf | 1349 | 2025-06 | Pedal Bike | Land Rover | Range Rover | Grey | Cause vehicle to be left in a dangerous position | None | Ladypool Road | Ladypool Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4520441 | -1.8787544 | ||
| 15425 | op-snap---monthly-publication-june-2025.pdf | 1354 | 2025-06 | Car | Honda | Blue | Cause vehicle to be left in a dangerous position | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | |||
| 15426 | op-snap---monthly-publication-june-2025.pdf | 1355 | 2025-06 | Car | Honda | Blue | Cause vehicle to be left in a dangerous position | None | Stratford Road | Stratford Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4203897 | -1.8338574 | |||
| 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 | ||
| 15439 | op-snap---monthly-publication-june-2025.pdf | 1368 | 2025-06 | Other | Skoda | Yeti | Grey | 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 | ||
| 15756 | op-snap---monthly-publication-june-2025.pdf | 1685 | 2025-06 | Car | Nissan | Qashqai | Black | 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 | ||
| 15758 | op-snap---monthly-publication-june-2025.pdf | 1687 | 2025-06 | Car | Toyota | Corolla | Grey | 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 | ||
| 15766 | op-snap---monthly-publication-june-2025.pdf | 1695 | 2025-06 | Car | Nissan | Qashqai | Blue | Cause vehicle to be left in a dangerous position | None | Sutton Road | Sutton Road | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 DAYS Late Submission | 52.5346721 | -1.827743 | ||
| 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 | ||
| 15779 | op-snap---monthly-publication-june-2025.pdf | 1708 | 2025-06 | Car | Volkswagen | Amarok | Silver | Cause vehicle to be left in a dangerous position | None | Westfield Road | Westfield Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4362187 | -1.8987821 | ||
| 15780 | op-snap---monthly-publication-june-2025.pdf | 1709 | 2025-06 | Car | Audi | A3 | White | Cause vehicle to be left in a dangerous position | None | Asheville Avenue | Asheville Avenue | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | ||||
| 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 | ||
| 15811 | op-snap---monthly-publication-june-2025.pdf | 1740 | 2025-06 | Car | Mercedes-Benz | EQA 250 | Grey | Cause vehicle to be left in a dangerous position | None | Little Sutton Lane | Little Sutton Lane | Sutton Coldfield | Sutton Coldfield | NFA | Outside of 14 DAYS Late Submission | 52.584913 | -1.8197066 | ||
| 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 | |||||
| 15818 | op-snap---monthly-publication-june-2025.pdf | 1747 | 2025-06 | Car | Vauxhall | Beige | Cause vehicle to be left in a dangerous position | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4762784 | -1.9678366 | |||
| 15819 | op-snap---monthly-publication-june-2025.pdf | 1748 | 2025-06 | Car | BMW | Blue | Cause vehicle to be left in a dangerous position | None | Bearwood Road | Bearwood Road | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.4762784 | -1.9678366 | |||
| 15821 | op-snap---monthly-publication-june-2025.pdf | 1750 | 2025-06 | Car | Ford | Ka | White | Cause vehicle to be left in a dangerous position | None | Birmingham New Road | Birmingham New Road | Wolverhampton | Wolverhampton | NFA | No Offence | 52.5560698 | -2.1044322 | ||
| 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 | ||
| 15835 | op-snap---monthly-publication-june-2025.pdf | 1764 | 2025-06 | Car | Toyota | Auris | 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 | ||
| 15836 | op-snap---monthly-publication-june-2025.pdf | 1765 | 2025-06 | Car | Nissan | GT R | 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 | ||
| 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 | ||
| 15930 | op-snap---monthly-publication-june-2025.pdf | 1859 | 2025-06 | Other | Ford | Transit | White | 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 | ||
| 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 | ||
| 15933 | op-snap---monthly-publication-june-2025.pdf | 1862 | 2025-06 | Other | Toyota | Corolla | 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 | ||
| 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 | ||
| 15958 | op-snap---monthly-publication-june-2025.pdf | 1887 | 2025-06 | Other | 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 | ||
| 15959 | op-snap---monthly-publication-june-2025.pdf | 1888 | 2025-06 | Car | Skoda | Kamiq | White | 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 | ||
| 15982 | op-snap---monthly-publication-june-2025.pdf | 1911 | 2025-06 | Car | Peugeot | Horizon | Grey | Cause vehicle to be left in a dangerous position | None | Darwin St | Darwin Street | Birmingham | Birmingham | NFA | Outside of 14 Days NIP | 52.468128 | -1.8848315 | ||
| 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 |
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);