Dataset: BellaBeat

About this Dataset

BellaBeat

data collected from thirty Fitbit users between 03/12/2016–05/12/2016.
and this is the data after cleaning process :
https://posit.cloud/spaces/498249/content/7905957

Tables

Dailyactivity

@kaggle.hossamelgebaly_bellabeat.dailyactivity

47.29 KB
940 rows
15 columns


CREATE TABLE dailyactivity (
  "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
);

Heartrate Seconds Merged

@kaggle.hossamelgebaly_bellabeat.heartrate_seconds_merged

12.8 MB
2483658 rows
3 columns


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

Minutemetsnarrow Merged

@kaggle.hossamelgebaly_bellabeat.minutemetsnarrow_merged

6.16 MB
1325580 rows
3 columns


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

Minutesleep Merged

@kaggle.hossamelgebaly_bellabeat.minutesleep_merged

791.6 KB
188521 rows
4 columns


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

Sleepday Merged

@kaggle.hossamelgebaly_bellabeat.sleepday_merged

7.82 KB
413 rows
5 columns


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

Weightloginfo Merged

@kaggle.hossamelgebaly_bellabeat.weightloginfo_merged

7.63 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
);