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 the 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.

 2025, 17th Annual Feldstein Lecture, N. Gregory Mankiw," The Fiscal Future"
  • Feldstein Lecture
N. Gregory Mankiw, Robert M. Beren Professor of Economics at Harvard University, presented the 2025 Martin Feldstein...
 2025 Methods Lecture, Raj Chetty, "Uncovering Causal Mechanisms: Mediation Analysis and Surrogate Indices"
  • Methods Lectures
SlidesBackground materials on mediationImai, Kosuke, Dustin Tingley, and Teppei Yamamoto. (2013). “Experimental Designs...
 Economics of Social Security Panel, "Challenges of Long-Term Social Security Forecasting" Primary tabs
  • Panel Discussion
  • Presenters: Molly Dahl, Sophie Shin, Mark Warshawsky, Sven Sinclair & Polina Vlasenko
Supported by the Alfred P. Sloan Foundation grant #G-2023-19633, the Lynde and Harry Bradley Foundation grant #20251294...