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

Stations

@kaggle.rohanrao_air_quality_data_in_india.stations

stationid StationId	stationname StationName	city City	state State	status Status
AP001	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
AP002	Anand Kala Kshetram, Rajamahendravaram - APPCB	Rajamahendravaram	Andhra Pradesh	nan
AP003	Tirumala, Tirupati - APPCB	Tirupati	Andhra Pradesh	nan
AP004	PWD Grounds, Vijayawada - APPCB	Vijayawada	Andhra Pradesh	nan
AP005	GVM Corporation, Visakhapatnam - APPCB	Visakhapatnam	Andhra Pradesh	Active
AS001	Railway Colony, Guwahati - APCB	Guwahati	Assam	Active
BR001	Collectorate, Gaya - BSPCB	Gaya	Bihar	nan
BR002	SFTI Kusdihra, Gaya - BSPCB	Gaya	Bihar	nan
BR003	Industrial Area, Hajipur - BSPCB	Hajipur	Bihar	nan
BR004	Muzaffarpur Collectorate, Muzaffarpur - BSPCB	Muzaffarpur	Bihar	nan


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