{"action":"created","issue":{"url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/36","repository_url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal","labels_url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/36/comments","events_url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/36/events","html_url":"https://github.com/Code4Nepal/nepalmap_federal/issues/36","id":386586235,"node_id":"MDU6SXNzdWUzODY1ODYyMzU=","number":36,"title":"Add population data missing for locality in Province 4","user":{"login":"cliftonmcintosh","id":3824492,"node_id":"MDQ6VXNlcjM4MjQ0OTI=","avatar_url":"https://avatars1.githubusercontent.com/u/3824492?v=4","gravatar_id":"","url":"https://api.github.com/users/cliftonmcintosh","html_url":"https://github.com/cliftonmcintosh","followers_url":"https://api.github.com/users/cliftonmcintosh/followers","following_url":"https://api.github.com/users/cliftonmcintosh/following{/other_user}","gists_url":"https://api.github.com/users/cliftonmcintosh/gists{/gist_id}","starred_url":"https://api.github.com/users/cliftonmcintosh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cliftonmcintosh/subscriptions","organizations_url":"https://api.github.com/users/cliftonmcintosh/orgs","repos_url":"https://api.github.com/users/cliftonmcintosh/repos","events_url":"https://api.github.com/users/cliftonmcintosh/events{/privacy}","received_events_url":"https://api.github.com/users/cliftonmcintosh/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-02T18:35:34Z","updated_at":"2018-12-18T13:43:19Z","closed_at":"2018-12-18T13:43:19Z","author_association":"MEMBER","body":"Our data set for population is missing data for one locality in Province 4. The data are available in our \"Federal Data\" in https://github.com/Code4Nepal/data/.\r\n\r\nAdd the data to the [population.sql](https://github.com/Code4Nepal/nepalmap_federal/blob/dev/sql/population.sql) file.  Please put the data in a logical place -- so that all data for the same district are in rows next to each other. That will make it easier to review in the future.\r\n\r\n- When you add them, you will add one row for female population and another row for male population. See the current file for examples.\r\n- You will need to update the totals for the district for that locality to include these additional data.\r\n- You will need to update the totals for Province 4 to include these additional data.\r\n- You will need to update the totals for Nepal to include these additional data.\r\n\r\nHere are the localities whose data are currently missing.\r\n\r\n | geo_level | geo_code |                name                 |   parent_name    | parent_level | parent_code |\r\n-----------|----------|-------------------------------------|------------------|--------------|-------------\r\n local     | 39008    | Kaligandagi                         | Syangja          | district     | 71\r\n\r\n- \"Kaligandagi\" in \"Syangja\" is \"Kaligandaki Gaunpalika\" in the federal population data: https://github.com/Code4Nepal/data/blob/master/Federal%20Data/753%20Local%20Unit%20Population%20and%20HouseHold/PRADESH%204/Syangja/Kaligandaki%20Gaunpalika.csv\r\n"},"comment":{"url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/comments/448225019","html_url":"https://github.com/Code4Nepal/nepalmap_federal/issues/36#issuecomment-448225019","issue_url":"https://api.github.com/repos/Code4Nepal/nepalmap_federal/issues/36","id":448225019,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODIyNTAxOQ==","user":{"login":"cliftonmcintosh","id":3824492,"node_id":"MDQ6VXNlcjM4MjQ0OTI=","avatar_url":"https://avatars1.githubusercontent.com/u/3824492?v=4","gravatar_id":"","url":"https://api.github.com/users/cliftonmcintosh","html_url":"https://github.com/cliftonmcintosh","followers_url":"https://api.github.com/users/cliftonmcintosh/followers","following_url":"https://api.github.com/users/cliftonmcintosh/following{/other_user}","gists_url":"https://api.github.com/users/cliftonmcintosh/gists{/gist_id}","starred_url":"https://api.github.com/users/cliftonmcintosh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cliftonmcintosh/subscriptions","organizations_url":"https://api.github.com/users/cliftonmcintosh/orgs","repos_url":"https://api.github.com/users/cliftonmcintosh/repos","events_url":"https://api.github.com/users/cliftonmcintosh/events{/privacy}","received_events_url":"https://api.github.com/users/cliftonmcintosh/received_events","type":"User","site_admin":false},"created_at":"2018-12-18T13:43:19Z","updated_at":"2018-12-18T13:43:19Z","author_association":"MEMBER","body":"fixed with #45 "}}
{"actor":{"display_login":"cliftonmcintosh"}}