Air Quality Across Countries In COVID-19

Air Quality Parameters data across geographies during COVID-19

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19

Table List

6 tables(4.76 MB)

Brazil

Canada

France

India

Italy

Usa

Canada

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.canada

542.42 KB
49221 rows
9 columns

date Date	country Country	city City	specie Specie	count Count	min Min	max Max	median Median	variance Variance
12-03-2021	CA	Hamilton	no2	95	0.3	17	3.8	102.28
29-04-2021	CA	Hamilton	no2	94	1.6	28.1	13.8	482.9
06-08-2021	CA	Hamilton	no2	96	0.3	19.3	3.8	191.88
26-08-2021	CA	Hamilton	no2	88	0.1	16.6	4.6	109.48
06-11-2021	CA	Hamilton	no2	90	1.7	30.7	9.4	832.07
04-02-2021	CA	Hamilton	no2	94	3.3	37.5	9.7	776.12
09-08-2021	CA	Hamilton	no2	72	0.2	22.5	6.3	338.22
25-08-2021	CA	Hamilton	no2	95	0.4	17.4	5.4	127.54
02-09-2021	CA	Hamilton	no2	96	1.3	15	2.9	54.96
29-09-2021	CA	Hamilton	no2	96	0.2	17.3	4.5	155.42


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