About this Dataset

Department Of Economic And Community Development (DECD) – Business Assistance Portfolio

DECD's listing of direct financial assistance to businesses from July 1, 2009 through June 30, 2024. New projects are usually added quarterly, but updates may be made on an ongoing basis.

Small Business Boost loan recipients can be found here: https://data.ct.gov/d/yk65-8y82
Organization: State of Connecticut
Last updated: 2021-08-07T13:23:42.014660
Tags: business-assistance, decd, department-of-economic-and-community-development, executive-order-38, grant, loan

Tables

Table 1

@usgov.state_of_connecticut_department_of_economic_and_commun_049cdd78.table_1

300.45 kB
2,206 rows
33 columns

CREATE TABLE table_1 (
  "fiscal_year" DOUBLE,
  "company_name" VARCHAR,
  "company_address" VARCHAR,
  "municipality" VARCHAR,
  "county_1" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "business_industry" VARCHAR,
  "naics_code" VARCHAR,
  "minority_woman_veteran_international_export" VARCHAR  -- Minority/ Woman/ Veteran/ International Export,
  "contract_execution_date" TIMESTAMP,
  "grant_amount" DOUBLE,
  "loan_amount" DOUBLE,
  "total_assistance" DOUBLE,
  "total_project_cost" DOUBLE,
  "amount_leveraged" DOUBLE,
  "funding_source" VARCHAR,
  "statutory_reference" VARCHAR,
  "per_contract_full_time_ct_jobs_to_be_retained" VARCHAR  -- Per Contract: Full-Time CT Jobs To Be Retained,
  "per_contract_full_time_ct_jobs_to_be_created" VARCHAR  -- Per Contract: Full-Time CT Jobs To Be Created,
  "per_contract_part_time_ct_jobs_to_be_retained" VARCHAR  -- Per Contract: Part-Time CT Jobs To Be Retained,
  "per_contract_part_time_ct_jobs_to_be_created" VARCHAR  -- Per Contract: Part-Time CT Jobs To Be Created,
  "actual_jobs_at_time_of_review" VARCHAR,
  "job_obligation_status" VARCHAR,
  "penalty_if_applicable" VARCHAR  -- Penalty (if Applicable),
  "forgiveness_earned_if_applicable" VARCHAR  -- Forgiveness Earned (if Applicable),
  "per_application_existing_full_time_jobs_in_ct" VARCHAR  -- Per Application: Existing Full-Time Jobs In CT,
  "per_application_full_time_jobs_to_be_created_in_ct" VARCHAR  -- Per Application: Full-Time Jobs To Be Created In CT,
  "per_application_existing_part_time_jobs_in_ct" VARCHAR  -- Per Application: Existing Part-Time Jobs In CT,
  "per_application_part_time_jobs_to_be_created_in_ct" VARCHAR  -- Per Application: Part Time Jobs To Be Created In CT,
  "full_time_ct_employment_at_6_30_24" DOUBLE,
  "location_1" VARCHAR,
  "geocoded_location" VARCHAR
);