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

1 comment

  1. BONANZA CASINO AND CASINO - Joliet CT
    BONANZA CASINO AND CASINO. Joliet 아산 출장마사지 CT is 논산 출장안마 one of the first high-end 영천 출장안마 hotels in 제주도 출장마사지 South America 하남 출장샵 with a bustling casino, an assortment of tables games, and a

    ReplyDelete