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 Hour

@kaggle.rohanrao_air_quality_data_in_india.station_hour

46.64 MB
2589083 rows
16 columns

stationid StationId	datetime Datetime	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_bucket AQI Bucket
AP001	Fri Nov 24 2017 17:00:00 GMT+0000 (Coordinated Universal Time)	60.5	98	2.35	30.8	18.25	8.5	0.1	11.85	126.4	0.1	6.1	0.1	nan
AP001	Fri Nov 24 2017 18:00:00 GMT+0000 (Coordinated Universal Time)	65.5	111.25	2.7	24.2	15.07	9.77	0.1	13.17	117.12	0.1	6.25	0.15	nan
AP001	Fri Nov 24 2017 19:00:00 GMT+0000 (Coordinated Universal Time)	80	132	2.1	25.18	15.15	12.02	0.1	12.08	98.98	0.2	5.98	0.18	nan
AP001	Fri Nov 24 2017 20:00:00 GMT+0000 (Coordinated Universal Time)	81.5	133.25	1.95	16.25	10.23	11.58	0.1	10.47	112.2	0.2	6.72	0.1	nan
AP001	Fri Nov 24 2017 21:00:00 GMT+0000 (Coordinated Universal Time)	75.25	116	1.43	17.48	10.43	12.03	0.1	9.12	106.35	0.2	5.75	0.08	nan
AP001	Fri Nov 24 2017 22:00:00 GMT+0000 (Coordinated Universal Time)	69.25	108.25	0.7	18.47	10.38	13.8	0.1	9.25	91.1	0.2	5.02		nan
AP001	Fri Nov 24 2017 23:00:00 GMT+0000 (Coordinated Universal Time)	67.5	111.5	1.05	12.15	7.3	17.65	0.1	9.4	112.7	0.2	5.6	0.1	nan
AP001	Sat Nov 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	68	111	1.25	14.12	8.5	20.28	0.1	8.9	116.12	0.2	5.55	0.05	nan
AP001	Sat Nov 25 2017 01:00:00 GMT+0000 (Coordinated Universal Time)	73	102	0.3	14.3	7.9	11.5	0.3	11.8	121.5	0.2	6.6		nan
AP001	Sat Nov 25 2017 02:00:00 GMT+0000 (Coordinated Universal Time)	81	123	0.8	24.85	13.88	10.28	0.1	11.62	83.8	0.23	6.77	0.1	nan


CREATE TABLE station_hour (
  "stationid" VARCHAR,
  "datetime" 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
);