When you download our U.S. or Canadian Postal Code^OM databases, you can choose between 4 separate formats for download, saving on conversion time and effort. Our zip codes database has the most comprehensive and precise data that you will find. You can perform free database lookups on our website with our software or you can download our ZIP codes database for data manipulation. Our free ZIP codes finder helps you find the ZIP codes and related demographic information for any U.S. or Canadian Postal Code^OM.

ZIP Code & Postal Code Facts

Zip Codes are largely responsible for the automation of the United States Post Office’s mail handling. Today, over 600,000,000 pieces of mail are delivered each business day, and our mail can take as little as one day to reach its destination. Back in 1799, it could take three weeks for a letter to travel from Lexington, Massachusetts to Philadelphia, Pennsylvania. The cost of mail was relatively much higher back then. It cost twenty-five cents to send a letter 450 miles – not much less than it costs today to send a letter anywhere in the country, and in considerably less time!

Today, many of us in the United States expect to have our mail delivered to our homes and offices at no extra charge. Before July 1, 1863, city residents had to pay to have a postal worker bring their mail to them; rural customers had to travel to pick up their own mail for another 30 years. Zip codes wouldn't have helped much in those days.

For the purposes of our free zip code database downloads, we will commonly list either the most common region for the ZIP code or list multiple regions if several exist in the ZIP code. For cities, the assignment is somewhat more complicated. USPS does not always use the city in which the ZIP code is located. If you want to send more than pieces of Every Door Direct Mail per ZIP code, sign in as a BMEU customer to continue. Need more information on Every Door Direct Mail (BMEU) requirements? Learn more ›.

Many famous Americans have been postal workers. Benjamin Franklin is known as “The Father of the United States Postal Service.” Abraham Lincoln was postmaster of New Salem, Illinois in the 1830’s, and it is rumored that he personally delivered mail by carrying it in his hat along with a list of delivery places. Harry S. Truman was postmaster of Grandview, Missouri for a time. William Faulkner was postmaster of the University of Mississippi Post Office.

Perhaps the most romantic era in our United States postal history is that of the Pony Express. Before then, stagecoaches took more than 20 days to deliver mail from coast to coast. In 1860, William H. Russell bought strong horses and put a listing for good horseback riders in newspaper ads that read: “Wanted: Young, skinny, wiry fellows not over 18. Must be expert riders willing to risk death daily. Orphans preferred.” Russell’s Pony Express was in service for 18 months, cutting the time it took for mail delivery coast to coast in half. The service closed in 1861 when telegraph lines connecting the coasts were finished being laid, allowing people to send information much faster and cheaper than they could by Pony Express.

The history of the United States Post Office is filled with fascinating data and amusing facts. Did you know the first Post Office in the United States was actually a tavern? Or that the United States employed camels to deliver mail over deserts in the Southwest? Or that one of the first airmail deliveries involved a three mile flight, and that the pilot dropped the bag of mail from the flying plane to a postmaster waiting below?

Zip Codes didn’t come into use until 1963. Their inventor, Robert Aurand Moon, is known as the “Father of ZIP Codes” and was nicknamed “Mr. ZIP Code.” Another character also went by this name: the lovable cartoon ambassador, Mr. Zip or Mr. Zippy, who some think was largely responsible for the success of United States ZIP code compliance.

And just what are ZIP Codes? And how does the United States Post Office use them? What do the numbers stand for? Where does the ZIP code data come from? How about the ZIP + 4 Codes? There’s plenty to learn about the Zoning Improvement Plan Codes!

To learn more about our ZIP Code finder - US ZIP Code Database Lists with Demographics Information, please view our FAQ's.

Load USPS Zip Code File (LZPS)

Purpose: Use this option to upload city/state/zip data from the U.S. Postal Service into the City/State/Zip (postal code) table.

Overview: The City State product, available from the U.S. Postal Service, provides a listing of ZIP codes with their associated city or town and state names. Updates are available on a periodic basis. Uploading this information provides an automated means to create records in your City/State/Zip table and keep the data in the table complete and accurate.

In this topic:

• Upload Process

• Load USPS File Screen

• Fields in the USPS Zip/City/State Table

• Fields in the Zip/City/State Table

• Troubleshooting the Zip/City/State Upload

Upload Process

1. When you receive the City State product, copy the data file to the location on your application server specified in the CWDIRECTCP_USPS_ UPLOAD_FILE setting in the CWDirectCP Properties File. By default, this setting indicates a file name of ctystate.txt in the C:CWSerenadeLZIP directory on your application server, but you can override this default.

2. While logged onto the application server specified by the properties file setting and where the data file has been copied, advance to the Load USPS File Screen. From this screen, you can submit the LZPS job, which uses the contents of the ctystate.txt data file to create records in the Zip/City/State table if these records do not already exist. The job performs the following steps:

• First, the job deletes any existing records in the USPS Zip/City/State work table and creates a record in this table for each eligible entry from the ctystate.txt data file. A record in the data file is eligible for upload if it is flagged with a D (detail) and is also flagged as mailable. See the Fields in the USPS Zip/City/State Table for mapping details.

• Next, the job compares the data in the USPS Zip/City/State work table with the existing records in the Zip/City/State table. If a record in the work table does not exist in the Zip/City/State table, the job creates it.

• Finally, if your current logging level supports it, the job uses the CWSerenade Application Log to track data such as the total number of records found in the data file and the total number of new records created in the.Zip/City/State table.

Note:

• The ctystate.txt data file as delivered by the U.S. Postal Service does not include delimiters between records, but the U.S. Postal Service does provide a utility to insert line breaks to make the data more readable. Important:Do not use this utility to transform the presentation of the records in the data file; if you do, the Load USPS File job will not work.

• The job does not create City/State/Zip Tax records. To create tax records at the postal code level if needed, use Setting Up the Zip/City/State (Postal Code) Table (WZIP).

• The entire process can take several minutes to a half hour to run. You can expect the job to take longer to run if you are creating records in the City/State/Zip table for the first time.

• The job tracks activity in the application log only if your current logging level (as specified in the MQ_LOG_LEVEL in the Logging Properties File) is set to INFO or higher.

For more information: See Troubleshooting the Zip/City/State Upload.

Load USPS File Screen

Before you start: Before you advance to this screen, confirm that you have copied the City State product data file from the U.S. Postal Service to the file name and location specified in the CWDIRECTCP_USPS_ UPLOAD_FILE setting in the CWDirectCP Properties File. By default, this setting indicates a file name of ctystate.txt in the C:CWSerenadeLZIP directory on your primary application server, but you can override this default. When you select the LZPS menu option, make sure you are logged onto the application server specified by the properties file.

How to display this screen: Select Load USPS Zip Code FIle from a menu, or enter LZPS in the Fast path field at the top of any menu.

City State data file found? When you select this menu option, the screen indicates whether there is a data file with the correct name in the location indicated by the properties file:

Completing this screen: If the file has been found and is ready to be loaded:

1. Optionally, deselect the Submit on hold option if you would like the job to run immediately; otherwise, you will need to select Release for the LZPS job at the Job Management Screen when you are ready to run it.

2. Click Accept to begin the upload process and launch the LZPS job. You might expect the job to take several minutes to a half hour to complete, depending on how many new postal code records you are loading.

Updates: See the Upload Process for an overview of the processing steps.

Fields in the USPS Zip/City/State Table

Purpose: The LZPS job reads each record in the file specified by the CWDIRECTCP_USPS_ UPLOAD_FILE setting in the CWDirectCP Properties File (the City State product file from the U.S. Postal Service) that is:

• flagged with a detail code of D

• identified as mailable by a setting of N at byte 56

Usps Zip Code Data

The job clears the previous contents of the USPS Zip/City/State work table and then writes the selected records from the City State data file into the USPS Zip/City/State work table as follows:

Usps Zip Code Download Free

The remaining fields in the USPS City/State/Zip work table are left blank.

Fields in the Zip/City/State Table

After creating the records in the USPS City/State/Zip table, the LZPS job creates new records in the City/State/Zip table if they do not already exist, mapping the data from the USPS City/State/Zip table as follows:

The remaining fields in the City/State/Zip table are left blank.

Troubleshooting the Zip/City/State Upload

Usps Zip Code Database With Postal Zones Download Free Windows 10

Usps Zip Code List Download