About this Dataset

Air Quality Purple Air Sensors

This dataset is made up of hourly measurements of PM2.5 and PM10, and meteorological measurements, collected through DOEE’s Purple Air network in the District of Columbia. The meteorological data collected are the sensor’s internal temperature and relative humidity readings. Measurements are collected to gain a better understanding of hyper-local air quality data. This data is collected through 24-hour continuous measurements.
Organization: District of Columbia
Last updated: 2025-10-30T22:19:48.831237
Tags: air-pollutants, air-quality, dc, district-of-columbia, environment, hourly, no2, ozone, particulate-matter, pm-10, pm-2-5, pollution, purple-air, sensor, washington-dc

Tables

Table 1

@usgov.district_of_columbia_air_quality_purple_air_sensors.table_1

3.49 MB
185,747 rows
16 columns

CREATE TABLE table_1 (
  "sensor_index" BIGINT,
  "reported_datetime" TIMESTAMP,
  "humidity" DOUBLE,
  "temperature" DOUBLE,
  "pressure" DOUBLE,
  "pm1" DOUBLE,
  "pm2_5" DOUBLE,
  "pm10" DOUBLE,
  "pm2_5_cf_1" DOUBLE,
  "pm2_5_alt" DOUBLE,
  "confidence" DOUBLE,
  "voc" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "gis_last_mod_dttm" TIMESTAMP,
  "objectid" BIGINT
);