Home
APIS Policy Topics
Underage Drinking>
Maps & Charts
About APIS>
About Alcohol Policy
What's New
Policy Changes at a Glance
Change Log
APIS Resources>
Contact APIS
 
 
Home > 
Data System Details

Details Regarding the Statewide Availability Data System II: 1933 - 2003

 
The table below summarizes the content of the data system. It is organized by content area, with one row per data table. Column entries indicate the years and States covered by the table, as well as a brief description of the data source. Please contact Bill Ponicki at (510) 883-5713 or bponicki@prev.org if you have questions about specific data items or file formats.
 
 
Statewide Availability Data System: Sources and Coverage
 

Category

 
Data Description
Earliest Year
Latest Year
States (incl. D.C.)
Brief Data Source
Table Name
Consumption
Annual Spirits Sales
1952
2001
51
Distilled Spirits Council of the United States, monthly shipment reports gathered from various secondary sources.
SPIRAN.SAV
Monthly Spirits Sales
1968
2001
51
Distilled Spirits Council of the United States, monthly shipment reports gathered from various secondary sources.
SPIRITS.SAV
Annual Wine Sales
1967
2004
51
Wine Institute data gathered from various secondary sources.
WINEAN.SAV
Monthly Wine Sales
1967
1997
51
Wine Institute data gathered from various secondary sources.
WINE.SAV
Monthly Beer Sales
1948
2001
51
Beer Institute, Shipment Reports (recent years from 2001 Brewers' Almanac on www.beerinstitute.com web site)
BEER.SAV
Annual Beer Sales
1948
2004
51
Beer Institute, Shipment Reports (1994 through 2004 from 2005 Brewers' Almanac on www.beerinstitute.com web site, accessed 2/22/06)
BEERAN.SAV
Per Capita Ethanol Consumption by Beverage (AEDS)
1970
2000
51
NIAAA, U.S. Alcohol Epidemiologic Data Reference Manual, Volume 1, 4th Edition, 2004.
AEDS.SAV
Average Percent Ethanol Content of Beverages
1850
2000
N/A
NIAAA, U.S. Alcohol Epidemiologic Data Reference Manual, Volume 1, 4th Edition, 2004.
CONVERT.SAV
Problems
Fatal Accident Reporting System
1975
2002
51
US Dept. of Transportation, National Highway Traffic Safety Administration, Fatal Accident Reporting System (CD-ROM for 1975-94, data files from NHTSA web site for 1995-2002)
FARS.SAV
Deaths with various Alcohol-Related ICD-8 codes
1968
1978
51
U.S. Dept. of Health and Human Services (US DHHS),
Centers for Disease Control and Prevention (CDC),
NationalCenter for Health Statistics Mortality Detail Files, Tape 1
DEATH8.SAV
Deaths with various Alcohol-Related ICD-9 codes
1979
1998
51
U.S. Dept. of Health and Human Services (US DHHS), Centers for Disease Control and Prevention (CDC), Compressed Mortality File (CMF), accessed from CDC WONDER On-line Database
DEATH9.SAV
Deaths with various Alcohol-Related ICD-10 codes
1999
2001
51
U.S. Dept. of Health and Human Services (US DHHS), Centers for Disease Control and Prevention (CDC), Compressed Mortality File (CMF), accessed from CDC WONDER On-line Database
DEATH10.SAV
Alcohol-Related Arrests
1980
2001
51
U.S. Dept. of Justice, Bureau of Justice Statistics, Sourcebook of Criminal Justice Statistics (annual)
CRIMENUM.SAV
Alcohol-Related Arrests as Percent of Total
1973
2001
51
U.S. Dept. of Justice, Bureau of Justice Statistics, Sourcebook of Criminal Justice Statistics (annual)
CRIMEPER.SAV
Price / Tax
ACCRA Prices - Adjusted AnnualState Averages
1973
2003
38-50
ACCRA (formerly American Chamber of Commerce Researchers Association), Cost of Living Index (Quarterly)
ACCRAADJ.SAV
Spirits Tax Rates
1933
2003
34
Distilled Spirits Council of the United States, Annual Statistical Review (annual); Jobson's/Adams Liquor Handbook (annual)
SPIRRATE.SAV
Wine Tax Rates
1970
2003
51
Jobson's/Adams' Wine Marketing Handbook,
WINERATE.SAV
Beer Tax Rates, State and Federal
1933
2003
51
Beer Institute, Brewer's Almanac (annual)
BEERRATE.SAV
Producer Price Index for Beer, Wine, Spirits
1967
2003
Nat'l
U.S. Dept. of Labor, Bureau of Labor Statistics, web site, Producer Price Index
PPIANN.SAV
Federal Excise Tax Collections
1935
1984
50
Distilled Spirits Council of the United States (DISCUS), Public Revenues from Alcohol Beverages 1984/85.
FEDCOLL.SAV
State and Local Alcohol Tax Collections
1984
1986
51
Distilled Spirits Council of the United States (DISCUS), Public Revenues from Alcohol Beverages 1984/85, 1986.
STATCOL2.SAV
Suggested Prices for fifth of various Liquor Brands (Jobson's)
1975
1986
51
Jobson's Liquor Handbook (annual)
PRICELIQ.SAV
Outlets
DISCUS Spirits Licenses
1952
1986
51
Distilled Spirits Council of the United States
SPIROUTL.SAV
Wine Marketing Handbook Wine Licenses
1974
1984
51
Jobson's/Adams Wine Marketing Handbook, Adams Liquor Handbook, plus other sources
WMHOUTL.SAV
Jobson's/Adams Beer/Wine/Spirits Licenses
1992
2003
51
Jobson's/Adams Wine Marketing Handbook, Jobson's/Adams Liquor Handbook
0
DISCUS Beer Licenses
1982
1984
45
Distilled Spirits Council of the United States
DISBEER.SAV
DISCUS Wine Licenses
1982
1984
38
Distilled Spirits Council of the United States
DISWINE.SAV
Policy
Minimum Drinking Age Laws Effective at Mid-Year
1969
2004
51
US Alcohol Epidemiologic Data Reference Manual Vol. 1, US Dept of Health and Human Services, 1985; O'Malley and Wagenaar "Effects of minimum drinking age laws on alcohol use, related behaviors, and traffic crash involvement among American youth: 1976-1987" (unpublished manuscript), Institute for Social Research, U of Michigan, 1990.
MINAGE.SAV
Minimum Drinking Age Laws, Adjusted for partial-years and Grandfathering
1970
2004
51
US Alcohol Epidemiologic Data Reference Manual Vol. 1, US Dept of Health and Human Services, 1985; O'Malley and Wagenaar "Effects of minimum drinking age laws on alcohol use...", Institute for Social Research, U of Michigan, 1990; and DISCUS " Minimum Purchase Age By State and Beverage, 1933-Present".
MINAGEGF.SAV
Seat Belt Laws
1984
2002
51
National Safety Council, Injury Facts (previously Accident Facts), annual.
SEATBELT.SAV
Alcohol Highway Laws
1982
2002
51
US Dept. of Transportation, National Highway Traffic Safety Administration, Digest of State Alcohol-Highway Safety Related Legislation (annual)
NHTSALEG.SAV
Alcohol Laws from DISCUS
1972
2004
51
Distilled Spirits Council of the United States (DISCUS), Summary of State Laws and Regulations Relating to Distilled Spirits (serial: 14 editions over these 33 years).
DISCUS_LAWS.SAV
.08 BAC Laws
1970
2004
51
National Center Against Drunk Driving (NCADD) web page, citing NHTSA as ultimate source.
08BACLAW.SAV
Zero Tolerance .02 under 21
1970
2004
51
Faxed table from NHTSA forwarded by Chris Carpenter in early July 2005.
ZT_AGE21_POINT02.SAV
Keg Registration
1970
2003
51
Wagenaar, AC, Harwood, EM, Silianoff, C, Toomey, TL, "Measuring public policy: The case of beer keg registration laws," Evaluation & Program Planning, Nov05, Vol. 28, Issue 4, pp. 359-367. Table 1.
KEGREGIS.SAV
Population in Counties Dry for Beer
1969
1998
51
Beer Institute, Brewer's Almanac (annual)
BEERDRY.SAV
Percent Living in Areas Wet for Spirits (DISCUS)
1967
1984
51
Distilled Spirits Council of the United States, Annual Statistical Review (annual)
WET.SAV
ControlState Indicator
Unchanging
51
Distilled Spirits Council of the United States
CONTROL.SAV
Enforce
Enforcement Agents
1950
1987
51
Joint Committee of the States / Steve Barsby
ENFORCE.SAV
Seizures of untaxed alcohol, by type
1953
1982
51
Bureau of Alcohol, Tobacco and Firearms, Alcohol, Tobacco and Firearms Summary Statistics: Distilled Spirits Wine, Beer, Tobacco, Firearms Enforcement, Taxes (annual)
SEIZURES.SAV
Demographic
Religious Adherents (Southern Baptist, Catholic, Mormon)
1971
2000
50
Data from GlenmaryResearchCenter, as downloaded from American Religious Data Archive (www.thearda.com).
ARDA RELIGIOUS ADHERENTS.SAV
Membership in Southern Baptist Convention
1968
1989
51
Southern Baptist Convention: Quarterly Review: A Survey of Southern Baptist Progress Summary of Churches by State Conventions
BAPTISTS.SAV
Mormon Church Membership
1960
2000
51
Church of Jesus Christ of Latter Day Saints (newsletters and personal communications)
MORMONS.SAV
Population by Age
1970
2002
51
U.S. Dept. of Commerce, Bureau of the Census, web site
POPBYAGE.SAV
Population by Age, Gender, and Race (NPA)
1967
2001
51
NPA Data Services, Inc.
DEMOG.SAV
Household Counts, Average Household Size and Income (NPA)
1967
2001
51
NPA Data Services, Inc.
HHOLD.SAV
Population in Metropolitan Counties (NPA)
1967
2001
51
NPA Data Services, Inc.
NPAMETRO.SAV
Percent of Population Living in Metropolitan Areas
1970
2000
51
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
METROPOL.SAV
Police (Full Time Equivalent)
1970
2001
51
U.S. Dept. of Justice, Bureau of Justice Statistics, Sourcebook of Criminal Justice Statistics (annual)
POLICE.SAV
Active Physicians
1967
2001
51
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
DOCTORS.SAV
Hospitals and Hospital Beds
1967
2001
51
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
HOSPITAL.SAV
Hotels and Hotel Employees
1967
2001
51
U.S. Dept. of Commerce, Bureau of the Census, County Business Patterns (annual)
HOTELS.SAV
High School Graduates (Public and Some Private)
1970
2002
51
U.S. Dept. of Education, NationalCenter for Education Statistics, Digest of Education Statistics (annual)
HSGRADS.SAV
Years of Schooling Completed
1970
1980
51
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
YRSCHOOL.SAV
Monthly Average Temperature
1931
2000
51
U.S. Dept. of Commerce, National Oceanic and Atmospheric Administration, National Climatic DataCenter, Web Site, Table HCS 4-1: State, Regional, and National Monthly Temperature (Weighted by Area)
TEMPER.SAV
Land Area
1980
2000
51
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
LANDAREA.SAV
Economic
Total Income and Disposable Income
1929
2002
51
U.S. Department of Commerce: Bureau of Economic Analysis, web site
INCOME.SAV
Median Income for 4-person families
1929
2002
51
U.S. Dept. of Commerce, Bureau of the Census, web site, table "Median Income for 4-Person Families, by State"
medinc4.SAV
Annual Labor Force (Employment, Labor Force, Unemp. Number and Rate)
1970
2003
51
U.S. Dept. of Labor, Bureau of Labor Statistics, web site
UNEMPANN.SAV
Employment, Earnings, Income by Sector of Economy (NPA)
1967
2001
51
NPA Data Services, Inc.
ECON.SAV
Consumer Price Index (CPI)
1913
2003
Nat'l
U.S. Bureau of Labor Statistics web site.
CPIANN.SAV
State Bond Ratings
1994
2003
50
U.S. Dept. of Commerce, Bureau of the Census, Statistical Abstract of the United States (annual)
BNDRATNG.SAV
CountyBusiness Patterns
1975
2004
51
U.S. Dept. of Commerce, Bureau of the Census, County Business Patterns (annual)
CNTYBUS.SAV
Traffic
Licensed Drivers
1969
2001
51
U.S. Department of Transportation, Federal Highway Administration, "Highway Statistics" (annual series).
LICENSES.SAV
Licensed Drivers by Age and Gender
1988
2001
40
U.S. Department of Transportation, Federal Highway Administration, "Highway Statistics" (annual series).
DRVBYAGE.SAV
Vehicle Registrations
1969
2001
51
U.S. Department of Transportation, Federal Highway Administration, "Highway Statistics" (annual series).
VREGIST.SAV
Highway Miles
1980
2002
51
U.S. Department of Transportation, Federal Highway Administration, "Highway Statistics" (annual series).
ROADMILE.SAV
Vehicle Miles Traveled
1967
2002
51
U.S. Department of Transportation, Federal Highway Administration, "Highway Statistics" (annual series).
VMILES.SAV
Utility
Matrix of state border connections
Unchanging
51
Created by PRC Staff
STMATRIX.SAV
Counties Bordering Other States
Unchanging
51
Created by PRC Staff
BORDCNTY.SAV

 

National Institute on Alcohol Abuse and Alcoholism National Institutes of Health Department of Health and Human Services USA.gov - Government Made Easy