I have constructed a new Excel workbook with a pivot table that allows users to analyze more than 250,000 Oregon residential HMDA loan originations from CY 2015 and newly released CY HMDA 2016 data.
The pivot table is set up by default to see (by Oregon metro area) loans originated by race and ethnicity, by source (conventional, FHA etc) and loan purpose (refinance, home improvement, and home purchase). Note that Portland metro data includes ONLY loans from Oregon counties, and not Clark County, Wa.
Changing the "as of year" at the top of the pivot table allows a quick comparisons between years for the same set of data. (Screen shot pasted below shows location of this field at the top of the Pivot table).
The "Property Type Name" data field allows users to focus on manufactured, 1-4 family, or multifamily dwellings.
The workbook also contains a summary of 2016 and 2015 home purchase originations by metro area and a worksheet that shows all of the 78 fields in the HMDA database and web links to the 2015 and 2016 HMDA data I downloaded.
This LARGE (100MB) Excel workbook is available for download HERE.
Originally created and posted on the Oregon Housing Blog