Baselight

SBA Paycheck Protection Program (PPP) Loan Data

Loan-level data from Covid-19 PPP

@kaggle.govtrades_sba_paycheck_protection_program_loan_data

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
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
  • 134.75 KB
  • 9515 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
  • 717.24 KB
  • 57931 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
  • 454.77 KB
  • 38177 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
  • 12.88 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
  • 821.18 KB
  • 69685 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.45 MB
  • 493436 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.04 MB
  • 91018 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
  • 632.73 KB
  • 52353 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
  • 120.59 KB
  • 9678 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
  • 140.1 KB
  • 10431 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
  • 3.83 MB
  • 350809 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.58 MB
  • 138519 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.07 KB
  • 1868 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
  • 224.98 KB
  • 21305 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
  • 630.54 KB
  • 52527 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
  • 308.62 KB
  • 26855 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.02 MB
  • 174745 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
  • 780.72 KB
  • 67294 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
  • 551 KB
  • 46015 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
  • 513.75 KB
  • 41932 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
  • 784.79 KB
  • 64767 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.06 MB
  • 94744 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
  • 817.52 KB
  • 68398 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
  • 290.68 KB
  • 24358 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
);

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
);

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
);