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.18 MB
101166 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

980.42 KB
84417 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

944.26 KB
80035 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

15.74 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

474.67 KB
41924 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

241.13 KB
20906 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.19 MB
105589 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

208.84 KB
17546 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

446.26 KB
38318 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

240 KB
20388 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.44 MB
125690 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

254.31 KB
18925 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

432.89 KB
36605 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.08 MB
277012 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.35 MB
117390 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

622.2 KB
57430 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

656.14 KB
53551 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.41 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.6 MB
139814 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

297.72 KB
35895 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

173.9 KB
14710 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

672.65 KB
55553 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

245.09 KB
20563 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

985.71 KB
82018 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.74 MB
337237 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
);