Dataset: Paycheck Protection Program Loan-Level Data

About this Dataset

Paycheck Protection Program Loan-Level Data

Context

Created under the Cares Act as a response to COVID economic disruption, the Paycheck Protection Program (PPP) offered emergency loans to small businesses in the United States with the goal of reducing job losses. To promote the program, borrowers may be eligible for loan forgiveness if at least 60% of the loan proceeds were used to pay workers.

Content

There are 3 data files:

ppp_loan_data.cvs: In addition to the loan amount (in U.S. dollars), the data file contains loan-level demographic information on the loans originated under the PPP program. Geographic fields include state, city, U.S. Congressional District, and zip code. It also includes business ownership type and a detailed NAICS code indicating the borrower's type of business, originating bank, and some borrower characteristics.
naics_6.csv: this file contains industry names to accompany the NAICS code in the data file
zip_county_crosswalk.cvs: this file maps zip codes to U.S. counties for anyone interested in incorporating additional demographic, economic, or other data of interest.

Acknowledgements

This data comes from the U.S. Small Business Administration (https://www.sba.gov/funding-programs/loans/coronavirus-relief-options/paycheck-protection-program).

Tables

Naics 6

@kaggle.davincermak_payroll_protection_program_loanlevel_data.naics_6

38.49 KB
1301 rows
2 columns


CREATE TABLE naics_6 (
  "industry_code" BIGINT,
  "industry_title" VARCHAR
);

Ppp Loan Data

@kaggle.davincermak_payroll_protection_program_loanlevel_data.ppp_loan_data

51.79 MB
4549613 rows
13 columns


CREATE TABLE ppp_loan_data (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "jobsreported" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "congressionaldistrict" VARCHAR
);

Zip County Crosswalk

@kaggle.davincermak_payroll_protection_program_loanlevel_data.zip_county_crosswalk

1017.88 KB
54194 rows
6 columns


CREATE TABLE zip_county_crosswalk (
  "zip" BIGINT,
  "county" BIGINT,
  "res_ratio" DOUBLE,
  "bus_ratio" DOUBLE,
  "oth_ratio" DOUBLE,
  "tot_ratio" DOUBLE
);