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

ZIP5Demographic Database
            $37.00
          Buy ZIP5Demographic
ZIP5Demographic ZIP Code Database The ZIP5Demographic Database is our most robust database. It includes all 45 data elements from the ZIP5Basic database plus an additional 35 data elements that will help you segment your customer lists even further. This database also comes standard with USPS licensed data such as ZIP Code, city name, city alias, county, state.

In general, the additional 35 data elements include information related to all ZIP Code and county race populations not just Black and White segments. It also includes: county growth ranks, housing unit figures for multiple years, median age for ZIP Codes by gender, and business related data such as number of businesses, employees and payroll amounts. It's a very complete set of data. Please see our View Data Element Listing page for a complete list of fields or the Compare Databases page to see the exact differences between the our two databases.

This database also includes over 79,000 ZIP Code records and 80 data elements. You can immediately download this database after purchase. The download process is simple.

Please check out the complete list of data elements below.

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


ZIP5Demographic 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 Used For Mailing Flag C1 Specifies whether or not the city alias can be used as a last line of address on a mail piece. "Y" = a USPS-approved mailing name. "N" = not approved by USPS as a last line.
11 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
12 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.
13 Finance Number C6 A code assigned to a Postal Service facility to collect statistical data.
14 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".
15 City State Key C6 The combination of ZIP Code and City State Key is a unique identifier.
16 Latitude D(9,6) The latitude measurement for the ZCTA[2]. The latitude and longitude together represent the approximate geographic center of the ZCTA.
17 Longitude D(9,6) The longitude measurement for the ZCTA[2]. The latitude and longitude together represent the approximate geographic center of the ZCTA.
18 Zip Code Size LI The size of the ZCTA[2] in square miles, based on 2000 Census data.
19 Area Code C40 Area code(s) associated with the ZIP Code.
20 Time Zone C40 A description of the time zone that the ZIP Code falls into.
21 Daylight Savings Flag C1 Identifies whether the ZIP Code observes daylight savings time.
22 Elevation LI Average county elevation.
23 ZIP Code White Population LI The ZCTAs[2] White population total, based on 2000 Census data and race definitions.
24 ZIP Code Black Population LI The ZCTAs[2] Black or African American population total, based on 2000 Census data and race definitions.
25 ZIP Code American Indian and Alaska Native Population LI The ZCTAs[2] American Indian and Alaska Native population total, based on 2000 Census data and definitions.
26 ZIP Code Asian Population LI The ZCTAs[2] Asian population total, based on 2000 Census data and definitions.
27 ZIP Code Native Hawaiian and Other Pacific Islander Population LI The ZCTAs[2] Native Hawaiian and Other Pacific Islander population total, based on 2000 Census data and definitions.
28 ZIP Code Some Other Race Alone Population LI The ZCTAs[2] Some Other Race Alone population total, based on 2000 Census data and definitions.
29 ZIP Code Two or More Races Population LI The ZCTAs[2] Two or More Races population total, based on 2000 Census data and definitions.
30 ZIP Code Hispanic/Latino Population LI The ZCTAs[2] Hispanic or Latino population total, based on 2000 Census data and definitions.
31 ZIP Code Total Population LI The ZCTAs[2] total population, based on 2000 Census data.
32 ZIP Code Median Age D(4,1) The median age of the ZCTA's entire population. Includes males and females and is based on 2000 Census data.
33 ZIP Code Median Age Female D(4,1) The median age of the ZCTA's female population. The figure only includes females and is based on 2000 Census data.
34 ZIP Code Median Age Male D(4,1) The median age of the ZCTA's male population. The figure only includes males and is based on 2000 Census data.
35 Zip Code Housing Units - 2000 LI Number of the ZCTAs[2] housing units in 2000, based on 2000 Census data.
36 ZIP Code Average Household Size D(4,2) The ZCTAs[2] average household size, based on 2000 Census data.
37 ZIP Code Median Household Income LI The ZCTAs[2] median household income, based on 2000 Census data.
38 ZIP Code Median House Value LI The ZCTAs median house value for owner occupied housing, based on 2000 Census data.
39 ZIP Code Employees 2004 LI The total number of employees for businesses operating in the ZCTA[2] in 2004.
40 Employees Size Code C5 Ocassionaly areas will not provide specific information about the number of employees and payroll. In some cases they provide a code that represents a value band for the numbers of employees. Below are the codes and bands:
A = 0 - 19
B = 20 - 99
C = 100 - 249
E = 250 - 499
F = 500 - 999
G = 1,000 - 2,499
H = 2,500 - 4,999
I = 5,000 - 9,999
J = 10,000 - 24,999
K = 25,000 - 49,999
L = 50,000 - 99,999
M = 100,000 or more
41 ZIP Code Businesses 2004 LI The total number of businesses operating in the ZCTA[2] in 2004.
42 ZIP Code Q1 2004 Payroll (thousands) LI The total Q1 2004 payroll for businesses operating in the ZCTA[2]. Note that the amounts are in thousands of dollars.
43 ZIP Code Annual 2004 Payroll (thousands) LI The total 2004 payroll for businesses operating in the ZCTA[2]. Note that the amounts are in thousands of dollars.
44 Congressional District C30 The 109th Congressional District that the ZCTA[2] lies within. In most cases, the district values were assigned based on Census ZCTA data. The districts were assigned based on which county the ZIP Code lies within where ZCTA data was not available.
45 Congressional County Flag C1 The Congressional District is primarily set based on ZIP Code. The Census Bureau doesn't include some ZIP Codes in their data because they relate to a single building or a Military Zip Code, . . . etc. When this is the case, we update the Congressional District based on what county the ZIP Code primarily lies within and set the Congressional County Flag to "Y".
46 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.
47 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.
48 County American Indian and Alaska Native Population LI The county's American Indian and Alaska Native population total, based on 2000 Census data and definitions.
49 County Asian Population LI The county's Asian population total, based on 2000 Census data and definitions.
50 County Native Hawaiian and Other Pacific Islander Population LI The county's Native Hawaiian and Other Pacific Islander population total, based on 2000 Census data and definitions.
51 County Some Other Race Alone Population LI The county's Some Other Race Alone population total, based on 2000 Census data and definitions.
52 County Two or More Races Population LI The county's Two or More Races population total, based on 2000 Census data and definitions.
53 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.
54 County Total Population LI The total population for the county that the ZIP Code predominantly lies within. Based on 2000 Census data.
55 County Housing Units - 2000 LI Number of the county's housing units in 2000, based on 2000 Census data.
56 County Housing Units 2003 LI Number of the county's housing units in 2003, based on Census population estimates data.
57 County Housing Units 2004 LI Number of the county's housing units in 2004, based on Census population estimates data.
58 County Housing Units 2005 LI Number of the county's housing units in 2005, based on Census population estimates data.
59 County Housing Unit Change 2005 LI The number increase/decrease in county housing units between 2004 and 2005. Derived field based on County Housing Units 2005 and County Housing Units 2004.
60 County Housing Unit Change Percent 2005 D(5,2) The percentage increase/decrease in county housing units between 2004 and 2005. Derived field based on County Housing Units 2005 and County Housing Units 2004.
61 County Growth Rank LI This rank is based on the percentage increase in the number of housing units between 2004 and 2005.
62 County Average Household Size D(4,2) The county's average household size, based on 2000 Census data.
63 County Median Household Income LI The county's median household income, based on 2000 Census data.
64 County Median House Value LI The county's median house value for owner occupied housing, based on 2000 Census data.
65 County Size LI The size of the county in square miles, based on 2000 Census data.
66 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.
67 CBSA Name C100 The name of the "core based statistical area", CBSA.
68 CBSA Type C30 Identifies the CBSA as either a "Metropolitan Statistical Area" or a "Micropolitan Statistical Area".
69 CBSA Population LI The population of the CBSA based on 2005 Census Population Estimates.
70 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."
71 CBSA Division Name C100 The name of the CBSA Division.
72 CBSA Division Population LI The population of the CBSA Division based on 2005 Census Population Estimates.
73 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."
74 PMSA Name C100 The name of the Primary Metropolitan Statistical Area (PMSA).
75 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)."
76 MSA Name C100 The name of the Metropolitan Statistical Area (MSA).
77 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.
78 CSA Name C100 The name of the Combined Statistical Area (CSA).
79 Census Region C20 The census region that the that the ZIP Code predominately lies within.
80 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