to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
There are certain things that are understood without having to be said, because they're very obvious. Things like "never get involved in a land war in Asia" or "never go against a Sicilian when death is on the line" are examples of these kinds of things. Other examples can be found in the kinds of things that Captain Obvious might say, such as "the sky is blue" or "Philadelphians sure drink a lot of alcohol".
But what drives Philadelphians to drink so much alcohol?
The short answer is that outside of prohibition, Philadelphians have always consumed large quantities of alcohol. And as many Philadelphians might point out, prohibition wasn't much of an obstacle for the city's dedicated alcohol consumers.
When it comes to alcohol consumption then, the city of Philadelphia is starting out with a strong base. So what might prompt already heavy-drinking Philadelphians to boost their alcohol consumption to even higher levels?
Believe it or not, the city's controversial tax on soft drinks would appear to be behind the city's recent surge in alcohol sales. Last August, Scott Drenkard and Courtney Shupert of the nonpartisan Tax Foundation found that Philadelphia's "high tax rate on nonalcoholic beverages makes them more expensive than beer in some cases", which they believed was "likely to drive consumers to more alcoholic beverage consumption".
Philadelphia's monthly liquor tax collections confirm that this outcome has come to pass, where the revenues from the city's 10% tax on alcoholic beverage sales is documented within its tax reports for School District revenue collections. The following chart, which covers the City of Philadelphia's last five fiscal years, reveals that in the 18 months since the implementation of the city's controversial tax on all naturally and artificially-sweetened beverages distributed for retail sale within the city went into effect, the city's has been collecting an average of $6.5 million per month from its alcohol taxes, up from the average of $5.5 million per month it collected in the 18 months preceding the soda tax implementation, an increase of $1 million per month on average.
The same phenomenon is not evident on the opposite side of Pennsylvania, where Allegheny County's revenues from its 7% tax on alcoholic beverage sales indicate no meaningful difference in the level of alcohol sales in that region of the same state over the same period of time (the data for June 2018 is preliminary).
The two observations together are important because Allegheny County, being in the same state as Philadelphia and thereby subject to all of the same state laws and regulations on the sale of alcohol, represents the control in what amounts to a natural experiment for measuring the effect of Philadelphia's soda tax upon liquor sales.
And what a difference it appears to be. Doing the math to work out the corresponding level of liquor sales, Philadelphia's residents would appear to have increased their average monthly consumption of alcoholic beverages from an average of $55 million to $65 million, an increase of $10 million in the sales of taxed alcoholic beverages per month.
Let's put that figure into a more fun context! In January 2017, just after Philadelphia's soda tax went into effect, the Tax Foundation documented that the sale price of a 12-pack of Icehouse beer, which had just become cheaper than a 12-pack of non-alcoholic Propel sports drinks, was $7.99 in Philadelphia. For the sake of argument, let's say that after Philadelphia's soda tax went into effect, Philadelphia's residents began exclusively consuming $10 million worth of Icehouse beer per month at this price. How many extra bottles of beer per month is that?
Dividing the average increase of $10 million per month by $7.99 for the 12-pack of Icehouse beer, we find that corresponds to the equivalent of roughly 1.25 million 12-packs per month, which works out to be about 15 million extra 12-oz bottles of beer consumed in the city. Per month.
Philadelphia's total population in July 2017 was estimated to be 1.581 million people. So, after the City of Philadelphia imposed its sweetened beverage tax in January 2017, every man, woman and child living in the city responded by increasing their consumption of Icehouse beer by 9.5 bottles per month. Multiplied by 12 months, that's an increase of 114 bottles per year.
Of course, that's a ridiculous number, because Pennsylvania prohibits the sale of alcoholic beverages to individuals under the age of 21. That prohibition blocks some 26% of the city's population from even being able to buy Icehouse beer, assuming that the law is actively enforced against Philadelphia residents under that age. If we do the back-of-the-envelope math to estimate how many extra equivalent 12-fluid-ounce bottles of Icehouse beer that Philadelphia's adult population is consuming, we come up with a monthly increase of 12.9 bottles per legal drinking-age Philadelphian, or over 154 bottles of Icehouse beer per adult in the city per year.
If we convert 12-fluid-ounce bottles of Icehouse beer into the equivalent number of calories, we find that at 149 calories per 12-fluid ounce container, Philadelphia's adults are drinking in an additional 1,916 calories per month, or just over 22,989 calories per year.
Since a 12-ounce bottle of Coca-Cola has 140 calories, that's a nearly one-for-one swap where calories are concerned, so there's no realized health benefit from calorie reduction for the portion of Philadelphia's adult population who have changed out sugary soft drinks for beer. For consumers who switched from low-to-no calorie soft drinks to beer, their calorie consumption would have substantially increased.
That of course doesn't consider the impact of other potential health and safety issues that city health officials believe would go along with the increased alcohol consumption in Philadelphia that would appear to have come about as a direct consequence of the city's controversial soda tax.
No matter what, one solid fact holds true. Philadelphians sure drink a lot of alcohol, and since the city's soda tax went into effect, they are sure drinking a lot more!
Update 8:34 PM EDT: Here's a chart showing the overall trend for the trailing 12-month total for Philadelphia's liquor tax collections from July 2014 through June 2018.
You can see Philadelphia's liquor tax collections accelerate from their previous growth rate beginning in January 2017 through December 2017. The peak values in the chart occur in January and February 2018 which, if you think about what was going on in Philadelphia in those specific months, have their own special contributing factor to boosting alcohol consumption in the city! Since then, Philadelphia's liquor tax collections have largely leveled out at an elevated level with respect to the trend that existed before Philadelphia's soda tax went into effect.
In the 18 months from January 2017 through June 2018, the trailing year total of Philadelphia's liquor tax collections increased by 13.4% of its December 2016 value, thanks to Philadelphia's increase in alcohol consumption. By comparison, the trailing year total of U.S. federal alcohol tax collections rose by just 0.5% over the same period. Since the city implemented its controversial soda tax, Philadelphians have increased their alcohol consumption by a much larger amount than the rest of America!
We've been covering the story of Philadelphia's flawed soda tax on roughly a monthly basis from almost the very beginning, where our coverage began as something of a natural extension from one of the stories we featured as part of our Examples of Junk Science Series. The linked list below will take you through all our in-near-real-time analysis of the impact of the tax, which at this writing, has still to reach its end.
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.