gistfile1.txt

import json
import sqlite3

traffic = json.load(open('https://api.onthecity.org/ministries/2773260'))
db = mysql.connect("cccdatabase.mysql")

query = "insert into ministries values (?,?,?,?,?,?,?)"
columns = ['name', 'about', 'group', 'subgroup', 'image', 'link']
for timestamp, data in traffic.iteritems():
    keys = (timestamp,) + tuple(data[c] for c in columns)
    c = db.cursor()
    c.execute(query, keys)
    c.close()