open_db.py

import sqlite3
import pandas as pd

db = sqlite3.connect("response.db")
df = pd.read_sql('SELECT * from responses', db)
print(df)
df.to_csv("responses.csv", index=False)