Dataset: Zillow Observed Rent Index (Jan 2014- June 2021)

About this Dataset

Zillow Observed Rent Index (Jan 2014- June 2021)

Context

The purpose of this dataset is to provide updated data on the Zillow Observed Rent Index (ZORI). Most of the Zillow datasets on Kaggle have not been updated in four years, and no other dataset except one contains information related to rent. Providing updated data on this will also allow the community to analyze the effects of COVID-19 on rent prices, which could not be done with previous available data sets.

Content

Zillow Observed Rent Index (ZORI): A smoothed measure of the typical observed market rate rent across a given region. ZORI is a repeat-rent index that is weighted to the rental housing stock to ensure representativeness across the entire market, not just those homes currently listed for-rent. The index is dollar-denominated by computing the mean of listed rents that fall into the 40th to 60th percentile range for all homes and apartments in a given region, which is once again weighted to reflect the rental housing stock. Details available in ZORI methodology. https://www.zillow.com/research/methodology-zori-repeat-rent-27092/

This dataset contains two files. The Metro dataset looks at the median rent prices for large US cities. The ZIP code dataset breaks the US cities down by their ZIP codes. Note that the region IDs in both datasets are only used for tracking purposes. Also, some of the ZIP codes under the Region Name are less than the standard five-digit zip code and unreliable. Even if you add zeros in accounting for possible formatting mistakes. It is recommended to remove these entries since there is no way to identify which ZIP code the entry actually represents. These entries are left in here in case some analyst can solve the issue.

Acknowledgements

Zillow provides many useful open source datasets that relate to housing, which can be found at Zillow Research Data. https://www.zillow.com/research/data/
This dataset was also prompted by an older dataset I came across that only lacked updated data. https://www.kaggle.com/zillow/rent-index
Thumbnail and banner picture is from this pixabay artist https://pixabay.com/users/pexels-2286921/

Inspiration

Where are the cheapest and most expensive ZIP codes to live?
We all know rent increases overtime, but has it been increasing at a faster rate since 2014?
If rent has been increasing at a faster rate, what year did it increase the fastest?
What cities or ZIP codes are increasing rent the fastest and by how much?
Did rent continue to increase during the COVID-19 pandemic, and was it at a faster or slower rate than previous years?

Tables

Zori Metros Allhomesplusmultifamily Ssa

@kaggle.haydenvenable_zillow_observed_rent_index_jan_2014_june_2021.zori_metros_allhomesplusmultifamily_ssa

108.07 KB
102 rows
93 columns


CREATE TABLE zori_metros_allhomesplusmultifamily_ssa (
  "regionid" BIGINT,
  "regionname" VARCHAR,
  "sizerank" BIGINT,
  "n_2014_01" DOUBLE,
  "n_2014_02" BIGINT,
  "n_2014_03" BIGINT,
  "n_2014_04" BIGINT,
  "n_2014_05" BIGINT,
  "n_2014_06" BIGINT,
  "n_2014_07" BIGINT,
  "n_2014_08" BIGINT,
  "n_2014_09" BIGINT,
  "n_2014_10" BIGINT,
  "n_2014_11" BIGINT,
  "n_2014_12" BIGINT,
  "n_2015_01" BIGINT,
  "n_2015_02" BIGINT,
  "n_2015_03" BIGINT,
  "n_2015_04" BIGINT,
  "n_2015_05" BIGINT,
  "n_2015_06" BIGINT,
  "n_2015_07" BIGINT,
  "n_2015_08" BIGINT,
  "n_2015_09" BIGINT,
  "n_2015_10" BIGINT,
  "n_2015_11" BIGINT,
  "n_2015_12" BIGINT,
  "n_2016_01" BIGINT,
  "n_2016_02" BIGINT,
  "n_2016_03" BIGINT,
  "n_2016_04" BIGINT,
  "n_2016_05" BIGINT,
  "n_2016_06" BIGINT,
  "n_2016_07" BIGINT,
  "n_2016_08" BIGINT,
  "n_2016_09" BIGINT,
  "n_2016_10" BIGINT,
  "n_2016_11" BIGINT,
  "n_2016_12" BIGINT,
  "n_2017_01" BIGINT,
  "n_2017_02" BIGINT,
  "n_2017_03" BIGINT,
  "n_2017_04" BIGINT,
  "n_2017_05" BIGINT,
  "n_2017_06" BIGINT,
  "n_2017_07" BIGINT,
  "n_2017_08" BIGINT,
  "n_2017_09" BIGINT,
  "n_2017_10" BIGINT,
  "n_2017_11" BIGINT,
  "n_2017_12" BIGINT,
  "n_2018_01" BIGINT,
  "n_2018_02" BIGINT,
  "n_2018_03" BIGINT,
  "n_2018_04" BIGINT,
  "n_2018_05" BIGINT,
  "n_2018_06" BIGINT,
  "n_2018_07" BIGINT,
  "n_2018_08" BIGINT,
  "n_2018_09" BIGINT,
  "n_2018_10" BIGINT,
  "n_2018_11" BIGINT,
  "n_2018_12" BIGINT,
  "n_2019_01" BIGINT,
  "n_2019_02" BIGINT,
  "n_2019_03" BIGINT,
  "n_2019_04" BIGINT,
  "n_2019_05" BIGINT,
  "n_2019_06" BIGINT,
  "n_2019_07" BIGINT,
  "n_2019_08" BIGINT,
  "n_2019_09" BIGINT,
  "n_2019_10" BIGINT,
  "n_2019_11" BIGINT,
  "n_2019_12" BIGINT,
  "n_2020_01" BIGINT,
  "n_2020_02" BIGINT,
  "n_2020_03" BIGINT,
  "n_2020_04" BIGINT,
  "n_2020_05" BIGINT,
  "n_2020_06" BIGINT,
  "n_2020_07" BIGINT,
  "n_2020_08" BIGINT,
  "n_2020_09" BIGINT,
  "n_2020_10" BIGINT,
  "n_2020_11" BIGINT,
  "n_2020_12" BIGINT,
  "n_2021_01" BIGINT,
  "n_2021_02" BIGINT,
  "n_2021_03" BIGINT,
  "n_2021_04" BIGINT,
  "n_2021_05" DOUBLE,
  "n_2021_06" BIGINT
);

Zor Zipcodes Allhomesplusmultifamily Smoothed

@kaggle.haydenvenable_zillow_observed_rent_index_jan_2014_june_2021.zor_zipcodes_allhomesplusmultifamily_smoothed

696.4 KB
1743 rows
94 columns


CREATE TABLE zor_zipcodes_allhomesplusmultifamily_smoothed (
  "regionid" BIGINT,
  "regionname" BIGINT,
  "sizerank" BIGINT,
  "msaname" VARCHAR,
  "n_2014_01" DOUBLE,
  "n_2014_02" DOUBLE,
  "n_2014_03" DOUBLE,
  "n_2014_04" DOUBLE,
  "n_2014_05" DOUBLE,
  "n_2014_06" DOUBLE,
  "n_2014_07" DOUBLE,
  "n_2014_08" DOUBLE,
  "n_2014_09" DOUBLE,
  "n_2014_10" DOUBLE,
  "n_2014_11" DOUBLE,
  "n_2014_12" DOUBLE,
  "n_2015_01" DOUBLE,
  "n_2015_02" DOUBLE,
  "n_2015_03" DOUBLE,
  "n_2015_04" DOUBLE,
  "n_2015_05" DOUBLE,
  "n_2015_06" DOUBLE,
  "n_2015_07" DOUBLE,
  "n_2015_08" DOUBLE,
  "n_2015_09" DOUBLE,
  "n_2015_10" DOUBLE,
  "n_2015_11" DOUBLE,
  "n_2015_12" DOUBLE,
  "n_2016_01" DOUBLE,
  "n_2016_02" DOUBLE,
  "n_2016_03" DOUBLE,
  "n_2016_04" DOUBLE,
  "n_2016_05" DOUBLE,
  "n_2016_06" DOUBLE,
  "n_2016_07" DOUBLE,
  "n_2016_08" DOUBLE,
  "n_2016_09" DOUBLE,
  "n_2016_10" DOUBLE,
  "n_2016_11" DOUBLE,
  "n_2016_12" DOUBLE,
  "n_2017_01" DOUBLE,
  "n_2017_02" DOUBLE,
  "n_2017_03" DOUBLE,
  "n_2017_04" DOUBLE,
  "n_2017_05" DOUBLE,
  "n_2017_06" DOUBLE,
  "n_2017_07" DOUBLE,
  "n_2017_08" DOUBLE,
  "n_2017_09" DOUBLE,
  "n_2017_10" DOUBLE,
  "n_2017_11" DOUBLE,
  "n_2017_12" DOUBLE,
  "n_2018_01" DOUBLE,
  "n_2018_02" DOUBLE,
  "n_2018_03" DOUBLE,
  "n_2018_04" DOUBLE,
  "n_2018_05" DOUBLE,
  "n_2018_06" DOUBLE,
  "n_2018_07" DOUBLE,
  "n_2018_08" DOUBLE,
  "n_2018_09" DOUBLE,
  "n_2018_10" DOUBLE,
  "n_2018_11" DOUBLE,
  "n_2018_12" DOUBLE,
  "n_2019_01" DOUBLE,
  "n_2019_02" DOUBLE,
  "n_2019_03" DOUBLE,
  "n_2019_04" DOUBLE,
  "n_2019_05" DOUBLE,
  "n_2019_06" DOUBLE,
  "n_2019_07" DOUBLE,
  "n_2019_08" DOUBLE,
  "n_2019_09" DOUBLE,
  "n_2019_10" DOUBLE,
  "n_2019_11" DOUBLE,
  "n_2019_12" DOUBLE,
  "n_2020_01" DOUBLE,
  "n_2020_02" DOUBLE,
  "n_2020_03" DOUBLE,
  "n_2020_04" DOUBLE,
  "n_2020_05" DOUBLE,
  "n_2020_06" DOUBLE,
  "n_2020_07" DOUBLE,
  "n_2020_08" DOUBLE,
  "n_2020_09" DOUBLE,
  "n_2020_10" DOUBLE,
  "n_2020_11" DOUBLE,
  "n_2020_12" DOUBLE,
  "n_2021_01" DOUBLE,
  "n_2021_02" DOUBLE,
  "n_2021_03" DOUBLE,
  "n_2021_04" DOUBLE,
  "n_2021_05" DOUBLE,
  "n_2021_06" DOUBLE
);