rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by athlete descending
This data as json, CSV (advanced)
These facets timed out: date
| Link | rowid | date | sport | data | workout_time | total_distance | athlete ▲ |
|---|---|---|---|---|---|---|---|
| 2474479 | 2474479 | 2017-04-01 07:03:25+00:00 | Bike | TDS-HC-AGL-E--- | 23326.0 | 118.99 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474480 | 2474480 | 2017-04-05 12:31:25+00:00 | Bike | TDS-H--AGL-E--- | 10220.0 | 82.17801 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474481 | 2474481 | 2017-04-06 15:37:12+00:00 | Bike | TDS-HC-AGL-E--- | 6862.0 | 28.39262 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474482 | 2474482 | 2017-04-10 16:06:35+00:00 | Bike | TDS-HC-AGL-E--- | 11026.0 | 56.20324 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474483 | 2474483 | 2017-04-11 14:37:26+00:00 | Bike | TDS-HC-AGL-E--- | 14852.0 | 77.77807 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474484 | 2474484 | 2017-04-12 16:39:02+00:00 | Bike | TDS-HC-AGL-E--- | 7816.0 | 21.07971 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474485 | 2474485 | 2017-04-13 07:59:44+00:00 | Bike | TDS-HC-AGL-E--- | 16818.0 | 85.98193 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474486 | 2474486 | 2017-04-15 07:56:33+00:00 | Bike | TDS-HC-AGL-E--- | 16657.0 | 96.77027 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474487 | 2474487 | 2017-04-16 15:15:38+00:00 | Bike | TDS-HC-AGL-E--- | 10017.0 | 60.6697 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474488 | 2474488 | 2017-04-29 10:38:45+00:00 | Bike | TDS-HC-AGL-E--- | 3448.0 | 19.8168 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474489 | 2474489 | 2017-04-30 07:02:06+00:00 | Bike | TDS-HC-AGL-E--- | 1012.0 | 4.83611 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474490 | 2474490 | 2017-04-30 07:29:01+00:00 | Bike | TDS-HC-AGL-E--- | 17652.0 | 113.48742 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474491 | 2474491 | 2017-05-01 18:01:43+00:00 | Bike | TDS-HC-AGL-E--- | 3528.0 | 12.62868 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474492 | 2474492 | 2017-05-07 10:36:45+00:00 | Bike | TDS-HC-AGL-E--- | 4225.0 | 23.29726 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474493 | 2474493 | 2017-05-08 17:06:11+00:00 | Bike | TDS-HC-AGL-E--- | 8303.0 | 37.9034 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474494 | 2474494 | 2017-05-09 18:10:17+00:00 | Bike | TDS-HC-AGL-E--- | 3217.0 | 18.02847 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474495 | 2474495 | 2018-01-03 09:41:25+00:00 | Bike | TDS--C-AGL-E--- | 9153.0 | 28.64586 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474496 | 2474496 | 2018-01-05 14:48:25+00:00 | Bike | TDS-HC-AGL-E--- | 4910.0 | 19.96493 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474497 | 2474497 | 2018-01-08 14:49:13+00:00 | Bike | TDS-HC-AGL-E--- | 2859.0 | 9.1996 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474498 | 2474498 | 2018-01-10 13:48:46+00:00 | Bike | TDS-HC-AGL-E--- | 4464.0 | 17.06603 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474499 | 2474499 | 2018-01-13 08:28:51+00:00 | Bike | TDS-HC-AGL-E--- | 7183.0 | 30.87279 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474500 | 2474500 | 2018-01-17 14:42:16+00:00 | Bike | TDS-HC-AGL-E--- | 3707.0 | 21.69739 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474501 | 2474501 | 2018-02-07 14:57:47+00:00 | Bike | TDS-HC-AGL-E--- | 7940.0 | 36.29906 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474502 | 2474502 | 2018-02-08 13:24:32+00:00 | Bike | TDSPHC-AGL----- | 7226.0 | 37.9741 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474503 | 2474503 | 2018-02-08 14:42:21+00:00 | Bike | TDS-HC-AGL-E--- | 8421.0 | 27.75264 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474504 | 2474504 | 2018-02-10 11:28:55+00:00 | Bike | TDS-HC-AGL-E--- | 7875.0 | 56.60964 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474505 | 2474505 | 2018-02-11 13:12:17+00:00 | Bike | TDS-HC-AGL-E--- | 3810.0 | 24.63874 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474506 | 2474506 | 2018-02-12 15:46:43+00:00 | Bike | TDS-HC-AGL-E--- | 5711.0 | 26.60188 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474507 | 2474507 | 2018-02-13 15:13:33+00:00 | Bike | TDS-HC-AGL-E--- | 8170.0 | 36.85218 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474508 | 2474508 | 2018-02-15 16:29:07+00:00 | Bike | TDS-HC-AGL-E--- | 3015.0 | 18.36151 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474509 | 2474509 | 2018-02-16 15:12:03+00:00 | Bike | TDS-HC-AGL-E--- | 5416.0 | 34.91051 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474510 | 2474510 | 2018-02-20 15:54:38+00:00 | Bike | TDS-HC-AGL-E--- | 6560.0 | 38.2261 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474511 | 2474511 | 2018-02-22 15:17:43+00:00 | Bike | TDS-HC-AGL-E--- | 6589.0 | 43.43682 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474512 | 2474512 | 2018-02-23 15:07:59+00:00 | Bike | TDS-HC-AGL-E--- | 5177.0 | 34.31475 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474513 | 2474513 | 2018-02-24 11:41:47+00:00 | Bike | TDS-HC-AGL-E--- | 8333.0 | 48.64726 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474514 | 2474514 | 2018-02-27 19:46:43+00:00 | Bike | T---H--A---E--- | 1805.0 | {fff279c7-564e-43b5-a139-d6736c81b34b} | |
| 2474515 | 2474515 | 2018-03-03 14:59:28+00:00 | Bike | TDS-HC-AGL-E--- | 5530.0 | 28.93002 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474516 | 2474516 | 2018-03-06 18:13:11+00:00 | Bike | T---HC-A---E--- | 3004.0 | {fff279c7-564e-43b5-a139-d6736c81b34b} | |
| 2474517 | 2474517 | 2018-03-08 14:08:58+00:00 | Bike | T---HC-A---E--- | 4324.0 | {fff279c7-564e-43b5-a139-d6736c81b34b} | |
| 2474518 | 2474518 | 2018-03-12 15:40:20+00:00 | Bike | TDS-HC-AGL-E--- | 7051.0 | 45.67165 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474519 | 2474519 | 2018-03-13 15:39:11+00:00 | Bike | TDS-HC-AGL-E--- | 6927.0 | 42.33822 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474520 | 2474520 | 2018-03-15 13:58:55+00:00 | Bike | TDS-HC-AGL-E--- | 4251.0 | 27.13787 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474521 | 2474521 | 2018-03-18 16:28:32+00:00 | Bike | TDS-HC-AGL-E--- | 3090.0 | 11.68285 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474522 | 2474522 | 2018-03-19 10:39:30+00:00 | Bike | TDS-HC-AGL-E--- | 8401.0 | 34.7011 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474523 | 2474523 | 2018-03-20 13:59:13+00:00 | Bike | TDS-H--AGL-E--- | 1876.0 | 10.48931 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474524 | 2474524 | 2018-03-21 14:01:10+00:00 | Bike | TDS-HC-AGL-E--- | 7649.0 | 40.95603 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474525 | 2474525 | 2018-03-23 09:31:54+00:00 | Bike | TDS-HC-AGL-E--- | 2570.0 | 16.83706 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474526 | 2474526 | 2018-03-24 10:53:20+00:00 | Bike | TDS-HC-AGL-E--- | 4649.0 | 21.34295 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474527 | 2474527 | 2018-03-25 07:27:38+00:00 | Bike | TDS-HC-AGL-E--- | 1558.0 | 9.46573 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474528 | 2474528 | 2018-03-25 07:59:47+00:00 | Bike | TDS-HC-AGL-E--- | 6260.0 | 40.47171 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474529 | 2474529 | 2018-03-27 07:49:55+00:00 | Bike | TDS-HC-AGL-E--- | 7505.0 | 28.60356 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474530 | 2474530 | 2018-03-28 10:03:50+00:00 | Bike | TDS-HC-AGL-E--- | 4212.0 | 18.7663 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474531 | 2474531 | 2018-03-29 08:18:04+00:00 | Bike | TDS-HC-AGL-E--- | 10815.0 | 37.20731 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474532 | 2474532 | 2018-03-29 15:06:24+00:00 | Bike | TDS-HC-AGL-E--- | 4368.0 | 20.6127 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474533 | 2474533 | 2018-03-31 09:35:16+00:00 | Bike | TDS-HC-AGL-E--- | 4228.0 | 20.63572 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474534 | 2474534 | 2018-04-01 10:37:34+00:00 | Bike | TDS-HC-AGL-E--- | 4760.0 | 32.56314 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474535 | 2474535 | 2018-04-01 11:57:00+00:00 | Bike | TDS-HC-AGL-E--- | 1902.0 | 10.4976 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474536 | 2474536 | 2018-04-03 15:02:28+00:00 | Bike | TDS-HC-AGL-E--- | 5837.0 | 21.91972 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474537 | 2474537 | 2018-04-04 14:51:58+00:00 | Bike | TDS-HC-AGL-E--- | 3850.0 | 22.56658 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474538 | 2474538 | 2018-04-07 14:10:13+00:00 | Bike | TDS-HC-AGL-E--- | 4997.0 | 23.83033 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474539 | 2474539 | 2018-04-09 14:40:16+00:00 | Bike | TDS-HC-AGL-E--- | 6414.0 | 29.11205 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474540 | 2474540 | 2018-04-10 15:09:47+00:00 | Bike | T---H--A---E--- | 2762.0 | {fff279c7-564e-43b5-a139-d6736c81b34b} | |
| 2474541 | 2474541 | 2018-04-13 15:11:12+00:00 | Bike | TDS-HC-AGL-E--- | 8674.0 | 36.24267 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474542 | 2474542 | 2018-04-14 07:25:44+00:00 | Bike | TDS-HC-AGL-E--- | 10506.0 | 81.1124 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474543 | 2474543 | 2018-04-15 07:24:13+00:00 | Bike | TDS-HC-AGL-E--- | 10383.0 | 83.91241 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474544 | 2474544 | 2018-04-15 10:22:04+00:00 | Bike | TDS-HC-AGL-E--- | 2220.0 | 4.60113 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474545 | 2474545 | 2018-04-17 15:05:03+00:00 | Bike | TDS-H--AGL-E--- | 6049.0 | 28.3558 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474546 | 2474546 | 2018-04-19 15:17:48+00:00 | Bike | TDS-HC-AGL-E--- | 5040.0 | 21.05422 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474547 | 2474547 | 2018-04-20 14:22:52+00:00 | Bike | TDS-H--AGL-E--- | 7065.0 | 48.84281 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474548 | 2474548 | 2018-04-21 06:26:36+00:00 | Bike | TDS-H--AGL-E--- | 17276.0 | 105.0866 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474549 | 2474549 | 2018-04-23 13:30:10+00:00 | Bike | TDS-H--AGL-E--- | 5083.0 | 36.87405 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474550 | 2474550 | 2018-04-25 13:54:59+00:00 | Bike | TDS-HC-AGL-E--- | 5610.0 | 22.87261 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474551 | 2474551 | 2018-04-26 12:24:23+00:00 | Bike | TDS-HC-AGL-E--- | 3328.0 | 18.13874 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474552 | 2474552 | 2018-04-27 14:36:39+00:00 | Bike | TDS-HC-AGL-E--- | 6477.0 | 16.02928 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474553 | 2474553 | 2018-04-28 07:03:18+00:00 | Bike | TDS-HC-AGL-E--- | 4287.0 | 20.55466 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474554 | 2474554 | 2018-04-29 07:03:25+00:00 | Bike | TDS-HC-AGL-E--- | 1037.0 | 2.71442 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474555 | 2474555 | 2018-04-29 07:36:01+00:00 | Bike | TDS-HC-AGL-E--- | 8622.0 | 46.36431 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474556 | 2474556 | 2018-05-02 13:25:16+00:00 | Bike | TDS-HC-AGL-E--- | 6865.0 | 33.19391 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474557 | 2474557 | 2018-05-03 13:38:35+00:00 | Bike | TDS-HC-AGL-E--- | 3409.0 | 16.06248 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474558 | 2474558 | 2018-05-04 16:59:09+00:00 | Bike | TDS-HC-AGL-E--- | 5403.0 | 26.43393 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474559 | 2474559 | 2018-05-05 07:28:30+00:00 | Bike | TDS-HC-AGL-E--- | 5538.0 | 31.36805 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474560 | 2474560 | 2018-05-05 09:04:32+00:00 | Bike | TDS-HC-AGL-E--- | 2204.0 | 5.92297 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474561 | 2474561 | 2018-05-06 07:04:56+00:00 | Bike | TDS-HC-AGL-E--- | 1296.0 | 6.39155 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474562 | 2474562 | 2018-05-06 07:44:42+00:00 | Bike | TDS-HC-AGL-E--- | 7174.0 | 28.5327 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474563 | 2474563 | 2018-05-09 16:05:45+00:00 | Bike | T---H--A---E--- | 1803.0 | {fff279c7-564e-43b5-a139-d6736c81b34b} | |
| 2474564 | 2474564 | 2018-05-10 14:43:12+00:00 | Bike | TDS-H--AGL-E--- | 7799.0 | 52.26754 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474565 | 2474565 | 2018-05-11 14:16:05+00:00 | Bike | TDS-HC-AGL-E--- | 1593.0 | 6.19727 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474566 | 2474566 | 2018-05-11 14:46:11+00:00 | Bike | TDS-H--AGL-E--- | 3899.0 | 22.25985 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474567 | 2474567 | 2018-05-12 14:32:31+00:00 | Bike | TDS-H--AGL-E--- | 3551.0 | 23.46036 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474568 | 2474568 | 2018-05-13 12:39:06+00:00 | Bike | TDS-H--AGL-E--- | 5179.0 | 34.12387 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474569 | 2474569 | 2018-05-15 12:42:15+00:00 | Bike | TDS-H--AGL-E--- | 7080.0 | 44.1498 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474570 | 2474570 | 2018-05-16 14:35:41+00:00 | Bike | TDS-HC-AGL-E--- | 4236.0 | 23.22982 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474571 | 2474571 | 2018-05-17 14:22:38+00:00 | Bike | TDS-HC-AGL-E--- | 43.0 | 0.10989 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474572 | 2474572 | 2018-05-17 14:23:26+00:00 | Bike | TDS-HC-AGL-E--- | 4015.0 | 9.66497 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474573 | 2474573 | 2018-05-17 15:37:53+00:00 | Bike | TDS-HC-AGL-E--- | 1853.0 | 10.35216 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474574 | 2474574 | 2018-05-17 16:25:39+00:00 | Bike | TDS-HC-AGL-E--- | 721.0 | 3.13565 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474575 | 2474575 | 2018-05-18 17:04:03+00:00 | Bike | TDS-HC-AGL-E--- | 4057.0 | 19.99838 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474576 | 2474576 | 2018-05-19 11:44:38+00:00 | Bike | TDSPHC-AGL-E--- | 4515.0 | 21.66608 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474577 | 2474577 | 2018-05-20 06:45:53+00:00 | Bike | TDSPHC-AGL-E--- | 1176.0 | 4.27186 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474578 | 2474578 | 2018-05-20 07:05:32+00:00 | Bike | TDSPHC-AGL-E--- | 1014.0 | 5.56227 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
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");