Skip to content

Instantly share code, notes, and snippets.

@joereddington

joereddington/export_history

Created November 7, 2018 11:53
Show Gist options
  • Save joereddington/5b3111a26a7748db5bf42f321f683bcd to your computer and use it in GitHub Desktop.
Save joereddington/5b3111a26a7748db5bf42f321f683bcd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
export_history
.headers on
.mode csv
.output data.csv
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment