Hi,
I’ve been trying to link 2000 tract-level data to 2000 MSA, the best file is a text file relationship file from 2003 (which from what I gather uses 2000 tract definitions), attached below. But wanted to see if there is a cvs file available that does this?
Thanks!
First, it depends on which version of MSAs you consider to be “2000 MSAs”. The Office of Management and Budget (OMB) updates MSA definitions on an irregular schedule. There are officially no “2000” definitions. There are 1999 definitions, which were used in 2000 Census data, and there are 2003 definitions, which were constructed based on 2000 Census population and commuting data.
If you request any data table from IPUMS NHGIS for census tracts from the 2000 Census, you can choose to get the file in CSV format, and it will contain a field identifying 1999 MSA codes (including CMSAs–Consolidated MSAs–which are combinations of PMSAs–Primary MSAs). However, it doesn’t contain complete MSA information for all tracts in New England because 1999 New England MSAs are defined as sets of towns & cities–not counties–which means that some New England census tracts contain parts of multiple 1999 MSAs.
The Geocorr 2000 website provides the same correspondence information in CSV format, including all associations in New England (with information about how much of each tract’s population was in each New England MSA).
For correspondences to 2003 MSAs, I would go to the Census Bureau’s Historical Delineation Files page and get the June 2003 version of the “Counties with metropolitan and micropolitan statistical area codes” file. That gives you a simple Excel spreadsheet of correspondences between counties and MSAs, which you could convert to CSV and join to tract data based on county identifiers.
