reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

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'}

201 rows where month = "2025-07", offence = "Cause vehicle to be left in a dangerous position" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Car · 201 ✖

offence 1

  • Cause vehicle to be left in a dangerous position · 201 ✖

month 1

  • 2025-07 · 201 ✖
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
12819 op-snap---monthly-publication-july-2025.pdf   871 2025-07 Car Toyota   White Cause vehicle to be left in a dangerous position None JUnction of Hertford Way / Balkwill Cl JUnction of Hertford Way / Balkwill Cl oBsierm ,i nBgirhmaimngham Obsierm ,I Nbgirhmaimngham NFA Out of Force      
12834 op-snap---monthly-publication-july-2025.pdf   886 2025-07 Car BMW   Black Cause vehicle to be left in a dangerous position None Outside Q E Hospital , Birmingham Outside Q E Hospital , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
12835 op-snap---monthly-publication-july-2025.pdf   887 2025-07 Car   NP White Cause vehicle to be left in a dangerous position None Measham Way , Wolverhampton Measham Way , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6105321 -2.0716593
12840 op-snap---monthly-publication-july-2025.pdf   892 2025-07 Car Mitsubishi   Silver Cause vehicle to be left in a dangerous position None Washwood Heath Road , Washwood Washwood Heath Road , Washwood HBeiramthingham Hbeiramthingham NFA Outside of 14 Days NIP   52.4929304 -1.8229092
12841 op-snap---monthly-publication-july-2025.pdf   893 2025-07 Car BMW   Grey Cause vehicle to be left in a dangerous position None Washwood Heath Road , Washwood Washwood Heath Road , Washwood HBeiramthingham Hbeiramthingham NFA Outside of 14 Days NIP   52.4929304 -1.8229092
12843 op-snap---monthly-publication-july-2025.pdf   895 2025-07 Car Mitsubishi   White Cause vehicle to be left in a dangerous position None Lozells Road , Birmingham Lozells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
12844 op-snap---monthly-publication-july-2025.pdf   896 2025-07 Car Honda   Grey Cause vehicle to be left in a dangerous position None LOzells Road , Birmingham LOzells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
12845 op-snap---monthly-publication-july-2025.pdf   897 2025-07 Car Honda Civic Blue Cause vehicle to be left in a dangerous position None Witton Road , Birmingham Witton Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12859 op-snap---monthly-publication-july-2025.pdf   911 2025-07 Car Hyundai i30 Blue Cause vehicle to be left in a dangerous position None Witton Road , Birmingham Witton Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12860 op-snap---monthly-publication-july-2025.pdf   912 2025-07 Car Vauxhall Astra Grey Cause vehicle to be left in a dangerous position None New street , Birmingham New street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4793544 -1.9010661
12867 op-snap---monthly-publication-july-2025.pdf   919 2025-07 Car BMW E Drive 40 Grey Cause vehicle to be left in a dangerous position None New Street , Birmingham New Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4793544 -1.9010661
12964 op-snap---monthly-publication-july-2025.pdf   1016 2025-07 Car   NP Lilac   Cause vehicle to be left in a dangerous position None Dorridge ( Opposite Sainsburys ) Dorridge ( Opposite Sainsburys ) Solihull Solihull NFA Outside of 14 Days NIP      
12968 op-snap---monthly-publication-july-2025.pdf   1020 2025-07 Car Volkswagen Tourag White Cause vehicle to be left in a dangerous position None Pope Road , Wolverhampton Pope Road , Wolverhampton Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.6162266 -2.0979326
13051 op-snap---monthly-publication-july-2025.pdf   1103 2025-07 Car Mercedes-Benz Sprinter Red Cause vehicle to be left in a dangerous position None A454 Little Aston Road Little Aston Road Birmingham Birmingham Education N/A      
13094 op-snap---monthly-publication-july-2025.pdf   1146 2025-07 Car Mercedes-Benz Sprinter White Cause vehicle to be left in a dangerous position None Rushey Lane , Tyseley Rushey Lane , Tyseley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4535634 -1.8325696
13099 op-snap---monthly-publication-july-2025.pdf   1151 2025-07 Car Nissan   Silver Cause vehicle to be left in a dangerous position None Lozells STreet , Birmingham Lozells STreet , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5007454 -1.9067107
13131 op-snap---monthly-publication-july-2025.pdf   1183 2025-07 Car Vauxhall   White Cause vehicle to be left in a dangerous position None Reddings Lane Reddings Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4506039 -1.8463952
13144 op-snap---monthly-publication-july-2025.pdf   1196 2025-07 Car Honda CRV Silver Cause vehicle to be left in a dangerous position None Greswolde Road , Sparkhill Greswolde Road , Sparkhill Birmingham Birmingham NFA Outside of 14 Days NIP      
13146 op-snap---monthly-publication-july-2025.pdf   1198 2025-07 Car   N/P Black Cause vehicle to be left in a dangerous position None Icknield Port Road , Ladywood Icknield Port Road , Ladywood Solihull Solihull NFA Outside of 14 Days NIP      
13148 op-snap---monthly-publication-july-2025.pdf   1200 2025-07 Car Nissan Qashqai Black Cause vehicle to be left in a dangerous position None Avon Street , Birmingham Avon Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4556565 -1.8643304
13149 op-snap---monthly-publication-july-2025.pdf   1201 2025-07 Car BMW 320 i White Cause vehicle to be left in a dangerous position None St Joesphs Avenue , Northfield Street Joesphs Avenue , Northfield Birmingham Birmingham NFA Outside of 14 Days NIP      
13151 op-snap---monthly-publication-july-2025.pdf   1203 2025-07 Car Volkswagen Passat Grey Cause vehicle to be left in a dangerous position None Lozells Road , Birmingham Lozells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
13152 op-snap---monthly-publication-july-2025.pdf   1204 2025-07 Car Toyota Hiace White Cause vehicle to be left in a dangerous position None LOzells Road , Birmingham LOzells Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5025035 -1.8998926
13258 op-snap---monthly-publication-july-2025.pdf   1310 2025-07 Car Renault clio White Cause vehicle to be left in a dangerous position None Fulham Road Fulham Road Birmingham Birmingham Warning Letter N/A   52.4561743 -1.8694787
13260 op-snap---monthly-publication-july-2025.pdf   1312 2025-07 Car Volvo XC60 Grey Cause vehicle to be left in a dangerous position None Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
13261 op-snap---monthly-publication-july-2025.pdf   1313 2025-07 Car Volkswagen T-Roc Grey Cause vehicle to be left in a dangerous position None Roberts St Roberts Street Dudley Dudley Warning Letter N/A   52.5213135 -2.1197042
13262 op-snap---monthly-publication-july-2025.pdf   1314 2025-07 Car Audi Q2 Grey Cause vehicle to be left in a dangerous position None Olton Boulevard Olton Boulevard Birmingham Birmingham Warning Letter N/A   52.443439 -1.8180486
13263 op-snap---monthly-publication-july-2025.pdf   1315 2025-07 Car BMW 320D Silver Cause vehicle to be left in a dangerous position None Olton Boulevard Olton Boulevard Birmingham Birmingham Warning Letter N/A   52.443439 -1.8180486
13264 op-snap---monthly-publication-july-2025.pdf   1316 2025-07 Car Mercedes-Benz C200 White Cause vehicle to be left in a dangerous position None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Warning Letter N/A   52.4418944 -1.8407335
13266 op-snap---monthly-publication-july-2025.pdf   1318 2025-07 Car Mercedes-Benz C63 Black Cause vehicle to be left in a dangerous position None Moseley Rd Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
13267 op-snap---monthly-publication-july-2025.pdf   1319 2025-07 Car Mercedes-Benz GLA Black Cause vehicle to be left in a dangerous position None Moseley Rd Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
13268 op-snap---monthly-publication-july-2025.pdf   1320 2025-07 Car Mercedes-Benz S350 black Cause vehicle to be left in a dangerous position None Moseley Rd Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
13270 op-snap---monthly-publication-july-2025.pdf   1322 2025-07 Car BMW 420D White Cause vehicle to be left in a dangerous position None Moseley Rd Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
13272 op-snap---monthly-publication-july-2025.pdf   1324 2025-07 Car Toyota C-HR Grey Cause vehicle to be left in a dangerous position None Colville Road Colville Road Birmingham Birmingham Warning Letter N/A   52.4569997 -1.8758405
13273 op-snap---monthly-publication-july-2025.pdf   1325 2025-07 Car Land Rover Velar Black Cause vehicle to be left in a dangerous position None Overdale Road Overdale Road Birmingham Birmingham Warning Letter N/A   52.4540128 -1.9850912
13278 op-snap---monthly-publication-july-2025.pdf   1330 2025-07 Car Ford Fiesta Blue Cause vehicle to be left in a dangerous position None Sevendwellings View Sevendwellings View Dudley Dudley Warning Letter N/A   52.4740529 -2.1270111
13279 op-snap---monthly-publication-july-2025.pdf   1331 2025-07 Car Porsche Taycan Red Cause vehicle to be left in a dangerous position None Tetenhall High Street Tettenhall High Street Wolverhampton Wolverhampton Warning Letter N/A   52.598292 -2.1677123
13280 op-snap---monthly-publication-july-2025.pdf   1332 2025-07 Car Peugeot 208 White Cause vehicle to be left in a dangerous position None Long Mill South Long Mill South Wolverhampton Wolverhampton Warning Letter N/A   52.6095019 -2.0915196
13294 op-snap---monthly-publication-july-2025.pdf   1346 2025-07 Car Honda Civic Silver Cause vehicle to be left in a dangerous position None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
13295 op-snap---monthly-publication-july-2025.pdf   1347 2025-07 Car Honda Civic Black Cause vehicle to be left in a dangerous position None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
13296 op-snap---monthly-publication-july-2025.pdf   1348 2025-07 Car Toyota Prius White Cause vehicle to be left in a dangerous position None stratford road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
13297 op-snap---monthly-publication-july-2025.pdf   1349 2025-07 Car Skoda Fabia Grey Cause vehicle to be left in a dangerous position None High street, Tetenhall High street, Tetenhall Wolverhampton Wolverhampton Warning Letter N/A      
13302 op-snap---monthly-publication-july-2025.pdf   1354 2025-07 Car Ford Mondeo Green Cause vehicle to be left in a dangerous position None Castle Road West Castle Road West Sandwell Sandwell Warning Letter N/A   52.4686934 -1.9974957
13303 op-snap---monthly-publication-july-2025.pdf   1355 2025-07 Car Volkswagen Polo Black Cause vehicle to be left in a dangerous position None Pershore Road, Stirchley Pershore Road, Stirchley Birmingham Birmingham Warning Letter N/A   52.4274734 -1.9223167
13315 op-snap---monthly-publication-july-2025.pdf   1367 2025-07 Car Toyota Corolla Grey Cause vehicle to be left in a dangerous position None Roberts Street Roberts Street Sandwell Sandwell Warning Letter N/A      
13317 op-snap---monthly-publication-july-2025.pdf   1369 2025-07 Car Vauxhall Mokka Red Cause vehicle to be left in a dangerous position None Roberts Street Roberts Street Sandwell Sandwell Warning Letter N/A      
13318 op-snap---monthly-publication-july-2025.pdf   1370 2025-07 Car Vauxhall Corsa Silver Cause vehicle to be left in a dangerous position None High Street, Tetenhall High Street, Tetenhall Wolverhampton Wolverhampton Warning Letter N/A      
13320 op-snap---monthly-publication-july-2025.pdf   1372 2025-07 Car Audi A3 Silver Cause vehicle to be left in a dangerous position None Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
13331 op-snap---monthly-publication-july-2025.pdf   1383 2025-07 Car BMW X5 Black Cause vehicle to be left in a dangerous position None Alexandra Road Alexandra Road Walsall Walsall Warning Letter N/A   52.5710317 -1.9827085
13332 op-snap---monthly-publication-july-2025.pdf   1384 2025-07 Car Toyota avensis White Cause vehicle to be left in a dangerous position none Churchill Road Churchill Road Birmingham Birmingham Warning Letter N/A   52.5529597 -1.8615015
13337 op-snap---monthly-publication-july-2025.pdf   1389 2025-07 Car BMW 116D White Cause vehicle to be left in a dangerous position None Ellesmere Road Ellesmere Road Birmingham Birmingham Warning Letter N/A   52.4881533 -1.8553625
13340 op-snap---monthly-publication-july-2025.pdf   1392 2025-07 Car Toyota   White Cause vehicle to be left in a dangerous position None Broad Street Broad Street Birmingham Birmingham Warning Letter N/A   52.4749212 -1.9147497
13341 op-snap---monthly-publication-july-2025.pdf   1393 2025-07 Car Toyota Yaris Silver Cause vehicle to be left in a dangerous position None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
13342 op-snap---monthly-publication-july-2025.pdf   1394 2025-07 Car Toyota Prius Silver Cause vehicle to be left in a dangerous position None Earlsdon Street Earlsdon Street Coventry Coventry Warning Letter N/A   52.3988977 -1.5323674
13345 op-snap---monthly-publication-july-2025.pdf   1397 2025-07 Car Land Rover Velar Black Cause vehicle to be left in a dangerous position None Overdale Road Overdale Road Halesowen Halesowen Warning Letter N/A   52.4540128 -1.9850912
13350 op-snap---monthly-publication-july-2025.pdf   1402 2025-07 Car Volkswagen Golf Blue Cause vehicle to be left in a dangerous position None Constitution Hill Constitution Hill Birmingham Birmingham Warning Letter N/A   52.4866022 -1.901562
13351 op-snap---monthly-publication-july-2025.pdf   1403 2025-07 Car Tesla Model Y White Cause vehicle to be left in a dangerous position None Monastery Drive Monastery Drive Solihull Solihull Warning Letter N/A   52.4247635 -1.8069503
13352 op-snap---monthly-publication-july-2025.pdf   1404 2025-07 Car Dacia BK25KFY Grey Cause vehicle to be left in a dangerous position None Darwin Street Darwin Street Birmingham Birmingham Warning Letter N/A   52.468128 -1.8848315
13353 op-snap---monthly-publication-july-2025.pdf   1405 2025-07 Car Seat Ibiza Blue Cause vehicle to be left in a dangerous position None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Warning Letter N/A   52.473883 -1.9198244
13355 op-snap---monthly-publication-july-2025.pdf   1407 2025-07 Car Ford Puma Grey 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
13437 op-snap---monthly-publication-july-2025.pdf   1489 2025-07 Car Toyota MPV Silver Cause vehicle to be left in a dangerous position None Bearwood Road Bearwood Road Birmingham Birmingham Warning Letter N/A   52.4762784 -1.9678366
13483 op-snap---monthly-publication-july-2025.pdf   1535 2025-07 Car Skoda Fabia Red Cause vehicle to be left in a dangerous position None Selly oak Road Selly oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
13550 op-snap---monthly-publication-july-2025.pdf   1602 2025-07 Car Honda Civic Black Cause vehicle to be left in a dangerous position None Pitmaston Road Pitmaston Road Birmingham Birmingham Warning Letter N/A   52.4254701 -1.8322218
13553 op-snap---monthly-publication-july-2025.pdf   1605 2025-07 Car Ford Grand C-MAX White Cause vehicle to be left in a dangerous position None Tetenhall High Street Tettenhall High Street Wolverhampton Wolverhampton Warning Letter N/A   52.598292 -2.1677123
13555 op-snap---monthly-publication-july-2025.pdf   1607 2025-07 Car Mercedes-Benz C43 Grey Cause vehicle to be left in a dangerous position None Colmore Row Colmore Row Birmingham Birmingham Warning Letter N/A   52.4811968 -1.9001526
13557 op-snap---monthly-publication-july-2025.pdf   1609 2025-07 Car Toyota PRIUS Grey Cause vehicle to be left in a dangerous position None Kings Heath high Street Kings Heath high Street Birmingham Birmingham Warning Letter N/A   52.4391028 -1.893289
13559 op-snap---monthly-publication-july-2025.pdf   1611 2025-07 Car Mercedes-Benz a class White Cause vehicle to be left in a dangerous position None Pitmaston Road Pitmaston Road Birmingham Birmingham Warning Letter N/A   52.4254701 -1.8322218
13560 op-snap---monthly-publication-july-2025.pdf   1612 2025-07 Car Volkswagen Tiguan Green Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13561 op-snap---monthly-publication-july-2025.pdf   1613 2025-07 Car Toyota PRIUS Silver Cause vehicle to be left in a dangerous position None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
13562 op-snap---monthly-publication-july-2025.pdf   1614 2025-07 Car Peugeot 2008 White Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13563 op-snap---monthly-publication-july-2025.pdf   1615 2025-07 Car Peugeot 3008 White Cause vehicle to be left in a dangerous position None Bayston Road Bayston Road Birmingham Birmingham Warning Letter N/A   52.4131998 -1.8910749
13564 op-snap---monthly-publication-july-2025.pdf   1616 2025-07 Car Audi E TRON Grey Cause vehicle to be left in a dangerous position None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
13570 op-snap---monthly-publication-july-2025.pdf   1622 2025-07 Car Ford Transit White Cause vehicle to be left in a dangerous position None King Edwards Street King Edwards Street Walsall Walsall Warning Letter N/A      
13573 op-snap---monthly-publication-july-2025.pdf   1625 2025-07 Car Mercedes-Benz Sprinter Grey Cause vehicle to be left in a dangerous position None Dovehouse Lane Dovehouse Lane Birmingham Birmingham Warning Letter N/A      
13582 op-snap---monthly-publication-july-2025.pdf   1634 2025-07 Car Nissan Leaf Grey Cause vehicle to be left in a dangerous position None Selly Oak Road Selly Oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
13584 op-snap---monthly-publication-july-2025.pdf   1636 2025-07 Car       Cause vehicle to be left in a dangerous position None MAdresfield Road MAdresfield Road Wolverhampton Wolverhampton NFA No Independent Evidence Available      
13586 op-snap---monthly-publication-july-2025.pdf   1638 2025-07 Car Skoda Fabia Red Cause vehicle to be left in a dangerous position None Hill Village Road Hill Village Road Birmingham Birmingham Warning Letter N/A   52.5959906 -1.8345802
13587 op-snap---monthly-publication-july-2025.pdf   1639 2025-07 Car Hyundai I20 Silver Cause vehicle to be left in a dangerous position None Elms Close Elms Close Birmingham Birmingham Warning Letter N/A   52.3985603 -1.9561282
13589 op-snap---monthly-publication-july-2025.pdf   1641 2025-07 Car Mercedes-Benz CLA Silver Cause vehicle to be left in a dangerous position None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
13592 op-snap---monthly-publication-july-2025.pdf   1644 2025-07 Car Peugeot 3008 Blue Cause vehicle to be left in a dangerous position None Kings Road Kings Road Birmingham Birmingham NFA Not in Public Interest   52.5531351 -1.8852761
13600 op-snap---monthly-publication-july-2025.pdf   1652 2025-07 Car Volkswagen Touareg White Cause vehicle to be left in a dangerous position None Pope Road Pope Road Wolverhampton Wolverhampton Warning Letter N/A   52.6162266 -2.0979326
13602 op-snap---monthly-publication-july-2025.pdf   1654 2025-07 Car Daf BOX VAN White Cause vehicle to be left in a dangerous position None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
13606 op-snap---monthly-publication-july-2025.pdf   1658 2025-07 Car Vauxhall Corsa Silver Cause vehicle to be left in a dangerous position None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
13624 op-snap---monthly-publication-july-2025.pdf   1676 2025-07 Car BMW 2 series Grey Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13625 op-snap---monthly-publication-july-2025.pdf   1677 2025-07 Car Volkswagen Golf Black Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13626 op-snap---monthly-publication-july-2025.pdf   1678 2025-07 Car BMW 3 series Black Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13627 op-snap---monthly-publication-july-2025.pdf   1679 2025-07 Car Volvo XC40 Green Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13628 op-snap---monthly-publication-july-2025.pdf   1680 2025-07 Car Audi A6 Blue Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13632 op-snap---monthly-publication-july-2025.pdf   1684 2025-07 Car Toyota Prius Red Cause vehicle to be left in a dangerous position None Sell Oak Road Sell Oak Road Birmingham Birmingham Warning Letter N/A      
13638 op-snap---monthly-publication-july-2025.pdf   1690 2025-07 Car Vauxhall vivaro White Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13639 op-snap---monthly-publication-july-2025.pdf   1691 2025-07 Car Vauxhall astra Blue Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13640 op-snap---monthly-publication-july-2025.pdf   1692 2025-07 Car Nissan xtrail Orange Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
13641 op-snap---monthly-publication-july-2025.pdf   1693 2025-07 Car Toyota Auris Silver Cause vehicle to be left in a dangerous position None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
13642 op-snap---monthly-publication-july-2025.pdf   1694 2025-07 Car Nissan Qashqai Black Cause vehicle to be left in a dangerous position None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
13643 op-snap---monthly-publication-july-2025.pdf   1695 2025-07 Car Porsche Taycan Blue Cause vehicle to be left in a dangerous position None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
13644 op-snap---monthly-publication-july-2025.pdf   1696 2025-07 Car Peugeot 207 Black Cause vehicle to be left in a dangerous position None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
13645 op-snap---monthly-publication-july-2025.pdf   1697 2025-07 Car BMW M4 White Cause vehicle to be left in a dangerous position None Lower Queen Street Lower Queen Street Birmingham Birmingham Warning Letter N/A   52.5603978 -1.8227403
13658 op-snap---monthly-publication-july-2025.pdf   1710 2025-07 Car Ford Transit White Cause vehicle to be left in a dangerous position None Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
13659 op-snap---monthly-publication-july-2025.pdf   1711 2025-07 Car Nissan X-Trail Black Cause vehicle to be left in a dangerous position None strourbridge ring road Strourbridge Ring Road Dudley Dudley Warning Letter N/A      
13660 op-snap---monthly-publication-july-2025.pdf   1712 2025-07 Car Ford Focus Black Cause vehicle to be left in a dangerous position None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Warning Letter N/A   52.4590366 -2.1465735

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);