ZipCodePros Header

 

 

Home

Purchase

Contact Us

FAQ's

Home
About This Site
Data Quality
Privacy Policy

ZIP5Basic
ZIP5Demographic
Custom Databases
Compare Products
ZIP Code Maps

Last ZIP Code
Database Update:
March 2007

Download Updates

ZIP Code Lookup

Links
Site Map

ZIP5Basic Database
        $67.00
      Buy ZIP5Basic
ZIP5Basic ZIP Code Database Our ZIP5Basic Database is our entry level database. It includes 45 data elements that will allow your business to accomplish many things. It comes standard with USPS licensed data such as ZIP Code, city name, city alias, county, state, just to name a few. These can be used to reduce or eliminate incorrect data entry or even generate lists of zip codes that reside within specific counties, states, . . . etc.

This database will also enable you to do things such as: adding a search function to your web site so that your customers can locate your closest store; segmenting your customer lists by attributes such as race, age, home value, average household size, median household income, population, . . . etc.

This database includes over 79,000 ZIP Code records, 45 data elements and you receive free monthly updates for a year so you know that you have the most up to date data available. You can immediately download this database after purchase. To get updates simply download the updated database, free of charge, from ZIPCodePros each month.

Please check out the complete list of data elements below.

View Data Element Listing     View Sample Data     Download Sample Data     Compare Databases


ZIP5Basic Data Elements:

Field Nbr Field Name Data
Type [1]
Description
1 ZIP Code C5 A 5-digit code that identifies a specific geographic delivery area. ZIP Codes can represent an area within a state, an area that crosses state boundaries (unusual condition), or a single building or company that has a very high mail volume. ZIP is an acronym for Zone Improvement Plan.
2 Preferred City Name C35 May be the name of a city, USPS entity (such as a post office or station), community, USPS-preferred last line, municipality or urbanization (Puerto Rico only). This is the preferred last-line name for a ZIP Code.
3 City Alias C35 May be the name of a city, USPS entity (such as a post office or station), community, USPS-preferred last line, municipality or urbanization (Puerto Rico only). There can be several different names for a ZIP Code.
4 City Alias Abbreviation C13 A standard 13-character abbreviation for an alias city/state name. This field is only used for names that are greater than 13 characters in length and have a City Used For Mailing Ind of "Y". If the field is longer than 13 characters and the City Used For Mailing Ind is "N", the field will be blank.
5 State Abbreviation C5 A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. If APO/FPO, then the state abbreviation will be "AA", "AE", or "AP".
6 State Name C75 The state name.
7 County Name C64 The name of the county or parish in which the 5-digit ZIP Code resides. If APO/FPO, then the county name will be blank. It is important to remember that many ZIP Codes serve more than one county. If a ZIP Code serves more than one county, the county with the most deliveries will be the one reflected here. For example, let's say that ZIP Code 12345 serves counties named Able County (2,000 deliveries), Baker County (1,500 deliveries) and Charlie County (4,500 deliveries). Charlie County would be included in the ZIPCodePros data file.
8 State FIPS C3 Two digit state code assigned to the state by Federal Information Processing Standards.
9 County FIPS C5 Three digit county code assigned to the county by Federal Information Processing Standards. The county fips values are unique within a state.
10 City Type C1 The type of locale identified in the city name. The facility may be a USPS facility, such as a post office, station, or branch, or it may be a non-postal place name. City State Name Facility Codes include the following:
B = Branch
C = Community post office (CPO)
N = Non-postal community name, former USPS facility, or place name
P = Post office
S = Station
U = Urbanization
11 ZIP Code Type C1 Assignes ZIP Codes to one of these groups:
M = Military ZIP Code
P = ZIP Code having only P.O. Boxes
U = Unique ZIP Codes assigned to single companies
Blank = Standard ZIP Codes with many addresses.
12 Primary Record Flag C1 Indicates that this is the primary record for the ZIP Code. You can get a unique list of ZIP Codes if you limit your queries so that they select rows where the Primary Record Indicator = "Y".
13 City State Key C6 The combination of ZIP Code and City State Key is a unique identifier.
14 Latitude D(9,6) The latitude measurement for the ZCTA[2]. The latitude and longitude together represent the approximate geographic center of the ZCTA.
15 Longitude D(9,6) The longitude measurement for the ZCTA[2]. The latitude and longitude together represent the approximate geographic center of the ZCTA.
16 Area Code C40 Area code(s) associated with the ZIP Code.
17 Time Zone C40 A description of the time zone that the ZIP Code falls into.
18 Daylight Savings Flag C1 Identifies whether the ZIP Code observes daylight savings time.
19 Elevation LI Average county elevation.
20 ZIP Code White Population LI The ZCTAs[2] White population total, based on 2000 Census data and race definitions.
21 ZIP Code Black Population LI The ZCTAs[2] Black or African American population total, based on 2000 Census data and race definitions.
22 ZIP Code Hispanic/Latino Population LI The ZCTAs[2] Hispanic or Latino population total, based on 2000 Census data and definitions.
23 ZIP Code Total Population LI The ZCTAs[2] total population, based on 2000 Census data.
24 Zip Code Housing Units - 2000 LI Number of the ZCTAs[2] housing units in 2000, based on 2000 Census data.
25 ZIP Code Average Household Size D(4,2) The ZCTAs[2] average household size, based on 2000 Census data.
26 ZIP Code Median Household Income LI The ZCTAs[2] median household income, based on 2000 Census data.
27 ZIP Code Median House Value LI The ZCTAs median house value for owner occupied housing, based on 2000 Census data.
28 County White Population LI The White population total for the county that the ZIP Code predominantly lies within. Based on 2000 Census data and race definitions.
29 County Black Population LI The Black or African American population total for the county that the ZIP Code predominantly lies within. Based on 2000 Census data and race definitions.
30 County Hispanic/Latino Population LI The Hispanic or Latino population total for the county that the ZIP Code predominantly lies within. Based on 2000 Census data and definitions.
31 County Total Population LI The total population for the county that the ZIP Code predominantly lies within. Based on 2000 Census data.
32 County Housing Units - 2000 LI Number of the county's housing units in 2000, based on 2000 Census data.
33 CBSA Code C10 This is the CBSA that the ZIP Code predominately lies within. The term "core based statistical area" (CBSA) became effective in 2000 and refers collectively to metropolitan and micropolitan statistical areas. According to The United States Office of Management and Budget (OMB) each metropolitan statistical area must have at least one urbanized area of 50,000 or more inhabitants. Each micropolitan statistical area must have at least one urban cluster of at least 10,000 but less than 50,000 population. This value is blank if the ZIP Code does not lie within an area the meets the definition of a metropolitan or micropolitan statistical area.
34 CBSA Name C100 The name of the "core based statistical area", CBSA.
35 CBSA Type C30 Identifies the CBSA as either a "Metropolitan Statistical Area" or a "Micropolitan Statistical Area".
36 CBSA Division Code C10 This is the code for the CBSA Division that the ZIP Code predominately lies within. According to the OMB, if specified criteria are met, a metropolitan statistical area containing a single core with a population of 2.5 million or more may be subdivided to form smaller groupings of counties referred to as "metropolitan divisions."
37 CBSA Division Name C100 The name of the CBSA Division.
38 PMSA Code C10 This is the code for the Primary Metropolitan Statistical Area (PMSA) that the ZIP Code predominately lies within. This way of viewing data is outdated and was replaced by CBSA's in 2000. Here is additional information from the Census Department related to how PMSA's were defined.

"If an area that qualifies as a metropolitan area (MA) has more than one million people, two or more primary metropolitan statistical areas (PMSAs) may be defined within it. Each PMSA consists of a large urbanized county or cluster of counties (cities and towns in New England) that demonstrate very strong internal economic and social links, in addition to close ties to other portions of the larger area. When PMSAs are established, the larger MA of which they are component parts is designated a consolidated metropolitan statistical area (CMSA). CMSAs and PMSAs are established only where local governments favor such designations for a large MA."
39 PMSA Name C100 The name of the Primary Metropolitan Statistical Area (PMSA).
40 MSA Code C10 This is the code for the Metropolitan Statistical Area (MSA) that the ZIP Code predominately lies within. This way of viewing data is outdated and was replaced by CBSA's in 2000. Here is additional information from the Census Department about MSA's.

"Metropolitan statistical areas (MSAs) are metropolitan areas (MAs) that are not closely associated with other MAs. These areas typically are surrounded by nonmetropolitan counties (county subdivisions in New England)."
41 MSA Name C100 The name of the Metropolitan Statistical Area (MSA).
42 CSA Code C10 This is the code for the Combined Statistical Area (CSA) that the ZIP Code predominately lies within.

If specified criteria are met, adjacent metropolitan and micropolitan statistical areas, in various combinations, may become the components of a new set of areas called combined statistical areas (CSAs). Using Census Bureau data the OMB compiles lists of CSAs. The areas that combine retain their own designations as metropolitan or micropolitan statistical areas within the larger combined statistical area. There are 124 CSAs defined by OMB as of December 2005.

Note that CSAs represent multiple metropolitan or micropolitan areas that have a high degree of employment interchange. CSAs often represent regions with common labor and media markets. The use of CSAs as a representation for a single metropolitan area is not always appropriate.
43 CSA Name C100 The name of the Combined Statistical Area (CSA).
44 Census Region C20 The census region that the that the ZIP Code predominately lies within.
45 Census Division C30 The census division that the that the ZIP Code predominately lies within.


Notes:

[1] The following describes the above data types:

  • C## = denotes character data types. The ## that follow the "C" give the maximum length for that field. For example, C35 represents a field that is a character data type with up to a maximum of 35 characters.
  • LI = denotes a long integer. This data type stores values between -2,147,483,648 and 2,147,483,642 with no decimal places.
  • I = denotes an integer. This data type stores values between -32,768 and 32,767 with no decimal places.
  • D(#,#) = denotes a number with decimal places. For example, D(9,6) describes a number that has up to nine digits. Up to three digits would be to the left of the decimal and up to six digits to the right. There may be a plus or minus sign also. Examples include: 38.747216 and
    -75.914595 .

[2] According to the U.S. Census Bureau, ZIP Code Tabulation Areas (ZCTAs) are a new statistical entity developed by the U.S. Census Bureau for tabulating summary statistics from Census 2000. ZCTAs are generalized area representations of U.S. Postal Service (USPS) ZIP Code service areas. Simply put, each one is built by aggregating the Census 2000 blocks, whose addresses use a given ZIP Code, into a ZCTA which gets that ZIP Code assigned as its ZCTA code. They represent the majority USPS five-digit ZIP Code found in a given area. In most instances the ZCTA code equals the ZIP Code for an area

Copyright © ZIPCodePros.com All Rights Reserved