Name: Most Polluted Cities And Countries (IQAir Index)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Most Polluted Cities And Countries (IQAir Index)

Air pollution is the contamination of air due to the presence of substances in the atmosphere that are harmful to the health of humans and other living beings, or cause damage to the climate or to materials. There are many different types of air pollutants, such as gases (including ammonia, carbon monoxide, sulfur dioxide, nitrous oxides, methane, carbon dioxide and chlorofluorocarbons), particulates (both organic and inorganic), and biological molecules. Air pollution can cause diseases, allergies, and even death to humans; it can also cause harm to other living organisms such as animals and food crops, and may damage the natural environment (for example, climate change, ozone depletion or habitat degradation) or built environment (for example, acid rain). Both human activity and natural processes can generate air pollution.

dataset is scrapped from the IQAir website.
almost 6k most polluted cities are covered in it.

All values are average.

Tables

Air Quality Index By Cities Iqair

@kaggle.ramjasmaurya_most_polluted_cities_and_countries_iqair_index.air_quality_index_by_cities_iqair

285.34 KB
6475 rows
19 columns


CREATE TABLE air_quality_index_by_cities_iqair (
  "rank" BIGINT,
  "city" VARCHAR,
  "n_2021" DOUBLE,
  "jan_2021" VARCHAR,
  "feb_2021" VARCHAR,
  "mar_2021" VARCHAR,
  "apr_2021" VARCHAR,
  "may_2021" VARCHAR,
  "jun_2021" VARCHAR,
  "jul_2021" VARCHAR,
  "aug_2021" VARCHAR,
  "sep_2021" VARCHAR,
  "oct_2021" VARCHAR,
  "nov_2021" VARCHAR,
  "dec_2021" VARCHAR,
  "n_2020" VARCHAR,
  "n_2019" VARCHAR,
  "n_2018" VARCHAR,
  "n_2017" VARCHAR
);

Air Quality Index Top Countries

@kaggle.ramjasmaurya_most_polluted_cities_and_countries_iqair_index.air_quality_index_top_countries

9.68 KB
118 rows
7 columns


CREATE TABLE air_quality_index_top_countries (
  "rank" BIGINT,
  "country_region" VARCHAR,
  "n_2021" DOUBLE,
  "n_2020" VARCHAR,
  "n_2019" VARCHAR,
  "n_2018" VARCHAR,
  "population" BIGINT
);