Skip to content

Mandatory Fitbit Format

This is a description of the format RAPIDS needs to process data for the following Fitbit sensors.

FITBIT_HEARTRATE_SUMMARY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss
DEVICE_ID A string that uniquely identifies a device
HEARTRATE_DAILY_RESTINGHR Daily resting heartrate
HEARTRATE_DAILY_CALORIESOUTOFRANGE Calories spent while heartrate was oustide a heartrate zone
HEARTRATE_DAILY_CALORIESFATBURN Calories spent while heartrate was inside the fat burn zone
HEARTRATE_DAILY_CALORIESCARDIO Calories spent while heartrate was inside the cardio zone
HEARTRATE_DAILY_CALORIESPEAK Calories spent while heartrate was inside the peak zone
FITBIT_HEARTRATE_INTRADAY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss
DEVICE_ID A string that uniquely identifies a device
HEARTRATE Intraday heartrate
HEARTRATE_ZONE Heartrate zone that HEARTRATE belongs to. It is based on the heartrate zone ranges of each device
FITBIT_SLEEP_SUMMARY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss, this either is a copy of LOCAL_START_DATE_TIME or LOCAL_END_DATE_TIME depending on which column is used to assign an episode to a specific day
LOCAL_START_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss representing the start of a daily sleep episode
LOCAL_END_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss representing the end of a daily sleep episode
DEVICE_ID A string that uniquely identifies a device
EFFICIENCY Sleep efficiency computed by fitbit as time asleep / (total time in bed - time to fall asleep)
MINUTES_AFTER_WAKEUP Minutes the participant spent in bed after waking up
MINUTES_ASLEEP Minutes the participant was asleep
MINUTES_AWAKE Minutes the participant was awake
MINUTES_TO_FALL_ASLEEP Minutes the participant spent in bed before falling asleep
MINUTES_IN_BED Minutes the participant spent in bed across the sleep episode
IS_MAIN_SLEEP 0 if this episode is a nap, or 1 if it is a main sleep episode
TYPE stages or classic sleep data
FITBIT_SLEEP_INTRADAY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss, this either is a copy of LOCAL_START_DATE_TIME or LOCAL_END_DATE_TIME depending on which column is used to assign an episode to a specific day
DEVICE_ID A string that uniquely identifies a device
TYPE_EPISODE_ID An id for each unique main or nap episode. Main and nap episodes have different levels, each row in this table is one of such levels, so multiple rows can have the same TYPE_EPISODE_ID
DURATION Duration of the episode level in minutes
IS_MAIN_SLEEP 0 if this episode level belongs to a nap, or 1 if it belongs to a main sleep episode
TYPE type of level: stages or classic sleep data
LEVEL For stages levels one of wake, deep, light, or rem. For classic levels one of awake, restless, and asleep
FITBIT_STEPS_SUMMARY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss
DEVICE_ID A string that uniquely identifies a device
STEPS Daily step count
FITBIT_STEPS_INTRADAY
RAPIDS column Description
TIMESTAMP An UNIX timestamp (13 digits) when a row of data was logged (automatically created by RAPIDS)
LOCAL_DATE_TIME Date time string with format yyyy-mm-dd hh:mm:ss
DEVICE_ID A string that uniquely identifies a device
STEPS Intraday step count (usually every minute)