Name: Fitbit Dataset
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Fitbit Dataset

The file contains a comprehensive record of human activity data collected over a period of time. It includes various parameters related to health and physical activity, providing valuable insights into the individual's lifestyle and fitness level. The data covers:

Calories: Information about the number of calories consumed by the individual. This data can give an overview of the person's dietary habits and energy intake.

Steps: The number of steps taken by the person each day. This data is useful to track daily physical activity and overall movement patterns.

Sleep Data: Details about the individual's sleep patterns, including sleep duration and sleep quality. This information can reveal the person's sleep habits and help identify potential sleep-related issues.

Intensity Activity: Information about the intensity of physical activities performed. It may include data on activities like walking, running, cycling, or other exercises, indicating the level of physical exertion.

Logged Weight: The recorded body weight of the individual at different points in time. Tracking weight changes can offer insights into weight management progress and health goals.

Calories Burned for Activities: Data on the number of calories burned during various physical activities and exercises. This information can be crucial in understanding the effectiveness of different workouts and the overall impact on calorie expenditure.

The comprehensive nature of this data makes it a valuable resource for conducting in-depth analysis of the individual's health and fitness trends over the course of the year. It can be used for various purposes, such as monitoring health progress, identifying patterns in activity levels, and making informed decisions to improve overall well-being and lifestyle.

Tables

Dailyactivity Merged

@kaggle.animeshmahajan_fitbit_dataset.dailyactivity_merged

45.52 KB
940 rows
15 columns


CREATE TABLE dailyactivity_merged (
  "id" BIGINT,
  "activitydate" TIMESTAMP,
  "totalsteps" BIGINT,
  "totaldistance" DOUBLE,
  "trackerdistance" DOUBLE,
  "loggedactivitiesdistance" DOUBLE,
  "veryactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "sedentaryactivedistance" DOUBLE,
  "veryactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "sedentaryminutes" BIGINT,
  "calories" BIGINT
);

Dailycalories Merged

@kaggle.animeshmahajan_fitbit_dataset.dailycalories_merged

7.62 KB
940 rows
3 columns


CREATE TABLE dailycalories_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "calories" BIGINT
);

Dailyintensities Merged

@kaggle.animeshmahajan_fitbit_dataset.dailyintensities_merged

25.74 KB
940 rows
10 columns


CREATE TABLE dailyintensities_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "sedentaryminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "veryactiveminutes" BIGINT,
  "sedentaryactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "veryactivedistance" DOUBLE
);

Dailysteps Merged

@kaggle.animeshmahajan_fitbit_dataset.dailysteps_merged

8.14 KB
940 rows
3 columns


CREATE TABLE dailysteps_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "steptotal" BIGINT
);

Heartrate Seconds Merged

@kaggle.animeshmahajan_fitbit_dataset.heartrate_seconds_merged

5.24 MB
1048575 rows
5 columns


CREATE TABLE heartrate_seconds_merged (
  "id" BIGINT,
  "date_time" TIMESTAMP,
  "value" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR
);

Sleepday Merged

@kaggle.animeshmahajan_fitbit_dataset.sleepday_merged

8.99 KB
413 rows
6 columns


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

Weightloginfo Merged

@kaggle.animeshmahajan_fitbit_dataset.weightloginfo_merged

7.58 KB
67 rows
8 columns


CREATE TABLE weightloginfo_merged (
  "id" BIGINT,
  "date" TIMESTAMP,
  "weightkg" DOUBLE,
  "weightpounds" DOUBLE,
  "fat" DOUBLE,
  "bmi" DOUBLE,
  "ismanualreport" BOOLEAN,
  "logid" DOUBLE
);