# PUMAs missing values ACS industry

**URL:** <https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558>\
**Category:** NHGIS\
**Created:** [June 2, 2020, 7:15am UTC](https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558 "2020-06-02T07:15:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![seiferf0](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@seiferf0](https://forum.ipums.org/u/seiferf0)\
**Post date:** [June 2, 2020, 7:15am UTC](https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558/1 "2020-06-02T07:15:14Z")

</div>

The table on “Industry by Occupation for the Civilian Employed Population 16 Years and Over” (B24050) from the 1-year ACS data has many missing values for PUMAs (years 2012-2018 at least). In contrast, the PUMA-level data downloaded from [data.census.gov](http://data.census.gov) on the same topic appears to have observations for all PUMAs. Where does the discrepancy come from?

---

<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:** [June 2, 2020, 2:13pm UTC](https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558/2 "2020-06-02T14:13:46Z")

</div>

When I use [data.census.gov](http://data.census.gov) to find PUMA-level data for the B24050 table (or the related C24050 table), I find blank/null values for the same set of PUMAs that are blank/null in NHGIS. Here’s [a link to the census.gov results](https://data.census.gov/cedsci/table?g=0400000US01.795000&tid=ACSDT1Y2018.B24050&d=ACS%201-Year%20Estimates%20Detailed%20Tables&vintage=2018&y=2018&t=Industry%3AOccupation&hidePreview=false&layer=VT_2018_795_00_PY_D1&cid=B24050_001E) that I found (limited to Alabama PUMAs in this case). Possibly the results you found on [data.census.gov](http://data.census.gov) aren’t for B24050? If you are able to find complete results for B24050, please share a link to those results.

---

<div class="post-metadata">

**Author:** ![seiferf0](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@seiferf0](https://forum.ipums.org/u/seiferf0)\
**Post date:** [June 3, 2020, 11:22am UTC](https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558/3 "2020-06-03T11:22:16Z")

</div>

Indeed, I realized that I have used the S2403 from [data.census.gov](http://data.census.gov) instead. I am sorry for the confusion. But this creates new questions for me. Why do I seem unable to find S2403 in NHGIS? Is there any other table in NHGIS that lists employment numbers by industry for all PUMAs?

---

<div class="post-metadata">

**Author:** ![MPC\_vanriper](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@MPC\_vanriper](https://forum.ipums.org/u/MPC_vanriper)\
**Post date:** [June 3, 2020, 1:12pm UTC](https://forum.ipums.org/t/pumas-missing-values-acs-industry/3558/4 "2020-06-03T13:12:49Z")

</div>

NHGIS does not provide the subject tables from the ACS; instead, we provide the detailed ACS tables. The subject tables collate information from the detailed tables, so all information in the subject tables can be found in the detailed tables.

I recommend looking at table C24040. Sex by Industry for the Full-Time, Year-Round Civilian Employed Population 16 Years and Over or  
B24040. Sex by Industry for the Full-Time, Year-Round Civilian Employed Population 16 Years and Over. The C24040 table provide employment numbers for 26 industries - the same industries listed in S2403. The B24040 table provide employment numbers for 103 industries. Given the larger number of industries in B24040, I expect some PUMAs will have no data for some industries (because that PUMA has no employees in some industries).