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 |
|---|---|---|---|---|---|---|---|
| 1469652 | 1469652 | 2020-03-30 17:58:22+00:00 | Bike | TDSPHC-A-L-EV-- | {35c4aebe-1785-459b-b2b4-85853aa26a3c} | ||
| 1482831 | 1482831 | 2018-07-18 15:02:41+00:00 | CF SLX | TDSPHC-AGL-EV-- | 49.5103 | {64b8cf79-17a3-4bda-b32b-bb9dd92f9228} | |
| 1501702 | 1501702 | 2015-04-18 15:47:18+00:00 | Bike | TDSPHC-----E--- | {94c48843-363f-4126-9b42-f2e3f40bbcaf} | ||
| 1501709 | 1501709 | 2015-07-23 17:39:41+00:00 | TDSPHC-AGL----- | {94c48843-363f-4126-9b42-f2e3f40bbcaf} | |||
| 1506747 | 1506747 | 2019-01-14 09:13:30+00:00 | Indoor | TDSPHC-----E--- | {a274d46f-f587-4e9b-bdc4-522b5b9dc882} | ||
| 1557515 | 1557515 | 2017-04-17 07:49:56+00:00 | Rolle | T--PHC-A---EV-- | 95.0 | {4a0c275c-039a-415a-89e7-6c34a3db0c49} | |
| 1568196 | 1568196 | 2020-04-02 08:50:55+00:00 | Bike | TDSPHC-AGL----- | 38.66304 | {5ad057d3-1027-4241-8894-131beb3a5dd9} | |
| 1568319 | 1568319 | 2020-01-01 10:00:11+00:00 | Bike | TDSPHC-AGL-E--- | {85c30a8a-26ae-4ab2-b381-aab60b4097c7} | ||
| 1568370 | 1568370 | 2020-03-21 12:13:39+00:00 | Bike | TDSPHC-AGL-EV-- | {85c30a8a-26ae-4ab2-b381-aab60b4097c7} | ||
| 1576106 | 1576106 | 2020-04-08 14:39:22+00:00 | Bike | TDSPHC-AGL-E--- | {9e0a737f-6943-4095-9eed-71dd4b237498} | ||
| 1588769 | 1588769 | 2016-02-07 10:45:17+00:00 | Bike | TDSPHC-AGL----- | 97.8786 | {9bc859a3-5e62-4523-aaed-72fe18eecf7a} | |
| 1596683 | 1596683 | 2019-10-15 17:09:44+00:00 | Bike | T--PHC--------- | {520e34f9-03d0-4039-875e-e12e29bf75a6} | ||
| 1610235 | 1610235 | 2016-12-30 08:54:29+00:00 | Bike | TDSPHC-AGL-EV-- | {bf112bad-2d34-4ff4-be9c-b7b2129f5a39} | ||
| 1610242 | 1610242 | 2017-01-08 09:04:18+00:00 | Bike | TDSPHC-AGL-EV-- | 81.72588 | {bf112bad-2d34-4ff4-be9c-b7b2129f5a39} | |
| 1617052 | 1617052 | 2017-03-18 09:06:01+00:00 | Bike | TDSPHC-AGL-E--- | 44.4202 | {d686b098-3e13-47c9-bb1c-b79fc96454df} | |
| 1617059 | 1617059 | 2017-03-26 06:59:37+00:00 | Bike | TDSPHC-AGL-EV-- | {d686b098-3e13-47c9-bb1c-b79fc96454df} | ||
| 1617064 | 1617064 | 2017-04-01 07:36:46+00:00 | TDSPHC-AGL-EV-- | 100.02568 | {d686b098-3e13-47c9-bb1c-b79fc96454df} | ||
| 1617335 | 1617335 | 2018-05-02 18:01:03+00:00 | Bike | TDSPHC-AGL-EV-- | 37.02759 | {d686b098-3e13-47c9-bb1c-b79fc96454df} | |
| 1619358 | 1619358 | 2019-08-17 06:10:48+00:00 | Bike | TDSPHC-AGL-EV-- | {a6e1bacf-aaac-4bc6-a297-e66a3723d41e} | ||
| 1622499 | 1622499 | 2013-12-01 13:55:36+00:00 | Bike | TDSPHC--------- | 22.20274 | {a6c88f22-ecd0-488f-9afc-3ff07fb27f58} | |
| 1628817 | 1628817 | 2020-04-21 09:29:13+00:00 | Bike | TDSPHC-----E--- | {32e77804-a10b-4cd8-bf4d-6bf566f32f1f} | ||
| 1628822 | 1628822 | 2020-04-25 09:57:49+00:00 | Bike | TDSPHC-----E--- | 54.3622 | {32e77804-a10b-4cd8-bf4d-6bf566f32f1f} | |
| 1655463 | 1655463 | 2018-04-30 07:51:57+00:00 | Bike | TDSPHC-AGL-E--- | {8c2c1819-8222-4f8e-b24d-09c170dbae38} | ||
| 1669774 | 1669774 | 2016-12-24 08:06:49+00:00 | ALTOTERO | TDSPHC-AGL-E--- | 98.73428 | {2b5f4094-3fab-4ba0-9764-56b3b1a3d4de} | |
| 1674211 | 1674211 | 2017-05-03 14:22:33+00:00 | TDSPHC--------- | 12.8748 | {27d4b1dc-7d47-4cd7-9907-652cef60164e} | ||
| 1676217 | 1676217 | 2018-03-20 17:30:20+00:00 | Bike | TDSPHC-A-L-EV-- | {beae6ce3-404e-42aa-87d2-a729adbc39ae} | ||
| 1676226 | 1676226 | 2018-04-13 07:51:00+00:00 | Bike | TDSPHC-A-L-EV-- | {beae6ce3-404e-42aa-87d2-a729adbc39ae} | ||
| 1676231 | 1676231 | 2018-04-26 06:39:37+00:00 | carretera | TDSPHC-A-L-EV-- | {beae6ce3-404e-42aa-87d2-a729adbc39ae} | ||
| 1676257 | 1676257 | 2020-02-28 08:41:38+00:00 | Bike | TDSPHC-AGL----- | 60.2053 | {beae6ce3-404e-42aa-87d2-a729adbc39ae} | |
| 1711280 | 1711280 | 2020-04-01 17:02:14+00:00 | Bike | TDSPHC-AGL-EV-- | 35.0854 | {79812523-2c69-4141-8d33-8b3a03cc94cd} | |
| 1721485 | 1721485 | 2013-01-18 15:17:04+00:00 | TDSPHC-A-L-E--- | 32.0319 | {42f24109-a3c2-4174-a6b8-1cb4185ad71a} | ||
| 1734057 | 1734057 | 2016-12-24 08:06:49+00:00 | ALTOTERO | TDSPHC-AGL-E--- | 98.73428 | {d783fd97-c906-4af3-acf0-7cbec92c1e35} | |
| 1763242 | 1763242 | 2020-03-25 14:48:56+00:00 | Bike | TDSPHC-AGL-E--- | 43.73713 | {ca2ece57-7f84-42b5-9d3b-93c5b38ef007} | |
| 1787630 | 1787630 | 2020-04-19 15:23:37+00:00 | 0 | TDSPHC-AGL-EV-- | 27.4568 | {fc56b27b-0f6a-48be-91c3-0873527cb41f} | |
| 1798247 | 1798247 | 2019-06-15 14:49:53+00:00 | Bike | TDSPHC-AGL-E--- | {0b77a6ff-ecc3-474d-8cfd-e835b11012e4} | ||
| 1836675 | 1836675 | 2016-04-28 17:10:17+00:00 | Bike | TDSPHC-AGL-EV-- | 35.74488 | {e7079a4a-e6d5-4dfe-a0c9-48c7789cfd96} | |
| 1847215 | 1847215 | 2019-10-05 08:02:11+00:00 | 1 | TDSPHC-AGL-EV-- | {4b9f1954-4ded-4108-ad82-f1d4942eb3c2} | ||
| 1913929 | 1913929 | 2018-05-22 06:27:09+00:00 | Bike | TDSPHC-AGL-EV-- | 80.5613 | {0bf011cc-ad11-46f0-b893-1b703b31cf65} | |
| 1914035 | 1914035 | 2018-12-23 07:47:17+00:00 | Bike | TDSPHC-AGL-EV-- | {0bf011cc-ad11-46f0-b893-1b703b31cf65} | ||
| 1944403 | 1944403 | 2016-11-22 18:01:13+00:00 | Bike | TD-PH--AGL-EVO- | {eb359c8b-c491-4dda-be77-91ec9211255d} | ||
| 1975763 | 1975763 | 2016-09-29 14:11:37+00:00 | Bike | TDSPHC-AGL-E--- | {4babedca-5349-43e7-823b-242e28171540} | ||
| 1975785 | 1975785 | 2016-10-23 09:09:08+00:00 | Bike | TDSPHC-AGL-E--- | 73.30964 | {4babedca-5349-43e7-823b-242e28171540} | |
| 2001906 | 2001906 | 2015-09-01 08:04:31+00:00 | T--PHC-A---E--- | {ab6df498-7fbb-4399-b710-9b056e5e5f37} | |||
| 2025647 | 2025647 | 2019-04-11 14:19:10+00:00 | Bike | TDSPHC-AGL-EV-- | {497879a5-30dc-4c47-b587-e4d306c11765} | ||
| 2040252 | 2040252 | 2017-08-08 06:57:34+00:00 | Run | TDSPH--AGL----- | 7.81 | {79205bf4-c03f-409f-be15-70d64f050ad7} | |
| 2040254 | 2040254 | 2017-08-12 10:14:12+00:00 | Bike | TDSPHC--------- | {79205bf4-c03f-409f-be15-70d64f050ad7} | ||
| 2040255 | 2040255 | 2017-08-15 20:12:24+00:00 | Bike | TDSPHC--------- | {79205bf4-c03f-409f-be15-70d64f050ad7} | ||
| 2042578 | 2042578 | 2020-04-14 15:27:01+00:00 | Bike | TDSPHC-AGL-E--- | 11.915 | {581ea037-1ab4-4540-9955-225360dcef95} | |
| 2046788 | 2046788 | 2018-02-28 18:28:58+00:00 | TDSPHC------V-- | 18.0212 | {ff50075b-952d-49b4-8fd9-08cf0057cc0a} | ||
| 2046829 | 2046829 | 2018-04-24 05:34:04+00:00 | Run | TDSPHC-AGL----- | {ff50075b-952d-49b4-8fd9-08cf0057cc0a} | ||
| 2057960 | 2057960 | 2019-03-28 14:34:56+00:00 | Bike | TDSPHC-AGL----- | {0812d5ee-0b2a-44a8-b3e1-b16854fcf1af} | ||
| 2059422 | 2059422 | 2016-08-08 23:51:00+00:00 | Bike | T--PHC-A---E--- | {35e05a90-dbd3-4568-88cc-fedc41d08689} | ||
| 2090895 | 2090895 | 2018-07-12 22:07:17+00:00 | Bike | TDSPHC-AGL-EV-- | 40.2186 | {567cd049-8b1f-41f1-92c6-cd53e30edf60} | |
| 2094928 | 2094928 | 2020-03-10 11:50:16+00:00 | Bike | TDSPHC-AGL----- | {b752a782-0801-4be0-bb2c-e1652ff211e9} | ||
| 2094952 | 2094952 | 2020-04-03 08:32:59+00:00 | Bike | TDSPHC-AGL-E--- | 114.66 | {b752a782-0801-4be0-bb2c-e1652ff211e9} | |
| 2126048 | 2126048 | 2019-08-31 08:28:01+00:00 | Bike | TDSPHC-AGL-E--- | {885395be-5931-4870-8d01-e6e971e6b827} | ||
| 2201483 | 2201483 | 2013-01-18 15:17:04+00:00 | TDSPHC-A-L-E--- | 32.0319 | {b02ffb08-ec17-4e02-878e-71f03d87e763} | ||
| 2216712 | 2216712 | 2016-01-03 16:13:37+00:00 | Bike | TDSPHC-AGL----- | 49.97884 | {977e5961-287b-4637-8818-eb1b983199f7} | |
| 2260192 | 2260192 | 2018-11-01 08:45:58+00:00 | Bike | TDSPHC-AGL-EV-- | {d5c798a6-ec05-4fd7-bc15-22003fe509e9} | ||
| 2260193 | 2260193 | 2018-11-03 09:29:37+00:00 | Bike | TDSPHC-AGL-E--- | {d5c798a6-ec05-4fd7-bc15-22003fe509e9} | ||
| 2315353 | 2315353 | 2019-01-14 09:13:30+00:00 | Indoor | TDSPHC-----E--- | {14233c7c-1e8b-4ecb-8a19-721b2dfd8834} | ||
| 2341296 | 2341296 | 2020-02-21 15:38:39+00:00 | Bike | TDSPHC-A-L----- | {6cb48fd4-dc23-440b-907a-04f5942f6d67} | ||
| 2343093 | 2343093 | 2019-12-29 08:00:45+00:00 | TDSPHC-AGL-E--- | 65.0854 | {7d3b0731-a89b-4773-a755-3d53dfbc26cc} | ||
| 2351679 | 2351679 | 2018-08-18 21:15:21+00:00 | Bike | TDSPHC-AGL----- | 100.471 | {1909f149-25ff-490d-a7cc-dc5a3b3f95ff} | |
| 2352012 | 2352012 | 2020-04-16 18:58:53+00:00 | Bike | TDSPHC-A-L----- | {bf5e39b5-ac52-4d87-b23b-95f00051c86b} | ||
| 2373481 | 2373481 | 2019-10-22 10:09:52+00:00 | Bike | TDSPHC-AGL----- | {2bfae22f-6984-4a05-891f-40381fdf91cc} | ||
| 2377384 | 2377384 | 2017-05-04 12:20:54+00:00 | Biketrek5,9 | TDSPHC-A-L-E--- | 39.26691 | {6ca67b8a-d3ed-4a1a-86a0-511ed3e80398} | |
| 2394356 | 2394356 | 2017-01-21 10:44:19+00:00 | Bike | TDSPHC-AGL----- | 54.8487 | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} | |
| 2394551 | 2394551 | 2017-12-14 13:34:22+00:00 | Bike | TDSPHC-AGL----- | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} | ||
| 2394554 | 2394554 | 2017-12-20 10:09:03+00:00 | Bike | TDSPHC-AGL----- | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} | ||
| 2394658 | 2394658 | 2018-05-06 05:07:52+00:00 | Bike | TDSPHC-AGL----- | 115.99344 | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} | |
| 2394711 | 2394711 | 2018-08-02 07:33:49+00:00 | Bike | TDSPHC-AGL----- | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} | ||
| 2398807 | 2398807 | 2019-12-05 07:28:59+00:00 | Álora ( puente ) | TDSPHC-AGL----- | {c4be8a62-1043-4d11-9974-da8e6c54d3c2} | ||
| 2409397 | 2409397 | 2019-11-30 10:43:05+00:00 | Bike | TDSPHC-AGL----- | {68a76fad-5e20-459f-8cad-3d76ae8e3d91} | ||
| 2409405 | 2409405 | 2019-12-05 15:44:24+00:00 | Bike | TDSPHC-AGL----- | {68a76fad-5e20-459f-8cad-3d76ae8e3d91} | ||
| 2431396 | 2431396 | 2016-09-29 14:11:37+00:00 | Bike | TDSPHC-AGL-E--- | {aedec212-6033-4eb1-aded-77bb25188692} | ||
| 2431418 | 2431418 | 2016-10-23 09:09:08+00:00 | Bike | TDSPHC-AGL-E--- | 73.30964 | {aedec212-6033-4eb1-aded-77bb25188692} | |
| 2465976 | 2465976 | 2019-05-10 07:22:57+00:00 | Ciclismo por la mañana | TDSPHC-AGL-E--- | 162.19079 | {36413bd0-f129-4a03-9dad-25e804f20b50} | |
| 2472605 | 2472605 | 2014-07-26 06:23:39+00:00 | Bike | TDSPHC-A-L-E--- | {7c1ef0bb-7758-4223-8208-bb07c4e3c167} | ||
| 2472675 | 2472675 | 2018-11-15 14:48:36+00:00 | Bike Rolle | TDSPHC-A-L-E--- | {7c1ef0bb-7758-4223-8208-bb07c4e3c167} | ||
| 2472676 | 2472676 | 2018-11-18 15:56:05+00:00 | indoorcycling | TDSPHC-A-L-E--- | {7c1ef0bb-7758-4223-8208-bb07c4e3c167} | ||
| 2477819 | 2477819 | 2015-07-26 20:15:00+00:00 | ERGO | T--PHCN----E--- | 25.0 | {c2b16c2e-f96a-4530-9c32-ba8a5a2b9580} | |
| 2525878 | 2525878 | 2020-03-17 18:50:57+00:00 | Bike | TDSPHC-A-L-E--- | 30.2136 | {5bb223f3-f2dc-4171-98f4-0a5b402313ca} | |
| 2566353 | 2566353 | 2017-03-11 09:33:40+00:00 | Bike | TDSPHC-AGL-E--- | {279b0fb3-b0b2-494e-82c0-7ed003f05f3f} | ||
| 2567339 | 2567339 | 2018-10-08 09:00:00+00:00 | -DSPHC-AGLWE--- | 28.7473 | {062c0153-5e5b-4c62-ba7a-a1f5cdbdf876} | ||
| 2572544 | 2572544 | 2018-11-22 18:20:41+00:00 | Bike | TDSPHC-A-L-E--- | {2e8ec895-a09a-4866-9932-23bc9d92d38d} | ||
| 2582650 | 2582650 | 2020-03-25 13:56:53+00:00 | Bike | TDSPHC-AGL-EV-- | 53.09647 | {928209b1-b5b2-4c5b-ad9f-59010b19fefe} | |
| 2588835 | 2588835 | 2016-10-02 14:12:40+00:00 | Bike | TDSPHCNAGL-EV-- | 39.96123 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} | |
| 58320 | 58320 | 2018-03-18 09:59:56+00:00 | Bike | --SPHC-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 58433 | 58433 | 2018-11-22 10:18:26+00:00 | Bike | --SPHC-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 187375 | 187375 | 2020-03-15 15:29:23+00:00 | Bike | -DSPHC-A-L----- | 1.0 | 21.15821 | {468751ef-dce1-4504-845b-623097ec4d2f} |
| 202759 | 202759 | 2020-04-18 06:16:41+00:00 | Bike | --SPHC-AG------ | 1.0 | {6657492a-a0ea-4483-a862-cfb828979d8c} | |
| 223684 | 223684 | 2017-10-06 17:19:43+00:00 | Bike | --SPHC-AG------ | 1.0 | {60ec9b36-d194-47c3-b022-2634eccb582e} | |
| 223718 | 223718 | 2017-11-22 19:02:22+00:00 | Bike | --SPHC-AG------ | 1.0 | {60ec9b36-d194-47c3-b022-2634eccb582e} | |
| 404655 | 404655 | 2018-09-10 06:40:24+00:00 | Bike | TDSPHC-AGL--V-- | 1.0 | 25.11372 | {603f6742-9986-4282-8c0c-aed02ada2e5a} |
| 437508 | 437508 | 2018-09-22 08:49:48+00:00 | Bike | TDSPHC-AGL-EV-- | 1.0 | 0.0073 | {cbef31ef-2568-45ed-b7d3-cd128d52fe24} |
| 454483 | 454483 | 2016-11-20 12:15:12+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.05111 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454484 | 454484 | 2016-12-14 19:40:03+00:00 | Bike | TD-PHC-AGL-E--- | 1.0 | 0.00084 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454485 | 454485 | 2016-12-15 17:46:11+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.04049 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454486 | 454486 | 2016-12-23 14:54:17+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.10503 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
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");