DataBrighten

    ZIP code to county list for every US state

    40,977ZIP codes · 50 states and DC

    Every US ZIP code with its county and county FIPS code in one file, or one file per state. Updated 19 November 2026.

    textnumberdateyes/no
    ZIP codes40,977one row each
    States5150 states + DC
    Counties3,147with at least one ZIP
    LicenceCC BY 4.0credit GeoNames

    What is in the file

    One row for each of 40,977 ZIP codes in the 50 states and the District of Columbia, with the place name, the county it is assigned to, the five-digit county FIPS code and an approximate latitude and longitude. The codes are assigned to 3,147 different counties and county equivalents. Texas has the most ZIP codes (2,600), then California (2,593) and Pennsylvania (2,176); Rhode Island has the fewest (90).

    Military APO, FPO and DPO codes and the territories are left out, because they have no county. Each ZIP code is given one county, the one GeoNames assigns. A ZIP code is a delivery route rather than a boundary, so a few hundred ZIP codes also reach into a neighbouring county; for those, the county here is the main one, not the only one.

    Use it to add a county to your data

    Most address files have a ZIP code but no county. Join on the zip column and you get the county name and FIPS code, which is the key that Census, BLS and election files use. Keep zip as text so codes that begin with 0, as in New England and New Jersey, keep their leading zero.

    import pandas as pd
    z = pd.read_csv("us-zip-codes.csv", dtype={"zip": str, "county_fips": str})
    customers = customers.merge(z[["zip", "county", "county_fips"]], on="zip", how="left")
    -- SQL: count customers per county
    SELECT z.county_fips, z.county, z.state, COUNT(*) AS customers
    FROM customers c
    JOIN us_zip_codes z ON z.zip = c.zip
    GROUP BY z.county_fips, z.county, z.state
    ORDER BY customers DESC;

    ZIP codes by state

    StateCodeZIP codesCountiesFiles
    AlabamaAL81167CSV · XLSX
    AlaskaAK27330CSV · XLSX
    ArizonaAZ53015CSV · XLSX
    ArkansasAR70675CSV · XLSX
    CaliforniaCA2,59358CSV · XLSX
    ColoradoCO64564CSV · XLSX
    ConnecticutCT42915CSV · XLSX
    DelawareDE963CSV · XLSX
    District of ColumbiaDC2771CSV · XLSX
    FloridaFL1,47367CSV · XLSX
    GeorgiaGA952157CSV · XLSX
    HawaiiHI1374CSV · XLSX
    IdahoID32044CSV · XLSX
    IllinoisIL1,575102CSV · XLSX
    IndianaIN96892CSV · XLSX
    IowaIA1,05599CSV · XLSX
    KansasKS748105CSV · XLSX
    KentuckyKY946120CSV · XLSX
    LouisianaLA71964CSV · XLSX
    MaineME48516CSV · XLSX
    MarylandMD60524CSV · XLSX
    MassachusettsMA68514CSV · XLSX
    MichiganMI1,15983CSV · XLSX
    MinnesotaMN99287CSV · XLSX
    MississippiMS53182CSV · XLSX
    MissouriMO1,157115CSV · XLSX
    MontanaMT40456CSV · XLSX
    NebraskaNE62093CSV · XLSX
    NevadaNV25417CSV · XLSX
    New HampshireNH28110CSV · XLSX
    New JerseyNJ72321CSV · XLSX
    New MexicoNM42733CSV · XLSX
    New YorkNY2,15462CSV · XLSX
    North CarolinaNC1,081100CSV · XLSX
    North DakotaND40753CSV · XLSX
    OhioOH1,41688CSV · XLSX
    OklahomaOK76577CSV · XLSX
    OregonOR48136CSV · XLSX
    PennsylvaniaPA2,17667CSV · XLSX
    Rhode IslandRI905CSV · XLSX
    South CarolinaSC53446CSV · XLSX
    South DakotaSD38566CSV · XLSX
    TennesseeTN78595CSV · XLSX
    TexasTX2,600254CSV · XLSX
    UtahUT34729CSV · XLSX
    VermontVT30814CSV · XLSX
    VirginiaVA1,214133CSV · XLSX
    WashingtonWA71639CSV · XLSX
    West VirginiaWV85155CSV · XLSX
    WisconsinWI89672CSV · XLSX
    WyomingWY19523CSV · XLSX

    Data dictionary

    ColumnTypeMeaning
    ziptextFive-digit ZIP code
    placetextPlace name used by the postal service
    countytextCounty or county equivalent the ZIP code is assigned to
    county_fipstextFive-digit county FIPS code
    statetextTwo-letter state code
    state_nametextState name
    latitudenumberApproximate centre (GeoNames estimate)
    longitudenumberApproximate centre (GeoNames estimate)