We’ve just completed a robust update cycle focused on improving the accuracy and usability of our home mortgage data. While we’ve made our usual improvements—like updating records, correcting characteristics, and removing entries for deceased individuals—this quarter’s featured update is on reconciling and refining mortgage-related fields.
New: Estimated Home Value Change Fields
To better track fluctuations in housing markets, we’ve added three new fields to each record that measure estimated home value changes over different time horizons:
home_est_value_change_1_year(1-year value change)home_est_value_change_3_year(3-year value change)home_est_value_change_5_year(5-year value change)
Each field contains a percentage change (e.g., 1.82 for a 1.82% increase or -5.10 for a 5.1% decrease). These calculations are based on our estimated home values, not tax assessments, offering a more refined picture of neighborhood trends over time.
Updated Mortgage Field Definitions
In our latest data dictionary, fields marked in green indicate code and definition updates. Two key mortgage-related fields have been revised:
Home_Mortgage_TypeHome_Transaction_Type
These changes support greater consistency across mortgage records and better alignment with external data sources.
🆕 New Field Addition
We’ve also introduced a new mortgage-related field:
Most_Recent_2nd_Mortgage_Transaction_Type
This field captures the latest known activity involving a second mortgage on the property.
If you have questions about implementing these updates or want to explore how to use the new value change fields in your analysis, feel free to reach out. We’re here to help make your insights sharper and your strategy stronger.
