Thursday, December 8, 2016

New ACS 2011-2015 Renter Cost Burden Data by Income Out: My Excel Lookup Includes 1,000+ Geos From US to OR Census Tract Levels.

Readers may recall that last December I did a post with an Excel workbook (HERE) that showed ACS 2010-2014 rent cost burdens by income levels; it included a lookup worksheet that allowed users to select from more than 1,000 geographies from the national level all the way down to the Oregon census tract level. 

On Thursday Census released 2011-2015 ACS data so I have constructed a similar workbook HERE that also includes a lookup worksheet that displays counts and percentages of rent burdens by income levels and a graph that displays the results for the chosen geography. The workbook includes worksheets with the raw data and a link to the query that you can paste into a web browser to replicate the data I used. 

The main point that the data illustrates is that rent burdens decline significantly by income levels and severe cost burdens are virtually non existent for renter HH's above $50k in Oregon, and the US. (There may be some cities and metro areas outside Oregon where that isn't true, but they are the exception and not the rule). 

The table/graph pasted below for Oregon illustrates this point (you may need to scroll to right to see full table/graph):

Putting this together required a fair amount of data manipulation:). IF you discover any problems drop me an email and I will take a look. (

Originally created and posted on the Oregon Housing Blog

No comments:

Post a Comment