import sqlite3

conn = sqlite3.connect('sample.db')
cur = conn.cursor()

# データの抽出
sql = """SELECT id, name
  FROM personal"""

data = cur.execute(sql)

list = data.fetchall()
for row in list:
  print(row)

conn.close()