SBA Paycheck Protection Program (PPP) Loan Data

loanrange LoanRange	businessname BusinessName	address Address	city City	state State	zip Zip	naicscode NAICSCode	businesstype BusinessType	raceethnicity RaceEthnicity	gender Gender	veteran Veteran	nonprofit NonProfit	jobsretained JobsRetained	dateapproved DateApproved	lender Lender	cd CD
a $5-10 million	ARCTIC SLOPE NATIVE ASSOCIATION, LTD.	7000 Uula St	BARROW	AK	99723	813920	Non-Profit Organization	Unanswered	Unanswered	Unanswered	Y	295	Tue Apr 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	National Cooperative Bank, National Association	AK - 00
a $5-10 million	CRUZ CONSTRUCTION INC	7000 East Palmer Wasilla Hwy	PALMER	AK	99645	238190	Subchapter S Corporation	Unanswered	Unanswered	Unanswered	nan	215	Wed Apr 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	First National Bank Alaska	AK - 00
a $5-10 million	I. C. E. SERVICES, INC	2606 C Street	ANCHORAGE	AK	99503	722310	Corporation	Unanswered	Unanswered	Unanswered	nan	367	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KeyBank National Association	AK - 00
a $5-10 million	KATMAI HEALTH SERVICES LLC	11001 O'MALLEY CENTRE DRIVE, SUITE 204	ANCHORAGE	AK	99515	621111	Limited Liability Company(LLC)	Unanswered	Unanswered	Unanswered	nan		Wed Apr 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Truist Bank d/b/a Branch Banking & Trust Co	AK - 00
a $5-10 million	MATANUSKA TELEPHONE ASSOCIATION	1740 S. CHUGACH ST	PALMER	AK	99645	517311	Cooperative	Unanswered	Unanswered	Unanswered	nan	267	Wed Jun 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CoBank ACB	AK - 00
a $5-10 million	NANA WORLEY, LLC	3700 Centerpoint Drive, 7th floor	ANCHORAGE	AK	99503	541330	Limited Liability Company(LLC)	Unanswered	Unanswered	Unanswered	nan	231	Tue May 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	First National Bank Alaska	AK - 00
a $5-10 million	NORTHERN ENERGY SERVICES, LLC	6250 South Airpark Place	ANCHORAGE	AK	99502	213112	Limited Liability Company(LLC)	Unanswered	Unanswered	Unanswered	nan	298	Mon Apr 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Northrim Bank	AK - 00
a $5-10 million	SOUTH PENINSULA HOSPITAL INC	4300 BARTLETT STREET	HOMER	AK	99603	622110	Corporation	Unanswered	Unanswered	Unanswered	nan	439	Tue Apr 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	First National Bank Alaska	AK - 00
a $5-10 million	TATITLEK TECHNOLOGIES, INC.	561 E. 36th Avenue	ANCHORAGE	AK	99503	518210	Corporation	Unanswered	Unanswered	Unanswered	nan	361	Tue Apr 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KeyBank National Association	AK - 00
a $5-10 million	TYONEK GLOBAL SERVICES, LLC	1689 C ST	ANCHORAGE	AK	99501	611420	Limited Liability Company(LLC)	Unanswered	Unanswered	Unanswered	nan		Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBVA USA	AK - 00


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