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'}
161 rows where disposal = "Warning Letter", month = "2025-07" 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
vehicle_make 26
council_area 7
- Birmingham 113
- Coventry 13
- Dudley 13
- Walsall 9
- Solihull 6
- Sutton Coldfield 4
- Wolverhampton 3
reporter_transport_mode 4
- Pedestrian 98
- Car 46
- Pedal Bike 11
- Other 6
offence 1
- Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 161 ✖
month 1
- 2025-07 · 161 ✖
disposal 1
- Warning Letter · 161 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12159 | op-snap---monthly-publication-july-2025.pdf | 211 | 2025-07 | Other | Daf | Dennis | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | High Street, Kings Heath | High Street, Kings Heath | Birmingham | Birmingham | Warning Letter | N/A | 52.4353506 | -1.8927483 | ||
| 12332 | op-snap---monthly-publication-july-2025.pdf | 384 | 2025-07 | Car | BMW | 730d | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Walsall Road | Walsall Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5919543 | -1.8517118 | ||
| 12785 | op-snap---monthly-publication-july-2025.pdf | 837 | 2025-07 | Pedestrian | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Petersfield Road | Petersfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4307 | -1.8494663 | ||
| 13360 | op-snap---monthly-publication-july-2025.pdf | 1412 | 2025-07 | Pedestrian | Land Rover | Evouque | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Brewery Street | Brewery Street | Birmingham | Birmingham | Warning Letter | N/A | 52.503835 | -1.9471019 | ||
| 13361 | op-snap---monthly-publication-july-2025.pdf | 1413 | 2025-07 | Pedal Bike | Land Rover | SVR | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Edgbaston Street | Edgbaston Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4764509 | -1.8958723 | ||
| 13363 | op-snap---monthly-publication-july-2025.pdf | 1415 | 2025-07 | Pedestrian | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Acocks Green | Acocks Green | Birmingham | Birmingham | Warning Letter | N/A | 52.449547 | -1.8192198 | ||
| 13364 | op-snap---monthly-publication-july-2025.pdf | 1416 | 2025-07 | Pedestrian | Hyundai | Tucson | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Acocks Green | Acocks Green | Birmingham | Birmingham | Warning Letter | N/A | 52.449547 | -1.8192198 | ||
| 13366 | op-snap---monthly-publication-july-2025.pdf | 1418 | 2025-07 | Pedestrian | Vauxhall | corsa | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Startford road | Startford road | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13367 | op-snap---monthly-publication-july-2025.pdf | 1419 | 2025-07 | Pedestrian | Audi | A5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 13368 | op-snap---monthly-publication-july-2025.pdf | 1420 | 2025-07 | Pedestrian | Ford | Tourne | Beige | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 13369 | op-snap---monthly-publication-july-2025.pdf | 1421 | 2025-07 | Pedestrian | Vauxhall | grandland | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 13370 | op-snap---monthly-publication-july-2025.pdf | 1422 | 2025-07 | Pedestrian | Ford | Fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Highbury Pakr | Highbury Pakr | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13371 | op-snap---monthly-publication-july-2025.pdf | 1423 | 2025-07 | Pedestrian | Audi | A4 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Worcester Lane | Worcester Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.5994728 | -1.8113342 | ||
| 13372 | op-snap---monthly-publication-july-2025.pdf | 1424 | 2025-07 | Pedestrian | Renault | Captur | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Lincoln Road | Lincoln Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4438344 | -1.810878 | ||
| 13373 | op-snap---monthly-publication-july-2025.pdf | 1425 | 2025-07 | Car | Skoda | Ocatavia | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Darwin Street | Darwin Street | Birmingham | Birmingham | Warning Letter | N/A | 52.468128 | -1.8848315 | ||
| 13374 | op-snap---monthly-publication-july-2025.pdf | 1426 | 2025-07 | Car | Renault | Kadjar | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Valentine road | Valentine road | Birmingham | Birmingham | Warning Letter | N/A | 52.4381959 | -1.8907391 | ||
| 13375 | op-snap---monthly-publication-july-2025.pdf | 1427 | 2025-07 | Car | Mercedes-Benz | SLK 200 | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oak Park Road | Oak Park Road | Walsall | Walsall | Warning Letter | N/A | 52.6322981 | -1.9294669 | ||
| 13376 | op-snap---monthly-publication-july-2025.pdf | 1428 | 2025-07 | Car | Volkswagen | CC | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Oak Park Road | Oak Park Road | Walsall | Walsall | Warning Letter | N/A | 52.6322981 | -1.9294669 | ||
| 13377 | op-snap---monthly-publication-july-2025.pdf | 1429 | 2025-07 | Other | Land Rover | Evoque | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13378 | op-snap---monthly-publication-july-2025.pdf | 1430 | 2025-07 | Other | Volkswagen | Tiguan | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13379 | op-snap---monthly-publication-july-2025.pdf | 1431 | 2025-07 | Pedestrian | Mercedes-Benz | Luton Van | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dudley Road | Dudley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4865107 | -1.9386263 | ||
| 13380 | op-snap---monthly-publication-july-2025.pdf | 1432 | 2025-07 | Pedestrian | Vauxhall | Corsa | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13381 | op-snap---monthly-publication-july-2025.pdf | 1433 | 2025-07 | Pedestrian | Mazda | 5 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Appleton Avenue | Appleton Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13385 | op-snap---monthly-publication-july-2025.pdf | 1437 | 2025-07 | Pedal Bike | Toyota | Hilux | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13386 | op-snap---monthly-publication-july-2025.pdf | 1438 | 2025-07 | Pedestrian | Honda | CRV | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Croftdown road | Croftdown road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613299 | -1.9748385 | ||
| 13388 | op-snap---monthly-publication-july-2025.pdf | 1440 | 2025-07 | Pedestrian | Mercedes-Benz | c200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Croftdown Road | Croftdown Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4613299 | -1.9748385 | ||
| 13389 | op-snap---monthly-publication-july-2025.pdf | 1441 | 2025-07 | Pedestrian | Mercedes-Benz | GLE400 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13391 | op-snap---monthly-publication-july-2025.pdf | 1443 | 2025-07 | Pedestrian | Skoda | octavia | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley road | Barnsley road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13392 | op-snap---monthly-publication-july-2025.pdf | 1444 | 2025-07 | Pedestrian | Audi | Q7 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13393 | op-snap---monthly-publication-july-2025.pdf | 1445 | 2025-07 | Pedestrian | Mercedes-Benz | GLE400 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13394 | op-snap---monthly-publication-july-2025.pdf | 1446 | 2025-07 | Pedestrian | Nissan | Qashqai | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13395 | op-snap---monthly-publication-july-2025.pdf | 1447 | 2025-07 | Pedestrian | Porsche | Panamera | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13396 | op-snap---monthly-publication-july-2025.pdf | 1448 | 2025-07 | Pedestrian | BMW | X5 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13397 | op-snap---monthly-publication-july-2025.pdf | 1449 | 2025-07 | Pedestrian | Audi | A6 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13398 | op-snap---monthly-publication-july-2025.pdf | 1450 | 2025-07 | Pedestrian | Land Rover | Sport | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13399 | op-snap---monthly-publication-july-2025.pdf | 1451 | 2025-07 | Pedestrian | BMW | 320D | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13400 | op-snap---monthly-publication-july-2025.pdf | 1452 | 2025-07 | Pedestrian | Citroen | C1 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Raod | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13409 | op-snap---monthly-publication-july-2025.pdf | 1461 | 2025-07 | Pedal Bike | Audi | a3 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Duncroft Avenue | Duncroft Avenue | Coventry | Coventry | Warning Letter | N/A | 52.4285538 | -1.5345395 | ||
| 13412 | op-snap---monthly-publication-july-2025.pdf | 1464 | 2025-07 | Pedestrian | Citroen | DS3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holland Road | Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5568516 | -1.8248341 | ||
| 13415 | op-snap---monthly-publication-july-2025.pdf | 1467 | 2025-07 | Pedestrian | Ford | ranger | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Ganton Road | Ganton Road | Walsall | Walsall | Warning Letter | N/A | 52.6293068 | -2.0106252 | ||
| 13417 | op-snap---monthly-publication-july-2025.pdf | 1469 | 2025-07 | Pedestrian | Hyundai | Ionic | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13418 | op-snap---monthly-publication-july-2025.pdf | 1470 | 2025-07 | Pedestrian | Audi | A3 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13420 | op-snap---monthly-publication-july-2025.pdf | 1472 | 2025-07 | Pedestrian | Peugeot | 2008 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Barnsley Road | Barnsley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4743497 | -1.965737 | ||
| 13423 | op-snap---monthly-publication-july-2025.pdf | 1475 | 2025-07 | Pedestrian | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Hagley Road | Hagley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.471632 | -1.9456776 | ||
| 13427 | op-snap---monthly-publication-july-2025.pdf | 1479 | 2025-07 | Pedestrian | Peugeot | 208 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holland Road | Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5568516 | -1.8248341 | ||
| 13428 | op-snap---monthly-publication-july-2025.pdf | 1480 | 2025-07 | Pedestrian | Renault | capture | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Appleton Avenue | Appleton Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13429 | op-snap---monthly-publication-july-2025.pdf | 1481 | 2025-07 | Pedestrian | Mg | ZS | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Appleton Avenue | Appleton Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13430 | op-snap---monthly-publication-july-2025.pdf | 1482 | 2025-07 | Pedestrian | Toyota | Yaris | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Appleton Avenue | Appleton Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13431 | op-snap---monthly-publication-july-2025.pdf | 1483 | 2025-07 | Pedestrian | Mercedes-Benz | E200 | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Appleton Avenue | Appleton Avenue | Birmingham | Birmingham | Warning Letter | N/A | ||||
| 13436 | op-snap---monthly-publication-july-2025.pdf | 1488 | 2025-07 | Pedestrian | Cupra | seat | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Warwick Road | Warwick Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4555288 | -1.8613929 | ||
| 13440 | op-snap---monthly-publication-july-2025.pdf | 1492 | 2025-07 | Pedestrian | Renault | Clio | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glen Rise | Glen Rise | Birmingham | Birmingham | Warning Letter | N/A | 52.425244 | -1.8620426 | ||
| 13442 | op-snap---monthly-publication-july-2025.pdf | 1494 | 2025-07 | Pedestrian | Chevrolet | Orlando | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3848122 | -1.5204351 | ||
| 13443 | op-snap---monthly-publication-july-2025.pdf | 1495 | 2025-07 | Pedestrian | Hyundai | I20 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dewsbury Avenue | Dewsbury Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3848122 | -1.5204351 | ||
| 13447 | op-snap---monthly-publication-july-2025.pdf | 1499 | 2025-07 | Car | Peugeot | 308 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath road | Washwood Heath road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 13448 | op-snap---monthly-publication-july-2025.pdf | 1500 | 2025-07 | Car | Ford | transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 13449 | op-snap---monthly-publication-july-2025.pdf | 1501 | 2025-07 | Car | Toyota | Yaris | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | washwood heath road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 13450 | op-snap---monthly-publication-july-2025.pdf | 1502 | 2025-07 | Car | Toyota | RAV4 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Washwood Heath Road | Washwood Heath Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4929304 | -1.8229092 | ||
| 13451 | op-snap---monthly-publication-july-2025.pdf | 1503 | 2025-07 | Pedestrian | Skoda | Kodiaq | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Parkgate Road | Parkgate Road | Coventry | Coventry | Warning Letter | N/A | 52.445796 | -1.5148141 | ||
| 13452 | op-snap---monthly-publication-july-2025.pdf | 1504 | 2025-07 | Pedestrian | BMW | 520D | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Green Road | Green Road | Birmingham | Birmingham | Warning Letter | N/A | 52.436871 | -1.8592799 | ||
| 13453 | op-snap---monthly-publication-july-2025.pdf | 1505 | 2025-07 | Other | Ford | focus | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13454 | op-snap---monthly-publication-july-2025.pdf | 1506 | 2025-07 | Other | Toyota | Prius | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13455 | op-snap---monthly-publication-july-2025.pdf | 1507 | 2025-07 | Other | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Glenville Drive | Glenville Drive | Birmingham | Birmingham | Warning Letter | N/A | 52.5265939 | -1.8509884 | ||
| 13456 | op-snap---monthly-publication-july-2025.pdf | 1508 | 2025-07 | Pedestrian | BMW | 118D | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Mitchell Avenue | Mitchell Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3940834 | -1.5696642 | ||
| 13459 | op-snap---monthly-publication-july-2025.pdf | 1511 | 2025-07 | Pedestrian | Nissan | Juke | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Station Road | Station Road | Solihull | Solihull | Warning Letter | N/A | 52.3927253 | -1.6455823 | ||
| 13461 | op-snap---monthly-publication-july-2025.pdf | 1513 | 2025-07 | Pedestrian | Honda | CRV | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | florence Road | florence Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5358059 | -1.8289953 | ||
| 13462 | op-snap---monthly-publication-july-2025.pdf | 1514 | 2025-07 | Pedestrian | Ford | Transit | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stream Road | Stream Road | Dudley | Dudley | Warning Letter | N/A | 52.4871725 | -2.1623764 | ||
| 13465 | op-snap---monthly-publication-july-2025.pdf | 1517 | 2025-07 | Car | Volkswagen | Polo | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5065077 | -1.892207 | ||
| 13466 | op-snap---monthly-publication-july-2025.pdf | 1518 | 2025-07 | Car | Hyundai | Tucson | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5065077 | -1.892207 | ||
| 13467 | op-snap---monthly-publication-july-2025.pdf | 1519 | 2025-07 | Car | Audi | Etron | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5065077 | -1.892207 | ||
| 13472 | op-snap---monthly-publication-july-2025.pdf | 1524 | 2025-07 | Pedestrian | Mercedes-Benz | CLA35 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bassetts Pole Road | Bassetts Pole Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | ||||
| 13474 | op-snap---monthly-publication-july-2025.pdf | 1526 | 2025-07 | Pedestrian | Volkswagen | Passat | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Broadway North | Broadway North | Walsall | Walsall | Warning Letter | N/A | 52.5886007 | -1.9741222 | ||
| 13477 | op-snap---monthly-publication-july-2025.pdf | 1529 | 2025-07 | Pedestrian | Peugeot | 208 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Holland Road | Holland Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5568516 | -1.8248341 | ||
| 13478 | op-snap---monthly-publication-july-2025.pdf | 1530 | 2025-07 | Pedestrian | Seat | Arona | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Dunsmore Avenue | Dunsmore Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3855553 | -1.4659743 | ||
| 13481 | op-snap---monthly-publication-july-2025.pdf | 1533 | 2025-07 | Pedestrian | Volkswagen | Polo | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Upper Holland Road | Upper Holland Road | Sutton Coldfield | Sutton Coldfield | Warning Letter | N/A | 52.561 | -1.8187105 | ||
| 13486 | op-snap---monthly-publication-july-2025.pdf | 1538 | 2025-07 | Pedestrian | Nissan | Qashqai | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Monastery Drive | Monastery Drive | Solihull | Solihull | Warning Letter | N/A | 52.4247635 | -1.8069503 | ||
| 13488 | op-snap---monthly-publication-july-2025.pdf | 1540 | 2025-07 | Pedestrian | Volkswagen | Polo | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Grange Road | Grange Road | Solihull | Solihull | Warning Letter | N/A | 52.4285724 | -1.8019101 | ||
| 13491 | op-snap---monthly-publication-july-2025.pdf | 1543 | 2025-07 | Pedestrian | Vauxhall | Astra | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Colmore Road | Colmore Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4296373 | -1.8993161 | ||
| 13494 | op-snap---monthly-publication-july-2025.pdf | 1546 | 2025-07 | Pedestrian | Skoda | Kamiq | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Institute road | Institute road | Birmingham | Birmingham | Warning Letter | N/A | 52.4334781 | -1.8892337 | ||
| 13497 | op-snap---monthly-publication-july-2025.pdf | 1549 | 2025-07 | Pedestrian | Peugeot | 3008 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Selly oak Road | Selly oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263875 | -1.9397954 | ||
| 13498 | op-snap---monthly-publication-july-2025.pdf | 1550 | 2025-07 | Pedestrian | Toyota | Yaris | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Belchers Lane | Belchers Lane | Birmingham | Birmingham | Warning Letter | N/A | 52.4800061 | -1.833007 | ||
| 13499 | op-snap---monthly-publication-july-2025.pdf | 1551 | 2025-07 | Pedestrian | BMW | 118D | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13500 | op-snap---monthly-publication-july-2025.pdf | 1552 | 2025-07 | Pedestrian | Toyota | Prius | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13501 | op-snap---monthly-publication-july-2025.pdf | 1553 | 2025-07 | Pedestrian | BMW | 330E | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13502 | op-snap---monthly-publication-july-2025.pdf | 1554 | 2025-07 | Pedestrian | Peugeot | 3008 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13503 | op-snap---monthly-publication-july-2025.pdf | 1555 | 2025-07 | Pedestrian | Kia | Sportage | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Welstead Road | Welstead Road | Walsall | Walsall | Warning Letter | N/A | ||||
| 13505 | op-snap---monthly-publication-july-2025.pdf | 1557 | 2025-07 | Pedestrian | Mercedes-Benz | C220 | Red | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | none | Shirley Road | Shirley Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4198291 | -1.9241732 | ||
| 13509 | op-snap---monthly-publication-july-2025.pdf | 1561 | 2025-07 | Car | Ford | fiesta | Silver | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | selly oak road | Selly Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263875 | -1.9397954 | ||
| 13511 | op-snap---monthly-publication-july-2025.pdf | 1563 | 2025-07 | Car | Audi | A4 | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | selly oak road | Selly Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263875 | -1.9397954 | ||
| 13512 | op-snap---monthly-publication-july-2025.pdf | 1564 | 2025-07 | Car | Nissan | Qashqai | Blue | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | selly oak road | Selly Oak Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4263875 | -1.9397954 | ||
| 13513 | op-snap---monthly-publication-july-2025.pdf | 1565 | 2025-07 | Pedal Bike | Seat | Leon | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Horseley heath | Horseley heath | Dudley | Dudley | Warning Letter | N/A | 52.525777 | -2.0464686 | ||
| 13514 | op-snap---monthly-publication-july-2025.pdf | 1566 | 2025-07 | Pedal Bike | Ford | focus | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Gayfield Avenue | Gayfield Avenue | Dudley | Dudley | Warning Letter | N/A | 52.4693896 | -2.1251602 | ||
| 13515 | op-snap---monthly-publication-july-2025.pdf | 1567 | 2025-07 | Pedestrian | Nissan | Duke | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Charter Avenue | Charter Avenue | Coventry | Coventry | Warning Letter | N/A | 52.3928409 | -1.5888076 | ||
| 13516 | op-snap---monthly-publication-july-2025.pdf | 1568 | 2025-07 | Pedestrian | Audi | A5 | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Stratford Road | Stratford Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4203897 | -1.8338574 | ||
| 13517 | op-snap---monthly-publication-july-2025.pdf | 1569 | 2025-07 | Pedestrian | Toyota | Auris | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5154198 | -1.9135452 | ||
| 13518 | op-snap---monthly-publication-july-2025.pdf | 1570 | 2025-07 | Pedestrian | Nissan | Micra | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Howard Road | Howard Road | Birmingham | Birmingham | Warning Letter | N/A | 52.5154198 | -1.9135452 | ||
| 13519 | op-snap---monthly-publication-july-2025.pdf | 1571 | 2025-07 | Pedestrian | Vauxhall | corsa | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | dudley road | Dudley Road | Dudley | Dudley | Warning Letter | N/A | 52.4881161 | -2.1199108 | ||
| 13520 | op-snap---monthly-publication-july-2025.pdf | 1572 | 2025-07 | Pedal Bike | BMW | 318D | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 13522 | op-snap---monthly-publication-july-2025.pdf | 1574 | 2025-07 | Pedal Bike | BMW | 318I | Black | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Bradford Street | Bradford Street | Birmingham | Birmingham | Warning Letter | N/A | 52.4708802 | -1.8792135 | ||
| 13523 | op-snap---monthly-publication-july-2025.pdf | 1575 | 2025-07 | Pedestrian | Audi | a6 | Grey | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | None | Castle Road East | Castle Road East | Wolverhampton | Wolverhampton | Warning Letter | N/A | ||||
| 13524 | op-snap---monthly-publication-july-2025.pdf | 1576 | 2025-07 | Pedestrian | Ford | Transit | White | Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area | No Insurance | Springfield Road | Springfield Road | Birmingham | Birmingham | Warning Letter | N/A | 52.4327486 | -1.8844997 |
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);