Question

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

IPUMS-Census

Hi IPUMS,


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:

https://cps.ipums.org/cps/codes/count...


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

avatar

Erin_Meyer

Staff

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

1
0
Report it

Answers

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

0
0
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

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

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?
Health Insurance Unit in ACS versus MEPS
Login   |   Register

Recently Active Members

View More »

Share |