District-wise Air Quality In INDIA
Air Pollutants like SO2,NO2,PM10,PM2.5 (Annual average in micrograms/m3) 2015-17
@kaggle.bharath011_district_wise_air_quality_in_india
Air Pollutants like SO2,NO2,PM10,PM2.5 (Annual average in micrograms/m3) 2015-17
@kaggle.bharath011_district_wise_air_quality_in_india
This Dataset consists of Concentration of Pollutants such as SO2,NO2,PM10,PM2.5 (Annual average in micrograms/m3) from 2015 to 2017. National Ambient Air Quality Standard (NAAQS) for Residential, Industrial, Rural and others Areas (Annual average) for SO2: 50 micrograms/m3; NO2: 40micrograms/m3; PM10: 60 micrograms/m3 & PM2.5: 40 micrograms/m3 and SO2: 20 micrograms/m3; NO2: 30 micrograms/m3; PM10: 60 micrograms/m3 and PM2.5: 40 micrograms/m3 for Ecologically sensitive area.
CREATE TABLE air_quality_in_india (
"states_uts" VARCHAR,
"cities" VARCHAR,
"n_2015_so2" VARCHAR -- 2015 - SO2,
"n_2015_no2" VARCHAR -- 2015 - NO2,
"n_2015_pm10" VARCHAR -- 2015 - PM10,
"n_2015_pm2_5" VARCHAR -- 2015 - PM2.5,
"n_2016_so2" VARCHAR -- 2016 - SO2,
"n_2016_no2" VARCHAR -- 2016 - NO2,
"n_2016_pm10" VARCHAR -- 2016 - PM10,
"n_2016_pm2_5" VARCHAR -- 2016 - PM2.5,
"n_2017_so2" VARCHAR -- 2017 - SO2,
"n_2017_no2" VARCHAR -- 2017 - NO2,
"n_2017_pm10" VARCHAR -- 2017 - PM10,
"n_2017_pm2_5" VARCHAR -- 2017 - PM2.5
);
Anyone who has the link will be able to view this.