Dataset Assignment and Blog

Chicago Manual of Style Citation: Upper Penn Neck Township, Salem County, New Jersey, Poll Lists, 1800″ from the American Revolution Museum’s virtual exhibit “When Women Lost the Vote: A Revolutionary Story”

Blog #3: Dataset Assignment

Chicago Manual of Style Citation: Barton, Clara. “Clara Barton to Lon Poor about the changes in Abraham Lincoln.” Correspondence. The Gilder Lehrman Institute of American History.

Reflection: The sources I selected were Poll Lists from New Jersey. These included women’s names who voted during this time period. These lists ranged from December 1800 through October 1801. Women were allowed to vote in New Jersey for a short period of time, these polls were from this time period. This relates to the topic of my final project as I am studying women’s voting rights before the Civil War and this was a large part of it. Women were granted rights and shortly after they were taken away. 

The process of creating your initial Google spreadsheet was simple, I took my sources and data within them such as the date, people (in this case women voting) and location (such as county, township and state) and put them into the sheet. My google sheet had 7 variables, which included the URL to the source. This was to have an easier access later in my research process. My goal was to keep any information kept in the Google spreadsheet simple and to the point as it made it easier to analyze the data. Transcribing structured data, like in databases or spreadsheets, is easier because it’s organized and often involves numbers or dates that are specific.. It focuses on facts, reducing interpretation errors. Transcribing text, with stories or emotions, is harder as it requires understanding and capturing every meaning accurately. Both need careful handling to get the information right, but structured data is simpler due to its organized nature and clear data points.

The process of transforming your spreadsheet into a database was complicated for me personally. Spreadsheets are different from Airtable because they have more complexity and features to them. I took the data and imputed it into two different tables, names and location.  The third table was the relationship or what they had in common. I had three tables total, and the relationships stayed the same as those in the poll lists. For example, it connected that everyone voted in the same Township, County and State. Airtable is more for finding similarities in data and spreadsheets are for more broad information. For any abnormalities, such as repetition I made sure to proofread the data and ensure there were none of the same variables.  

I honestly felt challenged through this process. Once I got help from Mrs. Swain I felt more at ease. I feel like I now have the hang of things and can continue to add data to both the google sheet and the AirTable.


Leave a Reply

Your email address will not be published. Required fields are marked *