About this Dataset

Governor's Report On Housing Development

This dataset represents affordable housing development/preservation that is supported by the State of Connecticut Department of Housing. It includes units that have been completed under the current administration and when, or are actively under construction.

*Completion dates/percentages for HTCC only developments are based upon the most recently submitted quarterly statements.
*Projects labeled as "Under Construction" include those that have had reported greater than 0% completed.
*Projects labeled as "In Progress" include those that have received funding commitments but have not yet reported a % complete.

In some cases the Total DOH & CHFA funding exceeds Total Project Cost due to CHFA construction financing.
*Only projects with a Board Approval (or application date if Board Approval N/A), Initial Close, Final Close or Construction Completion % date after 1/1/19 are to be included on list
*Any Subtotal/Total amounts may be inflated due to multiple applications being captured for a single project
*All projects specified as Family in the "Family or Elderly" column are non-age restrictive
*Projects that have Final Closed prior to 2019 are not shown
*Projects that were approved for funding or under construction but not yet complete, prior to 2019 are included
*Total Equity is an aggregate of 4%, 9%, SHPO, & HTCC equities
Organization: State of Connecticut
Last updated: 2022-01-25T00:00:38.440456
Tags: affordable-housing, doh, housing

Tables

Table 1

@usgov.state_of_connecticut_governors_report_on_housing_devel_7fbec88d.table_1

70.65 kB
524 rows
28 columns

CREATE TABLE table_1 (
  "project_name" VARCHAR,
  "chfa_loan" VARCHAR  -- CHFA Loan #,
  "address" VARCHAR,
  "municipality" VARCHAR,
  "county" VARCHAR,
  "zip_code" VARCHAR,
  "total_project_cost" DOUBLE,
  "doh_investment" DOUBLE,
  "source_of_doh_funds" VARCHAR,
  "total_project_units" DOUBLE,
  "doh_supported_units" DOUBLE,
  "lihtc_qualified_units" DOUBLE,
  "supportive_housing_units" DOUBLE,
  "new_units" DOUBLE,
  "rehab_units" DOUBLE,
  "family_or_elderly" VARCHAR,
  "attorney_general_approval_date" TIMESTAMP,
  "actual_completion_date" TIMESTAMP,
  "percentage_complete" DOUBLE,
  "total_chfa_perm_sources" DOUBLE,
  "total_equity" DOUBLE,
  "total_chfa_equity" DOUBLE  -- Total CHFA & Equity,
  "total_doh_chfa_sources" DOUBLE  -- Total DOH & CHFA Sources,
  "total_doh_chfa_equity" DOUBLE  -- Total DOH & CHFA + Equity,
  "units_below_30_ami" DOUBLE  -- Units Below 30% AMI,
  "units_31_60_ami" DOUBLE  -- Units 31-60% AMI,
  "units_61_80_ami" DOUBLE  -- Units 61-80% AMI,
  "above_80_ami" DOUBLE  -- Above 80% AMI
);