Connecticut: Affordable Housing by Town 2011-2023

Source Files For 20260926191932-30aff0d91e9d

• Affordable_Housing_by_Town_2011-2023.csv: source

Open Data Contract YAML

Open raw YAML

dataset_id: ct-affordable-housing-by-town-2011-2023
title: 'Connecticut: Affordable Housing by Town 2011-2023'
description: 'Connecticut: Affordable Housing by Town 2011-2023 discovered from data.ct.gov.'
source_name: data.ct.gov
source_url: https://data.ct.gov/api/views/3udy-56vi/rows.csv?accessType=DOWNLOAD
update_frequency: adhoc
next_scan_at: '2026-09-29T02:00:00+00:00'
license:
  name: Public Domain
  url: https://data.ct.gov/Housing-and-Development/Affordable-Housing-by-Town-2011-2023/3udy-56vi
tags:
- data.ct.gov
- housing
geography:
- Connecticut
revisions:
- revision_id: 20260926191932-30aff0d91e9d
  detected_at: '2026-09-26T19:19:32+00:00'
  source_updated_at: Thu, 30 Jan 2025 18:36:12 GMT
  context: Affordable_Housing_by_Town_2011-2023.csv detected from rows.csv.
  assets:
  - asset_id: asset-3a2f75de11e27637
    name: Affordable_Housing_by_Town_2011-2023.csv
    source_url: https://data.ct.gov/api/views/3udy-56vi/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: 3a2f75de11e27637516c8dba74819deb234c53065d88cbe281eecd0c54512c5a
    size_bytes: 96466
    parent_archive_id: null
  row_count: 2197
  headers:
  - Year
  - Town Code
  - Town
  - Census Units
  - Government Assisted
  - Tenant Rental Assistance
  - Single Family CHFA/ USDA Mortgages
  - Deed Restricted Units
  - Total Assisted Units
  - Percent Affordable
  sample_rows:
  - Year: '2023'
    Town Code: '1'
    Town: Andover
    Census Units: '1324'
    Government Assisted: '24'
    Tenant Rental Assistance: '1'
    Single Family CHFA/ USDA Mortgages: '26'
    Deed Restricted Units: '0'
    Total Assisted Units: '51'
    Percent Affordable: '3.85'
  - Year: '2022'
    Town Code: '1'
    Town: Andover
    Census Units: '1317'
    Government Assisted: '24'
    Tenant Rental Assistance: '1'
    Single Family CHFA/ USDA Mortgages: '27'
    Deed Restricted Units: '0'
    Total Assisted Units: '52'
    Percent Affordable: '3.95'
  - Year: '2021'
    Town Code: '1'
    Town: Andover
    Census Units: '1317'
    Government Assisted: '24'
    Tenant Rental Assistance: '1'
    Single Family CHFA/ USDA Mortgages: '29'
    Deed Restricted Units: '0'
    Total Assisted Units: '54'
    Percent Affordable: '4.10'
  - Year: '2020'
    Town Code: '1'
    Town: Andover
    Census Units: '1317'
    Government Assisted: '18'
    Tenant Rental Assistance: '1'
    Single Family CHFA/ USDA Mortgages: '32'
    Deed Restricted Units: '0'
    Total Assisted Units: '51'
    Percent Affordable: '3.87'
  - Year: '2019'
    Town Code: '1'
    Town: Andover
    Census Units: '1317'
    Government Assisted: '18'
    Tenant Rental Assistance: '1'
    Single Family CHFA/ USDA Mortgages: '29'
    Deed Restricted Units: '0'
    Total Assisted Units: '48'
    Percent Affordable: '3.64'
  parser_errors: []
  logical_asset_id: 7ced764399639cb1c6f1e708
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:19:32+00:00'

Revision dbt Source YAML

Open raw YAML

version: 2
sources:
- name: ct_affordable_housing_by_town_2011_2023
  description: 'Connecticut: Affordable Housing by Town 2011-2023 discovered from
    data.ct.gov.'
  meta:
    opendataodc:
      dataset_id: ct-affordable-housing-by-town-2011-2023
      revision_id: 20260926191932-30aff0d91e9d
      detected_at: '2026-09-26T19:19:32+00:00'
      source_url: https://data.ct.gov/api/views/3udy-56vi/rows.csv?accessType=DOWNLOAD
  tables:
  - name: affordable_housing_by_town_2011_2023_csv
    description: Source asset Affordable_Housing_by_Town_2011-2023.csv.
    meta:
      opendataodc:
        source_url: https://data.ct.gov/api/views/3udy-56vi/rows.csv?accessType=DOWNLOAD
        content_hash: 3a2f75de11e27637516c8dba74819deb234c53065d88cbe281eecd0c54512c5a
        row_count: 2197
        parser_errors: []
    columns:
    - name: Year
    - name: Town Code
    - name: Town
    - name: Census Units
    - name: Government Assisted
    - name: Tenant Rental Assistance
    - name: Single Family CHFA/ USDA Mortgages
    - name: Deed Restricted Units
    - name: Total Assisted Units
    - name: Percent Affordable

Sample Rows