Baselight

Should This Loan Be Approved Or Denied?

A large and rich dataset from the U.S. Small Business Administration (SBA)

@kaggle.mirbektoktogaraev_should_this_loan_be_approved_or_denied

Sbanational
@kaggle.mirbektoktogaraev_should_this_loan_be_approved_or_denied.sbanational

  • 45.92 MB
  • 899164 rows
  • 27 columns
loannr_chkdgt

LoanNr ChkDgt

name

Name

city

City

state

State

zip

Zip

bank

Bank

bankstate

BankState

naics

NAICS

approvaldate

ApprovalDate

approvalfy

ApprovalFY

term

Term

noemp

NoEmp

newexist

NewExist

createjob

CreateJob

retainedjob

RetainedJob

franchisecode

FranchiseCode

urbanrural

UrbanRural

revlinecr

RevLineCr

lowdoc

LowDoc

chgoffdate

ChgOffDate

disbursementdate

DisbursementDate

disbursementgross

DisbursementGross

balancegross

BalanceGross

mis_status

MIS Status

chgoffpringr

ChgOffPrinGr

grappv

GrAppv

sba_appv

SBA Appv

1000014003ABC HOBBYCRAFTEVANSVILLEIN47711FIFTH THIRD BANKOH45112028-Feb-97199784421NYnan28-Feb-99$60,000.00 $0.00 P I F$0.00 $60,000.00 $48,000.00
1000024006LANDMARK BAR & GRILLE (THE)NEW PARISIN465261ST SOURCE BANKIN72241028-Feb-97199760221NYnan31-May-97$40,000.00 $0.00 P I F$0.00 $40,000.00 $32,000.00
1000034009WHITLOCK DDS, TODD M.BLOOMINGTONIN47401GRANT COUNTY STATE BANKIN62121028-Feb-971997180711NNnan31-Dec-97$287,000.00 $0.00 P I F$0.00 $287,000.00 $215,250.00
1000044001BIG BUCKS PAWN & JEWELRY, LLCBROKEN ARROWOK740121ST NATL BK & TR CO OF BROKENOK28-Feb-97199760211NYnan30-Jun-97$35,000.00 $0.00 P I F$0.00 $35,000.00 $28,000.00
1000054004ANASTASIA CONFECTIONS, INC.ORLANDOFL32801FLORIDA BUS. DEVEL CORPFL28-Feb-971997240141771NNnan14-May-97$229,000.00 $0.00 P I F$0.00 $229,000.00 $229,000.00
1000084002B&T SCREW MACHINE COMPANY, INCPLAINVILLECT6062TD BANK, NATIONAL ASSOCIATIONDE33272128-Feb-9719971201911NNnan30-Jun-97$517,000.00 $0.00 P I F$0.00 $517,000.00 $387,750.00
1000093009MIDDLE ATLANTIC SPORTS CO INCUNIONNJ7083WELLS FARGO BANK NATL ASSOCSD2-Jun-80198045452NN24-Jun-9122-Jul-80$600,000.00 $0.00 CHGOFF$208,959.00 $600,000.00 $499,998.00
1000094005WEAVER PRODUCTSSUMMERFIELDFL34491REGIONS BANKAL81111828-Feb-97199784121NYnan30-Jun-98$45,000.00 $0.00 P I F$0.00 $45,000.00 $36,000.00
1000104006TURTLE BEACH INNPORT SAINT JOEFL32456CENTENNIAL BANKFL72131028-Feb-971997297221NNnan31-Jul-97$305,000.00 $0.00 P I F$0.00 $305,000.00 $228,750.00
1000124001INTEXT BUILDING SYS LLCGLASTONBURYCT6073WEBSTER BANK NATL ASSOCCT28-Feb-97199784321NYnan30-Apr-97$70,000.00 $0.00 P I F$0.00 $70,000.00 $56,000.00

CREATE TABLE sbanational (
  "loannr_chkdgt" BIGINT,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "bank" VARCHAR,
  "bankstate" VARCHAR,
  "naics" BIGINT,
  "approvaldate" VARCHAR,
  "approvalfy" VARCHAR,
  "term" BIGINT,
  "noemp" BIGINT,
  "newexist" DOUBLE,
  "createjob" BIGINT,
  "retainedjob" BIGINT,
  "franchisecode" BIGINT,
  "urbanrural" BIGINT,
  "revlinecr" VARCHAR,
  "lowdoc" VARCHAR,
  "chgoffdate" VARCHAR,
  "disbursementdate" VARCHAR,
  "disbursementgross" VARCHAR,
  "balancegross" VARCHAR,
  "mis_status" VARCHAR,
  "chgoffpringr" VARCHAR,
  "grappv" VARCHAR,
  "sba_appv" VARCHAR
);

Share link

Anyone who has the link will be able to view this.