rides

Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▲ date sport data workout_time total_distance athlete
2588836 2588836 2016-10-03 10:36:25+00:00 Spinning T---H------E--- 4287.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588835 2588835 2016-10-02 14:12:40+00:00 Bike TDSPHCNAGL-EV--   39.96123 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588834 2588834 2016-09-28 10:28:02+00:00 Spinning T---H------E--- 5685.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588833 2588833 2016-09-27 11:03:51+00:00 Spinning T---H------E--- 3000.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588832 2588832 2016-09-26 10:46:06+00:00 Spinning T---H------E--- 3196.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588831 2588831 2016-09-25 06:51:38+00:00 Bike TDSPHCNAGL-EV-- 24589.0 169.484 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588830 2588830 2016-09-22 10:50:43+00:00 Spinning T---H------E--- 3840.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588829 2588829 2016-09-21 10:37:26+00:00 Spinning T---H------E--- 5135.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588828 2588828 2016-09-20 10:46:37+00:00 Spinning T---H------E--- 4427.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588827 2588827 2016-09-19 10:30:38+00:00 Spinning T---H------E--- 4025.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588826 2588826 2016-09-17 13:34:39+00:00 Bike TDSPHCNA-L-EV-- 8871.0 33.17857 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588825 2588825 2016-09-14 11:15:06+00:00 Spinning T---H------E--- 3022.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588824 2588824 2016-09-12 09:30:32+00:00 Spinning T---H------E--- 3536.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588823 2588823 2016-09-11 07:00:04+00:00 Bike TDSPHCNAGL-EV-- 3466.0 23.4169 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588822 2588822 2016-09-07 10:20:11+00:00 Spinning T---H------E--- 3536.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588821 2588821 2016-09-04 04:31:26+00:00 Bike TDSPHCNAGL-EV-- 38995.0 197.316 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588820 2588820 2016-08-27 08:14:55+00:00 Bike TDSPHCNAGL----- 29845.0 155.165 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588819 2588819 2016-08-17 07:47:38+00:00 Bike TDSPHC-AGL-EV-- 20180.0 119.38144 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588818 2588818 2016-08-14 06:06:29+00:00 Bike TDSPHCNAGL-EV-- 13182.0 72.35772 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588817 2588817 2016-08-13 14:09:32+00:00 Bike TDSPHCNAGL-EV-- 8106.0 29.44952 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588816 2588816 2016-08-07 07:46:28+00:00 Bike TDSPHC-AGL-EV-- 25309.0 112.0869 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588815 2588815 2016-08-06 14:22:46+00:00 Bike TDSPHC-AGL-EV-- 8930.0 37.5341 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588814 2588814 2016-08-03 10:37:32+00:00 Spinning T---H------E--- 3753.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588813 2588813 2016-07-31 14:22:55+00:00 Bike TDSPHC-AGL-EV-- 9938.0 44.39916 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588812 2588812 2016-07-30 14:38:31+00:00 Bike TDSPHCNAGL-EV-- 6012.0 17.55345 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588811 2588811 2016-07-27 10:39:22+00:00 Spinning T---H------E--- 3536.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588810 2588810 2016-07-25 10:41:44+00:00 Spinning T---H------E--- 3387.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588809 2588809 2016-07-24 05:45:24+00:00 Bike TDSPHC-AGL-EV-- 40514.0 191.98453 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588808 2588808 2016-07-20 10:36:00+00:00 Spinning T---H------E--- 4070.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588807 2588807 2016-07-18 10:34:42+00:00 Spinning T---H------E--- 3891.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588806 2588806 2016-07-17 09:08:58+00:00 Bike TDSPHC-AGLWEV-- 23682.0 69.31696 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588805 2588805 2016-07-16 06:20:44+00:00 Bike TDSPHC-AGLWEV-- 15505.0 94.56349 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588804 2588804 2016-07-13 10:34:02+00:00 Spinning T---H------E--- 3807.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588803 2588803 2016-07-11 10:41:42+00:00 Spinning T---H------E--- 3494.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588802 2588802 2016-07-10 07:29:50+00:00 Bike TDSPHC-AGLWEV-- 7638.0 21.33564 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588801 2588801 2016-07-06 10:23:25+00:00 Spinning T---H------E--- 4430.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588800 2588800 2016-07-03 07:12:16+00:00 Bike TDSPHC-AGLWEV-- 24008.0 82.41251 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588799 2588799 2016-06-29 16:31:46+00:00 Bike TDSPHC-AGLWEV-- 9766.0 55.9891 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588798 2588798 2016-06-26 08:07:11+00:00 Bike TDSPHC-AGLWEV-- 23559.0 64.50991 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588797 2588797 2016-06-25 15:30:20+00:00 Bike TDSPHC-AGLWEV-- 1369.0 7.26867 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588796 2588796 2016-06-25 14:20:09+00:00 Bike TDSPHC-AGLWEV-- 4204.0 17.26243 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588795 2588795 2016-06-21 15:02:37+00:00 Bike TDSPHC-AGLWEV-- 5616.0 39.13005 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588794 2588794 2016-06-18 06:20:04+00:00 Bike TDSPHC-AGLWEV-- 19947.0 111.54574 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588793 2588793 2016-06-17 15:30:38+00:00 Bike TDSPHC-AGLWEV-- 7330.0 42.8158 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588792 2588792 2016-06-15 10:42:34+00:00 Spinning T---H------E--- 3719.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588791 2588791 2016-06-12 06:12:01+00:00 Bike TDSPHC-AGLWEV-- 30785.0 151.94257 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588790 2588790 2016-06-05 06:19:29+00:00 Bike TDSPHC-AGLWEV-- 21706.0 108.50308 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588789 2588789 2016-06-01 10:34:31+00:00 Spinning T---H------E--- 4054.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588788 2588788 2016-05-30 10:45:36+00:00 Spinning T---H------E--- 3068.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588787 2588787 2016-05-24 16:16:51+00:00 Bike TDSPHC-AGLWEV-- 6022.0 39.84554 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588786 2588786 2016-05-21 06:36:03+00:00 Bike TDSPHC-AGLWEV-- 13796.0 94.78345 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588785 2588785 2016-05-20 10:42:07+00:00 Spinning T---H------E--- 3312.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588784 2588784 2016-05-15 14:40:26+00:00 MTB TDS-HC-AGLWE--- 6316.0 45.74822 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588783 2588783 2016-05-15 08:49:29+00:00 MTB TDS-HC-AGLWE--- 14752.0 56.40173 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588782 2588782 2016-05-15 08:33:56+00:00 MTB TDS-HC-AGLWE--- 528.0 2.68319 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588781 2588781 2016-05-14 06:29:22+00:00 Bike TDSPHC-AGLWEV-- 15943.0 92.10685 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588780 2588780 2016-05-09 09:51:00+00:00 Spinning T---H------E--- 6452.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588779 2588779 2016-05-07 06:30:30+00:00 Bike TDSPHC-AGLWEV-- 12036.0 71.39315 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588778 2588778 2016-05-04 10:37:11+00:00 Spinning T---H------E--- 3517.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588777 2588777 2016-05-02 10:35:02+00:00 Spinning T---H------E--- 3917.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588776 2588776 2016-04-30 06:09:18+00:00 Bike TDSPHC-AGLWEV-- 15014.0 96.02808 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588775 2588775 2016-04-27 10:40:38+00:00 Spinning T---H------E--- 3299.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588774 2588774 2016-04-24 09:28:05+00:00 MTB TDS-HC-AGLWE--- 17785.0 64.1995 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588773 2588773 2016-04-20 10:30:18+00:00 Spinning T---H------E--- 4107.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588772 2588772 2016-04-17 06:40:01+00:00 Bike TDSPHC-AGLWEV-- 13922.0 94.54334 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588771 2588771 2016-04-14 15:19:18+00:00 Bike TDSPHC-AGLWEV-- 6018.0 39.79154 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588770 2588770 2016-04-13 10:39:58+00:00 Spinning T---H------E--- 3717.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588769 2588769 2016-04-11 10:44:05+00:00 Spinning T---H------E--- 3297.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588768 2588768 2016-04-10 07:23:23+00:00 Bike TDSPHC-AGLWEV-- 11953.0 66.5487 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588767 2588767 2016-04-06 10:39:00+00:00 Spinning T---H------E--- 3723.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588766 2588766 2016-04-03 07:57:10+00:00 Bike TDSPHC-AGLWEV-- 10914.0 58.013 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588765 2588765 2016-03-27 09:17:57+00:00 MTB TDSPHC-AGLWEV-- 17271.0 89.39095 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588764 2588764 2016-03-20 08:28:39+00:00 Spinning T---H------E--- 11892.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588763 2588763 2016-03-16 11:39:22+00:00 Spinning T---H------E--- 3818.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588762 2588762 2016-03-14 11:35:14+00:00 Spinning T---H------E--- 3897.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588761 2588761 2016-03-09 11:28:21+00:00 Spinning T---H------E--- 4304.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588760 2588760 2016-03-02 11:38:51+00:00 Spinning T---H------E--- 3853.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588759 2588759 2016-02-29 11:40:35+00:00 Spinning T---H------E--- 3829.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588758 2588758 2016-02-24 11:39:06+00:00 Spinning T---H------E--- 3710.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588757 2588757 2016-02-22 11:42:39+00:00 Spinning T---H------E--- 3411.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588756 2588756 2016-02-19 11:16:29+00:00 Spinning T---H------E--- 5329.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588755 2588755 2016-02-15 11:39:06+00:00 Spinning T---H------E--- 3724.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588754 2588754 2016-02-10 11:33:45+00:00 Spinning T---H------E--- 4298.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588753 2588753 2016-02-08 10:40:09+00:00 Spinning T---H------E--- 7177.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588752 2588752 2016-02-03 11:43:54+00:00 Spinning T---H------E--- 3329.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588751 2588751 2016-02-01 11:33:39+00:00 Spinning T---H------E--- 3902.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588750 2588750 2016-01-31 13:33:50+00:00 MTB TDSPHC-AGL-E--- 10002.0 32.93837 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588749 2588749 2016-01-29 11:31:07+00:00 Spinning T---H------E--- 4517.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588748 2588748 2016-01-27 11:37:04+00:00 Spinning T---H------E--- 3855.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588747 2588747 2016-01-25 11:38:07+00:00 Spinning T---H------E--- 3619.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588746 2588746 2016-01-24 11:09:21+00:00 MTB TDS-HC-AGL-E--- 6458.0 29.6686 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588745 2588745 2016-01-22 11:38:32+00:00 Spinning T---H------E--- 3823.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588744 2588744 2016-01-20 11:38:29+00:00 Spinning T---H------E--- 3691.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588743 2588743 2016-01-15 11:25:54+00:00 Spinning T---H------E--- 4599.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588742 2588742 2016-01-13 11:37:19+00:00 Spinning T---H------E--- 3965.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588741 2588741 2016-01-11 11:37:07+00:00 Spinning T---H------E--- 3898.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588740 2588740 2016-01-08 11:02:14+00:00 Spinning T---H------E--- 5847.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588739 2588739 2015-12-16 11:43:25+00:00 Spinning T---H------E--- 3313.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588738 2588738 2015-12-13 09:07:41+00:00 MTB TDSPH--AGL-E--- 11727.0 56.2961 {53d206a4-3797-4f13-b638-7dc6b24e95e3}
2588737 2588737 2015-12-09 11:33:15+00:00 Spinning T---H------E--- 4135.0   {53d206a4-3797-4f13-b638-7dc6b24e95e3}

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