About this Dataset

Affordable Housing Inventory

This dataset includes all housing projects that have received a subsidy from or participated in a city of Austin developer incentive program. Projects may include a mix of income-restricted and market rate units and span the development pipeline from developer incentive certification or loan approval to project completion.
Organization: City of Austin
Last updated: 2022-09-02T18:37:45.159502
Tags: affordability, affordable-housing, housing, housing-units

Tables

Table 1

@usgov.city_of_austin_affordable_housing_inventory_6038a.table_1

200.69 kB
2,376 rows
52 columns

CREATE TABLE table_1 (
  "contract_id" BIGINT,
  "project_id" BIGINT,
  "project_name" VARCHAR,
  "ownership" VARCHAR,
  "developer" VARCHAR,
  "address" VARCHAR,
  "zip" DOUBLE,
  "parcel_id" VARCHAR,
  "council_district" VARCHAR,
  "unit_type" VARCHAR,
  "housing_tenure" VARCHAR,
  "development_status" VARCHAR,
  "total_units" BIGINT,
  "affordable_units" BIGINT,
  "total_ada_units" DOUBLE,
  "psh_units" BIGINT,
  "mfi_20" BIGINT,
  "mfi_30" BIGINT,
  "mfi_40" BIGINT,
  "mfi_50" BIGINT,
  "mfi_60" BIGINT,
  "mfi_65" BIGINT,
  "mfi_70" BIGINT,
  "mfi_80" BIGINT,
  "mfi_100" BIGINT,
  "mfi_120" BIGINT,
  "affordability_start_date" VARCHAR,
  "affordability_expiration_date" VARCHAR,
  "affordability_period" DOUBLE,
  "fil_status" VARCHAR,
  "cal_fil" DOUBLE,
  "date_fil_recorded" VARCHAR,
  "hda" VARCHAR,
  "private_activity_bonds" VARCHAR,
  "affordability_unlocked" VARCHAR,
  "smart" VARCHAR,
  "dev_agreement" VARCHAR,
  "density_bonus" VARCHAR,
  "fil" VARCHAR,
  "lihtc" VARCHAR,
  "go_bonds_2006" DOUBLE,
  "go_bonds_2013" DOUBLE,
  "go_bonds_2018" DOUBLE,
  "go_bonds_2022" DOUBLE,
  "cdbg" DOUBLE,
  "cip_funds" DOUBLE,
  "home" DOUBLE,
  "htf" DOUBLE,
  "project_connect" DOUBLE,
  "city_subsidy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);