Hello, so for an analysis project I am trying to get the number of households in the US by state as an Excel file, and then further organize these data by the type of household (e.g. single-family, multi-family, apartment, etc.), and then then further organize these state-level counts by the type of heating-cooling equipment used in the household. I am having a tough time trying to get this accomplished though, as I don’t know how to actually just retrieve the data columns I want.
I am looking at the US Census Bureau website, and specifically the American Housing Survey (AHS) section:
https://www.census.gov/programs-surveys/ahs.html
I am specifically trying to use the AHS Table Creator tool to get the columns I want:
https://www.census.gov/programs-surveys/ahs/data/interactive/ahstablecreator.html?s_areas=00000&s_year=2021&s_tablename=TABLE1&s_bygroup1=1&s_bygroup2=1&s_filtergroup1=1&s_filtergroup2=1
However, I only see limited States actually offered, and am not sure how to get the other columns I want. Organizing this data to get the data I need is really confusing me, and I would appreciate any help on how I can accomplish this if anyone knows! Thanks!
submitted by /u/teledude_22
[link] [comments]
