US Housing & Real Estate Essentials

US housing valuation & financing, addresses, points of interest, construction spending, & building permits


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

  • Building permits

  • Total dollar value of construction work done each month on new structures or improvements to existing structures for private and public sectors

  • Number/total valuation of new housing units authorized by building permit, by state & structure type

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.

Releases & Changelog

2/26/24 - Added the Building Permit Survey and construction spending from the US Census Bureau

Added new data from the US Census Bureau. An indicator of future construction activity, the Building Permits Survey (BPS) provides the number and valuation of new housing units authorized by building permits at the national, state, and local levels. Construction Spending data quantifies actual expenditures on construction projects, categorized into residential, non-residential, and public sectors

The data is available in the following tables: US_REAL_ESTATE_ATTRIBUTES US_REAL_ESTATE_TIMESERIES

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)


The data in this dataset is sourced on the individual source pages. Links to provider license, terms and disclaimers are provided where appropriate.

Cybersyn is not endorsed by or affiliated with any of these providers.

Last updated

Copyright © 2024 Cybersyn