# 2022 Five year ACS Count compared to 2017

**URL:** <https://forum.ipums.org/t/2022-five-year-acs-count-compared-to-2017/5936>\
**Category:** General\
**Created:** [June 10, 2024, 4:35pm UTC](https://forum.ipums.org/t/2022-five-year-acs-count-compared-to-2017/5936 "2024-06-10T16:35:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dougrhess](https://avatars.discourse-cdn.com/v4/letter/d/3ec8ea/32.png) [@dougrhess](https://forum.ipums.org/u/dougrhess)\
**Post date:** [June 10, 2024, 4:35pm UTC](https://forum.ipums.org/t/2022-five-year-acs-count-compared-to-2017/5936/1 "2024-06-10T16:35:24Z")

</div>

Hi. I downloaded the 2022 and 2017 five-year ACS data to look at occupational codes by PUMA. However, the 2017 includes 15.7 million records but the 2022 only 5.57 million records. Is there a reason for this?The 2022 five-ear ACS includes 2018-2022 (about a million records for each year).

Am I misunderstanding something? Thanks.

---

<div class="post-metadata">

**Author:** ![Isabel\_Pastoor](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/isabel_pastoor/32/788_2.png) [@Isabel\_Pastoor](https://forum.ipums.org/u/Isabel_Pastoor)\
**Post date:** [June 10, 2024, 9:21pm UTC](https://forum.ipums.org/t/2022-five-year-acs-count-compared-to-2017/5936/2 "2024-06-10T21:21:57Z")

</div>

There are 15,721,123 person records in the 2022 5-year ACS. You can check this quickly by tabulating any variable in the [online data analysis system](https://usa.ipums.org/usa/sda/) for the 2022 5-year ACS, making sure to select “none” under weight options to view the unweighted number of person records in the sample. For example, I tabulated the variable SEX for this sample without weights and see the total number of persons is roughly 15.7 million:

 ![Screenshot 2024-06-10 at 3.21.03 PM](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/1X/acff5e790fa7a3c03109b23a3096694795ee7008.png)

Below is the same table for the 2017 5-year ACS. You can see there are 15,758,937 person records in this sample.

![Screenshot 2024-06-10 at 4.20.33 PM](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/1X/5cd6947ef7b036fb200b25566cf04d5306fba13d.png)

If you have restricted your analytical sample in some way or perhaps accidentally dropped a number of records during data cleaning, that could explain why you see a smaller number of person records than are present in the sample. I do not see any issue with your most recent IPUMS USA extract, which is a rectangular, person-level extract that includes both the 2017 5-year ACS and 2022 5-year ACS.