Listware for Excel:US:Output Columns

← Listware for Excel Reference

Specify what data you want to output by checking the box next to the desired columns.

You can right-click each section to 'Check All' or 'Check None'.

The following output columns are available:

Name 1

This section contains name components.

Full Name

Output the full name. E.g. "Dr. Bill S. Preston, Esquire."

Prefix

Output the parsed name prefix. E.g. "Dr."

First Name

Output the parsed first name. E.g. "Bill."

Middle Name

Output the parsed middle name. E.g. "S."

Last Name

Output the parsed last name. E.g. "Preston."

Suffix

Output the parsed name suffix. E.g. "Esquire."

Gender

This will output the name's gender. "M" for male, "F" for female, and "N" for neutral.

Use Demographic Data When Available

Check this item if you want to use the more accurate demographic-derived gender. This option is available for Output Name1 Gender only.

Name 2

This section contains a second set of name components for when your input contains two names. The columns here have the same definitions as the columns contained under Name 1.

Salutation

Salutation

Output a salutation. E.g. "Dear Mr. Preston."

Address

Company

Output the company or organization.

Address

Output the address.

Address 2

Output the second address. If you specify a second address line, secondary information (apartment, suite, etc.) will be put here. If you choose to not output to Address 2, secondary information will be appended to the first Address.

City

Output the city.

State

Output the US State or Canadian Province.

ZIP Code

Output the US ZIP Code or Canadian Postal Code.

Country

Output the Country.

AddressKey

Output the AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa Data products.

MAK and Base MAK

A unique key assigned to the submitted address (MAK) and base address of a complex with apartments or suites (Base MAK). For more information, see Melissa Address Key.

GeoLocation

Latitude and Longitude

Output the latitude and longitude.

Link to Map Location

US Check and Verify use the returned Address and Latitude Longitude pair to create a hyperlink to the specified Map Server. Unverified records with no returned Lat Long pair, may therefore display a map to the user’s local area determined by the selected Map Server.

Phone

Phone

Output the phone number. The number will be formatted in the selected format below.

Format

(800) 800-6245

(800) 800 6245

800-800-6245

800 800 6245

800.800.6245

8008006245

E-mail

E-mail

Output the e-mail address.

Address Information

Address Type

Output the Address Type.

Code	Description
S	Standard Address
G	General Delivery Address
M	Military Address
P	PO Box Address
R	Rural Route Address
U	Unique/LVR Address

Delivery Indicator

Output the Delivery Indicator.

Code	Description
B	Business Address
R	Residential Address
U	Unknown Address

Extra Address Information

Output extra information that does not fit in any of the output address columns.

Suite

Output the suite.

If requested, the suite will be populated in this column instead of the output address columns.

Private Mailbox

Output the Private Mailbox. These mailboxes are used in commercial receiving agencies, such as the UPS store.

If requested, the Private Mailbox will be populated in this column instead of the output address columns.

Urbanization (PR Only)

Output the urbanization name. These are used only in Puerto Rican addresses.

City Abbreviation

Output the city abbreviation is any is available.

State Name

Output the full state name.

ISO Country Code

Output the ISO country code.

Carrier Route

Output the Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.

Delivery Point

Output the Delivery Point (DP) and its check digit. This is a 2-digit code defining the address's delivery location. The single-digit check digit follows the delivery point and serves as an error check for the ZIP Code, Plus4 and Delivery Point.

Universal Time Code

Output the Universal Time Code (UTC.) This indicates the amount of hours:minutes offset from Greenwich Mean Time (GMT.)

Census Information

CBSA Code

Output the Census Bureau Core-Based Statistical Area (CBSA) code. This is a 5-digit code for the address.

CBSA Title

Output the Title describing the CBSA code.

CBSA Level

Output the Level of the CBSA code. If present, the CBSA Level will be Metropolitan or Micropolitan.

Divisional CBSA Code

Output the CBSA representing the division associated with the address.

Divisional CBSA Title

Output the Title describing the Divisional CBSA code.

Divisional CBSA Level

Output the Level of the Divisional CBSA code. If present, the Divisional CBSA Level will be Metropolitan or Micropolitan.

County Name

Output the County name.

County FIPS Code

Output the County FIPS code. This is a 5-digit code. The first two digits indicate the state while the last three digits indicate the county within the state.

Census Block

Output the Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blocks are the smallest geographic area for which the Bureau of the Census collects information.

Census Tract

Output the Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Census Tracts are small subdivisions of the county.

Place Name

Output the Place Name. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Name will refer to that area.

Place Code

Output the Place Code. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Code will refer to that area.

Congressional District

Output the Congressional District. This is a 2-digit code indicating the address's congressional district.

Demographics

Date of Birth

Output the Date of Birth demographic. The date of birth will be formatted: yyyy-mm (no day will be specified.)

Date of Death

Output the Date of Death demographic. The date of death will be formatted: yyyy-mm-dd.

Household Income

Output the household income demographic.

Residence Type

Output the residence type demographic.

Code	Description
DR	Definite Renter
PR	Inferred Renter
PO	Inferred Owner
DO	Definite Owner

Length of Residence

Output the length of residence demographic (i.e., the number of years at the current residence.)

Occupation

Output the occupation demographic.

Married?

Output the marital status demographic.

Code	Description
	Unknown
DS	Definitely Single
PS	Inferred Single
PM	Inferred Married
DM	Definitely Married

Children Present?

Output the children demographic.

Code	Description
Y	Yes
N	No

Education

Returns the highest level of education completed by an individual.

HouseholdSize

Returns the number of occupants in the household.

PoliticalParty

Returns an individual’s political affiliation.

PresenceOfSenior

Returns the presence of senior/s in the household.

CreditCardUser

Returns whether the user has a credit card or not.

EthnicCode

Returns an individual’s specific ethnicity.

EthnicGroup

Returns the grouped category for a person’s ethnicity. This is a more generalized grouping compared to Ethnic Codes.

Property

Assessors Parcel Number (APN)

Output the formatted Assessor's Parcel Number (APN.) This is present for 99% of properties.

Owner Name

Output the property owner's name. This is present for 45% of properties.

Owner Address

Output the property owner's address. This is present for 98% of properties.

Total Property Value

Output the calculated total value (parcel plus improvement values, closest to market value, used for assessment by tax agencies.) This is present for 97% of properties.

Improvement Value

Output the Calculated Improvement Value. This is clsoed to the current market value, and is used for assessment by tax agencies. This is present for 68% of properties.

Assessed Property Value

Output the Total Assessed value. This is parcel plus improvement values. This is present for 92% of properties.

Tax Amount

Output the property's total tax amount. This is present for 89% of properties.

Last Sale Date

Output the property's sale date, formatted yyyy-mm-dd. This is present for 47% of properties.

Last Sale Price

Output the property's sale price. This is present for 46% of properties.

Acreage

Output the total land area in acres. This is present for 86% of properties.

Property Square Footage

Output the property's square footage. This is present for 8% of properties.

Building Square Footage

Output the total building area in square feet. This is present for 35% of properties.

Living Space Square Footage

Output the area of the building used for general living. This is for heated or cooled areas. This does not include any garage, basement, or porch areas. This is present for 53% of properties.

Year Built

Output the original building's year of construction. This is present for 55% of properties.

Total Rooms

Output the property's number of rooms in the primary building. This is present for 27% of properties.

Bedrooms

Output the total number of bedrooms in the primary building. This is present for 39% of properties.

Bathrooms

Output the property's total bathrooms. This is present for 48% of properties.

Mortgage Term

Output the property's mortgage term. This is present for 19% of properties.

Mortgage Due Date

Output the property's mortgage due date. This is present for 19% of properties.

Mortgage Amount

Output the property's mortgage amount. This is present for 27% of properties.

Parsed Address

House Number

Output the parsed House Number for the output address.

Street Pre-Directional

Output the parsed Street Pre-Directional for the output address.

Street Name

Output the parsed Street Name for the output address.

Street Suffix/Type

Output the parsed Street Suffix (a.k.a. Street Type) for the output address.

Street Post-Directional

Output the parsed Post-Direction for the output address.

Suite Name

Output the parsed Suite Name for the output address.

Suite Number

Output the parsed Suite Number for the output address.

Private Mailbox Name

Output the parsed Private Mailbox Name for the output address.

Private Mailbox Number

Output the parsed Private Mailbox Number for the output address.

Route Service Number (CAN Only)

Output the parsed Route Service Number for the output address.

Canada Only.

Delivery Installation (CAN Only)

Output the parsed Delivery Installation for the output address.

Canada Only.

Lock Box Number (CAN Only)

Output the parsed Lock Box Number for the output address.

Canada Only.