home

james_garmin_summary

Custom SQL query

Tables

_attributes

timestamp, key, value

47 rows

days_summary

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

3,286 rows

intensity_hr

timestamp, intensity, heart_rate

585,112 rows

months_summary

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

110 rows

summary

timestamp, key, value

0 rows

weeks_summary

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

517 rows

years_summary

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

10 rows

Views

  • years_summary_view
  • months_summary_view
  • weeks_summary_view
  • days_summary_view

Download SQLite DB: james_garmin_summary.db 44.8 MB

Powered by Datasette · Queries took 5.326ms