title: Python Error:"TypeError: string indices must be integers"
body: <p>I'm here trying to parse JSON string that comes from a sql table, but while parsing it is giving the error <code>TypeError: string indices must be integers</code> at line <code>result = json_normalize(json_st,'results')</code></p>
  
  <p>here is the code snippet</p>
  
  <pre><code>from pandas.io.json import json_normalize
  import pyodbc
  cnxn = pyodbc.connect('connection string')
  cursor = cnxn.cursor()
  
  cursor.execute("select TOP 1 GEOCODE_ID, JSON from GEOCODE_TBL where GEOCODE_ID = 20")
  ID=[]
  JSON=[]
  
  for row in cursor.fetchall():
        ID.append(row[0])
        JSON.append(row[1])
  
  
  json_st1 = json.dumps(JSON)
  json_st=json.loads(json_st1)
  
  result = json_normalize(json_st,'results')
  </code></pre>
  
  <p>Any suggestion on this will be helpful.</p>
  
  <p>Thanks</p>
  
  <p>Domnick.</p>