Connecticut county FIPS codes
Every Connecticut county FIPS code with name, type, area, centre point and ZIP count, as CSV, Excel or JSON. Updated 19 November 2026.
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
| FIPS | Name | Type | Area km² | Latitude | Longitude | ZIP codes |
|---|---|---|---|---|---|---|
| 09110 | Capitol Planning Region | Planning Region | 119 | |||
| 09120 | Greater Bridgeport Planning Region | Planning Region | 20 | |||
| 09130 | Lower Connecticut River Valley Planning Region | Planning Region | 25 | |||
| 09140 | Naugatuck Valley Planning Region | Planning Region | 41 | |||
| 09150 | Northeastern Connecticut Planning Region | Planning Region | 31 | |||
| 09160 | Northwest Hills Planning Region | Planning Region | 34 | |||
| 09170 | South Central Connecticut Planning Region | Planning Region | 48 | |||
| 09180 | Southeastern Connecticut Planning Region | Planning Region | 36 | |||
| 09190 | Western Connecticut Planning Region | Planning Region | 64 |
File: connecticut-county-fips-codes.csv
Connecticut's former counties (before 2022)
| FIPS | County | Area km² |
|---|---|---|
| 09001 | Fairfield | 1,688 |
| 09003 | Hartford | 1,945 |
| 09005 | Litchfield | 2,415 |
| 09007 | Middlesex | 982 |
| 09009 | New Haven | 1,551 |
| 09011 | New London | 1,739 |
| 09013 | Tolland | 1,064 |
| 09015 | Windham | 1,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
| Column | Type | Meaning |
|---|---|---|
| fips | text | Five-digit county FIPS code |
| state_fips | text | Two-digit state FIPS code |
| county_fips | text | Three-digit county code within the state |
| name | text | Short name |
| full_name | text | Name with its type, e.g. 'Kent County' |
| type | text | County, Parish, Borough, City, Census Area, Planning Region… |
| state | text | Two-letter state code |
| state_name | text | State name |
| area_sq_km | number | Area in km² (Natural Earth; rounded) |
| latitude | number | Centre point latitude (Natural Earth) |
| longitude | number | Centre point longitude (Natural Earth) |
| zip_codes | number | ZIP codes assigned to it in the GeoNames postal list |
| wikidata_id | text | Wikidata item, for linking to other data |