# Census Data File ID

**URL:** <https://forum.ipums.org/t/census-data-file-id/3976>\
**Category:** NHGIS\
**Created:** [February 15, 2021, 3:57pm UTC](https://forum.ipums.org/t/census-data-file-id/3976 "2021-02-15T15:57:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tathagato\_Chakrabort](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@Tathagato\_Chakrabort](https://forum.ipums.org/u/Tathagato_Chakrabort)\
**Post date:** [February 15, 2021, 3:57pm UTC](https://forum.ipums.org/t/census-data-file-id/3976/1 "2021-02-15T15:57:54Z")

</div>

I have Census Table IDs (for example DP04) for 2014-18 ACS data collection on various indicators. How can I find tables in NHGIS that correspond to the same ID?  
Thanks,  
TC

---

<div class="post-metadata">

**Author:** ![JonathanSchroeder](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jonathanschroeder/32/70_2.png) [@JonathanSchroeder](https://forum.ipums.org/u/JonathanSchroeder)\
**Post date:** [February 17, 2021, 5:39pm UTC](https://forum.ipums.org/t/census-data-file-id/3976/2 "2021-02-17T17:39:05Z")

</div>

First, NHGIS does not include the “DP” tables from the ACS. We provide only the “detailed tables” from the ACS Summary Files. Their codes start with “B” or “C”.

Second, NHGIS doesn’t have a search tool for looking up specific table IDs. Alternatively, I think the best way to find a table from a particular ACS period would be to filter by Year to list all available tables for the period of interest. For example, here I’ve selected “2014-2018” as the Year filter:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/1X/4e66364d1ee5c1533757a7deea0dbe1da2b056bd.png)  
Notice that there’s also a dropdown menu to change how many tables are listed. I changed that to the largest option: 500. Then I can use my browser’s “Find” tool (Ctrl+F or Option+F) to search for text on that page. If the table I’m looking for is not on the page, I advance to the next set of 500 and do another search in that group.

---

<div class="post-metadata">

**Author:** ![JonathanSchroeder](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jonathanschroeder/32/70_2.png) [@JonathanSchroeder](https://forum.ipums.org/u/JonathanSchroeder)\
**Post date:** [February 17, 2021, 5:41pm UTC](https://forum.ipums.org/t/census-data-file-id/3976/3 "2021-02-17T17:41:31Z")

</div>

Another option if you’re comfortable with scripting (e.g., Python, R, etc.) would be to use [our API](https://developer.ipums.org), which _does_ allow you to request tables by their ID.