Outdoor Air Pollution

CREATE TABLE air_pollution_london_vs_delhi (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "suspended_particulate_matter_spm_fouquet_and_dpcc_2011" DOUBLE  -- Suspended Particulate Matter (SPM) (Fouquet And DPCC (2011))
);

CREATE TABLE ambient_pollution_death_rates_2017_1990 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_92cbd17e" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Age-standardized (Rate),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_7c4159bc" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Age-standardized (Rate).1,
  "year_1" DOUBLE
);

CREATE TABLE death_rate_from_pm25_vs_pm25_concentration (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_ambient_particulate_matte_912ac1bd" DOUBLE  -- Deaths - Cause: All Causes - Risk: Ambient Particulate Matter Pollution - Sex: Both - Age: Age-standardized (Rate),
  "pm2_5_air_pollution_mean_annual_exposure_micrograms_pe_a3f395b6" DOUBLE  -- PM2.5 Air Pollution, Mean Annual Exposure (micrograms Per Cubic Meter),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE death_rates_from_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_household_air_pollution_f_c15d87f1" DOUBLE  -- Deaths - Cause: All Causes - Risk: Household Air Pollution From Solid Fuels - Sex: Both - Age: Age-standardized (Rate),
  "deaths_cause_all_causes_risk_ambient_particulate_matte_912ac1bd" DOUBLE  -- Deaths - Cause: All Causes - Risk: Ambient Particulate Matter Pollution - Sex: Both - Age: Age-standardized (Rate),
  "deaths_cause_all_causes_risk_air_pollution_sex_both_ag_de74f99c" DOUBLE  -- Deaths - Cause: All Causes - Risk: Air Pollution - Sex: Both - Age: Age-standardized (Rate),
  "deaths_cause_all_causes_risk_ambient_ozone_pollution_s_78a51a77" DOUBLE  -- Deaths - Cause: All Causes - Risk: Ambient Ozone Pollution - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE emissions_of_air_pollutants (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm_index" DOUBLE  -- PM₁₀ (Index),
  "pm_index_9c0060" DOUBLE  -- PM₂.₅ (Index),
  "non_methane_volatile_organic_compounds_index" DOUBLE  -- Non-methane Volatile Organic Compounds (Index),
  "nitrogen_oxides_index" DOUBLE  -- Nitrogen Oxides (Index),
  "ammonia_index" DOUBLE  -- Ammonia (Index),
  "sulphur_dioxide_index" DOUBLE  -- Sulphur Dioxide (Index)
);

CREATE TABLE emissions_of_air_pollutants_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm_index" DOUBLE  -- PM₁₀ (Index),
  "pm_index_9c0060" DOUBLE  -- PM₂.₅ (Index),
  "non_methane_volatile_organic_compounds_index" DOUBLE  -- Non-methane Volatile Organic Compounds (Index),
  "nitrogen_oxides_index" DOUBLE  -- Nitrogen Oxides (Index),
  "ammonia_index" DOUBLE  -- Ammonia (Index),
  "sulphur_dioxide_index" DOUBLE  -- Sulphur Dioxide (Index)
);

CREATE TABLE exposure_pollution_above_who_targets (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm2_5_pollution_population_exposed_to_levels_exceeding_84f5d440" DOUBLE  -- PM2.5 Pollution, Population Exposed To Levels Exceeding WHO Interim Target-1 Value (% Of Total),
  "pm2_5_pollution_population_exposed_to_levels_exceeding_945ef98c" DOUBLE  -- PM2.5 Pollution, Population Exposed To Levels Exceeding WHO Interim Target-2 Value (% Of Total),
  "pm2_5_pollution_population_exposed_to_levels_exceeding_b56b931a" DOUBLE  -- PM2.5 Pollution, Population Exposed To Levels Exceeding WHO Interim Target-3 Value (% Of Total),
  "pm2_5_air_pollution_population_exposed_to_levels_excee_1244c30a" DOUBLE  -- PM2.5 Air Pollution, Population Exposed To Levels Exceeding WHO Guideline Value (% Of Total)
);

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 outdoor_pollution_death_rate (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_92cbd17e" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE outdoor_pollution_deaths_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_2223f033" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: All Ages (Number),
  "continent" VARCHAR,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_8f7238b7" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: All Ages (Number).1,
  "year_1" DOUBLE
);

CREATE TABLE outdoor_pollution_rates_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_d93fc0de" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Under 5 (Rate),
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_df837aa7" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: 5-14 Years (Rate),
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_c2e3f523" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: 70+ Years (Rate),
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_23a1e7aa" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: 15-49 Years (Rate),
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_3f12ec82" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: 50-69 Years (Rate)
);

CREATE TABLE outdoor_pollution_rate_vs_gdp (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_92cbd17e" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Age-standardized (Rate),
  "gdp_per_capita_ppp_constant_2017_international" DOUBLE  -- GDP Per Capita, PPP (constant 2017 International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE pm25_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm2_5_air_pollution_mean_annual_exposure_micrograms_pe_a3f395b6" DOUBLE  -- PM2.5 Air Pollution, Mean Annual Exposure (micrograms Per Cubic Meter)
);

CREATE TABLE pm_exposure_1990_2017 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm2_5_air_pollution_mean_annual_exposure_micrograms_pe_a3f395b6" DOUBLE  -- PM2.5 Air Pollution, Mean Annual Exposure (micrograms Per Cubic Meter),
  "continent" VARCHAR,
  "pm2_5_air_pollution_mean_annual_exposure_micrograms_pe_4e462867" DOUBLE  -- PM2.5 Air Pollution, Mean Annual Exposure (micrograms Per Cubic Meter).1,
  "year_1" DOUBLE
);

CREATE TABLE share_above_who_pollution_guidelines (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pm2_5_air_pollution_population_exposed_to_levels_excee_1244c30a" DOUBLE  -- PM2.5 Air Pollution, Population Exposed To Levels Exceeding WHO Guideline Value (% Of Total)
);

CREATE TABLE share_deaths_outdoor_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_f4775fbd" DOUBLE  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: Age-standardized (Percent)
);