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

483.16 KB
43954 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.05 MB
93049 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

32.28 KB
1724 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

138.29 KB
10387 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.02 MB
85202 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

861.33 KB
73104 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

199.51 KB
15025 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

155.65 KB
11866 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
);