Сша zip code

US Zip Codes

The complete list and database of 5-digit US zip codes is available for download in SQL, CSV, YAML, XML, MS Excel, HTML, and PDF formats.

Number of Zip Codes: 41,685

List Updated On: December 2021

Source: US Postal Service

Keywords: US zip codes ♦ postal ♦ zipcodes ♦ zip ♦ complete ♦ list ♦ database ♦ download ♦ CSV ♦ SQL ♦ YAML ♦ XML ♦ Excel ♦ HTML ♦ PDF ♦ XLS ♦ YML ♦ US states ♦ US territories ♦ US cities

State / Territory		Number of Zip Codes
AL	Alabama	810
AK	Alaska	273
AS	American Samoa	1
AZ	Arizona	525
AR	Arkansas	705
CA	California	2,585
CO	Colorado	642
CT	Connecticut	422
DE	Delaware	96
DC	District of Columbia	293
FM	Federated States of Micronesia	4
FL	Florida	1,464
GA	Georgia	950
GU	Guam	13
HI	Hawaii	137
ID	Idaho	317
IL	Illinois	1,568
IN	Indiana	957
IA	Iowa	1,055
KS	Kansas	747
KY	Kentucky	944
LA	Louisiana	719
ME	Maine	485
MH	Marshall Islands	2
MD	Maryland	603
MA	Massachusetts	680
MI	Michigan	1,158
MN	Minnesota	960
MS	Mississippi	531
MO	Missouri	1,154
MT	Montana	404
NE	Nebraska	616
NV	Nevada	254
NH	New Hampshire	281
NJ	New Jersey	722
NM	New Mexico	427
NY	New York	2,150
NC	North Carolina	1,079
ND	North Dakota	407
MP	Northern Mariana Islands	3
OH	Ohio	1,415
OK	Oklahoma	763
OR	Oregon	479
PW	Palau	2
PA	Pennsylvania	2,168
PR	Puerto Rico	176
RI	Rhode Island	90
SC	South Carolina	534
SD	South Dakota	385
TN	Tennessee	785
TX	Texas	2,598
UT	Utah	344
VT	Vermont	308
VI	Virgin Islands	16
VA	Virginia	1,213
WA	Washington	715
WV	West Virginia	851
WI	Wisconsin	879
WY	Wyoming	194
AA	Armed Forces Americas	54
AE	Armed Forces AF | CA | EU | ME	395
AE	Armed Forces Africa
AE	Armed Forces Canada
AE	Armed Forces Europe
AE	Armed Forces Middle East
AP	Armed Forces Pacific	178
Total		41,685

SQL	Download SQL files	Number of Lines	File Size
US States	Preview	76	2 KB
US States 50	Preview	61	2 KB
US Zipcodes	Preview	41,741	2,145 KB
US Zipcode Default Cities	Preview	41,741	2,145 KB
US Zipcode Cities	Preview	80,587	6,943 KB
US Zipcodes (by City)	Preview	80,587	6,944 KB
CSV	Download CSV files	Number of Lines	File Size
US States	Preview	67	2 KB
US States 50	Preview	52	2 KB
US Zipcodes	Preview	41,686	1,815 KB
US Zipcode Default Cities	Preview	41,686	1,815 KB
US Zipcode Cities	Preview	80,429	5,981 KB
US Zipcodes (by City)	Preview	80,429	5,981 KB
YAML	Download YAML files	Number of Lines	File Size
US States	Preview	268	4 KB
US States 50	Preview	208	3 KB
US Zipcodes	Preview	208,429	3,938 KB
US Zipcode Default Cities	Preview	201,890	3,731 KB
US Zipcode Cities	Preview	267,457	5,266 KB
US Zipcodes (by City)	Preview	400,952	7,116 KB
XML	Download XML files	Number of Lines	File Size
US States	Preview Preview 2	69	3 KB
US States 50	Preview Preview 2	54	2 KB
US Zipcodes	Preview Preview 2	208,428	5,862 KB
US Zipcode Default Cities	Preview Preview 2	100,946	3,017 KB
US Zipcode Cities	Preview Preview 2	246,056	6,643 KB
US Zipcodes (by City)	Preview Preview 2	200,477	5,854 KB
MS Excel	Download MS Excel files	Number of Rows	File Size
US States	Preview Preview 2	67	11 KB
US States 50	Preview Preview 2	52
US Zipcodes	Preview Preview 2	41,686	4,351 KB
US Zipcode Default Cities	Preview Preview 2	41,686
US Zipcode Cities	Preview Preview 2	80,429
US Zipcodes (by City)	Preview Preview 2	80,429	4,520 KB
HTML	Download HTML files	Number of Pages	File Size
US States	Preview Preview 2	1	29 KB
US States 50	Preview Preview 2	1	24 KB
US Zipcodes	Preview Preview 2	62	3,383 KB
US Zipcode Default Cities	Preview Preview 2	62	3,384 KB
US Zipcode Cities	Preview Preview 2	62	15,742 KB
US Zipcodes (by City)	Preview Preview 2	62	15,993 KB
PDF	Download PDF files	Number of Pages	File Size
US States	Preview Preview 2	1	10 KB
US States 50	Preview Preview 2	1	10 KB
US Zipcodes	Preview Preview 2	642	2,392 KB
US Zipcode Default Cities	Preview Preview 2	642	2,430 KB
US Zipcode Cities	Preview Preview 2	1,238	4,750 KB
US Zipcodes (by City)	Preview Preview 2	1,238	4,729 KB

US Zip Codes can be downloaded in the following formats:

SQL* SQL CREATE and multiple-row INSERT statements for SQL Server and MySQL.CSV* Lines of data that can be viewed as spreadsheet, or imported to database server.YAML* Serialized data arranged in an outline or list format.MS ExcelMS Excel spreadsheets that can be readily viewed and personalized.HTML* HTML webpages that can be styled and viewed offline on web browsers.PDFPDF documents that can be printed by pages or viewed with Acrobat Reader and web browsers.

* Files can be opened with text editor applications like Notepad++.

The complete list and database of 5-digit US zip codes in multiple formats

US Zip Codes Database

We’re proud to offer a simple, accurate and up-to-date database of US Zip Codes. It’s been built from the ground up using authoritative sources including the U.S. Postal Service™, U.S. Census Bureau, National Weather Service, American Community Survey, and the IRS.

Databases

BasicProComprehensiveCommercial useAllowedAllowedAllowedFile formatCSV, ExcelCSV, Excel, SQLCSV, Excel, SQLCensus-designated zipsYes, all ZCTASYes, all ZCTASYes, all ZCTASCurrent USPS zipsMostYes, all USPS zipsYes, all USPS zipsNumber of entries33,78841,69141,691Fields (listed below)Basic fieldsMore fieldsAll fieldsFuture updatesNot guaranteedIncluded for 12 monthsIncluded for 24 monthsAttributionRequiredNot requiredNot requiredLicenseCreative Commons Attribution 4.0Permissive, no redistributionPermissive, no redistributionRefund policyN/A30-day guarantee30-day guaranteeOne-time feeFree$99$199DownloadBuy Now!Buy Now!

Customer Approved

Sam Osborn, Customer

Sample Preview

Here is a sample of rows from the database with some commonly used fields:

All Fields

Use scrollbar to see all fields.

Frequently Asked Questions

What is a ZCTA (Zip Code Tabulation Area)?

Are all zip codes ZCTAs (Zip Code Tabulation Areas)?

No. Some zip codes are for PO boxes only, unique to an organization, or used by the military. Such zip codes are not areas and therefore are not represented by ZCTAs. When possible, our database uses parent_zcta to let you know if a zip code resides within an established ZCTA. This allows you to use the ZCTA as a proxy for additional information.

Is the Basic (free) version sufficient for my needs?

How are latitude and longitude calculated?

We’ve used GIS software to calculate the centroid for every ZIP code categorized as a ZCTA. A centroid is the average position of all of the points in a shape. This is best way to convert an area into a point. For zip codes that represent discrete points, we’ve used authoritative sources such as the National Weather Service to geocode them into latitude and longitude.

Why don’t latitude and longitude coordinates exist for some zip codes?

Some zip codes, such as those used by the military, do not represent a discrete point or a ZCTA area. In these cases, it’s not possible to convert a zip code to a geographical point.

No. You are not allowed to sell the database or make it publicly available. However, you can make copies and backups of the data. You are also allowed to query the database to power publicly facing applications such as a store locator. To learn more, read the full license terms.

How often do you release updates?

It depends. We frequently monitor the USPS for updates to zip codes. If there are any changes, we will release a new version.

Why should I trust this data?

This database was aggregated from authoritative sources and carefully processed by SimpleMaps. We’ve been developing and selling interactive maps to Fortune 500 companies and prominent international organizations for over 11 years. Over this time, we’ve learned a lot about geographic data. To get a sense of the expertise and support we offer, check out some of the testimonials from our happy customers.

If I use the free database, what type of attribution is required?

If you use the Basic (free) database, you must link back to this page:
https://simplemaps.com/data/us-zips
from a public webpage where you are using the data. If you want to use the data internally, you must link back to this page from your firm’s website on a page that can be easily found though links on the root domain. The link must be clearly visible to the human eye.

Why do other databases contain more zip codes?

Unlike other databases, we only include one entry per zip code and we only include active USPS zip codes and ZCTAs. Our goal is to create an accurate database that is easy to use, not artificially inflate the size of our database.

How do I calculate the distance between two zip codes?

How come some demographic variables are blank (empty strings) for some zip codes?

For privacy reasons, the Census Bureau and IRS will only provide zip code level data if the zip code is large enough to protect resident privacy. So, for smaller zip codes some variables may not be available.

Has your database been updated with results from the 2020 Census?

Yes, all latitude and longitude coordinates for ZCTAs (and geographic relationships) are now based on ZCTA shapes from the 2020 Census. We’re also now using the 2020 American Community Survey (5-year estimate) for demographic data. The Census Bureau is still basing 2020 ACS data on the 2010 ZCTA shapes. So, we only display the ACS data when the 2010 and 2020 shapes overlap. When the 2021 ACS is released they will switch to using the 2020 ZCTA shapes for demographic calculations and this adjustment will no longer be necessary.

Источники:

• http://simplemaps.com/data/us-zips