Air Quality Data In India (2015 - 2020)

Air Quality Index (AQI) and hourly data across stations and cities in India

@kaggle.rohanrao_air_quality_data_in_india

Table List

5 tables(64.07 MB)

City Day

@kaggle.rohanrao_air_quality_data_in_india.city_day

852.92 KB
29531 rows
16 columns

city City	date Date	no NO	no2 NO2	nox NOx	co CO	so2 SO2	o3 O3	benzene Benzene	toluene Toluene	xylene Xylene	aqi_bucket AQI Bucket
Ahmedabad	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	0.92	18.22	17.15	0.92	27.64	133.36		0.02		nan
Ahmedabad	Fri Jan 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	0.97	15.69	16.46	0.97	24.55	34.06	3.68	5.5	3.77	nan
Ahmedabad	Sat Jan 03 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	17.4	19.3	29.7	17.4	29.07	30.7	6.8	16.4	2.25	nan
Ahmedabad	Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7	18.48	17.97	1.7	18.59	36.08	4.43	10.14	1	nan
Ahmedabad	Mon Jan 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	22.1	21.42	37.76	22.1	39.33	39.31	7.01	18.89	2.78	nan
Ahmedabad	Tue Jan 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	45.41	38.48	81.5	45.41	45.76	46.51	5.42	10.83	1.93	nan
Ahmedabad	Wed Jan 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	112.16	40.62	130.77	112.16	32.28	33.47				nan
Ahmedabad	Thu Jan 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	80.87	36.74	96.75	80.87	38.54	31.89				nan
Ahmedabad	Fri Jan 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	29.16	31	48	29.16	58.68	25.75				nan
Ahmedabad	Sat Jan 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		7.04			8.29	4.55				nan


CREATE TABLE city_day (
  "city" VARCHAR,
  "date" TIMESTAMP,
  "pm2_5" DOUBLE,
  "pm10" DOUBLE,
  "no" DOUBLE,
  "no2" DOUBLE,
  "nox" DOUBLE,
  "nh3" DOUBLE,
  "co" DOUBLE,
  "so2" DOUBLE,
  "o3" DOUBLE,
  "benzene" DOUBLE,
  "toluene" DOUBLE,
  "xylene" DOUBLE,
  "aqi" DOUBLE,
  "aqi_bucket" VARCHAR
);