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 descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid | date ▲ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1251703 | 1251703 | 2106-02-07 06:28:15+00:00 | Fitness equipment | T--PHC--------- | 409.0 | {dd0332ba-e437-4727-9bd4-25eed225962d} | |
| 1995504 | 1995504 | 2080-12-30 23:16:05+00:00 | Bike | TDSPHC-AGL----- | 3424.0 | 30.05593 | {3cbfbe79-bca0-4cbb-9f47-aeeed28935ea} |
| 2256496 | 2256496 | 2038-11-21 00:10:56+00:00 | Bike | TDSPHC-AGL-EV-- | 8798.0 | 62.754 | {c3dfebf3-92a2-4cff-b08a-5c120968641b} |
| 1350125 | 1350125 | 2028-02-06 00:00:01+00:00 | Bike | TDSPHC-AGL-E--- | 8946.0 | 33.5266 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 1350124 | 1350124 | 2028-02-05 22:50:23+00:00 | Bike | TDSPHC-AGL-E--- | 2115.0 | 7.13258 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 171321 | 171321 | 2021-04-04 15:59:36+00:00 | TDSPHC-A-L----- | 12620.0 | 100.465 | {24f0bef8-c356-4112-9385-14525c187d9d} | |
| 1471801 | 1471801 | 2020-12-15 20:09:33+00:00 | TDSPHC-AGL----- | 300.0 | 0.0015 | {5b29d991-aed3-414e-82a7-028f9e65cfc0} | |
| 2307020 | 2307020 | 2020-05-27 12:18:52+00:00 | Run | TDSPHC-AGL-EV-R | 3939.0 | 8.03493 | {74bb725a-10df-409c-a0f2-c4af63b328a2} |
| 860225 | 860225 | 2020-05-27 10:51:39+00:00 | Bike | TDSPHC-AGL-EV-- | 4286.0 | 40.00193 | {b1d74472-3094-40b1-a74b-aaf5458d54de} |
| 2207226 | 2207226 | 2020-05-27 09:21:37+00:00 | Bike | TDSPHC-AGL----- | 3656.0 | 16.91078 | {968b5656-26c8-4247-86aa-d61c96bab48f} |
| 517360 | 517360 | 2020-05-27 08:06:23+00:00 | Bike | TDSPHC-A-L-EV-- | 661.0 | 2.97332 | {7533797f-f594-4339-8d66-e6f4a9b56540} |
| 517359 | 517359 | 2020-05-27 07:51:59+00:00 | Bike | TDSPHC-A-L-EV-- | 421.0 | 2.26539 | {7533797f-f594-4339-8d66-e6f4a9b56540} |
| 646915 | 646915 | 2020-05-27 07:13:15+00:00 | Bike | TDSPHC-AGL----- | 4033.0 | 32.9454 | {8dcd2a50-5e80-4212-86da-253f8477c465} |
| 1574550 | 1574550 | 2020-05-27 06:08:20+00:00 | Bike | TDSPHC-AGL-E--- | 4189.0 | 20.74298 | {fd18f701-f1c2-4081-8dd4-16a8f3c9fa7a} |
| 909262 | 909262 | 2020-05-26 22:59:58+00:00 | Bike | TDSPHCNAGL-EV-- | 4408.0 | 32.1019 | {a6557316-ecb9-4400-8b4b-22c8340a6085} |
| 252288 | 252288 | 2020-05-26 21:58:11+00:00 | TDSPHC-AGL-E--- | 11281.0 | 59.39707 | {cc076ae8-9bbd-49fb-8eba-9a942c76ce68} | |
| 2337758 | 2337758 | 2020-05-26 19:20:03+00:00 | Bike | TDSPHC-AGL-EV-- | 7340.0 | 62.38154 | {a2cfe223-381d-4b45-8db7-cbe97ea2cbef} |
| 679312 | 679312 | 2020-05-26 17:02:30+00:00 | Running: Road | TDSPHC-AGL-E--R | 3826.0 | 12.3004 | {759a3f61-01f4-4433-a93e-48129dba9b23} |
| 764722 | 764722 | 2020-05-26 16:05:13+00:00 | Bike | TDSPHC-AGL----- | 7831.0 | 72.95652 | {09423884-dfb0-44ce-8ad2-2e86aa926a5e} |
| 325204 | 325204 | 2020-05-26 16:03:55+00:00 | Bike | TDSPHC-A-L-E--- | 3721.0 | 30.7838 | {b0153cca-c5d0-416a-b482-b8aa969cfe14} |
| 1800287 | 1800287 | 2020-05-26 15:49:08+00:00 | Bike | TDSPHC-AGL----- | 1576.0 | 11.2783 | {4c9d0ed0-5470-4523-8fa4-cb29efbff751} |
| 309375 | 309375 | 2020-05-26 15:43:40+00:00 | Bike | TDSPHC-AGL-E--- | 8386.0 | 57.1114 | {5cd61b91-8272-4e56-a027-0a25ca1ae09d} |
| 552124 | 552124 | 2020-05-26 15:23:36+00:00 | Bike | TDSPHC-AGL----- | 5929.0 | 3.716 | {42a2231c-0a81-4eaf-bc5e-e21dea1ec9ee} |
| 1900361 | 1900361 | 2020-05-26 15:22:04+00:00 | Bike | TDSPHC-AGL----- | 3071.0 | 24.4667 | {b745f3a6-0cb8-4ebb-8740-ca056d452a5b} |
| 1100081 | 1100081 | 2020-05-26 15:21:30+00:00 | Bike | TDSPHC-AGL----- | 4669.0 | 36.0621 | {f9bcbc5c-51ca-48de-b493-2905d56b9189} |
| 1662118 | 1662118 | 2020-05-26 14:02:58+00:00 | TDSPHC--------- | 3146.0 | 17.2776 | {0e47ed92-d639-4cb3-97db-6f9a5fbfac70} | |
| 2097824 | 2097824 | 2020-05-26 12:32:21+00:00 | Bike | TDSPHC-AGL----- | 9545.0 | 76.82532 | {5a91f419-f1e8-48b5-95d8-0a1586e9215b} |
| 829240 | 829240 | 2020-05-26 12:30:42+00:00 | Bike | TDSPHC-AGL-E--- | 9266.0 | 66.951 | {90edd0f7-b94c-4aec-95fe-28ad4eb011d7} |
| 860224 | 860224 | 2020-05-26 11:03:19+00:00 | Bike | TDSPHC-AGL-EV-- | 6800.0 | 46.9794 | {b1d74472-3094-40b1-a74b-aaf5458d54de} |
| 408794 | 408794 | 2020-05-26 10:21:27+00:00 | Bike | TDSPHC-AGL-E--- | 3603.0 | 18.1821 | {ec31cd51-1351-4dfd-8b60-c956022ddd51} |
| 974478 | 974478 | 2020-05-26 10:16:35+00:00 | Bike | TDSPHC-AGL----- | 3387.0 | 31.1333 | {cd376bf3-8b7c-453c-aa8c-eb580fd01ace} |
| 663855 | 663855 | 2020-05-26 09:23:49+00:00 | Bike | TDSPHC--------- | 2045.0 | 14.0361 | {080ee7a6-d88b-4c9a-85a1-414ed379e752} |
| 2447051 | 2447051 | 2020-05-26 07:37:51+00:00 | Bike | TDSPHC-AGL-E--- | 16900.0 | 81.7092 | {7c6b4603-ed9c-4906-90c0-e95664e00c7d} |
| 1524429 | 1524429 | 2020-05-26 07:02:45+00:00 | Bike | TDSPHC-AGL-E--- | 12104.0 | 91.76072 | {4b42863d-fbba-4d43-ad17-e2f06e52b706} |
| 646914 | 646914 | 2020-05-26 06:52:04+00:00 | Bike | TDSPHC-AGL----- | 7302.0 | 67.6921 | {8dcd2a50-5e80-4212-86da-253f8477c465} |
| 1533559 | 1533559 | 2020-05-26 06:45:32+00:00 | Bike | TDSPHC-AGL----- | 4084.0 | 35.0685 | {42f9083c-f725-4faa-b2ae-c6b14fdc9cc9} |
| 1837391 | 1837391 | 2020-05-26 06:39:01+00:00 | Bike | TDSPHC-AGL----- | 7617.0 | 60.2038 | {3b95fa3f-58ba-477b-820e-1ec1ba69c1dc} |
| 813095 | 813095 | 2020-05-26 06:23:33+00:00 | Bike | TDSPHC-AGL-EV-- | 4316.0 | 31.4831 | {966da803-67d9-4f9a-9bd9-da7a186f80ad} |
| 2207225 | 2207225 | 2020-05-26 02:32:31+00:00 | Bike | TDSPHC-AGL----- | 3547.0 | 30.06349 | {968b5656-26c8-4247-86aa-d61c96bab48f} |
| 325203 | 325203 | 2020-05-25 23:29:28+00:00 | Bike | TDSPHC-A-L-E--- | 1801.0 | 16.2347 | {b0153cca-c5d0-416a-b482-b8aa969cfe14} |
| 721254 | 721254 | 2020-05-25 22:46:39+00:00 | Bike | TDSPHC-AGL-EV-- | 5753.0 | 38.44846 | {ebc162ef-680a-4fd6-927c-11b42aa77f63} |
| 944683 | 944683 | 2020-05-25 22:12:01+00:00 | VirtualRide | TDSPHC-AGL----- | 2941.0 | 27.7348 | {69c65c93-75dd-40d3-a687-1da912810438} |
| 1596675 | 1596675 | 2020-05-25 21:13:42+00:00 | Bike | TDSPHCNA-L-E--- | 7880.0 | 53.7184 | {0109b2b3-1b3b-440c-8b44-337aa29f028d} |
| 2337757 | 2337757 | 2020-05-25 19:16:59+00:00 | Bike | TDSPHC-AGL-EV-- | 8943.0 | 77.48499 | {a2cfe223-381d-4b45-8db7-cbe97ea2cbef} |
| 624586 | 624586 | 2020-05-25 18:59:01+00:00 | Run | TDSPHC-AGL----- | 2155.0 | 6.9961 | {80bf0183-e6f4-43f0-abd8-97acb6b80280} |
| 1574549 | 1574549 | 2020-05-25 17:59:31+00:00 | Bike | TDSPHC-AGL-E--- | 5998.0 | 31.86925 | {fd18f701-f1c2-4081-8dd4-16a8f3c9fa7a} |
| 2346373 | 2346373 | 2020-05-25 17:51:52+00:00 | Evening Ride | TDSPHC-A-L-E--- | 2633.0 | 14.7448 | {c0738560-12b1-4046-aca5-e7c08733065b} |
| 1668434 | 1668434 | 2020-05-25 17:35:10+00:00 | Bike | TDSPHC-AGL-E--- | 2603.0 | 20.4456 | {693bca7d-088c-424e-9f8a-a8d29ff50a4d} |
| 1837390 | 1837390 | 2020-05-25 17:18:09+00:00 | Bike | TDSPHC-AGL----- | 5006.0 | 42.3501 | {3b95fa3f-58ba-477b-820e-1ec1ba69c1dc} |
| 308964 | 308964 | 2020-05-25 16:45:40+00:00 | Bike | TDSPH--AGL-E--- | 1980.0 | 17.52535 | {797f027f-cd5e-479f-b956-8a052e5dd0dc} |
| 1152996 | 1152996 | 2020-05-25 16:08:51+00:00 | MTB | TDSPHC-AGL-E-O- | 8989.0 | 45.01256 | {31974efd-7867-4648-b73e-7a58c8d742ee} |
| 2327791 | 2327791 | 2020-05-25 15:51:44+00:00 | Bike | TDSPHC-AGL-EV-- | 13624.0 | 77.364 | {eaa4dc84-9cfa-4366-bdf7-a535473cd60e} |
| 1001987 | 1001987 | 2020-05-25 15:51:09+00:00 | Bike | TDSPHC-A-L----- | 4326.06 | 30.9869 | {9fb42d5b-13d2-440a-aa3d-cf5663cdc0f7} |
| 1413283 | 1413283 | 2020-05-25 15:38:57+00:00 | Run | TDSPHC-----E--R | 5408.0 | 14.4545 | {045e4210-a638-4e0b-80ff-8ee91b639ad9} |
| 2154430 | 2154430 | 2020-05-25 15:17:10+00:00 | Bike | TDSPHC-AGL----- | 3027.0 | 26.2433 | {86f10c55-71bd-4c61-a22e-1c14e7a448d2} |
| 1900360 | 1900360 | 2020-05-25 15:03:42+00:00 | Bike | TDSPHC-AGL----- | 3310.0 | 24.3364 | {b745f3a6-0cb8-4ebb-8740-ca056d452a5b} |
| 552123 | 552123 | 2020-05-25 14:45:34+00:00 | Bike | TDSPHC--------- | 1801.0 | 11.4717 | {42a2231c-0a81-4eaf-bc5e-e21dea1ec9ee} |
| 309374 | 309374 | 2020-05-25 14:43:24+00:00 | Bike | TDSPHC-AGL-E--- | 1900.0 | 13.07009 | {5cd61b91-8272-4e56-a027-0a25ca1ae09d} |
| 2142846 | 2142846 | 2020-05-25 14:38:13+00:00 | Bike | TDSPHC--------- | 3661.0 | 25.544 | {dce41788-af95-47cb-bc1a-06ba58952ad5} |
| 1302014 | 1302014 | 2020-05-25 14:28:08+00:00 | Bike | TDSPHC-AGL-E--- | 5045.0 | 57.9589 | {c43cb18d-4bfb-4f78-8fb4-2730412334e9} |
| 1900430 | 1900430 | 2020-05-25 13:28:39+00:00 | TDSPHC--------- | 3600.0 | 23.74975 | {3e18fd52-0648-48a9-8deb-42903f6592da} | |
| 292000 | 292000 | 2020-05-25 12:36:48+00:00 | Bike | TDSPHC-AGL----- | 1904.0 | 8.89473 | {f1f03650-0c4d-4a0e-b551-5f991853ead7} |
| 944682 | 944682 | 2020-05-25 11:43:13+00:00 | VirtualRide | TDSPHC-AGL----- | 391.0 | 3.2542 | {69c65c93-75dd-40d3-a687-1da912810438} |
| 860223 | 860223 | 2020-05-25 10:58:47+00:00 | Bike | TDSPHC-AGL-EV-- | 4479.0 | 40.3178 | {b1d74472-3094-40b1-a74b-aaf5458d54de} |
| 623838 | 623838 | 2020-05-25 09:54:13+00:00 | Bike | TDSPHC--------- | 1530.0 | 12.068 | {124d67ec-56a8-4fd2-9539-d484f17957d8} |
| 944681 | 944681 | 2020-05-25 09:53:16+00:00 | VirtualRide | TDSPHC-AGL----- | 6361.0 | 46.8408 | {69c65c93-75dd-40d3-a687-1da912810438} |
| 721253 | 721253 | 2020-05-25 08:42:13+00:00 | Bike | TDSPHC-AGL-EV-- | 8448.0 | 50.84231 | {ebc162ef-680a-4fd6-927c-11b42aa77f63} |
| 2587345 | 2587345 | 2020-05-25 08:18:27+00:00 | Bike | TDSPHC-AGL-E--- | 11344.0 | 81.7961 | {d51c71fa-8d86-4e2f-bb62-9de6b37f2163} |
| 646913 | 646913 | 2020-05-25 07:35:50+00:00 | Bike | TDSPHC-AGL----- | 3672.0 | 25.0983 | {8dcd2a50-5e80-4212-86da-253f8477c465} |
| 813094 | 813094 | 2020-05-25 07:00:45+00:00 | Bike | TDSPHC-AGL-EV-- | 3263.0 | 28.1346 | {966da803-67d9-4f9a-9bd9-da7a186f80ad} |
| 947796 | 947796 | 2020-05-25 06:52:21+00:00 | Bike | T--PHC-----E--- | 5541.0 | {273aa53f-1a39-4aa6-be26-1df7f1f59068} | |
| 1961223 | 1961223 | 2020-05-25 06:46:14+00:00 | Bike | TDSPHC-AGL-E--- | 5689.0 | 40.907 | {62b49286-9146-489d-838f-2ac3563d763d} |
| 237252 | 237252 | 2020-05-25 06:15:03+00:00 | Bike | TDSPHC-AGL-E--- | 5724.0 | 31.1818 | {232ed74e-26aa-41a2-8fc7-a2cb55ef8a70} |
| 1735257 | 1735257 | 2020-05-24 21:19:33+00:00 | Bike | TDSPHC-AGL-E--- | 8582.0 | 62.7463 | {da3781a3-b13c-4dc3-9e38-0c08a10fc88f} |
| 2337756 | 2337756 | 2020-05-24 20:25:39+00:00 | Bike | TDSPHC-AGL-EV-- | 5540.0 | 53.45724 | {a2cfe223-381d-4b45-8db7-cbe97ea2cbef} |
| 1100078 | 1100078 | 2020-05-24 19:00:57+00:00 | Bike | TDSPHC-AGL----- | 689.0 | 5.1977 | {f9bcbc5c-51ca-48de-b493-2905d56b9189} |
| 986550 | 986550 | 2020-05-24 18:20:10+00:00 | Bike | TDSPHC-AGL-E--- | 5460.0 | 33.53235 | {4d7a925d-5ed0-4542-b67a-a29d58f620d2} |
| 187115 | 187115 | 2020-05-24 18:18:10+00:00 | Bike | TDSPHC-AGL-EV-- | 4426.0 | 19.3002 | {d6d4d7f5-eeec-4dc1-bae3-c1a3757dbddd} |
| 1100077 | 1100077 | 2020-05-24 18:10:18+00:00 | Bike | TDSPHC-AGL----- | 2918.0 | 30.7702 | {f9bcbc5c-51ca-48de-b493-2905d56b9189} |
| 1574548 | 1574548 | 2020-05-24 17:58:44+00:00 | Bike | TDSPHC-AGL-E--- | 7038.0 | 34.99029 | {fd18f701-f1c2-4081-8dd4-16a8f3c9fa7a} |
| 2301203 | 2301203 | 2020-05-24 17:19:00+00:00 | Bike | TDSPHC-A-L-EV-- | 3902.0 | 26.2242 | {74b20974-ee41-4e01-9af1-c20f7704e9ec} |
| 1413282 | 1413282 | 2020-05-24 17:04:23+00:00 | Run | TDSPHC-AGL----R | 3794.0 | 9.82417 | {045e4210-a638-4e0b-80ff-8ee91b639ad9} |
| 1100076 | 1100076 | 2020-05-24 17:01:26+00:00 | Bike | TDSPHC-AGL----- | 3219.0 | 32.7449 | {f9bcbc5c-51ca-48de-b493-2905d56b9189} |
| 252287 | 252287 | 2020-05-24 16:52:36+00:00 | Bike | TDSPHC-AGL----- | 10629.0 | 83.20797 | {cc076ae8-9bbd-49fb-8eba-9a942c76ce68} |
| 1100075 | 1100075 | 2020-05-24 16:47:59+00:00 | Bike | TDSPHC-AGL----- | 541.0 | 3.9238 | {f9bcbc5c-51ca-48de-b493-2905d56b9189} |
| 325201 | 325201 | 2020-05-24 16:27:12+00:00 | Bike | TDSPHC-AGL----- | 3936.0 | 28.03159 | {b0153cca-c5d0-416a-b482-b8aa969cfe14} |
| 1302013 | 1302013 | 2020-05-24 16:09:52+00:00 | Bike | TDSPH--AGL----- | 540.0 | 5.0753 | {c43cb18d-4bfb-4f78-8fb4-2730412334e9} |
| 2142845 | 2142845 | 2020-05-24 15:21:24+00:00 | Bike | TDSPHC--------- | 3301.0 | 23.0653 | {dce41788-af95-47cb-bc1a-06ba58952ad5} |
| 2154429 | 2154429 | 2020-05-24 15:15:43+00:00 | Bike | TDSPHC-A-L----- | 6607.0 | 47.80005 | {86f10c55-71bd-4c61-a22e-1c14e7a448d2} |
| 1900359 | 1900359 | 2020-05-24 14:23:20+00:00 | Bike | TDSPHC-AGL----- | 801.0 | 7.0623 | {b745f3a6-0cb8-4ebb-8740-ca056d452a5b} |
| 552122 | 552122 | 2020-05-24 14:16:13+00:00 | Bike | TDSPHC--------- | 1511.0 | 10.0404 | {42a2231c-0a81-4eaf-bc5e-e21dea1ec9ee} |
| 1001986 | 1001986 | 2020-05-24 14:02:08+00:00 | Bike | TDSPHC-A-L----- | 10044.0 | 86.8996 | {9fb42d5b-13d2-440a-aa3d-cf5663cdc0f7} |
| 1260593 | 1260593 | 2020-05-24 13:20:20+00:00 | Bike | TDSPHC--------- | 7201.0 | 52.9841 | {489ea8fd-52a6-4d37-bc58-891f71c8776a} |
| 2097823 | 2097823 | 2020-05-24 13:07:43+00:00 | Bike | TDSPHC-AGL----- | 9717.0 | 76.75458 | {5a91f419-f1e8-48b5-95d8-0a1586e9215b} |
| 133661 | 133661 | 2020-05-24 11:51:38+00:00 | Bike | TDSPHC-A-L-E--- | 2535.0 | 16.8581 | {79b91d61-0c00-4fda-9406-bcffc30d5aa7} |
| 291999 | 291999 | 2020-05-24 11:44:51+00:00 | Bike | TDSPHC-AGL----- | 8338.0 | 36.3369 | {f1f03650-0c4d-4a0e-b551-5f991853ead7} |
| 1837387 | 1837387 | 2020-05-24 11:02:45+00:00 | Bike | TDSPHC-AGL----- | 3696.0 | 26.021 | {3b95fa3f-58ba-477b-820e-1ec1ba69c1dc} |
| 1302012 | 1302012 | 2020-05-24 09:52:27+00:00 | Bike | TDSPHC-AGL-E--- | 11683.0 | 70.9542 | {c43cb18d-4bfb-4f78-8fb4-2730412334e9} |
| 309373 | 309373 | 2020-05-24 09:28:52+00:00 | Bike | TDSPHC-AGL-E--- | 3791.0 | 29.57811 | {5cd61b91-8272-4e56-a027-0a25ca1ae09d} |
| 2207224 | 2207224 | 2020-05-24 09:11:56+00:00 | Bike | TDSPHC-AGL----- | 7265.0 | 70.33124 | {968b5656-26c8-4247-86aa-d61c96bab48f} |
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");