Monday, December 7, 2015

New ACS 2010-2014 Easy to Use Excel Lookup Tool: Find Renter Cost Burdens by Income Levels for US, States, and Oregon Geographies to CT Level.

In my prior post I alerted readers to the publication of new 5 year ACS  renter cost burden data available down to the block group level. 

I have now created an Excel tool that allows users to select from among 1,700+ geographies to produce a table and graph showing the share of cost burden renters by income group. The workbook also includes a worksheet with all the data used for the lookup tool,  including margin of error data.

Geographies include the US, States, and Oregon Congressional Districts, Oregon Metro and Micropolitan areas, Oregon Counties, Oregon Places, and Oregon Census Tracts.  [Block group data is not included as it would require downloading for each county individually]. 

That tool is HERE and embedded below; if you run into any data discrepancies drop me a heads up note to [In the embedded version you will likely have to scroll to the right to see all columns and the end of the graph. ].

You will note that for virtually ALL areas there is a steep drop off in renter cost burdens as income rise. By default the workbook opens to a view of Oregon renter cost burdens by income; that geography can be changed with a pull down list near the top of the table. [You may have to download to use the pull down list of available geographies].

For Oregon, 66.5% of renters with incomes between $10,000 and $19,999 have a severe cost burden [50% or more for rent] , but for renters with incomes between $35,000 and $49,999 the severe cost burden percentage drops to 4.8%

Put another way the severe cost burden rate for Oregon renters between $10,000 and $19,999 is nearly 14 times the rate for renters with incomes between $35,000 and $49,999. 

Originally created and posted on the Oregon Housing Blog

No comments:

Post a Comment