Official U.S. ZIP Code Database with Geocode

This FREE database includes every ZIP code in the United States (42,613 records)  including decommissioned ZIP code.  ZIP code data changes occur quite frequently and controlled by USPS.
It's important that you use the latest ZIP code database for accuracy.

The data file available here is updated in 2017. Each record contains other valuable information such as phone area codes used, population estimate and county name.

The database can only be used for Personal / Non-commercial use.

Column	Column Name	Length	Column Type	POSSIBLE VALUES & REMARKS
1	zip	5	String	ZIP Code
2	type	255	String	Standard, PO Box, Military, Unique
3	decommissioned	1	Boolean	Active or Decommissioned
4	primary_city	50	String	Primary City Name
5	state	2	String	State Abbreviation
6	county	50	String	County Name
7	area_code	30	String	Phone Area Codes
8	latitude		Decimal(14,6)	Geocode
9	longitude		Decimal(14,6)	Geocode
10	est_population		Int	Estimated Population 2014

Download Now