Mac OS: get chrome history as CSV

gistfile1.txt

/* Note: Turn Chrome 'off' first */

cd /Users/{{USER}}/Library/Application\ Support/Google/Chrome/Default && sqlite3 History

sqlite> .mode csv
sqlite> .ouput chrome_history.csv
sqlite> select url from urls;
sqlite> .ouput stdout

cat chrome_history.csv 

| OR V

sqlite> .mode csv
sqlite> .ouput chrome_history.csv
sqlite> select urls.id, urls.url, urls.title, urls.visit_count, urls.typed_count, urls.last_visit_time, urls.hidden, urls.favicon_id, visits.visit_time, visits.from_visit, visits.visit_duration, visits.transition, visit_source.source FROM urls JOIN visits ON urls.id = visits.url LEFT JOIN visit_source ON visits.id = visit_source.id
sqlite> .ouput stdout

a=/tmp/history-$RANDOM; \cp /Users/$USER/Library/Application\ Support/Google/Chrome/Default/History $a && sqlite3 -csv $a 'select urls.id, urls.url, urls.title, urls.visit_count, urls.typed_count, urls.last_visit_time, urls.hidden, urls.favicon_id, visits.visit_time, visits.from_visit, visits.visit_duration, visits.transition, visit_source.source FROM urls JOIN visits ON urls.id = visits.url LEFT JOIN visit_source ON visits.id = visit_source.id;' | grep google | grep search | grep -o 'q=[a-z0-9A-Z\+]+' | sort -u && rm $a && unset a

sqlite3 -list /Users/$USERNAME/Library/Application\ Support/Google/Chrome/Default/History "select url from urls;" | grep -u UTF-8#q= | sed "s/^.*UTF-8#q=//p" | sed s/&es_th=1/\ /g | sed s/%../\ /g | sed s/+/\ /g