Air Quality

City of New York

@usgov.city_of_new_york_air_quality

Table List

1 table(287.44 KB)

Table 1

@usgov.city_of_new_york_air_quality.table_1

287.44 KB
18862 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
336867	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	407	Flushing and Whitestone (CD7)	Winter 2014-15	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	23.97
336741	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	107	Upper West Side (CD7)	Winter 2014-15	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	27.42
550157	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	414	Rockaway and Broad Channel (CD14)	Annual Average 2017	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	12.55
412802	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	407	Flushing and Whitestone (CD7)	Winter 2015-16	Tue Dec 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	22.63
412803	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	407	Flushing and Whitestone (CD7)	Summer 2016	Wed Jun 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	14
412676	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	107	Upper West Side (CD7)	Winter 2015-16	Tue Dec 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	26.43
412677	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	107	Upper West Side (CD7)	Summer 2016	Wed Jun 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	19.1
603044	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	314	Flatbush and Midwood (CD14)	Annual Average 2018	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	17.28
412804	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	407	Flushing and Whitestone (CD7)	Annual Average 2016	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	18.2
825832	375	Nitrogen dioxide (NO2)	Mean	ppb	CD	107	Upper West Side (CD7)	Winter 2021-22	Wed Dec 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	22.07527023


CREATE TABLE table_1 (
  "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
);