# Creating an overcrowding measure?

**URL:** <https://forum.ipums.org/t/creating-an-overcrowding-measure/5103>\
**Category:** General\
**Created:** [February 8, 2023, 8:10pm UTC](https://forum.ipums.org/t/creating-an-overcrowding-measure/5103 "2023-02-08T20:10:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michele\_Wong](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@Michele\_Wong](https://forum.ipums.org/u/Michele_Wong)\
**Post date:** [February 8, 2023, 8:10pm UTC](https://forum.ipums.org/t/creating-an-overcrowding-measure/5103/1 "2023-02-08T20:10:28Z")

</div>

Hello, I am trying to create an overcrowding variable using the IPUMS USA 5 year data. The variable that I am looking for would help identify persons per room (similar to this variable: [IPUMS USA: descr: NOCCUP](https://usa.ipums.org/usa-action/variables/NOCCUP#codes_section)). Is there currently anyway to make this calculation using the most recent 5 year dataset? I see there are variables to determine the rooms per household, but I haven’t been able to find a variable that identifies number of persons per household or room.

Thanks!

---

<div class="post-metadata">

**Author:** ![Ivan\_Strahof](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/ivan_strahof/32/626_2.png) [@Ivan\_Strahof](https://forum.ipums.org/u/Ivan_Strahof)\
**Post date:** [February 10, 2023, 7:03pm UTC](https://forum.ipums.org/t/creating-an-overcrowding-measure/5103/2 "2023-02-10T19:03:23Z")

</div>

The ACS is a questionnaire which gathers information on every person within a sampled housing unit (i.e. household). The variable [NUMPREC](https://usa.ipums.org/usa-action/variables/NUMPREC#description_section) will tell you the number of person records associated with the household. You could then divide that number by [ROOMS](https://usa.ipums.org/usa-action/variables/ROOMS#description_section) or [BEDROOMS](https://usa.ipums.org/usa-action/variables/BEDROOMS#description_section) to calculate your measure. Note that a household may include multiple unrelated families, but it only includes those individuals for whom the unit is their usual residence (you can [review the residence rules here](https://www.census.gov/content/dam/Census/library/publications/2010/acs/acs_design_methodology_ch06.pdf)). However, you will not be able to obtain this data on the neighborhood-level as the lowest geographic detail reported in the Public Use Microdata Sample is on the Public Use Microdata Area ([PUMA](https://usa.ipums.org/usa-action/variables/PUMA#description_section)). Luckily, this data is also available in geographically aggregated tables through [IPUMS NHGIS](https://www.nhgis.org/) that are not bound by the same geography disclosure rules as the ACS. Using the [Data Finder tool](https://data2.nhgis.org/main), you can select _Occupants per Room_ as your topic as well as the time period and geographical level of your choice. The table _Tenure by Occupants per Room_ provides a breakdown of occupancy rates into five intervals for renter, owner, and general occupied housing.
