Paycheck Protection Program Loan-Level Data

Info on loans made by the U.S. SBA in response to COVID

@kaggle.davincermak_payroll_protection_program_loanlevel_data

Table List

3 tables(52.82 MB)

Naics 6

Ppp Loan Data

Zip County Crosswalk

Ppp Loan Data

@kaggle.davincermak_payroll_protection_program_loanlevel_data.ppp_loan_data

51.79 MB
4549613 rows
13 columns

loanamount Loanamount	city City	state State	zip Zip	naicscode Naicscode	businesstype Businesstype	raceethnicity Raceethnicity	gender Gender	veteran Veteran	jobsreported Jobsreported	dateapproved Dateapproved	lender Lender	congressionaldistrict Congressionaldistrict
149978	Pelham	AL	35124	561311	Limited Liability Company(LLC)	nan	nan	nan	17	Thu May 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Truist Bank d/b/a Branch Banking & Trust Co	AL-06
149900	Birmingham	AL	35242	561311	Corporation	nan	Female Owned	nan	39	Mon Apr 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Peoples Bank of Alabama	AL-06
149887	Trussville	AL	35173	238910	Limited Liability Company(LLC)	nan	nan	nan	14	Wed Apr 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Bryant Bank	AL-06
149865	Trussville	AL	35173	621340	Self-Employed Individuals	nan	nan	nan		Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Regions Bank	AL-06
149862	Springville	AL	35146	624221	Non-Profit Organization	nan	nan	nan	19	Sun Apr 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	South State Bank, National Association	AL-06
149824.27	Huntsville	AL	35806	423710	Limited Liability Company(LLC)	White	Female Owned	Non-Veteran	12	Fri Apr 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	First National Bank of Pulaski	AL-05
149800	Dothan	AL	36303	488999	Limited Liability Company(LLC)	nan	Male Owned	nan	17	Fri Apr 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MidSouth Bank	AL-02
149800	Auburn	AL	36831	236220	Subchapter S Corporation	nan	nan	nan	10	Mon Apr 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AuburnBank	AL-03
149800	Fyffe	AL	35971	236210	Limited Liability Company(LLC)	nan	nan	nan	16	Wed Apr 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Peoples Bank of Alabama	AL-04
149753.62	Fort Payne	AL	35967	484121	Limited Liability Company(LLC)	White	Male Owned	Non-Veteran	15	Thu Apr 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	First State Bank of DeKalb County	AL-04


CREATE TABLE ppp_loan_data (
  "loanamount" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "jobsreported" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "congressionaldistrict" VARCHAR
);