Name: Air Quality Across Countries In COVID-19
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Air Quality Across Countries In COVID-19

Air Quality Parameters data across geographies during COVID-19

The dataset contains information on Air Quality Parameters across geographies. Each CSV file holds the details for a single country of the Air Quality Values for the years 2020-2021. Within each CSV file data for multiple cities located within the country is made available.

The following are the Air Quality Parameters whose data is present in the files (Along with their notations mentioned in brackets):

Carbon Monoxide (CO)
Dew (dew)
Humidity (humidity)
Nitrogen Dioxide (NO2)
Ozone (O3)
Particulate Matter 10 (pm10)
Particulate Matter 2.5 (pm25)
Pressure (pressure)
Sulphur Dioxide (SO2)
Temperature
Wind Gusts
Wind Speed

Tables

Brazil

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.brazil

140.46 kB
10,683 rows
9 columns

CREATE TABLE brazil (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);

Canada

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.canada

555.44 kB
49,221 rows
9 columns

CREATE TABLE canada (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);

France

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.france

901.81 kB
81,515 rows
9 columns

CREATE TABLE france (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);

India

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.india

1.02 MB
79,769 rows
9 columns

CREATE TABLE india (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);

Italy

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.italy

401.36 kB
37,986 rows
9 columns

CREATE TABLE italy (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);

Usa

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.usa

1.97 MB
179,365 rows
9 columns

CREATE TABLE usa (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "specie" VARCHAR,
  "count" BIGINT,
  "min" DOUBLE,
  "max" DOUBLE,
  "median" DOUBLE,
  "variance" DOUBLE
);