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…
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 presented at the county subdivision level, it represents the MSA/non-MSA data. https://www.huduser.gov/portal/datasets/il.html#2013. It looks to me like the 2013 HUD data is based on 2010 ACS data.
Thanks Bernie, works perfectly for my use case.