Numeric code to identify every County/State in the US. 1st 2 positions = State, last 3 positions = County
varchar
Assessor's Parcel Number (APN, PIN)
Present if matched
varchar
Property Full Street Address
For Address components, see Property Address Fields on Assessment Tab of Public Records RLO.
varchar
Property Unit Type
Property Address Unit Designator.
varchar
Property Unit Number
For Address components, see Property Address Fields on Assessment Tab of Public Records RLO.
varchar
Property City Name
For Address components, see Property Address Fields on Assessment Tab of Public Records RLO.
varchar
Property State
Two-letter standard postal abbreviation
varchar
Property Zip Code
Five-digit postal zip code.
varchar
Estimated Date
The date the valuation was created
varchar
Estimated Value
The derived valuation for the subject property
varchar
Confidence Score
100 - FSD_Score (description below)
varchar
FSD
Forecasted Standard Deviation. A statistical measure that represents the probability that the valuation falls within one standard deviation of the actual market value. For example: If the FSD for an HVE value estimate is 10%, there is a 68% (one standard deviation) probability that the actual market value will fall between +/-10% of the HVE value estimate.
varchar
Price Range Min
Low limit of the valuation range
varchar
Price Range Max
High limit of the valuation range
varchar
Hashvalue
Record hash value, updated hashvalue indicates if the record changed
varchar
ModificationTimestamp
When the record was updated
TimeStamp
Hashvalue
Record hash value, updated hashvalue indicates if the record changed
varchar
Version
varchar
Constellation AVM Whitepaper
AVM History Layout
Field Name
Field Description
Data Type
Constellation1_ID (CID)
Unique Identifier in Constellation1
varchar
Record ID
Source ID
varchar
Fips Code
Numeric code to identify every County/State in the US. 1st 2 positions = State, last 3 positions = County
varchar
Assessor's Parcel Number (APN, PIN)
Present if matched
varchar
Property House Number
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property Street Direction Left
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property Street Name
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property Street Suffix
The recommended Official USPS Standardized Suffix Abbreviations
varchar
Property Street Direction Right
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property Unit Type
Property Address Unit Designator.
varchar
Property Unit Number
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property City Name
For Address components, see Property Address fields on Assessment Tab in Public Records RLO.
varchar
Property State
Two-letter standard postal abbreviation.
varchar
Property Zip Code
Five-digit postal zip code.
varchar
YYYY_MM_Val
Starting way back from 2019 July the derived valuation for the subject property in that month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07). Every month we will be adding a new column for that month with YYYY_MM_Val format
number
YYYY_MM_Low
Starting way back from 2019 July the low limit of the valuation range in year + month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07) Every month we will be adding a new column for that month with YYYY_MM_Low
number
YYYY_MM_High
Starting way back from 2019 July high limit of the valuation range in year + month. We will have repeated columns for YYYY_MM_Val where YYYY = year (2019) and MM = month (07). Every month we will be adding a new column for that month with YYYY_MM_High
number
Full Detail information
Confidential. Not for Distribution.