{"action":"closed","issue":{"url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/issues/28","repository_url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto","labels_url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/issues/28/comments","events_url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/issues/28/events","html_url":"https://github.com/CityOfPhiladelphia/soda-carto/issues/28","id":206775461,"number":28,"title":"Verify CSV encoding","user":{"login":"timwis","id":761444,"avatar_url":"https://avatars.githubusercontent.com/u/761444?v=3","gravatar_id":"","url":"https://api.github.com/users/timwis","html_url":"https://github.com/timwis","followers_url":"https://api.github.com/users/timwis/followers","following_url":"https://api.github.com/users/timwis/following{/other_user}","gists_url":"https://api.github.com/users/timwis/gists{/gist_id}","starred_url":"https://api.github.com/users/timwis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timwis/subscriptions","organizations_url":"https://api.github.com/users/timwis/orgs","repos_url":"https://api.github.com/users/timwis/repos","events_url":"https://api.github.com/users/timwis/events{/privacy}","received_events_url":"https://api.github.com/users/timwis/received_events","type":"User","site_admin":false},"labels":[{"id":470787713,"url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/labels/help%20wanted","name":"help wanted","color":"128A0C","default":true}],"state":"closed","locked":false,"assignee":{"login":"andrewbt","id":2013555,"avatar_url":"https://avatars.githubusercontent.com/u/2013555?v=3","gravatar_id":"","url":"https://api.github.com/users/andrewbt","html_url":"https://github.com/andrewbt","followers_url":"https://api.github.com/users/andrewbt/followers","following_url":"https://api.github.com/users/andrewbt/following{/other_user}","gists_url":"https://api.github.com/users/andrewbt/gists{/gist_id}","starred_url":"https://api.github.com/users/andrewbt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrewbt/subscriptions","organizations_url":"https://api.github.com/users/andrewbt/orgs","repos_url":"https://api.github.com/users/andrewbt/repos","events_url":"https://api.github.com/users/andrewbt/events{/privacy}","received_events_url":"https://api.github.com/users/andrewbt/received_events","type":"User","site_admin":false},"assignees":[{"login":"andrewbt","id":2013555,"avatar_url":"https://avatars.githubusercontent.com/u/2013555?v=3","gravatar_id":"","url":"https://api.github.com/users/andrewbt","html_url":"https://github.com/andrewbt","followers_url":"https://api.github.com/users/andrewbt/followers","following_url":"https://api.github.com/users/andrewbt/following{/other_user}","gists_url":"https://api.github.com/users/andrewbt/gists{/gist_id}","starred_url":"https://api.github.com/users/andrewbt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrewbt/subscriptions","organizations_url":"https://api.github.com/users/andrewbt/orgs","repos_url":"https://api.github.com/users/andrewbt/repos","events_url":"https://api.github.com/users/andrewbt/events{/privacy}","received_events_url":"https://api.github.com/users/andrewbt/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/milestones/2","html_url":"https://github.com/CityOfPhiladelphia/soda-carto/milestone/2","labels_url":"https://api.github.com/repos/CityOfPhiladelphia/soda-carto/milestones/2/labels","id":2321470,"number":2,"title":"Go-live","description":"","creator":{"login":"timwis","id":761444,"avatar_url":"https://avatars.githubusercontent.com/u/761444?v=3","gravatar_id":"","url":"https://api.github.com/users/timwis","html_url":"https://github.com/timwis","followers_url":"https://api.github.com/users/timwis/followers","following_url":"https://api.github.com/users/timwis/following{/other_user}","gists_url":"https://api.github.com/users/timwis/gists{/gist_id}","starred_url":"https://api.github.com/users/timwis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timwis/subscriptions","organizations_url":"https://api.github.com/users/timwis/orgs","repos_url":"https://api.github.com/users/timwis/repos","events_url":"https://api.github.com/users/timwis/events{/privacy}","received_events_url":"https://api.github.com/users/timwis/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":1,"state":"open","created_at":"2017-02-14T11:12:28Z","updated_at":"2017-02-17T12:13:44Z","due_on":"2017-02-24T08:00:00Z","closed_at":null},"comments":0,"created_at":"2017-02-10T11:40:42Z","updated_at":"2017-02-17T12:13:44Z","closed_at":"2017-02-17T12:13:44Z","body":"I downloaded a CSV and got an error about its encoding when trying to open it in `csvlook`:\r\n\r\n```\r\n'ascii' codec can't encode character u'\\u2026' in position 247: ordinal not in range(128)\r\n```\r\nNeed to try the same thing directly against the carto data to find out if the proxy is changing the character encoding or something\r\n\r\nEDIT: verified that same thing happens when downloading from carto directly ([example query](http://phl.carto.com/api/v2/sql?q=SELECT%20*,%20ST_AsText(the_geom)%20AS%20the_geom%20FROM%20%22incidents_part1_part2%22%20LIMIT%2010))\r\n\r\n\r\nI'm lost on this one. Not sure it's carto's fault, maybe it's csvkit's fault?? Looks like a common python error. @andrewbt maybe you're more familiar with it? I'm using it via\r\n\r\n```bash\r\ncsvlook incidents.csv | less -S\r\n```\r\n"}}
{"actor":{"display_login":"timwis"}}