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
People	FirstName	varchar(64)	First name
	LastName	varchar(64)	Last Name
	PhoneNumber	varchar(12)	Phone Number
Address	AddressLine1	varchar(64)	Address line
	City	varchar(64)	City
	State	varchar(2)	State
	ZIPCode	varchar(5)	ZIP Code
	Plus4	varchar(4)	ZIP Code plus 4
	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	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.
	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.
Demographic Mortgage And Loan Details	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