ACS Data Users Group

Hi all

I’m looking for housing costs as percent of household income, by race and ethnicity, at the state or county level, NYS.

S0201 has these rows

SELECTED MONTHLY OWNER COSTS AS A PERCENTAGE OF HOUSEHOLD INCOME IN THE PAST 12 MONTHS
Housing units with a mortgage (excluding units where SMOC cannot be computed)
Less than 30 percent
30 percent or more

At some point in the past, around 2015, I thought this table had data by race and ethnicity, but now it doesn’t. Is it possible that either I got the wrong table, or that the table changed?

Another table, b25070, is gross rent as percent of household income. Again, at some point in the past, around 2015, I thought this table also had data by race and ethnicity, but now it doesn’t. Is it possible that either I got the wrong table, or that the table changed?

Thanks

Gene

Dear Gene,

You might check out the American Housing Survey PUF data. I don't know if it has the geographies that you need. https://www.census.gov/programs-surveys/ahs/data/2021/ahs-2021-public-use-file--puf-.html

https://www.census.gov/programs-surveys/ahs/data/2021/ahs-2021-public-use-file--puf-.html

There is also the Supplemental Poverty Measure(SPM) PUMS files

https://www.census.gov/topics/income-poverty/supplemental-poverty-measure/data/datasets.html

The SPM file merges with the usual ACS PUMS files. It has housing cost and income data.

The SAS and STATA datasets t are for the entire US so it takes a bit of a memory to extract a single state.

www.census.gov/.../acs-research-files.html

I have an R program that I am working on that uses Small Area Estimation to get the SPM variables at the census tract level. You can then reaggregate to the county and state level.

Dave

Hi David. Thanks, I'm working my way through your resources.

Hi Gene, if you haven't heard of the HUD CHAS (US Housing and Urban Development/ Comprehensive Housing Affordability Strategy) )data, there's more info here: CHAS: Background | HUD USER

It's a special run of the ACS data done by HUD, it usually lags behind release of standard ACS, (latest release is from the 2015-2019 ACS) but has the detailed data by race/ethnicity that you are interested in.

The query tool is pretty easy to use and is available at many geographic levels including state and county here:

Consolidated Planning/CHAS Data | HUD USER

It breaks out housing costs by race/ethnicity, by renter and owner and more. Hope it helps!

Tina

Hi Tina. Thanks very much. This looks interesting. Does this have data by race and ethnicity? It looks like it's just totals for the state.

Thanks.

Gene.

Dear Gene,

I would take Tina's suggestion and check out the HUD custom tabulations. I am aware of them but I didn't think of that. I don't know what geographies they have but I'm sure they have states and maybe counties.

https://www.census.gov/programs-surveys/acs/data/custom-tables.html

list of custom tabulations

https://www.census.gov/about/policies/foia/foia_library/custom_tabulations.html

I can't find the custom tabulations that HUD has requested. Try emailing ASCO

acso.users.support@census.gov

I just looked at the HUD website page https://www.huduser.gov/portal/datasets/cp.html

and they seem to say that the most recent data does not have the race/ethnic breakdown. That put you back to using PUMA level data and the SPM micro data.

Dave

CHAS data includes race and ethnicity groups and some tables are available down to the tract level. Tract data is not available through the online tool; for that you need to download the data.