Does anyone have a list of variable names that would help me identify the median age, sex of population (in percent), median household income, and race (in percentages) for each state from 2010-2019 (or even earlier if that is possible)? There are a lot of variable names, and I wanted to check this forum to see if there were a few that were predominantly used in research. If there are any other important state level variables you would suggest to use, that would also be greatly appreciated.
Thanks for any support you may provide! For reference, I and querying the API using tidycensus.
I find the Census Reporter topic documentation to be really useful for this. Here, for example, is their income topic that describes the different income-related variables in ACS and when you might choose…
No to state the obvious, but the ACS Table Shells workbook is worth perusing. https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html
This is the complete codebook for the…
B01002_001E Should be median age
Adam, thanks for your response! I think I am starting to understand how these variables are grouped. MEDIAN AGE BY SEX Total, is total median age for both sexes combined. This is making more sense.
This is true for most of the ACS tables, they are often broken down by an additional variable and have to be aggregated to create a desired analysis table.
To take your example, searching for "Median Age" led me to table B01002, "Median Age by Sex":
This gives you a median age value for the entire population for a given geography (B01002_001) along with the breakdown by sex. In some cases, such as Table B01001, you have to add variables together to get a total. For example, to get the total number of children under 5, you need to add B01001_003E + B01001_027E. You also have to calculate a revised margin of error --Look in the technical docs to see how to do this.
Unfortunately, THERE IS NO WAY AROUND THIS TYPE OF DATA PROCESSING. Learning how to manipulate the table cells published by the Census Bureau is an essential skill.
Good luck with your project.