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.

Users should be aware that it appears that CMS did not update their SSA to FIPS county crosswalk to use 2010 Census definitions. It should be possible; however, to link the FIPS county codes in this file to those in Census' CBSA to FIPS County Crosswalk file to get more up to date CBSA definititions.

Some additional 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-2016 files are identical.
2005 and 2011 file have 3,289 counties and 2012-2016 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-2017
SAS
Stata
CSV
Desc




CBSA to SSA and FIPS State and County Crosswalk
Fiscal Year
Source ZIP
Source Excel
Source Text
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2017
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2016
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2015
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2014
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2013
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2012
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1
2011
Source ZIP
Source Excel
Source txt
SAS
Stata
CSV
Desc
Diff Year N+1
Diff Year N-1



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
CSV
Desc

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

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

 
Publications
Activities
Meetings
NBER Videos
Themes
Data
People
About

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

Contact Us