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 Mi

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_mi

1.23 MB
101,166 rows
14 columns

CREATE TABLE foia_up_to_150k_mi (
  "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 Mn

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_mn

1 MB
84,417 rows
14 columns

CREATE TABLE foia_up_to_150k_mn (
  "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 Mo

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_mo

966.93 kB
80,035 rows
14 columns

CREATE TABLE foia_up_to_150k_mo (
  "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 Mp

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_mp

16.12 kB
417 rows
14 columns

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

Foia Up To 150k Ms

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ms

486.06 kB
41,924 rows
14 columns

CREATE TABLE foia_up_to_150k_ms (
  "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 Mt

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_mt

246.91 kB
20,906 rows
14 columns

CREATE TABLE foia_up_to_150k_mt (
  "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 Nc

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nc

1.24 MB
105,589 rows
14 columns

CREATE TABLE foia_up_to_150k_nc (
  "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 Nd

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nd

213.85 kB
17,546 rows
14 columns

CREATE TABLE foia_up_to_150k_nd (
  "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 Ne

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ne

456.97 kB
38,318 rows
14 columns

CREATE TABLE foia_up_to_150k_ne (
  "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 Nh

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nh

245.76 kB
20,388 rows
14 columns

CREATE TABLE foia_up_to_150k_nh (
  "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 Nj

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nj

1.51 MB
125,690 rows
14 columns

CREATE TABLE foia_up_to_150k_nj (
  "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 Nm

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nm

260.42 kB
18,925 rows
14 columns

CREATE TABLE foia_up_to_150k_nm (
  "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 Nv

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_nv

443.28 kB
36,605 rows
14 columns

CREATE TABLE foia_up_to_150k_nv (
  "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 Ny

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ny

3.23 MB
277,012 rows
14 columns

CREATE TABLE foia_up_to_150k_ny (
  "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 Oh

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_oh

1.42 MB
117,390 rows
14 columns

CREATE TABLE foia_up_to_150k_oh (
  "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 Ok

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ok

637.14 kB
57,430 rows
14 columns

CREATE TABLE foia_up_to_150k_ok (
  "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 Or

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_or

671.89 kB
53,551 rows
14 columns

CREATE TABLE foia_up_to_150k_or (
  "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 Other

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_other

12.71 kB
196 rows
14 columns

CREATE TABLE foia_up_to_150k_other (
  "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 Pa

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_pa

1.67 MB
139,814 rows
14 columns

CREATE TABLE foia_up_to_150k_pa (
  "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 Pr

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_pr

304.87 kB
35,895 rows
14 columns

CREATE TABLE foia_up_to_150k_pr (
  "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 Ri

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ri

178.07 kB
14,710 rows
14 columns

CREATE TABLE foia_up_to_150k_ri (
  "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 Sc

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_sc

688.8 kB
55,553 rows
14 columns

CREATE TABLE foia_up_to_150k_sc (
  "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 Sd

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_sd

250.97 kB
20,563 rows
14 columns

CREATE TABLE foia_up_to_150k_sd (
  "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 Tn

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_tn

1.01 MB
82,018 rows
14 columns

CREATE TABLE foia_up_to_150k_tn (
  "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 Tx

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_tx

3.92 MB
337,237 rows
14 columns

CREATE TABLE foia_up_to_150k_tx (
  "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
);