Links

US Housing & Real Estate Essentials

US housing valuation & financing, addresses, change of address requests, points of interest, and income levels

Overview

US Housing & Real Estate Essentials serves as a central source of housing and real estate data covering the United States. This product provides housing valuation and financing, migration, addresses, points of interest (POI), and income statistics across the US. A single, unified schema joins together across the various publishers.
Example topics covered:
  • Housing market values and appraisals
  • Mortgage lending, bankruptcies, and rates
  • Change of address requests through June 30, 2023
  • Income levels
  • Business locations and points of interest
  • Geographic boundaries

Data Sources, Attributes, Sample Queries

A detailed description of the data is available by source. Source pages include key attributes (e.g. geographic coverage, time granularity, history, entity level), release frequency, notes & methodologies, and sample queries.
All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.
As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Data Dictionary

Releases & Changelog

1/3/24 - Added monthly housing prices and weekly mortgage interest rates from Freddie Mac
Added Freddie Mac’s House Price Index (HPI) which provides a monthly measure of typical price inflation for single family homes within the US using data from loans purchased by Freddie Mac or Fannie Mae.
Added Freddie Mac's Primary Mortgage Market Survey (PMMS) which provides a weekly report on the national average of 30/15-year fixed rate mortgages as well as adjustable rate mortgages, tracking borrowing costs for US homebuyers and refinancers.
The data is available in the following tables:
  • FREDDIE_MAC_HOUSING_ATTRIBUTES details the Freddie Mac House Price Index and mortgage interest rate variables covered.
  • FREDDIE_MAC_HOUSING_TIMESERIES provides historical values for each reported attribute
10/09/23 - Added U.S. Census Regions & Divisions.
Expanded the geography_index table to include U.S. Census Regions and Divisions.
Expanded the geography_hierarchy table to include the relationships between U.S. Census regions and U.S. Census divisions; U.S. Census regions and U.S. states; and U.S. Census divisions and U.S. states.
Census regions include the United States Northeast, Midwest, etc. and census divisions include the United States Middle Atlantic, East North Central, etc.
8/27/23 - Added points of interest data from Overture Maps Foundation
Added the point_of_interest_index table, which includes names and categories for points of interest in the US. Each POI is uniquely identified by a POI_ID.
To tie POIs to addresses, we added a new column, ADDRESS_ID, to the us_addresses table to uniquely identify each individual address. This column allows users to join addresses to POIs using the new point_of_interest_addresses_relationships table with POI_ID and ADDRESS_ID as the join keys for the point_of_interest_index table and us_addresses table, respectively.
8/27/23 - Added 7.2M new addresses, removed 49.8M duplicate addresses, deleted 1.2M addresses with Null STREET value
Added 7.2M new addresses covering points of interest from Overture Maps Foundation to the us_addresses table.
Removed 49.8M addresses that were duplicative aside from minor variability in coordinates. Removed 1.2M rows from rows from the us_addresses table where the STREET value contained a string with value Null.
8/27/23 - Added country-level geospatial boundaries to the geography_characteristics table
Added country-level geospatial boundaries to the geography_characteristics table with data from Overture Maps Foundation.
8/11/23 - Added geospatial boundaries data for territories in the US and Canada
The Census Bureau and Statistics Canada publish geospatial boundaries data for their territories at multiple geographic levels. We added a table geography_characteristics with the boundary coordinates from the most recent releases in both WKT and GeoJSON formats. The table is joinable at different levels using Cybersyn's GEO_ID. This GEO_ID is compatible with all Cybersyn listings that have geographic identifiers. Currently, the geographic levels covered include:
  • State (US and Canada)
  • County (US only)
  • Census Tract (US only)
  • ZIP Code (US only)
  • Dissemination Area and Aggregate Dissemination Area (Canada only)
  • Census Division and Census Subdivision (Canada only)
  • Census Agglomeration and Census Agglomeration Part (Canada only)
  • Census Metropolitan Division and Census Metropolitan Division Part (Canada only)

Disclaimers

The data in this dataset is sourced on the individual source pages. Links to provider license, terms and disclaimers are provided where appropriate: Copyright © 2021 OpenAddresses & License OpenAddresses, Data Commons: License, Overture Maps Foundation Disclaimer
Cybersyn is not endorsed by or affiliated with any of these providers.
Last modified 14d ago