Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows

View and edit SQL

These facets timed out: date

Link rowid ▼ date sport data workout_time total_distance athlete
1 2018-07-07 11:33:58+00:00 Bike TDS-H--AGL-E--- 9461.0 82.2777 {862ffe90-6760-472e-969a-5b3cd11c2798}
2 2018-07-08 14:19:39+00:00 Bike TDS-H--AGL-E--- 6674.0 39.6764 {862ffe90-6760-472e-969a-5b3cd11c2798}
3 2018-07-10 22:30:43+00:00 Bike TDS-H--AGL-E--- 7228.0 60.56882 {862ffe90-6760-472e-969a-5b3cd11c2798}
4 2018-07-12 21:38:29+00:00 Bike TDS-H--AGL-E--- 5024.0 16.90347 {862ffe90-6760-472e-969a-5b3cd11c2798}
5 2018-07-14 12:04:18+00:00 Bike TDS-H--AGL-E--- 9781.0 79.10735 {862ffe90-6760-472e-969a-5b3cd11c2798}
6 2018-07-15 14:18:59+00:00 Bike TDS-H--AGL-E--- 5181.0 43.6815 {862ffe90-6760-472e-969a-5b3cd11c2798}
7 2018-07-17 22:30:04+00:00 Bike TDS-H--AGL-E--- 6427.0 54.68898 {862ffe90-6760-472e-969a-5b3cd11c2798}
8 2018-07-19 21:01:53+00:00 Bike TDS-H--AGL-E--- 4398.0 37.72233 {862ffe90-6760-472e-969a-5b3cd11c2798}
9 2018-07-21 13:14:05+00:00 Bike TDS-H--AGL-E--- 8386.0 70.5535 {862ffe90-6760-472e-969a-5b3cd11c2798}
10 2018-07-28 13:10:51+00:00 Bike TDS-H--AGL-E--- 5783.0 51.32727 {862ffe90-6760-472e-969a-5b3cd11c2798}
11 2018-07-29 13:44:12+00:00 Bike TDS----AGL-E--- 9532.0 77.36283 {862ffe90-6760-472e-969a-5b3cd11c2798}
12 2018-07-31 14:01:53+00:00 Bike TDS-H--AGL-E--- 9340.0 77.326 {862ffe90-6760-472e-969a-5b3cd11c2798}
13 2018-08-02 13:36:22+00:00 Bike TDS-H--AGL-E--- 8113.0 66.70456 {862ffe90-6760-472e-969a-5b3cd11c2798}
14 2018-08-03 13:19:36+00:00 Bike TDS-H--AGL-E--- 5342.0 43.9868 {862ffe90-6760-472e-969a-5b3cd11c2798}
15 2018-08-05 13:49:57+00:00 Bike TDS-H--AGL-E--- 7531.0 58.76861 {862ffe90-6760-472e-969a-5b3cd11c2798}
16 2018-08-08 22:03:57+00:00 Bike TDS-H--AGL-E--- 3670.0 22.81351 {862ffe90-6760-472e-969a-5b3cd11c2798}
17 2018-08-11 13:41:02+00:00 Bike TDS-H--AGL-E--- 7540.0 59.45814 {862ffe90-6760-472e-969a-5b3cd11c2798}
18 2018-08-12 12:42:33+00:00 Bike TDS-H--AGL-E--- 7268.0 58.05615 {862ffe90-6760-472e-969a-5b3cd11c2798}
19 2018-08-14 20:57:30+00:00 Bike TDS-H--AGL-E--- 8210.0 66.54857 {862ffe90-6760-472e-969a-5b3cd11c2798}
20 2018-08-16 21:42:56+00:00 Bike TDS-H--AGL-E--- 4078.0 26.22698 {862ffe90-6760-472e-969a-5b3cd11c2798}
21 2018-08-18 13:55:24+00:00 Bike TDS----AGL-E--- 10191.0 78.684 {862ffe90-6760-472e-969a-5b3cd11c2798}
22 2018-08-19 14:12:16+00:00 Bike TDS----AGL-E--- 6796.0 48.64709 {862ffe90-6760-472e-969a-5b3cd11c2798}
23 2018-08-21 21:57:30+00:00 Bike TDS-H--AGL-E--- 4771.0 27.25624 {862ffe90-6760-472e-969a-5b3cd11c2798}
24 2018-08-23 21:32:18+00:00 Bike TDS-H--AGL-E--- 6741.0 55.77193 {862ffe90-6760-472e-969a-5b3cd11c2798}
25 2018-08-25 12:59:44+00:00 Bike TDS-H--AGL-E--- 10919.0 91.59971 {862ffe90-6760-472e-969a-5b3cd11c2798}
26 2018-08-26 13:53:54+00:00 Bike TDS-H--AGL-E--- 8671.0 51.54341 {862ffe90-6760-472e-969a-5b3cd11c2798}
27 2018-08-28 20:39:39+00:00 Bike TDS-H--AGL-E--- 3317.0 21.26509 {862ffe90-6760-472e-969a-5b3cd11c2798}
28 2018-09-01 12:44:44+00:00 Bike TDS-H--AGL-E--- 11686.0 71.00108 {862ffe90-6760-472e-969a-5b3cd11c2798}
29 2018-09-02 14:05:59+00:00 Bike TDS-H--AGL-E--- 7063.0 57.74023 {862ffe90-6760-472e-969a-5b3cd11c2798}
30 2018-09-06 20:44:12+00:00 Bike TDS-H--AGL-E--- 6876.0 57.46943 {862ffe90-6760-472e-969a-5b3cd11c2798}
31 2018-09-08 13:12:43+00:00 Bike TDS-H--AGL-E--- 5493.0 46.45597 {862ffe90-6760-472e-969a-5b3cd11c2798}
32 2018-09-09 12:44:38+00:00 Bike TDS-H--AGL-E--- 8824.0 39.11958 {862ffe90-6760-472e-969a-5b3cd11c2798}
33 2018-09-11 21:02:18+00:00 Bike TDS-H--AGL-E--- 6859.0 56.56734 {862ffe90-6760-472e-969a-5b3cd11c2798}
34 2018-09-13 22:08:46+00:00 Bike TDS-H--AGL-E--- 4084.0 19.51168 {862ffe90-6760-472e-969a-5b3cd11c2798}
35 2018-09-15 13:25:04+00:00 Bike TDS-H--AGL-E--- 6558.0 53.11692 {862ffe90-6760-472e-969a-5b3cd11c2798}
36 2018-09-16 13:08:29+00:00 Bike TDS-H--AGL-E--- 9913.0 81.05589 {862ffe90-6760-472e-969a-5b3cd11c2798}
37 2018-09-18 21:32:52+00:00 Bike TDS-H--AGL-E--- 6143.0 38.32656 {862ffe90-6760-472e-969a-5b3cd11c2798}
38 2018-09-22 12:39:34+00:00 Bike TDS-H--AGL-E--- 6982.0 58.34663 {862ffe90-6760-472e-969a-5b3cd11c2798}
39 2018-09-23 12:45:05+00:00 Bike TDS-H--AGL-E--- 9163.0 48.26446 {862ffe90-6760-472e-969a-5b3cd11c2798}
40 2018-09-25 21:02:28+00:00 Bike TDS-H--AGL-E--- 3886.0 28.4059 {862ffe90-6760-472e-969a-5b3cd11c2798}
41 2018-09-29 13:33:40+00:00 Bike TDS-H--AGL-E--- 10204.0 75.6633 {862ffe90-6760-472e-969a-5b3cd11c2798}
42 2018-09-30 13:30:53+00:00 Bike TDS----AGL-E--- 3858.0 25.61622 {862ffe90-6760-472e-969a-5b3cd11c2798}
43 2018-10-07 12:37:58+00:00 Bike TDS----AGL-E--- 7889.0 36.31397 {862ffe90-6760-472e-969a-5b3cd11c2798}
44 2018-10-08 13:43:59+00:00 Bike TDS----AGL-E--- 8185.0 45.95568 {862ffe90-6760-472e-969a-5b3cd11c2798}
45 2018-10-10 20:43:02+00:00 Bike TDS----AGL-E--- 6995.0 41.1246 {862ffe90-6760-472e-969a-5b3cd11c2798}
46 2018-10-14 13:13:09+00:00 Bike TDS----AGL-E--- 6931.0 31.6827 {862ffe90-6760-472e-969a-5b3cd11c2798}
47 2018-10-15 21:40:59+00:00 Bike TDS----AGL-E--- 6837.0 34.6308 {862ffe90-6760-472e-969a-5b3cd11c2798}
48 2018-10-18 23:02:50+00:00 Bike TDS----AGL-E--- 5919.0 28.78155 {862ffe90-6760-472e-969a-5b3cd11c2798}
49 2018-10-20 13:34:52+00:00 Bike TDS----AGL-E--- 7238.0 46.41149 {862ffe90-6760-472e-969a-5b3cd11c2798}
50 2018-10-21 12:47:46+00:00 Bike TDS----AGL-E--- 9836.0 44.39642 {862ffe90-6760-472e-969a-5b3cd11c2798}
51 2018-10-22 21:54:34+00:00 Bike TDS----AGL-E--- 6171.0 40.0424 {862ffe90-6760-472e-969a-5b3cd11c2798}
52 2018-10-29 21:41:51+00:00 Bike TDS----AGL-E--- 5325.0 21.9971 {862ffe90-6760-472e-969a-5b3cd11c2798}
53 2018-11-03 14:40:34+00:00 Bike TDS----AGL-E--- 5718.0 44.21793 {862ffe90-6760-472e-969a-5b3cd11c2798}
54 2018-11-04 14:10:50+00:00 Bike TDS----AGL-E--- 8693.0 63.15389 {862ffe90-6760-472e-969a-5b3cd11c2798}
55 2018-11-05 22:49:55+00:00 Bike TDS----AGL-E--- 8683.0 42.2118 {862ffe90-6760-472e-969a-5b3cd11c2798}
56 2018-11-11 14:04:06+00:00 Bike TDS----AGL-E--- 9872.0 35.82186 {862ffe90-6760-472e-969a-5b3cd11c2798}
57 2018-11-12 22:44:21+00:00 Bike TDS----AGL-E--- 6697.0 43.3922 {862ffe90-6760-472e-969a-5b3cd11c2798}
58 2018-11-17 14:11:37+00:00 Bike TDS----AGL-E--- 1974.0 7.34998 {862ffe90-6760-472e-969a-5b3cd11c2798}
59 2018-11-22 23:27:30+00:00 Bike TDS----AGL-E--- 6305.0 17.66357 {862ffe90-6760-472e-969a-5b3cd11c2798}
60 2018-11-25 14:58:53+00:00 Bike TDS----AGL-E--- 5689.0 22.79068 {862ffe90-6760-472e-969a-5b3cd11c2798}
61 2018-12-01 14:42:50+00:00 Bike TDS----AGL-E--- 7517.0 44.80934 {862ffe90-6760-472e-969a-5b3cd11c2798}
62 2018-12-03 22:45:20+00:00 Bike TDS----AGL-E--- 10105.0 43.23107 {862ffe90-6760-472e-969a-5b3cd11c2798}
63 2018-12-08 14:09:06+00:00 Bike TDS----AGL-E--- 6989.0 18.4453 {862ffe90-6760-472e-969a-5b3cd11c2798}
64 2018-12-09 13:45:39+00:00 Bike TDS----AGL-E--- 8945.0 42.48479 {862ffe90-6760-472e-969a-5b3cd11c2798}
65 2018-12-10 22:55:43+00:00 Bike TDS----AGL-E--- 7701.0 20.76378 {862ffe90-6760-472e-969a-5b3cd11c2798}
66 2018-12-15 15:22:15+00:00 Bike TDS----AGL-E--- 5632.0 16.5011 {862ffe90-6760-472e-969a-5b3cd11c2798}
67 2018-12-16 14:05:11+00:00 Bike TDS-H--AGL-E--- 10266.0 24.34646 {862ffe90-6760-472e-969a-5b3cd11c2798}
68 2018-12-23 14:41:41+00:00 Bike TDS-H--AGL-E--- 7141.0 32.79855 {862ffe90-6760-472e-969a-5b3cd11c2798}
69 2018-12-26 15:03:49+00:00 Bike TDS-H--AGL-E--- 7367.0 32.66147 {862ffe90-6760-472e-969a-5b3cd11c2798}
70 2018-12-27 16:03:12+00:00 Bike TDS-H--AGL-E--- 6000.0 26.88388 {862ffe90-6760-472e-969a-5b3cd11c2798}
71 2018-12-30 14:07:52+00:00 Bike TDS-H--AGL-E--- 8127.0 24.83275 {862ffe90-6760-472e-969a-5b3cd11c2798}
72 2019-01-06 14:16:17+00:00 Bike TDS-H--AGL-E--- 6213.0 18.4468 {862ffe90-6760-472e-969a-5b3cd11c2798}
73 2019-01-12 14:01:12+00:00 Bike TDS-H--AGL-E--- 3703.0 19.1207 {862ffe90-6760-472e-969a-5b3cd11c2798}
74 2019-01-20 14:21:36+00:00 Bike TDS----AGL-E--- 9125.0 18.17449 {862ffe90-6760-472e-969a-5b3cd11c2798}
75 2019-01-26 19:00:51+00:00 Bike TDS-H--AGL-E--- 3868.0 13.298 {862ffe90-6760-472e-969a-5b3cd11c2798}
76 2019-02-02 15:19:34+00:00 Bike TDS-H--AGL-E--- 8579.0 21.87237 {862ffe90-6760-472e-969a-5b3cd11c2798}
77 2019-02-10 14:07:18+00:00 Bike TDS-H--AGL-E--- 8037.0 49.96073 {862ffe90-6760-472e-969a-5b3cd11c2798}
78 2019-02-17 14:03:32+00:00 Bike TDS-H--AGL-E--- 8719.0 24.9473 {862ffe90-6760-472e-969a-5b3cd11c2798}
79 2019-02-23 14:25:49+00:00 Bike TDS-H--AGL-E--- 6254.0 22.842 {862ffe90-6760-472e-969a-5b3cd11c2798}
80 2019-03-03 15:22:34+00:00 Bike TDS-H--AGL-E--- 5800.0 12.8706 {862ffe90-6760-472e-969a-5b3cd11c2798}
81 2019-03-04 23:39:27+00:00 Bike TDS-H--AGL-E--- 4299.0 11.41563 {862ffe90-6760-472e-969a-5b3cd11c2798}
82 2019-03-09 13:57:05+00:00 Bike TDS-H--AGL-E--- 8852.0 27.68319 {862ffe90-6760-472e-969a-5b3cd11c2798}
83 2019-03-17 17:14:39+00:00 Bike TDS-H--AGL-E--- 7251.0 50.30427 {862ffe90-6760-472e-969a-5b3cd11c2798}
84 2019-03-19 21:04:29+00:00 Bike TDS-H--AGL-E--- 3435.0 17.64515 {862ffe90-6760-472e-969a-5b3cd11c2798}
85 2019-03-21 20:48:20+00:00 Bike TDS-H--AGL-E--- 4679.0 35.17268 {862ffe90-6760-472e-969a-5b3cd11c2798}
86 2019-03-23 13:34:57+00:00 Bike TDS-H--AGL-E--- 6233.0 45.98868 {862ffe90-6760-472e-969a-5b3cd11c2798}
87 2019-03-24 13:02:08+00:00 Bike TDS-H--AGL-E--- 6718.0 48.84507 {862ffe90-6760-472e-969a-5b3cd11c2798}
88 2019-03-26 21:38:59+00:00 Bike TDS-H--AGL-E--- 4577.0 28.91636 {862ffe90-6760-472e-969a-5b3cd11c2798}
89 2019-03-27 20:44:08+00:00 Bike TDS-H--AGL-E--- 7089.0 51.11704 {862ffe90-6760-472e-969a-5b3cd11c2798}
90 2019-04-06 12:55:10+00:00 Bike TDS-H--AGL-E--- 5190.0 40.48332 {862ffe90-6760-472e-969a-5b3cd11c2798}
91 2019-04-07 12:30:23+00:00 Bike TDS-H--AGL-E--- 9622.0 69.65101 {862ffe90-6760-472e-969a-5b3cd11c2798}
92 2019-04-13 12:16:21+00:00 Bike TDS-H--AGL-E--- 12892.0 84.90858 {862ffe90-6760-472e-969a-5b3cd11c2798}
93 2019-05-02 21:42:10+00:00 Bike TDS-H--AGL-E--- 5372.0 25.30364 {862ffe90-6760-472e-969a-5b3cd11c2798}
94 2019-05-07 21:00:05+00:00 Bike TDS-H--AGL-E--- 5899.0 49.25954 {862ffe90-6760-472e-969a-5b3cd11c2798}
95 2019-05-08 20:51:41+00:00 Bike TDS-H--AGL-E--- 4762.0 25.6847 {862ffe90-6760-472e-969a-5b3cd11c2798}
96 2019-05-16 21:26:04+00:00 Bike TDS-H--AGL-E--- 7677.0 58.50062 {862ffe90-6760-472e-969a-5b3cd11c2798}
97 2019-05-18 13:39:56+00:00 Bike TDS-H--AGL-E--- 8062.0 57.67858 {862ffe90-6760-472e-969a-5b3cd11c2798}
98 2019-05-19 13:30:42+00:00 Bike TDS-H--AGL-E--- 7055.0 54.03515 {862ffe90-6760-472e-969a-5b3cd11c2798}
99 2019-05-21 22:52:10+00:00 Bike TDS-H--AGL-E--- 3989.0 20.0038 {862ffe90-6760-472e-969a-5b3cd11c2798}
100 2019-05-26 13:52:31+00:00 Bike TDS----AGL-E--- 5816.0 45.50784 {862ffe90-6760-472e-969a-5b3cd11c2798}

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