$8.6 Billion in U.S. /$51.6 Million in Oregon HUD Recovery Act FY 09 Obligations to Date: New LOCAL Data Now Available (But Not from HUD).

Sadly, HUD still does NOT have a website where it is possible to download LOCAL FY 2009 HUD Recovery Act obligations. (Feel free to correct me if you think I am wrong).

Some HUD data is available via the HUD/RD Recovery Act mapping page, but that site has no useful way to download the underlying map data. HUD's Recovery website has weekly Excel reports , but all data is aggregated at the STATE level.

So to get local data, I went to the usaspending.gov website and downloaded ALL of the HUD Recovery Act obligation transactions for FY 2009 (as of June 30th, 2009) and put those into an Excel workbook,HERE. [27,000+ HUD Recovery Act transactions so far in FY 2009].

(File is in Excel 2007 file format. Some users report when they save Excel 2007 files they end up with a compressed .zip file extension. My suggestion is to download and save the file to your pc. Find the downloaded file, and if necessary, change the .zip extension to Excel 2007 extension (.xlsx), and THEN open the file with Excel)

Results as of June 30th:

• Total U.S, HUD FY 2009 Recovery Act obligations $8,646,269,648
• Total Oregon HUD FY 2009 Recovery Act obligations $51,670,699
• Oregon State Government has received 27% of HUD Recovery obligations in Oregon ($13.9 of $51.6 Million).
• Portland has been the biggest recipient so far, receiving 32% of HUD Recovery obligations in Oregon ($16.3 of $51.6 Million).
  

The workbook I constructed contains 5 worksheets.

READ ME and...

1. Oregon HUD Recovery Act Pivot (currently displaying city, by grantee type)
2. Oregon HUD Recovery Act Data.
3. US HUD Recovery Act Pivot Data (currently displaying state, by HUD program).
4. US HUD Recovery Act Data.

NOTE: ProPublica has done a good job in attempting to capture Recovery spending by state and county, using the same usaspending.gov database. However, ProPublica's report on Oregon recovery spending shows a substantially LOWER HUD spending level at $28.2 million (HERE) than the $51.6 million in HUD Recovery Act obligations that I show for Oregon. It is possible that they may cover a different time period or track spending at a different stage than the obligation stage as entered in the usaspending.gov database.

Originally created and posted on the Oregon Housing Blog.