Free US ZIP code database

Every US ZIP code — all 41,711 of them, including PO-box-only and military codes — with its town, state, county and FIPS code, coordinates, population and telephone area codes. One row per ZIP code, as CSV, JSON or SQLite. Free for any use, commercial included, under CC BY 4.0. Data release 2026-10-12.

Always the newest release, at addresses that do not change: https://zipcodes.pro/download/us-zip-codes.csv, https://zipcodes.pro/download/us-zip-codes.json, https://zipcodes.pro/download/us-zip-codes.sqlite. Also here: LICENSE.txt, FIELDS.csv (the field dictionary), SOURCES.csv and checksums. Files are served with open CORS, so a browser app can fetch them directly.

What the rows look like

A blank is a value no source publishes for that ZIP code, never a zero: a ZIP code that only serves PO boxes has no residents counted, and a military code has no county or fixed location.

Fields

"Filled" counts the rows with a value, out of 41,711. In the JSON, county_fips_all and area_codes are arrays; in the CSV and SQLite they are separated by |. ZIP codes are text, so 00601 keeps its leading zeros; when opening the CSV in Excel, import the zip column as text.

Licence and credit

ZIP code data from zipcodes.pro (https://zipcodes.pro/download), CC BY 4.0. Includes U.S. Census Bureau data (public domain) and GeoNames (CC BY 4.0).

ZIP code data from <a href="https://zipcodes.pro/download">zipcodes.pro</a> (<a href="https://creativecommons.org/licenses/by/4.0/">CC BY 4.0</a>)

Sources

Using it

# Python / pandas: keep the ZIP codes as text
import pandas as pd
zips = pd.read_csv("https://zipcodes.pro/download/us-zip-codes.csv", dtype={"zip": str, "county_fips": str, "parent_zcta": str})

# SQLite
curl -O https://zipcodes.pro/download/us-zip-codes.sqlite
sqlite3 us-zip-codes.sqlite "SELECT zip, city, county_name FROM zips WHERE state = 'VT' LIMIT 5"

# JavaScript
const zips = await fetch("https://zipcodes.pro/download/us-zip-codes.json").then((r) => r.json());

What is not in it

• Time zones. Ours are looked up in OpenStreetMap-derived boundaries, licensed ODbL, which cannot be relicensed as CC BY. They are on every ZIP code page and in the paid editions.
• Demographics beyond population, business counts, metro areas, nearby ZIP codes and boundaries. Those are in the Core and Complete editions, with monthly updates.
• USPS delivery details. ZIP+4, carrier routes and the USPS list of acceptable city names come only from USPS-licensed data, which no free source carries.

Updates

The files are rebuilt with every data release, from the same database that answers every page on this site, so a row here and the page for that ZIP code always agree. File names carry the release date, so a link to one release keeps pointing at it; the names without a date follow the newest. Found something wrong? Email [email protected] with the ZIP code and the field.

Need to look up a list rather than download everything? The bulk lookup tool appends city, county and coordinates to a pasted list, and the API answers one ZIP code at a time.