Housing Data Ninja Consolidated Dataset

We currently have a beta version of a consolidated CSV file of publicly available data. This file will continue to be updated with many more publicly available fields and derived variables. Download latest file.

Variable Naming Conventions

To support time-series analysis, additional variables have been created for each original economic indicator. These follow a consistent naming pattern to make them easy to interpret:

Lagged Variables

Format: VARIABLE_LAGn
- VARIABLE = The original variable name (e.g., UNRATE, HOUST, PERMIT).
- n = The number of months the value is lagged.
- Example: UNRATE_LAG3 = Unemployment rate value from 3 months prior.

Rolling Standard Deviation Variables

Format: VARIABLE_SD6
- VARIABLE = The original variable name.
- SD6 = Standard deviation of the past 6 months (rolling window).
- Example: HOUST_SD6 = 6-month rolling standard deviation of housing starts.

These derived variables are useful for understanding both short-term volatility (via standard deviations) and historical trends (via lagged values) in the dataset.

Metadata & Definitions

Notes: SAAR = Seasonally Adjusted Annual Rate. NSA = Not Seasonally Adjusted.

HOUST Housing Starts — New Privately-Owned Housing Units Started: What: Number of new privately-owned housing units on which construction started (single- & multi-family).

Freq/Units: Monthly, SAAR, thousands of units.

Source: U.S. Census Bureau & HUD.

View on FRED
PERMIT New Private Housing Units Authorized by Building Permits: What: Housing units authorized by building permits (pipeline/leading indicator).

Freq/Units: Monthly, SAAR, thousands of units.

Source: U.S. Census Bureau & HUD.

View on FRED
CSUSHPINSA S&P/Case-Shiller U.S. National Home Price Index (NSA): What: Repeat-sales index tracking resale home prices nationwide (base 2000:01 = 100).

Freq/Units: Monthly, NSA, index (2000=100).

Source: S&P Dow Jones Indices via FRED.

View on FRED
HSN1F New One-Family Houses Sold — United States: What: Sales of new single-family homes (counted at contract signing).

Freq/Units: Monthly, SAAR, thousands of units.

Source: U.S. Census Bureau & HUD.

View on FRED
ACTLISCOUUS Housing Inventory — Active Listing Count (United States): What: Total number of active residential listings nationwide.

Freq/Units: Monthly, level (number of listings), NSA.

Source: Realtor.com via FRED.

View on FRED
UNRATE Unemployment Rate (Civilian, 16+, SA): What: Share of the civilian labor force that is unemployed.

Freq/Units: Monthly, seasonally adjusted, percent.

Source: U.S. Bureau of Labor Statistics (CPS) via FRED.

View on FRED