Baselight
Sign In

SBA Paycheck Protection Program (PPP) Loan Data

Loan-level data from Covid-19 PPP

@kaggle.govtrades_sba_paycheck_protection_program_loan_data

Loading...
Loading...

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
  • 28.82 MB
  • 661,218 rows
  • 16 columns
Loading... 
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
  • 137.98 kB
  • 9,515 rows
  • 14 columns
Loading... 
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
  • 734.46 kB
  • 57,931 rows
  • 14 columns
Loading... 
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
  • 465.68 kB
  • 38,177 rows
  • 14 columns
Loading... 
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
  • 13.19 kB
  • 204 rows
  • 14 columns
Loading... 
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
  • 840.89 kB
  • 69,685 rows
  • 14 columns
Loading... 
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.72 MB
  • 493,436 rows
  • 14 columns
Loading... 
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.09 MB
  • 91,018 rows
  • 14 columns
Loading... 
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
  • 647.92 kB
  • 52,353 rows
  • 14 columns
Loading... 
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
  • 123.49 kB
  • 9,678 rows
  • 14 columns
Loading... 
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
  • 143.46 kB
  • 10,431 rows
  • 14 columns
Loading... 
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
  • 4.02 MB
  • 350,809 rows
  • 14 columns
Loading... 
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.65 MB
  • 138,519 rows
  • 14 columns
Loading... 
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.92 kB
  • 1,868 rows
  • 14 columns
Loading... 
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
  • 230.38 kB
  • 21,305 rows
  • 14 columns
Loading... 
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
  • 645.68 kB
  • 52,527 rows
  • 14 columns
Loading... 
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
  • 316.02 kB
  • 26,855 rows
  • 14 columns
Loading... 
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.11 MB
  • 174,745 rows
  • 14 columns
Loading... 
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
  • 799.45 kB
  • 67,294 rows
  • 14 columns
Loading... 
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
  • 564.22 kB
  • 46,015 rows
  • 14 columns
Loading... 
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
  • 526.09 kB
  • 41,932 rows
  • 14 columns
Loading... 
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
  • 803.63 kB
  • 64,767 rows
  • 14 columns
Loading... 
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.11 MB
  • 94,744 rows
  • 14 columns
Loading... 
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
  • 837.14 kB
  • 68,398 rows
  • 14 columns
Loading... 
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
  • 297.65 kB
  • 24,358 rows
  • 14 columns
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.