Skip to main content

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

CMS delivered the same source spreadsheet in the FY 2014 and FY 2013 deliveries.
This could mean that CMS made no changes to the source file and reused the same file in the next year when the underlying data had no change..

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

CMS did not produce SSA to MSA or CBSA crosswalks between 2005-2011.
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.

FY 2005

Source ZIP

Source Excel

Source txt

SAS

Stata

CSV

Desc

Not Applicable

Contact data@nber.org with questions, comments, or suggestions.

Related

Topics

Data Categories

More from NBER

In addition to working papers, the NBER disseminates affiliates’ latest findings through a range of free periodicals — the NBER Reporter, the NBER Digest, the Bulletin on Retirement and Disability, the Bulletin on Health, and the Bulletin on Entrepreneurship — as well as online conference reports, video lectures, and interviews.

2024, 16th Annual Feldstein Lecture, Cecilia E. Rouse," Lessons for Economists from the Pandemic" cover slide
  • Feldstein Lecture
Cecilia Rouse, president of the Brookings Institution and a professor at Princeton University, who chaired the Council...
 2024 Methods Lecture, Susan Athey, "Analysis and Design of Multi-Armed Bandit Experiments and Policy Learning"
  • Methods Lectures
SlidesBackground Materials:backgroundAthey, Susan, Undral Byambadalai, Vitor Hadad, Sanath Kumar Krishnamurthy, Weiwen...