home / saraphina

oura_workouts

2 rows

✎ View and edit SQL

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

CSV options:

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);
Powered by Datasette · Queries took 5.153ms