# How do I account for HHWT when looking at data about number of households in a state from sample w/ all states?

**URL:** <https://forum.ipums.org/t/how-do-i-account-for-hhwt-when-looking-at-data-about-number-of-households-in-a-state-from-sample-w-all-states/1917>\
**Category:** USA\
**Created:** [September 12, 2017, 4:33pm UTC](https://forum.ipums.org/t/how-do-i-account-for-hhwt-when-looking-at-data-about-number-of-households-in-a-state-from-sample-w-all-states/1917 "2017-09-12T16:33:00Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Chip\_Halbach](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@Chip\_Halbach](https://forum.ipums.org/u/Chip_Halbach)\
**Post date:** [December 3, 2020, 7:07pm UTC](https://forum.ipums.org/t/how-do-i-account-for-hhwt-when-looking-at-data-about-number-of-households-in-a-state-from-sample-w-all-states/1917/3 "2020-12-03T19:07:44Z")

</div>

I have a similar question related to household count. When I download data for a MSA, here St. Louis #41180, using “ownership” as the only other selected field I get a household count of about 2.7 million… that is I added all the HHWT field entries for some 25 thousand records. But when I used the SDA online tool, filtering only for the MSA and pernum(1) I get a household count of 1.2 million. What am I doing wrong?

---

_[View the full topic](https://forum.ipums.org/t/how-do-i-account-for-hhwt-when-looking-at-data-about-number-of-households-in-a-state-from-sample-w-all-states/1917)._