Zip*Data II Data Layout

Zip*Data II Data Layout#

Introduction#

Zip*Data II is a ZIP Code™ database in comma separated (CSV) format. This information can be used to verify addresses and organizations; as well as append data such as latitude, longitude, marketing, population data, county names, and delivery statistics.

The included databases are:

  • ZipCnty Database

  • ZipData2 Database

List of Files#

Layout and Definitions#

ZIP/County Database (ZipCnty.csv)#

Column Name

Type

Definition

ZIP

char(5)

The ZIP code for the record

FIPS

char(5)

The county FIPS code

CountyName

char(25)

The name of the county

Percentage

decimal(6,2)

The percentage of deliverable addresses that reside in a county FIPS code for a ZIP Code

CNTY

varchar(5)

The number of records used to determine the percentage

ZIP Code Database (ZipData2.csv)#

Column Name

Type

Definition

ZIP

char(5)

ZIP Codes identify specific geographic delivery areas. A ZIP code can represent an area within a state, one which crosses state boundaries, or a single building

State

char(2)

The USPS® standard 2-letter state or territory abbreviation

City

char(30)

The city, community, station or other name by which a 5-digit ZIP area is known

CityAbbreviation

char(13)

The abbreviated city name

Latitude

decimal(7,4)

The geographic coordinate of a point measured in degrees north or south of the equator

Longitude

decimal(9,4)

The geographic coordinate of a point measured in degrees east or west of the Greenwich meridian

CountyFips

char(5)

A Federal Information Processing Standard number is assigned to each county in the United States. FIPS numbers begin with the 2-digit state code and are followed by the 3-digit county code

CountyName

char(25)

The name of the county

DominantAreaCode

char(3)

The 3-digit telephone area code

ZipType

char(1)

Defines the ZIP Code for delivery purposes

LastLineIndicator

char(1)

An “L” in this field indicates that the city name is the official USPS name for the ZIP Code. (Only one record per ZIP Code is coded with an “L”.)

FacilityCode

char(1)

This code refers to the Postal Facility Code associated with a particular ZIP Code

FinanceNumber

char(6)

The number that refers to the main Post Office that serves a city. It is also used with multi-coded cities. All ZIP Codes in a multi-coded city are assigned the same Finance Number by the USPS

CBSA

char(5)

The Core Based Statistical Area (CBSA) code for the ZIP Code

CBSATitle

varchar(50)

The official U.S. Census Bureau name for the CBSA

CBSAStatus

char(1)

CBSADivision

char(5)

The numeric code for the division within the CBSA containing the ZIP Code. Some CBSA’s are broken into parts known as divisions

CBSADivisionTitle

varchar(50)

The official U.S. Census Bureau’s official name for the division within the CBSA containing the ZIP Code

CBSADivisionStatus

varchar(1)

Organization

char(28)

The organization name.

ResidentialDeliveries

varchar(7)

The number of active residential mail deliveries to residence addresses

ResidentialPOBoxes

varchar(7)

The number of active residential mail deliveries made to PO boxes

BusinessDeliveries

varchar(7)

The number of active business mail deliveries made to business addresses

BusinessPOBoxes

varchar(7)

The number of active business mail deliveries made to PO Boxes

TotalPopulation

varchar(7)

Total Population for a ZIP Code

PopWhite

varchar(7)

The number of people in the population of White/Caucasian decent

PopAfricanAmerican

varchar(7)

The number of people in the population of Black/African American decent

PopAmericanIndianAlaskaNative

varchar(7)

The number of people in the population of American Indian or Alaskan Native decent

PopAsian

varchar(7)

The number of people in the population of Asian decent

PopPacificIslander

varchar(7)

The number of people in the population of Pacific Islander decent

PopOther

varchar(7)

The number of people in the population of Other decent

PopMultipleRace

varchar(7)

The number of people in the population of Multiple Race decent

PopHispanic

varchar(7)

The number of people in the population of Hispanic/Latino decent

MedianAge

varchar(7)

The median age of the population

MedianAgeMale

varchar(7)

The median age of the male portion of the population

MedianAgeFemale

varchar(7)

The median age of the female portion of the population

EduNineOrLess

varchar(7)

The number of people over 18 years of age in the population who have an education level under grade 9

EduSomeHighSchool

varchar(7)

The number of people over 18 years of age in the population who have attended some of high school (between grades 9 and 12) but not graduated.

EduHighSchoolGraduate

varchar(7)

The number of people over 18 years of age in the population who have graduated high school

EduSomeCollegeNoDiploma

varchar(7)

The number of people over 18 years of age in the population who have attended college but not received a degree

EduAssociatesDegree

varchar(7)

The number of people over 18 years of age in the population who have attended college and received an associate’s degree

EduBachelorsDegree

varchar(7)

The number of people over 18 years of age in the population who have attended college and received a bachelor’s degree

EduGraduateDegree

varchar(7)

The number of people over 18 years of age in the population who have attended college and received a graduate degree

MedianHouseholdIncome

varchar(7)

The median household income of the population

PerCapitaIncome

varchar(7)

The median income per person

MedianHomeValue

varchar(7)

The median home value in the ZIP Code

TimeZone

varchar(4)

The number representing the hours past UTC Time Standard. All Melissa products express time zones in UTC (Coordinated Universal Time)

Code and Definitions#

ZIP Code Database (ZipData2.csv)#

Column Name

Code

Definition

CBSAStatus

1

Metropolitan Statistical Area

2

Micropolitan Statistical Area

CBSADivisionStatus

1

Metropolitan Statistical Area

2

Micropolitan Statistical Area

FacilityCode

B

Branch

C

Community Post Office (BMF)

N

Community Name, Former Postal Facility or Place Name

P

Post Office

U

Urbanization

X

Unapproved Mailing Name

TimeZone

AKST

Alaska Standard Time

AST

Atlantic Standard time

CHST

Chamorro Standard Time

CST

Central Standard Time

EST

Eastern Standard Time

HAST

Hawaiian-Aleutian Standard Time

HST

Hawaii Standard time

MHT

Marshall Islands Time

MST

Mountain Standard Time / Mountain Time

PST

Pacific Standard Time / Pacific Time

PWT

Palau Time (standard time)

SST

Samoa Standard Time

ZipType

P

A ZIP code used only for P.O. Boxes

U

A unique* ZIP code

M

Identifies an APO/FPO ZIP Code

Blank

A standard ZIP Code
Contents