Name: Fitbit Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Fitbit Data

The original data set has been taken from https://www.kaggle.com/arashnic/fitbit from Möbius. It contains personal fitness tracker from thirty fitbit users. Thirty eligible Fitbit users consented to the submission of personal tracker data, including minute-level output for physical activity, heart rate, and sleep monitoring. It includes information about daily activity, steps, and heart rate that can be used to explore users’ habits.

Tables

Activity Nr

@kaggle.shivideveshwar_fitbit_data_analysis.activity_nr

13 kB
940 rows
5 columns

CREATE TABLE activity_nr (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "totaldistance" BIGINT,
  "totalactivehours" DOUBLE,
  "sedentaryhours" DOUBLE
);

Activity Summary

@kaggle.shivideveshwar_fitbit_data_analysis.activity_summary

12.77 kB
940 rows
5 columns

CREATE TABLE activity_summary (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "totaldistance" BIGINT,
  "totalactivehours" DOUBLE,
  "sedentaryhours" DOUBLE
);

Dailyactivity Merged

@kaggle.shivideveshwar_fitbit_data_analysis.dailyactivity_merged

28.66 kB
940 rows
12 columns

CREATE TABLE dailyactivity_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "calories" BIGINT,
  "sedentaryminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "veryactiveminutes" BIGINT,
  "sedentaryactivedistance" BIGINT,
  "lightactivedistance" BIGINT,
  "moderatelyactivedistance" BIGINT,
  "veryactivedistance" BIGINT,
  "steptotal" BIGINT
);

Sleep And Activity

@kaggle.shivideveshwar_fitbit_data_analysis.sleep_and_activity

14.19 kB
410 rows
7 columns

CREATE TABLE sleep_and_activity (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "average_sleep_hours" DOUBLE,
  "average_time_in_bed_hours" DOUBLE,
  "average_calories" BIGINT,
  "average_steps" BIGINT,
  "totaldistance" BIGINT
);

Sleep And Activity Nr

@kaggle.shivideveshwar_fitbit_data_analysis.sleep_and_activity_nr

14.39 kB
410 rows
7 columns

CREATE TABLE sleep_and_activity_nr (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "average_sleep_hours" DOUBLE,
  "average_time_in_bed_hours" DOUBLE,
  "average_calories" BIGINT,
  "average_steps" BIGINT,
  "totaldistance" BIGINT
);

Sleepday Merged

@kaggle.shivideveshwar_fitbit_data_analysis.sleepday_merged

8.72 kB
413 rows
6 columns

CREATE TABLE sleepday_merged (
  "id" BIGINT,
  "sleepday" TIMESTAMP,
  "time" VARCHAR,
  "totalsleeprecords" BIGINT,
  "totalminutesasleep" BIGINT,
  "totaltimeinbed" BIGINT
);