Metadata for each ride in GoldenCheetah OpenData.

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

2,589,036 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

Link rowid date ▲ sport data workout_time total_distance athlete
2474767 2106-02-07 06:28:15+00:00   -------AG--E--- 1.0   {fff279c7-564e-43b5-a139-d6736c81b34b}
1251703 2106-02-07 06:28:15+00:00 Fitness equipment T--PHC--------- 409.0   {dd0332ba-e437-4727-9bd4-25eed225962d}
1995504 2080-12-30 23:16:05+00:00 Bike TDSPHC-AGL----- 3424.0 30.05593 {3cbfbe79-bca0-4cbb-9f47-aeeed28935ea}
2256496 2038-11-21 00:10:56+00:00 Bike TDSPHC-AGL-EV-- 8798.0 62.754 {c3dfebf3-92a2-4cff-b08a-5c120968641b}
2259254 2038-11-21 00:00:00+00:00 Bike TDS----AGL-E--- 2136.0 13.4144 {647b413b-7683-4061-97bd-c318ac5cb439}
2259253 2038-11-20 23:59:54+00:00 Bike TDS--C-AGL-E--- 6145.0 23.459 {647b413b-7683-4061-97bd-c318ac5cb439}
1350125 2028-02-06 00:00:01+00:00 Bike TDSPHC-AGL-E--- 8946.0 33.5266 {1dc7c187-3560-49eb-8f48-417a7bfa6fa9}
1350124 2028-02-05 22:50:23+00:00 Bike TDSPHC-AGL-E--- 2115.0 7.13258 {1dc7c187-3560-49eb-8f48-417a7bfa6fa9}
171321 2021-04-04 15:59:36+00:00   TDSPHC-A-L----- 12620.0 100.465 {24f0bef8-c356-4112-9385-14525c187d9d}
1871226 2020-12-31 20:31:30+00:00   TDS----AGL----- 4865.0 33.7842 {5b64901f-bfbd-478b-a3db-82902ffd1949}
1871225 2020-12-30 14:23:08+00:00   TDS----AGL----- 4435.0 30.7995 {5b64901f-bfbd-478b-a3db-82902ffd1949}
1471801 2020-12-15 20:09:33+00:00   TDSPHC-AGL----- 300.0 0.0015 {5b29d991-aed3-414e-82a7-028f9e65cfc0}
1754402 2020-06-13 18:08:36+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754401 2020-06-11 18:08:17+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754400 2020-06-09 18:08:06+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754399 2020-06-08 18:07:37+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754398 2020-06-06 18:07:16+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754397 2020-06-04 18:07:06+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754396 2020-06-02 18:06:55+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1754395 2020-06-01 18:06:28+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1153001 2020-05-31 16:39:00+00:00   ---------------     {31974efd-7867-4648-b73e-7a58c8d742ee}
1754394 2020-05-30 18:06:17+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1153000 2020-05-30 16:38:41+00:00   ---------------     {31974efd-7867-4648-b73e-7a58c8d742ee}
1152999 2020-05-29 16:38:21+00:00   ---------------     {31974efd-7867-4648-b73e-7a58c8d742ee}
1754393 2020-05-28 18:06:08+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1152998 2020-05-28 16:37:54+00:00   ---------------     {31974efd-7867-4648-b73e-7a58c8d742ee}
2307020 2020-05-27 12:18:52+00:00 Run TDSPHC-AGL-EV-R 3939.0 8.03493 {74bb725a-10df-409c-a0f2-c4af63b328a2}
292001 2020-05-27 12:07:49+00:00 Bike TDS-HC-AGL----- 3636.0 15.2067 {f1f03650-0c4d-4a0e-b551-5f991853ead7}
1474524 2020-05-27 11:44:24+00:00 Bike T---H------E--- 2716.0   {698a8f5c-23b1-469c-83e4-b44f588ab3d9}
860225 2020-05-27 10:51:39+00:00 Bike TDSPHC-AGL-EV-- 4286.0 40.00193 {b1d74472-3094-40b1-a74b-aaf5458d54de}
2207226 2020-05-27 09:21:37+00:00 Bike TDSPHC-AGL----- 3656.0 16.91078 {968b5656-26c8-4247-86aa-d61c96bab48f}
517360 2020-05-27 08:06:23+00:00 Bike TDSPHC-A-L-EV-- 661.0 2.97332 {7533797f-f594-4339-8d66-e6f4a9b56540}
517359 2020-05-27 07:51:59+00:00 Bike TDSPHC-A-L-EV-- 421.0 2.26539 {7533797f-f594-4339-8d66-e6f4a9b56540}
646915 2020-05-27 07:13:15+00:00 Bike TDSPHC-AGL----- 4033.0 32.9454 {8dcd2a50-5e80-4212-86da-253f8477c465}
1574550 2020-05-27 06:08:20+00:00 Bike TDSPHC-AGL-E--- 4189.0 20.74298 {fd18f701-f1c2-4081-8dd4-16a8f3c9fa7a}
909262 2020-05-26 22:59:58+00:00 Bike TDSPHCNAGL-EV-- 4408.0 32.1019 {a6557316-ecb9-4400-8b4b-22c8340a6085}
252288 2020-05-26 21:58:11+00:00   TDSPHC-AGL-E--- 11281.0 59.39707 {cc076ae8-9bbd-49fb-8eba-9a942c76ce68}
2337758 2020-05-26 19:20:03+00:00 Bike TDSPHC-AGL-EV-- 7340.0 62.38154 {a2cfe223-381d-4b45-8db7-cbe97ea2cbef}
1754392 2020-05-26 18:05:56+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1474523 2020-05-26 17:54:44+00:00 Walking TDS-HC-AGL-E--- 1303.0 1.30731 {698a8f5c-23b1-469c-83e4-b44f588ab3d9}
1668435 2020-05-26 17:20:26+00:00 Bike TDSP-C-AGL-E--- 1405.0 5.8184 {693bca7d-088c-424e-9f8a-a8d29ff50a4d}
1474522 2020-05-26 17:06:59+00:00 Run TDS-HC-AGL-E--R 2827.0 4.59973 {698a8f5c-23b1-469c-83e4-b44f588ab3d9}
679312 2020-05-26 17:02:30+00:00 Running: Road TDSPHC-AGL-E--R 3826.0 12.3004 {759a3f61-01f4-4433-a93e-48129dba9b23}
1474521 2020-05-26 16:39:14+00:00 Run TDS-HC-AGL-E--R 1003.0 2.15873 {698a8f5c-23b1-469c-83e4-b44f588ab3d9}
1152997 2020-05-26 16:33:35+00:00   ---------------     {31974efd-7867-4648-b73e-7a58c8d742ee}
764722 2020-05-26 16:05:13+00:00 Bike TDSPHC-AGL----- 7831.0 72.95652 {09423884-dfb0-44ce-8ad2-2e86aa926a5e}
325204 2020-05-26 16:03:55+00:00 Bike TDSPHC-A-L-E--- 3721.0 30.7838 {b0153cca-c5d0-416a-b482-b8aa969cfe14}
1800287 2020-05-26 15:49:08+00:00 Bike TDSPHC-AGL----- 1576.0 11.2783 {4c9d0ed0-5470-4523-8fa4-cb29efbff751}
309375 2020-05-26 15:43:40+00:00 Bike TDSPHC-AGL-E--- 8386.0 57.1114 {5cd61b91-8272-4e56-a027-0a25ca1ae09d}
552124 2020-05-26 15:23:36+00:00 Bike TDSPHC-AGL----- 5929.0 3.716 {42a2231c-0a81-4eaf-bc5e-e21dea1ec9ee}
1900361 2020-05-26 15:22:04+00:00 Bike TDSPHC-AGL----- 3071.0 24.4667 {b745f3a6-0cb8-4ebb-8740-ca056d452a5b}
1100081 2020-05-26 15:21:30+00:00 Bike TDSPHC-AGL----- 4669.0 36.0621 {f9bcbc5c-51ca-48de-b493-2905d56b9189}
1800286 2020-05-26 14:26:20+00:00 WeightTraining T---H---------- 4016.0   {4c9d0ed0-5470-4523-8fa4-cb29efbff751}
1662118 2020-05-26 14:02:58+00:00   TDSPHC--------- 3146.0 17.2776 {0e47ed92-d639-4cb3-97db-6f9a5fbfac70}
2097824 2020-05-26 12:32:21+00:00 Bike TDSPHC-AGL----- 9545.0 76.82532 {5a91f419-f1e8-48b5-95d8-0a1586e9215b}
829240 2020-05-26 12:30:42+00:00 Bike TDSPHC-AGL-E--- 9266.0 66.951 {90edd0f7-b94c-4aec-95fe-28ad4eb011d7}
1100080 2020-05-26 11:48:39+00:00 Bike TDS----AGL----- 926.0 3.2422 {f9bcbc5c-51ca-48de-b493-2905d56b9189}
860224 2020-05-26 11:03:19+00:00 Bike TDSPHC-AGL-EV-- 6800.0 46.9794 {b1d74472-3094-40b1-a74b-aaf5458d54de}
408794 2020-05-26 10:21:27+00:00 Bike TDSPHC-AGL-E--- 3603.0 18.1821 {ec31cd51-1351-4dfd-8b60-c956022ddd51}
974478 2020-05-26 10:16:35+00:00 Bike TDSPHC-AGL----- 3387.0 31.1333 {cd376bf3-8b7c-453c-aa8c-eb580fd01ace}
663855 2020-05-26 09:23:49+00:00 Bike TDSPHC--------- 2045.0 14.0361 {080ee7a6-d88b-4c9a-85a1-414ed379e752}
2447051 2020-05-26 07:37:51+00:00 Bike TDSPHC-AGL-E--- 16900.0 81.7092 {7c6b4603-ed9c-4906-90c0-e95664e00c7d}
1524429 2020-05-26 07:02:45+00:00 Bike TDSPHC-AGL-E--- 12104.0 91.76072 {4b42863d-fbba-4d43-ad17-e2f06e52b706}
623839 2020-05-26 06:59:43+00:00 Run TDS-HC-AGL----- 2933.0 9.011 {124d67ec-56a8-4fd2-9539-d484f17957d8}
646914 2020-05-26 06:52:04+00:00 Bike TDSPHC-AGL----- 7302.0 67.6921 {8dcd2a50-5e80-4212-86da-253f8477c465}
686827 2020-05-26 06:51:05+00:00 Bike TDS-H--AGL-E--- 3709.0 27.6507 {c8503103-44d6-4aeb-8c49-8103a30455f8}
1533559 2020-05-26 06:45:32+00:00 Bike TDSPHC-AGL----- 4084.0 35.0685 {42f9083c-f725-4faa-b2ae-c6b14fdc9cc9}
1837391 2020-05-26 06:39:01+00:00 Bike TDSPHC-AGL----- 7617.0 60.2038 {3b95fa3f-58ba-477b-820e-1ec1ba69c1dc}
813095 2020-05-26 06:23:33+00:00 Bike TDSPHC-AGL-EV-- 4316.0 31.4831 {966da803-67d9-4f9a-9bd9-da7a186f80ad}
1100079 2020-05-26 03:41:12+00:00 Bike TDS----AGL----- 519.0 2.9124 {f9bcbc5c-51ca-48de-b493-2905d56b9189}
2207225 2020-05-26 02:32:31+00:00 Bike TDSPHC-AGL----- 3547.0 30.06349 {968b5656-26c8-4247-86aa-d61c96bab48f}
325203 2020-05-25 23:29:28+00:00 Bike TDSPHC-A-L-E--- 1801.0 16.2347 {b0153cca-c5d0-416a-b482-b8aa969cfe14}
721254 2020-05-25 22:46:39+00:00 Bike TDSPHC-AGL-EV-- 5753.0 38.44846 {ebc162ef-680a-4fd6-927c-11b42aa77f63}
944683 2020-05-25 22:12:01+00:00 VirtualRide TDSPHC-AGL----- 2941.0 27.7348 {69c65c93-75dd-40d3-a687-1da912810438}
1596675 2020-05-25 21:13:42+00:00 Bike TDSPHCNA-L-E--- 7880.0 53.7184 {0109b2b3-1b3b-440c-8b44-337aa29f028d}
2337757 2020-05-25 19:16:59+00:00 Bike TDSPHC-AGL-EV-- 8943.0 77.48499 {a2cfe223-381d-4b45-8db7-cbe97ea2cbef}
624586 2020-05-25 18:59:01+00:00 Run TDSPHC-AGL----- 2155.0 6.9961 {80bf0183-e6f4-43f0-abd8-97acb6b80280}
974477 2020-05-25 18:39:35+00:00 Hike TDS-HC-AGL-E--- 3197.0 3.8252 {cd376bf3-8b7c-453c-aa8c-eb580fd01ace}
1961141 2020-05-25 18:14:45+00:00 Bike TDS-HC-AGL-E--- 3579.0 28.8665 {48950e04-eb02-421e-8601-937b69d324dd}
1754391 2020-05-25 18:05:18+00:00   ---------------     {c61c720a-63fd-4880-a98f-25ba105e6fa5}
1474520 2020-05-25 18:03:52+00:00 Bike T---H------E--- 1339.0   {698a8f5c-23b1-469c-83e4-b44f588ab3d9}
1961140 2020-05-25 18:03:34+00:00 Bike TDS-HC-AGL-E--- 640.0 4.83486 {48950e04-eb02-421e-8601-937b69d324dd}
1574549 2020-05-25 17:59:31+00:00 Bike TDSPHC-AGL-E--- 5998.0 31.86925 {fd18f701-f1c2-4081-8dd4-16a8f3c9fa7a}
2346373 2020-05-25 17:51:52+00:00 Evening Ride TDSPHC-A-L-E--- 2633.0 14.7448 {c0738560-12b1-4046-aca5-e7c08733065b}
1668434 2020-05-25 17:35:10+00:00 Bike TDSPHC-AGL-E--- 2603.0 20.4456 {693bca7d-088c-424e-9f8a-a8d29ff50a4d}
1837390 2020-05-25 17:18:09+00:00 Bike TDSPHC-AGL----- 5006.0 42.3501 {3b95fa3f-58ba-477b-820e-1ec1ba69c1dc}
1001988 2020-05-25 16:59:46+00:00 Strength ---------------     {9fb42d5b-13d2-440a-aa3d-cf5663cdc0f7}
308964 2020-05-25 16:45:40+00:00 Bike TDSPH--AGL-E--- 1980.0 17.52535 {797f027f-cd5e-479f-b956-8a052e5dd0dc}
325202 2020-05-25 16:18:38+00:00 Bike TDS-H--AGL----- 5494.0 14.1791 {b0153cca-c5d0-416a-b482-b8aa969cfe14}
1152996 2020-05-25 16:08:51+00:00 MTB TDSPHC-AGL-E-O- 8989.0 45.01256 {31974efd-7867-4648-b73e-7a58c8d742ee}
2327791 2020-05-25 15:51:44+00:00 Bike TDSPHC-AGL-EV-- 13624.0 77.364 {eaa4dc84-9cfa-4366-bdf7-a535473cd60e}
1001987 2020-05-25 15:51:09+00:00 Bike TDSPHC-A-L----- 4326.06 30.9869 {9fb42d5b-13d2-440a-aa3d-cf5663cdc0f7}
1413283 2020-05-25 15:38:57+00:00 Run TDSPHC-----E--R 5408.0 14.4545 {045e4210-a638-4e0b-80ff-8ee91b639ad9}
2154430 2020-05-25 15:17:10+00:00 Bike TDSPHC-AGL----- 3027.0 26.2433 {86f10c55-71bd-4c61-a22e-1c14e7a448d2}
1900360 2020-05-25 15:03:42+00:00 Bike TDSPHC-AGL----- 3310.0 24.3364 {b745f3a6-0cb8-4ebb-8740-ca056d452a5b}
2133468 2020-05-25 14:46:21+00:00 Bike TDSP---AGL----- 3648.0 22.47587 {f48d1934-c2cc-4db9-958e-51b86a996cdf}
552123 2020-05-25 14:45:34+00:00 Bike TDSPHC--------- 1801.0 11.4717 {42a2231c-0a81-4eaf-bc5e-e21dea1ec9ee}
309374 2020-05-25 14:43:24+00:00 Bike TDSPHC-AGL-E--- 1900.0 13.07009 {5cd61b91-8272-4e56-a027-0a25ca1ae09d}
2142846 2020-05-25 14:38:13+00:00 Bike TDSPHC--------- 3661.0 25.544 {dce41788-af95-47cb-bc1a-06ba58952ad5}
1533558 2020-05-25 14:34:56+00:00 Run TDS-HC-AGL-E--- 3893.0 13.8041 {42f9083c-f725-4faa-b2ae-c6b14fdc9cc9}

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