Name: Air Pollution
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Air Pollution

Context

The main motto of this data is to explore the pollution data and understand the insights.

Content

This data consists of the Country and the number of deaths due to pollution and other factors.

Acknowledgements

This data is from Ourworldindata

Inspiration

I hope you can understand the seriousness of pollution and analyze the deaths across the world.

Tables

Death Rates From Air Pollution

@kaggle.pavan9065_air_pollution.death_rates_from_air_pollution

260.07 kB
6,468 rows
7 columns

CREATE TABLE death_rates_from_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_air_pollution_sex_both_age_age_standardized_rate" DOUBLE  -- Deaths - Air Pollution - Sex: Both - Age: Age-standardized (Rate),
  "deaths_household_air_pollution_from_solid_fuels_sex_bo_eef99a2c" DOUBLE  -- Deaths - Household Air Pollution From Solid Fuels - Sex: Both - Age: Age-standardized (Rate),
  "deaths_ambient_particulate_matter_pollution_sex_both_a_49ed29f8" DOUBLE  -- Deaths - Ambient Particulate Matter Pollution - Sex: Both - Age: Age-standardized (Rate),
  "deaths_ambient_ozone_pollution_sex_both_age_age_standa_e2931b26" DOUBLE  -- Deaths - Ambient Ozone Pollution - Sex: Both - Age: Age-standardized (Rate)
);

Death Rates Total Air Pollution

@kaggle.pavan9065_air_pollution.death_rates_total_air_pollution

70.47 kB
6,468 rows
4 columns

CREATE TABLE death_rates_total_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_air_pollution_sex_both_age_age_standardized_rate" DOUBLE  -- Deaths - Air Pollution - Sex: Both - Age: Age-standardized (Rate)
);

Number Of Deaths By Risk Factor

@kaggle.pavan9065_air_pollution.number_of_deaths_by_risk_factor

1.77 MB
6,468 rows
32 columns

CREATE TABLE number_of_deaths_by_risk_factor (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "unsafe_water_source" DOUBLE,
  "unsafe_sanitation" DOUBLE,
  "no_access_to_handwashing_facility" DOUBLE,
  "household_air_pollution_from_solid_fuels" DOUBLE,
  "non_exclusive_breastfeeding" DOUBLE,
  "discontinued_breastfeeding" DOUBLE,
  "child_wasting" DOUBLE,
  "child_stunting" DOUBLE,
  "low_birth_weight_for_gestation" DOUBLE,
  "secondhand_smoke" DOUBLE,
  "alcohol_use" DOUBLE,
  "drug_use" DOUBLE,
  "diet_low_in_fruits" DOUBLE,
  "diet_low_in_vegetables" DOUBLE,
  "unsafe_sex" DOUBLE,
  "low_physical_activity" DOUBLE,
  "high_fasting_plasma_glucose" DOUBLE,
  "high_total_cholesterol" DOUBLE,
  "high_body_mass_index" DOUBLE,
  "high_systolic_blood_pressure" DOUBLE,
  "smoking" DOUBLE,
  "iron_deficiency" DOUBLE,
  "vitamin_a_deficiency" DOUBLE,
  "low_bone_mineral_density" DOUBLE,
  "air_pollution" DOUBLE,
  "outdoor_air_pollution" DOUBLE,
  "diet_high_in_sodium" DOUBLE,
  "diet_low_in_whole_grains" DOUBLE,
  "diet_low_in_nuts_and_seeds" DOUBLE
);

Share Deaths Air Pollution

@kaggle.pavan9065_air_pollution.share_deaths_air_pollution

21.4 kB
6,412 rows
4 columns

CREATE TABLE share_deaths_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "air_pollution_total_ihme_2019" DOUBLE  -- Air Pollution (total) (IHME, 2019)
);