Postal-Zipcodes.com

USA - Ultimate

The database includes ZIP code, city name, alias city name, state code, phone area code, city type, county name, country FIPS, time zone, day light saving flag, latitude, longitude, county elevation, Metropolitan Statistical Area, Primary Metropolitan Statistical Area Core Based Statistical Area and Census 2000 data in the United States. Database contains over 120,000 records.

More details

On sale On sale!
$99.95 tax incl.

$149.95 tax incl.

Loyalty program By buying this product you can collect up to 9 reward points as a voucher of $1.80. Your reward points.



Available for Immediate Download

You'll receive the 5-digit ZIP Code Database, Ultimate Edition immediately. Your computer-generated account will be delivered to your email address immediately once the order has been approved.

Our products are available for download only, which allows us to keep our prices low and pass the savings on to you. The data will be available in your account for 30 days after your purchase.  It can be downloaded on any computer with internet access.

Product Features & Benefits

  • Lowest Price on the Net
  • 30-Day Money Back Guarantee
  • Updated Monthly with official USPS ZIP Code data
  • Raw text formats compatible with any database, including SQL Server, Oracle, MySQL, DB2, Access, and Postgre SQL
  • Award-Winning Customer Service

Technical Specification

Field# Field Name Data Type Field Description
  1   ZIP_CODE   nchar(5) The ZIP Code of the city designated by the USPS.
  2   CITY   varchar(35) The name of the city designated by the USPS.
  3   STATE   char(2) The two-letter abbreviation for the state to that particular ZIP code.
  4   AREA_CODE   varchar(40) The telephone area code belonging to the particular postal code is located.
  5   CITY_ALIAS_NAME   varchar(35) The alias name for the ZIP Code. This may be a city name, postal entity, community or a municipality name.
  6   CITY_ALIAS_ABBR   varchar(13) This is a standard 13-character abbreviation for city alias name. This field is empty if names are less or equal to 13-character.
  7   CITY_TYPE   char(1) The field indicates the type of locale identified in the city alias name such as Post Office, station or branch.
  8   COUNTY_NAME   varchar(25) The name of the county or parish in which the 5-digit ZIP Code resides.
  9   STATE_FIPS   nchar(2) The FIPS code assigned to state.
  10   COUNTY_FIPS   nchar(3) The FIPS code assigned to given county or parish within a state.
  11   TIME_ZONE   nchar(2) The time zone number represents by the hours past the Greenwich Time Zone.
  12   DAY_LIGHT_SAVING   char(1) This flag indicates whether the city observe day light saving.
  13   LATITUDE   numerical The geographic coordinate of a point measured in degrees north or south of the equator.
  14   LONGITUDE   numerical The geographic coordinate of a point measured in degrees east or west of the Greenwich meridian.
  15   ELEVATION   numerical The counties average elevation.
  16   MSA2000   nchar(4) Metropolitan Statistical Area based on Census 2000
  17   PMSA   nchar(4) Primary Metropolitan Statistical Area
  18   CBSA   nchar(5) Core Based Statistical Area, Metropolitan Statistical Area and Micropolitan Statistical Area released by OMB in Year 2003
  19   CBSA_DIV   nchar(5) Metropolitan Division
  20   CBSA_TITLE   varchar(128) Full title description of CBSA and MSA
  21   PERSONS_PER_HOUSEHOLD   numeric The average number of persons per household by ZIP code based on Census 2000.
  22   ZIPCODE_POPULATION   numeric The population of the ZIP Code based on Census 2000.
  23   COUNTIES_AREA   numeric The counties square mileage based on Census 2000.
  24   HOUSEHOLDS_PER_ZIPCODE   numeric Total estimated number of households per ZIP Code based on Census 2000.
  25   WHITE_POPULATION   numeric The estimate of White population per ZIP code based on Census 2000.
  26   BLACK_POPULATION   numeric The estimate of Black population per ZIP code based on Census 2000.
  27   HISPANIC_POPULATION   numeric The estimate of Hispanic population per ZIP code based on Census 2000.
  28   INCOME_PER_HOUSEHOLD   numeric The average household income within county based on Census 2000.
  29   AVERAGE_HOUSE_VALUE   numeric The average house value within county based on Census 2000.
           

No customer comments for the moment.

Only registered user can post a new comment.

Cart  

(empty)