rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,238,511 rows where data contains "H" and data contains "P" sorted by workout_time
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time ▼ | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 11721 | 11721 | 2015-08-22 10:58:04+00:00 | Bike | TDSPHC-AGL-E--- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 11737 | 11737 | 2015-09-13 09:16:51+00:00 | Bike | TDSPHC-AGL-E--- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 15430 | 15430 | 2020-02-19 14:32:59+00:00 | Bike | TDSPHC-AGL-E--- | {ee04cfac-a3c8-4a96-9780-bf0b0999cf35} | ||
| 18451 | 18451 | 2018-06-21 17:27:33+00:00 | Bike | TDSPHC-AGL----- | {820aab4b-dd94-49ff-a29f-1ba2835b1637} | ||
| 18495 | 18495 | 2019-02-15 15:15:05+00:00 | Bike | TDSPHC-AGL-E--- | 23.5969 | {820aab4b-dd94-49ff-a29f-1ba2835b1637} | |
| 22641 | 22641 | 2017-11-08 12:11:10+00:00 | Bike | T--PHC-A---EV-- | {fa6fd293-edb2-4e6a-be4d-d424df8a5b54} | ||
| 35320 | 35320 | 2018-02-25 09:13:39+00:00 | TDSPHC--------- | {652368a4-d13a-46d9-ba1b-f2e022bb1ac8} | |||
| 65014 | 65014 | 2015-05-22 20:07:15+00:00 | TDSPHC-AGL-EV-- | 2.21576 | {494566f9-395f-4a60-88e9-eee8a734da69} | ||
| 65188 | 65188 | 2016-12-07 12:56:00+00:00 | TDSPH--A-L----- | 5.36203 | {494566f9-395f-4a60-88e9-eee8a734da69} | ||
| 65210 | 65210 | 2018-04-22 11:19:13+00:00 | ciclismo | TDSPHC-AGL-E--- | 65.2753 | {494566f9-395f-4a60-88e9-eee8a734da69} | |
| 84439 | 84439 | 2017-02-12 12:49:21+00:00 | Bike | TDSPHC-AGL-EV-- | 55.5667 | {54d49c15-343e-49ad-9b24-226f31bb522a} | |
| 85116 | 85116 | 2019-11-06 16:21:24+00:00 | Bike | TDSPHC-AGL-EV-- | 44.18024 | {4590ec4a-f8ca-44fd-875d-5b19cc448b99} | |
| 86415 | 86415 | 2019-11-07 17:41:02+00:00 | Bike | T--PHC-----E--- | {d8d9a9c1-bb5e-4016-af64-ab4d3ade20d6} | ||
| 86416 | 86416 | 2019-11-08 17:32:13+00:00 | Bike | T--PHC-----E--- | {d8d9a9c1-bb5e-4016-af64-ab4d3ade20d6} | ||
| 86420 | 86420 | 2019-11-12 17:48:58+00:00 | Bike | T--PHC-----E--- | {d8d9a9c1-bb5e-4016-af64-ab4d3ade20d6} | ||
| 86428 | 86428 | 2019-11-20 23:10:33+00:00 | Bike | T--PHC-----E--- | {d8d9a9c1-bb5e-4016-af64-ab4d3ade20d6} | ||
| 89750 | 89750 | 2017-12-26 09:56:41+00:00 | TDSPHC--------- | {4fb202cb-2045-4678-8db8-293ab9d74e87} | |||
| 94449 | 94449 | 2015-06-08 16:42:47+00:00 | Bike | TDSPHC-AGL-E--- | {3a063e0d-8e76-4f6f-9bed-1b6826e42cb9} | ||
| 134512 | 134512 | 2019-07-23 17:40:23+00:00 | Bike | TDSPHC-AGL--V-- | 24.4003 | {49c7d0c2-0a5d-421c-ab68-1118ba7773ef} | |
| 165395 | 165395 | 2019-12-05 10:22:40+00:00 | T--PHC--------- | {6cc3b6e8-5666-4d0e-a862-af77ef9569b2} | |||
| 178945 | 178945 | 2017-09-01 12:24:28+00:00 | Bike | TDSPHC-AGL-EV-- | 42.42705 | {c81232f7-f95f-43b6-be66-f2575574b58d} | |
| 184505 | 184505 | 2018-09-02 09:09:00+00:00 | Bike | TDSPHC--------- | 10.6758 | {8a97d3a4-a27a-44ba-9b3d-d2569c9af533} | |
| 186060 | 186060 | 2017-09-06 19:35:32+00:00 | Bike | TDSPHC-AGL-E--- | 23.93897 | {67d6e943-d6d8-437d-a9f3-b0b4c73a40cf} | |
| 192058 | 192058 | 2016-09-13 07:21:14+00:00 | Bike | TDSPHCNA-L-E--- | {ac56eb65-3047-40e8-951a-d091564daee8} | ||
| 211081 | 211081 | 2019-01-02 10:32:48+00:00 | Bike | TDSPHC-AGL----- | {b453c2b0-3cee-41cf-bbd7-2189a8079592} | ||
| 218526 | 218526 | 2018-01-30 14:25:37+00:00 | Bike | TDSPHC-AGL----- | 18.6559 | {d2547c0f-5cd3-4a1e-a5bf-9f62b2901f68} | |
| 221613 | 221613 | 2017-09-05 17:19:30+00:00 | Bike | TDSPHC-AGL-E--- | 55.54315 | {f50b9dab-22b8-412f-a9bb-d49d48e28a1f} | |
| 269774 | 269774 | 2019-01-03 12:23:41+00:00 | Bike | TDSPHC-A-L-EV-- | {f2619765-558e-462d-9d42-386fe46f512c} | ||
| 294342 | 294342 | 2019-02-10 18:25:40+00:00 | Bike | TDSPHC-A-L-EV-- | 24.38329 | {41dd0232-60bb-4eb7-8532-5c561f31e977} | |
| 306250 | 306250 | 2018-08-29 07:46:10+00:00 | Bike | TDSPHC-A-L-EV-- | {c6964a76-aad4-41c7-856d-cb558f691053} | ||
| 307212 | 307212 | 2017-01-13 21:20:58+00:00 | Bike | TDSPHC-AGL-E--- | {40654cf1-202d-414c-a42a-00499f433231} | ||
| 324195 | 324195 | 2020-01-16 12:29:04+00:00 | Bike | TDSPHC-AGL-E--- | 19.0675 | {7f31f3e0-d38a-444b-bc0c-c6479de4e15c} | |
| 340358 | 340358 | 2020-05-02 09:12:51+00:00 | Bike | TDSPHC-AGL----- | {dbf3af9b-9d08-4a57-b89b-c20f745a3572} | ||
| 342051 | 342051 | 2015-03-10 16:18:23+00:00 | Bike | TDSPHC-AGL-E--- | {415a05b3-ef4d-4733-8f13-7211857935b0} | ||
| 343497 | 343497 | 2016-01-09 11:36:59+00:00 | Bike | TDSPHC-AGL-EV-- | 56.39031 | {b58f0877-db1f-4ba2-b1ce-9e5301e8e403} | |
| 343521 | 343521 | 2016-04-02 07:33:55+00:00 | Bike | TDSPHC-AGL----- | 38.85791 | {b58f0877-db1f-4ba2-b1ce-9e5301e8e403} | |
| 365008 | 365008 | 2017-12-29 10:56:08+00:00 | Bike | TDSPHC--------- | {e6168fd8-96f5-4cda-8bae-ca41871ab3e3} | ||
| 381870 | 381870 | 2014-11-08 08:53:56+00:00 | TDSPHC-AGL----- | {3c59468a-7406-46fd-8e8d-40c5a43d974f} | |||
| 407216 | 407216 | 2017-03-18 14:47:04+00:00 | Rolle | TDSPHC-A-L-EV-- | {12fcb8e7-f2f4-41ae-ba0c-7a488ae43eba} | ||
| 415015 | 415015 | 2019-06-26 11:48:23+00:00 | Bike | TDSPHC-AGL-E--- | 65.6484 | {1f50d41c-282b-4452-ab0a-03d6024688cb} | |
| 416627 | 416627 | 2019-04-03 16:50:09+00:00 | Bike | T--PHC-----EV-- | {dcab3dde-f4d5-4df0-92bf-448f5ef012d6} | ||
| 416637 | 416637 | 2019-06-02 12:39:28+00:00 | Bike | T--PHC-----E--- | {dcab3dde-f4d5-4df0-92bf-448f5ef012d6} | ||
| 443805 | 443805 | 2018-02-05 08:00:06+00:00 | Giro mattutino | TDSPHC-AGL----- | 64.4542 | {aeef0bc8-af99-4d5b-bfca-eddf457ac768} | |
| 471229 | 471229 | 2020-03-15 10:41:06+00:00 | Bike | TDSPHC--------- | {fca460eb-cf7f-463a-86be-3d041cc9378a} | ||
| 494436 | 494436 | 2019-10-04 12:10:45+00:00 | Bike | TDSPHC-AGL-EV-- | {5fb378ab-7d06-4ad5-8a6b-488321c5513a} | ||
| 535085 | 535085 | 2017-08-26 05:07:46+00:00 | Bike | TDSPHC-AGL-E--- | 77.19429 | {3d3aa55f-5945-4a9d-b3ea-79edeee7bfd6} | |
| 543335 | 543335 | 2018-12-30 07:12:58+00:00 | Bike | TDSPHC-AGL----- | 122.75684 | {f1c8df71-00e3-47da-a583-e680dd9ca402} | |
| 547992 | 547992 | 2019-02-26 13:23:29+00:00 | Bike | TDSPHC-AGL----- | {e4dbd3b3-74ef-4f2a-9743-8f28ea89f3d8} | ||
| 548713 | 548713 | 2018-04-10 16:03:39+00:00 | Bike | TDSPHC-AGL-E--- | 59.06104 | {535ab0a6-2ca7-47b9-9deb-6a84179400ba} | |
| 561909 | 561909 | 2020-01-10 06:59:43+00:00 | Bike | TDSPHC-AGL----- | {89c5317c-7b81-42cd-a087-0e5f66c53cd9} | ||
| 568708 | 568708 | 2019-03-19 16:20:28+00:00 | Bike | TDSPHC-AGL-EV-- | 39.08423 | {08dbe858-f429-4f7b-a7cc-940d049a111f} | |
| 571781 | 571781 | 2019-01-09 12:58:21+00:00 | Bike | T--PHC-A---EV-- | {a8ce047e-16c7-48a4-89b8-1087f50c001c} | ||
| 596844 | 596844 | 2016-02-07 06:39:54+00:00 | Bike | TDSPHC-A-L-E--- | {eaf6aa05-6ebd-40dd-ba5a-abb1912b40f9} | ||
| 597589 | 597589 | 2020-03-31 08:41:07+00:00 | Bike | T--PHC-A---E--- | {297e62e6-edd6-414e-8a8b-b1e27bf05ae6} | ||
| 603680 | 603680 | 2015-03-10 16:18:23+00:00 | Bike | TDSPHC-AGL-E--- | {6126f117-b584-4569-bacb-d1ce2adb6fb1} | ||
| 639519 | 639519 | 2020-01-15 14:10:02+00:00 | Bike | TDSPHC-A-L-EV-- | 31.9063 | {f3add639-57f6-47bb-ad28-cb47e8f1fd3f} | |
| 653288 | 653288 | 2016-12-16 04:12:57+00:00 | Bike | TDSPHC--------- | 30.174 | {450f3103-b8c2-4353-bdca-472ffd1c4dd7} | |
| 658910 | 658910 | 2020-01-04 18:36:00+00:00 | Run | TDSPHC-AGL----R | 4.51698 | {9ea85e0d-883e-4afd-8746-cb9b9fb2bd79} | |
| 718073 | 718073 | 2017-10-04 18:46:45+00:00 | Bike | TDSPHC-AGL----- | 37.8928 | {6c220619-fdce-4bd0-80a1-0f12bbb48f4f} | |
| 729614 | 729614 | 2018-04-20 12:30:49+00:00 | Bike | TDSPHC-AGL-EV-- | {134be1ef-d2e2-4c2f-a409-0599e9782220} | ||
| 741438 | 741438 | 2018-01-26 00:20:06+00:00 | Bike | TDSPHC-AGL----- | {478613d2-b8aa-45eb-8409-74e4d03bdf7c} | ||
| 752903 | 752903 | 2019-12-12 12:22:44+00:00 | Bike | TDSPHC-AGL-E--- | {c8fba4fb-0866-4d1e-823d-c193ef0baa4e} | ||
| 813557 | 813557 | 2019-02-26 07:47:56+00:00 | Bike | TDSPH--AGL----- | 21.8522 | {caf85c87-3d45-42fd-9fb9-8d737c47d956} | |
| 813564 | 813564 | 2019-03-09 06:43:31+00:00 | Bike | TDSPH--AGL-E--- | 100.193 | {caf85c87-3d45-42fd-9fb9-8d737c47d956} | |
| 828515 | 828515 | 2019-11-12 19:03:59+00:00 | Bike | TDSPHC------V-- | {3f20aeef-0e81-4bf7-90a2-a6c837e4c8d5} | ||
| 852580 | 852580 | 2012-10-01 21:39:04+00:00 | TDSPHC-AGL-E--- | 11.41359 | {b04578c5-d91f-4760-b2f2-d17cab0da031} | ||
| 861707 | 861707 | 2019-10-17 15:09:33+00:00 | TDSPHC-----E--- | 7.58637 | {6ff0ede9-d2f3-4501-98c6-2f2adcddb6d2} | ||
| 862543 | 862543 | 2018-03-29 17:11:22+00:00 | Bike | TDSPHC--------- | 26.181 | {4e55dff4-fc78-49f3-95bb-6df78b426fb9} | |
| 926762 | 926762 | 2018-03-29 17:11:22+00:00 | Bike | TDSPHC--------- | 26.181 | {9d92d726-9932-4a62-80b4-a8afdf1629f0} | |
| 937656 | 937656 | 2017-11-13 20:48:06+00:00 | Fitness | TDSPH--AGL----- | {a1600062-7c75-41a3-a8fb-9870b08a6f69} | ||
| 952736 | 952736 | 2017-11-13 20:48:06+00:00 | Fitness | TDSPH--AGL----- | {f2a4e060-dbc0-46d7-ad76-d02c6f8cdc57} | ||
| 961649 | 961649 | 2015-12-10 20:54:42+00:00 | T--PHC--------- | {ede8cf4e-ef65-4010-90e0-837e85f4adca} | |||
| 961781 | 961781 | 2018-07-20 21:13:59+00:00 | Bike | TDSPHC-AGL-EV-- | 23.1206 | {ede8cf4e-ef65-4010-90e0-837e85f4adca} | |
| 962237 | 962237 | 2018-09-25 23:28:54+00:00 | Bike | TDSPHC-AGL----- | {baec679e-a1d2-4431-8860-e89b391d3af1} | ||
| 971779 | 971779 | 2015-01-14 03:13:23+00:00 | TDSPHC--------- | 16.3576 | {982d7456-4738-40b4-9349-602ba78aec95} | ||
| 989511 | 989511 | 2015-10-23 21:13:40+00:00 | TDSPHC-AGL-EV-- | 137.296 | {a9f9b4d2-6cf8-4e85-8e6f-9d177ae7eaa2} | ||
| 1013205 | 1013205 | 2018-12-27 16:44:53+00:00 | Bike | TDSPHC-AGL-EV-- | 42.2 | {30c88c13-ab66-4c06-9d98-125bd025e99a} | |
| 1021451 | 1021451 | 2020-03-06 09:08:38+00:00 | Bike | TDSPHC-A-L-E--- | {bc7c6d1a-2945-4fcc-ba3a-f5d4847812ef} | ||
| 1058749 | 1058749 | 2019-02-03 11:11:01+00:00 | Bike | TDSPHC-AGL-EV-- | 18.86766 | {243dbca1-e137-47b8-8744-1f5db82e4029} | |
| 1073186 | 1073186 | 2016-04-28 17:10:17+00:00 | Bike | TDSPHC-AGL-EV-- | 35.74488 | {7fcdae85-1565-4734-b130-5bac205427e2} | |
| 1132905 | 1132905 | 2017-03-18 09:06:01+00:00 | Bike | TDSPHC-AGL-E--- | 44.4202 | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} | |
| 1132912 | 1132912 | 2017-03-26 06:59:37+00:00 | Bike | TDSPHC-AGL-EV-- | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} | ||
| 1132917 | 1132917 | 2017-04-01 07:36:46+00:00 | TDSPHC-AGL-EV-- | 100.02568 | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} | ||
| 1133188 | 1133188 | 2018-05-02 18:01:03+00:00 | Bike | TDSPHC-AGL-EV-- | 37.02759 | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} | |
| 1134038 | 1134038 | 2020-02-16 10:54:24+00:00 | Bike | T--PHC-----E--- | {688328c2-d677-4b8e-96f3-0eb731c9dc7f} | ||
| 1204109 | 1204109 | 2019-07-06 07:50:49+00:00 | Bike | TDSPHC-AGL-EV-- | {a99a99bd-4e17-4b49-9b7d-810a1cf18400} | ||
| 1215578 | 1215578 | 2013-02-17 12:11:33+00:00 | Bike | TDSPHC-A-L----- | 51.2826 | {3b4457fb-7c69-48c9-8cc9-5762fc08563d} | |
| 1228773 | 1228773 | 2019-10-11 13:44:25+00:00 | TDSPHC-AGL-E--- | 12.7129 | {37b0c7f8-c89d-45bf-a4a4-2c06ac475989} | ||
| 1242673 | 1242673 | 2019-07-02 04:13:24+00:00 | Bike | TDSPHC-AGL----- | 108.986 | {4bf0161a-a501-4993-9114-600a358c4807} | |
| 1250409 | 1250409 | 2018-09-29 12:04:45+00:00 | Bike | TDSPHC-AGL-EV-- | {a71d85d3-b46c-431e-b154-e06e98fcb472} | ||
| 1278348 | 1278348 | 2015-07-05 06:52:58+00:00 | Bike | TDSPHC-AGL----- | 101.12 | {6e9c7d45-3eca-4be7-a114-404459d8e956} | |
| 1278359 | 1278359 | 2016-05-18 16:05:30+00:00 | Bike | TDSPHC-AGL-EV-- | 57.0271 | {6e9c7d45-3eca-4be7-a114-404459d8e956} | |
| 1278376 | 1278376 | 2016-06-30 08:07:59+00:00 | Bike | TDSPHC-AGL-EV-- | {6e9c7d45-3eca-4be7-a114-404459d8e956} | ||
| 1292104 | 1292104 | 2019-12-14 12:31:09+00:00 | Bike | TDSPHC-AGL-E--- | {ccddd230-a79a-44ac-9008-427775df1134} | ||
| 1292112 | 1292112 | 2019-12-29 07:35:48+00:00 | Bike | TDSPHC-AGL-E--- | {ccddd230-a79a-44ac-9008-427775df1134} | ||
| 1292143 | 1292143 | 2019-02-22 15:19:24+00:00 | TDSPHC--------- | {1304c01f-2769-4186-a28b-853b63ceb47e} | |||
| 1389640 | 1389640 | 2020-04-24 16:35:45+00:00 | Bike | TDSPHC-AGL----- | {3ca027e6-7326-4f14-a2d2-c704368b8eef} | ||
| 1399864 | 1399864 | 2018-01-13 11:15:03+00:00 | Bike | TDSPHC-AGL-E--- | 20.45703 | {eff804aa-0a8b-4ba4-b6f3-7adf896e6cfc} | |
| 1457047 | 1457047 | 2019-09-14 09:36:46+00:00 | Run | TDSPHC-AGL-EV-R | 10.0114 | {0818ce38-0fff-40d8-a6c3-4bd6994bd893} | |
| 1463203 | 1463203 | 2016-07-09 04:34:06+00:00 | Bike | TDSPHC-AGL-EV-- | 118.62717 | {771b83e6-3278-4d79-bdaa-7c66ba5d30d8} |
Advanced export
JSON shape: default, array, newline-delimited
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");