Join us on Wednesday, June 3rd for a deep dive into Customer Predictive Analytics Learn more

Has anyone figured out how to Map US Census FIPS codes

Level 5
Has anyone figured out how to Map US Census FIPS codes

I'm looking at some NYC Times COVID-19 data that provides US Census FIPS codes.

https://github.com/nytimes/covid-19-data

I'd like to Map this data with using DSS.

It has a FIPS code.  No GeoPoints of Lat Lon. 

SO it looks like I have to do some Geo Location work here.

It looks like the Census might have an API to geocode the FIPS codes.

I see this discussion. https://www.dataiku.com/product/plugins/us-census/

Has anyone worked this out.

Is there a Python or R library that would make this easy?

--Tom
2 Replies
Dataiker
Dataiker

Hi Tom,

The US Census plugin won't be useful in your context since it enriches data with US Census data not performing reverse geocoding. I believe what you are looking for is here in in the gazetteer files, spot the US Counties : https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html

 

Best

Nicolas.

Level 5
Author

Thanks for the suggestion. 

In looking at this several times, I've not found a connection between the fips, codes in the NY Time data and the census data that tells something about the location of the areas.

Maybe I don't really know what a fips code is.  (in the case of the NY times data this looks like it is somehow connected to a county.

 

--Tom
0 Kudos