oura_workouts
2 rows
This data as json, CSV (advanced)
Suggested facets: day (date), start_datetime (date), end_datetime (date)
| id ▼ | day | activity | calories | distance | duration | intensity | start_datetime | end_datetime | raw_json |
|---|---|---|---|---|---|---|---|---|---|
| 863b829a-2bb1-4d9f-9950-c7430ff75ca2 | 2026-03-13 | cycling | 423.8697814941406 | 15996.826970434018 | moderate | 2026-03-13T17:43:00.000-06:00 | 2026-03-13T18:42:00.000-06:00 | {"id": "863b829a-2bb1-4d9f-9950-c7430ff75ca2", "activity": "cycling", "calories": 423.8697814941406, "day": "2026-03-13", "distance": 15996.826970434018, "end_datetime": "2026-03-13T18:42:00.000-06:00", "intensity": "moderate", "label": null, "source": "confirmed", "start_datetime": "2026-03-13T17:43:00.000-06:00"} | |
| ce933f15-d30b-4104-91d0-0f2e9bc5cd4e | 2026-03-19 | yardwork | 152.36192321777344 | 207.43117843660707 | moderate | 2026-03-19T11:30:00.000-06:00 | 2026-03-19T11:50:00.000-06:00 | {"id": "ce933f15-d30b-4104-91d0-0f2e9bc5cd4e", "activity": "yardwork", "calories": 152.36192321777344, "day": "2026-03-19", "distance": 207.43117843660707, "end_datetime": "2026-03-19T11:50:00.000-06:00", "intensity": "moderate", "label": null, "source": "confirmed", "start_datetime": "2026-03-19T11:30:00.000-06:00"} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE oura_workouts (
id TEXT PRIMARY KEY,
day TEXT NOT NULL,
activity TEXT,
calories REAL,
distance REAL,
duration INTEGER,
intensity TEXT,
start_datetime TEXT,
end_datetime TEXT,
raw_json TEXT NOT NULL
);
CREATE INDEX idx_oura_workouts_day ON oura_workouts(day);