years_summary_view (view)
10 rows
This data as json, CSV (advanced)
Suggested facets: inactive_hr, weight, vigorous_activity_time, steps_goal_percent, floors_avg, rem_sleep_avg, stress_avg, calories_consumed_avg, activities, hydration_goal, first_day (date)
| first_day | rhr | inactive_hr | weight | intensity_time | moderate_activity_time | vigorous_activity_time | total_steps | steps_avg | steps_goal_percent | total_floors | floors_avg | floors_goal_percent | sleep_avg | rem_sleep_avg | stress_avg | calories_avg | calories_bmr_avg | calories_active_avg | calories_consumed_avg | calories_goal | activities | activities_calories | activities_distance | hydration_goal | hydration_avg | sweat_loss_avg | sweat_loss_avg:1 | spo2_avg | rr_waking_avg |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-01-01 | 50.5 | 60.7 | 53.4 | 20:32:00.000000 | 04:22:00.000000 | 08:05:00.000000 | 3104055 | 8504.0 | 77.0 | 2445.9 | 7.0 | 72.0 | 07:56:59.000000 | 01:25:12.000000 | 30.1 | 2398.2 | 1795.6 | 1287.4 | 0.0 | 629000.0 | 344 | 87942.0 | 1666.2 | 952000.0 | 51.6 | 813.2 | 813.2 | 94.7 | 14.1 |
| 2024-01-01 | 51.5 | 62.0 | 52.9 | 21:46:00.000000 | 00:54:00.000000 | 10:26:00.000000 | 3922370 | 10746.0 | 88.0 | 2760.1 | 8.0 | 76.0 | 07:51:00.000000 | 01:30:36.000000 | 26.9 | 2357.7 | 1794.9 | 1252.5 | 0.0 | 675250.0 | 0 | 1022000.0 | 219.7 | 839.4 | 839.4 | 95.4 | 13.8 | ||
| 2023-01-01 | 56.1 | 62.6 | 52.0 | 00:12:00.000000 | 08:18:00.000000 | 19:57:00.000000 | 3081875 | 8443.0 | 87.0 | 1405.3 | 4.0 | 39.0 | 08:25:17.000000 | 02:15:10.000000 | 26.8 | 2274.2 | 1805.2 | 1003.1 | 455.0 | 29600.0 | 0 | 1022000.0 | 879.3 | 659.6 | 659.6 | 95.7 | 13.7 | ||
| 2022-01-01 | 56.2 | 63.1 | 19:04:00.000000 | 08:44:00.000000 | 05:10:00.000000 | 2420572 | 6631.0 | 84.0 | 1633.0 | 4.0 | 45.0 | 08:53:10.000000 | 02:24:41.000000 | 28.1 | 2267.0 | 1810.3 | 930.8 | 0 | 1022000.0 | ||||||||||
| 2021-01-01 | 56.7 | 63.3 | 02:58:00.000000 | 13:36:00.000000 | 06:41:00.000000 | 2287984 | 6268.0 | 88.0 | 1393.5 | 4.0 | 38.0 | 08:58:23.000000 | 02:27:23.000000 | 28.5 | 2225.5 | 1798.3 | 881.0 | 0 | 1022000.0 | ||||||||||
| 2020-01-01 | 55.1 | 61.5 | 20:44:00.000000 | 19:04:00.000000 | 12:50:00.000000 | 1817981 | 4980.0 | 85.0 | 1037.8 | 3.0 | 29.0 | 09:03:57.000000 | 02:34:58.000000 | 26.8 | 2137.9 | 1798.5 | 728.6 | 0 | 1022000.0 | ||||||||||
| 2019-01-01 | 56.6 | 63.3 | 09:29:00.000000 | 02:39:00.000000 | 15:25:00.000000 | 3030658 | 8303.0 | 91.0 | 2236.6 | 6.0 | 62.0 | 08:32:39.000000 | 02:07:42.000000 | 22.4 | 2224.0 | 1835.3 | 911.5 | 0 | 1022000.0 | ||||||||||
| 2018-01-01 | 54.9 | 65.1 | 54.0 | 11:13:00.000000 | 01:07:00.000000 | 05:03:00.000000 | 3188027 | 8734.0 | 89.0 | 2497.0 | 7.0 | 68.0 | 08:02:04.000000 | 02:05:13.000000 | 30.2 | 2352.9 | 1822.4 | 1135.7 | 0 | 1022000.0 | |||||||||
| 2017-01-01 | 59.4 | 68.4 | 54.0 | 22:01:00.000000 | 22:41:00.000000 | 11:40:00.000000 | 1495398 | 4096.0 | 81.0 | 933.8 | 3.0 | 50.0 | 08:08:58.000000 | 00:00:00.000000 | 36.1 | 2210.0 | 1655.9 | 1277.9 | 0 | 1022000.0 | |||||||||
| 2016-01-01 | 53.6 | 75.7 | 53.0 | 19:16:00.000000 | 17:36:00.000000 | 12:50:00.000000 | 1794054 | 4915.0 | 96.0 | 1066.6 | 3.0 | 52.0 | 08:20:00.000000 | 00:00:00.000000 | 2358.3 | 1704.3 | 1352.2 | 0 | 1022000.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW years_summary_view AS SELECT years_summary.first_day AS first_day, ROUND(years_summary.rhr_avg, 1) AS rhr , ROUND(years_summary.inactive_hr_avg, 1) AS inactive_hr , ROUND(years_summary.weight_avg, 1) AS weight , years_summary.intensity_time AS intensity_time, years_summary.moderate_activity_time AS moderate_activity_time, years_summary.vigorous_activity_time AS vigorous_activity_time, years_summary.steps AS total_steps, ROUND(round(steps / 365), 1) AS steps_avg , ROUND(round((steps * 100) / steps_goal), 1) AS steps_goal_percent , ROUND(floors, 1) AS total_floors , ROUND(round(floors / 365), 1) AS floors_avg , ROUND(round((floors * 100) / floors_goal), 1) AS floors_goal_percent , years_summary.sleep_avg AS sleep_avg, years_summary.rem_sleep_avg AS rem_sleep_avg, ROUND(years_summary.stress_avg, 1) AS stress_avg , ROUND(years_summary.calories_avg, 1) AS calories_avg , ROUND(years_summary.calories_bmr_avg, 1) AS calories_bmr_avg , ROUND(years_summary.calories_active_avg, 1) AS calories_active_avg , ROUND(years_summary.calories_consumed_avg, 1) AS calories_consumed_avg , ROUND(years_summary.calories_goal, 1) AS calories_goal , years_summary.activities AS activities, ROUND(years_summary.activities_calories, 1) AS activities_calories , ROUND(years_summary.activities_distance, 1) AS activities_distance , ROUND(years_summary.hydration_goal, 1) AS hydration_goal , ROUND(years_summary.hydration_avg, 1) AS hydration_avg , ROUND(years_summary.sweat_loss_avg, 1) AS sweat_loss_avg , ROUND(years_summary.sweat_loss_avg, 1) AS sweat_loss_avg , ROUND(years_summary.spo2_avg, 1) AS spo2_avg , ROUND(years_summary.rr_waking_avg, 1) AS rr_waking_avg FROM years_summary ORDER BY years_summary.first_day DESC;