# Selecting on STATEFP and PUMA5CE

**URL:** <https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095>\
**Category:** USA\
**Created:** [September 17, 2024, 4:49pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095 "2024-09-17T16:49:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![skogan](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@skogan](https://forum.ipums.org/u/skogan)\
**Post date:** [September 17, 2024, 4:49pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/1 "2024-09-17T16:49:25Z")

</div>

Trying to select PUMAs in Chicago. Happy to select out the many PUMAs involved, but I cannot figure out how to get both STATEFP and PUMA5CE (apparently need both) in the download. Even better would be to just download my selected state (“17”) and then select on 5CE, but I cant figure that out either. Just getting national dumps. HELP!

---

<div class="post-metadata">

**Author:** ![skogan](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@skogan](https://forum.ipums.org/u/skogan)\
**Post date:** [September 17, 2024, 8:25pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/2 "2024-09-17T20:25:39Z")

</div>

OK! I figured it out. Also that the PUMS areas that make up Chicago changed their numbers, names, and which neighboring community areas were aggregated into each PUMA between 2021 and 2022. Ouch!

---

<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:** [September 19, 2024, 10:25pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/3 "2024-09-19T22:25:55Z")

</div>

Glad you were able to resolve the immediate issue (even though it might have not given you the result that you were hoping). I can provide some additional information that may be useful.

The Census Bureau issued a new vintage of PUMA boundaries in 2022 that revised the boundaries used in samples from 2012-2021. You can see the changes in Chicago by overlaying the two PUMA vintages in [this PUMA map](https://usa.ipums.org/usa/volii/2020PUMAS.shtml). You can also view these changes in [the 2010-2020 PUMA crosswalk file](https://usa.ipums.org/usa/resources/volii/PUMA2010_PUMA2020_crosswalk.xls). Each observation in the file is an area of intersection between a 2010 vintage (2012-2021) and a 2020 vintage (2022-2031) PUMA. The file provides the estimated percent of each 2010 PUMA’s population and land area that corresponds to each 2020 PUMA. For example, you can see that 2010 PUMA 3408 (Cook County (Central)–Cicero, Berwyn & Oak Park Townships) was divided between two different 2020 PUMAs (3111 and 3112). About 26.96% of its population went to PUMA 3111 and 74.06% went to PUMA 3112.

If observing individual microdata records is not crucial for your analysis, you might instead obtain data from [IPUMS NHGIS](https://www.nhgis.org/), which reports aggregate summary statistics for geographies (e.g., cities, counties, census tracts, etc.) with 65,000 or more inhabitants on an annual basis and for smaller areas on a 5-year basis (e.g., 2018-2022). We recommend that new IPUMS NHGIS users familiarize themselves with the website by reviewing [the FAQ page](https://www.nhgis.org/frequently-asked-questions-faq) and the relevant [video tutorials on our User Guide](https://www.nhgis.org/user-guide).

---

<div class="post-metadata">

**Author:** ![Julia\_Gutierrez](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@Julia\_Gutierrez](https://forum.ipums.org/u/Julia_Gutierrez)\
**Post date:** [July 11, 2025, 8:41pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/4 "2025-07-11T20:41:22Z")

</div>

Hi! I am having a similar issue especifically downloading a specific PUMA5CE in Chicago. Do you mind sharing how did you figured it out?

---

<div class="post-metadata">

**Author:** ![Julia\_Gutierrez](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@Julia\_Gutierrez](https://forum.ipums.org/u/Julia_Gutierrez)\
**Post date:** [July 11, 2025, 8:43pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/5 "2025-07-11T20:43:17Z")

</div>

Hi. I am having a similar issue. Do you mind sharing how you figured it out? Thank you!

---

<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:** [July 14, 2025, 7:23pm UTC](https://forum.ipums.org/t/selecting-on-statefp-and-puma5ce/6095/6 "2025-07-14T19:23:03Z")

</div>

We do not allow for PUMA-based case selection via IPUMS USA because PUMA codes often change when PUMA boundaries are redrawn and because PUMA codes are not unique; they may be recycled over time and they must be paired with a state FIPS code to uniquely identify PUMAs.

You may request data for just Illinois by adding [STATEFIP](https://usa.ipums.org/usa-action/variables/STATEFIP) to your data cart and then using the _Select Cases_ tool in the _Extract Request_ menu (available between viewing your cart and submitting your extract for processing). Assuming you’ve also added the variable [PUMA](https://usa.ipums.org/usa-action/variables/PUMA) to your data cart, you can then filter by this variable once you’ve [downloaded, unzipped, and opened](https://usa.ipums.org/usa/extract_instructions.shtml) the processed data extract.

 ![Screenshot of the Select Cases option in the Extract Request page](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/2X/f/f9d3eaa53a9e066506c09677b475454c09ef2d1e.png)
