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




Official U.S. ZIP Code Database with Geocode Official U.S. ZIP Code Database with Geocode Reviewed by Brandon on November 18, 2017 Rating: 5

No comments