JSON files/ formats have a dictionary data structure and so it might make them less straightforward to use compared to list/ dataframes. This post gives a high-level overview of how a typical json data structure looks like and how we can retrieve data we want that is structured in json formats. This also includes how to convert JSON formats to pandas dataframe.
The following notebook is also uploaded onto Github and can be found here.