American Housing Survey National Cleaned Version
American Housing Survey (AHS)
@kaggle.egenaz_american_housing_survey_national_cleaned_version
American Housing Survey (AHS)
@kaggle.egenaz_american_housing_survey_national_cleaned_version
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.
CREATE TABLE national (
"degree" VARCHAR,
"metro3" VARCHAR,
"division" VARCHAR,
"per" DOUBLE,
"zadult" DOUBLE,
"zinc2" DOUBLE,
"zsmhc" DOUBLE,
"elder" DOUBLE,
"dish" VARCHAR,
"cook" VARCHAR,
"built" BIGINT,
"buyi" VARCHAR,
"garage" VARCHAR,
"busper" DOUBLE,
"condo" VARCHAR,
"value" BIGINT,
"hlth" VARCHAR,
"date" TIMESTAMP,
"cellar" VARCHAR,
"fplwk" VARCHAR,
"hhgrad" VARCHAR,
"type" VARCHAR
);
Anyone who has the link will be able to view this.