{"action":"created","issue":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/33","repository_url":"https://api.github.com/repos/caciviclab/disclosure-backend-static","labels_url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/33/comments","events_url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/33/events","html_url":"https://github.com/caciviclab/disclosure-backend-static/issues/33","id":178239349,"number":33,"title":"Determine the quantity of committee to committee expenditures for ballot measures","user":{"login":"tdooner","id":129120,"avatar_url":"https://avatars.githubusercontent.com/u/129120?v=3","gravatar_id":"","url":"https://api.github.com/users/tdooner","html_url":"https://github.com/tdooner","followers_url":"https://api.github.com/users/tdooner/followers","following_url":"https://api.github.com/users/tdooner/following{/other_user}","gists_url":"https://api.github.com/users/tdooner/gists{/gist_id}","starred_url":"https://api.github.com/users/tdooner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tdooner/subscriptions","organizations_url":"https://api.github.com/users/tdooner/orgs","repos_url":"https://api.github.com/users/tdooner/repos","events_url":"https://api.github.com/users/tdooner/events{/privacy}","received_events_url":"https://api.github.com/users/tdooner/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"monkeyhippies","id":8634687,"avatar_url":"https://avatars.githubusercontent.com/u/8634687?v=3","gravatar_id":"","url":"https://api.github.com/users/monkeyhippies","html_url":"https://github.com/monkeyhippies","followers_url":"https://api.github.com/users/monkeyhippies/followers","following_url":"https://api.github.com/users/monkeyhippies/following{/other_user}","gists_url":"https://api.github.com/users/monkeyhippies/gists{/gist_id}","starred_url":"https://api.github.com/users/monkeyhippies/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/monkeyhippies/subscriptions","organizations_url":"https://api.github.com/users/monkeyhippies/orgs","repos_url":"https://api.github.com/users/monkeyhippies/repos","events_url":"https://api.github.com/users/monkeyhippies/events{/privacy}","received_events_url":"https://api.github.com/users/monkeyhippies/received_events","type":"User","site_admin":false},"assignees":[{"login":"monkeyhippies","id":8634687,"avatar_url":"https://avatars.githubusercontent.com/u/8634687?v=3","gravatar_id":"","url":"https://api.github.com/users/monkeyhippies","html_url":"https://github.com/monkeyhippies","followers_url":"https://api.github.com/users/monkeyhippies/followers","following_url":"https://api.github.com/users/monkeyhippies/following{/other_user}","gists_url":"https://api.github.com/users/monkeyhippies/gists{/gist_id}","starred_url":"https://api.github.com/users/monkeyhippies/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/monkeyhippies/subscriptions","organizations_url":"https://api.github.com/users/monkeyhippies/orgs","repos_url":"https://api.github.com/users/monkeyhippies/repos","events_url":"https://api.github.com/users/monkeyhippies/events{/privacy}","received_events_url":"https://api.github.com/users/monkeyhippies/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2016-09-21T03:51:44Z","updated_at":"2016-09-22T06:09:06Z","closed_at":null,"body":"Related to #29, there are some instances of potential double-counting expenditures in support/opposition to ballot measures.\r\n\r\nFor instance, transaction ID `OgSkVRBY4uzb` ($59,000!) in `inputs/efile_COAK_2016_497.csv` was given to the Committee To Protect Oakland Renters.\r\n\r\nThat committee then also has spent $60,000 in support of the ballot measure, as determined by this query:\r\n\r\n```sql\r\n select sum(\"Tran_Amt1\") from \"efile_COAK_2016_A-Contributions\" where \"Report_Num\" = '001' AND \"Filer_ID\" = '1364564';\r\n```\r\n\r\nHow many contributions go from committee to committee? Which committees do this more than others? How deep does the rabbit hole go....? 🐰 "},"comment":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/comments/248820438","html_url":"https://github.com/caciviclab/disclosure-backend-static/issues/33#issuecomment-248820438","issue_url":"https://api.github.com/repos/caciviclab/disclosure-backend-static/issues/33","id":248820438,"user":{"login":"tdooner","id":129120,"avatar_url":"https://avatars.githubusercontent.com/u/129120?v=3","gravatar_id":"","url":"https://api.github.com/users/tdooner","html_url":"https://github.com/tdooner","followers_url":"https://api.github.com/users/tdooner/followers","following_url":"https://api.github.com/users/tdooner/following{/other_user}","gists_url":"https://api.github.com/users/tdooner/gists{/gist_id}","starred_url":"https://api.github.com/users/tdooner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tdooner/subscriptions","organizations_url":"https://api.github.com/users/tdooner/orgs","repos_url":"https://api.github.com/users/tdooner/repos","events_url":"https://api.github.com/users/tdooner/events{/privacy}","received_events_url":"https://api.github.com/users/tdooner/received_events","type":"User","site_admin":false},"created_at":"2016-09-22T06:09:06Z","updated_at":"2016-09-22T06:09:06Z","body":"@michaelliu2 What is the total amount, and which committees do it?\r\n\r\nI promised you a data dictionary. Here it is:\r\n\r\nhttps://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76\r\n\r\nI feel like a spreadsheet is still not the optimal format for a data dictionary, but at least it has a little bit of a description about each field 😀 \r\n\r\nAlso, I kind of like the term \"transfer\" for tabulating this internally but agree with @sfdoran that it probably isn't good terminology to surface to users. The benefit of using a term like that within our codebase is that it gives us a shorthand to refer to those contributions rather than the longwinded name: \"committee to committee expenditures\"."}}
{"actor":{"display_login":"tdooner"}}