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.
This dataset has the following 17 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| LoanRange | loanrange | text | Loan range for loans $150,000 and above: a) $5-10 million, b) $2-5 million, c) $1-2 million, d) $350,000-1 million, e) $150,000-350,000 | e $150,000-350,000 d $350,000-1 million c $1-2 million b $2-5 million a $5-10 million view top 100 |
| LoanAmount | loanamount | number | Loan amount for loans up to $150,000 | 20832 20833 20800 10000 20000 view top 100 |
| BusinessName | businessname | text | Business name | RAMZE ZAKKA INC DOUGLAS NEAL RESTAURANTS, LLC TRITECH MECHANICAL, LLC THE FRIENDSHIP CORPORATION NEW APPLICATION view top 100 |
| Address | address | text | Business address | 10 MIDDLE ST 17th Floor 200 EXECUTIVE BLVD 200 Executive Blvd 914 HARTFORD TPKE 341 BIDWELL ST view top 100 |
| City | city | text | Business city | STAMFORD NORWALK BRIDGEPORT HARTFORD FAIRFIELD view top 100 |
| State | state | text | Business state | CT view top 100 |
| Zip | zip | text | Business zip code | 06902 06880 06460 06824 06830 view top 100 |
| NAICSCode | naicscode | text | The North American Industry Classification System (NAICS) is used by the United States, Canada, and Mexico to classify businesses by industry. Each business is classified into a six-digit NAICS code number based on the majority of activity at the business. The code was provided by the loan recipient. | 722511 541110 531210 621111 812112 view top 100 |
| BusinessType | businesstype | text | Business type | Limited Liability Company(LLC) Corporation Sole Proprietorship Subchapter S Corporation Self-Employed Individuals view top 100 |
| RaceEthnicity | raceethnicity | text | Race/ethnicity of business owner | Unanswered White Asian Hispanic Black or African American view top 100 |
| Gender | gender | text | Gender of business owner | Unanswered Male Owned Female Owned view top 100 |
| Veteran | veteran | text | Veteran status of business owner | Unanswered Non-Veteran Veteran view top 100 |
| NonProfit | nonprofit | text | Nonprofit status of business | true view top 100 |
| JobsReported | jobsreported | number | Number of employees at business | 1 2 0 3 4 view top 100 |
| DateApproved | dateapproved | calendar_date | Date PPP loan was approved | 2020-04-28T00:00:00.000 2020-05-03T00:00:00.000 2020-04-27T00:00:00.000 2020-04-30T00:00:00.000 2020-04-29T00:00:00.000 view top 100 |
| Lender | lender | text | Lender to business | People's United Bank, National Association Webster Bank, National Association Bank of America, National Association TD Bank, National Association Liberty Bank view top 100 |
| CD | cd | text | Congressional district of business | CT-04 CT-05 CT-01 CT-03 CT-02 view top 100 |