home / opsnap

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

196 rows where month = "2025-09", offence = "Cause unnecessary obstruction by motor vehicle" and reporter_transport_mode = "Pedestrian" 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

vehicle_make 27

  • Volkswagen 22
  • Mercedes-Benz 21
  • BMW 17
  • Ford 16
  • Audi 14
  • Toyota 13
  • Peugeot 11
  • Vauxhall 10
  • Seat 8
  • Hyundai 7
  • Nissan 7
  • Citroen 6
  • Honda 6
  • Land Rover 6
  • Skoda 5
  • Kia 4
  • Other 4
  • Jaguar 3
  • Mg 3
  • Fiat 2
  • Renault 2
  • Volvo 2
  • Isuzu 1
  • Iveco 1
  • Jaecoo 1
  • Lexus 1
  • Mazda 1

council_area 8

  • Birmingham 136
  • Sandwell 15
  • Wolverhampton 15
  • Solihull 9
  • Coventry 8
  • Sutton Coldfield 7
  • Dudley 3
  • Out of Force Area 3

disposal 4

  • Warning Letter 155
  • NFA 33
  • Other Action Taken 5
  • Fixed Penalty 3

reporter_transport_mode 1

  • Pedestrian · 196 ✖

offence 1

  • Cause unnecessary obstruction by motor vehicle · 196 ✖

month 1

  • 2025-09 · 196 ✖
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
23831 op-snap---monthly-publication-september-2025.pdf   50 2025-09 Pedestrian Seat Leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
24134 op-snap---monthly-publication-september-2025.pdf   353 2025-09 Pedestrian BMW X5 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hobbs Road Hobbs Road Sandwell Sandwell Fixed Penalty N/A      
24583 op-snap---monthly-publication-september-2025.pdf   802 2025-09 Pedestrian Hyundai Tucson Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dowar Road, Rednal Dowar Road, Rednal Birmingham Birmingham Fixed Penalty N/A   52.3932301 -1.9992819
24694 op-snap---monthly-publication-september-2025.pdf   913 2025-09 Pedestrian Citroen C3 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Vimmy Road Vimmy Road Sandwell Sandwell Fixed Penalty N/A      
24849 op-snap---monthly-publication-september-2025.pdf   1068 2025-09 Pedestrian Honda CR-V Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hobbs Road Wednesbury Hobbs Road Wednesbury Sandwell Sandwell Warning Letter N/A      
24901 op-snap---monthly-publication-september-2025.pdf   1120 2025-09 Pedestrian Citroen DS4 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Natmel Grove Bartley Green Natmel Grove Bartley Green Birmingham Birmingham NFA No Independent Evidence Available      
24956 op-snap---monthly-publication-september-2025.pdf   1175 2025-09 Pedestrian Mercedes-Benz CLE300 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
24958 op-snap---monthly-publication-september-2025.pdf   1177 2025-09 Pedestrian Peugeot 2008 GT Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
24966 op-snap---monthly-publication-september-2025.pdf   1185 2025-09 Pedestrian Ford KA Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Tetenhall High Street Tettenhall High Street Wolverhampton Wolverhampton Warning Letter N/A   52.598292 -2.1677123
24983 op-snap---monthly-publication-september-2025.pdf   1202 2025-09 Pedestrian Hyundai I10 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
24984 op-snap---monthly-publication-september-2025.pdf   1203 2025-09 Pedestrian Other     Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area cannock road Cannock Road Wolverhampton Wolverhampton Other Action Taken N/A   52.6083917 -2.1033365
24985 op-snap---monthly-publication-september-2025.pdf   1204 2025-09 Pedestrian Other     Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area cannock road Cannock Road Wolverhampton Wolverhampton Other Action Taken N/A   52.6083917 -2.1033365
24986 op-snap---monthly-publication-september-2025.pdf   1205 2025-09 Pedestrian Other     Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area cannock road Cannock Road Wolverhampton Wolverhampton Other Action Taken N/A   52.6083917 -2.1033365
24987 op-snap---monthly-publication-september-2025.pdf   1206 2025-09 Pedestrian Seat Ibiza Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area rectory road Rectory Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5670974 -1.7943689
24993 op-snap---monthly-publication-september-2025.pdf   1212 2025-09 Pedestrian Citroen C1 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Durgham road Durgham road Birmingham Birmingham Warning Letter N/A      
24995 op-snap---monthly-publication-september-2025.pdf   1214 2025-09 Pedestrian Audi q7 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area glenville road Glenville Road Birmingham Birmingham Warning Letter N/A      
24997 op-snap---monthly-publication-september-2025.pdf   1216 2025-09 Pedestrian Kia sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dads lane Dads lane Birmingham Birmingham Warning Letter N/A   52.4375913 -1.9068522
25001 op-snap---monthly-publication-september-2025.pdf   1220 2025-09 Pedestrian Vauxhall Mokka Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25002 op-snap---monthly-publication-september-2025.pdf   1221 2025-09 Pedestrian BMW 1 Series Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Duke Street Duke Street Wolverhampton Wolverhampton Warning Letter N/A   52.6016845 -2.0816375
25007 op-snap---monthly-publication-september-2025.pdf   1226 2025-09 Pedestrian Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Church Road, Yardley Church Road, Yardley Birmingham Birmingham Warning Letter N/A   52.4655896 -1.8112542
25010 op-snap---monthly-publication-september-2025.pdf   1229 2025-09 Pedestrian BMW 5 series Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bordesley Green Bordesley Green Birmingham Birmingham Warning Letter N/A   52.4758869 -1.8512072
25016 op-snap---monthly-publication-september-2025.pdf   1235 2025-09 Pedestrian Toyota Corolla Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Bernards Road Street Bernards Road Solihull Solihull NFA Misc Inc Crimes      
25017 op-snap---monthly-publication-september-2025.pdf   1236 2025-09 Pedestrian Jaguar S type Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Bernards Road Street Bernards Road Solihull Solihull NFA Misc Inc Crimes      
25021 op-snap---monthly-publication-september-2025.pdf   1240 2025-09 Pedestrian Hyundai Ix20 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
25022 op-snap---monthly-publication-september-2025.pdf   1241 2025-09 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
25031 op-snap---monthly-publication-september-2025.pdf   1250 2025-09 Pedestrian Skoda Fabia White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Poplar Road Poplar Road Birmingham Birmingham Warning Letter N/A   52.436035 -1.891685
25033 op-snap---monthly-publication-september-2025.pdf   1252 2025-09 Pedestrian Honda civic Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area glenville drive Glenville Drive Birmingham Birmingham Warning Letter N/A   52.5265939 -1.8509884
25035 op-snap---monthly-publication-september-2025.pdf   1254 2025-09 Pedestrian Volkswagen move Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area william booth center William Booth Center Birmingham Birmingham Warning Letter N/A      
25036 op-snap---monthly-publication-september-2025.pdf   1255 2025-09 Pedestrian Toyota yaris Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area william booth center William Booth Center Birmingham Birmingham Warning Letter N/A      
25043 op-snap---monthly-publication-september-2025.pdf   1262 2025-09 Pedestrian Kia Picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St BErnards road Street BErnards road Solihull Solihull NFA Misc Inc Crimes      
25044 op-snap---monthly-publication-september-2025.pdf   1263 2025-09 Pedestrian Fiat 500 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Bernard Road Street Bernard Road Solihull Solihull Warning Letter N/A      
25045 op-snap---monthly-publication-september-2025.pdf   1264 2025-09 Pedestrian Jaguar Stype Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St bernards Road Street bernards Road Solihull Solihull NFA Misc Inc Crimes      
25046 op-snap---monthly-publication-september-2025.pdf   1265 2025-09 Pedestrian Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St bernards road Street bernards road Solihull Solihull NFA Misc Inc Crimes      
25047 op-snap---monthly-publication-september-2025.pdf   1266 2025-09 Pedestrian Audi Q3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St bernards road Street bernards road Solihull Solihull Warning Letter N/A      
25049 op-snap---monthly-publication-september-2025.pdf   1268 2025-09 Pedestrian Volkswagen passat Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
25052 op-snap---monthly-publication-september-2025.pdf   1271 2025-09 Pedestrian Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area MOseley Village MOseley Village Birmingham Birmingham Warning Letter N/A   52.4476512 -1.8848417
25053 op-snap---monthly-publication-september-2025.pdf   1272 2025-09 Pedestrian Hyundai Ioniq Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Village Moseley Village Birmingham Birmingham Warning Letter N/A   52.4476512 -1.8848417
25054 op-snap---monthly-publication-september-2025.pdf   1273 2025-09 Pedestrian Ford Transit Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Tetenhall High Street Tettenhall High Street Wolverhampton Wolverhampton Warning Letter N/A   52.598292 -2.1677123
25058 op-snap---monthly-publication-september-2025.pdf   1277 2025-09 Pedestrian Toyota Yaris Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Freer Road Freer Road Birmingham Birmingham Warning Letter N/A   52.5074462 -1.8979307
25059 op-snap---monthly-publication-september-2025.pdf   1278 2025-09 Pedestrian Peugeot 3008 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Mackadown Lane Mackadown Lane Birmingham Birmingham Warning Letter N/A   52.4708415 -1.7675939
25060 op-snap---monthly-publication-september-2025.pdf   1279 2025-09 Pedestrian Volvo V60 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Aston Weeb Boulevard Aston Webb Boulevard Birmingham Birmingham Warning Letter N/A   52.4468506 -1.9395619
25062 op-snap---monthly-publication-september-2025.pdf   1281 2025-09 Pedestrian Vauxhall movano White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Melton Road Melton Road Birmingham Birmingham Warning Letter N/A   52.4331096 -1.8874806
25063 op-snap---monthly-publication-september-2025.pdf   1282 2025-09 Pedestrian Mercedes-Benz A180 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
25064 op-snap---monthly-publication-september-2025.pdf   1283 2025-09 Pedestrian Audi A4 White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area South Yardley South Yardley Birmingham Birmingham Warning Letter N/A   52.456515 -1.8122679
25071 op-snap---monthly-publication-september-2025.pdf   1290 2025-09 Pedestrian Mercedes-Benz sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area valentine road Valentine Road Birmingham Birmingham Warning Letter N/A   52.4381959 -1.8907391
25073 op-snap---monthly-publication-september-2025.pdf   1292 2025-09 Pedestrian Seat arona Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Anderson road Anderson road Sandwell Sandwell Warning Letter N/A   52.4736413 -1.9673217
25076 op-snap---monthly-publication-september-2025.pdf   1295 2025-09 Pedestrian Mg HS Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kitts Green Road Kitts Green Road Birmingham Birmingham Warning Letter N/A   52.4815372 -1.7766518
25099 op-snap---monthly-publication-september-2025.pdf   1318 2025-09 Pedestrian Ford transit Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Institute road Institute road Birmingham Birmingham Warning Letter N/A   52.4334781 -1.8892337
25100 op-snap---monthly-publication-september-2025.pdf   1319 2025-09 Pedestrian Seat Leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Gnroenaeter London area Walford Road Walford Road Birmingham Birmingham Warning Letter N/A   52.4594072 -1.8658859
25104 op-snap---monthly-publication-september-2025.pdf   1323 2025-09 Pedestrian Fiat 500X Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Bernards Road Street Bernards Road Birmingham Birmingham Warning Letter N/A      
25105 op-snap---monthly-publication-september-2025.pdf   1324 2025-09 Pedestrian Volkswagen Polo White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
25108 op-snap---monthly-publication-september-2025.pdf   1327 2025-09 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kings heath Kings heath Birmingham Birmingham Warning Letter N/A   52.4388601 -1.8936667
25114 op-snap---monthly-publication-september-2025.pdf   1333 2025-09 Pedestrian Honda jazz Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Boldmere road Boldmere road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.548309 -1.8411769
25115 op-snap---monthly-publication-september-2025.pdf   1334 2025-09 Pedestrian Other     Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area cannock road Cannock Road Wolverhampton Wolverhampton Other Action Taken N/A   52.6083917 -2.1033365
25117 op-snap---monthly-publication-september-2025.pdf   1336 2025-09 Pedestrian Audi a4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hugh Road Hugh Road Birmingham Birmingham NFA Misc Inc Crimes   52.4724029 -1.8527024
25132 op-snap---monthly-publication-september-2025.pdf   1351 2025-09 Pedestrian Renault Clio Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wyrely road Wyrely road Birmingham Birmingham Warning Letter N/A      
25133 op-snap---monthly-publication-september-2025.pdf   1352 2025-09 Pedestrian Ford kuga Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Poplar Road Poplar Road Birmingham Birmingham Warning Letter N/A   52.436035 -1.891685
25134 op-snap---monthly-publication-september-2025.pdf   1353 2025-09 Pedestrian Skoda Octavia Beige Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Poplar road Poplar road Birmingham Birmingham Warning Letter N/A   52.436035 -1.891685
25136 op-snap---monthly-publication-september-2025.pdf   1355 2025-09 Pedestrian Nissan Qashqai White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Motala Close Motala Close Out of Force Area Out of Force Area NFA Misc Inc Crimes      
25139 op-snap---monthly-publication-september-2025.pdf   1358 2025-09 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
25140 op-snap---monthly-publication-september-2025.pdf   1359 2025-09 Pedestrian Nissan juke Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moseley Road Moseley Road Birmingham Birmingham Warning Letter N/A   52.4679402 -1.881408
25141 op-snap---monthly-publication-september-2025.pdf   1360 2025-09 Pedestrian Audi Q8 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kings heath high street Kings heath high street Birmingham Birmingham Warning Letter N/A   52.4391028 -1.893289
25142 op-snap---monthly-publication-september-2025.pdf   1361 2025-09 Pedestrian Toyota Corolla Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kings heath high street Kings heath high street Birmingham Birmingham Warning Letter N/A   52.4391028 -1.893289
25144 op-snap---monthly-publication-september-2025.pdf   1363 2025-09 Pedestrian Audi A4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Ellesmere Road Ellesmere Road Birmingham Birmingham Warning Letter N/A   52.4881533 -1.8553625
25147 op-snap---monthly-publication-september-2025.pdf   1366 2025-09 Pedestrian Ford   White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area ashfield road Ashfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.4387591 -1.8889991
25148 op-snap---monthly-publication-september-2025.pdf   1367 2025-09 Pedestrian Renault megane Gold Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area ashdale drive Ashdale Drive Birmingham Birmingham Warning Letter N/A   52.4027335 -1.876125
25149 op-snap---monthly-publication-september-2025.pdf   1368 2025-09 Pedestrian BMW 335D Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Coventry road Coventry road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
25152 op-snap---monthly-publication-september-2025.pdf   1371 2025-09 Pedestrian Land Rover Discovery Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Alexander road Alexander road Birmingham Birmingham Warning Letter N/A   52.4524008 -1.8262343
25153 op-snap---monthly-publication-september-2025.pdf   1372 2025-09 Pedestrian Land Rover evoque Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Charingworth road Charingworth road Birmingham Birmingham Warning Letter N/A      
25154 op-snap---monthly-publication-september-2025.pdf   1373 2025-09 Pedestrian Mercedes-Benz vito White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area institute road Institute Road Birmingham Birmingham Warning Letter N/A   52.4334781 -1.8892337
25159 op-snap---monthly-publication-september-2025.pdf   1378 2025-09 Pedestrian Honda CR-V Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wake Green Rd Wake Green Road Birmingham Birmingham Warning Letter N/A   52.4437078 -1.8783408
25160 op-snap---monthly-publication-september-2025.pdf   1379 2025-09 Pedestrian Volkswagen Passat Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Solihull Train Station Solihull Train Station Birmingham Birmingham Warning Letter N/A      
25167 op-snap---monthly-publication-september-2025.pdf   1386 2025-09 Pedestrian Nissan note Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Gnroenaeter London area Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
25182 op-snap---monthly-publication-september-2025.pdf   1401 2025-09 Pedestrian Ford Fiesta Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Camden Street Camden Street Birmingham Birmingham Warning Letter N/A   52.4840029 -1.9149681
25183 op-snap---monthly-publication-september-2025.pdf   1402 2025-09 Pedestrian Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Ashfield Road Ashfield Road Birmingham Birmingham Warning Letter N/A   52.4387591 -1.8889991
25199 op-snap---monthly-publication-september-2025.pdf   1418 2025-09 Pedestrian Hyundai I30 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bentley Road Bentley Road Birmingham Birmingham Warning Letter N/A   52.5417313 -1.8010055
25200 op-snap---monthly-publication-september-2025.pdf   1419 2025-09 Pedestrian Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bentley Road Bentley Road Birmingham Birmingham Warning Letter N/A   52.5417313 -1.8010055
25201 op-snap---monthly-publication-september-2025.pdf   1420 2025-09 Pedestrian Toyota Prius Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wheatcroft Road Wheatcroft Road Birmingham Birmingham Warning Letter N/A   52.4791027 -1.7954262
25202 op-snap---monthly-publication-september-2025.pdf   1421 2025-09 Pedestrian Mercedes-Benz EQA Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wheatcroft Road Wheatcroft Road Birmingham Birmingham Warning Letter N/A   52.4791027 -1.7954262
25208 op-snap---monthly-publication-september-2025.pdf   1427 2025-09 Pedestrian Toyota Yaris Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Glenville Drive Glenville Drive Birmingham Birmingham NFA Misc Inc Crimes   52.5265939 -1.8509884
25209 op-snap---monthly-publication-september-2025.pdf   1428 2025-09 Pedestrian Land Rover Defender Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bishopton Close, Coventry Bishopton Close, Coventry Coventry Coventry Warning Letter N/A   52.4096327 -1.5654023
25214 op-snap---monthly-publication-september-2025.pdf   1433 2025-09 Pedestrian Volkswagen Golf Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wentworth Road Wentworth Road Birmingham Birmingham Warning Letter N/A   52.5773229 -1.8324449
25216 op-snap---monthly-publication-september-2025.pdf   1435 2025-09 Pedestrian Mercedes-Benz GLC Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Petersfield Road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
25220 op-snap---monthly-publication-september-2025.pdf   1439 2025-09 Pedestrian Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dymond Road Dymond Road Birmingham Birmingham Warning Letter N/A      
25221 op-snap---monthly-publication-september-2025.pdf   1440 2025-09 Pedestrian Volkswagen Touran Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area York Rd York Road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
25226 op-snap---monthly-publication-september-2025.pdf   1445 2025-09 Pedestrian Volkswagen Golf Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kings Close, Vicerage Road Kings Close, Vicerage Road Birmingham Birmingham NFA Misc Inc Crimes      
25227 op-snap---monthly-publication-september-2025.pdf   1446 2025-09 Pedestrian Volkswagen Golf Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Rowood Drive Rowood Drive Solihull Solihull Warning Letter N/A   52.4285752 -1.7757399
25231 op-snap---monthly-publication-september-2025.pdf   1450 2025-09 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Woodstock Road Woodstock Road Birmingham Birmingham NFA Misc Inc Crimes   52.4486205 -1.8740822
25232 op-snap---monthly-publication-september-2025.pdf   1451 2025-09 Pedestrian Nissan juke Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area selly oak road Selly Oak Road Birmingham Birmingham Warning Letter N/A   52.4263875 -1.9397954
25236 op-snap---monthly-publication-september-2025.pdf   1455 2025-09 Pedestrian Vauxhall astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area PArtons Road PArtons Road Birmingham Birmingham NFA No VRM   52.4248418 -1.9030041
25239 op-snap---monthly-publication-september-2025.pdf   1458 2025-09 Pedestrian Audi S3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Bernard Road Street Bernard Road Birmingham Birmingham Warning Letter N/A      
25240 op-snap---monthly-publication-september-2025.pdf   1459 2025-09 Pedestrian BMW X3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Eagle Lane Eagle Lane Birmingham Birmingham Warning Letter N/A   52.4059411 -1.9939342
25244 op-snap---monthly-publication-september-2025.pdf   1463 2025-09 Pedestrian Volkswagen Golf Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Kings close Kings close Birmingham Birmingham Warning Letter N/A   52.4082793 -1.9251695
25249 op-snap---monthly-publication-september-2025.pdf   1468 2025-09 Pedestrian Land Rover Range Rover Gold Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Glenville Road Glenville Road Birmingham Birmingham Warning Letter N/A      
25250 op-snap---monthly-publication-september-2025.pdf   1469 2025-09 Pedestrian Nissan Qashqai White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area HArborne High Street HArborne High Street Birmingham Birmingham Warning Letter N/A   52.459563 -1.946922
25253 op-snap---monthly-publication-september-2025.pdf   1472 2025-09 Pedestrian BMW x3 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Gnroenaeter London area Tentenhall Tentenhall Wolverhampton Wolverhampton Warning Letter N/A      
25254 op-snap---monthly-publication-september-2025.pdf   1473 2025-09 Pedestrian Seat leon Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
25275 op-snap---monthly-publication-september-2025.pdf   1494 2025-09 Pedestrian Ford Focus Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Heath green road Heath green road Birmingham Birmingham Warning Letter N/A   52.4873353 -1.9407986
25276 op-snap---monthly-publication-september-2025.pdf   1495 2025-09 Pedestrian Audi Q8 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dudley road Dudley road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
25277 op-snap---monthly-publication-september-2025.pdf   1496 2025-09 Pedestrian Skoda Fabia Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dudley Road Dudley Road Sandwell Sandwell NFA No Independent Evidence Available   52.4877352 -1.9494469

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