| Schedule | Always Up-to-date. Official USPS monthly updates are applied before the first day of each month. Everything else is applied immediately. |
|---|---|
| Access to Data | Direct download anytime from account dashboard. Custom downloads via online utility included with purchase (see 30 sec video). Free FTP/SFTP access upon request. File formats CSV, Excel |
| Record Count | This file has a record for each ZIP Code containing the official USPS city name. Also included is a pipe-delimited field containing any accepted or alternative city names within the ZIP Code. Approximately 42k records and 60k city names. |
| Cleansing | Cleansing is the key to high-end data. USPS databases have thousands of errors (duplicates, misapplied locations, bad names). Our algorithms have tens of thousands built-in edits for accuracy and standardization. We continually monitor changes. |
To automate database updates via your script, we provide an FTP access. Just request it after purchase.
Comma-Separated Values (CSV) Text File, Excel
Subscriptions include free supplemental files containing full names or extended data that correspond to codes or abbreviations found in product (states.csv, msa-list.csv, cmsa-all.csv)
Official U.S. Postal Service five digit ZIP Code
U.S. Postal Service classification code:
(blank) – Standard ZIP Code for a general area
M – Military APO / FPO
P – P.O. Boxes
U – Unique to organization / private
Official U.S. Postal Service state abbreviation
Federal Information Processing Standard (FIPS) 2‐digit state. FIPS codes are not available for all areas (APO, FPO, some U.S. Territories).
The name of the county in which the ZIP Code is found.
Federal Information Processing Standard (FIPS) 3‐digit county. FIPS codes are not available for all areas (APO, FPO, some U.S. Territories).
Official preferred city name used by the U.S. Postal Service
Lat/Lon: Approximate ZIP Code center point. Our ZIP Code Premium version has population‐based center points, when available. Our ZIP Code Standard has shape-based centers.
Up-to-date population count from Census Bureau. Unpopulated ZIP Codes, such as P.O. Boxes and businesses, will have a zero in this field.
Metropolitan Statistical Area (MSA) codes are greater metropolitan areas as defined by the U.S. Office of Management & Budget. These areas usually represent the surrounding county or counties (if within commuting distance) of a city having 50,000 plus inhabitants.
Primary area code for each ZIP Code.
Standardized based on Coordinated Universal Time (UTC). Time zones range from ‐5 (Eastern Standard Time) to ‐10 (Hawaiian Standard Time).
Indicates if Daylight Savings Time is observed in that ZIP Code.
City names that the USPS considers valid for a ZIP Code, albeit not the preferred city name (See City field for preferred).
A unique key that combines the 5-digit ZIP Code with the 6-digit CityState key used by the USPS (the two are separated by a hyphen). Both correlate to other official USPS databases.
View the Product Documentation
