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

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ct-gov/governors-report-on-housing-development-6urm-da9a\".\"governors_report_on_housing_development\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.