About this Dataset

Air Quality Annual Summary

Part of What Works Cities Certification is reporting our city's annual average concentration of PM2.5 (fine particular matter) does not exceed 10 milligrams per cubic meter.

The information is sensor data from the Triple Oak Site (Site Number 0021) and Millbrook School (Site Number 0014).

Please look to the Dataset Schema section below for descriptions of columns and data types.

US Environmental Protection Agency. Air Data App Map [internet database] available at https://www.epa.gov/outdoor-air-quality-data/interactive-map-air-quality-monitors. Accessed January 10, 2023.

US Environmental Protection Agency. Air Quality System Data Mart [internet database] available at http://www.epa.gov/ttn/airs/aqsdatamart. Accessed January 10, 2023.
Organization: Town of Cary, North Carolina
Last updated: 2023-03-24T22:10:48.580427
Tags: air-quality

Tables

Table 1

@usgov.town_of_cary_north_carolina_air_quality_annual_summary.table_1

138.59 kB
1,258 rows
52 columns

CREATE TABLE table_1 (
  "state_code" BIGINT,
  "county_code" BIGINT,
  "site_number" BIGINT,
  "parameter_code" BIGINT,
  "poc" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datum" VARCHAR,
  "parameter_name" VARCHAR,
  "duration_description" VARCHAR,
  "pollutant_standard" VARCHAR,
  "year" BIGINT,
  "units_of_measure" VARCHAR,
  "exceptional_data_type" VARCHAR,
  "observation_count" BIGINT,
  "observation_percent" BIGINT,
  "primary_exceedance_count" DOUBLE,
  "secdary_exceedance_count" DOUBLE,
  "valid_day_count" BIGINT,
  "required_day_count" BIGINT,
  "exceptional_data_count" BIGINT,
  "certification_indicator" VARCHAR,
  "null_data_count" BIGINT,
  "half_mdl_sub_count" BIGINT,
  "arithmetic_mean" DOUBLE,
  "arithmetic_standard_dev" DOUBLE,
  "weighted_arithmetic_mean" DOUBLE,
  "minimum_value" DOUBLE,
  "first_maximum_value" DOUBLE,
  "first_maximum_datetime" TIMESTAMP,
  "second_maximum_value" DOUBLE,
  "second_maximum_datetime" TIMESTAMP,
  "third_maximum_value" DOUBLE,
  "third_maximum_datetime" TIMESTAMP,
  "fourth_maximum_value" DOUBLE,
  "fourth_maximum_datetime" TIMESTAMP,
  "n_50th_perecentile" DOUBLE  -- 50th Perecentile,
  "n_75th_perecentile" DOUBLE  -- 75th Perecentile,
  "n_90th_perecentile" DOUBLE  -- 90th Perecentile,
  "n_95th_perecentile" DOUBLE  -- 95th Perecentile,
  "n_98th_perecentile" DOUBLE  -- 98th Perecentile,
  "n_99th_perecentile" DOUBLE  -- 99th Perecentile,
  "method_count" BIGINT,
  "tribe_name" VARCHAR,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "local_site_name" VARCHAR,
  "address" VARCHAR,
  "msa_or_cbsa_name" VARCHAR,
  "data_source" VARCHAR,
  "monitoring_site_latitude_longitude" VARCHAR
);