About this Dataset

Allegheny County Air Quality

Air quality data is collected from the Allegheny County Health Department monitors throughout the county. This data must be verified by qualified individuals before it can be considered official. The following data is unverified. This means that any electrical disruption or equipment malfunction can report erroneous monitored data. For more information about the Health Department's Air Quality Program or to view a live version of the dashboard, please visit the ACHD website: https://alleghenycounty.us/Health-Department/Programs/Air-Quality/Air-Quality.aspx
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:45.718961
Tags: _etl, air, air-pollution, air-quality, fine-particulate-matter, health, ozone, pm-2-5, pollution, sulfur-dioxide-so2

Tables

[old Format] Daily Air Quality Data (historical Archive)

@usgov.allegheny_county_city_of_pitts_allegheny_county_air_quality.n__old_format_daily_air_quality_data_historical_archive

3.01 MB
173,076 rows
74 columns

CREATE TABLE n__old_format_daily_air_quality_data_historical_archive (
  "n__id" BIGINT  -- Id,
  "site" VARCHAR,
  "datetime" TIMESTAMP,
  "stat" VARCHAR,
  "bcstat" DOUBLE,
  "bcstat_txt" VARCHAR,
  "black_carbon" DOUBLE,
  "black_carbon_txt" VARCHAR,
  "bp" DOUBLE,
  "bp_txt" VARCHAR,
  "co" DOUBLE,
  "co_txt" VARCHAR,
  "h2s" DOUBLE,
  "h2s_txt" VARCHAR,
  "int_t" DOUBLE,
  "int_t_txt" VARCHAR,
  "no" DOUBLE,
  "no_txt" VARCHAR,
  "no2" DOUBLE,
  "no2_txt" VARCHAR,
  "nox" DOUBLE,
  "nox_txt" VARCHAR,
  "noy" DOUBLE,
  "noy_txt" VARCHAR,
  "noydif" DOUBLE,
  "noydif_txt" VARCHAR,
  "out_rh" DOUBLE,
  "out_rh_txt" VARCHAR,
  "out_t" DOUBLE,
  "out_t_txt" VARCHAR,
  "ozone" DOUBLE,
  "ozone_txt" VARCHAR,
  "ozone2" DOUBLE,
  "ozone2_txt" VARCHAR,
  "per_f" DOUBLE,
  "per_f_txt" VARCHAR,
  "per_f2" DOUBLE,
  "per_f2_txt" VARCHAR,
  "pm10" DOUBLE,
  "pm10_txt" VARCHAR,
  "pm10_fl" DOUBLE,
  "pm10_fl_txt" VARCHAR,
  "pm10b" DOUBLE,
  "pm10b_txt" VARCHAR,
  "pm25" DOUBLE,
  "pm25_txt" VARCHAR,
  "pm25_2" DOUBLE  -- Pm25(2),
  "pm25_2_txt" VARCHAR  -- Pm25(2) Txt,
  "pm25_fl" DOUBLE,
  "pm25_fl_txt" VARCHAR,
  "pm25b" DOUBLE,
  "pm25b_txt" VARCHAR,
  "pm25t" DOUBLE,
  "pm25t_txt" VARCHAR,
  "rwd" DOUBLE,
  "rwd_txt" VARCHAR,
  "rws" DOUBLE,
  "rws_txt" VARCHAR,
  "sigtheta" DOUBLE,
  "sigtheta_txt" VARCHAR,
  "so2" DOUBLE,
  "so2_txt" VARCHAR,
  "sonicwd" DOUBLE,
  "sonicwd_txt" VARCHAR,
  "sonicws" DOUBLE,
  "sonicws_txt" VARCHAR,
  "uvpm" DOUBLE,
  "uvpm_txt" VARCHAR,
  "rainfall" DOUBLE,
  "rainfall_txt" VARCHAR,
  "solarrad" DOUBLE,
  "solarrad_txt" VARCHAR,
  "uv_rad" DOUBLE,
  "uv_rad_txt" VARCHAR
);

[old Format] Hourly Air Quality Data (historical Archive)

@usgov.allegheny_county_city_of_pitts_allegheny_county_air_quality.n__old_format_hourly_air_quality_data_historical_archive

11.99 MB
678,940 rows
73 columns

CREATE TABLE n__old_format_hourly_air_quality_data_historical_archive (
  "n__id" BIGINT  -- Id,
  "site" VARCHAR,
  "datetime" TIMESTAMP,
  "bcstat" DOUBLE,
  "bcstat_txt" VARCHAR,
  "black_carbon" DOUBLE,
  "black_carbon_txt" VARCHAR,
  "bp" DOUBLE,
  "bp_txt" VARCHAR,
  "co" DOUBLE,
  "co_txt" VARCHAR,
  "h2s" DOUBLE,
  "h2s_txt" VARCHAR,
  "int_t" DOUBLE,
  "int_t_txt" VARCHAR,
  "no" DOUBLE,
  "no_txt" VARCHAR,
  "no2" DOUBLE,
  "no2_txt" VARCHAR,
  "nox" DOUBLE,
  "nox_txt" VARCHAR,
  "noy" DOUBLE,
  "noy_txt" VARCHAR,
  "noydif" DOUBLE,
  "noydif_txt" VARCHAR,
  "out_rh" DOUBLE,
  "out_rh_txt" VARCHAR,
  "out_t" DOUBLE,
  "out_t_txt" VARCHAR,
  "ozone" DOUBLE,
  "ozone_txt" VARCHAR,
  "ozone2" DOUBLE,
  "ozone2_txt" VARCHAR,
  "per_f" DOUBLE,
  "per_f_txt" VARCHAR,
  "per_f2" DOUBLE,
  "per_f2_txt" VARCHAR,
  "pm10" DOUBLE,
  "pm10_txt" VARCHAR,
  "pm10_fl" DOUBLE,
  "pm10_fl_txt" VARCHAR,
  "pm10b" DOUBLE,
  "pm10b_txt" VARCHAR,
  "pm25" DOUBLE,
  "pm25_txt" VARCHAR,
  "pm25_2" DOUBLE  -- Pm25(2),
  "pm25_2_txt" VARCHAR  -- Pm25(2) Txt,
  "pm25_fl" DOUBLE,
  "pm25_fl_txt" VARCHAR,
  "pm25b" DOUBLE,
  "pm25b_txt" VARCHAR,
  "pm25t" DOUBLE,
  "pm25t_txt" VARCHAR,
  "rwd" DOUBLE,
  "rwd_txt" VARCHAR,
  "rws" DOUBLE,
  "rws_txt" VARCHAR,
  "sigtheta" DOUBLE,
  "sigtheta_txt" VARCHAR,
  "so2" DOUBLE,
  "so2_txt" VARCHAR,
  "sonicwd" DOUBLE,
  "sonicwd_txt" VARCHAR,
  "sonicws" DOUBLE,
  "sonicws_txt" VARCHAR,
  "uvpm" DOUBLE,
  "uvpm_txt" VARCHAR,
  "rainfall" DOUBLE,
  "rainfall_txt" VARCHAR,
  "solarrad" DOUBLE,
  "solarrad_txt" VARCHAR,
  "uv_rad" DOUBLE,
  "uv_rad_txt" VARCHAR
);