{"action":"created","issue":{"url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/329","repository_url":"https://api.github.com/repos/os-data/eu-structural-funds","labels_url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/329/labels{/name}","comments_url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/329/comments","events_url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/329/events","html_url":"https://github.com/os-data/eu-structural-funds/issues/329","id":193341452,"number":329,"title":"Sweden 2007-2013 `member_state_amount` contains 3 pieces of information","user":{"login":"cyberbikepunk","id":1629834,"avatar_url":"https://avatars.githubusercontent.com/u/1629834?v=3","gravatar_id":"","url":"https://api.github.com/users/cyberbikepunk","html_url":"https://github.com/cyberbikepunk","followers_url":"https://api.github.com/users/cyberbikepunk/followers","following_url":"https://api.github.com/users/cyberbikepunk/following{/other_user}","gists_url":"https://api.github.com/users/cyberbikepunk/gists{/gist_id}","starred_url":"https://api.github.com/users/cyberbikepunk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cyberbikepunk/subscriptions","organizations_url":"https://api.github.com/users/cyberbikepunk/orgs","repos_url":"https://api.github.com/users/cyberbikepunk/repos","events_url":"https://api.github.com/users/cyberbikepunk/events{/privacy}","received_events_url":"https://api.github.com/users/cyberbikepunk/received_events","type":"User","site_admin":false},"labels":[{"id":494104597,"url":"https://api.github.com/repos/os-data/eu-structural-funds/labels/mapping","name":"mapping","color":"bfd4f2","default":false}],"state":"open","locked":false,"assignee":{"login":"cyberbikepunk","id":1629834,"avatar_url":"https://avatars.githubusercontent.com/u/1629834?v=3","gravatar_id":"","url":"https://api.github.com/users/cyberbikepunk","html_url":"https://github.com/cyberbikepunk","followers_url":"https://api.github.com/users/cyberbikepunk/followers","following_url":"https://api.github.com/users/cyberbikepunk/following{/other_user}","gists_url":"https://api.github.com/users/cyberbikepunk/gists{/gist_id}","starred_url":"https://api.github.com/users/cyberbikepunk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cyberbikepunk/subscriptions","organizations_url":"https://api.github.com/users/cyberbikepunk/orgs","repos_url":"https://api.github.com/users/cyberbikepunk/repos","events_url":"https://api.github.com/users/cyberbikepunk/events{/privacy}","received_events_url":"https://api.github.com/users/cyberbikepunk/received_events","type":"User","site_admin":false},"assignees":[{"login":"cyberbikepunk","id":1629834,"avatar_url":"https://avatars.githubusercontent.com/u/1629834?v=3","gravatar_id":"","url":"https://api.github.com/users/cyberbikepunk","html_url":"https://github.com/cyberbikepunk","followers_url":"https://api.github.com/users/cyberbikepunk/followers","following_url":"https://api.github.com/users/cyberbikepunk/following{/other_user}","gists_url":"https://api.github.com/users/cyberbikepunk/gists{/gist_id}","starred_url":"https://api.github.com/users/cyberbikepunk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cyberbikepunk/subscriptions","organizations_url":"https://api.github.com/users/cyberbikepunk/orgs","repos_url":"https://api.github.com/users/cyberbikepunk/repos","events_url":"https://api.github.com/users/cyberbikepunk/events{/privacy}","received_events_url":"https://api.github.com/users/cyberbikepunk/received_events","type":"User","site_admin":false},{"login":"michaeljokf","id":22743376,"avatar_url":"https://avatars.githubusercontent.com/u/22743376?v=3","gravatar_id":"","url":"https://api.github.com/users/michaeljokf","html_url":"https://github.com/michaeljokf","followers_url":"https://api.github.com/users/michaeljokf/followers","following_url":"https://api.github.com/users/michaeljokf/following{/other_user}","gists_url":"https://api.github.com/users/michaeljokf/gists{/gist_id}","starred_url":"https://api.github.com/users/michaeljokf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaeljokf/subscriptions","organizations_url":"https://api.github.com/users/michaeljokf/orgs","repos_url":"https://api.github.com/users/michaeljokf/repos","events_url":"https://api.github.com/users/michaeljokf/events{/privacy}","received_events_url":"https://api.github.com/users/michaeljokf/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-12-04T09:33:18Z","updated_at":"2016-12-05T10:26:34Z","closed_at":null,"body":"@michaeljokf Check this out. Sometimes, there's one, sometimes, two, sometimes three amounts in the same column. Can you find out what they are so I can split them correctly?\r\n\r\n```\r\nSample values =\r\n[\r\n    \"Regionförbundet Jämtlands län = 169 288\",\r\n    \"Regionförbundet Jämtlands län = 266 703\",\r\n    \"Almi företagspartner Västernorrland AB = 100 000 || Härnösands kommun = 24 000 || Länsstyrelsen i Västernorrlands län = 400 000 || Mittuniversitetet = 50 000 || Norrlandsfonden = 100 000 || Näringslivsbolaget i Sundsvall AB  = 30 000 || Sundsvalls kommun = 100 000 || Ånge kommun = 20 000 || Örnsköldsviks kommun = 30 000\",\r\n    \"Regionförbundet Jämtlands län = 413 978\",\r\n    \"Regionförbundet Jämtlands län = 365 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 127 450 || Timrå kommun = 127 450\",\r\n    \"Härnösands kommun = 225 000 || Västernorrlands läns landsting = 25 000\",\r\n    \"Regionförbundet Jämtlands län = 417 134\",\r\n    \"Mittuniversitetet = 183 000\",\r\n    \"Mittuniversitetet = 150 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 75 000 || Mittuniversitetet = 200 000 || Regionförbundet Jämtlands län = 75 000\",\r\n    \"Regionförbundet Jämtlands län = 248 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 500 000\",\r\n    \"Fiber Optic Valley AB  = 200 000 || Mittuniversitetet = 250 000\",\r\n    \"Mittuniversitetet = 300 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 306 875\",\r\n    \"Regionförbundet Jämtlands län = 220 000\",\r\n    \"Regionförbundet Jämtlands län = 169 765\",\r\n    \"Mittuniversitetet = 94 701\",\r\n    \"Mittuniversitetet = 250 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 300 000 || Mittuniversitetet = 90 457 || Riksarkivet = 140 043\",\r\n    \"Mittuniversitetet = 220 000\",\r\n    \"Mittuniversitetet = 50 000 || Sundsvalls kommun = 50 000\",\r\n    \"Regionförbundet Jämtlands län = 163 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 75 257 || Mittuniversitetet = 100 363 || Vinnova = 125 409\",\r\n    \"Regionförbundet Jämtlands län = 183 125\",\r\n    \"Mittuniversitetet = 365 000\",\r\n    \"Regionförbundet Jämtlands län = 125 000 || Åre kommun = 125 000\",\r\n    \"Regionförbundet Jämtlands län = 229 650\",\r\n    \"Mittuniversitetet = 241 136\",\r\n    \"Regionförbundet Jämtlands län = 169 288\",\r\n    \"Mittuniversitetet = 381 545\",\r\n    \"Regionförbundet Jämtlands län = 100 000 || Stiftelsen Tännäs Fritidsanläggningar = 100 000\",\r\n    \"Regionförbundet Jämtlands län = 100 736\",\r\n    \"Almi företagspartner Mitt AB = 110 000 || Länsstyrelsen i Västernorrlands län = 110 000 || Regionförbundet Jämtlands län = 110 000\",\r\n    \"Länsstyrelsen i Västernorrlands län = 300 000 || Ånge kommun = 100 000\",\r\n    \"Regionförbundet Jämtlands län = 100 328\",\r\n    \"Ragunda kommun = 125 000 || Regionförbundet Jämtlands län = 125 000\",\r\n    \"Härjedalens kommun = 75 000 || Regionförbundet Jämtlands län = 75 000\",\r\n    \"Östersunds kommun = 311 553\",\r\n    \"Coompanion Kooperativ Utveckling i Jämtlands län = 59 416 || Coompanion Västernorrland = 109 146 || Länsstyrelsen i Västernorrlands län = 109 147 || Regionförbundet Jämtlands län = 59 416\",\r\n    \"Regionförbundet Jämtlands län = 405 350\",\r\n    \"Länsstyrelsen i Västernorrlands län = 200 000 || Scenkonst Västernorrland AB = 210 560 || Stadsbacken AB = 50 000 || Västernorrlands läns landsting = 100 000\",\r\n    \"Närpes stad = 15 244 || Västerbottens läns landsting = 15 244\",\r\n    \"Länsstyrelsen i Norrbottens län = 350 000 || Swedavia AB = 840 000\",\r\n    \"Kommunförbundet Stockholms län = 150 000 || Länsstyrelsen i Stockholms län = 75 000 || Stockholms läns landsting = 75 000\",\r\n    \"Almi företagspartner Stockholm AB = 1 050 000 || Regionförbundet Västerbottens län = 499 860 || Umeå kommun = 525 000 || Umeå universitet = 525 000 || Uminova innovation = 110 400 || Västerbottens läns landsting = 525 000\",\r\n    \"Kista Science City AB = 300 000\",\r\n    \"Härnösands kommun = 64 500 || Länsstyrelsen i Västernorrlands län = 64 500\",\r\n    \"Sollentuna kommun = 50 400 || Stockholm Business Region Development = 51 300\",\r\n    \"Stockholms kommun = 299 780\",\r\n    \"Stiftelsen Flemingsberg Science = 300 000\",\r\n    \"Mittuniversitetet = 160 000\",\r\n    \"Stockholms kommun = 300 000\",\r\n    \"Södertälje kommun = 310 297\",\r\n    \"Kommunförbundet Stockholms län = 100 000 || Stockholms kommun = 100 000 || Stockholms läns landsting = 100 000\",\r\n    \"Länsstyrelsen i Stockholms län = 100 000 || Stockholm Business Region Development = 50 826 || Stockholms kommun = 149 174\",\r\n    \"Kista Science City AB = 300 000\",\r\n    \"Karolinska institutet = 103 623 || Länsstyrelsen i Stockholms län = 150 000 || Stockholms läns landsting = 50 000\",\r\n    \"Nacka kommun = 300 000\",\r\n    \"Kungliga tekniska högskolan = 300 000\",\r\n    \"Haninge kommun = 35 000 || Stockholms kommun = 35 000 || Stockholms läns landsting = 195 000 || Täby kommun = 35 000\",\r\n    \"Botkyrka kommun = 25 100 || Kungliga tekniska högskolan = 150 000 || Stockholms kommun = 25 100 || Telge Hovsjö AB = 25 100\",\r\n    \"Stockholm Business Region Development = 300 000\",\r\n    \"Skärgårdsstiftelsen i sthlms län = 29 387 || Stockholms läns landsting = 175 820\",\r\n    \"Länsstyrelsen i Stockholms län = 129 698\",\r\n    \"Kommunförbundet Stockholms län = 20 000 || Länsstyrelsen i Stockholms län = 134 000 || Stockholms läns landsting = 20 000\",\r\n    \"Stiftelsen Vetenskapsstaden = 303 034\",\r\n    \"Stockholm Business Region Development = 300 000\",\r\n    \"Eskilstuna kommun = 40 000 || Flens kommun = 5 000 || Gnesta kommun = 5 000 || Nyköpings kommun = 20 000 || Regionförbundet Östsam = 65 000 || Trosa kommun = 5 000 || Vingåkers kommun = 5 000 || Örebro kommun = 120 000\",\r\n    \"Föreningen blå vägen = 10 000 || Kvarkenrådet = 15 000 || Mittskandia = 5 000\",\r\n    \"Länsstyrelsen i Västmanlands län = 50 000 || Mälarens Vattenvårdsförbund = 20 000 || Stiftelsen skog & trä = 25 000 || Sveriges lantbruksuniversitet = 150 000\",\r\n    \"Intresseföreningen bergslaget = 75 000 || Länsstyrelsen i Västmanlands län = 75 000 || Sala lokaler AB = 73 100 || Västmanlands kommunförbund = 26 900\",\r\n    \"Länsstyrelsen i Västmanlands län = 250 000\",\r\n    \"Regionförbundet Örebro län = 162 450\",\r\n    \"Västerås Science Park AB = 500 000\",\r\n    \"Länsstyrelsen i Västmanlands län = 250 000\",\r\n    \"Eskilstuna kommun = 40 000 || Länsstyrelsen i Västmanlands län = 40 000 || Nyköpings kommun = 40 000 || Regionförbundet Sörmland = 40 000 || Västerås kommun = 40 000\",\r\n    \"Eskilstuna kommun = 250 000\",\r\n    \"Länsstyrelsen i Västmanlands län = 300 000 || Vinnova = 300 000 || Västerås kommun = 100 000 || Västmanlands läns landsting = 100 000\",\r\n    \"Arbetsförmedlingen = 200 000\",\r\n    \"Västerporten Fastigheter i Örebro AB = 67 950 || Örebro kommun = 121 025\",\r\n    \"Länsstyrelsen i Östergötlands län = 125 000 || Regionförbundet Östsam = 29 375\",\r\n    \"Regionförbundet Västerbottens län = 15 540 || Storumans kommun = 7 728\",\r\n    \"Länsstyrelsen i Västernorrlands län = 175 000 || Sundsvalls kommun = 75 000\",\r\n    \"Regionförbundet Västerbottens län = 15 306 || Sveriges lantbruksuniversitet = 306 || Teknologicentret KETEK AB = 3 903 || Yrkeshögskolan Novia = 3 903 || Österbottens förbund = 7 806\",\r\n    \"Regionförbundet Västerbottens län = 8 128 || Sveriges lantbruksuniversitet = 8 128 || Yrkeshögskolan Novia = 7 484 || Österbottens förbund = 7 484\",\r\n    \"Halmstads kommun = 16 500 || Högskolan i Halmstad = 2 500\",\r\n    \"UmeÃ¥ universitet = 10 390 || YrkeshÃ¶gskolan Novia = 4 223 || Ãbo akademi = 11 381\",\r\n    \"RegionfÃ¶rbundet VÃ¤sterbottens lÃ¤n = 1 273 111 || SkellefteÃ¥ kommun = 620 819 || UmeÃ¥ kommun = 804 070\",\r\n    \"HÃ¶gskolan i gÃ¤vle = 1 250 || RegionfÃ¶rbundet GÃ¤vleborg = 15 000 || Ãbo akademi = 5 750 || Ãsterbottens fÃ¶rbund = 10 500\",\r\n    \"HÃ¶gskolan VÃ¤st = 16 995 || University College Nordjylland = 27 135\",\r\n    \"Danmarks tekniske universitet - DTU = 3 264 || Region JÃ¶nkÃ¶pings lÃ¤n  = 4 200 || VÃ¤stra GÃ¶talandsregionen = 6 000\",\r\n    \"Frederikshavn ErhvervsrÃ¥d = 26 810 || Region Nordjylland = 6 032 || Vaeksthus Nordjylland = 7 372\",\r\n    \"Aalborg Universitet Aalborg = 27 653 || KommunalfÃ¶rbundet Skaraborg = 6 164 || Sveriges lantbruksuniversitet = 10 191 || VÃ¤stra GÃ¶talandsregionen = 14 084\",\r\n    \"HÃ¤rnÃ¶sands kommun = 100 000 || Kramfors kommun = 100 000 || VÃ¤sternorrlands lÃ¤ns landsting = 196 530\",\r\n    \"ABF MalmÃ¶ = 2 000 || FÃ¶reningen Norden = 41 765\",\r\n    \"Bornholms regionskommune = 15 000 || Ystads kommun = 15 000\",\r\n    \"Gate 21 = 27 910 || Hållbar utveckling Skåne = 10 920 || Region Skåne = 10 755\",\r\n    \"Köbenhavns universitet = 27 500 || Sveriges lantbruksuniversitet = 72 500\"\r\n]\r\n```"},"comment":{"url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/comments/264818213","html_url":"https://github.com/os-data/eu-structural-funds/issues/329#issuecomment-264818213","issue_url":"https://api.github.com/repos/os-data/eu-structural-funds/issues/329","id":264818213,"user":{"login":"michaeljokf","id":22743376,"avatar_url":"https://avatars.githubusercontent.com/u/22743376?v=3","gravatar_id":"","url":"https://api.github.com/users/michaeljokf","html_url":"https://github.com/michaeljokf","followers_url":"https://api.github.com/users/michaeljokf/followers","following_url":"https://api.github.com/users/michaeljokf/following{/other_user}","gists_url":"https://api.github.com/users/michaeljokf/gists{/gist_id}","starred_url":"https://api.github.com/users/michaeljokf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaeljokf/subscriptions","organizations_url":"https://api.github.com/users/michaeljokf/orgs","repos_url":"https://api.github.com/users/michaeljokf/repos","events_url":"https://api.github.com/users/michaeljokf/events{/privacy}","received_events_url":"https://api.github.com/users/michaeljokf/received_events","type":"User","site_admin":false},"created_at":"2016-12-05T10:26:34Z","updated_at":"2016-12-05T10:26:34Z","body":"yes exactly: member_state_amount it is! yeah do that - I am sure there are still a bunch of these \"hiccups\" ..."}}
{"actor":{"display_login":"michaeljokf"}}