{"action":"created","issue":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/94","labels_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/94/labels{/name}","comments_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/94/comments","events_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/94/events","html_url":"https://github.com/caciviclab/disclosure-backend/issues/94","id":123227439,"number":94,"title":"Load FIPS Ids & their corresponding Names & Types into API","user":{"login":"jnmarcus","id":1439922,"avatar_url":"https://avatars.githubusercontent.com/u/1439922?v=3","gravatar_id":"","url":"https://api.github.com/users/jnmarcus","html_url":"https://github.com/jnmarcus","followers_url":"https://api.github.com/users/jnmarcus/followers","following_url":"https://api.github.com/users/jnmarcus/following{/other_user}","gists_url":"https://api.github.com/users/jnmarcus/gists{/gist_id}","starred_url":"https://api.github.com/users/jnmarcus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jnmarcus/subscriptions","organizations_url":"https://api.github.com/users/jnmarcus/orgs","repos_url":"https://api.github.com/users/jnmarcus/repos","events_url":"https://api.github.com/users/jnmarcus/events{/privacy}","received_events_url":"https://api.github.com/users/jnmarcus/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-21T07:55:23Z","updated_at":"2015-12-21T11:50:37Z","closed_at":null,"body":"FIPS Ids are used nationwide at the city, county, and state level.  Per @chellrocks suggestion, and based on some various onsite discussions, we had previously decided that using FIPS ids made the most sense as it will help us to use a uniform identification nomenclature & not force us to re-write the wheel where we don't have to.  Now, we need to load this data into a consumable API :smile: \r\n\r\nBased on data retrieved by @chellrocks from ??(source needed)?? [this spreadsheet](https://docs.google.com/spreadsheets/d/1dYrLsYR7rRdV1iYyfA68nC40yJTPK7n22pspLlTJYt4/edit?usp=sharing) was used as a starting point to aggregate the state and county fips ids for California.  Note that some numbers in the state tab are missing because they are US entities considered out of scope for the sake of this project.  **California's FIPS ID is 6** and its corresponding county's FIPS Ids can be found on the second tab of the spreadsheet.\r\n\r\nAs of right now, it looks like we have only logged fips data for California's counties, not cities, so there is more work to do on that end.  That being said, @adborden and @tdooner it should be noted that the fips id you are currently loading in the front end for the 'city' of San Francisco (6075), is in fact the county fips id.\r\n\r\nAdditionally, it appears that there are multiple counties whose name(s) are the same as the city.  We should probably take inventory of this, and discuss how we are going to handle these cases."},"comment":{"url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/comments/166280376","html_url":"https://github.com/caciviclab/disclosure-backend/issues/94#issuecomment-166280376","issue_url":"https://api.github.com/repos/caciviclab/disclosure-backend/issues/94","id":166280376,"user":{"login":"mikeubell","id":6759416,"avatar_url":"https://avatars.githubusercontent.com/u/6759416?v=3","gravatar_id":"","url":"https://api.github.com/users/mikeubell","html_url":"https://github.com/mikeubell","followers_url":"https://api.github.com/users/mikeubell/followers","following_url":"https://api.github.com/users/mikeubell/following{/other_user}","gists_url":"https://api.github.com/users/mikeubell/gists{/gist_id}","starred_url":"https://api.github.com/users/mikeubell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikeubell/subscriptions","organizations_url":"https://api.github.com/users/mikeubell/orgs","repos_url":"https://api.github.com/users/mikeubell/repos","events_url":"https://api.github.com/users/mikeubell/events{/privacy}","received_events_url":"https://api.github.com/users/mikeubell/received_events","type":"User","site_admin":false},"created_at":"2015-12-21T11:50:37Z","updated_at":"2015-12-21T11:50:37Z","body":"Since San Francisco is both a county and a city using the county FIP is probably right.\n\n> On Dec 20, 2015, at 11:55 PM, Jamie Marcus <notifications@github.com> wrote:\n> \n> FIPS Ids are used nationwide at the city, county, and state level. Per @chellrocks suggestion, and based on some various onsite discussions, we had previously decided that using FIPS ids made the most sense as it will help us to use a uniform identification nomenclature & not force us to re-write the wheel where we don't have to. Now, we need to load this data into a consumable API \n> \n> Based on data retrieved by @chellrocks from ??(source needed)?? this spreadsheet was used as a starting point to aggregate the state and county fips ids for California. Note that some numbers in the state tab are missing because they are US entities considered out of scope for the sake of this project. California's FIPS ID is 6 and its corresponding county's FIPS Ids can be found on the second tab of the spreadsheet.\n> \n> As of right now, it looks like we have only logged fips data for California's counties, not cities, so there is more work to do on that end. That being said, @adborden and @tdooner it should be noted that the fips id you are currently loading in the front end for the 'city' of San Francisco (6075), is in fact the county fips id.\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n"}}