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 date
This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid | date ▼ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1880048 | 1880048 | 1915-09-23 10:35:00+00:00 | Bike | TDSPHCNA-L-E--- | 4265.0 | 31.9465 | {00b8b415-0abd-42d6-ac3e-0d122ba63fc3} |
| 1835545 | 1835545 | 1917-09-16 22:39:35+00:00 | Bike | TDSPHC-AGL----- | 1207.0 | 6.74883 | {686f112b-5b26-4760-b1c7-8356e2b03ad0} |
| 1835546 | 1835546 | 1919-03-27 22:29:58+00:00 | Bike | TDSPH--AGL----- | 1800.0 | 14.30491 | {686f112b-5b26-4760-b1c7-8356e2b03ad0} |
| 1835547 | 1835547 | 1919-03-29 22:32:26+00:00 | Bike | TDSPH--AGL----- | 1648.0 | 15.03046 | {686f112b-5b26-4760-b1c7-8356e2b03ad0} |
| 1835548 | 1835548 | 1919-03-31 22:19:43+00:00 | Bike | TDSPH--AGL----- | 2417.0 | 14.86078 | {686f112b-5b26-4760-b1c7-8356e2b03ad0} |
| 1835549 | 1835549 | 1919-04-10 22:09:07+00:00 | Bike | TDSPH--AGL----- | 3045.0 | 21.57007 | {686f112b-5b26-4760-b1c7-8356e2b03ad0} |
| 1250804 | 1250804 | 1970-01-01 00:00:02+00:00 | Bike | T--PHC--------- | 494.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250805 | 1250805 | 1970-01-01 00:00:05+00:00 | Bike | T--PHC--------- | 491.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250806 | 1250806 | 1970-01-01 00:00:06+00:00 | Bike | T--PHC--------- | 490.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250807 | 1250807 | 1970-01-01 00:00:07+00:00 | Bike | T--PHC--------- | 489.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250808 | 1250808 | 1970-01-01 00:00:12+00:00 | Bike | T--PHC--------- | 484.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250809 | 1250809 | 1970-01-01 00:00:15+00:00 | Bike | T--PHC--------- | 481.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250811 | 1250811 | 1970-01-01 00:00:24+00:00 | Bike | T--PHC--------- | 472.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250812 | 1250812 | 1970-01-01 00:00:26+00:00 | Bike | T--PHC--------- | 470.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250813 | 1250813 | 1970-01-01 00:00:27+00:00 | Bike | T--PHC--------- | 469.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250814 | 1250814 | 1970-01-01 00:00:28+00:00 | Bike | T--PHC--------- | 468.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250815 | 1250815 | 1970-01-01 00:00:29+00:00 | Bike | T--PHC--------- | 467.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1250816 | 1250816 | 1970-01-01 00:00:30+00:00 | Bike | T--PHC--------- | 466.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 2535815 | 2535815 | 1970-01-01 00:09:16+00:00 | TDSPHC-AGL----- | 93.0 | 1.19085 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535816 | 2535816 | 1970-01-01 00:11:04+00:00 | TDSPHC-AGL----- | 37.0 | 0.40969 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535817 | 2535817 | 1970-01-01 00:13:09+00:00 | TDSPHC-AGL----- | 141.0 | 1.65996 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535818 | 2535818 | 1970-01-01 00:15:21+00:00 | TDSPHC-AGL----- | 187.0 | 2.23111 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535819 | 2535819 | 1970-01-01 00:16:22+00:00 | TDSPHC-AGL----- | 44.0 | 0.486 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535820 | 2535820 | 1970-01-01 00:16:55+00:00 | TDSPHC-AGL----- | 93.0 | 1.06828 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535821 | 2535821 | 1970-01-01 00:21:25+00:00 | TDSPHC-AGL----- | 13.0 | 0.11962 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535822 | 2535822 | 1970-01-01 00:23:49+00:00 | TDSPHC-AGL----- | 109.0 | 1.17975 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535823 | 2535823 | 1970-01-01 00:26:55+00:00 | TDSPHC-AGL----- | 196.0 | 2.14055 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535824 | 2535824 | 1970-01-01 00:27:01+00:00 | TDSPHC-AGL----- | 97.0 | 1.05412 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535825 | 2535825 | 1970-01-01 00:29:58+00:00 | TDSPHC-AGL----- | 284.0 | 2.7378 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535826 | 2535826 | 1970-01-01 00:30:53+00:00 | TDSPHC-AGL----- | 43.0 | 0.52317 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535827 | 2535827 | 1970-01-01 00:31:56+00:00 | TDSPHC-AGL----- | 177.0 | 1.70332 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535828 | 2535828 | 1970-01-01 00:35:14+00:00 | TDSPHC-AGL----- | 71.0 | 0.58515 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535829 | 2535829 | 1970-01-01 00:36:55+00:00 | TDSPHC-AGL----- | 311.0 | 2.69504 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535830 | 2535830 | 1970-01-01 00:37:45+00:00 | TDSPHC-AGL----- | 42.0 | 0.47791 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535831 | 2535831 | 1970-01-01 00:37:47+00:00 | TDSPHC-AGL----- | 32.0 | 0.42765 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535832 | 2535832 | 1970-01-01 00:39:52+00:00 | TDSPHC-AGL----- | 60.0 | 0.54719 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535833 | 2535833 | 1970-01-01 00:41:01+00:00 | TDSPHC-AGL----- | 663.0 | 7.41808 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535834 | 2535834 | 1970-01-01 00:41:12+00:00 | TDSPHC-AGL----- | 58.0 | 0.49136 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535835 | 2535835 | 1970-01-01 00:42:29+00:00 | TDSPHC-AGL----- | 87.0 | 0.68024 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535836 | 2535836 | 1970-01-01 00:45:52+00:00 | TDSPHC-AGL----- | 1033.0 | 12.6469 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535837 | 2535837 | 1970-01-01 00:46:17+00:00 | TDSPHC-AGL----- | 587.0 | 7.11367 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535838 | 2535838 | 1970-01-01 00:49:39+00:00 | TDSPHC-AGL----- | 3105.0 | 34.931 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535839 | 2535839 | 1970-01-01 00:51:08+00:00 | TDSPHC-AGL----- | 142.0 | 1.61671 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535840 | 2535840 | 1970-01-01 00:52:22+00:00 | TDSPHC-AGL----- | 526.0 | 7.00997 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535841 | 2535841 | 1970-01-01 00:54:03+00:00 | TDSPHC-AGL----- | 236.0 | 2.67991 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535842 | 2535842 | 1970-01-01 00:55:43+00:00 | TDSPHC-AGL----- | 368.0 | 4.94087 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535843 | 2535843 | 1970-01-01 00:58:12+00:00 | TDSPHC-AGL----- | 229.0 | 2.61255 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535844 | 2535844 | 1970-01-01 00:58:43+00:00 | TDSPHC-AGL----- | 200.0 | 2.27916 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535845 | 2535845 | 1970-01-01 01:01:31+00:00 | TDSPHC-AGL----- | 386.0 | 4.62362 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535846 | 2535846 | 1970-01-01 01:04:26+00:00 | TDSPHC-AGL----- | 220.0 | 2.77284 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535847 | 2535847 | 1970-01-01 01:06:01+00:00 | TDSPHC-AGL----- | 202.0 | 2.2151 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535848 | 2535848 | 1970-01-01 01:07:56+00:00 | TDSPHC-AGL----- | 47.0 | 0.52959 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535849 | 2535849 | 1970-01-01 01:11:46+00:00 | TDSPHC-AGL----- | 270.0 | 2.56618 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535850 | 2535850 | 1970-01-01 01:13:24+00:00 | TDSPHC-AGL----- | 117.0 | 1.338 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535851 | 2535851 | 1970-01-01 01:15:13+00:00 | TDSPHC-AGL----- | 75.0 | 0.79819 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535852 | 2535852 | 1970-01-01 01:15:55+00:00 | TDSPHC-AGL----- | 329.0 | 2.27366 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535853 | 2535853 | 1970-01-01 01:17:47+00:00 | TDSPHC-AGL----- | 153.0 | 1.71408 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535854 | 2535854 | 1970-01-01 01:20:47+00:00 | TDSPHC-AGL----- | 763.0 | 8.81892 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535855 | 2535855 | 1970-01-01 01:22:11+00:00 | TDSPHC-AGL----- | 744.0 | 6.5822 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535856 | 2535856 | 1970-01-01 01:23:30+00:00 | TDSPHC-AGL----- | 1545.0 | 17.1317 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535857 | 2535857 | 1970-01-01 01:23:42+00:00 | TDSPHC-AGL----- | 367.0 | 4.44053 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535858 | 2535858 | 1970-01-01 01:25:00+00:00 | TDSPHC-AGL----- | 50.0 | 0.60919 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535859 | 2535859 | 1970-01-01 01:27:15+00:00 | TDSPHC-AGL----- | 89.0 | 1.00956 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535860 | 2535860 | 1970-01-01 01:28:11+00:00 | TDSPHC-AGL----- | 45.0 | 0.4944 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535861 | 2535861 | 1970-01-01 01:38:11+00:00 | TDSPHC-AGL----- | 758.0 | 8.29604 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535862 | 2535862 | 1970-01-01 01:43:01+00:00 | TDSPHC-AGL----- | 110.0 | 0.70983 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535863 | 2535863 | 1970-01-01 01:46:33+00:00 | TDSPHC-AGL----- | 230.0 | 2.36655 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535864 | 2535864 | 1970-01-01 01:49:34+00:00 | TDSPHC-AGL----- | 31.0 | 0.33269 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535865 | 2535865 | 1970-01-01 01:50:51+00:00 | TDSPHC-AGL----- | 96.0 | 1.04455 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535866 | 2535866 | 1970-01-01 01:54:20+00:00 | TDSPHC-AGL----- | 102.0 | 1.36765 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535867 | 2535867 | 1970-01-01 01:59:44+00:00 | TDSPHC-AGL----- | 368.0 | 3.90274 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535868 | 2535868 | 1970-01-01 02:01:12+00:00 | TDSPHC-AGL----- | 110.0 | 1.02778 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535869 | 2535869 | 1970-01-01 02:03:54+00:00 | TDSPHC-AGL----- | 118.0 | 1.31644 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535870 | 2535870 | 1970-01-01 03:13:36+00:00 | TDSPHC-AGL----- | 301.0 | 2.94609 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535871 | 2535871 | 1970-01-01 03:15:15+00:00 | TDSPHC-AGL----- | 96.0 | 1.01598 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535872 | 2535872 | 1970-01-01 03:15:44+00:00 | TDSPHC-AGL----- | 33.0 | 0.30802 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535873 | 2535873 | 1970-01-01 03:21:11+00:00 | TDSPHC-AGL----- | 194.0 | 1.88007 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535874 | 2535874 | 1970-01-02 01:43:01+00:00 | TDSPHC-AGL----- | 158.0 | 1.81718 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 2535875 | 2535875 | 1970-01-03 01:27:15+00:00 | TDSPHC-AGL----- | 89.0 | 1.00956 | {d8ebf8a2-b5d1-4ead-a42b-c5170d65d6c3} | |
| 1250817 | 1250817 | 1970-03-18 14:40:32+00:00 | Fitness equipment | T--PHC--------- | 436.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1862427 | 1862427 | 1978-11-02 09:55:23+00:00 | T-SPHC-AG--E--- | 321615001.0 | {f4d64878-666c-484b-a271-fb36494ef432} | ||
| 1111151 | 1111151 | 1989-12-30 13:27:21+00:00 | Bike | TDSPHC-AGL----- | 5560.0 | 30.92935 | {d178c210-aab0-4a95-b55c-16f6f064663a} |
| 1111152 | 1111152 | 1989-12-30 13:33:36+00:00 | Bike | TDSPHC-AGL----- | 5160.0 | 30.5648 | {d178c210-aab0-4a95-b55c-16f6f064663a} |
| 257408 | 257408 | 1989-12-30 13:38:19+00:00 | Bike | TDSPHC-AGL----- | 4888.0 | 47.65769 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257441 | 257441 | 1989-12-30 13:49:52+00:00 | Bike | TDSPHC-AGL----- | 4146.0 | 37.28066 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 1432930 | 1432930 | 1989-12-30 14:00:03+00:00 | Bike | TDSPHC-AGL----- | 3600.0 | 24.39838 | {1bc1499d-9370-44a7-a2b8-cd1e8fabd8cd} |
| 257492 | 257492 | 1989-12-30 14:05:22+00:00 | Bike | TDSPHC-AGL----- | 3263.0 | 36.54607 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257510 | 257510 | 1989-12-30 14:10:24+00:00 | Bike | TDSPHC-AGL----- | 2807.0 | 19.0635 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257552 | 257552 | 1989-12-30 14:21:53+00:00 | Bike | TDSPHC-AGL----- | 2287.0 | 21.34451 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257581 | 257581 | 1989-12-30 14:28:38+00:00 | Bike | TDSPHC-AGL----- | 1877.0 | 20.64966 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257629 | 257629 | 1989-12-30 14:35:08+00:00 | Bike | TDSPHC-AGL----- | 1494.0 | 19.0994 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257633 | 257633 | 1989-12-30 14:37:20+00:00 | Bike | TDSPHC-AGL----- | 1356.0 | 14.49626 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257659 | 257659 | 1989-12-30 14:39:23+00:00 | Bike | TDSPHC-AGL----- | 1234.0 | 14.54253 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257675 | 257675 | 1989-12-30 14:43:11+00:00 | Bike | TDSPHC-AGL----- | 997.0 | 10.97739 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257689 | 257689 | 1989-12-30 14:45:31+00:00 | Bike | TDSPHC-AGL----- | 870.0 | 6.69634 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257711 | 257711 | 1989-12-30 14:51:26+00:00 | Bike | TDSPHC-AGL----- | 493.0 | 4.55881 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257718 | 257718 | 1989-12-30 14:53:33+00:00 | Bike | TDSPHC-AGL----- | 384.0 | 3.60927 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257724 | 257724 | 1989-12-30 14:54:57+00:00 | Bike | TDSPHC-AGL----- | 303.0 | 3.65601 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 732841 | 732841 | 1989-12-30 15:03:22+00:00 | Bike | TDSPHC-AGL----- | 3398.0 | 24.2299 | {1f9023fa-7297-46c9-a034-9dba2f02d8d9} |
| 1286276 | 1286276 | 1989-12-30 18:56:46+00:00 | Bike | TDSPHC-AGL----- | 10730.0 | 103.71538 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
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");