[belorn]

I would like to see some data on failed coups that does not involve any military.

The latest major failed coup that I can remember would be the 2016 Turkish coup d'état attempt, and the effect it had on the country is well known. The general consensus internationally seems to be that the efforts by their government to stamp out their "terrorists" has been a bit of an overreaction, even if literal tanks was involved. The censorship machine in particular has been quite overreactive.

One can really hope that the US democracy manage a more appropriate reaction that is more proportional to the threat.