{"action":"created","issue":{"url":"https://api.github.com/repos/18F/openFEC/issues/1252","labels_url":"https://api.github.com/repos/18F/openFEC/issues/1252/labels{/name}","comments_url":"https://api.github.com/repos/18F/openFEC/issues/1252/comments","events_url":"https://api.github.com/repos/18F/openFEC/issues/1252/events","html_url":"https://github.com/18F/openFEC/pull/1252","id":110082520,"number":1252,"title":"limiting typeahead","user":{"login":"LindsayYoung","id":4406333,"avatar_url":"https://avatars.githubusercontent.com/u/4406333?v=3","gravatar_id":"","url":"https://api.github.com/users/LindsayYoung","html_url":"https://github.com/LindsayYoung","followers_url":"https://api.github.com/users/LindsayYoung/followers","following_url":"https://api.github.com/users/LindsayYoung/following{/other_user}","gists_url":"https://api.github.com/users/LindsayYoung/gists{/gist_id}","starred_url":"https://api.github.com/users/LindsayYoung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LindsayYoung/subscriptions","organizations_url":"https://api.github.com/users/LindsayYoung/orgs","repos_url":"https://api.github.com/users/LindsayYoung/repos","events_url":"https://api.github.com/users/LindsayYoung/events{/privacy}","received_events_url":"https://api.github.com/users/LindsayYoung/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-06T19:30:47Z","updated_at":"2015-10-07T19:13:09Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/18F/openFEC/pulls/1252","html_url":"https://github.com/18F/openFEC/pull/1252","diff_url":"https://github.com/18F/openFEC/pull/1252.diff","patch_url":"https://github.com/18F/openFEC/pull/1252.patch"},"body":"This will decrease the chances of offensive names popping up in typeahead.\r\n\r\nThis is not perfect because there are some issues with dimcandproperties. there are candidates that should show up that don't.\r\n\r\nfix 18F/openFEC-web-app#804"},"comment":{"url":"https://api.github.com/repos/18F/openFEC/issues/comments/146299309","html_url":"https://github.com/18F/openFEC/pull/1252#issuecomment-146299309","issue_url":"https://api.github.com/repos/18F/openFEC/issues/1252","id":146299309,"user":{"login":"LindsayYoung","id":4406333,"avatar_url":"https://avatars.githubusercontent.com/u/4406333?v=3","gravatar_id":"","url":"https://api.github.com/users/LindsayYoung","html_url":"https://github.com/LindsayYoung","followers_url":"https://api.github.com/users/LindsayYoung/followers","following_url":"https://api.github.com/users/LindsayYoung/following{/other_user}","gists_url":"https://api.github.com/users/LindsayYoung/gists{/gist_id}","starred_url":"https://api.github.com/users/LindsayYoung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LindsayYoung/subscriptions","organizations_url":"https://api.github.com/users/LindsayYoung/orgs","repos_url":"https://api.github.com/users/LindsayYoung/repos","events_url":"https://api.github.com/users/LindsayYoung/events{/privacy}","received_events_url":"https://api.github.com/users/LindsayYoung/received_events","type":"User","site_admin":false},"created_at":"2015-10-07T19:13:09Z","updated_at":"2015-10-07T19:13:09Z","body":"There are two places for the ici status. We started out using the ici table, but @PaulClark2 suggested using dimcandproperties since there were multiple ways to update ICI and the data might be incomplete. \r\n\r\nI am thinking we might want to strategize on how to do a little extra clean up. \r\n\r\nLet's take Issa for an example:\r\n```\r\n=> select * from dimcandstatusici where cand_sk=10025283;\r\n```\r\n\r\n candstatusici_sk | cand_sk  | election_yr | ici_code | cand_status | cand_inactive_flg |      load_date      | expire_date | pg_date \r\n------------------|----------|-------------|----------|-------------|-------------------|---------------------|-------------|---------\r\n          1100948 | 10025283 |        2004 |          | C           |                   | 2015-06-24 18:55:17 |             | \r\n          1073269 | 10025283 |        2008 | I        | C           |                   | 2015-06-24 18:55:17 |             | \r\n          1073271 | 10025283 |        2012 | I        | P           |                   | 2015-06-24 18:55:17 |             | \r\n          1100953 | 10025283 |        2016 |          | C           |                   | 2015-06-24 18:55:17 |             | \r\n          1073268 | 10025283 |        2006 | I        | C           |                   | 2015-06-24 18:55:17 |             | \r\n          1073270 | 10025283 |        2010 | I        |             |                   | 2015-06-24 18:55:17 |             | \r\n          1100952 | 10025283 |        2014 |          | C           |                   | 2015-06-24 18:55:17 |             | \r\n\r\n\r\n```\r\nc=> select election_yr, cand_ici_cd, cand_status_cd from dimcandproperties where cand_sk=10025283;\r\n```\r\n\r\n election_yr | cand_ici_cd | cand_status_cd \r\n-------------|-------------|----------------\r\n        2000 | O           | C\r\n        2002 | I           | C\r\n        2004 |             | C\r\n        2004 |             | C\r\n        2004 |             | C\r\n        2006 |             | C\r\n        2008 |             | P\r\n        2008 | I           | P\r\n        2008 | I           | C\r\n        2010 |             | P\r\n        2010 | I           | P\r\n        2010 | I           | P\r\n        2006 | I           | C\r\n        2012 | I           | N\r\n        2012 | I           | N\r\n        2012 | I           | N\r\n        2012 | I           | C\r\n        2014 |             | N\r\n        2014 |             | N\r\n        2014 | I           | N\r\n        2014 | I           | C\r\n        2014 | I           | C\r\n        2016 |             | N\r\n        2016 | I           | N\r\n        2016 | I           | F\r\n        2016 | I           | C\r\n\r\nPaul, do you think we could  \"fill down\" the ici status for each candidate in the dimcandproperties table?"}}