Name: Air Quality Data In India (2015 - 2020)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Air Quality Data In India (2015 - 2020)

Context

Air is what keeps humans alive. Monitoring it and understanding its quality is of immense importance to our well-being.

Content

The dataset contains air quality data and AQI (Air Quality Index) at hourly and daily level of various stations across multiple cities in India.

AQI

A tutorial of how AQI is calculated is available here: https://www.kaggle.com/rohanrao/calculating-aqi-air-quality-index

Cities

Ahmedabad, Aizawl, Amaravati, Amritsar, Bengaluru, Bhopal, Brajrajnagar, Chandigarh, Chennai, Coimbatore, Delhi, Ernakulam, Gurugram, Guwahati, Hyderabad, Jaipur, Jorapokhar, Kochi, Kolkata, Lucknow, Mumbai, Patna, Shillong, Talcher, Thiruvananthapuram, Visakhapatnam

Acknowledgements

The data has been made publicly available by the Central Pollution Control Board: https://cpcb.nic.in/ which is the official portal of Government of India. They also have a real-time monitoring app: https://app.cpcbccr.com/AQI_India/

Noise

Similar to air monitoring data, a dataset on noise decibel levels in India is available here: https://www.kaggle.com/rohanrao/noise-monitoring-data-in-india

Tables

City Day

@kaggle.rohanrao_air_quality_data_in_india.city_day

873.39 kB
29,531 rows
16 columns

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
);

City Hour

@kaggle.rohanrao_air_quality_data_in_india.city_hour

14.9 MB
707,875 rows
16 columns

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
);

Station Day

@kaggle.rohanrao_air_quality_data_in_india.station_day

2.49 MB
108,035 rows
16 columns

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
);

Station Hour

@kaggle.rohanrao_air_quality_data_in_india.station_hour

48.91 MB
2,589,083 rows
16 columns

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
);

Stations

@kaggle.rohanrao_air_quality_data_in_india.stations

11.78 kB
230 rows
5 columns

CREATE TABLE stations (
  "stationid" VARCHAR,
  "stationname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "status" VARCHAR
);