Baselight

Paycheck Protection Program(PPP) - FOIA

Program initiated to provide economic relief to small businesses during COVID-19

@kaggle.johnp47_paycheck_protection_programppp_foia

Loading...
Loading...

About this Dataset

Paycheck Protection Program(PPP) - FOIA

The Paycheck Protection Program (PPP) is a $953-billion business loan program established by the United States federal government, led by the Donald Trump administration in 2020 through the Coronavirus Aid, Relief, and Economic Security Act (CARES Act) to help certain businesses, self-employed workers, sole proprietors, certain non-profit organizations, and tribal businesses continue paying their workers.

The Paycheck Protection Program allows entities to apply for low-interest private loans to pay for their payroll and certain other costs. The amount of a PPP loan is approximately equal to 2.5 times the applicant's average monthly payroll costs. In some cases, an applicant may receive a second draw typically equal to the first. The loan proceeds may be used to cover payroll costs, rent, interest, and utilities. The loan may be partially or fully forgiven if the business keeps its employee counts and employee wages stable. The program is implemented by the U.S. Small Business Administration. The deadline to apply for a PPP loan was March 31, 2021.

Some economists have found that the PPP did not save as many jobs as purported and aided too many businesses that were not at risk of going under. They noted that other programs, such as unemployment insurance, food assistance, and aid to state and local governments, would have been more efficient at strengthening the economy. Opponents to this view note that the PPP functioned well to prevent business closures and cannot be measured on the number of jobs saved alone.

According to a 2022 study, the PPP: cumulatively preserved between 2 and 3 million job-years of employment over 14 months at a cost of $169K to $258K per job-year retained. These numbers imply that only 23 to 34 percent of PPP dollars went directly to workers who would otherwise have lost jobs; the balance flowed to business owners and shareholders, including creditors and suppliers of PPP-receiving firms. Program incidence was ultimately highly regressive, with about three-quarters of PPP funds accruing to the top quintile of households. PPP's breakneck scale-up, its high cost per job saved, and its regressive incidence have a common origin: PPP was essentially untargeted because the United States lacked the administrative infrastructure to do otherwise. Harnessing modern administrative systems, other high-income countries were able to better target pandemic business aid to firms in financial distress. Building similar capacity in the U.S. would enable improved targeting when the next pandemic or other large-scale economic emergency inevitably arises.

Additional Information
Field: Value
Created: April 5, 2022
Format: CSV
License: Other (Public Domain)
Size: 428.6 MiB

Tables

Public 150k Plus 220403

@kaggle.johnp47_paycheck_protection_programppp_foia.public_150k_plus_220403
  • 98.3 MB
  • 968532 rows
  • 53 columns
Loading...

CREATE TABLE public_150k_plus_220403 (
  "loannumber" BIGINT,
  "dateapproved" TIMESTAMP,
  "sbaofficecode" BIGINT,
  "processingmethod" VARCHAR,
  "borrowername" VARCHAR,
  "borroweraddress" VARCHAR,
  "borrowercity" VARCHAR,
  "borrowerstate" VARCHAR,
  "borrowerzip" VARCHAR,
  "loanstatusdate" TIMESTAMP,
  "loanstatus" VARCHAR,
  "term" BIGINT,
  "sbaguarantypercentage" BIGINT,
  "initialapprovalamount" DOUBLE,
  "currentapprovalamount" DOUBLE,
  "undisbursedamount" DOUBLE,
  "franchisename" VARCHAR,
  "servicinglenderlocationid" BIGINT,
  "servicinglendername" VARCHAR,
  "servicinglenderaddress" VARCHAR,
  "servicinglendercity" VARCHAR,
  "servicinglenderstate" VARCHAR,
  "servicinglenderzip" VARCHAR,
  "ruralurbanindicator" VARCHAR,
  "hubzoneindicator" VARCHAR,
  "lmiindicator" VARCHAR,
  "businessagedescription" VARCHAR,
  "projectcity" VARCHAR,
  "projectcountyname" VARCHAR,
  "projectstate" VARCHAR,
  "projectzip" VARCHAR,
  "cd" VARCHAR,
  "jobsreported" DOUBLE,
  "naicscode" DOUBLE,
  "race" VARCHAR,
  "ethnicity" VARCHAR,
  "utilities_proceed" DOUBLE,
  "payroll_proceed" DOUBLE,
  "mortgage_interest_proceed" DOUBLE,
  "rent_proceed" DOUBLE,
  "refinance_eidl_proceed" DOUBLE,
  "health_care_proceed" DOUBLE,
  "debt_interest_proceed" DOUBLE,
  "businesstype" VARCHAR,
  "originatinglenderlocationid" BIGINT,
  "originatinglender" VARCHAR,
  "originatinglendercity" VARCHAR,
  "originatinglenderstate" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "forgivenessamount" DOUBLE,
  "forgivenessdate" TIMESTAMP
);

Share link

Anyone who has the link will be able to view this.