Skip to main content

* Starting 2022 on, the FIPS to CBSA Crosswalk table published by CMS under IPPS stopped including ssa_codes. Therefore the Stata, SAS, and CSV files for those years are a combination of the Crosswalk and the Medicare  Advantage (MA) Ratebook which contains SSA and county names.

Los Angeles FIPS 06037 can have two SSA county codes: 05210 and 05200. Los Angeles is the only FIPS county with multiple SSA codes.

According to CMS the MSABEA file is no longer updated.
 

Fiscal Year or DateSourceStataSASCSVDesc
2026zipdtasas7bdacsv 
2025xlsdtasas7bdatcsv 
2024xlsdtasas7bdatcsvdesc
2023xlsdtasas7bdatcsvdesc
2022xlsdtasas7bdatcsvdesc
2021*xlsdtasas7bdatcsvdesc
2020xlsdtasas7bdatcsvdesc
2019xlsdtasas7bdatcsvdesc
2018xlsdtasas7bdatcsvdesc
2017xlsdtasas7bdatcsvdesc
2016xlsdtasas7bdatcsvdesc
2015xlsdtasas7bdatcsvdesc
2014xlsdtasas7bdatcsvdesc
2013xlsdtasas7bdatcsvdesc
2012xlsdtasas7bdatcsvdesc
2011xlsdtasas7bdatcsvdesc
CMS did not produce SSA to FIPS state and county crosswalk files between the 2003-08-19 and 2011.     
2003-08-19zipdtasas7bdatcsvdesc

In the 2003-08-19 Source crosswalk file, Angoon, Alaska with SSA county code 02030 has a fips county code of 02031. This FIPS county code does not seem to exist elsewhere, and it appears that the fips county value should be 02231, so this change has been made to the SAS and Stata files.

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

** Starting 2024 the Census Bureau has adopted the State of Connecticut's nine planning regions as county-equivalent geographic units. This change is observed in the 2025 International Committee for Information Technology Standards (INCITS) (formerly Federal Information Processing Standard (FIPS)) Codes to CBSA Crosswalk, but has not been implemented in the SSA County Codes in the MA Ratebook. Therefore it is not possible to generate a crosswalk for Connecticut. Researcher's might find useful Missouri Census Data Center's Geocorr 2022 that generates geographical correspondence tables between using 2020 census population, area or housing units as weights.

The following merges 2024 FIPS codes and ssa codes.

fipscountystatecountyname_fipscbsa_codecbsa_namessa_codestate_namecountyname_rate
FAIRFIELDCT900114860Bridgeport-Stamford-Norwalk, CT7000CONNECTICUTFAIRFIELD
HARTFORDCT900325540Hartford-East Hartford-Middletown, CT7010CONNECTICUTHARTFORD
LITCHFIELDCT9005  7020CONNECTICUTLITCHFIELD
MIDDLESEXCT900725540Hartford-East Hartford-Middletown, CT7030CONNECTICUTMIDDLESEX
NEW HAVENCT900935300New Haven-Milford, CT7040CONNECTICUTNEW HAVEN
NEW LONDONCT901135980Norwich-New London, CT7050CONNECTICUTNEW LONDON
TOLLANDCT901325540Hartford-East Hartford-Middletown, CT7060CONNECTICUTTOLLAND
WINDHAMCT901549340Worcester, MA-CT7070CONNECTICUTWINDHAM

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
Background Materials:backgroundAthey, Susan, Undral Byambadalai, Vitor Hadad, Sanath Kumar Krishnamurthy, Weiwen Leung...