Smoking

CREATE TABLE adults_smoking_2007_2018 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_of_current_tobacco_use_of_adults" DOUBLE  -- Prevalence Of Current Tobacco Use (% Of Adults),
  "prevalence_of_current_tobacco_use_of_adults_1" DOUBLE  -- Prevalence Of Current Tobacco Use (% Of Adults).1,
  "year_1" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE affordability_cigarettes (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_affordability_percentage_of_gdp_per_capita_r_60390fba" DOUBLE  -- Indicator:Affordability - Percentage Of GDP Per Capita Required To Purchase 2000 Cigarettes Of The Most Sold Brand
);

CREATE TABLE comparing_the_share_of_men_and_women_who_are_smoking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_of_current_tobacco_use_females_of_female_adults" DOUBLE  -- Prevalence Of Current Tobacco Use, Females (% Of Female Adults),
  "prevalence_of_current_tobacco_use_males_of_male_adults" DOUBLE  -- Prevalence Of Current Tobacco Use, Males (% Of Male Adults),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE consumption_per_smoker_per_day (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cigarette_consumption_per_smoker_per_day_ihme_ghdx_2012" DOUBLE  -- Cigarette Consumption Per Smoker Per Day (IHME, GHDx (2012))
);

CREATE TABLE daily_smoking_prevalence_bounds (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "daily_smoking_prevalence_both_ihme_ghdx_2012" DOUBLE  -- Daily Smoking Prevalence - Both (IHME, GHDx (2012))
);

CREATE TABLE death_rate_smoking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_sex_both_age_age__482b6033" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE death_rates_smoking_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_sex_both_age_under_5_rate" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: Under 5 (Rate),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_5_14_016971c9" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 5-14 Years (Rate),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_15_4_9f28e0a3" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 15-49 Years (Rate),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_50_6_4cd0fd7b" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 50-69 Years (Rate),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_70_y_7c45b3f1" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 70+ Years (Rate)
);

CREATE TABLE enforcement_of_bans_on_tobacco_advertising (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_enforce_bans_on_tobacco_advertising" BIGINT
);

CREATE TABLE lung_cancer_deaths_per_100000_by_sex_1950_2002 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "age_standardized_death_rate_per_100k_male" DOUBLE,
  "age_standardized_death_rate_per_100k_female" DOUBLE
);

CREATE TABLE number_of_deaths_by_risk_factor (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_2223f033" BIGINT  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_systolic_blood_press_6d2d316d" BIGINT  -- Deaths - Cause: All Causes - Risk: High Systolic Blood Pressure - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_high_in_sodium_sex_b_1e7c3e5c" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet High In Sodium - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_whole_grains__97b77447" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Whole Grains - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_alcohol_use_sex_both_age__c423e43f" BIGINT  -- Deaths - Cause: All Causes - Risk: Alcohol Use - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_fruits_sex_bo_8caf0533" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Fruits - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_water_source_sex_b_2fc61ce0" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Water Source - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_secondhand_smoke_sex_both_bfa91e74" BIGINT  -- Deaths - Cause: All Causes - Risk: Secondhand Smoke - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_birth_weight_sex_both_8686a6c4" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Birth Weight - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_child_wasting_sex_both_ag_fe7dd6b3" BIGINT  -- Deaths - Cause: All Causes - Risk: Child Wasting - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_sex_sex_both_age_a_bd9458b2" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Sex - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_nuts_and_seed_3b9ce52c" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Nuts And Seeds - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_household_air_pollution_f_493ab017" BIGINT  -- Deaths - Cause: All Causes - Risk: Household Air Pollution From Solid Fuels - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_vegetables_se_90ecc789" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Vegetables - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_physical_activity_sex_113bde09" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Physical Activity - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_all__b379affe" BIGINT  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_fasting_plasma_gluco_9c7ae811" BIGINT  -- Deaths - Cause: All Causes - Risk: High Fasting Plasma Glucose - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_air_pollution_sex_both_ag_57d75277" BIGINT  -- Deaths - Cause: All Causes - Risk: Air Pollution - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_body_mass_index_sex__0ab68ab2" BIGINT  -- Deaths - Cause: All Causes - Risk: High Body-mass Index - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_sanitation_sex_bot_769695cd" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Sanitation - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_no_access_to_handwashing__d22ef465" BIGINT  -- Deaths - Cause: All Causes - Risk: No Access To Handwashing Facility - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_bone_mineral_density__0011ff40" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Bone Mineral Density - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_vitamin_a_deficiency_sex__1b749459" BIGINT  -- Deaths - Cause: All Causes - Risk: Vitamin A Deficiency - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_child_stunting_sex_both_a_8f7eb8cb" BIGINT  -- Deaths - Cause: All Causes - Risk: Child Stunting - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_discontinued_breastfeedin_0b193825" BIGINT  -- Deaths - Cause: All Causes - Risk: Discontinued Breastfeeding - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_non_exclusive_breastfeedi_254d4816" BIGINT  -- Deaths - Cause: All Causes - Risk: Non-exclusive Breastfeeding - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_iron_deficiency_sex_both__054f5981" BIGINT  -- Deaths - Cause: All Causes - Risk: Iron Deficiency - Sex: Both - Age: All Ages (Number)
);

CREATE TABLE sales_of_cigarettes_per_adult_per_day (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "sales_of_cigarettes_per_adult_per_day_international_sm_08c08fe8" DOUBLE  -- Sales Of Cigarettes Per Adult Per Day (International Smoking Statistics (2017))
);

CREATE TABLE sales_of_cigarettes_per_adult_per_day_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "sales_of_cigarettes_per_adult_per_day_international_sm_08c08fe8" DOUBLE  -- Sales Of Cigarettes Per Adult Per Day (International Smoking Statistics (2017))
);

CREATE TABLE share_deaths_smoking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_owid_sex_both_age_291fbdf5" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - OWID - Sex: Both - Age: Age-standardized (Percent)
);

CREATE TABLE share_of_adults_who_smoke (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_of_current_tobacco_use_of_adults" DOUBLE  -- Prevalence Of Current Tobacco Use (% Of Adults)
);

CREATE TABLE share_of_cancer_deaths_attributed_to_tobacco (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_neoplasms_risk_smoking_owid_sex_both_age__7b697686" DOUBLE  -- Deaths - Cause: Neoplasms - Risk: Smoking - OWID - Sex: Both - Age: Age-standardized (Percent)
);

CREATE TABLE share_of_tobacco_retail_price_that_is_tax (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_raise_taxes_on_tobacco" BIGINT
);

CREATE TABLE smoking_death_rate_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_sex_both_age_age__482b6033" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: Age-standardized (Rate),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_age__9299c4cd" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: Age-standardized (Rate).1,
  "year_1" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE smoking_deaths_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_sex_both_age_all__b379affe" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_all__27969eeb" DOUBLE  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: All Ages (Number).1,
  "year_1" DOUBLE,
  "income_classifications_world_bank_2017" VARCHAR  -- Income Classifications (World Bank (2017))
);

CREATE TABLE smoking_deaths_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_smoking_sex_both_age_50_6_b0b28631" BIGINT  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 50-69 Years (Number),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_15_4_6475c77e" BIGINT  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 15-49 Years (Number),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_70_y_aeccf6f3" BIGINT  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: 70+ Years (Number)
);

CREATE TABLE support_to_help_to_quit_tobacco_use (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_offer_help_to_quit_tobacco_use" BIGINT
);

CREATE TABLE taxes_as_share_of_cigarette_price (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_average_taxes_as_a_of_cigarette_price_total_tax" DOUBLE  -- Indicator:Average - Taxes As A % Of Cigarette Price - Total Tax
);