{"action":"created","issue":{"url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/31","repository_url":"https://api.github.com/repos/NYCPlanning/db-housing","labels_url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/31/comments","events_url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/31/events","html_url":"https://github.com/NYCPlanning/db-housing/issues/31","id":349167352,"node_id":"MDU6SXNzdWUzNDkxNjczNTI=","number":31,"title":"Negative 2018 Unit change Numbers","user":{"login":"BillS85","id":40032653,"node_id":"MDQ6VXNlcjQwMDMyNjUz","avatar_url":"https://avatars2.githubusercontent.com/u/40032653?v=4","gravatar_id":"","url":"https://api.github.com/users/BillS85","html_url":"https://github.com/BillS85","followers_url":"https://api.github.com/users/BillS85/followers","following_url":"https://api.github.com/users/BillS85/following{/other_user}","gists_url":"https://api.github.com/users/BillS85/gists{/gist_id}","starred_url":"https://api.github.com/users/BillS85/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BillS85/subscriptions","organizations_url":"https://api.github.com/users/BillS85/orgs","repos_url":"https://api.github.com/users/BillS85/repos","events_url":"https://api.github.com/users/BillS85/events{/privacy}","received_events_url":"https://api.github.com/users/BillS85/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-09T15:01:32Z","updated_at":"2018-08-09T20:36:59Z","closed_at":null,"author_association":"NONE","body":"Negative 2018 unit change counts totaled -9,955. Something is amiss here.\r\nAlso Checked the residential units issued permit in 2018 to the end of July and it differs by 300 units from the tally I keep on a monthly basis. So that is good."},"comment":{"url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/comments/411888726","html_url":"https://github.com/NYCPlanning/db-housing/issues/31#issuecomment-411888726","issue_url":"https://api.github.com/repos/NYCPlanning/db-housing/issues/31","id":411888726,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMTg4ODcyNg==","user":{"login":"AmandaDoyle","id":5611960,"node_id":"MDQ6VXNlcjU2MTE5NjA=","avatar_url":"https://avatars1.githubusercontent.com/u/5611960?v=4","gravatar_id":"","url":"https://api.github.com/users/AmandaDoyle","html_url":"https://github.com/AmandaDoyle","followers_url":"https://api.github.com/users/AmandaDoyle/followers","following_url":"https://api.github.com/users/AmandaDoyle/following{/other_user}","gists_url":"https://api.github.com/users/AmandaDoyle/gists{/gist_id}","starred_url":"https://api.github.com/users/AmandaDoyle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmandaDoyle/subscriptions","organizations_url":"https://api.github.com/users/AmandaDoyle/orgs","repos_url":"https://api.github.com/users/AmandaDoyle/repos","events_url":"https://api.github.com/users/AmandaDoyle/events{/privacy}","received_events_url":"https://api.github.com/users/AmandaDoyle/received_events","type":"User","site_admin":false},"created_at":"2018-08-09T20:36:59Z","updated_at":"2018-08-09T20:36:59Z","author_association":"MEMBER","body":"unit_change_2018 is u_2018_existtota - u_2017_existtotal (cofoincrem.sql) \r\n\r\nWhen I do SELECT SUM(unit_change_2018::numeric) FROM housing; I get 10309 units\r\n\r\nAlso note that only 1/2 of 2018 is reported, (Jan to June) so a full year of units is not accounted for"}}
{"actor":{"display_login":"AmandaDoyle"}}