Delaware county FIPS codes
Every Delaware county FIPS code with name, type, area, centre point and ZIP count, as CSV, Excel or JSON. Updated 19 November 2026.
Delaware counties and FIPS codes
Delaware has state FIPS code 10, and this list has 3 counties and county equivalents: 3 counties. Each full FIPS code joins the state code and a three-digit county code, so Kent County is 10001: 10 for Delaware and 001 for the county.
By area the largest is Sussex at about 2,453 km² (947 sq mi) and the smallest is New Castle at about 1,154 km² (446 sq mi); the counties add up to about 5,172 km². New Castle has the most ZIP codes assigned to it (52).
All 3 counties
| FIPS | Name | Type | Area km² | Latitude | Longitude | ZIP codes |
|---|---|---|---|---|---|---|
| 10001 | Kent County | County | 1,565 | 39.090208 | -75.571212 | 21 |
| 10003 | New Castle County | County | 1,154 | 39.535081 | -75.671805 | 52 |
| 10005 | Sussex County | County | 2,453 | 38.667782 | -75.405302 | 23 |
File: delaware-county-fips-codes.csv
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 even though Delaware's codes start with 1: codes in states such as Alabama (01) and California (06) start with 0, and a number column drops that zero as soon as you combine states.
-- 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 = 'DE';In Excel, build the 5-digit code from two parts with =TEXT(A2,"00")&TEXT(B2,"000"), where A2 is the state code (10) and B2 the county code.
Where the data comes from
Names, types, areas and centre points come from Natural Earth's 1:10m admin-2 counties (version 5.1.1, public domain). We checked every FIPS code against the GeoNames admin-2 list: 3 of 3 match. ZIP counts come from the GeoNames postal code file on the Delaware ZIP code page.
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 |