Alcohol

Alcohol - Variable Definition Table:

Field Name

Description

Field Values

Variable Summary

alcohol_ever_used Alcohol Use No
Unknown
Yes
Indicator of whether subject has ever used alcohol
alcohol_current_use Alcohol Use No
Unknown
Yes
Current alcohol use indicator
alcohol_recent_use Alcohol Use No
Unknown
Yes
Participant (subject) alcohol consumption past 12 months
alcohol_prior_use Alcohol Use No
Unknown
Yes
Indicator of the participant's/subject's alcohol consumption prior to the past 12 months
alcohol_start_age Alcohol Use   Age in years when participant/subject started ingesting alcoholic beverages, including social drinking
alcohol_stop_age Alcohol Use   Age in years when participant/subject stopped ingesting alcoholic beverages, including social drinking
alcohol_use_frequency Alcohol Use   The frequency of consumption of alcohol by the participant
alcohol_drinks_daily_range Alcohol Use   Alcohol drinking day average drinks consumed range
alcohol_six_more_drinks_frequency Alcohol Use Never
Less than monthly
Unknown
Monthly
Daily or almost daily
Weekly
Alcohol consume six or more drinks frequency
alcohol_related_hospitalization Alcohol Use No
Unknown
Yes
Indicator of whether the participant/subject has been hospitalized for an alcohol-related problem (i.e., esophageal varices, delirium tremens (DTs), cirrhosis and others)
alcohol_drinks_day Alcohol Use 0 - 10 How many drinks do you have on an average day?
alcohol_consumed_years Alcohol Use   How many years consumed alcohol heavily in the past?
alcohol_consumption_change Alcohol Use No
Unknown
Yes
Has your alcohol consumption changed over the past 10 years?
alcohol_inc_dec Alcohol Use Decrease
Increase
Has there been a general increase or decrease in your consumption over a 10-year period

Tables that Reference this Variable:

  • Smoking_and_alcohol_history
     

Data Type Information:
 

Field Name

Type

Mode

alcohol_ever_used ENUMERATION NULLABLE
alcohol_current_use ENUMERATION NULLABLE
alcohol_recent_use ENUMERATION NULLABLE
alcohol_prior_use ENUMERATION NULLABLE
alcohol_start_age INTEGER NULLABLE
alcohol_stop_age INTEGER NULLABLE
alcohol_use_frequency STRING NULLABLE
alcohol_drinks_daily_range STRING NULLABLE
alcohol_six_more_drinks_frequency ENUMERATION NULLABLE
alcohol_related_hospitalization ENUMERATION NULLABLE
alcohol_drinks_day FLOAT NULLABLE
alcohol_consumed_years FLOAT NULLABLE
alcohol_consumption_change ENUMERATION NULLABLE
alcohol_inc_dec ENUMERATION NULLABLE


Curation Notations:

Query Definition
Smoking_and_alcohol_history.alcohol_ever_used is not null AND Smoking_and_alcohol_history.alcohol_ever_used != 'Unknown'

Clinical Data Forms Queried (available as a BigQuery Table and csv File)
Smoking_and_alcohol_history

Criteria
alcohol_ever_used is not null
alcohol_ever_used != 'Unknown'
AND

Query
SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.Smoking_and_alcohol_history` WHERE alcohol_ever_used is not null AND alcohol_ever_used != 'Unknown' GROUP BY Cohort ORDER BY Cohort