Hello, I was expecting to be able to get to the county level using the 5Yr PUMS data, but found it is still only by PUMAs. Yes, I can convert the PUMAs to counties, but some counties are too small and are grouped. The tables don't work for me as I need a different poverty level than just "Below Poverty Level"
I'm looking to get poverty levels of 165% FPL, 185%FPL, and 200% FPL by race and a few other variables
Any ideas?
Glenn is correct. NHGIS and Social Explorer redistribute the published ACS Detailed Tables (i.e., Summary File) data. I don't know of published ACS tables that cross-tabulate poverty ratio by race. In…
Jonathan Schroeder said:this approach makes the assumption that there is no variation in poverty/race correspondences among counties within a PUMA.
Right, this is a very simple method for estimation. I…
I keep to standard ACS-5 data and I do everything by county, however I do have all counties by poverty by age for every county at ( https://public.tableau.com/app/profile/tom.lahey/viz/ACS-5/Menu ) It might help a bit. You could also pull the county by race and match. It wont tell you which race for poverty rate, but give you the county profile overall. I know B17020 has poverty by race (not sure has levels), but again its standard ACS-5. I'm not a census person, but think you can rock 95% with standard ACS-5 and get close enough to whatever your looking for in zero time. Then go deep if needed (PUMS etc.). AM also almost done with tool to better search ACS-5 data at ( https://tomlaheyh.github.io/Census-ACS-5-data/ ).