Apparent Per Capita Alcohol Consumption: National, State, and Regional Trends 1977-2016

Version 2 release notes: Makes columns showing the number of beers, glasses of wine, shots of liquor, and total drinks consumed based on the amount of ethanol consumed for each category that was already included.This data set contains the per capita (persons aged 14+) consumption of ethanol (in gallons) for each state, Washington D.C., and totals for census regions and the United States as a whole, for the years 1977-2016. This includes total ethanol consumed as well as consumption by three categories: beer, wine, and shots of liquor ("spirits"). The PDF includes a method to convert the ethanol variables into total drinks of each type. I used this method to create columns for how many beers, glasses of wine, shots of liquor, and total drinks were consumed.The PDF doesn't say how many ounces of fluid is in each drink type (except for the number_of_drinks_total variable) so I used the information provided by the National Institute on Alcohol Abuse and Alcoholism here - https://www.niaaa.nih.gov/alcohol-health/overview-alcohol-consumption/what-standard-drink. Please note that the number_of_drinks_total variable is based on the conversion formula provided, not by adding the individual drink categories together and therefore will be slightly different than that way of measuring it. This data comes from a report by Sarah P. Haughwout and Dr. Megan E. Slater at the National Institute on Alcohol Abuse and Alcoholism (downloaded here https://pubs.niaaa.nih.gov/publications/surveillance110/CONS16.htm). That report is one of the files available to download and is included as it explains the methodology the two authors used for the data. I am not affiliated with the original report at all. If you do use this data please also cite the original report.For the code used to scrape and clean the data, and the tests to ensure my code is accurate, please see my GitHub file here: https://github.com/jacobkap/alcohol. When using this data consider that it is rate per capita (persons aged 14+) based on the population in that state so states that experience lots of visitors (e.g. Nevada and Washington D.C.) may have incorrect numbers.

版本 2 发布说明：本版本新增了基于各分类乙醇消耗量所展示的啤酒、葡萄酒杯数、烈酒盎司数以及总饮酒量的列。该数据集包含了1977年至2016年期间各州、华盛顿特区以及人口普查区域和美国整体的乙醇人均消耗量（以加仑为单位），并涵盖了乙醇总消耗量以及啤酒、葡萄酒和烈酒（酒精饮料）三个类别的消耗量。PDF文件中包含了一种将乙醇变量转换为各类别总饮酒量的方法。我利用此方法创建了啤酒、葡萄酒杯数、烈酒盎司数和总饮酒量的列。PDF并未说明各类饮酒中含有的液体盎司数（除了总数变量），因此我使用了国家酒精滥用与酒精中毒研究所提供的信息——https://www.niaaa.nih.gov/alcohol-health/overview-alcohol-consumption/what-standard-drink。请注意，总数变量是基于提供的转换公式计算得出，而非将各个饮酒类别相加的结果，因此其测量值可能略有差异。此数据来源于国家酒精滥用与酒精中毒研究所Sarah P. Haughwout博士和Megan E. Slater博士的报告（下载地址为https://pubs.niaaa.nih.gov/publications/surveillance110/CONS16.htm）。该报告是可供下载的文件之一，其中详细说明了两位作者所采用的数据分析方法。本人与原始报告无任何关联。如使用此数据，请务必引用原始报告。有关用于抓取和清洗数据的代码以及确保代码准确性的测试，请参阅我的GitHub文件：https://github.com/jacobkap/alcohol。在使用此数据时，请注意，该数据为人均消耗率（14岁以上人口），基于各州的居民人口，因此游客众多的州（例如内华达州和华盛顿特区）的数据可能存在误差。