After a quick discussion of ideas my group and I chose the question: ” what areas were more likely to have demonstrations”. We figured the term ‘demonstration’ would allow wiggle room for events held in specific places. Since using the word meant we could look for all synonyms of demonstrations such as protest, strike, walk-out, rally and many more. We build the database to show what type of demonstration and then linked that to its geographic area. In the demonstration table, there are fields for demonstration type, the image of the newspaper article, the reason for the demonstration and a link to the geographic table by geographic ID. Under the geographic table you can see, state, city, hemisphere and time of year the demonstration was held.
We started off with more fields such as zip code and location of event (for example the white house or grand canyon) and organizer of demonstration. We ended up taking those off because they were not as present or stated in the articles as we had hoped. I think we did a great job at organizing our thoughts and ensuring you could find the answer to the question, which based on the database is that most demonstrations take place in the east coast- or relatively mid east area. At least that is what I found for my ten sources.
I learned that I really like airtable and was able to grasp it better than I thought! In all honesty, I am thinking of recommending it to my job as we are in desperate need of using a database instead of Google’s spreadsheet. I also learned that they really are similar to spreadsheets they just have added features that make them better- and in airtable’s case- easier. Digital historians would definitely benefit from what databases have to offer. They can organize and structure information, as well as link it to separate tables making it easy to show lots of information and not just have everything on one long spreadsheet that is probably not as easily sorted into chronological or alphabetical order. Databases just make sorting and researching history easier. I am glad to say it was not as scary of a skill assignment as I once thought, and if I can use it an historian sure can!
Link to the database: Demonstrations on Suffrage 390-004