Metadata for each ride in GoldenCheetah OpenData.

Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData

2,589,036 rows sorted by workout_time

View and edit SQL

Link rowid date sport data workout_time ▼ total_distance athlete
9554 2009-05-13 06:08:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9556 2009-05-14 06:00:11+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9558 2009-05-15 06:13:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9561 2009-05-16 06:49:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9564 2009-05-17 06:15:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9566 2009-05-18 06:13:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9568 2009-05-19 06:10:21+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9571 2009-05-20 06:08:31+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9574 2009-05-21 05:52:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9576 2009-05-22 05:53:04+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9579 2009-05-23 06:28:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9581 2009-05-24 07:06:27+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9583 2009-05-25 06:23:02+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9585 2009-05-26 06:14:47+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9588 2009-05-27 06:02:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9591 2009-05-28 06:05:19+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9593 2009-05-28 18:24:27+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9595 2009-05-29 07:39:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9597 2009-05-30 07:26:36+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9599 2009-05-31 07:12:47+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9601 2009-06-02 06:24:25+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9604 2009-06-03 06:22:27+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9607 2009-06-04 06:06:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9610 2009-06-05 06:10:31+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9612 2009-06-06 06:12:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9615 2009-06-07 06:11:12+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9618 2009-06-08 06:10:20+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9621 2009-06-09 06:38:24+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9623 2009-06-10 06:06:40+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9626 2009-06-11 06:04:22+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9628 2009-06-12 06:08:38+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9631 2009-06-13 06:37:25+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9634 2009-06-14 06:48:41+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9637 2009-06-15 05:48:55+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9638 2009-06-15 05:54:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9640 2009-06-16 06:06:19+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9643 2009-06-17 06:26:29+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9645 2009-06-18 06:54:51+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9648 2009-06-19 05:58:23+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9650 2009-06-20 07:49:06+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9652 2009-06-21 06:36:21+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9655 2009-06-22 06:20:45+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9656 2009-06-22 06:28:20+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9659 2009-06-23 06:24:10+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9662 2009-06-24 05:55:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9664 2009-06-25 06:50:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9667 2009-06-26 06:11:32+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9670 2009-06-27 06:07:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9672 2009-06-28 06:34:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9675 2009-06-29 06:18:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9677 2009-06-30 06:23:25+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9680 2009-07-01 06:19:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9683 2009-07-02 06:09:36+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9685 2009-07-03 06:24:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9687 2009-07-04 07:20:38+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9689 2009-07-05 05:33:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9691 2009-07-06 06:11:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9694 2009-07-07 05:54:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9697 2009-07-08 06:23:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9699 2009-07-09 06:14:54+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9701 2009-07-10 06:30:52+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9704 2009-07-11 06:49:05+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9706 2009-07-12 07:09:36+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9709 2009-07-13 05:48:01+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9710 2009-07-13 06:13:02+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9713 2009-07-14 06:30:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9715 2009-07-15 06:11:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9718 2009-07-16 06:07:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9720 2009-07-17 06:21:08+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9722 2009-07-18 07:03:10+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9724 2009-07-19 14:33:46+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9726 2009-07-20 06:39:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9728 2009-07-21 06:13:50+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9730 2009-07-22 06:24:52+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9733 2009-07-23 05:45:41+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9736 2009-07-24 07:15:25+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9738 2009-07-25 08:34:22+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9740 2009-07-26 08:06:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9742 2009-07-28 06:30:16+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9744 2009-07-29 06:31:47+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9747 2009-07-30 06:45:09+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9749 2009-07-31 06:25:26+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9752 2009-08-01 06:55:40+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9754 2009-08-02 05:08:34+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9757 2009-08-03 20:35:25+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9759 2009-08-04 05:57:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9761 2009-08-05 06:17:24+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9763 2009-08-05 09:44:33+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9765 2009-08-06 07:50:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9767 2009-08-07 06:45:49+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9769 2009-08-08 07:05:55+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9771 2009-08-09 06:41:22+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9773 2009-08-10 05:19:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9776 2009-08-11 06:33:56+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9778 2009-08-12 07:29:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9781 2009-08-13 07:31:55+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9783 2009-08-14 06:43:36+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9785 2009-08-15 06:18:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9787 2009-08-16 06:38:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9790 2009-08-17 06:43:45+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "rides" (
"date" TIMESTAMP,
  "sport" TEXT,
  "data" TEXT,
  "workout_time" REAL,
  "total_distance" REAL,
  "athlete" TEXT
);
CREATE INDEX "ix_rides_date"ON "rides" ("date");