Pandemic Darlings The pandemic economy, in original documents
Home Data downloads Cross-program recipient matches

Derived table · PPP, COVID EIDL, RRF, and SVOG

Cross-program recipient matches

91,448 businesses that received money from two or more of PPP, the Restaurant Revitalization Fund, the Shuttered Venue Operators Grant, and COVID EIDL, matched by normalized name and state, with per-program amounts, the combination of programs, and a match-strength grade on every row.

Rows91,448
Columns29
Files1 · 17.4 MB
FormatCSV
Source vintageProject overlap build through 2026-07-10
Published byPandemic Darlings
Acquired / built2026-07-10
Releasepandemic-darlings-data-v1-2026-07-10
Built fromSBA PPP FOIA loan-level files · USASpending COVID EIDL prime-award files · SBA Restaurant Revitalization Fund award file · SBA Shuttered Venue Operators Grant award file
SHA-2564f0d56a41ba07d7ccfe58fef887ef7f9f491cf76968162ffad1bff6734595c81
RightsDerived from U.S. government public data; attribution to Pandemic Darlings requested for entity-resolution work.
Schema · dictionaryprogram-overlap-master.json · dictionary.csv

Download CSV 17.4 MBData dictionary CSVAt a glancePreviewColumnsHow to useBefore you quote a row

At a glance

Measured on the served file on 2026-09-12; the checksum above is the file these numbers describe.

Rows91,448
Columns29
Keybkey · unique
Cells left blank243,392 of 2,651,992 · 9.2%
Combined dollars, all rows$60.9 billion
HIGH-confidence rows77,155 · 84.4%
In three programs39,956
States and territories56
Matched businesses by program combination — counts rows of program-overlap-master.csv by overlap_combo.
Matched businesses by program combinationHorizontal bars, one per combination of programs, length proportional to the number of matched businesses.PPP+RRF43KPPP+RRF+EIDL37KPPP+SVOG4KRRF+EIDL3KPPP+SVOG+EIDL3KSVOG+EIDL1KPPP+SVOG+RRF1
The numbers behind this chart
CombinationBusinesses
PPP+RRF43K
PPP+RRF+EIDL37K
PPP+SVOG4K
RRF+EIDL3K
PPP+SVOG+EIDL3K
SVOG+EIDL1K
PPP+SVOG+RRF1
Ten states with the most matched businesses — counts rows of program-overlap-master.csv by state, ten largest of 56.
Ten states with the most matched businessesHorizontal bars, one per state, length proportional to the number of matched businesses in it.CA15KNY9KTX6KFL5KIL4KPA3KWA3KMI3KNJ3KOH3K
The numbers behind this chart
StateBusinesses
CA15K
NY9K
TX6K
FL5K
IL4K
PA3K
WA3K
MI3K
NJ3K
OH3K

What it is

One row per matched business. The search starts from the two grant programs: every Restaurant Revitalization Fund and Shuttered Venue Operators Grant recipient was looked up in the PPP loan file and the COVID EIDL award file, and RRF was compared with SVOG. A business is included when it appears in at least two of the four programs. Because the search begins with grant recipients, a business with only PPP and EIDL is not in this table by design.

The combinations: 42,749 businesses with PPP and RRF, 36,927 with PPP, RRF, and EIDL, 4,470 with PPP and SVOG, 3,209 with RRF and EIDL, 3,028 with PPP, SVOG, and EIDL, 1,064 with SVOG and EIDL, and one business in both grant programs. For each business the table carries its PPP loans and forgiveness, its grant amounts and venue or restaurant type, its EIDL loans, and the combined total.

How it was built

Names are normalized by upper-casing, replacing punctuation, and dropping legal-form and noise tokens (LLC, INC, CORP, CO, LP, DBA, THE, AND, and the - SVOG tag the SBA appends to every grantee), then paired with the two-letter state. Substantive words are never dropped, so Blue Moon Restaurant and Blue Moon Theatre stay separate. A key shorter than two words or eight characters is graded weak.

A cross-program link is HIGH when the name-and-state key matches and at least one five-digit ZIP agrees, and PROBABLE on name and state alone. The row's overall_confidence is HIGH only when every link is HIGH, PROBABLE otherwise, and WEAK whenever the name itself is weak. 77,155 rows are HIGH, 9,013 PROBABLE, 5,280 WEAK. anomaly_rrf_svog flags a business found in both RRF and SVOG, which program rules did not allow.

Preview

bkeynorm_namestatedisplay_namename_strengthgot_pppgot_svoggot_rrfgot_eidln_programsoverlap_comboppp_loansppp_totalppp_forgivenesssvog_grantsvog_typerrf_grantrrf_typeeidl_loanseidl_totalcombined_totalconf_pppconf_eidlconf_svog_rrf
SAN FRANCISCO OPERA ASSOCIATION|CASAN FRANCISCO OPERA ASSOCIATIONCASan Francisco Opera Associationstrong11002PPP+SVOG210911232.011027546.378000000.0Live performing arts organization operator0.000.018911232.0HIGH
WINDSOR CAPITAL GROUP|CAWINDSOR CAPITAL GROUPCAWindsor Capital Group Incstrong10113PPP+RRF+EIDL28593900.06700486.330.010000000.0Inn **1150000.018743900.0HIGHHIGH
NEW YORK BOTANICAL GARDEN|NYNEW YORK BOTANICAL GARDENNYThe New York Botanical Gardenstrong11002PPP+SVOG18535542.08650093.7210000000.0Museum Operator0.000.018535542.0HIGH
CLAIR GLOBAL|PACLAIR GLOBALPAClair Global Corporationstrong11002PPP+SVOG18455353.548553999.3310000000.0Live performing arts organization operator0.000.018455353.54HIGH
FISH MARKET RESTAURANTS|CAFISH MARKET RESTAURANTSCAFish Market Restaurants Inc.strong10102PPP+RRF28181800.08200294.590.010000000.0Restaurant00.018181800.0HIGH
CALIFORNIA ACADEMY OF SCIENCES|CACALIFORNIA ACADEMY OF SCIENCESCACalifornia Academy of Sciencesstrong11002PPP+SVOG18106745.08212673.1310000000.0Museum Operator0.000.018106745.0HIGH
THUNDERDOME RESTAURANTS|OHTHUNDERDOME RESTAURANTSOHThunderdome Restaurants LLCstrong10102PPP+RRF27923000.07998898.670.010000000.0Restaurant00.017923000.0HIGH
NOT YOUR AVERAGE JOES|MANOT YOUR AVERAGE JOESMANot Your Average Joe's Inc.strong10102PPP+RRF27909100.07987959.380.010000000.0Restaurant00.017909100.0HIGH
SAN FRANCISCO SYMPHONY|CASAN FRANCISCO SYMPHONYCASan Francisco Symphonystrong11002PPP+SVOG29776500.09900816.088000000.0Live performing arts organization operator0.000.017776500.0HIGH
MCMENAMINS|ORMCMENAMINSORMcMenamins, Incmedium11002PPP+SVOG212000000.012124876.725676347.58Live venue operator or promoter0.000.017676347.58HIGH

First 10 of 91,448 rows · first 24 of 29 columns (the download has all of them) · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.

Files

FileRowsSizeSHA-256
program-overlap-master.csv
CSV, UTF-8, header row		91,44818,219,048 B4f0d56a41ba07d7ccfe58fef887ef7f9f491cf76968162ffad1bff6734595c81Download ↓
dictionary.csv
data dictionary, 29 rows		29—built with this pageDownload ↓

Columns

ColumnType, measuredBlankDistinctRange / valuesMeaning
bkeytext091,448Match key: normalized name, a pipe, and the state.
norm_nametext090,110The normalized name.
statetext056Two-letter state.
display_nametext091,209A readable name taken from the source records.
name_strengthtext03strong (76,329), medium (9,839), weak (5,280)strong, medium, or weak; how specific the normalized name is.
got_pppinteger020 – 1 · median 11 if a PPP loan matched.
got_svoginteger020 – 1 · median 01 if an SVOG award matched.
got_rrfinteger020 – 1 · median 11 if an RRF award matched.
got_eidlinteger020 – 1 · median 01 if a COVID EIDL loan matched.
n_programsinteger022 – 3 · median 2Number of programs matched, 2 or 3.
overlap_combotext07PPP+RRF (42,749), PPP+RRF+EIDL (36,927), PPP+SVOG (4,470), RRF+EIDL (3,209), PPP+SVOG+EIDL (3,028), SVOG+EIDL (1,064)The programs joined with plus signs, for example PPP+RRF+EIDL.
ppp_loansinteger0410 – 54 · median 2Number of PPP loans matched.
ppp_totalnumber067,2560 – 12M · sum $16.5B · median $70KSum of PPP current approved amounts, dollars.
ppp_forgivenessnumber085,5030 – 12.1M · sum $16.1B · median $67KSum of PPP forgiveness amounts, dollars.
svog_grantnumber08,4290 – 16.2M · sum $9.4B · median $0SVOG award total, dollars.
svog_typetext82,8856Live venue operator or promoter (3,039), Live performing arts organization operator (2,360), Motion picture theater operator (1,045), Talent representative (954), Museum Operator (591), Theatrical producer (574)Venue type from the SVOG file.
rrf_grantnumber079,9980 – 10M · sum $24.8B · median $116KRRF award total, dollars.
rrf_typetext8,563387Restaurant type from the RRF file.
eidl_loansinteger0150 – 19 · median 0Number of COVID EIDL loans matched.
eidl_totalnumber05,1000 – 2.1M · sum $10.2B · median $0Sum of EIDL loan amounts, dollars.
combined_totalnumber089,5922K – 18.9M · sum $60.9B · median $335KAll of the above, dollars.
conf_ppptext4,2732HIGH (79,913), PROBABLE (7,262)HIGH or PROBABLE for the PPP link; blank if none.
conf_eidltext47,2202HIGH (41,710), PROBABLE (2,518)HIGH or PROBABLE for the EIDL link.
conf_svog_rrftext91,4471PROBABLE (1)HIGH or PROBABLE for the RRF-to-SVOG link, on the rare rows that have both.
overall_confidencetext03HIGH (77,155), PROBABLE (9,013), WEAK (5,280)HIGH, PROBABLE, or WEAK; see the method.
anomaly_rrf_svoginteger020 – 1 · median 01 when the business appears in both grant programs.
zipstext027,414Five-digit ZIPs seen across the matched records, semicolon-separated.
naicsinteger4,731483111K – 1000K · median 723KNAICS codes seen on the PPP loans.
citytext4,27311,765City from the PPP or grant record.

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.

  • bkey is the key (0 duplicates): the normalized name, a pipe, and the state. norm_name alone is not unique (1,338 names recur across states).
  • Filter on overall_confidence first. HIGH 77,155, PROBABLE 9,013, WEAK 5,280. A PROBABLE or WEAK row is a name match awaiting an address check.
  • Amounts are dollars as floats with a trailing .0 (ppp_total example 10911232.0); a zero means no match in that program, not a zero award. svog_type is blank on 82,885 rows and rrf_type on 8,563, the rows with no award in that program.
  • rrf_type carries the SBA's own markers: && joins multiple types and a trailing ** appears on 3,966 rows (Bakery **, Inn **), as the source file spells them. Strip before grouping.
  • zips is semicolon-separated on 15,543 rows; naics is blank on 4,731 rows (no PPP match) and otherwise a six-digit code stored as a number. state includes DC and the territories (AS, GU, MP, PR, VI).
  • 17.4 MB, CRLF line endings, UTF-8, ASCII only, no byte-order mark, no cell contains a line break.

Before you quote a row

  • Match tiers are not interchangeable. Filter on overall_confidence; a PROBABLE or WEAK row is a name coincidence until the ZIPs or addresses say otherwise, and must not be presented as an adjudicated identity match.
  • Same name, same state, different business is the main failure mode: chains, franchises, and generic names (Main Street Cafe) can merge.
  • The universe is grant-anchored. Counts here say nothing about how many PPP borrowers also took EIDL; that needs a different table.
  • Amounts are as of the source vintages: PPP 2024-09-30, EIDL exports of 2026-06-22, RRF copy of 2026-06-12, SVOG snapshot of 2022-07-05.
  • Match-strength tiers are not interchangeable; uncertain matches must not be presented as adjudicated identity matches.
Cite this table. Name the source vintage; the numbers depend on it.Cross-program recipient matches (PPP · RRF · SVOG · EIDL), built from SBA and USASpending award files (overlap build through 2026-07-10). Pandemic Darlings, release pandemic-darlings-data-v1-2026-07-10, https://pandemicdarlings.com/data/program-overlap-master/, SHA-256 4f0d56a41ba07d7ccfe58fef887ef7f9f491cf76968162ffad1bff6734595c81

Related records

In the data section

Statutes in the archive

Official source

Guides that cite this table

Key findings that cite this table

Elsewhere

Back to top