1.2 Million Loans: Excel File With USDA SF Guaranteed and Direct Loan Data by State and County

I have constructed a new Excel workbook HERE ,and embedded below, that includes a county level breakout of nearly 1.2 million USDA Rural Development SF guaranteed and direct loans. I downloaded USDA data and then added pivot tables and state and county NAMES instead of codes to make the data easier to use. 

The workbook contains these worksheets:

• A consolidated summary by state of loan counts and percentages of loans to whites. 
• A US pivot table and data worksheet of all direct loans.
• A US pivot table and data worksheet of all guaranteed loans.
• An Oregon pivot table and data worksheet of all 2,400 direct loans.
• An Oregon pivot table and data worksheet of all 16,000 guaranteed loans
• A worksheet of state and county FIPS codes and names. 
• A worksheet showing the data fields for guaranteed and direct loans. 

Originally created and posted on the Oregon Housing Blog.