{"action":"created","issue":{"url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/32","repository_url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong","labels_url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/32/comments","events_url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/32/events","html_url":"https://github.com/code4romania/monitorizare-vot-ong/issues/32","id":366340290,"node_id":"MDU6SXNzdWUzNjYzNDAyOTA=","number":32,"title":"Export the data as per-station observation to make analysis easier","user":{"login":"KrzysztofMadejski","id":849975,"node_id":"MDQ6VXNlcjg0OTk3NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/849975?v=4","gravatar_id":"","url":"https://api.github.com/users/KrzysztofMadejski","html_url":"https://github.com/KrzysztofMadejski","followers_url":"https://api.github.com/users/KrzysztofMadejski/followers","following_url":"https://api.github.com/users/KrzysztofMadejski/following{/other_user}","gists_url":"https://api.github.com/users/KrzysztofMadejski/gists{/gist_id}","starred_url":"https://api.github.com/users/KrzysztofMadejski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrzysztofMadejski/subscriptions","organizations_url":"https://api.github.com/users/KrzysztofMadejski/orgs","repos_url":"https://api.github.com/users/KrzysztofMadejski/repos","events_url":"https://api.github.com/users/KrzysztofMadejski/events{/privacy}","received_events_url":"https://api.github.com/users/KrzysztofMadejski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"KrzysztofMadejski","id":849975,"node_id":"MDQ6VXNlcjg0OTk3NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/849975?v=4","gravatar_id":"","url":"https://api.github.com/users/KrzysztofMadejski","html_url":"https://github.com/KrzysztofMadejski","followers_url":"https://api.github.com/users/KrzysztofMadejski/followers","following_url":"https://api.github.com/users/KrzysztofMadejski/following{/other_user}","gists_url":"https://api.github.com/users/KrzysztofMadejski/gists{/gist_id}","starred_url":"https://api.github.com/users/KrzysztofMadejski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrzysztofMadejski/subscriptions","organizations_url":"https://api.github.com/users/KrzysztofMadejski/orgs","repos_url":"https://api.github.com/users/KrzysztofMadejski/repos","events_url":"https://api.github.com/users/KrzysztofMadejski/events{/privacy}","received_events_url":"https://api.github.com/users/KrzysztofMadejski/received_events","type":"User","site_admin":false},"assignees":[{"login":"KrzysztofMadejski","id":849975,"node_id":"MDQ6VXNlcjg0OTk3NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/849975?v=4","gravatar_id":"","url":"https://api.github.com/users/KrzysztofMadejski","html_url":"https://github.com/KrzysztofMadejski","followers_url":"https://api.github.com/users/KrzysztofMadejski/followers","following_url":"https://api.github.com/users/KrzysztofMadejski/following{/other_user}","gists_url":"https://api.github.com/users/KrzysztofMadejski/gists{/gist_id}","starred_url":"https://api.github.com/users/KrzysztofMadejski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrzysztofMadejski/subscriptions","organizations_url":"https://api.github.com/users/KrzysztofMadejski/orgs","repos_url":"https://api.github.com/users/KrzysztofMadejski/repos","events_url":"https://api.github.com/users/KrzysztofMadejski/events{/privacy}","received_events_url":"https://api.github.com/users/KrzysztofMadejski/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-10-03T13:31:16Z","updated_at":"2018-10-28T11:49:39Z","closed_at":null,"author_association":"COLLABORATOR","body":"Our data team has said that pivoting every time the RawResults xlsx available on https://code4.ro/en/project/monitorizare-vot/ is too much work. They would need a csv export with:\r\n- each row is an observation (one polling station, one observer)\r\n- each column is a question/answer (along all forms)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/comments/433698030","html_url":"https://github.com/code4romania/monitorizare-vot-ong/issues/32#issuecomment-433698030","issue_url":"https://api.github.com/repos/code4romania/monitorizare-vot-ong/issues/32","id":433698030,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzY5ODAzMA==","user":{"login":"KrzysztofMadejski","id":849975,"node_id":"MDQ6VXNlcjg0OTk3NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/849975?v=4","gravatar_id":"","url":"https://api.github.com/users/KrzysztofMadejski","html_url":"https://github.com/KrzysztofMadejski","followers_url":"https://api.github.com/users/KrzysztofMadejski/followers","following_url":"https://api.github.com/users/KrzysztofMadejski/following{/other_user}","gists_url":"https://api.github.com/users/KrzysztofMadejski/gists{/gist_id}","starred_url":"https://api.github.com/users/KrzysztofMadejski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrzysztofMadejski/subscriptions","organizations_url":"https://api.github.com/users/KrzysztofMadejski/orgs","repos_url":"https://api.github.com/users/KrzysztofMadejski/repos","events_url":"https://api.github.com/users/KrzysztofMadejski/events{/privacy}","received_events_url":"https://api.github.com/users/KrzysztofMadejski/received_events","type":"User","site_admin":false},"created_at":"2018-10-28T11:49:39Z","updated_at":"2018-10-28T11:49:39Z","author_association":"COLLABORATOR","body":"I've prepared a huge pivot query that is doing that. Our data analyst was very happy with the result. I'd be happy to code that in. Maybe as a SQL procedure.\r\n\r\nThe question is how should it be coded? @bvizureanu ? I'd put that into the API and the dashboard would just call the endpoint to get the data and form it accordingly (html, xlsx, csv or some other format). But that 's a bigger question where reporting logic should be placed. If it will be placed in API other clients could use it as well."}}
{"actor":{"display_login":"KrzysztofMadejski"}}