About this Dataset

Affordable Housing

Affordable housing production and preservation projects are managed by the Department of Housing and Community Development (DHCD), the Deputy Mayor for Planning and Economic Development (DMPED), the DC Housing Authority, the DC Housing Finance Agency and DC's Inclusionary Zoning program. This dataset comprehensively covers affordable housing projects which started (i.e. reached financial closing and/or started construction) or completed since January of 2015. The data includes affordable housing projects (production and preservation, rental and for-sale) which were subsidized by DMPED, DHCD, DCHFA, or DCHA, and those which were produced as a result of Planned Unit Development (PUD) proffers or Inclusionary Zoning (IZ) requirements.
Organization: District of Columbia
Last updated: 2024-04-30T18:43:47.531139
Tags: affordable-housing-preservation-production, ami, business, community, dhcd, dmped, finance, housing, inclusion, mfi, planning, public-service

Tables

Table 1

@usgov.district_of_columbia_affordable_housing.table_1

122.67 kB
924 rows
22 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mar_ward" VARCHAR,
  "address" VARCHAR,
  "project_name" VARCHAR,
  "status_public" VARCHAR,
  "agency_calculated" VARCHAR,
  "total_affordable_units" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "affordable_units_at_0_30_ami" BIGINT,
  "affordable_units_at_31_50_ami" BIGINT,
  "affordable_units_at_51_60_ami" BIGINT,
  "affordable_units_at_61_80_ami" BIGINT,
  "affordable_units_at_81_ami" BIGINT,
  "case_id" VARCHAR,
  "mar_id" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "fulladdress" VARCHAR,
  "gis_last_mod_dttm" TIMESTAMP
);