{"comment":{"url":"https://api.github.com/repos/srajeev1/607Project3/comments/10299849","html_url":"https://github.com/srajeev1/607Project3/commit/7942d89f8810a8b198844c17e5f35f9e1751919a#commitcomment-10299849","id":10299849,"user":{"login":"simonnyc","id":10787891,"avatar_url":"https://avatars.githubusercontent.com/u/10787891?v=3","gravatar_id":"","url":"https://api.github.com/users/simonnyc","html_url":"https://github.com/simonnyc","followers_url":"https://api.github.com/users/simonnyc/followers","following_url":"https://api.github.com/users/simonnyc/following{/other_user}","gists_url":"https://api.github.com/users/simonnyc/gists{/gist_id}","starred_url":"https://api.github.com/users/simonnyc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonnyc/subscriptions","organizations_url":"https://api.github.com/users/simonnyc/orgs","repos_url":"https://api.github.com/users/simonnyc/repos","events_url":"https://api.github.com/users/simonnyc/events{/privacy}","received_events_url":"https://api.github.com/users/simonnyc/received_events","type":"User","site_admin":false},"position":null,"line":null,"path":"","commit_id":"7942d89f8810a8b198844c17e5f35f9e1751919a","created_at":"2015-03-20T05:21:53Z","updated_at":"2015-03-20T05:21:53Z","body":"Hi everyone,\njust an update.. \ni was able to load all the data set 10137 rows.  i had to change the encoding   to LATIN1 and explicitly provide column names.. i used the below command. i will post it in trello tomorrow as well. hopefully now we clean it even further.. \n\n\nCOPY academy( Year,Category,Nominee, AdditionalInfo ,Results)  FROM 'c:\\CUNY\\acaw.csv' with DELIMITER ',' encoding 'LATIN1' HEADER CSV;\n\nMohamed \n\n\n\n \n\n\n     On Thursday, March 19, 2015 2:36 AM, jameyletherton <notifications@github.com> wrote:\n   \n\n jameyletherton—\nReply to this email directly or view it on GitHub.   \n\n  "}}