years_summary
11 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, intensity_time_goal, floors_goal, rem_sleep_avg, rem_sleep_min, rem_sleep_max, calories_goal, calories_consumed_avg, activities, hydration_goal, rr_min, 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.70209081824908 | 33.0 | 203.0 | 53.6256157635468 | 33.0 | 80.0 | 75.68186851907782 | 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 | 1794103 | 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.25 | 0 | 1022000 | ||||||||||||||||
| 2017-01-01 | 73.92174484021213 | 30.0 | 199.0 | 59.43604651162791 | 39.0 | 80.0 | 68.4258233751093 | 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.20827613257501 | 31.0 | 201.0 | 54.917808219178085 | 39.0 | 75.0 | 65.14232325008794 | 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.88108475962224 | 31.0 | 198.0 | 56.56353591160221 | 45.0 | 86.0 | 63.289683310666405 | 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.44251691573772 | 2223.9586776859505 | 1835.314049586777 | 911.5429362880886 | 0 | 1022000 | ||||||||||||||||||
| 2020-01-01 | 69.31923558466217 | 30.0 | 199.0 | 55.09444444444444 | 37.0 | 63.0 | 61.473183498816006 | 34.0 | 180.0 | 20:06:00.000000 | 19:04:00.000000 | 12:31: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.75772266424319 | 2137.900826446281 | 1798.473829201102 | 728.5939226519337 | 0 | 1022000 | ||||||||||||||||||
| 2021-01-01 | 71.5881318364849 | 31.0 | 208.0 | 56.65934065934066 | 36.0 | 71.0 | 63.298177134158244 | 31.0 | 167.0 | 02:58:00.000000 | 13:36:00.000000 | 06:41:00.000000 | 10:00:00.000000 | 2287984 | 2585600 | 1393.1544999999992 | 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.75882418274037 | 30.0 | 214.0 | 56.23835616438356 | 42.0 | 67.0 | 63.07500562261039 | 36.0 | 214.0 | 18:45:00.000000 | 08:25:00.000000 | 05:10:00.000000 | 10:00:00.000000 | 2420572 | 2876070 | 1634.0779 | 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.32411383925776 | 30.0 | 213.0 | 56.112947658402206 | 40.0 | 72.0 | 62.58596630327057 | 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 | 1404.6923999999997 | 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.771181495915627 | 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.9008019617291 | 30.0 | 229.0 | 51.45479452054794 | 42.0 | 62.0 | 62.00937513439126 | 35.0 | 205.0 | 52.92211111111111 | 51.5 | 54.999 | 21:50:00.000000 | 00:56:00.000000 | 10:27:00.000000 | 10:00:00.000000 | 3922370 | 4449510 | 2761.6678999999963 | 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.28274076046179 | 33.0 | 221.0 | 50.53150684931507 | 42.0 | 58.0 | 60.82219615400729 | 41.0 | 204.0 | 53.43000000000001 | 52.6 | 54.2 | 03:38:00.000000 | 13:18:00.000000 | 19:10:00.000000 | 10:00:00.000000 | 3263892 | 4211730 | 2546.8641999999995 | 3650.0 | 07:57:35.000000 | 00:47:00.000000 | 10:17:00.000000 | 01:25:23.000000 | 00:08:00.000000 | 02:51:00.000000 | 30.154993349399483 | 2394.276712328767 | 1795.468493150685 | 1261.3479452054794 | 675250 | 0 | 0 | 1022000 | 71.57190635451505 | 21400 | 808.0942760942761 | 240004 | 94.75766016713092 | 73.0 | 14.18457300275482 | 59.0 | 5.0 | 76.73698630136987 | 19.80821917808219 | ||
| 2026-01-01 | 67.11627926867165 | 39.0 | 229.0 | 49.82410423452769 | 43.0 | 58.0 | 59.41570685964734 | 39.0 | 227.0 | 54.63076923076923 | 52.800000000000004 | 56.5 | 21:51:00.000000 | 10:09:00.000000 | 05:51:00.000000 | 10:00:00.000000 | 2751483 | 3485920 | 1819.3618999999994 | 3070.0 | 07:47:38.000000 | 00:28:00.000000 | 10:04:19.000000 | 01:24:01.000000 | 00:08:00.000000 | 02:42:00.000000 | 27.820137728346683 | 2406.5537459283387 | 1808.0814332247558 | 1322.6201298701299 | 567950 | 0 | 230 | 85857 | 1671.6093499999997 | 859600 | 7.317073170731708 | 1800 | 775.4756097560976 | 190767 | 95.52442996742671 | 72.0 | 14.348534201954397 | 58.0 | 5.0 | 79.48208469055375 | 23.514657980456025 |
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) );