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

178 rows where disposal = "Warning Letter", reporter_transport_mode = "Pedestrian" and vehicle_make = "Vauxhall" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

offence 16

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 108
  • Cause vehicle to be left in a dangerous position 34
  • Cause unnecessary obstruction by motor vehicle 9
  • Contravening a Red Traffic Light 5
  • Driving without Due Care and Attention 4
  • Misc - Non Traffic Offences 3
  • Stop a vehicle within pelican pedestrian crossing limits 3
  • Motor vehicle fail to accord precedence at a pelican crossing 2
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 2
  • Stop a vehicle on pedestrian crossing 2
  • Contravene Lane Closure Red X 1
  • Driving without Reasonable Consideration 1
  • Motor vehicle fail to comply with a non endorsab 1
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 1
  • No Seat Belt 1
  • Using a Mobile Phone Whilst Driving 1

month 14

  • 2025-10 26
  • 2025-11 26
  • 2025-08 23
  • 2025-07 18
  • 2025-09 15
  • 2025-12 13
  • 2025-02 12
  • 2025-03 10
  • 2025-06 9
  • 2025-01 8
  • 2026-01 7
  • 2026-02 6
  • 2025-05 4
  • 2025-04 1

council_area 11

  • Birmingham 107
  • Dudley 21
  • Sandwell 16
  • Wolverhampton 9
  • Coventry 7
  • Sutton Coldfield 7
  • Metropolitan Borough Of Dudley 3
  • Walsall 3
  • Out of Force Area 2
  • Solihull 2
  • Nbs Irrmdingham 1

vehicle_make 1

  • Vauxhall · 178 ✖

reporter_transport_mode 1

  • Pedestrian · 178 ✖

disposal 1

  • Warning Letter · 178 ✖
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
8625 op-snap---monthly-publication-february-2026.pdf   1372 2026-02 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None fallows road Fallows Road Birmingham Birmingham Warning Letter N/A   52.4613056 -1.8636034
8637 op-snap---monthly-publication-february-2026.pdf   1384 2026-02 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None dale close Dale Close Birmingham Birmingham Warning Letter N/A   52.4215728 -1.8433062
8714 op-snap---monthly-publication-february-2026.pdf   1461 2026-02 Pedestrian Vauxhall vivaro White Stop a vehicle within pelican pedestrian crossing limits None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
8717 op-snap---monthly-publication-february-2026.pdf   1464 2026-02 Pedestrian Vauxhall corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None rockingham gardens Rockingham Gardens Birmingham Birmingham Warning Letter N/A   52.5690681 -1.8271174
8722 op-snap---monthly-publication-february-2026.pdf   1469 2026-02 Pedestrian Vauxhall combo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None stoney stanton road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
8834 op-snap---monthly-publication-february-2026.pdf   1581 2026-02 Pedestrian Vauxhall astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None willies road Willies Road Birmingham Birmingham Warning Letter N/A      
10614 op-snap---monthly-publication-january-2026.pdf   75 2026-01 Pedestrian Vauxhall insgnia black Cause vehicle to be left in a dangerous position None alcester road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
10995 op-snap---monthly-publication-january-2026.pdf   456 2026-01 Pedestrian Vauxhall Astra Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Devonshire Road Devonshire Road Birmingham Birmingham Warning Letter N/A   52.5163419 -1.9288926
11049 op-snap---monthly-publication-january-2026.pdf   510 2026-01 Pedestrian Vauxhall Astra Red Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
11222 op-snap---monthly-publication-january-2026.pdf   683 2026-01 Pedestrian Vauxhall Corsa Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Ave Gayfield Ave Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4693896 -2.1251602
11223 op-snap---monthly-publication-january-2026.pdf   684 2026-01 Pedestrian Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Ave Gayfield Ave Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4693896 -2.1251602
11668 op-snap---monthly-publication-january-2026.pdf   1129 2026-01 Pedestrian Vauxhall Zafira Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Startford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
11699 op-snap---monthly-publication-january-2026.pdf   1160 2026-01 Pedestrian Vauxhall Mokka White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Metropolitan Borough of Dudley Metropolitan Borough Of Dudley Warning Letter N/A   52.4693896 -2.1251602
3918 op-snap---monthly-publication-december-2025.pdf   46 2025-12 Pedestrian Vauxhall   Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shelsley Avenue Shelsley Avenue Sandwell Sandwell Warning Letter N/A   52.4906088 -2.0317097
3945 op-snap---monthly-publication-december-2025.pdf   73 2025-12 Pedestrian Vauxhall Insignia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Scafell Road Scafell Road Dudley Dudley Warning Letter N/A   52.4592579 -2.1385749
4193 op-snap---monthly-publication-december-2025.pdf   321 2025-12 Pedestrian Vauxhall Meriva Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Marks Crescent Street Marks Crescent Birmingham Birmingham Warning Letter N/A      
4236 op-snap---monthly-publication-december-2025.pdf   364 2025-12 Pedestrian Vauxhall Insignia Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hall Green Road Hall Green Road Birmingham Birmingham Warning Letter N/A   52.473444 -1.8094123
4276 op-snap---monthly-publication-december-2025.pdf   404 2025-12 Pedestrian Vauxhall zafiara Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None abbey road Abbey Road Sandwell Sandwell Warning Letter N/A   52.47753 -1.9774758
4297 op-snap---monthly-publication-december-2025.pdf   425 2025-12 Pedestrian Vauxhall grandland White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lime grove Lime Grove Birmingham Birmingham Warning Letter N/A   52.5042965 -1.9074069
4573 op-snap---monthly-publication-december-2025.pdf   701 2025-12 Pedestrian Vauxhall Mervia White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Corner of Geraldine Rd and Deaki Corner of Geraldine Road and Deaki nBs iRrmdingham Nbs Irrmdingham Warning Letter N/A      
4939 op-snap---monthly-publication-december-2025.pdf   1067 2025-12 Pedestrian Vauxhall astra Grey 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
5013 op-snap---monthly-publication-december-2025.pdf   1141 2025-12 Pedestrian Vauxhall astra Red Cause vehicle to be left in a dangerous position None halesowne road Halesowne Road Dudley Dudley Warning Letter N/A      
5014 op-snap---monthly-publication-december-2025.pdf   1142 2025-12 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None ash street Ash Street Dudley Dudley Warning Letter N/A   52.6194553 -1.9924281
5040 op-snap---monthly-publication-december-2025.pdf   1168 2025-12 Pedestrian Vauxhall astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None st benedicts road St Benedicts Road Birmingham Birmingham Warning Letter N/A   52.47035 -1.8428703
5095 op-snap---monthly-publication-december-2025.pdf   1223 2025-12 Pedestrian Vauxhall Corsa Black 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
5112 op-snap---monthly-publication-december-2025.pdf   1240 2025-12 Pedestrian Vauxhall Vivaro Silver Motor vehicle fail to accord precedence at a pelican crossing None Woodbridge Road Woodbridge Road Birmingham Birmingham Warning Letter N/A   52.4482076 -1.8864335
20835 op-snap---monthly-publication-november-2025.pdf   377 2025-11 Pedestrian Vauxhall Movano White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Weston St Weston Street Walsall Walsall Warning Letter N/A   52.5717464 -1.9801677
20878 op-snap---monthly-publication-november-2025.pdf   420 2025-11 Pedestrian Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stoke On Trent Stoke On Trent Out of Force Area Out of Force Area Warning Letter N/A      
20903 op-snap---monthly-publication-november-2025.pdf   445 2025-11 Pedestrian Vauxhall Zafira Black Driving without Due Care and Attention None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
21020 op-snap---monthly-publication-november-2025.pdf   562 2025-11 Pedestrian Vauxhall Corsa White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Bernards Road Street Bernards Road Birmingham Birmingham Warning Letter N/A      
21046 op-snap---monthly-publication-november-2025.pdf   588 2025-11 Pedestrian Vauxhall corsa White Cause vehicle to be left in a dangerous position None wooten road Wooten Road Birmingham Birmingham Warning Letter N/A      
21048 op-snap---monthly-publication-november-2025.pdf   590 2025-11 Pedestrian Vauxhall astra Blue Cause vehicle to be left in a dangerous position None clarence road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21119 op-snap---monthly-publication-november-2025.pdf   661 2025-11 Pedestrian Vauxhall Crossland Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bells Lane Bells Lane Birmingham Birmingham Warning Letter N/A   52.4053419 -1.8944602
21125 op-snap---monthly-publication-november-2025.pdf   667 2025-11 Pedestrian Vauxhall Corsa Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Evelyn Road Evelyn Road Birmingham Birmingham Warning Letter N/A   52.4515664 -1.8624266
21134 op-snap---monthly-publication-november-2025.pdf   676 2025-11 Pedestrian Vauxhall Corsa White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kings Heath High Street Kings Heath High Street Birmingham Birmingham Warning Letter N/A   52.4391028 -1.893289
21146 op-snap---monthly-publication-november-2025.pdf   688 2025-11 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Abbey Road Abbey Road Birmingham Birmingham Warning Letter N/A   52.5162302 -1.8593733
21172 op-snap---monthly-publication-november-2025.pdf   714 2025-11 Pedestrian Vauxhall Vivaro White Stop a vehicle on pedestrian crossing None Radford Road Radford Road Coventry Coventry Warning Letter N/A   52.4235908 -1.5226276
21201 op-snap---monthly-publication-november-2025.pdf   743 2025-11 Pedestrian Vauxhall Astra Grey Stop a vehicle within pelican pedestrian crossing limits None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
21230 op-snap---monthly-publication-november-2025.pdf   772 2025-11 Pedestrian Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Av Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
21257 op-snap---monthly-publication-november-2025.pdf   799 2025-11 Pedestrian Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Quarry Road Quarry Road Birmingham Birmingham Warning Letter N/A   52.4339016 -1.9681726
21331 op-snap---monthly-publication-november-2025.pdf   873 2025-11 Pedestrian Vauxhall antara Grey Cause vehicle to be left in a dangerous position None high street quarry bank High Street Quarry Bank Dudley Dudley Warning Letter N/A   52.4583107 -2.1169703
21349 op-snap---monthly-publication-november-2025.pdf   891 2025-11 Pedestrian Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Brenton Rd, Penn Brenton Road, Penn Wolverhampton Wolverhampton Warning Letter N/A   52.5562533 -2.1523175
21350 op-snap---monthly-publication-november-2025.pdf   892 2025-11 Pedestrian Vauxhall Mokka White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Deepdale Avenue Deepdale Avenue Birmingham Birmingham Warning Letter N/A   52.4532939 -1.7809918
21375 op-snap---monthly-publication-november-2025.pdf   917 2025-11 Pedestrian Vauxhall corsa Red Cause vehicle to be left in a dangerous position None gayfield avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
21376 op-snap---monthly-publication-november-2025.pdf   918 2025-11 Pedestrian Vauxhall astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None tiverton road Tiverton Road Birmingham Birmingham Warning Letter N/A   52.4400034 -1.9295885
21377 op-snap---monthly-publication-november-2025.pdf   919 2025-11 Pedestrian Vauxhall zafira Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None pershore road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
21463 op-snap---monthly-publication-november-2025.pdf   1005 2025-11 Pedestrian Vauxhall zafiara Grey Cause vehicle to be left in a dangerous position None wake green road Wake Green Road Birmingham Birmingham Warning Letter N/A   52.4437078 -1.8783408
21464 op-snap---monthly-publication-november-2025.pdf   1006 2025-11 Pedestrian Vauxhall vivaro White Cause vehicle to be left in a dangerous position None northway Northway Dudley Dudley Warning Letter N/A   52.548846 -2.1297656
21466 op-snap---monthly-publication-november-2025.pdf   1008 2025-11 Pedestrian Vauxhall zafira Black Cause vehicle to be left in a dangerous position None petersfield road Petersfield Road Birmingham Birmingham Warning Letter N/A   52.4307 -1.8494663
21537 op-snap---monthly-publication-november-2025.pdf   1079 2025-11 Pedestrian Vauxhall corsa Blue 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
21840 op-snap---monthly-publication-november-2025.pdf   1382 2025-11 Pedestrian Vauxhall vivaro Grey Cause vehicle to be left in a dangerous position None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
21844 op-snap---monthly-publication-november-2025.pdf   1386 2025-11 Pedestrian Vauxhall corsa Black Cause vehicle to be left in a dangerous position None coombe parkl Coombe Parkl Coventry Coventry Warning Letter N/A      
23151 op-snap---monthly-publication-october-2025.pdf   1101 2025-10 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Apsley Road Apsley Road Birmingham Birmingham Warning Letter N/A   52.4633793 -1.9102892
23203 op-snap---monthly-publication-october-2025.pdf   1153 2025-10 Pedestrian Vauxhall corsa Blue Cause vehicle to be left in a dangerous position None hurst croft road Hurst Croft Road Birmingham Birmingham Warning Letter N/A      
23251 op-snap---monthly-publication-october-2025.pdf   1201 2025-10 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Feldon Lane Feldon Lane Dudley Dudley Warning Letter N/A   52.466978 -2.0272755
23261 op-snap---monthly-publication-october-2025.pdf   1211 2025-10 Pedestrian Vauxhall Vivaro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
23288 op-snap---monthly-publication-october-2025.pdf   1238 2025-10 Pedestrian Vauxhall zafira Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area none chester road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
23290 op-snap---monthly-publication-october-2025.pdf   1240 2025-10 Pedestrian Vauxhall astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None silverthorne lane Silverthorne Lane Dudley Dudley Warning Letter N/A      
23297 op-snap---monthly-publication-october-2025.pdf   1247 2025-10 Pedestrian Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Sandwell Sandwell Warning Letter N/A   52.4877352 -1.9494469
23338 op-snap---monthly-publication-october-2025.pdf   1288 2025-10 Pedestrian Vauxhall Mokka White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barclay Road Barclay Road Sandwell Sandwell Warning Letter N/A   52.4722765 -1.9787531
23353 op-snap---monthly-publication-october-2025.pdf   1303 2025-10 Pedestrian Vauxhall Insignia Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Primrose Hill Street Primrose Hill Street Coventry Coventry Warning Letter N/A   52.412862 -1.5030563
23375 op-snap---monthly-publication-october-2025.pdf   1325 2025-10 Pedestrian Vauxhall Corsa Red Stop a vehicle on pedestrian crossing None Green Lane Green Lane Birmingham Birmingham Warning Letter N/A   52.4618966 -1.9955421
23376 op-snap---monthly-publication-october-2025.pdf   1326 2025-10 Pedestrian Vauxhall Corsa Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None HAndsowrth Wood Road HAndsowrth Wood Road Birmingham Birmingham Warning Letter N/A      
23386 op-snap---monthly-publication-october-2025.pdf   1336 2025-10 Pedestrian Vauxhall Astra Silver 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
23387 op-snap---monthly-publication-october-2025.pdf   1337 2025-10 Pedestrian Vauxhall Astra Grey Cause vehicle to be left in a dangerous position None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
23411 op-snap---monthly-publication-october-2025.pdf   1361 2025-10 Pedestrian Vauxhall Zafira White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shelsley Avenue Shelsley Avenue Sandwell Sandwell Warning Letter N/A   52.4906088 -2.0317097
23412 op-snap---monthly-publication-october-2025.pdf   1362 2025-10 Pedestrian Vauxhall Astra White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Emerson Road Emerson Road Birmingham Birmingham Warning Letter N/A   52.4589005 -1.9541717
23439 op-snap---monthly-publication-october-2025.pdf   1389 2025-10 Pedestrian Vauxhall Mokka Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None York Road York Road Birmingham Birmingham Warning Letter N/A   52.5231321 -1.8415573
23443 op-snap---monthly-publication-october-2025.pdf   1393 2025-10 Pedestrian Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moor Green Moor Green Birmingham Birmingham Warning Letter N/A   52.5202158 -1.8317935
23470 op-snap---monthly-publication-october-2025.pdf   1420 2025-10 Pedestrian Vauxhall combo Grey 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
23505 op-snap---monthly-publication-october-2025.pdf   1455 2025-10 Pedestrian Vauxhall astra Silver Cause vehicle to be left in a dangerous position None yorkmead road Yorkmead Road Birmingham Birmingham Warning Letter N/A   52.4408494 -1.846394
23601 op-snap---monthly-publication-october-2025.pdf   1551 2025-10 Pedestrian Vauxhall Meriva Black 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
23615 op-snap---monthly-publication-october-2025.pdf   1565 2025-10 Pedestrian Vauxhall Corsa Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gowan Road Gowan Road Birmingham Birmingham Warning Letter N/A   52.4893829 -1.849975
23634 op-snap---monthly-publication-october-2025.pdf   1584 2025-10 Pedestrian Vauxhall Astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wooton Road Wooton Road Birmingham Birmingham Warning Letter N/A      
23650 op-snap---monthly-publication-october-2025.pdf   1600 2025-10 Pedestrian Vauxhall Insignia Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Orphanage Road Orphanage Road Birmingham Birmingham Warning Letter N/A   52.5269356 -1.8337856
23659 op-snap---monthly-publication-october-2025.pdf   1609 2025-10 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Sandwell Sandwell Warning Letter N/A      
23690 op-snap---monthly-publication-october-2025.pdf   1640 2025-10 Pedestrian Vauxhall   Black Misc - Non Traffic Offences None Walsall Road Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
23696 op-snap---monthly-publication-october-2025.pdf   1646 2025-10 Pedestrian Vauxhall Astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wootton Road Wootton Road Birmingham Birmingham Warning Letter N/A   52.3905192 -1.968829
24741 op-snap---monthly-publication-september-2025.pdf   960 2025-09 Pedestrian Vauxhall Grandland Grey Contravening a Red Traffic Light None Bushbury Rd / Cannock Rd Bushbury Road / Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.5988194 -2.1026037
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
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
25168 op-snap---monthly-publication-september-2025.pdf   1387 2025-09 Pedestrian Vauxhall zafira Blue Contravene Lane Closure Red X None M6 Southbound M6 Southbound Birmingham Birmingham Warning Letter N/A      
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
25272 op-snap---monthly-publication-september-2025.pdf   1491 2025-09 Pedestrian Vauxhall Vectra Red Misc - Non Traffic Offences None Hockley Heath Hockley Heath Birmingham Birmingham Warning Letter N/A   52.4921873 -1.9258317
25302 op-snap---monthly-publication-september-2025.pdf   1521 2025-09 Pedestrian Vauxhall Astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Broadwell Road, Oldbury Broadwell Road, Oldbury Sandwell Sandwell Warning Letter N/A   52.5080794 -2.0125585
25311 op-snap---monthly-publication-september-2025.pdf   1530 2025-09 Pedestrian Vauxhall Astra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area tettenhall Road tettenhall Road Wolverhampton Wolverhampton Warning Letter N/A   52.5883523 -2.1466187
25380 op-snap---monthly-publication-september-2025.pdf   1599 2025-09 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Antrobus Road Antrobus Road Birmingham Birmingham Warning Letter N/A   52.5457851 -1.8457052
25381 op-snap---monthly-publication-september-2025.pdf   1600 2025-09 Pedestrian Vauxhall corsa Silver Cause vehicle to be left in a dangerous position None castle road west Castle Road West Dudley Dudley Warning Letter N/A   52.5258312 -2.0768625
25430 op-snap---monthly-publication-september-2025.pdf   1649 2025-09 Pedestrian Vauxhall Astra Silver 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
25483 op-snap---monthly-publication-september-2025.pdf   1702 2025-09 Pedestrian Vauxhall corsa Grey Motor vehicle fail to comply with a non endorsab le traffic sign - detectedN boyn meeans other than ACD Queen elizabeth hospital Queen elizabeth hospital Birmingham Birmingham Warning Letter N/A   52.4517147 -1.9423655
25496 op-snap---monthly-publication-september-2025.pdf   1715 2025-09 Pedestrian Vauxhall Grandland Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area Moor Green Lane Moor Green Lane Birmingham Birmingham Warning Letter N/A   52.4374665 -1.9119895
25520 op-snap---monthly-publication-september-2025.pdf   1739 2025-09 Pedestrian Vauxhall combo White Cause vehicle to be left in a dangerous position None Canning road Canning road Birmingham Birmingham Warning Letter N/A      
25579 op-snap---monthly-publication-september-2025.pdf   1798 2025-09 Pedestrian Vauxhall mokka Black Cause unnecessary obstruction by motor vehicle / trailer outside of the GNroenateer London area cotysmore road Cotysmore Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5712977 -1.8098984
3224 op-snap---monthly-publication-august-2025.pdf   1199 2025-08 Pedestrian Vauxhall Corsa 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
3226 op-snap---monthly-publication-august-2025.pdf   1201 2025-08 Pedestrian Vauxhall astra Red 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
3328 op-snap---monthly-publication-august-2025.pdf   1303 2025-08 Pedestrian Vauxhall Astra Red Cause vehicle to be left in a dangerous position None Cannock Road Cannock Road Wolverhampton Wolverhampton Warning Letter N/A   52.6083917 -2.1033365
3338 op-snap---monthly-publication-august-2025.pdf   1313 2025-08 Pedestrian Vauxhall Vivaro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Craythorne Avenue Craythorne Avenue Birmingham Birmingham Warning Letter N/A   52.5264721 -1.9412009
3394 op-snap---monthly-publication-august-2025.pdf   1369 2025-08 Pedestrian Vauxhall Combo White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shutlock Street Shutlock Street Birmingham Birmingham Warning Letter N/A      
3446 op-snap---monthly-publication-august-2025.pdf   1421 2025-08 Pedestrian Vauxhall Grandland 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
3451 op-snap---monthly-publication-august-2025.pdf   1426 2025-08 Pedestrian Vauxhall Mokka Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Cannon Hill Birmingham Birmingham Warning Letter N/A   52.4516065 -1.9026461

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