Data Layout#

Introduction#

Reach these consumers ready for your offer with our database of 24 million+ records compiled from property transfer and deed recordings. More than 75,000 new records are added weekly, so you can connect with home buyers looking for electronics, appliances, furniture, décor, home goods, food, and for services including dental care, contracting, landscaping, remodeling and security.

Sample File#

Click here to download the sample file.

Layout and Definitions#

Grouping

Column Name

Type

Definition

Address

MelissaAddressKey

bigint

10-digit unique key assigned to each address.

BaseMelissaAddressKey

bigint

Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment

ContactName

FirstName

varchar(64)

First Name

LastName

varchar(64)

Last Name

Address

AddressLine

varchar(64)

Address Line

City

varchar(64)

City

State

varchar(2)

State

ZIPCode

varchar(5)

ZIP Code

Plus4

varchar(4)

Plus4

DeliveryPoint

varchar(2)

A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.

AddressKey

varchar(11)

Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint

CarrierRoute

varchar(4)

The carrier route for the location address assigned by the USPS.

FIPSCode

varchar(5)

The FIPSCode indicates the location of the address at both the state and county level.

Geo

PlaceCode

varchar(7)

Place identifier represented as State FIPS (2) + PlaceFIPS (5)

Latitude

decimal(18,6)

The latitude in decimal degrees using the WGS84 datum for the address.

Longitude

decimal(18,6)

The longitude in decimal degrees using the WGS84 datum for the address.

CensusKey

varchar(16)

Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.

Phone

PhoneNumber

varchar(12)

Phone number

Demographic Transaction Details

PurchasePrice

varchar(18)

The purchase price of the property.

SellDate

varchar(10)

The closing date, the ownership of the property is transferred to the buyer.

Lender

varchar(90)

A lender is an individual, a public or private group, or a financial institution that makes funds available to another with the expectation that the funds will be repaid.

TransactionType

varchar(5)

Transaction type code

PublishedDate

date

Record published date

CondoCode

varchar(2)

Indicates if a property is a condo.

Demographic MortgageAnd LoanDetails

MortgageAmount

varchar(18)

A regularly scheduled payment which includes principal and interest paid by borrower to lender of home loan.

RateType

varchar(5)

Whether a fixed-rate or an adjustable-rate mortgage loan.

LoanType

varchar(50)

Indicates whether the loan granted, applied for, or purchased was conventional, government-guaranteed, or government-insured.

Code and Definitions#

Column Name

Code

Definition

CondoCode

C

Condo

Not a Condo

NULL

Unknown/Unspecified

LoanType

No data

Building or Construction

Building or Construction

CNV

Conventional

Commercial

Commercial

Conventional

Conventional

FHA

Federal Housing Administration

Line of Credit

Line of Credit

PP

Private Party

Regional Government Programs

Regional Government Programs

Reverse Mortgage

Reverse Mortgage

SBA

Small Business Administration

USDA - US Department of Agriculture Loan

USDA - US Department of Agriculture Loan

VA

Veterans Administration

Veterans Administration Loan

Veterans Administration Loan

RateType

No data

ADJ

Adjustable-rate mortgage

FIX

Fixed-rate mortgage

MULT

Multiple Loan Amounts

OTH

Other

STP

Step Interest Rate

UNK

Unknown

VAR

Variable