Looking for Table C16002 HOUSEHOLD LANGUAGE BY HOUSEHOLD LIMITED ENGLISH SPEAKING STATUS

Hello Cliff, see if this link works for you:

https://data.census.gov/cedsci/table?text=C16002&hidePreview=true&tid=ACSDT5Y2018.C16002&g=0400000US25.140000&tp=true

I had to go into the Advanced search, type in the table ID and then hit Search. Click on "View All Tables (1)" in the results, then click "Customize Table" on the next screen.

There will be a drop-down menu labeled "Product" where you can select "2018:ACS 5-year estimates Detailed Tables". Now, click on the "Geography" icon & toggle on "Show Summary Levels". Scroll down to select 140 - Tract, then select your state, and then click the box for "All Census tracts within <state>". Then transpose the table to list your tracts as the rows instead of the columns.

When you download the file, it will include a column with the Geoids, tract name, and whatever data you selected for inclusion. (Ests and/or MOEs.)

Hope that helps!

Catherine

---

Data Analyst

Southwestern Pennsylvania Commission

Pittsburgh, PA

Thanks Catherine. That does indeed work and a coworker figured it out too.

I decided to try again just now and still could not get to this table by going through the Advanced Search. After clearing all my search terms, after a second try the site informed me that there are no tables about language available at all, regardless of year or level of geography! Next, I cleared my browser cookies for data.census.gov and, following the same sequence of steps, was able to finally find the table. It seems that if you start with the table number then customize from there you have better luck. This, of course, assumes that you know which table you want. Or perhaps it was clearing the cookies that did the trick, though this is hardly a step I'd expect a casual user to know to take. I hope someone at the CB is reading this.

Thanks Catherine. That does indeed work and a coworker figured it out too.

I decided to try again just now and still could not get to this table by going through the Advanced Search. After clearing all my search terms, after a second try the site informed me that there are no tables about language available at all, regardless of year or level of geography! Next, I cleared my browser cookies for data.census.gov and, following the same sequence of steps, was able to finally find the table. It seems that if you start with the table number then customize from there you have better luck. This, of course, assumes that you know which table you want. Or perhaps it was clearing the cookies that did the trick, though this is hardly a step I'd expect a casual user to know to take. I hope someone at the CB is reading this.