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
Info on loans made by the U.S. SBA in response to COVID
@kaggle.davincermak_payroll_protection_program_loanlevel_data
CREATE TABLE naics_6 (
"industry_code" BIGINT,
"industry_title" VARCHAR
);
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
);
CREATE TABLE zip_county_crosswalk (
"zip" BIGINT,
"county" BIGINT,
"res_ratio" DOUBLE,
"bus_ratio" DOUBLE,
"oth_ratio" DOUBLE,
"tot_ratio" DOUBLE
);
Anyone who has the link will be able to view this.