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