Master Table
Last updated
Last updated
| 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