About this Dataset

Housing Finance Agency Portfolio

The DC Housing Finance Agency is the financial intermediary and administrator of affordable housing programs and resources for the District of Columbia. Through its Multifamily Lending and Neighborhood Investment and Capital Markets divisions, DCHFA issues tax-exempt mortgage revenue bonds to lower the developers’ costs of acquiring, constructing and rehabilitating rental housing. The Agency offers private for-profit and non-profit developers low-cost predevelopment, construction and permanent financing that supports the new construction, acquisition, and rehabilitation of affordable rental housing in the District. DCHFA’s Single Family Programs division creates homeownership opportunities in the District by providing low-cost single family mortgages and down payment assistance, made possible through the issuance of mortgage-backed securities.
Organization: District of Columbia
Last updated: 2024-04-30T19:13:25.102225
Tags: affordable-housing, dchfa, district-of-columbia, housing-finance, rental-housing, washington-dc

Tables

Table 1

@usgov.district_of_columbia_housing_finance_agency_portfolio.table_1

72.62 kB
216 rows
33 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "projects" VARCHAR,
  "ward" VARCHAR,
  "units" DOUBLE,
  "year_built" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "management_company" VARCHAR,
  "property_manager_contact" VARCHAR,
  "sponsored_by" VARCHAR,
  "sponsory_contact" VARCHAR,
  "bondholder" VARCHAR,
  "loan_status_bonds_redeemed_active_recently_converted" VARCHAR  -- Loan Status (Bonds Redeemed / Active / Recently Converted),
  "risk_share_non_risk_share" VARCHAR  -- Risk Share / Non Risk Share,
  "renovation_new_construction_year" VARCHAR  -- Renovation / New Construction Year,
  "building_type" VARCHAR,
  "construction_type" VARCHAR,
  "occupancy_type" VARCHAR,
  "subsidized_programs" VARCHAR,
  "loan_closing_date" VARCHAR,
  "original_loan_balance" DOUBLE,
  "maturity_date" VARCHAR,
  "compliance_period_end_date" VARCHAR,
  "asset_manager" VARCHAR,
  "mar_latitude" DOUBLE,
  "mar_longitude" DOUBLE,
  "marid" DOUBLE,
  "globalid" VARCHAR,
  "editdate" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);