New GSE Excel Post: Details for 117,000 Loans to African American Borrowers.

I have put together a new GSE Excel workbook with loan level details for $22.529 Billion in CY 2010 GSE acquired loans for 117,524 African American Borrowers and Co Borrowers. 

How to Download These GSE Excel Workbooks

1. All of these GSE related Excel workbooks are included in a folder I have created on a cloud data sharing service, SpiderOak.  A link to that folder is HERE and it has also been added to the right pane as GSE CY 2010 Excel Files. [Ask me sometime about what a pain it was to find a web site that can host large file sizes].
2. The link above will open a web page.
3. From that web page you will see a “download” radio file on the right side that is supposed to allow you to download all Excel files in this folder as a single compressed file-I DO NOT recommend this method as I encounter errors in the size of the downloaded compressed file and in trying to open the file.
4. INSTEAD you should A. Left mouse click on the underlined folder name on the LEFT side of the page [GSE 2010 Public Shared Excel]  to open the folder AND THEN B. Click the “download” radio button on the right side for that file to download each file individually in an uncompressed format.
5. After downloading the file(s), navigate to the directory where you downloaded the file and double click to open.

GSE Loans Excel Workbook 4: GSE Loans to African Americans [47 MB]

The data in this Excel workbook consists of data for 117,524/$22.529 billion in single family loans purchased by the GSE’s during CY 2010 where the borrower OR Co borrower was an African American.  

The GSE CY 2010 data dictionary with all 39 field names and values can be found HERE (and has also been included in the SpiderOak Excel folder).

In addition, to make the workbook easier to use,  I created lookup formulas to add fields with NAMES for 8 of the 39 data elements; those additional columns begin at column “AN” of the Oregon CY 2010 GSE Data worksheet. These include columns with the county and MSA names, names for race and ethnicity, a name for the purpose of the loan, and a column that places the ratio of borrower income to median area income in one of 5 categories /“bins”. 
 

This workbook also includes a pivot table, allowing users to focus on geographies or demographics of interest; the default view is for a count of all loans by state showing by GSE the number of loans to African Americans. Users can change the fields displayed in the pivot table to retrieve any combination of data using the data fields available. 

The workbook also includes a state summary of the share of all loans that went to African Americans, in ranked order by the percentage of all loans to African Americans. (This state level African American loan summary also appears as Table 10 in the PDF file with my series of GSE CY 2010 tables, Picture of GSE Assisted Households, CY 2010) 

Finally, this workbook contains a second detailed state worksheet summary of African American loans counts by GSE and by borrower/co borrower.

Originally created and posted on the Oregon Housing Blog.

New Table Added to Picture of GSE Assisted Households CY 2010: $22.5 Billion in Loans to 117,000+ African Americans.

I have added a new table to the GSE PDF table series, with a link in the right pane, Picture of GSE Assisted Households, CY 2010.

Table 10 shows a count of loans and $$ by state, ranked by the share of all single family GSE loans made to African American borrowers or co borrowers
 

Some observations:

1. Oregon ranked 42nd in the share of all GSE loans in the state that went to African Americans.
2. Among top 20 states in share of loans to African Americans only two (Nevada and Texas ) were west of the Mississippi river.
3. In Michigan and California, states with substantial African American populations (6.67% and 14.27%), only 1.6% of GSE loans went to African Americans. [Wikipedia state African American population table is HERE].
4. GSE CY 2010 loans to investors [prior post] at $40.2 billion/243,000 loans were substantially higher than $22.5 billion/117,000 loans to African Americans.

Note: 

In this table and in my coming Excel workbook "African American borrowers" includes all loans where an African American was borrower AND all loans where African American was a co borrower (even if borrower was not African American). 

Excel Workbook Coming  
A scheduled posting later will include a link to my Excel cloud space folder where the complete Excel workbook with loan level records for African American borrowers and co borrowers will be uploaded so users may do further analysis.

Originally created and posted on the Oregon Housing Blog.

Metro Portland Scores Well on Urban Institute Black and Hispanic Equity Ratings/ Rankings; Higher than Metro Seattle.

The Urban Insitute has put up new map/scorecard HERE of 100 largest metro areas that provides data and rankings on black/white and hispanic/white equity.  

Portland ranks and ratings:

• Black/White Equity: Ranking, 19th; Score A
• Hispanic/White Equity: Ranking, 32nd; Score B

Seattle Ranks and Ratings

• Black/White Equity: Ranking, 39th; Score B
• Hispanic/White Equity: Ranking, 33rd; Score B

I have prepared a breakout of ALL Portland AND  Seattle Metro values, ratings and rankings in a PDF file HERE.

Rating Data include:

Residential Segregation: Dissimilarity index

Neighborhood Income Gap: Percent difference between the median income of the average non-Hispanic white’s neighborhood and that of the average black or Latino. 

School Test Score Gap: Percent difference between the state test score ranking of the school attended by the average non-Hispanic white student and that of the school attended by the average black or Latino student. 

Employment Gap: Percent difference between the share of working-age non-Hispanic whites who are employed and the corresponding share of blacks or Latinos, 

Homeownership Gap: Percent difference between the share of non-Hispanic white households that are homeowners and the corresponding share of black or Latino households

Grading Scale: Each statistic is scaled by its average and given an equal weight, and then all statistics are summed into a final measure. Each metro is assigned a rank based on this measure and then fit into the following grading scale: A=Best 20, B=21-40, C=41-60, D=61-80, F=Worst 20.

Originally created and posted on the Oregon Housing Blog.

Portland Tribune Has City of Portland African American Drop in Home Ownership Rate Story.

Story from Steve Law is HERE in printer ready format.

Story references Census data I recently posted [post is HERE] and a quote from interview with me. Quotes from Economic Fairness Oregon, Realty Trust broker, Portland Housing Center, and African American home owners helped by PHC are also included in the story.

NOTE: African American Alliance for Home Ownership will have their annual home ownership fair in Portland on October 29th at Emanuel Hospital. Details HERE. 

Fair includes exhibits/presence of multiple lenders, agencies, and non profits. Noticed that this years Fair will include education session on first time home buyers facilitated by Jon Gail, formerly at Portland Housing Bureau, and now operator of new web based education/referral site for first time home buyers, First Home Advisor. 

Originally created and posted on the Oregon Housing Blog.