rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid | date ▼ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1229746 | 1229746 | Bike | T-------G------ | 63586100001.0 | {f4db7965-6fba-4a5f-bc5c-173f18f46a4a} | ||
| 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} |
| 540562 | 540562 | 1970-01-01 00:00:00+00:00 | T-------------- | 1.0 | {d1ad12c9-86b2-4589-83cb-d944b2440ce5} | ||
| 764723 | 764723 | 1970-01-01 00:00:00+00:00 | -D------G------ | 1.0 | 102.16 | {afadd1e5-c917-44f8-9e58-1358c19ef9c2} | |
| 1203210 | 1203210 | 1970-01-01 00:00:00+00:00 | T-------------- | 1.0 | {d849a11f-e21b-41a9-916f-459332bf0fff} | ||
| 1250804 | 1250804 | 1970-01-01 00:00:02+00:00 | Bike | T--PHC--------- | 494.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 2317572 | 2317572 | 1970-01-01 00:00:04+00:00 | Walking | TD------------- | 1481.0 | 1.67 | {24d2885a-693f-43ac-ace1-3f3522156bf5} |
| 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} | |
| 1250810 | 1250810 | 1970-01-01 00:00:16+00:00 | Bike | T--P-C--------- | 480.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} | |
| 1296782 | 1296782 | 1970-01-01 01:04:32+00:00 | Bike | TDS----AGL-E--- | 3834.0 | 18.6191 | {a8fc609e-20ef-464c-892e-d0b70acb3386} |
| 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} | |
| 2535876 | 2535876 | 1970-01-05 15:45:24+00:00 | TD-----AGL----- | 45991.0 | 204.912 | {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} | ||
| 257398 | 257398 | 1989-12-30 04:17:06+00:00 | Bike | TDSP-C-AGL----- | 3293.0 | 23.9181 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 396179 | 396179 | 1989-12-30 05:57:40+00:00 | T-S-----G--E--R | 79.0 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | ||
| 257399 | 257399 | 1989-12-30 12:56:17+00:00 | Bike | TDSP-C-AGL----- | 7406.0 | 55.75644 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257400 | 257400 | 1989-12-30 12:58:03+00:00 | Bike | TDSP-C-AGL----- | 7315.0 | 13.14225 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257401 | 257401 | 1989-12-30 13:23:49+00:00 | Bike | TDSP-C-AGL----- | 5752.0 | 41.7987 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257402 | 257402 | 1989-12-30 13:25:30+00:00 | Bike | TDSP-C-AGL----- | 5634.0 | 42.94011 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 1111151 | 1111151 | 1989-12-30 13:27:21+00:00 | Bike | TDSPHC-AGL----- | 5560.0 | 30.92935 | {d178c210-aab0-4a95-b55c-16f6f064663a} |
| 257403 | 257403 | 1989-12-30 13:31:28+00:00 | Bike | TDSP-C-AGL----- | 5294.0 | 38.68342 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 1111152 | 1111152 | 1989-12-30 13:33:36+00:00 | Bike | TDSPHC-AGL----- | 5160.0 | 30.5648 | {d178c210-aab0-4a95-b55c-16f6f064663a} |
| 257404 | 257404 | 1989-12-30 13:34:29+00:00 | Bike | TDSP-C-AGL----- | 5073.0 | 45.25186 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257405 | 257405 | 1989-12-30 13:37:23+00:00 | Bike | TDSP-C-AGL----- | 4920.0 | 40.05797 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
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");