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

303 rows where council_area = "Birmingham" and offence = "Cause unnecessary obstruction by motor vehicle" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

vehicle_make 29

  • Volkswagen 35
  • Toyota 34
  • Mercedes-Benz 31
  • Audi 27
  • Ford 26
  • BMW 20
  • Seat 14
  • Vauxhall 14
  • Nissan 12
  • Peugeot 11
  • Citroen 9
  • Mg 9
  • Honda 8
  • Land Rover 8
  • Hyundai 7
  • Renault 7
  • Skoda 6
  • Jaguar 5
  • Mini 3
  • Tesla 3
  • Fiat 2
  • Lexus 2
  • Mazda 2
  • Volvo 2
  • Isuzu 1
  • Iveco 1
  • Kia 1
  • Porsche 1
  • Rolls-Royce 1

disposal 4

  • Warning Letter 274
  • NFA 27
  • Fixed Penalty 1
  • Other Action Taken 1

reporter_transport_mode 3

  • Car 164
  • Pedestrian 136
  • Pedal Bike 3

offence 1

  • Cause unnecessary obstruction by motor vehicle · 303 ✖

month 1

  • 2025-09 303

council_area 1

  • Birmingham · 303 ✖
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
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
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      
24954 op-snap---monthly-publication-september-2025.pdf   1173 2025-09 Car Mercedes-Benz CLC200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area coleshill Street coleshill Street Birmingham Birmingham NFA Misc Inc Crimes   52.5645717 -1.8214603
24955 op-snap---monthly-publication-september-2025.pdf   1174 2025-09 Car Ford transit Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area coleshill street Coleshill Street Birmingham Birmingham Warning Letter N/A   52.5645717 -1.8214603
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
24959 op-snap---monthly-publication-september-2025.pdf   1178 2025-09 Car Mercedes-Benz GLE Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Meadow Road Moor Meadow Road Birmingham Birmingham Warning Letter N/A   52.5730351 -1.811074
24960 op-snap---monthly-publication-september-2025.pdf   1179 2025-09 Car Ford Fiesta Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Meadow Road Moor Meadow Road Birmingham Birmingham Warning Letter N/A   52.5730351 -1.811074
24961 op-snap---monthly-publication-september-2025.pdf   1180 2025-09 Car Toyota Yaris Red Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Meadow Road Moor Meadow Road Birmingham Birmingham Warning Letter N/A   52.5730351 -1.811074
24962 op-snap---monthly-publication-september-2025.pdf   1181 2025-09 Car Rolls-Royce Ghost Purple Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Meadow Road Moor Meadow Road Birmingham Birmingham Warning Letter N/A   52.5730351 -1.811074
24963 op-snap---monthly-publication-september-2025.pdf   1182 2025-09 Car Ford Fiesta Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Meadow Road Moor Meadow Road Birmingham Birmingham Warning Letter N/A   52.5730351 -1.811074
24968 op-snap---monthly-publication-september-2025.pdf   1187 2025-09 Car Volkswagen Polo Silver 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
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
24991 op-snap---monthly-publication-september-2025.pdf   1210 2025-09 Car Volkswagen polo Blue 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
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
24998 op-snap---monthly-publication-september-2025.pdf   1217 2025-09 Car Audi Q2 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
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
25006 op-snap---monthly-publication-september-2025.pdf   1225 2025-09 Car Mg 4 SE White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
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
25008 op-snap---monthly-publication-september-2025.pdf   1227 2025-09 Car Toyota Corolla Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Elm Road Elm Road Birmingham Birmingham Warning Letter N/A   52.5508541 -1.7995315
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
25011 op-snap---monthly-publication-september-2025.pdf   1230 2025-09 Car Volkswagen Golf 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
25012 op-snap---monthly-publication-september-2025.pdf   1231 2025-09 Car Mg HS Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Franklin Road Franklin Road Birmingham Birmingham Warning Letter N/A   52.4195456 -1.9350703
25013 op-snap---monthly-publication-september-2025.pdf   1232 2025-09 Car Hyundai i20 Blue 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
25014 op-snap---monthly-publication-september-2025.pdf   1233 2025-09 Car Toyota Aygo Red 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
25015 op-snap---monthly-publication-september-2025.pdf   1234 2025-09 Car Jaguar I pace 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
25018 op-snap---monthly-publication-september-2025.pdf   1237 2025-09 Car Audi Q4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
25023 op-snap---monthly-publication-september-2025.pdf   1242 2025-09 Car Peugeot 5008 Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Wolverhampton Road Wolverhampton Road Birmingham Birmingham Warning Letter N/A   52.463146 -1.9844677
25024 op-snap---monthly-publication-september-2025.pdf   1243 2025-09 Car Hyundai I10 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
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      
25039 op-snap---monthly-publication-september-2025.pdf   1258 2025-09 Car Mercedes-Benz C200 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Drayton Road Drayton Road Birmingham Birmingham Warning Letter N/A   52.4321165 -1.8902667
25040 op-snap---monthly-publication-september-2025.pdf   1259 2025-09 Car Skoda Fabia Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Sladefield road Sladefield road Birmingham Birmingham Warning Letter N/A   52.488525 -1.83277
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
25050 op-snap---monthly-publication-september-2025.pdf   1269 2025-09 Car BMW 520d Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area westely road Westely Road Birmingham Birmingham Warning Letter N/A      
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
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
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
25072 op-snap---monthly-publication-september-2025.pdf   1291 2025-09 Car Ford transit Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area St Josephs Road Street Josephs Road Birmingham Birmingham Warning Letter N/A      
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
25077 op-snap---monthly-publication-september-2025.pdf   1296 2025-09 Car Mercedes-Benz GLA 200 Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hustcroft Road Hustcroft Road Birmingham Birmingham Warning Letter N/A      
25078 op-snap---monthly-publication-september-2025.pdf   1297 2025-09 Car Mg ZS White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hurstcroft Road Hurstcroft Road Birmingham Birmingham Warning Letter N/A   52.4830179 -1.783876
25079 op-snap---monthly-publication-september-2025.pdf   1298 2025-09 Car Volkswagen Golf Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hurstcroft Road Hurstcroft Road Birmingham Birmingham Warning Letter N/A   52.4830179 -1.783876
25080 op-snap---monthly-publication-september-2025.pdf   1299 2025-09 Pedal Bike Honda Jazz Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Witton Road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
25082 op-snap---monthly-publication-september-2025.pdf   1301 2025-09 Car Skoda Superb Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Witton road Witton road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
25083 op-snap---monthly-publication-september-2025.pdf   1302 2025-09 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
25084 op-snap---monthly-publication-september-2025.pdf   1303 2025-09 Car Audi A3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Witton road Witton road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
25085 op-snap---monthly-publication-september-2025.pdf   1304 2025-09 Car Land Rover Ranger rover White 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
25086 op-snap---monthly-publication-september-2025.pdf   1305 2025-09 Car Land Rover Range Rover Blue 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
25087 op-snap---monthly-publication-september-2025.pdf   1306 2025-09 Car Seat Arona Orange 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
25088 op-snap---monthly-publication-september-2025.pdf   1307 2025-09 Car Honda Insight Silver 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
25089 op-snap---monthly-publication-september-2025.pdf   1308 2025-09 Car Seat Ibiza White 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
25090 op-snap---monthly-publication-september-2025.pdf   1309 2025-09 Car Toyota Auris Blue 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
25091 op-snap---monthly-publication-september-2025.pdf   1310 2025-09 Car Peugeot 3008 Blue 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
25092 op-snap---monthly-publication-september-2025.pdf   1311 2025-09 Car Vauxhall Astra Silver 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
25093 op-snap---monthly-publication-september-2025.pdf   1312 2025-09 Car Mercedes-Benz A180 Silver 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
25094 op-snap---monthly-publication-september-2025.pdf   1313 2025-09 Car Seat leon Black 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
25095 op-snap---monthly-publication-september-2025.pdf   1314 2025-09 Car Audi A3 Brown Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Pitmaston road Pitmaston road Birmingham Birmingham Warning Letter N/A   52.4254701 -1.8322218
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
25101 op-snap---monthly-publication-september-2025.pdf   1320 2025-09 Car Ford Transit Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
25102 op-snap---monthly-publication-september-2025.pdf   1321 2025-09 Car Renault Traffic Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Hazlewell Road Hazlewell Road Birmingham Birmingham Warning Letter N/A      
25103 op-snap---monthly-publication-september-2025.pdf   1322 2025-09 Car Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Fetherstone Road Fetherstone Road Birmingham Birmingham Warning Letter N/A      
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
25112 op-snap---monthly-publication-september-2025.pdf   1331 2025-09 Car Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
25113 op-snap---monthly-publication-september-2025.pdf   1332 2025-09 Car Audi A1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Queslett Road Queslett Road Birmingham Birmingham Warning Letter N/A   52.5458699 -1.9304484
25116 op-snap---monthly-publication-september-2025.pdf   1335 2025-09 Car Renault clio 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
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
25118 op-snap---monthly-publication-september-2025.pdf   1337 2025-09 Car Volkswagen Taigo Grey 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
25119 op-snap---monthly-publication-september-2025.pdf   1338 2025-09 Car Audi A5 Grey 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
25120 op-snap---monthly-publication-september-2025.pdf   1339 2025-09 Car 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
25123 op-snap---monthly-publication-september-2025.pdf   1342 2025-09 Car Audi A3 Grey 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
25126 op-snap---monthly-publication-september-2025.pdf   1345 2025-09 Car Citroen C3 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Poplar Road Poplar Road Birmingham Birmingham NFA No Independent Evidence Available   52.436035 -1.891685
25128 op-snap---monthly-publication-september-2025.pdf   1347 2025-09 Car Honda civic Grey 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
25129 op-snap---monthly-publication-september-2025.pdf   1348 2025-09 Car Mercedes-Benz CLA White 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
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
25138 op-snap---monthly-publication-september-2025.pdf   1357 2025-09 Car Toyota Prius Grey 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
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
25151 op-snap---monthly-publication-september-2025.pdf   1370 2025-09 Car Audi Q5 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Dower road Dower road Birmingham Birmingham Warning Letter N/A   52.5779855 -1.8253507
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

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