Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows

View and edit SQL

Link rowid ▼ date sport data workout_time total_distance athlete
101 2019-05-30 20:51:05+00:00 Bike TDS-H--AGL-E--- 8368.0 55.90673 {862ffe90-6760-472e-969a-5b3cd11c2798}
102 2019-06-02 13:08:41+00:00 Bike TDS-H--AGL-E--- 8610.0 18.91804 {862ffe90-6760-472e-969a-5b3cd11c2798}
103 2019-06-04 22:50:20+00:00 Bike TDS-H--AGL-E--- 4205.0 19.4848 {862ffe90-6760-472e-969a-5b3cd11c2798}
104 2019-06-06 21:00:09+00:00 Bike TDS-H--AGL-E--- 6875.0 55.05508 {862ffe90-6760-472e-969a-5b3cd11c2798}
105 2019-06-07 22:20:49+00:00 Bike TDS-H--AGL-E--- 10191.0 73.44745 {862ffe90-6760-472e-969a-5b3cd11c2798}
106 2019-06-08 15:14:30+00:00 Bike TDS-H--AGL-E--- 5155.0 32.46475 {862ffe90-6760-472e-969a-5b3cd11c2798}
107 2019-06-09 13:09:46+00:00 Bike TDS-H--AGL-E--- 7140.0 16.16285 {862ffe90-6760-472e-969a-5b3cd11c2798}
108 2019-06-11 22:49:12+00:00 Bike TDS-H--AGL-E--- 5438.0 24.0403 {862ffe90-6760-472e-969a-5b3cd11c2798}
109 2019-06-12 20:50:54+00:00 Bike TDS-H--AGL-E--- 4670.0 35.18027 {862ffe90-6760-472e-969a-5b3cd11c2798}
110 2019-06-14 14:37:22+00:00 Bike TDS-H--AGL-E--- 6143.0 44.54724 {862ffe90-6760-472e-969a-5b3cd11c2798}
111 2019-06-15 14:09:44+00:00 Bike TDS-H--AGL-E--- 6945.0 57.35163 {862ffe90-6760-472e-969a-5b3cd11c2798}
112 2019-06-16 14:13:49+00:00 Bike TDS-H--AGL-E--- 7793.0 64.33058 {862ffe90-6760-472e-969a-5b3cd11c2798}
113 2019-06-18 21:04:04+00:00 Bike TDS-H--AGL-E--- 8182.0 66.48682 {862ffe90-6760-472e-969a-5b3cd11c2798}
114 2019-06-19 20:59:34+00:00 Bike TDS-H--AGL-E--- 2746.0 8.3789 {862ffe90-6760-472e-969a-5b3cd11c2798}
115 2019-08-03 13:52:34+00:00 Bike TDS-H--AGL-E--- 6617.0 52.38232 {862ffe90-6760-472e-969a-5b3cd11c2798}
116 2019-08-04 14:36:53+00:00 Bike TDS-H--AGL-E--- 7176.0 58.1311 {862ffe90-6760-472e-969a-5b3cd11c2798}
117 2019-08-05 14:14:31+00:00 Bike TDS-H--AGL-E--- 6168.0 50.38784 {862ffe90-6760-472e-969a-5b3cd11c2798}
118 2019-08-07 20:59:57+00:00 Bike TDS-H--AGL-E--- 8007.0 64.76614 {862ffe90-6760-472e-969a-5b3cd11c2798}
119 2019-08-10 13:13:49+00:00 Bike TDS-H--AGL-E--- 8941.0 73.15063 {862ffe90-6760-472e-969a-5b3cd11c2798}
120 2019-08-11 13:40:45+00:00 Bike TDS----AGL-E--- 9286.0 74.2366 {862ffe90-6760-472e-969a-5b3cd11c2798}
121 2019-08-13 20:37:00+00:00 Bike TDS-H--AGL-E--- 3671.0 22.78966 {862ffe90-6760-472e-969a-5b3cd11c2798}
122 2019-08-14 22:34:44+00:00 Bike TDS-HC-AGL-E--- 5625.0 50.11708 {862ffe90-6760-472e-969a-5b3cd11c2798}
123 2019-08-16 20:55:02+00:00 Bike TDS-HC-AGL-E--- 6701.0 56.39964 {862ffe90-6760-472e-969a-5b3cd11c2798}
124 2019-08-18 13:04:58+00:00 Bike TDS-HC-AGL-E--- 11097.0 93.07605 {862ffe90-6760-472e-969a-5b3cd11c2798}
125 2019-08-20 21:35:09+00:00 Bike TDS-HC-AGL-E--- 6743.0 54.54423 {862ffe90-6760-472e-969a-5b3cd11c2798}
126 2019-08-21 22:36:37+00:00 Bike TDS-HC-AGL-E--- 5008.0 43.2098 {862ffe90-6760-472e-969a-5b3cd11c2798}
127 2019-08-24 14:03:07+00:00 Bike TDS-HC-AGL-E--- 8084.0 70.3556 {862ffe90-6760-472e-969a-5b3cd11c2798}
128 2019-08-28 20:52:03+00:00 Bike TDS-HC-AGL-E--- 4051.0 26.38928 {862ffe90-6760-472e-969a-5b3cd11c2798}
129 2019-08-30 19:35:17+00:00 Bike TDS-HC-AGL-E--- 6266.0 50.29458 {862ffe90-6760-472e-969a-5b3cd11c2798}
130 2019-09-01 13:00:33+00:00 Bike TDS-H--AGL-E--- 10888.0 84.04075 {862ffe90-6760-472e-969a-5b3cd11c2798}
131 2019-09-02 14:51:53+00:00 Bike TDS-H--AGL-E--- 5051.0 37.59228 {862ffe90-6760-472e-969a-5b3cd11c2798}
132 2019-09-07 12:52:33+00:00 Bike TDS-HC-AGL-E--- 6156.0 51.7314 {862ffe90-6760-472e-969a-5b3cd11c2798}
133 2019-09-08 13:04:44+00:00 Bike TDS-HC-AGL-E--- 7118.0 58.67128 {862ffe90-6760-472e-969a-5b3cd11c2798}
134 2019-09-10 20:57:41+00:00 Bike TDS-HC-AGL-E--- 7406.0 58.75571 {862ffe90-6760-472e-969a-5b3cd11c2798}
135 2019-09-11 22:14:26+00:00 Bike TDS-HC-AGL-E--- 5597.0 50.21498 {862ffe90-6760-472e-969a-5b3cd11c2798}
136 2019-09-14 14:39:30+00:00 Bike TDS-HC-AGL-E--- 7572.0 58.56205 {862ffe90-6760-472e-969a-5b3cd11c2798}
137 2019-09-15 12:31:53+00:00 Bike TDS-HC-AGL-E--- 8904.0 64.43529 {862ffe90-6760-472e-969a-5b3cd11c2798}
138 2019-09-20 18:07:39+00:00 Bike TDS-H--AGL-E--- 8673.0 69.63591 {862ffe90-6760-472e-969a-5b3cd11c2798}
139 2019-09-21 14:48:46+00:00 Bike TDS-HC-AGL-E--- 6031.0 52.04605 {862ffe90-6760-472e-969a-5b3cd11c2798}
140 2019-09-22 14:09:13+00:00 Bike TDS-HC-AGL-E--- 7145.0 58.44673 {862ffe90-6760-472e-969a-5b3cd11c2798}
141 2019-09-25 21:34:30+00:00 Bike TDS--C-AGL-E--- 4990.0 44.66443 {862ffe90-6760-472e-969a-5b3cd11c2798}
142 2019-09-29 14:10:35+00:00 Bike TDS-HC-AGL-E--- 7445.0 57.8874 {862ffe90-6760-472e-969a-5b3cd11c2798}
143 2019-10-05 12:53:00+00:00 Bike TDS-HC-AGL-E--- 4701.0 34.47849 {862ffe90-6760-472e-969a-5b3cd11c2798}
144 2019-10-10 21:14:38+00:00 Bike TDS-HC-AGL-E--- 5119.0 37.22352 {862ffe90-6760-472e-969a-5b3cd11c2798}
145 2019-10-13 13:56:40+00:00 Bike TDS-HC-AGL-E--- 3845.0 28.013 {862ffe90-6760-472e-969a-5b3cd11c2798}
146 2019-10-14 14:16:19+00:00 Bike TDS-HC-AGL-E--- 6861.0 50.06715 {862ffe90-6760-472e-969a-5b3cd11c2798}
147 2019-10-19 13:00:28+00:00 Bike TDS-HC-AGL-E--- 8938.0 65.02102 {862ffe90-6760-472e-969a-5b3cd11c2798}
148 2019-10-20 14:04:52+00:00 Bike TDS-HC-AGL-E--- 6454.0 51.86586 {862ffe90-6760-472e-969a-5b3cd11c2798}
149 2019-10-25 20:42:32+00:00 Bike TDS-H--AGL-E--- 3598.0 18.47212 {862ffe90-6760-472e-969a-5b3cd11c2798}
150 2019-10-26 14:01:47+00:00 Bike TDS-H--AGL-E--- 5939.0 24.69595 {862ffe90-6760-472e-969a-5b3cd11c2798}
151 2019-11-03 14:03:53+00:00 Bike TDS-H--AGL-E--- 8257.0 28.9129 {862ffe90-6760-472e-969a-5b3cd11c2798}
152 2019-11-10 14:04:50+00:00 Bike TDS-H--AGL-E--- 7114.0 24.76458 {862ffe90-6760-472e-969a-5b3cd11c2798}
153 2019-11-16 15:25:33+00:00 Bike TDS-H--AGL-E--- 5976.0 19.592 {862ffe90-6760-472e-969a-5b3cd11c2798}
154 2019-11-24 14:06:43+00:00 Bike TDS-H--AGL-E--- 7367.0 26.51745 {862ffe90-6760-472e-969a-5b3cd11c2798}
155 2019-11-30 15:01:42+00:00 Bike TDS-H--AGL-E--- 6264.0 27.15312 {862ffe90-6760-472e-969a-5b3cd11c2798}
156 2019-12-06 14:19:16+00:00 Bike TDS----AGL-E--- 4807.0 21.4578 {862ffe90-6760-472e-969a-5b3cd11c2798}
157 2019-12-07 14:13:26+00:00 Bike TDS-H--AGL-E--- 8734.0 27.86461 {862ffe90-6760-472e-969a-5b3cd11c2798}
158 2019-12-28 13:50:00+00:00 Bike TDS-H--AGL-E--- 10316.0 62.4399 {862ffe90-6760-472e-969a-5b3cd11c2798}
159 2020-01-18 13:42:18+00:00 Bike TDS-H--AGL-E--- 5348.0 9.79096 {862ffe90-6760-472e-969a-5b3cd11c2798}
160 2020-01-19 14:59:39+00:00 Bike TDS-H--AGL-E--- 3746.0 17.22212 {862ffe90-6760-472e-969a-5b3cd11c2798}
161 2020-02-02 15:22:07+00:00 Bike TDS-H--AGL-E--- 6018.0 22.93501 {862ffe90-6760-472e-969a-5b3cd11c2798}
162 2020-02-05 22:43:34+00:00 Bike TDS----AGL-E--- 5751.0 20.5869 {862ffe90-6760-472e-969a-5b3cd11c2798}
163 2020-02-06 22:03:31+00:00 Bike TDS----AGL-E--- 6024.0 21.44752 {862ffe90-6760-472e-969a-5b3cd11c2798}
164 2020-02-08 15:33:23+00:00 Bike TDS-H--AGL-E--- 7559.0 19.8483 {862ffe90-6760-472e-969a-5b3cd11c2798}
165 2020-02-09 16:20:07+00:00 Bike TDS-H--AGL-E--- 6146.0 23.17451 {862ffe90-6760-472e-969a-5b3cd11c2798}
166 2020-02-12 21:52:10+00:00 Bike TDS-H--AGL-E--- 5864.0 23.77807 {862ffe90-6760-472e-969a-5b3cd11c2798}
167 2020-02-13 22:59:29+00:00 Bike TDS-H--AGL-E--- 6618.0 19.57465 {862ffe90-6760-472e-969a-5b3cd11c2798}
168 2020-02-16 13:59:24+00:00 Bike TDS-H--AGL-E--- 7925.0 19.01881 {862ffe90-6760-472e-969a-5b3cd11c2798}
169 2020-02-17 14:48:16+00:00 Bike TDS-H--AGL-E--- 5558.0 20.87423 {862ffe90-6760-472e-969a-5b3cd11c2798}
170 2020-02-20 23:22:11+00:00 Bike TDS-H--AGL-E--- 6895.0 18.0324 {862ffe90-6760-472e-969a-5b3cd11c2798}
171 2020-02-22 15:49:33+00:00 Bike TDS-H--AGL-E--- 5721.0 22.54379 {862ffe90-6760-472e-969a-5b3cd11c2798}
172 2020-02-23 13:21:40+00:00 Bike TDS-H--AGL-E--- 10635.0 69.66532 {862ffe90-6760-472e-969a-5b3cd11c2798}
173 2020-03-01 15:00:51+00:00 Bike TDS-H--AGL-E--- 4705.0 16.09478 {862ffe90-6760-472e-969a-5b3cd11c2798}
174 2020-03-07 14:50:03+00:00 Bike TDS-H--AGL-E--- 4604.0 32.98871 {862ffe90-6760-472e-969a-5b3cd11c2798}
175 2020-03-08 12:44:27+00:00 Bike TDS-H--AGL-E--- 12017.0 75.97083 {862ffe90-6760-472e-969a-5b3cd11c2798}
176 2020-03-10 20:56:38+00:00 Bike TDS-H--AGL-E--- 5048.0 23.29242 {862ffe90-6760-472e-969a-5b3cd11c2798}
177 2020-03-12 21:03:47+00:00 Bike TDS-H--AGL-E--- 5468.0 37.90163 {862ffe90-6760-472e-969a-5b3cd11c2798}
178 2020-03-14 12:57:56+00:00 Bike TDS-H--AGL-E--- 5776.0 25.97658 {862ffe90-6760-472e-969a-5b3cd11c2798}
179 2020-03-15 13:08:15+00:00 Bike TDS-H--AGL-E--- 9611.0 59.7363 {862ffe90-6760-472e-969a-5b3cd11c2798}
180 2020-03-17 21:10:53+00:00 Bike TDS-H--AGL-E--- 6905.0 50.46145 {862ffe90-6760-472e-969a-5b3cd11c2798}
181 2020-03-22 14:00:42+00:00 Bike TDS-H--AGL-E--- 6288.0 44.37123 {862ffe90-6760-472e-969a-5b3cd11c2798}
182 2020-03-24 20:58:52+00:00 Bike TDS-H--AGL-E--- 5919.0 42.65058 {862ffe90-6760-472e-969a-5b3cd11c2798}
183 2020-03-25 20:43:08+00:00 Bike TDS-H--AGL-E--- 8148.0 58.19992 {862ffe90-6760-472e-969a-5b3cd11c2798}
184 2020-03-27 21:01:31+00:00 Bike TDS-HC-AGL-E--- 4968.0 38.07911 {862ffe90-6760-472e-969a-5b3cd11c2798}
185 2020-03-29 15:35:59+00:00 Bike TDS-H--AGL-E--- 8211.0 61.3894 {862ffe90-6760-472e-969a-5b3cd11c2798}
186 2020-04-01 20:35:19+00:00 Bike TDS-HC-AGL-E--- 8641.0 68.16502 {862ffe90-6760-472e-969a-5b3cd11c2798}
187 2020-04-02 20:54:10+00:00 Bike TDS-HC-AGL-E--- 3945.0 23.39257 {862ffe90-6760-472e-969a-5b3cd11c2798}
188 2020-04-04 13:55:42+00:00 Bike TDS-HC-AGL-E--- 10535.0 80.9735 {862ffe90-6760-472e-969a-5b3cd11c2798}
189 2020-04-05 15:17:45+00:00 Bike TDS-HC-AGL-E--- 7160.0 55.04652 {862ffe90-6760-472e-969a-5b3cd11c2798}
190 2020-04-07 21:07:26+00:00 Bike TDS-H--AGL-E--- 4325.0 27.23611 {862ffe90-6760-472e-969a-5b3cd11c2798}
191 2020-04-08 20:34:06+00:00 Bike TDS-HC-AGL-E--- 5822.0 46.65055 {862ffe90-6760-472e-969a-5b3cd11c2798}
192 2020-04-11 14:23:53+00:00 Bike TDS-H--AGL-E--- 14522.0 91.26425 {862ffe90-6760-472e-969a-5b3cd11c2798}
193 2020-04-12 15:20:12+00:00 Bike TDS-HC-AGL-E--- 4530.0 34.40868 {862ffe90-6760-472e-969a-5b3cd11c2798}
194 2020-04-14 21:14:52+00:00 Bike TDSPHC--------- 3601.0 21.92338 {862ffe90-6760-472e-969a-5b3cd11c2798}
195 2020-04-15 21:01:07+00:00 Bike TDSPHC--------- 3601.0 20.86033 {862ffe90-6760-472e-969a-5b3cd11c2798}
196 2020-04-18 13:41:27+00:00 Bike TDS-HC-AGL-E--- 12158.0 89.69974 {862ffe90-6760-472e-969a-5b3cd11c2798}
197 2020-04-19 14:53:48+00:00 Bike TDS-H--AGL-E--- 5434.0 37.15663 {862ffe90-6760-472e-969a-5b3cd11c2798}
198 2020-04-22 20:27:00+00:00 Bike TDSPHC-AGL-EV-- 4426.0 30.6013 {862ffe90-6760-472e-969a-5b3cd11c2798}
199 2020-04-25 13:34:33+00:00 Bike TDSPHC-AGL-E--- 12265.0 90.58273 {862ffe90-6760-472e-969a-5b3cd11c2798}
200 2020-04-26 14:48:10+00:00 Bike TDSPHC-AGL-E--- 4987.0 34.12898 {862ffe90-6760-472e-969a-5b3cd11c2798}

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