Field Name | Field Description | Data Type |
---|---|---|
Constellation_ID (CID) | CID (Constellation Unique Identifier) | varchar |
FIPS Code (State/County) | 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 |
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 |