Tuesday, January 19, 2021

New Oregon HUD Subsidized Households Data for 52K+ Households , 2020: I Put ALL Oregon Geographies in One Big Excel File.

HUD has just released their December 2020 Picture of Subsidized Households data. 

As I did in 2018 I have compiled an Excel workbook with multiple Oregon geographic levels. For each geographic level I have included both the data and a pivot table that makes it easier to navigate the data.[Pivot tables are shown in red in the Table of Contents tab]. 

CAVEAT: The Excel workbook is a large file, about 212 MB

My 2020 Excel file is HERE.
My previous post with 2018 data is HERE.
The HUD 2020 data dictionary is HERE. HUD's data for multiple years and geographies is HERE

Worksheets within the workbook:
  • Table of contents
  • State field listing (there are 74 data fields).
  • State summary (with map showing state rank by voucher share of all HUD rental assistance; Oregon's state rank is  #1).
  • States.
  • SMSA’s
  • Congressional Districts
  • PHA’s
  • Counties
  • Places
  • Zip Codes
  • Census Tracts
  • Projects
  • City Lookup

The 2020 HUD Picture data counts were 54,820 HUD assisted units in Oregon with 97,094 people. 
The counts for 2018 were 52,887 units and 97,094 people, so there were 1,923 more units reported in 2020, but 428 fewer people. 

The state summary worksheet opens with a ranked listing of states by their share of all HUD assisted units that come from the housing voucher program. The map in that worksheet (also pasted below) shows that Oregon has the HIGHEST state percentage of units that come from the housing voucher program. The table shows that 72.3% of all Oregon HUD assisted units come from the voucher program vs 51.7% nationally. 

The default view of the Pivot table of state data opens to show the percentage of all HUD assisted units headed by women, by women with children, and by minorities.  In Oregon 55% of all HUD assisted units were reported as headed by women, 19% by women with children, and 27% by minorities. 

The default view of the Pivot table of project data shows by city, by program, and by project name the percentage of units occupied by minorities.  
So for example in Lake Oswego there were two HUD assisted projects with one having 9% minority residents and the other with 5% minority residents. 
In the city of Portland minority head of household percentages in HUD assisted projects ranged from 7% to 88%.  

Data fields for individual minority groups are available, however with smaller projects (and geographies) those percentages may be suppressed because of privacy concerns. 

Originally created and posted on the Oregon Housing Blog

No comments:

Post a Comment