{"blog_url":"https://walkingmask.hatenablog.com/","blog_title":"walkingmask\u2019s development log","width":"100%","url":"https://walkingmask.hatenablog.com/entry/2019/03/03/100525","version":"1.0","author_url":"https://blog.hatena.ne.jp/walkingmask/","title":"Google Chrome \u306e\u5c65\u6b74\u3092 csv \u3067\u51fa\u529b\u3059\u308b","published":"2019-03-03 10:05:25","categories":[],"height":"190","type":"rich","description":"\u6563\u3005\u65e2\u51fa\u3067\u3059\u304c\u3001\u81ea\u5206\u7528\u30e1\u30e2\u3002 \u62e1\u5f35\u6a5f\u80fd\u306f\u4e0d\u8981\u3067\u3001\u5b9f\u884c\u74b0\u5883\u306fmacOS\u3001sqlite3\u3092\u4f7f\u3044\u307e\u3059\u3002 \u4ee5\u4e0b\u3001\u624b\u9806\u3002 cp ~/Library/Application\\ Support/Google/Chrome/Default/History ~/Desktop/ sqlite3 ~/Desktop/History \u4ee5\u4e0b\u3092\u5b9f\u884c .mode csv .output chrome-history.csv SELECT datetime(last_visit_time/1000000-11644473600, \"unixepoch\", \"+9 hours\") as last_visited, url, \u2026","image_url":null,"author_name":"walkingmask","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwalkingmask.hatenablog.com%2Fentry%2F2019%2F03%2F03%2F100525\" title=\"Google Chrome \u306e\u5c65\u6b74\u3092 csv \u3067\u51fa\u529b\u3059\u308b - walkingmask\u2019s development log\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog"}