It’d be better to only include non-HTTPS entries when an HTTPS entry doesn’t also exist: $ sqlite3 places.sqlite 'select url from moz_places' | python3 -c '

It’d be better to only include non-HTTPS entries when an HTTPS entry doesn’t also exist: $ sqlite3 places.sqlite 'select url from moz_places' | python3 -c ' import sys, urllib.parse v = [urllib.parse.urlparse(l) for l in sys.stdin] secure = {u.hostname for u in v if u.scheme == "https"} insecure = {u.hostname for u in v if u.scheme == "http"} print(len(insecure - secure), len(secure))' 430 1124 Even this will miss places you haven’t visited in a while that have since added security, though.