added column data for analysis