About this Dataset

Department Of Economic And Community Development- Tax Credit Portfolio

A listing of DECD administered tax credits that have been allocated and/or earned for projects with agreements executed from FY 2014- February 2025.

Please note- Film, Television & Digital Media tax credit activity has been removed from this dataset and can be found here: https://data.ct.gov/Business/DECD-Film-TV-and-Digital-Media-Tax-Credit-Activity/kjsu-mdny
Organization: State of Connecticut
Last updated: 2020-11-12T14:56:26.752844
Tags: business, digital, film, historic, insurance, jet, media, small-business, tax-credits, tax-credits-earned, ura

Tables

Table 1

@usgov.state_of_connecticut_department_of_economic_and_commun_f70cbbd6.table_1

26.99 kB
54 rows
26 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "applicant_recipient" VARCHAR,
  "applicant_address" VARCHAR,
  "applicant_city" VARCHAR,
  "applicant_state" VARCHAR,
  "applicant_zip_code" DOUBLE,
  "project_address" VARCHAR,
  "project_municipality" VARCHAR,
  "project_zip_code" DOUBLE,
  "program_name" VARCHAR,
  "statutory_reference" VARCHAR,
  "total_tax_credits_issued_offset_exempted" VARCHAR  -- Total Tax Credits Issued/ Offset/ Exempted,
  "total_tax_credit_allocation" DOUBLE,
  "contract_date_allocation_date" VARCHAR  -- Contract Date/ Allocation Date,
  "total_number_of_investments" DOUBLE,
  "total_qualified_expenditures" DOUBLE,
  "leveraged_funds" VARCHAR,
  "total_jobs_created" DOUBLE,
  "contract_requirement_jobs_to_be_retained" DOUBLE,
  "contract_requirement_jobs_to_be_created" DOUBLE  -- Contract Requirement: Jobs To Be Created,
  "contract_requirement_target_date" VARCHAR  -- Contract Requirement: Target Date,
  "actual_jobs_at_time_of_review" VARCHAR,
  "job_obligation_status" VARCHAR,
  "reallocated_funds_if_applicable" VARCHAR  -- Reallocated Funds (if Applicable),
  "project_location" VARCHAR,
  "applicant_location" VARCHAR
);