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

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.