apple_health_workouts

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: day, activity_type, hk_workout_activity_type, day (date), start_datetime (date), end_datetime (date), synced_at (date)

CREATE TABLE apple_health_workouts (
    id TEXT PRIMARY KEY,
    day TEXT NOT NULL,
    activity_type TEXT NOT NULL,
    hk_workout_activity_type INTEGER,
    start_datetime TEXT NOT NULL,
    end_datetime TEXT NOT NULL,
    duration_seconds REAL NOT NULL,
    active_calories REAL,
    total_calories REAL,
    distance_meters REAL,
    source_name TEXT,
    source_bundle_id TEXT,
    device_name TEXT,
    metadata_json TEXT,
    raw_json TEXT,
    synced_at TEXT NOT NULL
);
CREATE INDEX idx_apple_health_workouts_day ON apple_health_workouts(day);
CREATE INDEX idx_apple_health_workouts_start ON apple_health_workouts(start_datetime);