Bellabeat Case Study
Fitbit Data Points _Bellabeat
@kaggle.soroyac_fitbit_data_points_bellabeat
Table List
- 18 tables(40.61 MB)
- Dailyactivity Merged
- Dailycalories Merged
- Dailyintensities Merged
- Dailysteps Merged
- Heartrate Seconds Merged
- Hourlycalories Merged
- Hourlyintensities Merged
- Hourlysteps Merged
- Minutecaloriesnarrow Merged
- Minutecalorieswide Merged
- Minuteintensitiesnarrow Merged
- Minuteintensitieswide Merged
- Minutemetsnarrow Merged
- Minutesleep Merged
- Minutestepsnarrow Merged
- Minutestepswide Merged
- Sleepday Merged
- Weightloginfo Merged
Minuteintensitieswide Merged
@kaggle.soroyac_fitbit_data_points_bellabeat.minuteintensitieswide_merged
- 298.52 KB
- 21645 rows
- 62 columns
idId | activityhourActivityHour | intensity00Intensity00 | intensity01Intensity01 | intensity02Intensity02 | intensity03Intensity03 | intensity04Intensity04 | intensity05Intensity05 | intensity06Intensity06 | intensity07Intensity07 | intensity08Intensity08 | intensity09Intensity09 | intensity10Intensity10 | intensity11Intensity11 | intensity12Intensity12 | intensity13Intensity13 | intensity14Intensity14 | intensity15Intensity15 | intensity16Intensity16 | intensity17Intensity17 | intensity18Intensity18 | intensity19Intensity19 | intensity20Intensity20 | intensity21Intensity21 | intensity22Intensity22 | intensity23Intensity23 | intensity24Intensity24 | intensity25Intensity25 | intensity26Intensity26 | intensity27Intensity27 | intensity28Intensity28 | intensity29Intensity29 | intensity30Intensity30 | intensity31Intensity31 | intensity32Intensity32 | intensity33Intensity33 | intensity34Intensity34 | intensity35Intensity35 | intensity36Intensity36 | intensity37Intensity37 | intensity38Intensity38 | intensity39Intensity39 | intensity40Intensity40 | intensity41Intensity41 | intensity42Intensity42 | intensity43Intensity43 | intensity44Intensity44 | intensity45Intensity45 | intensity46Intensity46 | intensity47Intensity47 | intensity48Intensity48 | intensity49Intensity49 | intensity50Intensity50 | intensity51Intensity51 | intensity52Intensity52 | intensity53Intensity53 | intensity54Intensity54 | intensity55Intensity55 | intensity56Intensity56 | intensity57Intensity57 | intensity58Intensity58 | intensity59Intensity59 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1503960366 | 4/13/2016 12:00:00 AM | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 1:00:00 AM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 2:00:00 AM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 3:00:00 AM | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 4:00:00 AM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 5:00:00 AM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 6:00:00 AM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 7:00:00 AM | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 8:00:00 AM | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 1503960366 | 4/13/2016 9:00:00 AM | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
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
);