I'm trying to get detailed data on languages spoken at home to do an LEP study. I'm able to get the data by PUMA; however, my city is lumped in with two other cities, with no way to segregate them.
Is there some other way to do this? We're on the hook for non-English language support but can't get granular-enough data to figure out which languages we have to service. Thanks in advance.
For city (sumlevel 160) and tracts (sum level 140), have you looked at table C16001 ? There're nine non-English languages listed
Grid View: Table C16001 - Census ReporterWhy just nine languages?
About…
Hi,
ACS Table B16002 provides detailed language data at the household level.
Data is available for municipalities and Census Tracts. You may need to isolate the tracts in your city and then aggregate them…
Perhaps whoever wrote the law should have checked what's actually available in the ACS before the law was passed.
I get difficult-to-answer questions like this a lot.
If you're able to get the data by PUMA, you could do an allocation to the place level using Geocorr.
https://mcdc.missouri.edu/applications/geocorr.html
Table B16007 has gross language categories by age for persons over age 5. (Spanish, Other Indo-European, Asain, and Other)
You will not be able to get detailed languages from this table. If you need to drill down to specific language groups, allocating things from the PUMS is probably your best bet, per Glenn Rice
BTW, ALL of this information is available from the ACS table shells (https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html) You may wish to become familiar with this document.
Cheers--
AB