American Housing Survey National Cleaned Version

American Housing Survey (AHS)

@kaggle.egenaz_american_housing_survey_national_cleaned_version

Table List

1 table(501.68 KB)

National

@kaggle.egenaz_american_housing_survey_national_cleaned_version.national

501.68 KB
35243 rows
22 columns

degree DEGREE	metro3 METRO3	division DIVISION	per PER	zadult ZADULT	zinc2 ZINC2	zsmhc ZSMHC	elder ELDER	dish DISH	cook COOK	built BUILT	buyi BUYI	garage GARAGE	busper BUSPER	condo CONDO	value VALUE	hlth HLTH	date DATE	cellar CELLAR	fplwk FPLWK	hhgrad HHGRAD	type TYPE
Cold	MSA, rural	Middle Atlantic						Yes	Yes	2006	nan	Yes		Condo	200000	nan	Mon Oct 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Crawl space	Yes	nan	House, apartment, flat
Cold	MSA, rural	Middle Atlantic	2	2	36200	662	2	Yes	Yes	2006	Yes	Yes		Condo	222000	Very Good	Thu Sep 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Basement under all of the house	Yes	High school graduate	House, apartment, flat
Cool	Non-MSA, rural	South Atlantic & East South Central						No	Yes	1980	nan	No		Not Condo	120000	nan	Wed Aug 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Crawl space	No	nan	House, apartment, flat
Cool	Non-MSA, rural	South Atlantic & East South Central	1	1	44982	1000		Yes	Yes	1980	Yes	Yes		Not Condo	125000	Very Good	Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Basement under all of the house	Yes	Some college but no degree	House, apartment, flat
Cool	Non-MSA, rural	South Atlantic & East South Central						Yes	Yes	2007	nan	No		Not Condo	110000	nan	Mon Sep 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Basement under part of the house	Yes	nan	House, apartment, flat
Cool	Non-MSA, rural	South Atlantic & East South Central	2	2	36781	1154	2	Yes	Yes	1985	Yes	Yes		Not Condo	250000	Fair	Wed Aug 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Basement under all of the house	No	High school graduate	House, apartment, flat
Mild	Central MSA city	South Atlantic & East South Central	3	2	57446	1286		Yes	Yes	1985	Yes	Yes		Not Condo	169000	Excellent	Thu Aug 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Crawl space	No	Associate degree in occupational program	House, apartment, flat
Mild	Non-MSA, rural	Mountain & Pacific	2	2	129964	1293		Yes	Yes	1985	Yes	Yes		Not Condo	140000	Very Good	Mon Sep 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	On a concrete slab	Yes	Associate degree in occupational program	House, apartment, flat
Cool	Non-MSA, rural	South Atlantic & East South Central	2	2	258664	1454		Yes	Yes	1985	Yes	Yes		Not Condo	225000	Very Good	Sat Aug 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Crawl space	No	Associate degree in occupational program	House, apartment, flat
Cool	MSA, rural	West North Central	2	2	396551	1355		Yes	Yes	2007	Yes	Yes	1	Not Condo	300000	Very Good	Fri Oct 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	On a concrete slab	Yes	Bachelor's degree	House, apartment, flat


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
);