{"action":"created","issue":{"url":"https://api.github.com/repos/18F/openFEC/issues/1406","labels_url":"https://api.github.com/repos/18F/openFEC/issues/1406/labels{/name}","comments_url":"https://api.github.com/repos/18F/openFEC/issues/1406/comments","events_url":"https://api.github.com/repos/18F/openFEC/issues/1406/events","html_url":"https://github.com/18F/openFEC/issues/1406","id":122659853,"number":1406,"title":"Restrict candidate-committee linkages by committee type","user":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2015-12-17T04:42:57Z","updated_at":"2015-12-22T14:57:51Z","closed_at":null,"body":"Some candidates are linked to committees associated with the wrong office. For example, House candidate Tammy Baldwin is associated with Senate committee Tammy Baldwin for Senate in 2014. This has the undesired effects of counting receipts from Baldwin for Senate for both the House and Senate versions of the candidate. One solution here (I think @PaulClark2 mentioned this in an example query a while back) is to restrict linkages to committees whose type match the first letter of the candidate ID.\r\n\r\n@PaulClark2, can you verify that this is correct? If so, I can submit this as a hotfix and get Tammy Baldwin's numbers fixed quick.\r\n\r\ncc @LindsayYoung "},"comment":{"url":"https://api.github.com/repos/18F/openFEC/issues/comments/166637213","html_url":"https://github.com/18F/openFEC/issues/1406#issuecomment-166637213","issue_url":"https://api.github.com/repos/18F/openFEC/issues/1406","id":166637213,"user":{"login":"jmcarp","id":1633460,"avatar_url":"https://avatars.githubusercontent.com/u/1633460?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcarp","html_url":"https://github.com/jmcarp","followers_url":"https://api.github.com/users/jmcarp/followers","following_url":"https://api.github.com/users/jmcarp/following{/other_user}","gists_url":"https://api.github.com/users/jmcarp/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcarp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcarp/subscriptions","organizations_url":"https://api.github.com/users/jmcarp/orgs","repos_url":"https://api.github.com/users/jmcarp/repos","events_url":"https://api.github.com/users/jmcarp/events{/privacy}","received_events_url":"https://api.github.com/users/jmcarp/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T14:57:51Z","updated_at":"2015-12-22T14:57:51Z","body":"@PaulClark2, how would you like to proceed with this? Do you want to review the linkage rows whose candidate IDs don't match their committee types, or should we filter them out programmatically (there's a pull request in that would do this)?"}}