import requests
import sqlite3 as lite

con = lite.connect(r"test.db")

cur = con.cursor()
cur.execute("CREATE TABLE main(id INTEGER PRIMARY KEY AUTOINCREMENT, status_code TEXT, headers TEXT, content TEXT)")

r = requests.head("https://ya.ru")

status_code = r.status_code
headers = "%s" % r.headers
content = "%s" % r.content

cur.execute(u"""INSERT INTO main (status_code, headers, content) VALUES (?,?,?)""", (status_code, headers, content,))
con.commit()

print (r.status_code)
print (r.headers)
print (r.content)