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 |
|
CountyName |
varchar(100) |
County |
|
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 |
int |
The purchase price of the property. |
SellDate |
date |
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. |
|
MortgageAmount |
int |
A regularly scheduled payment which includes principal and interest paid by borrower to lender of home loan. |
|
Demographic MortgageAnd LoanDetails |
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. |
|
AddressMisc |
SchoolDistrict |
varchar(100) |
School District name |
ApartmentName |
varchar(255) |
The name of an apartment complex |
|
NeighborhoodName |
varchar(100) |
The name of a Neighborhood |