A quick guide on how to use the Physical Activity Data Explorer
In addition to the home page, the website consists of 2 other navigation options as follows:
- Data - You can request files you would like to download
- Downloads - Download the files which are ready and manage your existing downloads
Fitbit - Monthly Data tab
In this section users can download monthly data for each month for following data types:
- Steps - Total step count for each day of the month
- Sleep - Total sleep hours for each night of the month
- Calories - Total Calroies burnt for each day of the month
- Heartrate - Resting heartrate for each day of the month
The CSV file is in wide format with each column corresponding to a given day in the month. Other columns are as follows -
- rtid - id of the respondent (participant)
- alir - 0/1, where 1 indicates the respondent is a participant in alir project and 0 if not
- uasclear - 0/1, where 1 indicates the respondent is a participant in the uasclear project and 0 if not
- device - 1, where 1 indicates if the data is coming from Fitbit API
NOTE:
Each record for a given user and a given date can include the following-- Value - value of the data type i.e. record (step count, heart rate, calories, sleep hours)
- “.” - If the Fitbit API returned a record for the user but there was no value for that data type
- “.m” - If the Fitbit API did not return a record
- “.n” - If the user is not participating for the given date
- “.e” - If the Fitbit API consent for the user has expired
Apple - Montly Data tab
Apple data comes from users through the UAS “Zemi” iOS app i.e iPhone users. Here's how it flows into the Activity Data Explorer:Users first pair their fitness tracker (eg. Apple Watch) with their iPhone.
If using fitness trackers other than Apple Watch, users can enable data writing to Apple Health through the device's app.
Users can give permission on the Zemi app for their data to be uploaded.
Once connected, the Zemi app can send the data collected in Apple Health to the UAS Fitbit server. Data is uploaded once per day, but only when the user opens the Zemi app.
In this section users can download monthly data for each month coming from Apple users for following data types:
- Steps - Total step count for each day of the month
- Sleep - Total sleep hours for each night of the month
- Calories - Total Active Calroies burnt for each day of the month
- Heartrate - Resting heartrate for each day of the month
The CSV file is in wide format with each column corresponding to a given day in the month. Other columns are as follows -
- rtid - id of the respondent (participant)
- alir - 0/1, where 1 indicates the respondent is a participant in alir project and 0 if not
- uasclear - 0/1, where 1 indicates the respondent is a participant in the uasclear project and 0 if not
- device - 3, where 3 indicates if the data is coming from Apple device users
NOTE:
Each record for a given user and a given date can include the following-- Value - value of the data type i.e. record (step count, heart rate, calories, sleep hours)
- “.m” - If no data is recorded for that user for the given date
- “.n” - If the user is not participating for the given date
Android - Montly Data tab
Android data comes from users through the UAS “Zemi” Android app, including devices from Samsung, Pixel, Garmin, and others. Here’s how it flows into the Activity Data Explorer: Users first pair their fitness tracker with their Android phone. Once connected, they enable data sharing to Google’s Android Health Connect through the device’s app. Users can give permission on the Zemi app for their data to be uploaded. After that, the Zemi app can send the data collected in Health Connect to the UAS Fitbit server. Data is uploaded once per day, but only when the user opens the Zemi app.
In this section users can download monthly data for each month coming from Android users for following data types:
- Steps - Total step count for each day of the month
- Sleep - Total sleep hours for each night of the month
- Calories - Total Active Calroies burnt for each day of the month
- Heartrate - Resting heartrate for each day of the month
The CSV file is in wide format with each column corresponding to a given day in the month. Other columns are as follows -
- rtid - id of the respondent (participant)
- alir - 0/1, where 1 indicates the respondent is a participant in alir project and 0 if not
- uasclear - 0/1, where 1 indicates the respondent is a participant in the uasclear project and 0 if not
- device - 4, where 4 indicates if the data is coming from Android device users
NOTE:
Each record for a given user and a given date can include the following-- Value - value of the data type i.e. record (step count, heart rate, calories, sleep hours)
- “.m” - If no data is recorded for that user for the given date
- “.n” - If the user is not participating for the given date
Fitbit - Intraday Data tab
In this section users can download Intraday and daily aggregate data for each month in long format where each record is in JSON format as it is returned from the Fitbit API. All CSV files includes two columns UASID and event_date and other columns are the intraday records for the selected data type.
In this section users can download the following file types:
- All Daily (No Sleep) - This will download daily aggregate data with each column representing Aggregate values for following data types:
- Calories
- Distance
- Elevation
- Floors
- Heart
- Steps
- Breathing Rate
- Heartrate Variability
- SpO2
- Temperature Skin
- Temperature Core
- VO2Max
- Intraday files for activezone data and each of the above data types except for VO2Max, temperature core, and temperature skin.
- Heartrate data by every second.
- Sleep (daily+intraday) - This csv file includes two columns sleep-daily and sleep-intraday. The sleep-daily column provides a summary of each sleep session, including total sleep duration, start and end times, and the breakdown of time spent in different sleep stages (e.g., REM, light, core, etc.).The sleep-intraday column records timestamped data showing transitions between sleep stages throughout each session.
NOTE:
Each record for a given user and a given date can include the following-- Value - value of the data type i.e. record (step count, heart rate, calories, sleep hours)
- “.” - If the Fitbit API returned a record for the user but there was no value for that data type
- “.m” - If the Fitbit API did not return a record
- “.n” - If the user is not participating for the given date
- “.e” - If the Fitbit API consent for the user has expired
Apple - Intraday Data tab
In this section users can download Intraday and daily aggregate data for each month in long format where each record is in JSON format with data returned from Apple Health via the Zemi app. All CSV files includes two columns UASID and event_date and other columns are the intraday records for the selected data type.
In this section users can download the following file types:
- All Daily (No Sleep) - This will download daily aggregate data with each column representing Aggregate values for following data types:
- Steps
- Heart
- Active-Calories
- Resting-Calories
- Distance
- Flights-climbed
- VO2max
- Heartrate Variability
- Breathing Rate
- Walking Speed
- Walking Double Support
- Walking Step Length
- Walking Asymmetry
- Stair Ascent Speed
- Stair Descent Speed
- Running Speed
- Running Stride
- Time in Daylight
- Running Ground Contact
- SpO2
- Temperature
- Intraday files for each of the above data types
- Sleep (daily+intraday) - This csv file includes two columns sleep-daily and sleep-intraday. The sleep-daily column provides a summary of each sleep session, including total sleep duration, start and end times, and the breakdown of time spent in different sleep stages (e.g., REM, light, core, etc.).The sleep-intraday column records timestamped data showing transitions between sleep stages throughout each session.
NOTE:
Each record for a given user and a given date can include the following-- JSON record of the data Type
- “.”,".m" - If no data is recorded for that user for the given date
Android - Intraday Data tab
In this section users can download Intraday and daily aggregate data for each month in long format where each record is in JSON format with intraday data representing minute level buckets returned by the Health Connect via the Zemi App. All CSV files includes two columns UASID and event_date and other columns are the intraday records for the selected data type.
In this section users can download the following file types:
- All Daily (No Sleep) - This will download daily aggregate data with each column representing Aggregate values for following data types:
- Calories
- Distance
- Heart
- Steps
- Intraday files for each of the above data types with minute level data, each minute level record includes a key “dd” which indicates the fitness tracker:
- 3-Fitbit
- 4-Garmin
- 5-Aura
- 9-Local Phone or other devices
- Heartrate data by every second.
- Sleep (daily+intraday) - This csv file includes two columns sleep-daily and sleep-intraday.The sleep-daily column provides a summary of each sleep session, including total sleep duration, start and end times, and the breakdown of time spent in different sleep stages (e.g., REM, light, core, etc.).
The sleep-intraday column records timestamped data showing transitions between sleep stages throughout each session. Each intraday level record includes a key “dd” which indicates the fitness tracker:
- 3-Fitbit
- 4-Garmin
- 5-Aura
- 9-Local Phone or other devices
NOTE:
Each record for a given user and a given date can include the following-- JSON record of the data Type
- “.m” - If no data is recorded for that user for the given date
- “.n” - If the user is not participating for the given date
Yearly Data tab
In this section users can download data for a given year. The CSV files downloaded from this section includes two columns uas_id and event_date and other columns are the aggregate records for the selected data type.
Note: The files include values for the metrics extracted from the Fitbit API JSON data
In this section users can download the following file types:
- All Daily (No Sleep) - This will download daily aggregate data with each column representing Aggregate values for following data types: - resting_heart_rate, Out_of_Range_min_hr, Out_of_Range_max_hr, Out_of_Range_minutes, Out_of_Range_calories, Fat_Burn_min_hr, Fat_Burn_max_hr, Fat_Burn_minutes, Fat_Burn_calories, Cardio_min_hr, Cardio_max_hr, Cardio_minutes , Cardio_calories, Peak_min_hr, Peak_max_hr, Peak_minutes, Peak_calories, calories, distance, elevation, floors, steps, br, hrv_daily_rmssd, hrv_deep_rmssd, spo2_avg, spo2_min, spo2_max, vo2_max, temp_skin_nightly_relative and temp_core.
- Sleep (daily+intraday) - This csv file includes columns: start_time, end_time, duration_seconds, efficiency, info_code, is_main_sleep, minutes_after_wakeup, minutes_awake, minutes_asleep, minutes_to_fall_asleep, time_in_bed, summary_deep_count, summary_deep_minutes, summary_deep_minutes_30dayavg, summary_light_count summary_light_minutes, summary_light_minutes_30dayavg, summary_rem_count, summary_rem_minutes, summary_rem_minutes_30dayavg, summary_wake_count, summary_wake_minutes and summary_wake_minutes_30dayavg
NOTE:
Each record for a given user and a given date can include the following-- Value - value of the data type i.e. record (step count, heart rate, calories, sleep hours)
- “.” - If the Fitbit API returned a record for the user but there was no value for that data type
- “.m” - If the Fitbit API did not return a record
- “.n” - If the user is not participating for the given date
- “.e” - If the Fitbit API consent for the user has expired
Alir Pilot Data tab
This study began in August of 2021 with a nationally representative sample of 1,038 UAS members who were provided with Fitbit inspire 2 devices and were followed over the course of one year. Since then, we have allowed members to continue to contribute Fitbit data for as long as they wish to participate. We have data from August 2021 - April 2023
In this section users can download the following file types:
- Activity - Calories
- Steps
- Distance
- Body - BMI
- Body-Fat
- Calories-BMR
- Food Calories-in
- Foods-Water
- Heartrate
- Minutes Fairly Active
- Minutes Lightly Active
- Minutes Sedentary
- Minutes Very Active
- Sleep
- Calories