home

james_garmin

Custom SQL query

Tables

_attributes

timestamp, key, value

17 rows

attributes

timestamp, key, value

25 rows

daily_summary

day, hr_min, hr_max, rhr, stress_avg, step_goal, steps, moderate_activity_time, vigorous_activity_time, intensity_time_goal, floors_up, floors_down, floors_goal, distance, calories_goal, calories_total, calories_bmr, calories_active, calories_consumed, hydration_goal, hydration_intake, sweat_loss, spo2_avg, spo2_min, rr_waking_avg, rr_max, rr_min, bb_charged, bb_max, bb_min, description

3,659 rows

device_info

timestamp, file_id, serial_number, software_version, cum_operating_time, battery_status, battery_voltage

42,990 rows

devices

serial_number, timestamp, device_type, manufacturer, product, hardware_version

11 rows

files

id, name, type, serial_number

37,510 rows

resting_hr

day, resting_heart_rate

3,260 rows

sleep

day, start, end, total_sleep, deep_sleep, light_sleep, rem_sleep, awake, avg_spo2, avg_rr, avg_stress, score, qualifier

3,660 rows

sleep_events

timestamp, event, duration

15,647 rows

stress

timestamp, stress

4,184,127 rows

weight

day, weight

74 rows

Views

  • device_info_view
  • files_view

Download SQLite DB: james_garmin.db 323.1 MB

Powered by Datasette · Queries took 5.628ms