import MySQLdb

db = MySQLdb.connect(host="localhost",user="root",passwd="admin",db="consultancy")
cur = db.cursor()

cur.execute("SELECT JSON_EXTRACT(header, '$.Date') "
            "FROM extractions ")
dateoutput = cur.fetchall()
db.close()

print(dateoutput)