About this Dataset

Subsidized Housing

This database includes the quantity of units available for individual programs and whether they are designated for seniors or families. Construction dates are also included where available. Twenty records are not geocoded because their addresses are not valid or they do not have specific addresses. In addition, records with multiple, unlisted locations were not geocoded. For individual programs, unit quantities are not mutually exclusive. According to Paul Bursley at MSHDA, in 2011, the database was last updated in 2009.

Metadata are available here.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:59:52.272864
Tags: detroit, genesee-county, housing, hud, lapeer-county, livingston-county, macomb-county, monroe-county, mshda, oakland-county, property-land-use-and-housing, public-housing, southeast-michigan, st-clair-county, subsidized, washtenaw-county, wayne-county

Tables

Table 1

@usgov.city_of_ferndale_michigan_subsidized_housing_44f3c.table_1

91.56 KB
709 rows
41 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "county" VARCHAR,
  "phone" VARCHAR,
  "admin" VARCHAR,
  "first_buil" BIGINT,
  "last_built" BIGINT,
  "age" DOUBLE,
  "mshda" BIGINT,
  "lihtc" BIGINT,
  "market" BIGINT,
  "rap" BIGINT,
  "sec_515_un" BIGINT,
  "sec_202_un" BIGINT,
  "barrier_fr" BIGINT,
  "rehab_choi" BIGINT,
  "public_hsg" BIGINT,
  "sec_221d3" BIGINT,
  "sec_236_un" BIGINT,
  "sec_8_unit" BIGINT,
  "rs_units" BIGINT,
  "special_hs" BIGINT,
  "eld_eff" BIGINT,
  "eld_1br" BIGINT,
  "eld_2br" BIGINT,
  "eld_3br" BIGINT,
  "eld_4br" BIGINT,
  "eld_tot" BIGINT,
  "fam_eff" BIGINT,
  "fam_1br" BIGINT,
  "fam_2br" BIGINT,
  "fam_3br" BIGINT,
  "fam_4br" BIGINT,
  "fam_tot" BIGINT
);