Dataset: Air Quality History

About this Dataset

Air Quality History

This dataset contains quality assured and DOEE-certified air quality data collected from the District’s five air monitoring network sites. The dataset covers a three-year period and includes hourly concentration data points from the Environmental Protection Agency (EPA)’s criteria pollutants, air toxics, and speciation. It also includes hourly surface meteorology data points.
Organization: District of Columbia
Last updated: 2024-04-30T17:51:43.235436
Tags: 24-hour-average-of-ozone, air-quality, air-quality-data, carbon-monoxide, district-of-columbia, hourly-ozone, hourly-pm2-5, ozone, pm2-5, washington-dc

Tables

Table 1

@usgov.district_of_columbia_air_quality_history.table_1

499.26 KB
45352 rows
30 columns


CREATE TABLE table_1 (
  "aqsid" BIGINT,
  "site_num" BIGINT,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "parameter_code" BIGINT,
  "parameter_name" VARCHAR,
  "datetime_local" TIMESTAMP,
  "poc" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datum" VARCHAR,
  "units_of_measure" VARCHAR,
  "method_code" DOUBLE,
  "method_name" VARCHAR,
  "date_of_last_change" TIMESTAMP,
  "sample_duration" VARCHAR,
  "pollutant_standard" VARCHAR,
  "event_type" VARCHAR,
  "aqi" DOUBLE,
  "arithmetic_mean" BIGINT,
  "first_max_value" DOUBLE,
  "first_max_hour" BIGINT,
  "observation_count" BIGINT,
  "observation_percent" BIGINT,
  "local_site_name" VARCHAR,
  "address" VARCHAR,
  "city_name" VARCHAR,
  "cbsa_name" VARCHAR,
  "objectid" BIGINT
);