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 150k Plus

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_150k_plus

27.49 MB
661218 rows
16 columns


CREATE TABLE foia_150k_plus (
  "loanrange" VARCHAR,
  "businessname" VARCHAR,
  "address" VARCHAR,
  "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 Ak

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ak

134.75 KB
9515 rows
14 columns


CREATE TABLE foia_up_to_150k_ak (
  "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 Al

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_al

717.24 KB
57931 rows
14 columns


CREATE TABLE foia_up_to_150k_al (
  "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 Ar

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ar

454.77 KB
38177 rows
14 columns


CREATE TABLE foia_up_to_150k_ar (
  "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 As

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_as

12.88 KB
204 rows
14 columns


CREATE TABLE foia_up_to_150k_as (
  "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 Az

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_az

821.18 KB
69685 rows
14 columns


CREATE TABLE foia_up_to_150k_az (
  "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 Ca

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ca

5.45 MB
493436 rows
14 columns


CREATE TABLE foia_up_to_150k_ca (
  "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 Co

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_co

1.04 MB
91018 rows
14 columns


CREATE TABLE foia_up_to_150k_co (
  "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 Ct

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ct

632.73 KB
52353 rows
14 columns


CREATE TABLE foia_up_to_150k_ct (
  "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 Dc

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_dc

120.59 KB
9678 rows
14 columns


CREATE TABLE foia_up_to_150k_dc (
  "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 De

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_de

140.1 KB
10431 rows
14 columns


CREATE TABLE foia_up_to_150k_de (
  "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 Fl

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_fl

3.83 MB
350809 rows
14 columns


CREATE TABLE foia_up_to_150k_fl (
  "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 Ga

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ga

1.58 MB
138519 rows
14 columns


CREATE TABLE foia_up_to_150k_ga (
  "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 Gu

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_gu

35.07 KB
1868 rows
14 columns


CREATE TABLE foia_up_to_150k_gu (
  "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 Hi

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_hi

224.98 KB
21305 rows
14 columns


CREATE TABLE foia_up_to_150k_hi (
  "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 Ia

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ia

630.54 KB
52527 rows
14 columns


CREATE TABLE foia_up_to_150k_ia (
  "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 Id

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_id

308.62 KB
26855 rows
14 columns


CREATE TABLE foia_up_to_150k_id (
  "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 Il

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_il

2.02 MB
174745 rows
14 columns


CREATE TABLE foia_up_to_150k_il (
  "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 In

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_in

780.72 KB
67294 rows
14 columns


CREATE TABLE foia_up_to_150k_in (
  "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 Ks

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ks

551 KB
46015 rows
14 columns


CREATE TABLE foia_up_to_150k_ks (
  "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 Ky

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ky

513.75 KB
41932 rows
14 columns


CREATE TABLE foia_up_to_150k_ky (
  "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 La

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_la

784.79 KB
64767 rows
14 columns


CREATE TABLE foia_up_to_150k_la (
  "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 Ma

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_ma

1.06 MB
94744 rows
14 columns


CREATE TABLE foia_up_to_150k_ma (
  "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 Md

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_md

817.52 KB
68398 rows
14 columns


CREATE TABLE foia_up_to_150k_md (
  "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 Me

@kaggle.govtrades_sba_paycheck_protection_program_loan_data.foia_up_to_150k_me

290.68 KB
24358 rows
14 columns


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