Connecticut's 2022 Geographic Reorganization and FIPS Codes
In 2022, Connecticut replaced its 8 historical counties with 9 planning regions for federal statistical purposes. Here's what changed and why it matters for data work.
In 2022, Connecticut made a major change to its county-level geography that affects anyone working with federal datasets for the state. Connecticut's 8 historical counties — established in 1666 and long used for statistical purposes despite having no actual county government — were replaced with 9 planning regions as the state's county-equivalent geographic units for federal data. The new planning regions have new 5-digit FIPS codes in the 09XXX range, replacing the old 8-county codes.
The old Connecticut counties (09001 Fairfield, 09003 Hartford, 09005 Litchfield, 09007 Middlesex, 09009 New Haven, 09011 New London, 09013 Tolland, 09015 Windham) are no longer the primary county-equivalent geography for federal statistical programs. The new 9 planning regions have codes 09110 through 09190. Most federal datasets began using the new codes starting with 2022 data, meaning any analysis spanning pre- and post-2022 requires a crosswalk between the old and new geographies.
This change directly affects Census ACS data, BLS employment data, EPA environmental data, and any other federal dataset that uses Connecticut county-level geography. If you're building a time series for Connecticut counties that extends from, say, 2018 to 2024, you'll hit a discontinuity in 2022 where the geographic units change. The Census Bureau publishes a crosswalk showing which old counties map to which new planning regions, but the mapping isn't always clean — some old county areas were split across new planning regions.
For current Connecticut data, use the 9 new planning region FIPS codes (09110–09190). For historical data, use the 8 old county codes (09001–09015). Our FIPS database reflects the current standard (the 9 planning regions are in the OMB 2023 delineation for MSA membership, though Connecticut's MSA assignments have also been updated). Use Connecticut's state page to browse current county-equivalent geography, and see the FIPS explainer for context on how geographic changes are handled.
More Articles
Seattle-Tacoma-Bellevue MSA (42660): Regional Economic Data
The Seattle-Tacoma-Bellevue MSA is home to Amazon, Microsoft, and Boeing. Here's a data-driven profile of MSA 42660 using BLS, Census, and BEA sources.
Aug 15, 2026
FIPS Codes in Excel: VLOOKUP and Power Query Tips
Excel is still widely used for federal data analysis. Here's how to handle FIPS codes correctly in Excel using text formatting, VLOOKUP, and Power Query.
Aug 23, 2026
Los Angeles County (FIPS 06037): Data Profile
Los Angeles County is the most populous county in the United States. Here's what the data says about FIPS code 06037 and why it's one of the most-studied geographies in federal datasets.
Jul 14, 2026