Smoking
Smoking = Bad | Not Smoking = Good | I guess dont know lol
@kaggle.programmerrdai_smoking
Smoking = Bad | Not Smoking = Good | I guess dont know lol
@kaggle.programmerrdai_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_1" DOUBLE,
"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
);
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_males_of_male_adults" DOUBLE,
"population_historical_estimates" DOUBLE,
"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
);
CREATE TABLE daily_smoking_prevalence_bounds (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"daily_smoking_prevalence_both_ihme_ghdx_2012" DOUBLE
);
CREATE TABLE death_rate_smoking (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_cause_all_causes_risk_smoking_sex_both_age_age__482b6033" DOUBLE
);
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_5_14_016971c9" DOUBLE,
"deaths_cause_all_causes_risk_smoking_sex_both_age_15_4_9f28e0a3" DOUBLE,
"deaths_cause_all_causes_risk_smoking_sex_both_age_50_6_4cd0fd7b" DOUBLE,
"deaths_cause_all_causes_risk_smoking_sex_both_age_70_y_7c45b3f1" DOUBLE
);
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_high_systolic_blood_press_6d2d316d" BIGINT,
"deaths_cause_all_causes_risk_diet_high_in_sodium_sex_b_1e7c3e5c" BIGINT,
"deaths_cause_all_causes_risk_diet_low_in_whole_grains__97b77447" BIGINT,
"deaths_cause_all_causes_risk_alcohol_use_sex_both_age__c423e43f" BIGINT,
"deaths_cause_all_causes_risk_diet_low_in_fruits_sex_bo_8caf0533" BIGINT,
"deaths_cause_all_causes_risk_unsafe_water_source_sex_b_2fc61ce0" BIGINT,
"deaths_cause_all_causes_risk_secondhand_smoke_sex_both_bfa91e74" BIGINT,
"deaths_cause_all_causes_risk_low_birth_weight_sex_both_8686a6c4" BIGINT,
"deaths_cause_all_causes_risk_child_wasting_sex_both_ag_fe7dd6b3" BIGINT,
"deaths_cause_all_causes_risk_unsafe_sex_sex_both_age_a_bd9458b2" BIGINT,
"deaths_cause_all_causes_risk_diet_low_in_nuts_and_seed_3b9ce52c" BIGINT,
"deaths_cause_all_causes_risk_household_air_pollution_f_493ab017" BIGINT,
"deaths_cause_all_causes_risk_diet_low_in_vegetables_se_90ecc789" BIGINT,
"deaths_cause_all_causes_risk_low_physical_activity_sex_113bde09" BIGINT,
"deaths_cause_all_causes_risk_smoking_sex_both_age_all__b379affe" BIGINT,
"deaths_cause_all_causes_risk_high_fasting_plasma_gluco_9c7ae811" BIGINT,
"deaths_cause_all_causes_risk_air_pollution_sex_both_ag_57d75277" BIGINT,
"deaths_cause_all_causes_risk_high_body_mass_index_sex__0ab68ab2" BIGINT,
"deaths_cause_all_causes_risk_unsafe_sanitation_sex_bot_769695cd" BIGINT,
"deaths_cause_all_causes_risk_no_access_to_handwashing__d22ef465" BIGINT,
"deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT,
"deaths_cause_all_causes_risk_low_bone_mineral_density__0011ff40" BIGINT,
"deaths_cause_all_causes_risk_vitamin_a_deficiency_sex__1b749459" BIGINT,
"deaths_cause_all_causes_risk_child_stunting_sex_both_a_8f7eb8cb" BIGINT,
"deaths_cause_all_causes_risk_discontinued_breastfeedin_0b193825" BIGINT,
"deaths_cause_all_causes_risk_non_exclusive_breastfeedi_254d4816" BIGINT,
"deaths_cause_all_causes_risk_iron_deficiency_sex_both__054f5981" BIGINT
);
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
);
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
);
CREATE TABLE share_deaths_smoking (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_cause_all_causes_risk_smoking_owid_sex_both_age_291fbdf5" DOUBLE
);
CREATE TABLE share_of_adults_who_smoke (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_of_current_tobacco_use_of_adults" DOUBLE
);
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
);
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__9299c4cd" DOUBLE,
"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__27969eeb" DOUBLE,
"year_1" DOUBLE,
"income_classifications_world_bank_2017" VARCHAR
);
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_15_4_6475c77e" BIGINT,
"deaths_cause_all_causes_risk_smoking_sex_both_age_70_y_aeccf6f3" BIGINT
);
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
);
Anyone who has the link will be able to view this.