Last Friday HUD released the 2016 version of the HUD Picture of Subsidized Households.
There are multiple geographies that can be chosen to display this data; HUD has a useful tool to allow you to drill down to specific programs and geography HERE.
I went in a different direction and downloaded and combined these geographies and added and created two (large) Excel files in MS One Drive that allow a user to view
- The first Excel file HERE (38MB) contains US, state, congressional district, CBSA, PHA, county, and place level work sheets and pivot tables for each. Pivot tables are set by default to Oregon, when the state field is available. This is easily changed to allow selection of another state or to show data for multiple states.
- The second Excel file HERE (74MB) contains two worksheets for Census Tract level files and a worksheet for project level data. The file is large enough that Pivot tables are somewhat impractical, instead you can filter the data to drill down to the levels and data of interest. The default filter is set to display Oregon data.
Originally created and posted on the Oregon Housing Blog.