There are hundreds of examples of violent uprisings and insurgencies that are recorded in US history. I am trying to build a spreadsheet on how many of these violent actions were "successful" in reaching their aims.

I have started in 1800, and am listing the date, name of the incident, a brief description and outcome and whether or not the aims of the extremists were met.

My purpose in this is to determine how often violent political action pays off better than nonviolent resistance. Not too many studies like this have been done, so it looks like those of us who are interested in this topic will need to do some back work ourselves.