compiled data for joining