Countries Poluation

Cities with high air pollution (AQI)

@kaggle.willianoliveiragibin_countries_poluation

Table List

1 table(146.38 KB)

Air Pollution New

@kaggle.willianoliveiragibin_countries_poluation.air_pollution_new

146.38 KB
6985 rows
9 columns

city City	country Country	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Kabul	Afghanistan	61.8	58.8	46.5	37.5	17.1	18.1
Tirana	Albania	0	0	16.0	12.5	14.5	14.4
Algiers	Algeria	0	21.2	20.2	20.0	17.8	17.4
Ordino	Andorra	0	0	7.4	7.3	5.4	5.3
Luanda	Angola	0	15.9	13.0	11.0	8.8	8.7
Buenos Aires	Argentina	0	12.4	14.2	13.6	14.2	14.2
Cordoba	Argentina	0	0	0	10.3	8.7	8.7
General Pico	Argentina	0	0	0	7.1	7.2	7.2
Mendoza	Argentina	0	0	0	9.3	8.2	8.2
Rafaela	Argentina	0	0	0	10.4	10.7	10.7


CREATE TABLE air_pollution_new (
  "city" VARCHAR,
  "country" VARCHAR,
  "n_2017" VARCHAR,
  "n_2018" VARCHAR,
  "n_2019" VARCHAR,
  "n_2020" VARCHAR,
  "n_2021" VARCHAR,
  "n_2022" VARCHAR,
  "n_2023" VARCHAR
);