I need to produce the MSA/MD statewide & non-MSA/MD Median Family Income at the census tract level (for all tracts in the US) using the ACS 5Y 2010 estimates.
More precisely, I need to get the Median Family Income for the MSA/MD in which each tract is located. If the tract is not in a MSA/MD, this Median Family Income needs to be for all portions of the state not in MSA/MDs. The values for MSA/MD statewide non-MSA/MD Median Family Income need to originate from the U.S. Census Bureau's 2010 ACS 5 year estimates.
Any help on how to proceed will be much appreciated.
Hey, how about HUD Income Limits? This data, which is derived through ACS, has Median Family Income at the county subdivision level, which nests within MSAs (and non-MSAs). And even though the data is…
How about something like this:https://data.census.gov/cedsci/table?q=median&t=Income%20%28Households,%20Families,%20Individuals%29&g=0100000US.310000_04000G0US01&y=2010&d=ACS%205-Year%20Estimates%20Detailed…
Interestingly, "Area Outside of Metro/Micro Statistical Areas (or part)" is an available geography, but it doesn't seem to have available data for ACS. Perhaps it is available but just isn't working right…
How about something like this:https://data.census.gov/cedsci/table?q=median&t=Income%20%28Households,%20Families,%20Individuals%29&g=0100000US.310000_04000G0US01&y=2010&d=ACS%205-Year%20Estimates%20Detailed%20Tables&tid=ACSDT5Y2010.B19113&hidePreview=true
This gives MFI for all MSAs in the USA, plus MFI for all of Alabama not in MSAs, using geocomp. Unfortunately there doesn't seem to get that for all states at once, at least not in data.census.gov. You could use this, and then list all tracts within and without those areas and apply the MFIs to each. If I'm understanding you correctly.
Interestingly, "Area Outside of Metro/Micro Statistical Areas (or part)" is an available geography, but it doesn't seem to have available data for ACS. Perhaps it is available but just isn't working right?As an aside, it's frustrating that you can't search for "median family income" at data.census.gov and get a relevant result. That seems like a pretty basic search. In fact, if I filter my search for ACS 5-year detailed tables, if I just search for "family income", it returns no results.
yeah I had to search for "median" alone. Good times.
I also ended up frustated when I saw this before posting... If that box worked, there would have been no need for the post. Thanks Bernie!