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 |
|---|---|---|---|---|---|---|---|
| 201 | 201 | 2020-04-28 20:59:51+00:00 | Bike | TDSPHC-AGL-EV-- | 4485.0 | 27.04347 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 202 | 202 | 2020-04-29 20:43:00+00:00 | Bike | TDSPHC-AGL-E--- | 4082.0 | 28.255 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 203 | 203 | 2020-04-30 21:02:40+00:00 | Bike | TDSPHC-AGL-EV-- | 3721.0 | 25.23757 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 204 | 204 | 2020-05-02 14:03:12+00:00 | Bike | TDSPHC-AGL-EV-- | 10287.0 | 82.68389 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 205 | 205 | 2020-05-03 14:11:19+00:00 | Bike | TDSPHC-AGL-EV-- | 8911.0 | 65.91125 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 206 | 206 | 2020-05-05 20:58:13+00:00 | Bike | TDSPHC-AGL-EV-- | 5867.0 | 30.52833 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 207 | 207 | 2020-05-06 20:36:34+00:00 | Bike | TDSPHC-AGL-E--- | 3828.0 | 26.13592 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 208 | 208 | 2020-05-09 13:17:12+00:00 | Bike | TDSP-C-AGL----- | 5408.0 | 36.21909 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
| 209 | 209 | 2014-12-29 04:17:26+00:00 | Bike | TD-----AGL-E--- | 814.0 | 1e-05 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 210 | 210 | 2015-01-14 21:07:50+00:00 | Bike | TDS-HC-AGL-E--- | 7895.0 | 42.5631 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 211 | 211 | 2015-01-15 16:40:17+00:00 | Bike | TDS-HC-AGL-E--- | 16683.0 | 82.1767 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 212 | 212 | 2015-01-16 16:52:09+00:00 | Bike | TDS-HC-AGL-E--- | 14153.0 | 80.5275 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 213 | 213 | 2015-01-17 17:13:00+00:00 | Bike | TDS-HC-AGL-E--- | 14099.0 | 76.82516 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 214 | 214 | 2015-01-26 13:36:20+00:00 | Bike | TDS--C-AGL-E--- | 1506861.0 | 25.29133 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 215 | 215 | 2015-03-14 00:03:19+00:00 | Bike | TDS-HC-AGL-E--- | 1340.0 | 10.43852 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 216 | 216 | 2015-04-17 19:14:53+00:00 | Bike | TDS----AGL-E--- | 6093.0 | 3.38676 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 217 | 217 | 2015-04-23 22:01:16+00:00 | Bike | TDS----AGL-E--- | 4076.0 | 17.376 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 218 | 218 | 2015-05-06 23:04:08+00:00 | Bike | TDS-H--AGL-E--- | 2260.0 | 16.33771 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 219 | 219 | 2015-05-09 22:48:42+00:00 | Bike | TDS-H--AGL-E--- | 2401.0 | 12.88472 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 220 | 220 | 2015-05-10 22:34:41+00:00 | Bike | TDS-H--AGL-E--- | 2315.0 | 14.55147 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 221 | 221 | 2015-05-16 20:32:03+00:00 | Bike | TDS-H--AGL-E--- | 1739.0 | 11.83366 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 222 | 222 | 2015-05-17 20:09:28+00:00 | Bike | TDS-H--AGL-E--- | 361531.0 | 7.26775 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 223 | 223 | 2015-05-22 00:35:08+00:00 | Bike | TDS-H--AGL-E--- | 1198.0 | 9.55918 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 224 | 224 | 2015-06-17 22:44:10+00:00 | Bike | TDS----AGL-E--- | 1081.0 | 4.83296 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 225 | 225 | 2015-06-18 21:39:16+00:00 | Bike | TDS-H--AGL-E--- | 1532.0 | 11.48965 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 226 | 226 | 2015-06-30 18:14:40+00:00 | Bike | TDS-H--AGL-E--- | 2032.0 | 14.94402 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 227 | 227 | 2015-07-06 00:56:16+00:00 | Bike | TDS-H--AGL-E--- | 1805.0 | 14.92497 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 228 | 228 | 2015-07-06 22:10:15+00:00 | Bike | TDS-H--AGL-E--- | 3911.0 | 30.04318 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 229 | 229 | 2015-07-07 23:10:58+00:00 | Bike | TDS-H--AGL-E--- | 4551.0 | 16.8675 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 230 | 230 | 2015-07-12 18:32:57+00:00 | Bike | TDS-H--AGL-E--- | 4925.0 | 35.02625 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 231 | 231 | 2015-07-16 23:11:00+00:00 | Bike | TDS-H--AGL-E--- | 6836.0 | 43.30554 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 232 | 232 | 2015-07-23 14:39:22+00:00 | Bike | TDS-H--AGL-E--- | 1867.0 | 15.15217 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 233 | 233 | 2015-07-24 23:12:30+00:00 | Bike | TDS-H--AGL-E--- | 4946.0 | 37.50716 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 234 | 234 | 2015-07-28 13:59:27+00:00 | Bike | TDS-H--AGL-E--- | 1535.0 | 0.77651 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 235 | 235 | 2015-07-28 14:25:34+00:00 | Bike | TDS-H--AGL-E--- | 11230.0 | 59.67257 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 236 | 236 | 2015-08-16 01:14:36+00:00 | Bike | TDS-H--AGL-E--- | 1879.0 | 14.95773 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 237 | 237 | 2015-08-17 00:19:56+00:00 | Bike | TDS-H--AGL-E--- | 3241.0 | 25.64414 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 238 | 238 | 2015-08-26 16:20:01+00:00 | Bike | TDS-H--AGL-E--- | 3471.0 | 15.42641 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 239 | 239 | 2015-09-01 01:05:04+00:00 | Bike | TDS-H--AGL-E--- | 1340.0 | 9.95304 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 240 | 240 | 2015-09-11 22:04:53+00:00 | Bike | TDS-H--AGL-E--- | 7797.0 | 32.41532 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 241 | 241 | 2015-09-18 22:26:24+00:00 | Bike | TDS-H--AGL-E--- | 5641.0 | 30.2553 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 242 | 242 | 2015-09-19 13:38:58+00:00 | Bike | TDS-H--AGL-E--- | 15329.0 | 94.44289 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 243 | 243 | 2015-09-20 13:46:12+00:00 | Bike | TDS-H--AGL-E--- | 10075.0 | 58.44618 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 244 | 244 | 2015-10-08 22:55:42+00:00 | Bike | T---H--AG--E--- | 363.0 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 245 | 245 | 2015-10-08 23:08:25+00:00 | Bike | TDS-H--AGL-E--- | 281.0 | 0.0181 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 246 | 246 | 2015-10-08 23:13:15+00:00 | Bike | TDS-H--AGL-E--- | 1813.0 | 0.15158 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 247 | 247 | 2015-11-17 23:40:19+00:00 | Bike | TD-----AGL-E--- | 2118.0 | 0.10704 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 248 | 248 | 2015-11-20 22:20:23+00:00 | Bike | TDS-H--AGL-E--- | 4492.0 | 27.7259 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 249 | 249 | 2015-11-24 20:17:01+00:00 | Bike | TDS-H--AGL-E--- | 3373.0 | 16.9831 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 250 | 250 | 2015-11-27 21:26:13+00:00 | Bike | TD--H--AGL-E--- | 2726.0 | 0.01358 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 251 | 251 | 2015-11-29 00:14:08+00:00 | Bike | TD--H--AGL-E--- | 2701.0 | 0.08017 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 252 | 252 | 2015-12-02 00:51:16+00:00 | Bike | TD--H--AGL-E--- | 2147.0 | 0.03481 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 253 | 253 | 2015-12-05 00:06:50+00:00 | Bike | TD--H--AGL-E--- | 2488.0 | 0.05646 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 254 | 254 | 2015-12-05 22:38:10+00:00 | Bike | TD--H--AGL-E--- | 1802.0 | 0.10956 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 255 | 255 | 2015-12-17 20:59:07+00:00 | Bike | TDS-H--AGL-E--- | 5053.0 | 39.70312 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 256 | 256 | 2015-12-22 21:57:11+00:00 | Bike | TDS-H--AGL-E--- | 3396.0 | 24.82097 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 257 | 257 | 2015-12-25 20:30:32+00:00 | Bike | TDS-H--AGL-E--- | 5017.0 | 37.88751 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 258 | 258 | 2016-01-07 14:24:16+00:00 | Bike | TDS-H--AGL-E--- | 63070.0 | 29.91138 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 259 | 259 | 2016-02-12 22:21:56+00:00 | Bike | TDS----AGL-E--- | 5782.0 | 27.8222 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 260 | 260 | 2016-02-19 17:23:45+00:00 | Bike | TDS----AGL-E--- | 3584.0 | 17.22246 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 261 | 261 | 2016-02-19 22:30:46+00:00 | Bike | TDS----AGL-E--- | 5248.0 | 27.46194 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 262 | 262 | 2016-02-21 14:40:21+00:00 | Bike | TDS----AGL-E--- | 11441.0 | 45.3423 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 263 | 263 | 2016-02-26 22:11:40+00:00 | Bike | TDS----AGL-E--- | 6687.0 | 29.02997 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 264 | 264 | 2016-03-25 21:53:05+00:00 | Bike | TDS-H--AGL-E--- | 6393.0 | 28.83934 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 265 | 265 | 2016-03-27 01:47:55+00:00 | Bike | TD--H--AGL-E--- | 2387.0 | 0.00027 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 266 | 266 | 2016-04-11 15:44:21+00:00 | Bike | TDS-H--AGL-E--- | 2182.0 | 14.60735 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 267 | 267 | 2016-04-12 15:19:25+00:00 | Bike | TDS-H--AGL-E--- | 284794.0 | 16.43036 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 268 | 268 | 2016-04-15 22:26:03+00:00 | Bike | TDS-H--AGL-E--- | 253587.0 | 19.28164 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 269 | 269 | 2016-04-18 20:52:35+00:00 | Bike | TDS-H--AGL-E--- | 5345.0 | 32.03125 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 270 | 270 | 2016-04-22 22:09:52+00:00 | Bike | TDS-H--AGL-E--- | 7923.0 | 34.9506 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 271 | 271 | 2016-05-10 21:50:58+00:00 | Bike | TDS-H--AGL-E--- | 3931.0 | 22.2101 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 272 | 272 | 2016-05-23 21:39:24+00:00 | Bike | TDS-H--AGL-E--- | 3219.0 | 25.57985 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 273 | 273 | 2016-05-24 20:10:37+00:00 | Bike | TDS-H--AGL-E--- | 8174.0 | 57.19483 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 274 | 274 | 2016-05-29 22:12:06+00:00 | Bike | TDS-H--AGL-E--- | 3878.0 | 29.10988 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 275 | 275 | 2016-06-06 14:47:30+00:00 | Bike | TDS-H--AGL-E--- | 8429.0 | 56.63907 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 276 | 276 | 2016-06-10 23:24:09+00:00 | Bike | TDS-H--AGL-E--- | 2739.0 | 21.17404 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 277 | 277 | 2016-06-21 23:04:08+00:00 | Bike | TDS-H--AGL-E--- | 3843.0 | 29.53954 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 278 | 278 | 2016-06-23 23:01:29+00:00 | Bike | TDS-H--AGL-E--- | 6162.0 | 41.72919 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 279 | 279 | 2016-06-25 00:20:32+00:00 | Bike | TDS-H--AGL-E--- | 1868.0 | 15.19661 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 280 | 280 | 2016-07-02 11:26:45+00:00 | Bike | TDS-H--AGL-E--- | 14023.0 | 99.79916 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 281 | 281 | 2016-07-03 15:49:36+00:00 | Bike | TDS-H--AGL-E--- | 3440.0 | 25.21586 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 282 | 282 | 2016-07-06 11:28:15+00:00 | Bike | TDS-H--AGL-E--- | 731010.0 | 32.33692 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 283 | 283 | 2016-07-14 22:32:04+00:00 | Bike | TDS-H--AGL-E--- | 9797.0 | 60.75608 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 284 | 284 | 2016-07-26 00:14:06+00:00 | Bike | TDS-H--AGL-E--- | 2904.0 | 24.73262 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 285 | 285 | 2016-08-08 23:39:40+00:00 | Bike | TDS-H--AGL-E--- | 2859.0 | 17.89394 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 286 | 286 | 2016-08-26 22:23:14+00:00 | Bike | TDS-H--AGL-E--- | 6123.0 | 27.99241 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 287 | 287 | 2016-08-29 20:42:55+00:00 | Bike | TDS-H--AGL-E--- | 3615.0 | 17.28121 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 288 | 288 | 2016-09-09 22:33:15+00:00 | Bike | TDS-H--AGL-E--- | 4789.0 | 20.39054 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 289 | 289 | 2016-09-17 13:06:53+00:00 | Bike | TDS-H--AGL-E--- | 4264.0 | 23.09562 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 290 | 290 | 2016-10-10 23:52:03+00:00 | Bike | TDS-H--AGL-E--- | 1630.0 | 11.50327 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 291 | 291 | 2016-10-26 23:13:49+00:00 | Bike | TD--H--AGL-E--- | 2055.0 | 0.05288 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 292 | 292 | 2016-10-28 22:11:52+00:00 | Bike | TDS-H--AGL-E--- | 7979.0 | 34.68685 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 293 | 293 | 2017-01-22 01:04:59+00:00 | Bike | TD--H--AGL-E--- | 2243.0 | 0.07239 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 294 | 294 | 2017-01-30 03:19:24+00:00 | Bike | TD--H--AGL-E--- | 2642.0 | 0.05281 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 295 | 295 | 2017-03-28 01:04:01+00:00 | Bike | TD--H--AGL-E--- | 1833.0 | 0.08561 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 296 | 296 | 2017-04-02 05:52:11+00:00 | Bike | TDS-H--AGL-E--- | 2009.0 | 0.08002 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 297 | 297 | 2017-04-02 18:56:37+00:00 | Bike | TDS-H--AGL-E--- | 4119.0 | 28.19721 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 298 | 298 | 2017-04-07 22:10:05+00:00 | Bike | TDS-H--AGL-E--- | 6376.0 | 35.39327 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 299 | 299 | 2017-04-14 22:29:44+00:00 | Bike | TDS-H--AGL-E--- | 4799.0 | 27.47597 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 300 | 300 | 2017-04-15 13:03:01+00:00 | Bike | TDS-H--AGL-E--- | 11215.0 | 56.24233 | {96836b71-7497-4393-b0ef-810ee3041daa} |
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");