Name: SBA Paycheck Protection Program (PPP) Loan Data
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

SBA Paycheck Protection Program (PPP) Loan Data

Context

The Paycheck Protection Program (PPP) was passed by congress to give relief to businesses negatively impacted by Covid-19 in order to maintain pay for employees. The program gives forgivable loans to businesses that continue paying employees during the pandemic. The PPP quickly ran out of funds, limiting which businesses received relief. Some controversy around the program arose from large, publicly traded companies applying for and receiving PPP funds while many small businesses were unable to access relief.

Content

This dataset released by the treasury department on July 6 shows all loans above $150K given through the Paycheck Protection Program.

Acknowledgements

This dataset was posted by GovTrades, a mission-oriented organization working to increase transparency and accountability in policymaking. Check out GovTrades.org for data on stocks that elected officials buy and sell.

Tables

Foia Up To 150k Ut

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ut

494.76 kB
43,954 rows
14 columns

CREATE TABLE foia_up_to_150k_ut (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Va

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_va

1.1 MB
93,049 rows
14 columns

CREATE TABLE foia_up_to_150k_va (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Vi

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_vi

33.05 kB
1,724 rows
14 columns

CREATE TABLE foia_up_to_150k_vi (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Vt

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_vt

141.61 kB
10,387 rows
14 columns

CREATE TABLE foia_up_to_150k_vt (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Wa

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_wa

1.07 MB
85,202 rows
14 columns

CREATE TABLE foia_up_to_150k_wa (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Wi

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_wi

882 kB
73,104 rows
14 columns

CREATE TABLE foia_up_to_150k_wi (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Wv

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_wv

204.3 kB
15,025 rows
14 columns

CREATE TABLE foia_up_to_150k_wv (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);

Foia Up To 150k Wy

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_wy

159.38 kB
11,866 rows
14 columns

CREATE TABLE foia_up_to_150k_wy (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsretained" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);