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)

Station Day

@kaggle.rohanrao_air_quality_data_in_india.station_day

2.38 MB
108035 rows
16 columns

stationid StationId	date Date	pm2_5 PM2.5	pm10 PM10	no NO	no2 NO2	nox NOx	nh3 NH3	co CO	so2 SO2	o3 O3	benzene Benzene	toluene Toluene	xylene Xylene	aqi AQI	aqi_bucket AQI Bucket
AP001	Fri Nov 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	71.36	115.75	1.75	20.65	12.4	12.19	0.1	10.76	109.26	0.17	5.92	0.1		nan
AP001	Sat Nov 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	81.4	124.5	1.44	20.5	12.08	10.72	0.12	15.24	127.09	0.2	6.5	0.06	184	Moderate
AP001	Sun Nov 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	78.32	129.06	1.26	26	14.85	10.28	0.14	26.96	117.44	0.22	7.95	0.08	197	Moderate
AP001	Mon Nov 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	88.76	135.32	6.6	30.85	21.77	12.91	0.11	33.59	111.81	0.29	7.63	0.12	198	Moderate
AP001	Tue Nov 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	64.18	104.09	2.56	28.07	17.01	11.42	0.09	19	138.18	0.17	5.02	0.07	188	Moderate
AP001	Wed Nov 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	72.47	114.84	5.23	23.2	16.59	12.25	0.16	10.55	109.74	0.21	4.71	0.08	173	Moderate
AP001	Thu Nov 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	69.8	114.86	4.69	20.17	14.54	10.95	0.12	14.07	118.09	0.16	3.52	0.06	165	Moderate
AP001	Fri Dec 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	73.96	113.56	4.58	19.29	13.97	10.95	0.1	13.9	123.8	0.17	2.85	0.04	191	Moderate
AP001	Sat Dec 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	89.9	140.2	7.71	26.19	19.87	13.12	0.1	19.37	128.73	0.25	2.79	0.07	191	Moderate
AP001	Sun Dec 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	87.14	130.52	0.97	21.31	12.12	14.36	0.15	11.41	114.8	0.23	3.82	0.04	227	Poor


CREATE TABLE station_day (
  "stationid" 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
);