A newer version of this project is available. See below for other available versions.

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

Principal Investigator(s): View help for Principal Investigator(s) Jacob Kaplan, University of Pennsylvania

Name	File Type	Size	Last Modified
apparent_per_capita_alcohol_consumption_1977_2018.csv	text/csv	274.3 KB	06/29/2020 06:40:PM
apparent_per_capita_alcohol_consumption_1977_2018.dta	application/x-stata	208.9 KB	06/29/2020 06:39:PM
apparent_per_capita_alcohol_consumption_1977_2018.rda	application/x-rlang-transport	28.1 KB	06/29/2020 06:39:PM
surveillance_report_115.pdf	application/pdf	1.5 MB	06/29/2020 06:29:PM

Project Citation:

Kaplan, Jacob. Apparent Per Capita Alcohol Consumption: National, State, and Regional Trends 1977-2018. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2020-06-29. https://doi.org/10.3886/E105583V4

Project Description

Summary:

Version 4 release notes:

Adds 2018 data.
Please note that this file has some revisions on the pre-2018 data because the report changed those values, not due to any changes in my code.

Version 3 release notes:

Adds 2017 data.

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-2018. 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 Dr. Megan E. Slater and Dr. Hillel R. Alpert at the National Institute on Alcohol Abuse and Alcoholism (downloaded here https://pubs.niaaa.nih.gov/publications/surveillance115/CONS18.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.

Scope of Project

Subject Terms: alcohol consumption; alcohol; drinking behavior; beer; liquor; spirits; wine; booze; alcohol use; NIH

Geographic Coverage: United States

Time Period(s): 1977 – 2018

Universe: Persons aged 14 and over living in the United States

Data Type(s): aggregate data

Methodology

Data Source:

Apparent per Capita Alcohol Consumption: National, State, and Regional Trends, 1977–2017

https://pubs.niaaa.nih.gov/publications/surveillance113/CONS17.htm

Unit(s) of Observation: State-year

Geographic Unit: State, Region, Country

Related Publications

Download this project

Published Versions

Export Metadata

Dublin Core

DDI 2.5

Report a Problem

Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.

This material is distributed exactly as it arrived from the data depositor. ICPSR has not checked or processed this material. Users should consult the investigator(s) if further information is desired.