Air Quality Data - NYC

Precise New York City Air Quality Data, updated through April 2022.

@kaggle.kaggleprollc_air_quality_data_nyc

Table List

1 table(159.95 KB)

Air Quality

@kaggle.kaggleprollc_air_quality_data_nyc.air_quality

159.95 KB
16122 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
216498	386	Ozone (O3)	Mean	ppb	CD	313	Coney Island (CD13)	Summer 2013	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	34.64
216499	386	Ozone (O3)	Mean	ppb	CD	313	Coney Island (CD13)	Summer 2014	Sun Jun 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	33.22
219969	386	Ozone (O3)	Mean	ppb	Borough	1	Bronx	Summer 2013	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.25
219970	386	Ozone (O3)	Mean	ppb	Borough	1	Bronx	Summer 2014	Sun Jun 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	31.15
164876	383	Sulfur Dioxide (SO2)	Mean	ppb	CD	211	Morris Park and Bronxdale (CD11)	Winter 2008-09	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	5.89
164877	383	Sulfur Dioxide (SO2)	Mean	ppb	CD	212	Williamsbridge and Baychester (CD12)	Winter 2008-09	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	5.75
219971	386	Ozone (O3)	Mean	ppb	Borough	2	Brooklyn	Summer 2009	Mon Jun 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	26.27
219972	386	Ozone (O3)	Mean	ppb	Borough	2	Brooklyn	Summer 2010	Tue Jun 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	33.83
164878	383	Sulfur Dioxide (SO2)	Mean	ppb	CD	301	Greenpoint and Williamsburg (CD1)	Winter 2008-09	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	4.33
164879	383	Sulfur Dioxide (SO2)	Mean	ppb	CD	302	Fort Greene and Brooklyn Heights (CD2)	Winter 2008-09	Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	4.41


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