| 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 |