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

Zip County Crosswalk

@kaggle.davincermak_payroll_protection_program_loanlevel_data.zip_county_crosswalk

1017.88 KB
54194 rows
6 columns

zip ZIP	county COUNTY	res_ratio RES RATIO	bus_ratio BUS RATIO	oth_ratio OTH RATIO	tot_ratio TOT RATIO
501	36103		1		1
601	72001	0.839799099	0.800982801	0.871165644	0.838114754
601	72113	0.160200901	0.199017199	0.128834356	0.161885246
602	72003	1	0.998800959	1	0.999919374
602	72005		0.00119904		0.000080626
603	72071	0.000278722			0.000255193
603	72099	0.00256425	0.00183486		0.00244985
603	72005	0.997157032	0.998165138	1	0.997294952
604	72005	1	1	1	1
605	72005	1	1	1	1


CREATE TABLE zip_county_crosswalk (
  "zip" BIGINT,
  "county" BIGINT,
  "res_ratio" DOUBLE,
  "bus_ratio" DOUBLE,
  "oth_ratio" DOUBLE,
  "tot_ratio" DOUBLE
);