US Zip Codes

United States Zip Codes with Latitude, Longitude and Area Code

Data Structure

city [42,741]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ zip_code (100%)
varchar(40)
+ city (100%)
char(2)
+ state_abbreviation (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(40)
+ county (98.7%)
varchar(255)
+ zip_code_type (100%)
bigint(20) unsigned
+ zip_code_type_id (100%)
varchar(255)
+ latitude (98.4%)
varchar(255)
+ longitude (98.4%)
varchar(255)
+ area_code (98.7%)
varchar(255)
+ time_zone (98.7%)
varchar(255)
+ DST (98.7%)
state [62]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
char(2)
+ abbreviation (100%)
varchar(255)
+ title (100%)
zip_code_type [4]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ zip_code_type (100%)

Description

With 42,741 unique USPS zip codes of United States, this database comes with city, county, state / territory / military, latitude, longitude, telephone area code, time zone and DST (Daylight Saving Time) for each of the zip codes.

There are 4 different types of zip codes: Military, P.O. Box Only, Standard, and Unique.

There are 62 different states / territories / armed forces: Armed Forces Americas (except Canada), Armed Forces (Europe, Canada, Middle East, Africa), Alaska, Alabama, Armed Forces Pacific, Arkansas, American Samoa, Arizona, California, Colorado, Connecticut, District of Columbia, Delaware, Florida, Federated States of Micronesia, Georgia, Guam, Hawaii, Iowa, Idaho, Illinois, Indiana, Kansas, Kentucky, Louisiana, Massachusetts, Maryland, Maine, Marshall Islands, Michigan, Minnesota, Missouri, Northern Mariana Islands, Mississippi, Montana, North Carolina, North Dakota, Nebraska, New Hampshire, New Jersey, New Mexico, Nevada, New York, Ohio, Oklahoma, Oregon, Pennsylvania, Puerto Rico, Palau, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Virgin Islands, Vermont, Washington, Wisconsin, West Virginia, Wyoming

Data Profile

Size 26.73M
Tables 3
Last Commit 2016-08-31 03:16:28

Updates / Commits

Time Size Tables Columns Rows
2016-08-31 03:16:28 26.73M 3 21 42807

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 42,741 .001 42.741
state 62 .001 0.062
zip_code_type 4 .001 0.004
Total Credits 42.807 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.