initial creation of consolidated data