{"action":"created","issue":{"url":"https://api.github.com/repos/jsoma/playfair-projects/issues/75","repository_url":"https://api.github.com/repos/jsoma/playfair-projects","labels_url":"https://api.github.com/repos/jsoma/playfair-projects/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/jsoma/playfair-projects/issues/75/comments","events_url":"https://api.github.com/repos/jsoma/playfair-projects/issues/75/events","html_url":"https://github.com/jsoma/playfair-projects/issues/75","id":168468015,"number":75,"title":"Pensioners vs refugees","user":{"login":"gcgruen","id":7279358,"avatar_url":"https://avatars.githubusercontent.com/u/7279358?v=3","gravatar_id":"","url":"https://api.github.com/users/gcgruen","html_url":"https://github.com/gcgruen","followers_url":"https://api.github.com/users/gcgruen/followers","following_url":"https://api.github.com/users/gcgruen/following{/other_user}","gists_url":"https://api.github.com/users/gcgruen/gists{/gist_id}","starred_url":"https://api.github.com/users/gcgruen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gcgruen/subscriptions","organizations_url":"https://api.github.com/users/gcgruen/orgs","repos_url":"https://api.github.com/users/gcgruen/repos","events_url":"https://api.github.com/users/gcgruen/events{/privacy}","received_events_url":"https://api.github.com/users/gcgruen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jsoma/playfair-projects/labels/Project%203","name":"Project 3","color":"f1b98d"},{"url":"https://api.github.com/repos/jsoma/playfair-projects/labels/Request:%20Data","name":"Request: Data","color":"f9d0c4"},{"url":"https://api.github.com/repos/jsoma/playfair-projects/labels/Type:%20Pitch","name":"Type: Pitch","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-07-30T13:45:48Z","updated_at":"2016-08-03T00:20:40Z","closed_at":null,"body":"\"There's lots of money for refugees, but only few for pensioners and families.\" is one of the arguments of xenophobic people in Germany. \r\nI would like to know whether that's actually true and dive into government expenditures on these areas.\r\n* [Absolute + per capita] government expenditures for refugees/pensioners/social benefit recipients\r\n* Breakdown to one person: How much does a refugee/pensioner/social benefit recipient get?\r\n\r\nOn a first glimpse it looks like as if there's no data evidence for the claim made at the beginning:\r\nRoughly 4 billion dollar are spend on refugees, vs 93 billion for pensioners and 34 billion for social benefits, 7 billion for family support.\r\n\r\nOn a recipient perspective breakdown, a social benefit recipient receives 399 euros per month, a refugee 130 euros.\r\n\r\n**Data source** \r\n[German government](https://www.bundeshaushalt-info.de/#/2016/soll/ausgaben/einzelplan/0603.html)\r\n\r\n**Clip search**\r\nAs far as I can see this has not been done before by German media as a visual yet. \r\nThere's a long story about by-federal-state breakdown [by Die Welt](http://www.welt.de/wirtschaft/article154060168/Ob-Bayern-oder-Bremen-ist-fuer-Fluechtlinge-ein-grosser-Unterschied.html), just listing numbers, not making any charts.\r\n\r\nAnd there's another story by Zeit Online, including a [card game (cards 15, 17 and 18)](http://www.zeit.de/politik/deutschland/2015-09/fluechtlingshilfe-deutschland-massnahmen-sozialneid-kommunen), that highlights this topic but doesn't really cover it visually either.\r\n\r\n**Headline suggestions**\r\n* Xenophobic arguments debunked\r\n* No need for social envy towards refugees\r\n* ...\r\n\r\n## Thoughts/Questions:\r\nMaybe there's a reason why media hasn't done it yet: Could be that data is too little/too uninteresting (just boring bar charts?) I'd appreciate any input on how to enlarge the dataset investigated or in what direction to extend this. Or whether it would be better to come up with a new pitch?\r\n\r\n## Pitch issue checklist\r\n- [x] My pitch issue has `[Pitch]` in the title\r\n- [x] My pitch issue has `[Data request]` in the title if I need additional data\r\n- [x] My pitch issue links to my data set\r\n- [x] My pitch issue explains what I'd like to explore in the data set\r\n- [x] My pitch issue includes multiple possible headlines\r\n- [x] My pitch issue includes appropriate labels in the title such as `[Pitch]` and maybe `[Data Request]`\r\n- [x] I have received two comments of peer feedback on my pitch issue\r\n- [x] I have received editorial feedback on my pitch issue\r\n- [x] My pitch has been approved"},"comment":{"url":"https://api.github.com/repos/jsoma/playfair-projects/issues/comments/237091712","html_url":"https://github.com/jsoma/playfair-projects/issues/75#issuecomment-237091712","issue_url":"https://api.github.com/repos/jsoma/playfair-projects/issues/75","id":237091712,"user":{"login":"gcgruen","id":7279358,"avatar_url":"https://avatars.githubusercontent.com/u/7279358?v=3","gravatar_id":"","url":"https://api.github.com/users/gcgruen","html_url":"https://github.com/gcgruen","followers_url":"https://api.github.com/users/gcgruen/followers","following_url":"https://api.github.com/users/gcgruen/following{/other_user}","gists_url":"https://api.github.com/users/gcgruen/gists{/gist_id}","starred_url":"https://api.github.com/users/gcgruen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gcgruen/subscriptions","organizations_url":"https://api.github.com/users/gcgruen/orgs","repos_url":"https://api.github.com/users/gcgruen/repos","events_url":"https://api.github.com/users/gcgruen/events{/privacy}","received_events_url":"https://api.github.com/users/gcgruen/received_events","type":"User","site_admin":false},"created_at":"2016-08-03T00:20:40Z","updated_at":"2016-08-03T00:20:40Z","body":"# Proof of viability\r\nCollected the first data for Germany from around the net.\r\nIt's inaccurate and pretty coarse. Given the large differences, it's still okay, though.\r\n\r\nThese are just to show that there's a story in there that could be visualized. \r\nGraphics not yet beautified (only boring matplotlib) and not complete -- more to come until next week in the story issue.\r\n\r\n![benefits-fd-gov-spendings-bar](https://cloud.githubusercontent.com/assets/7279358/17349715/18091e50-58ee-11e6-9f5a-7a832a0f2314.png)\r\n\r\nBetter as a pie? Not really, right?\r\n![benefits-fd-gov-spendings](https://cloud.githubusercontent.com/assets/7279358/17349729/2a48a59a-58ee-11e6-9106-18a26fd88b5a.png)\r\n\r\nThe above are in absolute terms. Below in relation to the number of pensioners/social benefit recipients/refugees.\r\n\r\n![benefits-fd-gov-pcspendings](https://cloud.githubusercontent.com/assets/7279358/17349758/7b566832-58ee-11e6-89d5-31561e4654e9.png)\r\n\r\nAll data for Germany, 2016.\r\n\r\nI'm a bit afraid this will be a endlessly boring collection of bar graphs whose variation is based on whether it's horizontal or vertical....\r\n\r\n\r\n"}}
{"actor":{"display_login":"gcgruen"}}