Metadata for each ride in GoldenCheetah OpenData.

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

1,460,162 rows where data contains "P" sorted by sport

View and edit SQL

Link rowid date sport ▼ data workout_time total_distance athlete
402 2018-01-03 22:36:08+00:00   TDSP-C-AGL-E--- 5140.0 42.50397 {96836b71-7497-4393-b0ef-810ee3041daa}
1999 2014-12-30 18:02:53+00:00   TDSPHC-A-L-E--- 2789.0 22.05755 {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
3680 2015-08-30 10:11:01+00:00   TDSPHC-AGL-E--- 4898.0 34.0139 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3681 2015-08-31 18:52:55+00:00   TDSPHC-AGL-E--- 7264.0 51.1193 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3682 2015-09-03 10:26:06+00:00   TDSPHC-AGL-E--- 12291.0 80.1604 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3683 2015-09-04 14:39:40+00:00   TDSPHC-AGL-E--- 7012.0 51.2787 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3684 2015-09-12 10:26:41+00:00   TDSPHC-AGL-E--- 11132.0 67.7325 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3686 2015-10-09 11:15:13+00:00   TDSPHC-AGL-E--- 6436.0 43.8053 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3687 2015-10-17 12:43:03+00:00   TDSPHC-AGL-E--- 2654.0 16.5944 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3688 2015-11-02 12:15:16+00:00   TDSPHC-AGL-E--- 5468.0 36.4833 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3689 2015-11-03 14:33:20+00:00   TDSPHC-AGL-E--- 6562.0 42.3458 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3690 2015-11-04 15:51:22+00:00   TDSPHC-AGL-E--- 4336.0 28.3004 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3691 2018-03-15 13:34:41+00:00   TDSP-C-AGL-E--- 1172.0 6.0853 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3692 2018-03-17 15:01:36+00:00   TDSPHC-AGL-E--- 3084.0 15.7083 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3693 2018-03-18 14:54:36+00:00   TDSP-C-AGL-E--- 3157.0 15.9903 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3710 2018-05-13 09:49:32+00:00   TDSPHC-AGL-E--- 5416.0 37.2659 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3849 2019-02-09 15:23:02+00:00   TDSPHC-AGL----- 5535.0 31.7478 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3858 2019-03-31 22:42:00+00:00   TDSPHC-AGL----- 3618.0 24.2706 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3859 2019-04-01 23:59:13+00:00   TDSPHC-AGL----- 3616.0 31.8582 {bcffcd4a-1727-481b-8eda-858e976c3cea}
3970 2019-11-12 23:32:45+00:00   TDSPHC-AGL----- 1000.0 7.77837 {bcffcd4a-1727-481b-8eda-858e976c3cea}
4384 2017-07-15 22:43:29+00:00   TDSPHC-AGL-E--- 3896.0 0.77267 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4385 2017-07-17 07:35:44+00:00   TDSPHC-AGL-E--- 2725.0 0.5867 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4386 2017-07-17 12:01:09+00:00   TDSPHC-AGL-E--- 1812.0 0.48128 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4387 2017-07-17 22:52:51+00:00   TDSPHC-AGL-E--- 3014.0 0.75159 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4390 2017-07-18 20:20:03+00:00   TDSPHC-AGL-E--- 3674.0 21.4632 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4391 2017-07-19 20:17:53+00:00   TDSPHC-AGL-E--- 2791.0 21.5164 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4392 2017-07-20 07:32:45+00:00   TDSPHC-AGL-E--- 8897.0 0.69932 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4393 2017-07-20 12:02:17+00:00   TDSPHC-AGL-E--- 2081.0 0.67438 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4394 2017-07-20 20:25:14+00:00   TDSPHC-AGL-E--- 2374.0 17.707 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4395 2017-07-22 21:54:32+00:00   TDSPHC-AGL-E--- 4410.0 37.0385 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4396 2017-07-23 07:30:01+00:00   TDSPHC-AGL-E--- 3183.0 0.98768 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4397 2017-07-23 20:24:11+00:00   TDSPHC-AGL-E--- 3354.0 23.8249 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4398 2017-07-24 22:36:53+00:00   TDSPHC-AGL-E--- 1213.0 0.23852 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4401 2017-07-25 08:17:06+00:00   TDSPHC-AGL-E--- 4541.0 1.05581 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4402 2017-07-25 12:26:00+00:00   TDSP-C-AGL-E--- 3031.0 0.23437 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4403 2017-07-25 20:26:48+00:00   TDSPHC-AGL-E--- 3096.0 25.0604 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4404 2017-07-26 22:29:16+00:00   TDSPHC-AGL-E--- 1805.0 0.42778 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4405 2017-07-28 08:03:37+00:00   TDSPHC-AGL-E--- 3768.0 0.89728 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4406 2017-07-28 20:26:52+00:00   TDSPHC-AGL-E--- 2403.0 0.63304 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4407 2017-07-29 23:15:39+00:00   TDSPHC-AGL-E--- 8533.0 67.1894 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4408 2017-07-30 08:03:45+00:00   TDSPHC-AGL-E--- 2702.0 0.60366 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4409 2017-07-30 20:13:11+00:00   TDSPHC-AGL-E--- 3070.0 20.7665 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4410 2017-07-31 20:16:13+00:00   TDSPHC-AGL-E--- 5617.0 36.6737 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4411 2017-08-01 20:27:41+00:00   TDSPHC-AGL-E--- 4263.0 32.1887 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4414 2017-08-02 20:17:19+00:00   TDSPHC-AGL-E--- 2906.0 21.9927 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4417 2017-08-03 23:37:05+00:00   TDSPHC-AGL-E--- 3903.0 0.99162 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4418 2017-08-04 03:27:48+00:00   TDSPHC-AGL-E--- 3612.0 1.56731 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4421 2017-08-05 07:11:19+00:00   TDSPHC-AGL-E--- 628.0 3.02219 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4422 2017-08-05 07:49:48+00:00   TDSPHC-AGL-E--- 3606.0 0.86829 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4423 2017-08-05 21:35:58+00:00   TDSPHC-AGL-E--- 7331.0 55.0952 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4424 2017-08-06 06:23:47+00:00   TDSP-C-AGL-E--- 6806.0 52.885 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4433 2017-08-10 21:32:15+00:00   TDSP-C-AGL-E--- 3893.0 25.39 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4434 2017-08-11 08:07:57+00:00   TDSP-C-AGL-E--- 2629.0 18.1995 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4435 2017-08-11 21:14:48+00:00   TDSP-C-AGL-E--- 8761.0 62.649 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4436 2017-08-12 06:03:59+00:00   TDSP-C-AGL-E--- 2702.0 1.10414 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4438 2017-08-12 22:35:24+00:00   TDSP-C-AGL-E--- 7897.0 59.1623 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4439 2017-08-13 08:07:42+00:00   TDSP-C-AGL-E--- 2702.0 1.48484 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4440 2017-08-13 22:17:43+00:00   TDSP-C-AGL-E--- 4886.0 29.7815 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4441 2017-08-15 21:52:06+00:00   TDSP-C-AGL-E--- 2220.0 5.38821 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4442 2017-08-16 07:05:55+00:00   TDSP-C-AGL-E--- 2403.0 0.88587 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4443 2017-08-16 21:28:22+00:00   TDSP-C-AGL-E--- 9861.0 74.7893 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4444 2017-08-17 05:28:20+00:00   TDSP-C-AGL-E--- 3122.0 0.68335 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4445 2017-08-17 19:20:47+00:00   TDSP-C-AGL-E--- 8147.0 65.719 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4446 2017-08-18 23:36:26+00:00   TDSPHC-AGL-E--- 9199.0 66.461 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4447 2017-08-19 07:48:46+00:00   TDSPHC-AGL-E--- 4502.0 0.71147 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4448 2017-08-19 23:10:59+00:00   TDSPHC-AGL-E--- 16839.0 90.411 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4449 2017-08-20 08:13:58+00:00   TDSPHC-AGL-E--- 3002.0 0.68942 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4450 2017-08-20 21:35:37+00:00   TDSPHC-AGL-E--- 3557.0 20.4046 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4451 2017-08-21 08:09:40+00:00   TDSPHC-AGL-E--- 2888.0 17.5564 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4452 2017-08-21 10:03:01+00:00   TDSPHC-AGL-E--- 3499.0 0.65552 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4453 2017-08-21 20:53:23+00:00   TDSPHC-AGL-E--- 5856.0 36.0676 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4454 2017-08-22 08:10:30+00:00   TDSPHC-AGL-E--- 2755.0 18.0394 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4455 2017-08-22 10:20:32+00:00   TDSPHC-AGL-E--- 5666.0 41.0299 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4456 2017-08-22 21:31:24+00:00   TDSPHC-AGL-E--- 3797.0 21.1915 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4457 2017-08-23 08:12:42+00:00   TDSPHC-AGL-E--- 3004.0 17.4482 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4458 2017-08-23 21:02:05+00:00   TDSPHC-AGL-E--- 5604.0 28.6048 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4459 2017-08-24 08:28:52+00:00   TDSPHC-AGL-E--- 2989.0 16.4651 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4460 2017-08-24 21:33:08+00:00   TDSPHC-AGL-E--- 3603.0 18.9706 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4461 2017-08-25 08:16:01+00:00   TDSPHC-AGL-E--- 2739.0 16.6124 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4462 2017-08-25 22:17:49+00:00   TDSP-C-AGL-E--- 479.0 2.82263 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4463 2017-08-26 22:00:03+00:00   TDSPHC-AGL-E--- 3792.0 20.0427 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4464 2017-08-27 00:03:35+00:00   TDSPHC-AGL-E--- 3894.0 19.8348 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4465 2017-08-27 21:40:36+00:00   TDSPHC-AGL-E--- 3297.0 17.6954 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4466 2017-08-28 08:15:08+00:00   TDSPHC-AGL-E--- 2597.0 16.6733 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4467 2017-08-28 20:42:05+00:00   TDSPHC-AGL-E--- 6823.0 47.5995 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4468 2017-08-29 08:11:50+00:00   TDSPHC-AGL-E--- 2861.0 18.0431 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4469 2017-08-29 10:11:45+00:00   TDSPHC-AGL-E--- 3839.0 28.2677 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4470 2017-08-29 20:54:40+00:00   TDSPHC-AGL-E--- 5295.0 31.681 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4471 2017-08-30 09:21:39+00:00   TDSPHC-AGL-E--- 2418.0 16.3222 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4472 2017-08-30 20:43:19+00:00   TDSPHC-AGL-E--- 7139.0 49.768 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4473 2017-08-31 08:10:47+00:00   TDSPHC-AGL-E--- 2867.0 16.1963 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4474 2017-08-31 09:53:33+00:00   TDSPHC-AGL-E--- 4941.0 36.4222 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4475 2017-08-31 21:30:31+00:00   TDSPHC-AGL-E--- 3906.0 19.9961 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4476 2017-09-01 08:20:55+00:00   TDSPHC-AGL-E--- 2964.0 16.6542 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4477 2017-09-01 21:24:10+00:00   TDSPHC-AGL-E--- 10372.0 78.7936 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4480 2017-09-02 06:19:02+00:00   TDSPHC-AGL-E--- 6200.0 46.8749 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4481 2017-09-02 22:56:20+00:00   TDSPHC-AGL-E--- 5875.0 50.0447 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4482 2017-09-03 00:51:04+00:00   TDSPHC-AGL-E--- 4167.0 38.9913 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4483 2017-09-03 02:06:47+00:00   TDSPHC-AGL-E--- 7793.0 22.3764 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4484 2017-09-03 06:29:43+00:00   TDSPHC-AGL-E--- 6273.0 48.7881 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}

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