Name: AHS 2011 National Public Use File
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

AHS 2011 National Public Use File

Source: https://www.census.gov/programs-surveys/ahs/data/2011/ahs-2011-public-use-file-puf/ahs-2011-national-public-use-file-puf.html
Further explanation on columns: https://www.census.gov/data-tools/demo/codebook/ahs/ahsdict.html?s_keyword=&s_year=&sortby=

The AHS is sponsored by the Department of Housing and Urban Development (HUD) and conducted by the U.S. Census Bureau. The survey is the most comprehensive national housing survey in the United States.

Tables

Ahs2011n

@kaggle.egenaz_ahs_2011_national_public_use_file.ahs2011n

211.6 MB
61,003 rows
3,073 columns

CREATE TABLE ahs2011n (
  "control" VARCHAR,
  "smsa" VARCHAR,
  "degree" VARCHAR,
  "metro3" VARCHAR,
  "region" VARCHAR,
  "lmed" BIGINT,
  "lmeda" BIGINT,
  "lmedb" BIGINT,
  "fmr" BIGINT,
  "fmra" BIGINT,
  "fmrb" BIGINT,
  "l30" BIGINT,
  "l50" BIGINT,
  "l80" BIGINT,
  "l30a" BIGINT,
  "l50a" BIGINT,
  "l80a" BIGINT,
  "l30b" BIGINT,
  "l50b" BIGINT,
  "l80b" BIGINT,
  "ipov" VARCHAR,
  "histry" VARCHAR,
  "cmsa" VARCHAR,
  "division" VARCHAR,
  "lodg" BIGINT,
  "per" BIGINT,
  "zadult" BIGINT,
  "zinc" BIGINT,
  "zinc2" BIGINT,
  "phone" VARCHAR,
  "kitchen" VARCHAR,
  "plumb" VARCHAR,
  "zadeq" VARCHAR,
  "zsmhc" BIGINT,
  "amtx" VARCHAR,
  "nummor" BIGINT,
  "ran" BIGINT,
  "rac" BIGINT,
  "hkran" BIGINT,
  "hkrac" VARCHAR,
  "vother" BIGINT,
  "vother2" BIGINT,
  "mobiltyp" VARCHAR,
  "qself" VARCHAR,
  "qss" VARCHAR,
  "qssi" VARCHAR,
  "qwelf" VARCHAR,
  "qretir" VARCHAR,
  "qwkcmp" VARCHAR,
  "samehh2" VARCHAR,
  "jvother" VARCHAR,
  "jvother2" VARCHAR,
  "qint" VARCHAR,
  "qdiv" VARCHAR,
  "qrent" VARCHAR,
  "qother" VARCHAR,
  "qalim" VARCHAR,
  "jqint" VARCHAR,
  "jqdiv" VARCHAR,
  "jqrent" VARCHAR,
  "jqother" VARCHAR,
  "jqalim" VARCHAR,
  "jqself" VARCHAR,
  "jqretir" VARCHAR,
  "jqss" VARCHAR,
  "jqwelf" VARCHAR,
  "jqssi" VARCHAR,
  "jqwkcmp" VARCHAR,
  "status" VARCHAR,
  "none" VARCHAR,
  "winteroven" VARCHAR,
  "winterkesp" VARCHAR,
  "winterelsp" VARCHAR,
  "winterwood" VARCHAR,
  "winternone" VARCHAR,
  "moldkitch" VARCHAR,
  "moldbath" VARCHAR,
  "moldbedrm" VARCHAR,
  "moldlroom" VARCHAR,
  "moldbasem" VARCHAR,
  "moldother" VARCHAR,
  "jhmelevte" VARCHAR,
  "jhmentbd" VARCHAR,
  "jhmentbth" VARCHAR,
  "jhmtoilet" VARCHAR,
  "jhmswitch" VARCHAR,
  "jhmclctrl" VARCHAR,
  "hhear" VARCHAR,
  "hsee" VARCHAR,
  "hmemry" VARCHAR,
  "hwalk" VARCHAR,
  "hcare" VARCHAR,
  "herrnd" VARCHAR,
  "hdsb" VARCHAR,
  "hmwheeln" BIGINT,
  "hkcab" VARCHAR,
  "hcab" VARCHAR,
  "hstov" VARCHAR,
  "hctruse" VARCHAR,
  "hgetbr" VARCHAR
);