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

109 rows where offence = "Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area" and vehicle_make = "Seat" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

month 13

  • 2025-10 17
  • 2025-03 15
  • 2025-11 14
  • 2025-01 10
  • 2025-08 10
  • 2026-02 10
  • 2025-06 9
  • 2025-05 7
  • 2025-02 5
  • 2025-04 3
  • 2025-07 3
  • 2025-12 3
  • 2026-01 3

council_area 10

  • Birmingham 77
  • Sandwell 8
  • Coventry 7
  • Dudley 7
  • Sutton Coldfield 3
  • Out of Force Area 2
  • Solihull 2
  • Halesowen 1
  • Wolverhampton 1
  • `Birmingham 1

reporter_transport_mode 6

  • Pedestrian 68
  • Car 21
  • Pedal Bike 16
  • Other 2
  • Bus 1
  • car 1

disposal 5

  • Warning Letter 64
  • Fixed Penalty 23
  • NFA 19
  • Court 2
  • Other Action Taken 1

vehicle_make 1

  • Seat · 109 ✖

offence 1

  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area · 109 ✖
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
7382 op-snap---monthly-publication-february-2026.pdf   129 2026-02 Pedal Bike Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lordswood Road Lordswood Road Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
7545 op-snap---monthly-publication-february-2026.pdf   292 2026-02 Pedal Bike Seat Leon Grey 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
7553 op-snap---monthly-publication-february-2026.pdf   300 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7563 op-snap---monthly-publication-february-2026.pdf   310 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
7564 op-snap---monthly-publication-february-2026.pdf   311 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
7702 op-snap---monthly-publication-february-2026.pdf   449 2026-02 Car Seat Alhambra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cambridge Crescent Cambridge Crescent Birmingham Birmingham Warning Letter N/A   52.4652475 -1.9056734
7712 op-snap---monthly-publication-february-2026.pdf   459 2026-02 Pedestrian Seat   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kings Heath Kings Heath Birmingham Birmingham Warning Letter N/A   52.4388601 -1.8936667
7989 op-snap---monthly-publication-february-2026.pdf   736 2026-02 Pedestrian Seat Leon Orange Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Oswalds Road Street Oswalds Road Birmingham Birmingham NFA No Offence      
8242 op-snap---monthly-publication-february-2026.pdf   989 2026-02 Pedestrian Seat Leon Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bedford Road Bedford Road Birmingham Birmingham Fixed Penalty N/A   52.4718425 -1.8774188
8871 op-snap---monthly-publication-february-2026.pdf   1618 2026-02 Pedal Bike Seat altea Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None gordon road Gordon Road Coventry Coventry Warning Letter N/A      
10721 op-snap---monthly-publication-january-2026.pdf   182 2026-01 Car Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Zoar Street Zoar Street Wolverhampton Wolverhampton NFA No Offence   52.5807478 -2.1383109
11093 op-snap---monthly-publication-january-2026.pdf   554 2026-01 Pedestrian Seat alhambra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Green Lane North Green Lane North Coventry Coventry Warning Letter N/A      
11632 op-snap---monthly-publication-january-2026.pdf   1093 2026-01 Pedestrian Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry NFA No Independent Evidence Available   52.3848122 -1.5204351
4486 op-snap---monthly-publication-december-2025.pdf   614 2025-12 Pedestrian Seat   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None dudley road Dudley Road Birmingham Birmingham NFA Misc Inc Crimes   52.4865107 -1.9386263
4796 op-snap---monthly-publication-december-2025.pdf   924 2025-12 Car Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road Church Road Sandwell Sandwell Warning Letter N/A   52.4857168 -1.9703938
5102 op-snap---monthly-publication-december-2025.pdf   1230 2025-12 Car Seat leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
20867 op-snap---monthly-publication-november-2025.pdf   409 2025-11 Pedal Bike Seat Arona Black 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
20922 op-snap---monthly-publication-november-2025.pdf   464 2025-11 Car Seat Exeo Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
20936 op-snap---monthly-publication-november-2025.pdf   478 2025-11 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wooton Road Wooton Road Birmingham Birmingham Warning Letter N/A      
20958 op-snap---monthly-publication-november-2025.pdf   500 2025-11 Pedestrian Seat arona 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
20978 op-snap---monthly-publication-november-2025.pdf   520 2025-11 Pedestrian Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Barclay Road Barclay Road Birmingham Birmingham Warning Letter N/A      
20979 op-snap---monthly-publication-november-2025.pdf   521 2025-11 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hamstead Road Hamstead Road Birmingham Birmingham Warning Letter N/A   52.505832 -1.92002
20992 op-snap---monthly-publication-november-2025.pdf   534 2025-11 Pedestrian Seat Ateca Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None pershore road Pershore Road Birmingham Birmingham NFA Misc Inc Crimes   52.4308271 -1.920078
21027 op-snap---monthly-publication-november-2025.pdf   569 2025-11 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Freer Road Freer Road Birmingham Birmingham Warning Letter N/A   52.5074462 -1.8979307
21100 op-snap---monthly-publication-november-2025.pdf   642 2025-11 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dolphin Road Dolphin Road Birmingham Birmingham Warning Letter N/A   52.4542174 -1.8608812
21120 op-snap---monthly-publication-november-2025.pdf   662 2025-11 Pedestrian Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Russell Road Russell Road Birmingham Birmingham Warning Letter N/A   52.4398245 -1.8469786
21528 op-snap---monthly-publication-november-2025.pdf   1070 2025-11 Pedestrian Seat arona Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None clarence oad Clarence Oad Sutton Coldfield Sutton Coldfield Warning Letter N/A      
21728 op-snap---monthly-publication-november-2025.pdf   1270 2025-11 Pedal Bike Seat leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
21913 op-snap---monthly-publication-november-2025.pdf   1455 2025-11 Car Seat leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None huntingtree road Huntingtree Road Halesowen Halesowen NFA No Independent Evidence Available   52.4522837 -2.0740811
22004 op-snap---monthly-publication-november-2025.pdf   1546 2025-11 Pedal Bike Seat Leon Grey 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
22491 op-snap---monthly-publication-october-2025.pdf   441 2025-10 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Street Church Street Birmingham Birmingham NFA No Offence   52.5020781 -1.9122368
23132 op-snap---monthly-publication-october-2025.pdf   1082 2025-10 Pedestrian Seat Ateca 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
23163 op-snap---monthly-publication-october-2025.pdf   1113 2025-10 Pedal Bike Seat Leon Grey 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
23178 op-snap---monthly-publication-october-2025.pdf   1128 2025-10 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Jockey Rd Jockey Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5535276 -1.8302584
23282 op-snap---monthly-publication-october-2025.pdf   1232 2025-10 Pedestrian Seat Leon Red 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
23334 op-snap---monthly-publication-october-2025.pdf   1284 2025-10 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Belchers Lane Belchers Lane Birmingham Birmingham Warning Letter N/A   52.4800061 -1.833007
23364 op-snap---monthly-publication-october-2025.pdf   1314 2025-10 Car Seat alhambra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
23373 op-snap---monthly-publication-october-2025.pdf   1323 2025-10 Car Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
23374 op-snap---monthly-publication-october-2025.pdf   1324 2025-10 Pedestrian Seat Alhambra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None REginald Road REginald Road Birmingham Birmingham Warning Letter N/A   52.4893183 -1.8578906
23390 op-snap---monthly-publication-october-2025.pdf   1340 2025-10 Pedestrian Seat Toledo Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None College Road College Road Birmingham Birmingham Warning Letter N/A   52.5151832 -1.9361664
23404 op-snap---monthly-publication-october-2025.pdf   1354 2025-10 Pedestrian Seat Ibiza Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wentworth Road Wentworth Road Birmingham Birmingham Warning Letter N/A   52.5773229 -1.8324449
23484 op-snap---monthly-publication-october-2025.pdf   1434 2025-10 Pedestrian Seat ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None oak treen lane Oak Treen Lane Birmingham Birmingham Warning Letter N/A      
23588 op-snap---monthly-publication-october-2025.pdf   1538 2025-10 Pedestrian Seat Ateca 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
23644 op-snap---monthly-publication-october-2025.pdf   1594 2025-10 Pedestrian Seat Ateca Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Whithymoor Primary School Whithymoor Primary School Dudley Dudley Warning Letter N/A      
23702 op-snap---monthly-publication-october-2025.pdf   1652 2025-10 Car Seat ibiza Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23715 op-snap---monthly-publication-october-2025.pdf   1665 2025-10 Car Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
23745 op-snap---monthly-publication-october-2025.pdf   1695 2025-10 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3019 op-snap---monthly-publication-august-2025.pdf   994 2025-08 Car Seat Leon Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hertford Way Hertford Way Solihull Solihull NFA No Offence   52.3778812 -1.7427424
3375 op-snap---monthly-publication-august-2025.pdf   1350 2025-08 Car Seat Alhambra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
3438 op-snap---monthly-publication-august-2025.pdf   1413 2025-08 Pedestrian Seat Ibiza 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
3440 op-snap---monthly-publication-august-2025.pdf   1415 2025-08 Pedestrian Seat Ibiza Blue 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
3495 op-snap---monthly-publication-august-2025.pdf   1470 2025-08 Pedestrian Seat toledo Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Pelham Road Pelham Road Birmingham Birmingham NFA Misc Inc Crimes   52.487616 -1.8277815
3588 op-snap---monthly-publication-august-2025.pdf   1563 2025-08 Pedestrian Seat ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None cannon hill road Cannon Hill Road Birmingham Birmingham Warning Letter N/A   52.4569873 -1.8971744
3595 op-snap---monthly-publication-august-2025.pdf   1570 2025-08 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Rd Cannon Hill Road Birmingham Birmingham Warning Letter N/A   52.4569873 -1.8971744
3643 op-snap---monthly-publication-august-2025.pdf   1618 2025-08 Pedestrian Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Rd Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3855 op-snap---monthly-publication-august-2025.pdf   1830 2025-08 Car Seat leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Knowle High Street Knowle High Street Solihull Solihull Warning Letter N/A   52.3872283 -1.733682
3866 op-snap---monthly-publication-august-2025.pdf   1841 2025-08 Pedal Bike Seat Leon Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
13478 op-snap---monthly-publication-july-2025.pdf   1530 2025-07 Pedestrian Seat Arona Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dunsmore Avenue Dunsmore Avenue Coventry Coventry Warning Letter N/A   52.3855553 -1.4659743
13513 op-snap---monthly-publication-july-2025.pdf   1565 2025-07 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Horseley heath Horseley heath Dudley Dudley Warning Letter N/A   52.525777 -2.0464686
13537 op-snap---monthly-publication-july-2025.pdf   1589 2025-07 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Catholic Lane Catholic Lane Dudley Dudley Warning Letter N/A   52.5360259 -2.125828
14619 op-snap---monthly-publication-june-2025.pdf   548 2025-06 Pedestrian Seat Alto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Poplar Road Poplar Road Birmingham Birmingham Fixed Penalty N/A   52.436035 -1.891685
15002 op-snap---monthly-publication-june-2025.pdf   931 2025-06 Car Seat Ibiza Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
15350 op-snap---monthly-publication-june-2025.pdf   1279 2025-06 Pedestrian Seat Ibiza Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rectory Road Rectory Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5670974 -1.7943689
15891 op-snap---monthly-publication-june-2025.pdf   1820 2025-06 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Naseby Drive Naseby Drive Dudley Dudley NFA No Independent Evidence Available   52.4413419 -2.0782707
15910 op-snap---monthly-publication-june-2025.pdf   1839 2025-06 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road, Yardley Church Road, Yardley Birmingham Birmingham Warning Letter N/A   52.4655896 -1.8112542
15911 op-snap---monthly-publication-june-2025.pdf   1840 2025-06 Pedestrian Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road, Yardley Church Road, Yardley Birmingham Birmingham Warning Letter N/A   52.4655896 -1.8112542
16132 op-snap---monthly-publication-june-2025.pdf   2061 2025-06 Pedestrian Seat ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Fox Hollies Fox Hollies Birmingham Birmingham Warning Letter N/A   52.4378631 -1.8367854
16152 op-snap---monthly-publication-june-2025.pdf   2081 2025-06 Pedestrian Seat Ibiza Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Fulham road Fulham road Birmingham Birmingham Warning Letter N/A   52.4561743 -1.8694787
16191 op-snap---monthly-publication-june-2025.pdf   2120 2025-06 Car Seat Tarraco Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
18866 op-snap---monthly-publication-may-2025.pdf   228 2025-05 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tennal Road Tennal Road Birmingham Birmingham NFA No Offence   52.4578511 -1.9734988
18886 op-snap---monthly-publication-may-2025.pdf   248 2025-05 Other Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Shutlock Lane Shutlock Lane Birmingham Birmingham Warning Letter N/A   52.4381927 -1.9042054
19551 op-snap---monthly-publication-may-2025.pdf   913 2025-05 car Seat LEON Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None WITTON ROAD Witton Road Birmingham Birmingham Fixed Penalty N/A   52.513336 -1.8833226
19735 op-snap---monthly-publication-may-2025.pdf   1097 2025-05 Car Seat TOLEDO Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance WITTON ROAD Witton Road Birmingham Birmingham Court N/A   52.513336 -1.8833226
19823 op-snap---monthly-publication-may-2025.pdf   1185 2025-05 Pedal Bike Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None The Burges The Burges Coventry Coventry Warning Letter N/A   52.410226 -1.5111468
19863 op-snap---monthly-publication-may-2025.pdf   1225 2025-05 Other Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Not provided other than `Handsworth Not provided other than `Handsworth `Birmingham `Birmingham NFA No Independent Evidence Available      
19896 op-snap---monthly-publication-may-2025.pdf   1258 2025-05 Car Seat Ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Marsham Road Marsham Road Birmingham Birmingham Fixed Penalty N/A   52.4117052 -1.888565
245 op-snap---monthly-publication-april-2025.pdf   244 2025-04 Pedestrian Seat Ateca White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None High St High Street Birmingham Birmingham Warning Letter N/A   52.5254588 -1.8373064
1801 op-snap---monthly-publication-april-2025.pdf   1800 2025-04 Car Seat NP White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Handsworth Handsworth Birmingham Birmingham NFA Outside of 14 Days NIP   52.5135967 -1.9394384
1987 op-snap---monthly-publication-april-2025.pdf   1986 2025-04 Car Seat NP White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hamsworth Hamsworth Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
16626 op-snap---monthly-publication-march-2025.pdf   383 2025-03 Pedestrian Seat Leon Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tennal Road Tennal Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4578511 -1.9734988
16706 op-snap---monthly-publication-march-2025.pdf   463 2025-03 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kenelm Road Kenelm Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4710451 -1.8504087
16707 op-snap---monthly-publication-march-2025.pdf   464 2025-03 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kenelm Road Kenelm Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4710451 -1.8504087
16753 op-snap---monthly-publication-march-2025.pdf   510 2025-03 Pedal Bike Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Legge Lane Legge Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4843538 -1.9127963
16844 op-snap---monthly-publication-march-2025.pdf   601 2025-03 Pedestrian Seat Ibiza Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Green Street, Smethwick Green Street, Smethwick Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.5078981 -1.9846469
16850 op-snap---monthly-publication-march-2025.pdf   607 2025-03 Pedestrian Seat Cupra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Thompson Road, Smethwick Thompson Road, Smethwick Sandwell Sandwell Fixed Penalty N/A Yes - Via Email 52.485863 -1.9753873
16860 op-snap---monthly-publication-march-2025.pdf   617 2025-03 Car Seat Exeo Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A Yes - Via Email 52.4929304 -1.8229092
17146 op-snap---monthly-publication-march-2025.pdf   903 2025-03 Pedal Bike Seat Ibiza Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17147 op-snap---monthly-publication-march-2025.pdf   904 2025-03 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Fixed Penalty N/A Yes - Via Email    
17344 op-snap---monthly-publication-march-2025.pdf   1101 2025-03 Pedestrian Seat Leon Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ramsay Road Ramsay Road Sandwell Sandwell Warning Letter N/A Yes - Via Email 52.4723061 -1.9942558
17390 op-snap---monthly-publication-march-2025.pdf   1147 2025-03 Pedestrian Seat Ibiza Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Marsham Road Marsham Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4117052 -1.888565
17857 op-snap---monthly-publication-march-2025.pdf   1614 2025-03 Pedestrian Seat ibiza White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Grange Road Grange Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5065077 -1.892207
17897 op-snap---monthly-publication-march-2025.pdf   1654 2025-03 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Foster Road Foster Road Coventry Coventry Fixed Penalty N/A Yes - Via Email 52.42785 -1.5190909
18114 op-snap---monthly-publication-march-2025.pdf   1871 2025-03 Pedestrian Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Amberley Road, Sparkhill Amberley Road, Sparkhill Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
18636 op-snap---monthly-publication-march-2025.pdf   2393 2025-03 Pedestrian Seat Ibiza Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tennal Lane Tennal Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4577809 -1.9796585
5393 op-snap---monthly-publication-february-2025.pdf   210 2025-02 Pedestrian Seat Ateca Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Droitwich Droitwich Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
5709 op-snap---monthly-publication-february-2025.pdf   526 2025-02 Pedestrian Seat LEON Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None BELCHERS LANE Belchers Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4800061 -1.833007
6651 op-snap---monthly-publication-february-2025.pdf   1468 2025-02 Pedestrian Seat Ibiza Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holly Lane Holly Lane Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.5236889 -1.8253311
6902 op-snap---monthly-publication-february-2025.pdf   1719 2025-02 Bus Seat LEON Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None STRATFORD ROAD Stratford Road Birmingham Birmingham NFA No VRM Yes - Via Email 52.4203897 -1.8338574
7251 op-snap---monthly-publication-february-2025.pdf   2068 2025-02 Pedestrian Seat ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cannon Hill Road Cannon Hill Road Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4569873 -1.8971744
9100 op-snap---monthly-publication-january-2025.pdf   208 2025-01 Pedestrian Seat Ibiza Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Marsham Road, Birmingham Marsham Road, Birmingham Birmingham Birmingham Fixed Penalty N/A Yes - Via Email 52.4117052 -1.888565

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