Air Pollution

It is a combination of World Pollution Data

@kaggle.pavan9065_air_pollution

Table List

4 tables(2.03 MB)

Death Rates From Air Pollution

Death Rates Total Air Pollution

Number Of Deaths By Risk Factor

Share Deaths Air Pollution

Death Rates From Air Pollution

@kaggle.pavan9065_air_pollution.death_rates_from_air_pollution

253.97 KB
6468 rows
7 columns

entity Entity	code Code	year Year	deaths_air_pollution_sex_both_age_age_standardized_rate Deaths - Air Pollution - Sex: Both - Age: Age-standardized (Rate)	deaths_household_air_pollution_from_solid_fuels_sex_bo_eef99a2c Deaths - Household Air Pollution From Solid Fuels - Sex: Both - Age: Age-standardized (Rate)	deaths_ambient_particulate_matter_pollution_sex_both_a_49ed29f8 Deaths - Ambient Particulate Matter Pollution - Sex: Both - Age: Age-standardized (Rate)	deaths_ambient_ozone_pollution_sex_both_age_age_standa_e2931b26 Deaths - Ambient Ozone Pollution - Sex: Both - Age: Age-standardized (Rate)
Afghanistan	AFG	1990	299.4773088832807	250.36290974237468	46.44658943828465	5.616442030749176
Afghanistan	AFG	1991	291.2779667340464	242.575124973334	46.033840567028406	5.6039601160366725
Afghanistan	AFG	1992	278.96305561506625	232.04387789481063	44.24376603219239	5.611822064825636
Afghanistan	AFG	1993	278.79081474634074	231.6481335037935	44.44014814437854	5.655266062756284
Afghanistan	AFG	1994	287.16292317725527	238.83717682210664	45.594328410021305	5.718922220615058
Afghanistan	AFG	1995	288.01422374242964	239.90659871687808	45.367141130097366	5.739173782337074
Afghanistan	AFG	1996	286.6425885327999	238.51205048775049	45.38359107873392	5.747049995214075
Afghanistan	AFG	1997	286.4474545749148	238.113519904184	45.585062178377854	5.7555086614962
Afghanistan	AFG	1998	286.26520191157164	238.6801502365848	44.83748988696936	5.758544580353425
Afghanistan	AFG	1999	286.6360183477336	238.53929410311216	45.32550113934951	5.793572911264204


CREATE TABLE death_rates_from_air_pollution (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_air_pollution_sex_both_age_age_standardized_rate" DOUBLE,
  "deaths_household_air_pollution_from_solid_fuels_sex_bo_eef99a2c" DOUBLE,
  "deaths_ambient_particulate_matter_pollution_sex_both_a_49ed29f8" DOUBLE,
  "deaths_ambient_ozone_pollution_sex_both_age_age_standa_e2931b26" DOUBLE
);