Paycheck Protection Program(PPP) - FOIA
Program initiated to provide economic relief to small businesses during COVID-19
@kaggle.johnp47_paycheck_protection_programppp_foia
Program initiated to provide economic relief to small businesses during COVID-19
@kaggle.johnp47_paycheck_protection_programppp_foia
CREATE TABLE public_150k_plus_220403 (
"loannumber" BIGINT,
"dateapproved" TIMESTAMP,
"sbaofficecode" BIGINT,
"processingmethod" VARCHAR,
"borrowername" VARCHAR,
"borroweraddress" VARCHAR,
"borrowercity" VARCHAR,
"borrowerstate" VARCHAR,
"borrowerzip" VARCHAR,
"loanstatusdate" TIMESTAMP,
"loanstatus" VARCHAR,
"term" BIGINT,
"sbaguarantypercentage" BIGINT,
"initialapprovalamount" DOUBLE,
"currentapprovalamount" DOUBLE,
"undisbursedamount" DOUBLE,
"franchisename" VARCHAR,
"servicinglenderlocationid" BIGINT,
"servicinglendername" VARCHAR,
"servicinglenderaddress" VARCHAR,
"servicinglendercity" VARCHAR,
"servicinglenderstate" VARCHAR,
"servicinglenderzip" VARCHAR,
"ruralurbanindicator" VARCHAR,
"hubzoneindicator" VARCHAR,
"lmiindicator" VARCHAR,
"businessagedescription" VARCHAR,
"projectcity" VARCHAR,
"projectcountyname" VARCHAR,
"projectstate" VARCHAR,
"projectzip" VARCHAR,
"cd" VARCHAR,
"jobsreported" DOUBLE,
"naicscode" DOUBLE,
"race" VARCHAR,
"ethnicity" VARCHAR,
"utilities_proceed" DOUBLE,
"payroll_proceed" DOUBLE,
"mortgage_interest_proceed" DOUBLE,
"rent_proceed" DOUBLE,
"refinance_eidl_proceed" DOUBLE,
"health_care_proceed" DOUBLE,
"debt_interest_proceed" DOUBLE,
"businesstype" VARCHAR,
"originatinglenderlocationid" BIGINT,
"originatinglender" VARCHAR,
"originatinglendercity" VARCHAR,
"originatinglenderstate" VARCHAR,
"gender" VARCHAR,
"veteran" VARCHAR,
"nonprofit" VARCHAR,
"forgivenessamount" DOUBLE,
"forgivenessdate" TIMESTAMP
);
Anyone who has the link will be able to view this.