Data Layout#
Introduction#
Property and Mortgage data for Insight and Analytics. Add Property and Mortgage Data to Your Records for Data-Driven Insight and Analytics. Our custom property data solutions give you fresh, accurate real estate and property data on more than 140 million U.S. properties including parcel and building information, calculated value, deed information and history, and more. Along with comprehensive information on the property, you also get detailed information on the homeowner and all other properties that owner has ever owned.
When you add more than 400 fields of detailed property data to your in-house records, you’ll gain the competitive edge and capitalize on market opportunities. The Property API is ideal for lenders, real estate professionals, investors and insurance agents.
Sample File#
Click here to download the sample file.
Layout and Definitions#
Grouping |
Column Name |
Type |
Definition |
|---|---|---|---|
Primary Owner |
Owner1FullName |
varchar(255) |
Owner 1 Full Name |
Owner1FirstName |
varchar(166) |
Owner 1 First Name |
|
Owner1MiddleName |
varchar(166) |
Owner 1 Middle Name |
|
Owner1LastName |
varchar(166) |
Owner 1 Last Name |
|
Owner1NameSuffix |
varchar(50) |
Owner 1 Name Suffix |
|
Owner2FullName |
varchar(255) |
Owner 2 Full Name |
|
Owner2FirstName |
varchar(166) |
Owner 2 First Name |
|
Owner2MiddleName |
varchar(166) |
Owner 2 Middle Name |
|
Owner2LastName |
varchar(166) |
Owner 2 Last Name |
|
Owner2NameSuffix |
varchar(50) |
Owner 2 Name Suffix |
|
PropertyAddress |
PropertyMelissaAddressKey |
bigint |
10-digit unique key assigned to each address. |
PropertyBaseMelissaAddressKey |
bigint |
Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment |
|
PropertyAddressLine |
varchar(150) |
Address line |
|
PropertyCity |
varchar(100) |
City |
|
PropertyState |
varchar(2) |
State |
|
PropertyZIPCode |
varchar(5) |
ZIP Code |
|
PropertyPlus4 |
varchar(4) |
Plus4 |
|
PropertyDeliveryPoint |
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. |
|
PropertyAddressKey |
varchar(11) |
Address key is a combination of a location?s ZIPCode + Plus4 + DeliveryPoint |
|
PropertyAddressStreetNumber |
varchar(50) |
Address street number. Ex. ‘6450’ |
|
PropertyAddressDirectionPrefix |
varchar(10) |
Address directional prefix. Ex. ‘e’ |
|
PropertyAddressStreetName |
varchar(100) |
Street name. Ex. ‘Side’ |
|
PropertyAddressStreetSuffix |
varchar(10) |
Suffix of address. Ex. ‘Dr’ |
|
PropertyAddressDirectionSuffix |
varchar(10) |
Address directional suffix. Ex. ‘Ne’ |
|
PropertyAddressSuiteName |
varchar(50) |
Suite. Ex. ‘Apt’ |
|
PropertyAddressSuiteNumber |
varchar(50) |
Suite number. Ex. ‘Q’ |
|
PropertyRBDI |
varchar(1) |
Business/residential indication |
|
PropertyCarrierRoute |
varchar(4) |
The carrier route for the location address as assigned by the USPS. |
|
PropertyFIPSCode |
varchar(5) |
The FIPSCode indicates the location of the address at both the state and county level. |
|
PropertyAddressType |
varchar(1) |
Address type |
|
PropertyResultCodes |
varchar(100) |
Melissa result codes |
|
Propertygeo |
PropertyCensusKey |
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. |
PropertyLatitude |
decimal(18, 6) |
The latitude in decimal degrees using the WGS84 datum for the address |
|
PropertyLongitude |
decimal(18, 6) |
The longitude in decimal degrees using the WGS84 datum for the address |
|
Parcel |
UDParcelNumberRaw |
varchar(45) |
Undecorated Assessor’s Parcel Number or Parcel Identification Number. |
ParcelNumberRaw |
varchar(45) |
Assessor’s Parcel Number or Parcel Identification Number. |
|
ParcelNumberYearAdded |
int |
The year that the current Parcel Number was created by the Assessor. |
|
ParcelNumberAlternate |
varchar(60) |
In addition to the primary parcel number, an alternate property identifier. |
|
ParcelAccountNumber |
varchar(30) |
When provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes. |
|
Tax |
TaxYearAssessed |
varchar(4) |
Relates to the current lien date for which the values contained in (Assessed Land Value, Assessed Improvement Value and Total Assessed Value) were established. If a fiscal year (Mar’95 - Feb’96), this is the beginning year (i.e. 1995). |
TaxAssessedValueTotal |
int |
The total current assessed value of both Land and Improvements (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only. |
|
TaxAssessedValueImprovements |
int |
The current assessed value of the improvements only (before exemptions) as reported on the current county tax/assessment roll. Whenever separate fields are provided for additional improved values, this will be the total of all improvement values. |
|
TaxAssessedValueLand |
int |
The current assessed value of the land only (before exemptions) as reported on the current county tax/assessment roll. |
|
TaxMarketValueYear |
varchar(4) |
The year the market values were established. Normally, this is a constant year for all records with a market value > zero, although there are cases where the county file contains the year each parcel was physically appraised and in such cases we move the Market Value year specific to each parcel resulting in several different values per county. |
|
TaxMarketValueTotal |
int |
When available from the county, the Total Market Value as determined by the Assessor. See also Total Assessed Value |
|
TaxMarketValueImprovements |
int |
When available from the county, the Market Improvement Value as determined by the Assessor. See also Assessed Improvement Value |
|
TaxMarketValueLand |
int |
When available from the county, the Market Land Value as determined by the Assessor. See also Assessed Land Value |
|
TaxFiscalYear |
varchar(4) |
This is the year in which the amount shown in Tax Amount was levied. |
|
TaxRateArea |
varchar(18) |
Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll. |
|
TaxBilledAmount |
decimal(11, 2) |
This field contains the amount of tax on the property expressed in dollars and cents |
|
TaxDelinquentYear |
varchar(4) |
This is the year in which the property tax became delinquent (unpaid). |
|
AVM |
PropertyEstimatedValue |
int |
Property estimated value |
CurrentDeed |
Mortgage1Amount |
int |
Mortgage (purchase money) recorded concurrently with the conveying instrument. |
Mortgage1InterestRate |
decimal(10, 2) |
When available, initial rate as given on the trust deed or rider. |
|
Mortgage1InterestRateType |
varchar(1) |
When available will indicate the type of interest rate terms for the concurrent TD |
|
Mortgage1LenderInfoSellerCarryBackInd |
bit |
Indicator for lender type |
|
Mortgage1LenderNameFullStandardized |
varchar(40) |
Name of the beneficiary to the first trust deed (mortgage). |
|
Mortgage1RecordingDate |
date |
The official date of the document recordation. |
|
Mortgage1Type |
varchar(3) |
Indicates the type of loan, if able to determine from the recorded document. See Code Description table. |
|
Mortgage2Amount |
int |
Loan amount of second trust deed concurrent (subject to) to the original (1st) loan. |
|
Mortgage2InterestRate |
varchar(1) |
When available, initial rate as given on the trust deed or rider. |
|
Mortgage2InterestRateType |
varchar(1) |
When available will indicate the type of interest rate terms for the concurrent TD |
|
Mortgage2LenderInfoSellerCarryBackInd |
varchar(1) |
Indicator for lender type |
|
Mortgage2LenderNameFullStandardized |
varchar(1) |
Name of the beneficiary to the first trust deed (mortgage). |
|
Mortgage2RecordingDate |
date |
The official date of the document recordation. |
|
Mortgage2Type |
varchar(1) |
Indicates the type of loan, if able to determine from the recorded document. See Code Description table. |
|
SaleInfo |
AssessorLastSaleAmount |
int |
Whole dollars only without commas (,) and NO Cents |
AssessorLastSaleDate |
date |
Recording Date of the latest sale in the transaction history. |
|
VestingTypeCode |
varchar(3) |
When available, either identifies how the Assessee took title (vesting) OR describes the type of entity (ID) based on conversion. See Code Description table. |
|
TrustDescription |
varchar(50) |
Trust description |
|
CompanyInd |
varchar(1) |
Indicating the property is company owned |
|
PropertyUseInfo |
YearBuilt |
varchar(4) |
Year the primary structure on the property was built |
EffectiveYearBuilt |
varchar(4) |
The date that reflects the condition of an improvement. It is the same or later than Year Built. |
|
UseStandardized |
varchar(3) |
Land Use code standardized for all counties. See Separate Land Use Table. |
|
ExteriorAmendities |
AreaBuilding |
int |
The building area of the primary structure on the property.When multiple building areas are given for a structure, the preferred data for this field is Living Area for residential properties and Total Area for all others. |
AreaLotAcres |
decimal(18, 7) |
This field contains the total area measurement of the land in acres. If the lot size is provided by the county assessor in square feet, this field will contain a conversion of square feet to acres. |
|
AreaLotSF |
int |
This field contains the total area measurement of the land in square feet. If the lot size is provided by the county assessor in acres, this field will be show the conversion to square feet. |
|
Pool |
varchar(3) |
Indicates if a pool exists on the property and any additional information about the pool. |
|
Foundation |
varchar(3) |
Indicates the type of foundation for the primary structure on the property. |
|
Construction |
varchar(2) |
Indicates the material used in the construction of the framework for the primary structure on the property. |
|
RoofConstruction |
varchar(3) |
Indicates the primary roof framing structure (A-Frame, Gable, Mansard, etc.). |
|
ContentOverheadDoorInd |
bit |
Indicates the existence of an Overhead Door. |
|
ViewDescription |
varchar(3) |
Identifies features or characteristics of a location which might influence the value or desirability of a parcel, such as waterfront or traffic patterns. The field can contain up to two codes. |
|
PorchCode |
varchar(3) |
This indicates if a proch is present, and if so, potentially what type of porch. |
|
PorchArea |
int |
The total square footage of the porch(s) on the property . |
|
PatioArea |
int |
The square footage of the patio(s) for all structures on a property. |
|
DeckInd |
bit |
Code indicating the presence of a deck on the property. It, alternatively, can also indicate if the deck is covered. |
|
DeckArea |
int |
If a deck is present, this details the size of the deck in square feet. |
|
InteriorAmendities |
RoomsBasementArea |
int |
The total area of the basement, in square feet. |
InteriorStructure |
varchar(3) |
This field contains a code reflecting the composition of the interior walls |
|
BathCount |
decimal(5, 2) |
Physical count of all bathrooms (including 1/2 baths). See Code Description table. Input Format: 99v99 (implied decimal) |
|
BedroomsCount |
int |
Actual count of bedrooms (with closet). Residential only. |
|
UnitsCount |
int |
Number of Units reported on the Assessment Roll. Primarily used for reporting of apartment buildings. |
|
FireplaceInd |
bit |
Indicating the presence of fireplace |
|
ContentStormShutterInd |
bit |
Indicates the presence of Storm Shutters on the main structure. |
|
HVACCoolingDetail |
varchar(3) |
Indicates the method or system used to provide cooling. |
|
HVACHeatingDetail |
varchar(3) |
Indicates the method or system used to provide heat. |
|
Foreclosure |
ForeclosureLenderNameFullStandardized |
varchar(40) |
Name of the beneficiary to the first trust deed (mortgage). |
ForeclosureLenderAddressLine |
varchar(100) |
Lender Address |
|
ForeclosureLenderAddressCity |
varchar(50) |
Lender Address City |
|
ForeclosureLenderAddressState |
varchar(2) |
Lender Address State |
|
ForeclosureLenderAddressZIPCode |
varchar(10) |
Lender Address ZIP Code |
|
ForeclosureLenderAddressStreetNumber |
varchar(25) |
Address street number. Ex. ‘6450’ |
|
ForeclosureLenderAddressDirectionPrefix |
varchar(10) |
Address street number. Ex. ‘6450’ |
|
ForeclosureLenderAddressStreetName |
varchar(100) |
Street name. Ex. ‘Side’ |
|
ForeclosureLenderAddressStreetSuffix |
varchar(10) |
Suffix of address. Ex. ‘Dr’ |
|
ForeclosureLenderAddressDirectionSuffix |
varchar(25) |
Address directional suffix. Ex. ‘Ne’ |
|
ForeclosureLenderAddressSuiteNumber |
varchar(25) |
Suite number. Ex. ‘Q’ |
|
ForeclosureLenderPhone |
varchar(15) |
Lender Phone Number |
|
ForeclosureLenderPhoneDNCInd |
bit |
Do not call Flag for Foreclosure_LenderPhone |
|
ForeclosureInstrumentNumber |
varchar(20) |
Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation as listed on the county/tax assessment roll. |
|
ForeclosureRecordingDate |
date |
Recording Date for most recent sale as listed on the county tax/assessment roll, if available. The date the property sold to the current ownership. Format provides four positions for the year: YYYYMMDD |
|
ForeclosureRecordedAuctionOpeningBid |
varchar(11) |
The minimum bid amount as reported on the Notice of Sale or reflects the total amount due on the loan. |
|
ForeclosureAuctionDate |
date |
The scheduled Auction Date as reported on the Notice of Sale. |
|
ForeclosureAuctionTime |
varchar(5) |
The scheduled Auction Time as reported on the Notice of Sale. |
|
ForeclosureAuctionAddress |
varchar(60) |
The Street Address where the auction is scheduled to take place, usually reported on the Notice of Sale |
|
ForeclosureAuctionCity |
varchar(40) |
The City where the auction is scheduled to take place as reported on the Notice of Sale |
|
ForeclosureServicerAddress |
varchar(60) |
Full Street Address, City, State, ZIP Code and Plus4 |
|
ForeclosureServicerPhoneNumber |
varchar(25) |
Foreclosure Servicer Phone Number |
|
ForeclosureServicerPhoneDNCInd |
bit |
Do not call Flat for Foreclosure Servicer Phone Number |
|
ForeclosureTrusteeReferenceNumber |
varchar(15) |
Number assigned by the Trustee for the purpose of tracking the foreclosure for the given property. |
|
ForeclosureTrusteeName |
varchar(40) |
Trustee First Name & Middle Name. Note: In Colorado, the Trustee fields will be blank since Colorado uses a Public Trustee |
|
ForeclosureTrusteeAddress |
varchar(60) |
Trustee Full Street Address , City, State, Zip Code, Plus4 |
|
ForeclosureTrusteeAddressCity |
varchar(30) |
Trustee City |
|
ForeclosureTrusteeAddressState |
varchar(2) |
Trustee State |
|
ForeclosureTrusteeAddressZIPCode |
varchar(5) |
Trustee ZIP Code |
|
ForeclosureTrusteePhone |
varchar(12) |
Trustee Phone Number |
|
ForeclosureTrusteePhoneDNCInd |
bit |
Do not call Flag for Foreclosure_TrusteePhone |
|
ForeclosureJudgmentAmount |
int |
Whole dollars. Unpaid principal amount of the loan as stated on the foreclosure document. |
|
ForeclosureBorrowerNameOwner |
varchar(40) |
#1 - Trustor/Borrower First Name & Middle |
|
ForeclosureOriginalLoanAmount |
int |
Loan amount of the original loan in default. Whole dollars only. |
|
ForeclosureRecordType |
varchar(3) |
Unique 2 position document type field that identifies the foreclosure record type. Refer to Foreclosure Doc Type by State tab for complete list. |
|
ForeclosureDefaultAmount |
int |
Amount that is past due on the loan. First priority is to key the Total Delinquency Amount, if this is not available, then enter the Installment Payment Amount. |
|
ForeclosureRecordLastUpdated |
date |
The official date of recordation for the foreclosure document. |
|
MailingAddress |
MailingMelissaAddressKey |
bigint |
10-digit unique key assigned to each address. |
MailingBaseMelissaAddressKey |
bigint |
Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment |
|
MailingAddressLine |
varchar(150) |
Address line |
|
MailigCity |
varchar(100) |
Mailing city |
|
MailingState |
varchar(2) |
State |
|
MailingZIPCode |
varchar(5) |
ZIP Code |
|
MailingPlus4 |
varchar(4) |
Plus4 |
|
MailingDeliveryPoint |
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. |
|
MailingResultCodes |
varchar(100) |
Melissa result codes |
|
MailingAddressStreetNumber |
varchar(50) |
Address street number. Ex. ‘6450’ |
|
MailingAddressDirectionPrefix |
varchar(20) |
Address directional prefix. Ex. ‘e’ |
|
MailingAddressStreetName |
varchar(100) |
Street name. Ex. ‘Side’ |
|
MailingAddressStreetSuffix |
varchar(20) |
Suffix of address. Ex. ‘Dr’ |
|
MailingAddressDirectionSuffix |
varchar(20) |
Address directional suffix. Ex. ‘Ne’ |
|
MailingAddressSuiteName |
varchar(50) |
Suite. Ex. ‘Apt’ |
|
MailingAddressSuiteNumber |
varchar(50) |
Suite number. Ex. ‘Q’ |
|
MailingRBDI |
varchar(1) |
Business/residential indication |
|
MailingCarrierRoute |
varchar(4) |
The carrier route for the location address assigned by the USPS. |
|
MailingFIPSCode |
varchar(5) |
The FIPSCode indicates the location of the address at both the state and county level. |
|
MailingAddressType |
varchar(1) |
Address type |
|
MailingAddressgeo |
MailingCensusKey |
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. |
PlaceCode |
varchar(5) |
Place Codes, Place as defined by the US Census Bureau. Supplemental geographical definition provided to assist with data analysis. |
|
Phone |
FullPhoneNumber |
varchar(10) |
Full phone number |
FullPhoneNumber_DNCInd |
bit |
Do not call Flag for Phone |
|
CellPhoneNumber |
varchar(10) |
Cell phone number |
|
Emaill |
CellPhoneNumber_DNCInd |
bit |
Do not call Flag for Cell Phone |
varchar(450) |
|||
EmailResultLevel |
int |
EmailResultLevel |