Air Pollution Dataset

In-depth air quality measurements across different locations

@kaggle.sahirmaharajj_air_pollution_dataset

Table List

1 table(217.77 KB)

Air Quality

@kaggle.sahirmaharajj_air_pollution_dataset.air_quality

217.77 KB
16218 rows
12 columns

unique_id Unique ID	indicator_id Indicator ID	name Name	measure Measure	measure_info Measure Info	geo_type_name Geo Type Name	geo_join_id Geo Join ID	geo_place_name Geo Place Name	time_period Time Period	start_date Start Date	data_value Data Value
172653	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	203	Bedford Stuyvesant - Crown Heights	Annual Average 2011	Wed Dec 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	25.3
172585	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	203	Bedford Stuyvesant - Crown Heights	Annual Average 2009	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	26.93
336637	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	204	East New York	Annual Average 2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	19.09
336622	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	103	Fordham - Bronx Pk	Annual Average 2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	19.76
172582	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	104	Pelham - Throgs Neck	Annual Average 2009	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	22.83
667327	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	104	Pelham - Throgs Neck	Annual Average 2020	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	16.19
172607	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	306308	Chelsea-Village	Annual Average 2009	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	38.16
172675	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF34	306308	Chelsea-Village	Annual Average 2011	Wed Dec 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	34.96
175345	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF42	206	Borough Park	Winter 2010-11	Wed Dec 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	30.1
176689	375	Nitrogen dioxide (NO2)	Mean	ppb	UHF42	206	Borough Park	Annual Average 2013	Sat Dec 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	20.23


CREATE TABLE air_quality (
  "unique_id" BIGINT,
  "indicator_id" BIGINT,
  "name" VARCHAR,
  "measure" VARCHAR,
  "measure_info" VARCHAR,
  "geo_type_name" VARCHAR,
  "geo_join_id" BIGINT,
  "geo_place_name" VARCHAR,
  "time_period" VARCHAR,
  "start_date" TIMESTAMP,
  "data_value" DOUBLE,
  "message" VARCHAR
);