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
This data as json, CSV (advanced)
| Link | rowid ▼ | date | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 642 | 642 | 2015-05-01 08:54:54+00:00 | Bike | TDSPHC-AGL-E--- | 9313.0 | 62.99486 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 643 | 643 | 2015-05-03 09:14:41+00:00 | Bike | TDSPHC-AGL-E--- | 7733.0 | 67.01924 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 644 | 644 | 2015-05-05 14:34:01+00:00 | Bike | TDSPHC-AGL-E--- | 4932.0 | 37.02252 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 645 | 645 | 2015-05-07 12:05:35+00:00 | Bike | TDSPHC-AGL-E--- | 3855.0 | 40.18397 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 646 | 646 | 2015-05-08 12:01:50+00:00 | Bike | TDSPHC-AGL-E--- | 7076.0 | 70.20142 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 647 | 647 | 2015-05-09 09:01:59+00:00 | Bike | TDSPHC-AGL-E--- | 10689.0 | 101.1039 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 648 | 648 | 2015-05-10 15:24:58+00:00 | Bike | TDSPHC-AGL-E--- | 3608.0 | 34.14195 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 649 | 649 | 2015-05-12 15:00:36+00:00 | Bike | TDSPHC-AGL-E--- | 6307.0 | 47.74753 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 650 | 650 | 2015-05-13 15:25:55+00:00 | Bike | TDSPHC-AGL-E--- | 5738.0 | 39.10755 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 651 | 651 | 2015-05-15 14:05:13+00:00 | Bike | TDSPHC-AGL-E--- | 7888.0 | 56.3199 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 652 | 652 | 2015-05-16 10:08:47+00:00 | Bike | TDSPHC-AGL-E--- | 9344.0 | 72.05559 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 653 | 653 | 2015-05-17 15:29:41+00:00 | Bike | TDSPHC-AGL-E--- | 3743.0 | 40.07341 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 654 | 654 | 2015-05-19 14:58:47+00:00 | Bike | TDSPHC-AGL-E--- | 5050.0 | 51.99901 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 655 | 655 | 2015-05-20 15:08:37+00:00 | Bike | TDSPHC-AGL-E--- | 4967.0 | 34.02139 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 656 | 656 | 2015-05-21 15:07:23+00:00 | Bike | TDSPHC-AGL-E--- | 5323.0 | 38.78175 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 657 | 657 | 2015-05-23 10:53:19+00:00 | Bike | TDSPHC-AGL-E--- | 10414.0 | 73.15695 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 658 | 658 | 2015-05-24 05:54:26+00:00 | Bike | TDSPHC-AGL-E--- | 8301.0 | 62.99181 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 659 | 659 | 2015-05-26 16:31:32+00:00 | Bike | TDSPHC-AGL-E--- | 3881.0 | 36.58236 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 660 | 660 | 2015-05-28 15:30:01+00:00 | Bike | TDSPHC-AGL-E--- | 7027.0 | 49.21583 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 661 | 661 | 2015-05-29 15:19:40+00:00 | Bike | TDSPHC-AGL-E--- | 6320.0 | 41.37015 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 662 | 662 | 2015-05-30 10:01:11+00:00 | Bike | TDSPHC-AGL-E--- | 9967.0 | 66.85316 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 663 | 663 | 2015-05-31 06:17:56+00:00 | Bike | TDSPHC-AGL-E--- | 7576.0 | 55.30547 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 664 | 664 | 2015-06-02 15:48:44+00:00 | Bike | TDSPHC-AGL-E--- | 5064.0 | 42.62956 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 665 | 665 | 2015-06-03 16:24:01+00:00 | Bike | TDSPHC-AGL-E--- | 4128.0 | 37.80945 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 666 | 666 | 2015-06-04 16:09:21+00:00 | Bike | TDSPHC-AGL-E--- | 4005.0 | 32.08627 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 667 | 667 | 2015-06-05 16:00:44+00:00 | Bike | TDSPHC-AGL-E--- | 3728.0 | 31.08725 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 668 | 668 | 2015-06-06 06:49:12+00:00 | Bike | TDSPHC-AGL-E--- | 8183.0 | 70.23241 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 669 | 669 | 2015-06-07 05:18:05+00:00 | Bike | TDSPHC-AGL-E--- | 5521.0 | 43.1429 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 670 | 670 | 2015-06-09 15:50:34+00:00 | Bike | TDSPHC-AGL-E--- | 5937.0 | 50.5774 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 671 | 671 | 2015-06-10 16:11:18+00:00 | Bike | TDSPHC-AGL-E--- | 4391.0 | 30.48694 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 672 | 672 | 2015-06-11 15:10:22+00:00 | Bike | TDSPHC-AGL-E--- | 5844.0 | 56.46968 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 673 | 673 | 2015-06-13 11:25:45+00:00 | Bike | TDSPHC-AGL-E--- | 11235.0 | 84.06832 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 674 | 674 | 2015-06-14 06:08:55+00:00 | Bike | TDSPHC-AGL-E--- | 5970.0 | 52.58338 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 675 | 675 | 2015-06-16 14:34:49+00:00 | Bike | TDSPHC-AGL-E--- | 6600.0 | 59.6669 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 676 | 676 | 2015-06-18 15:38:02+00:00 | Bike | TDSPHC-AGL-E--- | 5578.0 | 47.60485 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 677 | 677 | 2015-06-19 11:55:09+00:00 | Bike | TDSPHC-AGL-E--- | 14471.0 | 114.74814 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 678 | 678 | 2015-06-20 16:25:47+00:00 | Bike | TDSPHC-AGL-E--- | 4081.0 | 36.24729 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 679 | 679 | 2015-06-21 10:15:08+00:00 | Bike | TDSPHC-AGL-E--- | 7361.0 | 69.51655 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 680 | 680 | 2015-06-22 16:19:15+00:00 | Bike | TDSPHC-AGL-E--- | 5324.0 | 36.93444 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 681 | 681 | 2015-06-23 16:03:48+00:00 | Bike | TDSPHC-AGL-E--- | 5743.0 | 47.45218 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 682 | 682 | 2015-06-25 15:11:08+00:00 | Bike | TDSPHC-AGL-E--- | 7034.0 | 59.55096 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 683 | 683 | 2015-06-27 14:39:39+00:00 | Bike | TDSPHC-AGL-E--- | 11284.0 | 89.82244 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 684 | 684 | 2015-06-28 05:01:13+00:00 | Bike | TDSPHC-AGL-E--- | 6606.0 | 55.76445 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 685 | 685 | 2015-06-29 15:55:10+00:00 | Bike | TDSPHC-AGL-E--- | 4433.0 | 34.77869 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 686 | 686 | 2015-07-01 13:19:32+00:00 | Bike | TDSPHC-AGL-E--- | 10812.0 | 66.96148 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 687 | 687 | 2015-07-02 05:06:28+00:00 | Bike | TDSPHC-AGL-E--- | 3878.0 | 30.13109 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 688 | 688 | 2015-07-03 05:37:54+00:00 | Bike | TDSPHC-AGL-E--- | 5043.0 | 33.84908 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 689 | 689 | 2015-07-04 09:16:46+00:00 | Bike | TDSPHC-AGL-E--- | 14005.0 | 84.3003 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 690 | 690 | 2015-07-05 04:02:20+00:00 | Bike | TDSPHC-AGL-E--- | 8191.0 | 68.41934 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 691 | 691 | 2015-07-06 16:24:12+00:00 | Bike | TDSPHC-AGL-E--- | 4022.0 | 28.83915 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 692 | 692 | 2015-07-07 16:20:41+00:00 | Bike | TDSPHC-AGL-E--- | 5737.0 | 40.03443 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 693 | 693 | 2015-07-08 03:53:06+00:00 | Bike | TDSPHC-AGL-E--- | 5587.0 | 38.31597 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 694 | 694 | 2015-07-09 03:56:06+00:00 | Bike | TDSPHC-AGL-E--- | 5788.0 | 47.66721 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 695 | 695 | 2015-07-10 16:13:52+00:00 | Bike | TDSPHC-AGL-E--- | 6123.0 | 40.03658 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 696 | 696 | 2015-07-11 08:22:16+00:00 | Bike | TDSPHC-AGL-E--- | 12248.0 | 89.56997 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 697 | 697 | 2015-07-12 05:02:23+00:00 | Bike | TDSPHC-AGL-E--- | 7302.0 | 52.81364 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 698 | 698 | 2015-07-13 03:57:14+00:00 | Bike | TDSPHC-AGL-E--- | 3604.0 | 27.20291 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 699 | 699 | 2015-07-14 16:03:50+00:00 | Bike | TDSPHC-AGL-E--- | 5323.0 | 35.01045 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 700 | 700 | 2015-07-15 15:20:38+00:00 | Bike | TDSPHC-AGL-E--- | 4295.0 | 29.1727 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 701 | 701 | 2015-07-16 16:03:32+00:00 | Bike | TDSPHC-AGL-E--- | 6291.0 | 48.37244 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 702 | 702 | 2015-07-17 03:49:12+00:00 | Bike | TDSPHC-AGL-E--- | 3795.0 | 28.27676 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 703 | 703 | 2015-07-18 04:01:35+00:00 | Bike | TDSPHC-AGL-E--- | 9143.0 | 79.85216 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 704 | 704 | 2015-07-19 04:03:35+00:00 | Bike | TDSPHC-AGL-E--- | 8098.0 | 65.85578 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 705 | 705 | 2015-07-20 03:53:00+00:00 | Bike | TDSPHC-AGL-E--- | 3480.0 | 26.00459 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 706 | 706 | 2015-07-21 16:00:10+00:00 | Bike | TDSPHC-AGL-E--- | 4608.0 | 35.67607 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 707 | 707 | 2015-07-22 03:47:04+00:00 | Bike | TDSPHC-AGL-E--- | 4180.0 | 32.14733 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 708 | 708 | 2015-07-23 03:43:47+00:00 | Bike | TDSPHC-AGL-E--- | 4025.0 | 28.00775 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 709 | 709 | 2015-07-24 03:50:22+00:00 | Bike | TDSPHC-AGL-E--- | 3493.0 | 27.93864 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 710 | 710 | 2015-07-25 06:37:12+00:00 | Bike | TDSPHC-AGL-E--- | 11370.0 | 86.50105 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 711 | 711 | 2015-07-26 05:01:31+00:00 | Bike | TDSPHC-AGL-E--- | 8273.0 | 68.11927 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 712 | 712 | 2015-07-28 15:38:49+00:00 | Bike | TDSPHC-AGL-E--- | 6175.0 | 44.42364 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 713 | 713 | 2015-07-30 15:35:44+00:00 | Bike | TDSPHC-AGL-E--- | 6868.0 | 51.01196 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 714 | 714 | 2015-08-01 07:59:11+00:00 | Bike | TDSPHC-AGL-E--- | 12064.0 | 77.77649 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 715 | 715 | 2015-08-02 11:03:23+00:00 | Bike | TDSPHC-AGL-E--- | 7369.0 | 66.86455 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 717 | 717 | 2015-08-05 15:09:53+00:00 | Bike | TDSPHC-AGL-E--- | 8631.0 | 61.48705 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 718 | 718 | 2015-08-06 16:35:55+00:00 | Bike | TDSPHC-AGL-E--- | 3733.0 | 30.33154 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 719 | 719 | 2015-08-07 15:51:49+00:00 | Bike | TDSPHC-AGL-E--- | 4192.0 | 34.69966 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 720 | 720 | 2015-08-08 05:44:24+00:00 | Bike | TDSPHC-AGL----- | 8900.0 | 69.23203 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 721 | 721 | 2015-08-09 04:56:28+00:00 | Bike | TDSPHC-AGL-E--- | 7378.0 | 50.0579 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 722 | 722 | 2015-08-11 15:56:50+00:00 | Bike | TDSPHC-AGL-E--- | 7805.0 | 51.03024 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 723 | 723 | 2015-08-12 16:01:37+00:00 | Bike | TDSPHCNAGL-E--- | 4928.0 | 37.66448 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 724 | 724 | 2015-08-13 07:55:31+00:00 | Bike | TDSPHC-AGL-E--- | 7403.0 | 38.25339 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 725 | 725 | 2015-08-14 14:34:47+00:00 | Bike | TDSPHC-AGL-E--- | 3804.0 | 27.26841 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 726 | 726 | 2015-08-15 06:48:51+00:00 | Bike | TDSPHC-AGL-E--- | 3796.0 | 27.98984 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 727 | 727 | 2015-08-16 08:16:31+00:00 | Bike | TDSPHC-AGL-E--- | 6756.0 | 28.16169 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 729 | 729 | 2015-08-28 15:41:57+00:00 | Bike | TDSPHC-AGL-E--- | 6633.0 | 47.89087 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 730 | 730 | 2015-08-29 09:01:00+00:00 | Bike | TDSPHC-AGL-E--- | 14470.0 | 96.11562 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 731 | 731 | 2015-09-01 15:45:16+00:00 | Bike | TDSPHC-AGL-E--- | 5465.0 | 35.25831 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 732 | 732 | 2015-09-02 15:58:33+00:00 | Bike | TDSPHC-AGL-E--- | 4965.0 | 32.12425 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 733 | 733 | 2015-09-03 15:37:59+00:00 | Bike | TDSPHC-AGL-E--- | 5872.0 | 37.00789 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 734 | 734 | 2015-09-04 15:52:33+00:00 | Bike | TDSPHC-AGL-E--- | 4162.0 | 28.62281 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 735 | 735 | 2015-09-05 09:00:46+00:00 | Bike | TDSPHC-AGL-E--- | 16078.0 | 100.75479 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 736 | 736 | 2015-09-06 10:22:37+00:00 | Bike | TDSPHC-AGL-E--- | 8032.0 | 66.07237 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 737 | 737 | 2015-09-08 15:22:45+00:00 | Bike | TDSPHC-AGL-E--- | 5465.0 | 36.73705 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 738 | 738 | 2015-09-09 16:23:11+00:00 | Bike | TDSPHC-AGL-E--- | 3501.0 | 24.15909 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 739 | 739 | 2015-09-11 15:40:26+00:00 | Bike | TDSPHC-AGL-E--- | 3696.0 | 30.12587 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 740 | 740 | 2015-09-12 08:52:43+00:00 | Bike | TDSPHC-AGL-E--- | 17466.0 | 125.05512 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 741 | 741 | 2015-09-13 15:20:51+00:00 | Bike | TDSPHC-AGL-E--- | 4553.0 | 46.10241 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 742 | 742 | 2015-09-14 15:34:12+00:00 | Bike | TDSPHC-AGL-E--- | 3249.0 | 24.64396 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 743 | 743 | 2015-09-15 14:32:12+00:00 | Bike | TDSPHC-AGL-E--- | 6308.0 | 46.21845 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
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");