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 Hour

@kaggle.rohanrao_air_quality_data_in_india.city_hour

14.21 MB
707875 rows
16 columns

city City	datetime Datetime	no NO	no2 NO2	nox NOx	co CO	so2 SO2	o3 O3	aqi_bucket AQI Bucket
Ahmedabad	Thu Jan 01 2015 01:00:00 GMT+0000 (Coordinated Universal Time)	1	40.01	36.37	1	122.07		nan
Ahmedabad	Thu Jan 01 2015 02:00:00 GMT+0000 (Coordinated Universal Time)	0.02	27.75	19.73	0.02	85.9		nan
Ahmedabad	Thu Jan 01 2015 03:00:00 GMT+0000 (Coordinated Universal Time)	0.08	19.32	11.08	0.08	52.83		nan
Ahmedabad	Thu Jan 01 2015 04:00:00 GMT+0000 (Coordinated Universal Time)	0.3	16.45	9.2	0.3	39.53	153.58	nan
Ahmedabad	Thu Jan 01 2015 05:00:00 GMT+0000 (Coordinated Universal Time)	0.12	14.9	7.85	0.12	32.63		nan
Ahmedabad	Thu Jan 01 2015 06:00:00 GMT+0000 (Coordinated Universal Time)	0.33	15.95	10.82	0.33	29.87	64.25	nan
Ahmedabad	Thu Jan 01 2015 07:00:00 GMT+0000 (Coordinated Universal Time)	0.45	15.94	12.47	0.45	27.41	191.96	nan
Ahmedabad	Thu Jan 01 2015 08:00:00 GMT+0000 (Coordinated Universal Time)	1.03	16.66	16.48	1.03	20.92	177.21	nan
Ahmedabad	Thu Jan 01 2015 09:00:00 GMT+0000 (Coordinated Universal Time)	1.47	16.25	18.02	1.47	16.45	122.08	nan
Ahmedabad	Thu Jan 01 2015 10:00:00 GMT+0000 (Coordinated Universal Time)	2.05	13.78	16.08	2.05	15.14		nan


CREATE TABLE city_hour (
  "city" 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
);