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 |