Status:Closed    Asked:Oct 14, 2015 - 04:15 AM



I am trying to merge county level data from ipums that I downloaded (ACS surveys), but it's not in the fips code. I came across:

However, they don't seem to have the crosswalk from the ipums data to fips codes? Am I overlooking something?

Do you have the same question? Follow this Question

Staff Answer




The variable COUNTY uses the ICPSR coding scheme. While the first three digits are usually identical to the FIPS county codes, ICPSR adds a fourth digit to accommodate change over time. I recommend reading the description and codes pages for COUNTY, as they will contain information about the limitations of the variable as well as links to the codes. If you are not interested in using the ICPSR coding scheme, the variable COUNTYFIPS offers county information using the FIPS codes.

I hope this helps.


Oct 15, 2015 - 03:56 PM

Report it


Hi Erica,

Sorry for the delayed reply -- didn't realize you had replied already and I couldn't find the thread until Tim thankfully clarified to me how to find threads!

I had read the ICSPR description, but was hoping to avoid manually hardcoding the crosswalk. Just to clarify your suggestion -- the idea is combine the statefips and countyfips codes to create a unique county code within a year, right? Can I drop the fourth digit that yours adds and just weight regularly, or how would I match the fourth digit over to a regular county level dataset?


Oct 20, 2015 - 03:29 PM

Report it

Never mind, I think I resolved it based on your initial clarification.

Basically generate county = st*1000 + countyfip


Oct 20, 2015 - 05:47 PM

Report it


Birthplace only downloads codes for foreign countries, no state FIPS codes.
If you are examining individual level data, can you use the state FIPS codes?
Is there an easy way to convert metaarea codes to standard census fips code? ...
Is there a way to link place FIPS codes to the variable CITY in IPUMS-USA?
Match IPUMS-CPS with (I)PUMS USA census data 1970-2010 at PUMA/county level
Login   |   Register

Recently Active Members

View More »

Share |