Sunday, April 1, 2012

First Ever Multiple Month/Year Voucher Excel Data for 2,300+ Housing Authorities, Including All Oregon PHA's.

I have prepared a single MS Excel workbook that contains multiple months/years of Voucher Management System data for 2,300+ US public housing authorities with vouchers. (It is possible that there may be a similar multi-year voucher public workbook out there someplace, but I am the proverbial "doubting Thomas" about that).

There are 86 data fields in the HUD VMS data, and I added two fields, a state field and a HUD region number field to make analysis by those fields easy to do. (For the 33 months included in the database that's more than 6.6 million pieces of voucher data, but whose counting?)

A HUD MS Word data dictionary HERE provides details about the values found in the VMS data fields. The IMPORTANT READ ME worksheet in the MS Excel Workbook has a complete list of these data fields in the column order in which they appear in the workbook.

The data includes monthly data for all months in CY 2009 and CY 2010. For CY 2011, data is only through September 2011, the last quarterly data currently available from HUD.

The workbook includes 
  1. An Important READ me worksheet.
  2. An Oregon voucher pivot table [The default view shows September 2009, 2010, and 2011 sum of vouchers under lease at the end of the month for each Oregon housing authority].
  3. An Oregon voucher worksheet.
  4. A US voucher pivot table [Default view shows September 2009, 2010, and 2011 sum of vouchers under lease BY STATE at the end of the month].
  5. A US voucher data worksheet. 
  6. A HUD Regional Lookup worksheet, used in a formula to fill in the HUD Region number in a field in the US voucher data worksheet.
This 42 MB MS Excel workbook is HERE and for easy future reference a link has been added in the right pane. Look for: 
 "Voucher VMS Data, US and Oregon: 2009,2010,2011". 

As a sample of the kinds of data found in the database, I have pasted below a pic with a count of vouchers, BY HUD REGIONS, under lease at the end of September 2009,2010, and 2011. 

Excel Downloading Tip-This workbook was created in Excel 2007/2010 format. Some users report they cannot direct view Excel files in this format from within their browser and/or that Excel files they save end up with a compressed .zip file extension.

My suggestion is to RIGHT CLICK and save the file to your PC. Then navigate to the file you downloaded and look at its file extension. IF it appears as .ZIP extension, change the .ZIP extension to an Excel 2007/2010 extension (.xlsx), and THEN open the file with Excel 2007/2010.

Originally created and posted on the Oregon Housing Blog.

No comments:

Post a Comment