Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows sorted by sport

View and edit SQL

These facets timed out: date

Link rowid date sport ▼ data workout_time total_distance athlete
4430 2017-08-09 08:11:31+00:00   TDS----AGL-E--- 3039.0 18.1974 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4431 2017-08-09 21:33:05+00:00   TDS----AGL-E--- 4037.0 21.7801 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4432 2017-08-10 08:09:31+00:00   TDS----AGL-E--- 2900.0 18.288 {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}
4437 2017-08-12 07:57:04+00:00   TDS----AGL-E--- 800.0 4.39912 {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}
4478 2017-09-02 00:52:49+00:00   TDS-H--AGL-E--- 1004.0 4.24213 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4479 2017-09-02 01:49:45+00:00   TDS-H--AGL-E--- 1025.0 4.09477 {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}
4485 2017-09-03 21:37:16+00:00   TDSPHC-AGL-E--- 3515.0 19.6997 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4486 2017-09-04 08:45:03+00:00   TDSPHC-AGL-E--- 2809.0 16.1568 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4487 2017-09-04 20:34:11+00:00   TDSPHC-AGL-E--- 7450.0 50.8044 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4488 2017-09-05 08:14:28+00:00   TDSPHC-AGL-E--- 2733.0 17.8365 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4489 2017-09-05 10:32:38+00:00   TDSPHC-AGL-E--- 337.0 0.13026 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4490 2017-09-05 21:07:02+00:00   TDSPHC-AGL-E--- 5124.0 30.3786 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4491 2017-09-06 08:58:01+00:00   TDSPHC-AGL-E--- 2677.0 18.0805 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4492 2017-09-06 21:06:33+00:00   TDSPHC-AGL-E--- 5334.0 32.9134 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4493 2017-09-07 08:51:42+00:00   TDSPHC-AGL-E--- 2601.0 16.4235 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4494 2017-09-07 21:37:59+00:00   TDSPHC-AGL-E--- 3216.0 17.6765 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4495 2017-09-08 09:36:22+00:00   TDSPHC-AGL-E--- 2277.0 16.7079 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4496 2017-09-08 21:32:35+00:00   TDSPHC-AGL-E--- 1871.0 14.142 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4497 2017-09-09 07:34:19+00:00   TDSPHC-AGL-E--- 1919.0 11.1743 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4498 2017-09-09 20:44:34+00:00   TDSP-C-AGL-E--- 765.0 4.91149 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4499 2017-09-09 21:30:03+00:00   TDSP-C-AGL-E--- 246.0 2.23977 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4500 2017-09-09 22:00:01+00:00   TDSPHC-AGL-E--- 4104.0 27.1785 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4501 2017-09-10 00:18:08+00:00   TDSPHC-AGL-E--- 4531.0 25.8687 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4502 2017-09-11 21:34:51+00:00   TDSPHC-AGL-E--- 3558.0 17.0661 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4503 2017-09-12 09:29:34+00:00   TDSPHC-AGL-E--- 2808.0 16.666 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4504 2017-09-12 21:39:31+00:00   TDSPHC-AGL-E--- 3718.0 17.9336 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4505 2017-09-13 09:22:55+00:00   TDSPHC-AGL-E--- 2622.0 16.4479 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4506 2017-09-13 20:45:03+00:00   TDSPHC-AGL-E--- 6529.0 35.372 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4507 2017-09-14 09:21:05+00:00   TDSPHC-AGL-E--- 2641.0 16.9201 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4508 2017-09-14 21:37:54+00:00   TDSPHC-AGL-E--- 3411.0 18.8722 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4509 2017-09-15 09:24:41+00:00   TDSPHC-AGL-E--- 2522.0 16.7211 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4510 2017-09-15 21:09:45+00:00   TDSPHC-AGL-E--- 4151.0 32.1232 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4511 2017-09-16 06:59:26+00:00   TDSPHC-AGL-E--- 2450.0 1.06036 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4512 2017-09-16 21:58:09+00:00   TDSPHC-AGL-E--- 3030.0 22.5889 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4513 2017-09-17 21:09:10+00:00   TDSPHC-AGL-E--- 5366.0 33.0164 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4514 2017-09-18 08:48:21+00:00   TDSPHC-AGL-E--- 2496.0 16.6926 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4515 2017-09-18 20:53:04+00:00   TDSPHC-AGL-E--- 6001.0 34.3157 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4516 2017-09-19 08:32:47+00:00   TDSPHC-AGL-E--- 2535.0 16.6876 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4517 2017-09-19 20:57:23+00:00   TDSPHC-AGL-E--- 5839.0 37.7598 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4518 2017-09-20 10:21:59+00:00   TDSPHC-AGL-E--- 2344.0 17.8836 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4519 2017-09-20 21:00:24+00:00   TDSPHC-AGL-E--- 6055.0 41.0044 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4520 2017-09-21 10:23:29+00:00   TDSPHC-AGL-E--- 2555.0 16.9021 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4521 2017-09-21 21:40:01+00:00   TDSPHC-AGL-E--- 3271.0 17.7342 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4522 2017-09-22 10:23:48+00:00   TDSPHC-AGL-E--- 2654.0 16.973 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4523 2017-09-22 23:11:03+00:00   TDSPHC-AGL-E--- 10178.0 75.5882 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4524 2017-09-23 21:14:23+00:00   TDSPHC-AGL-E--- 14349.0 108.85 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4525 2017-09-24 04:58:23+00:00   TDSP-C-AGL-E--- 10498.0 31.0771 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4526 2017-09-24 21:41:53+00:00   TDSPHC-AGL-E--- 3234.0 19.0228 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4527 2017-09-25 10:20:45+00:00   TDSPHC-AGL-E--- 2374.0 16.9551 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4528 2017-09-25 20:52:08+00:00   TDSPHC-AGL-E--- 6015.0 37.3058 {75bc14e8-270b-4b8b-ae37-ed0219ca70ec}
4529 2017-09-26 10:24:52+00:00   TDSPHC-AGL-E--- 2549.0 16.8293 {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");