How to match ipums usa population counts with other sources by urbanicity?

Hi, I am trying to match national population broken by race/ethnicity, hispanic origin, sex and urbanicity. I am using the metro and met2013 variables with other variables I have at the county level. I have been trying to use the statefip and countyfip variables and metro13 variables to merge with the CBSA Code from the 2013 OMB delineation files available at the census website

However, there does not seem to be a good match. Is there an specific crosswalk between the metro and met2013 variables with the OMB that I could use?

Thanks in advance

Welcome to the IPUMS forums Ariadne! :grinning:

As I compare the MET2013 variable to the Feb. 2013 delineation files in your link I see them all matching. There are only 295 CBSAs covered by MET2013, and when I crosswalk them to the Feb. 2013 CBSA delineation file, all 295 match. Perhaps you’re noticing that there aren’t as many CBSAs in the IPUMS sample as there are actual CBSAs (933 per the 02/2013 OMB file you linked)? This is due (at least I believe) to the fact that many CBSAs are small areas (<100000 pop.) which IPUMS does not report.

As @Chris_B notes, IPUMS USA isn’t able to identify all metro areas, nor is it able to identify most U.S. counties in any recent microdata samples.

I suggest reviewing this blog post about county identification in IPUMS USA, and reviewing both the COUNTYFIP and MET2013 variable descriptions. You’ll find more info in both places about which counties and metro areas are identifiable in IPUMS USA samples. You may also be interested in the DENSITY and METPOP10 variables, which are designed to provide two distinct indices of urbanization for microdata.

Alternatively, you can get summary tables of population by race/ethnicity and sex for all U.S. metro areas and counties through IPUMS NHGIS.

1 Like

Today, I am learning from Jonathan (in several places): Time to get to work with NHGIS! :smile:

1 Like