Parse json from mysql in flask to get a field from record
<p>Mind that I am new to flask and python for that matter, I appreciate any help that anyone gives. I'm looking to access one of the fields of my JSON response(just the field not the entire response), how should I go about parsing the response. Image of the response attached below,thanks.
<br></p>

<h1>This is my main thread</h1>

<pre><code>from flask import Flask,render_template,request
from Qhandler import Qhandler
from MakePlayer import MakePlayer
app = Flask(__name__)

@app.route('/createplayer',methods=['GET','POST'] )
def showCreatePlayer():
    if request.method == 'POST':
        MakePlayer(request.form['playername'],request.form['playerteam'],request.form['playerrole'], request.form['playerpos'])
        return "created player: &lt;br&gt;"+request.form['playername']+" "+request.form['playerteam']+" "+request.form['playerrole']+" "+request.form['playerpos']

    return render_template("createPlayer.html")

@app.route('/sucess')
def success():
    return "success"

@app.route('/showplayers')
def showPlayers():
    Q = Qhandler()
    return Q.displayQuery(""" select * from Player""")

if __name__ == '__main__':
    app.run(debug=True)
</code></pre>

<p><br></p>

<h3>This is my query handler</h3>

<pre><code>from flask import Flask, jsonify, json
from flaskext.mysql import MySQL

class Qhandler(object):
    #global mysql
    global cursor
    global connection
    global mysql
    # database connection
    app = Flask(__name__)

    mysql = MySQL()
    app.config['MYSQL_DATABASE_USER'] = 'root'
    app.config['MYSQL_DATABASE_PASSWORD'] = 'root'
    app.config['MYSQL_DATABASE_DB'] = 'Optimizer'
    app.config['MYSQL_DATABASE_HOST'] = 'localhost'
    mysql.init_app(app)



    def ins(self,query):
        try:
            connection=mysql.connect()
            cursor = connection.cursor()
            cursor.execute(query)
            connection.commit()

        except:
            print "error running query"

        finally:
            #cursor.close()
            connection.close()

    def displayQuery(self,query):
        try:
            connection = mysql.connect()
            cursor = connection.cursor()
            cursor.execute(query)
            fetchedData = cursor.fetchall()
            fetchedData = jsonify(fetchedData)
            #fetchedData = json.dumps(fetchedData)
            #record = json.loads(fetchedData)
            #print "the resonse is here:"
            return fetchedData

        except:
            print "error running query"

        finally:
            #cursor.close()
            connection.close()
</code></pre>

<h3>current response is</h3>

<p><a href="http://i.stack.imgur.com/GYAJz.png" rel="nofollow">screenshot of results</a></p>