And the protests over Iraq were particulary virulent. Probably the worst I've seen apart from the riots where Charles & Camilla had their car attacked.
And there have not only been the 4 successful assassinations but numerous attempts and thrwarted plots. Reagan was shot, Ford was shot at twice and at least Bush Sr was the target of a foreign assassination plot.
As for Andrew, is he covered very much in the UK press anymore? It seems a far cry from the level of publicity he received in his Randy Andy and early married days. The brief press flurries over rumors about his relationship with Sarah and then this incident seem to have garnered the most publicity he's received in awhile.