title: JSON and SQLite3 in Python
body: <p>I'm currently trying to parse the following small sample lines from a JSON dataset.  However, in python I'm running into issues.  Any help is greatly appreciated.  My poor attempt at the code is below:</p>
  
  <p>Dataset:</p>
  
  <pre><code>{
     "matchId": 1778839570,
     "region": "NA",
     "platformId": "NA1",
     "matchMode": "CLASSIC",
     "matchType": "MATCHED_GAME",
     "matchCreation": 1427867835805,
     "matchDuration": 3424,
     "queueType": "RANKED_SOLO_5x5",
     "mapId": 11,
     "season": "SEASON2015",
     "matchVersion": "5.6.0.194",
     "participants": [
        {
           "teamId": 100,
           "spell1Id": 4,
           "spell2Id": 11,
           "championId": 113,
           "highestAchievedSeasonTier": "GOLD"
        }
     ]
  }
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>import json
  from pprint import pprint
  fhand = json.load(open('riot.json'))
  for e in fhand:
      print e
  </code></pre>
  
  <p>Note: The idea is to parse each one of these as a column, where the matchID will be a key_id for a sql table (distinct).  The other tuples will be columns with values.  In reality, there'll be numerous blocks of text like the above Dataset, and each one will correspond to a matchID.  Thanks for the help!</p>