Last semester, I wrote a historiography on Jewish immigration to the U.S. at the turn of the 20th century, a period that is typically defined as ranging from 1881 to 1924. During this time, approximately 23 million immigrants came to this country, about 2 million of which were Jews from Eastern Europe.
While researching books to write about, I found a fascinating dissertation (political science PhD at Columbia University) on the subject: Jewish immigration to the United States from 1881 to 1910 by Samuel Joseph, notable because it was written in 1914, while mass immigration was still happening!
In his dissertation, Joseph took a primarily statistical approach, quantifying newcomers into categories based on things like country of origin, destination, port of entry, occupation, and even literacy levels.
When I read this book last year, I realized that this information might be really useful in my work at NMAJH. However, while this book has been digitized, Joseph’s statistics are presented only in chart form, which is difficult both to interpret and to feed through an OCR.
So for his assignment, I wanted to see how I could make these statistics more useful, both to visualize them, and to make them more convenient than having to scroll through a slowly-loading 200 page book on Hathi Trust. I made the following charts through Excel, which I had to learn how to do last year to create board reports at work. Here are a few reasons why I love Excel:
- You can make a variety of charts super quickly.
- You can manipulate/fix the data and see how that changes your chart.
- It’s really easy to customize how the chart looks, such as making colors easier to read, including data values, etc.
I think it could prove useful to eventually continue doing this for the rest of the book, or at least transcribing Joseph’s charts into plain text. If possible, that would involve checking his statistics against his original sources, which come from a variety of places (census records, synagogue and charity reports, etc), so this information can be made more consistent and to clear up any uncertainties.