In partnership with the Church, IPUMS (Integrated Public Use Microdata Series) has recently made the entire 1850-1890 set of census data available in tabular (spreadsheet) form for analysis. While individual records have been available for some time, as has a 1% sample of the quantitative data, this new development allows us to download all of the census responses for the 19th century at once. As you can imagine, this is a fairly large file, but if you subset Utah it is much more manageable. The wonderful IPUMS folks have harmonized the different questions asked across time so that you can make comparisons across decennial censuses.
In a previous post I discussed race in early Utah. In this post I’ll discuss what the Census Bureau data has to say about inequality (or equality, as we’ll see) in early Utah. As far as I can tell, the IPUMS data doesn’t have much in way of economic variables that extend all the way from the 19th into the 20th centuries. The exceptions are occupation scores, these are numeric socioeconomic scores that are assigned to particular occupations based on 1950s data. Here we use the Duncan Socioeconomic Index in particular. There is some controversy about these measures that I’m not terribly well read up on, but I see them enough that I assume they have some validity. I’m sure cross-century comparisons also complicate some things, so here I’m including various additional states as a sort of point of comparison. For inequality in particular I will look at the variation in the Duncan SEI. High variation obviously means greater inequality, with lower variation meaning more equality. Since we are looking at the entire census and not just a sample I will be using a simple standard deviation to measure variation/inequality.
As seen in the above graph, Utah had relatively high levels of equality as measured by occupational status for the first couple of decades of Latter-day settlement. Ultimately this isn’t super surprising since (I assume) just about everybody was a poor farmer. Once the railroad came in and the Utah economy started diversifying there was probably additional room for socioeconomic differentiation and by 1900 Utah had become more unequal than the comparison states. It is worth noting that looking at total assets would probably tell a loss rosy story since there is room for highly leveraged points (i.e. very wealthy religious/social elites increasing the overall variation) than there is a on a scale from 1-100. There is some census data for property values, but only for a few decades in the 19th century. Another post for another day.
if (!require(“ipumsr”)) stop(“Reading IPUMS data into R requires the ipumsr package. It can be installed using the following command: install.packages(‘ipumsr’)”)
ddi <- read_ipums_ddi(“usa_00016.xml”)
data <- read_ipums_micro(ddi)
#Per codebook, 0s are NAs
summary_df <- df %>%
group_by(STATEFIP, YEAR) %>%
mean_SEI = mean(SEI, na.rm = TRUE),
sd_SEI = sd(SEI, na.rm = TRUE)