US housing valuation & financing, addresses, points of interest, construction spending, & building permits
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
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.
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_ATTRIBUTESUS_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 NullSTREET 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.
Cybersyn is not endorsed by or affiliated with any of these providers.
