FHFA Uniform Appraisal Attributes

Snowflake table name : CYBERSYN.FHFA_UNIFORM_APPRAISAL_ATTRIBUTES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
VARIABLE	A unique identifier for a variable joinable to the timeseries table for filtering	VARCHAR	Quarterly_Mean_Comps_Range_Percent_(settled_sales_only)_New_Cons...
VARIABLE_NAME	Human-readable description for the variable	VARCHAR	Quarterly Mean Comps Range Percent (settled sales only) New Cons...
VARIABLE_GROUP	Overall variable grouping for the timeseries (e.g., Median Appraised Value, Count of Appraisals, etc.)	VARCHAR	Mean Comps Range Percent (settled sales only)
APPRAISAL_PURPOSE	Reason for appraisal request (e.g., Purchase, Refinance, Purchase & Refinance)	VARCHAR	Purchase
CHARACTERISTIC	Characteristic for category grouping based on home features (e.g., Central Air, Type of Foundation, etc)	VARCHAR	New Construction Status
CATEGORY	Actual category corresponding to the characteristic type. Notes important features of home (e.g. No Central Air, built between 1970 to 1979, etc.)	VARCHAR	Missing
UNIT	Unit of measure for the variable: (e.g., Count, Percent, Ratio, USD)	VARCHAR	Percent
FREQUENCY	Frequency of aggregations (e.g. Annual).	VARCHAR	Quarterly