R Script That Transforms JSON to a Data Frame

I need an R script that will translate the attached JSON file into a data frame. Sample data frame structure is within the "Desired Data Frame Format" tab of the Excel fie.