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

Usa

@kaggle.aestheteaman01_air_quality_across_countries_in_covid19.usa

1.88 MB
179365 rows
9 columns

date Date	country Country	city City	specie Specie	count Count	min Min	max Max	median Median	variance Variance
13-06-2021	UNITED STATES	Oklahoma City	o3	48	8	45.6	26.4	1207.36
19-04-2021	UNITED STATES	Oklahoma City	o3	45	3.2	47.2	32.8	2046.93
24-06-2021	UNITED STATES	Oklahoma City	o3	48	14.5	36.1	28.1	312.87
19-07-2021	UNITED STATES	Oklahoma City	o3	46	13.6	40	28.9	893.52
25-09-2021	UNITED STATES	Oklahoma City	o3	48	19.2	62.2	40	1398.22
01-11-2021	UNITED STATES	Oklahoma City	o3	44	13.6	24.1	16.8	88.27
12-01-2021	UNITED STATES	Oklahoma City	o3	44	2.4	28.1	12.1	569.75
15-03-2021	UNITED STATES	Oklahoma City	o3	48	5.6	37.6	29.6	722.67
16-04-2021	UNITED STATES	Oklahoma City	o3	48	12.1	28.1	18.4	121.13
15-02-2021	UNITED STATES	Oklahoma City	o3	48	14.5	26.4	20	95.23


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