According to a Governing article,

State sin tax collections exceeded $32 billion in fiscal year 2014, representing roughly 3.8 percent of total tax revenues. While they’re not a major source of revenue in most states, some do rely on them much more than others. Sin taxes account for the largest share of tax revenues in Rhode Island,  Nevada, West Virginia, New Hampshire and Delaware.

Definitions on what constitutes a sin tax vay. Data shown here reflect alcohol, tobacco, casino, racino, video gaming and pari-mutuel revenues that states collected in fiscal year 2014.

Here is how North Carolina adds up when it comes to sin taxes:

Screen Shot 2015-08-27 at 2.26.46 PM