Question

Status:Closed    Asked:Jan 12, 2015 - 10:55 AM

Is there an easy way to convert metaarea codes to standard census fips code? IPUMS 2000 5%

I am trying to aggregate data at the msa level using the IPUMS 2000 5% sample and census msa figures. However, there is a lot of variation in the codes used. There are also some MSAs in the IPUMS 2000 5% that do not appear in the 2000 Census delineations, and vice-versa. One example is Corvallis, OR MSA (fips code 1890), which is in the Census 2000 delineations but not in the IPUMS 5% 2000. I am wondering if there is anything available to help with this translation.

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

The METAREA codes in IPUMS-USA are actually FIPS codes, however, they represent the coding and naming structure used in the 1990 OMB definitions with minor adjustments to reflect hierarchical relationships among metro areas across time. For a full discussion of METAREA codes and labels, so the METAREA Variable Description and Comparability Statement. MSA's that are not represented in the data are likely not identifiable due to population restrictions, such as in your example of Corvallis, OR which did not have a sufficiently large population to be identified in the Public Use Data. To see how the original MSA codes for the 2000 samples nest within the METAREA codes you can see the METAREA Translation Table (I recommend reading the Introduction to Translation Tables to better understand how these files are constructed).
I hope this helps.

 

Jan 12, 2015 - 12:56 PM

1
0
Report it
avatar

Joe_Grover

Staff

In the text file you linked to, Akron, OH can be found listed under PMSA FIPS code 0080.


I hope this helps.

 

Jan 16, 2015 - 08:50 AM

0
0
Report it
avatar

Tim_Moreland

Staff

The METAREA values that you list are available in the IPUMS-CPS data, but they are not available in the IPUMS-USA data. Since the Translation Tables linked to above pertain to the IPUMS-USA version of the METAREA variable, those metro areas cannot be found in the Translation Table. As well, those metro areas were not part of the 1990 OMB delineation, which is why they are not included in the OMB file. You can, however, find these metro areas in more recent versions of the OMB delineation file, e.g. Dec 2009.


Hope this helps.

 

Jan 28, 2015 - 04:20 PM

0
0
Report it

Answers

Not an answer but a follow-up question. I understand that some metarea codes are on the 1990 OMB list (see attached) but not in the IPUMS sample due to confidentiality reasons. However, how are there metarea codes in IPUMS that are *not* on the 1990 OMB list? For example, Akron OH (metarea = 80) is in the IPUMS sample but not in any OMB documentation that I can find. Any idea what's going on here? Thanks!

Source: http://www.census.gov/population/metr...

 

Jan 15, 2015 - 04:02 PM

0
0
Report it
avatar

Joe_Grover

Staff

In the text file you linked to, Akron, OH can be found listed under PMSA FIPS code 0080.


I hope this helps.

 

Jan 16, 2015 - 08:50 AM

0
0
Report it

Thanks! What about METAREAs that are neither in the 1990 OMB documentation now the METAREA translation tables? Any idea where these are coming from? A few are listed below.


NAME (METAREA)

Bend, OH (900)

Bowling Green, KY (1130)

Coeur d’Alene, ID (1700)

El Centro, CA (2300)

Farmington, NM (2540)

Harrisonburg, VA (3260)

Kingston, NY (3830)

Las Vegas-Paradise, NM (4130)

Madera, CA (4700)

Michigan City-La Porte (5020)

Monroe, MI (5220)

Ocean City, NJ (5840)

Prescott, AZ (6470)

Salisbury, MD (7130)

Valdosta, GA (8700)

Vero Beach, FL (8740)

 

Jan 27, 2015 - 11:50 AM

0
0
Report it
avatar

Tim_Moreland

Staff

The METAREA values that you list are available in the IPUMS-CPS data, but they are not available in the IPUMS-USA data. Since the Translation Tables linked to above pertain to the IPUMS-USA version of the METAREA variable, those metro areas cannot be found in the Translation Table. As well, those metro areas were not part of the 1990 OMB delineation, which is why they are not included in the OMB file. You can, however, find these metro areas in more recent versions of the OMB delineation file, e.g. Dec 2009.


Hope this helps.

 

Jan 28, 2015 - 04:20 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

ind1990 for IPUMS-USA: crosswalk recode between 1990 and 2000 Census classifi...
How do I create a variable for the racial composition of the PUMA using IPUMS...
How can I generate MSA-level data with consistent MSA boundaries in 1990, 200...
total population from 2000 census 5% sample
Login   |   Register

Recently Active Members

View More »

Share |