Usage & Publication License: database price dollar sign109.00

42,050 Zip Codes Database of 29,809 Cities in US

Zip codes / postcodes database of United States for 29,809 cities from 58 states

database structure screenshot of 42,050 Zip Codes Database of 29,809 Cities in US

Description: Find locations based on zip codes, find postal codes based on city name, or find cities based on area codes. The postal code database contains 42,050 zip code 29,809 city and state 58 in the United States. Each postcode record consists of city name, zip code, time zone, daylight saving time, longitude and latitude.

Related DBs:

Database Statistics

  • Size: 11.50 MB
  • Tables: 3
  • Records: 42,050
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
postcode 42,050
  1. id
  2. city_id
  3. state_id
  4. zip
  5. city
  6. area_code
  7. time_zone
  8. dst
  9. longitude
  10. latitude
city 29,809
  1. id
  2. state_id
  3. title
  4. slug
state 58
  1. id
  2. title
  3. count
  4. slug

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:


  • Alabama Zip Codes
  • Alaska Zip Codes
  • American Samoa Zip Codes
  • Arizona Zip Codes
  • Arkansas Zip Codes
  • California Zip Codes
  • Colorado Zip Codes
  • Connecticut Zip Codes
  • Delaware Zip Codes
  • District of Columbia Zip Codes
  • Federated States of Micronesia Zip Codes
  • Florida Zip Codes
  • Georgia Zip Codes
  • Guam Zip Codes
  • Hawaii Zip Codes
  • Idaho Zip Codes
  • Illinois Zip Codes
  • Indiana Zip Codes
  • Iowa Zip Codes
  • Kansas Zip Codes
  • Kentucky Zip Codes
  • Louisiana Zip Codes
  • Maine Zip Codes
  • Marshal Islands Zip Codes
  • Maryland Zip Codes
  • Massachusetts Zip Codes
  • Michigan Zip Codes
  • Minnesota Zip Codes
  • Mississippi Zip Codes
  • Missouri Zip Codes
  • Montana Zip Codes
  • Nebraska Zip Codes
  • Nevada Zip Codes
  • New Hampshire Zip Codes
  • New Jersey Zip Codes
  • New Mexico Zip Codes
  • New York Zip Codes
  • North Carolina Zip Codes
  • North Dakota Zip Codes
  • Northern Mariana Islands Zip Codes
  • Ohio Zip Codes
  • Oklahoma Zip Codes
  • Oregon Zip Codes
  • Palau Zip Codes
  • Pennsylvania Zip Codes
  • Puerto Rico Zip Codes
  • Rhode Island Zip Codes
  • South Carolina Zip Codes
  • South Dakota Zip Codes
  • Tennessee Zip Codes
  • Texas Zip Codes
  • Utah Zip Codes
  • Vermont Zip Codes
  • Virgin Islands Zip Codes
  • Virginia Zip Codes
  • Washington Zip Codes
  • West Virginia Zip Codes
  • Wisconsin Zip Codes

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.

Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email:

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What is opposite to yes?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!

Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.