Smoking

Smoking - Variable Definition Table:

Field Name

Description

Field Values

Variable Summary
tobacco_ever_used Tobacco Use No
Unknown
Yes		 Indicator of whether subject has ever used tobacco
tobacco_current_use Tobacco Use No
Unknown
Yes		 Indicator of whether in your lifetime subject have smoked 100 or more cigarettes (5 packs)
smoked_100_more_cigarettes Tobacco Use No
Unknown
Yes		 Current tobacco use indicator
tobacco_recent_use Tobacco Use No
Unknown
Yes		 Tobacco recent use indicator
tobacco_prior_use Tobacco Use No
Unknown
Yes		 Indicator of the participant's/subject's past regular tobacco (e.g. cigarettes, cigars, chewing tobacco or pipe) use prior to the past 12 months
tobacco_start_age Tobacco Use   Age in years when participant/subject started using tobacco products (e.g. cigarettes, cigars, chewing tobacco or pipe)
tobacco_stop_age Tobacco Use   Age in years when participant/subject stopped using tobacco products (e.g. cigarettes, cigars, chewing tobacco or pipe)
tobacco_product_type Tobacco Use   Type of tobacco product that has been used
cigarettes_per_day Tobacco Use   Average number cigarettes smoked daily
cigarettes_packs_per_day Tobacco Use   Average number packs of cigarettes smoked daily
cigarettes_per_day_current Tobacco Use 0 - 250 Current smokers: average number cigarettes per day?
cigarettes_per_day_past Tobacco Use 0 - 80 Past smokers: average number of cigarettes smoked daily?
smoke_exposure_home Tobacco Use 0 - 15 How many hours a day are you exposed to the cigarette smoke of others (on average) at home?
smoke_exposure_work Tobacco Use 0 - 10 How many hours a day are you exposed to the cigarette smoke of others (on average) at work?
smoke_exposure_other_areas Tobacco Use 0 - 10 How many hours a day are you exposed to the cigarette smoke of others (on average) in other areas?


Tables that Reference this Variable:

  • Smoking_and_alcohol_history
     

Data Type Information:
 

Field Name

Type

Mode
tobacco_ever_used ENUMERATION NULLABLE
tobacco_current_use ENUMERATION NULLABLE
smoked_100_more_cigarettes ENUMERATION NULLABLE
tobacco_recent_use ENUMERATION NULLABLE
tobacco_prior_use ENUMERATION NULLABLE
tobacco_start_age INTEGER NULLABLE
tobacco_stop_age INTEGER NULLABLE
tobacco_product_type STRING NULLABLE
cigarettes_per_day STRING NULLABLE
cigarettes_packs_per_day ENUMERATION NULLABLE
cigarettes_per_day_current INTEGER NULLABLE
cigarettes_per_day_past FLOAT NULLABLE
smoke_exposure_home FLOAT NULLABLE
smoke_exposure_work INTEGER NULLABLE
smoke_exposure_other_areas FLOAT NULLABLE


Curation Notations:  

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

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

Criteria
tobacco_ever_used is not null
tobacco_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 tobacco_ever_used is not null AND tobacco_ever_used != 'Unknown' GROUP BY Cohort ORDER BY Cohort