years_summary
10 rows
This data as json, CSV (advanced)
Suggested facets: hr_min, hr_max, rhr_min, rhr_max, inactive_hr_min, inactive_hr_max, weight_avg, weight_min, weight_max, vigorous_activity_time, intensity_time_goal, floors_goal, rem_sleep_avg, rem_sleep_min, rem_sleep_max, calories_consumed_avg, activities, hydration_goal, first_day (date)
| first_day ▼ | hr_avg | hr_min | hr_max | rhr_avg | rhr_min | rhr_max | inactive_hr_avg | inactive_hr_min | inactive_hr_max | weight_avg | weight_min | weight_max | intensity_time | moderate_activity_time | vigorous_activity_time | intensity_time_goal | steps | steps_goal | floors | floors_goal | sleep_avg | sleep_min | sleep_max | rem_sleep_avg | rem_sleep_min | rem_sleep_max | stress_avg | calories_avg | calories_bmr_avg | calories_active_avg | calories_goal | calories_consumed_avg | activities | activities_calories | activities_distance | hydration_goal | hydration_avg | hydration_intake | sweat_loss_avg | sweat_loss | spo2_avg | spo2_min | rr_waking_avg | rr_max | rr_min | bb_max | bb_min |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2016-01-01 | 79.70226626086028 | 33.0 | 203.0 | 53.6256157635468 | 33.0 | 80.0 | 75.68948163059889 | 42.0 | 181.0 | 53.0 | 52.5 | 54.0 | 19:16:00.000000 | 17:36:00.000000 | 12:50:00.000000 | 00:00:00.000000 | 1794054 | 1861773 | 1066.5781999999997 | 2060.0 | 08:20:00.000000 | 04:53:00.000000 | 12:21:00.000000 | 00:00:00.000000 | 00:00:00.000000 | 00:00:00.000000 | 2358.2512077294687 | 1704.3155339805826 | 1352.205 | 0 | 1022000 | ||||||||||||||||
| 2017-01-01 | 73.92251832148997 | 30.0 | 199.0 | 59.43604651162791 | 39.0 | 80.0 | 68.42916788037674 | 40.0 | 182.0 | 54.0 | 54.0 | 54.0 | 22:01:00.000000 | 22:41:00.000000 | 11:40:00.000000 | 10:00:00.000000 | 1495398 | 1833387 | 933.7846000000005 | 1880.0 | 08:08:58.000000 | 04:16:00.000000 | 12:01:00.000000 | 00:00:00.000000 | 00:00:00.000000 | 00:00:00.000000 | 36.08828842637704 | 2209.978947368421 | 1655.872340425532 | 1277.8947368421052 | 0 | 1022000 | |||||||||||||||
| 2018-01-01 | 72.20864544359347 | 31.0 | 201.0 | 54.917808219178085 | 39.0 | 75.0 | 65.14364203771262 | 35.0 | 181.0 | 54.0 | 54.0 | 54.0 | 11:13:00.000000 | 01:07:00.000000 | 05:03:00.000000 | 10:00:00.000000 | 3188027 | 3561420 | 2496.9790999999996 | 3650.0 | 08:02:04.000000 | 00:55:00.000000 | 11:48:00.000000 | 02:05:13.000000 | 00:23:00.000000 | 04:16:00.000000 | 30.221930575791617 | 2352.9479452054793 | 1822.3808219178081 | 1135.6602739726027 | 0 | 1022000 | |||||||||||||||
| 2019-01-01 | 71.87810172445793 | 31.0 | 198.0 | 56.56353591160221 | 45.0 | 86.0 | 63.283723414586774 | 37.0 | 154.0 | 09:29:00.000000 | 02:39:00.000000 | 15:25:00.000000 | 10:00:00.000000 | 3030658 | 3316830 | 2236.6058999999977 | 3630.0 | 08:32:39.000000 | 02:37:00.000000 | 12:34:00.000000 | 02:07:42.000000 | 00:26:00.000000 | 04:30:00.000000 | 22.442535170130945 | 2223.9586776859505 | 1835.314049586777 | 911.5429362880886 | 0 | 1022000 | ||||||||||||||||||
| 2020-01-01 | 69.31995927520879 | 30.0 | 199.0 | 55.09444444444444 | 37.0 | 63.0 | 61.47381535778064 | 34.0 | 180.0 | 20:44:00.000000 | 19:04:00.000000 | 12:50:00.000000 | 10:00:00.000000 | 1817981 | 2136580 | 1037.8068999999996 | 3630.0 | 09:03:57.000000 | 06:38:00.000000 | 12:54:00.000000 | 02:34:58.000000 | 00:29:00.000000 | 04:53:00.000000 | 26.759496382054994 | 2137.900826446281 | 1798.473829201102 | 728.5939226519337 | 0 | 1022000 | ||||||||||||||||||
| 2021-01-01 | 71.58807269622994 | 31.0 | 208.0 | 56.65934065934066 | 36.0 | 71.0 | 63.295553039472146 | 31.0 | 167.0 | 02:58:00.000000 | 13:36:00.000000 | 06:41:00.000000 | 10:00:00.000000 | 2287984 | 2585600 | 1393.5115999999991 | 3650.0 | 08:58:23.000000 | 05:04:00.000000 | 11:42:00.000000 | 02:27:23.000000 | 00:32:00.000000 | 04:32:00.000000 | 28.538854127780965 | 2225.476712328767 | 1798.2931506849316 | 881.0109890109891 | 0 | 1022000 | ||||||||||||||||||
| 2022-01-01 | 71.76090975281676 | 30.0 | 214.0 | 56.23835616438356 | 42.0 | 67.0 | 63.074255941224976 | 36.0 | 214.0 | 19:04:00.000000 | 08:44:00.000000 | 05:10:00.000000 | 10:00:00.000000 | 2420572 | 2876070 | 1633.0032 | 3650.0 | 08:53:10.000000 | 04:22:00.000000 | 11:44:00.000000 | 02:24:41.000000 | 00:22:00.000000 | 04:28:00.000000 | 28.0805058514075 | 2267.035616438356 | 1810.345205479452 | 930.7972602739726 | 0 | 1022000 | ||||||||||||||||||
| 2023-01-01 | 71.3307799216197 | 30.0 | 213.0 | 56.112947658402206 | 40.0 | 72.0 | 62.60554168153169 | 31.0 | 213.0 | 51.97927586206896 | 50.0 | 55.0 | 00:12:00.000000 | 08:18:00.000000 | 19:57:00.000000 | 10:00:00.000000 | 3081875 | 3517390 | 1405.2949999999996 | 3630.0 | 08:25:17.000000 | 02:02:00.000000 | 13:31:00.000000 | 02:15:10.000000 | 00:16:00.000000 | 04:41:00.000000 | 26.770944739080058 | 2274.2038567493114 | 1805.228650137741 | 1003.0578512396694 | 29600 | 455 | 0 | 1022000 | 879.3103448275862 | 25500 | 659.5925925925926 | 17809 | 95.71428571428571 | 81.0 | 13.685714285714285 | 42.0 | 8.0 | 88.02857142857142 | 33 | ||
| 2024-01-01 | 69.89874577192991 | 30.0 | 229.0 | 51.45479452054794 | 42.0 | 62.0 | 62.00537611285536 | 35.0 | 205.0 | 52.92211111111111 | 51.5 | 54.999 | 21:46:00.000000 | 00:54:00.000000 | 10:26:00.000000 | 10:00:00.000000 | 3922370 | 4449510 | 2760.0936999999967 | 3650.0 | 07:51:00.000000 | 00:08:00.000000 | 11:17:00.000000 | 01:30:36.000000 | 00:05:00.000000 | 03:05:00.000000 | 26.897500148859734 | 2357.66301369863 | 1794.9342465753425 | 1252.4794520547944 | 675250 | 0 | 0 | 1022000 | 219.66666666666666 | 65900 | 839.4080267558528 | 250983 | 95.42857142857143 | 77.0 | 13.848901098901099 | 55.0 | 2.0 | 80.61643835616438 | 25.410958904109588 | ||
| 2025-01-01 | 67.12381458533171 | 33.0 | 194.0 | 50.51176470588236 | 42.0 | 58.0 | 60.72267746984624 | 41.0 | 171.0 | 53.43000000000001 | 52.6 | 54.2 | 20:32:00.000000 | 04:22:00.000000 | 08:05:00.000000 | 10:00:00.000000 | 3104055 | 4014960 | 2445.891799999999 | 3400.0 | 07:56:59.000000 | 00:47:00.000000 | 10:17:00.000000 | 01:25:12.000000 | 00:08:00.000000 | 02:51:00.000000 | 30.112223531639977 | 2398.2294117647057 | 1795.6235294117646 | 1287.438596491228 | 629000 | 0 | 344 | 87942 | 1666.2413499999998 | 952000 | 51.618705035971225 | 14350 | 813.1588447653429 | 225245 | 94.74850299401197 | 73.0 | 14.124260355029586 | 59.0 | 5.0 | 76.67941176470588 | 19.764705882352942 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE years_summary ( first_day DATE NOT NULL, hr_avg FLOAT, hr_min FLOAT, hr_max FLOAT, rhr_avg FLOAT, rhr_min FLOAT, rhr_max FLOAT, inactive_hr_avg FLOAT, inactive_hr_min FLOAT, inactive_hr_max FLOAT, weight_avg FLOAT, weight_min FLOAT, weight_max FLOAT, intensity_time TIME NOT NULL, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, steps INTEGER, steps_goal INTEGER, floors FLOAT, floors_goal FLOAT, sleep_avg TIME NOT NULL, sleep_min TIME NOT NULL, sleep_max TIME NOT NULL, rem_sleep_avg TIME NOT NULL, rem_sleep_min TIME NOT NULL, rem_sleep_max TIME NOT NULL, stress_avg INTEGER, calories_avg INTEGER, calories_bmr_avg INTEGER, calories_active_avg INTEGER, calories_goal INTEGER, calories_consumed_avg INTEGER, activities INTEGER, activities_calories INTEGER, activities_distance INTEGER, hydration_goal INTEGER, hydration_avg INTEGER, hydration_intake INTEGER, sweat_loss_avg INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_max INTEGER, bb_min INTEGER, PRIMARY KEY (first_day) );