About this Dataset

PPP Loans To Connecticut Businesses

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in Connecticut that received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient.

This dataset includes loans under $150,000 and loans of $150,000 and above made to Connecticut businesses through August 8, 2020.

Please see attached document for more details.
Organization: State of Connecticut
Last updated: 2020-11-12T14:56:48.277115
Tags: covid-19, economic-recovery, loan, ppp, small-business

Tables

Table 1

@usgov.state_of_connecticut_ppp_loans_to_connecticut_businesses.table_1

987.98 kB
64,627 rows
17 columns

CREATE TABLE table_1 (
  "loanrange" VARCHAR,
  "loanamount" DOUBLE,
  "businessname" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "naicscode" DOUBLE,
  "businesstype" VARCHAR,
  "raceethnicity" VARCHAR,
  "gender" VARCHAR,
  "veteran" VARCHAR,
  "nonprofit" VARCHAR,
  "jobsreported" DOUBLE,
  "dateapproved" TIMESTAMP,
  "lender" VARCHAR,
  "cd" VARCHAR
);