rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by sport
This data as json, CSV (advanced)
These facets timed out: date
| Link | rowid | date | sport ▼ | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 374 | 374 | 2017-11-07 19:00:00+00:00 | --------------- | 1800.0 | 16.0934 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 402 | 402 | 2018-01-03 22:36:08+00:00 | TDSP-C-AGL-E--- | 5140.0 | 42.50397 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 421 | 421 | 2018-01-27 23:55:28+00:00 | TDS----AGL----- | 1438.0 | 8.91269 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 422 | 422 | 2018-01-28 03:59:35+00:00 | TDS----AGL----- | 1522.0 | 9.13776 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 444 | 444 | 2018-02-24 14:30:00+00:00 | --------------- | 7200.0 | 56.327 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
| 1999 | 1999 | 2014-12-30 18:02:53+00:00 | TDSPHC-A-L-E--- | 2789.0 | 22.05755 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | |
| 2155 | 2155 | 2015-09-10 16:03:19+00:00 | T---H---------- | 3181.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2168 | 2168 | 2015-10-09 12:59:59+00:00 | T---H---------- | 3602.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2169 | 2169 | 2015-10-09 14:13:00+00:00 | TDS-HC-AGL----R | 9119.0 | 17.5382 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | |
| 2185 | 2185 | 2015-11-15 15:15:22+00:00 | TDS-HC--------R | 8031.0 | 15.7594 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | |
| 2187 | 2187 | 2015-11-24 00:08:10+00:00 | T---H---------- | 3336.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2188 | 2188 | 2015-11-26 17:02:09+00:00 | T---H---------- | 3302.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2345 | 2345 | 2016-09-08 16:15:29+00:00 | T---H---------- | 2711.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2347 | 2347 | 2016-09-13 00:52:01+00:00 | TDS-HC-AGL----R | 665.0 | 2.29539 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | |
| 2349 | 2349 | 2016-09-13 15:54:00+00:00 | T---H---------- | 4774.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2350 | 2350 | 2016-09-15 00:02:50+00:00 | T---H---------- | 3328.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2352 | 2352 | 2016-09-15 16:16:16+00:00 | T---H---------- | 2684.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2353 | 2353 | 2016-09-17 02:56:22+00:00 | T---H---------- | 1805.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2356 | 2356 | 2016-09-20 16:14:06+00:00 | T---H---------- | 2725.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2363 | 2363 | 2016-10-04 16:18:47+00:00 | T---H---------- | 2542.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2365 | 2365 | 2016-10-06 16:15:58+00:00 | T---H---------- | 2753.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2367 | 2367 | 2016-10-11 16:17:11+00:00 | T---H---------- | 2679.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2372 | 2372 | 2016-10-18 16:22:02+00:00 | T---H---------- | 2349.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2374 | 2374 | 2016-10-18 17:47:00+00:00 | T---H---------- | 2686.0 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | ||
| 2888 | 2888 | 2019-02-24 15:00:16+00:00 | --------------- | {a261fff9-a6c6-46a6-ba88-969773bc80dd} | |||
| 2889 | 2889 | 2019-02-25 01:12:24+00:00 | --------------- | 900.0 | {a261fff9-a6c6-46a6-ba88-969773bc80dd} | ||
| 2897 | 2897 | 2019-03-01 13:12:50+00:00 | T-------G--E--- | 15.0 | {a261fff9-a6c6-46a6-ba88-969773bc80dd} | ||
| 2913 | 2913 | 2017-04-12 10:00:00+00:00 | --------------- | {0e118a96-d384-4ac2-8021-c3508781a03b} | |||
| 3563 | 3563 | 2019-02-14 16:52:53+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3564 | 3564 | 2019-02-16 15:59:46+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3565 | 3565 | 2019-02-17 09:46:50+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3587 | 3587 | 2014-04-19 15:52:45+00:00 | TDS----AGL----- | 5906.0 | 14.9058 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3588 | 3588 | 2014-04-21 19:58:21+00:00 | TDS----AGL----- | 2984.0 | 5.14428 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3589 | 3589 | 2014-04-22 19:44:27+00:00 | TDS----AGL----- | 10771.0 | 6.63186 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3590 | 3590 | 2014-04-23 09:34:03+00:00 | TDS----AGL----- | 2084.0 | 3.63124 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3591 | 3591 | 2014-04-23 19:01:17+00:00 | TDS----AGL----- | 2461.0 | 4.64216 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3592 | 3592 | 2014-04-27 20:10:36+00:00 | TDS----AGL----- | 3954.0 | 19.344 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3593 | 3593 | 2014-05-01 19:36:13+00:00 | TDS----AGL----- | 2511.0 | 15.4261 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3594 | 3594 | 2014-05-07 13:37:50+00:00 | TDS----AGL----- | 5059.0 | 29.7827 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3595 | 3595 | 2014-05-10 09:50:27+00:00 | TDS----AGL----- | 5540.0 | 34.4099 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3596 | 3596 | 2014-05-11 09:50:12+00:00 | TDS----AGL----- | 2944.0 | 17.879 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3597 | 3597 | 2014-05-25 14:14:28+00:00 | TDS----AGL----- | 6786.0 | 43.6702 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3598 | 3598 | 2014-05-29 16:14:30+00:00 | TDS----AGL----- | 5657.0 | 33.0624 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3599 | 3599 | 2014-05-31 10:05:15+00:00 | TDS----AGL----- | 5445.0 | 37.099 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3600 | 3600 | 2014-06-07 09:39:48+00:00 | TDS----AGL----- | 7421.0 | 50.9883 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3601 | 3601 | 2014-06-08 09:42:44+00:00 | TDS----AGL----- | 4371.0 | 25.1629 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3602 | 3602 | 2014-06-09 18:27:24+00:00 | TDS----AGL----- | 2884.0 | 4.88035 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3603 | 3603 | 2014-06-15 12:38:08+00:00 | TDS----AGL----- | 5910.0 | 9.87302 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3604 | 3604 | 2014-06-17 00:41:11+00:00 | TDS----AGL----- | 1621.0 | 1.97925 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3605 | 3605 | 2014-07-04 12:23:24+00:00 | TDS----AGL----- | 2640.0 | 5.32697 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3606 | 3606 | 2014-07-10 22:48:20+00:00 | TDS----AGL----- | 4893.0 | 33.9941 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3607 | 3607 | 2014-07-12 09:44:34+00:00 | TDS----AGL----- | 7173.0 | 51.3607 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3608 | 3608 | 2014-07-18 17:43:08+00:00 | TDS----AGL----- | 8094.0 | 54.0192 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3609 | 3609 | 2014-07-20 16:31:42+00:00 | TDS----AGL----- | 889.0 | 1.69347 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3610 | 3610 | 2014-07-20 17:35:42+00:00 | TDS----AGL----- | 7370.0 | 48.0043 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3611 | 3611 | 2014-07-26 09:54:10+00:00 | TDS----AGL----- | 7366.0 | 54.6243 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3612 | 3612 | 2014-08-01 19:04:44+00:00 | TDS----AGL----- | 2645.0 | 5.47637 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3613 | 3613 | 2014-08-02 16:56:53+00:00 | TDS----AGL----- | 7526.0 | 52.4898 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3614 | 3614 | 2014-08-14 09:37:47+00:00 | TDS----AGL----- | 40926.0 | 11.4509 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3615 | 3615 | 2014-08-16 10:07:03+00:00 | TDS----AGL----- | 7997.0 | 57.4005 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3616 | 3616 | 2014-08-19 16:19:23+00:00 | TDS----AGL----- | 9898.0 | 9.26837 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3617 | 3617 | 2014-08-27 13:29:35+00:00 | TDS----AGL----- | 21267.0 | 23.6829 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3618 | 3618 | 2014-09-09 20:19:26+00:00 | TDS--C-AGL-E--- | 140.0 | 0.53748 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3619 | 3619 | 2014-09-14 13:41:23+00:00 | TDS-HC-AGL-E--- | 7608.0 | 50.9659 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3620 | 3620 | 2014-09-16 16:58:05+00:00 | TDS-HC-AGL-E--- | 7505.0 | 52.8642 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3621 | 3621 | 2014-09-19 12:37:46+00:00 | TDS-HC-AGL-E--- | 10456.0 | 64.5917 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3622 | 3622 | 2014-09-21 10:40:40+00:00 | TDS-HC-AGL-E--- | 3773.0 | 27.9509 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3623 | 3623 | 2014-09-27 10:45:07+00:00 | TDS-HC-AGL-E--- | 11279.0 | 70.3339 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3624 | 3624 | 2014-09-29 13:49:54+00:00 | TDS-HC-AGL-E--- | 7274.0 | 51.2096 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3625 | 3625 | 2014-10-05 16:44:04+00:00 | TDS--C-AGL-E--- | 5342.0 | 12.7939 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3626 | 3626 | 2014-10-11 16:10:17+00:00 | TDS-HC-AGL-E--- | 5444.0 | 37.9275 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3627 | 3627 | 2014-10-12 15:12:11+00:00 | TDS-HC-AGL-E--- | 7076.0 | 46.4255 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3628 | 3628 | 2014-10-16 16:40:02+00:00 | TDS-HC-AGL-E--- | 7818.0 | 51.3423 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3629 | 3629 | 2014-10-18 10:42:44+00:00 | TDS-HC-AGL-E--- | 10111.0 | 65.2067 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3630 | 3630 | 2014-10-19 10:53:20+00:00 | TDS-HC-AGL-E--- | 2356.0 | 16.1337 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3631 | 3631 | 2014-10-25 10:48:01+00:00 | TDS-HC-AGL-E--- | 10607.0 | 67.1579 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3632 | 3632 | 2014-10-26 10:45:58+00:00 | TDS-HC-AGL-E--- | 5158.0 | 33.6963 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3633 | 3633 | 2014-11-02 13:59:16+00:00 | TDS----AGL----- | 3749.0 | 6.48437 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3634 | 3634 | 2014-11-04 11:35:21+00:00 | TDS-HC-AGL-E--- | 7693.0 | 51.3081 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3635 | 3635 | 2014-11-08 11:27:11+00:00 | TDS--C-AGL-E--- | 6610.0 | 42.7911 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3636 | 3636 | 2014-11-09 13:37:47+00:00 | TDS-HC-AGL-E--- | 7014.0 | 51.0671 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3637 | 3637 | 2014-11-15 11:48:23+00:00 | TDS-HC-AGL-E--- | 4675.0 | 33.138 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3638 | 3638 | 2014-11-16 17:20:04+00:00 | TDS-HC-AGL-E--- | 4431.0 | 28.0493 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3639 | 3639 | 2014-11-22 11:59:53+00:00 | TDS-HC-AGL-E--- | 5040.0 | 31.0389 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3640 | 3640 | 2014-11-23 11:52:31+00:00 | TDS-HC-AGL-E--- | 4622.0 | 32.2411 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3641 | 3641 | 2014-11-25 11:51:55+00:00 | TDS-HC-AGL-E--- | 7321.0 | 51.512 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3642 | 3642 | 2014-11-27 13:07:43+00:00 | TDS-HC-AGL-E--- | 4850.0 | 33.0805 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3643 | 3643 | 2014-11-28 14:05:13+00:00 | TDS-HC-AGL-E--- | 4671.0 | 33.0228 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3644 | 3644 | 2014-11-29 15:00:33+00:00 | TDS-HC-AGL-E--- | 2651.0 | 16.161 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3645 | 3645 | 2014-11-30 13:14:58+00:00 | TDS-HC-AGL-E--- | 7024.0 | 50.7107 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3646 | 3646 | 2014-12-05 12:24:22+00:00 | TDS-HC-AGL-E--- | 4846.0 | 32.9726 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3647 | 3647 | 2014-12-07 14:43:47+00:00 | TDS-HC-AGL-E--- | 2524.0 | 16.2767 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3648 | 3648 | 2014-12-21 15:00:06+00:00 | TDS-HC-AGL-E--- | 4653.0 | 32.2815 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3649 | 3649 | 2014-12-25 18:27:05+00:00 | TDS--C-AGL-E--- | 2528.0 | 16.3071 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3650 | 3650 | 2014-12-26 13:00:35+00:00 | TDS-HC-AGL-E--- | 7319.0 | 51.1627 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3651 | 3651 | 2014-12-27 12:57:19+00:00 | TDS-HC-AGL-E--- | 4637.0 | 32.8917 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3652 | 3652 | 2015-01-01 15:53:40+00:00 | TDS-HC-AGL-E--- | 4812.0 | 33.7653 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3653 | 3653 | 2015-01-03 12:40:04+00:00 | TDS-HC-AGL-E--- | 860.0 | 4.58794 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3654 | 3654 | 2015-01-03 13:00:23+00:00 | TDS-HC-AGL-E--- | 8594.0 | 39.6642 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3655 | 3655 | 2015-01-10 18:52:45+00:00 | TDS-HC-AGL-E--- | 2687.0 | 16.0553 | {bcffcd4a-1727-481b-8eda-858e976c3cea} |
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");