{"id":24051,"date":"2023-11-19T19:27:09","date_gmt":"2023-11-19T18:27:09","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/how-can-i-pull-housing-type-counts-by-state-from-us-census-data\/"},"modified":"2023-11-19T19:27:09","modified_gmt":"2023-11-19T18:27:09","slug":"how-can-i-pull-housing-type-counts-by-state-from-us-census-data","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/how-can-i-pull-housing-type-counts-by-state-from-us-census-data\/","title":{"rendered":"How Can I Pull Housing Type Counts By State From US Census Data?"},"content":{"rendered":"

<\/p>\n

\n

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<\/a>
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<\/a>
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!<\/p>\n<\/div>\n

submitted by \/u\/teledude_22 <\/a>
[link]<\/a><\/span> [comments]<\/a><\/span><\/p>