Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows sorted by athlete

View and edit SQL

These facets timed out: date

Link rowid date sport data workout_time total_distance athlete ▼
2578609 2017-08-03 10:08:20+00:00 Bike T--PHC-A---E--- 982.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578610 2017-08-07 07:00:18+00:00 Bike TDSPHC-AGL-E--- 16517.0 116.31595 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578611 2017-08-07 16:04:11+00:00 Bike TDSPHC-AGL-E--- 8018.0 53.22113 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578612 2017-08-08 07:03:23+00:00 Bike TDSPHC-AGL-E--- 9593.0 67.42696 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578613 2017-08-09 07:52:47+00:00 Bike TDSPHC-AGL-E--- 3457.0 27.2569 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578614 2017-08-09 13:59:47+00:00 Bike TDSP-C-AGL-E--- 9561.0 100.674 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578615 2017-08-11 07:50:24+00:00 Bike TDSPHC-AGL-E--- 2306.0 5.50205 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578616 2017-08-11 13:58:05+00:00 Bike TDSP-C-AGL-E--- 9438.0 100.115 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578617 2017-10-10 13:00:13+00:00 Bike TDS-H--AGL----- 5263.0 40.35878 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578618 2017-10-12 08:50:37+00:00 Bike TDS-H--AGL----- 10133.0 18.69211 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578619 2017-10-16 13:51:26+00:00 Bike TDS-H--AGL----- 6045.0 46.65599 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578620 2017-10-17 14:21:48+00:00 Bike TDS-H--AGL----- 6065.0 43.90915 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578621 2017-10-19 13:55:40+00:00 Bike TDS-H--AGL----- 5937.0 40.23251 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578622 2017-10-20 08:43:51+00:00 Run TDS----AGL----- 2029.0 7.87418 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578623 2017-10-21 08:00:44+00:00 Bike TDS-H--AGL----- 7992.0 34.50757 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578624 2017-10-22 07:01:25+00:00 Bike TDS-H--AGL----- 17935.0 34.0414 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578625 2017-10-28 06:45:13+00:00 Run TDS--C-AGL----- 18539.0 31.2906 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578626 2017-10-29 08:33:10+00:00 Bike TDS-H--AGL----- 14782.0 44.25413 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578627 2017-10-30 19:51:18+00:00 Bike T---H--A------- 3918.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578628 2017-10-31 09:13:53+00:00 Bike T---H--A------- 3006.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578629 2017-11-01 08:48:40+00:00 Bike TDS-H--AGL----- 15789.0 97.40457 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578630 2017-11-03 10:11:03+00:00 Run TDS----AGL----- 1828.0 6.74938 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578631 2017-11-04 07:16:48+00:00 Run TDS-H--AGL----- 12827.0 20.9697 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578632 2017-11-05 07:58:31+00:00 Bike TDS-H--AGL----- 13018.0 58.3492 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578633 2017-11-06 15:06:45+00:00 Bike TDS-H--AGL----- 8749.0 65.78611 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578634 2017-11-07 14:47:58+00:00 Bike TDS-H--AGL----- 6926.0 45.0396 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578635 2017-11-07 16:43:57+00:00 Bike TDS-H--AGL----- 819.0 4.34211 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578636 2017-11-09 13:15:56+00:00 Bike TDS-H--AGL----- 5705.0 41.3538 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578637 2017-11-10 06:52:08+00:00 Bike TDSPHC-AGL----- 15960.0 115.73551 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578638 2017-11-11 06:59:18+00:00 Bike TDS-H--AGL----- 29362.0 118.191 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578639 2017-11-12 06:52:55+00:00 Bike TDSPHC-AGL----R 23749.0 144.02843 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578640 2017-11-14 18:25:49+00:00 Bike T--PHC-A------- 2033.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578641 2017-11-15 12:59:14+00:00 Bike TDSPHC-AGL----- 11067.0 87.4819 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578642 2017-11-16 13:15:51+00:00 Bike TDSPHC-AGL----- 6717.0 50.18972 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578643 2017-11-17 10:32:28+00:00 Bike TDSPHC-AGL----- 10868.0 89.23507 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578644 2017-11-18 07:39:09+00:00 Bike TDSPHC-AGL----- 18957.0 115.709 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578645 2017-11-21 09:33:36+00:00 Bike TDSPHC-AGL----R 10452.0 78.73888 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578646 2017-11-22 13:11:35+00:00 Bike TDSPH--AGL----- 13521.0 103.38114 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578647 2017-11-23 13:11:48+00:00 Bike TDSPHC-AGL----- 11123.0 87.84501 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578648 2017-11-24 09:20:00+00:00 Bike TDSPHC-AGL----- 15467.0 113.92305 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578649 2017-11-25 07:54:47+00:00 Bike TDSPHC-AGL----- 15202.0 95.75164 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578650 2017-11-28 10:55:34+00:00 Bike TDSPHC-AGL----- 8228.0 70.40977 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578651 2017-11-30 11:55:32+00:00 Bike TDSPHC-AGL----- 16216.0 114.03177 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578652 2017-12-01 08:10:04+00:00 Bike TDSPHC-AGL----R 10917.0 78.60286 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578653 2017-12-02 09:08:39+00:00 Bike TDSPHC-AGL----- 20737.0 130.38608 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578654 2017-12-03 07:41:27+00:00 Bike TDSPH--AGL----- 19758.0 140.19773 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578655 2017-12-06 07:40:54+00:00 Bike T--PHC-A------- 3121.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578656 2017-12-06 09:19:34+00:00 Bike TDSPHC-AGL----R 16785.0 115.968 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578657 2017-12-07 07:11:52+00:00 Bike T--PHC-A------R 3002.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578658 2017-12-07 09:10:25+00:00 Bike TDSPH--AGL----- 15883.0 103.88891 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578659 2017-12-08 09:04:07+00:00 Bike TDSPHC-AGL----- 20516.0 148.27616 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578660 2017-12-09 09:13:34+00:00 Bike TDSPHC-AGL----- 14943.0 93.78401 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578661 2017-12-10 08:02:59+00:00 Bike TDSPH--AGL----- 22063.0 148.34327 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578662 2017-12-11 05:11:06+00:00 Bike T--PHC-A------- 3614.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578663 2017-12-13 12:43:54+00:00 Bike TDSPHC-AGL----- 5856.0 46.85974 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578664 2017-12-15 09:35:29+00:00 Bike TDSPHC-AGL----- 17909.0 113.93568 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578665 2017-12-16 08:26:33+00:00 Bike TDSPHC-AGL----- 10674.0 84.2975 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578666 2017-12-17 07:17:48+00:00 Bike TDSPHC-AGL----R 20299.0 140.89011 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578667 2017-12-18 14:22:54+00:00 Bike TDSPH--AGL----- 6103.0 50.63983 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578668 2017-12-19 12:52:53+00:00 Bike TDSPHC-AGL----- 10902.0 82.6051 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578669 2017-12-20 13:01:36+00:00 Bike TDSPHC-AGL----- 7758.0 60.16999 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578670 2017-12-21 11:49:36+00:00 Bike TDSPHC-AGL----- 10165.0 84.015 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578671 2017-12-22 08:22:18+00:00 Bike TDSPHC-AGL----R 24837.0 165.92223 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578672 2017-12-23 09:21:36+00:00 Bike TDSPHC-AGL----- 12746.0 95.26613 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578673 2017-12-23 13:01:37+00:00 Bike T--PHC-A------- 1209.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578674 2017-12-24 08:34:29+00:00 Bike TDSPHC-AGL----- 22066.0 140.4255 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578675 2017-12-25 09:18:35+00:00 Bike TDSPH--AGL----- 8898.0 66.70647 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578676 2017-12-26 09:38:51+00:00 Bike TDSPH--AGL----- 12470.0 94.63577 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578677 2017-12-26 13:10:40+00:00 Bike T--PHC-A------R 1280.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578678 2017-12-27 09:38:32+00:00 Bike T--PH--A------- 11075.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578679 2017-12-28 09:20:07+00:00 Bike T--PHC-A------- 4050.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578680 2017-12-28 16:33:26+00:00 Bike T--PHC-A------- 1806.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578681 2017-12-29 05:59:22+00:00 Bike T--PHC-A------- 2710.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578682 2017-12-29 08:22:21+00:00   TDS----AGL----- 13090.0 90.7265 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578683 2017-12-30 08:43:27+00:00 Bike TDSPHC-AGL----R 16637.0 106.68929 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578684 2017-12-31 08:02:19+00:00 Bike TDSPHC-AGL----R 23014.0 162.8193 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578685 2018-01-01 09:33:53+00:00 Bike TDSPHC-AGL----R 9060.0 68.8623 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578686 2018-01-02 08:56:24+00:00 Bike TDSPHC-AGL----R 17619.0 142.757 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578687 2018-01-03 08:18:17+00:00 Bike T--PHC-A------- 3657.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578688 2018-01-03 10:57:55+00:00 Bike TDSPHC-AGL----- 8318.0 60.8527 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578689 2018-01-04 08:59:03+00:00 Bike TDSPHC-AGL----R 15540.0 104.691 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578690 2018-01-05 08:12:43+00:00 Bike TDSPHC-AGL----R 21856.0 148.88139 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578691 2018-01-06 06:19:19+00:00 Bike T--PHC-A------- 3305.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578692 2018-01-06 08:31:39+00:00 Bike TDSPHC-AGL----- 10170.0 69.01111 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578693 2018-01-07 07:08:27+00:00 Bike TDSPHC-AGL----R 26274.0 166.08788 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578694 2018-01-09 11:03:32+00:00 Bike TDSPHC-AGL----- 8380.0 57.638 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578695 2018-01-10 09:21:40+00:00 Bike TDSPHC-AGL----R 16178.0 129.76885 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578696 2018-01-11 07:18:08+00:00 Bike T--PHC-A------- 3128.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578697 2018-01-11 08:51:20+00:00 Bike TDSPHC-AGL----- 11248.0 72.13651 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578698 2018-01-12 10:57:42+00:00 Bike TDSPHC-AGL----R 14777.0 111.32672 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578699 2018-01-13 07:32:28+00:00 Bike T--PHC-A------- 4294.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578700 2018-01-13 10:20:44+00:00 Bike TDSPHC-AGL----R 12192.0 94.25281 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578701 2018-01-14 07:04:26+00:00 Bike TDSPHC-AGL----R 22383.0 156.13989 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578702 2018-01-15 10:33:43+00:00 Bike TDSPHC-AGL----- 12073.0 73.11387 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578703 2018-01-16 07:09:54+00:00 Bike TDSPHC-AGL----R 28139.0 190.54263 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578704 2018-01-17 08:43:41+00:00 Bike TDSPHC-AGL----- 13315.0 96.27591 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578705 2018-01-19 06:48:50+00:00 Bike T--PHC-A------- 3138.0   {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578706 2018-01-19 08:36:25+00:00 Bike TDSPHC-AGL----R 11579.0 90.81104 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578707 2018-01-20 09:10:59+00:00 Bike TDSPHC-AGL----R 13364.0 119.34196 {000c6417-e1e4-497e-89e6-bb21e17ec355}
2578708 2018-01-21 08:57:40+00:00 Bike TDSPHC-AGL----R 13338.0 86.525 {000c6417-e1e4-497e-89e6-bb21e17ec355}

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