Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows sorted by sport

View and edit SQL

These facets timed out: date

Link rowid date sport ▼ data workout_time total_distance athlete
3656 2015-01-17 14:26:33+00:00   TDS--C-AGL-E--- 2312.0 14.1325 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3657 2015-01-19 14:18:09+00:00   TDS-HC-AGL-E--- 6412.0 42.9955 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3658 2015-01-21 07:10:41+00:00   TDS-HC-AGL-E--- 4442621.0 58.4576 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3659 2015-03-06 12:40:33+00:00   TDS----AGL----- 2799.0 4.55374 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3660 2015-03-15 11:01:10+00:00   TDS-HC-AGL-E--- 9244.0 60.0866 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3661 2015-03-17 11:42:37+00:00   TDS-HC-AGL-E--- 13450.0 71.0311 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3662 2015-03-18 13:06:07+00:00   TDS-HC-AGL-E--- 4960.0 33.7076 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3663 2015-04-04 10:19:56+00:00   TDS-HC-AGL-E--- 12678.0 83.6604 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3664 2015-04-05 10:30:14+00:00   TDS-HC-AGL-E--- 2434.0 16.2044 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3665 2015-04-05 13:15:27+00:00   TDS--C-AGL-E--- 781.0 4.47765 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3666 2015-04-05 19:43:23+00:00   TDS--C-AGL-E--- 768.0 4.5032 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3667 2015-04-09 13:09:16+00:00   TDS-HC-AGL-E--- 7095.0 51.3231 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3668 2015-04-11 10:13:01+00:00   TDS-HC-AGL-E--- 13707.0 96.1907 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3669 2015-04-12 11:55:59+00:00   TDS-HC-AGL-E--- 3587.0 24.6715 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3670 2015-04-14 18:34:42+00:00   TDS--C-AGL-E--- 6913.0 51.006 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3671 2015-04-16 12:45:20+00:00   TDS--C-AGL-E--- 6007.0 42.413 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3672 2015-04-19 10:00:41+00:00   TDS-HC-AGL-E--- 13766.0 95.6339 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3673 2015-04-22 13:06:19+00:00   TDS-HC-AGL-E--- 6278.0 42.2639 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3674 2015-04-25 10:04:39+00:00   TDS-HC-AGL-E--- 6741.0 51.3607 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3675 2015-04-27 10:38:59+00:00   TDS-HC-AGL-E--- 18064.0 114.17 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3676 2015-04-28 14:03:15+00:00   TDS--C-AGL-E--- 16781.0 48.3422 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3677 2015-04-29 13:51:35+00:00   TDS-HC-AGL-E--- 11219.0 72.831 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3678 2015-04-29 17:13:42+00:00   TDS-HC-AGL-E--- 175276.0 86.7051 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3679 2015-05-08 10:41:06+00:00   TDS-HC-AGL-E--- 15034.0 97.2474 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3680 2015-08-30 10:11:01+00:00   TDSPHC-AGL-E--- 4898.0 34.0139 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3681 2015-08-31 18:52:55+00:00   TDSPHC-AGL-E--- 7264.0 51.1193 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3682 2015-09-03 10:26:06+00:00   TDSPHC-AGL-E--- 12291.0 80.1604 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3683 2015-09-04 14:39:40+00:00   TDSPHC-AGL-E--- 7012.0 51.2787 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3684 2015-09-12 10:26:41+00:00   TDSPHC-AGL-E--- 11132.0 67.7325 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3685 2015-10-04 13:46:38+00:00   TDS----AGL-E--- 11236.0 35.6869 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3686 2015-10-09 11:15:13+00:00   TDSPHC-AGL-E--- 6436.0 43.8053 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3687 2015-10-17 12:43:03+00:00   TDSPHC-AGL-E--- 2654.0 16.5944 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3688 2015-11-02 12:15:16+00:00   TDSPHC-AGL-E--- 5468.0 36.4833 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3689 2015-11-03 14:33:20+00:00   TDSPHC-AGL-E--- 6562.0 42.3458 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3690 2015-11-04 15:51:22+00:00   TDSPHC-AGL-E--- 4336.0 28.3004 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3691 2018-03-15 13:34:41+00:00   TDSP-C-AGL-E--- 1172.0 6.0853 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3692 2018-03-17 15:01:36+00:00   TDSPHC-AGL-E--- 3084.0 15.7083 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3693 2018-03-18 14:54:36+00:00   TDSP-C-AGL-E--- 3157.0 15.9903 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3694 2018-03-21 11:44:22+00:00   TDS----AGL----- 4823.0 7.29227 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3695 2018-03-22 11:24:37+00:00   TDS----AGL----- 4368.0 7.21421 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3696 2018-03-23 11:25:31+00:00   TDS----AGL----- 3703.0 5.3397 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3697 2018-03-26 15:37:48+00:00   TDS----AGL----- 3347.0 20.0211 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3698 2018-03-28 12:16:44+00:00   TDS----AGL----- 3452.0 20.3991 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3699 2018-04-01 13:07:50+00:00   TDS----AGL----- 3817.0 23.1621 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3700 2018-04-08 18:01:32+00:00   TDS----AGL-E--- 3805.0 21.5262 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3704 2018-04-21 10:18:10+00:00   ---------------     {bcffcd4a-1727-481b-8eda-858e976c3cea}
3710 2018-05-13 09:49:32+00:00   TDSPHC-AGL-E--- 5416.0 37.2659 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3849 2019-02-09 15:23:02+00:00   TDSPHC-AGL----- 5535.0 31.7478 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3855 2019-03-18 11:41:31+00:00   TDS-H--AGL----- 3651.0 28.7196 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3856 2019-03-25 11:34:07+00:00   TDS----AGL----- 3748.0 30.0791 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3857 2019-03-26 12:06:20+00:00   TDS----AGL----- 3706.0 28.5181 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3858 2019-03-31 22:42:00+00:00   TDSPHC-AGL----- 3618.0 24.2706 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3859 2019-04-01 23:59:13+00:00   TDSPHC-AGL----- 3616.0 31.8582 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3970 2019-11-12 23:32:45+00:00   TDSPHC-AGL----- 1000.0 7.77837 {bcffcd4a-1727-481b-8eda-858e976c3cea}
4384 2017-07-15 22:43:29+00:00   TDSPHC-AGL-E--- 3896.0 0.77267 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4385 2017-07-17 07:35:44+00:00   TDSPHC-AGL-E--- 2725.0 0.5867 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4386 2017-07-17 12:01:09+00:00   TDSPHC-AGL-E--- 1812.0 0.48128 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4387 2017-07-17 22:52:51+00:00   TDSPHC-AGL-E--- 3014.0 0.75159 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4388 2017-07-18 00:50:59+00:00   TDS-H--AGL-E--- 423.0 1.6099 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4389 2017-07-18 03:47:43+00:00   TDS-H--AGL-E--- 362.0 1.42955 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4390 2017-07-18 20:20:03+00:00   TDSPHC-AGL-E--- 3674.0 21.4632 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4391 2017-07-19 20:17:53+00:00   TDSPHC-AGL-E--- 2791.0 21.5164 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4392 2017-07-20 07:32:45+00:00   TDSPHC-AGL-E--- 8897.0 0.69932 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4393 2017-07-20 12:02:17+00:00   TDSPHC-AGL-E--- 2081.0 0.67438 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4394 2017-07-20 20:25:14+00:00   TDSPHC-AGL-E--- 2374.0 17.707 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4395 2017-07-22 21:54:32+00:00   TDSPHC-AGL-E--- 4410.0 37.0385 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4396 2017-07-23 07:30:01+00:00   TDSPHC-AGL-E--- 3183.0 0.98768 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4397 2017-07-23 20:24:11+00:00   TDSPHC-AGL-E--- 3354.0 23.8249 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4398 2017-07-24 22:36:53+00:00   TDSPHC-AGL-E--- 1213.0 0.23852 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4399 2017-07-25 01:55:12+00:00   TDS-H--AGL-E--- 359.0 0.89291 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4400 2017-07-25 03:10:59+00:00   TDS-H--AGL-E--- 403.0 1.59418 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4401 2017-07-25 08:17:06+00:00   TDSPHC-AGL-E--- 4541.0 1.05581 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4402 2017-07-25 12:26:00+00:00   TDSP-C-AGL-E--- 3031.0 0.23437 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4403 2017-07-25 20:26:48+00:00   TDSPHC-AGL-E--- 3096.0 25.0604 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4404 2017-07-26 22:29:16+00:00   TDSPHC-AGL-E--- 1805.0 0.42778 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4405 2017-07-28 08:03:37+00:00   TDSPHC-AGL-E--- 3768.0 0.89728 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4406 2017-07-28 20:26:52+00:00   TDSPHC-AGL-E--- 2403.0 0.63304 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4407 2017-07-29 23:15:39+00:00   TDSPHC-AGL-E--- 8533.0 67.1894 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4408 2017-07-30 08:03:45+00:00   TDSPHC-AGL-E--- 2702.0 0.60366 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4409 2017-07-30 20:13:11+00:00   TDSPHC-AGL-E--- 3070.0 20.7665 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4410 2017-07-31 20:16:13+00:00   TDSPHC-AGL-E--- 5617.0 36.6737 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4411 2017-08-01 20:27:41+00:00   TDSPHC-AGL-E--- 4263.0 32.1887 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4412 2017-08-02 04:48:26+00:00   TDS-H--AGL-E--- 836.0 4.07654 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4413 2017-08-02 06:59:34+00:00   TDS-H--AGL-E--- 1310.0 5.01913 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4414 2017-08-02 20:17:19+00:00   TDSPHC-AGL-E--- 2906.0 21.9927 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4415 2017-08-03 00:16:19+00:00   TDS-H--AGL-E--- 580.0 1.54457 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4416 2017-08-03 01:19:46+00:00   TDS-H--AGL-E--- 358.0 1.40974 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4417 2017-08-03 23:37:05+00:00   TDSPHC-AGL-E--- 3903.0 0.99162 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4418 2017-08-04 03:27:48+00:00   TDSPHC-AGL-E--- 3612.0 1.56731 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4419 2017-08-04 07:05:28+00:00   TDS-H--AGL-E--- 1157.0 4.71162 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4420 2017-08-04 08:02:46+00:00   TDS-H--AGL-E--- 1017.0 3.81927 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4421 2017-08-05 07:11:19+00:00   TDSPHC-AGL-E--- 628.0 3.02219 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4422 2017-08-05 07:49:48+00:00   TDSPHC-AGL-E--- 3606.0 0.86829 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4423 2017-08-05 21:35:58+00:00   TDSPHC-AGL-E--- 7331.0 55.0952 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4424 2017-08-06 06:23:47+00:00   TDSP-C-AGL-E--- 6806.0 52.885 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4425 2017-08-06 21:23:57+00:00   TDS----AGL-E--- 3444.0 17.7328 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4426 2017-08-07 08:15:46+00:00   TDS----AGL-E--- 3466.0 16.785 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4427 2017-08-07 21:28:09+00:00   TDS----AGL-E--- 3446.0 17.6231 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4428 2017-08-08 08:11:27+00:00   TDS----AGL-E--- 2982.0 18.0894 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4429 2017-08-08 21:36:15+00:00   TDS----AGL-E--- 3598.0 20.0613 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}

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");