Derived table · Federal Reserve facilities
PPPLF advances by lender, 70 disclosures combined
Harvest Small Business Finance had $11.52 billion of Federal Reserve money outstanding on June 30, 2021, the largest PPPLF balance any lender reached. The Loan Source borrowed the most over the facility's life, $36.18 billion across 1,063 advances, and its balance never passed $9.16 billion. One row per borrowing institution, combined from 70 Fed disclosures: 787 lenders, 26,557 advances, $198.61 billion advanced, and a facility-wide peak of $90.63 billion on June 30, 2021.
Download CSV 63 KBData dictionary CSVAt a glancePreviewColumnsHow to useBefore you quote a row
At a glance
Measured on the file on 2026-10-15; the checksum above is the file these numbers describe.
institution_rssd · uniqueThe 70 disclosure workbooks behind this table, each on its own page
What it is
One row per institution that borrowed from the Paycheck Protection Program Liquidity Facility: advances taken, their original amounts added up, and the largest balance outstanding on any report date, with that date. Two more columns give the dates of the lender's first and last advance. The Federal Reserve lent to PPP lenders against the PPP loans they pledged as collateral, so a lender's row measures how much Reserve Bank money stood behind its PPP book.
Gross advances count every advance once at its original amount, so they run above any balance outstanding at one time. The Loan Source's $36.18 billion gross against a $9.16 billion peak is the widest gap in the table: 1,063 advances between June 22, 2020 and July 28, 2021.
The sum of each lender's peak, $138.55 billion, adds peaks from different dates and is not a facility-wide balance. The facility-wide peak, $90.63 billion, is the total outstanding across all lenders on the June 30, 2021 report date, published in the Fed's July 13, 2021 release. Fountainhead SBF LLC shows 362 advances, $5.49 billion gross and a $4.69 billion peak on May 31, 2021, a month-end between quarter-ends.
How it was built
Each of the 70 disclosure workbooks lists the advances outstanding on its report date, and an advance stays in the list until it is repaid. An advance is identified by institution RSSD, advance date, maturity date and original amount, and counted once however many workbooks repeat it. A lender's peak is the largest sum of its current outstanding amounts on any one report date; the facility-wide peak is that sum across all lenders. Column headings that changed between releases were matched by name.
One row in the October 13, 2021 workbook, a $3,924,767.39 advance of April 20, 2020 to First Bank of the Lake, carries text where its current amount should be. It was left out of that date's balance; the advance itself is counted from the other workbooks, and the bank's row shows 165 advances. The 70 report-date totals are in ppplf-facility-by-report-date.csv (report date, total outstanding, lenders with a balance).
Preview
| institution_rssd | institution_name | n_advances | total_gross_advances_usd | peak_outstanding_usd | peak_outstanding_date | first_advance_date | last_advance_date |
|---|---|---|---|---|---|---|---|
| 5511408 | PPPLF THE LOAN SOURCE | 1063 | 36179541720.92 | 9161408154.17 | 2021-06-30 | 2020-06-22 | 2021-07-28 |
| 3783313 | CROSS RIVER BK | 309 | 18805308340.69 | 10011245136.22 | 2021-04-30 | 2020-04-17 | 2021-07-30 |
| 5500251 | PPPLF HARVEST SMALL BUS FNC | 120 | 12727880180.55 | 11518536906.04 | 2021-06-30 | 2020-05-08 | 2021-07-20 |
| 2354985 | CUSTOMERS BK | 204 | 7368139542.66 | 4811009450.02 | 2020-09-30 | 2020-04-30 | 2021-06-01 |
| 5503636 | PPPLF PRESTAMOS CDFI | 127 | 7170529098.55 | 7162941713.30 | 2021-07-31 | 2020-05-15 | 2021-07-30 |
| 5511314 | PPPLF CAPITAL PLUS | 205 | 6459179299.43 | 6397994161.64 | 2021-07-31 | 2021-01-29 | 2021-07-30 |
| 5499672 | PPPLF FOUNTAINHEAD SBF LLC | 362 | 5486440402.63 | 4685738180.74 | 2021-05-31 | 2020-05-07 | 2021-07-23 |
| 5502433 | PPPLF ITRIA VENTS LLC | 208 | 4905099619.79 | 4770125283.35 | 2021-05-31 | 2020-05-20 | 2021-07-30 |
| 5501164 | PPPLF BENWORTH CAP PTNRS LLC | 150 | 4304482271.81 | 4197908018.65 | 2021-07-31 | 2020-05-11 | 2021-07-27 |
| 2998576 | CELTIC BK CORP | 147 | 3652475078.10 | 3284050754.79 | 2021-03-31 | 2020-04-27 | 2021-06-15 |
First 10 of 787 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.
Files
| File | Rows | Size | SHA-256 | |
|---|---|---|---|---|
ppplf-cumulative-by-lender.csvCSV, UTF-8, header row | 787 | 64,950 B | 28f428603f3ec51be16f17f48d7913875f56211607b535229bd3c1dce1a45029 | Download ↓ |
dictionary.csvdata dictionary, 8 rows | 8 | — | built with this page | Download ↓ |
Columns
| Column | Type, measured | Blank | Distinct | Range / values | Meaning |
|---|---|---|---|---|---|
institution_rssd | integer | 0 | 787 | 2.2K – 5.6M · median 892.2K | Federal Reserve RSSD identifier of the borrowing institution. |
institution_name | text | 0 | 755 | AMERICAN BK NA (4), PEOPLES BK (4), FIRST NB (4) | Institution name as a disclosure gives it; spellings vary between releases. |
n_advances | integer | 0 | 152 | 1 – 1.1K · median 13 | Distinct advances across all 70 disclosures. |
total_gross_advances_usd | number | 0 | 786 | 10.2K – 36.2B · median 27.8M | Original amounts of those advances added up, in dollars. |
peak_outstanding_usd | number | 0 | 779 | 0.00 – 11.5B · median 22.8M | Largest total current outstanding balance on any one report date, in dollars. |
peak_outstanding_date | text | 0 | 17 | 2020-09-30 (361), 2020-06-30 (181), 2020-12-31 (41) | Report date of that peak. |
first_advance_date | text | 0 | 122 | 2020-04-20 (60), 2020-04-21 (58), 2020-04-17 (50) | Earliest advance date in the lender's rows. |
last_advance_date | text | 0 | 222 | 2021-07-30 (20), 2020-05-05 (18), 2020-04-22 (17) | Latest advance date in the lender's rows. |
Type, blanks, distinct count, and range are measured on the file. The same table as CSV: dictionary.csv.
How to use it
Specific to this file, measured on it: keys, joins, encodings, units, and the values that will trip a naive count.
- Join on
institution_rssd, not the name. Names are abbreviated as the Fed prints them (CROSS RIVER BK) and some rows carry aPPPLForPPPFLprefix (PPPLF THE LOAN SOURCE,PPPFL BSD CAPITAL). - Do not add the peak column across lenders as a facility balance; the peaks fall on different dates. The facility-wide series by report date is in
ppplf-facility-by-report-date.csv. - Sorted by gross advances, largest first. Rank by
peak_outstanding_usdfor the exposure view: Harvest first, then Cross River, then The Loan Source. - LF line endings, UTF-8, 64,950 bytes.
Before you quote a row
- Advances, not PPP loans. A lender borrowed against PPP loans it held as collateral, so its advances can exceed the PPP loans it originated.
- Identity of an advance is inferred. Two advances to one institution on the same day with the same maturity and amount would be counted once.
- Dates are the Fed's. One row, Trenton Business Assistance Corp., shows a first advance dated March 23, 2020, before the facility's April 9, 2020 announcement. Rows are printed as the disclosures give them.
- Later disclosures exist. The table stops at the February 28, 2026 report date. The Fed's July 13, 2026 and August 11, 2026 releases and the disclosure as of August 31, 2026 are on this site and not in this table.
- Names vary. The name column takes one spelling from among the workbooks that list the lender; the RSSD is the constant.
PPPLF advances by lender, combined across 70 Federal Reserve transaction-specific disclosures (releases of July 10, 2020 to March 11, 2026). Pandemic Darlings, https://pandemicdarlings.com/data/ppplf-cumulative-by-lender/, SHA-256 28f428603f3ec51be16f17f48d7913875f56211607b535229bd3c1dce1a45029