Dataset: U.S. Housing Market Factors

About this Dataset

U.S. Housing Market Factors

The data in this dataset is collected from FRED.

I decided to create this dataset while reading the research paper Factors Affecting House Prices in Cyprus: 1988-2008 by Panos Pashardes & Christos S. Savva. This research paper is extremely informative and covers a lot of details regarding the macroeconomics involved in real estate market. So I would recommend you all to go through it once.

NOTE:

This dataset will be updated over a period of time and include the following:

Macroeconomic factors with quarterly, monthly frequencies.
Microeconomic factors such as house type, age, location, size (BR, BA, carpet area/built-up area), facilities, view, disability functions, region, house prices, etc.

NOTE 2:

I recommend you all to check the file in this dataset with the title Housing_Macroeconomic_Factors_US (2).csv, it includes both the supply and demand factors associated with the housing market.

General Defintions:

1. Macroeconomic Factors

House_Price_Index: House price change according to the index base period set (you can check the date at which this value is 100).
Stock_Price_Index: Stock price change according to the index base period set (you can check the date at which this value is 100).
Consumer_Price_Index: The Consumer Price Index measures the overall change in consumer prices based on a representative basket of goods and services over time.
Population: Population of USA (unit: thousands).
Unemployment_Rate: Unemployment rate of USA (unit: percentage).
Real_GDP: GDP with adjusted inflation (Annual version unit: billions of chain 2012 dollars in, Monthly version unit: Annualised change).
Mortgage_Rate: Interest charged on mortgages (unit: percentage).
Real_Disposable_Income (Real Disposable Personal Income): Money left from salary after all the taxes are paid (unit: billions of chain 2012 dollars).
Inflation: Decline in purchasing power over time (unit: percentage). [Forgot to remove this column in Annual version since CPI is one of the measures used to determine inflation].

What can you do with this dataset?

Perform statistical analysis, find significant features & find the value by which these features affect the house price index (recommend to use a percentage change instead of index).
Perform multivariate regression and predict the price of houses using microeconomic features (soon).

Thanks!
If you like this dataset, I'll appreciate it if you give this dataset a vote! Discussions, suggestions & doubts are always welcome.
Happy Learning!!

Tables

Annual Macroeconomic Factors

@kaggle.faryarmemon_usa_housing_market_factors.annual_macroeconomic_factors

10.45 KB
47 rows
9 columns


CREATE TABLE annual_macroeconomic_factors (
  "date" TIMESTAMP,
  "house_price_index" DOUBLE,
  "stock_price_index" DOUBLE,
  "consumer_price_index" DOUBLE,
  "population" DOUBLE,
  "unemployment_rate" DOUBLE,
  "real_gdp" DOUBLE,
  "mortgage_rate" DOUBLE,
  "real_disposable_income" DOUBLE
);

Housing Macroeconomic Factors Us 2

@kaggle.faryarmemon_usa_housing_market_factors.housing_macroeconomic_factors_us_2

42.03 KB
425 rows
13 columns


CREATE TABLE housing_macroeconomic_factors_us_2 (
  "date" TIMESTAMP,
  "house_price_index" DOUBLE,
  "population" BIGINT,
  "house_supply" DOUBLE,
  "gdp" DOUBLE,
  "mortgage_rate" DOUBLE,
  "employment_rate" DOUBLE,
  "permit_new" DOUBLE,
  "ppi_res" DOUBLE,
  "m3" DOUBLE,
  "cci" DOUBLE,
  "delinquency_rate" DOUBLE,
  "hcai" DOUBLE
);

Monthly Macroeconomic Factors

@kaggle.faryarmemon_usa_housing_market_factors.monthly_macroeconomic_factors

33.61 KB
423 rows
9 columns


CREATE TABLE monthly_macroeconomic_factors (
  "date" TIMESTAMP,
  "house_price_index" DOUBLE,
  "stock_price_index" DOUBLE,
  "consumer_price_index" DOUBLE,
  "population" DOUBLE,
  "unemployment_rate" DOUBLE,
  "real_gdp" DOUBLE,
  "mortgage_rate" DOUBLE,
  "real_disposable_income" DOUBLE
);