ppp · loans

This is a searchable dataset of Paycheck Protection Program loans

As of March 3rd, 2021, the program has been allocated nearly $1 trillion dollars, and guaranteed over $675 billion dollars in forgivable loans to small businesses. This interface makes it easy for anyone to see where the money went.

The Small Business Administration, which administers this program, spent months fighting the release of detailed information until litigation by the media compelled the release of the full dataset.

Help support this project and more like it with a simple, one-time contribution. This project is created, hosted, and managed by one data scientist. All contributions go directly to server/hosting costs and future projects!

California (13.1%) $88.6B explore
Texas (7.8%) $52.9B explore
New York (7.5%) $50.9B explore
Florida (6%) $40.9B explore
Illinois (4.5%) $30.8B explore
Pennsylvania (4%) $26.8B explore
Ohio (3.4%) $23.2B explore
New Jersey (3.3%) $22.2B explore
Other states (50.4%) $341.9B explore

Total loans $678.7B

Total in small loans < $150k (31%) $207.3B

Total in large loans > $150k (69%) $471.3B
Total unused $76.1B

Unused in small loans < $150k (40%) $30.6B

Unused in large loans > $150k (60%) $45.5B
Number of loans 7,341,398

Small loans < $150k (88%) 6,461,437

Large loans > $150k (12%) 879,961
Number of jobs 78,541,427

For small loans < $150k (41%) 32,543,918

For large loans > $150k (59%) 45,997,509

Loans by state

Loans by district

Loans by county

Loans by city

Loans by industry
Loan date/location next update
Adds more detailed information to loan results.
Loans by ZIP code next update
Search cities, industries, and loans by ZIP code.
US territories/dependencies next update
Include loans to Puerto Rico, Guam, and 4 others.
FUTURE ROADMAP
EIDL loans
Include the public dataset of Economic Injury Disaster Loans, and correlate to PPP loan recipients.
Loans by lender
Aggregate loans by lender ID, to show which regions and industries that each lender and sub-lender was most active in.
Loans by date
Aggregate loans and industries by loan type (first or second) over time, to see when certain industries and regions were most impacted.
Race/gender statistics
Some loan applications answered gender/race questions, but a majority did not. When displaying aggregated statistics about race, the visualization should correctly show the proportion of unanswered responses.