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 rowid descending
This data as json, CSV (advanced)
| Link | rowid ▲ | date | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 2588768 | 2588768 | 2016-04-10 07:23:23+00:00 | Bike | TDSPHC-AGLWEV-- | 11953.0 | 66.5487 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588766 | 2588766 | 2016-04-03 07:57:10+00:00 | Bike | TDSPHC-AGLWEV-- | 10914.0 | 58.013 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588765 | 2588765 | 2016-03-27 09:17:57+00:00 | MTB | TDSPHC-AGLWEV-- | 17271.0 | 89.39095 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588750 | 2588750 | 2016-01-31 13:33:50+00:00 | MTB | TDSPHC-AGL-E--- | 10002.0 | 32.93837 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588738 | 2588738 | 2015-12-13 09:07:41+00:00 | MTB | TDSPH--AGL-E--- | 11727.0 | 56.2961 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588735 | 2588735 | 2015-12-06 10:00:13+00:00 | MTB | TDSPHC-AGL-E--- | 10841.0 | 56.5905 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588732 | 2588732 | 2015-11-29 12:38:44+00:00 | MTB | TDSPHC-AGL-E--- | 12046.0 | 63.5426 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588729 | 2588729 | 2015-11-22 10:28:58+00:00 | MTB | TDSPHC-AGL-E--- | 13241.0 | 68.5996 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588726 | 2588726 | 2015-11-15 11:44:27+00:00 | MTB | TDSPHC-AGL-E--- | 13016.0 | 69.16815 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588717 | 2588717 | 2015-11-01 09:28:56+00:00 | MTB | TDSPHC-AGL-E--- | 5844.0 | 31.03054 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588704 | 2588704 | 2015-10-03 14:00:53+00:00 | MTB | TDSPH--AGL-E--- | 4576.0 | 21.1062 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588700 | 2588700 | 2015-09-27 06:37:29+00:00 | Bike | TDSPHC-AGL-EV-- | 16406.0 | 114.75851 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588696 | 2588696 | 2015-09-20 06:10:16+00:00 | Bike | TDSPHC-AGL-EV-- | 13119.0 | 76.13932 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588695 | 2588695 | 2015-09-19 12:06:29+00:00 | Bike | TDSPHC-AGL-EV-- | 6422.0 | 41.3546 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588691 | 2588691 | 2015-09-12 08:26:28+00:00 | Bike | TDSPHC-AGL-EV-- | 26865.0 | 64.40071 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588690 | 2588690 | 2015-09-06 07:58:34+00:00 | Bike | TDSPHC-AGL-EV-- | 16263.0 | 85.60672 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588689 | 2588689 | 2015-09-05 13:50:24+00:00 | Bike | TDSPHC-AGL-EV-- | 8113.0 | 44.8249 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588688 | 2588688 | 2015-09-04 14:34:39+00:00 | Bike | TDSPHC-AGL-EV-- | 7481.0 | 54.4219 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588687 | 2588687 | 2015-09-02 17:11:58+00:00 | Bike | TDSPHC-AGL-EV-- | 755.0 | 4.30981 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588686 | 2588686 | 2015-09-02 15:50:18+00:00 | Bike | TDSPHC-AGL-EV-- | 3602.0 | 24.72681 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588685 | 2588685 | 2015-09-01 14:48:35+00:00 | Bike | TDSPHC-AGL-EV-- | 6552.0 | 42.81928 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588684 | 2588684 | 2015-08-31 08:58:42+00:00 | Bike | TDSPHC-AGL-EV-- | 4634.0 | 31.5461 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588683 | 2588683 | 2015-08-16 06:09:03+00:00 | Bike | TDSPHC-AGL-EV-- | 15981.0 | 116.55531 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588682 | 2588682 | 2015-08-12 05:32:25+00:00 | Bike | TDSPHC-AGL-EV-- | 18972.0 | 89.0366 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588681 | 2588681 | 2015-08-09 06:06:48+00:00 | Bike | TDSPHC-AGL-EV-- | 10533.0 | 75.39495 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588678 | 2588678 | 2015-08-02 06:03:16+00:00 | Bike | TDSPHC-AGL-EV-- | 13009.0 | 83.3584 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588677 | 2588677 | 2015-08-01 09:36:18+00:00 | Bike | TDSPHC-AGL-EV-- | 6365.0 | 41.0925 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588676 | 2588676 | 2015-07-31 12:01:40+00:00 | Bike | TDSPHC-AGL-EV-- | 9141.0 | 60.26322 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588673 | 2588673 | 2015-07-26 06:09:18+00:00 | Bike | TDSPHC-AGL-EV-- | 11937.0 | 66.44437 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588672 | 2588672 | 2015-07-25 09:20:54+00:00 | Bike | TDSPHC-AGL-EV-- | 4654.0 | 22.83018 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588671 | 2588671 | 2015-07-25 08:52:32+00:00 | Bike | TDSPHC-AGL-EV-- | 6348.0 | 38.7261 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588670 | 2588670 | 2015-07-24 07:08:32+00:00 | Bike | TDSPHC-AGL-EV-- | 5716.0 | 35.5143 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588667 | 2588667 | 2015-07-18 06:04:10+00:00 | Bike | TDSPHC-AGL-EV-- | 14814.0 | 85.20991 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588666 | 2588666 | 2015-07-16 07:38:22+00:00 | Bike | TDSPHC-AGL-EV-- | 8903.0 | 49.6421 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588664 | 2588664 | 2015-07-14 14:01:12+00:00 | Bike | TDSPHC-AGL-EV-- | 11510.0 | 61.60571 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588662 | 2588662 | 2015-07-11 06:04:59+00:00 | Bike | TDSPHC-AGL-E--- | 12255.0 | 80.672 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588661 | 2588661 | 2015-07-10 08:54:38+00:00 | Bike | TDSPHC-AGL-EV-- | 5828.0 | 35.5381 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588658 | 2588658 | 2015-07-05 11:26:30+00:00 | Bike | TDSPHC-AGL-EV-- | 3461.0 | 32.37512 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588657 | 2588657 | 2015-07-05 08:00:57+00:00 | Bike | TDSPHC-AGL-EV-- | 8878.0 | 49.8021 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588656 | 2588656 | 2015-07-04 06:05:03+00:00 | Bike | TDSPHC-AGL-EV-- | 12070.0 | 84.86984 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588655 | 2588655 | 2015-07-02 16:10:01+00:00 | Bike | TDSPHC-AGL-EV-- | 4811.0 | 28.47638 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588651 | 2588651 | 2015-06-28 06:51:03+00:00 | Bike | TDSPHC-AGL-EV-- | 1152.0 | 6.53828 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588650 | 2588650 | 2015-06-28 06:50:58+00:00 | Bike | TDSPHC-AGL-EV-- | 3502.0 | 10.11316 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588649 | 2588649 | 2015-06-28 05:27:17+00:00 | Bike | TDSPHC-AGL-EV-- | 2200.0 | 11.54014 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588646 | 2588646 | 2015-06-21 07:13:54+00:00 | Bike | TDSPHC-AGL-EV-- | 11105.0 | 73.43127 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588645 | 2588645 | 2015-06-19 10:54:15+00:00 | Bike | TDSPHC-AGL-EV-- | 13328.0 | 62.2312 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588640 | 2588640 | 2015-06-07 06:34:57+00:00 | Bike | TDSPHC-AGL-EV-- | 16419.0 | 76.8887 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588637 | 2588637 | 2015-05-31 06:40:26+00:00 | Bike | TDSPHC-AGL-E--- | 13012.0 | 65.7324 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588635 | 2588635 | 2015-05-17 06:34:20+00:00 | Bike | TDSPHC-AGL-E--- | 11999.0 | 66.02793 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588631 | 2588631 | 2015-04-12 06:40:34+00:00 | Bike | TDSPHC-AGL-E--- | 20019.0 | 95.4576 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588629 | 2588629 | 2015-02-01 09:47:22+00:00 | Bike | TDSPHC-AGL-E--- | 20452.0 | 82.919 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588628 | 2588628 | 2014-11-01 13:20:32+00:00 | Bike | TDSPH--AGL-E--- | 9002.0 | 15.6052 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588627 | 2588627 | 2014-10-26 12:55:21+00:00 | Bike | TDSPH--AGL-E--- | 11267.0 | 45.9725 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588626 | 2588626 | 2014-10-05 10:13:47+00:00 | Bike | TDSPH--AGL-E--- | 8844.0 | 39.2514 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588625 | 2588625 | 2014-09-07 09:21:13+00:00 | Bike | TDSPHC-AGL-E--- | 10711.0 | 55.82624 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588624 | 2588624 | 2014-08-31 10:28:19+00:00 | Bike | TDSPHC-AGL-E--- | 19991.0 | 119.61313 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588622 | 2588622 | 2014-08-21 16:48:23+00:00 | Bike | TDSPH--AGL-E--- | 3425.0 | 10.6745 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588621 | 2588621 | 2014-08-21 14:44:46+00:00 | Bike | TDSPH--AGL-E--- | 7411.0 | 52.70984 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588620 | 2588620 | 2014-08-17 08:20:25+00:00 | Bike | TDSPH--AGL-E--- | 18357.0 | 91.81942 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588619 | 2588619 | 2014-08-14 15:50:55+00:00 | Bike | TDSPHC-AGL-E--- | 8232.0 | 54.0103 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588618 | 2588618 | 2014-08-10 07:02:26+00:00 | Bike | TDSPHC-AGL-E--- | 32627.0 | 140.934 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588617 | 2588617 | 2014-08-05 15:53:39+00:00 | Bike | TDSPHC-AGL-E--- | 8108.0 | 52.7453 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588616 | 2588616 | 2014-08-02 16:06:38+00:00 | Bike | TDSPHC-AGL-E--- | 8223.0 | 53.1703 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588615 | 2588615 | 2014-07-20 06:30:56+00:00 | Bike | TDSPH--AGL-E--- | 11144.0 | 38.29179 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588614 | 2588614 | 2014-07-06 06:17:46+00:00 | Bike | TDSPHC-AGL-E--- | 41479.0 | 180.163 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588613 | 2588613 | 2014-06-14 12:32:40+00:00 | Bike | TDSPHC-AGL-E--- | 16201.0 | 97.95147 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588612 | 2588612 | 2014-06-08 06:22:17+00:00 | Bike | TDSPHC-AGL-E--- | 20807.0 | 94.0837 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588611 | 2588611 | 2014-06-01 08:38:44+00:00 | Bike | TDSPHC-AGL-E--- | 14540.0 | 72.8399 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588610 | 2588610 | 2014-05-24 14:46:49+00:00 | Bike | TDSPHC-AGL-E--- | 11078.0 | 60.68616 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588609 | 2588609 | 2014-05-18 12:30:37+00:00 | Bike | TDSPH--AGL-E--- | 9844.0 | 49.1285 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588608 | 2588608 | 2014-05-10 07:58:46+00:00 | Bike | TDSPHC-AGL-E--- | 13820.0 | 97.5936 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588607 | 2588607 | 2014-05-04 08:54:01+00:00 | Bike | TDSPHC-AGL-E--- | 10037.0 | 74.0978 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588606 | 2588606 | 2014-04-06 09:05:45+00:00 | Bike | TDSPHC-AGL-E--- | 13276.0 | 89.42036 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588605 | 2588605 | 2014-03-29 11:10:00+00:00 | Bike | TDSPHC-AGL-E--- | 15442.0 | 93.8955 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588604 | 2588604 | 2013-12-15 11:33:01+00:00 | Bike | TDSPHC-AGL-E--- | 5814.0 | 36.63313 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588603 | 2588603 | 2013-11-17 11:16:27+00:00 | Bike | TDSPHC-AGL-E--- | 9775.0 | 77.33961 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588602 | 2588602 | 2013-09-27 14:30:51+00:00 | Bike | TDSPH--AGL-E--- | 8737.0 | 30.2161 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588601 | 2588601 | 2013-09-21 10:05:31+00:00 | Bike | TDSPHC-AGL-E--- | 10640.0 | 57.8106 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588600 | 2588600 | 2013-09-01 13:47:16+00:00 | Bike | TDSPHC-AGL-E--- | 4485.0 | 10.97279 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588599 | 2588599 | 2013-09-01 09:08:25+00:00 | Bike | TDSPHC-AGL-E--- | 16682.0 | 103.01335 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588598 | 2588598 | 2013-08-29 14:03:50+00:00 | Bike | TDSPH--AGL-E--- | 8439.0 | 24.6987 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588597 | 2588597 | 2013-08-27 16:05:21+00:00 | Bike | TDSPHC-AGL-E--- | 5740.0 | 33.29805 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588596 | 2588596 | 2013-08-25 14:36:48+00:00 | Bike | TDSPHC-AGL-E--- | 5906.0 | 33.3386 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588595 | 2588595 | 2013-08-23 14:58:08+00:00 | Bike | TDSPH--AGL-E--- | 10788.0 | 33.6942 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588594 | 2588594 | 2013-08-22 07:51:19+00:00 | Bike | TDSPHC-AGL-E--- | 11066.0 | 57.7878 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588593 | 2588593 | 2013-08-15 09:00:07+00:00 | Bike | TDSPHC-AGL-E--- | 22312.0 | 115.22027 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588592 | 2588592 | 2013-08-14 16:16:39+00:00 | Bike | TDSPHC-AGL-E--- | 6296.0 | 33.3316 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588591 | 2588591 | 2013-08-10 16:53:43+00:00 | Bike | TDSPHC-AGL-E--- | 6204.0 | 26.6859 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588590 | 2588590 | 2013-08-04 07:30:06+00:00 | Bike | TDSPH--AGL-E--- | 12160.0 | 28.95842 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588589 | 2588589 | 2013-07-23 16:06:01+00:00 | Bike | TDSPH--AGL-E--- | 9506.0 | 26.7078 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588588 | 2588588 | 2013-07-20 08:00:10+00:00 | Bike | TDSPH--AGL-E--- | 11411.0 | 32.2882 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588587 | 2588587 | 2013-07-06 08:42:06+00:00 | Bike | TDSPHC-AGL-E--- | 12921.0 | 68.031 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588586 | 2588586 | 2013-06-30 08:10:15+00:00 | Bike | TDSPH--AGL-E--- | 16325.0 | 36.4835 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588585 | 2588585 | 2013-06-29 14:33:06+00:00 | Bike | TDSPHC-AGL-E--- | 5629.0 | 24.80656 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} |
| 2588584 | 2588584 | 2020-05-05 15:09:22+00:00 | Bike | TDSPHC-AGL----- | 3613.0 | 31.8536 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
| 2588583 | 2588583 | 2020-05-04 13:22:23+00:00 | Bike | TDSPHC-AGL----- | 4273.0 | 33.7796 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
| 2588581 | 2588581 | 2020-05-01 14:03:43+00:00 | Bike | TDSPHC-AGL----- | 3206.0 | 26.2064 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
| 2588580 | 2588580 | 2020-04-30 17:55:25+00:00 | Bike | TDSPHC-AGL----- | 4792.0 | 31.5923 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
| 2588579 | 2588579 | 2020-04-29 14:04:47+00:00 | Bike | TDSPHC-AGL----- | 3870.0 | 32.9673 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
| 2588578 | 2588578 | 2020-04-28 13:14:00+00:00 | Bike | TDSPHC-AGL----- | 3677.0 | 27.1458 | {cc4d1f22-0998-41b2-b3be-dae1d8a8924d} |
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");