# Race/ethnicity by state 1996-2012

**URL:** <https://forum.ipums.org/t/race-ethnicity-by-state-1996-2012/4895>\
**Category:** General\
**Created:** [October 5, 2022, 9:22pm UTC](https://forum.ipums.org/t/race-ethnicity-by-state-1996-2012/4895 "2022-10-05T21:22:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sean\_Whyard](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@Sean\_Whyard](https://forum.ipums.org/u/Sean_Whyard)\
**Post date:** [October 5, 2022, 9:22pm UTC](https://forum.ipums.org/t/race-ethnicity-by-state-1996-2012/4895/1 "2022-10-05T21:22:44Z")

</div>

I am trying to export a dataset that has states (row) and ethnicity/race (columns) broken down by survey year (1996-2012). I would like the race/ethnicity values to be percentages. I have been trying to get what I am looking for but am having trouble.

---

<div class="post-metadata">

**Author:** ![KariWilliams](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@KariWilliams](https://forum.ipums.org/u/KariWilliams)\
**Post date:** [October 11, 2022, 8:50pm UTC](https://forum.ipums.org/t/race-ethnicity-by-state-1996-2012/4895/2 "2022-10-11T20:50:09Z")

</div>

I am not sure which IPUMS dataset you are using. For [IPUMS CPS](http://cps.ipums.org/) or [IPUMS USA](http://usa.ipums.org/), the resulting data extract will be a microdata file where each row represents a single person and their responses to all of the variables. You can use a stats package to create a custom tabulation that is race/ethnicity by year. [IPUMS NHGIS](http://nhgis.ipums.org/) will provide you with summary data already in tabular form (i.e., you don’t need to make these yourself from the underlying microdata), but there isn’t annual data at the state-level prior to 2009. You may be interested in the Census Bureau’s [Population Estimates Program](https://www.census.gov/programs-surveys/popest.html) for this information.