* 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 Date | Source | Stata | SAS | CSV | Desc |
2026 | zip | dta | sas7bda | csv | |
2025 | xls | dta | sas7bdat | csv | |
2024 | xls | dta | sas7bdat | csv | desc |
2023 | xls | dta | sas7bdat | csv | desc |
2022 | xls | dta | sas7bdat | csv | desc |
2021* | xls | dta | sas7bdat | csv | desc |
2020 | xls | dta | sas7bdat | csv | desc |
2019 | xls | dta | sas7bdat | csv | desc |
2018 | xls | dta | sas7bdat | csv | desc |
2017 | xls | dta | sas7bdat | csv | desc |
2016 | xls | dta | sas7bdat | csv | desc |
2015 | xls | dta | sas7bdat | csv | desc |
2014 | xls | dta | sas7bdat | csv | desc |
2013 | xls | dta | sas7bdat | csv | desc |
2012 | xls | dta | sas7bdat | csv | desc |
2011 | xls | dta | sas7bdat | csv | desc |
CMS did not produce SSA to FIPS state and county crosswalk files between the 2003-08-19 and 2011. | |||||
2003-08-19 | zip | dta | sas7bdat | csv | desc |
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.
fipscounty | state | countyname_fips | cbsa_code | cbsa_name | ssa_code | state_name | countyname_rate |
FAIRFIELD | CT | 9001 | 14860 | Bridgeport-Stamford-Norwalk, CT | 7000 | CONNECTICUT | FAIRFIELD |
HARTFORD | CT | 9003 | 25540 | Hartford-East Hartford-Middletown, CT | 7010 | CONNECTICUT | HARTFORD |
LITCHFIELD | CT | 9005 | 7020 | CONNECTICUT | LITCHFIELD | ||
MIDDLESEX | CT | 9007 | 25540 | Hartford-East Hartford-Middletown, CT | 7030 | CONNECTICUT | MIDDLESEX |
NEW HAVEN | CT | 9009 | 35300 | New Haven-Milford, CT | 7040 | CONNECTICUT | NEW HAVEN |
NEW LONDON | CT | 9011 | 35980 | Norwich-New London, CT | 7050 | CONNECTICUT | NEW LONDON |
TOLLAND | CT | 9013 | 25540 | Hartford-East Hartford-Middletown, CT | 7060 | CONNECTICUT | TOLLAND |
WINDHAM | CT | 9015 | 49340 | Worcester, MA-CT | 7070 | CONNECTICUT | WINDHAM |