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
2888 2019-02-24 15:00:16+00:00   ---------------     {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2913 2017-04-12 10:00:00+00:00   ---------------     {0e118a96-d384-4ac2-8021-c3508781a03b}
3563 2019-02-14 16:52:53+00:00   ---------------     {4f0c636a-4f97-42fd-9a94-313324a9206e}
3564 2019-02-16 15:59:46+00:00   ---------------     {4f0c636a-4f97-42fd-9a94-313324a9206e}
3565 2019-02-17 09:46:50+00:00   ---------------     {4f0c636a-4f97-42fd-9a94-313324a9206e}
3704 2018-04-21 10:18:10+00:00   ---------------     {bcffcd4a-1727-481b-8eda-858e976c3cea}
7661 2019-02-14 12:34:24+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7662 2019-02-15 11:56:41+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7663 2019-02-16 09:19:35+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7664 2019-02-17 08:42:34+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7665 2019-02-18 11:47:04+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7666 2019-02-21 11:13:07+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7667 2019-02-23 09:26:28+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7668 2019-02-24 09:11:05+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7669 2019-02-25 11:58:12+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7670 2019-02-25 14:20:00+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7671 2019-02-26 11:30:45+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7672 2019-02-27 09:32:28+00:00   ---------------     {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2}
7997 2019-06-29 04:55:39+00:00 Bike ---------------     {2f3ac106-9ea5-45d2-a645-06534b2439dd}
8043 2019-09-30 12:10:34+00:00   ---------------     {2f3ac106-9ea5-45d2-a645-06534b2439dd}
8411 2015-06-18 16:29:16+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8412 2015-06-21 07:07:17+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8413 2015-06-23 16:39:38+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8414 2015-06-30 16:35:02+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8415 2015-07-05 07:05:51+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8416 2015-07-07 16:38:09+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8417 2015-07-09 16:43:50+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8418 2015-07-12 16:31:46+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8419 2015-07-14 16:37:04+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8420 2015-07-17 12:15:42+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8421 2015-07-21 16:32:25+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8422 2015-07-24 16:29:25+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8423 2015-07-28 16:36:05+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8424 2015-07-31 16:37:25+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8425 2015-08-02 07:06:52+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8426 2015-08-04 16:32:02+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8427 2015-08-06 16:31:17+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8428 2015-08-09 07:03:58+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8429 2015-08-11 16:33:20+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8430 2015-08-15 06:13:38+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8431 2015-08-18 16:38:16+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8432 2015-08-20 16:39:55+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8433 2015-08-23 07:08:49+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8434 2015-08-28 16:25:07+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8435 2015-08-30 16:24:49+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8455 2015-12-06 08:23:29+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8456 2015-12-12 12:44:06+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8457 2015-12-23 09:06:05+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8458 2015-12-25 07:48:55+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8459 2015-12-27 08:15:06+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8460 2015-12-30 12:21:42+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8461 2016-01-03 12:01:19+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8462 2016-02-06 08:35:50+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8463 2016-02-28 08:11:09+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8470 2016-04-03 07:06:53+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8471 2016-04-05 16:32:53+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8472 2016-04-09 12:38:15+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8473 2016-04-10 13:15:43+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8474 2016-04-12 16:31:41+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8475 2016-04-14 16:49:58+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8476 2016-04-17 07:06:13+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8477 2016-04-19 16:34:30+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8478 2016-04-22 16:31:00+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8479 2016-04-26 16:35:57+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8480 2016-05-01 11:10:10+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8481 2016-05-03 16:33:20+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8482 2016-05-05 07:10:06+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8483 2016-05-08 07:07:34+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8484 2016-05-10 16:34:13+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8485 2016-05-15 07:06:38+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8486 2016-05-17 16:35:08+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8487 2016-05-19 17:36:11+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8488 2016-05-28 06:52:57+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8489 2016-06-03 16:49:27+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8490 2016-06-07 16:30:00+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8491 2016-06-19 07:16:35+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8492 2016-06-28 16:39:25+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8493 2016-07-05 16:32:28+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8494 2016-07-08 17:09:35+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8495 2016-07-10 07:08:54+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8496 2016-07-12 16:34:32+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8497 2016-07-17 16:52:15+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8498 2016-07-19 16:44:20+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
8499 2016-07-24 07:07:38+00:00   ---------------     {ffc038ac-716e-4c9f-bffd-f35edaf5640f}
9006 2008-04-25 08:02:54+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9007 2008-04-25 08:21:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9008 2008-04-25 16:52:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9062 2008-06-18 19:49:52+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9069 2008-06-25 11:42:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9162 2008-10-20 12:05:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9254 2009-01-28 05:56:18+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9256 2009-01-28 10:55:55+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9258 2009-01-29 06:18:20+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9260 2009-01-30 06:09:09+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9264 2009-01-31 06:22:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9266 2009-02-01 06:03:49+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9270 2009-02-02 05:59:19+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9272 2009-02-03 06:28:21+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9276 2009-02-04 06:00:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9278 2009-02-05 06:38:05+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");