rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where 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} | |
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} | |
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} | ||
257398 | 257398 | 1989-12-30 04:17:06+00:00 | Bike | TDSP-C-AGL----- | 3293.0 | 23.9181 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
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} |
257406 | 257406 | 1989-12-30 13:37:47+00:00 | Bike | TDSP-C-AGL----- | 4907.0 | 44.95314 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257407 | 257407 | 1989-12-30 13:38:01+00:00 | Bike | TDSP-C-AGL----- | 4910.0 | 36.12047 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257408 | 257408 | 1989-12-30 13:38:19+00:00 | Bike | TDSPHC-AGL----- | 4888.0 | 47.65769 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257409 | 257409 | 1989-12-30 13:40:29+00:00 | Bike | TDSP-C-AGL----- | 4427.0 | 30.35055 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257410 | 257410 | 1989-12-30 13:40:43+00:00 | Bike | TDSP-C-AGL----- | 4744.0 | 42.93625 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257411 | 257411 | 1989-12-30 13:43:02+00:00 | Bike | TDSP-C-AGL----- | 4593.0 | 43.53883 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257412 | 257412 | 1989-12-30 13:43:55+00:00 | Bike | TDSP-C-AGL----- | 4541.0 | 41.40476 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
257413 | 257413 | 1989-12-30 13:44:47+00:00 | Bike | TDSP-C-AGL----- | 4505.0 | 37.96464 | {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");