About this Dataset

TracMyAir Pilot Studies 1 And 2

data for manuscript titled "Smartphone Application (TracMyAir) for Modeling Exposures to PM2.5 and Ozone – Integration with Air Quality Networks and Location-Activity Sensors" by M. Breen, V. Isakov, et al.

This dataset is associated with the following publication:
Breen, M., V. Isakov, C. Seppanen, S. Arunachalam, M. Breen, S. Prince, T. Long, D. Heist, P. Deshmukh, K. Appel, C. Hogrefe, B. Murphy, C. Nolte, R. Owen, G. Pouliot, H. Pye, and J. Rosati Rowe. TracMyAir smartphone application for modeling exposures to PM2.5 and ozone – Integration with air quality networks and location-activity sensors. SCIENCE OF THE TOTAL ENVIRONMENT. Elsevier BV, AMSTERDAM, NETHERLANDS, 959: 178200, (2025).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-04-24T11:59:29.736024
Tags: air-pollution, exposure-modeling, microenvironment, particulate-matter, time-activity

Tables

TracMyAir Figure3 TimeSpent In ME

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure3_timespent_in_me

6.82 kB
90 rows
6 columns

CREATE TABLE tracmyair_figure3_timespent_in_me (
  "participant_id" BIGINT,
  "microenviroment" BIGINT,
  "actual_total_duration_min" DOUBLE  -- Actual-total-duration(min),
  "actual_total_duration" BIGINT  -- Actual-total-duration(%),
  "tracmyair_total_duration_min" BIGINT  -- TracMyAir-Total-Duration(min),
  "tracmyair_total_duration" BIGINT  -- TracMyAir-Total-Duration(%)
);

TracMyAir Figure4 PS1AirNow

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure4_ps1airnow

30.11 kB
402 rows
21 columns

CREATE TABLE tracmyair_figure4_ps1airnow (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_local_time" BIGINT  -- Hour (local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "outdoor_temperature_c" DOUBLE  -- Outdoor Temperature (ºC),
  "outdoor_wind_speed_km_hr" DOUBLE  -- Outdoor Wind Speed (km/hr),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "time_spent_indoors_at_home" DOUBLE  -- Time Spent Indoors At Home (%),
  "pm2_5_exposure_indoors_at_home_g_m" DOUBLE  -- PM2.5 Exposure [indoors At Home] (µg/m³),
  "ozone_exposure_indoors_at_home_ppb" DOUBLE  -- Ozone Exposure [indoors At Home] (ppb),
  "home_air_exchange_rate_hr" DOUBLE  -- Home Air Exchange Rate (/hr),
  "home_pm2_5_infiltration_factor" DOUBLE,
  "home_indoor_pm2_5_level_g_m" DOUBLE  -- Home Indoor PM2.5 Level (µg/m³),
  "personal_pm2_5_exposure_factor" DOUBLE,
  "home_ozone_infiltration_factor" DOUBLE,
  "home_indoor_ozone_level_ppb" DOUBLE  -- Home Indoor Ozone Level (ppb),
  "personal_ozone_exposure_factor" DOUBLE
);

TracMyAir Figure5 O3 PS2AirNow

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure5_o3_ps2airnow

26.45 kB
785 rows
12 columns

CREATE TABLE tracmyair_figure5_o3_ps2airnow (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "time_spent_indoors_at_home" DOUBLE  -- Time Spent Indoors At Home (%),
  "ozone_exposure_indoors_at_home_ppb" DOUBLE  -- Ozone Exposure [indoors At Home] (ppb),
  "home_air_exchange_rate_hr" DOUBLE  -- Home Air Exchange Rate (/hr),
  "home_ozone_infiltration_factor" DOUBLE,
  "home_indoor_ozone_level_ppb" DOUBLE  -- Home Indoor Ozone Level (ppb)
);

TracMyAir Figure5 PM25 PS2PurpleAir

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure5_pm25_ps2purpleair

19.27 kB
747 rows
12 columns

CREATE TABLE tracmyair_figure5_pm25_ps2purpleair (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "time_spent_indoors_at_home" DOUBLE  -- Time Spent Indoors At Home (%),
  "pm2_5_exposure_indoors_at_home_g_m" DOUBLE  -- PM2.5 Exposure [indoors At Home] (µg/m³),
  "home_air_exchange_rate_hr" DOUBLE  -- Home Air Exchange Rate (/hr),
  "home_pm2_5_infiltration_factor" DOUBLE,
  "home_indoor_pm2_5_level_g_m" DOUBLE  -- Home Indoor PM2.5 Level (µg/m³)
);

TracMyAir Figure6 PM25indoor PS2PurpleAir

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure6_pm25indoor_ps2purpleair

12.79 kB
747 rows
9 columns

CREATE TABLE tracmyair_figure6_pm25indoor_ps2purpleair (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "home_indoor_pm2_5_level_g_m" DOUBLE  -- Home Indoor PM2.5 Level (µg/m³),
  "purpleair_home_indoor_pm2_5_level_g_m" DOUBLE  -- PurpleAir Home Indoor PM2.5 Level (µg/m³),
  "non_ambient_home_indoor_pm2_5_level_g_m" VARCHAR  -- Non-ambient Home Indoor PM2.5 Level (µg/m³)
);

TracMyAir Figure7a O3AirNow PS2dose StepsPhone

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7a_o3airnow_ps2dose_stepsphone

16.2 kB
785 rows
9 columns

CREATE TABLE tracmyair_figure7a_o3airnow_ps2dose_stepsphone (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "ozone_dose_g_m" DOUBLE  -- Ozone Dose (µg/m²),
  "ozone_dose_indoors_at_home_g_m" DOUBLE  -- Ozone Dose [indoors At Home] (µg/m²)
);

TracMyAir Figure7a PM25PurpleAir PS2dose StepsPhone

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7a_pm25purpleair_ps2dose_stepsphone

11.66 kB
747 rows
9 columns

CREATE TABLE tracmyair_figure7a_pm25purpleair_ps2dose_stepsphone (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "sp_pm2_5_dose_g_m" DOUBLE  -- SP PM2.5 Dose (µg/m²),
  "sp_pm2_5_dose_indoors_at_home_g_m" DOUBLE  -- SP PM2.5 Dose [indoors At Home] (µg/m²)
);

TracMyAir Figure7b O3AirNow PS2dose StepsWatch

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7b_o3airnow_ps2dose_stepswatch

17.67 kB
930 rows
9 columns

CREATE TABLE tracmyair_figure7b_o3airnow_ps2dose_stepswatch (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_local_time" BIGINT  -- Hour (local Time),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "ozone_dose_g_m" DOUBLE  -- Ozone Dose (µg/m²),
  "ozone_dose_indoors_at_home_g_m" DOUBLE  -- Ozone Dose [indoors At Home] (µg/m²)
);

TracMyAir Figure7b PM25PurpleAir PS2dose StepsWatch

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7b_pm25purpleair_ps2dose_stepswatch

11.69 kB
747 rows
9 columns

CREATE TABLE tracmyair_figure7b_pm25purpleair_ps2dose_stepswatch (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "sw_pm2_5_dose_g_m" DOUBLE  -- SW PM2.5 Dose (µg/m²),
  "sw_pm2_5_dose_indoors_at_home_g_m" DOUBLE  -- SW PM2.5 Dose [indoors At Home] (µg/m²)
);

TracMyAir Figure7c O3AirNow PS2dose HeartRate

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7c_o3airnow_ps2dose_heartrate

18.17 kB
907 rows
9 columns

CREATE TABLE tracmyair_figure7c_o3airnow_ps2dose_heartrate (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_local_time" BIGINT  -- Hour (local Time),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "ozone_dose_g_m" DOUBLE  -- Ozone Dose (µg/m²),
  "ozone_dose_indoors_at_home_g_m" DOUBLE  -- Ozone Dose [indoors At Home] (µg/m²)
);

TracMyAir Figure7c PM25PurpleAir PS2dose HeartRate

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figure7c_pm25purpleair_ps2dose_heartrate

12.08 kB
747 rows
9 columns

CREATE TABLE tracmyair_figure7c_pm25purpleair_ps2dose_heartrate (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "hr_pm2_5_dose_g_m" DOUBLE  -- HR PM2.5 Dose (µg/m²),
  "hr_pm2_5_dose_indoors_at_home_g_m" DOUBLE  -- HR PM2.5 Dose [indoors At Home] (µg/m²)
);

TracMyAir FigureS1 PS1AirNow

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figures1_ps1airnow

23.34 kB
402 rows
17 columns

CREATE TABLE tracmyair_figures1_ps1airnow (
  "p" BIGINT,
  "yr" BIGINT,
  "mo" BIGINT,
  "dy" BIGINT,
  "hr" BIGINT,
  "outdoor_pm2_5_g_m" DOUBLE  -- Outdoor PM2.5 (µg/m³),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "pm2_5_exposure_g_m" DOUBLE  -- PM2.5 Exposure (µg/m³),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "time_spent_indoors_at_home" DOUBLE  -- Time Spent Indoors At Home (%),
  "pm2_5_exposure_indoors_at_home_g_m" DOUBLE  -- PM2.5 Exposure [indoors At Home] (µg/m³),
  "ozone_exposure_indoors_at_home_ppb" DOUBLE  -- Ozone Exposure [indoors At Home] (ppb),
  "home_air_exchange_rate_hr" DOUBLE  -- Home Air Exchange Rate (/hr),
  "home_pm2_5_infiltration_factor" DOUBLE,
  "personal_pm2_5_exposure_factor" DOUBLE,
  "home_ozone_infiltration_factor" DOUBLE,
  "personal_ozone_exposure_factor" DOUBLE
);

TracMyAir FigureS2 O3 PS2AirNow

@usgov.epa_gov_tracmyair_pilot_studies_1_and_2.tracmyair_figures2_o3_ps2airnow

28.36 kB
785 rows
13 columns

CREATE TABLE tracmyair_figures2_o3_ps2airnow (
  "p" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "hour_start_local_time" BIGINT  -- Hour (Start Local Time),
  "outdoor_ozone_ppb" DOUBLE  -- Outdoor Ozone (ppb),
  "ozone_exposure_ppb" DOUBLE  -- Ozone Exposure (ppb),
  "time_spent_indoors_at_home" DOUBLE  -- Time Spent Indoors At Home (%),
  "ozone_exposure_indoors_at_home_ppb" DOUBLE  -- Ozone Exposure [indoors At Home] (ppb),
  "home_air_exchange_rate_hr" DOUBLE  -- Home Air Exchange Rate (/hr),
  "home_ozone_infiltration_factor" DOUBLE,
  "home_indoor_ozone_level_ppb" DOUBLE  -- Home Indoor Ozone Level (ppb),
  "personal_ozone_exposure_factor" DOUBLE
);