Name: FitBit Fitness Tracker Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FitBit Fitness Tracker Data

This dataset generated by respondents to a distributed survey via Amazon Mechanical Turk between 03.12.2016-05.12.2016. Thirty eligible Fitbit users consented to the submission of personal tracker data, including minute-level output for physical activity, heart rate, and sleep monitoring. Individual reports can be parsed by export session ID (column A) or timestamp (column B). Variation between output represents use of different types of Fitbit trackers and individual tracking behaviors / preferences.

Source: Click here
Checkout the metadata

Tables

Dailyactivity Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.dailyactivity_merged

48.42 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.nurudeenabdulsalaam_fitbit_fitness_tracker_data.dailycalories_merged

7.8 kB
940 rows
3 columns

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

Dailyintensities Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.dailyintensities_merged

26.36 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.nurudeenabdulsalaam_fitbit_fitness_tracker_data.dailysteps_merged

8.33 kB
940 rows
3 columns

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

Heartrate Seconds Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.heartrate_seconds_merged

13.42 MB
2,483,658 rows
3 columns

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

Hourlycalories Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.hourlycalories_merged

35.45 kB
22,099 rows
3 columns

CREATE TABLE hourlycalories_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories" BIGINT
);

Hourlyintensities Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.hourlyintensities_merged

48.56 kB
22,099 rows
4 columns

CREATE TABLE hourlyintensities_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "totalintensity" BIGINT,
  "averageintensity" DOUBLE
);

Hourlysteps Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.hourlysteps_merged

46.88 kB
22,099 rows
3 columns

CREATE TABLE hourlysteps_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steptotal" BIGINT
);

Minutecaloriesnarrow Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutecaloriesnarrow_merged

6.63 MB
1,325,580 rows
3 columns

CREATE TABLE minutecaloriesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "calories" DOUBLE
);

Minutecalorieswide Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutecalorieswide_merged

1.58 MB
21,645 rows
62 columns

CREATE TABLE minutecalorieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories00" DOUBLE,
  "calories01" DOUBLE,
  "calories02" DOUBLE,
  "calories03" DOUBLE,
  "calories04" DOUBLE,
  "calories05" DOUBLE,
  "calories06" DOUBLE,
  "calories07" DOUBLE,
  "calories08" DOUBLE,
  "calories09" DOUBLE,
  "calories10" DOUBLE,
  "calories11" DOUBLE,
  "calories12" DOUBLE,
  "calories13" DOUBLE,
  "calories14" DOUBLE,
  "calories15" DOUBLE,
  "calories16" DOUBLE,
  "calories17" DOUBLE,
  "calories18" DOUBLE,
  "calories19" DOUBLE,
  "calories20" DOUBLE,
  "calories21" DOUBLE,
  "calories22" DOUBLE,
  "calories23" DOUBLE,
  "calories24" DOUBLE,
  "calories25" DOUBLE,
  "calories26" DOUBLE,
  "calories27" DOUBLE,
  "calories28" DOUBLE,
  "calories29" DOUBLE,
  "calories30" DOUBLE,
  "calories31" DOUBLE,
  "calories32" DOUBLE,
  "calories33" DOUBLE,
  "calories34" DOUBLE,
  "calories35" DOUBLE,
  "calories36" DOUBLE,
  "calories37" DOUBLE,
  "calories38" DOUBLE,
  "calories39" DOUBLE,
  "calories40" DOUBLE,
  "calories41" DOUBLE,
  "calories42" DOUBLE,
  "calories43" DOUBLE,
  "calories44" DOUBLE,
  "calories45" DOUBLE,
  "calories46" DOUBLE,
  "calories47" DOUBLE,
  "calories48" DOUBLE,
  "calories49" DOUBLE,
  "calories50" DOUBLE,
  "calories51" DOUBLE,
  "calories52" DOUBLE,
  "calories53" DOUBLE,
  "calories54" DOUBLE,
  "calories55" DOUBLE,
  "calories56" DOUBLE,
  "calories57" DOUBLE,
  "calories58" DOUBLE,
  "calories59" DOUBLE
);

Minuteintensitiesnarrow Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minuteintensitiesnarrow_merged

6.15 MB
1,325,580 rows
3 columns

CREATE TABLE minuteintensitiesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "intensity" BIGINT
);

Minuteintensitieswide Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minuteintensitieswide_merged

305.68 kB
21,645 rows
62 columns

CREATE TABLE minuteintensitieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "intensity00" BIGINT,
  "intensity01" BIGINT,
  "intensity02" BIGINT,
  "intensity03" BIGINT,
  "intensity04" BIGINT,
  "intensity05" BIGINT,
  "intensity06" BIGINT,
  "intensity07" BIGINT,
  "intensity08" BIGINT,
  "intensity09" BIGINT,
  "intensity10" BIGINT,
  "intensity11" BIGINT,
  "intensity12" BIGINT,
  "intensity13" BIGINT,
  "intensity14" BIGINT,
  "intensity15" BIGINT,
  "intensity16" BIGINT,
  "intensity17" BIGINT,
  "intensity18" BIGINT,
  "intensity19" BIGINT,
  "intensity20" BIGINT,
  "intensity21" BIGINT,
  "intensity22" BIGINT,
  "intensity23" BIGINT,
  "intensity24" BIGINT,
  "intensity25" BIGINT,
  "intensity26" BIGINT,
  "intensity27" BIGINT,
  "intensity28" BIGINT,
  "intensity29" BIGINT,
  "intensity30" BIGINT,
  "intensity31" BIGINT,
  "intensity32" BIGINT,
  "intensity33" BIGINT,
  "intensity34" BIGINT,
  "intensity35" BIGINT,
  "intensity36" BIGINT,
  "intensity37" BIGINT,
  "intensity38" BIGINT,
  "intensity39" BIGINT,
  "intensity40" BIGINT,
  "intensity41" BIGINT,
  "intensity42" BIGINT,
  "intensity43" BIGINT,
  "intensity44" BIGINT,
  "intensity45" BIGINT,
  "intensity46" BIGINT,
  "intensity47" BIGINT,
  "intensity48" BIGINT,
  "intensity49" BIGINT,
  "intensity50" BIGINT,
  "intensity51" BIGINT,
  "intensity52" BIGINT,
  "intensity53" BIGINT,
  "intensity54" BIGINT,
  "intensity55" BIGINT,
  "intensity56" BIGINT,
  "intensity57" BIGINT,
  "intensity58" BIGINT,
  "intensity59" BIGINT
);

Minutemetsnarrow Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutemetsnarrow_merged

6.46 MB
1,325,580 rows
3 columns

CREATE TABLE minutemetsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "mets" BIGINT
);

Minutesleep Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutesleep_merged

810.6 kB
188,521 rows
4 columns

CREATE TABLE minutesleep_merged (
  "id" BIGINT,
  "date" VARCHAR,
  "value" BIGINT,
  "logid" BIGINT
);

Minutestepsnarrow Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutestepsnarrow_merged

6.37 MB
1,325,580 rows
3 columns

CREATE TABLE minutestepsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "steps" BIGINT
);

Minutestepswide Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.minutestepswide_merged

614.42 kB
21,645 rows
62 columns

CREATE TABLE minutestepswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steps00" BIGINT,
  "steps01" BIGINT,
  "steps02" BIGINT,
  "steps03" BIGINT,
  "steps04" BIGINT,
  "steps05" BIGINT,
  "steps06" BIGINT,
  "steps07" BIGINT,
  "steps08" BIGINT,
  "steps09" BIGINT,
  "steps10" BIGINT,
  "steps11" BIGINT,
  "steps12" BIGINT,
  "steps13" BIGINT,
  "steps14" BIGINT,
  "steps15" BIGINT,
  "steps16" BIGINT,
  "steps17" BIGINT,
  "steps18" BIGINT,
  "steps19" BIGINT,
  "steps20" BIGINT,
  "steps21" BIGINT,
  "steps22" BIGINT,
  "steps23" BIGINT,
  "steps24" BIGINT,
  "steps25" BIGINT,
  "steps26" BIGINT,
  "steps27" BIGINT,
  "steps28" BIGINT,
  "steps29" BIGINT,
  "steps30" BIGINT,
  "steps31" BIGINT,
  "steps32" BIGINT,
  "steps33" BIGINT,
  "steps34" BIGINT,
  "steps35" BIGINT,
  "steps36" BIGINT,
  "steps37" BIGINT,
  "steps38" BIGINT,
  "steps39" BIGINT,
  "steps40" BIGINT,
  "steps41" BIGINT,
  "steps42" BIGINT,
  "steps43" BIGINT,
  "steps44" BIGINT,
  "steps45" BIGINT,
  "steps46" BIGINT,
  "steps47" BIGINT,
  "steps48" BIGINT,
  "steps49" BIGINT,
  "steps50" BIGINT,
  "steps51" BIGINT,
  "steps52" BIGINT,
  "steps53" BIGINT,
  "steps54" BIGINT,
  "steps55" BIGINT,
  "steps56" BIGINT,
  "steps57" BIGINT,
  "steps58" BIGINT,
  "steps59" BIGINT
);

Sleepday Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.sleepday_merged

8 kB
413 rows
5 columns

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

Weightloginfo Merged

@kaggle.nurudeenabdulsalaam_fitbit_fitness_tracker_data.weightloginfo_merged

7.81 kB
67 rows
8 columns

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