Dataset: AHS 2011 National Public Use File

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

201.8 MB
61003 rows
3073 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
);