{"action":"created","issue":{"url":"https://api.github.com/repos/feomike/slope/issues/2","labels_url":"https://api.github.com/repos/feomike/slope/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/feomike/slope/issues/2/comments","events_url":"https://api.github.com/repos/feomike/slope/issues/2/events","html_url":"https://github.com/feomike/slope/issues/2","id":123585864,"number":2,"title":"load data","user":{"login":"feomike","id":1706858,"avatar_url":"https://avatars.githubusercontent.com/u/1706858?v=3","gravatar_id":"","url":"https://api.github.com/users/feomike","html_url":"https://github.com/feomike","followers_url":"https://api.github.com/users/feomike/followers","following_url":"https://api.github.com/users/feomike/following{/other_user}","gists_url":"https://api.github.com/users/feomike/gists{/gist_id}","starred_url":"https://api.github.com/users/feomike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/feomike/subscriptions","organizations_url":"https://api.github.com/users/feomike/orgs","repos_url":"https://api.github.com/users/feomike/repos","events_url":"https://api.github.com/users/feomike/events{/privacy}","received_events_url":"https://api.github.com/users/feomike/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-23T01:34:30Z","updated_at":"2015-12-24T04:42:04Z","closed_at":null,"body":"load all data into postgress"},"comment":{"url":"https://api.github.com/repos/feomike/slope/issues/comments/167041604","html_url":"https://github.com/feomike/slope/issues/2#issuecomment-167041604","issue_url":"https://api.github.com/repos/feomike/slope/issues/2","id":167041604,"user":{"login":"feomike","id":1706858,"avatar_url":"https://avatars.githubusercontent.com/u/1706858?v=3","gravatar_id":"","url":"https://api.github.com/users/feomike","html_url":"https://github.com/feomike","followers_url":"https://api.github.com/users/feomike/followers","following_url":"https://api.github.com/users/feomike/following{/other_user}","gists_url":"https://api.github.com/users/feomike/gists{/gist_id}","starred_url":"https://api.github.com/users/feomike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/feomike/subscriptions","organizations_url":"https://api.github.com/users/feomike/orgs","repos_url":"https://api.github.com/users/feomike/repos","events_url":"https://api.github.com/users/feomike/events{/privacy}","received_events_url":"https://api.github.com/users/feomike/received_events","type":"User","site_admin":false},"created_at":"2015-12-24T04:42:04Z","updated_at":"2015-12-24T04:42:04Z","body":"Transmittal Sheet Update\r\nall TS data from 1990-2014 is loaded in Postgres (script forthcoming).  there where some issues\r\n* 2004 and 2005 had non UTF-8 issues.  they were easy to solve by opening the file in textwrangler and re-openning as utf-8 and saving.\r\n* 1992 and 1993 download files are totally hosed; had 100% binary characters in them.  I downloaded and used the 1992 and 1993 ultimate files in their stead, which did work\r\n* 1990 and 1991 had sporadic non-utf-8 characters which couldn't be solved with re-openning and saving the file as utf-8 compatable.  i had to hand edit an search for issues\r\n\r\n"}}