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	B24022_043M_1YR_2016
VARIABLE_NAME	Human-readable name for the variable.	VARCHAR	Detailed Occupation By Median Earnings In The Past 12 Months (In...
SERIES_ID	Unique ACS identifier for the subject of the ACS variable.	VARCHAR	B19037F
CENSUS_SUBJECT	ACS high-level description for the subject/category of the variable.	VARCHAR	Earnings
SERIES_TYPE	ACS detailed description for the subject/category of the variable.	VARCHAR	Detailed Occupation By Median Earnings In The Past 12 Months (In...
RACE	Associated race with the population variable.	VARCHAR	Two or More Races
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	Householder 45 to 64 years
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	American Indian and Alaska Native alone
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	Income in the past 12 months at or above poverty level
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	6 to 17 years only
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	Computer and information research scientists and analysts, and i...
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	Estimate
MEASUREMENT_PERIOD	Data collection period for the variable (ex. 1YR or 5 YR).	VARCHAR	5YR