{"action":"created","issue":{"url":"https://api.github.com/repos/devinit/digital-platform/issues/243","labels_url":"https://api.github.com/repos/devinit/digital-platform/issues/243/labels{/name}","comments_url":"https://api.github.com/repos/devinit/digital-platform/issues/243/comments","events_url":"https://api.github.com/repos/devinit/digital-platform/issues/243/events","html_url":"https://github.com/devinit/digital-platform/issues/243","id":128715928,"number":243,"title":"Data Warehouse check","user":{"login":"xriss","id":3142388,"avatar_url":"https://avatars.githubusercontent.com/u/3142388?v=3","gravatar_id":"","url":"https://api.github.com/users/xriss","html_url":"https://github.com/xriss","followers_url":"https://api.github.com/users/xriss/followers","following_url":"https://api.github.com/users/xriss/following{/other_user}","gists_url":"https://api.github.com/users/xriss/gists{/gist_id}","starred_url":"https://api.github.com/users/xriss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xriss/subscriptions","organizations_url":"https://api.github.com/users/xriss/orgs","repos_url":"https://api.github.com/users/xriss/repos","events_url":"https://api.github.com/users/xriss/events{/privacy}","received_events_url":"https://api.github.com/users/xriss/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dw8547","id":10259585,"avatar_url":"https://avatars.githubusercontent.com/u/10259585?v=3","gravatar_id":"","url":"https://api.github.com/users/dw8547","html_url":"https://github.com/dw8547","followers_url":"https://api.github.com/users/dw8547/followers","following_url":"https://api.github.com/users/dw8547/following{/other_user}","gists_url":"https://api.github.com/users/dw8547/gists{/gist_id}","starred_url":"https://api.github.com/users/dw8547/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dw8547/subscriptions","organizations_url":"https://api.github.com/users/dw8547/orgs","repos_url":"https://api.github.com/users/dw8547/repos","events_url":"https://api.github.com/users/dw8547/events{/privacy}","received_events_url":"https://api.github.com/users/dw8547/received_events","type":"User","site_admin":false},"milestone":null,"comments":11,"created_at":"2016-01-26T03:49:03Z","updated_at":"2016-01-28T15:29:20Z","closed_at":null,"body":"I've added a warehouse branch containing data that has been imported from Data Warehouse as a test. Please check that they are ok.\r\n\r\nhttps://github.com/devinit/digital-platform/tree/warehouse\r\n\r\nMostly I think the import has had a slight cosmetic effect on the format of the CSV files, ie numerical formats or use of quotes or line endings.\r\n\r\nThe most important part of the CSV files are the header names so double check that these are still the same.\r\n\r\nNote that not all files have been imported, for instance I've ignored all files under the reference directory and the following files have not been changed as I'm not sure where to get the data from.\r\n\r\ncountry-year/adult-literacy\r\ncountry-year/domestic-netlending\r\ncountry-year/education-pc-transferred-oda\r\ncountry-year/employment-agriculture\r\ncountry-year/employment-by-sector\r\ncountry-year/employment-industry\r\ncountry-year/employment-services\r\ncountry-year/gdp-current-ncu-fy\r\ncountry-year/gdp-growth\r\ncountry-year/gdp-pc-usd-2005\r\ncountry-year/gdp-pc-usd-current\r\ncountry-year/gdp-usd-2005\r\ncountry-year/gdp-usd-2012\r\ncountry-year/gni-usd-2005\r\ncountry-year/govtspend-USD\r\ncountry-year/health-pc-transferred-oda\r\ncountry-year/income-share-top-10pc\r\ncountry-year/infant-mortality\r\ncountry-year/in-oda-and-repayments\r\ncountry-year/in-oof-and-repayments\r\ncountry-year/in-oof-net\r\ncountry-year/intl-flows-donors-wide\r\ncountry-year/intl-flows-recipients-wide\r\ncountry-year/kenya-electricity-avg\r\ncountry-year/kenya-electricity-rank\r\ncountry-year/kenya-improved-sani-avg\r\ncountry-year/kenya-improved-sani-rank\r\ncountry-year/kenya-improved-water-avg\r\ncountry-year/kenya-improved-water-rank\r\ncountry-year/kenya-paved-roads-avg\r\ncountry-year/kenya-paved-roads-rank\r\ncountry-year/kenya-pov-avg\r\ncountry-year/kenya-pov-rank\r\ncountry-year/kenya-urban-avg\r\ncountry-year/kenya-urban-rank\r\ncountry-year/long-term-debt\r\ncountry-year/mean-years-of-schooling\r\ncountry-year/non-grant-revenue-PPP-capita\r\ncountry-year/oda\r\ncountry-year/oda-donor/oda-AE\r\ncountry-year/oda-donor/oda-afdb\r\ncountry-year/oda-donor/oda-afdf\r\ncountry-year/oda-donor/oda-afesd\r\ncountry-year/oda-donor/oda-arab-fund-afesd\r\ncountry-year/oda-donor/oda-asdb-special-funds\r\ncountry-year/oda-donor/oda-AT\r\ncountry-year/oda-donor/oda-AU\r\ncountry-year/oda-donor/oda-badea\r\ncountry-year/oda-donor/oda-BE\r\ncountry-year/oda-donor/oda-CA\r\ncountry-year/oda-donor/oda-CH\r\ncountry-year/oda-donor/oda-CZ\r\ncountry-year/oda-donor/oda-DE\r\ncountry-year/oda-donor/oda-DK\r\ncountry-year/oda-donor/oda-ebrd\r\ncountry-year/oda-donor/oda-EE\r\ncountry-year/oda-donor/oda-ES\r\ncountry-year/oda-donor/oda-EU\r\ncountry-year/oda-donor/oda-FI\r\ncountry-year/oda-donor/oda-FR\r\ncountry-year/oda-donor/oda-gavi\r\ncountry-year/oda-donor/oda-GB\r\ncountry-year/oda-donor/oda-gef\r\ncountry-year/oda-donor/oda-global-fund\r\ncountry-year/oda-donor/oda-GR\r\ncountry-year/oda-donor/oda-ibrd\r\ncountry-year/oda-donor/oda-ida\r\ncountry-year/oda-donor/oda-idb-specialfund\r\ncountry-year/oda-donor/oda-IE\r\ncountry-year/oda-donor/oda-ifad\r\ncountry-year/oda-donor/oda-imf\r\ncountry-year/oda-donor/oda-imf-concessional-trust-fund\r\ncountry-year/oda-donor/oda-IS\r\ncountry-year/oda-donor/oda-islamic-dev-bank\r\ncountry-year/oda-donor/oda-IT\r\ncountry-year/oda-donor/oda-JP\r\ncountry-year/oda-donor/oda-KR\r\ncountry-year/oda-donor/oda-KW\r\ncountry-year/oda-donor/oda-LU\r\ncountry-year/oda-donor/oda-NL\r\ncountry-year/oda-donor/oda-NO\r\ncountry-year/oda-donor/oda-nordic-dev-fund\r\ncountry-year/oda-donor/oda-NZ\r\ncountry-year/oda-donor/oda-ofid\r\ncountry-year/oda-donor/oda-osce\r\ncountry-year/oda-donor/oda-PL\r\ncountry-year/oda-donor/oda-PT\r\ncountry-year/oda-donor/oda-SE\r\ncountry-year/oda-donor/oda-SI\r\ncountry-year/oda-donor/oda-SK\r\ncountry-year/oda-donor/oda-unaids\r\ncountry-year/oda-donor/oda-undp\r\ncountry-year/oda-donor/oda-unece\r\ncountry-year/oda-donor/oda-unfpa\r\ncountry-year/oda-donor/oda-unhcr\r\ncountry-year/oda-donor/oda-unicef\r\ncountry-year/oda-donor/oda-unpbf\r\ncountry-year/oda-donor/oda-unrwa\r\ncountry-year/oda-donor/oda-US\r\ncountry-year/oda-donor/oda-wfp\r\ncountry-year/oda-donor/oda-who\r\ncountry-year/out-oda-and-repayments\r\ncountry-year/out-oda-gross\r\ncountry-year/out-oof-and-repayments\r\ncountry-year/out-oof-gross\r\ncountry-year/poorest20pct-percentages\r\ncountry-year/population-0-14\r\ncountry-year/population-15-64\r\ncountry-year/population-65-\r\ncountry-year/poverty-gap-125\r\ncountry-year/poverty-gap-2\r\ncountry-year/primary-school-enrolment\r\ncountry-year/taxrev-pctGDP\r\ncountry-year/total-employment\r\ncountry-year/total-revenue-pct-GDP\r\ncountry-year/total-revenue-PPP-capita\r\ncountry-year/under-5-mortality\r\ncountry-year/university-college-enrolment\r\ncountry-year/youth-literacy\r\ncountry-year/youth-unemployment\r\n"},"comment":{"url":"https://api.github.com/repos/devinit/digital-platform/issues/comments/176236596","html_url":"https://github.com/devinit/digital-platform/issues/243#issuecomment-176236596","issue_url":"https://api.github.com/repos/devinit/digital-platform/issues/243","id":176236596,"user":{"login":"dw8547","id":10259585,"avatar_url":"https://avatars.githubusercontent.com/u/10259585?v=3","gravatar_id":"","url":"https://api.github.com/users/dw8547","html_url":"https://github.com/dw8547","followers_url":"https://api.github.com/users/dw8547/followers","following_url":"https://api.github.com/users/dw8547/following{/other_user}","gists_url":"https://api.github.com/users/dw8547/gists{/gist_id}","starred_url":"https://api.github.com/users/dw8547/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dw8547/subscriptions","organizations_url":"https://api.github.com/users/dw8547/orgs","repos_url":"https://api.github.com/users/dw8547/repos","events_url":"https://api.github.com/users/dw8547/events{/privacy}","received_events_url":"https://api.github.com/users/dw8547/received_events","type":"User","site_admin":false},"created_at":"2016-01-28T15:29:20Z","updated_at":"2016-01-28T15:29:20Z","body":"This is a space holder comment for @robtew to OK the channel."}}