American Community Survey Attributes

Snowflake table name : CYBERSYN.AMERICAN_COMMUNITY_SURVEY_ATTRIBUTES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
VARIABLE	Unique identifier for a variable, joinable to the timeseries table.	VARCHAR	B24123_476E_5YR_2012
VARIABLE_NAME	Human-readable name for the variable.	VARCHAR	Sex By Work Experience In The Past 12 Months By Earnings In The ...
SERIES_ID	Unique ACS identifier for the subject of the ACS variable.	VARCHAR	B24123
CENSUS_SUBJECT	ACS high-level description for the subject/category of the variable.	VARCHAR	Industry, Occupation, and Class of Worker
SERIES_TYPE	ACS detailed description for the subject/category of the variable.	VARCHAR	Sex By Work Experience In The Past 12 Months By Earnings In The ...
RACE	Associated race with the population variable.	VARCHAR	American Indian and Alaska Native Alone
SERIES_LEVEL_1	First characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	Female
SERIES_LEVEL_2	Second characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	Other
SERIES_LEVEL_3	Third characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	With earnings
SERIES_LEVEL_4	Fourth characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	Householder 35 to 44 years (dollars)
SERIES_LEVEL_5	Fifth characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	Naturalized U.S. citizen
SERIES_LEVEL_6	Sixth characteristic that makes up a variable, specific to a series ID, helpful for comparison across variables within a series (if available).	VARCHAR	Employed or in Armed Forces
MEASURE	Quantifiable attribute; description of what is being recorded.	VARCHAR	Population
UNIT	Unit of measurement for the reported value.	VARCHAR	Count
FREQUENCY	Frequency of aggregations.	VARCHAR	Annual
MEASUREMENT_TYPE	Measurement classification of the variable (ex. estimate, margin of error).	VARCHAR	Margin of Error
MEASUREMENT_PERIOD	Data collection period for the variable (ex. 1YR or 5 YR).	VARCHAR	5YR