NATIONAL BUREAU OF ECONOMIC RESEARCH
NATIONAL BUREAU OF ECONOMIC RESEARCH

CMS's SSA to FIPS CBSA and MSA County Crosswalk

CMS periodically produces SSA to FIPS CBSA to county crosswalk files. They released a CBSA to MSA to FIPS county crosswalk as well. Some CMS data files have SSA state and county codes or county name rather than FIPS state and county codes. Jean Roth processed the data files below for greater ease of use.

Updates and changes.


The MSA CBSA FIPS County crosswalk below is a merge of the individual CBSA and MSA files below.
Some notes about the data are the following:

Los Angeles FIPS 06037 can have two SSA county codes: 05210 and 05200.
Los Angeles is the only FIPS county with multiple SSA codes.
2012 and 2013 files are identical.
2005 and 2011 file have 3,289 counties and 2012-2013 have 3,273 counties.
A list of the counties present in 2011 and not in 2012 is in Updates and changes

Combined MSA CBSA FIPS County Crosswalk 2005, 2011-2013
SAS
Stata
CSV




CBSA to SSA and FIPS State and County Crosswalk
FY 2013
Source ZIP
Source Excel
Source txt
SAS
Stata
FY 2012
Source ZIP
Source Excel
Source txt
SAS
Stata
FY 2011
Source ZIP
Source Excel
Source txt
SAS
Stata



This file is a crosswalk by county from the old MSA to the New MSA (under the CBSA definitions) and includes SSA state and county as well.

New MSA (Under CBSA Definitions) to Old MSA Crosswalk File
FY 2005
Source Excel
Source ZIP
Source txt
SAS
Stata

To report errors, or if you have comments or suggestions e-mail jroth@nber.org

Last Update: November 9, 2012 Created by Jean Roth September 19, 2012

 
Publications
Activities
Meetings
Data
People
About

Support
National Bureau of Economic Research, 1050 Massachusetts Ave., Cambridge, MA 02138; 617-868-3900; email: info@nber.org

Contact Us