PPP Oregon Excel Database Update. 103,000 Loans/$9.7 Billion.

My most recent March blog post with Oregon PPP data is HERE. 

In that post the Excel database I constructed had information on $9.15 billion/91,080 PPP loans in Oregon through the end of February 2021. That was up from $7 billion/66,000 PPP loans in December 2020. 

I have just uploaded a large (42MB) NEW Excel database HERE that includes PPP loans through the end of March of 2021. It includes data for $9.7 billion+/ 103,000+ PPP loans. 

The default view is a pivot table that by month, by county, and by loan size, of all Oregon PPP loans. Filters at the top allow focus by city, organization type, minority, gender, etc.  [ A screen capture below shows the default view]. 

There is also a county summary worksheet, a worksheet with the raw data, and a worksheet that shows NAICS codes and names. 

The default pivot table loan amount is from the "currently approval amount" data field. I added a data field that helps filter for loans below $150, 000 and  year and month data fields that help filter by date of loan approval.

Some additional observations: 

• Three Portland metro counties account for 54%/$5.27 billion of the total loan volume.
• There are small number (10) of Oregon businesses with PPP loans where the "project" in the database is located in another state.
• Loans for less than $150,000 accounted for 31%/$3.06 billion of the total loan volume but a much higher 87%/90,212 of the total count of 103,399 loans.
• The database "jobs reported" field isn't credible and there is no verification process to my knowledge. 
• Unfortunately the database does not yet have a field showing the extent to which a loan has been forgiven.

Pivot Table Default View

Originally created and posted on the Oregon Housing Blog.