Data & Analytics
Today, more than ever before, it is all about the numbers. But burgeoning data from basic research, clinical studies, and epidemiologic studies (including electronic medical records) can be challenging to manage. Data may exist in various formats and distributed across multiple organizations and systems. Integrating these data is a growing need. Interpreting these data using new tools and techniques is equally important. CSR offers Ph.D.-level, highly experienced staff to support these tasks.
Needs Assessment
Data Visualization
Qualitative Data & Analytics
HIPAA Privacy and Security
Primary and Secondary Data & Analytics
Data Cleansing
Environmental Scans
OMB/IRB Process Capability (added)
Data Harmonization and Management
Formative Research
Survey Design and Implementation
Standardized Reporting and Improved Data Collection Techniques
Surveillance Report: Apparent Per Capita Alcohol Consumption
Background. The Surveillance Report on apparent per capita alcohol consumption was first developed by CSR and has been produced annually since the original AEDS contract. It is one of the most consistent and long-standing resources for tracking national, State, and regional alcohol consumption trends in the United States and is used worldwide and by the World Health Organization (WHO). This report has been used by other government agencies and is routinely cited in alcohol research publications and in the media. This report also serves as an important reference, often used by public health professionals and other audiences interested in State-level data.
Data Sources. CSR staff will collect sales and tax receipt information from individual States and the District of Columbia to estimate alcohol consumption for beer, wine, spirits, and all alcohol beverages combined. This is the only primary data collection effort regularly conducted under the AEDS project. CSR staff will collect these data by directly contacting each State’s department of revenue, department of taxation, alcoholic beverage commission, or similar agencies that produce relevant data. When available, these data are obtained online from States that provide some or all such data on their public websites (currently 22 States). In the event that sales or tax receipt data are not available from States or NABCA, we will use shipment data from the alcohol beverage industry sources (Beverage Information Group, 2022 a,b,c).
Methods. CSR will receive data in multiple formats and various units of measurement. CSR staff will carefully examine and enter the data into an Access database. The database incorporates customized formulas created by CSR staff that convert the State-specific sales figures to uniform gallonage estimates for each beverage type. CSR will use estimated average ethanol (pure alcohol) content in the alcoholic beverage types to convert gallons of beer, wine, and spirits into gallons of ethanol for per capita
consumption estimates. The ethanol conversion coefficients, (i.e., proportion of pure alcohol for each beverage type), are 0.045 for beer, 0.129 for wine, and 0.411 for spirits (Doernberg and Stinson, 1985). Updated State population data for persons ages 14 years and older, and 21 years and older, are obtained from the Centers for Disease Control and Prevention Wide-ranging Online Data for Epidemiologic Research (CDC WONDER) online database, a useful ad-hoc query system for analysis of public health data. After CSR staff complete data entry, conversion, and export, they will use the aforementioned SAS
program to conduct quality assurance and control, develop the complete data text file (including the time varying ABV estimates obtained from ARG), and create the updated tables and figures for the report.
