title: How to parse a JSON file in Python
body: <p>I am still new to python in general. I'm currently trying to read in this JSON file I extracted from this site:</p>
  
  <p><a href="https://public.opendatasoft.com/explore/dataset/us-115th-congress-members/table/?rows=100&amp;lang=EN&amp;refine.rep_sen=Senator&amp;exclude.rep_sen=Representative" rel="nofollow noreferrer">https://public.opendatasoft.com/explore/dataset/us-115th-congress-members/table/?rows=100&amp;lang=EN&amp;refine.rep_sen=Senator&amp;exclude.rep_sen=Representative</a></p>
  
  <p>However, when I read it in using: </p>
  
  <pre><code>senators_json = pd.read_json('us-115th-congress-members.json', orient = 'columns')
  senators_json
  </code></pre>
  
  <p>I can't seem to access the fields I am really looking for (in the fields column). Am I completely off base in how to read in json files? </p>
  
  <p><a href="https://i.stack.imgur.com/6wbHJ.png" rel="nofollow noreferrer">Current Code Results</a></p>