{"categories":["AWS"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/yohei-a/20200704/20200704175055.png","blog_title":"ablog","title":"Amazon QuickSight \u3067 S3 \u306e\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20200704%2F1593852322\" title=\"Amazon QuickSight \u3067 S3 \u306e\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316 - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","description":"Amazon QuickSight \u3067 S3 \u306e\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3057\u3066\u307f\u305f\u3002 \u30c7\u30fc\u30bf\u306e\u6e96\u5099 \u4f4f\u6240\u30c7\u30fc\u30bfCSV\u3010\u4f4f\u6240.jp\u3011 \u304b\u3089 csv_zenkoku.zip \u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3002 \u89e3\u51cd\u3057\u3066\u3001UTF8 \u306b\u5909\u63db\u3059\u308b\uff08macOS\uff09\u3002 $ brew install nkf $ unzip csv_26kyouto.zip $ nkf -Lw zenkoku.csv > zenkoku-utf8.csv $ file zenkoku-utf8.csv zenkoku-utf8.csv: UTF-8 Unicode text, with CRLF line terminators e$ head -3 z\u2026","author_url":"https://blog.hatena.ne.jp/yohei-a/","provider_name":"Hatena Blog","blog_url":"https://yohei-a.hatenablog.jp/","url":"https://yohei-a.hatenablog.jp/entry/20200704/1593852322","version":"1.0","published":"2020-07-04 17:45:22","height":"190","provider_url":"https://hatena.blog","author_name":"yohei-a"}