ACS Data Users Group

Hi,

I'm struggling to find what I thought would be a simple data set:

List of US Counties (County) with AMI for each county (optional with US Census Tract ID)

Nice to have: List of US Counties with Targeted Area Designation (Yes or No)

I have the tareted area dataset for Maryland, but hoping to find the resource to get the data at the national level: data.imap.maryland.gov/.../data

Have you tried data.census.gov?

https://data.census.gov/cedsci/table?q=median%20income&t=Income%20and%20Poverty&g=0100000US.050000&d=ACS%205-Year%20Estimates%20Detailed%20Tables&tid=ACSDT5Y2019.B19113&hidePreview=false

Hi Glenn - Thank you. This is a good start. I guess the issue for me is getting the latest available data (2020) that is more current and by HUD to determine income limits for housing programs, all derived from AMI. This data is estimate for 2019 using a 5-year average I think so it won't be as accurate.

Alberto, just so you're aware, there is no data more recent than 2019 (and no census tract data more recent than the 5-year 2015-2019). The HUD data suggested to you in the other thread uses a variety of previous years (focusing on 2013-2017 data according to their methodology https://www.huduser.gov/portal/datasets/il/il2020/2020MedCalc.odn). In other words, it's a 2020 HUD release of older Census ACS data. I do think that's indeed what you want, I just wanted to clarify (and also point out that if you needed it for some reason, there is more current data than what's contained in the HUD income limits data).

It’s tricky. Looking for data to match this, for example, in DC:

This might be of help to you, if you're trying to find the Section 8 income limits. https://github.com/BPSTechServices/income-analysis/blob/main/data/resources/limits_2000t2020.csv You just have to apply coefficients to adjust for household size. See page 22 of this PDF: http://www.commerce.wa.gov/wp-content/uploads/2016/10/AHAB-Housing-Needs-Appendices.pdf

I need to confirm if the limits used for home purchase limits are from the same Section 8 table, they may or may not be the same.

I don't know what you mean by home purchase limits.

The Area Median Incomes are based upon households of 1 to 8 persons and are published annually by HUD for designated Areas. They are then used for pegging Income Limits for housing subsidies.

Here is the latest release: https://www.huduser.gov/portal/datasets/il.html

The income limits are from a special run the the Census Bureau makes for HUD. They are based upon the income of a four person household and then are adjusted from their for household size.

The areas are defined by HUD, but usually are counties or an assemblage of counties.

Andy

Yes, this is closer to the data I need. acsdatacommunity.prb.org/.../income_2D00_and_2D00_purchase_2D00_limits.pdf

At the County Level, mapping out the Income Limits for each household size. Various programs use different tools to show qualifications, building a tool to standardize this information so that it shows: County, County AMI, Purchase Limits for Household Sizes 1 - 8

The AMI tries to harmonize the limits with the household size. This is not done in any Census file directly. The AMI are used for purchases and rentals for the LIHTC Low Income Housing Tax Credit program, some of which can lead to purchases,. But they are used to set income banks: Under 30%, 30 to 50% 50 to 80% called extremely, very and low income, and are also used for moderate income 95%, and sometimes limits are set above 100%.

Yes, thank you Andrew! The FY Income Limits data is exactly what I need for half of the problem: https://www.huduser.gov/portal/datasets/il.html#2020_data

This data helps capture the AMI at the county level and is updated annually. I can then use the 30%, 50% and 80% AMI or build calculated fields based on the AMI at the county level.

My next challenge is to pull together the areas designated as "Targeted Areas" by County. I located this Maryland file that has the list by County laid out perfectly. But rather than finding the state file, I want to find a US file by County to get a Yes indicator for all Counties designated "Targeted Area"

data.imap.maryland.gov/.../geoservice