Master Table

COLUMN ID	COLUMN DESCRIPTION	DATA TYPE	DATA REPRESENTATION	GROUP NAME	SOURCE NAME
ZIP_CODE	US Zip Code	TEXT	TEXT	UNIVERSE	ATERIO
CITY_NAME	City name	TEXT	TEXT	UNIVERSE	ATERIO
COUNTY_NAME	County name	TEXT	TEXT	UNIVERSE	ATERIO
COUNTY_FIPS_CODE	Federal Information Processing Standards (FIPS) code for counties	TEXT	TEXT	UNIVERSE	ATERIO
STATE_CODE	State code	TEXT	TEXT	UNIVERSE	ATERIO
ATERIO_UNIQUE_ID	Aterio Unique ID for the record	TEXT	OTHER	UNIVERSE	ATERIO
LOCATION_LATITUDE	Latitude coordinate location	FLOAT	OTHER	UNIVERSE	CENSUS
LOCATION_LONGITUDE	Longitude coordinate location	FLOAT	OTHER	UNIVERSE	CENSUS
AREA_LAND_SQ_MI	Land area in square miles	FLOAT	OTHER	UNIVERSE	CENSUS
AREA_WATER_SQ_MI	Water area in square miles	FLOAT	OTHER	UNIVERSE	CENSUS
CBSA_CODE	Core-based Statistical Area Code	TEXT	OTHER	UNIVERSE	CENSUS
CBSA_TITLE	Core-based Statistical Area Title	TEXT	OTHER	UNIVERSE	CENSUS
STATISTICAL_AREA_TYPE_NAME	Type of CBSA (Metropolitan Statistical Area or Micropolitan Statistical Area)	TEXT	OTHER	UNIVERSE	CENSUS
PLACE_FIPS_CODE	City FIPS Code	TEXT	OTHER	UNIVERSE	CENSUS
TOT_CENSUS_POP_2010	Population count for Census year 2010	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2011	Population count for Census year 2011	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2012	Population count for Census year 2012	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2013	Population count for Census year 2013	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2014	Population count for Census year 2014	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2015	Population count for Census year 2015	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2016	Population count for Census year 2016	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2017	Population count for Census year 2017	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2018	Population count for Census year 2018	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2019	Population count for Census year 2019	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2020	Population count for Census year 2020	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2021	Population count for Census year 2021	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_CENSUS_POP_2022	Population count for Census year 2022	NUMBER	QUANTITY	POPULATION & MIGRATION	CENSUS
TOT_FX_POP_2023	Forecasted population for the year 2023	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2024	Forecasted population for the year 2024	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2025	Forecasted population for the year 2025	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2026	Forecasted population for the year 2026	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2027	Forecasted population for the year 2027	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2028	Forecasted population for the year 2028	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2029	Forecasted population for the year 2029	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_FX_POP_2030	Forecasted population for the year 2030	NUMBER	QUANTITY	POPULATION & MIGRATION	ATERIO
TOT_HOME_AVAILABLE_2020	Total available homes in 2020	NUMBER	QUANTITY	DEMAND AND SUPPLY	ATERIO
TOT_HOME_AVAILABLE_2021	Total available homes in 2021	NUMBER	QUANTITY	DEMAND AND SUPPLY	ATERIO
AVG_PEOPLE_PER_HOME	Average number of people per home	NUMBER	QUANTITY	DEMAND AND SUPPLY	ATERIO
EST_TOTAL_HOME_DEMAND_2030	Estimated demand for homes in 2030 based on population forecast for 2030	NUMBER	QUANTITY	DEMAND AND SUPPLY	ATERIO
TOT_BALANCE_INVENTORY	Total homes needed to meet demand in year 2030. (2030 Inventory - 2020 Inventory = Homes needed to fulfill demand)	NUMBER	QUANTITY	DEMAND AND SUPPLY	ATERIO
IDX_DEMAND_SUPPLY	Index evaluating demand and supply factors	NUMBER	INDEX	DEMAND AND SUPPLY	ATERIO
IDX_CAPACITY_PAY	Index gauging capacity to pay	NUMBER	INDEX	CAPACITY TO PAY	ATERIO
IDX_AFFORDABILITY	Index indicating housing affordability	FLOAT	INDEX	CAPACITY TO PAY	ATERIO
AVG_HOUSEHOLD_INCOME_2021	US Annual average household income reported in 2021	NUMBER	CURRENCY	CAPACITY TO PAY	CENSUS
PCT_HOUSEHOLD_INCOME_100K_200K_2020	Percentage household debt-to-income $100K-$200K in 2020	FLOAT	PERCENTAGE	CAPACITY TO PAY	IRS
PCT_HOUSEHOLD_INCOME_50K_75K_2020	Percentage household debt-to-income $50K-$75K in 2020	FLOAT	PERCENTAGE	CAPACITY TO PAY	IRS
PCT_HOUSEHOLD_INCOME_75K_100K_2020	Percentage household debt-to-income $75K-$100K in 2020	FLOAT	PERCENTAGE	CAPACITY TO PAY	IRS
PCT_HOUSEHOLD_INCOME_ABOVE_200K_2020	Percentage household debt-to-income above $200K in 2020	FLOAT	PERCENTAGE	CAPACITY TO PAY	IRS
PCT_HOUSEHOLD_INCOME_BELOW_50K_2020	Percentage household debt-to-income below $50K in 2020	FLOAT	PERCENTAGE	CAPACITY TO PAY	IRS
IDX_ECONOMIC_DEV	Index assessing economic development	NUMBER	INDEX	ECONOMIC DEVELOPMENT	ATERIO
AVG_RT_UNEMPLOYMENT_COUNTY_6M	Average county unemployment rate over the last 6 months	NUMBER	PERCENTAGE	RISK FACTORS	BLS
RT_DEFAULT_MORTGAGE_2019	Default mortgage rate in 2019	FLOAT	PERCENTAGE	RISK FACTORS	FEDERAL RESERVE
RT_DEFAULT_MORTGAGE_2020	Default mortgage rate in 2020	FLOAT	PERCENTAGE	RISK FACTORS	FEDERAL RESERVE
RT_DEFAULT_MORTGAGE_2021	Default mortgage rate in 2021	FLOAT	PERCENTAGE	RISK FACTORS	FEDERAL RESERVE
AVG_LISTING_PRICE_REALTOR	Average Listing Price from Realtor	NUMBER	CURRENCY	RISK FACTORS	REALTOR
HOME_VALUE_RSI_SCORE	Home value RSI (Relative Score Index)	FLOAT	INDEX	PRICING	ATERIO
HOME_VALUE_VOLATILITY_SCORE_L24M	Home value volatility score over last 24 months	FLOAT	INDEX	PRICING	ATERIO
AVG_LISTING_PRICE_REALTOR	Realtor's average listing price	NUMBER	CURRENCY	PRICING	REALTOR
MEDIAN_LISTING_PRICE_REALTOR	Realtor's median listing price	NUMBER	CURRENCY	PRICING	REALTOR
REALTOR_DEMAND_SCORE	Realtor's demand score	NUMBER	SCORE	PRICING	REALTOR
REALTOR_HOTNESS_SCORE	Realtor's hotness score	NUMBER	SCORE	PRICING	REALTOR
REALTOR_NIELSEN_HH_RANK	Realtor's nielsen score rank	NUMBER	OTHER	PRICING	REALTOR
REALTOR_SUPPLY_SCORE	Realtor's supply score	NUMBER	SCORE	PRICING	REALTOR
HOME_VALUE_INDEX_ZILLOW_12M	Home value index on Zillow 12 months ago	NUMBER	INDEX	PRICING	ZILLOW
HOME_VALUE_INDEX_ZILLOW_6M	Home value index on Zillow 6 months ago	NUMBER	INDEX	PRICING	ZILLOW
HOME_VALUE_INDEX_ZILLOW_LM	Home value index on Zillow last month.	FLOAT	INDEX	PRICING	ZILLOW
UPDATED_AT	Date of the last data update	TIMESTAMP_LTZ	TIMESTAMP	OTHER	ATERIO