Doc: Zillow Rents

Using historical rental data, Zillow aggregates median rents by month for various apartment sizes across the US. You can read about their methodology here. The original source has many data sets that might be useful in your projects, we have provided 6 tables which we think are most interesting: rent statistics by neighborhood and zip code for studios, one bedroom, and two bedroom apartments. Each of the tables has median rents from October, 2010 until January, 2017. Note that some of the earlier months may have null values.

---

Table paths:

• `smart_cities_data.median_rents_neighborhood_studio`
  • Shape: 81 rows, 79 columns
• `smart_cities_data.median_rents_neighborhood_1br`
  • Shape: 274 rows, 79 columns
• `smart_cities_data.median_rents_neighborhood_2br`
  • Shape: 292 rows, 79 columns
• `smart_cities_data.median_rents_zipcode_studio`
  • Shape: 87 rows, 79 columns
• `smart_cities_data.median_rents_zipcode_1br`
  • Shape: 424 rows, 79 columns
• `smart_cities_data.median_rents_zipcode_2br`
  • Shape: 619 rows, 79 columns

Column Name	Explanation
RegionName	String, Represents either the neighborhood or zip code
City	String
State	String
Metro	String
CountyName	String
SizeRank	Integer
_2010_10	Float
_2010_11	Float
_2010_12	Float
_2011_01	Float
_2011_02	Float
_2011_03	Float
_2011_04	Float
_2011_05	Float
_2011_06	Float
_2011_07	Float
_2011_08	Float
_2011_09	Float
_2011_10	Float
_2011_11	Float
_2011_12	Float
_2012_01	Float
_2012_02	Float
_2012_03	Float
_2012_04	Float
_2012_05	Float
_2012_06	Float
_2012_07	Float
_2012_08	Float
_2012_09	Float
_2012_10	Float
_2012_11	Float
_2012_12	Float
_2013_01	Float
_2013_02	Float
_2013_03	Float
_2013_04	Float
_2013_05	Float
_2013_06	Float
_2013_07	Float
_2013_08	Float
_2013_09	Float
_2013_10	Float
_2013_11	Float
_2013_12	Float
_2014_01	Float
_2014_02	Float
_2014_03	Float
_2014_04	Float
_2014_05	Float
_2014_06	Float
_2014_07	Float
_2014_08	Float
_2014_09	Float
_2014_10	Float
_2014_11	Float
_2014_12	Float
_2015_01	Float
_2015_02	Float
_2015_03	Float
_2015_04	Float
_2015_05	Float
_2015_06	Float
_2015_07	Float
_2015_08	Float
_2015_09	Float
_2015_10	Float
_2015_11	Float
_2015_12	Float
_2016_01	Float
_2016_02	Float
_2016_03	Float
_2016_04	Float
_2016_05	Float
_2016_06	Float
_2016_07	Float
_2016_08	Float
_2016_09	Float
_2016_10	Float
_2016_11	Float
_2016_12	Float
_2017_01	Float