DataBrighten

    Connecticut county FIPS codes

    9planning regions · state FIPS 09

    Every Connecticut county FIPS code with name, type, area, centre point and ZIP count, as CSV, Excel or JSON. Updated 19 November 2026.

    textnumberdateyes/no
    State FIPS09Connecticut
    Planning9planning regions
    LargestCapitolby ZIP codes
    LicenceCC BY 4.0GeoNames

    Connecticut counties and FIPS codes

    Connecticut has state FIPS code 09, and this list has 9 counties and county equivalents: 9 planning regions. Each full FIPS code joins the state code and a three-digit county code, so Capitol Planning Region is 09110: 09 for Connecticut and 110 for the county.

    Capitol has the most ZIP codes assigned to it (119).

    In 2022 the Census Bureau replaced Connecticut's eight counties with its nine planning regions as county equivalents, so current federal data uses the codes 09110 to 09190 shown here. The old county codes (09001 to 09015) still appear in data from before 2022; they are listed below from Natural Earth so you can map old files.

    All 9 planning regions

    FIPSNameTypeArea km²LatitudeLongitudeZIP codes
    09110Capitol Planning RegionPlanning Region119
    09120Greater Bridgeport Planning RegionPlanning Region20
    09130Lower Connecticut River Valley Planning RegionPlanning Region25
    09140Naugatuck Valley Planning RegionPlanning Region41
    09150Northeastern Connecticut Planning RegionPlanning Region31
    09160Northwest Hills Planning RegionPlanning Region34
    09170South Central Connecticut Planning RegionPlanning Region48
    09180Southeastern Connecticut Planning RegionPlanning Region36
    09190Western Connecticut Planning RegionPlanning Region64

    File: connecticut-county-fips-codes.csv

    Connecticut's former counties (before 2022)

    FIPSCountyArea km²
    09001Fairfield1,688
    09003Hartford1,945
    09005Litchfield2,415
    09007Middlesex982
    09009New Haven1,551
    09011New London1,739
    09013Tolland1,064
    09015Windham1,324

    Source: Natural Earth 5.1.1, public domain.

    Using FIPS codes

    FIPS codes are the join key for most US county data, from Census population tables to election results and BLS unemployment files. Store them as five-character text: as a number, 09110 would lose its leading zero (all of Connecticut's codes start with 0).

    -- add county names to any table that has a 5-digit fips column
    SELECT d.*, c.name AS county_name
    FROM my_data d
    LEFT JOIN county_fips c ON c.fips = d.fips
    WHERE c.state = 'CT';

    In Excel, build the 5-digit code from two parts with =TEXT(A2,"00")&TEXT(B2,"000"), where A2 is the state code (9) and B2 the county code.

    Where the data comes from

    The nine planning regions and their codes come from the GeoNames admin-2 list (CC BY 4.0); Natural Earth 5.1.1 still has the old counties, shown in the second table. ZIP counts come from the GeoNames postal code file.

    Data dictionary

    ColumnTypeMeaning
    fipstextFive-digit county FIPS code
    state_fipstextTwo-digit state FIPS code
    county_fipstextThree-digit county code within the state
    nametextShort name
    full_nametextName with its type, e.g. 'Kent County'
    typetextCounty, Parish, Borough, City, Census Area, Planning Region…
    statetextTwo-letter state code
    state_nametextState name
    area_sq_kmnumberArea in km² (Natural Earth; rounded)
    latitudenumberCentre point latitude (Natural Earth)
    longitudenumberCentre point longitude (Natural Earth)
    zip_codesnumberZIP codes assigned to it in the GeoNames postal list
    wikidata_idtextWikidata item, for linking to other data