# County

**URL:** <https://forum.ipums.org/t/county/2213>\
**Category:** USA\
**Created:** [March 13, 2018, 10:56pm UTC](https://forum.ipums.org/t/county/2213 "2018-03-13T22:56:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gycarton](https://avatars.discourse-cdn.com/v4/letter/g/f0a364/32.png) [@gycarton](https://forum.ipums.org/u/gycarton)\
**Post date:** [March 13, 2018, 10:56pm UTC](https://forum.ipums.org/t/county/2213/1 "2018-03-13T22:56:00Z")

</div>

Hi Michelle,

Thank you for answering my question regarding county-level data using IPUMS USA. Is county-level data essentially only available for the geographies listed in the “counties\_1950\_on” spreadsheet by combining the state, county, and countyfips codes?

Thank you,

Gina

---

<div class="post-metadata">

**Author:** ![Michelle\_Pratt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/michelle_pratt/32/194_2.png) [@Michelle\_Pratt](https://forum.ipums.org/u/Michelle_Pratt)\
**Post date:** [March 14, 2018, 6:28pm UTC](https://forum.ipums.org/t/county/2213/2 "2018-03-14T18:28:00Z")

</div>

COUNTY (or COUNTYFIPS) is a state dependent variable so either must be read in combination with one of the STATE variables ([STATEICP](https://usa.ipums.org/usa-action/variables/STATEICP#description_section) or [STATEFIP](https://usa.ipums.org/usa-action/variables/STATEFIP#description_section)). In other words, when creating your extract/conducting your analysis, you can include either of the county variables and either of the state variables. If, for example, you were interested in Fresno, CA. You can see in the excel spreadsheet that data on this county is available from 1950 onwards, so analyzing your data you would want to identify observations with STATEFIP == 6 & COUNTY == 190.