Indoor Air Pollution

CREATE TABLE access_to_clean_fuels_and_technologies_for_cooking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_proportion_of_population_with_primary_relian_6c252176" DOUBLE
);

CREATE TABLE access_to_clean_fuels_for_cooking_vs_gdp_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_proportion_of_population_with_primary_relian_6c252176" DOUBLE,
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE death_rate_by_source_from_indoor_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_c15d87f1" DOUBLE
);

CREATE TABLE death_rate_indoor_pollution_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_c15d87f1" DOUBLE,
  "continent" VARCHAR,
  "deaths_cause_all_causes_risk_household_air_pollution_f_5dcaca3f" DOUBLE,
  "year_1" DOUBLE
);

CREATE TABLE deaths_from_indoor_air_pollution_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_41065243" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_c32f4ed5" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_857be6b2" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_cecfd75a" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_3ae6b3c8" BIGINT
);

CREATE TABLE household_air_pollution_deaths_by_region (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_493ab017" BIGINT
);

CREATE TABLE indoor_pollution_death_rates_clean_fuels (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_c15d87f1" DOUBLE,
  "indicator_proportion_of_population_with_primary_relian_6c252176" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

CREATE TABLE indoor_pollution_deaths_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_493ab017" DOUBLE,
  "continent" VARCHAR,
  "deaths_cause_all_causes_risk_household_air_pollution_f_312ecb5f" DOUBLE,
  "year_1" 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 population_using_solid_fuels_for_cooking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "households_using_solid_fuels_as_the_main_cooking_fuel" DOUBLE
);

CREATE TABLE share_deaths_indoor_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_822c5f0d" DOUBLE
);