This repository is under review for potential modification in compliance with Administration directives.
The AMP PD Knowledge Portal was developed to host and share resources related to Parkinson’s disease research and remains fully operational. We continue to maintain and accept Parkinson’s disease and related disorders data and resources throughout this review process.

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