American Community Survey Attributes

Snowflake table name : CYBERSYN.AMERICAN_COMMUNITY_SURVEY_ATTRIBUTES

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

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

Last updated

Copyright © 2024 Cybersyn