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…
Dear LornaBea,
I have a program that will do this. I worked on this problem for the Commonwealth of Virginia where they had the same issue. This basic idea is to start with PUMA level data and make an adjustment based on tract level B S D C tables. This method makes an adjustment that is more advanced than adjusting using the GeoCorr factor variables. You can cross tabulate using any PUMS variable such as Race. The Poverty ratio PUMS variable can be cut at any poverty level you like. If you work for a government entity or 501(c)(3) a consult is free.
Dave Dorer
info@dorerfoundation.org